AccountsTable: Difference between revisions

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

Revision as of 11:05, 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
DIF password varchar(64) 0 The encrypted password. Type used to be 'varchar(32)' in PSLegacy.
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)
graphics_card varchar(64)
graphics_version varchar(32)
ADD password256 varchar(64) 0
ADD OS char(1)
ADD OS_ver_major int(2) 0
ADD OS_ver_minor int(2) 0
ADD OS_platform char(14)
ADD Machine_type varchar(64)