diff options
| author | QAston <qaston@gmail.com> | 2011-06-26 13:54:44 +0200 |
|---|---|---|
| committer | QAston <qaston@gmail.com> | 2011-06-26 13:54:44 +0200 |
| commit | ac88fa026f7996444a865dd15ea8955e22b90d99 (patch) | |
| tree | 664b42516aee60013363b7404b457efad8a9a25d /sql/updates | |
| parent | 6dcee0c0ea23617849a6b04ae22d2b74fb04f097 (diff) | |
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.
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2011_06_26_01_world_spell_proc.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/2011_06_26_02_world_command.sql | 1 |
2 files changed, 2 insertions, 0 deletions
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 |