Character_spell - cmangos/issues 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).