From bba8e6fe41b4f41f647c08c17e8fcc09283fdfa8 Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Thu, 23 Nov 2023 02:31:31 +0100 Subject: Core/Items: downgrade items part 1: removed item bonus generation, artifact weapon handling and azerite item mechanics --- .../characters/3.4.x/2023_11_22_00_characters.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/characters/3.4.x/2023_11_22_00_characters.sql (limited to 'sql/updates') 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`; -- cgit v1.2.3