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