DB:Character:Account data

From Project Skyfire
Revision as of 21:37, 19 February 2013 by Admin (talk | contribs) (Created page with "{| align="right" | __TOC__ |} {{Back-to:Characters}} <big>'''The `account_data` table'''</big> Contains data about client account and settings. <big>'''Structure'''</big>...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

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;