aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2011_06_09_03_world_spell_script_names.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2011_06_09_03_world_spell_script_names.sql b/sql/updates/world/2011_06_09_03_world_spell_script_names.sql
new file mode 100644
index 00000000000..1ce1d7a9fb2
--- /dev/null
+++ b/sql/updates/world/2011_06_09_03_world_spell_script_names.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_scripts` WHERE `id` IN(37751,37752); -- Remove redundant data from spell_scripts
+DELETE FROM `spell_script_names` WHERE `spell_id` IN(37751,37752);
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(37751,'spell_xt002_submerged'),
+(37752,'spell_xt002_stand');