DB:World

Database and Table Structures Updated to TrinityCore Revision XXX (xxx)

Client Patch Supported: 3.3.5a

This is the list of tables in the TrinityCore `world` database

[R] - Reloadable in-game with the .reload command.
[T] - These tables are maintained by the core team. Any table that is marked with a [T] should have the data in the Trinity Core repo. If it is NOT marked with a [T] then the data must go into TDB.
[E] - These are EAI tables

• access_requirement [R]

• achievement_criteria_data [R]

• achievement_dbc

• achievement_reward [R]

• areatrigger_involvedrelation [R]

• areatrigger_scripts [T]

• areatrigger_tavern [R]

• areatrigger_teleport [R]

• autobroadcast [R]

• battleground_template [T]

• battlemaster_entry

• command [R] [T]

• conditions [R] [I]

• creature

• creature_addon

• creature_ai_scripts [R] [E]

• creature_ai_summons [R] [E]

• creature_ai_texts [R] [E]

• creature_classlevelstats [T]

• creature_equip_template

• creature_formations

• creature_involvedrelation [R]

• creature_loot_template [R]

• creature_model_info

• creature_onkill_reputation [R]

• creature_questrelation [R]

• creature_template [R] note: enter creature entries separated by space

• creature_template_addon

• creature_text [R]

• creature_transport

• custom_texts [E]

• db_script_string

• disables [R]

• disenchant_loot_template [R]

• event_scripts [R]

• exploration_basexp [T]

• fishing_loot_template [R]

• game_event

• game_event_arena_seasons

• game_event_battleground_holiday

• game_event_condition

• game_event_creature

• game_event_creature_quest

• game_event_gameobject

• game_event_gameobject_quest

• game_event_model_equip

• game_event_npcflag

• game_event_npc_vendor

• game_event_pool

• game_event_prerequisite

• game_event_quest_condition

• game_event_seasonal_questrelation

• game_graveyard_zone [R]

• game_tele [R]

• game_weather

• gameobject

• gameobject_involvedrelation [R]

• gameobject_loot_template [R]

• gameobject_questrelation [R]

• gameobject_scripts [R]

• gameobject_template

• gossip_menu [R]

• gossip_menu_option [R] [T]

• instance_encounters

• instance_template

• item_enchantment_template [R]

• item_loot_template [R]

• item_set_names [R]

• item_template

• lfg_dungeon_rewards [R]

• linked_respawn [R]

• locales_achievement_reward [R]

• locales_creature [R]

• locales_gameobject [R]

• locales_item [R]

• locales_gossip_menu_option [R]

• locales_item_set_names [R]

• locales_npc_text [R]

• locales_page_text [R]

• locales_points_of_interest [R]

• locales_quest [R]

• mail_level_reward [R]

• mail_loot_template [R]

• milling_loot_template [R]

• npc_spellclick_spells [R]

• npc_text

• npc_trainer [R]

• npc_vendor [R]

• outdoorpvp_template

• page_text [R]

• pet_levelstats [T]

• pet_name_generation [T]

• pickpocketing_loot_template [R]

• player_classlevelstats [T]

• player_factionchange_achievement

• player_factionchange_items

• player_factionchange_reputations

• player_factionchange_spells

• player_levelstats [T]

• player_xp_for_level [T]

• playercreateinfo [T]

• playercreateinfo_action [T]

• playercreateinfo_item

• playercreateinfo_spell [T]

• playercreateinfo_spell_custom

• points_of_interest [R]

• pool_creature

• pool_gameobject

• pool_pool

• pool_quest

• pool_template

• prospecting_loot_template [R]

• quest_end_scripts [R]

• quest_poi [R]

• quest_poi_points [R]

• quest_start_scripts [R]

• quest_template [R]

• reference_loot_template [R]

• reputation_reward_rate [R]

• reputation_spillover_template [R]

• script_texts [T]

• script_waypoint [T]

• skill_discovery_template [R]

• skill_extra_item_template [R]

• skill_fishing_base_level [R]

• skinning_loot_template [R]

• smart_scripts [R]

• spell_area [R]

• spell_bonus_data [R] [T]

• spell_dbc [T]

• spell_enchant_proc_data [T]

• spell_group [T]

• spell_group_stack_rules [T]

• spell_learn_spell [R] [T]

• spell_linked_spell [R] [T]

• spell_loot_template [R]

• spell_pet_auras [R] [T]

• spell_proc [R] [?]

• spell_proc_event [R] [T]

• spell_ranks [T]

• spell_required [R]

• spell_script_names [T]

• spell_scripts [R]

• spell_target_position [R]

• spell_threat [R] [T]

• spelldifficulty_dbc [T]

• transports

• trinity_string [R] [T]

• vehicle_accessory [T]

• vehicle_template_accessory [T]

• version

• waypoint_data [R]

• waypoint_scripts [R]

• waypoints