World Database Tables

The world database is mostly static and contains definitions for all game content like items, creatures and quests. Each table is documented below.

Tables

• DB-Script-Tables - The generic script command set shared by all the script tables.
• area_template - Contains information about all areas and zones of the world, including flags, recommended level, faction ownership, and liquid type.
• areatrigger_bg_entrance - Defines battleground entrance portals that players can use to join the queue.
• areatrigger_involvedrelation - Associates area triggers with quest completion.
• areatrigger_scripts - Scripts executed when a player enters an area trigger.
• areatrigger_tavern - Defines area triggers that act as inns/taverns.
• areatrigger_teleport - Defines where area triggers (like dungeon portals) teleport players, and the conditions required to use them.
• areatrigger_template - Defines the location, size, and shape of all area triggers.
• auctionhousebot - Defines items that will be sold by the Auction House Bot (simulated economy).
• autobroadcast - Defines messages sent periodically to all online players.
• battleground_events - Defines events that spawn creatures and gameobjects during battleground matches.
• battleground_template - Defines core parameters for each battleground: team sizes, level range, spawn locations, and reward spells.
• battlemaster_entry - Defines which creatures are battlemasters and which battleground they represent.
• broadcast_text - Central repository for in-game NPC text strings.
• cinematic_waypoints - Defines camera positions at specific times during intro cinematics.
• command - Overrides the default security level and provides help text for in-game chat commands.
• conditions - Provides a flexible conditional logic system used by scripts, gossip, quests, teleports, etc.
• creature - Contains creature spawn data (placement, respawn, movement, and overrides).
• creature_addon - Provides per-spawn overrides for creature visual state, equipment, mount, emotes, and auras.
• creature_ai_events - Defines events that trigger scripts for creatures using EventAI.
• creature_ai_scripts - Actions executed by EventAI events.
• creature_battleground - Links creature spawns to battleground events, allowing specific NPCs to react to battleground state changes.
• creature_charm_spells - Defines spells available on the pet bar of charmed creatures (e.g., mind-controlled mobs).
• creature_classlevelstats - Base stats for creatures by class and level - health, mana, damage, armor, and primary attributes.
• creature_display_info_addon - Additional data for creature display info - bounding radius, combat reach, movement speeds, and gender.
• creature_equip_template - Defines held items by creatures (main hand, off hand, ranged).
• creature_groups - Groups creatures into formations, with a leader and relative positions.
• creature_groups_entry_limit - Restricts the number of creatures of a specific creature id that can be part of a group.
• creature_involvedrelation - Maps creatures (NPCs) to quests that they end, the turn-in side of the relation pair (offer side: creature_questrelation).
• creature_linking - Links creatures so they aggro / evade / respawn together.
• creature_linking_template - Template-level creature linking - all spawns of a given entry link to a master entry on a specific map.
• creature_loot_template - Loot tables for creatures - defines items, drop chances, groups, and patch ranges.
• creature_movement - Waypoints assigned by spawn GUID.
• creature_movement_scripts - Scripts executed when a creature reaches a waypoint.
• creature_movement_special - Waypoints for special purposes (e.g., scripted escort or event paths).
• creature_movement_template - Waypoints assigned by creature template id.
• creature_onkill_reputation - Reputation rewards granted when a player kills a creature of a specific entry.
• creature_questrelation - Maps creatures (NPCs) to quests they offer (quest givers).
• creature_spells - Defines spell lists for creatures to use on a timer in combat - up to 8 spells with probabilities, targets, delays, and repeat intervals.
• creature_spells_scripts - Scripts triggered by creature spell casts.
• creature_template - Defines base properties for all creature ids - stats, display, faction, AI, loot, and more.
• custom_texts - Holds custom text entries used by scripts, with support for localized versions.
• disenchant_loot_template - Loot tables for disenchanting items - defines what materials drop when an item is disenchanted.
• event_scripts - Scripts started when using some gameobjects or spells (effect 61). The ids come from official sources.
• exploration_basexp - Base experience points awarded for discovering new areas (exploration XP).
• faction - Defines reputation factions, their base standings per race/class, and other properties.
• faction_template - Defines faction reactions - which factions are friendly, hostile, or enemy. This is the id assigned to units, not the base faction id.
• fishing_loot_template - Loot tables for fishing - defines items catchable in specific zones.
• forbidden_items - Items that are forbidden from being used or obtained in certain patches. Part of progression system.
• game_event - Defines world events - their start/end times, occurrence intervals, and holidays.
• game_event_creature - Spawns creatures only during specific game events.
• game_event_creature_data - Overrides creature data (display, equipment, spells) during events.
• game_event_gameobject - Spawns game objects only during specific game events.
• game_event_mail - Sends mail to players during events based on race, quest, and faction.
• game_event_quest - Makes quests available only during specific events.
• game_graveyard_zone - Maps graveyards to zones and factions.
• game_tele - Defines teleport locations for the .tele command (GM teleport).
• game_weather - Defines weather patterns for zones by season.
• gameobject - Static world spawns of game objects (chests, doors, quest objects, etc.).
• gameobject_battleground - Links game objects to battleground events (e.g., flag spawns, towers).
• gameobject_display_info_addon - Additional data for game object display info - bounding box dimensions.
• gameobject_involvedrelation - Maps game objects to quest turn in.
• gameobject_loot_template - Loot tables for game objects (chests).
• gameobject_questrelation - Maps game objects to quests they offer (quest giver objects).
• gameobject_requirement - Gates use of a game object spawn behind world state: the linked creature must be dead, or another game object must currently be active.
• gameobject_scripts - Scripts executed when a game object is activated.
• gameobject_template - Defines base properties for all game object ids - type, display, data fields, and script.
• generic_scripts - Generic script actions used by various core systems. Can be triggered by many things.
• gossip_menu - Defines gossip menus - links NPCs to text and script logic.
• gossip_menu_option - Defines clickable options within a gossip menu.
• gossip_scripts - Scripts executed when a gossip option is selected.
• instance_buff_removal - Defines spells (buffs) that are removed when entering specific instances.
• item_display_info - Maps item display IDs to icon names.
• item_enchantment_template - Defines random enchantments for items (e.g., from random_property fields).
• item_loot_template - Loot tables for items (e.g., when an item is opened).
• item_required_target - Defines targets required for quest items (e.g., "use this on that creature").
• item_template - Defines base properties for all items - stats, spells, quality, and behavior.
• locales_area - Localized names for areas/zones.
• locales_areatrigger - Localized messages for area triggers.
• locales_broadcast_text - Localized versions of broadcast texts.
• locales_creature - Localized names and subnames for creatures.
• locales_faction - Localized faction names and descriptions.
• locales_gameobject - Localized names for game objects.
• locales_gossip_menu_option - Localized gossip menu option texts. Only needed if there is no broadcast text.
• locales_item - Localized item names and descriptions.
• locales_page_text - Localized page/book texts.
• locales_points_of_interest - Localized point-of-interest names.
• locales_quest - Localized quest text: title, details, objectives, rewards, and end text.
• locales_spell - Localized spell names, subtitles, descriptions, and aura descriptions.
• locales_taxi_node - Localized taxi node names.
• mail_loot_template - Loot tables for mail items - determines what players receive in mail.
• mail_text_template - Defines mail body text with localized support.
• mangos_string - Core system strings used by the server for messages, errors, and GM commands.
• map_loot_disabled - Disables loot from specific maps (e.g., to prevent abuse).
• map_template - Defines map properties - parent map, type, player limit, reset delay, and script binding.
• migrations - Tracks applied database migrations (schema updates).
• npc_gossip - Per-spawn gossip overrides - assigns custom gossip text to specific creature GUIDs. Only used if we don't know the gossip menu id.
• npc_text - Defines NPC gossip text with multiple broadcast text IDs and probabilities.
• npc_trainer - Defines spells taught by specific NPC trainers.
• npc_trainer_greeting - Defines custom greeting texts for specific trainer NPCs.
• npc_trainer_template - Defines spells taught by trainer templates (reusable across multiple NPCs via creature_template.trainer_id).
• npc_vendor - Defines items sold by specific NPC vendors.
• npc_vendor_template - Reusable vendor templates (assigned to NPCs via creature_template.vendor_id)
• page_text - Defines book/page text content with links to next pages.
• pet_levelstats - Base stats for pets by creature entry and level.
• pet_name_generation - Generates random names for hunter pets.
• pet_spell_data - Spell data for pets - up to 4 spells per pet entry.
• petcreateinfo_spell - Defines spells that a pet knows when created (by creature entry).
• pickpocketing_loot_template - Loot tables for pickpocketing - items that can be stolen from creatures by a rogue.
• player_classlevelstats - Base health and mana per class/level.
• player_crit_per_agility - Defines how much melee/ranged critical strike chance (in percent) each class gains per point of agility, scaled by level.
• player_dodge_per_agility - Defines how much dodge chance (in percent) each class gains per point of agility, scaled by level.
• player_factionchange_items - Maps items between Alliance and Horde equivalents (faction-specific items).
• player_factionchange_mounts - Maps faction-specific mounts between Alliance and Horde.
• player_factionchange_quests - Maps quests between Alliance and Horde equivalents.
• player_factionchange_reputations - Maps faction reputations between Alliance and Horde equivalents.
• player_factionchange_spells - Maps spells between Alliance and Horde equivalents (faction-specific spells).
• player_levelstats - Defines base primary attributes (strength, agility, stamina, intellect, spirit) for each race/class/level combination.
• player_premade_item - Defines items granted to premade characters (used for testing or templates).
• player_premade_item_template - Defines premade character templates (name, class, level, role).
• player_premade_spell - Defines individual spells and talents granted by a premade character template.
• player_premade_spell_template - Specs for premade characters (name, class, level, role).
• player_xp_for_level - Defines experience points required to reach each level.
• playercreateinfo - Defines starting location for each race/class combination.
• playercreateinfo_action - Defines starting action bar layout for each race/class combination.
• playercreateinfo_item - Defines starting items for each race/class combination.
• playercreateinfo_spell - Defines starting spells for each race/class combination.
• points_of_interest - Defines map points of interest (POI) shown on the world map when asking guards for directions. Assigned to gossip_menu_option rows.
• pool_creature - Links creature spawns to spawn pools (group of spawns that share a spawn limit).
• pool_creature_template - Links creature template IDs to spawn pools (for all spawns on map).
• pool_gameobject - Links game object spawns to spawn pools.
• pool_gameobject_template - Links game object template IDs to spawn pools (for all spawns on map).
• pool_pool - Defines nested pools - a pool within a pool, with shared chance.
• pool_template - Defines spawn pools - groups of spawns that collectively follow a spawn limit.
• quest_end_scripts - Scripts executed when a quest is completed (handed in).
• quest_greeting - Defines greeting text and emotes for quest givers (creatures or game objects).
• quest_start_scripts - Scripts executed when a quest is accepted.
• quest_template - Defines all quest data: objectives, rewards, requirements, text, and emote sequences.
• reference_loot_template - Reference loot tables - reusable loot lists that can be referenced by other loot templates via negative mincountOrRef values.
• reputation_reward_rate - Defines reputation reward multipliers for quests, creatures, and spells by faction.
• reputation_spillover_template - Defines spillover reputation - gaining reputation with one faction also grants partial reputation to others.
• reserved_name - List of reserved character names that cannot be used.
• script_escort_data - Defines escort quest data - creature, quest, and faction override.
• script_texts - Generic script texts - similar to custom_texts but used by core scripts.
• script_waypoint - Defines waypoint paths for c++ scripted creatures using ScriptedEscortAI.
• scripted_event_id - Maps scripted event IDs to script names, same thing as event_scripts but for c++ scripts.
• skill_fishing_base_level - Defines base fishing skill required per zone/area.
• skill_line_ability - Defines what skill every spell belongs to. Used for professions and class spells.
• skinning_loot_template - Loot tables for skinning creatures.
• sound_entries - Maps sound IDs to sound file names.
• spell_area - Limit spells to a given area, or make them automatically applied in the area.
• spell_chain - Defines spell ranks and their chain relationships (e.g., rank 1, rank 2, etc.).
• spell_check - Expected spell properties used by .debug spellcheck to validate loaded spells against in-code assumptions.
• spell_cone - Defines cone angles for spells with cone area of effect.
• spell_disabled - List of spells that are disabled (cannot be cast).
• spell_effect_mod - Overrides spell effect parameters (e.g., damage, radius, target) for custom tuning.
• spell_elixir - Defines elixir spells and their mask (battle/guardian) for stacking rules.
• spell_enchant_charges - Defines the number of charges for item enchantments.
• spell_group - Groups spells together for stack rules and exclusive categories.
• spell_group_stack_rules - Defines stacking rules for spell groups.
• spell_learn_spell - Defines spells that are learned automatically when another spell is learned (e.g., passive rank-ups).
• spell_mod - Overrides various spell attributes - proc chance, cooldown, duration, casting time, etc.
• spell_pet_auras - Defines auras that are applied to specific pet types when a spell is cast.
• spell_proc_event - Defines proc event conditions for spells (e.g., on hit, on crit, on spellcast).
• spell_proc_item_enchant - Defines proc rates for item enchantments (PPM).
• spell_script_target - Defines script targets for spells - restricts spell to specific creatures or game objects.
• spell_scripts - Scripts executed when a spell with effect 77 is cast.
• spell_target_position - Defines target position for spells that teleport or summon to a fixed location.
• spell_template - Defines spell data - the primary table for all spells in the world database.
• spell_threat - Defines threat values for spells - how much threat they generate.
• taxi_nodes - Defines taxi (flight master) nodes - location and mount creature IDs.
• taxi_path_transitions - Defines transitions between taxi paths - connects paths and nodes.
• transports - Defines transport vehicles (e.g., ships, zeppelins) with their path period and name.
• variables - Key-value store for core variables (e.g., world state, script tracking).
• warden_scans - Defines Warden scans - anti-cheat checks for client memory modifications.
• world_safe_locs_facing - Defines orientation for world safe locations (graveyards, respawn points).