Core/Items: Drop item random property and suffix - all random stats must be given using bonus lists

3 files changed, 31 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2019_06_08_02_auth.sql b/sql/updates/auth/master/2019_06_08_02_auth.sql
new file mode 100644
index 00000000000..83d1e41689a
--- /dev/null
+++ b/sql/updates/auth/master/2019_06_08_02_auth.sql
@@ -0,0 +1 @@
+UPDATE `rbac_permissions` SET `name`='Command: reload item_random_bonus_list_template' WHERE `id`=653;
diff --git a/sql/updates/characters/master/2019_06_08_01_characters.sql b/sql/updates/characters/master/2019_06_08_01_characters.sql
new file mode 100644
index 00000000000..fec66d5e025
--- /dev/null
+++ b/sql/updates/characters/master/2019_06_08_01_characters.sql
@@ -0,0 +1,13 @@
+UPDATE `character_void_storage` SET `randomProperty`=0 WHERE `randomPropertyType`!=2;
+UPDATE `item_instance` SET `randomPropertyId`=0 WHERE `randomPropertyType`!=2;
+UPDATE `item_loot_items` SET `rnd_prop`=0 WHERE `rnd_type`!=2;
+
+ALTER TABLE `character_void_storage`
+  DROP `randomPropertyType`,
+  CHANGE `randomProperty` `randomBonusListId` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_instance`
+  DROP `randomPropertyType`,
+  CHANGE `randomPropertyId` `randomBonusListId` int(10) unsigned NOT NULL DEFAULT '0';
+ALTER TABLE `item_loot_items`
+  DROP `rnd_type`,
+  CHANGE `rnd_prop` `rnd_bonus` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'random bonus list added when originally rolled';
diff --git a/sql/updates/world/master/2019_06_08_02_world.sql b/sql/updates/world/master/2019_06_08_02_world.sql
new file mode 100644
index 00000000000..2eca38e48f1
--- /dev/null
+++ b/sql/updates/world/master/2019_06_08_02_world.sql
@@ -0,0 +1,17 @@
+DELETE FROM `item_enchantment_template` WHERE `type`!=2;
+
+ALTER TABLE `item_enchantment_template`
+  DROP PRIMARY KEY,
+  DROP `type`,
+  CHANGE `entry` `Id` int(10) unsigned NOT NULL,
+  CHANGE `ench` `BonusListID` int(10) unsigned NOT NULL,
+  CHANGE `chance` `chance_temp` float NOT NULL,
+  ADD PRIMARY KEY(`Id`,`BonusListID`);
+
+ALTER TABLE `item_enchantment_template` CHANGE `chance_temp` `Chance` float NOT NULL;
+
+RENAME TABLE `item_enchantment_template` TO `item_random_bonus_list_template`;
+
+ALTER TABLE `item_template_addon` ADD `RandomBonusListTemplateId` int(10) unsigned NOT NULL DEFAULT '0';
+
+UPDATE `command` SET `name`='reload item_random_bonus_list_template' WHERE `name`='reload item_enchantment_template';