From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/character_spell.md | 97 ++++++++++++++++++++++++++++++++++++++++++++++--- 1 file changed, 91 insertions(+), 6 deletions(-) (limited to 'docs/character_spell.md') diff --git a/docs/character_spell.md b/docs/character_spell.md index ffae499..f0458e9 100644 --- a/docs/character_spell.md +++ b/docs/character_spell.md @@ -1,7 +1,92 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_spell](character_spell) +# character\_spell -Column | Type | Description ---- | --- | --- -Guid | int(10) unsigned | -Spell | mediumint(8) unsigned | -SpecMask | tinyint(3) unsigned | +`Back-to:Characters` + +**The \`character\_spell\` table** + +Holds information for each character's spells. + +**Structure** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

Global Unique Identifier

spell

mediumint(8)

unsigned

PRI

NO

0

 

Spell Identifier

active

tinyint(3)

unsigned

 

NO

1

 

 

disabled

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