[svn] Implement a new table (spell_disabled) to allow disabling some spells for players and / or creatures. To disable a spell for a players and pets, set 2^0 in the disable_mask, to disable for creatures, set 2^1. The comment field is optional. Original patch provided by Craker.

--HG--
branch : trunk

1 files changed, 7 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';