目录

character_achievement

<-Back-to:Characters

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

guid

The GUID of the character. See characters.guid.

achievement

The ID of the achievement from Achievement.dbc.

date

The date/time when this achievement was earned, in Unix time. See Unix timestamp Calculator