diff options
Diffstat (limited to 'sql/updates')
9 files changed, 46 insertions, 0 deletions
diff --git a/sql/updates/characters/2012_11_07_00_characters_guild_newslog_434.sql b/sql/updates/characters/2012_11_07_00_characters_guild_newslog_434.sql new file mode 100644 index 00000000000..1504bd3b6e5 --- /dev/null +++ b/sql/updates/characters/2012_11_07_00_characters_guild_newslog_434.sql @@ -0,0 +1,21 @@ +-- Rename table and column to fit the other guild_*log tables and columns and create indexes +RENAME TABLE `guild_news_log` TO `guild_newslog`; + +ALTER TABLE `guild_newslog` +CHANGE COLUMN `guild` `guildid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator', +CHANGE COLUMN `id` `LogGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column', +CHANGE COLUMN `eventType` `EventType` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Event type', +CHANGE COLUMN `playerGuid` `PlayerGuid` int(10) unsigned NOT NULL DEFAULT '0', +CHANGE COLUMN `data` `Value` int(10) unsigned NOT NULL DEFAULT '0', +CHANGE COLUMN `flags` `Flags` int(10) unsigned NOT NULL DEFAULT '0' AFTER `PlayerGuid`, +CHANGE COLUMN `date` `TimeStamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', +ADD KEY `guildid_key` (`guildid`), +ADD KEY `Idx_PlayerGuid` (`PlayerGuid`), +ADD KEY `Idx_LogGuid` (`LogGuid`); + +-- Create missing tabs + +ALTER TABLE `guild_member_withdraw` +ADD COLUMN `tab6` int(10) unsigned NOT NULL DEFAULT '0' AFTER `tab5`, +ADD COLUMN `tab7` int(10) unsigned NOT NULL DEFAULT '0' AFTER `tab6`; + diff --git a/sql/updates/characters/2012_11_21_00_characters_worldstates_434.sql b/sql/updates/characters/2012_11_21_00_characters_worldstates_434.sql new file mode 100644 index 00000000000..14e9ffb6834 --- /dev/null +++ b/sql/updates/characters/2012_11_21_00_characters_worldstates_434.sql @@ -0,0 +1 @@ +UPDATE `worldstates` SET `comment` = 'NextCurrencyDistributionTime' WHERE `entry` =20001; diff --git a/sql/updates/characters/2013_01_30_00_characters_characters.sql b/sql/updates/characters/2013_01_30_00_characters_characters.sql new file mode 100644 index 00000000000..1ddb4c8900d --- /dev/null +++ b/sql/updates/characters/2013_01_30_00_characters_characters.sql @@ -0,0 +1,2 @@ +-- Add missing fields for new titles field +UPDATE `characters` SET knownTitles = CONCAT(knownTitles, '0 0 ') WHERE (LENGTH(knownTitles) - LENGTH(REPLACE(knownTitles, ' ', ''))) = 6; diff --git a/sql/updates/world/2013_01_22_01_world_spell_script_names_434.sql b/sql/updates/world/2013_01_22_01_world_spell_script_names_434.sql new file mode 100644 index 00000000000..cc74d504e94 --- /dev/null +++ b/sql/updates/world/2013_01_22_01_world_spell_script_names_434.sql @@ -0,0 +1,4 @@ +-- 85256 - Templar's Verdict +DELETE FROM `spell_script_names` WHERE `spell_id`=85256; +INSERT INTO `spell_script_names` VALUES +(85256,'spell_pal_templar_s_verdict'); diff --git a/sql/updates/world/2013_01_24_00_world_instance_template.sql b/sql/updates/world/2013_01_24_00_world_instance_template.sql new file mode 100644 index 00000000000..23a0ffb04b8 --- /dev/null +++ b/sql/updates/world/2013_01_24_00_world_instance_template.sql @@ -0,0 +1 @@ +UPDATE `instance_template` SET `script`='instance_baradin_hold' WHERE `map`=757; diff --git a/sql/updates/world/2013_01_25_00_world_spell_linked_spell_434.sql b/sql/updates/world/2013_01_25_00_world_spell_linked_spell_434.sql new file mode 100644 index 00000000000..5eb29aa4de1 --- /dev/null +++ b/sql/updates/world/2013_01_25_00_world_spell_linked_spell_434.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (77769, -77769); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(77769, 82946, 2, 'Trap Launcher - Add/Remove'); diff --git a/sql/updates/world/2013_01_26_00_world_spell_script_names_434.sql b/sql/updates/world/2013_01_26_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..d0c4a61c422 --- /dev/null +++ b/sql/updates/world/2013_01_26_00_world_spell_script_names_434.sql @@ -0,0 +1,7 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_running_wild'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_two_forms'; +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_darkflight'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(87840,'spell_gen_running_wild'), +(68996,'spell_gen_two_forms'), +(68992,'spell_gen_darkflight'); diff --git a/sql/updates/world/2013_01_29_00_world_creature_template_434.sql b/sql/updates/world/2013_01_29_00_world_creature_template_434.sql new file mode 100644 index 00000000000..52954b2b9f5 --- /dev/null +++ b/sql/updates/world/2013_01_29_00_world_creature_template_434.sql @@ -0,0 +1 @@ +ALTER TABLE `creature_template` DROP `trainer_spell`; diff --git a/sql/updates/world/2013_01_31_00_world_spell_script_names_434.sql b/sql/updates/world/2013_01_31_00_world_spell_script_names_434.sql new file mode 100644 index 00000000000..a615525b626 --- /dev/null +++ b/sql/updates/world/2013_01_31_00_world_spell_script_names_434.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_warl_demon_soul', 'spell_warl_conflagrate', 'spell_warl_fel_flame'); +DELETE FROM `spell_script_names` WHERE `spell_id` IN (17962, 77799, 77801); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(17962, 'spell_warl_conflagrate'), +(77799, 'spell_warl_fel_flame'), +(77801, 'spell_warl_demon_soul'); |