character_spell
Holds information for each character's spells.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | int | unsigned | PRI | NO | 0 | Global Unique Identifier | |
| spell | mediumint | unsigned | PRI | NO | 0 | Spell Identifier | |
| active | tinyint | unsigned | NO | 1 | |||
| disabled | tinyint | unsigned | NO | 0 | |||
Description of fields
guid
The guid of the character.
spell
The Spell ID known to the character.
active
Signifies whether the spell appears in the spell book
- 0: unavailable
- 1: available
disabled
Signifies when a spell is disabled because talent which teaches it has been unlearned. When talent is learned again the spell will be available again.
- 0: available
- 1: unavailable due to precondition