diff options
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 |