Add new Edit Delete History Source

Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.

item_enchantment_template

<-Back-to:World

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.

Table Structure

Field	Type	Attributes	Key	Null
entry	MEDIUMINT	UNSIGNED	PRI	NO
ench	MEDIUMINT	UNSIGNED	PRI	NO
chance	FLOAT	UNSIGNED		NO

Description of the fields

entry

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.

ench

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.

chance

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.