From 06b9be494a7e4d1249d11550cc0eec2e35712d25 Mon Sep 17 00:00:00 2001
From: TDB Release <tdb-release@build.bot>
Date: Wed, 17 Nov 2021 13:31:04 +0000
Subject: TDB 915.21111 - 2021/11/17

---
 sql/base/dev/hotfixes_database.sql | 654 ++++++++++++++++++++++++++++++++++---
 1 file changed, 603 insertions(+), 51 deletions(-)

(limited to 'sql/base/dev/hotfixes_database.sql')

diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index d27b8f2a777..81ffe5ad1b0 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 5.7.35, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 5.7.36, for Linux (x86_64)
 --
 -- Host: localhost    Database: hotfixes
 -- ------------------------------------------------------
--- Server version	5.7.35
+-- Server version	5.7.36
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -268,9 +268,9 @@ DROP TABLE IF EXISTS `animation_data`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `animation_data` (
   `ID` int(10) unsigned NOT NULL DEFAULT '0',
-  `BehaviorID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `Fallback` smallint(5) unsigned NOT NULL DEFAULT '0',
   `BehaviorTier` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `Fallback` int(11) NOT NULL DEFAULT '0',
+  `BehaviorID` int(11) NOT NULL DEFAULT '0',
   `Flags1` int(11) NOT NULL DEFAULT '0',
   `Flags2` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
@@ -969,7 +969,7 @@ CREATE TABLE `azerite_power_set_member` (
   `AzeritePowerSetID` int(11) NOT NULL DEFAULT '0',
   `AzeritePowerID` int(11) NOT NULL DEFAULT '0',
   `Class` int(11) NOT NULL DEFAULT '0',
-  `Tier` int(11) NOT NULL DEFAULT '0',
+  `Tier` tinyint(4) NOT NULL DEFAULT '0',
   `OrderIndex` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -1304,8 +1304,8 @@ CREATE TABLE `broadcast_text` (
   `EmotesID` smallint(5) unsigned NOT NULL DEFAULT '0',
   `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `ChatBubbleDurationMs` int(10) unsigned NOT NULL DEFAULT '0',
-  `SoundEntriesID1` int(10) unsigned NOT NULL DEFAULT '0',
-  `SoundEntriesID2` int(10) unsigned NOT NULL DEFAULT '0',
+  `SoundKitID1` int(10) unsigned NOT NULL DEFAULT '0',
+  `SoundKitID2` int(10) unsigned NOT NULL DEFAULT '0',
   `EmoteID1` smallint(5) unsigned NOT NULL DEFAULT '0',
   `EmoteID2` smallint(5) unsigned NOT NULL DEFAULT '0',
   `EmoteID3` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1317,6 +1317,23 @@ CREATE TABLE `broadcast_text` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `broadcast_text_duration`
+--
+
+DROP TABLE IF EXISTS `broadcast_text_duration`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `broadcast_text_duration` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `BroadcastTextID` int(11) NOT NULL DEFAULT '0',
+  `Locale` int(11) NOT NULL DEFAULT '0',
+  `Duration` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `broadcast_text_locale`
 --
@@ -1552,9 +1569,9 @@ CREATE TABLE `chr_classes` (
   `AttackPowerPerAgility` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `AttackPowerPerStrength` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `SpellClassSet` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `ChatColorR` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `ChatColorG` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `ChatColorB` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ClassColorR` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ClassColorG` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ClassColorB` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1625,6 +1642,7 @@ CREATE TABLE `chr_customization_choice` (
   `SortOrder` smallint(5) unsigned NOT NULL DEFAULT '0',
   `UiOrderIndex` smallint(5) unsigned NOT NULL DEFAULT '0',
   `Flags` int(11) NOT NULL DEFAULT '0',
+  `AddedInPatch` int(11) NOT NULL DEFAULT '0',
   `SwatchColor1` int(11) NOT NULL DEFAULT '0',
   `SwatchColor2` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
@@ -1720,6 +1738,7 @@ CREATE TABLE `chr_customization_option` (
   `ChrCustomizationID` int(11) NOT NULL DEFAULT '0',
   `ChrCustomizationReqID` int(11) NOT NULL DEFAULT '0',
   `UiOrderIndex` int(11) NOT NULL DEFAULT '0',
+  `AddedInPatch` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1852,15 +1871,15 @@ CREATE TABLE `chr_races` (
   `NameFemale` text COLLATE utf8mb4_unicode_ci,
   `NameLowercase` text COLLATE utf8mb4_unicode_ci,
   `NameFemaleLowercase` text COLLATE utf8mb4_unicode_ci,
-  `NameS` text COLLATE utf8mb4_unicode_ci,
-  `NameFemaleS` text COLLATE utf8mb4_unicode_ci,
-  `NameLowercaseS` text COLLATE utf8mb4_unicode_ci,
-  `NameFemaleLowercaseS` text COLLATE utf8mb4_unicode_ci,
-  `RaceFantasyDescription` text COLLATE utf8mb4_unicode_ci,
-  `NameL` text COLLATE utf8mb4_unicode_ci,
-  `NameFemaleL` text COLLATE utf8mb4_unicode_ci,
-  `NameLowercaseL` text COLLATE utf8mb4_unicode_ci,
-  `NameFemaleLowercaseL` text COLLATE utf8mb4_unicode_ci,
+  `LoreName` text COLLATE utf8mb4_unicode_ci,
+  `LoreNameFemale` text COLLATE utf8mb4_unicode_ci,
+  `LoreNameLower` text COLLATE utf8mb4_unicode_ci,
+  `LoreNameLowerFemale` text COLLATE utf8mb4_unicode_ci,
+  `LoreDescription` text COLLATE utf8mb4_unicode_ci,
+  `ShortName` text COLLATE utf8mb4_unicode_ci,
+  `ShortNameFemale` text COLLATE utf8mb4_unicode_ci,
+  `ShortNameLower` text COLLATE utf8mb4_unicode_ci,
+  `ShortNameLowerFemale` text COLLATE utf8mb4_unicode_ci,
   `Flags` int(11) NOT NULL DEFAULT '0',
   `FactionID` int(11) NOT NULL DEFAULT '0',
   `CinematicSequenceID` int(11) NOT NULL DEFAULT '0',
@@ -1926,15 +1945,15 @@ CREATE TABLE `chr_races_locale` (
   `NameFemale_lang` text COLLATE utf8mb4_unicode_ci,
   `NameLowercase_lang` text COLLATE utf8mb4_unicode_ci,
   `NameFemaleLowercase_lang` text COLLATE utf8mb4_unicode_ci,
-  `NameS_lang` text COLLATE utf8mb4_unicode_ci,
-  `NameFemaleS_lang` text COLLATE utf8mb4_unicode_ci,
-  `NameLowercaseS_lang` text COLLATE utf8mb4_unicode_ci,
-  `NameFemaleLowercaseS_lang` text COLLATE utf8mb4_unicode_ci,
-  `RaceFantasyDescription_lang` text COLLATE utf8mb4_unicode_ci,
-  `NameL_lang` text COLLATE utf8mb4_unicode_ci,
-  `NameFemaleL_lang` text COLLATE utf8mb4_unicode_ci,
-  `NameLowercaseL_lang` text COLLATE utf8mb4_unicode_ci,
-  `NameFemaleLowercaseL_lang` text COLLATE utf8mb4_unicode_ci,
+  `LoreName_lang` text COLLATE utf8mb4_unicode_ci,
+  `LoreNameFemale_lang` text COLLATE utf8mb4_unicode_ci,
+  `LoreNameLower_lang` text COLLATE utf8mb4_unicode_ci,
+  `LoreNameLowerFemale_lang` text COLLATE utf8mb4_unicode_ci,
+  `LoreDescription_lang` text COLLATE utf8mb4_unicode_ci,
+  `ShortName_lang` text COLLATE utf8mb4_unicode_ci,
+  `ShortNameFemale_lang` text COLLATE utf8mb4_unicode_ci,
+  `ShortNameLower_lang` text COLLATE utf8mb4_unicode_ci,
+  `ShortNameLowerFemale_lang` text COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
@@ -2022,6 +2041,7 @@ CREATE TABLE `cinematic_camera` (
   `SoundID` int(10) unsigned NOT NULL DEFAULT '0',
   `OriginFacing` float NOT NULL DEFAULT '0',
   `FileDataID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Unknown915` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2471,6 +2491,56 @@ CREATE TABLE `criteria_tree_locale` (
  PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `currency_container`
+--
+
+DROP TABLE IF EXISTS `currency_container`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `currency_container` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `ContainerName` text COLLATE utf8mb4_unicode_ci,
+  `ContainerDescription` text COLLATE utf8mb4_unicode_ci,
+  `MinAmount` int(11) NOT NULL DEFAULT '0',
+  `MaxAmount` int(11) NOT NULL DEFAULT '0',
+  `ContainerIconID` int(11) NOT NULL DEFAULT '0',
+  `ContainerQuality` int(11) NOT NULL DEFAULT '0',
+  `OnLootSpellVisualKitID` int(11) NOT NULL DEFAULT '0',
+  `CurrencyTypesID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `currency_container_locale`
+--
+
+DROP TABLE IF EXISTS `currency_container_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `currency_container_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `ContainerName_lang` text COLLATE utf8mb4_unicode_ci,
+  `ContainerDescription_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int(11) 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 `currency_types`
 --
@@ -2983,6 +3053,7 @@ CREATE TABLE `friendship_rep_reaction` (
   `Reaction` text COLLATE utf8mb4_unicode_ci,
   `FriendshipRepID` int(10) unsigned NOT NULL DEFAULT '0',
   `ReactionThreshold` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `OverrideColor` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3164,10 +3235,10 @@ CREATE TABLE `garr_ability` (
   `Name` text COLLATE utf8mb4_unicode_ci,
   `Description` text COLLATE utf8mb4_unicode_ci,
   `GarrAbilityCategoryID` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `GarrFollowerTypeID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `GarrFollowerTypeID` tinyint(4) NOT NULL DEFAULT '0',
   `IconFileDataID` int(11) NOT NULL DEFAULT '0',
   `FactionChangeGarrAbilityID` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `Flags` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3215,7 +3286,7 @@ CREATE TABLE `garr_building` (
   `Description` text COLLATE utf8mb4_unicode_ci,
   `Tooltip` text COLLATE utf8mb4_unicode_ci,
   `GarrTypeID` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `BuildingType` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `BuildingType` tinyint(4) NOT NULL DEFAULT '0',
   `HordeGameObjectID` int(11) NOT NULL DEFAULT '0',
   `AllianceGameObjectID` int(11) NOT NULL DEFAULT '0',
   `GarrSiteID` int(11) NOT NULL DEFAULT '0',
@@ -3233,7 +3304,7 @@ CREATE TABLE `garr_building` (
   `GarrAbilityID` smallint(5) unsigned NOT NULL DEFAULT '0',
   `BonusGarrAbilityID` smallint(5) unsigned NOT NULL DEFAULT '0',
   `GoldCost` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3303,7 +3374,7 @@ CREATE TABLE `garr_class_spec` (
   `UiTextureAtlasMemberID` smallint(5) unsigned NOT NULL DEFAULT '0',
   `GarrFollItemSetID` smallint(5) unsigned NOT NULL DEFAULT '0',
   `FollowerClassLimit` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3351,14 +3422,14 @@ CREATE TABLE `garr_follower` (
   `AllianceSourceText` text COLLATE utf8mb4_unicode_ci,
   `TitleName` text COLLATE utf8mb4_unicode_ci,
   `GarrTypeID` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `GarrFollowerTypeID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `GarrFollowerTypeID` tinyint(4) NOT NULL DEFAULT '0',
   `HordeCreatureID` int(11) NOT NULL DEFAULT '0',
   `AllianceCreatureID` int(11) NOT NULL DEFAULT '0',
   `HordeGarrFollRaceID` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `AllianceGarrFollRaceID` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `HordeGarrClassSpecID` int(11) NOT NULL DEFAULT '0',
   `AllianceGarrClassSpecID` int(11) NOT NULL DEFAULT '0',
-  `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Quality` tinyint(4) NOT NULL DEFAULT '0',
   `FollowerLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `ItemLevelWeapon` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ItemLevelArmor` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -3376,7 +3447,7 @@ CREATE TABLE `garr_follower` (
   `HordeSlottingBroadcastTextID` int(10) unsigned NOT NULL DEFAULT '0',
   `AllySlottingBroadcastTextID` int(10) unsigned NOT NULL DEFAULT '0',
   `ChrClassID` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(11) NOT NULL DEFAULT '0',
   `Gender` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `AutoCombatantID` int(11) NOT NULL DEFAULT '0',
   `CovenantID` int(11) NOT NULL DEFAULT '0',
@@ -3432,6 +3503,82 @@ CREATE TABLE `garr_follower_x_ability` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `garr_mission`
+--
+
+DROP TABLE IF EXISTS `garr_mission`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `garr_mission` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text COLLATE utf8mb4_unicode_ci,
+  `Location` text COLLATE utf8mb4_unicode_ci,
+  `Description` text COLLATE utf8mb4_unicode_ci,
+  `MapPosX` float NOT NULL DEFAULT '0',
+  `MapPosY` float NOT NULL DEFAULT '0',
+  `WorldPosX` float NOT NULL DEFAULT '0',
+  `WorldPosY` float NOT NULL DEFAULT '0',
+  `GarrTypeID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `GarrMissionTypeID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `GarrFollowerTypeID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `MaxFollowers` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `MissionCost` int(10) unsigned NOT NULL DEFAULT '0',
+  `MissionCostCurrencyTypesID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `OfferedGarrMissionTextureID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `UiTextureKitID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `EnvGarrMechanicID` int(10) unsigned NOT NULL DEFAULT '0',
+  `EnvGarrMechanicTypeID` int(11) NOT NULL DEFAULT '0',
+  `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
+  `GarrMissionSetID` int(11) NOT NULL DEFAULT '0',
+  `TargetLevel` tinyint(4) NOT NULL DEFAULT '0',
+  `TargetItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `MissionDuration` int(11) NOT NULL DEFAULT '0',
+  `TravelDuration` int(11) NOT NULL DEFAULT '0',
+  `OfferDuration` int(10) unsigned NOT NULL DEFAULT '0',
+  `BaseCompletionChance` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `BaseFollowerXP` int(10) unsigned NOT NULL DEFAULT '0',
+  `OvermaxRewardPackID` int(10) unsigned NOT NULL DEFAULT '0',
+  `FollowerDeathChance` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `AreaID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(11) NOT NULL DEFAULT '0',
+  `AutoMissionScalar` float NOT NULL DEFAULT '0',
+  `AutoMissionScalarCurveID` int(11) NOT NULL DEFAULT '0',
+  `AutoCombatantEnvCasterID` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `garr_mission_locale`
+--
+
+DROP TABLE IF EXISTS `garr_mission_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `garr_mission_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text COLLATE utf8mb4_unicode_ci,
+  `Location_lang` text COLLATE utf8mb4_unicode_ci,
+  `Description_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int(11) 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 `garr_plot`
 --
@@ -3697,10 +3844,14 @@ CREATE TABLE `heirloom` (
   `UpgradeItemID2` int(11) NOT NULL DEFAULT '0',
   `UpgradeItemID3` int(11) NOT NULL DEFAULT '0',
   `UpgradeItemID4` int(11) NOT NULL DEFAULT '0',
+  `UpgradeItemID5` int(11) NOT NULL DEFAULT '0',
+  `UpgradeItemID6` int(11) NOT NULL DEFAULT '0',
   `UpgradeItemBonusListID1` smallint(5) unsigned NOT NULL DEFAULT '0',
   `UpgradeItemBonusListID2` smallint(5) unsigned NOT NULL DEFAULT '0',
   `UpgradeItemBonusListID3` smallint(5) unsigned NOT NULL DEFAULT '0',
   `UpgradeItemBonusListID4` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `UpgradeItemBonusListID5` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `UpgradeItemBonusListID6` smallint(5) unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3829,6 +3980,7 @@ DROP TABLE IF EXISTS `hotfix_data`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `hotfix_data` (
   `Id` int(11) NOT NULL,
+  `UniqueId` int(10) unsigned NOT NULL DEFAULT '0',
   `TableHash` int(10) unsigned NOT NULL,
   `RecordId` int(11) NOT NULL,
   `Status` tinyint(3) unsigned NOT NULL DEFAULT '3',
@@ -3934,6 +4086,7 @@ CREATE TABLE `item` (
   `SoundOverrideSubclassID` tinyint(4) NOT NULL DEFAULT '0',
   `IconFileDataID` int(11) NOT NULL DEFAULT '0',
   `ItemGroupSoundsID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ContentTuningID` int(11) NOT NULL DEFAULT '0',
   `ModifiedCraftingReagentItemID` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -3949,7 +4102,7 @@ DROP TABLE IF EXISTS `item_appearance`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `item_appearance` (
   `ID` int(10) unsigned NOT NULL DEFAULT '0',
-  `DisplayType` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `DisplayType` int(11) NOT NULL DEFAULT '0',
   `ItemDisplayInfoID` int(11) NOT NULL DEFAULT '0',
   `DefaultIconFileDataID` int(11) NOT NULL DEFAULT '0',
   `UiOrder` int(11) NOT NULL DEFAULT '0',
@@ -4511,10 +4664,10 @@ DROP TABLE IF EXISTS `item_modified_appearance`;
 CREATE TABLE `item_modified_appearance` (
   `ID` int(10) unsigned NOT NULL DEFAULT '0',
   `ItemID` int(11) NOT NULL DEFAULT '0',
-  `ItemAppearanceModifierID` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `ItemAppearanceID` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `TransmogSourceTypeEnum` tinyint(4) NOT NULL DEFAULT '0',
+  `ItemAppearanceModifierID` int(11) NOT NULL DEFAULT '0',
+  `ItemAppearanceID` int(11) NOT NULL DEFAULT '0',
+  `OrderIndex` int(11) NOT NULL DEFAULT '0',
+  `TransmogSourceTypeEnum` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -4753,7 +4906,7 @@ CREATE TABLE `item_sparse` (
   `Display` text COLLATE utf8mb4_unicode_ci,
   `ExpansionID` int(11) NOT NULL DEFAULT '0',
   `DmgVariance` float NOT NULL DEFAULT '0',
-  `InstanceBound` int(11) NOT NULL DEFAULT '0',
+  `LimitCategory` int(11) NOT NULL DEFAULT '0',
   `DurationInInventory` int(10) unsigned NOT NULL DEFAULT '0',
   `QualityModifier` float NOT NULL DEFAULT '0',
   `BagFamily` int(10) unsigned NOT NULL DEFAULT '0',
@@ -4797,10 +4950,10 @@ CREATE TABLE `item_sparse` (
   `ItemNameDescriptionID` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RequiredTransmogHoliday` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RequiredHoliday` smallint(5) unsigned NOT NULL DEFAULT '0',
-  `LimitCategory` smallint(5) unsigned NOT NULL DEFAULT '0',
   `GemProperties` smallint(5) unsigned NOT NULL DEFAULT '0',
   `SocketMatchEnchantmentId` smallint(5) unsigned NOT NULL DEFAULT '0',
   `TotemCategoryID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `InstanceBound` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ZoneBound1` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ZoneBound2` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ItemSet` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -4840,8 +4993,8 @@ CREATE TABLE `item_sparse` (
   `RequiredPVPMedal` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `RequiredPVPRank` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `RequiredLevel` tinyint(4) NOT NULL DEFAULT '0',
-  `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `OverallQualityID` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `InventoryType` tinyint(4) NOT NULL DEFAULT '0',
+  `OverallQualityID` tinyint(4) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -4946,6 +5099,212 @@ CREATE TABLE `item_x_item_effect` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `journal_encounter`
+--
+
+DROP TABLE IF EXISTS `journal_encounter`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `journal_encounter` (
+  `Name` text COLLATE utf8mb4_unicode_ci,
+  `Description` text COLLATE utf8mb4_unicode_ci,
+  `MapX` float NOT NULL DEFAULT '0',
+  `MapY` float NOT NULL DEFAULT '0',
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `JournalInstanceID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `DungeonEncounterID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `OrderIndex` int(10) unsigned NOT NULL DEFAULT '0',
+  `FirstSectionID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `UiMapID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `MapDisplayConditionID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `DifficultyMask` tinyint(4) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `journal_encounter_locale`
+--
+
+DROP TABLE IF EXISTS `journal_encounter_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `journal_encounter_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text COLLATE utf8mb4_unicode_ci,
+  `Description_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int(11) 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 `journal_encounter_section`
+--
+
+DROP TABLE IF EXISTS `journal_encounter_section`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `journal_encounter_section` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Title` text COLLATE utf8mb4_unicode_ci,
+  `BodyText` text COLLATE utf8mb4_unicode_ci,
+  `JournalEncounterID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ParentSectionID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `FirstChildSectionID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `NextSiblingSectionID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `Type` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `IconCreatureDisplayInfoID` int(10) unsigned NOT NULL DEFAULT '0',
+  `UiModelSceneID` int(11) NOT NULL DEFAULT '0',
+  `SpellID` int(11) NOT NULL DEFAULT '0',
+  `IconFileDataID` int(11) NOT NULL DEFAULT '0',
+  `Flags` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `IconFlags` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `DifficultyMask` tinyint(4) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `journal_encounter_section_locale`
+--
+
+DROP TABLE IF EXISTS `journal_encounter_section_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `journal_encounter_section_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Title_lang` text COLLATE utf8mb4_unicode_ci,
+  `BodyText_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int(11) 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 `journal_instance`
+--
+
+DROP TABLE IF EXISTS `journal_instance`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `journal_instance` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text COLLATE utf8mb4_unicode_ci,
+  `Description` text COLLATE utf8mb4_unicode_ci,
+  `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `BackgroundFileDataID` int(11) NOT NULL DEFAULT '0',
+  `ButtonFileDataID` int(11) NOT NULL DEFAULT '0',
+  `ButtonSmallFileDataID` int(11) NOT NULL DEFAULT '0',
+  `LoreFileDataID` int(11) NOT NULL DEFAULT '0',
+  `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `AreaID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `journal_instance_locale`
+--
+
+DROP TABLE IF EXISTS `journal_instance_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `journal_instance_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text COLLATE utf8mb4_unicode_ci,
+  `Description_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int(11) 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 `journal_tier`
+--
+
+DROP TABLE IF EXISTS `journal_tier`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `journal_tier` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Name` text COLLATE utf8mb4_unicode_ci,
+  `PlayerConditionID` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `journal_tier_locale`
+--
+
+DROP TABLE IF EXISTS `journal_tier_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `journal_tier_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int(11) 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 `keychain`
 --
@@ -4992,6 +5351,51 @@ CREATE TABLE `keychain` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `keystone_affix`
+--
+
+DROP TABLE IF EXISTS `keystone_affix`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `keystone_affix` (
+  `Name` text COLLATE utf8mb4_unicode_ci,
+  `Description` text COLLATE utf8mb4_unicode_ci,
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `FiledataID` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `keystone_affix_locale`
+--
+
+DROP TABLE IF EXISTS `keystone_affix_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `keystone_affix_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text COLLATE utf8mb4_unicode_ci,
+  `Description_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int(11) 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 `language_words`
 --
@@ -5347,6 +5751,55 @@ CREATE TABLE `map` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `map_challenge_mode`
+--
+
+DROP TABLE IF EXISTS `map_challenge_mode`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `map_challenge_mode` (
+  `Name` text COLLATE utf8mb4_unicode_ci,
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `MapID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `ExpansionLevel` int(10) unsigned NOT NULL DEFAULT '0',
+  `RequiredWorldStateID` int(11) NOT NULL DEFAULT '0',
+  `CriteriaCount1` smallint(6) NOT NULL DEFAULT '0',
+  `CriteriaCount2` smallint(6) NOT NULL DEFAULT '0',
+  `CriteriaCount3` smallint(6) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `map_challenge_mode_locale`
+--
+
+DROP TABLE IF EXISTS `map_challenge_mode_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `map_challenge_mode_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int(11) 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 `map_difficulty`
 --
@@ -5474,6 +5927,22 @@ CREATE TABLE `map_locale` (
  PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `maw_power`
+--
+
+DROP TABLE IF EXISTS `maw_power`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `maw_power` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `SpellID` int(11) NOT NULL DEFAULT '0',
+  `MawPowerRarityID` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `modifier_tree`
 --
@@ -6257,7 +6726,7 @@ CREATE TABLE `quest_info` (
   `ID` int(10) unsigned NOT NULL DEFAULT '0',
   `InfoName` text COLLATE utf8mb4_unicode_ci,
   `Type` tinyint(4) NOT NULL DEFAULT '0',
-  `Modifiers` tinyint(3) unsigned NOT NULL DEFAULT '0',
+  `Modifiers` int(11) NOT NULL DEFAULT '0',
   `Profession` smallint(5) unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -6303,6 +6772,7 @@ CREATE TABLE `quest_line_x_quest` (
   `QuestLineID` int(10) unsigned NOT NULL DEFAULT '0',
   `QuestID` int(10) unsigned NOT NULL DEFAULT '0',
   `OrderIndex` int(10) unsigned NOT NULL DEFAULT '0',
+  `Flags` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6644,6 +7114,7 @@ CREATE TABLE `scene_script` (
   `ID` int(10) unsigned NOT NULL DEFAULT '0',
   `FirstSceneScriptID` smallint(5) unsigned NOT NULL DEFAULT '0',
   `NextSceneScriptID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `Unknown915` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6675,6 +7146,7 @@ DROP TABLE IF EXISTS `scene_script_package`;
 CREATE TABLE `scene_script_package` (
   `ID` int(10) unsigned NOT NULL DEFAULT '0',
   `Name` text COLLATE utf8mb4_unicode_ci,
+  `Unknown915` int(11) NOT NULL DEFAULT '0',
   `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6801,6 +7273,24 @@ CREATE TABLE `skill_race_class_info` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `soulbind_conduit_rank`
+--
+
+DROP TABLE IF EXISTS `soulbind_conduit_rank`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `soulbind_conduit_rank` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `RankIndex` int(11) NOT NULL DEFAULT '0',
+  `SpellID` int(11) NOT NULL DEFAULT '0',
+  `AuraPointsOverride` float NOT NULL DEFAULT '0',
+  `SoulbindConduitID` int(10) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `sound_kit`
 --
@@ -7114,7 +7604,7 @@ CREATE TABLE `spell_effect` (
   `EffectAura` smallint(6) NOT NULL DEFAULT '0',
   `DifficultyID` int(11) NOT NULL DEFAULT '0',
   `EffectIndex` int(11) NOT NULL DEFAULT '0',
-  `Effect` int(11) NOT NULL DEFAULT '0',
+  `Effect` int(10) unsigned NOT NULL DEFAULT '0',
   `EffectAmplitude` float NOT NULL DEFAULT '0',
   `EffectAttributes` int(11) NOT NULL DEFAULT '0',
   `EffectAuraPeriod` int(11) NOT NULL DEFAULT '0',
@@ -8351,8 +8841,8 @@ CREATE TABLE `ui_map` (
   `ID` int(10) unsigned NOT NULL DEFAULT '0',
   `ParentUiMapID` int(11) NOT NULL DEFAULT '0',
   `Flags` int(11) NOT NULL DEFAULT '0',
-  `System` int(11) NOT NULL DEFAULT '0',
-  `Type` int(11) NOT NULL DEFAULT '0',
+  `System` int(10) unsigned NOT NULL DEFAULT '0',
+  `Type` int(10) unsigned NOT NULL DEFAULT '0',
   `BountySetID` int(11) NOT NULL DEFAULT '0',
   `BountyDisplayLocation` int(10) unsigned NOT NULL DEFAULT '0',
   `VisibilityPlayerConditionID` int(11) NOT NULL DEFAULT '0',
@@ -8463,6 +8953,68 @@ CREATE TABLE `ui_map_x_map_art` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
+--
+-- Table structure for table `ui_splash_screen`
+--
+
+DROP TABLE IF EXISTS `ui_splash_screen`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ui_splash_screen` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `Header` text COLLATE utf8mb4_unicode_ci,
+  `TopLeftFeatureTitle` text COLLATE utf8mb4_unicode_ci,
+  `TopLeftFeatureDesc` text COLLATE utf8mb4_unicode_ci,
+  `BottomLeftFeatureTitle` text COLLATE utf8mb4_unicode_ci,
+  `BottomLeftFeatureDesc` text COLLATE utf8mb4_unicode_ci,
+  `RightFeatureTitle` text COLLATE utf8mb4_unicode_ci,
+  `RightFeatureDesc` text COLLATE utf8mb4_unicode_ci,
+  `AllianceQuestID` int(11) NOT NULL DEFAULT '0',
+  `HordeQuestID` int(11) NOT NULL DEFAULT '0',
+  `ScreenType` tinyint(4) NOT NULL DEFAULT '0',
+  `TextureKitID` int(11) NOT NULL DEFAULT '0',
+  `SoundKitID` int(11) NOT NULL DEFAULT '0',
+  `PlayerConditionID` int(11) NOT NULL DEFAULT '0',
+  `CharLevelConditionID` int(11) NOT NULL DEFAULT '0',
+  `RequiredTimeEventPassed` int(11) NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) 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 `ui_splash_screen_locale`
+--
+
+DROP TABLE IF EXISTS `ui_splash_screen_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ui_splash_screen_locale` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Header_lang` text COLLATE utf8mb4_unicode_ci,
+  `TopLeftFeatureTitle_lang` text COLLATE utf8mb4_unicode_ci,
+  `TopLeftFeatureDesc_lang` text COLLATE utf8mb4_unicode_ci,
+  `BottomLeftFeatureTitle_lang` text COLLATE utf8mb4_unicode_ci,
+  `BottomLeftFeatureDesc_lang` text COLLATE utf8mb4_unicode_ci,
+  `RightFeatureTitle_lang` text COLLATE utf8mb4_unicode_ci,
+  `RightFeatureDesc_lang` text COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int(11) 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 `unit_power_bar`
 --
@@ -8750,7 +9302,7 @@ CREATE TABLE `world_effect` (
   `ID` int(10) unsigned NOT NULL DEFAULT '0',
   `QuestFeedbackEffectID` int(10) unsigned NOT NULL DEFAULT '0',
   `WhenToDisplay` tinyint(3) unsigned NOT NULL DEFAULT '0',
-  `TargetType` tinyint(4) NOT NULL DEFAULT '0',
+  `TargetType` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `TargetAsset` int(11) NOT NULL DEFAULT '0',
   `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0',
   `CombatConditionID` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -8816,4 +9368,4 @@ CREATE TABLE `world_state_expression` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-10-15 10:11:51
+-- Dump completed on 2021-11-17 13:23:22
-- 
cgit v1.2.3

