From: <wel...@us...> - 2009-08-03 13:43:11
|
Revision: 4176 http://planeshift.svn.sourceforge.net/planeshift/?rev=4176&view=rev Author: weltall2 Date: 2009-08-03 13:43:01 +0000 (Mon, 03 Aug 2009) Log Message: ----------- added a comment Modified Paths: -------------- trunk/src/server/database/mysql/item_stats.sql trunk/src/server/database/mysql/upgrade_schema.sql Modified: trunk/src/server/database/mysql/item_stats.sql =================================================================== --- trunk/src/server/database/mysql/item_stats.sql 2009-08-03 13:16:45 UTC (rev 4175) +++ trunk/src/server/database/mysql/item_stats.sql 2009-08-03 13:43:01 UTC (rev 4176) @@ -28,7 +28,7 @@ `visible_distance` float(10,2) NOT NULL default '100.00', `size` int(5) unsigned NOT NULL default '1', `container_max_size` int(5) unsigned NOT NULL default '1', - `container_max_slots` INT(5) UNSIGNED NOT NULL DEFAULT '0', + `container_max_slots` INT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT "The amount of slots which will be available in this item to store items inside if it's a container", `valid_slots` varchar(255) default 'BULK', `flags` varchar(255) default NULL, `decay_rate` float(3,2) NOT NULL default '0.10', Modified: trunk/src/server/database/mysql/upgrade_schema.sql =================================================================== --- trunk/src/server/database/mysql/upgrade_schema.sql 2009-08-03 13:16:45 UTC (rev 4175) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2009-08-03 13:43:01 UTC (rev 4176) @@ -1264,7 +1264,7 @@ #1226 - Stefano Angeleri - Added selectable max slots for a container -ALTER TABLE `item_stats` ADD COLUMN `container_max_slots` INT(5) UNSIGNED NOT NULL DEFAULT 0 AFTER `container_max_size`; +ALTER TABLE `item_stats` ADD COLUMN `container_max_slots` INT(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT "The amount of slots which will be available in this item to store items inside if it's a container" AFTER `container_max_size`; UPDATE item_stats set container_max_slots=16 where flags like "%CONTAINER%"; UPDATE `server_options` SET `option_value`='1226' WHERE `option_name`='db_version'; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |