...
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.