From 182c390ae794618a5f44005a6a3c815e54c49fa9 Mon Sep 17 00:00:00 2001 From: Shauren Date: Wed, 11 May 2016 20:38:24 +0200 Subject: Core/Auras: Renamed fields of SpellProcEntry structure and change types to more appropriate ones (cherry picked from commit ef7df652560f559f5db0d8842475a9c6259145b0) Build fix (cherry picked from commit c03e7ecd05275fc6ab0938f728e1905d1c83e895) SQL fix (cherry picked from commit 7a41467cf71e790fb6cffad21db82c7119d8c2e7) --- .../master/2017_01_08_03_world_2016_05_11_01_world.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/master/2017_01_08_03_world_2016_05_11_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2017_01_08_03_world_2016_05_11_01_world.sql b/sql/updates/world/master/2017_01_08_03_world_2016_05_11_01_world.sql new file mode 100644 index 00000000000..7741f6e8e4f --- /dev/null +++ b/sql/updates/world/master/2017_01_08_03_world_2016_05_11_01_world.sql @@ -0,0 +1,17 @@ +ALTER TABLE `spell_proc` + CHANGE `spellId` `SpellId` int(11) NOT NULL DEFAULT 0 FIRST, + CHANGE `schoolMask` `SchoolMask` tinyint(3) unsigned NOT NULL DEFAULT 0 AFTER `SpellId`, + CHANGE `spellFamilyName` `SpellFamilyName` smallint(5) unsigned NOT NULL DEFAULT 0 AFTER `SchoolMask`, + CHANGE `spellFamilyMask0` `SpellFamilyMask0` int(10) unsigned NOT NULL DEFAULT 0 AFTER `SpellFamilyName`, + CHANGE `spellFamilyMask1` `SpellFamilyMask1` int(10) unsigned NOT NULL DEFAULT 0 AFTER `SpellFamilyMask0`, + CHANGE `spellFamilyMask2` `SpellFamilyMask2` int(10) unsigned NOT NULL DEFAULT 0 AFTER `SpellFamilyMask1`, + CHANGE `spellFamilyMask3` `SpellFamilyMask3` int(10) unsigned NOT NULL DEFAULT 0 AFTER `SpellFamilyMask2`, + CHANGE `typeMask` `ProcFlags` int(10) unsigned NOT NULL DEFAULT 0 AFTER `SpellFamilyMask3`, + CHANGE `spellTypeMask` `SpellTypeMask` int(10) unsigned NOT NULL DEFAULT 0 AFTER `ProcFlags`, + CHANGE `spellPhaseMask` `SpellPhaseMask` int(10) unsigned NOT NULL DEFAULT 0 AFTER `SpellTypeMask`, + CHANGE `hitMask` `HitMask` int(10) unsigned NOT NULL DEFAULT 0 AFTER `SpellPhaseMask`, + CHANGE `attributesMask` `AttributesMask` int(10) unsigned NOT NULL DEFAULT 0 AFTER `HitMask`, + CHANGE `ratePerMinute` `ProcsPerMinute` float NOT NULL DEFAULT 0 AFTER `AttributesMask`, + CHANGE `chance` `Chance` float NOT NULL DEFAULT 0 AFTER `ProcsPerMinute`, + CHANGE `cooldown` `Cooldown` int(10) unsigned NOT NULL DEFAULT 0 AFTER `Chance`, + CHANGE `charges` `Charges` tinyint(3) unsigned NOT NULL DEFAULT 0 AFTER `Cooldown`; -- cgit v1.2.3