From 9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd Mon Sep 17 00:00:00 2001 From: "Julio A. Leyva Osorio" Date: Fri, 16 Jul 2021 16:23:43 -0400 Subject: 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 --- docs/quest_tracker.md | 58 ++++++++++++++++++++++++++------------------------- 1 file changed, 30 insertions(+), 28 deletions(-) (limited to 'docs/quest_tracker.md') 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 -- cgit