diff options
author | ariel- <ariel-@users.noreply.github.com> | 2017-02-22 00:11:49 -0300 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2019-08-17 20:04:14 +0200 |
commit | 420f2e8ec2c5f19db313492c52a730c87fa2dab6 (patch) | |
tree | 470354aabdaefdf3c4ffb2a6a4eb91b78f68ea6f /sql | |
parent | 5f70be050f971ee70da8953c4f094cb2adc233f8 (diff) |
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)
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/master/2019_07_28_02_world_2017_02_21_02_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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`; |