character_spell_cooldown Table¶
Spell cooldowns persisting across logout.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
guid |
int(11) unsigned | PRI | NO | 0 | |
spell |
int(11) unsigned | PRI | NO | 0 | |
spell_expire_time |
bigint(20) unsigned | NO | 0 | ||
category |
int(11) unsigned | NO | 0 | ||
category_expire_time |
bigint(20) unsigned | NO | 0 | ||
item_id |
int(11) unsigned | NO | 0 |
Field Breakdown¶
guid- Primary Key. Character guid (fromcharacters.guid).spell- Primary Key. Spell on cooldown.spell_expire_time- Unix timestamp when the spell cooldown ends.category- Cooldown category id (shared-category cooldowns).category_expire_time- Category cooldown expiry timestamp.item_id- Item causing the cooldown (item cooldowns), else 0.