diff options
| author | Julio A. Leyva Osorio <tony931023@gmail.com> | 2021-07-16 16:23:43 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-07-16 22:23:43 +0200 |
| commit | 9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd (patch) | |
| tree | cc7fe36188f6d9144baaddecdc35ed77a2eb1a36 /docs/quest_tracker.md | |
| parent | 535ad2787b77d2ffd79b6788e38156ec5144ca7f (diff) | |
| download | wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.tar.gz wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.tar.bz2 wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.zip | |
chore: characters (#584)
* Update account_data.md
* Update account_instance_times.md
* Update account_tutorial.md
* Update addons.md
* Update arena_team.md
* Fix arena_team.md
* Update arena_team_member.md
* Update auctionhouse.md
* Update banned_addons.md
* Update battleground_deserters.md
* Update bugreport.md
* Update calendar_events.md
* fix calendar_events.md
* fix
* fix
* fix3
* update calendar_invites.md
* update channels.md
* fix channels.md
* fix channels.md
* update channels_bans.md
* update channels_bans.md
* update petition.md
* fix 4
* Update characters.md
* Update worlstates.md
* Update gm_ticket.md
* + Update
* + update 2.md
* + update 3
* update + characters.md
* + update 4.md
* + update 5.md
* update characters, thanks @r-o-b-o-t-o
* fix +
* + Update 6
* + Update 7
* + Update 8
* + Update 9
* Fix + @Kitzunu
Diffstat (limited to 'docs/quest_tracker.md')
| -rw-r--r-- | docs/quest_tracker.md | 58 |
1 files changed, 30 insertions, 28 deletions
diff --git a/docs/quest_tracker.md b/docs/quest_tracker.md index 77ac708..a38e174 100644 --- a/docs/quest_tracker.md +++ b/docs/quest_tracker.md @@ -1,59 +1,61 @@ -# quest_tracker +# quest\_tracker [<-Back-to:Character](database-character.md) -**The \`quest_tracker\` table** +**The \`quest\_tracker\` table** **Structure** -| Field | Type | Attribute | Key | Null | Default | Extra | Comment -|:--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- -|[id][1] | MEDIUMINT | UNSIGNED | | NO | 0 -|[character_guid][2] | INT | UNSIGNED | | NO | 0 -|[quest_accept_time][3] | DATETIME | | | NO -|[quest_complete_time][4] | DATETIME | | | YES | NULL -|[quest_abandon_time][5] | DATETIME | | | YES | NULL -|[completed_by_gm][6] | TINYINT | SIGNED | | NO | 0 -|[core_hash][7] | VARCHAR(120) | | | NO | 0 -|[core_revision][8] | VARCHAR(120) | | | NO | 0 +| 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]: #character_guid -[3]: #quest_accept_time -[4]: #quest_complete_time -[5]: #quest_abandon_time -[6]: #completed_by_gm -[7]: #core_hash -[8]: #core_revision +[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 +### character\_guid -[characters.guid](characters#guid). +See [characters.guid](characters#guid). -### quest_accept_time +### quest\_accept\_time When the quest was accepted. -### quest_complete_time +### quest\_complete\_time When the quest was completed. -### quest_abandon_time +### quest\_abandon\_time When the quest was abandoned. -### completed_by_gm +### completed\_by\_gm `field-no-description|6` -### core_hash +### core\_hash `field-no-description|7` -### core_revision +### core\_revision -`field-no-description|8` +`field-no-description|8`
\ No newline at end of file |