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