aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/world_database.sql5
-rw-r--r--sql/updates/5944_world_spell_script_names.sql3
2 files changed, 7 insertions, 1 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index e4e829ad839..939a7269a43 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -14803,7 +14803,10 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
( 47193, 'spell_warl_demonic_empowerment'),
( 47422, 'spell_warl_everlasting_affliction'),
-- druid
-( 54846, 'spell_dru_glyph_of_starfire');
+( 54846, 'spell_dru_glyph_of_starfire'),
+-- example
+( 66244, 'spell_ex_66244'),
+( 5581, 'spell_ex_5581');
/*!40000 ALTER TABLE `spell_script_names` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/updates/5944_world_spell_script_names.sql b/sql/updates/5944_world_spell_script_names.sql
new file mode 100644
index 00000000000..341b1f43bdd
--- /dev/null
+++ b/sql/updates/5944_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` = 66244 AND `ScriptName` = "spell_ex_66244";
+DELETE FROM `spell_script_names` WHERE `spell_id` = 5581 AND `ScriptName` = "spell_ex_5581";
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (66244, "spell_ex_66244"), (5581, "spell_ex_5581");