From: <Ven...@us...> - 2008-11-07 06:23:23
|
Revision: 2373 http://planeshift.svn.sourceforge.net/planeshift/?rev=2373&view=rev Author: Vengeance2001 Date: 2008-11-07 06:23:20 +0000 (Fri, 07 Nov 2008) Log Message: ----------- Improved upgrade_schema.sql a bit. 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 2008-11-07 06:18:33 UTC (rev 2372) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2008-11-07 06:23:20 UTC (rev 2373) @@ -1028,6 +1028,9 @@ #### 1203 - Keith Fulton - Voiced NPC Dialog Support ALTER TABLE `npc_responses` ADD `audio_path` VARCHAR(100) NULL COMMENT 'This holds an optional VFS path to a speech file to be sent to the client and played on demand.' +UPDATE `server_options` SET `option_value`='1203' WHERE `option_name`='db_version'; +source npc_responses.sql +source quest_scripts.sql # 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. |
From: <wel...@us...> - 2008-11-08 18:33:00
|
Revision: 2386 http://planeshift.svn.sourceforge.net/planeshift/?rev=2386&view=rev Author: weltall2 Date: 2008-11-08 18:32:57 +0000 (Sat, 08 Nov 2008) Log Message: ----------- removed source calls in order to avoid having them executed on laanx in a future upgrade bt mistake 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 2008-11-08 18:17:10 UTC (rev 2385) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2008-11-08 18:32:57 UTC (rev 2386) @@ -1029,8 +1029,6 @@ #### 1203 - Keith Fulton - Voiced NPC Dialog Support ALTER TABLE `npc_responses` ADD `audio_path` VARCHAR(100) NULL COMMENT 'This holds an optional VFS path to a speech file to be sent to the client and played on demand.' UPDATE `server_options` SET `option_value`='1203' WHERE `option_name`='db_version'; -source npc_responses.sql -source quest_scripts.sql #### 1204 - Stefano Angeleri - removed underscore from admin commands and removed /show_gm which is a duplicate of /show gm UPDATE command_group_assignment SET command_name = '/targetname' WHERE command_name = '/target_name'; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <are...@us...> - 2008-11-09 01:57:45
|
Revision: 2390 http://planeshift.svn.sourceforge.net/planeshift/?rev=2390&view=rev Author: aresilek Date: 2008-11-09 01:57:43 +0000 (Sun, 09 Nov 2008) Log Message: ----------- - Fixed typo. 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 2008-11-08 23:41:52 UTC (rev 2389) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2008-11-09 01:57:43 UTC (rev 2390) @@ -1027,7 +1027,7 @@ UPDATE `server_options` SET `option_value`='1202' WHERE `option_name`='db_version'; #### 1203 - Keith Fulton - Voiced NPC Dialog Support -ALTER TABLE `npc_responses` ADD `audio_path` VARCHAR(100) NULL COMMENT 'This holds an optional VFS path to a speech file to be sent to the client and played on demand.' +ALTER TABLE `npc_responses` ADD `audio_path` VARCHAR(100) NULL COMMENT 'This holds an optional VFS path to a speech file to be sent to the client and played on demand.'; UPDATE `server_options` SET `option_value`='1203' WHERE `option_name`='db_version'; #### 1204 - Stefano Angeleri - removed underscore from admin commands and removed /show_gm which is a duplicate of /show gm This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wel...@us...> - 2008-12-26 12:07:54
|
Revision: 2777 http://planeshift.svn.sourceforge.net/planeshift/?rev=2777&view=rev Author: weltall2 Date: 2008-12-26 12:07:50 +0000 (Fri, 26 Dec 2008) Log Message: ----------- fixed missing semicolon 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 2008-12-26 08:23:41 UTC (rev 2776) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2008-12-26 12:07:50 UTC (rev 2777) @@ -1063,7 +1063,7 @@ UPDATE `server_options` SET `option_value`='1210' WHERE `option_name`='db_version'; #### 1211 - Keith Fulton - added last npc tracking to quest assignements -ALTER TABLE `character_quests` ADD `last_response_npc_id` INT(10) UNSIGNED NULL COMMENT 'This field stores the npc PID who gave the last response. Required for menu filtering.' +ALTER TABLE `character_quests` ADD `last_response_npc_id` INT(10) UNSIGNED NULL COMMENT 'This field stores the npc PID who gave the last response. Required for menu filtering.'; UPDATE `server_options` SET `option_value`='1211' WHERE `option_name`='db_version'; #### 1211 - Stefano Angeleri - Added /setkillexp This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <are...@us...> - 2009-06-22 14:22:53
|
Revision: 3858 http://planeshift.svn.sourceforge.net/planeshift/?rev=3858&view=rev Author: aresilek Date: 2009-06-22 13:43:31 +0000 (Mon, 22 Jun 2009) Log Message: ----------- - Fixed query. 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-06-22 13:35:51 UTC (rev 3857) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2009-06-22 13:43:31 UTC (rev 3858) @@ -1216,7 +1216,7 @@ UPDATE `server_options` SET `option_value`='1220' WHERE `option_name`='db_version'; #1221 - Stefano Angeleri - Added vote and comment in the character_events table -ALTER TABLE `character_events` ADDCOLUMN `vote` TINYINT(2) DEFAULT NULL COMMENT 'The vote expressed by the player on the specific event (range 1-10)' AFTER `event_id`, +ALTER TABLE `character_events` ADD COLUMN `vote` TINYINT(2) DEFAULT NULL COMMENT 'The vote expressed by the player on the specific event (range 1-10)' AFTER `event_id`, ADD COLUMN `comments` TEXT DEFAULT NULL COMMENT 'A comment left by the player on the event' AFTER `vote`; UPDATE `server_options` SET `option_value`='1221' WHERE `option_name`='db_version'; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wel...@us...> - 2009-06-22 14:53:19
|
Revision: 3857 http://planeshift.svn.sourceforge.net/planeshift/?rev=3857&view=rev Author: weltall2 Date: 2009-06-22 13:35:51 +0000 (Mon, 22 Jun 2009) Log Message: ----------- fixed the query 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-06-22 10:59:17 UTC (rev 3856) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2009-06-22 13:35:51 UTC (rev 3857) @@ -1216,8 +1216,8 @@ UPDATE `server_options` SET `option_value`='1220' WHERE `option_name`='db_version'; #1221 - Stefano Angeleri - Added vote and comment in the character_events table -ALTER TABLE `planeshiftshardtrunk`.`character_events` MODIFY COLUMN `vote` TINYINT(2) DEFAULT NULL COMMENT 'The vote expressed by the player on the specific event (range 1-10)', -MODIFY COLUMN `comments` TEXT DEFAULT NULL COMMENT 'A comment left by the player on the event'; +ALTER TABLE `character_events` ADDCOLUMN `vote` TINYINT(2) DEFAULT NULL COMMENT 'The vote expressed by the player on the specific event (range 1-10)' AFTER `event_id`, +ADD COLUMN `comments` TEXT DEFAULT NULL COMMENT 'A comment left by the player on the event' AFTER `vote`; UPDATE `server_options` SET `option_value`='1221' WHERE `option_name`='db_version'; # Insert your upgrade before this line. Remember when you set a new db_version This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2009-08-04 17:21:52
|
Revision: 4181 http://planeshift.svn.sourceforge.net/planeshift/?rev=4181&view=rev Author: lpancallo Date: 2009-08-04 17:21:45 +0000 (Tue, 04 Aug 2009) Log Message: ----------- Fixed some errors. We have to check spells.range !! range is a reserved mysql word. 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-08-04 11:37:30 UTC (rev 4180) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2009-08-04 17:21:45 UTC (rev 4181) @@ -936,6 +936,7 @@ UPDATE `server_options` SET `option_value`='1191' WHERE `option_name`='db_version'; #### 1192 - Paldorin - adding flag for forceall option of changename and adding checkitem command +DELETE FROM command_group_assignment where command_name='/checkitem'; INSERT INTO command_group_assignment VALUES( "/checkitem", 30 ); INSERT INTO command_group_assignment VALUES( "/checkitem", 26 ); INSERT INTO command_group_assignment VALUES( "/checkitem", 25 ); @@ -1087,7 +1088,7 @@ UPDATE `server_options` SET `option_value`='1212' WHERE `option_name`='db_version'; #### 1213 - Stefano Angeleri - Added the ability to make char creation data dynamic with factions -ALTER TABLE factions ADD COLUMN faction_character BLOB NOT NULL DEFAULT '' AFTER faction_description; +ALTER TABLE factions ADD COLUMN faction_character BLOB NOT NULL AFTER faction_description; ALTER TABLE characters ADD COLUMN description_life TEXT DEFAULT NULL AFTER creation_info; #### Kougaro - Added item rotation around the x and z axis This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2009-08-04 17:32:42
|
Revision: 4182 http://planeshift.svn.sourceforge.net/planeshift/?rev=4182&view=rev Author: lpancallo Date: 2009-08-04 17:32:28 +0000 (Tue, 04 Aug 2009) Log Message: ----------- If 'range' is quoted the alter statement works. 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-08-04 17:21:45 UTC (rev 4181) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2009-08-04 17:32:28 UTC (rev 4182) @@ -1125,7 +1125,7 @@ DROP saving_throw_value, ADD exclude_target boolean DEFAULT false AFTER target_type, ADD cast_duration text NOT NULL AFTER exclude_target, - ADD range text AFTER cast_duration, + ADD `range` text AFTER cast_duration, ADD aoe_radius text AFTER range, ADD aoe_angle text AFTER aoe_radius, CHANGE progression_event outcome text NOT NULL AFTER aoe_angle; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <mg...@us...> - 2009-09-22 15:52:52
|
Revision: 4481 http://planeshift.svn.sourceforge.net/planeshift/?rev=4481&view=rev Author: mgist Date: 2009-09-22 15:52:45 +0000 (Tue, 22 Sep 2009) Log Message: ----------- - Check for and disallow null strings in old common string fields (default is ''). 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 14:30:12 UTC (rev 4480) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2009-09-22 15:52:45 UTC (rev 4481) @@ -1288,31 +1288,44 @@ UPDATE `server_options` SET `option_value`='1229' WHERE `option_name`='db_version'; #1230 - Mike Gist - Remove common_strings, update field names and types. -ALTER TABLE `item_animations` CHANGE COLUMN `cstr_id_animation` `cstr_animation` VARCHAR(200) DEFAULT ''; +UPDATE `item_animations` set cstr_id_animation='' where cstr_id_animation is null +ALTER TABLE `item_animations` CHANGE COLUMN `cstr_id_animation` `cstr_animation` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `item_animations` set cstr_animation=(select string from common_strings where id=cstr_animation); -ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_mesh` `cstr_gfx_mesh` VARCHAR(200) DEFAULT ''; +UPDATE `item_stats` set cstr_id_gfx_mesh='' where cstr_id_gfx_mesh is null +ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_mesh` `cstr_gfx_mesh` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `item_stats` set cstr_gfx_mesh=(select string from common_strings where id=cstr_gfx_mesh); -ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_icon` `cstr_gfx_icon` VARCHAR(200) DEFAULT ''; +UPDATE `item_stats` set cstr_id_gfx_icon='' where cstr_id_gfx_icon is null +ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_icon` `cstr_gfx_icon` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `item_stats` set cstr_gfx_icon=(select string from common_strings where id=cstr_gfx_icon); -ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_texture` `cstr_gfx_texture` VARCHAR(200) DEFAULT ''; +UPDATE `item_stats` set cstr_id_gfx_texture='' where cstr_id_gfx_texture is null +ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_texture` `cstr_gfx_texture` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `item_stats` set cstr_gfx_texture=(select string from common_strings where id=cstr_gfx_texture); -ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_part` `cstr_part` VARCHAR(200) DEFAULT ''; +UPDATE `item_stats` set cstr_id_part='' where cstr_id_part is null +ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_part` `cstr_part` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `item_stats` set cstr_part=(select string from common_strings where id=cstr_part); -ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_part_mesh` `cstr_part_mesh` VARCHAR(200) DEFAULT ''; +UPDATE `item_stats` set cstr_id_part_mesh='' where cstr_id_part_mesh is null +ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_part_mesh` `cstr_part_mesh` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `item_stats` set cstr_part_mesh=(select string from common_strings where id=cstr_part_mesh); -ALTER TABLE `quests` CHANGE COLUMN `cstr_id_icon` `cstr_icon` VARCHAR(200) DEFAULT ''; +UPDATE `quests` set cstr_id_icon='' where cstr_id_icon is null +ALTER TABLE `quests` CHANGE COLUMN `cstr_id_icon` `cstr_icon` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `quests` set cstr_icon=(select string from common_strings where id=cstr_icon); -ALTER TABLE `race_info` CHANGE COLUMN `cstr_id_mesh` `cstr_mesh` VARCHAR(200) DEFAULT ''; +UPDATE `race_info` set cstr_id_mesh='' where cstr_id_mesh is null +ALTER TABLE `race_info` CHANGE COLUMN `cstr_id_mesh` `cstr_mesh` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `race_info` set cstr_mesh=(select string from common_strings where id=cstr_mesh); -ALTER TABLE `race_info` CHANGE COLUMN `cstr_id_base_texture` `cstr_base_texture` VARCHAR(200) DEFAULT ''; +UPDATE `race_info` set cstr_id_base_texture='' where cstr_id_base_texture is null +ALTER TABLE `race_info` CHANGE COLUMN `cstr_id_base_texture` `cstr_base_texture` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `race_info` set cstr_base_texture=(select string from common_strings where id=cstr_base_texture); -ALTER TABLE `spells` MODIFY COLUMN `cstr_npc_spell_category` VARCHAR(200) DEFAULT ''; +UPDATE `spells` set cstr_npc_spell_category='' where cstr_npc_spell_category is null +ALTER TABLE `spells` MODIFY COLUMN `cstr_npc_spell_category` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `spells` set cstr_npc_spell_category=(select string from common_strings where id=cstr_npc_spell_category); -ALTER TABLE `traits` CHANGE COLUMN `cstr_id_mesh` `cstr_mesh` VARCHAR(200) DEFAULT ''; +UPDATE `traits` set cstr_id_mesh='' where cstr_id_mesh is null +ALTER TABLE `traits` CHANGE COLUMN `cstr_id_mesh` `cstr_mesh` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `traits` set cstr_mesh=(select string from common_strings where id=cstr_mesh); -ALTER TABLE `traits` CHANGE COLUMN `cstr_id_material` `cstr_material` VARCHAR(200) DEFAULT ''; +UPDATE `traits` set cstr_id_material='' where cstr_id_material is null +ALTER TABLE `traits` CHANGE COLUMN `cstr_id_material` `cstr_material` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `traits` set cstr_material=(select string from common_strings where id=cstr_material); -ALTER TABLE `traits` CHANGE COLUMN `cstr_id_texture` `cstr_texture` VARCHAR(200) DEFAULT ''; +UPDATE `traits` set cstr_id_texture='' where cstr_id_texture is null +ALTER TABLE `traits` CHANGE COLUMN `cstr_id_texture` `cstr_texture` VARCHAR(200) NOT NULL DEFAULT ''; UPDATE `traits` set cstr_texture=(select string from common_strings where id=cstr_texture); DROP TABLE common_strings; UPDATE `server_options` SET `option_value`='1230' WHERE `option_name`='db_version'; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <mg...@us...> - 2009-09-22 16:32:27
|
Revision: 4484 http://planeshift.svn.sourceforge.net/planeshift/?rev=4484&view=rev Author: mgist Date: 2009-09-22 16:32:21 +0000 (Tue, 22 Sep 2009) Log Message: ----------- - Another attempt... 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:03:37 UTC (rev 4483) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2009-09-22 16:32:21 UTC (rev 4484) @@ -1288,45 +1288,58 @@ UPDATE `server_options` SET `option_value`='1229' WHERE `option_name`='db_version'; #1230 - Mike Gist - Remove common_strings, update field names and types. -UPDATE `item_animations` set cstr_id_animation='' where cstr_id_animation is null -ALTER TABLE `item_animations` CHANGE COLUMN `cstr_id_animation` `cstr_animation` VARCHAR(200) NOT NULL DEFAULT ''; +ALTER TABLE `item_animations` CHANGE COLUMN `cstr_id_animation` `cstr_animation` VARCHAR(200) DEFAULT ''; UPDATE `item_animations` set cstr_animation=(select string from common_strings where id=cstr_animation); -UPDATE `item_stats` set cstr_id_gfx_mesh='' where cstr_id_gfx_mesh is null -ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_mesh` `cstr_gfx_mesh` VARCHAR(200) NOT NULL DEFAULT ''; +UPDATE `item_animations` set cstr_animation='' where cstr_animation is null; +ALTER TABLE `item_animations` MODIFY COLUMN `cstr_animation` VARCHAR(200) NOT NULL DEFAULT ''; +ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_mesh` `cstr_gfx_mesh` VARCHAR(200) DEFAULT ''; UPDATE `item_stats` set cstr_gfx_mesh=(select string from common_strings where id=cstr_gfx_mesh); -UPDATE `item_stats` set cstr_id_gfx_icon='' where cstr_id_gfx_icon is null -ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_icon` `cstr_gfx_icon` VARCHAR(200) NOT NULL DEFAULT ''; +UPDATE `item_stats` set cstr_gfx_mesh='' where cstr_gfx_mesh is null; +ALTER TABLE `item_stats` MODIFY COLUMN `cstr_gfx_mesh` VARCHAR(200) NOT NULL DEFAULT ''; +ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_icon` `cstr_gfx_icon` VARCHAR(200) DEFAULT ''; UPDATE `item_stats` set cstr_gfx_icon=(select string from common_strings where id=cstr_gfx_icon); -UPDATE `item_stats` set cstr_id_gfx_texture='' where cstr_id_gfx_texture is null -ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_texture` `cstr_gfx_texture` VARCHAR(200) NOT NULL DEFAULT ''; +UPDATE `item_stats` set cstr_gfx_icon='' where cstr_gfx_icon is null; +ALTER TABLE `item_stats` MODIFY COLUMN `cstr_gfx_icon` VARCHAR(200) NOT NULL DEFAULT ''; +ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_gfx_texture` `cstr_gfx_texture` VARCHAR(200) DEFAULT ''; UPDATE `item_stats` set cstr_gfx_texture=(select string from common_strings where id=cstr_gfx_texture); -UPDATE `item_stats` set cstr_id_part='' where cstr_id_part is null -ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_part` `cstr_part` VARCHAR(200) NOT NULL DEFAULT ''; +UPDATE `item_stats` set cstr_gfx_texture='' where cstr_gfx_texture is null; +ALTER TABLE `item_stats` MODIFY COLUMN `cstr_gfx_texture` VARCHAR(200) NOT NULL DEFAULT ''; +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_id_part_mesh='' where cstr_id_part_mesh is null -ALTER TABLE `item_stats` CHANGE COLUMN `cstr_id_part_mesh` `cstr_part_mesh` VARCHAR(200) NOT NULL DEFAULT ''; +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` 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 `quests` set cstr_id_icon='' where cstr_id_icon is null -ALTER TABLE `quests` CHANGE COLUMN `cstr_id_icon` `cstr_icon` VARCHAR(200) NOT NULL DEFAULT ''; +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 `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 `race_info` set cstr_id_mesh='' where cstr_id_mesh is null -ALTER TABLE `race_info` CHANGE COLUMN `cstr_id_mesh` `cstr_mesh` VARCHAR(200) NOT NULL DEFAULT ''; +UPDATE `quests` set cstr_icon='' where cstr_icon is null; +ALTER TABLE `quests` MODIFY COLUMN `cstr_icon` VARCHAR(200) NOT NULL DEFAULT ''; +ALTER TABLE `race_info` CHANGE COLUMN `cstr_id_mesh` `cstr_mesh` VARCHAR(200) DEFAULT ''; UPDATE `race_info` set cstr_mesh=(select string from common_strings where id=cstr_mesh); -UPDATE `race_info` set cstr_id_base_texture='' where cstr_id_base_texture is null -ALTER TABLE `race_info` CHANGE COLUMN `cstr_id_base_texture` `cstr_base_texture` VARCHAR(200) NOT NULL DEFAULT ''; +UPDATE `race_info` set cstr_mesh='' where cstr_mesh is null; +ALTER TABLE `race_info` MODIFY COLUMN `cstr_mesh` VARCHAR(200) NOT NULL DEFAULT ''; +ALTER TABLE `race_info` CHANGE COLUMN `cstr_id_base_texture` `cstr_base_texture` VARCHAR(200) DEFAULT ''; UPDATE `race_info` set cstr_base_texture=(select string from common_strings where id=cstr_base_texture); -UPDATE `spells` set cstr_npc_spell_category='' where cstr_npc_spell_category is null +UPDATE `race_info` set cstr_base_texture='' where cstr_base_texture is null; +ALTER TABLE `race_info` MODIFY COLUMN `cstr_base_texture` VARCHAR(200) NOT NULL DEFAULT ''; +ALTER TABLE `spells` MODIFY COLUMN `cstr_npc_spell_category` VARCHAR(200) DEFAULT ''; +UPDATE `spells` set cstr_npc_spell_category=(select string from common_strings where id=cstr_npc_spell_category); +UPDATE `spells` set cstr_npc_spell_category='' where cstr_npc_spell_category is null; ALTER TABLE `spells` MODIFY COLUMN `cstr_npc_spell_category` VARCHAR(200) NOT NULL DEFAULT ''; -UPDATE `spells` set cstr_npc_spell_category=(select string from common_strings where id=cstr_npc_spell_category); -UPDATE `traits` set cstr_id_mesh='' where cstr_id_mesh is null -ALTER TABLE `traits` CHANGE COLUMN `cstr_id_mesh` `cstr_mesh` VARCHAR(200) NOT NULL DEFAULT ''; +ALTER TABLE `traits` CHANGE COLUMN `cstr_id_mesh` `cstr_mesh` VARCHAR(200) DEFAULT ''; UPDATE `traits` set cstr_mesh=(select string from common_strings where id=cstr_mesh); -UPDATE `traits` set cstr_id_material='' where cstr_id_material is null -ALTER TABLE `traits` CHANGE COLUMN `cstr_id_material` `cstr_material` VARCHAR(200) NOT NULL DEFAULT ''; +UPDATE `traits` set cstr_mesh='' where cstr_mesh is null; +ALTER TABLE `traits` MODIFY COLUMN `cstr_mesh` VARCHAR(200) NOT NULL DEFAULT ''; +ALTER TABLE `traits` CHANGE COLUMN `cstr_id_material` `cstr_material` VARCHAR(200) DEFAULT ''; UPDATE `traits` set cstr_material=(select string from common_strings where id=cstr_material); -UPDATE `traits` set cstr_id_texture='' where cstr_id_texture is null -ALTER TABLE `traits` CHANGE COLUMN `cstr_id_texture` `cstr_texture` VARCHAR(200) NOT NULL DEFAULT ''; +UPDATE `traits` set cstr_material='' where cstr_material is null; +ALTER TABLE `traits` MODIFY COLUMN `cstr_material` VARCHAR(200) NOT NULL DEFAULT ''; +ALTER TABLE `traits` CHANGE COLUMN `cstr_id_texture` `cstr_texture` VARCHAR(200) DEFAULT ''; UPDATE `traits` set cstr_texture=(select string from common_strings where id=cstr_texture); +UPDATE `traits` set cstr_texture='' where cstr_texture is null; +ALTER TABLE `traits` MODIFY COLUMN `cstr_texture` VARCHAR(200) NOT NULL DEFAULT ''; DROP TABLE common_strings; UPDATE `server_options` SET `option_value`='1230' WHERE `option_name`='db_version'; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <mg...@us...> - 2009-09-22 16:36:39
|
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. |
From: <Kha...@us...> - 2009-09-27 16:28:14
|
Revision: 4572 http://planeshift.svn.sourceforge.net/planeshift/?rev=4572&view=rev Author: Khakilord Date: 2009-09-27 16:28:05 +0000 (Sun, 27 Sep 2009) Log Message: ----------- Increased column width for graphics info. 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-27 16:13:39 UTC (rev 4571) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2009-09-27 16:28:05 UTC (rev 4572) @@ -1348,7 +1348,7 @@ #1231 - Andrew Dai added os and graphics card info ALTER TABLE `accounts` ADD COLUMN `operating_system` VARCHAR(32) NULL default '' COMMENT "The last operating system used with this account" AFTER `advisor_ban`; -ALTER TABLE `accounts` ADD COLUMN `graphics_card` VARCHAR(32) NULL default '' COMMENT "The last graphics card used with this account" AFTER `operating_system`; +ALTER TABLE `accounts` ADD COLUMN `graphics_card` VARCHAR(64) NULL default '' COMMENT "The last graphics card used with this account" AFTER `operating_system`; UPDATE `server_options` SET `option_value`='1231' WHERE `option_name`='db_version'; #1232 - Andrew Dai added graphics driver version This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <Kha...@us...> - 2010-02-09 23:02:29
|
Revision: 5504 http://planeshift.svn.sourceforge.net/planeshift/?rev=5504&view=rev Author: Khakilord Date: 2010-02-09 23:02:23 +0000 (Tue, 09 Feb 2010) Log Message: ----------- Fixed wrong sql command. 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 2010-02-09 22:59:48 UTC (rev 5503) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2010-02-09 23:02:23 UTC (rev 5504) @@ -1401,7 +1401,7 @@ UPDATE `server_options` SET `option_value`='1237' WHERE `option_name`='db_version'; #1238 - Stefano Angeleri Added instanced action locations. -ALTER TABLE `action_locations` MODIFY COLUMN `pos_instance` INTEGER UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'Indicates the instance where this action location will be accessible from. 0xFFFFFFFF (default) is instance all'; +ALTER TABLE `action_locations` ADD COLUMN `pos_instance` INTEGER UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'Indicates the instance where this action location will be accessible from. 0xFFFFFFFF (default) is instance all'; UPDATE `server_options` SET `option_value`='1238' WHERE `option_name`='db_version'; # Insert your upgrade before this line. Remember when you set a new db_version This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wel...@us...> - 2011-03-22 20:03:06
|
Revision: 7099 http://planeshift.svn.sourceforge.net/planeshift/?rev=7099&view=rev Author: weltall2 Date: 2011-03-22 20:02:59 +0000 (Tue, 22 Mar 2011) Log Message: ----------- removed db names 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 2011-03-21 19:52:28 UTC (rev 7098) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2011-03-22 20:02:59 UTC (rev 7099) @@ -1496,7 +1496,7 @@ UPDATE `server_options` SET `option_value`='1255' WHERE `option_name`='db_version'; #1256 - Stefano Angeleri - Added support for automatic fog and snow events. -ALTER TABLE `planeshift`.`sectors` MODIFY COLUMN `name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'The name of the sector (as defined in map files)', +ALTER TABLE `sectors` MODIFY COLUMN `name` VARCHAR(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'The name of the sector (as defined in map files)', MODIFY COLUMN `rain_enabled` CHAR(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'N' COMMENT 'Sets if automatic rain should trigger. Put Y to enable it, N to disable it.', MODIFY COLUMN `rain_min_gap` INTEGER UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Sets the minimum time between two automatically triggered rain events.', MODIFY COLUMN `rain_max_gap` INTEGER UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Sets the maximum time between two automatically triggered rain events.', @@ -1551,7 +1551,7 @@ DELETE FROM command_group_assignment where command_name in("/money","/awardexp"); #1256 - Stefano Angeleri - Converted trans_points in a math expression. -ALTER TABLE `planeshift`.`trade_transformations` MODIFY COLUMN `trans_points` VARCHAR(255) NOT NULL DEFAULT '0'; +ALTER TABLE `trade_transformations` MODIFY COLUMN `trans_points` VARCHAR(255) NOT NULL DEFAULT '0'; INSERT INTO `server_options` VALUES('npcmanager:petskill', '31'); #1257 - Stefano Angeleri - defined the math script used for calculation in the skill rows This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <rav...@us...> - 2011-12-23 00:48:42
|
Revision: 7887 http://planeshift.svn.sourceforge.net/planeshift/?rev=7887&view=rev Author: ravna-ps Date: 2011-12-23 00:48:36 +0000 (Fri, 23 Dec 2011) Log Message: ----------- changed 2 ' into ` 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 2011-12-22 21:53:21 UTC (rev 7886) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2011-12-23 00:48:36 UTC (rev 7887) @@ -1649,7 +1649,7 @@ ALTER TABLE `tribes` ADD COLUMN tribal_recipe int(5) NOT NULL AFTER `npc_idle_behavior`; update tribes set tribal_recipe=5; INSERT INTO `item_categories` VALUES (28,'Buildings',NULL,NULL,NULL,100,0,0); -ALTER TABLE 'sc_tribe_resources' ADD COLUMN `nick` varchar(30) NOT NULL default '' AFTER 'name'; +ALTER TABLE `sc_tribe_resources` ADD COLUMN `nick` varchar(30) NOT NULL default '' AFTER `name`; # # Updated tribe member types to be a string 1262 This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wel...@us...> - 2012-01-24 15:09:03
|
Revision: 8039 http://planeshift.svn.sourceforge.net/planeshift/?rev=8039&view=rev Author: weltall2 Date: 2012-01-24 15:08:54 +0000 (Tue, 24 Jan 2012) Log Message: ----------- missing file 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 2012-01-24 15:08:37 UTC (rev 8038) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2012-01-24 15:08:54 UTC (rev 8039) @@ -1678,6 +1678,14 @@ ALTER TABLE `quest_scripts` MODIFY COLUMN `script` TEXT NOT NULL; +CREATE TABLE `planeshift`.`loot_modifiers_restrains` ( + `loot_modifier_id` INTEGER NOT NULL COMMENT 'The id of the loot modifier rule', + `item_id` INTEGER NOT NULL COMMENT 'The id of the item included in the loot modifier rule', + PRIMARY KEY (`loot_modifier_id`, `item_id`) +) +ENGINE = MyISAM +COMMENT = 'Allows to define some restrain to the loot_modifiers'; + # 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. |
From: <lpa...@us...> - 2012-09-24 21:02:21
|
Revision: 8444 http://planeshift.svn.sourceforge.net/planeshift/?rev=8444&view=rev Author: lpancallo Date: 2012-09-24 21:02:14 +0000 (Mon, 24 Sep 2012) Log Message: ----------- Cosmetic change just to have notepad++ not mess up with syntax highlight. 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 2012-09-24 13:32:39 UTC (rev 8443) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2012-09-24 21:02:14 UTC (rev 8444) @@ -1452,7 +1452,7 @@ #1247 - Stefano Angeleri - Added a field to define which mesh are hidden by the items. UPDATE `server_options` SET `option_value`='1247' WHERE `option_name`='db_version'; -ALTER TABLE `item_stats` ADD COLUMN `removed_mesh` VARCHAR(200) NOT NULL COMMENT 'Lists the mesh to be removed when this item is equipped. It\'s defined in this format slotname:mesh1,mesh2; slotname:mesh3; mesh4,mesh5. slotname is optional.' AFTER `cstr_part_mesh`; +ALTER TABLE `item_stats` ADD COLUMN `removed_mesh` VARCHAR(200) NOT NULL COMMENT 'Lists the mesh to be removed when this item is equipped. It is defined in this format slotname:mesh1,mesh2; slotname:mesh3; mesh4,mesh5. slotname is optional.' AFTER `cstr_part_mesh`; UPDATE item_stats set removed_mesh="helm:Hair" where valid_slots like "%HELM%" and name != "basecloths" and name not like "%Natural%" and name != "Rogue Armor"; #1248 - Anders Reggestad added need set to tribe_needs This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <lpa...@us...> - 2013-12-24 18:19:27
|
Revision: 9105 http://sourceforge.net/p/planeshift/code/9105 Author: lpancallo Date: 2013-12-24 18:19:24 +0000 (Tue, 24 Dec 2013) Log Message: ----------- Added missing "Calculate Lockpicking Experience" script 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 2013-12-22 11:21:11 UTC (rev 9104) +++ trunk/src/server/database/mysql/upgrade_schema.sql 2013-12-24 18:19:24 UTC (rev 9105) @@ -1790,6 +1790,15 @@ INSERT INTO command_group_assignment VALUES( "/scale", 24 ); INSERT INTO command_group_assignment VALUES( "/scale", 23 ); +#Lockpicking scripts +INSERT INTO math_scripts VALUES( "Calculate Lockpicking Experience", +" +ResultPractice = 1; +ResultModifier = 1; +"); + + + # 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. |