DB:Character:Account data

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

Account.id.

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;