AccountsTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
Grimston (talk | contribs)
No edit summary
Grimston (talk | contribs)
mNo edit summary
 
Line 1: Line 1:
{| class="wikitable"
{| class="wikitable"
|+
|+
Line 17: Line 15:
|
|
|auto_increment
|auto_increment
|Unique account id  
|Unique account id
|-
|-
|
|
Line 25: Line 23:
|0
|0
|
|
|Login name for the account  
|Login name for the account
|-
|-
|DIF
|
|password
|password
|varchar(64)
|varchar(64)
Line 33: Line 31:
|0
|0
|
|
|The encrypted password. Type used to be 'varchar(32)' in PSLegacy.
|The encrypted password.  
|-
|
|password256
|varchar(64)
|
|0
|
|
|-
|-
|
|
Line 73: Line 79:
|
|
|
|
|The verification id used in the URL to activate/reset account.  
|The verification id used in the URL to activate/reset account.
|-
|-
|
|
Line 81: Line 87:
|
|
|
|
|The country this user is from.  
|The country this user is from.
|-
|-
|
|
Line 121: Line 127:
|0
|0
|
|
|The number of advisor points this account has accumulated.  
|The number of advisor points this account has accumulated.
|-
|-
|
|
Line 145: Line 151:
|0
|0
|
|
|If the account is banned from being an advisor  
|If the account is banned from being an advisor
|-
|-
|
|
Line 156: Line 162:
|-
|-
|
|
|graphics_card
|varchar(64)
|
|
|
|
|-
|
|graphics_version
|varchar(32)
|
|
|
|
|-
|ADD
|password256
|varchar(64)
|
|0
|
|
|-
|ADD
|OS
|OS
|char(1)
|char(1)
Line 187: Line 169:
|  
|  
|-
|-
|ADD
|
|OS_ver_major
|OS_ver_major
|int(2)
|int(2)
Line 195: Line 177:
|  
|  
|-
|-
|ADD
|
|OS_ver_minor
|OS_ver_minor
|int(2)
|int(2)
Line 203: Line 185:
|  
|  
|-
|-
|ADD
|
|OS_platform
|OS_platform
|char(14)
|char(14)
Line 211: Line 193:
|  
|  
|-
|-
|ADD
|DIF
|Machine_type
|Machine_type
|varchar(64)
|varchar(64)
|
|
|
|  Type used to be 'char(6)' in PSLegacy.
|-
|
|graphics_card
|varchar(64)
|
|
|
|
|-
|
|graphics_version
|varchar(32)
|
|
|
|

Latest revision as of 14:16, 11 January 2022

UE Field Type Key Type Default Extra Description
id int(10) unsigned PRI auto_increment Unique account id
username varchar(50) UNI 0 Login name for the account
password varchar(64) 0 The encrypted password.
password256 varchar(64) 0
last_login datetime The last login time this account was used.
created_date datetime The date this account was created
last_login_ip varchar(16) MUL The IP address last used to login with this account.
security_level tinyint(3) 0 The Security Level of this account.
verificationid varchar(32) The verification id used in the URL to activate/reset account.
country varchar(64) The country this user is from.
gender varchar(1) N The gender of the player.
birth int(4) 0 The year this player was born.
status char(1) The status of this account. (A)ctive (U)nactive.
spam_points tinyint(1) 0 The amount of spam points this account has accumulated.
advisor_points int(10) 0 The number of advisor points this account has accumulated.
comments text Additional comments about account.
realname varchar(64) The real name of the person using account.
advisor_ban tinyint(1) 0 If the account is banned from being an advisor
operating_system varchar(32)
OS char(1)
OS_ver_major int(2) 0
OS_ver_minor int(2) 0
OS_platform char(14)
DIF Machine_type varchar(64) Type used to be 'char(6)' in PSLegacy.
graphics_card varchar(64)
graphics_version varchar(32)