aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorariel- <ariel-@users.noreply.github.com>2017-02-22 00:11:49 -0300
committerShauren <shauren.trinity@gmail.com>2019-08-17 20:04:14 +0200
commit420f2e8ec2c5f19db313492c52a730c87fa2dab6 (patch)
tree470354aabdaefdf3c4ffb2a6a4eb91b78f68ea6f /sql
parent5f70be050f971ee70da8953c4f094cb2adc233f8 (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.sql6
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`;