AccountsTable: Difference between revisions
Jump to navigation
Jump to search
m add to category (Engine documents) |
mNo edit summary |
||
(2 intermediate revisions by 2 users not shown) | |||
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 | |||
|- | |- | ||
| | | | ||
| varchar( | |password | ||
| | |varchar(64) | ||
| | | | ||
|0 | |||
| | |||
|The encrypted password. | |||
|- | |- | ||
| | | | ||
| varchar( | |password256 | ||
| | |varchar(64) | ||
| | | | ||
|0 | |||
| | |||
| | |||
|- | |- | ||
| last_login | | | ||
| datetime | |last_login | ||
| | |datetime | ||
| The last login time this account was used. | | | ||
| | |||
| | |||
|The last login time this account was used. | |||
|- | |- | ||
| created_date | | | ||
| datetime | |created_date | ||
| | |datetime | ||
| The date this account was created | | | ||
| | |||
| | |||
|The date this account was created | |||
|- | |- | ||
| last_login_ip | | | ||
| varchar(16) | |last_login_ip | ||
| | |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 | ||
| | |tinyint(3) | ||
| The | | | ||
|0 | |||
| | |||
|The Security Level of this account. | |||
|- | |- | ||
| verificationid | | | ||
| varchar(32) | |verificationid | ||
| | |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 | ||
| | |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 | ||
| | |int(4) | ||
| The year this player was born. | | | ||
|0 | |||
| | |||
|The year this player was born. | |||
|- | |- | ||
| status | | | ||
| char(1) | |status | ||
| | |char(1) | ||
| The status of this account. (A)ctive (U)nactive. | | | ||
| | |||
| | |||
|The status of this account. (A)ctive (U)nactive. | |||
|- | |- | ||
| spam_points | | | ||
| | |spam_points | ||
| | |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 | ||
| | |int(10) | ||
| The number of advisor points this account has accumulated. | | | ||
|0 | |||
| | |||
|The number of advisor points this account has accumulated. | |||
|- | |- | ||
| comments | | | ||
| text | |comments | ||
| | |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 | |||
| | |||
| | |||
|- | |- | ||
| | | | ||
| | |OS_ver_minor | ||
| | |int(2) | ||
| | | | ||
|0 | |||
| | |||
| | |||
|- | |- | ||
| | | | ||
| | |OS_platform | ||
| | |char(14) | ||
| | |||
| | |||
| | |||
| | | | ||
|- | |- | ||
| | |DIF | ||
| varchar( | |Machine_type | ||
| | |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) |