blob: b7ae2aa3b80094fd40d659e7a5476d462fd36d3b (
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
# quest\_tracker
[<-Back-to:Character](database-character.md)
**The \`quest\_tracker\` table**
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| ----------------------- | ------------ | ---------- | --- | ---- | ------- | ----- | ------- |
|[id][1] | MEDIUMINT | UNSIGNED | | NO | 0 | | |
|[character_guid][2] | INT | UNSIGNED | | NO | 0 | | |
|[quest_accept_time][3] | DATETIME | SIGNED | | NO | | | |
|[quest_complete_time][4] | DATETIME | SIGNED | | YES | | | |
|[quest_abandon_time][5] | DATETIME | SIGNED | | YES | | | |
|[completed_by_gm][6] | TINYINT | SIGNED | | NO | 0 | | |
|[core_hash][7] | VARCHAR(120) | SIGNED | | NO | 0 | | |
|[core_revision][8] | VARCHAR(120) | SIGNED | | NO | 0 | | |
[1]: #id
[2]: #characterguid
[3]: #questaccepttime
[4]: #questcompletetime
[5]: #questabandontime
[6]: #completedbygm
[7]: #corehash
[8]: #corerevision
**Description of the fields**
### id
`field-no-description|1`
### character\_guid
See [characters.guid](characters#guid).
### quest\_accept\_time
When the quest was accepted.
### quest\_complete\_time
When the quest was completed.
### quest\_abandon\_time
When the quest was abandoned.
### completed\_by\_gm
`field-no-description|6`
### core\_hash
`field-no-description|7`
### core\_revision
`field-no-description|8`
|
