Admin: Created page with "{| align="right" | TOC |} {{Back-to:Characters}} '''The `account_data` table''' Contains data about client account and settings. '''Structure'''..."

2013-02-20T02:37:50Z

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>..."

New page

{| align="right"
| __TOC__
|}
{{Back-to:Characters}}

<big>'''The `account_data` table'''</big>

Contains data about client account and settings.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#account|account]]
|int(10)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#type|type]]
|tinyint(3)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#time|time]]
|int(10)
|unsigned
|
|NO
|0
|
|
|-
|[[#data|data]]
|blob
|signed
|
|NO
|
|
|
|}

<big>'''Description of the fields'''</big>

==== account ====
[[DB:Auth:account#id|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 ====

<pre>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;</pre>

[[Category: Characters database tables]]

DB:Character:Account data - Revision history

Admin: Created page with "{| align="right" | __TOC__ |} {{Back-to:Characters}} '''The `account_data` table''' Contains data about client account and settings. '''Structure'''..."

Admin: Created page with "{| align="right" | TOC |} {{Back-to:Characters}} '''The `account_data` table''' Contains data about client account and settings. '''Structure'''..."