AzerothCore
Pages :
Important: As of 19/09/24 all versions of MariaDB, MySQL 5.7 and 8.1 will no longer be supported. Consider upgrading to MySQL 8.0 or 8.4.
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
Boolean 1 or 0 signifying whether the spell is active (appears in the spell book).