From ac88fa026f7996444a865dd15ea8955e22b90d99 Mon Sep 17 00:00:00 2001 From: QAston Date: Sun, 26 Jun 2011 13:54:44 +0200 Subject: Database/Spells: Add spell_proc table which is a replacement for spell_proc_event table. This is the initial patch from series of patches changing the way we currently handle procs in the core, and doesn't interfere with existing code in any way. --- sql/updates/world/2011_06_26_01_world_spell_proc.sql | 1 + sql/updates/world/2011_06_26_02_world_command.sql | 1 + 2 files changed, 2 insertions(+) create mode 100644 sql/updates/world/2011_06_26_01_world_spell_proc.sql create mode 100644 sql/updates/world/2011_06_26_02_world_command.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_06_26_01_world_spell_proc.sql b/sql/updates/world/2011_06_26_01_world_spell_proc.sql new file mode 100644 index 00000000000..5a5ea9973e5 --- /dev/null +++ b/sql/updates/world/2011_06_26_01_world_spell_proc.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS `spell_proc`; CREATE TABLE `spell_proc` ( `spellId` mediumint(8) NOT NULL DEFAULT '0', `schoolMask` tinyint(4) NOT NULL DEFAULT '0', `spellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0', `spellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0', `spellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0', `spellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0', `typeMask` int(10) unsigned NOT NULL DEFAULT '0', `spellTypeMask` int(10) unsigned NOT NULL DEFAULT '0', `spellPhaseMask` int(10) NOT NULL DEFAULT '0', `hitMask` int(10) NOT NULL DEFAULT '0', `attributesMask` int(10) unsigned NOT NULL DEFAULT '0', `ratePerMinute` float NOT NULL DEFAULT '0', `chance` float NOT NULL DEFAULT '0', `cooldown` float unsigned NOT NULL DEFAULT '0', `charges` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`spellId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; \ No newline at end of file diff --git a/sql/updates/world/2011_06_26_02_world_command.sql b/sql/updates/world/2011_06_26_02_world_command.sql new file mode 100644 index 00000000000..81259662612 --- /dev/null +++ b/sql/updates/world/2011_06_26_02_world_command.sql @@ -0,0 +1 @@ +DELETE FROM `command` WHERE `name` = 'reload spell_proc'; INSERT INTO `command` VALUES ('reload spell_proc',3,'Syntax: .reload spell_proc\nReload spell_proc table.'); \ No newline at end of file -- cgit v1.2.3