AccountsTable

From PSwiki
Jump to navigation Jump to search
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)