AccountsTable
| 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) |