From: <rds...@us...> - 2008-03-16 21:15:12
|
Revision: 1194 http://planeshift.svn.sourceforge.net/planeshift/?rev=1194&view=rev Author: rdschulz Date: 2008-03-16 14:15:18 -0700 (Sun, 16 Mar 2008) Log Message: ----------- - small fix to preserve INSTANCE_ALL members in item_instances on upgrade Modified Paths: -------------- trunk/docs/history.txt trunk/src/server/database/mysql/upgrade_schema.sql Modified: trunk/docs/history.txt =================================================================== --- trunk/docs/history.txt 2008-03-16 21:05:05 UTC (rev 1193) +++ trunk/docs/history.txt 2008-03-16 21:15:18 UTC (rev 1194) @@ -1,6 +1,7 @@ *** 2008-03-15 by Roland Schulz - changed loc_instance in item_instances to unsigned to avoid 0x7fffffff instance bug. - DBVER BUMP! +- small fix to preserve INSTANCE_ALL members in item_instances on upgrade *** 2008-03-16 by Thomas Towey - Fixed server crash from allowing transformations to be done in hand without containers.for combine. Modified: trunk/src/server/database/mysql/upgrade_schema.sql =================================================================== --- trunk/src/server/database/mysql/upgrade_schema.sql 2008-03-16 21:05:05 UTC (rev 1193) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2008-03-16 21:15:18 UTC (rev 1194) @@ -887,7 +887,9 @@ UPDATE `server_options` SET `option_value`='1181' WHERE `option_name`='db_version'; #### 1182 - Roland Schulz - switch loc_instance in item_instances to unsigned +update item_instances set loc_instance=0x7fffffff where loc_instance=-1; ALTER TABLE item_instances MODIFY COLUMN `loc_instance` int(11) unsigned default '0'; +update item_instances set loc_instance=0xffffffff where loc_instance=0x7fffffff; # Insert your upgrade before this line. Remember when you set a new db_version # to update the server_options.sql file and update psserver.cpp as well. This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |