aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorQAston <none@none>2010-07-24 22:41:42 +0200
committerQAston <none@none>2010-07-24 22:41:42 +0200
commit2352fc7cdfff0e677f6516c0ab2b91d3efc9ab70 (patch)
tree470b0d66f513cb62b6be88863003408864d117ae /sql
parent687cd83bddfbc5416ba11bff53c8a636747a5802 (diff)
*Add base scripting interfce for spells - thanks to Brian for help in making it compile with GCC.
*Add hook for handling spell effects in new scripting system. --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/base/world_database.sql14
-rw-r--r--sql/updates/9012_world_spell_script_names.sql6
2 files changed, 20 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 8b5f03706a8..03ce3ba57f2 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -14570,6 +14570,20 @@ INSERT INTO `spelldifficulty_dbc` VALUES
UNLOCK TABLES;
--
+-- Table structure for table `spell_script_names`
+--
+
+DROP TABLE IF EXISTS `spell_script_names`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `spell_script_names` (
+ `spell_id` mediumint(8) NOT NULL,
+ `ScriptName` char(64) NOT NULL,
+ UNIQUE (`spell_id`, `ScriptName`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `transports`
--
diff --git a/sql/updates/9012_world_spell_script_names.sql b/sql/updates/9012_world_spell_script_names.sql
new file mode 100644
index 00000000000..410357f82f9
--- /dev/null
+++ b/sql/updates/9012_world_spell_script_names.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS `spell_script_names`;
+CREATE TABLE `spell_script_names` (
+ `spell_id` int(11) NOT NULL,
+ `ScriptName` char(64) NOT NULL,
+ UNIQUE (`spell_id`, `ScriptName`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;