...
The `item_effect` table
This table links together the appearances and item ids in regards to item hotfixes. Together with item, item_appearance and item_sparse they present the means to hotfix an itemcontains some of the item effect data regarding item hotfixes. This table is primarily used to hotfix spells on items.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ID | int(10) | unsigned | PRI | NO | 0 | ||
| ItemID | int(10) | unsigned | NO | 0 | |||
| OrderIndex | int(10) | unsigned | NO | 0 | |||
| SpellID | int(10) | unsigned | NO | 0 | |||
| Trigger | int(10) | unsigned | NO | 0 | |||
| Charges | int(10) | unsigned | NO | 0 | |||
| Cooldown | int(11) | signed | 0 | ||||
| Category | int(10) | unsigned | 0 | ||||
| CategoryCooldown | int(11) | signed | 0 | ||||
| VerifiedBuild | smallint(6) | signed | NO | 0 |
...