character_achievement_progress
This table contains the character archievement progress.
Structure
| Field | Type | Default | Comment |
|---|---|---|---|
| guid | int(10) | 0 | |
| criteria | int(10) | 0 | |
| counter | int(10) | NULL | |
| date | int(10) | NULL |
guid
The character guid from characters table.
criteria
Criteria id from the client data. Up to 4.x the ids of Achievement_Criteria, from 5.x on the ids of Criteria (see last_login_build).
counter
The progress of the criteria. From 5.x on only counted criteria are stored, values the server reads from the character (level, skills, reputation, …) are computed at login.
date
Unix time of the last change of the counter.