blob: 6b70935f406fdfb741a1def3e2c9f4d514f3ad82 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
# character\_spell
[<-Back-to:Characters](database-characters.md)
**The \`character\_spell\` table**
Holds information for each character's spells.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---------------|--------------|------------|-----|------|---------|-------|--------------------------|
| [guid][1] | INT | UNSIGNED | PRI | NO | 0 | | Global Unique Identifier |
| [spell][2] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | Spell Identifier |
| [active][3] | TINYINT | UNSIGNED | | NO | 1 | | |
| [disabled][4] | TINYINT | UNSIGNED | | NO | 0 | | |
[1]: #guid
[2]: #spell
[3]: #active
[4]: #disabled
**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.
|
