Character_spell - Schmoozerd/mangos-wotlk GitHub Wiki
Back to the characters database list of tables.
Holds information for each character’s spells.
| Field | Type | Null | Key | Default | Extra |
| guid | int(11) unsigned | NO | PRI | 0 | |
| spell | int(11) unsigned | NO | PRI | 0 | |
| slot | int(11) unsigned | NO | 0 | ||
| active | tinyint(3) unsigned | NO | 1 |
The GUID of the character. See character.guid
The spell ID. See Spell.dbc column 1
The slot in the spell book that the spell is in.
Boolean 1 or 0 signifying whether the spell is active (appears in the spell book).