From 420f2e8ec2c5f19db313492c52a730c87fa2dab6 Mon Sep 17 00:00:00 2001 From: ariel- Date: Wed, 22 Feb 2017 00:11:49 -0300 Subject: Core/Spells: refactor spell_enchant_proc_data table - Renamed fields to mimic those in spell_proc - Added Enchant proc attributes for controlling specific enchant features Ref #7789 (cherrypicked from f609e7a08b3b4d2d9642e5ec252e1eedad836f0f) --- .../world/master/2019_07_28_02_world_2017_02_21_02_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/master/2019_07_28_02_world_2017_02_21_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2019_07_28_02_world_2017_02_21_02_world.sql b/sql/updates/world/master/2019_07_28_02_world_2017_02_21_02_world.sql new file mode 100644 index 00000000000..fa0f11d7f80 --- /dev/null +++ b/sql/updates/world/master/2019_07_28_02_world_2017_02_21_02_world.sql @@ -0,0 +1,6 @@ +ALTER TABLE `spell_enchant_proc_data` + CHANGE `entry` `EnchantID` int(10) UNSIGNED NOT NULL, + CHANGE `customChance` `Chance` float DEFAULT '0' NOT NULL, + CHANGE `PPMChance` `ProcsPerMinute` float DEFAULT '0' NOT NULL, + CHANGE `procEx` `HitMask` int(10) UNSIGNED DEFAULT '0' NOT NULL, + ADD COLUMN `AttributesMask` int(10) UNSIGNED DEFAULT '0' NOT NULL AFTER `HitMask`; -- cgit v1.2.3