diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/world_database.sql | 28 | ||||
| -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 |
3 files changed, 30 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 35f79bc11cf..88dc144b418 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -674,6 +674,7 @@ INSERT INTO `command` VALUES ('reload spell_linked_spell',3,'Usage: .reload spell_linked_spell\r\nReloads the spell_linked_spell DB table.'), ('reload spell_loot_template',3,'Syntax: .reload spell_loot_template\nReload spell_loot_template table.'), ('reload spell_pet_auras',3,'Syntax: .reload spell_pet_auras\nReload spell_pet_auras table.'), +('reload spell_proc',3,'Syntax: .reload spell_proc\nReload spell_proc table.'), ('reload spell_proc_event',3,'Syntax: .reload spell_proc_event\nReload spell_proc_event table.'), ('reload spell_required',3,'Syntax: .reload spell_required\nReload spell_required table.'), ('reload spell_scripts',3,'Syntax: .reload spell_scripts\nReload spell_scripts table.'), @@ -18333,6 +18334,33 @@ INSERT INTO `spell_pet_auras` VALUES (19028,0,0,25228), UNLOCK TABLES; -- +-- Table structure for table `spell_proc` +-- + +DROP TABLE IF EXISTS `spell_proc`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `spell_proc_event` -- 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 |