*Add delete query for data in 4212_world.sql.(if you had problems with 4212 use 4222).

--HG--
branch : trunk

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);