DB:Character:Account data

From Project Skyfire
Jump to: navigation, 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

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;