summaryrefslogtreecommitdiff
path: root/docs/account.md
diff options
context:
space:
mode:
authorYehonal <yehonal.azeroth@gmail.com>2019-02-17 21:34:28 +0100
committerYehonal <yehonal.azeroth@gmail.com>2019-02-17 21:34:28 +0100
commita3d359e1cc4f40328f898653a5cc3b9711a522e6 (patch)
tree48d879cbdbf5e78a72ca686912ca4ac361c929c7 /docs/account.md
parentb781501462339649eac45d9d54f8dbbfb11a32db (diff)
downloadwiki-a3d359e1cc4f40328f898653a5cc3b9711a522e6.tar.gz
wiki-a3d359e1cc4f40328f898653a5cc3b9711a522e6.tar.bz2
wiki-a3d359e1cc4f40328f898653a5cc3b9711a522e6.zip
Import all wiki page from old wiki (links to fix)
Diffstat (limited to 'docs/account.md')
-rw-r--r--docs/account.md25
1 files changed, 25 insertions, 0 deletions
diff --git a/docs/account.md b/docs/account.md
new file mode 100644
index 0000000..cac6f71
--- /dev/null
+++ b/docs/account.md
@@ -0,0 +1,25 @@
+[[Database Structure|Database Structure]] > [[Auth-Database|Auth-Database]] > [[account|account]]
+
+Column | Type | Description
+--- | --- | ---
+Id | int(10) unsigned |
+Username | varchar(32) |
+Sha_pass_hash | varchar(40) |
+Sessionkey | varchar(80) |
+V | varchar(64) |
+S | varchar(64) |
+Email | varchar(254) |
+Joindate | timestamp |
+Last_ip | varchar(15) |
+Failed_logins | int(10) unsigned |
+Locked | tinyint(3) unsigned |
+Last_login | timestamp |
+totaltime | int(10) unsigned [0] | total time played on all characters
+Online | tinyint(3) unsigned |
+Expansion | tinyint(3) unsigned |
+Mutetime | bigint(20) |
+Mutereason | varchar(255) |
+Muteby | varchar(50) |
+Locale | tinyint(3) unsigned |
+Os | varchar(3) |
+Recruiter | int(10) unsigned |