blob: 5bc3d54a5b13322d11f6e6fc108cbf67fd4579ae (
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
|
# character\_achievement
[<-Back-to:Characters](database-characters.md)
**The \`character\_achievement\` table**
This table holds information on the achievements a character has earned / completed.
**Note:** if you delete a "realm first" achievement from the characters database, you have to reboot the server to take it into account.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|------------------|-------------|------------|-----|------|---------|-------|---------|
| [guid][1] | int(10) | unsigned | PRI | NO | | | |
| [achievement][2] | smallint(5) | unsigned | PRI | NO | | | |
| [date][3] | int(10) | unsigned | | NO | 0 | | |
[1]: #guid
[2]: #achievement
[3]: #date
**Description of the fields**
### guid
The GUID of the character. See [characters.guid](characters_table_)
### achievement
The ID of the achievement from [Achievement.dbc](Achievement).
### date
The date/time when this achievement was earned, in Unix time. See [Unix Timestamp Calculator](http://www.unixtimestamp.com/index.php)
|
