[PlaneShift-svn] SF.net SVN: planeshift:[6161] trunk/src/server/database/mysql/ item_instances.sql

[<weltall2@us...>]

Revision: 6161
          http://planeshift.svn.sourceforge.net/planeshift/?rev=6161&view=rev
Author:   weltall2
Date:     2010-08-17 20:35:14 +0000 (Tue, 17 Aug 2010)

Log Message:
-----------
added missing new field

Modified Paths:
--------------
    trunk/src/server/database/mysql/item_instances.sql

Modified: trunk/src/server/database/mysql/item_instances.sql
===================================================================
--- trunk/src/server/database/mysql/item_instances.sql	2010-08-16 05:31:28 UTC (rev 6160)
+++ trunk/src/server/database/mysql/item_instances.sql	2010-08-17 20:35:14 UTC (rev 6161)
@@ -47,6 +47,7 @@
   `openable_locks` varchar(100) default '0',
   `item_name` varchar(100) default '',
   `item_description` varchar(255) default '',
+  `creative_definition` TEXT  DEFAULT NULL COMMENT 'This is used for books/sketch.';
   `charges` int(3) NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `char_id_owner` (`char_id_owner`)
@@ -57,123 +58,123 @@
 #
 
 # Some axes that are hanging around
-INSERT INTO `item_instances` VALUES (1,0,0,0,0,1,0,0,0,3,0,2,-200,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (2,0,0,0,0,1,0,0,0,3,4,2,-210,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (1,0,0,0,0,1,0,0,0,3,0,2,-200,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (2,0,0,0,0,1,0,0,0,3,4,2,-210,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
 
 # Smith items
-INSERT INTO `item_instances` VALUES (3,5,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (4,5,0,0,22,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,3,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (5,5,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,4,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (6,5,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,5,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (7,5,0,0,25,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,6,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (8,5,0,0,26,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,7,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (9,5,0,0,23,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,8,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (10,5,0,0,24,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,9,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (11,5,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (12,5,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,11,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (13,5,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,12,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (3,5,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (4,5,0,0,22,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,3,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (5,5,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,4,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (6,5,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,5,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (7,5,0,0,25,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,6,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (8,5,0,0,26,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,7,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (9,5,0,0,23,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,8,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (10,5,0,0,24,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,9,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (11,5,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (12,5,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,11,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (13,5,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,12,0,'',0,-1,'','','','','0');
 
 # More axes
-INSERT INTO `item_instances` VALUES (14,0,0,0,0,1,0,0,0,3,20,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (15,0,0,0,0,1,0,0,0,3,0,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (16,0,0,0,0,1,0,0,0,3,20,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (17,0,0,0,0,1,0,0,0,3,0,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (14,0,0,0,0,1,0,0,0,3,20,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (15,0,0,0,0,1,0,0,0,3,0,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (16,0,0,0,0,1,0,0,0,3,20,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (17,0,0,0,0,1,0,0,0,3,0,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
 
 # Guest player items
-INSERT INTO `item_instances` VALUES (20,1,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (21,1,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (22,1,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (23,1,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (24,1,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,65,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (25,1,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,90,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (26,1,0,0,22,1,1,1,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (20,1,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (21,1,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (22,1,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (23,1,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (24,1,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,65,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (25,1,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,90,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (26,1,0,0,22,1,1,1,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','','','0');
 
 # Merchant items
-INSERT INTO `item_instances` VALUES (30,8,0,0,29,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (31,8,0,0,30,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (32,8,0,0,28,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (33,8,0,0,26,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,16,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (34,8,0,0,27,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,17,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (35,8,0,0,33,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,18,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (36,8,0,0,34,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,19,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (37,8,0,0,31,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,20,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (38,8,0,0,32,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,21,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (39,8,0,0,25,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,22,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (40,8,0,0,18,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,23,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (41,8,0,0,19,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,24,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (42,8,0,0,16,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,25,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (43,8,0,0,17,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,26,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (44,8,0,0,20,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,27,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (45,8,0,0,23,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,28,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (46,8,0,0,24,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,29,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (47,8,0,0,21,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,44,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (48,8,0,0,22,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,47,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (49,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,421,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (172,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,423,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (185,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,232,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (186,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,233,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (30,8,0,0,29,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (31,8,0,0,30,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (32,8,0,0,28,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (33,8,0,0,26,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,16,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (34,8,0,0,27,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,17,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (35,8,0,0,33,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,18,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (36,8,0,0,34,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,19,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (37,8,0,0,31,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,20,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (38,8,0,0,32,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,21,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (39,8,0,0,25,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,22,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (40,8,0,0,18,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,23,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (41,8,0,0,19,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,24,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (42,8,0,0,16,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,25,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (43,8,0,0,17,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,26,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (44,8,0,0,20,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,27,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (45,8,0,0,23,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,28,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (46,8,0,0,24,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,29,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (47,8,0,0,21,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,44,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (48,8,0,0,22,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,47,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (49,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,421,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (172,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,423,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (185,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,232,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (186,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,233,0,'',0,-1,'','','','','0');
 
 # acraig items 
-INSERT INTO `item_instances` VALUES (50,3,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (51,3,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (50,3,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (51,3,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','','','0');
 
 # vengeance items
-INSERT INTO `item_instances` VALUES (60,2,0,0,16,1,0,0,0,0,0,0,0,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (61,2,0,0,17,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,85,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (62,2,0,0,18,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,411,0,'',0,-1,'','','','1');
-INSERT INTO `item_instances` VALUES (63,2,0,0,20,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (67,2,0,0,27,1,0,0,0,0,0,0,0,0,0,0,0,50,50,71,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (68,2,0,0,24,1,0,0,0,0,0,0,0,0,0,0,0,50,50,235,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (69,2,0,0,28,1,0,0,0,0,0,0,0,0,0,0,0,50,50,65,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (60,2,0,0,16,1,0,0,0,0,0,0,0,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (61,2,0,0,17,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,85,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (62,2,0,0,18,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,411,0,'',0,-1,'','','','','1');
+INSERT INTO `item_instances` VALUES (63,2,0,0,20,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (67,2,0,0,27,1,0,0,0,0,0,0,0,0,0,0,0,50,50,71,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (68,2,0,0,24,1,0,0,0,0,0,0,0,0,0,0,0,50,50,235,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (69,2,0,0,28,1,0,0,0,0,0,0,0,0,0,0,0,50,50,65,0,'',0,-1,'','','','','0');
 
 # Wooden bowl and contents
-INSERT INTO `item_instances` VALUES (70,0,0,0,0,1,0,0,0,3,-3.7,1.07,-180.58,0,0,0,0,50,50,70,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (71,0,2,70,1,1,0,0,0,3,0,0,0,0,0,0,0,50,-1,60,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (72,0,2,70,2,2,0,0,0,3,0,0,0,0,0,0,0,50,-1,61,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (73,0,2,70,3,7,0,0,0,3,0,0,0,0,0,0,0,50,-1,62,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (70,0,0,0,0,1,0,0,0,3,-3.7,1.07,-180.58,0,0,0,0,50,50,70,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (71,0,2,70,1,1,0,0,0,3,0,0,0,0,0,0,0,50,-1,60,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (72,0,2,70,2,2,0,0,0,3,0,0,0,0,0,0,0,50,-1,61,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (73,0,2,70,3,7,0,0,0,3,0,0,0,0,0,0,0,50,-1,62,0,'',0,-1,'','','','','0');
 
 # Book container and contents
-INSERT INTO `item_instances` VALUES (80,0,0,0,0,1,0,0,0,3,-56.16,-3,-154.73,0,4.74,0,0,50,50,234,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (81,0,0,80,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2008,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (82,0,0,0,0,1,0,0,0,3,-55.79,-3,-153.56,0,4.74,0,0,50,50,234,0,'NOPICKUP NPCOWNED',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (83,0,0,82,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'NOPICKUP',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (80,0,0,0,0,1,0,0,0,3,-56.16,-3,-154.73,0,4.74,0,0,50,50,234,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (81,0,0,80,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2008,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (82,0,0,0,0,1,0,0,0,3,-55.79,-3,-153.56,0,4.74,0,0,50,50,234,0,'NOPICKUP NPCOWNED',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (83,0,0,82,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'NOPICKUP',0,-1,'','','','','0');
 
 # Weapons for fighter1 and fighter2
-INSERT INTO `item_instances` VALUES (90,6,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (91,7,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (90,6,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (91,7,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','','0');
 
 # Key and lock for entrance
-INSERT INTO `item_instances` VALUES (95,0,0,0,0,1,0,0,0,3,-56,-1,-148,0,0,0,0,50,50,420,0,'LOCKED,SECURITYLOCK,UNPICKABLE',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (96,0,0,0,0,1,0,0,0,3,-54,1,-148,0,0,0,0,50,50,413,0,'KEY',0,-1,'95','','','0');
+INSERT INTO `item_instances` VALUES (95,0,0,0,0,1,0,0,0,3,-56,-1,-148,0,0,0,0,50,50,420,0,'LOCKED,SECURITYLOCK,UNPICKABLE',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (96,0,0,0,0,1,0,0,0,3,-54,1,-148,0,0,0,0,50,50,413,0,'KEY',0,-1,'95','','','','0');
 
 # Items on ground
-INSERT INTO `item_instances` VALUES (100,0,0,0,0,1,0,0,0,3,-2.72,0.37,-182.03,0,90,0,0,50,50,74,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (101,0,0,0,0,1,0,0,0,3,-6.67,0.12,-140.5,0,0,0,0,50,50,91,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (102,0,0,0,0,1,0,0,0,3,-6.67,0.12,-142.5,0,0,0,0,50,50,92,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (103,0,0,0,0,1,0,0,0,3,-6.67,0.12,-144.5,0,0,0,0,50,50,93,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (104,0,0,0,0,1,0,0,0,3,-6.67,0.12,-146.5,0,0,0,0,50,50,94,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (105,0,0,0,0,1,0,0,0,3,-6.67,0.12,-148.5,0,0,0,0,50,50,95,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (106,0,0,0,0,1,0,0,0,3,-6.67,0.12,-150.5,0,0,0,0,50,50,96,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (107,0,0,0,0,1,0,0,0,3,-6.67,0.12,-152.5,0,0,0,0,50,50,97,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (108,0,0,0,0,1,0,0,0,3,-6.67,0.12,-154.5,0,0,0,0,50,50,98,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (109,0,0,0,0,1,0,0,0,3,-6.67,0.12,-156.5,0,0,0,0,50,50,99,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (110,0,0,0,0,1,0,0,0,3,-6.67,0.12,-158.5,0,0,0,0,50,50,100,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (111,0,0,0,0,1,0,0,0,3,-6.67,0.12,-160.5,0,0,0,0,50,50,101,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (112,0,0,0,0,1,0,0,0,3,-16,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (113,0,0,0,0,1,0,0,0,3,-15,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (114,0,0,0,0,1,0,0,0,3,-14,0.12,-140.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'112 113','','','0');
-INSERT INTO `item_instances` VALUES (115,0,0,0,0,1,0,0,0,3,-52.77,-4,-157.63,0,9.03,0,0,50,50,4815,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (116,0,0,0,0,1,0,0,0,3,-55.34,-4,-157.58,0,4.15,0,0,50,50,4811,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (117,0,0,0,0,34,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (118,0,0,0,0,1,0,0,0,3,-38.51,0,-160.54,0,8.03,0,0,50,99,419,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (119,0,0,0,0,1,0,0,0,3,-16,0.12,-138.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (120,0,0,0,0,1,0,0,0,3,-15,0.12,-138.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'119','','','0');
-INSERT INTO `item_instances` VALUES (121,0,0,0,0,1,0,0,0,3,-16,0.12,-136.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (128,0,0,0,0,1,0,0,0,3,-3.72,0.37,-183.03,0,90,0,0,50,50,138,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (140,2,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,50,50,9,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (151,20,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'TRANSIENT',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (166,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,3,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (171,0,0,0,0,17,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (100,0,0,0,0,1,0,0,0,3,-2.72,0.37,-182.03,0,90,0,0,50,50,74,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (101,0,0,0,0,1,0,0,0,3,-6.67,0.12,-140.5,0,0,0,0,50,50,91,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (102,0,0,0,0,1,0,0,0,3,-6.67,0.12,-142.5,0,0,0,0,50,50,92,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (103,0,0,0,0,1,0,0,0,3,-6.67,0.12,-144.5,0,0,0,0,50,50,93,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (104,0,0,0,0,1,0,0,0,3,-6.67,0.12,-146.5,0,0,0,0,50,50,94,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (105,0,0,0,0,1,0,0,0,3,-6.67,0.12,-148.5,0,0,0,0,50,50,95,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (106,0,0,0,0,1,0,0,0,3,-6.67,0.12,-150.5,0,0,0,0,50,50,96,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (107,0,0,0,0,1,0,0,0,3,-6.67,0.12,-152.5,0,0,0,0,50,50,97,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (108,0,0,0,0,1,0,0,0,3,-6.67,0.12,-154.5,0,0,0,0,50,50,98,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (109,0,0,0,0,1,0,0,0,3,-6.67,0.12,-156.5,0,0,0,0,50,50,99,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (110,0,0,0,0,1,0,0,0,3,-6.67,0.12,-158.5,0,0,0,0,50,50,100,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (111,0,0,0,0,1,0,0,0,3,-6.67,0.12,-160.5,0,0,0,0,50,50,101,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (112,0,0,0,0,1,0,0,0,3,-16,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (113,0,0,0,0,1,0,0,0,3,-15,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (114,0,0,0,0,1,0,0,0,3,-14,0.12,-140.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'112 113','','','','0');
+INSERT INTO `item_instances` VALUES (115,0,0,0,0,1,0,0,0,3,-52.77,-4,-157.63,0,9.03,0,0,50,50,4815,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (116,0,0,0,0,1,0,0,0,3,-55.34,-4,-157.58,0,4.15,0,0,50,50,4811,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (117,0,0,0,0,34,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (118,0,0,0,0,1,0,0,0,3,-38.51,0,-160.54,0,8.03,0,0,50,99,419,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (119,0,0,0,0,1,0,0,0,3,-16,0.12,-138.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (120,0,0,0,0,1,0,0,0,3,-15,0.12,-138.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'119','','','','0');
+INSERT INTO `item_instances` VALUES (121,0,0,0,0,1,0,0,0,3,-16,0.12,-136.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (128,0,0,0,0,1,0,0,0,3,-3.72,0.37,-183.03,0,90,0,0,50,50,138,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (140,2,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,50,50,9,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (151,20,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'TRANSIENT',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (166,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,3,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (171,0,0,0,0,17,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','','','0');
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[PlaneShift-svn] SF.net SVN: planeshift:[6161] trunk/src/server/database/mysql/ item_instances.sql

[<weltall2@us...>]

Revision: 6161
          http://planeshift.svn.sourceforge.net/planeshift/?rev=6161&view=rev
Author:   weltall2
Date:     2010-08-17 20:35:14 +0000 (Tue, 17 Aug 2010)

Log Message:
-----------
added missing new field

Modified Paths:
--------------
    trunk/src/server/database/mysql/item_instances.sql

Modified: trunk/src/server/database/mysql/item_instances.sql
===================================================================
--- trunk/src/server/database/mysql/item_instances.sql	2010-08-16 05:31:28 UTC (rev 6160)
+++ trunk/src/server/database/mysql/item_instances.sql	2010-08-17 20:35:14 UTC (rev 6161)
@@ -47,6 +47,7 @@
   `openable_locks` varchar(100) default '0',
   `item_name` varchar(100) default '',
   `item_description` varchar(255) default '',
+  `creative_definition` TEXT  DEFAULT NULL COMMENT 'This is used for books/sketch.';
   `charges` int(3) NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `char_id_owner` (`char_id_owner`)
@@ -57,123 +58,123 @@
 #
 
 # Some axes that are hanging around
-INSERT INTO `item_instances` VALUES (1,0,0,0,0,1,0,0,0,3,0,2,-200,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (2,0,0,0,0,1,0,0,0,3,4,2,-210,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (1,0,0,0,0,1,0,0,0,3,0,2,-200,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (2,0,0,0,0,1,0,0,0,3,4,2,-210,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
 
 # Smith items
-INSERT INTO `item_instances` VALUES (3,5,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (4,5,0,0,22,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,3,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (5,5,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,4,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (6,5,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,5,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (7,5,0,0,25,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,6,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (8,5,0,0,26,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,7,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (9,5,0,0,23,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,8,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (10,5,0,0,24,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,9,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (11,5,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (12,5,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,11,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (13,5,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,12,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (3,5,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (4,5,0,0,22,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,3,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (5,5,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,4,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (6,5,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,5,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (7,5,0,0,25,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,6,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (8,5,0,0,26,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,7,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (9,5,0,0,23,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,8,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (10,5,0,0,24,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,9,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (11,5,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (12,5,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,11,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (13,5,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,12,0,'',0,-1,'','','','','0');
 
 # More axes
-INSERT INTO `item_instances` VALUES (14,0,0,0,0,1,0,0,0,3,20,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (15,0,0,0,0,1,0,0,0,3,0,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (16,0,0,0,0,1,0,0,0,3,20,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (17,0,0,0,0,1,0,0,0,3,0,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (14,0,0,0,0,1,0,0,0,3,20,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (15,0,0,0,0,1,0,0,0,3,0,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (16,0,0,0,0,1,0,0,0,3,20,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (17,0,0,0,0,1,0,0,0,3,0,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
 
 # Guest player items
-INSERT INTO `item_instances` VALUES (20,1,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (21,1,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (22,1,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (23,1,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (24,1,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,65,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (25,1,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,90,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (26,1,0,0,22,1,1,1,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (20,1,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (21,1,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (22,1,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (23,1,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (24,1,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,65,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (25,1,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,90,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (26,1,0,0,22,1,1,1,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','','','0');
 
 # Merchant items
-INSERT INTO `item_instances` VALUES (30,8,0,0,29,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (31,8,0,0,30,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (32,8,0,0,28,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (33,8,0,0,26,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,16,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (34,8,0,0,27,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,17,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (35,8,0,0,33,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,18,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (36,8,0,0,34,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,19,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (37,8,0,0,31,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,20,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (38,8,0,0,32,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,21,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (39,8,0,0,25,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,22,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (40,8,0,0,18,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,23,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (41,8,0,0,19,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,24,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (42,8,0,0,16,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,25,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (43,8,0,0,17,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,26,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (44,8,0,0,20,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,27,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (45,8,0,0,23,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,28,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (46,8,0,0,24,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,29,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (47,8,0,0,21,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,44,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (48,8,0,0,22,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,47,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (49,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,421,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (172,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,423,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (185,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,232,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (186,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,233,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (30,8,0,0,29,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (31,8,0,0,30,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (32,8,0,0,28,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (33,8,0,0,26,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,16,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (34,8,0,0,27,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,17,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (35,8,0,0,33,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,18,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (36,8,0,0,34,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,19,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (37,8,0,0,31,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,20,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (38,8,0,0,32,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,21,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (39,8,0,0,25,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,22,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (40,8,0,0,18,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,23,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (41,8,0,0,19,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,24,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (42,8,0,0,16,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,25,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (43,8,0,0,17,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,26,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (44,8,0,0,20,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,27,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (45,8,0,0,23,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,28,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (46,8,0,0,24,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,29,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (47,8,0,0,21,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,44,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (48,8,0,0,22,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,47,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (49,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,421,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (172,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,423,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (185,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,232,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (186,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,233,0,'',0,-1,'','','','','0');
 
 # acraig items 
-INSERT INTO `item_instances` VALUES (50,3,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (51,3,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (50,3,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (51,3,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','','','0');
 
 # vengeance items
-INSERT INTO `item_instances` VALUES (60,2,0,0,16,1,0,0,0,0,0,0,0,0,0,0,0,50,50,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (61,2,0,0,17,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,85,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (62,2,0,0,18,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,411,0,'',0,-1,'','','','1');
-INSERT INTO `item_instances` VALUES (63,2,0,0,20,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (67,2,0,0,27,1,0,0,0,0,0,0,0,0,0,0,0,50,50,71,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (68,2,0,0,24,1,0,0,0,0,0,0,0,0,0,0,0,50,50,235,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (69,2,0,0,28,1,0,0,0,0,0,0,0,0,0,0,0,50,50,65,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (60,2,0,0,16,1,0,0,0,0,0,0,0,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (61,2,0,0,17,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,85,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (62,2,0,0,18,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,411,0,'',0,-1,'','','','','1');
+INSERT INTO `item_instances` VALUES (63,2,0,0,20,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (67,2,0,0,27,1,0,0,0,0,0,0,0,0,0,0,0,50,50,71,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (68,2,0,0,24,1,0,0,0,0,0,0,0,0,0,0,0,50,50,235,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (69,2,0,0,28,1,0,0,0,0,0,0,0,0,0,0,0,50,50,65,0,'',0,-1,'','','','','0');
 
 # Wooden bowl and contents
-INSERT INTO `item_instances` VALUES (70,0,0,0,0,1,0,0,0,3,-3.7,1.07,-180.58,0,0,0,0,50,50,70,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (71,0,2,70,1,1,0,0,0,3,0,0,0,0,0,0,0,50,-1,60,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (72,0,2,70,2,2,0,0,0,3,0,0,0,0,0,0,0,50,-1,61,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (73,0,2,70,3,7,0,0,0,3,0,0,0,0,0,0,0,50,-1,62,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (70,0,0,0,0,1,0,0,0,3,-3.7,1.07,-180.58,0,0,0,0,50,50,70,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (71,0,2,70,1,1,0,0,0,3,0,0,0,0,0,0,0,50,-1,60,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (72,0,2,70,2,2,0,0,0,3,0,0,0,0,0,0,0,50,-1,61,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (73,0,2,70,3,7,0,0,0,3,0,0,0,0,0,0,0,50,-1,62,0,'',0,-1,'','','','','0');
 
 # Book container and contents
-INSERT INTO `item_instances` VALUES (80,0,0,0,0,1,0,0,0,3,-56.16,-3,-154.73,0,4.74,0,0,50,50,234,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (81,0,0,80,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2008,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (82,0,0,0,0,1,0,0,0,3,-55.79,-3,-153.56,0,4.74,0,0,50,50,234,0,'NOPICKUP NPCOWNED',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (83,0,0,82,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'NOPICKUP',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (80,0,0,0,0,1,0,0,0,3,-56.16,-3,-154.73,0,4.74,0,0,50,50,234,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (81,0,0,80,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2008,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (82,0,0,0,0,1,0,0,0,3,-55.79,-3,-153.56,0,4.74,0,0,50,50,234,0,'NOPICKUP NPCOWNED',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (83,0,0,82,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'NOPICKUP',0,-1,'','','','','0');
 
 # Weapons for fighter1 and fighter2
-INSERT INTO `item_instances` VALUES (90,6,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (91,7,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (90,6,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (91,7,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','','0');
 
 # Key and lock for entrance
-INSERT INTO `item_instances` VALUES (95,0,0,0,0,1,0,0,0,3,-56,-1,-148,0,0,0,0,50,50,420,0,'LOCKED,SECURITYLOCK,UNPICKABLE',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (96,0,0,0,0,1,0,0,0,3,-54,1,-148,0,0,0,0,50,50,413,0,'KEY',0,-1,'95','','','0');
+INSERT INTO `item_instances` VALUES (95,0,0,0,0,1,0,0,0,3,-56,-1,-148,0,0,0,0,50,50,420,0,'LOCKED,SECURITYLOCK,UNPICKABLE',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (96,0,0,0,0,1,0,0,0,3,-54,1,-148,0,0,0,0,50,50,413,0,'KEY',0,-1,'95','','','','0');
 
 # Items on ground
-INSERT INTO `item_instances` VALUES (100,0,0,0,0,1,0,0,0,3,-2.72,0.37,-182.03,0,90,0,0,50,50,74,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (101,0,0,0,0,1,0,0,0,3,-6.67,0.12,-140.5,0,0,0,0,50,50,91,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (102,0,0,0,0,1,0,0,0,3,-6.67,0.12,-142.5,0,0,0,0,50,50,92,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (103,0,0,0,0,1,0,0,0,3,-6.67,0.12,-144.5,0,0,0,0,50,50,93,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (104,0,0,0,0,1,0,0,0,3,-6.67,0.12,-146.5,0,0,0,0,50,50,94,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (105,0,0,0,0,1,0,0,0,3,-6.67,0.12,-148.5,0,0,0,0,50,50,95,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (106,0,0,0,0,1,0,0,0,3,-6.67,0.12,-150.5,0,0,0,0,50,50,96,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (107,0,0,0,0,1,0,0,0,3,-6.67,0.12,-152.5,0,0,0,0,50,50,97,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (108,0,0,0,0,1,0,0,0,3,-6.67,0.12,-154.5,0,0,0,0,50,50,98,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (109,0,0,0,0,1,0,0,0,3,-6.67,0.12,-156.5,0,0,0,0,50,50,99,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (110,0,0,0,0,1,0,0,0,3,-6.67,0.12,-158.5,0,0,0,0,50,50,100,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (111,0,0,0,0,1,0,0,0,3,-6.67,0.12,-160.5,0,0,0,0,50,50,101,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (112,0,0,0,0,1,0,0,0,3,-16,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (113,0,0,0,0,1,0,0,0,3,-15,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (114,0,0,0,0,1,0,0,0,3,-14,0.12,-140.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'112 113','','','0');
-INSERT INTO `item_instances` VALUES (115,0,0,0,0,1,0,0,0,3,-52.77,-4,-157.63,0,9.03,0,0,50,50,4815,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (116,0,0,0,0,1,0,0,0,3,-55.34,-4,-157.58,0,4.15,0,0,50,50,4811,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (117,0,0,0,0,34,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (118,0,0,0,0,1,0,0,0,3,-38.51,0,-160.54,0,8.03,0,0,50,99,419,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (119,0,0,0,0,1,0,0,0,3,-16,0.12,-138.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (120,0,0,0,0,1,0,0,0,3,-15,0.12,-138.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'119','','','0');
-INSERT INTO `item_instances` VALUES (121,0,0,0,0,1,0,0,0,3,-16,0.12,-136.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (128,0,0,0,0,1,0,0,0,3,-3.72,0.37,-183.03,0,90,0,0,50,50,138,0,'NOPICKUP',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (140,2,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,50,50,9,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (151,20,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'TRANSIENT',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (166,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,3,0,'',0,-1,'','','','0');
-INSERT INTO `item_instances` VALUES (171,0,0,0,0,17,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','','0');
+INSERT INTO `item_instances` VALUES (100,0,0,0,0,1,0,0,0,3,-2.72,0.37,-182.03,0,90,0,0,50,50,74,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (101,0,0,0,0,1,0,0,0,3,-6.67,0.12,-140.5,0,0,0,0,50,50,91,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (102,0,0,0,0,1,0,0,0,3,-6.67,0.12,-142.5,0,0,0,0,50,50,92,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (103,0,0,0,0,1,0,0,0,3,-6.67,0.12,-144.5,0,0,0,0,50,50,93,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (104,0,0,0,0,1,0,0,0,3,-6.67,0.12,-146.5,0,0,0,0,50,50,94,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (105,0,0,0,0,1,0,0,0,3,-6.67,0.12,-148.5,0,0,0,0,50,50,95,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (106,0,0,0,0,1,0,0,0,3,-6.67,0.12,-150.5,0,0,0,0,50,50,96,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (107,0,0,0,0,1,0,0,0,3,-6.67,0.12,-152.5,0,0,0,0,50,50,97,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (108,0,0,0,0,1,0,0,0,3,-6.67,0.12,-154.5,0,0,0,0,50,50,98,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (109,0,0,0,0,1,0,0,0,3,-6.67,0.12,-156.5,0,0,0,0,50,50,99,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (110,0,0,0,0,1,0,0,0,3,-6.67,0.12,-158.5,0,0,0,0,50,50,100,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (111,0,0,0,0,1,0,0,0,3,-6.67,0.12,-160.5,0,0,0,0,50,50,101,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (112,0,0,0,0,1,0,0,0,3,-16,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (113,0,0,0,0,1,0,0,0,3,-15,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (114,0,0,0,0,1,0,0,0,3,-14,0.12,-140.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'112 113','','','','0');
+INSERT INTO `item_instances` VALUES (115,0,0,0,0,1,0,0,0,3,-52.77,-4,-157.63,0,9.03,0,0,50,50,4815,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (116,0,0,0,0,1,0,0,0,3,-55.34,-4,-157.58,0,4.15,0,0,50,50,4811,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (117,0,0,0,0,34,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (118,0,0,0,0,1,0,0,0,3,-38.51,0,-160.54,0,8.03,0,0,50,99,419,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (119,0,0,0,0,1,0,0,0,3,-16,0.12,-138.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (120,0,0,0,0,1,0,0,0,3,-15,0.12,-138.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'119','','','','0');
+INSERT INTO `item_instances` VALUES (121,0,0,0,0,1,0,0,0,3,-16,0.12,-136.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (128,0,0,0,0,1,0,0,0,3,-3.72,0.37,-183.03,0,90,0,0,50,50,138,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (140,2,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,50,50,9,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (151,20,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'TRANSIENT',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (166,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,3,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (171,0,0,0,0,17,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','','','0');
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[PlaneShift-svn] SF.net SVN: planeshift:[6162] trunk/src/server/database/mysql/ item_instances.sql

[<weltall2@us...>]

Revision: 6162
          http://planeshift.svn.sourceforge.net/planeshift/?rev=6162&view=rev
Author:   weltall2
Date:     2010-08-17 20:43:42 +0000 (Tue, 17 Aug 2010)

Log Message:
-----------
changed to comma

Modified Paths:
--------------
    trunk/src/server/database/mysql/item_instances.sql

Modified: trunk/src/server/database/mysql/item_instances.sql
===================================================================
--- trunk/src/server/database/mysql/item_instances.sql	2010-08-17 20:35:14 UTC (rev 6161)
+++ trunk/src/server/database/mysql/item_instances.sql	2010-08-17 20:43:42 UTC (rev 6162)
@@ -47,7 +47,7 @@
   `openable_locks` varchar(100) default '0',
   `item_name` varchar(100) default '',
   `item_description` varchar(255) default '',
-  `creative_definition` TEXT  DEFAULT NULL COMMENT 'This is used for books/sketch.';
+  `creative_definition` TEXT  DEFAULT NULL COMMENT 'This is used for books/sketch.',
   `charges` int(3) NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `char_id_owner` (`char_id_owner`)


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[PlaneShift-svn] SF.net SVN: planeshift:[6168] trunk/src/server/database/mysql/ item_instances.sql

[<weltall2@us...>]

Revision: 6168
          http://planeshift.svn.sourceforge.net/planeshift/?rev=6168&view=rev
Author:   weltall2
Date:     2010-08-18 15:06:13 +0000 (Wed, 18 Aug 2010)

Log Message:
-----------
fixed value in the creative definition column

Modified Paths:
--------------
    trunk/src/server/database/mysql/item_instances.sql

Modified: trunk/src/server/database/mysql/item_instances.sql
===================================================================
--- trunk/src/server/database/mysql/item_instances.sql	2010-08-18 14:27:13 UTC (rev 6167)
+++ trunk/src/server/database/mysql/item_instances.sql	2010-08-18 15:06:13 UTC (rev 6168)
@@ -58,123 +58,123 @@
 #
 
 # Some axes that are hanging around
-INSERT INTO `item_instances` VALUES (1,0,0,0,0,1,0,0,0,3,0,2,-200,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (2,0,0,0,0,1,0,0,0,3,4,2,-210,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (1,0,0,0,0,1,0,0,0,3,0,2,-200,0,0,0,0,50,50,2,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (2,0,0,0,0,1,0,0,0,3,4,2,-210,0,0,0,0,50,50,2,0,'',0,-1,'','','',NULL,'0');
 
 # Smith items
-INSERT INTO `item_instances` VALUES (3,5,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (4,5,0,0,22,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,3,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (5,5,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,4,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (6,5,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,5,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (7,5,0,0,25,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,6,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (8,5,0,0,26,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,7,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (9,5,0,0,23,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,8,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (10,5,0,0,24,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,9,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (11,5,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (12,5,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,11,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (13,5,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,12,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (3,5,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (4,5,0,0,22,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,3,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (5,5,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,4,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (6,5,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,5,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (7,5,0,0,25,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,6,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (8,5,0,0,26,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,7,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (9,5,0,0,23,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,8,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (10,5,0,0,24,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,9,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (11,5,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (12,5,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,11,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (13,5,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,12,0,'',0,-1,'','','',NULL,'0');
 
 # More axes
-INSERT INTO `item_instances` VALUES (14,0,0,0,0,1,0,0,0,3,20,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (15,0,0,0,0,1,0,0,0,3,0,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (16,0,0,0,0,1,0,0,0,3,20,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (17,0,0,0,0,1,0,0,0,3,0,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (14,0,0,0,0,1,0,0,0,3,20,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (15,0,0,0,0,1,0,0,0,3,0,1,-150,0,0,0,0,50,50,2,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (16,0,0,0,0,1,0,0,0,3,20,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (17,0,0,0,0,1,0,0,0,3,0,1,-130,0,0,0,0,50,50,2,0,'',0,-1,'','','',NULL,'0');
 
 # Guest player items
-INSERT INTO `item_instances` VALUES (20,1,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (21,1,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (22,1,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (23,1,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (24,1,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,65,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (25,1,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,90,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (26,1,0,0,22,1,1,1,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (20,1,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (21,1,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (22,1,0,0,18,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (23,1,0,0,19,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (24,1,0,0,20,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,65,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (25,1,0,0,21,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,90,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (26,1,0,0,22,1,1,1,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','',NULL,'0');
 
 # Merchant items
-INSERT INTO `item_instances` VALUES (30,8,0,0,29,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (31,8,0,0,30,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (32,8,0,0,28,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (33,8,0,0,26,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,16,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (34,8,0,0,27,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,17,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (35,8,0,0,33,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,18,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (36,8,0,0,34,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,19,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (37,8,0,0,31,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,20,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (38,8,0,0,32,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,21,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (39,8,0,0,25,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,22,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (40,8,0,0,18,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,23,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (41,8,0,0,19,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,24,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (42,8,0,0,16,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,25,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (43,8,0,0,17,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,26,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (44,8,0,0,20,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,27,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (45,8,0,0,23,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,28,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (46,8,0,0,24,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,29,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (47,8,0,0,21,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,44,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (48,8,0,0,22,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,47,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (49,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,421,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (172,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,423,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (185,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,232,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (186,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,233,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (30,8,0,0,29,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,13,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (31,8,0,0,30,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,14,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (32,8,0,0,28,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,15,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (33,8,0,0,26,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,16,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (34,8,0,0,27,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,17,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (35,8,0,0,33,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,18,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (36,8,0,0,34,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,19,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (37,8,0,0,31,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,20,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (38,8,0,0,32,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,21,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (39,8,0,0,25,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,22,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (40,8,0,0,18,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,23,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (41,8,0,0,19,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,24,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (42,8,0,0,16,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,25,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (43,8,0,0,17,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,26,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (44,8,0,0,20,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,27,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (45,8,0,0,23,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,28,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (46,8,0,0,24,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,29,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (47,8,0,0,21,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,44,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (48,8,0,0,22,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,47,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (49,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,421,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (172,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,423,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (185,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,232,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (186,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,233,0,'',0,-1,'','','',NULL,'0');
 
 # acraig items 
-INSERT INTO `item_instances` VALUES (50,3,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (51,3,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (50,3,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (51,3,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','',NULL,'0');
 
 # vengeance items
-INSERT INTO `item_instances` VALUES (60,2,0,0,16,1,0,0,0,0,0,0,0,0,0,0,0,50,50,2,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (61,2,0,0,17,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,85,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (62,2,0,0,18,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,411,0,'',0,-1,'','','','','1');
-INSERT INTO `item_instances` VALUES (63,2,0,0,20,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (67,2,0,0,27,1,0,0,0,0,0,0,0,0,0,0,0,50,50,71,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (68,2,0,0,24,1,0,0,0,0,0,0,0,0,0,0,0,50,50,235,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (69,2,0,0,28,1,0,0,0,0,0,0,0,0,0,0,0,50,50,65,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (60,2,0,0,16,1,0,0,0,0,0,0,0,0,0,0,0,50,50,2,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (61,2,0,0,17,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,85,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (62,2,0,0,18,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,411,0,'',0,-1,'','','',NULL,'1');
+INSERT INTO `item_instances` VALUES (63,2,0,0,20,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (67,2,0,0,27,1,0,0,0,0,0,0,0,0,0,0,0,50,50,71,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (68,2,0,0,24,1,0,0,0,0,0,0,0,0,0,0,0,50,50,235,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (69,2,0,0,28,1,0,0,0,0,0,0,0,0,0,0,0,50,50,65,0,'',0,-1,'','','',NULL,'0');
 
 # Wooden bowl and contents
-INSERT INTO `item_instances` VALUES (70,0,0,0,0,1,0,0,0,3,-3.7,1.07,-180.58,0,0,0,0,50,50,70,0,'NOPICKUP',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (71,0,2,70,1,1,0,0,0,3,0,0,0,0,0,0,0,50,-1,60,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (72,0,2,70,2,2,0,0,0,3,0,0,0,0,0,0,0,50,-1,61,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (73,0,2,70,3,7,0,0,0,3,0,0,0,0,0,0,0,50,-1,62,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (70,0,0,0,0,1,0,0,0,3,-3.7,1.07,-180.58,0,0,0,0,50,50,70,0,'NOPICKUP',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (71,0,2,70,1,1,0,0,0,3,0,0,0,0,0,0,0,50,-1,60,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (72,0,2,70,2,2,0,0,0,3,0,0,0,0,0,0,0,50,-1,61,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (73,0,2,70,3,7,0,0,0,3,0,0,0,0,0,0,0,50,-1,62,0,'',0,-1,'','','',NULL,'0');
 
 # Book container and contents
-INSERT INTO `item_instances` VALUES (80,0,0,0,0,1,0,0,0,3,-56.16,-3,-154.73,0,4.74,0,0,50,50,234,0,'NOPICKUP',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (81,0,0,80,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2008,0,'NOPICKUP',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (82,0,0,0,0,1,0,0,0,3,-55.79,-3,-153.56,0,4.74,0,0,50,50,234,0,'NOPICKUP NPCOWNED',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (83,0,0,82,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'NOPICKUP',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (80,0,0,0,0,1,0,0,0,3,-56.16,-3,-154.73,0,4.74,0,0,50,50,234,0,'NOPICKUP',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (81,0,0,80,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2008,0,'NOPICKUP',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (82,0,0,0,0,1,0,0,0,3,-55.79,-3,-153.56,0,4.74,0,0,50,50,234,0,'NOPICKUP NPCOWNED',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (83,0,0,82,1,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,10,0,'NOPICKUP',0,-1,'','','',NULL,'0');
 
 # Weapons for fighter1 and fighter2
-INSERT INTO `item_instances` VALUES (90,6,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (91,7,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (90,6,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (91,7,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,2,0,'',0,-1,'','','',NULL,'0');
 
 # Key and lock for entrance
-INSERT INTO `item_instances` VALUES (95,0,0,0,0,1,0,0,0,3,-56,-1,-148,0,0,0,0,50,50,420,0,'LOCKED,SECURITYLOCK,UNPICKABLE',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (96,0,0,0,0,1,0,0,0,3,-54,1,-148,0,0,0,0,50,50,413,0,'KEY',0,-1,'95','','','','0');
+INSERT INTO `item_instances` VALUES (95,0,0,0,0,1,0,0,0,3,-56,-1,-148,0,0,0,0,50,50,420,0,'LOCKED,SECURITYLOCK,UNPICKABLE',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (96,0,0,0,0,1,0,0,0,3,-54,1,-148,0,0,0,0,50,50,413,0,'KEY',0,-1,'95','','',NULL,'0');
 
 # Items on ground
-INSERT INTO `item_instances` VALUES (100,0,0,0,0,1,0,0,0,3,-2.72,0.37,-182.03,0,90,0,0,50,50,74,0,'NOPICKUP',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (101,0,0,0,0,1,0,0,0,3,-6.67,0.12,-140.5,0,0,0,0,50,50,91,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (102,0,0,0,0,1,0,0,0,3,-6.67,0.12,-142.5,0,0,0,0,50,50,92,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (103,0,0,0,0,1,0,0,0,3,-6.67,0.12,-144.5,0,0,0,0,50,50,93,0,'NOPICKUP',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (104,0,0,0,0,1,0,0,0,3,-6.67,0.12,-146.5,0,0,0,0,50,50,94,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (105,0,0,0,0,1,0,0,0,3,-6.67,0.12,-148.5,0,0,0,0,50,50,95,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (106,0,0,0,0,1,0,0,0,3,-6.67,0.12,-150.5,0,0,0,0,50,50,96,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (107,0,0,0,0,1,0,0,0,3,-6.67,0.12,-152.5,0,0,0,0,50,50,97,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (108,0,0,0,0,1,0,0,0,3,-6.67,0.12,-154.5,0,0,0,0,50,50,98,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (109,0,0,0,0,1,0,0,0,3,-6.67,0.12,-156.5,0,0,0,0,50,50,99,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (110,0,0,0,0,1,0,0,0,3,-6.67,0.12,-158.5,0,0,0,0,50,50,100,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (111,0,0,0,0,1,0,0,0,3,-6.67,0.12,-160.5,0,0,0,0,50,50,101,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (112,0,0,0,0,1,0,0,0,3,-16,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (113,0,0,0,0,1,0,0,0,3,-15,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (114,0,0,0,0,1,0,0,0,3,-14,0.12,-140.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'112 113','','','','0');
-INSERT INTO `item_instances` VALUES (115,0,0,0,0,1,0,0,0,3,-52.77,-4,-157.63,0,9.03,0,0,50,50,4815,0,'NOPICKUP',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (116,0,0,0,0,1,0,0,0,3,-55.34,-4,-157.58,0,4.15,0,0,50,50,4811,0,'NOPICKUP',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (117,0,0,0,0,34,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (118,0,0,0,0,1,0,0,0,3,-38.51,0,-160.54,0,8.03,0,0,50,99,419,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (119,0,0,0,0,1,0,0,0,3,-16,0.12,-138.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (120,0,0,0,0,1,0,0,0,3,-15,0.12,-138.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'119','','','','0');
-INSERT INTO `item_instances` VALUES (121,0,0,0,0,1,0,0,0,3,-16,0.12,-136.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (128,0,0,0,0,1,0,0,0,3,-3.72,0.37,-183.03,0,90,0,0,50,50,138,0,'NOPICKUP',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (140,2,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,50,50,9,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (151,20,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'TRANSIENT',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (166,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,3,0,'',0,-1,'','','','','0');
-INSERT INTO `item_instances` VALUES (171,0,0,0,0,17,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','','','0');
+INSERT INTO `item_instances` VALUES (100,0,0,0,0,1,0,0,0,3,-2.72,0.37,-182.03,0,90,0,0,50,50,74,0,'NOPICKUP',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (101,0,0,0,0,1,0,0,0,3,-6.67,0.12,-140.5,0,0,0,0,50,50,91,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (102,0,0,0,0,1,0,0,0,3,-6.67,0.12,-142.5,0,0,0,0,50,50,92,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (103,0,0,0,0,1,0,0,0,3,-6.67,0.12,-144.5,0,0,0,0,50,50,93,0,'NOPICKUP',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (104,0,0,0,0,1,0,0,0,3,-6.67,0.12,-146.5,0,0,0,0,50,50,94,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (105,0,0,0,0,1,0,0,0,3,-6.67,0.12,-148.5,0,0,0,0,50,50,95,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (106,0,0,0,0,1,0,0,0,3,-6.67,0.12,-150.5,0,0,0,0,50,50,96,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (107,0,0,0,0,1,0,0,0,3,-6.67,0.12,-152.5,0,0,0,0,50,50,97,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (108,0,0,0,0,1,0,0,0,3,-6.67,0.12,-154.5,0,0,0,0,50,50,98,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (109,0,0,0,0,1,0,0,0,3,-6.67,0.12,-156.5,0,0,0,0,50,50,99,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (110,0,0,0,0,1,0,0,0,3,-6.67,0.12,-158.5,0,0,0,0,50,50,100,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (111,0,0,0,0,1,0,0,0,3,-6.67,0.12,-160.5,0,0,0,0,50,50,101,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (112,0,0,0,0,1,0,0,0,3,-16,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (113,0,0,0,0,1,0,0,0,3,-15,0.12,-140.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE,UNPICKABLE',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (114,0,0,0,0,1,0,0,0,3,-14,0.12,-140.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'112 113','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (115,0,0,0,0,1,0,0,0,3,-52.77,-4,-157.63,0,9.03,0,0,50,50,4815,0,'NOPICKUP',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (116,0,0,0,0,1,0,0,0,3,-55.34,-4,-157.58,0,4.15,0,0,50,50,4811,0,'NOPICKUP',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (117,0,0,0,0,34,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (118,0,0,0,0,1,0,0,0,3,-38.51,0,-160.54,0,8.03,0,0,50,99,419,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (119,0,0,0,0,1,0,0,0,3,-16,0.12,-138.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (120,0,0,0,0,1,0,0,0,3,-15,0.12,-138.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'119','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (121,0,0,0,0,1,0,0,0,3,-16,0.12,-136.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (128,0,0,0,0,1,0,0,0,3,-3.72,0.37,-183.03,0,90,0,0,50,50,138,0,'NOPICKUP',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (140,2,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,50,50,9,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (151,20,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'TRANSIENT',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (166,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,3,0,'',0,-1,'','','',NULL,'0');
+INSERT INTO `item_instances` VALUES (171,0,0,0,0,17,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','',NULL,'0');
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[PlaneShift-svn] SF.net SVN: planeshift:[8228] trunk/src/server/database/mysql/ item_instances.sql

[<lpancallo@us...>]

Revision: 8228
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8228&view=rev
Author:   lpancallo
Date:     2012-04-18 22:44:38 +0000 (Wed, 18 Apr 2012)
Log Message:
-----------
changed IDs to avoid primary ID clash
changed default of TEXT column to NULL or table doesn't load.

Modified Paths:
--------------
    trunk/src/server/database/mysql/item_instances.sql

Modified: trunk/src/server/database/mysql/item_instances.sql
===================================================================
--- trunk/src/server/database/mysql/item_instances.sql	2012-04-18 22:31:41 UTC (rev 8227)
+++ trunk/src/server/database/mysql/item_instances.sql	2012-04-18 22:44:38 UTC (rev 8228)
@@ -46,7 +46,7 @@
   `lock_skill` int(2) NOT NULL default '-1',
   `openable_locks` varchar(100) default '0',
   `item_name` varchar(100) default '',
-  `item_description` TEXT default '',
+  `item_description` TEXT default NULL,
   `creative_definition` TEXT  DEFAULT NULL COMMENT 'This is used for books/sketch.',
   `charges` int(3) NOT NULL default '0',
   `prefix` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Determines the prefix to be used from the loot modifiers table',
@@ -114,8 +114,8 @@
 INSERT INTO `item_instances` VALUES (48,8,0,0,22,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,47,0,'',0,-1,'','','',NULL,'0',0,0,0);
 INSERT INTO `item_instances` VALUES (49,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,421,0,'',0,-1,'','','',NULL,'0',0,0,0);
 INSERT INTO `item_instances` VALUES (172,8,0,0,35,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,423,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (185,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,232,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (186,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,233,0,'',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (173,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,232,0,'',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (174,8,0,0,35,1,8,0,0,0,0,0,0,0,0,0,0,50,-1,233,0,'',0,-1,'','','',NULL,'0',0,0,0);
 
 # acraig items
 INSERT INTO `item_instances` VALUES (50,3,0,0,16,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,71,0,'',0,-1,'','','',NULL,'0',0,0,0);
@@ -182,25 +182,25 @@
 
 # SpellMasters items
 INSERT INTO `item_instances` VALUES (180,82,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,50,50,13,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,82,0,0,2,1,0,0,0,0,0,0,0,0,0,0,0,50,50,14,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,82,0,0,3,1,0,0,0,0,0,0,0,0,0,0,0,50,50,15,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,82,0,0,4,1,0,0,0,0,0,0,0,0,0,0,0,50,50,17,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,82,0,0,5,1,0,0,0,0,0,0,0,0,0,0,0,50,50,19,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,82,0,0,6,1,0,0,0,0,0,0,0,0,0,0,0,50,50,20,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,82,0,0,7,1,0,0,0,0,0,0,0,0,0,0,0,50,50,29,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,82,0,0,8,1,0,0,0,0,0,0,0,0,0,0,0,50,50,44,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,82,0,0,9,1,0,0,0,0,0,0,0,0,0,0,0,50,50,47,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (181,82,0,0,2,1,0,0,0,0,0,0,0,0,0,0,0,50,50,14,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (182,82,0,0,3,1,0,0,0,0,0,0,0,0,0,0,0,50,50,15,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (183,82,0,0,4,1,0,0,0,0,0,0,0,0,0,0,0,50,50,17,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (184,82,0,0,5,1,0,0,0,0,0,0,0,0,0,0,0,50,50,19,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (185,82,0,0,6,1,0,0,0,0,0,0,0,0,0,0,0,50,50,20,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (186,82,0,0,7,1,0,0,0,0,0,0,0,0,0,0,0,50,50,29,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (187,82,0,0,8,1,0,0,0,0,0,0,0,0,0,0,0,50,50,44,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (188,82,0,0,9,1,0,0,0,0,0,0,0,0,0,0,0,50,50,47,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
 
 # SpellFighters items
-INSERT INTO `item_instances` VALUES (180,83,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,50,50,13,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,83,0,0,2,1,0,0,0,0,0,0,0,0,0,0,0,50,50,14,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,83,0,0,3,1,0,0,0,0,0,0,0,0,0,0,0,50,50,15,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,83,0,0,4,1,0,0,0,0,0,0,0,0,0,0,0,50,50,17,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,83,0,0,5,1,0,0,0,0,0,0,0,0,0,0,0,50,50,19,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,83,0,0,6,1,0,0,0,0,0,0,0,0,0,0,0,50,50,20,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,83,0,0,7,1,0,0,0,0,0,0,0,0,0,0,0,50,50,29,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,83,0,0,8,1,0,0,0,0,0,0,0,0,0,0,0,50,50,44,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (180,83,0,0,9,1,0,0,0,0,0,0,0,0,0,0,0,50,50,47,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (189,83,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,50,50,13,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (190,83,0,0,2,1,0,0,0,0,0,0,0,0,0,0,0,50,50,14,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (191,83,0,0,3,1,0,0,0,0,0,0,0,0,0,0,0,50,50,15,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (192,83,0,0,4,1,0,0,0,0,0,0,0,0,0,0,0,50,50,17,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (193,83,0,0,5,1,0,0,0,0,0,0,0,0,0,0,0,50,50,19,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (194,83,0,0,6,1,0,0,0,0,0,0,0,0,0,0,0,50,50,20,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (195,83,0,0,7,1,0,0,0,0,0,0,0,0,0,0,0,50,50,29,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (196,83,0,0,8,1,0,0,0,0,0,0,0,0,0,0,0,50,50,44,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (197,83,0,0,9,1,0,0,0,0,0,0,0,0,0,0,0,50,50,47,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[PlaneShift-svn] SF.net SVN: planeshift:[8356] trunk/src/server/database/mysql/ item_instances.sql

[<lpancallo@us...>]

Revision: 8356
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8356&view=rev
Author:   lpancallo
Date:     2012-06-11 17:23:40 +0000 (Mon, 11 Jun 2012)
Log Message:
-----------
Added sample item with loot modifiers.
Fixed few wrong items.

Modified Paths:
--------------
    trunk/src/server/database/mysql/item_instances.sql

Modified: trunk/src/server/database/mysql/item_instances.sql
===================================================================
--- trunk/src/server/database/mysql/item_instances.sql	2012-06-11 12:34:12 UTC (rev 8355)
+++ trunk/src/server/database/mysql/item_instances.sql	2012-06-11 17:23:40 UTC (rev 8356)
@@ -122,19 +122,21 @@
 INSERT INTO `item_instances` VALUES (51,3,0,0,17,1,5,0,0,0,0,0,0,0,0,0,0,50,-1,69,0,'',0,-1,'','','',NULL,'0',0,0,0);
 
 # vengeance items
-INSERT INTO `item_instances` VALUES (60,2,0,0,16,1,0,0,0,0,0,0,0,0,0,0,0,50,50,2,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (61,2,0,0,17,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,85,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (62,2,0,0,18,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,411,0,'',0,-1,'','','',NULL,'1',0,0,0);
-INSERT INTO `item_instances` VALUES (63,2,0,0,20,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (67,2,0,0,27,1,0,0,0,0,0,0,0,0,0,0,0,50,50,71,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (68,2,0,0,24,1,0,0,0,0,0,0,0,0,0,0,0,50,50,235,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (69,2,0,0,28,1,0,0,0,0,0,0,0,0,0,0,0,50,50,65,0,'',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (60,2,0,0,16,1,0,0,0,0,0,0,0,0,0,0,0,50,50,2,0,'',0,-1,'','','',NULL,'0',0,0,0); -- Small Battle Axe
+INSERT INTO `item_instances` VALUES (61,2,0,0,17,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,85,0,'',0,-1,'','','',NULL,'0',0,0,0); -- Gold Ore
+INSERT INTO `item_instances` VALUES (62,2,0,0,18,1,0,0,0,0,0,0,0,0,0,0,0,50,-1,411,0,'',0,-1,'','','',NULL,'1',0,0,0); -- Ring of Familiar
+INSERT INTO `item_instances` VALUES (63,2,0,0,20,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'',0,-1,'','','',NULL,'0',0,0,0); -- Rock Pick
+INSERT INTO `item_instances` VALUES (67,2,0,0,24,1,0,0,0,0,0,0,0,0,0,0,0,50,50,71,0,'',0,-1,'','','',NULL,'0',0,0,0); -- Gareths waybread recipe
+INSERT INTO `item_instances` VALUES (68,2,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,50,50,235,0,'',0,-1,'','','',NULL,'0',0,0,0); -- sack
+INSERT INTO `item_instances` VALUES (69,2,0,0,28,1,0,0,0,0,0,0,0,0,0,0,0,50,50,65,0,'',0,-1,'','','',NULL,'0',0,0,0); -- wooden spoon
+INSERT INTO `item_instances` VALUES (70,2,0,0,29,1,0,0,0,0,0,0,0,0,0,0,0,50,50,7,0,'',0,-1,'','','',NULL,'0',3,10,5); -- falchion with modifiers
+INSERT INTO `item_instances` VALUES (140,2,0,0,26,1,0,0,0,0,0,0,0,0,0,0,0,50,50,9,0,'',0,-1,'','','',NULL,'0',0,0,0); -- mug
 
 # Wooden bowl and contents
-INSERT INTO `item_instances` VALUES (70,0,0,0,0,1,0,0,0,3,-3.7,1.07,-180.58,0,0,0,0,50,50,70,0,'NOPICKUP',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (71,0,2,70,1,1,0,0,0,3,0,0,0,0,0,0,0,50,-1,60,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (72,0,2,70,2,2,0,0,0,3,0,0,0,0,0,0,0,50,-1,61,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (73,0,2,70,3,7,0,0,0,3,0,0,0,0,0,0,0,50,-1,62,0,'',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (75,0,0,0,0,1,0,0,0,3,-3.7,1.07,-180.58,0,0,0,0,50,50,70,0,'NOPICKUP',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (76,0,2,70,1,1,0,0,0,3,0,0,0,0,0,0,0,50,-1,60,0,'',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (77,0,2,70,2,2,0,0,0,3,0,0,0,0,0,0,0,50,-1,61,0,'',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (78,0,2,70,3,7,0,0,0,3,0,0,0,0,0,0,0,50,-1,62,0,'',0,-1,'','','',NULL,'0',0,0,0);
 
 # Book container and contents
 INSERT INTO `item_instances` VALUES (80,0,0,0,0,1,0,0,0,3,-56.16,-3,-154.73,0,4.74,0,0,50,50,234,0,'NOPICKUP',0,-1,'','','',NULL,'0',0,0,0);
@@ -174,11 +176,11 @@
 INSERT INTO `item_instances` VALUES (120,0,0,0,0,1,0,0,0,3,-15,0.12,-138.5,0,0,0,0,50,50,413,0,'KEY',0,-1,'119','','',NULL,'0',0,0,0);
 INSERT INTO `item_instances` VALUES (121,0,0,0,0,1,0,0,0,3,-16,0.12,-136.5,0,0,0,0,50,50,412,0,'LOCKED,LOCKABLE',0,-1,'','','',NULL,'0',0,0,0);
 INSERT INTO `item_instances` VALUES (128,0,0,0,0,1,0,0,0,3,-3.72,0.37,-183.03,0,90,0,0,50,50,138,0,'NOPICKUP',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (140,2,0,0,25,1,0,0,0,0,0,0,0,0,0,0,0,50,50,9,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (151,20,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
 INSERT INTO `item_instances` VALUES (166,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,3,0,'',0,-1,'','','',NULL,'0',0,0,0);
 INSERT INTO `item_instances` VALUES (171,0,0,0,0,17,0,0,0,3,-16.6,-0.01,-171.9,0,0,0,0,50,50,91,0,'',0,-1,'','','',NULL,'0',0,0,0);
 
+# Miner items
+INSERT INTO `item_instances` VALUES (151,20,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,50,50,84,0,'TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);
 
 # SpellMasters items
 INSERT INTO `item_instances` VALUES (180,82,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,50,50,13,0,'PURIFIED,TRANSIENT',0,-1,'','','',NULL,'0',0,0,0);

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[PlaneShift-svn] SF.net SVN: planeshift:[8445] trunk/src/server/database/mysql/ item_instances.sql

[<lpancallo@us...>]

Revision: 8445
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8445&view=rev
Author:   lpancallo
Date:     2012-09-24 21:05:11 +0000 (Mon, 24 Sep 2012)
Log Message:
-----------
Added comments to the table, no field changes.

Modified Paths:
--------------
    trunk/src/server/database/mysql/item_instances.sql

Modified: trunk/src/server/database/mysql/item_instances.sql
===================================================================
--- trunk/src/server/database/mysql/item_instances.sql	2012-09-24 21:02:14 UTC (rev 8444)
+++ trunk/src/server/database/mysql/item_instances.sql	2012-09-24 21:05:11 UTC (rev 8445)
@@ -20,35 +20,35 @@
 
 DROP TABLE IF EXISTS `item_instances`;
 CREATE TABLE `item_instances` (
-  `id` int(10) unsigned NOT NULL auto_increment,
-  `char_id_owner` int(10) unsigned default '0',
-  `char_id_guardian` int(10) unsigned default '0',
-  `parent_item_id` int(10) unsigned default '0',
-  `location_in_parent` smallint(4) default '0',
-  `stack_count` int(10) unsigned NOT NULL default '0',
-  `creator_mark_id` int(10) unsigned default '0',
-  `guild_mark_id` int(10) unsigned default '0',
-  `loc_instance` int(11) unsigned default '0',
-  `loc_sector_id` smallint(4) unsigned default '0',
-  `loc_x` float(14,6) default '0.00',
-  `loc_y` float(14,6) default '0.00',
-  `loc_z` float(14,6) default '0.00',
-  `loc_xrot` float(14,6) default '0.00',
-  `loc_yrot` float(14,6) default '0.00',
-  `loc_zrot` float(14,6) default '0.00',
-  `decay_resistance` float(3,2) NOT NULL default '0.00',
-  `item_quality` float(5,2) default '50.00',
-  `crafted_quality` float(5,2) default '50.00',
-  `item_stats_id_standard` int(10) unsigned NOT NULL default '0',
-  `item_stats_id_unique` int(10) unsigned default '0',
-  `flags` varchar(200) default '0',
-  `lock_str` int(5) NOT NULL default '0',
-  `lock_skill` int(2) NOT NULL default '-1',
-  `openable_locks` varchar(100) default '0',
-  `item_name` varchar(100) default '',
-  `item_description` TEXT default NULL,
-  `creative_definition` TEXT  DEFAULT NULL COMMENT 'This is used for books/sketch.',
-  `charges` int(3) NOT NULL default '0',
+  `id` int(10) unsigned NOT NULL auto_increment COMMENT 'The ID of the item, primary key',
+  `char_id_owner` int(10) unsigned default '0' COMMENT 'The ID of the character carring/owning the item',
+  `char_id_guardian` int(10) unsigned default '0' COMMENT 'If Talad drops an item to the ground, none else can take it, and Talad char ID is written here',
+  `parent_item_id` int(10) unsigned default '0' COMMENT 'The container ID where the item is stored into',
+  `location_in_parent` smallint(4) default '0' COMMENT 'The slot/position of the item inside the container or inside inventory',
+  `stack_count` int(10) unsigned NOT NULL default '0' COMMENT 'The number of identical items stacked into the same slot',
+  `creator_mark_id` int(10) unsigned default '0' COMMENT 'The character ID of the crafter of this item',
+  `guild_mark_id` int(10) unsigned default '0' COMMENT 'The UID of the guild who has certified this item',
+  `loc_instance` int(11) unsigned default '0' COMMENT 'The instance where the item is located',
+  `loc_sector_id` smallint(4) unsigned default '0' COMMENT 'The secot where the item is located',
+  `loc_x` float(14,6) default '0.00' COMMENT 'The x coordinate of the item location',
+  `loc_y` float(14,6) default '0.00' COMMENT 'The y coordinate of the item location',
+  `loc_z` float(14,6) default '0.00' COMMENT 'The z coordinate of the item location',
+  `loc_xrot` float(14,6) default '0.00' COMMENT 'The x rotation of the item. Valid when on ground.',
+  `loc_yrot` float(14,6) default '0.00' COMMENT 'The y rotation of the item. Valid when on ground.',
+  `loc_zrot` float(14,6) default '0.00' COMMENT 'The z rotation of the item. Valid when on ground.',
+  `decay_resistance` float(3,2) NOT NULL default '0.00' COMMENT 'The decay resistance percentage for the item',
+  `item_quality` float(5,2) default '50.00' COMMENT 'Current quality of item, can be lower than max',
+  `crafted_quality` float(5,2) default '50.00' COMMENT 'The max quality of the item',
+  `item_stats_id_standard` int(10) unsigned NOT NULL default '0' COMMENT 'The ID pointing to the item_stats base item definition',
+  `item_stats_id_unique` int(10) unsigned default '0' COMMENT 'NOT USED ATM',
+  `flags` varchar(200) default '0' COMMENT 'Various flags like: NOPICKUP, STACKABLE, PURIFIED, ...',
+  `lock_str` int(5) NOT NULL default '0' COMMENT 'If the item is a lock, this field expresses the lock strength to be lockpicked',
+  `lock_skill` int(2) NOT NULL default '-1' COMMENT 'If the item is a lock, this field expresses the required skill rank to be lockpicked',
+  `openable_locks` varchar(100) default '0' COMMENT 'Is the item is a key, lists all locks it can open. Can be multiple locks',
+  `item_name` varchar(100) default '' COMMENT 'Holds a custom item name. Can be empty',
+  `item_description` TEXT default NULL COMMENT 'Holds a custom item description. Can be empty',
+  `creative_definition` TEXT  DEFAULT NULL COMMENT 'This is used for books/sketch. Contains the XML to create the book/sketch',
+  `charges` int(3) NOT NULL default '0' COMMENT 'This is the number of charges currently held in the item',
   `prefix` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Determines the prefix to be used from the loot modifiers table',
   `suffix` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Determines the suffix to be used from the loot modifiers table',
   `adjective` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Determines the adjective to be used from the loot modifiers table',

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[PlaneShift-svn] SF.net SVN: planeshift:[8840] trunk/src/server/database/mysql/ item_instances.sql

[<ralphcampbell@us...>]

Revision: 8840
          http://sourceforge.net/p/planeshift/code/8840
Author:   ralphcampbell
Date:     2013-10-01 23:34:41 +0000 (Tue, 01 Oct 2013)
Log Message:
-----------
Fix bug 6169 - Fix container ID for wooden bowl contents.

Modified Paths:
--------------
    trunk/src/server/database/mysql/item_instances.sql

Modified: trunk/src/server/database/mysql/item_instances.sql
===================================================================
--- trunk/src/server/database/mysql/item_instances.sql	2013-10-01 16:15:05 UTC (rev 8839)
+++ trunk/src/server/database/mysql/item_instances.sql	2013-10-01 23:34:41 UTC (rev 8840)
@@ -134,9 +134,9 @@
 
 # Wooden bowl and contents
 INSERT INTO `item_instances` VALUES (75,0,0,0,0,1,0,0,0,3,-3.7,1.07,-180.58,0,0,0,0,50,50,70,0,'NOPICKUP',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (76,0,2,70,1,1,0,0,0,3,0,0,0,0,0,0,0,50,-1,60,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (77,0,2,70,2,2,0,0,0,3,0,0,0,0,0,0,0,50,-1,61,0,'',0,-1,'','','',NULL,'0',0,0,0);
-INSERT INTO `item_instances` VALUES (78,0,2,70,3,7,0,0,0,3,0,0,0,0,0,0,0,50,-1,62,0,'',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (76,0,2,75,1,1,0,0,0,3,0,0,0,0,0,0,0,50,-1,60,0,'',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (77,0,2,75,2,2,0,0,0,3,0,0,0,0,0,0,0,50,-1,61,0,'',0,-1,'','','',NULL,'0',0,0,0);
+INSERT INTO `item_instances` VALUES (78,0,2,75,3,7,0,0,0,3,0,0,0,0,0,0,0,50,-1,62,0,'',0,-1,'','','',NULL,'0',0,0,0);
 
 # Book container and contents
 INSERT INTO `item_instances` VALUES (80,0,0,0,0,1,0,0,0,3,-56.16,-3,-154.73,0,4.74,0,0,50,50,234,0,'NOPICKUP',0,-1,'','','',NULL,'0',0,0,0);

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.