Character_spell

Back to the characters database list of tables.

The `character_spell` table

Holds information for each character’s spells.

Structure

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

Description of the fields

guid

The GUID of the character. See character.guid

spell

The spell ID. See Spell.dbc column 1

slot

The slot in the spell book that the spell is in.

active

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