AccountsTable: Difference between revisions

From PSwiki
Jump to navigation Jump to search
No edit summary
Grimston (talk | contribs)
mNo edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{| border=1
{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|-
! field
|
! type
|id
! foreign key
|int(10) unsigned
! description
|PRI
|
|auto_increment
|Unique account id 
|-
|-
| id
|
| int(10)
|username
| N
|varchar(50)
| unique account id
|UNI
|0
|
|Login name for the account
|-
|-
| username
|
| varchar(50)
|password
| N
|varchar(64)
| Login name for the account
|
|0
|
|The encrypted password.
|-
|-
| password
|
| varchar(32)
|password256
| N
|varchar(64)
| The MD5 encrypted password.
|
|0
|
|
|-
|-
| last_login
|
| datetime
|last_login
| N
|datetime
| The last login time this account was used.  
|
|
|
|The last login time this account was used.
|-
|-
| created_date
|
| datetime
|created_date
| N
|datetime
| The date this account was created
|
|
|
|The date this account was created
|-
|-
| last_login_ip
|
| varchar(16)
|last_login_ip
| N
|varchar(16)
| The IP address last used to login with this account.
|MUL
|
|
|The IP address last used to login with this account.
|-
|-
| security_level
|
| tinyint(3)
|security_level
| N
|tinyint(3)
| The [[Security Level]] of this account.
|
|0
|
|The Security Level of this account.
|-
|-
| verificationid
|
| varchar(32)
|verificationid
| N
|varchar(32)
| The verification id used in the URL to activate/reset account.
|
|
|
|The verification id used in the URL to activate/reset account.
|-
|-
| country
|
| varchar(64)
|country
| N
|varchar(64)
| The country this user is from.
|
|
|
|The country this user is from.
|-
|-
| gender
|
| varchar(1)
|gender
| N
|varchar(1)
| The gender of the player.
|
|N
|
|The gender of the player.
|-
|-
| birth
|
| int(4)
|birth
| N
|int(4)
| The year this player was born.
|
|0
|
|The year this player was born.
|-
|-
| status
|
| char(1)
|status
| N
|char(1)
| The status of this account. (A)ctive (U)nactive.
|
|
|
|The status of this account. (A)ctive (U)nactive.
|-
|-
| spam_points
|
| int
|spam_points
| N
|tinyint(1)
| The amount of spam points this account has accumulated.  
|
|0
|
|The amount of spam points this account has accumulated.
|-
|-
| advisor_points
|
| int
|advisor_points
| N
|int(10)
| The number of advisor points this account has accumulated.  
|
|0
|
|The number of advisor points this account has accumulated.
|-
|-
| comments
|
| text
|comments
| N
|text
| Additional comments about account.
|
|
|
|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
|
|
|-
|-
| realname
|
| varchar(64)
|OS_ver_minor
| N
|int(2)
| The real name of the person using account.
|
|0
|
|
|-
|-
| advisor_ban
|
| tinyint(1)
|OS_platform
| N
|char(14)
|
|
|
|  
|  
|-
|-
| operating_system
|DIF
| varchar(32)
|Machine_type
| N
|varchar(64)
|
|
|
|
|  Type used to be 'char(6)' in PSLegacy.
|-
|-
| graphics_card
| varchar(64)
| N
|
|
|graphics_card
|varchar(64)
|
|
|
|
|-
|-
| graphics_version
| varchar(32)
| N
|
|
|graphics_version
|varchar(32)
|
|
|
|
|}
|}
[[Category:Engine documents]]

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)