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

[<mg...@us...>]

Revision: 4485
          http://planeshift.svn.sourceforge.net/planeshift/?rev=4485&view=rev
Author:   mgist
Date:     2009-09-22 16:36:30 +0000 (Tue, 22 Sep 2009)

Log Message:
-----------
- Fix.

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

Modified: trunk/src/server/database/mysql/upgrade_schema.sql
===================================================================
--- trunk/src/server/database/mysql/upgrade_schema.sql	2009-09-22 16:32:21 UTC (rev 4484)
+++ trunk/src/server/database/mysql/upgrade_schema.sql	2009-09-22 16:36:30 UTC (rev 4485)
@@ -1307,11 +1307,11 @@
 ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_part` `cstr_part` VARCHAR(200) DEFAULT '';
 UPDATE `item_stats` set cstr_part=(select string from common_strings where id=cstr_part);
 UPDATE `item_stats` set cstr_part='' where cstr_part is null;
-ALTER TABLE `item_stats` MODIFY COLUMN `cstr_gfx_part` VARCHAR(200) NOT NULL DEFAULT '';
+ALTER TABLE `item_stats` MODIFY COLUMN `cstr_part` VARCHAR(200) NOT NULL DEFAULT '';
 ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_part_mesh` `cstr_part_mesh` VARCHAR(200) DEFAULT '';
 UPDATE `item_stats` set cstr_part_mesh=(select string from common_strings where id=cstr_part_mesh);
 UPDATE `item_stats` set cstr_part_mesh='' where cstr_part_mesh is null;
-ALTER TABLE `item_stats` MODIFY COLUMN `cstr_gfx_part_mesh` VARCHAR(200) NOT NULL DEFAULT '';
+ALTER TABLE `item_stats` MODIFY COLUMN `cstr_part_mesh` VARCHAR(200) NOT NULL DEFAULT '';
 ALTER TABLE `quests` CHANGE COLUMN `cstr_id_icon` `cstr_icon` VARCHAR(200) DEFAULT '';
 UPDATE `quests` set cstr_icon=(select string from common_strings where id=cstr_icon);
 UPDATE `quests` set cstr_icon='' where cstr_icon is null;


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