DB/Hotfixes: First batch of wotlk_classic hotfixes

1 files changed, 436 insertions, 0 deletions

diff --git a/sql/updates/hotfixes/3.4.x/2023_11_23_02_hotfixes.sql b/sql/updates/hotfixes/3.4.x/2023_11_23_02_hotfixes.sql
new file mode 100644
index 00000000000..d3d38898cb3
--- /dev/null
+++ b/sql/updates/hotfixes/3.4.x/2023_11_23_02_hotfixes.sql
@@ -0,0 +1,436 @@
+DELETE FROM `achievement`;
+DELETE FROM `achievement_category`;
+DELETE FROM `achievement_category_locale`;
+DELETE FROM `achievement_locale`;
+DELETE FROM `adventure_journal`;
+DELETE FROM `adventure_journal_locale`;
+DELETE FROM `adventure_map_poi`;
+DELETE FROM `adventure_map_poi_locale`;
+DELETE FROM `anim_kit`;
+DELETE FROM `animation_data`;
+DELETE FROM `area_group_member`;
+DELETE FROM `area_table`;
+DELETE FROM `area_table_locale`;
+DELETE FROM `area_trigger`;
+DELETE FROM `area_trigger_locale`;
+DELETE FROM `armor_location`;
+DELETE FROM `artifact`;
+DELETE FROM `artifact_appearance`;
+DELETE FROM `artifact_appearance_locale`;
+DELETE FROM `artifact_appearance_set`;
+DELETE FROM `artifact_appearance_set_locale`;
+DELETE FROM `artifact_category`;
+DELETE FROM `artifact_locale`;
+DELETE FROM `artifact_power`;
+DELETE FROM `artifact_power_link`;
+DELETE FROM `artifact_power_picker`;
+DELETE FROM `artifact_power_rank`;
+DELETE FROM `artifact_quest_xp`;
+DELETE FROM `artifact_tier`;
+DELETE FROM `artifact_unlock`;
+DELETE FROM `auction_house`;
+DELETE FROM `auction_house_locale`;
+DELETE FROM `azerite_empowered_item`;
+DELETE FROM `azerite_essence`;
+DELETE FROM `azerite_essence_locale`;
+DELETE FROM `azerite_essence_power`;
+DELETE FROM `azerite_essence_power_locale`;
+DELETE FROM `azerite_item`;
+DELETE FROM `azerite_item_milestone_power`;
+DELETE FROM `azerite_knowledge_multiplier`;
+DELETE FROM `azerite_level_info`;
+DELETE FROM `azerite_power`;
+DELETE FROM `azerite_power_set_member`;
+DELETE FROM `azerite_tier_unlock`;
+DELETE FROM `azerite_tier_unlock_set`;
+DELETE FROM `azerite_unlock_mapping`;
+DELETE FROM `bank_bag_slot_prices`;
+DELETE FROM `banned_addons`;
+DELETE FROM `barber_shop_style`;
+DELETE FROM `barber_shop_style_locale`;
+DELETE FROM `battle_pet_ability`;
+DELETE FROM `battle_pet_ability_locale`;
+DELETE FROM `battle_pet_breed_quality`;
+DELETE FROM `battle_pet_breed_state`;
+DELETE FROM `battle_pet_species`;
+DELETE FROM `battle_pet_species_locale`;
+DELETE FROM `battle_pet_species_state`;
+DELETE FROM `battlemaster_list`;
+DELETE FROM `battlemaster_list_locale`;
+DELETE FROM `broadcast_text`;
+DELETE FROM `broadcast_text_duration`;
+DELETE FROM `broadcast_text_locale`;
+DELETE FROM `cfg_categories`;
+DELETE FROM `cfg_categories_locale`;
+DELETE FROM `cfg_regions`;
+DELETE FROM `challenge_mode_item_bonus_override`;
+DELETE FROM `char_titles`;
+DELETE FROM `char_titles_locale`;
+DELETE FROM `character_loadout`;
+DELETE FROM `character_loadout_item`;
+DELETE FROM `chat_channels`;
+DELETE FROM `chat_channels_locale`;
+DELETE FROM `chr_class_ui_display`;
+DELETE FROM `chr_classes`;
+DELETE FROM `chr_classes_locale`;
+DELETE FROM `chr_classes_x_power_types`;
+DELETE FROM `chr_customization_choice`;
+DELETE FROM `chr_customization_choice_locale`;
+DELETE FROM `chr_customization_display_info`;
+DELETE FROM `chr_customization_element`;
+DELETE FROM `chr_customization_option`;
+DELETE FROM `chr_customization_option_locale`;
+DELETE FROM `chr_customization_req`;
+DELETE FROM `chr_customization_req_choice`;
+DELETE FROM `chr_customization_req_locale`;
+DELETE FROM `chr_model`;
+DELETE FROM `chr_race_x_chr_model`;
+DELETE FROM `chr_races`;
+DELETE FROM `chr_races_locale`;
+DELETE FROM `chr_specialization`;
+DELETE FROM `chr_specialization_locale`;
+DELETE FROM `cinematic_camera`;
+DELETE FROM `cinematic_sequences`;
+DELETE FROM `conditional_chr_model`;
+DELETE FROM `conditional_content_tuning`;
+DELETE FROM `content_tuning`;
+DELETE FROM `content_tuning_x_expected`;
+DELETE FROM `content_tuning_x_label`;
+DELETE FROM `conversation_line`;
+DELETE FROM `corruption_effects`;
+DELETE FROM `creature`;
+DELETE FROM `creature_difficulty`;
+DELETE FROM `creature_display_info`;
+DELETE FROM `creature_display_info_extra`;
+DELETE FROM `creature_family`;
+DELETE FROM `creature_family_locale`;
+DELETE FROM `creature_model_data`;
+DELETE FROM `creature_type`;
+DELETE FROM `creature_type_locale`;
+DELETE FROM `criteria`;
+DELETE FROM `criteria_tree`;
+DELETE FROM `criteria_tree_locale`;
+DELETE FROM `currency_container`;
+DELETE FROM `currency_container_locale`;
+DELETE FROM `currency_types`;
+DELETE FROM `currency_types_locale`;
+DELETE FROM `curve`;
+DELETE FROM `curve_point`;
+DELETE FROM `destructible_model_data`;
+DELETE FROM `difficulty`;
+DELETE FROM `difficulty_locale`;
+DELETE FROM `dungeon_encounter`;
+DELETE FROM `dungeon_encounter_locale`;
+DELETE FROM `durability_costs`;
+DELETE FROM `durability_quality`;
+DELETE FROM `emotes`;
+DELETE FROM `emotes_text`;
+DELETE FROM `emotes_text_sound`;
+DELETE FROM `expected_stat`;
+DELETE FROM `expected_stat_mod`;
+DELETE FROM `faction`;
+DELETE FROM `faction_locale`;
+DELETE FROM `faction_template`;
+DELETE FROM `friendship_rep_reaction`;
+DELETE FROM `friendship_rep_reaction_locale`;
+DELETE FROM `friendship_reputation`;
+DELETE FROM `friendship_reputation_locale`;
+DELETE FROM `gameobject_art_kit`;
+DELETE FROM `gameobject_display_info`;
+DELETE FROM `gameobjects`;
+DELETE FROM `gameobjects_locale`;
+DELETE FROM `garr_ability`;
+DELETE FROM `garr_ability_locale`;
+DELETE FROM `garr_building`;
+DELETE FROM `garr_building_locale`;
+DELETE FROM `garr_building_plot_inst`;
+DELETE FROM `garr_class_spec`;
+DELETE FROM `garr_class_spec_locale`;
+DELETE FROM `garr_follower`;
+DELETE FROM `garr_follower_locale`;
+DELETE FROM `garr_follower_x_ability`;
+DELETE FROM `garr_mission`;
+DELETE FROM `garr_mission_locale`;
+DELETE FROM `garr_plot`;
+DELETE FROM `garr_plot_building`;
+DELETE FROM `garr_plot_instance`;
+DELETE FROM `garr_site_level`;
+DELETE FROM `garr_site_level_plot_inst`;
+DELETE FROM `garr_talent_tree`;
+DELETE FROM `garr_talent_tree_locale`;
+DELETE FROM `gem_properties`;
+DELETE FROM `global_curve`;
+DELETE FROM `glyph_bindable_spell`;
+DELETE FROM `glyph_properties`;
+DELETE FROM `glyph_required_spec`;
+DELETE FROM `glyph_slot`;
+DELETE FROM `gossip_npc_option`;
+DELETE FROM `guild_color_background`;
+DELETE FROM `guild_color_border`;
+DELETE FROM `guild_color_emblem`;
+DELETE FROM `guild_perk_spells`;
+DELETE FROM `heirloom`;
+DELETE FROM `heirloom_locale`;
+DELETE FROM `holidays`;
+DELETE FROM `hotfix_blob`;
+DELETE FROM `hotfix_data`;
+DELETE FROM `hotfix_optional_data`;
+DELETE FROM `import_price_armor`;
+DELETE FROM `import_price_quality`;
+DELETE FROM `import_price_shield`;
+DELETE FROM `import_price_weapon`;
+DELETE FROM `item`;
+DELETE FROM `item_appearance`;
+DELETE FROM `item_armor_quality`;
+DELETE FROM `item_armor_shield`;
+DELETE FROM `item_armor_total`;
+DELETE FROM `item_bag_family`;
+DELETE FROM `item_bag_family_locale`;
+DELETE FROM `item_bonus`;
+DELETE FROM `item_bonus_list_group_entry`;
+DELETE FROM `item_bonus_list_level_delta`;
+DELETE FROM `item_bonus_tree`;
+DELETE FROM `item_bonus_tree_node`;
+DELETE FROM `item_child_equipment`;
+DELETE FROM `item_class`;
+DELETE FROM `item_class_locale`;
+DELETE FROM `item_context_picker_entry`;
+DELETE FROM `item_currency_cost`;
+DELETE FROM `item_damage_ammo`;
+DELETE FROM `item_damage_one_hand`;
+DELETE FROM `item_damage_one_hand_caster`;
+DELETE FROM `item_damage_two_hand`;
+DELETE FROM `item_damage_two_hand_caster`;
+DELETE FROM `item_disenchant_loot`;
+DELETE FROM `item_effect`;
+DELETE FROM `item_extended_cost`;
+DELETE FROM `item_level_selector`;
+DELETE FROM `item_level_selector_quality`;
+DELETE FROM `item_level_selector_quality_set`;
+DELETE FROM `item_limit_category`;
+DELETE FROM `item_limit_category_condition`;
+DELETE FROM `item_limit_category_locale`;
+DELETE FROM `item_modified_appearance`;
+DELETE FROM `item_modified_appearance_extra`;
+DELETE FROM `item_name_description`;
+DELETE FROM `item_name_description_locale`;
+DELETE FROM `item_price_base`;
+DELETE FROM `item_search_name`;
+DELETE FROM `item_search_name_locale`;
+DELETE FROM `item_set`;
+DELETE FROM `item_set_locale`;
+DELETE FROM `item_set_spell`;
+DELETE FROM `item_sparse`;
+DELETE FROM `item_sparse_locale`;
+DELETE FROM `item_spec`;
+DELETE FROM `item_spec_override`;
+DELETE FROM `item_x_bonus_tree`;
+DELETE FROM `item_x_item_effect`;
+DELETE FROM `journal_encounter`;
+DELETE FROM `journal_encounter_locale`;
+DELETE FROM `journal_encounter_section`;
+DELETE FROM `journal_encounter_section_locale`;
+DELETE FROM `journal_instance`;
+DELETE FROM `journal_instance_locale`;
+DELETE FROM `journal_tier`;
+DELETE FROM `journal_tier_locale`;
+DELETE FROM `keychain`;
+DELETE FROM `keystone_affix`;
+DELETE FROM `keystone_affix_locale`;
+DELETE FROM `language_words`;
+DELETE FROM `languages`;
+DELETE FROM `languages_locale`;
+DELETE FROM `lfg_dungeons`;
+DELETE FROM `lfg_dungeons_locale`;
+DELETE FROM `light`;
+DELETE FROM `liquid_type`;
+DELETE FROM `lock`;
+DELETE FROM `mail_template`;
+DELETE FROM `mail_template_locale`;
+DELETE FROM `map`;
+DELETE FROM `map_challenge_mode`;
+DELETE FROM `map_challenge_mode_locale`;
+DELETE FROM `map_difficulty`;
+DELETE FROM `map_difficulty_locale`;
+DELETE FROM `map_difficulty_x_condition`;
+DELETE FROM `map_difficulty_x_condition_locale`;
+DELETE FROM `map_locale`;
+DELETE FROM `maw_power`;
+DELETE FROM `modifier_tree`;
+DELETE FROM `mount`;
+DELETE FROM `mount_capability`;
+DELETE FROM `mount_locale`;
+DELETE FROM `mount_type_x_capability`;
+DELETE FROM `mount_x_display`;
+DELETE FROM `movie`;
+DELETE FROM `mythic_plus_season`;
+DELETE FROM `name_gen`;
+DELETE FROM `names_profanity`;
+DELETE FROM `names_reserved`;
+DELETE FROM `names_reserved_locale`;
+DELETE FROM `num_talents_at_level`;
+DELETE FROM `override_spell_data`;
+DELETE FROM `paragon_reputation`;
+DELETE FROM `phase`;
+DELETE FROM `phase_x_phase_group`;
+DELETE FROM `player_condition`;
+DELETE FROM `player_condition_locale`;
+DELETE FROM `power_display`;
+DELETE FROM `power_type`;
+DELETE FROM `prestige_level_info`;
+DELETE FROM `prestige_level_info_locale`;
+DELETE FROM `pvp_difficulty`;
+DELETE FROM `pvp_item`;
+DELETE FROM `pvp_season`;
+DELETE FROM `pvp_talent`;
+DELETE FROM `pvp_talent_category`;
+DELETE FROM `pvp_talent_locale`;
+DELETE FROM `pvp_talent_slot_unlock`;
+DELETE FROM `pvp_tier`;
+DELETE FROM `pvp_tier_locale`;
+DELETE FROM `quest_faction_reward`;
+DELETE FROM `quest_info`;
+DELETE FROM `quest_info_locale`;
+DELETE FROM `quest_line_x_quest`;
+DELETE FROM `quest_money_reward`;
+DELETE FROM `quest_package_item`;
+DELETE FROM `quest_sort`;
+DELETE FROM `quest_sort_locale`;
+DELETE FROM `quest_v2`;
+DELETE FROM `quest_xp`;
+DELETE FROM `rand_prop_points`;
+DELETE FROM `reward_pack`;
+DELETE FROM `reward_pack_x_currency_type`;
+DELETE FROM `reward_pack_x_item`;
+DELETE FROM `scaling_stat_distribution`;
+DELETE FROM `scaling_stat_values`;
+DELETE FROM `scenario`;
+DELETE FROM `scenario_locale`;
+DELETE FROM `scenario_step`;
+DELETE FROM `scenario_step_locale`;
+DELETE FROM `scene_script`;
+DELETE FROM `scene_script_global_text`;
+DELETE FROM `scene_script_package`;
+DELETE FROM `scene_script_text`;
+DELETE FROM `server_messages`;
+DELETE FROM `server_messages_locale`;
+DELETE FROM `skill_line`;
+DELETE FROM `skill_line_ability`;
+DELETE FROM `skill_line_ability_locale`;
+DELETE FROM `skill_line_locale`;
+DELETE FROM `skill_line_x_trait_tree`;
+DELETE FROM `skill_race_class_info`;
+DELETE FROM `soulbind_conduit_rank`;
+DELETE FROM `sound_kit`;
+DELETE FROM `spec_set_member`;
+DELETE FROM `specialization_spells`;
+DELETE FROM `specialization_spells_locale`;
+DELETE FROM `spell_aura_options`;
+DELETE FROM `spell_aura_restrictions`;
+DELETE FROM `spell_cast_times`;
+DELETE FROM `spell_casting_requirements`;
+DELETE FROM `spell_categories`;
+DELETE FROM `spell_category`;
+DELETE FROM `spell_category_locale`;
+DELETE FROM `spell_class_options`;
+DELETE FROM `spell_cooldowns`;
+DELETE FROM `spell_duration`;
+DELETE FROM `spell_effect`;
+DELETE FROM `spell_equipped_items`;
+DELETE FROM `spell_focus_object`;
+DELETE FROM `spell_focus_object_locale`;
+DELETE FROM `spell_interrupts`;
+DELETE FROM `spell_item_enchantment`;
+DELETE FROM `spell_item_enchantment_condition`;
+DELETE FROM `spell_item_enchantment_locale`;
+DELETE FROM `spell_keybound_override`;
+DELETE FROM `spell_label`;
+DELETE FROM `spell_learn_spell`;
+DELETE FROM `spell_levels`;
+DELETE FROM `spell_misc`;
+DELETE FROM `spell_name`;
+DELETE FROM `spell_name_locale`;
+DELETE FROM `spell_power`;
+DELETE FROM `spell_power_difficulty`;
+DELETE FROM `spell_procs_per_minute`;
+DELETE FROM `spell_procs_per_minute_mod`;
+DELETE FROM `spell_radius`;
+DELETE FROM `spell_range`;
+DELETE FROM `spell_range_locale`;
+DELETE FROM `spell_reagents`;
+DELETE FROM `spell_reagents_currency`;
+DELETE FROM `spell_scaling`;
+DELETE FROM `spell_shapeshift`;
+DELETE FROM `spell_shapeshift_form`;
+DELETE FROM `spell_shapeshift_form_locale`;
+DELETE FROM `spell_target_restrictions`;
+DELETE FROM `spell_totems`;
+DELETE FROM `spell_visual`;
+DELETE FROM `spell_visual_effect_name`;
+DELETE FROM `spell_visual_kit`;
+DELETE FROM `spell_visual_missile`;
+DELETE FROM `spell_x_spell_visual`;
+DELETE FROM `summon_properties`;
+DELETE FROM `talent`;
+DELETE FROM `talent_locale`;
+DELETE FROM `talent_tab`;
+DELETE FROM `talent_tab_locale`;
+DELETE FROM `taxi_nodes`;
+DELETE FROM `taxi_nodes_locale`;
+DELETE FROM `taxi_path`;
+DELETE FROM `taxi_path_node`;
+DELETE FROM `totem_category`;
+DELETE FROM `totem_category_locale`;
+DELETE FROM `toy`;
+DELETE FROM `toy_locale`;
+DELETE FROM `trait_cond`;
+DELETE FROM `trait_cost`;
+DELETE FROM `trait_currency`;
+DELETE FROM `trait_currency_source`;
+DELETE FROM `trait_currency_source_locale`;
+DELETE FROM `trait_definition`;
+DELETE FROM `trait_definition_effect_points`;
+DELETE FROM `trait_definition_locale`;
+DELETE FROM `trait_edge`;
+DELETE FROM `trait_node`;
+DELETE FROM `trait_node_entry`;
+DELETE FROM `trait_node_entry_x_trait_cond`;
+DELETE FROM `trait_node_entry_x_trait_cost`;
+DELETE FROM `trait_node_group`;
+DELETE FROM `trait_node_group_x_trait_cond`;
+DELETE FROM `trait_node_group_x_trait_cost`;
+DELETE FROM `trait_node_group_x_trait_node`;
+DELETE FROM `trait_node_x_trait_cond`;
+DELETE FROM `trait_node_x_trait_cost`;
+DELETE FROM `trait_node_x_trait_node_entry`;
+DELETE FROM `trait_tree`;
+DELETE FROM `trait_tree_loadout`;
+DELETE FROM `trait_tree_loadout_entry`;
+DELETE FROM `trait_tree_x_trait_cost`;
+DELETE FROM `trait_tree_x_trait_currency`;
+DELETE FROM `transmog_holiday`;
+DELETE FROM `transmog_illusion`;
+DELETE FROM `transmog_set`;
+DELETE FROM `transmog_set_group`;
+DELETE FROM `transmog_set_group_locale`;
+DELETE FROM `transmog_set_item`;
+DELETE FROM `transmog_set_locale`;
+DELETE FROM `transport_animation`;
+DELETE FROM `transport_rotation`;
+DELETE FROM `ui_map`;
+DELETE FROM `ui_map_assignment`;
+DELETE FROM `ui_map_link`;
+DELETE FROM `ui_map_locale`;
+DELETE FROM `ui_map_x_map_art`;
+DELETE FROM `ui_splash_screen`;
+DELETE FROM `ui_splash_screen_locale`;
+DELETE FROM `unit_condition`;
+DELETE FROM `unit_power_bar`;
+DELETE FROM `unit_power_bar_locale`;
+DELETE FROM `vehicle`;
+DELETE FROM `vehicle_seat`;
+DELETE FROM `wmo_area_table`;
+DELETE FROM `wmo_area_table_locale`;
+DELETE FROM `world_effect`;
+DELETE FROM `world_map_overlay`;
+DELETE FROM `world_state_expression`;
\ No newline at end of file