DB/Base: Fix characters_database.sql

1 files changed, 20 insertions, 338 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 60b002e6a79..185499e09aa 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -888,138 +888,6 @@ LOCK TABLES `character_fishingsteps` WRITE;
 UNLOCK TABLES;
 
 --
--- Table structure for table `character_garrison`
---
-
-DROP TABLE IF EXISTS `character_garrison`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_garrison` (
-  `guid` bigint unsigned NOT NULL,
-  `siteLevelId` int unsigned NOT NULL DEFAULT '0',
-  `followerActivationsRemainingToday` int unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_garrison`
---
-
-LOCK TABLES `character_garrison` WRITE;
-/*!40000 ALTER TABLE `character_garrison` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_garrison` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_garrison_blueprints`
---
-
-DROP TABLE IF EXISTS `character_garrison_blueprints`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_garrison_blueprints` (
-  `guid` bigint unsigned NOT NULL,
-  `buildingId` int unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`,`buildingId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_garrison_blueprints`
---
-
-LOCK TABLES `character_garrison_blueprints` WRITE;
-/*!40000 ALTER TABLE `character_garrison_blueprints` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_garrison_blueprints` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_garrison_buildings`
---
-
-DROP TABLE IF EXISTS `character_garrison_buildings`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_garrison_buildings` (
-  `guid` bigint unsigned NOT NULL,
-  `plotInstanceId` int unsigned NOT NULL DEFAULT '0',
-  `buildingId` int unsigned NOT NULL DEFAULT '0',
-  `timeBuilt` bigint NOT NULL,
-  `active` tinyint unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`,`plotInstanceId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_garrison_buildings`
---
-
-LOCK TABLES `character_garrison_buildings` WRITE;
-/*!40000 ALTER TABLE `character_garrison_buildings` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_garrison_buildings` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_garrison_follower_abilities`
---
-
-DROP TABLE IF EXISTS `character_garrison_follower_abilities`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_garrison_follower_abilities` (
-  `dbId` bigint unsigned NOT NULL,
-  `abilityId` int unsigned NOT NULL,
-  `slot` tinyint unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`dbId`,`abilityId`,`slot`),
-  CONSTRAINT `fk_foll_dbid` FOREIGN KEY (`dbId`) REFERENCES `character_garrison_followers` (`dbId`) ON DELETE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_garrison_follower_abilities`
---
-
-LOCK TABLES `character_garrison_follower_abilities` WRITE;
-/*!40000 ALTER TABLE `character_garrison_follower_abilities` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_garrison_follower_abilities` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `character_garrison_followers`
---
-
-DROP TABLE IF EXISTS `character_garrison_followers`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_garrison_followers` (
-  `dbId` bigint unsigned NOT NULL,
-  `guid` bigint unsigned NOT NULL,
-  `followerId` int unsigned NOT NULL,
-  `quality` int unsigned NOT NULL DEFAULT '2',
-  `level` int unsigned NOT NULL DEFAULT '90',
-  `itemLevelWeapon` int unsigned NOT NULL DEFAULT '600',
-  `itemLevelArmor` int unsigned NOT NULL DEFAULT '600',
-  `xp` int unsigned NOT NULL DEFAULT '0',
-  `currentBuilding` int unsigned NOT NULL DEFAULT '0',
-  `currentMission` int unsigned NOT NULL DEFAULT '0',
-  `status` int unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`dbId`),
-  UNIQUE KEY `idx_guid_id` (`guid`,`followerId`),
-  CONSTRAINT `fk_foll_owner` FOREIGN KEY (`guid`) REFERENCES `characters` (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_garrison_followers`
---
-
-LOCK TABLES `character_garrison_followers` WRITE;
-/*!40000 ALTER TABLE `character_garrison_followers` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_garrison_followers` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
 -- Table structure for table `character_gifts`
 --
 
@@ -1055,8 +923,9 @@ DROP TABLE IF EXISTS `character_glyphs`;
 CREATE TABLE `character_glyphs` (
   `guid` bigint unsigned NOT NULL,
   `talentGroup` tinyint unsigned NOT NULL DEFAULT '0',
+  `glyphSlot` tinyint unsigned NOT NULL DEFAULT '0',
   `glyphId` smallint unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`guid`,`talentGroup`,`glyphId`)
+  PRIMARY KEY (`guid`,`talentGroup`,`glyphSlot`,`glyphId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -1718,6 +1587,7 @@ DROP TABLE IF EXISTS `character_talent`;
 CREATE TABLE `character_talent` (
   `guid` bigint unsigned NOT NULL,
   `talentId` int unsigned NOT NULL,
+  `talentRank` tinyint unsigned NOT NULL DEFAULT '0',
   `talentGroup` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`talentId`,`talentGroup`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1852,11 +1722,10 @@ CREATE TABLE `character_void_storage` (
   `itemEntry` int unsigned NOT NULL,
   `slot` tinyint unsigned NOT NULL,
   `creatorGuid` bigint unsigned NOT NULL DEFAULT '0',
-  `randomBonusListId` int unsigned NOT NULL DEFAULT '0',
   `fixedScalingLevel` int unsigned DEFAULT '0',
-  `artifactKnowledgeLevel` int unsigned DEFAULT '0',
+  `randomPropertiesId` int NOT NULL DEFAULT '0',
+  `randomPropertiesSeed` int NOT NULL DEFAULT '0',
   `context` tinyint unsigned NOT NULL DEFAULT '0',
-  `bonusListIDs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`itemId`),
   UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`),
   KEY `idx_player` (`playerGuid`)
@@ -1917,7 +1786,8 @@ CREATE TABLE `characters` (
   `resettalents_cost` int unsigned NOT NULL DEFAULT '0',
   `resettalents_time` bigint NOT NULL DEFAULT '0',
   `numRespecs` tinyint unsigned NOT NULL DEFAULT '0',
-  `primarySpecialization` int unsigned NOT NULL DEFAULT '0',
+  `activeTalentGroup` tinyint unsigned NOT NULL DEFAULT '0',
+  `bonusTalentGroups` tinyint unsigned NOT NULL DEFAULT '0',
   `trans_x` float NOT NULL DEFAULT '0',
   `trans_y` float NOT NULL DEFAULT '0',
   `trans_z` float NOT NULL DEFAULT '0',
@@ -1947,7 +1817,6 @@ CREATE TABLE `characters` (
   `power9` int unsigned NOT NULL DEFAULT '0',
   `power10` int unsigned NOT NULL DEFAULT '0',
   `latency` int unsigned NOT NULL DEFAULT '0',
-  `activeTalentGroup` tinyint unsigned NOT NULL DEFAULT '0',
   `lootSpecId` int unsigned NOT NULL DEFAULT '0',
   `exploredZones` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `equipmentCache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
@@ -2702,7 +2571,6 @@ CREATE TABLE `item_instance` (
   `charges` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `flags` int unsigned NOT NULL DEFAULT '0',
   `enchantments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
-  `randomBonusListId` int unsigned NOT NULL DEFAULT '0',
   `durability` smallint unsigned NOT NULL DEFAULT '0',
   `playedTime` int unsigned NOT NULL DEFAULT '0',
   `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
@@ -2712,8 +2580,9 @@ CREATE TABLE `item_instance` (
   `battlePetBreedData` int unsigned NOT NULL DEFAULT '0',
   `battlePetLevel` smallint unsigned NOT NULL DEFAULT '0',
   `battlePetDisplayId` int unsigned NOT NULL DEFAULT '0',
+  `randomPropertiesId` int NOT NULL DEFAULT '0',
+  `randomPropertiesSeed` int NOT NULL DEFAULT '0',
   `context` tinyint unsigned NOT NULL DEFAULT '0',
-  `bonusListIDs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`guid`),
   KEY `idx_owner_guid` (`owner_guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System';
@@ -2729,174 +2598,6 @@ LOCK TABLES `item_instance` WRITE;
 UNLOCK TABLES;
 
 --
--- Table structure for table `item_instance_artifact`
---
-
-DROP TABLE IF EXISTS `item_instance_artifact`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_artifact` (
-  `itemGuid` bigint unsigned NOT NULL,
-  `xp` bigint unsigned NOT NULL DEFAULT '0',
-  `artifactAppearanceId` int unsigned NOT NULL DEFAULT '0',
-  `artifactTierId` int unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`itemGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_artifact`
---
-
-LOCK TABLES `item_instance_artifact` WRITE;
-/*!40000 ALTER TABLE `item_instance_artifact` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_artifact` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `item_instance_artifact_powers`
---
-
-DROP TABLE IF EXISTS `item_instance_artifact_powers`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_artifact_powers` (
-  `itemGuid` bigint unsigned NOT NULL,
-  `artifactPowerId` int unsigned NOT NULL,
-  `purchasedRank` tinyint unsigned DEFAULT '0',
-  PRIMARY KEY (`itemGuid`,`artifactPowerId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_artifact_powers`
---
-
-LOCK TABLES `item_instance_artifact_powers` WRITE;
-/*!40000 ALTER TABLE `item_instance_artifact_powers` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_artifact_powers` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `item_instance_azerite`
---
-
-DROP TABLE IF EXISTS `item_instance_azerite`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_azerite` (
-  `itemGuid` bigint unsigned NOT NULL,
-  `xp` bigint unsigned NOT NULL DEFAULT '0',
-  `level` int unsigned NOT NULL DEFAULT '1',
-  `knowledgeLevel` int unsigned NOT NULL DEFAULT '0',
-  `selectedAzeriteEssences1specId` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences1azeriteEssenceId1` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences1azeriteEssenceId2` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences1azeriteEssenceId3` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences1azeriteEssenceId4` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences2specId` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences2azeriteEssenceId1` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences2azeriteEssenceId2` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences2azeriteEssenceId3` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences2azeriteEssenceId4` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences3specId` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences3azeriteEssenceId1` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences3azeriteEssenceId2` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences3azeriteEssenceId3` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences3azeriteEssenceId4` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences4specId` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences4azeriteEssenceId1` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences4azeriteEssenceId2` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences4azeriteEssenceId3` int unsigned DEFAULT '0',
-  `selectedAzeriteEssences4azeriteEssenceId4` int unsigned DEFAULT '0',
-  PRIMARY KEY (`itemGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_azerite`
---
-
-LOCK TABLES `item_instance_azerite` WRITE;
-/*!40000 ALTER TABLE `item_instance_azerite` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_azerite` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `item_instance_azerite_empowered`
---
-
-DROP TABLE IF EXISTS `item_instance_azerite_empowered`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_azerite_empowered` (
-  `itemGuid` bigint unsigned NOT NULL,
-  `azeritePowerId1` int NOT NULL,
-  `azeritePowerId2` int NOT NULL,
-  `azeritePowerId3` int NOT NULL,
-  `azeritePowerId4` int NOT NULL,
-  `azeritePowerId5` int NOT NULL,
-  PRIMARY KEY (`itemGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_azerite_empowered`
---
-
-LOCK TABLES `item_instance_azerite_empowered` WRITE;
-/*!40000 ALTER TABLE `item_instance_azerite_empowered` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_azerite_empowered` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `item_instance_azerite_milestone_power`
---
-
-DROP TABLE IF EXISTS `item_instance_azerite_milestone_power`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_azerite_milestone_power` (
-  `itemGuid` bigint unsigned NOT NULL,
-  `azeriteItemMilestonePowerId` int unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`itemGuid`,`azeriteItemMilestonePowerId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_azerite_milestone_power`
---
-
-LOCK TABLES `item_instance_azerite_milestone_power` WRITE;
-/*!40000 ALTER TABLE `item_instance_azerite_milestone_power` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_azerite_milestone_power` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `item_instance_azerite_unlocked_essence`
---
-
-DROP TABLE IF EXISTS `item_instance_azerite_unlocked_essence`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_azerite_unlocked_essence` (
-  `itemGuid` bigint unsigned NOT NULL,
-  `azeriteEssenceId` int unsigned NOT NULL DEFAULT '0',
-  `rank` int unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`itemGuid`,`azeriteEssenceId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_azerite_unlocked_essence`
---
-
-LOCK TABLES `item_instance_azerite_unlocked_essence` WRITE;
-/*!40000 ALTER TABLE `item_instance_azerite_unlocked_essence` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_azerite_unlocked_essence` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
 -- Table structure for table `item_instance_gems`
 --
 
@@ -2908,15 +2609,12 @@ CREATE TABLE `item_instance_gems` (
   `gemItemId1` int unsigned NOT NULL DEFAULT '0',
   `gemBonuses1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `gemContext1` tinyint unsigned NOT NULL DEFAULT '0',
-  `gemScalingLevel1` int unsigned NOT NULL DEFAULT '0',
   `gemItemId2` int unsigned NOT NULL DEFAULT '0',
   `gemBonuses2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `gemContext2` tinyint unsigned NOT NULL DEFAULT '0',
-  `gemScalingLevel2` int unsigned NOT NULL DEFAULT '0',
   `gemItemId3` int unsigned NOT NULL DEFAULT '0',
   `gemBonuses3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `gemContext3` tinyint unsigned NOT NULL DEFAULT '0',
-  `gemScalingLevel3` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`itemGuid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2931,30 +2629,6 @@ LOCK TABLES `item_instance_gems` WRITE;
 UNLOCK TABLES;
 
 --
--- Table structure for table `item_instance_modifiers`
---
-
-DROP TABLE IF EXISTS `item_instance_modifiers`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `item_instance_modifiers` (
-  `itemGuid` bigint unsigned NOT NULL,
-  `fixedScalingLevel` int unsigned DEFAULT '0',
-  `artifactKnowledgeLevel` int unsigned DEFAULT '0',
-  PRIMARY KEY (`itemGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_instance_modifiers`
---
-
-LOCK TABLES `item_instance_modifiers` WRITE;
-/*!40000 ALTER TABLE `item_instance_modifiers` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_instance_modifiers` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
 -- Table structure for table `item_instance_transmog`
 --
 
@@ -3012,9 +2686,9 @@ CREATE TABLE `item_loot_items` (
   `counted` tinyint(1) NOT NULL DEFAULT '0',
   `under_threshold` tinyint(1) NOT NULL DEFAULT '0',
   `needs_quest` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'quest drop',
-  `rnd_bonus` int unsigned NOT NULL DEFAULT '0' COMMENT 'random bonus list added when originally rolled',
+  `random_properties_id` int NOT NULL DEFAULT '0',
+  `random_properties_seed` int NOT NULL DEFAULT '0',
   `context` tinyint unsigned NOT NULL DEFAULT '0',
-  `bonus_list_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Space separated list of bonus list ids',
   PRIMARY KEY (`container_id`,`item_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3723,7 +3397,15 @@ INSERT INTO `updates` VALUES
 ('2023_10_06_00_characters.sql','FFAFF1F0916BB9DC58345466E0BB1A15A4611836','ARCHIVED','2023-10-06 00:40:46',0),
 ('2023_11_02_00_characters.sql','1A76A843F204901C8598DA5682029E815477E427','RELEASED','2023-11-02 18:59:41',0),
 ('2023_11_09_00_characters.sql','1A3D7CA6890353DA55793FE8D925CC8C54965A69','RELEASED','2023-11-09 00:56:31',0),
-('2023_11_16_00_characters.sql','1D200630578074A4E3A373F891323DB867D00B02','RELEASED','2023-11-16 10:29:32',0);
+('2023_11_16_00_characters.sql','1D200630578074A4E3A373F891323DB867D00B02','RELEASED','2023-11-16 10:29:32',0),
+('2023_11_19_00_characters.sql','F247770A7F116070ABF13E4A61BB8E1693052548','RELEASED','2023-11-19 13:43:39',0),
+('2023_11_20_00_characters.sql','274C157F28DE1DC13F689755793AA2DE675CCC7F','RELEASED','2023-11-20 02:36:26',0),
+('2023_11_21_00_characters.sql','127057D4EFEB5DC63ECB877C1043B4AE996F11FA','RELEASED','2023-11-21 02:36:26',0),
+('2023_11_22_00_characters.sql','DEDDD2774AE3788C45F459B200EE446AD1C7AEE8','RELEASED','2023-11-22 02:36:26',0),
+('2023_11_23_00_characters.sql','4916DECE5A49D23B1DCFA27A713B250BE2A7225A','RELEASED','2023-11-23 21:05:48',0),
+('2023_11_25_00_characters.sql','76CE77D4B1625CE384B01295F4D3FFC16A7F696C','RELEASED','2023-11-25 12:33:10',0),
+('2023_11_27_00_characters.sql','A0CEE90B60612AA7315117FAFF22D14163D4ADF2','RELEASED','2023-11-27 12:33:10',0),
+('2023_12_03_00_characters.sql','C91A51EA86C26F3AB60445FE147B0E4B220716A0','RELEASED','2023-12-03 22:16:45',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;