aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorariel- <ariel-@users.noreply.github.com>2017-02-22 00:11:49 -0300
committerariel- <ariel-@users.noreply.github.com>2017-02-22 00:11:49 -0300
commitf609e7a08b3b4d2d9642e5ec252e1eedad836f0f (patch)
tree07318bca27c3200eb1540985ad3fd8bceb733c56 /sql/updates
parenteac9c1f0b992fd3622fd7dd864b2acc2781ec778 (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
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/3.3.5/2017_02_21_02_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_02_21_02_world.sql b/sql/updates/world/3.3.5/2017_02_21_02_world.sql
new file mode 100644
index 00000000000..fa0f11d7f80
--- /dev/null
+++ b/sql/updates/world/3.3.5/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`;