TDB 915.21111 - 2021/11/17TDB915.21111

4 files changed, 636 insertions, 82 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 2c71e98a497..8dfa767df28 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_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: auth
 -- ------------------------------------------------------
--- 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 */;
@@ -205,16 +205,16 @@ UNLOCK TABLES;
 
 DROP TABLE IF EXISTS `battle_pet_declinedname`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
+/*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `battle_pet_declinedname` (
-  `guid` bigint NOT NULL,
+  `guid` bigint(20) NOT NULL,
   `genitive` varchar(12) NOT NULL DEFAULT '',
   `dative` varchar(12) NOT NULL DEFAULT '',
   `accusative` varchar(12) NOT NULL DEFAULT '',
   `instrumental` varchar(12) NOT NULL DEFAULT '',
   `prepositional` varchar(12) NOT NULL DEFAULT '',
   PRIMARY KEY (`guid`),
-  CONSTRAINT `fk_battle_pet__battle_pet_declinedname` FOREIGN KEY (`guid`) REFERENCES `battle_pets` (`guid`) ON DELETE RESTRICT ON UPDATE RESTRICT
+  CONSTRAINT `fk_battle_pet__battle_pet_declinedname` FOREIGN KEY (`guid`) REFERENCES `battle_pets` (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -226,7 +226,6 @@ LOCK TABLES `battle_pet_declinedname` WRITE;
 /*!40000 ALTER TABLE `battle_pet_declinedname` DISABLE KEYS */;
 /*!40000 ALTER TABLE `battle_pet_declinedname` ENABLE KEYS */;
 UNLOCK TABLES;
-/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
 --
 -- Table structure for table `battle_pet_slots`
@@ -1240,6 +1239,7 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (196,872),
 (196,873),
 (196,881),
+(196,882),
 (197,232),
 (197,236),
 (197,237),
@@ -2374,9 +2374,9 @@ INSERT INTO `updates` VALUES
 ('2018_06_22_00_auth.sql','9DA24F70B8A365AFDEF58A9B578255CDEDFCA47C','ARCHIVED','2018-06-22 17:45:45',0),
 ('2018_06_23_00_auth.sql','BE35312C386A127D047E5A7CE0D14DB41D905F8E','ARCHIVED','2018-06-23 00:00:00',0),
 ('2018_06_29_00_auth.sql','03AAEA7E52848FA5522C3F0C6D9C38B988407480','ARCHIVED','2018-06-29 22:34:04',0),
-('2018_08_30_00_auth.sql','22F69864361D3E72F800379338310172C0576D1C','RELEASED','2018-08-30 00:00:00',0),
+('2018_08_30_00_auth.sql','22F69864361D3E72F800379338310172C0576D1C','ARCHIVED','2018-08-30 00:00:00',0),
 ('2018_09_06_00_auth.sql','309D21E0DF82ED8921F77EAFDE741F38AC32BB13','ARCHIVED','2018-09-06 00:00:00',0),
-('2018_09_17_00_auth.sql','4DB671F0A4FA1A93AF28FB6426AF13DE72C7DA3D','RELEASED','2018-09-17 00:00:00',0),
+('2018_09_17_00_auth.sql','4DB671F0A4FA1A93AF28FB6426AF13DE72C7DA3D','ARCHIVED','2018-09-17 00:00:00',0),
 ('2018_12_09_00_auth_2017_01_06_00_auth.sql','6CCFE6A9774EC733C9863D36A0F15F3534189BBD','ARCHIVED','2017-01-06 00:00:00',0),
 ('2018_12_09_01_auth.sql','576C2A11BE671D8420FA3EB705E594E381ECCC56','ARCHIVED','2018-12-09 14:49:17',0),
 ('2019_06_08_00_auth.sql','EA5A78F5A26C17BC790481EA9B3772D3A6912459','ARCHIVED','2019-05-20 17:21:20',0),
@@ -2444,15 +2444,16 @@ INSERT INTO `updates` VALUES
 ('2021_10_07_00_auth.sql','45F2D92E28382F0CBE1F9B3A97693C0CC69E50BC','ARCHIVED','2021-10-07 10:32:05',0),
 ('2021_10_13_00_auth.sql','220E63385CACCBCEC36C57717DE369F2FCABCAAF','ARCHIVED','2021-10-13 21:15:05',0),
 ('2021_10_15_00_auth.sql','C8AA212AB2BB2DB5B3C2C9622A3874475AEFBD7B','ARCHIVED','2021-10-15 10:11:47',0),
-('2021_10_15_01_auth.sql','72A0437F0ADEC59FF9D6839DF845C473F693CA5B','RELEASED','2021-10-16 00:15:25',0),
-('2021_10_16_00_auth.sql','FDC45C7BEFBAFC9BCE6C77377B026A59AE52EE21','RELEASED','2021-10-16 11:24:39',0),
-('2021_10_22_00_auth.sql','6F55BAD44B9299BE23F79DB09AA90CB42AA63A00','RELEASED','2021-10-10 17:23:09',0),
-('2021_10_23_00_auth.sql','97A8F2C2CEDB99C942D38F5B65DAD1DC11296E20','RELEASED','2021-10-23 00:00:00',0),
-('2021_10_26_00_auth.sql','91E8B308267847569D9A669BC34794F154242ECF','RELEASED','2021-10-26 00:41:04',0),
-('2021_11_05_00_auth.sql','4A4510436578B6486E8399602D3060376E96A8C7','RELEASED','2021-11-05 00:33:00',0),
-('2021_11_06_00_auth.sql','3646F9356429CCE7C1CECC7D9BA7960E011C7B6B','RELEASED','2021-11-06 11:54:12',0),
-('2021_11_10_00_auth.sql','EB3D26EFD3109BC17447B3BAC7573473F5103F65','RELEASED','2021-11-10 14:07:05',0),
-('2021_11_12_00_auth.sql','012C088794362FE57BAEA0C3BD05356B40289028','RELEASED','2021-11-12 12:17:24',0);
+('2021_10_15_01_auth.sql','72A0437F0ADEC59FF9D6839DF845C473F693CA5B','ARCHIVED','2021-10-16 00:15:25',0),
+('2021_10_16_00_auth.sql','FDC45C7BEFBAFC9BCE6C77377B026A59AE52EE21','ARCHIVED','2021-10-16 11:24:39',0),
+('2021_10_22_00_auth.sql','07D7397061A5A906357DC6E91FC33C74638EFDC3','ARCHIVED','2021-11-17 13:21:03',0),
+('2021_10_23_00_auth.sql','97A8F2C2CEDB99C942D38F5B65DAD1DC11296E20','ARCHIVED','2021-10-23 00:00:00',0),
+('2021_10_26_00_auth.sql','91E8B308267847569D9A669BC34794F154242ECF','ARCHIVED','2021-10-26 00:41:04',0),
+('2021_11_05_00_auth.sql','4A4510436578B6486E8399602D3060376E96A8C7','ARCHIVED','2021-11-05 00:33:00',0),
+('2021_11_06_00_auth.sql','3646F9356429CCE7C1CECC7D9BA7960E011C7B6B','ARCHIVED','2021-11-06 11:54:12',0),
+('2021_11_10_00_auth.sql','EB3D26EFD3109BC17447B3BAC7573473F5103F65','ARCHIVED','2021-11-10 14:07:05',0),
+('2021_11_12_00_auth.sql','012C088794362FE57BAEA0C3BD05356B40289028','ARCHIVED','2021-11-12 12:17:24',0),
+('2021_11_17_00_auth.sql','298DA8468B30042B15FA17A90325C72879DF6D8E','ARCHIVED','2021-11-17 13:23:17',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2525,4 +2526,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-10-15 10:11:48
+-- Dump completed on 2021-11-17 13:23:18
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index da109df7c71..ee52a3e8884 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_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: characters
 -- ------------------------------------------------------
--- 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 */;
@@ -3671,9 +3671,10 @@ INSERT INTO `updates` VALUES
 ('2021_10_02_00_characters.sql','31CEACE4E9A4BE58A659A2BDE4A7C51D2DB8AC41','ARCHIVED','2021-10-02 21:21:37',0),
 ('2021_10_02_01_characters.sql','F97B956F3B5F909294CA399F75B5795A07C4D8EC','ARCHIVED','2021-10-02 21:47:38',0),
 ('2021_10_15_00_characters.sql','906FECD65CBA7C406969F45FDF28DDEF8AAF8715','ARCHIVED','2021-10-15 10:11:47',0),
-('2021_10_16_00_characters.sql','B5A31BB6FBC34512767475EDF13099DEC948EBB7','RELEASED','2021-10-16 01:12:20',0),
-('2021_11_02_00_characters.sql','A3C0A6DA70CC70803C80685E4E2ED6255156520A','RELEASED','2021-11-02 18:11:13',0),
-('2021_11_04_00_characters.sql','ED533235ADAD174F91A6B8E51D1046243B78B46D','RELEASED','2021-11-04 21:53:04',0);
+('2021_10_16_00_characters.sql','B5A31BB6FBC34512767475EDF13099DEC948EBB7','ARCHIVED','2021-10-16 01:12:20',0),
+('2021_11_02_00_characters.sql','A3C0A6DA70CC70803C80685E4E2ED6255156520A','ARCHIVED','2021-11-02 18:11:13',0),
+('2021_11_04_00_characters.sql','ED533235ADAD174F91A6B8E51D1046243B78B46D','ARCHIVED','2021-11-04 21:53:04',0),
+('2021_11_17_00_characters.sql','03A0AB8ECD8BE5D818D41A8A610097C94A9C7DB9','ARCHIVED','2021-11-17 13:23:17',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3772,4 +3773,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-10-15 10:11:48
+-- Dump completed on 2021-11-17 13:23:18
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',
@@ -1318,6 +1318,23 @@ CREATE TABLE `broadcast_text` (
 /*!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;
@@ -2472,6 +2492,56 @@ CREATE TABLE `criteria_tree_locale` (
 /*!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',
@@ -3433,6 +3504,82 @@ CREATE TABLE `garr_follower_x_ability` (
 /*!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;
@@ -4947,6 +5100,212 @@ CREATE TABLE `item_x_item_effect` (
 /*!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`
 --
 
@@ -4993,6 +5352,51 @@ CREATE TABLE `keychain` (
 /*!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`
 --
 
@@ -5348,6 +5752,55 @@ CREATE TABLE `map` (
 /*!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`
 --
 
@@ -5475,6 +5928,22 @@ CREATE TABLE `map_locale` (
 /*!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;
@@ -6802,6 +7274,24 @@ CREATE TABLE `skill_race_class_info` (
 /*!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',
@@ -8464,6 +8954,68 @@ CREATE TABLE `ui_map_x_map_art` (
 /*!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
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 21798f11323..02f729fbab4 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_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: world
 -- ------------------------------------------------------
--- 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 */;
@@ -138,7 +138,7 @@ CREATE TABLE `areatrigger_create_properties` (
   `ScaleCurveId` int(10) unsigned NOT NULL DEFAULT '0',
   `MorphCurveId` int(10) unsigned NOT NULL DEFAULT '0',
   `FacingCurveId` int(10) unsigned NOT NULL DEFAULT '0',
-  `AnimId` int(11) NOT NULL DEFAULT '0',
+  `AnimId` int(11) NOT NULL DEFAULT '-1',
   `AnimKitId` int(11) NOT NULL DEFAULT '0',
   `DecalPropertiesId` int(10) unsigned NOT NULL DEFAULT '0',
   `TimeToTarget` int(10) unsigned NOT NULL DEFAULT '0',
@@ -510,7 +510,6 @@ DROP TABLE IF EXISTS `conversation_line_template`;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `conversation_line_template` (
   `Id` int(10) unsigned NOT NULL,
-  `StartTime` int(10) unsigned NOT NULL DEFAULT '0',
   `UiCameraID` int(10) unsigned NOT NULL DEFAULT '0',
   `ActorIdx` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -529,7 +528,6 @@ DROP TABLE IF EXISTS `conversation_template`;
 CREATE TABLE `conversation_template` (
   `Id` int(10) unsigned NOT NULL,
   `FirstLineId` int(10) unsigned NOT NULL,
-  `LastLineEndTime` int(10) unsigned NOT NULL,
   `TextureKitId` int(10) unsigned NOT NULL DEFAULT '0',
   `ScriptName` varchar(64) NOT NULL DEFAULT '',
   `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0',
@@ -1011,6 +1009,7 @@ CREATE TABLE `creature_text` (
   `Emote` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `Duration` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `Sound` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `SoundPlayType` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `BroadcastTextId` mediumint(6) NOT NULL DEFAULT '0',
   `TextRange` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `comment` varchar(255) DEFAULT '',
@@ -1637,6 +1636,7 @@ CREATE TABLE `gameobject_template` (
   `Data31` int(10) NOT NULL DEFAULT '0',
   `Data32` int(10) NOT NULL DEFAULT '0',
   `Data33` int(11) NOT NULL DEFAULT '0',
+  `Data34` int(11) NOT NULL DEFAULT '0',
   `ContentTuningId` int(11) NOT NULL DEFAULT '0',
   `AIName` char(64) NOT NULL DEFAULT '',
   `ScriptName` varchar(64) NOT NULL DEFAULT '',
@@ -1899,7 +1899,6 @@ CREATE TABLE `instance_template` (
   `map` smallint(5) unsigned NOT NULL,
   `parent` smallint(5) unsigned NOT NULL,
   `script` varchar(128) NOT NULL DEFAULT '',
-  `allowMount` tinyint(3) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`map`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3846,6 +3845,7 @@ CREATE TABLE `smart_scripts` (
   `target_param1` int(10) unsigned NOT NULL DEFAULT '0',
   `target_param2` int(10) unsigned NOT NULL DEFAULT '0',
   `target_param3` int(10) unsigned NOT NULL DEFAULT '0',
+  `target_param4` int(10) unsigned NOT NULL DEFAULT '0',
   `target_x` float NOT NULL DEFAULT '0',
   `target_y` float NOT NULL DEFAULT '0',
   `target_z` float NOT NULL DEFAULT '0',
@@ -4505,4 +4505,4 @@ CREATE TABLE `world_safe_locs` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2021-10-15 10:11:49
+-- Dump completed on 2021-11-17 13:23:19