diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/world_database.sql | 14 | ||||
| -rw-r--r-- | sql/updates/9012_world_spell_script_names.sql | 6 |
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; |