https://wiki.projectskyfire.org/index.php?title=DB:Character:Account_data&feed=atom&action=history
DB:Character:Account data - Revision history
2024-03-29T14:56:05Z
Revision history for this page on the wiki
MediaWiki 1.39.1
https://wiki.projectskyfire.org/index.php?title=DB:Character:Account_data&diff=612&oldid=prev
Admin: 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>..."
2013-02-20T02:37:50Z
<p>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>..."</p>
<p><b>New page</b></p><div>{| align="right"<br />
| __TOC__<br />
|}<br />
{{Back-to:Characters}}<br />
<br />
<br />
<big>'''The `account_data` table'''</big><br />
<br />
Contains data about client account and settings.<br />
<br />
<br />
<big>'''Structure'''</big><br />
{| border="1"<br />
|'''Field'''<br />
|'''Type'''<br />
|'''Attributes'''<br />
|'''Key'''<br />
|'''Null'''<br />
|'''Default'''<br />
|'''Extra'''<br />
|'''Comment'''<br />
|-<br />
|[[#account|account]]<br />
|int(10)<br />
|unsigned<br />
|PRI<br />
|NO<br />
|0<br />
|<br />
|<br />
|-<br />
|[[#type|type]]<br />
|tinyint(3)<br />
|unsigned<br />
|PRI<br />
|NO<br />
|0<br />
|<br />
|<br />
|-<br />
|[[#time|time]]<br />
|int(10)<br />
|unsigned<br />
|<br />
|NO<br />
|0<br />
|<br />
|<br />
|-<br />
|[[#data|data]]<br />
|blob<br />
|signed<br />
|<br />
|NO<br />
|<br />
|<br />
|<br />
|}<br />
<br />
<br />
<big>'''Description of the fields'''</big><br />
<br />
==== account ====<br />
[[DB:Auth:account#id|Account.id]].<br />
<br />
==== type ====<br />
* 0 = Global-account config cache<br />
* 2 = Global-account bindings cache<br />
* 4 = Global-account macros cache<br />
<br />
==== time ====<br />
Time of last modification in Unixtime<br />
<br />
==== data ====<br />
No description can be written. You just must understand it's data.<br />
<br />
==== SQL Table Query ====<br />
<br />
<pre>CREATE TABLE `account_data` (<br />
`accountId` INT(10) UNSIGNED NOT NULL DEFAULT '0',<br />
`type` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',<br />
`time` INT(10) UNSIGNED NOT NULL DEFAULT '0',<br />
`data` BLOB NOT NULL,<br />
PRIMARY KEY (`accountId`, `type`)<br />
)<br />
COLLATE='utf8_general_ci'<br />
ENGINE=InnoDB;</pre><br />
<br />
<br />
[[Category: Characters database tables]]</div>
Admin