Skip to content

character_account_data Table

Per-character client UI data blobs (window layouts, action settings), stored by data type.


Schema Summary

Field Type Key Null Default Extra
guid int(11) unsigned PRI NO 0
type int(11) unsigned PRI NO 0
time bigint(11) unsigned NO 0
data longblob NO

Field Breakdown

  • guid - Primary Key. Character guid these settings belong to (characters.guid).
  • type - Primary Key. Per-character data type index (1 = config, 3 = bindings, 5 = macros, 6 = layout, 7 = chat; PER_CHARACTER_CACHE_MASK). Global types 0/2/4 live in account_data.
  • time - Unix timestamp of last modification.
  • data - Client UI configuration blob.

Per-character variant: account_data.