Core/Items: downgrade items part 1: removed item bonus generation, artifact weapon handling and azerite item mechanics

1 files changed, 19 insertions, 0 deletions

diff --git a/sql/updates/characters/3.4.x/2023_11_22_00_characters.sql b/sql/updates/characters/3.4.x/2023_11_22_00_characters.sql
new file mode 100644
index 00000000000..97c316db5ce
--- /dev/null
+++ b/sql/updates/characters/3.4.x/2023_11_22_00_characters.sql
@@ -0,0 +1,19 @@
+ALTER TABLE `item_instance`   
+	DROP COLUMN `bonusListIDs`,
+	DROP COLUMN `randomBonusListId`;
+
+DROP TABLE IF EXISTS `item_instance_artifact`;
+DROP TABLE IF EXISTS `item_instance_artifact_powers`;
+DROP TABLE IF EXISTS `item_instance_azerite`;
+DROP TABLE IF EXISTS `item_instance_azerite_empowered`;
+DROP TABLE IF EXISTS `item_instance_azerite_milestone_power`;
+DROP TABLE IF EXISTS `item_instance_azerite_unlocked_essence`;
+
+ALTER TABLE `character_void_storage`   
+	DROP COLUMN `randomBonusListId`, 
+	DROP COLUMN `artifactKnowledgeLevel`, 
+	DROP COLUMN `bonusListIDs`;
+
+ALTER TABLE `item_loot_items`   
+	DROP COLUMN `rnd_bonus`, 
+	DROP COLUMN `bonus_list_ids`;