Skip to content

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 (from characters.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.