From 110ae3e6261694cd5a9ad1687ee209ef42a55c3e Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 2 May 2016 18:52:15 +0200 Subject: Core/Spells: Implemented RPPM proc effects Closes #17001 --- .../hotfixes/6.x/2016_05_02_00_hotfixes.sql | 26 ++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 sql/updates/hotfixes/6.x/2016_05_02_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/6.x/2016_05_02_00_hotfixes.sql b/sql/updates/hotfixes/6.x/2016_05_02_00_hotfixes.sql new file mode 100644 index 00000000000..8a20e13d4c5 --- /dev/null +++ b/sql/updates/hotfixes/6.x/2016_05_02_00_hotfixes.sql @@ -0,0 +1,26 @@ +-- +-- Table structure for table `spell_procs_per_minute` +-- + +DROP TABLE IF EXISTS `spell_procs_per_minute`; +CREATE TABLE `spell_procs_per_minute` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `BaseProcRate` float NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `spell_procs_per_minute_mod` +-- +DROP TABLE IF EXISTS `spell_procs_per_minute_mod`; +CREATE TABLE `spell_procs_per_minute_mod` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Type` int(10) unsigned NOT NULL DEFAULT '0', + `Param` int(10) unsigned NOT NULL DEFAULT '0', + `Coeff` float NOT NULL DEFAULT '0', + `SpellProcsPerMinuteID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3