From 168b4ecad16a95da99e806098323cf3b59c3f105 Mon Sep 17 00:00:00 2001 From: Brian Date: Thu, 8 Jul 2010 05:59:15 -0600 Subject: * Prepare SQL directories --HG-- branch : trunk rename : sql/updates/8770_world_areatrigger_scripts.sql => sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql rename : sql/updates/8770_world_script_waypoints.sql => sql/updates/3.3.3a_old/8770_world_script_waypoints.sql rename : sql/updates/8770_world_scriptname.sql => sql/updates/3.3.3a_old/8770_world_scriptname.sql rename : sql/updates/8790_world_locales_item_set_names.sql => sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql rename : sql/updates/8816_world_spell_bonus_data.sql => sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql rename : sql/updates/8821_world_spell_dbc.sql => sql/updates/3.3.3a_old/8821_world_spell_dbc.sql rename : sql/updates/8836_world_spell_linked_spell.sql => sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql rename : sql/updates/8842_world_script_texts.sql => sql/updates/3.3.3a_old/8842_world_script_texts.sql rename : sql/updates/8842_world_scriptname.sql => sql/updates/3.3.3a_old/8842_world_scriptname.sql rename : sql/updates/8843_world_scriptname.sql => sql/updates/3.3.3a_old/8843_world_scriptname.sql --- sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql | 4 ++++ sql/updates/3.3.3a_old/8770_world_script_waypoints.sql | 9 +++++++++ sql/updates/3.3.3a_old/8770_world_scriptname.sql | 12 ++++++++++++ sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql | 2 ++ sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql | 4 ++++ sql/updates/3.3.3a_old/8821_world_spell_dbc.sql | 8 ++++++++ sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql | 3 +++ sql/updates/3.3.3a_old/8842_world_script_texts.sql | 5 +++++ sql/updates/3.3.3a_old/8842_world_scriptname.sql | 2 ++ sql/updates/3.3.3a_old/8843_world_scriptname.sql | 2 ++ sql/updates/3.3.5a_old/CMakeLists.txt | 3 +++ sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql | 3 +++ sql/updates/8770_world_areatrigger_scripts.sql | 4 ---- sql/updates/8770_world_script_waypoints.sql | 9 --------- sql/updates/8770_world_scriptname.sql | 12 ------------ sql/updates/8790_world_locales_item_set_names.sql | 2 -- sql/updates/8816_world_spell_bonus_data.sql | 4 ---- sql/updates/8821_world_spell_dbc.sql | 8 -------- sql/updates/8836_world_spell_linked_spell.sql | 3 --- sql/updates/8842_world_script_texts.sql | 5 ----- sql/updates/8842_world_scriptname.sql | 2 -- sql/updates/8843_world_scriptname.sql | 2 -- sql/updates/CMakeLists.txt | 1 + 23 files changed, 58 insertions(+), 51 deletions(-) create mode 100644 sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql create mode 100644 sql/updates/3.3.3a_old/8770_world_script_waypoints.sql create mode 100644 sql/updates/3.3.3a_old/8770_world_scriptname.sql create mode 100644 sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql create mode 100644 sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql create mode 100644 sql/updates/3.3.3a_old/8821_world_spell_dbc.sql create mode 100644 sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql create mode 100644 sql/updates/3.3.3a_old/8842_world_script_texts.sql create mode 100644 sql/updates/3.3.3a_old/8842_world_scriptname.sql create mode 100644 sql/updates/3.3.3a_old/8843_world_scriptname.sql create mode 100644 sql/updates/3.3.5a_old/CMakeLists.txt create mode 100644 sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql delete mode 100644 sql/updates/8770_world_areatrigger_scripts.sql delete mode 100644 sql/updates/8770_world_script_waypoints.sql delete mode 100644 sql/updates/8770_world_scriptname.sql delete mode 100644 sql/updates/8790_world_locales_item_set_names.sql delete mode 100644 sql/updates/8816_world_spell_bonus_data.sql delete mode 100644 sql/updates/8821_world_spell_dbc.sql delete mode 100644 sql/updates/8836_world_spell_linked_spell.sql delete mode 100644 sql/updates/8842_world_script_texts.sql delete mode 100644 sql/updates/8842_world_scriptname.sql delete mode 100644 sql/updates/8843_world_scriptname.sql (limited to 'sql') diff --git a/sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql b/sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql new file mode 100644 index 00000000000..044725b3a5f --- /dev/null +++ b/sql/updates/3.3.3a_old/8770_world_areatrigger_scripts.sql @@ -0,0 +1,4 @@ +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5369,5423); +INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES +(5369, 'at_RX_214_repair_o_matic_station'), +(5423, 'at_RX_214_repair_o_matic_station'); diff --git a/sql/updates/3.3.3a_old/8770_world_script_waypoints.sql b/sql/updates/3.3.3a_old/8770_world_script_waypoints.sql new file mode 100644 index 00000000000..c2418f6da33 --- /dev/null +++ b/sql/updates/3.3.3a_old/8770_world_script_waypoints.sql @@ -0,0 +1,9 @@ +-- Waypoints for Mimron Inferno +DELETE FROM `script_waypoint` WHERE `entry`=33370; +INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES +(33370, 1, 331.674, -68.6878, 409.804, 0, '0'), +(33370, 2, 274.578, -92.1829, 409.804, 0, '0'), +(33370, 3, 226.433, -66.6652, 409.793, 0, '0'), +(33370, 4, 206.092, -34.7447, 409.801, 0, '0'), +(33370, 5, 240.208, 1.10346, 409.802, 0, '0'), +(33370, 6, 337.199, 11.7051, 409.802, 0, '0'); diff --git a/sql/updates/3.3.3a_old/8770_world_scriptname.sql b/sql/updates/3.3.3a_old/8770_world_scriptname.sql new file mode 100644 index 00000000000..e173f7e41f2 --- /dev/null +++ b/sql/updates/3.3.3a_old/8770_world_scriptname.sql @@ -0,0 +1,12 @@ +UPDATE `creature_template` SET `ScriptName`= 'npc_thorims_hammer' WHERE `entry`=33365; +UPDATE `creature_template` SET `ScriptName`= 'npc_mimirons_inferno' WHERE `entry`=33370; +UPDATE `creature_template` SET `ScriptName`= 'npc_hodirs_fury' WHERE `entry`=33312; +UPDATE `creature_template` SET `ScriptName`= 'npc_freyas_ward' WHERE `entry`=33367; +UPDATE `creature_template` SET `ScriptName`= 'npc_lorekeeper' WHERE `entry`=33686; +UPDATE `creature_template` SET `ScriptName`= 'npc_brann_bronzebeard' WHERE `entry`=33579; +UPDATE `creature_template` SET `ScriptName`= 'npc_freya_ward_summon' WHERE `entry`=34275; +UPDATE `creature_template` SET `ScriptName`= 'npc_mechanolift' WHERE `entry`=33214; +UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194375; +UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194371; +UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194370; +UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194377; diff --git a/sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql b/sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql new file mode 100644 index 00000000000..4f6015ac749 --- /dev/null +++ b/sql/updates/3.3.3a_old/8790_world_locales_item_set_names.sql @@ -0,0 +1,2 @@ +DROP TABLE IF EXISTS `locales_item_set_names`; +RENAME TABLE `locales_item_set_name` TO `locales_item_set_names`; diff --git a/sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql b/sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql new file mode 100644 index 00000000000..67d01d19b77 --- /dev/null +++ b/sql/updates/3.3.3a_old/8816_world_spell_bonus_data.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_bonus_data` WHERE `entry` IN (45284,45297); +INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES +(45284,0.357,-1,-1,-1,'Shaman - LO Lightning Bolt'), +(45297,0.285,-1,-1,-1,'Shaman - LO Chain Lightning'); diff --git a/sql/updates/3.3.3a_old/8821_world_spell_dbc.sql b/sql/updates/3.3.3a_old/8821_world_spell_dbc.sql new file mode 100644 index 00000000000..903a932edaf --- /dev/null +++ b/sql/updates/3.3.3a_old/8821_world_spell_dbc.sql @@ -0,0 +1,8 @@ +-- Add serverside spells place holders for future development +DELETE FROM `spell_dbc` WHERE `Id` IN (11202,25359,40145,45767,71098); +INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES +(11202, 'Item 3776 spellid_1 serverside spell'), +(25359, 'Item 21293 spellid_2 serverside spell'), +(40145, 'Quest 11000 RewSpellCast serverside spell'), +(45767, 'Quest 11670 RewSpellCast serverside spell'), +(71098, 'Quest 24451 RewSpellCast serverside spell'); diff --git a/sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql b/sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql new file mode 100644 index 00000000000..64c3c66c9e1 --- /dev/null +++ b/sql/updates/3.3.3a_old/8836_world_spell_linked_spell.sql @@ -0,0 +1,3 @@ +-- Make the Ardent Defender heal (66235) trigger the visuals (66233) +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=66235; +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES (66235,66233,0, 'Ardent Defender Visuals'); diff --git a/sql/updates/3.3.3a_old/8842_world_script_texts.sql b/sql/updates/3.3.3a_old/8842_world_script_texts.sql new file mode 100644 index 00000000000..617b61a694f --- /dev/null +++ b/sql/updates/3.3.3a_old/8842_world_script_texts.sql @@ -0,0 +1,5 @@ +DELETE FROM script_texts where entry IN (-1000474, -1000475, -1000476); +INSERT INTO script_texts (`npc_entry`, `entry`, `content_default`, `type`, `language`, `comment`) VALUE +(17375, -1000474, '[Fulborg] The Stillpine furbolgs will not soon forget your bravery!', 0, 0, 'Stillpine Capitive free say text 1'), +(17375, -1000475, '[Fulborg] Thank you, $N', 0, 0, 'Stillpine Capitive free say text 2'), +(17375, -1000476, '[Fulborg] Those remaining at Stillpine Hold will welcome you as a hero!', 0, 0, 'Stillpine Capitive free say text 3'); diff --git a/sql/updates/3.3.3a_old/8842_world_scriptname.sql b/sql/updates/3.3.3a_old/8842_world_scriptname.sql new file mode 100644 index 00000000000..5ef8e4b6aa9 --- /dev/null +++ b/sql/updates/3.3.3a_old/8842_world_scriptname.sql @@ -0,0 +1,2 @@ +UPDATE `creature_template` SET `ScriptName`='npc_stillpine_capitive' where `entry`=17375; +UPDATE `gameobject_template` SET `ScriptName`='go_stillpine_cage' WHERE `entry`=181714; diff --git a/sql/updates/3.3.3a_old/8843_world_scriptname.sql b/sql/updates/3.3.3a_old/8843_world_scriptname.sql new file mode 100644 index 00000000000..4517544d99d --- /dev/null +++ b/sql/updates/3.3.3a_old/8843_world_scriptname.sql @@ -0,0 +1,2 @@ +UPDATE `gameobject_template` SET `ScriptName`='go_bristlelimb_cage' WHERE `entry`=181714; + diff --git a/sql/updates/3.3.5a_old/CMakeLists.txt b/sql/updates/3.3.5a_old/CMakeLists.txt new file mode 100644 index 00000000000..63cb6eab23e --- /dev/null +++ b/sql/updates/3.3.5a_old/CMakeLists.txt @@ -0,0 +1,3 @@ +FILE(GLOB _SQL_335 *.sql) + +INSTALL(FILES ${_SQL_333} DESTINATION share/trinity/sql/updates/3.3.5a_old) diff --git a/sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql b/sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql new file mode 100644 index 00000000000..c6622d5ce1e --- /dev/null +++ b/sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=12340 WHERE `id`=1; +ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '12340'; + diff --git a/sql/updates/8770_world_areatrigger_scripts.sql b/sql/updates/8770_world_areatrigger_scripts.sql deleted file mode 100644 index 044725b3a5f..00000000000 --- a/sql/updates/8770_world_areatrigger_scripts.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5369,5423); -INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES -(5369, 'at_RX_214_repair_o_matic_station'), -(5423, 'at_RX_214_repair_o_matic_station'); diff --git a/sql/updates/8770_world_script_waypoints.sql b/sql/updates/8770_world_script_waypoints.sql deleted file mode 100644 index c2418f6da33..00000000000 --- a/sql/updates/8770_world_script_waypoints.sql +++ /dev/null @@ -1,9 +0,0 @@ --- Waypoints for Mimron Inferno -DELETE FROM `script_waypoint` WHERE `entry`=33370; -INSERT INTO `script_waypoint` (`entry`, `pointid`, `location_x`, `location_y`, `location_z`, `waittime`, `point_comment`) VALUES -(33370, 1, 331.674, -68.6878, 409.804, 0, '0'), -(33370, 2, 274.578, -92.1829, 409.804, 0, '0'), -(33370, 3, 226.433, -66.6652, 409.793, 0, '0'), -(33370, 4, 206.092, -34.7447, 409.801, 0, '0'), -(33370, 5, 240.208, 1.10346, 409.802, 0, '0'), -(33370, 6, 337.199, 11.7051, 409.802, 0, '0'); diff --git a/sql/updates/8770_world_scriptname.sql b/sql/updates/8770_world_scriptname.sql deleted file mode 100644 index e173f7e41f2..00000000000 --- a/sql/updates/8770_world_scriptname.sql +++ /dev/null @@ -1,12 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`= 'npc_thorims_hammer' WHERE `entry`=33365; -UPDATE `creature_template` SET `ScriptName`= 'npc_mimirons_inferno' WHERE `entry`=33370; -UPDATE `creature_template` SET `ScriptName`= 'npc_hodirs_fury' WHERE `entry`=33312; -UPDATE `creature_template` SET `ScriptName`= 'npc_freyas_ward' WHERE `entry`=33367; -UPDATE `creature_template` SET `ScriptName`= 'npc_lorekeeper' WHERE `entry`=33686; -UPDATE `creature_template` SET `ScriptName`= 'npc_brann_bronzebeard' WHERE `entry`=33579; -UPDATE `creature_template` SET `ScriptName`= 'npc_freya_ward_summon' WHERE `entry`=34275; -UPDATE `creature_template` SET `ScriptName`= 'npc_mechanolift' WHERE `entry`=33214; -UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194375; -UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194371; -UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194370; -UPDATE `gameobject_template` SET `ScriptName`= 'go_ulduar_tower' WHERE `entry`=194377; diff --git a/sql/updates/8790_world_locales_item_set_names.sql b/sql/updates/8790_world_locales_item_set_names.sql deleted file mode 100644 index 4f6015ac749..00000000000 --- a/sql/updates/8790_world_locales_item_set_names.sql +++ /dev/null @@ -1,2 +0,0 @@ -DROP TABLE IF EXISTS `locales_item_set_names`; -RENAME TABLE `locales_item_set_name` TO `locales_item_set_names`; diff --git a/sql/updates/8816_world_spell_bonus_data.sql b/sql/updates/8816_world_spell_bonus_data.sql deleted file mode 100644 index 67d01d19b77..00000000000 --- a/sql/updates/8816_world_spell_bonus_data.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `spell_bonus_data` WHERE `entry` IN (45284,45297); -INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES -(45284,0.357,-1,-1,-1,'Shaman - LO Lightning Bolt'), -(45297,0.285,-1,-1,-1,'Shaman - LO Chain Lightning'); diff --git a/sql/updates/8821_world_spell_dbc.sql b/sql/updates/8821_world_spell_dbc.sql deleted file mode 100644 index 903a932edaf..00000000000 --- a/sql/updates/8821_world_spell_dbc.sql +++ /dev/null @@ -1,8 +0,0 @@ --- Add serverside spells place holders for future development -DELETE FROM `spell_dbc` WHERE `Id` IN (11202,25359,40145,45767,71098); -INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES -(11202, 'Item 3776 spellid_1 serverside spell'), -(25359, 'Item 21293 spellid_2 serverside spell'), -(40145, 'Quest 11000 RewSpellCast serverside spell'), -(45767, 'Quest 11670 RewSpellCast serverside spell'), -(71098, 'Quest 24451 RewSpellCast serverside spell'); diff --git a/sql/updates/8836_world_spell_linked_spell.sql b/sql/updates/8836_world_spell_linked_spell.sql deleted file mode 100644 index 64c3c66c9e1..00000000000 --- a/sql/updates/8836_world_spell_linked_spell.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Make the Ardent Defender heal (66235) trigger the visuals (66233) -DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=66235; -INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES (66235,66233,0, 'Ardent Defender Visuals'); diff --git a/sql/updates/8842_world_script_texts.sql b/sql/updates/8842_world_script_texts.sql deleted file mode 100644 index 617b61a694f..00000000000 --- a/sql/updates/8842_world_script_texts.sql +++ /dev/null @@ -1,5 +0,0 @@ -DELETE FROM script_texts where entry IN (-1000474, -1000475, -1000476); -INSERT INTO script_texts (`npc_entry`, `entry`, `content_default`, `type`, `language`, `comment`) VALUE -(17375, -1000474, '[Fulborg] The Stillpine furbolgs will not soon forget your bravery!', 0, 0, 'Stillpine Capitive free say text 1'), -(17375, -1000475, '[Fulborg] Thank you, $N', 0, 0, 'Stillpine Capitive free say text 2'), -(17375, -1000476, '[Fulborg] Those remaining at Stillpine Hold will welcome you as a hero!', 0, 0, 'Stillpine Capitive free say text 3'); diff --git a/sql/updates/8842_world_scriptname.sql b/sql/updates/8842_world_scriptname.sql deleted file mode 100644 index 5ef8e4b6aa9..00000000000 --- a/sql/updates/8842_world_scriptname.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_stillpine_capitive' where `entry`=17375; -UPDATE `gameobject_template` SET `ScriptName`='go_stillpine_cage' WHERE `entry`=181714; diff --git a/sql/updates/8843_world_scriptname.sql b/sql/updates/8843_world_scriptname.sql deleted file mode 100644 index 4517544d99d..00000000000 --- a/sql/updates/8843_world_scriptname.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `gameobject_template` SET `ScriptName`='go_bristlelimb_cage' WHERE `entry`=181714; - diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index 0d2d6cd6bfa..fca7e740f90 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -4,6 +4,7 @@ add_subdirectory(3.1.3_old) add_subdirectory(3.2.2a_old) add_subdirectory(3.3.2_old) add_subdirectory(3.3.3a_old) +add_subdirectory(3.3.5a_old) FILE(GLOB _SQL_UPDATES *.sql) -- cgit v1.2.3 From 44e7a7b7e51404d49924cce9c9e8111b3795597f Mon Sep 17 00:00:00 2001 From: Brian Date: Thu, 8 Jul 2010 12:47:07 -0600 Subject: * Rename SQL file --HG-- branch : trunk rename : sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql => sql/updates/3.3.5a_old/8861_realmd_realmlist.sql --- sql/updates/3.3.5a_old/8861_realmd_realmlist.sql | 3 +++ sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql | 3 --- 2 files changed, 3 insertions(+), 3 deletions(-) create mode 100644 sql/updates/3.3.5a_old/8861_realmd_realmlist.sql delete mode 100644 sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql (limited to 'sql') diff --git a/sql/updates/3.3.5a_old/8861_realmd_realmlist.sql b/sql/updates/3.3.5a_old/8861_realmd_realmlist.sql new file mode 100644 index 00000000000..c6622d5ce1e --- /dev/null +++ b/sql/updates/3.3.5a_old/8861_realmd_realmlist.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=12340 WHERE `id`=1; +ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '12340'; + diff --git a/sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql b/sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql deleted file mode 100644 index c6622d5ce1e..00000000000 --- a/sql/updates/3.3.5a_old/xxxx_realmd_realmlist.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `realmlist` SET `gamebuild`=12340 WHERE `id`=1; -ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '12340'; - -- cgit v1.2.3 From 8353e4461115382ff909f27a6126a58a03a7962b Mon Sep 17 00:00:00 2001 From: Brian Date: Fri, 9 Jul 2010 02:33:42 -0600 Subject: * Proper naming for auth SQL file * Update base SQL file for new installs --HG-- branch : trunk rename : sql/updates/3.3.5a_old/8861_realmd_realmlist.sql => sql/updates/3.3.5a_old/8861_auth_realmlist.sql --- sql/base/auth_database.sql | 4 ++-- sql/updates/3.3.5a_old/8861_auth_realmlist.sql | 3 +++ sql/updates/3.3.5a_old/8861_realmd_realmlist.sql | 3 --- 3 files changed, 5 insertions(+), 5 deletions(-) create mode 100644 sql/updates/3.3.5a_old/8861_auth_realmlist.sql delete mode 100644 sql/updates/3.3.5a_old/8861_realmd_realmlist.sql (limited to 'sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 50940b45705..459b3fa1468 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -196,7 +196,7 @@ CREATE TABLE `realmlist` ( `timezone` tinyint(3) unsigned NOT NULL default '0', `allowedSecurityLevel` tinyint(3) unsigned NOT NULL default '0', `population` float unsigned NOT NULL default '0', - `gamebuild` int(11) unsigned NOT NULL default '11723', + `gamebuild` int(11) unsigned NOT NULL default '12340', PRIMARY KEY (`id`), UNIQUE KEY `idx_name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System'; @@ -209,7 +209,7 @@ CREATE TABLE `realmlist` ( LOCK TABLES `realmlist` WRITE; /*!40000 ALTER TABLE `realmlist` DISABLE KEYS */; INSERT INTO `realmlist` (`id`,`name`,`address`,`port`,`icon`,`color`,`timezone`,`allowedSecurityLevel`,`population`,`gamebuild`) VALUES -(1,'Trinity','127.0.0.1',8085,1,0,1,0,0,11723); +(1,'Trinity','127.0.0.1',8085,1,0,1,0,0,12340); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/3.3.5a_old/8861_auth_realmlist.sql b/sql/updates/3.3.5a_old/8861_auth_realmlist.sql new file mode 100644 index 00000000000..c6622d5ce1e --- /dev/null +++ b/sql/updates/3.3.5a_old/8861_auth_realmlist.sql @@ -0,0 +1,3 @@ +UPDATE `realmlist` SET `gamebuild`=12340 WHERE `id`=1; +ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '12340'; + diff --git a/sql/updates/3.3.5a_old/8861_realmd_realmlist.sql b/sql/updates/3.3.5a_old/8861_realmd_realmlist.sql deleted file mode 100644 index c6622d5ce1e..00000000000 --- a/sql/updates/3.3.5a_old/8861_realmd_realmlist.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `realmlist` SET `gamebuild`=12340 WHERE `id`=1; -ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '12340'; - -- cgit v1.2.3 From 1f5be45855b34743fdb66745524bef1e18270007 Mon Sep 17 00:00:00 2001 From: Brian Date: Fri, 9 Jul 2010 02:42:30 -0600 Subject: * Updated DB name in DB create file to reflect the new authserver --HG-- branch : trunk --- sql/create/create_mysql.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/create/create_mysql.sql b/sql/create/create_mysql.sql index dc272ebf697..e182e06168f 100644 --- a/sql/create/create_mysql.sql +++ b/sql/create/create_mysql.sql @@ -4,10 +4,10 @@ CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; -CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; +CREATE DATABASE `auth` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; GRANT ALL PRIVILEGES ON `world` . * TO 'trinity'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON `characters` . * TO 'trinity'@'localhost' WITH GRANT OPTION; -GRANT ALL PRIVILEGES ON `realmd` . * TO 'trinity'@'localhost' WITH GRANT OPTION; +GRANT ALL PRIVILEGES ON `auth` . * TO 'trinity'@'localhost' WITH GRANT OPTION; -- cgit v1.2.3 From 948e86ef174e83ded5055f0212a5d4bcd1f6f595 Mon Sep 17 00:00:00 2001 From: Brian Date: Fri, 9 Jul 2010 02:47:16 -0600 Subject: * Update drop file as well --HG-- branch : trunk --- sql/create/drop_mysql.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'sql') diff --git a/sql/create/drop_mysql.sql b/sql/create/drop_mysql.sql index c0ec81e378f..ee05439df99 100644 --- a/sql/create/drop_mysql.sql +++ b/sql/create/drop_mysql.sql @@ -8,9 +8,9 @@ REVOKE ALL PRIVILEGES ON `characters` . * FROM 'trinity'@'localhost'; REVOKE GRANT OPTION ON `characters` . * FROM 'trinity'@'localhost'; -REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'trinity'@'localhost'; +REVOKE ALL PRIVILEGES ON `auth` . * FROM 'trinity'@'localhost'; -REVOKE GRANT OPTION ON `realmd` . * FROM 'trinity'@'localhost'; +REVOKE GRANT OPTION ON `auth` . * FROM 'trinity'@'localhost'; DROP USER 'trinity'@'localhost'; @@ -18,4 +18,4 @@ DROP DATABASE IF EXISTS `world`; DROP DATABASE IF EXISTS `characters`; -DROP DATABASE IF EXISTS `realmd`; +DROP DATABASE IF EXISTS `auth`; -- cgit v1.2.3