aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorQAston <none@none>2009-02-11 22:59:02 +0100
committerQAston <none@none>2009-02-11 22:59:02 +0100
commitc4fa6a5d54adbb76b5c7fd4a27d2a453149a30c9 (patch)
treebe9b1722c49a843178840e8db0074977e193ca97 /sql
parent376788d761a2f06c7ceb6437fab801cee0c9abab (diff)
*Allow creatures to have up to 8 spells in creature_template.
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/1327_world.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/1327_world.sql b/sql/updates/1327_world.sql
new file mode 100644
index 00000000000..61ae8ded684
--- /dev/null
+++ b/sql/updates/1327_world.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `creature_template` ADD COLUMN `spell5` mediumint(8) unsigned NOT NULL default '0' AFTER `spell4`;
+ALTER TABLE `creature_template` ADD COLUMN `spell6` mediumint(8) unsigned NOT NULL default '0' AFTER `spell5`;
+ALTER TABLE `creature_template` ADD COLUMN `spell7` mediumint(8) unsigned NOT NULL default '0' AFTER `spell6`;
+ALTER TABLE `creature_template` ADD COLUMN `spell8` mediumint(8) unsigned NOT NULL default '0' AFTER `spell7`;