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

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

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

Log Message:
-----------
updated db

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

Modified: trunk/src/server/database/mysql/server_options.sql
===================================================================
--- trunk/src/server/database/mysql/server_options.sql	2010-08-07 20:20:23 UTC (rev 6147)
+++ trunk/src/server/database/mysql/server_options.sql	2010-08-08 17:01:42 UTC (rev 6148)
@@ -29,7 +29,7 @@
 # Dumping data for table server_options
 #
 
-INSERT INTO `server_options` VALUES ('db_version','1250');
+INSERT INTO `server_options` VALUES ('db_version','1251');
 INSERT INTO `server_options` VALUES ('game_time','15:00');
 INSERT INTO `server_options` VALUES ('game_date','100-1-1');
 INSERT INTO `server_options` VALUES ('standard_motd','This is the message of the day from server_options table.');

Modified: trunk/src/server/database/mysql/upgrade_schema.sql
===================================================================
--- trunk/src/server/database/mysql/upgrade_schema.sql	2010-08-07 20:20:23 UTC (rev 6147)
+++ trunk/src/server/database/mysql/upgrade_schema.sql	2010-08-08 17:01:42 UTC (rev 6148)
@@ -1471,6 +1471,10 @@
 UPDATE `server_options` SET `option_value`='1250' WHERE `option_name`='db_version';
 ALTER TABLE `npc_spawn_rules`
   ADD COLUMN `min_spawn_spacing_dist` float(10,2) default '0.0' AFTER `dead_remain_time`;
+  
+#1251 - Stefano Angeleri - Added possibility to define a command associated to an item to be shown in the context menu
+ALTER TABLE `item_stats` ADD COLUMN `assigned_command` VARCHAR(40)  NOT NULL DEFAULT '' COMMENT 'Used to determine if the item could be used with a specific command. Will be used to show it in the context menu when the item is equipped.' AFTER `weapon_range`;
+UPDATE `server_options` SET `option_value`='1251' WHERE `option_name`='db_version';
 
 # 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.