Mangosdb struct

From UDB

This is the list of tables in the regular 'mangos' database

[R] - 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.

• areatrigger_involvedrelation [R]

• areatrigger_tavern [R]

• areatrigger_teleport [R]

• battleground_template

• battlemaster_entry

• command [R]

• creature

• creature_addon

• creature_equip_template

• creature_involvedrelation [R]

• creature_loot_template [R]

• creature_model_info

• creature_movement

• creature_onkill_reputation

• creature_questrelation [R]

• creature_respawn [M]

• creature_template

• creature_template_addon

• db_version

• disenchant_loot_template [R]

• event_scripts [R]

• exploration_basexp

• fishing_loot_template [R]

• game_event

• game_event_creature

• game_event_creature_quest

• game_event_gameobject

• game_event_model_equip

• game_graveyard_zone [R]

• game_tele

• game_weather

• gameobject

• gameobject_involvedrelation [R]

• gameobject_loot_template [R]

• gameobject_questrelation [R]

• gameobject_respawn [M]

• gameobject_scripts [R]

• gameobject_template

• instance_template

• item_enchantment_template

• item_loot_template [R]

• item_template

• locales_creature

• locales_gameobject

• locales_item

• locales_npc_text

• locales_page_text

• locales_quest

• mangos_string

• npc_gossip

• npc_gossip_textid

• npc_option

• npc_text

• npc_trainer

• npc_vendor

• page_text

• pet_levelstats

• pet_name_generation

• petcreateinfo_spell

• pickpocketing_loot_template [R]

• player_classlevelstats [M]

• player_levelstats [M]

• playercreateinfo [M]

• playercreateinfo_action [M]

• playercreateinfo_item [M]

• playercreateinfo_spell [M]

• prospecting_loot_template [R]

• quest_end_scripts [R]

• quest_mail_loot_template [R]

• quest_start_scripts [R]

• quest_template [R]

• reserved_name [R]

• skill_discovery_template [R]

• skill_extra_item_template

• skill_fishing_base_level

• skinning_loot_template

• spell_affect [R] [M]

• spell_chain [R] [M]

• spell_elixir [R] [M]

• spell_learn_spell [R] [M]

• spell_proc_event [R] [M]

• spell_script_target [R]

• spell_scripts [R]

• spell_target_position [R]

• spell_threat [R] [M]

• transports

• uptime