character_spell
The `character_spell` table
Holds information for each character's spells.
Table 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 | |
| specMask | TINYINT | UNSIGNED | NO | 1 |
Description of the fields
guid
The character guid. See characters.guid.
spell
The spell ID. See Spell.dbc column 1.
specMask
Bitmask saving the specs using the spell.
| Value | Type |
|---|---|
| 1 | First Spec |
| 2 | Second Spec |
| 3 | Both Specs |