SkyFire MoP Database Wiki
Comprehensive reference for all World, Character, and Auth database tables — sourced directly from the server source code.
Complete: World DB (224 tables), Characters DB (126 tables), and Auth DB (30 tables) are fully documented.
Creature Tables world
Tables that define creature templates, spawn data, AI behavior, equipment, loot, and interactions.
creature
Spawn data for all creatures placed in the world — position, respawn time, movement type, phase.
creature_addon
Per-GUID overrides for mounts, emotes, auras, and animation kits on individual creature spawns.
creature_difficulty
Difficulty-based stat modifiers — health, damage, attack power scaling per dungeon/raid difficulty.
creature_equip_template
Weapon/shield equipment definitions for creatures — up to 3 visible equipment slots.
creature_linked_respawn
Links creature respawns together — when one dies, another also respawns or despawns.
creature_loot_template
Loot drop definitions — items, drop chances, group rolls, and reference loot tables.
creature_classlevelstats
Base HP, mana, armor, and damage per level/class — multiplied by creature_template modifiers.
creature_model_info
Model-specific data — bounding radius, combat reach, gender, alternate gender model.
creature_onkill_reputation
Reputation gains/losses awarded when a creature is killed — separate for Alliance and Horde.
creature_questender
Maps creatures to quests they can turn in — the NPC shows a quest completion marker.
creature_queststarter
Maps creatures to quests they offer — the NPC shows a quest available marker.
creature_sparring_template
Defines sparring behavior — creatures stop attacking each other below a health threshold.
creature_summon_groups
Grouped temporary summon definitions — spawn multiple creatures at once via script.
creature_template ★
The main creature definition table — stats, flags, spells, AI, models, faction, and everything else.
creature_template_addon
Per-entry addons for mounts, emotes, auras, and animation kits — applies to all spawns of an entry.
creature_text
NPC speech, yells, emotes, and whispers — used by scripts and SmartAI talk actions.
SmartAI Tables world
Data-driven scripting system — define complex NPC behavior without C++ code.
Reference Pages
Searchable enum and flag tables — UnitFlags, NpcFlags, CreatureType, and more.
GameObject Tables world
Tables that define game objects — chests, doors, forges, quest objects, and their spawn/behavior data.
gameobject
Spawn data for all game objects — position, rotation, respawn time, phase, and state.
gameobject_template ★
Main GO definition — type, display, data0–31 (type-specific), AI, and script references.
gameobject_template_addon
Per-template addon — faction, flags, gold, and per-GUID invisibility settings.
NPC Interaction Tables world
Gossip menus, vendor inventories, and NPC dialogue systems.
gossip_menu ★
NPC gossip menus and clickable options — covers both gossip_menu and gossip_menu_option tables.
npc_trainer
Trainer spell lists — what spells/recipes an NPC teaches, costs, and skill requirements.
npc_vendor
Vendor item lists — what items an NPC sells, stock limits, and extended cost requirements.
npc_text
Gossip text options — 8 random text slots with gender-specific text, language, probability, and emotes.
Conditions & Waypoints world
Universal condition system and creature pathing/waypoint data.
conditions ★
Universal condition system — apply conditional logic to gossip, loot, quests, smart scripts, and more.
waypoint_data
Creature waypoint paths — coordinate sequences with delays, movement types, and scripted actions.
Quest Tables world
Quest definitions, objectives, and the 5.x objective system.
quest_template ★
Primary quest data — levels, flags, prerequisites, rewards, reputation, text, and more.
quest_template_objective
MoP 5.x objectives — kill, collect, interact, cast, currency, pet battles, and more.
Item Tables world
Item definitions with 135 columns — stats, spells, sockets, quality, bonding, and class restrictions.
item_template ★
Complete item definition — class, quality, stats, spells, sockets, equip type, and more.
disenchant_loot_template
Disenchant results — shared loot table structure with LootMode, GroupId, and reference system.
page_text
Readable item/GO text pages — books, letters, and plaques with multi-page chaining.
quest_required_any / _all
Quest prerequisite chains — OR (any) and AND (all) logic for complex quest dependencies.
areatrigger_queststarter
Auto-offer quests when entering AreaTrigger zones — discovery & exploration quests.
Loot Tables world
All 12 loot template tables share the same structure — Entry, Item, Reference, Chance, QuestRequired, LootMode, GroupId, MinCount, MaxCount.
creature_loot_template ★
Primary creature drops — kill loot with full documentation of the unified loot structure.
disenchant_loot_template
Disenchant results with full loot system cross-reference of all 12 tables.
fishing_loot_template
Open-water fishing loot — entry is zone/area ID.
gameobject_loot_template
Chest / GO loot — LootMode bitmask for dungeon difficulties.
item_loot_template
Lockbox / container item loot with ITEM_FLAG_HAS_LOOT.
mail_loot_template
Items attached to quest reward mail via RewardMailTemplateId.
milling_loot_template
Inscription herb milling results — pigments and inks.
pickpocketing_loot_template
Rogue Pick Pocket drops — coin pouches, junk, lockboxes.
prospecting_loot_template
Jewelcrafting ore prospecting results — gems.
reference_loot_template ★
Shared/reusable loot groups with practical usage example.
skinning_loot_template
Skinning results — leather, scales, hides, exotic materials.
spell_loot_template
Spell-generated loot (CREATE_RANDOM_ITEM/CREATE_LOOT effects).
personal_loot_template ★
MoP personal loot — LFR/Flex boss loot pools, money bags, legendary quest bitmask (5 types).
personal_loot_item
Item pool for personal loot — spec-appropriate gear per boss, Flexible difficulty tag filtering.
bonus_loot_template ★
Bonus roll system — Elder Charm, Mogu Rune, Warforged Seal with bad luck protection.
world_drop_loot_template
Global BOE world drops — expansion filter (0–4), creature level range, group competition.
blackmarket_template
BMAH item pool — daily rotation, seller NPCs, minimum bids, weighted appearance chance.
Instance & Access world
Dungeon and raid configuration — scripts, mount rules, and entry requirements.
access_requirement ★
Instance entry checks — level, ilvl, key items, quest attunement, achievement gates, 8 difficulties.
instance_template ★
Instance config — scripts, parent maps, allowMount, and C++ ScriptName assignment.
Spell Tables world
Spell coefficients, proc systems, stacking rules, linked casting, threat modifiers, and discovery.
spell_area ★
Auto-apply auras by zone — quest status bitmask, race/gender filters, autocast.
spell_bonus_data
SP/AP coefficient overrides — direct_bonus, dot_bonus, ap_bonus with damage formula.
spell_group
Spell stacking groups and stack rules — exclusive, same-caster, strongest-effect.
spell_learn_spell
Auto-learn companion spells when a trigger spell is learned.
spell_linked_spell
Link spells — cast/hit/aura triggers that automatically fire linked effects.
spell_proc ★
New proc system — schoolMask, spellFamilyMask, PPM rate, ICD, charges, hit/phase/attribute masks.
spell_proc_event ★
Legacy proc overrides — SchoolMask, SpellFamily, procFlags (16), procEx (18), PPM, ICD.
spell_pet_auras
Owner talent → pet buff mappings + spell_enchant_proc_data enchantment proc overrides.
spell_script_names
Maps spells to C++ SpellScript/AuraScript handlers for custom behavior.
spell_target_position
Teleport spell destinations — Hearthstone, portals, Death Gate, Zen Pilgrimage.
spell_threat
Threat modifiers — flat, percentage, and AP-based threat overrides.
spell_custom_attribute
Custom server-side spell flags (19 types) — armor ignore, backstab, share damage, persistence.
World & Events world
World events, holidays, weather, teleport triggers, graveyards, transports, and phasing.
areatrigger_scripts
AreaTrigger to C++ script mapping — cutscenes, boss encounters, puzzle triggers.
areatrigger_teleport
Instance portal destinations — AreaTrigger to teleport coordinate mappings.
exploration_basexp
Area discovery XP by exploration level.
game_event ★
Holiday/event system — scheduling, holiday IDs, 12 related subtables.
game_graveyard_zone
Graveyard-to-zone links with faction filtering (Alliance/Horde/Any).
game_tele
GM .tele command locations — named coordinates with MoP map IDs.
game_weather
Per-zone weather config — seasonal rain/snow/storm probability.
phase_definitions
Server-side phasing — phaseId, terrain swaps, condition-driven world layers.
transports
Cross-map transport objects — ships, zeppelins, elevators.
holiday_dates / arena_seasons
Custom holiday date overrides (12 holidays) + arena season ↔ game_event mapping (15 seasons).
locales_creature_text
11-locale translations for creature_text — male + female variants per locale.
waypoints / waypoint_scripts
SmartAI waypoints + waypoint script commands (24 types) — talk, emote, cast, summon, etc.
PvP & Battlegrounds world
Battleground configurations, arena templates, and outdoor PvP zone scripts.
battleground_template ★
BG/arena config — player limits, level brackets, start positions, 19 BG type IDs.
outdoorpvp_template
Outdoor PvP zone scripts — Hellfire, Zangarmarsh, Nagrand, Silithus.
lfg_dungeon_template
LFG dungeon entrance overrides — teleport position, iLvl requirement per dungeon.
Pools, Reputation & Misc world
Spawn pools, reputation rates, faction change mappings, skill systems, anti-cheat, and miscellaneous tables.
creature_loot_currency
Currency drops — Justice/Valor Points, Elder Charms, Timeless Coins.
disables ★
Disable spells, quests, maps, BGs, VMAPs, MMAPs — 9 sourceTypes.
lfg_dungeon_rewards
LFG Dungeon Finder bonus rewards — first random and subsequent quests.
mail_level_reward
Auto-mail sent to players at specific levels — class quests, mount rewards.
pet_name_generation
Random pet name prefix/suffix generation for summoned demons and pets.
player_factionchange_* (×6)
All 6 faction transfer mapping tables — achievements, items, quests, reputations, spells, titles.
points_of_interest
Minimap POI markers for NPC gossip directions — 11 icon types.
pool_template ★
Random spawn pool system — rare spawns, herb/ore nodes, random daily quests.
reputation_reward_rate
Per-faction rep gain multipliers — quest, daily, weekly, creature, spell rates.
reputation_spillover_template
Reputation spillover — gain rep with allied factions, lose with opposing.
skill_discovery_template
Recipe discovery + extra item crafting procs — Alchemy, Inscription research.
skill_fishing_base_level
Minimum fishing skill per zone — below = junk only.
warden_checks
Anti-cheat Warden system — 9 check types (memory, MPQ, driver, timing, etc.).
achievement_reward ★
Achievement criteria conditions (25 types) + rewards — titles, items, spells, mail.
command
GM command permissions (security levels 0–4) + skill_extra_item crafting bonus procs.
guild_rewards
Guild vendor items + guild_xp_for_level — reputation standing, race, achievement gates.
playercreateinfo (×3)
New character spawn positions + starting items + action bar — 15 races, 11 classes.
player_class_spells / reclass
Per-class spell lists (faction-aware) + reclass_routine class change service — learn/unlearn routines.
player_levelstats
Base stats per race/class/level + player_xp_for_level XP requirements.
script_waypoint
EscortAI waypoints + scenario_poi/scenario_poi_points MoP scenario minimap markers.
Core Character Tables characters
The fundamental character tables — player data, stats, spells, talents, skills, inventory, and appearance.
characters ★
The main character table — 79 columns covering name, race, class, level, position, money, play time, and more.
character_stats
Cached combat stats at logout — health, power, primary stats, resistances, dodge, parry, crit, spell power.
character_spell
All known spells per character — class abilities, racials, profession recipes.
character_talent
MoP talent choices — one per tier per spec, 6 tiers total.
character_skills
All learned skills with current/max values — weapons, professions, riding, secondary skills.
character_glyphs
Active glyphs per spec — 6 glyph slots (3 Major, 3 Minor).
character_action
Action bar layout per spec — button positions mapped to spells, items, or macros.
character_inventory
All items in bags, bank, and equipment — bag/slot positions.
character_equipmentsets
Saved equipment sets from the Equipment Manager — 19 slot GUIDs per set.
character_homebind
Hearthstone bind location — map, zone, and coordinates.
character_currency
Currency amounts — Justice, Valor, Honor, Conquest, Elder Charms, and more.
character_reputation
Faction reputation standings and flags — every faction interaction.
Item Storage characters
Item instances, void storage, transmogrification, refunds, loot inside containers, and deleted item logging.
item_instance ★
Every item in the game — entry, owner, enchantments, random properties, durability, reforging, upgrades.
character_void_storage
Void Storage deposits — 80 extra slots that strip enchants and gems.
item_deleted
Deleted item log for restoration — owner, entry, count, deletion type, timestamps.
item_refund_instance
Item refund eligibility — 2-hour vendor return window tracking.
item_soulbound_trade_data
Soulbound trade window — recently looted items tradeable to group members.
item_loot_items
Items inside unopened containers (lockboxes, clams) — pending loot.
item_loot_money
Money inside unopened containers — copper amount.
character_gifts
Gift-wrapped items — original item data saved for unwrapping.
custom_transmogrification
Active transmog appearances — item GUID to fake entry mapping.
custom_transmogrification_sets
Saved transmog preset outfits — named sets with slot/entry pairs.
fake_items
Fake item display overrides — simple GUID to entry visual swap.
Auras, Cooldowns & Spell State characters
Persistent buffs/debuffs and spell cooldowns that survive logout.
character_aura
Persistent auras on characters — caster, spell, stacks, remaining duration.
character_aura_effect
Individual effect values for each persistent aura — base and current amounts.
character_spell_cooldown
Active spell cooldowns persisted across logout.
character_spell_charges
MoP spell charge system — Roll, Conflagrate, Force of Nature, etc.
Quest Progress characters
Active quest state, objective progress, and completion tracking across daily/weekly/monthly/seasonal resets.
character_queststatus
Active quest status — exploration flags and timer tracking.
character_queststatus_objective
Per-objective progress counts for active quests.
character_queststatus_rewarded
Permanent record of all completed quests — prevents re-completion.
character_queststatus_daily
Daily quest completions — resets at daily reset time.
character_queststatus_weekly
Weekly quest completions — resets on Tuesday/Wednesday.
character_queststatus_monthly
Monthly quest completions — resets on the 1st.
character_queststatus_seasonal
Holiday/event quest completions tied to game_event cycles.
Achievements characters
Achievement completions and criteria progress at both account and character level.
account_achievement
Account-wide achievement completions shared across all characters.
account_achievement_progress
Incremental progress toward account-wide criteria.
character_achievement
Per-character achievement completions.
character_achievement_progress
Per-character criteria progress tracking.
PvP & Arena characters
Battleground data, arena ratings, rated PvP stats, and deserter tracking.
rated_pvp_info ★
Full rated PvP stats — rating, MMR, weekly/seasonal wins, win streaks per bracket.
character_arena_stats
Matchmaking rating per arena bracket.
character_battleground_data
Saved return position and state when entering a battleground.
character_battleground_stats
Lifetime BG statistics — total played and wins.
character_battleground_random
Daily random BG reward eligibility tracker.
character_battleground_weekend
Call to Arms (BG weekend) bonus eligibility tracker.
character_deserter
Deserter penalty tracking — escalating durations for repeat offenders.
Pets & Battle Pets characters
Hunter/warlock pets, battle pet collections, pet auras, spells, and cooldowns.
character_pet ★
Hunter/warlock pets — entry, level, name, health, action bar, specialization.
character_pet_current
Currently summoned pet per character.
pet_aura / pet_aura_effect
Persistent pet auras and their effect values — survive dismiss and logout.
pet_spell / pet_spell_cooldown
Pet known spells and active cooldowns.
account_battle_pet ★
Account-wide battle pet collection — species, stats, quality, breed, level.
account_battle_pet_slots
Active battle pet team — 3 slots for Pet Battle combat.
character_pet_declinedname
Grammatically declined pet names for Russian localization.
Guild System characters
Guild data, ranks, bank, achievements, challenges, events, finder, and member tracking.
guild ★
Core guild data — name, leader, tabard, MOTD, bank money, level, experience.
guild_member
Guild membership — rank, notes, achievement points, profession info.
guild_rank
Rank hierarchy — names, permissions, daily bank money limits.
guild_bank_tab
Bank tab metadata — up to 8 tabs with custom names and icons.
guild_bank_item
Items in guild bank — tab/slot to item GUID mapping.
guild_bank_right
Per-rank bank tab permissions and daily withdrawal limits.
guild_bank_eventlog
Bank transaction history — deposits, withdrawals, transfers.
guild_achievement
Guild achievement completions with contributing member GUIDs.
guild_challenges
Weekly guild challenge counts — dungeon, raid, BG, scenario, challenge mode.
guild_completed_challenges
Best Challenge Mode times per dungeon for guild leaderboards.
guild_eventlog
Guild event history — joins, leaves, promotions, demotions.
guild_newslog
Guild news feed — achievements, boss kills, item acquisitions.
guild_finder_applicant
Pending Guild Finder applications from players.
guild_finder_guild_settings
Guild recruitment settings for the Guild Finder.
guild_member_withdraw
Daily guild bank withdrawal tracking per member.
guild_reputation
Per-character guild reputation standing for vendor/perk access.
petition / petition_sign
Guild charter petitions and their signatures.
Groups & Instances characters
Party/raid groups, instance lockouts, Challenge Mode records, and LFG state.
groups ★
Persistent party/raid groups — leader, loot method, markers, difficulty settings.
group_member
Group membership — roles (tank/healer/DPS), subgroups, flags.
instance
Active dungeon/raid instances — map, difficulty, reset time, encounter data.
instance_reset
Next scheduled reset time per map and difficulty.
character_instance
Character-to-instance lockout bindings (raid saves).
group_instance
Group-to-instance bindings.
character_completed_challenges
Personal best Challenge Mode times and medals per dungeon.
group_completed_challenges
Realm-best Challenge Mode records with full group composition.
character_loot_lockout
Per-character loot lockouts — prevents double-looting bosses in LFR/Flex.
character_bonus_roll
Bad luck protection value for bonus loot rolls.
lfg_data
Looking For Group queue state per character.
Mail System characters
In-game mail messages and item attachments.
mail ★
Mail messages — sender, receiver, subject, body, money, COD, stationery, timestamps.
mail_items
Item attachments linked to mail messages.
Social & Calendar characters
Friends list, ignore list, chat channels, calendar events, and name declension.
character_social
Friends and ignore list — relationship flags and personal notes.
channels
Persistent custom chat channels — settings, passwords, ban lists.
calendar_events
Player-created calendar events — raids, meetings, reminders.
calendar_invites
Calendar event invitations with accept/decline status.
character_declinedname
Grammatically declined names for Russian localization.
character_cuf_profiles
Compact Unit Frame (raid frame) profiles — up to 5 saved layouts.
Auction House characters
Regular and Black Market auction house listings.
auctionhouse ★
Active auction listings — seller, item, bids, buyout, deposit, expiration.
blackmarket_auctions
Black Market AH listings — high-value scheduled auctions.
Archaeology characters
Dig sites, research projects, and completion history.
character_research_digsites
Active dig sites — remaining finds per site.
character_research_projects
Currently available research projects in the archaeology UI.
character_research_history
Completed project history — count and first completion date.
GM Tickets & Reports characters
Support tickets, bug reports, lag reports, surveys, and anti-cheat reports.
gm_tickets ★
GM support tickets — message, position, assignment, resolution, comments.
ticket_bug
Bug reports via the newer ticket system — position, notes, assignment.
bugreport
Legacy bug reports — type and description text.
lag_reports
Player lag reports with position and latency data.
gm_surveys / gm_subsurveys
GM ticket satisfaction surveys and individual question responses.
daily_players_reports
Daily anti-cheat report aggregation — speed, fly, jump, teleport hack counts.
players_reports_status
Accumulated anti-cheat report status per character.
Account Data characters
Account-wide settings, spells, tutorials, instance lockouts, and bans.
account_data
Account-wide client settings — keybindings, macros, UI layout backup.
character_account_data
Per-character client settings that override account defaults.
account_spell
Account-wide spells — mounts and companions.
account_tutorial
Tutorial dismissal bitmask — 8 tutorial flag values.
account_instance_times
Hourly instance entry tracking — 5 per hour anti-farming limit.
character_banned
Character-level bans — specific character blocked, account still usable.
World State & Respawns characters
Persistent world variables, creature/GO respawn timers, event state, and quest pools.
worldstates
Server-wide persistent variables — Wintergrasp, Tol Barad, and other cross-session state.
creature_respawn
Creature respawn timers per instance — tracks dead creatures awaiting respawn.
gameobject_respawn
Game object respawn timers per instance — chests, nodes, interactables.
game_event_save
Game event state persistence — active/inactive and next start time.
game_event_condition_save
Event condition progress — war effort style contribution tracking.
pool_quest_save
Currently active quests from random quest pools.
corpse
Player corpses in the world — position, display, equipment cache, expiry timer.
Services, Addons & Miscellaneous characters
Character services, addon validation, armory cache, Warden anti-cheat, and custom modules.
character_service
Pending/completed services — rename, race change, faction transfer, customization.
executed_services
Service audit log — old/new data for rollback, 16 service types.
addons
Known addon name/CRC pairs for communication validation.
banned_addons
Server-banned addons by name and version.
warden_action
Anti-cheat Warden check failure actions — log, kick, or ban.
armory_character_stats
Cached web armory data — JSON stats blob, item level, gear score.
reserved_name
Reserved character names that cannot be used by players.
custom_solocraft_character_stats
Solocraft module — per-character dungeon/raid stat scaling.
auth Core Account Tables
Account credentials, access levels, bans, and session management.
account
Core account table — credentials, SRP6 auth, session, expansion, locale (48 columns)
account_access
GM access levels per realm
account_banned
Account ban list with realm support
account_boost
Character boost tokens per realm
account_data
Account configuration cache
account_muted
Account mute history with details
ip_banned
IP address ban list
auth Battle.net & Shop
Battle.net accounts, bans, and in-game shop transactions.
battlenet_accounts
Battle.net account system
battlenet_account_bans
Battle.net account ban list
battlepay_log
In-game shop transaction log
pandaria_token
VP/token transaction log
currency_transactions
Gold/currency audit trail
auth Realm & Server
Realm configuration, uptime tracking, and server management.
realmlist
Realm server list — addresses, settings, transfer config (33 columns)
realmcharacters
Character count per account per realm
realm_diff_stats
Realm performance statistics
uptime
Server uptime history
config
Database-stored server config overrides
autobroadcast
Automated server broadcast messages
logs
Server log entries
sql_update
Applied SQL update tracking
auth PvP & Arena
Arena match history and game tracking.
auth Mute & Moderation
Chat mute system and moderation tools.
auth Promotions & Bonuses
Bonus rates, promotions, and boost systems.
bonus_rates
Scheduled bonus XP/honor rate periods
boost_promotion_executed
Boost promotion tracking
promotion_auras
Promotional buff/aura periods
auth Project & Members
Project-specific member management, beta testing, and premium features.