TDB 1002.22121 - 2022/12/20TDB1002.22121

119 files changed, 785 insertions, 63 deletions

diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index 9d71ec48b7b..246919b1923 100644
--- a/revision_data.h.in.cmake
+++ b/revision_data.h.in.cmake
@@ -9,8 +9,8 @@
  #define _SOURCE_DIRECTORY          R"(@CMAKE_SOURCE_DIR@)"
  #define _BUILD_DIRECTORY           R"(@BUILDDIR@)"
  #define _MYSQL_EXECUTABLE          R"(@MYSQL_EXECUTABLE@)"
- #define _FULL_DATABASE             "TDB_full_world_927.22111_2022_11_20.sql"
- #define _HOTFIXES_DATABASE         "TDB_full_hotfixes_927.22111_2022_11_20.sql"
+ #define _FULL_DATABASE             "TDB_full_world_1002.22121_2022_12_20.sql"
+ #define _HOTFIXES_DATABASE         "TDB_full_hotfixes_1002.22121_2022_12_20.sql"
  #define VER_COMPANYNAME_STR        "TrinityCore Developers"
  #define VER_LEGALCOPYRIGHT_STR     "(c)2008-@rev_year@ TrinityCore"
  #define VER_FILEVERSION            0,0,0
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index ff0b8b0a19c..f08fdba3957 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -2,7 +2,7 @@
 --
 -- Host: localhost    Database: auth
 -- ------------------------------------------------------
--- Server version	8.0.31-0ubuntu0.20.04.1
+-- Server version	8.0.31-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2633,9 +2633,10 @@ INSERT INTO `updates` VALUES
 ('2022_09_23_00_auth.sql','F7DB1B903982D99295BC0D7D2BC205C5A2145F03','ARCHIVED','2022-09-23 03:44:55',0),
 ('2022_10_03_00_auth.sql','B956A37F71B42EB0289C2066A15D1F6C02F21E5A','ARCHIVED','2022-10-03 21:32:38',0),
 ('2022_11_20_00_auth.sql','37123D83589CFD96472D9187799C1F3FD67645DD','ARCHIVED','2022-11-20 11:05:20',0),
-('2022_12_16_00_auth.sql','249B00480ACC8B67C908435748C202D8363C6EDE','RELEASED','2022-12-16 22:39:07',0),
-('2022_12_17_00_auth.sql','0D3963AC2DBF74A4C8B88EA4A680C046FCCF8E70','RELEASED','2022-12-17 07:34:53',0),
-('2022_12_17_01_auth.sql','5D1E2EA3C3CE087F7FB647CD0DE000979961863C','RELEASED','2022-12-17 13:09:19',0);
+('2022_12_16_00_auth.sql','249B00480ACC8B67C908435748C202D8363C6EDE','ARCHIVED','2022-12-16 22:39:07',0),
+('2022_12_17_00_auth.sql','0D3963AC2DBF74A4C8B88EA4A680C046FCCF8E70','ARCHIVED','2022-12-17 07:34:53',0),
+('2022_12_17_01_auth.sql','5D1E2EA3C3CE087F7FB647CD0DE000979961863C','ARCHIVED','2022-12-17 13:09:19',0),
+('2022_12_20_00_auth.sql','BA88146743B060A14937688C0DB94BF11C6CF1BA','ARCHIVED','2022-12-20 03:10:07',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2661,6 +2662,7 @@ LOCK TABLES `updates_include` WRITE;
 /*!40000 ALTER TABLE `updates_include` DISABLE KEYS */;
 INSERT INTO `updates_include` VALUES
 ('$/sql/custom/auth','RELEASED'),
+('$/sql/old/10.x/auth','ARCHIVED'),
 ('$/sql/old/6.x/auth','ARCHIVED'),
 ('$/sql/old/7/auth','ARCHIVED'),
 ('$/sql/old/8.x/auth','ARCHIVED'),
@@ -2777,4 +2779,4 @@ SET character_set_client = @saved_cs_client;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-11-20 11:05:22
+-- Dump completed on 2022-12-20  3:10:10
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 03de47c4123..ae7a7b33efb 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2,7 +2,7 @@
 --
 -- Host: localhost    Database: characters
 -- ------------------------------------------------------
--- Server version	8.0.31-0ubuntu0.20.04.1
+-- Server version	8.0.31-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -1625,7 +1625,6 @@ LOCK TABLES `character_spell_cooldown` WRITE;
 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
 UNLOCK TABLES;
 
-
 --
 -- Table structure for table `character_spell_favorite`
 --
@@ -3689,8 +3688,9 @@ INSERT INTO `updates` VALUES
 ('2022_10_03_01_characters.sql','7CF58BD9CC366301CC992017028568C8774C4BC2','ARCHIVED','2022-10-03 22:36:38',0),
 ('2022_10_03_02_characters.sql','33135AB3132943F15F4849A16EC5EFEA402F24F6','ARCHIVED','2022-10-03 22:38:27',0),
 ('2022_11_20_00_characters.sql','4EB8BB24CAF16B0962DF3EF92C77BE05E234CFA6','ARCHIVED','2022-11-20 11:05:20',0),
-('2022_12_16_00_characters.sql','36D6220143109ECD37219CC4A84773B31EAE9E50','RELEASED','2022-12-16 22:52:19',0),
-('2022_12_17_00_characters.sql','3E005BD6B9C60653749B0B3C19CBC497092B9CCB','RELEASED','2022-12-17 18:26:43',0);
+('2022_12_16_00_characters.sql','36D6220143109ECD37219CC4A84773B31EAE9E50','ARCHIVED','2022-12-16 22:52:19',0),
+('2022_12_17_00_characters.sql','3E005BD6B9C60653749B0B3C19CBC497092B9CCB','ARCHIVED','2022-12-17 18:26:43',0),
+('2022_12_20_00_characters.sql','75A37A085AF1B953926E4352E439C7916B290924','ARCHIVED','2022-12-20 03:10:07',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3716,6 +3716,7 @@ LOCK TABLES `updates_include` WRITE;
 /*!40000 ALTER TABLE `updates_include` DISABLE KEYS */;
 INSERT INTO `updates_include` VALUES
 ('$/sql/custom/characters','RELEASED'),
+('$/sql/old/10.x/characters','ARCHIVED'),
 ('$/sql/old/6.x/characters','ARCHIVED'),
 ('$/sql/old/7/characters','ARCHIVED'),
 ('$/sql/old/8.x/characters','ARCHIVED'),
@@ -3816,4 +3817,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-11-20 11:05:23
+-- Dump completed on 2022-12-20  3:10:11
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index 9217f0ceb65..b954c2154a1 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -2,7 +2,7 @@
 --
 -- Host: localhost    Database: hotfixes
 -- ------------------------------------------------------
--- Server version	8.0.31-0ubuntu0.20.04.1
+-- Server version	8.0.31-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -1118,6 +1118,7 @@ DROP TABLE IF EXISTS `battle_pet_breed_quality`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `battle_pet_breed_quality` (
   `ID` int unsigned NOT NULL DEFAULT '0',
+  `MaxQualityRoll` int NOT NULL DEFAULT '0',
   `StateMultiplier` float NOT NULL DEFAULT '0',
   `QualityEnum` tinyint NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -1157,7 +1158,7 @@ CREATE TABLE `battle_pet_species` (
   `SummonSpellID` int NOT NULL DEFAULT '0',
   `IconFileDataID` int NOT NULL DEFAULT '0',
   `PetTypeEnum` tinyint NOT NULL DEFAULT '0',
-  `Flags` smallint unsigned NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
   `SourceTypeEnum` tinyint NOT NULL DEFAULT '0',
   `CardUIModelSceneID` int NOT NULL DEFAULT '0',
   `LoadoutUIModelSceneID` int NOT NULL DEFAULT '0',
@@ -1230,7 +1231,7 @@ CREATE TABLE `battlemaster_list` (
   `MaxLevel` tinyint NOT NULL DEFAULT '0',
   `RatedPlayers` tinyint NOT NULL DEFAULT '0',
   `MinPlayers` tinyint NOT NULL DEFAULT '0',
-  `MaxPlayers` tinyint NOT NULL DEFAULT '0',
+  `MaxPlayers` int NOT NULL DEFAULT '0',
   `GroupsAllowed` tinyint NOT NULL DEFAULT '0',
   `MaxGroupSize` tinyint NOT NULL DEFAULT '0',
   `HolidayWorldState` smallint NOT NULL DEFAULT '0',
@@ -1439,8 +1440,8 @@ CREATE TABLE `character_loadout` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `RaceMask` bigint NOT NULL DEFAULT '0',
   `ChrClassID` tinyint NOT NULL DEFAULT '0',
-  `Purpose` tinyint NOT NULL DEFAULT '0',
-  `Unused910` tinyint NOT NULL DEFAULT '0',
+  `Purpose` int NOT NULL DEFAULT '0',
+  `ItemContext` tinyint NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1640,6 +1641,7 @@ CREATE TABLE `chr_customization_choice` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `ChrCustomizationOptionID` int NOT NULL DEFAULT '0',
   `ChrCustomizationReqID` int NOT NULL DEFAULT '0',
+  `ChrCustomizationVisReqID` int NOT NULL DEFAULT '0',
   `SortOrder` smallint unsigned NOT NULL DEFAULT '0',
   `UiOrderIndex` smallint unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
@@ -1714,6 +1716,7 @@ CREATE TABLE `chr_customization_element` (
   `ChrCustomizationCondModelID` int NOT NULL DEFAULT '0',
   `ChrCustomizationDisplayInfoID` int NOT NULL DEFAULT '0',
   `ChrCustItemGeoModifyID` int NOT NULL DEFAULT '0',
+  `ChrCustomizationVoiceID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1781,9 +1784,11 @@ DROP TABLE IF EXISTS `chr_customization_req`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `chr_customization_req` (
   `ID` int unsigned NOT NULL DEFAULT '0',
+  `ReqSource` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Flags` int NOT NULL DEFAULT '0',
   `ClassMask` int NOT NULL DEFAULT '0',
   `AchievementID` int NOT NULL DEFAULT '0',
+  `QuestID` int NOT NULL DEFAULT '0',
   `OverrideArchive` int NOT NULL DEFAULT '0',
   `ItemModifiedAppearanceID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -1808,6 +1813,33 @@ CREATE TABLE `chr_customization_req_choice` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `chr_customization_req_locale`
+--
+
+DROP TABLE IF EXISTS `chr_customization_req_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `chr_customization_req_locale` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `ReqSource_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!50500 PARTITION BY LIST  COLUMNS(locale)
+(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB,
+ PARTITION esES VALUES IN ('esES') ENGINE = InnoDB,
+ PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB,
+ PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB,
+ PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB,
+ PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB,
+ PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB,
+ PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB,
+ PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB,
+ PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `chr_model`
 --
 
@@ -1852,6 +1884,8 @@ CREATE TABLE `chr_race_x_chr_model` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `ChrRacesID` int NOT NULL DEFAULT '0',
   `ChrModelID` int NOT NULL DEFAULT '0',
+  `Sex` int NOT NULL DEFAULT '0',
+  `AllowedTransmogSlots` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1921,6 +1955,7 @@ CREATE TABLE `chr_races` (
   `Unknown910_21` float NOT NULL DEFAULT '0',
   `Unknown910_22` float NOT NULL DEFAULT '0',
   `Unknown910_23` float NOT NULL DEFAULT '0',
+  `Unknown1000` int NOT NULL DEFAULT '0',
   `BaseLanguage` tinyint NOT NULL DEFAULT '0',
   `CreatureType` tinyint NOT NULL DEFAULT '0',
   `MaleModelFallbackSex` tinyint NOT NULL DEFAULT '0',
@@ -2042,7 +2077,7 @@ CREATE TABLE `cinematic_camera` (
   `SoundID` int unsigned NOT NULL DEFAULT '0',
   `OriginFacing` float NOT NULL DEFAULT '0',
   `FileDataID` int unsigned NOT NULL DEFAULT '0',
-  `Unknown915` int NOT NULL DEFAULT '0',
+  `ConversationID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2249,6 +2284,7 @@ CREATE TABLE `creature_display_info` (
   `TextureVariationFileDataID1` int NOT NULL DEFAULT '0',
   `TextureVariationFileDataID2` int NOT NULL DEFAULT '0',
   `TextureVariationFileDataID3` int NOT NULL DEFAULT '0',
+  `TextureVariationFileDataID4` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2565,6 +2601,8 @@ CREATE TABLE `currency_types` (
   `XpQuestDifficulty` int NOT NULL DEFAULT '0',
   `AwardConditionID` int NOT NULL DEFAULT '0',
   `MaxQtyWorldStateID` int NOT NULL DEFAULT '0',
+  `RechargingAmountPerCycle` int unsigned NOT NULL DEFAULT '0',
+  `RechargingCycleDurationMS` int unsigned NOT NULL DEFAULT '0',
   `Flags1` int NOT NULL DEFAULT '0',
   `Flags2` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -2624,11 +2662,11 @@ DROP TABLE IF EXISTS `curve_point`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `curve_point` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `PosX` float NOT NULL DEFAULT '0',
   `PosY` float NOT NULL DEFAULT '0',
   `PreSLSquishPosX` float NOT NULL DEFAULT '0',
   `PreSLSquishPosY` float NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `CurveID` smallint unsigned NOT NULL DEFAULT '0',
   `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -2741,7 +2779,6 @@ CREATE TABLE `dungeon_encounter` (
   `OrderIndex` int NOT NULL DEFAULT '0',
   `CompleteWorldStateID` int NOT NULL DEFAULT '0',
   `Bit` tinyint NOT NULL DEFAULT '0',
-  `CreatureDisplayID` int NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `SpellIconFileID` int NOT NULL DEFAULT '0',
   `Faction` int NOT NULL DEFAULT '0',
@@ -2960,8 +2997,10 @@ CREATE TABLE `faction` (
   `ParentFactionID` smallint unsigned NOT NULL DEFAULT '0',
   `Expansion` tinyint unsigned NOT NULL DEFAULT '0',
   `FriendshipRepID` int unsigned NOT NULL DEFAULT '0',
-  `Flags` tinyint unsigned NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
   `ParagonFactionID` smallint unsigned NOT NULL DEFAULT '0',
+  `RenownFactionID` int NOT NULL DEFAULT '0',
+  `RenownCurrencyID` int NOT NULL DEFAULT '0',
   `ReputationClassMask1` smallint NOT NULL DEFAULT '0',
   `ReputationClassMask2` smallint NOT NULL DEFAULT '0',
   `ReputationClassMask3` smallint NOT NULL DEFAULT '0',
@@ -3033,10 +3072,18 @@ CREATE TABLE `faction_template` (
   `Enemies2` smallint unsigned NOT NULL DEFAULT '0',
   `Enemies3` smallint unsigned NOT NULL DEFAULT '0',
   `Enemies4` smallint unsigned NOT NULL DEFAULT '0',
+  `Enemies5` smallint unsigned NOT NULL DEFAULT '0',
+  `Enemies6` smallint unsigned NOT NULL DEFAULT '0',
+  `Enemies7` smallint unsigned NOT NULL DEFAULT '0',
+  `Enemies8` smallint unsigned NOT NULL DEFAULT '0',
   `Friend1` smallint unsigned NOT NULL DEFAULT '0',
   `Friend2` smallint unsigned NOT NULL DEFAULT '0',
   `Friend3` smallint unsigned NOT NULL DEFAULT '0',
   `Friend4` smallint unsigned NOT NULL DEFAULT '0',
+  `Friend5` smallint unsigned NOT NULL DEFAULT '0',
+  `Friend6` smallint unsigned NOT NULL DEFAULT '0',
+  `Friend7` smallint unsigned NOT NULL DEFAULT '0',
+  `Friend8` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3704,7 +3751,7 @@ DROP TABLE IF EXISTS `garr_talent_tree`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `garr_talent_tree` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `Name` text COLLATE utf8mb4_unicode_ci,
+  `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0',
   `ClassID` int NOT NULL DEFAULT '0',
   `MaxTiers` tinyint NOT NULL DEFAULT '0',
@@ -3713,7 +3760,7 @@ CREATE TABLE `garr_talent_tree` (
   `UiTextureKitID` smallint unsigned NOT NULL DEFAULT '0',
   `GarrTalentTreeType` int NOT NULL DEFAULT '0',
   `PlayerConditionID` int NOT NULL DEFAULT '0',
-  `FeatureTypeIndex` tinyint NOT NULL DEFAULT '0',
+  `FeatureTypeIndex` tinyint unsigned NOT NULL DEFAULT '0',
   `FeatureSubtypeIndex` tinyint NOT NULL DEFAULT '0',
   `CurrencyID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -3730,8 +3777,8 @@ DROP TABLE IF EXISTS `garr_talent_tree_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `garr_talent_tree_locale` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `Name_lang` text COLLATE utf8mb4_unicode_ci,
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
@@ -3831,6 +3878,35 @@ CREATE TABLE `glyph_required_spec` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `gossip_npc_option`
+--
+
+DROP TABLE IF EXISTS `gossip_npc_option`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `gossip_npc_option` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `GossipNpcOption` int NOT NULL DEFAULT '0',
+  `LFGDungeonsID` int NOT NULL DEFAULT '0',
+  `TrainerID` int NOT NULL DEFAULT '0',
+  `GarrFollowerTypeID` int NOT NULL DEFAULT '0',
+  `CharShipmentID` int NOT NULL DEFAULT '0',
+  `GarrTalentTreeID` int NOT NULL DEFAULT '0',
+  `UiMapID` int NOT NULL DEFAULT '0',
+  `UiItemInteractionID` int NOT NULL DEFAULT '0',
+  `Unknown_1000_8` int NOT NULL DEFAULT '0',
+  `Unknown_1000_9` int NOT NULL DEFAULT '0',
+  `CovenantID` int NOT NULL DEFAULT '0',
+  `GossipOptionID` int NOT NULL DEFAULT '0',
+  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `ProfessionID` int NOT NULL DEFAULT '0',
+  `Unknown_1002_14` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `guild_color_background`
 --
 
@@ -4160,6 +4236,7 @@ CREATE TABLE `item` (
   `ItemGroupSoundsID` tinyint unsigned NOT NULL DEFAULT '0',
   `ContentTuningID` int NOT NULL DEFAULT '0',
   `ModifiedCraftingReagentItemID` int NOT NULL DEFAULT '0',
+  `CraftingQualityID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -4588,7 +4665,7 @@ CREATE TABLE `item_extended_cost` (
   `ArenaBracket` tinyint NOT NULL DEFAULT '0',
   `Flags` tinyint unsigned NOT NULL DEFAULT '0',
   `MinFactionID` tinyint unsigned NOT NULL DEFAULT '0',
-  `MinReputation` tinyint unsigned NOT NULL DEFAULT '0',
+  `MinReputation` int NOT NULL DEFAULT '0',
   `RequiredAchievement` tinyint unsigned NOT NULL DEFAULT '0',
   `ItemID1` int NOT NULL DEFAULT '0',
   `ItemID2` int NOT NULL DEFAULT '0',
@@ -4838,7 +4915,7 @@ CREATE TABLE `item_search_name` (
   `OverallQualityID` tinyint unsigned NOT NULL DEFAULT '0',
   `ExpansionID` int NOT NULL DEFAULT '0',
   `MinFactionID` smallint unsigned NOT NULL DEFAULT '0',
-  `MinReputation` tinyint unsigned NOT NULL DEFAULT '0',
+  `MinReputation` int NOT NULL DEFAULT '0',
   `AllowableClass` int NOT NULL DEFAULT '0',
   `RequiredLevel` tinyint NOT NULL DEFAULT '0',
   `RequiredSkill` smallint unsigned NOT NULL DEFAULT '0',
@@ -5007,6 +5084,7 @@ CREATE TABLE `item_sparse` (
   `StatPercentEditor10` int NOT NULL DEFAULT '0',
   `Stackable` int NOT NULL DEFAULT '0',
   `MaxCount` int NOT NULL DEFAULT '0',
+  `MinReputation` int NOT NULL DEFAULT '0',
   `RequiredAbility` int unsigned NOT NULL DEFAULT '0',
   `SellPrice` int unsigned NOT NULL DEFAULT '0',
   `BuyPrice` int unsigned NOT NULL DEFAULT '0',
@@ -5061,7 +5139,6 @@ CREATE TABLE `item_sparse` (
   `StatModifierBonusStat9` tinyint NOT NULL DEFAULT '0',
   `StatModifierBonusStat10` tinyint NOT NULL DEFAULT '0',
   `ContainerSlots` tinyint unsigned NOT NULL DEFAULT '0',
-  `MinReputation` tinyint unsigned NOT NULL DEFAULT '0',
   `RequiredPVPMedal` tinyint unsigned NOT NULL DEFAULT '0',
   `RequiredPVPRank` tinyint unsigned NOT NULL DEFAULT '0',
   `RequiredLevel` tinyint NOT NULL DEFAULT '0',
@@ -5298,7 +5375,6 @@ CREATE TABLE `journal_instance` (
   `ButtonFileDataID` int NOT NULL DEFAULT '0',
   `ButtonSmallFileDataID` int NOT NULL DEFAULT '0',
   `LoreFileDataID` int NOT NULL DEFAULT '0',
-  `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `AreaID` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -5819,6 +5895,7 @@ CREATE TABLE `map` (
   `WindSettingsID` smallint NOT NULL DEFAULT '0',
   `ZmpFileDataID` int NOT NULL DEFAULT '0',
   `WdtFileDataID` int NOT NULL DEFAULT '0',
+  `NavigationMaxDistance` int NOT NULL DEFAULT '0',
   `Flags1` int NOT NULL DEFAULT '0',
   `Flags2` int NOT NULL DEFAULT '0',
   `Flags3` int NOT NULL DEFAULT '0',
@@ -6083,6 +6160,7 @@ CREATE TABLE `mount_capability` (
   `ModSpellAuraID` int NOT NULL DEFAULT '0',
   `ReqMapID` smallint NOT NULL DEFAULT '0',
   `PlayerConditionID` int NOT NULL DEFAULT '0',
+  `FlightCapabilityID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6389,6 +6467,7 @@ CREATE TABLE `player_condition` (
   `MaxPVPRank` tinyint unsigned NOT NULL DEFAULT '0',
   `ContentTuningID` int NOT NULL DEFAULT '0',
   `CovenantID` int NOT NULL DEFAULT '0',
+  `TraitNodeEntryLogic` int unsigned NOT NULL DEFAULT '0',
   `SkillID1` smallint unsigned NOT NULL DEFAULT '0',
   `SkillID2` smallint unsigned NOT NULL DEFAULT '0',
   `SkillID3` smallint unsigned NOT NULL DEFAULT '0',
@@ -6479,6 +6558,18 @@ CREATE TABLE `player_condition` (
   `QuestKillMonster6` int unsigned NOT NULL DEFAULT '0',
   `MovementFlags1` int NOT NULL DEFAULT '0',
   `MovementFlags2` int NOT NULL DEFAULT '0',
+  `TraitNodeEntryID1` int NOT NULL DEFAULT '0',
+  `TraitNodeEntryID2` int NOT NULL DEFAULT '0',
+  `TraitNodeEntryID3` int NOT NULL DEFAULT '0',
+  `TraitNodeEntryID4` int NOT NULL DEFAULT '0',
+  `TraitNodeEntryMinRank1` smallint unsigned NOT NULL DEFAULT '0',
+  `TraitNodeEntryMinRank2` smallint unsigned NOT NULL DEFAULT '0',
+  `TraitNodeEntryMinRank3` smallint unsigned NOT NULL DEFAULT '0',
+  `TraitNodeEntryMinRank4` smallint unsigned NOT NULL DEFAULT '0',
+  `TraitNodeEntryMaxRank1` smallint unsigned NOT NULL DEFAULT '0',
+  `TraitNodeEntryMaxRank2` smallint unsigned NOT NULL DEFAULT '0',
+  `TraitNodeEntryMaxRank3` smallint unsigned NOT NULL DEFAULT '0',
+  `TraitNodeEntryMaxRank4` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6542,12 +6633,12 @@ CREATE TABLE `power_type` (
   `CostGlobalStringTag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
   `PowerTypeEnum` tinyint NOT NULL DEFAULT '0',
-  `MinPower` tinyint NOT NULL DEFAULT '0',
-  `MaxBasePower` smallint NOT NULL DEFAULT '0',
-  `CenterPower` tinyint NOT NULL DEFAULT '0',
-  `DefaultPower` tinyint NOT NULL DEFAULT '0',
-  `DisplayModifier` tinyint NOT NULL DEFAULT '0',
-  `RegenInterruptTimeMS` smallint NOT NULL DEFAULT '0',
+  `MinPower` int NOT NULL DEFAULT '0',
+  `MaxBasePower` int NOT NULL DEFAULT '0',
+  `CenterPower` int NOT NULL DEFAULT '0',
+  `DefaultPower` int NOT NULL DEFAULT '0',
+  `DisplayModifier` int NOT NULL DEFAULT '0',
+  `RegenInterruptTimeMS` int NOT NULL DEFAULT '0',
   `RegenPeace` float NOT NULL DEFAULT '0',
   `RegenCombat` float NOT NULL DEFAULT '0',
   `Flags` smallint NOT NULL DEFAULT '0',
@@ -6653,6 +6744,7 @@ CREATE TABLE `pvp_talent` (
   `ActionBarSpellID` int NOT NULL DEFAULT '0',
   `PvpTalentCategoryID` int NOT NULL DEFAULT '0',
   `LevelRequired` int NOT NULL DEFAULT '0',
+  `PlayerConditionID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6803,7 +6895,7 @@ CREATE TABLE `quest_info` (
   `InfoName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Type` tinyint NOT NULL DEFAULT '0',
   `Modifiers` int NOT NULL DEFAULT '0',
-  `Profession` smallint unsigned NOT NULL DEFAULT '0',
+  `Profession` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6949,6 +7041,7 @@ DROP TABLE IF EXISTS `quest_v2`;
 CREATE TABLE `quest_v2` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `UniqueBitFlag` smallint unsigned NOT NULL DEFAULT '0',
+  `UiQuestDetailsTheme` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -7265,6 +7358,8 @@ CREATE TABLE `skill_line` (
   `ParentTierIndex` int NOT NULL DEFAULT '0',
   `Flags` smallint unsigned NOT NULL DEFAULT '0',
   `SpellBookSpellID` int NOT NULL DEFAULT '0',
+  `ExpansionNameSharedStringID` int NOT NULL DEFAULT '0',
+  `HordeExpansionNameSharedStringID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -7279,6 +7374,8 @@ DROP TABLE IF EXISTS `skill_line_ability`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `skill_line_ability` (
   `RaceMask` bigint NOT NULL DEFAULT '0',
+  `AbilityVerb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `AbilityAllVerb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
   `SkillLine` smallint NOT NULL DEFAULT '0',
   `Spell` int NOT NULL DEFAULT '0',
@@ -7299,6 +7396,34 @@ CREATE TABLE `skill_line_ability` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `skill_line_ability_locale`
+--
+
+DROP TABLE IF EXISTS `skill_line_ability_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `skill_line_ability_locale` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `AbilityVerb_lang` text COLLATE utf8mb4_unicode_ci,
+  `AbilityAllVerb_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!50500 PARTITION BY LIST  COLUMNS(locale)
+(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB,
+ PARTITION esES VALUES IN ('esES') ENGINE = InnoDB,
+ PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB,
+ PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB,
+ PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB,
+ PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB,
+ PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB,
+ PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB,
+ PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB,
+ PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `skill_line_locale`
 --
 
@@ -7329,6 +7454,23 @@ CREATE TABLE `skill_line_locale` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `skill_line_x_trait_tree`
+--
+
+DROP TABLE IF EXISTS `skill_line_x_trait_tree`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `skill_line_x_trait_tree` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `SkillLineID` int NOT NULL DEFAULT '0',
+  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `OrderIndex` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `skill_race_class_info`
 --
 
@@ -7378,7 +7520,7 @@ CREATE TABLE `sound_kit` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `SoundType` int NOT NULL DEFAULT '0',
   `VolumeFloat` float NOT NULL DEFAULT '0',
-  `Flags` smallint unsigned NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
   `MinDistance` float NOT NULL DEFAULT '0',
   `DistanceCutoff` float NOT NULL DEFAULT '0',
   `EAXDef` tinyint unsigned NOT NULL DEFAULT '0',
@@ -7391,6 +7533,7 @@ CREATE TABLE `sound_kit` (
   `PitchAdjust` float NOT NULL DEFAULT '0',
   `BusOverwriteID` smallint unsigned NOT NULL DEFAULT '0',
   `MaxInstances` tinyint unsigned NOT NULL DEFAULT '0',
+  `SoundMixGroupID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -7490,15 +7633,19 @@ DROP TABLE IF EXISTS `spell_aura_restrictions`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_aura_restrictions` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
-  `CasterAuraState` tinyint unsigned NOT NULL DEFAULT '0',
-  `TargetAuraState` tinyint unsigned NOT NULL DEFAULT '0',
-  `ExcludeCasterAuraState` tinyint unsigned NOT NULL DEFAULT '0',
-  `ExcludeTargetAuraState` tinyint unsigned NOT NULL DEFAULT '0',
+  `DifficultyID` int NOT NULL DEFAULT '0',
+  `CasterAuraState` int NOT NULL DEFAULT '0',
+  `TargetAuraState` int NOT NULL DEFAULT '0',
+  `ExcludeCasterAuraState` int NOT NULL DEFAULT '0',
+  `ExcludeTargetAuraState` int NOT NULL DEFAULT '0',
   `CasterAuraSpell` int NOT NULL DEFAULT '0',
   `TargetAuraSpell` int NOT NULL DEFAULT '0',
   `ExcludeCasterAuraSpell` int NOT NULL DEFAULT '0',
   `ExcludeTargetAuraSpell` int NOT NULL DEFAULT '0',
+  `CasterAuraType` int NOT NULL DEFAULT '0',
+  `TargetAuraType` int NOT NULL DEFAULT '0',
+  `ExcludeCasterAuraType` int NOT NULL DEFAULT '0',
+  `ExcludeTargetAuraType` int NOT NULL DEFAULT '0',
   `SpellID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -7533,7 +7680,7 @@ CREATE TABLE `spell_casting_requirements` (
   `SpellID` int NOT NULL DEFAULT '0',
   `FacingCasterFlags` tinyint unsigned NOT NULL DEFAULT '0',
   `MinFactionID` smallint unsigned NOT NULL DEFAULT '0',
-  `MinReputation` tinyint NOT NULL DEFAULT '0',
+  `MinReputation` int NOT NULL DEFAULT '0',
   `RequiredAreasID` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredAuraVision` tinyint unsigned NOT NULL DEFAULT '0',
   `RequiresSpellFocus` smallint unsigned NOT NULL DEFAULT '0',
@@ -7646,6 +7793,7 @@ CREATE TABLE `spell_cooldowns` (
   `CategoryRecoveryTime` int NOT NULL DEFAULT '0',
   `RecoveryTime` int NOT NULL DEFAULT '0',
   `StartRecoveryTime` int NOT NULL DEFAULT '0',
+  `AuraSpellID` int NOT NULL DEFAULT '0',
   `SpellID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -7809,6 +7957,7 @@ CREATE TABLE `spell_item_enchantment` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `HordeName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Duration` int NOT NULL DEFAULT '0',
   `EffectArg1` int unsigned NOT NULL DEFAULT '0',
   `EffectArg2` int unsigned NOT NULL DEFAULT '0',
   `EffectArg3` int unsigned NOT NULL DEFAULT '0',
@@ -8070,6 +8219,7 @@ CREATE TABLE `spell_power` (
   `AltPowerBarID` int NOT NULL DEFAULT '0',
   `PowerCostPct` float NOT NULL DEFAULT '0',
   `PowerCostMaxPct` float NOT NULL DEFAULT '0',
+  `OptionalCostPct` float NOT NULL DEFAULT '0',
   `PowerPctPerSecond` float NOT NULL DEFAULT '0',
   `PowerType` tinyint NOT NULL DEFAULT '0',
   `RequiredAuraSpellID` int NOT NULL DEFAULT '0',
@@ -8223,6 +8373,22 @@ CREATE TABLE `spell_reagents` (
   `ReagentCount6` smallint NOT NULL DEFAULT '0',
   `ReagentCount7` smallint NOT NULL DEFAULT '0',
   `ReagentCount8` smallint NOT NULL DEFAULT '0',
+  `ReagentRecraftCount1` smallint NOT NULL DEFAULT '0',
+  `ReagentRecraftCount2` smallint NOT NULL DEFAULT '0',
+  `ReagentRecraftCount3` smallint NOT NULL DEFAULT '0',
+  `ReagentRecraftCount4` smallint NOT NULL DEFAULT '0',
+  `ReagentRecraftCount5` smallint NOT NULL DEFAULT '0',
+  `ReagentRecraftCount6` smallint NOT NULL DEFAULT '0',
+  `ReagentRecraftCount7` smallint NOT NULL DEFAULT '0',
+  `ReagentRecraftCount8` smallint NOT NULL DEFAULT '0',
+  `ReagentSource1` tinyint unsigned NOT NULL DEFAULT '0',
+  `ReagentSource2` tinyint unsigned NOT NULL DEFAULT '0',
+  `ReagentSource3` tinyint unsigned NOT NULL DEFAULT '0',
+  `ReagentSource4` tinyint unsigned NOT NULL DEFAULT '0',
+  `ReagentSource5` tinyint unsigned NOT NULL DEFAULT '0',
+  `ReagentSource6` tinyint unsigned NOT NULL DEFAULT '0',
+  `ReagentSource7` tinyint unsigned NOT NULL DEFAULT '0',
+  `ReagentSource8` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -8515,6 +8681,7 @@ CREATE TABLE `spell_x_spell_visual` (
   `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
   `SpellVisualID` int unsigned NOT NULL DEFAULT '0',
   `Probability` float NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
   `Priority` int NOT NULL DEFAULT '0',
   `SpellIconFileID` int NOT NULL DEFAULT '0',
   `ActiveIconFileID` int NOT NULL DEFAULT '0',
@@ -8820,6 +8987,475 @@ CREATE TABLE `toy_locale` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `trait_cond`
+--
+
+DROP TABLE IF EXISTS `trait_cond`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_cond` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `CondType` int NOT NULL DEFAULT '0',
+  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `GrantedRanks` int NOT NULL DEFAULT '0',
+  `QuestID` int NOT NULL DEFAULT '0',
+  `AchievementID` int NOT NULL DEFAULT '0',
+  `SpecSetID` int NOT NULL DEFAULT '0',
+  `TraitNodeGroupID` int NOT NULL DEFAULT '0',
+  `TraitNodeID` int NOT NULL DEFAULT '0',
+  `TraitCurrencyID` int NOT NULL DEFAULT '0',
+  `SpentAmountRequired` int NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
+  `RequiredLevel` int NOT NULL DEFAULT '0',
+  `FreeSharedStringID` int NOT NULL DEFAULT '0',
+  `SpendMoreSharedStringID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_cost`
+--
+
+DROP TABLE IF EXISTS `trait_cost`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_cost` (
+  `InternalName` text COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Amount` int NOT NULL DEFAULT '0',
+  `TraitCurrencyID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_currency`
+--
+
+DROP TABLE IF EXISTS `trait_currency`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_currency` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Type` int NOT NULL DEFAULT '0',
+  `CurrencyTypesID` int NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
+  `Icon` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_currency_source`
+--
+
+DROP TABLE IF EXISTS `trait_currency_source`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_currency_source` (
+  `Requirement` text COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitCurrencyID` int NOT NULL DEFAULT '0',
+  `Amount` int NOT NULL DEFAULT '0',
+  `QuestID` int NOT NULL DEFAULT '0',
+  `AchievementID` int NOT NULL DEFAULT '0',
+  `PlayerLevel` int NOT NULL DEFAULT '0',
+  `TraitNodeEntryID` int NOT NULL DEFAULT '0',
+  `OrderIndex` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_currency_source_locale`
+--
+
+DROP TABLE IF EXISTS `trait_currency_source_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_currency_source_locale` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Requirement_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!50500 PARTITION BY LIST  COLUMNS(locale)
+(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB,
+ PARTITION esES VALUES IN ('esES') ENGINE = InnoDB,
+ PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB,
+ PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB,
+ PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB,
+ PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB,
+ PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB,
+ PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB,
+ PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB,
+ PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_definition`
+--
+
+DROP TABLE IF EXISTS `trait_definition`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_definition` (
+  `OverrideName` text COLLATE utf8mb4_unicode_ci,
+  `OverrideSubtext` text COLLATE utf8mb4_unicode_ci,
+  `OverrideDescription` text COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `SpellID` int NOT NULL DEFAULT '0',
+  `OverrideIcon` int NOT NULL DEFAULT '0',
+  `OverridesSpellID` int NOT NULL DEFAULT '0',
+  `VisibleSpellID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_definition_effect_points`
+--
+
+DROP TABLE IF EXISTS `trait_definition_effect_points`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_definition_effect_points` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitDefinitionID` int NOT NULL DEFAULT '0',
+  `EffectIndex` int NOT NULL DEFAULT '0',
+  `OperationType` int NOT NULL DEFAULT '0',
+  `CurveID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_definition_locale`
+--
+
+DROP TABLE IF EXISTS `trait_definition_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_definition_locale` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `OverrideName_lang` text COLLATE utf8mb4_unicode_ci,
+  `OverrideSubtext_lang` text COLLATE utf8mb4_unicode_ci,
+  `OverrideDescription_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!50500 PARTITION BY LIST  COLUMNS(locale)
+(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB,
+ PARTITION esES VALUES IN ('esES') ENGINE = InnoDB,
+ PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB,
+ PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB,
+ PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB,
+ PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB,
+ PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB,
+ PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB,
+ PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB,
+ PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_edge`
+--
+
+DROP TABLE IF EXISTS `trait_edge`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_edge` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `VisualStyle` int NOT NULL DEFAULT '0',
+  `LeftTraitNodeID` int NOT NULL DEFAULT '0',
+  `RightTraitNodeID` int NOT NULL DEFAULT '0',
+  `Type` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node`
+--
+
+DROP TABLE IF EXISTS `trait_node`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `PosX` int NOT NULL DEFAULT '0',
+  `PosY` int NOT NULL DEFAULT '0',
+  `Type` tinyint NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node_entry`
+--
+
+DROP TABLE IF EXISTS `trait_node_entry`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node_entry` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitDefinitionID` int NOT NULL DEFAULT '0',
+  `MaxRanks` int NOT NULL DEFAULT '0',
+  `NodeEntryType` tinyint unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node_entry_x_trait_cond`
+--
+
+DROP TABLE IF EXISTS `trait_node_entry_x_trait_cond`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node_entry_x_trait_cond` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitCondID` int NOT NULL DEFAULT '0',
+  `TraitNodeEntryID` int unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node_entry_x_trait_cost`
+--
+
+DROP TABLE IF EXISTS `trait_node_entry_x_trait_cost`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node_entry_x_trait_cost` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitNodeEntryID` int NOT NULL DEFAULT '0',
+  `TraitCostID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node_group`
+--
+
+DROP TABLE IF EXISTS `trait_node_group`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node_group` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node_group_x_trait_cond`
+--
+
+DROP TABLE IF EXISTS `trait_node_group_x_trait_cond`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node_group_x_trait_cond` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitCondID` int NOT NULL DEFAULT '0',
+  `TraitNodeGroupID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node_group_x_trait_cost`
+--
+
+DROP TABLE IF EXISTS `trait_node_group_x_trait_cost`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node_group_x_trait_cost` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitNodeGroupID` int NOT NULL DEFAULT '0',
+  `TraitCostID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node_group_x_trait_node`
+--
+
+DROP TABLE IF EXISTS `trait_node_group_x_trait_node`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node_group_x_trait_node` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitNodeGroupID` int NOT NULL DEFAULT '0',
+  `TraitNodeID` int NOT NULL DEFAULT '0',
+  `Index` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node_x_trait_cond`
+--
+
+DROP TABLE IF EXISTS `trait_node_x_trait_cond`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node_x_trait_cond` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitCondID` int NOT NULL DEFAULT '0',
+  `TraitNodeID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node_x_trait_cost`
+--
+
+DROP TABLE IF EXISTS `trait_node_x_trait_cost`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node_x_trait_cost` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitNodeID` int unsigned NOT NULL DEFAULT '0',
+  `TraitCostID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_node_x_trait_node_entry`
+--
+
+DROP TABLE IF EXISTS `trait_node_x_trait_node_entry`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_node_x_trait_node_entry` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitNodeID` int NOT NULL DEFAULT '0',
+  `TraitNodeEntryID` int NOT NULL DEFAULT '0',
+  `Index` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_tree`
+--
+
+DROP TABLE IF EXISTS `trait_tree`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_tree` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitSystemID` int NOT NULL DEFAULT '0',
+  `Unused1000_1` int NOT NULL DEFAULT '0',
+  `FirstTraitNodeID` int NOT NULL DEFAULT '0',
+  `PlayerConditionID` int NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
+  `Unused1000_2` float NOT NULL DEFAULT '0',
+  `Unused1000_3` float NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_tree_loadout`
+--
+
+DROP TABLE IF EXISTS `trait_tree_loadout`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_tree_loadout` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `ChrSpecializationID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_tree_loadout_entry`
+--
+
+DROP TABLE IF EXISTS `trait_tree_loadout_entry`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_tree_loadout_entry` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitTreeLoadoutID` int NOT NULL DEFAULT '0',
+  `SelectedTraitNodeID` int NOT NULL DEFAULT '0',
+  `SelectedTraitNodeEntryID` int NOT NULL DEFAULT '0',
+  `NumPoints` int NOT NULL DEFAULT '0',
+  `OrderIndex` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_tree_x_trait_cost`
+--
+
+DROP TABLE IF EXISTS `trait_tree_x_trait_cost`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_tree_x_trait_cost` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
+  `TraitCostID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trait_tree_x_trait_currency`
+--
+
+DROP TABLE IF EXISTS `trait_tree_x_trait_currency`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `trait_tree_x_trait_currency` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Index` int NOT NULL DEFAULT '0',
+  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `TraitCurrencyID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `transmog_holiday`
 --
 
@@ -9076,6 +9712,7 @@ CREATE TABLE `ui_map_link` (
   `ParentUiMapID` int NOT NULL DEFAULT '0',
   `OrderIndex` int NOT NULL DEFAULT '0',
   `ChildUiMapID` int NOT NULL DEFAULT '0',
+  `PlayerConditionID` int NOT NULL DEFAULT '0',
   `OverrideHighlightFileDataID` int NOT NULL DEFAULT '0',
   `OverrideHighlightAtlasID` int NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
@@ -9582,4 +10219,4 @@ CREATE TABLE `world_state_expression` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-11-20 11:05:28
+-- Dump completed on 2022-12-20  3:10:19
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 52aafe97366..5b676a10ed4 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -2,7 +2,7 @@
 --
 -- Host: localhost    Database: world
 -- ------------------------------------------------------
--- Server version	8.0.31-0ubuntu0.20.04.1
+-- Server version	8.0.31-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -948,7 +948,7 @@ CREATE TABLE `creature_template` (
   `WidgetSetID` int NOT NULL DEFAULT '0',
   `WidgetSetUnitConditionID` int NOT NULL DEFAULT '0',
   `RegenHealth` tinyint unsigned NOT NULL DEFAULT '1',
-  `mechanic_immune_mask` int unsigned NOT NULL DEFAULT '0',
+  `mechanic_immune_mask` bigint unsigned NOT NULL DEFAULT '0',
   `spell_school_immune_mask` int unsigned NOT NULL DEFAULT '0',
   `flags_extra` int unsigned NOT NULL DEFAULT '0',
   `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
@@ -1866,33 +1866,22 @@ DROP TABLE IF EXISTS `gossip_menu_option`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gossip_menu_option` (
   `MenuID` int unsigned NOT NULL DEFAULT '0',
+  `GossipOptionID` int NOT NULL DEFAULT '0',
   `OptionID` int unsigned NOT NULL DEFAULT '0',
   `OptionNpc` tinyint unsigned NOT NULL DEFAULT '0',
   `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `OptionBroadcastTextID` int unsigned NOT NULL DEFAULT '0',
   `Language` int unsigned NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
   `ActionMenuID` int unsigned NOT NULL DEFAULT '0',
   `ActionPoiID` int unsigned NOT NULL DEFAULT '0',
+  `GossipNpcOptionID` int DEFAULT NULL,
   `BoxCoded` tinyint unsigned NOT NULL DEFAULT '0',
   `BoxMoney` int unsigned NOT NULL DEFAULT '0',
   `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `BoxBroadcastTextID` int unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` int NOT NULL DEFAULT '0',
-  PRIMARY KEY (`MenuID`,`OptionID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `gossip_menu_option_addon`
---
-
-DROP TABLE IF EXISTS `gossip_menu_option_addon`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `gossip_menu_option_addon` (
-  `MenuID` int unsigned NOT NULL DEFAULT '0',
-  `OptionID` int unsigned NOT NULL DEFAULT '0',
-  `GarrTalentTreeID` int DEFAULT NULL,
+  `SpellID` int DEFAULT NULL,
+  `OverrideIconID` int DEFAULT NULL,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`MenuID`,`OptionID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2951,6 +2940,44 @@ CREATE TABLE `prospecting_loot_template` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `quest_completion_log_conditional`
+--
+
+DROP TABLE IF EXISTS `quest_completion_log_conditional`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `quest_completion_log_conditional` (
+  `QuestId` int NOT NULL,
+  `PlayerConditionId` int NOT NULL,
+  `QuestgiverCreatureId` int NOT NULL,
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `OrderIndex` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestId`,`PlayerConditionId`,`QuestgiverCreatureId`,`locale`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `quest_description_conditional`
+--
+
+DROP TABLE IF EXISTS `quest_description_conditional`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `quest_description_conditional` (
+  `QuestId` int NOT NULL,
+  `PlayerConditionId` int NOT NULL,
+  `QuestgiverCreatureId` int NOT NULL,
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `OrderIndex` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestId`,`PlayerConditionId`,`QuestgiverCreatureId`,`locale`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `quest_details`
 --
 
@@ -3087,6 +3114,25 @@ CREATE TABLE `quest_offer_reward` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `quest_offer_reward_conditional`
+--
+
+DROP TABLE IF EXISTS `quest_offer_reward_conditional`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `quest_offer_reward_conditional` (
+  `QuestId` int NOT NULL,
+  `PlayerConditionId` int NOT NULL,
+  `QuestgiverCreatureId` int NOT NULL,
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `OrderIndex` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestId`,`PlayerConditionId`,`QuestgiverCreatureId`,`locale`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `quest_offer_reward_locale`
 --
 
@@ -3202,6 +3248,25 @@ CREATE TABLE `quest_request_items` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `quest_request_items_conditional`
+--
+
+DROP TABLE IF EXISTS `quest_request_items_conditional`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `quest_request_items_conditional` (
+  `QuestId` int NOT NULL,
+  `PlayerConditionId` int NOT NULL,
+  `QuestgiverCreatureId` int NOT NULL,
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `OrderIndex` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestId`,`PlayerConditionId`,`QuestgiverCreatureId`,`locale`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `quest_request_items_locale`
 --
 
@@ -3717,6 +3782,10 @@ CREATE TABLE `serverside_spell` (
   `TargetAuraSpell` int unsigned NOT NULL DEFAULT '0',
   `ExcludeCasterAuraSpell` int unsigned NOT NULL DEFAULT '0',
   `ExcludeTargetAuraSpell` int unsigned NOT NULL DEFAULT '0',
+  `CasterAuraType` int NOT NULL DEFAULT '0',
+  `TargetAuraType` int NOT NULL DEFAULT '0',
+  `ExcludeCasterAuraType` int NOT NULL DEFAULT '0',
+  `ExcludeTargetAuraType` int NOT NULL DEFAULT '0',
   `CastingTimeIndex` int unsigned NOT NULL DEFAULT '1',
   `RecoveryTime` int unsigned NOT NULL DEFAULT '0',
   `CategoryRecoveryTime` int unsigned NOT NULL DEFAULT '0',
@@ -4796,4 +4865,4 @@ CREATE TABLE `world_state` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-11-20 11:05:24
+-- Dump completed on 2022-12-20  3:10:14
diff --git a/sql/updates/auth/master/2022_11_20_00_auth.sql b/sql/old/10.x/auth/22111_2022_12_20/2022_11_20_00_auth.sql
index 7f3734af8d8..7f3734af8d8 100644
--- a/sql/updates/auth/master/2022_11_20_00_auth.sql
+++ b/sql/old/10.x/auth/22111_2022_12_20/2022_11_20_00_auth.sql
diff --git a/sql/updates/auth/master/2022_12_16_00_auth.sql b/sql/old/10.x/auth/22111_2022_12_20/2022_12_16_00_auth.sql
index 1c8144e6782..1c8144e6782 100644
--- a/sql/updates/auth/master/2022_12_16_00_auth.sql
+++ b/sql/old/10.x/auth/22111_2022_12_20/2022_12_16_00_auth.sql
diff --git a/sql/updates/auth/master/2022_12_17_00_auth.sql b/sql/old/10.x/auth/22111_2022_12_20/2022_12_17_00_auth.sql
index 142da8452a2..142da8452a2 100644
--- a/sql/updates/auth/master/2022_12_17_00_auth.sql
+++ b/sql/old/10.x/auth/22111_2022_12_20/2022_12_17_00_auth.sql
diff --git a/sql/updates/auth/master/2022_12_17_01_auth.sql b/sql/old/10.x/auth/22111_2022_12_20/2022_12_17_01_auth.sql
index 23ce1b5b4f9..23ce1b5b4f9 100644
--- a/sql/updates/auth/master/2022_12_17_01_auth.sql
+++ b/sql/old/10.x/auth/22111_2022_12_20/2022_12_17_01_auth.sql
diff --git a/sql/updates/characters/master/2022_11_20_00_characters.sql b/sql/old/10.x/characters/22111_2022_12_20/2022_11_20_00_characters.sql
index 46bfa1de3a1..46bfa1de3a1 100644
--- a/sql/updates/characters/master/2022_11_20_00_characters.sql
+++ b/sql/old/10.x/characters/22111_2022_12_20/2022_11_20_00_characters.sql
diff --git a/sql/updates/characters/master/2022_12_16_00_characters.sql b/sql/old/10.x/characters/22111_2022_12_20/2022_12_16_00_characters.sql
index 514d198f18b..514d198f18b 100644
--- a/sql/updates/characters/master/2022_12_16_00_characters.sql
+++ b/sql/old/10.x/characters/22111_2022_12_20/2022_12_16_00_characters.sql
diff --git a/sql/updates/characters/master/2022_12_17_00_characters.sql b/sql/old/10.x/characters/22111_2022_12_20/2022_12_17_00_characters.sql
index d9a6b09da7a..d9a6b09da7a 100644
--- a/sql/updates/characters/master/2022_12_17_00_characters.sql
+++ b/sql/old/10.x/characters/22111_2022_12_20/2022_12_17_00_characters.sql
diff --git a/sql/updates/hotfixes/master/2022_11_20_00_hotfixes.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_11_20_00_hotfixes.sql
index 9b451aef949..9b451aef949 100644
--- a/sql/updates/hotfixes/master/2022_11_20_00_hotfixes.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_11_20_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2022_12_16_00_hotfixes.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_16_00_hotfixes.sql
index 8c24cef1e71..8c24cef1e71 100644
--- a/sql/updates/hotfixes/master/2022_12_16_00_hotfixes.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_16_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2022_12_16_01_hotfixes.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_16_01_hotfixes.sql
index a76ff3ea1a1..a76ff3ea1a1 100644
--- a/sql/updates/hotfixes/master/2022_12_16_01_hotfixes.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_16_01_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2022_12_17_00_hotfixes_enUS.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_17_00_hotfixes_enUS.sql
index d2724dff546..d2724dff546 100644
--- a/sql/updates/hotfixes/master/2022_12_17_00_hotfixes_enUS.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_17_00_hotfixes_enUS.sql
diff --git a/sql/updates/hotfixes/master/2022_12_19_00_hotfixes_ptBR.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_00_hotfixes_ptBR.sql
index acc3f982cb4..acc3f982cb4 100644
--- a/sql/updates/hotfixes/master/2022_12_19_00_hotfixes_ptBR.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_00_hotfixes_ptBR.sql
diff --git a/sql/updates/hotfixes/master/2022_12_19_01_hotfixes_esMX.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_01_hotfixes_esMX.sql
index 4d7960048b0..4d7960048b0 100644
--- a/sql/updates/hotfixes/master/2022_12_19_01_hotfixes_esMX.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_01_hotfixes_esMX.sql
diff --git a/sql/updates/hotfixes/master/2022_12_19_02_hotfixes_esES.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_02_hotfixes_esES.sql
index 3d45c7399a1..3d45c7399a1 100644
--- a/sql/updates/hotfixes/master/2022_12_19_02_hotfixes_esES.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_02_hotfixes_esES.sql
diff --git a/sql/updates/hotfixes/master/2022_12_19_03_hotfixes_itIT.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_03_hotfixes_itIT.sql
index 04c8e056d9f..04c8e056d9f 100644
--- a/sql/updates/hotfixes/master/2022_12_19_03_hotfixes_itIT.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_03_hotfixes_itIT.sql
diff --git a/sql/updates/hotfixes/master/2022_12_19_04_hotfixes_ruRU.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_04_hotfixes_ruRU.sql
index 26fbc1ea6a7..26fbc1ea6a7 100644
--- a/sql/updates/hotfixes/master/2022_12_19_04_hotfixes_ruRU.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_04_hotfixes_ruRU.sql
diff --git a/sql/updates/hotfixes/master/2022_12_19_05_hotfixes_koKR.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_05_hotfixes_koKR.sql
index ba91995f880..ba91995f880 100644
--- a/sql/updates/hotfixes/master/2022_12_19_05_hotfixes_koKR.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_05_hotfixes_koKR.sql
diff --git a/sql/updates/hotfixes/master/2022_12_19_06_hotfixes_zhTW.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_06_hotfixes_zhTW.sql
index e824077d0bb..e824077d0bb 100644
--- a/sql/updates/hotfixes/master/2022_12_19_06_hotfixes_zhTW.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_06_hotfixes_zhTW.sql
diff --git a/sql/updates/hotfixes/master/2022_12_19_07_hotfixes_deDE.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_07_hotfixes_deDE.sql
index 9a9911b43fd..9a9911b43fd 100644
--- a/sql/updates/hotfixes/master/2022_12_19_07_hotfixes_deDE.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_07_hotfixes_deDE.sql
diff --git a/sql/updates/hotfixes/master/2022_12_19_08_hotfixes_frFR.sql b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_08_hotfixes_frFR.sql
index 025b88ee207..025b88ee207 100644
--- a/sql/updates/hotfixes/master/2022_12_19_08_hotfixes_frFR.sql
+++ b/sql/old/10.x/hotfixes/22111_2022_12_20/2022_12_19_08_hotfixes_frFR.sql
diff --git a/sql/updates/world/master/2022_11_20_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_11_20_00_world.sql
index 59833286749..59833286749 100644
--- a/sql/updates/world/master/2022_11_20_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_11_20_00_world.sql
diff --git a/sql/updates/world/master/2022_11_20_01_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_11_20_01_world.sql
index bcd5fe9c8bd..bcd5fe9c8bd 100644
--- a/sql/updates/world/master/2022_11_20_01_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_11_20_01_world.sql
diff --git a/sql/updates/world/master/2022_11_22_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_11_22_00_world.sql
index 8a384ae1715..8a384ae1715 100644
--- a/sql/updates/world/master/2022_11_22_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_11_22_00_world.sql
diff --git a/sql/updates/world/master/2022_11_28_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_11_28_00_world.sql
index 0c249cb8936..0c249cb8936 100644
--- a/sql/updates/world/master/2022_11_28_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_11_28_00_world.sql
diff --git a/sql/updates/world/master/2022_11_28_01_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_11_28_01_world.sql
index c79cf09e3c6..c79cf09e3c6 100644
--- a/sql/updates/world/master/2022_11_28_01_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_11_28_01_world.sql
diff --git a/sql/updates/world/master/2022_11_28_02_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_11_28_02_world.sql
index 6ecab4cc6c6..6ecab4cc6c6 100644
--- a/sql/updates/world/master/2022_11_28_02_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_11_28_02_world.sql
diff --git a/sql/updates/world/master/2022_11_28_03_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_11_28_03_world.sql
index e0e2395fda9..e0e2395fda9 100644
--- a/sql/updates/world/master/2022_11_28_03_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_11_28_03_world.sql
diff --git a/sql/updates/world/master/2022_11_28_04_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_11_28_04_world.sql
index 701754668f4..701754668f4 100644
--- a/sql/updates/world/master/2022_11_28_04_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_11_28_04_world.sql
diff --git a/sql/updates/world/master/2022_12_04_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_04_00_world.sql
index 3752651d81b..3752651d81b 100644
--- a/sql/updates/world/master/2022_12_04_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_04_00_world.sql
diff --git a/sql/updates/world/master/2022_12_05_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_00_world.sql
index 417033caf34..417033caf34 100644
--- a/sql/updates/world/master/2022_12_05_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_00_world.sql
diff --git a/sql/updates/world/master/2022_12_05_01_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_01_world.sql
index aaaecc3b6a3..aaaecc3b6a3 100644
--- a/sql/updates/world/master/2022_12_05_01_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_01_world.sql
diff --git a/sql/updates/world/master/2022_12_05_02_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_02_world.sql
index 9464e53980a..9464e53980a 100644
--- a/sql/updates/world/master/2022_12_05_02_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_02_world.sql
diff --git a/sql/updates/world/master/2022_12_05_03_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_03_world.sql
index 4ca9d17e851..4ca9d17e851 100644
--- a/sql/updates/world/master/2022_12_05_03_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_03_world.sql
diff --git a/sql/updates/world/master/2022_12_05_04_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_04_world.sql
index 9e88e36e700..9e88e36e700 100644
--- a/sql/updates/world/master/2022_12_05_04_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_04_world.sql
diff --git a/sql/updates/world/master/2022_12_05_05_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_05_world.sql
index 6bfbd0c1345..6bfbd0c1345 100644
--- a/sql/updates/world/master/2022_12_05_05_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_05_world.sql
diff --git a/sql/updates/world/master/2022_12_05_06_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_06_world.sql
index b59a0998486..b59a0998486 100644
--- a/sql/updates/world/master/2022_12_05_06_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_06_world.sql
diff --git a/sql/updates/world/master/2022_12_05_07_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_07_world.sql
index c1bbb1f4134..c1bbb1f4134 100644
--- a/sql/updates/world/master/2022_12_05_07_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_05_07_world.sql
diff --git a/sql/updates/world/master/2022_12_06_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_00_world.sql
index 4fe5e72d9d0..4fe5e72d9d0 100644
--- a/sql/updates/world/master/2022_12_06_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_00_world.sql
diff --git a/sql/updates/world/master/2022_12_06_01_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_01_world.sql
index 0d397fcbb81..0d397fcbb81 100644
--- a/sql/updates/world/master/2022_12_06_01_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_01_world.sql
diff --git a/sql/updates/world/master/2022_12_06_02_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_02_world.sql
index 599d5ccaf64..599d5ccaf64 100644
--- a/sql/updates/world/master/2022_12_06_02_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_02_world.sql
diff --git a/sql/updates/world/master/2022_12_06_03_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_03_world.sql
index 7a4f2ad8ea0..7a4f2ad8ea0 100644
--- a/sql/updates/world/master/2022_12_06_03_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_03_world.sql
diff --git a/sql/updates/world/master/2022_12_06_04_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_04_world.sql
index d8934655439..d8934655439 100644
--- a/sql/updates/world/master/2022_12_06_04_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_04_world.sql
diff --git a/sql/updates/world/master/2022_12_06_05_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_05_world.sql
index bbfca291d9d..bbfca291d9d 100644
--- a/sql/updates/world/master/2022_12_06_05_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_05_world.sql
diff --git a/sql/updates/world/master/2022_12_06_06_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_06_world.sql
index 97f1e03047e..97f1e03047e 100644
--- a/sql/updates/world/master/2022_12_06_06_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_06_world.sql
diff --git a/sql/updates/world/master/2022_12_06_07_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_07_world.sql
index a4ab8a8bfb6..a4ab8a8bfb6 100644
--- a/sql/updates/world/master/2022_12_06_07_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_06_07_world.sql
diff --git a/sql/updates/world/master/2022_12_07_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_00_world.sql
index dc8492c4c52..dc8492c4c52 100644
--- a/sql/updates/world/master/2022_12_07_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_00_world.sql
diff --git a/sql/updates/world/master/2022_12_07_01_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_01_world.sql
index f604543eed8..f604543eed8 100644
--- a/sql/updates/world/master/2022_12_07_01_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_01_world.sql
diff --git a/sql/updates/world/master/2022_12_07_02_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_02_world.sql
index d9a09fd850c..d9a09fd850c 100644
--- a/sql/updates/world/master/2022_12_07_02_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_02_world.sql
diff --git a/sql/updates/world/master/2022_12_07_03_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_03_world.sql
index 1b8d83cb870..1b8d83cb870 100644
--- a/sql/updates/world/master/2022_12_07_03_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_03_world.sql
diff --git a/sql/updates/world/master/2022_12_07_04_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_04_world.sql
index afa9b21abc4..afa9b21abc4 100644
--- a/sql/updates/world/master/2022_12_07_04_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_04_world.sql
diff --git a/sql/updates/world/master/2022_12_07_05_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_05_world.sql
index ac5340a1154..ac5340a1154 100644
--- a/sql/updates/world/master/2022_12_07_05_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_05_world.sql
diff --git a/sql/updates/world/master/2022_12_07_06_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_06_world.sql
index 9738cf1f227..9738cf1f227 100644
--- a/sql/updates/world/master/2022_12_07_06_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_06_world.sql
diff --git a/sql/updates/world/master/2022_12_07_07_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_07_world.sql
index 4f9538d23a4..4f9538d23a4 100644
--- a/sql/updates/world/master/2022_12_07_07_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_07_world.sql
diff --git a/sql/updates/world/master/2022_12_07_08_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_08_world.sql
index 9db32e3f962..9db32e3f962 100644
--- a/sql/updates/world/master/2022_12_07_08_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_08_world.sql
diff --git a/sql/updates/world/master/2022_12_07_09_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_09_world.sql
index 77c600e7153..77c600e7153 100644
--- a/sql/updates/world/master/2022_12_07_09_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_09_world.sql
diff --git a/sql/updates/world/master/2022_12_07_10_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_10_world.sql
index bd2a218834f..bd2a218834f 100644
--- a/sql/updates/world/master/2022_12_07_10_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_10_world.sql
diff --git a/sql/updates/world/master/2022_12_07_11_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_11_world.sql
index 939ad106e2e..939ad106e2e 100644
--- a/sql/updates/world/master/2022_12_07_11_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_07_11_world.sql
diff --git a/sql/updates/world/master/2022_12_08_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_00_world.sql
index a3183e9e7ab..a3183e9e7ab 100644
--- a/sql/updates/world/master/2022_12_08_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_00_world.sql
diff --git a/sql/updates/world/master/2022_12_08_01_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_01_world.sql
index 0d174055ea0..0d174055ea0 100644
--- a/sql/updates/world/master/2022_12_08_01_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_01_world.sql
diff --git a/sql/updates/world/master/2022_12_08_02_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_02_world.sql
index c805310bbd5..c805310bbd5 100644
--- a/sql/updates/world/master/2022_12_08_02_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_02_world.sql
diff --git a/sql/updates/world/master/2022_12_08_03_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_03_world.sql
index 8a9bb15c725..8a9bb15c725 100644
--- a/sql/updates/world/master/2022_12_08_03_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_03_world.sql
diff --git a/sql/updates/world/master/2022_12_08_04_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_04_world.sql
index 203527ea057..203527ea057 100644
--- a/sql/updates/world/master/2022_12_08_04_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_04_world.sql
diff --git a/sql/updates/world/master/2022_12_08_05_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_05_world.sql
index bdb2c579890..bdb2c579890 100644
--- a/sql/updates/world/master/2022_12_08_05_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_05_world.sql
diff --git a/sql/updates/world/master/2022_12_08_06_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_06_world.sql
index dc8763e747b..dc8763e747b 100644
--- a/sql/updates/world/master/2022_12_08_06_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_06_world.sql
diff --git a/sql/updates/world/master/2022_12_08_07_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_07_world.sql
index 76835a8bf3a..76835a8bf3a 100644
--- a/sql/updates/world/master/2022_12_08_07_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_07_world.sql
diff --git a/sql/updates/world/master/2022_12_08_08_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_08_world.sql
index da4a541e363..da4a541e363 100644
--- a/sql/updates/world/master/2022_12_08_08_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_08_world.sql
diff --git a/sql/updates/world/master/2022_12_08_09_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_09_world.sql
index c3a607ab0c7..c3a607ab0c7 100644
--- a/sql/updates/world/master/2022_12_08_09_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_09_world.sql
diff --git a/sql/updates/world/master/2022_12_08_10_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_10_world.sql
index 5163fb39143..5163fb39143 100644
--- a/sql/updates/world/master/2022_12_08_10_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_10_world.sql
diff --git a/sql/updates/world/master/2022_12_08_11_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_11_world.sql
index f52e03d8bcf..f52e03d8bcf 100644
--- a/sql/updates/world/master/2022_12_08_11_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_11_world.sql
diff --git a/sql/updates/world/master/2022_12_08_12_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_12_world.sql
index 0b0491492bd..0b0491492bd 100644
--- a/sql/updates/world/master/2022_12_08_12_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_12_world.sql
diff --git a/sql/updates/world/master/2022_12_08_13_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_13_world.sql
index 26da0d46894..26da0d46894 100644
--- a/sql/updates/world/master/2022_12_08_13_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_13_world.sql
diff --git a/sql/updates/world/master/2022_12_08_14_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_14_world.sql
index 9c97c13f0d4..9c97c13f0d4 100644
--- a/sql/updates/world/master/2022_12_08_14_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_14_world.sql
diff --git a/sql/updates/world/master/2022_12_08_15_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_15_world.sql
index b95c82c6467..b95c82c6467 100644
--- a/sql/updates/world/master/2022_12_08_15_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_08_15_world.sql
diff --git a/sql/updates/world/master/2022_12_10_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_10_00_world.sql
index 0435ba945e7..0435ba945e7 100644
--- a/sql/updates/world/master/2022_12_10_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_10_00_world.sql
diff --git a/sql/updates/world/master/2022_12_10_01_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_10_01_world.sql
index 2d02042c22b..2d02042c22b 100644
--- a/sql/updates/world/master/2022_12_10_01_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_10_01_world.sql
diff --git a/sql/updates/world/master/2022_12_10_02_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_10_02_world.sql
index 35f0742fc82..35f0742fc82 100644
--- a/sql/updates/world/master/2022_12_10_02_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_10_02_world.sql
diff --git a/sql/updates/world/master/2022_12_10_03_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_10_03_world.sql
index 85c6537f64d..85c6537f64d 100644
--- a/sql/updates/world/master/2022_12_10_03_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_10_03_world.sql
diff --git a/sql/updates/world/master/2022_12_10_04_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_10_04_world.sql
index a2b65e9aa41..a2b65e9aa41 100644
--- a/sql/updates/world/master/2022_12_10_04_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_10_04_world.sql
diff --git a/sql/updates/world/master/2022_12_12_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_12_00_world.sql
index 2d66741460b..2d66741460b 100644
--- a/sql/updates/world/master/2022_12_12_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_12_00_world.sql
diff --git a/sql/updates/world/master/2022_12_12_01_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_12_01_world.sql
index 75eb03a6ba0..75eb03a6ba0 100644
--- a/sql/updates/world/master/2022_12_12_01_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_12_01_world.sql
diff --git a/sql/updates/world/master/2022_12_12_02_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_12_02_world.sql
index 18bd2180588..18bd2180588 100644
--- a/sql/updates/world/master/2022_12_12_02_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_12_02_world.sql
diff --git a/sql/updates/world/master/2022_12_13_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_13_00_world.sql
index 0d685348087..0d685348087 100644
--- a/sql/updates/world/master/2022_12_13_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_13_00_world.sql
diff --git a/sql/updates/world/master/2022_12_16_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_16_00_world.sql
index d2ec3dd87de..d2ec3dd87de 100644
--- a/sql/updates/world/master/2022_12_16_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_16_00_world.sql
diff --git a/sql/updates/world/master/2022_12_17_00_world_enUS.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_17_00_world_enUS.sql
index 4ae31db0c3e..4ae31db0c3e 100644
--- a/sql/updates/world/master/2022_12_17_00_world_enUS.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_17_00_world_enUS.sql
diff --git a/sql/updates/world/master/2022_12_17_01_world_enUS.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_17_01_world_enUS.sql
index dae051334dd..dae051334dd 100644
--- a/sql/updates/world/master/2022_12_17_01_world_enUS.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_17_01_world_enUS.sql
diff --git a/sql/updates/world/master/2022_12_19_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_00_world.sql
index f4b3aef61ba..f4b3aef61ba 100644
--- a/sql/updates/world/master/2022_12_19_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_00_world.sql
diff --git a/sql/updates/world/master/2022_12_19_01_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_01_world.sql
index 0a76c0a9533..0a76c0a9533 100644
--- a/sql/updates/world/master/2022_12_19_01_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_01_world.sql
diff --git a/sql/updates/world/master/2022_12_19_02_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_02_world.sql
index e7178878497..e7178878497 100644
--- a/sql/updates/world/master/2022_12_19_02_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_02_world.sql
diff --git a/sql/updates/world/master/2022_12_19_03_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_03_world.sql
index 4db01635bff..4db01635bff 100644
--- a/sql/updates/world/master/2022_12_19_03_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_03_world.sql
diff --git a/sql/updates/world/master/2022_12_19_04_world_ptBR.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_04_world_ptBR.sql
index 02d400e1765..02d400e1765 100644
--- a/sql/updates/world/master/2022_12_19_04_world_ptBR.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_04_world_ptBR.sql
diff --git a/sql/updates/world/master/2022_12_19_05_world_esMX.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_05_world_esMX.sql
index d14983ed61d..d14983ed61d 100644
--- a/sql/updates/world/master/2022_12_19_05_world_esMX.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_05_world_esMX.sql
diff --git a/sql/updates/world/master/2022_12_19_06_world_esES.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_06_world_esES.sql
index a0a0e9af340..a0a0e9af340 100644
--- a/sql/updates/world/master/2022_12_19_06_world_esES.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_06_world_esES.sql
diff --git a/sql/updates/world/master/2022_12_19_07_world_itIT.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_07_world_itIT.sql
index 90182b805d0..90182b805d0 100644
--- a/sql/updates/world/master/2022_12_19_07_world_itIT.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_07_world_itIT.sql
diff --git a/sql/updates/world/master/2022_12_19_08_world_ruRU.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_08_world_ruRU.sql
index 72d16befb02..72d16befb02 100644
--- a/sql/updates/world/master/2022_12_19_08_world_ruRU.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_08_world_ruRU.sql
diff --git a/sql/updates/world/master/2022_12_19_09_world_koKR.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_09_world_koKR.sql
index c9c1f0ca929..c9c1f0ca929 100644
--- a/sql/updates/world/master/2022_12_19_09_world_koKR.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_09_world_koKR.sql
diff --git a/sql/updates/world/master/2022_12_19_10_world_zhTW.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_10_world_zhTW.sql
index 2ea24a4e8bc..2ea24a4e8bc 100644
--- a/sql/updates/world/master/2022_12_19_10_world_zhTW.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_10_world_zhTW.sql
diff --git a/sql/updates/world/master/2022_12_19_11_world_deDE.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_11_world_deDE.sql
index 8f753757757..8f753757757 100644
--- a/sql/updates/world/master/2022_12_19_11_world_deDE.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_11_world_deDE.sql
diff --git a/sql/updates/world/master/2022_12_19_12_world_frFR.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_12_world_frFR.sql
index e6229f47b13..e6229f47b13 100644
--- a/sql/updates/world/master/2022_12_19_12_world_frFR.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_12_world_frFR.sql
diff --git a/sql/updates/world/master/2022_12_19_13_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_13_world.sql
index 9c4e7765072..9c4e7765072 100644
--- a/sql/updates/world/master/2022_12_19_13_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_13_world.sql
diff --git a/sql/updates/world/master/2022_12_19_14_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_14_world.sql
index 7ff27aa5e7b..7ff27aa5e7b 100644
--- a/sql/updates/world/master/2022_12_19_14_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_14_world.sql
diff --git a/sql/updates/world/master/2022_12_19_15_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_15_world.sql
index a44faa6b930..a44faa6b930 100644
--- a/sql/updates/world/master/2022_12_19_15_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_15_world.sql
diff --git a/sql/updates/world/master/2022_12_19_16_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_16_world.sql
index 07d0840256d..07d0840256d 100644
--- a/sql/updates/world/master/2022_12_19_16_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_16_world.sql
diff --git a/sql/updates/world/master/2022_12_19_17_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_17_world.sql
index 777dc504350..777dc504350 100644
--- a/sql/updates/world/master/2022_12_19_17_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_17_world.sql
diff --git a/sql/updates/world/master/2022_12_19_18_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_18_world.sql
index a88dba60aeb..a88dba60aeb 100644
--- a/sql/updates/world/master/2022_12_19_18_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_18_world.sql
diff --git a/sql/updates/world/master/2022_12_19_19_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_19_world.sql
index d745a2ce468..d745a2ce468 100644
--- a/sql/updates/world/master/2022_12_19_19_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_19_world.sql
diff --git a/sql/updates/world/master/2022_12_19_20_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_20_world.sql
index 40ac4790399..40ac4790399 100644
--- a/sql/updates/world/master/2022_12_19_20_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_20_world.sql
diff --git a/sql/updates/world/master/2022_12_19_21_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_21_world.sql
index 245fa745823..245fa745823 100644
--- a/sql/updates/world/master/2022_12_19_21_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_21_world.sql
diff --git a/sql/updates/world/master/2022_12_19_22_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_22_world.sql
index 606fb8e925f..606fb8e925f 100644
--- a/sql/updates/world/master/2022_12_19_22_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_19_22_world.sql
diff --git a/sql/updates/world/master/2022_12_20_00_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_20_00_world.sql
index e7053a907e1..e7053a907e1 100644
--- a/sql/updates/world/master/2022_12_20_00_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_20_00_world.sql
diff --git a/sql/updates/world/master/2022_12_20_01_world.sql b/sql/old/10.x/world/22111_2022_12_20/2022_12_20_01_world.sql
index ecc0d67a6f2..ecc0d67a6f2 100644
--- a/sql/updates/world/master/2022_12_20_01_world.sql
+++ b/sql/old/10.x/world/22111_2022_12_20/2022_12_20_01_world.sql
diff --git a/sql/updates/auth/master/2022_12_20_00_auth.sql b/sql/updates/auth/master/2022_12_20_00_auth.sql
new file mode 100644
index 00000000000..36ae1aeddab
--- /dev/null
+++ b/sql/updates/auth/master/2022_12_20_00_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 1002.22121 auth
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED');
diff --git a/sql/updates/characters/master/2022_12_20_00_characters.sql b/sql/updates/characters/master/2022_12_20_00_characters.sql
new file mode 100644
index 00000000000..27a01e4766e
--- /dev/null
+++ b/sql/updates/characters/master/2022_12_20_00_characters.sql
@@ -0,0 +1,3 @@
+-- TDB 1002.22121 characters
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED');
diff --git a/sql/updates/hotfixes/master/2022_12_20_00_hotfixes.sql b/sql/updates/hotfixes/master/2022_12_20_00_hotfixes.sql
new file mode 100644
index 00000000000..cf68adfcf7f
--- /dev/null
+++ b/sql/updates/hotfixes/master/2022_12_20_00_hotfixes.sql
@@ -0,0 +1,3 @@
+-- TDB 1002.22121 hotfixes
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/hotfixes', 'ARCHIVED');
diff --git a/sql/updates/world/master/2022_12_20_02_world.sql b/sql/updates/world/master/2022_12_20_02_world.sql
new file mode 100644
index 00000000000..a4df5b1d58e
--- /dev/null
+++ b/sql/updates/world/master/2022_12_20_02_world.sql
@@ -0,0 +1,4 @@
+-- TDB 1002.22121 world
+UPDATE `version` SET `db_version`='TDB 1002.22121', `cache_id`=22121 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/world', 'ARCHIVED');