Character Database

The character database stores all player-owned state: characters themselves, inventories, guilds, groups, mail, auctions, tickets, pets, corpses and respawn data.

Tables

• account_data - Stores account-wide client UI data blobs, kept separately from per-character settings.
• auction - Active auctions on the world auction houses.
• character_account_data - Per-character client UI data blobs stored by data type.
• character_action - Player action bar button assignments (spells/items placed on slots).
• character_aura - Auras persisting on a character across logout (passives, shapeshifts, DoTs with long duration).
• character_battleground_data - Per-character battleground state that must survive a restart (marked for BG, random BG info).
• character_deleted_items - Items deleted from a character, kept for restoration purposes.
• character_forgotten_skills - Skills explicitly unlearned from a character (weapon skill resets); remembered so they are not re-granted automatically.
• character_gifts - Items wrapped as gifts waiting to be opened (gift target stored until unwrapped).
• character_homebind - Home bind position (hearthstone destination) per character.
• character_honor_cp - Honour contribution points accumulated during the current honour day (used by the weekly honour calculation).
• character_instance - Instance binds of a character (which dungeon/raid saves they belong to).
• character_inventory - Every item a character carries: bag/slot mapping from item_instance.
• character_pet - Persistent pet data (hunter pets): stats, spells, loyalty, name and stable slot.
• character_queststatus - Quest progress: accepted quests, kill/credit counters, rewarded status and timers.
• character_reputation - Standing per faction for every character.
• character_skills - Learned skills and their current/max values (professions, weapon skills).
• character_social - Friends and ignores of each character.
• character_spell - Spells learned by the character.
• character_spell_cooldown - Spell cooldowns persisting across logout.
• character_stats - Cached lifetime statistics for the character sheet: kills, honour, quest counts and combat stats.
• character_tutorial - Tutorial flags shown to newly created accounts/characters.
• characters - The central table: one row per player character with race/class/level, position, money and appearance.
• characters_guid_delete - Queue of character GUIDs scheduled for deletion by the cleanup system.
• characters_item_delete - Purge list used by the item reference cleanup item_instance deletion queue.
• corpse - Corpses left in the world after deaths (position, bones/state).
• creature_respawn - Persisted respawn times of creatures so respawn state survives server restarts.
• game_event_status - Manual override of game event state set by admins (start/stop events independent of their schedule).
• gameobject_respawn - Persisted respawn times of game objects.
• gm_subsurveys - Optional follow-up survey answers attached to GM tickets.
• gm_surveys - Player satisfaction surveys submitted after a GM ticket was resolved.
• gm_tickets - Open and archived GM tickets written by players.
• group_instance - Which instances a group is bound to.
• group_member - Members of each party/raid group.
• groups - Party and raid group headers (leader, loot rules, difficulty).
• guild - Guild header row: name, leader, emblem/tabard colours, public info, MOTD and creation date.
• guild_eventlog - Recent guild events (member join/leave, leadership changes) shown in-game.
• guild_member - Guild roster with rank and public/officer notes.
• guild_rank - Rank definitions per guild (name and permission rights).
• instance - Dungeon/raid save instances with reset times.
• instance_reset - Global reset schedule per map/difficulty.
• item_instance - One row per physical item in the world: owner, enchantments, durability, flags.
• item_loot - Loot rolled inside an openable item, persisted until looted.
• item_text - Text written on letter-stationery items (old book items) - deprecated content.
• mail - Mailbox messages: sender, receiver, subject, body, attachments state, expiry.
• mail_items - Items attached to mails (moved out of mailfor performance.
• migrations - Applied migration IDs for the characters database.
• pet_aura - Auras persisting on pets across logout.
• pet_spell - Spells known by persistent pets.
• pet_spell_cooldown - Pet spell cooldowns persisting across logout.
• petition - Charter petitions for founding guilds, including the requested guild name and charter item.
• petition_sign - Signatures collected on a petition.
• playerbot - State storage for player bots managed by the built-in bot system.
• saved_variables - Miscellaneous global flags saved between restarts, such as the next honour-day maintenance date.
• world - World-wide persistent variables, such as per-map weather timers.