Skip to content

character_spell Table

Spells learned by the character.

Schema Summary

Field Type Key Null Default Extra
guid int(11) unsigned PRI NO 0
spell int(11) unsigned PRI NO 0
active tinyint(3) unsigned NO 1
disabled tinyint(3) unsigned NO 0

Field Breakdown

  • guid - Primary Key. Character guid (from characters.guid).
  • spell - Primary Key. Learned spell id.
  • active - 1 = spell shown as known in the spell book / usable on action bars; within a rank chain only the highest learned rank stays active (lower ranks are flipped off on supersede).
  • disabled - 1 = non-talent spell that was unlearned while it was a dependent/higher rank of a removed spell; the row is kept so re-training the base spell recursively re-enables these ranks. Disabled spells fail HasSpell. Talent spells are never marked disabled - they are removed outright.