From 18ae1e8f460e7c2f5ff4a264975c069eda548108 Mon Sep 17 00:00:00 2001 From: Barbz Date: Sun, 28 Jun 2020 20:11:07 +0200 Subject: refactor: account table now in markdown + add "totaltime" (#248) - Before that commit, it was missing the column "totaltime" which was added by Nefertumm or Winfi on my behalf xD - Refactored the table, now it's perfect --- docs/account.md | 362 +++++++++----------------------------------------------- 1 file changed, 56 insertions(+), 306 deletions(-) diff --git a/docs/account.md b/docs/account.md index d5ed39f..d4d068c 100644 --- a/docs/account.md +++ b/docs/account.md @@ -8,312 +8,57 @@ This table holds information on all available accounts. ## Structure - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

id

int(10)

unsigned

PRI

NO


-

Auto increment

Identifier

username

varchar(32)


-

UNI

NO

"


-


-

sha_pass_hash

varchar(40)


-


-

NO

"


-


-

sessionkey

varchar(80)


-


-

NO

"


-


-

v

varchar(64)


-


-

NO

"


-


-

s

varchar(64)


-


-

NO

"


-


-

token_keyvarchar(100)
-
-		NO''
-
-

email

varchar(255)


-


-

NO

"


-


-

reg_mailvarchar(255)
-
-		NO''
-
-

joindate

timestamp

signed


-

NO

CURRENT_TIMESTAMP


-


-

last_ip

varchar(15)


-


-

NO

127.0.0.1


-


-

failed_logins

int(10)

unsigned


-

NO

0


-


-

locked

tinyint(3)

unsigned


-

NO

0


-


-

last_login

timestamp

signed


-

NO

0000-00-00 00:00:00


-


-

online

tinyint(3)

signed


-

NO

0


-


-

expansion

tinyint(3)

unsigned


-

NO

2


-


-

mutetime

bigint(20)

signed


-

NO

0


-


-

mutereasonvarchar(255)signed
-		NO

"


-
-
mutebyvarchar(50)signed
-		NO

"


-
-

locale

tinyint(3)

unsigned


-

NO

0


-


-

os

varchar(3)

signed


-

NO

"


-


-

recruiter

int(10)

unsigned


-

NO

0


-


-

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|---------------------|--------------|------------|-----|------|---------------------|----------------|------------| +| [id][1] | int(10) | unsigned | PRI | NO | | Auto increment | Identifier | +| [username][2] | varchar(32) | | UNI | NO | '' | | | +| [sha_pass_hash][3] | varchar(40) | | | NO | '' | | | +| [sessionkey][4] | varchar(80) | | | NO | '' | | | +| [v][5] | varchar(64) | | | NO | '' | | | +| [s][6] | varchar(64) | | | NO | '' | | | +| [token_key][7] | varchar(100) | | | NO | '' | | | +| [email][8] | varchar(255) | | | NO | '' | | | +| [reg_mail][9] | varchar(255) | | | NO | '' | | | +| [joindate][10] | timestamp | signed | | NO | CURRENT_TIMESTAMP | | | +| [last_ip][11] | varchar(15) | | | NO | 127.0.0.1 | | | +| [failed_logins][12] | int(10) | unsigned | | NO | 0 | | | +| [locked][13] | tinyint(3) | unsigned | | NO | 0 | | | +| [last_login][14] | timestamp | signed | | NO | 0000-00-00 00:00:00 | | | +| [totaltime][15] | int(10) | unsigned | | NO | 0 | | | +| [online][16] | tinyint(3) | signed | | NO | 0 | | | +| [expansion][17] | tinyint(3) | unsigned | | NO | 2 | | | +| [mutetime][18] | bigint(20) | signed | | NO | 0 | | | +| [mutereason][19] | varchar(255) | signed | | NO | '' | | | +| [muteby][20] | varchar(50) | signed | | NO | '' | | | +| [locale][21] | tinyint(3) | unsigned | | NO | 0 | | | +| [os][22] | varchar(3) | signed | | NO | '' | | | +| [recruiter][23] | int(10) | unsigned | | NO | 0 | | | + + +[1]: #id +[2]: #username +[3]: #sha_pass_hash +[4]: #sessionkey +[5]: #v +[6]: #s +[7]: #token_key +[8]: #email +[9]: #reg_mail +[10]: #joindate +[11]: #last_ip +[12]: #failed_logins +[13]: #locked +[14]: #last_login +[15]: #totaltime +[16]: #online +[17]: #expansion +[18]: #mutetime +[19]: #mutereason +[20]: #muteby +[21]: #locale +[22]: #os +[23]: #recruiter + ## Description of the fields @@ -388,6 +133,11 @@ Boolean 0 or 1 controlling if the account has been locked or not. This can be co The date when the account was last logged into. +### totaltime + +Total time played on all the characters of a player. Even the deleted characters that are no longer in the database. +Stored in Unix Time. + ### online Boolean 0 or 1 controlling if the account is currently logged in and online. -- cgit