Back to 'battlenet_account_transmog_illusions' Return to auth Go to 'battlenet_item_appearances'
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | int | unsigned | PRI | NO | auto_increment | Identifier | |
| varchar(320) | NO | ||||||
| srp_version | tinyint | signed | NO | 1 | |||
| salt | binary(32) | NO | |||||
| verifier | blob | NO | |||||
| joindate | timestamp | NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED | |||
| last_ip | varchar(15) | NO | 127.0.0.1 | ||||
| failed_logins | int | unsigned | NO | 0 | |||
| locked | tinyint | unsigned | NO | 0 | |||
| lock_country | varchar(2) | NO | 00 | ||||
| last_login | timestamp | YES | NULL | ||||
| online | tinyint | unsigned | NO | 0 | |||
| locale | tinyint | unsigned | NO | 0 | |||
| os | varchar(4) | NO | '' | ||||
| LastCharacterUndelete | int | unsigned | NO | 0 | |||
| LoginTicket | varchar(64) | YES | NULL | ||||
| LoginTicketExpiry | int | unsigned | YES | NULL |
The unique account ID.
The e-mail address associated with this account.
- no description -
- no description -
- no description -
The date when the account was created.
The last IP used by the person who logged in the account.
The number of failed logins attempted on the account.
Boolean 0 or 1 controlling if the account has been locked or not. This can be controlled with the ".account lock" GM command. If locked (1), the user can only log in with their last_ip. If unlocked (0), a user can log in from any IP, and their last_ip will be updated if it is different. ".Ban account" does not lock it.
- no description -
The date when the account was last logged into.
Boolean 0 or 1 controlling if the account is currently logged in and online.
The locale used by the client logged into this account. If multiple locale data has been configured and added to the world servers, the world servers will return the proper locale strings to the client. See localization IDs
Stores information about client's OS. Used by Warden system.
- no description -
- no description -
- no description -
Back to 'battlenet_account_transmog_illusions' Return to auth Go to 'battlenet_item_appearances'