AzerothCore
Pages :

character_spell

<-Back-to:Characters

The `character_spell` table

Holds information for each character's spells.

Structure

Field Type Attributes Key Null Default Extra Comment
guid INT UNSIGNED PRI NO 0 Global Unique Identifier
spell MEDIUMINT UNSIGNED PRI NO 0 Spell Identifier
specMask TINYINT UNSIGNED NO 1

Description of the fields

guid

The character guid. See characters.guid.

spell

The spell ID. See Spell.dbc column 1.

specMask

Boolean 1 or 0 signifying whether the spell is active (appears in the spell book).