diff options
| -rw-r--r-- | sql/updates/4212_world.sql | 14 | ||||
| -rw-r--r-- | sql/updates/4222_world.sql | 13 |
2 files changed, 13 insertions, 14 deletions
diff --git a/sql/updates/4212_world.sql b/sql/updates/4212_world.sql index 2912d485aa2..ce4b8d56e86 100644 --- a/sql/updates/4212_world.sql +++ b/sql/updates/4212_world.sql @@ -1,17 +1,3 @@ ALTER TABLE spell_pet_auras ADD effectId TINYINT( 3 ) UNSIGNED NOT NULL AFTER spell; - ALTER TABLE spell_pet_auras DROP PRIMARY KEY, ADD PRIMARY KEY(spell,effectId,pet); - -INSERT INTO spell_pet_auras VALUES -(56314, 0, 0, 57447), -(56314, 1, 0, 57485), -(56315, 0, 0, 57452), -(56315, 1, 0, 57484), -(56316, 0, 0, 57453), -(56316, 1, 0, 57483), -(56317, 0, 0, 57457), -(56317, 1, 0, 57482), -(56318, 0, 0, 57458), -(56318, 1, 0, 57475); -DELETE FROM spell_linked_spell where `spell_trigger` in (57447,57482,57453, 57457, 57458); diff --git a/sql/updates/4222_world.sql b/sql/updates/4222_world.sql new file mode 100644 index 00000000000..88cba6a134b --- /dev/null +++ b/sql/updates/4222_world.sql @@ -0,0 +1,13 @@ +DELETE FROM spell_pet_auras where `spell` in (56314,56315,56316, 56317, 56318); +INSERT INTO spell_pet_auras VALUES +(56314, 0, 0, 57447), +(56314, 1, 0, 57485), +(56315, 0, 0, 57452), +(56315, 1, 0, 57484), +(56316, 0, 0, 57453), +(56316, 1, 0, 57483), +(56317, 0, 0, 57457), +(56317, 1, 0, 57482), +(56318, 0, 0, 57458), +(56318, 1, 0, 57475); +DELETE FROM spell_linked_spell where `spell_trigger` in (57447,57482,57453, 57457, 57458); |