DB:Character:Account data
Jump to navigation
Jump to search
Back to characters database list of tables.
The `account_data` table
Contains data about client account and settings.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
account | int(10) | unsigned | PRI | NO | 0 | ||
type | tinyint(3) | unsigned | PRI | NO | 0 | ||
time | int(10) | unsigned | NO | 0 | |||
data | blob | signed | NO |
Description of the fields
account
type
- 0 = Global-account config cache
- 2 = Global-account bindings cache
- 4 = Global-account macros cache
time
Time of last modification in Unixtime
data
No description can be written. You just must understand it's data.
SQL Table Query
CREATE TABLE `account_data` ( `accountId` INT(10) UNSIGNED NOT NULL DEFAULT '0', `type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', `time` INT(10) UNSIGNED NOT NULL DEFAULT '0', `data` BLOB NOT NULL, PRIMARY KEY (`accountId`, `type`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB;