character_spell
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).