AccountsTable: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
Line 1: | Line 1: | ||
{| class="wikitable" | {| class="wikitable" | ||
|+ | |+ | ||
Line 17: | Line 15: | ||
| | | | ||
|auto_increment | |auto_increment | ||
|Unique account id | |Unique account id | ||
|- | |- | ||
| | | | ||
Line 25: | Line 23: | ||
|0 | |0 | ||
| | | | ||
|Login name for the account | |Login name for the account | ||
|- | |- | ||
| | | | ||
|password | |password | ||
|varchar(64) | |varchar(64) | ||
Line 33: | Line 31: | ||
|0 | |0 | ||
| | | | ||
|The encrypted password. | |The encrypted password. | ||
|- | |||
| | |||
|password256 | |||
|varchar(64) | |||
| | |||
|0 | |||
| | |||
| | |||
|- | |- | ||
| | | | ||
Line 73: | Line 79: | ||
| | | | ||
| | | | ||
|The verification id used in the URL to activate/reset account. | |The verification id used in the URL to activate/reset account. | ||
|- | |- | ||
| | | | ||
Line 81: | Line 87: | ||
| | | | ||
| | | | ||
|The country this user is from. | |The country this user is from. | ||
|- | |- | ||
| | | | ||
Line 121: | Line 127: | ||
|0 | |0 | ||
| | | | ||
|The number of advisor points this account has accumulated. | |The number of advisor points this account has accumulated. | ||
|- | |- | ||
| | | | ||
Line 145: | Line 151: | ||
|0 | |0 | ||
| | | | ||
|If the account is banned from being an advisor | |If the account is banned from being an advisor | ||
|- | |- | ||
| | | | ||
Line 156: | Line 162: | ||
|- | |- | ||
| | | | ||
|OS | |OS | ||
|char(1) | |char(1) | ||
Line 187: | Line 169: | ||
| | | | ||
|- | |- | ||
| | | | ||
|OS_ver_major | |OS_ver_major | ||
|int(2) | |int(2) | ||
Line 195: | Line 177: | ||
| | | | ||
|- | |- | ||
| | | | ||
|OS_ver_minor | |OS_ver_minor | ||
|int(2) | |int(2) | ||
Line 203: | Line 185: | ||
| | | | ||
|- | |- | ||
| | | | ||
|OS_platform | |OS_platform | ||
|char(14) | |char(14) | ||
Line 211: | Line 193: | ||
| | | | ||
|- | |- | ||
| | |DIF | ||
|Machine_type | |Machine_type | ||
|varchar(64) | |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) |