diff options
Diffstat (limited to 'sql/updates')
7 files changed, 25 insertions, 0 deletions
diff --git a/sql/updates/7884_01_mangos_playercreateinfo_spell.sql b/sql/updates/7884_01_mangos_playercreateinfo_spell.sql new file mode 100644 index 00000000000..f16e7e40ebc --- /dev/null +++ b/sql/updates/7884_01_mangos_playercreateinfo_spell.sql @@ -0,0 +1,3 @@ +ALTER TABLE db_version CHANGE COLUMN required_7879_01_mangos_spell_proc_event required_7884_01_mangos_playercreateinfo_spell bit; + +DELETE FROM playercreateinfo_spell WHERE Spell = '28734';
\ No newline at end of file diff --git a/sql/updates/7884_02_mangos_playercreateinfo_action.sql b/sql/updates/7884_02_mangos_playercreateinfo_action.sql new file mode 100644 index 00000000000..c95375213c1 --- /dev/null +++ b/sql/updates/7884_02_mangos_playercreateinfo_action.sql @@ -0,0 +1,5 @@ +ALTER TABLE db_version CHANGE COLUMN required_7884_01_mangos_playercreateinfo_spell required_7884_02_mangos_playercreateinfo_action bit; + +DELETE FROM playercreateinfo_action WHERE action = '28734'; +UPDATE playercreateinfo_action SET button = '3' WHERE race = '10' AND class IN ('8', '9', '5', '2', '3') AND button = '4'; +UPDATE playercreateinfo_action SET button = '4' WHERE race = '10' AND class = '4' AND button = '5'; diff --git a/sql/updates/7884_03_characters_character_spell.sql b/sql/updates/7884_03_characters_character_spell.sql new file mode 100644 index 00000000000..f428689f01d --- /dev/null +++ b/sql/updates/7884_03_characters_character_spell.sql @@ -0,0 +1,3 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_7802_02_characters_character_achievement_progress required_7884_03_characters_character_spell bit; + +DELETE FROM character_spell WHERE spell = '28734'; diff --git a/sql/updates/7884_04_characters_character_aura.sql b/sql/updates/7884_04_characters_character_aura.sql new file mode 100644 index 00000000000..cfe19211d3f --- /dev/null +++ b/sql/updates/7884_04_characters_character_aura.sql @@ -0,0 +1,3 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_7884_03_characters_character_spell required_7884_04_characters_character_aura bit; + +DELETE FROM character_aura WHERE spell = '28734'; diff --git a/sql/updates/7884_05_characters_character_action.sql b/sql/updates/7884_05_characters_character_action.sql new file mode 100644 index 00000000000..8aa77cc6f3c --- /dev/null +++ b/sql/updates/7884_05_characters_character_action.sql @@ -0,0 +1,3 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_7884_04_characters_character_aura required_7884_05_characters_character_action bit; + +DELETE FROM character_action WHERE action = '28734' AND type = '0';
\ No newline at end of file diff --git a/sql/updates/7886_01_mangos_petcreateinfo_spell.sql b/sql/updates/7886_01_mangos_petcreateinfo_spell.sql new file mode 100644 index 00000000000..673d1b317f9 --- /dev/null +++ b/sql/updates/7886_01_mangos_petcreateinfo_spell.sql @@ -0,0 +1,4 @@ +ALTER TABLE db_version CHANGE COLUMN required_7884_02_mangos_playercreateinfo_action required_7886_01_mangos_petcreateinfo_spell bit; + +DROP TABLE IF EXISTS `petcreateinfo_spell`; + diff --git a/sql/updates/7887_01_characters_character_pet.sql b/sql/updates/7887_01_characters_character_pet.sql new file mode 100644 index 00000000000..2d61410ec11 --- /dev/null +++ b/sql/updates/7887_01_characters_character_pet.sql @@ -0,0 +1,4 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_7884_05_characters_character_action required_7887_01_characters_character_pet bit; + +ALTER TABLE `character_pet` + DROP TeachSpelldata; |