Table: battlenet_accounts
This table holds information on all available battlenet accounts.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(10) | unsigned | PRI | NO |
| Auto increment | Identifier | |
| varchar(320) | NO | ||||||
| sha_pass_hash | varchar(64) | NO | '' | ||||
| v | varchar(256) | NO | '' | ||||
| s | varchar(64) | NO | '' | ||||
| sessionKey | varchar(128) | NO | '' | ||||
| joindate | timestamp | NO | CURRENT_TIMESTAMP | ||||
| last_ip | varchar(15) | NO | '127.0.0.1' | ||||
| failed_logins | int(10) | unsigned | NO | '0' | |||
| locked | tinyint(3) | unsigned | NO | '0' | |||
| lock_country | varchar(2) | NO | '00' | ||||
| last_login | timestamp | NO | '0000-00-00 00:00:00' | ||||
| online | tinyint(3) | unsigned | NO | '0' | |||
| locale | tinyint(3) | unsigned | NO | '0' | |||
| os | varchar(3) | NO | '' |
Description of the fields
id
The unique account ID.
field-no-description|2
sha_pass_hash
field-no-description|3
v
field-no-description|4
s
field-no-description|5
sessionKey
field-no-description|6
joindate
field-no-description|7
last_ip
field-no-description|8
failed_logins
field-no-description|9
locked
field-no-description|10
lock_country
field-no-description|11
last_login
field-no-description|12