Список таблиц
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) (Новая страница: «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. E…») |
NeatElves (Обсуждение | вклад) |
||
(95 промежуточных версий не показаны.) | |||
Строка 1: | Строка 1: | ||
- | + | <big>'''Описания структур таблиц базы данных 'mangos' '''</big> | |
- | + | ||
- | + | [R] - Таблицы можно перегружать из игры, введя в консоли команду .reload имя_таблицы | |
- | achievement_reward | + | |
- | areatrigger_involvedrelation [R] | + | [M] - MaNGOS таблицы. Данные таблицы заполняются разработчиками ядра MaNGOS. Команда разработчиков YTDB не заполняет данные таблицы. |
- | + | ||
- | areatrigger_tavern [R] | + | [S] - Таблицы библиотеки скриптов. Данные таблицы заполняются разработчиками скриптов(ScriptDev2). Команда разработчиков YTDB не заполняет данные таблицы. |
- | areatrigger_teleport [R] | + | |
- | battleground_events | + | |
- | battleground_template | + | * [[achievement_criteria_requirement]] [R] |
- | battlemaster_entry | + | |
- | command [R] [M] | + | * [[achievement_reward]] [R] |
- | creature | + | |
- | creature_ai_scripts [R] | + | * [[areatrigger_involvedrelation]] [R] |
- | creature_ai_summons [R] | + | |
- | creature_ai_texts [R] | + | * [[areatrigger_tavern]] [R] |
- | + | ||
- | creature_battleground | + | * [[areatrigger_teleport]] [R] |
- | creature_equip_template | + | |
- | creature_involvedrelation [R] | + | * [[area_group_template]] |
- | creature_loot_template [R] | + | |
- | creature_model_info | + | * [[battleground_events]] |
- | creature_movement | + | |
- | creature_onkill_reputation | + | * [[battleground_template]] |
- | creature_questrelation [R] | + | |
- | + | * [[battlemaster_entry]] | |
- | creature_template | + | |
- | creature_template_addon | + | * [[broadcast_text]] |
- | + | ||
- | + | * [[broadcast_text_locale]] | |
- | + | ||
- | + | * [[command]] [R] [M] | |
- | + | ||
- | + | * [[conditions]] [R] | |
- | + | ||
- | + | * [[creature]] | |
- | + | ||
- | + | * [[creature_addon]] | |
- | + | ||
- | + | * [[Event_AI|creature_ai_scripts]] [R] | |
- | + | ||
- | + | * [[creature_ai_summons]] [R] | |
- | + | ||
- | gameobject | + | * [[Eventai_texts|creature_ai_texts]] [R] |
- | gameobject_battleground | + | |
- | gameobject_involvedrelation [R] | + | * [[creature_battleground]] [R] |
- | gameobject_loot_template [R] | + | |
- | gameobject_questrelation [R] | + | * [[creature_conditional_spawn]] |
- | + | ||
- | + | * [[creature_cooldowns]] | |
- | + | ||
- | instance_template | + | * [[creature_equip_template]] |
- | item_enchantment_template | + | |
- | item_loot_template [R] | + | * [[creature_involvedrelation]] [R] |
- | item_required_target [R] | + | |
- | item_template | + | * [[creature_linking]] |
- | locales_creature | + | |
- | locales_gameobject | + | * [[creature_linking_template]] |
- | locales_item | + | |
- | locales_npc_text | + | * [[creature_loot_template]] [R] |
- | locales_page_text | + | |
- | locales_quest | + | * [[creature_model_info]] |
- | mangos_string | + | |
- | milling_loot_template | + | * [[creature_model_race]] |
- | npc_gossip | + | |
- | + | * [[creature_movement]] | |
- | + | ||
- | npc_spellclick_spells [R] | + | * [[creature_movement_template]] |
- | npc_text | + | |
- | npc_trainer | + | * [[creature_onkill_reputation]] |
- | npc_vendor | + | |
- | page_text | + | * [[creature_questrelation]] [R] |
- | pet_levelstats | + | |
- | pet_name_generation | + | * [[creature_spawn_entry]] |
- | pickpocketing_loot_template [R] | + | |
- | + | * [[creature_template]] | |
- | + | ||
- | + | * [[creature_template_addon]] | |
- | + | ||
- | + | * [[creature_template_classlevelstats]] [R] | |
- | + | ||
- | pool_creature | + | * [[creature_template_spells]] |
- | pool_gameobject | + | |
- | pool_template | + | * [[custom_texts]] [S] |
- | prospecting_loot_template [R] | + | |
- | + | * [[dbscripts_on_creature_death]] [R] | |
- | + | ||
- | + | * [[dbscripts_on_creature_movement]] [R] | |
- | quest_template [R] | + | |
- | reference_loot_template [R] | + | * [[dbscripts_on_event]] [R] |
- | reserved_name [R] | + | |
- | skill_discovery_template [R] | + | * [[dbscripts_on_gossip]] [R] |
- | skill_extra_item_template | + | |
- | skill_fishing_base_level | + | * [[dbscripts_on_go_template_use]] [R] |
- | + | ||
- | + | * [[dbscripts_on_go_use]] [R] | |
- | spell_area [R] | + | |
- | spell_bonus_data [M] | + | * [[dbscripts_on_quest_end]] [R] |
- | spell_chain [R] [M] | + | |
- | + | * [[dbscripts_on_quest_start]] [R] | |
- | spell_elixir [R] [M] | + | |
- | spell_learn_spell [R] [M] | + | * [[dbscripts_on_relay]] [R] |
- | spell_loot_template [R] | + | |
- | spell_proc_event [R] [M] | + | * [[dbscripts_on_spell]] [R] |
- | + | ||
- | + | * [[dbscript_random_templates]] | |
- | spell_target_position [R] | + | |
- | spell_threat [R] [M] | + | * [[dbscript_string]] [R] |
- | transports | + | |
+ | * [[db_version]] | ||
+ | |||
+ | * [[db_version_ytdb]] [для базы данных ytdb] | ||
+ | |||
+ | * [[disenchant_loot_template]] [R] | ||
+ | |||
+ | * [[exploration_basexp]] | ||
+ | |||
+ | * [[fishing_loot_template]] [R] | ||
+ | |||
+ | * [[gameobject]] | ||
+ | |||
+ | * [[gameobject_addon]] | ||
+ | |||
+ | * [[gameobject_battleground]] [R] | ||
+ | |||
+ | * [[gameobject_involvedrelation]] [R] | ||
+ | |||
+ | * [[gameobject_loot_template]] [R] | ||
+ | |||
+ | * [[gameobject_questrelation]] [R] | ||
+ | |||
+ | * [[gameobject_template]] | ||
+ | |||
+ | * [[game_event]] | ||
+ | |||
+ | * [[game_event_creature]] | ||
+ | |||
+ | * [[game_event_creature_data]] | ||
+ | |||
+ | * [[game_event_gameobject]] | ||
+ | |||
+ | * [[game_event_mail]] | ||
+ | |||
+ | * [[game_event_quest]] | ||
+ | |||
+ | * [[game_event_time]] | ||
+ | |||
+ | * [[game_graveyard_zone]] [R] | ||
+ | |||
+ | * [[game_tele]] [R] | ||
+ | |||
+ | * [[game_weather]] | ||
+ | |||
+ | * [[gossip_menu]] [R] | ||
+ | |||
+ | * [[gossip_menu_option]] [R] | ||
+ | |||
+ | * [[gossip_text]] [S] | ||
+ | |||
+ | * [[instance_dungeon_encounter]] | ||
+ | |||
+ | * [[instance_encounters]] [M] | ||
+ | |||
+ | * [[instance_template]] | ||
+ | |||
+ | * [[item_convert]] [R] | ||
+ | |||
+ | * [[item_enchantment_template]] [R] | ||
+ | |||
+ | * [[item_expire_convert]] | ||
+ | |||
+ | * [[item_loot_template]] [R] | ||
+ | |||
+ | * [[item_required_target]] [R] | ||
+ | |||
+ | * [[item_template]] | ||
+ | |||
+ | * [[locales_achievement_reward]] [R] | ||
+ | |||
+ | * [[locales_areatrigger_teleport]] | ||
+ | |||
+ | * [[locales_creature]] [R] | ||
+ | |||
+ | * [[locales_gameobject]] [R] | ||
+ | |||
+ | * [[locales_gossip_menu_option]] [R] | ||
+ | |||
+ | * [[locales_item]] [R] | ||
+ | |||
+ | * [[locales_npc_text]] [R] | ||
+ | |||
+ | * [[locales_page_text]] [R] | ||
+ | |||
+ | * [[locales_points_of_interest]] [R] | ||
+ | |||
+ | * [[locales_quest]] [R] | ||
+ | |||
+ | * [[locales_questgiver_greeting]] [R] | ||
+ | |||
+ | * [[locales_trainer_greeting]] [R] | ||
+ | |||
+ | * [[mail_level_reward]] [R] | ||
+ | |||
+ | * [[mail_loot_template]] [R] | ||
+ | |||
+ | * [[mangos_string]] [R] | ||
+ | |||
+ | * [[milling_loot_template]] [R] | ||
+ | |||
+ | * [[npc_gossip]] [R] | ||
+ | |||
+ | * [[npc_spellclick_spells]] [R] | ||
+ | |||
+ | * [[npc_text]] [R] | ||
+ | |||
+ | * [[npc_text_broadcast_text]] | ||
+ | |||
+ | * [[npc_trainer]] [R] | ||
+ | |||
+ | * [[npc_trainer_template]] [R] | ||
+ | |||
+ | * [[npc_vendor]] [R] | ||
+ | |||
+ | * [[npc_vendor_template]] [R] | ||
+ | |||
+ | * [[page_text]] [R] | ||
+ | |||
+ | * [[pet_levelstats]] | ||
+ | |||
+ | * [[pet_name_generation]] [M] | ||
+ | |||
+ | * [[pickpocketing_loot_template]] [R] | ||
+ | |||
+ | * [[playercreateinfo]] [M] | ||
+ | |||
+ | * [[playercreateinfo_action]] [M] | ||
+ | |||
+ | * [[playercreateinfo_item]] [M] | ||
+ | |||
+ | * [[playercreateinfo_skills]] [M] | ||
+ | |||
+ | * [[playercreateinfo_spell]] [M] | ||
+ | |||
+ | * [[player_classlevelstats]] [M] | ||
+ | |||
+ | * [[player_levelstats]] [M] | ||
+ | |||
+ | * [[player_xp_for_level]] | ||
+ | |||
+ | * [[points_of_interest]] [R] | ||
+ | |||
+ | * [[pool_creature]] | ||
+ | |||
+ | * [[pool_creature_template]] | ||
+ | |||
+ | * [[pool_gameobject]] | ||
+ | |||
+ | * [[pool_gameobject_template]] | ||
+ | |||
+ | * [[pool_pool]] | ||
+ | |||
+ | * [[pool_template]] | ||
+ | |||
+ | * [[prospecting_loot_template]] [R] | ||
+ | |||
+ | * [[questgiver_greeting]] [R] | ||
+ | |||
+ | * [[quest_poi]] [R] | ||
+ | |||
+ | * [[quest_poi_points]] [R] | ||
+ | |||
+ | * [[quest_template]] [R] | ||
+ | |||
+ | * [[reference_loot_template]] [R] | ||
+ | |||
+ | * [[reference_loot_template_names]] | ||
+ | |||
+ | * [[reputation_reward_rate]] [R] | ||
+ | |||
+ | * [[reputation_spillover_template]] [R] | ||
+ | |||
+ | * [[reserved_name]] [R] | ||
+ | |||
+ | * [[scripted_areatrigger]] [S] | ||
+ | |||
+ | * [[scripted_event_id]] [S] | ||
+ | |||
+ | * [[script_texts]] [S] | ||
+ | |||
+ | * [[script_waypoint]] [S] | ||
+ | |||
+ | * [[skill_discovery_template]] [R] | ||
+ | |||
+ | * [[skill_extra_item_template]] [R] | ||
+ | |||
+ | * [[skill_fishing_base_level]] [R] | ||
+ | |||
+ | * [[skinning_loot_template]] [R] | ||
+ | |||
+ | * [[spam_records]] | ||
+ | |||
+ | * [[spell_area]] [R] | ||
+ | |||
+ | * [[spell_bonus_data]] [R] [M] | ||
+ | |||
+ | * [[spell_chain]] [R] [M] | ||
+ | |||
+ | * [[spell_cone]] [M] | ||
+ | |||
+ | * [[spell_elixir]] [R] [M] | ||
+ | |||
+ | * [[spell_learn_spell]] [R] [M] | ||
+ | |||
+ | * [[spell_loot_template]] [R] | ||
+ | |||
+ | * [[spell_pet_auras]] [R] | ||
+ | |||
+ | * [[spell_proc_event]] [R] [M] | ||
+ | |||
+ | * [[spell_proc_item_enchant]] [R] [M] | ||
+ | |||
+ | * [[spell_script_target]] [R] | ||
+ | |||
+ | * [[spell_target_position]] [R] | ||
+ | |||
+ | * [[spell_template]] | ||
+ | |||
+ | * [[spell_threat]] [R] [M] | ||
+ | |||
+ | * [[taxi_shortcuts]] | ||
+ | |||
+ | * [[trainer_greeting]] [R] | ||
+ | |||
+ | * [[transports]] | ||
+ | |||
+ | * [[vehicle_accessory]] | ||
+ | |||
+ | * [[world_safe_locs]] | ||
+ | |||
+ | * [[world_template]] [S] |
Текущая версия на 07:07, 5 февраля 2020
Описания структур таблиц базы данных 'mangos'
[R] - Таблицы можно перегружать из игры, введя в консоли команду .reload имя_таблицы
[M] - MaNGOS таблицы. Данные таблицы заполняются разработчиками ядра MaNGOS. Команда разработчиков YTDB не заполняет данные таблицы.
[S] - Таблицы библиотеки скриптов. Данные таблицы заполняются разработчиками скриптов(ScriptDev2). Команда разработчиков YTDB не заполняет данные таблицы.
- command [R] [M]
- conditions [R]
- custom_texts [S]
- dbscript_string [R]
- db_version_ytdb [для базы данных ytdb]
- game_tele [R]
- gossip_menu [R]
- gossip_text [S]
- item_convert [R]
- locales_creature [R]
- locales_item [R]
- locales_npc_text [R]
- locales_quest [R]
- mangos_string [R]
- npc_gossip [R]
- npc_text [R]
- npc_trainer [R]
- npc_vendor [R]
- page_text [R]
- playercreateinfo [M]
- quest_poi [R]
- quest_poi_points [R]
- quest_template [R]
- reserved_name [R]
- script_texts [S]
- script_waypoint [S]
- spell_area [R]
- spell_bonus_data [R] [M]
- spell_chain [R] [M]
- spell_cone [M]
- spell_elixir [R] [M]
- spell_learn_spell [R] [M]
- spell_pet_auras [R]
- spell_proc_event [R] [M]
- spell_proc_item_enchant [R] [M]
- spell_threat [R] [M]
- trainer_greeting [R]
- world_template [S]