blob: 08b0cb7d0b18d87fa7f54646dc5cb29f75f72dc7 (
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 | UNSIGNED | PRI | NO | | | |
| [achievement][2] | SMALLINT | UNSIGNED | PRI | NO | | | |
| [date][3] | INT | UNSIGNED | | NO | 0 | | |
[1]: #guid
[2]: #achievement
[3]: #date
**Description of the fields**
### guid
The GUID of the character. See [characters.guid](characters#guid).
### 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)
|
