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_achievement.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_achievement.md')
| -rw-r--r-- | docs/character_achievement.md | 82 |
1 files changed, 76 insertions, 6 deletions
diff --git a/docs/character_achievement.md b/docs/character_achievement.md index 7a56c1e..c5c3f3c 100644 --- a/docs/character_achievement.md +++ b/docs/character_achievement.md @@ -1,7 +1,77 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [character_achievement](character_achievement) +# character\_achievement -Column | Type | Description ---- | --- | --- -Guid | int(10) unsigned | -Achievement | smallint(5) unsigned | -Date | int(10) unsigned | +`Back-to:Characters` + +**The \`character\_achievement\` table** + +This table holds information on the achievements a character has earned / completed. + +**Structure** + +<table> +<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_achievement-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><br /> +</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#character_achievement-achievement">achievement</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +<tr class="even"> +<td><p><a href="#character_achievement-date">date</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p><br /> +</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p><br /> +</p></td> +<td><p><br /> +</p></td> +</tr> +</tbody> +</table> + +**Description of the fields** + +### guid + +The GUID of the character. See [characters.guid](../tc-wiki/characters_table_) + +### achievement + +The ID of the achievement from [Achievement.dbc](https://trinitycore.atlassian.net/wiki/display/tc/Achievement) + +### date + +The date/time when this achievement was earned, in Unix time. See [Unix Timestamp Calculator](http://www.unixtimestamp.com/index.php) |