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 | INT | UNSIGNED | PRI | NO | |||
| achievement | SMALLINT | UNSIGNED | PRI | NO | |||
| date | INT | UNSIGNED | NO | 0 |
Description of the fields
The GUID of the character. See characters.guid.
The ID of the achievement from Achievement.dbc.
The date/time when this achievement was earned, in Unix time. See Unix timestamp Calculator