Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB restructuring - world - spell_enchant_proc_data #1199

Closed
FrancescoBorzi opened this issue Dec 30, 2018 · 0 comments
Closed

DB restructuring - world - spell_enchant_proc_data #1199

FrancescoBorzi opened this issue Dec 30, 2018 · 0 comments

Comments

@FrancescoBorzi
Copy link
Member

FrancescoBorzi commented Dec 30, 2018

This is part of: #1118

General note: not all structure differences can or should be imported. Every change must be first verified. If a structure change is not suitable, we just close the issue.


TrinityCore/TrinityCore@f609e7a

--- Dumping structure for table acore_world.spell_enchant_proc_data
+-- Dumping structure for table tc_world.spell_enchant_proc_data
 DROP TABLE IF EXISTS `spell_enchant_proc_data`;
 CREATE TABLE IF NOT EXISTS `spell_enchant_proc_data` (
-  `entry` int(10) unsigned NOT NULL,
-  `customChance` int(10) unsigned NOT NULL DEFAULT '0',
-  `PPMChance` float unsigned NOT NULL DEFAULT '0',
-  `procEx` int(10) unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`entry`)
+  `EnchantID` int(10) unsigned NOT NULL,
+  `Chance` float NOT NULL DEFAULT '0',
+  `ProcsPerMinute` float NOT NULL DEFAULT '0',
+  `HitMask` int(10) unsigned NOT NULL DEFAULT '0',
+  `AttributesMask` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`EnchantID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants