From 5e1c19e4d9b6e2deb247e6ce6b25ea132b8118d4 Mon Sep 17 00:00:00 2001
From: w12x <none@none>
Date: Tue, 21 Oct 2008 03:58:38 -0500
Subject: [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
---
 sql/updates/90_world.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 sql/updates/90_world.sql

(limited to 'sql/updates/90_world.sql')

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';
-- 
cgit v1.2.3

