Mangosdb_struct

This is the list of tables in the regular ‘mangos’ database

® – Reloadable in-game with the .reload command.
[M] – MaNGOS table. These tables are either used by MaNGOS internally, or they are maintained by the MaNGOS team. Either way, the UDB team does not touch them.
[S] – Script library tables. These tables are maintained by script library projects (such as ScriptDev2). The UDB team does not touch them.

• achievement_criteria_requirement

• achievement_reward

• areatrigger_involvedrelation®

• areatrigger_tavern®

• areatrigger_teleport®

• battleground_events

• battleground_template

• battlemaster_entry

• command® [M]

• conditions

• creature

• creature_addon

• creature_ai_scripts®

• creature_ai_summons®

• creature_ai_texts®

• creature_battleground

• creature_equip_template

• creature_involvedrelation®

• creature_loot_template®

• creature_model_info

• creature_model_race

• creature_movement

• creature_movement_scripts

• creature_movement_template

• creature_onkill_reputation

• creature_questrelation®

• creature_template

• creature_linking_template

• creature_template_addon

• db_script_string

• db_version

• disenchant_loot_template®

• event_scripts®

• exploration_basexp

• fishing_loot_template®

• game_event

• game_event_creature

• game_event_creature_data

• game_event_gameobject

• game_event_mail

• game_event_quest

• game_graveyard_zone®

• game_tele

• game_weather

• gameobject

• gameobject_addon

• gameobject_battleground

• gameobject_involvedrelation®

• gameobject_loot_template®

• gameobject_questrelation®

• gameobject_scripts®

• gameobject_template

• gossip_menu®

• gossip_menu_option®

• gossip_scripts®

• instance_template

• item_convert

• item_enchantment_template

• item_expire_convert [M]®

• item_loot_template®

• item_required_target®

• item_template

• locales_creature

• locales_gameobject

• locales_item

• locales_npc_text

• locales_page_text

• locales_quest

• mail_level_reward®

• mail_loot_template®

• mangos_string

• milling_loot_template

• npc_gossip

• npc_spellclick_spells®

• npc_text

• npc_trainer

• npc_trainer_template

• npc_vendor

• npc_vendor_template

• page_text

• pet_levelstats

• pet_name_generation

• pickpocketing_loot_template®

• player_classlevelstats [M]

• player_levelstats [M]

• player_xp_for_level [M]

• playercreateinfo [M]

• playercreateinfo_action [M]

• playercreateinfo_item [M]

• playercreateinfo_spell [M]

• points_of_interest®

• pool_creature

• pool_creature_template

• pool_gameobject

• pool_gameobject_template

• pool_pool

• pool_template

• prospecting_loot_template®

• quest_end_scripts®

• quest_poi®

• quest_poi_points®

• quest_start_scripts®

• quest_template®

• reference_loot_template®

• reputation_reward_rate®

• reputation_spillover_template

• reserved_name®

• scripted_areatrigger [S]

• scripted_event_id [S]

• skill_discovery_template®

• skill_extra_item_template

• skill_fishing_base_level

• skinning_loot_template

• spell_affect® [M]

• spell_area®

• spell_bonus_data® [M]

• spell_chain® [M]

• spell_check [M]

• spell_elixir® [M]

• spell_learn_spell® [M]

• spell_loot_template®

• spell_pet_auras

• spell_proc_event® [M]

• spell_proc_item_enchant® [M]

• spell_script_target®

• spell_scripts®

• spell_target_position®

• spell_threat® [M]

• transports