AzerothCore
Pages :

character_spell

<-Back-to:Characters

The `character_spell` table

Holds information for each character's spells.

Table 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

Bitmask saving the specs using the spell.

Value Type
1 First Spec
2 Second Spec
3 Both Specs