diff options
| -rw-r--r-- | sql/updates/world/2011_06_26_04_world_spell_proc.sql | 20 | ||||
| -rw-r--r-- | sql/updates/world/2011_06_26_05_world_command.sql | 4 |
2 files changed, 22 insertions, 2 deletions
diff --git a/sql/updates/world/2011_06_26_04_world_spell_proc.sql b/sql/updates/world/2011_06_26_04_world_spell_proc.sql index 5a5ea9973e5..063a3edd3bf 100644 --- a/sql/updates/world/2011_06_26_04_world_spell_proc.sql +++ b/sql/updates/world/2011_06_26_04_world_spell_proc.sql @@ -1 +1,19 @@ -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 +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;
diff --git a/sql/updates/world/2011_06_26_05_world_command.sql b/sql/updates/world/2011_06_26_05_world_command.sql index 81259662612..b18bbe61954 100644 --- a/sql/updates/world/2011_06_26_05_world_command.sql +++ b/sql/updates/world/2011_06_26_05_world_command.sql @@ -1 +1,3 @@ -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 +DELETE FROM `command` WHERE `name` = 'reload spell_proc';
+INSERT INTO `command` VALUES
+('reload spell_proc',3,'Syntax: .reload spell_proc\nReload spell_proc table.');
|