DB:World

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

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

• access_requirement [R]

• achievement_criteria_data [R]

• achievement_reward [R]

• areatrigger_involvedrelation [R]

• areatrigger_scripts [S]

• areatrigger_tavern [R]

• areatrigger_teleport [R]

• autobroadcast [R]

• battleground_template [S]

• battlemaster_entry

• command [R] [S]

• conditions [R] [I]

• creature

• creature_addon

• creature_ai_scripts [R] [E]
• creature_ai_summons [R] [E]

• creature_ai_texts [R][E]

• creature_classlevelstats [S]

• 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: only one creature per command can be reloaded

• 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 [S]

• fishing_loot_template [R]

• gameobject

• gameobject_involvedrelation [R]

• gameobject_loot_template [R]

• gameobject_questrelation [R]

• gameobject_scripts [R]

• gameobject_template

• game_event

• 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_gossip

• game_event_npc_vendor

• game_event_pool

• game_event_prerequisite

• game_event_quest_condition

• game_graveyard_zone [R]

• game_tele [R]

• game_weather

• gossip_menu [R]

• gossip_menu_option [R] [S]

• gossip_scripts [R]

• instance_template

• item_enchantment_template [R]

• item_script_names [R]

• item_loot_template [R]

• item_set_names [R]

• item_template

• item_template_addon

• lfg_dungeon_encounters [R]

• 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_gossip [R] (Deprecated)

• npc_spellclick_spells [R]

• npc_text

• npc_trainer [R]

• npc_vendor [R]

• outdoorpvp_template

• page_text [R]

• pet_levelstats [S]

• pet_name_generation [S]

• pickpocketing_loot_template [R]

• playercreateinfo [S]

• playercreateinfo_action [S]

• playercreateinfo_item

• playercreateinfo_spell [S]

• playercreateinfo_spell_custom

• player_classlevelstats [S]

• player_levelstats [S]

• player_factionchange_achievement

• player_factionchange_items

• player_factionchange_reputations

• player_factionchange_spells

• player_xp_for_level [S]

• 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 [S]

• script_waypoint [S]

• season_linked_event [S]

• skill_discovery_template [R]

• skill_extra_item_template [R]

• skill_fishing_base_level [R]

• skinning_loot_template [R]

• smart_scripts [R]

• spelldifficulty_dbc [S]

• spell_area [R]

• spell_bonus_data [R] [S]

• spell_dbc [S]

• spell_enchant_proc_data [S]

• spell_group [S]

• spell_group_stack_rules [S]

• spell_learn_spell [R] [S]

• spell_linked_spell [R] [S]

• spell_loot_template [R]

• spell_pet_auras [R] [S]

• spell_proc_event [R] [S]

• spell_ranks [S]

• spell_required [R]

• spell_scripts [R]

• spell_script_names [S]

• spell_target_position [R]

• spell_threat [R] [S]

• transports

• trinity_string [R] [S]

• vehicle_accessory [S]

• vehicle_scaling_info [S]

• version

• waypoints

• waypoint_data [R]

• waypoint_scripts [R]

• Database Help - Bit Values and Phasing