AccountsTable: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 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 | |||
|- | |- | ||
| | |||
|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. | |||
|- | |- | ||
| | | | ||
| varchar( | |verificationid | ||
| | |varchar(32) | ||
| | | | ||
| | |||
| | |||
|The verification id used in the URL to activate/reset account. | |||
|- | |- | ||
| | | | ||
| varchar( | |country | ||
| | |varchar(64) | ||
| The | | | ||
| | |||
| | |||
|The country this user is from. | |||
|- | |- | ||
| | | | ||
| | |gender | ||
| N | |varchar(1) | ||
| The | | | ||
|N | |||
| | |||
|The gender of the player. | |||
|- | |- | ||
| | | | ||
| | |birth | ||
| | |int(4) | ||
| The | | | ||
|0 | |||
| | |||
|The year this player was born. | |||
|- | |- | ||
| | | | ||
| | |status | ||
| | |char(1) | ||
| The | | | ||
| | |||
| | |||
|The status of this account. (A)ctive (U)nactive. | |||
|- | |- | ||
| | | | ||
| tinyint( | |spam_points | ||
| | |tinyint(1) | ||
| The | | | ||
|0 | |||
| | |||
|The amount of spam points this account has accumulated. | |||
|- | |- | ||
| | | | ||
| | |advisor_points | ||
| | |int(10) | ||
| The | | | ||
|0 | |||
| | |||
|The number of advisor points this account has accumulated. | |||
|- | |- | ||
| | | | ||
| | |comments | ||
| | |text | ||
| | | | ||
| | |||
| | |||
|Additional comments about account. | |||
|- | |- | ||
| | | | ||
| varchar( | |realname | ||
| | |varchar(64) | ||
| The | | | ||
| | |||
| | |||
|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 | ||
| varchar( | |Machine_type | ||
| | |varchar(64) | ||
| | |||
| | |||
| | | | ||
| | |||
|} | |} | ||
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) |