From 1d26eec2e40a67cd3140bf5282c963b250d70e14 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Tue, 26 Feb 2019 23:12:08 +0100 Subject: DB: add indexes --- docs/database-world.md | 168 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 168 insertions(+) (limited to 'docs/database-world.md') diff --git a/docs/database-world.md b/docs/database-world.md index 9695590..b06c745 100644 --- a/docs/database-world.md +++ b/docs/database-world.md @@ -1 +1,169 @@ NOTE: the DB documentation is still a work in progress. We need your help to make it better, please read [this](https://github.com/azerothcore/wiki/issues/11). + +- [access_requirement](access_requirement.md) +- [achievement_criteria_data](achievement_criteria_data.md) +- [achievement_dbc](achievement_dbc.md) +- [achievement_reward](achievement_reward.md) +- [achievement_reward_locale](achievement_reward_locale.md) +- [areatrigger](areatrigger.md) +- [areatrigger_involvedrelation](areatrigger_involvedrelation.md) +- [areatrigger_scripts](areatrigger_scripts.md) +- [areatrigger_tavern](areatrigger_tavern.md) +- [areatrigger_teleport](areatrigger_teleport.md) +- [battleground_template](battleground_template.md) +- [battlemaster_entry](battlemaster_entry.md) +- [broadcast_text](broadcast_text.md) +- [broadcast_text_locale](broadcast_text_locale.md) +- [command](command.md) +- [conditions](conditions.md) +- [creature](creature.md) +- [creature_addon](creature_addon.md) +- [creature_classlevelstats](creature_classlevelstats.md) +- [creature_equip_template](creature_equip_template.md) +- [creature_formations](creature_formations.md) +- [creature_loot_template](creature_loot_template.md) +- [creature_model_info](creature_model_info.md) +- [creature_onkill_reputation](creature_onkill_reputation.md) +- [creature_questender](creature_questender.md) +- [creature_questitem](creature_questitem.md) +- [creature_queststarter](creature_queststarter.md) +- [creature_summon_groups](creature_summon_groups.md) +- [creature_template](creature_template.md) +- [creature_template_addon](creature_template_addon.md) +- [creature_template_locale](creature_template_locale.md) +- [creature_text](creature_text.md) +- [creature_text_locale](creature_text_locale.md) +- [disables](disables.md) +- [disenchant_loot_template](disenchant_loot_template.md) +- [event_scripts](event_scripts.md) +- [exploration_basexp](exploration_basexp.md) +- [fishing_loot_template](fishing_loot_template.md) +- [game_event](game_event.md) +- [game_event_arena_seasons](game_event_arena_seasons.md) +- [game_event_battleground_holiday](game_event_battleground_holiday.md) +- [game_event_condition](game_event_condition.md) +- [game_event_creature](game_event_creature.md) +- [game_event_creature_quest](game_event_creature_quest.md) +- [game_event_gameobject](game_event_gameobject.md) +- [game_event_gameobject_quest](game_event_gameobject_quest.md) +- [game_event_model_equip](game_event_model_equip.md) +- [game_event_npc_vendor](game_event_npc_vendor.md) +- [game_event_npcflag](game_event_npcflag.md) +- [game_event_pool](game_event_pool.md) +- [game_event_prerequisite](game_event_prerequisite.md) +- [game_event_quest_condition](game_event_quest_condition.md) +- [game_event_seasonal_questrelation](game_event_seasonal_questrelation.md) +- [game_graveyard](game_graveyard.md) +- [game_graveyard_zone](game_graveyard_zone.md) +- [game_tele](game_tele.md) +- [game_weather](game_weather.md) +- [gameobject](gameobject.md) +- [gameobject_addon](gameobject_addon.md) +- [gameobject_loot_template](gameobject_loot_template.md) +- [gameobject_questender](gameobject_questender.md) +- [gameobject_questitem](gameobject_questitem.md) +- [gameobject_queststarter](gameobject_queststarter.md) +- [gameobject_template](gameobject_template.md) +- [gameobject_template_addon](gameobject_template_addon.md) +- [gameobject_template_locale](gameobject_template_locale.md) +- [gossip_menu](gossip_menu.md) +- [gossip_menu_option](gossip_menu_option.md) +- [gossip_menu_option_locale](gossip_menu_option_locale.md) +- [holiday_dates](holiday_dates.md) +- [instance_encounters](instance_encounters.md) +- [instance_template](instance_template.md) +- [item_enchantment_template](item_enchantment_template.md) +- [item_loot_template](item_loot_template.md) +- [item_set_names](item_set_names.md) +- [item_set_names_locale](item_set_names_locale.md) +- [item_template](item_template.md) +- [item_template_locale](item_template_locale.md) +- [lfg_dungeon_rewards](lfg_dungeon_rewards.md) +- [lfg_dungeon_template](lfg_dungeon_template.md) +- [linked_respawn](linked_respawn.md) +- [mail_level_reward](mail_level_reward.md) +- [mail_loot_template](mail_loot_template.md) +- [milling_loot_template](milling_loot_template.md) +- [npc_spellclick_spells](npc_spellclick_spells.md) +- [npc_text](npc_text.md) +- [npc_text_locale](npc_text_locale.md) +- [npc_trainer](npc_trainer.md) +- [npc_vendor](npc_vendor.md) +- [outdoorpvp_template](outdoorpvp_template.md) +- [page_text](page_text.md) +- [page_text_locale](page_text_locale.md) +- [pet_levelstats](pet_levelstats.md) +- [pet_name_generation](pet_name_generation.md) +- [pickpocketing_loot_template](pickpocketing_loot_template.md) +- [player_classlevelstats](player_classlevelstats.md) +- [player_factionchange_achievement](player_factionchange_achievement.md) +- [player_factionchange_items](player_factionchange_items.md) +- [player_factionchange_quests](player_factionchange_quests.md) +- [player_factionchange_reputations](player_factionchange_reputations.md) +- [player_factionchange_spells](player_factionchange_spells.md) +- [player_factionchange_titles](player_factionchange_titles.md) +- [player_levelstats](player_levelstats.md) +- [player_xp_for_level](player_xp_for_level.md) +- [playercreateinfo](playercreateinfo.md) +- [playercreateinfo_action](playercreateinfo_action.md) +- [playercreateinfo_item](playercreateinfo_item.md) +- [playercreateinfo_spell](playercreateinfo_spell.md) +- [playercreateinfo_spell_custom](playercreateinfo_spell_custom.md) +- [points_of_interest](points_of_interest.md) +- [points_of_interest_locale](points_of_interest_locale.md) +- [pool_creature](pool_creature.md) +- [pool_gameobject](pool_gameobject.md) +- [pool_pool](pool_pool.md) +- [pool_quest](pool_quest.md) +- [pool_template](pool_template.md) +- [prospecting_loot_template](prospecting_loot_template.md) +- [quest_details](quest_details.md) +- [quest_mail_sender](quest_mail_sender.md) +- [quest_offer_reward](quest_offer_reward.md) +- [quest_offer_reward_locale](quest_offer_reward_locale.md) +- [quest_poi](quest_poi.md) +- [quest_poi_points](quest_poi_points.md) +- [quest_request_items](quest_request_items.md) +- [quest_request_items_locale](quest_request_items_locale.md) +- [quest_template](quest_template.md) +- [quest_template_addon](quest_template_addon.md) +- [quest_template_locale](quest_template_locale.md) +- [reference_loot_template](reference_loot_template.md) +- [reputation_reward_rate](reputation_reward_rate.md) +- [reputation_spillover_template](reputation_spillover_template.md) +- [script_waypoint](script_waypoint.md) +- [skill_discovery_template](skill_discovery_template.md) +- [skill_extra_item_template](skill_extra_item_template.md) +- [skill_fishing_base_level](skill_fishing_base_level.md) +- [skinning_loot_template](skinning_loot_template.md) +- [smart_scripts](smart_scripts.md) +- [spell_area](spell_area.md) +- [spell_bonus_data](spell_bonus_data.md) +- [spell_custom_attr](spell_custom_attr.md) +- [spell_dbc](spell_dbc.md) +- [spell_enchant_proc_data](spell_enchant_proc_data.md) +- [spell_group](spell_group.md) +- [spell_group_stack_rules](spell_group_stack_rules.md) +- [spell_linked_spell](spell_linked_spell.md) +- [spell_loot_template](spell_loot_template.md) +- [spell_mixology](spell_mixology.md) +- [spell_pet_auras](spell_pet_auras.md) +- [spell_proc](spell_proc.md) +- [spell_proc_event](spell_proc_event.md) +- [spell_ranks](spell_ranks.md) +- [spell_required](spell_required.md) +- [spell_script_names](spell_script_names.md) +- [spell_scripts](spell_scripts.md) +- [spell_target_position](spell_target_position.md) +- [spell_threat](spell_threat.md) +- [spelldifficulty_dbc](spelldifficulty_dbc.md) +- [transports](transports.md) +- [trinity_string](trinity_string.md) +- [vehicle_accessory](vehicle_accessory.md) +- [vehicle_template_accessory](vehicle_template_accessory.md) +- [version](version.md) +- [version_db_world](version_db_world.md) +- [warden_checks](warden_checks.md) +- [waypoint_data](waypoint_data.md) +- [waypoint_scripts](waypoint_scripts.md) +- [waypoints](waypoints.md) -- cgit