diff options
| author | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
|---|---|---|
| committer | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
| commit | a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 (patch) | |
| tree | 91e0cde00f6f27b730b0df3f4338fcf99fa8447a /docs/character_spell.md | |
| parent | d8d1823802ded97300fa57405d80b16736603489 (diff) | |
| download | wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.gz wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.bz2 wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.zip | |
Import DB wiki from TC 335
Diffstat (limited to 'docs/character_spell.md')
| -rw-r--r-- | docs/character_spell.md | 97 |
1 files changed, 91 insertions, 6 deletions
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** + +<table> +<colgroup> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +</colgroup> +<tbody> +<tr class="odd"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +<td><p><strong>Extra</strong></p></td> +<td><p><strong>Comment</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#character_spell-guid">guid</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p>Global Unique Identifier</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#character_spell-spell">spell</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p>Spell Identifier</p></td> +</tr> +<tr class="even"> +<td><p><a href="#character_spell-active">active</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>1</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#character_spell-disabled">disabled</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +</tbody> +</table> + +**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. |