Core/Misc: dropped several db2 storages which are empty/unused in classic and removed many unused opcode handlers and packet classes

1 files changed, 50 insertions, 0 deletions

diff --git a/sql/updates/hotfixes/cata_classic/2024_06_25_00_hotfixes.sql b/sql/updates/hotfixes/cata_classic/2024_06_25_00_hotfixes.sql
new file mode 100644
index 00000000000..913efdf3de5
--- /dev/null
+++ b/sql/updates/hotfixes/cata_classic/2024_06_25_00_hotfixes.sql
@@ -0,0 +1,50 @@
+DROP TABLE IF EXISTS `adventure_journal`;
+DROP TABLE IF EXISTS `adventure_journal_locale`;
+DROP TABLE IF EXISTS `adventure_map_poi`;
+DROP TABLE IF EXISTS `adventure_map_poi_locale`;
+DROP TABLE IF EXISTS `artifact`;
+DROP TABLE IF EXISTS `artifact_appearance`;
+DROP TABLE IF EXISTS `artifact_appearance_locale`;
+DROP TABLE IF EXISTS `artifact_appearance_set`;
+DROP TABLE IF EXISTS `artifact_appearance_set_locale`;
+DROP TABLE IF EXISTS `artifact_category`;
+DROP TABLE IF EXISTS `artifact_locale`;
+DROP TABLE IF EXISTS `artifact_power`;
+DROP TABLE IF EXISTS `artifact_power_link`;
+DROP TABLE IF EXISTS `artifact_power_picker`;
+DROP TABLE IF EXISTS `artifact_power_rank`;
+DROP TABLE IF EXISTS `artifact_quest_xp`;
+DROP TABLE IF EXISTS `artifact_tier`;
+DROP TABLE IF EXISTS `artifact_unlock`;
+DROP TABLE IF EXISTS `azerite_empowered_item`;
+DROP TABLE IF EXISTS `azerite_essence`;
+DROP TABLE IF EXISTS `azerite_essence_locale`;
+DROP TABLE IF EXISTS `azerite_essence_power`;
+DROP TABLE IF EXISTS `azerite_essence_power_locale`;
+DROP TABLE IF EXISTS `azerite_item`;
+DROP TABLE IF EXISTS `azerite_item_milestone_power`;
+DROP TABLE IF EXISTS `azerite_knowledge_multiplier`;
+DROP TABLE IF EXISTS `azerite_level_info`;
+DROP TABLE IF EXISTS `azerite_power`;
+DROP TABLE IF EXISTS `azerite_power_set_member`;
+DROP TABLE IF EXISTS `azerite_tier_unlock`;
+DROP TABLE IF EXISTS `azerite_tier_unlock_set`;
+DROP TABLE IF EXISTS `garr_ability`;
+DROP TABLE IF EXISTS `garr_ability_locale`;
+DROP TABLE IF EXISTS `garr_building`;
+DROP TABLE IF EXISTS `garr_building_locale`;
+DROP TABLE IF EXISTS `garr_building_plot_inst`;
+DROP TABLE IF EXISTS `garr_class_spec`;
+DROP TABLE IF EXISTS `garr_class_spec_locale`;
+DROP TABLE IF EXISTS `garr_follower`;
+DROP TABLE IF EXISTS `garr_follower_locale`;
+DROP TABLE IF EXISTS `garr_follower_x_ability`;
+DROP TABLE IF EXISTS `garr_mission`;
+DROP TABLE IF EXISTS `garr_mission_locale`;
+DROP TABLE IF EXISTS `garr_plot`;
+DROP TABLE IF EXISTS `garr_plot_building`;
+DROP TABLE IF EXISTS `garr_plot_instance`;
+DROP TABLE IF EXISTS `garr_site_level`;
+DROP TABLE IF EXISTS `garr_site_level_plot_inst`;
+DROP TABLE IF EXISTS `garr_talent_tree`;
+DROP TABLE IF EXISTS `garr_talent_tree_locale`;