Mangosdb_struct

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

(Reloadable) – Reloadable in-game with the .reload command.
(CMaNGOS) – CMaNGOS table. These tables are either used by MaNGOS internally, or they are maintained by the CMaNGOS team. Either way, the DB teams do not touch them.
(ScriptLibrary) – Script library tables. These tables are maintained by script library projects (such as ScriptDev2). The DB teams do not touch them.

• achievement_criteria_requirement

• achievement_reward

• areatrigger_involvedrelation (Reloadable)

• areatrigger_tavern (Reloadable)

• areatrigger_teleport (Reloadable)

• battleground_events

• battleground_template

• battlemaster_entry

• command (Reloadable) (CMaNGOS)

• conditions

• creature

• creature_addon

• creature_ai_scripts (Reloadable)

• creature_ai_summons (Reloadable)

• creature_ai_texts (Reloadable)

• creature_battleground

• creature_equip_template

• creature_involvedrelation (Reloadable)

• creature_loot_template (Reloadable)

• creature_model_info

• creature_model_race

• creature_movement

• creature_movement_template

• creature_onkill_reputation

• creature_questrelation (Reloadable)

• Creature_Template

• creature_template_addon

• creature_linking_template

• creature_template_addon

• creature_template_classlevelstats

• creature_template_spells

• db_script_string

• db_version

• dbscripts (Reloadable)

• disenchant_loot_template (Reloadable)

• exploration_basexp

• fishing_loot_template (Reloadable)

• game_event

• game_event_creature

• game_event_creature_data

• game_event_gameobject

• game_event_mail

• game_event_quest

• game_graveyard_zone (Reloadable)

• game_tele

• game_weather

• gameobject

• gameobject_addon

• gameobject_battleground

• gameobject_involvedrelation (Reloadable)

• gameobject_loot_template (Reloadable)

• gameobject_questrelation (Reloadable)

• gameobject_template

• gossip_menu (Reloadable)

• gossip_menu_option (Reloadable)

• instance_template

• item_convert

• item_enchantment_template

• item_expire_convert (CMaNGOS) (Reloadable)

• item_loot_template (Reloadable)

• item_required_target (Reloadable)

• item_template

• locales_creature

• locales_gameobject

• locales_item

• locales_npc_text

• locales_page_text

• locales_quest

• mail_level_reward (Reloadable)

• mail_loot_template (Reloadable)

• mangos_string

• milling_loot_template

• npc_gossip

• npc_spellclick_spells (Reloadable)

• npc_text

• npc_trainer

• npc_trainer_template

• npc_vendor

• npc_vendor_template

• page_text

• pet_levelstats

• pet_name_generation

• pickpocketing_loot_template (Reloadable)

• player_classlevelstats (CMaNGOS)

• player_levelstats (CMaNGOS)

• player_xp_for_level (CMaNGOS)

• playercreateinfo (CMaNGOS)

• playercreateinfo_action (CMaNGOS)

• playercreateinfo_item (CMaNGOS)

• playercreateinfo_spell (CMaNGOS)

• points_of_interest (Reloadable)

• pool_creature

• pool_creature_template

• pool_gameobject

• pool_gameobject_template

• pool_pool

• pool_template

• prospecting_loot_template (Reloadable)

• quest_poi (Reloadable)

• quest_poi_points (Reloadable)

• quest_template (Reloadable)

• reference_loot_template (Reloadable)

• reputation_reward_rate (Reloadable)

• reputation_spillover_template

• reserved_name (Reloadable)

• scripted_areatrigger (ScriptLibrary)

• scripted_event_id (ScriptLibrary)

• skill_discovery_template (Reloadable)

• skill_extra_item_template

• skill_fishing_base_level

• skinning_loot_template

• spell_affect (Reloadable) (CMaNGOS)

• spell_area (Reloadable)

• spell_bonus_data (Reloadable) (CMaNGOS)

• spell_chain (Reloadable) (CMaNGOS)

• spell_check (CMaNGOS)

• spell_elixir (Reloadable) (CMaNGOS)

• spell_learn_spell (Reloadable) (CMaNGOS)

• spell_loot_template (Reloadable)

• spell_pet_auras

• spell_proc_event (Reloadable) (CMaNGOS)

• spell_proc_item_enchant (Reloadable) (CMaNGOS)

• spell_script_target (Reloadable)

• spell_target_position (Reloadable)

• spell_template

• spell_threat (Reloadable) (CMaNGOS)

• transports

• vehicle_accessory

• world_template