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

[<wel...@us...>]

Revision: 3601
          http://planeshift.svn.sourceforge.net/planeshift/?rev=3601&view=rev
Author:   weltall2
Date:     2009-05-01 18:54:09 +0000 (Fri, 01 May 2009)

Log Message:
-----------
fixed a db inconsistency

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

Modified: trunk/src/server/database/mysql/trade_processes.sql
===================================================================
--- trunk/src/server/database/mysql/trade_processes.sql	2009-05-01 17:31:08 UTC (rev 3600)
+++ trunk/src/server/database/mysql/trade_processes.sql	2009-05-01 18:54:09 UTC (rev 3601)
@@ -23,7 +23,7 @@
   primary_max_skill int(8) unsigned ,                           # maximum primary skill level at which practice and quality are effected, 0 is no maximum
   primary_practice_points int(4) ,                              # number of practice primary skill points gained for performing transformation
   primary_quality_factor int(3) unsigned DEFAULT '0' ,          # percentage of the primary skill range that applies to quality
-  secondary_skill_id int(10) unsigned ,                         # secondary skill foriegn key
+  secondary_skill_id int(10)  ,                                 # secondary skill foriegn key
   secondary_min_skill int(8) unsigned ,                         # minimum secondary skill level required to perform transformation, 0 is no minimum
   secondary_max_skill int(8) unsigned ,                         # maximum secondary skill level at which practice and quality are effected, 0 is no maximum
   secondary_practice_points int(4) ,                            # number of practice secondary skill points gained for performing transformation

Modified: trunk/src/server/database/mysql/upgrade_schema.sql
===================================================================
--- trunk/src/server/database/mysql/upgrade_schema.sql	2009-05-01 17:31:08 UTC (rev 3600)
+++ trunk/src/server/database/mysql/upgrade_schema.sql	2009-05-01 18:54:09 UTC (rev 3601)
@@ -1189,6 +1189,8 @@
 Exp = if(StartQuality < CurrentQuality, 2*(CurrentQuality-StartQuality), 0);
 ");
 
+ALTER TABLE `trade_processes` MODIFY COLUMN `secondary_skill_id` INTEGER;
+
 # 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 to ensure that everything is working if you use the create_all.sql to


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