character_spell

Back-to:Characters

The `character_spell` table

Holds information for each character's spells.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	int(10)	unsigned	PRI	NO	0		Global Unique Identifier
spell	mediumint(8)	unsigned	PRI	NO	0		Spell Identifier
active	tinyint(3)	unsigned		NO	1
disabled	tinyint(3)	unsigned		NO	0

Description of the fields

guid

The GUID of the character. See characters.guid

spell

The spell ID. See Spell.dbc column 1

active

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

disabled

Boolean flag 0 or 1 when spell is disabled because talent which teaches it has been unlearned. When talent is learned again the spell will be available again.