Back-to:Characters
The `character_spell` table
Holds information for each character's spells.
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
int(10) |
unsigned |
PRI |
NO |
0 |
|
Global Unique Identifier |
|
mediumint(8) |
unsigned |
PRI |
NO |
0 |
|
Spell Identifier |
|
tinyint(3) |
unsigned |
|
NO |
1 |
|
|
|
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.