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.