From 5a345eeade9073fd5c3fd8c1848ab3ebf86ab48a Mon Sep 17 00:00:00 2001
From: Shauren <none@none>
Date: Fri, 6 Aug 2010 20:09:23 +0200
Subject: Implemented Dalaran no-fly zone

--HG--
branch : trunk
---
 sql/base/world_database.sql                   | 2 ++
 sql/updates/9205_world_spell_script_names.sql | 3 +++
 2 files changed, 5 insertions(+)
 create mode 100644 sql/updates/9205_world_spell_script_names.sql

(limited to 'sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 656f1ead05c..379477cb949 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -14712,6 +14712,8 @@ CREATE TABLE `spell_script_names` (
 LOCK TABLES `spell_script_names` WRITE;
 /*!40000 ALTER TABLE `spell_script_names` DISABLE KEYS */;
 INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+-- generic
+( 58601, 'spell_gen_remove_flight_auras'),
 -- warrior
 ( 12975,'spell_warr_last_stand'),
 ( 21977,'spell_warr_warriors_wrath'),
diff --git a/sql/updates/9205_world_spell_script_names.sql b/sql/updates/9205_world_spell_script_names.sql
new file mode 100644
index 00000000000..15ec8063c06
--- /dev/null
+++ b/sql/updates/9205_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=58601 AND `ScriptName`='spell_gen_remove_flight_auras';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES 
+(58601, 'spell_gen_remove_flight_auras');
-- 
cgit v1.2.3