Core/Items: restore item random properties handling

1 files changed, 11 insertions, 0 deletions

diff --git a/sql/updates/characters/3.4.x/2023_11_27_00_characters.sql b/sql/updates/characters/3.4.x/2023_11_27_00_characters.sql
new file mode 100644
index 00000000000..12c5f735bf0
--- /dev/null
+++ b/sql/updates/characters/3.4.x/2023_11_27_00_characters.sql
@@ -0,0 +1,11 @@
+ALTER TABLE `item_instance`   
+	ADD COLUMN `randomPropertiesId` INT DEFAULT 0 NOT NULL AFTER `battlePetDisplayId`,
+	ADD COLUMN `randomPropertiesSeed` INT DEFAULT 0 NOT NULL AFTER `randomPropertiesId`;
+
+ALTER TABLE `item_loot_items`   
+	ADD COLUMN `random_properties_id` INT DEFAULT 0 NOT NULL AFTER `needs_quest`,
+	ADD COLUMN `random_properties_seed` INT DEFAULT 0 NOT NULL AFTER `random_properties_id`;
+
+ALTER TABLE `character_void_storage`   
+	ADD COLUMN `randomPropertiesId` INT DEFAULT 0 NOT NULL AFTER `fixedScalingLevel`,
+	ADD COLUMN `randomPropertiesSeed` INT DEFAULT 0 NOT NULL AFTER `randomPropertiesId`;