diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/90_world.sql | 7 | ||||
| -rw-r--r-- | sql/world.sql | 21 |
2 files changed, 28 insertions, 0 deletions
diff --git a/sql/updates/90_world.sql b/sql/updates/90_world.sql new file mode 100644 index 00000000000..53278fc694b --- /dev/null +++ b/sql/updates/90_world.sql @@ -0,0 +1,7 @@ +DROP TABLE IF EXISTS `spell_disabled`;
+CREATE TABLE `spell_disabled` (
+ `entry` int(11) unsigned NOT NULL default '0' COMMENT 'Spell entry',
+ `disable_mask` int(8) unsigned NOT NULL default '0',
+ `comment` varchar(64) NOT NULL default '',
+ PRIMARY KEY (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Disabled Spell System';
diff --git a/sql/world.sql b/sql/world.sql index cbccf3b4b5c..2f9772636c4 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -2947,6 +2947,27 @@ LOCK TABLES `spell_chain` WRITE; UNLOCK TABLES; -- +-- Table structure for table `spell_disabled` +-- + +DROP TABLE IF EXISTS `spell_disabled`; +CREATE TABLE `spell_disabled` ( + `entry` int(11) unsigned NOT NULL default '0' COMMENT 'Spell entry', + `disable_mask` int(8) unsigned NOT NULL default '0', + `comment` varchar(64) NOT NULL default '', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Disabled Spell System'; + +-- +-- Dumping data for table `spell_disabled` +-- + +LOCK TABLES `spell_disabled` WRITE; +/*!40000 ALTER TABLE `spell_disabled` DISABLE KEYS */; +/*!40000 ALTER TABLE `spell_disabled` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `spell_elixir` -- |