The `item_enchantment_template` table
This table holds enchantment chance information for items that should have either a random property or a random suffix attached to them.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| entry | MEDIUMINT | UNSIGNED | PRI | NO | 0 | ||
| ench | MEDIUMINT | UNSIGNED | PRI | NO | 0 | ||
| chance | FLOAT | UNSIGNED | NO | 0 |
Description of the fields
This field ties in with EITHER RandomProperty OR RandomSuffix fields in the item_template table. An item cannot have both of those fields set at non-zero values.
The enchantment to apply on the item. If the entry for the current row is used in RandomProperty, then this field points to the ID in ItemRandomProperties.dbc. If the entry is used in RandomSuffix, then this field points to the ID in ItemRandomSuffix.dbc.
The chance for a random property or suffix to be applied to the item. For each entry in this table, the combined chances of all properties/suffixes need to equal 100 otherwise the item may not get a random enchantment on it.
Value must be >=0. If the value does not meet the condition the SQL will fail on item_enchantment_template_chk_1.