TDB 343.23121 - 2023/12/20TDB343.23121

author: funjoker <funjoker109@gmail.com> 2023-12-21 00:28:23 +0100
committer: funjoker <funjoker109@gmail.com> 2023-12-21 00:28:23 +0100
commit: f5c8b53b2e3d4203d74ba1af2b0345efe7609db3 (patch)
tree: 00ac035c9629feb07060c3a3a4dac1a247cac36d /sql
parent: e5bf7ab086b51601985f2bbcafa62beee23be166 (diff)
151 files changed, 720 insertions, 436 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index fbe211835fb..f1a26a18d73 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -739,13 +739,13 @@ INSERT INTO `build_info` VALUES
 (51536,10,1,7,NULL,NULL,'570EEA10A8EC169C3FF9621D1B635BB4',NULL,NULL,NULL),
 (51754,10,1,7,NULL,NULL,'BED5A861C071AB41FEF6087E0C37BB1A',NULL,NULL,NULL),
 (51886,10,1,7,NULL,NULL,'09CF8919FD2EABDEAEBC0C810F53B511',NULL,NULL,NULL),
+(51943,3,4,3,NULL,NULL,'926D8C2514A3FEBA84F0DEB031AE41CE',NULL,NULL,NULL),
 (51972,10,1,7,NULL,NULL,'444DC7EF3544B6670C18884DADA00428',NULL,NULL,NULL),
 (52038,10,2,0,NULL,NULL,'A8EF004ADED8A3AFF5A67D2BB8D95795',NULL,NULL,NULL),
 (52068,10,2,0,NULL,NULL,'A44F842BACCC7EE8E2975FAF01F12474',NULL,NULL,NULL),
 (52095,10,2,0,NULL,NULL,'BA36382887D16D274EA9149695F0C9C8',NULL,NULL,NULL),
 (52106,10,2,0,NULL,NULL,'95F43869B7D881212CBC1690B8F393ED',NULL,NULL,NULL),
 (52129,10,2,0,NULL,NULL,'02DD842F2A7162EEB8FD5B9D325606F8',NULL,NULL,NULL),
-(51943,3,4,3,NULL,NULL,'926D8C2514A3FEBA84F0DEB031AE41CE',NULL,NULL,NULL),
 (52237,3,4,3,NULL,NULL,'3BA993D54FD86EE03E6F81C8FBCE26B7',NULL,NULL,NULL);
 /*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
 UNLOCK TABLES;
@@ -2751,16 +2751,17 @@ INSERT INTO `updates` VALUES
 ('2023_09_23_00_auth.sql','B6250AE892CF5988FD4EB08EC35DE25096B52115','ARCHIVED','2023-09-23 01:57:24',0),
 ('2023_09_28_00_auth.sql','E69955264CD347921DDD1B52BC31E8C39EC41B21','ARCHIVED','2023-09-28 05:36:07',0),
 ('2023_10_06_00_auth.sql','3480687DEEB3E12ECC9632809A518425F9FA0FCC','ARCHIVED','2023-10-06 00:40:46',0),
-('2023_10_17_00_auth.sql','EE4C430E9535EC3466E4D2FABA7F009F87AF18BD','RELEASED','2023-10-17 21:07:51',0),
-('2023_10_25_00_auth.sql','86B16D5D78A8ED31FDD8553D223CF56F013B00DB','RELEASED','2023-10-25 00:06:14',0),
-('2023_11_01_00_auth.sql','4EA6010E9035AFC80326FE56C642C7918254F2BE','RELEASED','2023-11-01 10:47:18',0),
-('2023_11_09_00_auth.sql','C8A9223E6868593904634193ACBD421F40078FE5','RELEASED','2023-11-09 00:53:45',0),
-('2023_11_09_01_auth.sql','BC9BC28D41608A78166B5A38F3A7F598FBDB879D','RELEASED','2023-11-09 18:21:59',0),
-('2023_11_14_00_auth.sql','192D729737C5E3332D7B5B9B7F9DBDD9626D7B98','RELEASED','2023-11-14 11:36:05',0),
-('2023_11_15_00_auth.sql','DC89EA5C9D799C213B3E6A606F081697ADEF8250','RELEASED','2023-11-15 10:47:53',0),
-('2023_11_21_00_auth.sql','146E5E6EF94C5DB78343372A8FDB32B062B80040','RELEASED','2023-11-21 11:24:11',0),
-('2023_11_23_00_auth.sql','EC3D1289A07E387BF4D2AC94EEBE3A29483EAD3A','RELEASED','2023-11-23 02:39:18',0),
-('2023_11_24_00_auth.sql','AC1B5136CC97264A21933BD1074D02E88D819488','RELEASED','2023-11-24 19:37:38',0);
+('2023_10_17_00_auth.sql','EE4C430E9535EC3466E4D2FABA7F009F87AF18BD','ARCHIVED','2023-10-17 21:07:51',0),
+('2023_10_25_00_auth.sql','86B16D5D78A8ED31FDD8553D223CF56F013B00DB','ARCHIVED','2023-10-25 00:06:14',0),
+('2023_11_01_00_auth.sql','4EA6010E9035AFC80326FE56C642C7918254F2BE','ARCHIVED','2023-11-01 10:47:18',0),
+('2023_11_09_00_auth.sql','C8A9223E6868593904634193ACBD421F40078FE5','ARCHIVED','2023-11-09 00:53:45',0),
+('2023_11_09_01_auth.sql','BC9BC28D41608A78166B5A38F3A7F598FBDB879D','ARCHIVED','2023-11-09 18:21:59',0),
+('2023_11_14_00_auth.sql','192D729737C5E3332D7B5B9B7F9DBDD9626D7B98','ARCHIVED','2023-11-14 11:36:05',0),
+('2023_11_15_00_auth.sql','DC89EA5C9D799C213B3E6A606F081697ADEF8250','ARCHIVED','2023-11-15 10:47:53',0),
+('2023_11_21_00_auth.sql','146E5E6EF94C5DB78343372A8FDB32B062B80040','ARCHIVED','2023-11-21 11:24:11',0),
+('2023_11_23_00_auth.sql','EC3D1289A07E387BF4D2AC94EEBE3A29483EAD3A','ARCHIVED','2023-11-23 02:39:18',0),
+('2023_11_24_00_auth.sql','AC1B5136CC97264A21933BD1074D02E88D819488','ARCHIVED','2023-11-24 19:37:38',0),
+('2023_12_20_00_auth.sql','D4AB92FEB9FECC1EE35BB9A734B2E95A44C43CD4','ARCHIVED','2023-12-20 21:51:28',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2787,6 +2788,7 @@ LOCK TABLES `updates_include` WRITE;
 INSERT INTO `updates_include` VALUES
 ('$/sql/custom/auth','RELEASED'),
 ('$/sql/old/10.x/auth','ARCHIVED'),
+('$/sql/old/3.4.x/auth','ARCHIVED'),
 ('$/sql/old/6.x/auth','ARCHIVED'),
 ('$/sql/old/7/auth','ARCHIVED'),
 ('$/sql/old/8.x/auth','ARCHIVED'),
@@ -2903,4 +2905,4 @@ SET character_set_client = @saved_cs_client;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2023-10-06  0:40:48
+-- Dump completed on 2023-12-20 23:02:11
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 185499e09aa..c666cafdd4c 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -3395,17 +3395,18 @@ INSERT INTO `updates` VALUES
 ('2023_09_14_00_characters.sql','DAC56929C724C2971A4476400F2439CBDFAF3C5C','ARCHIVED','2023-09-13 22:20:22',0),
 ('2023_09_30_00_characters.sql','4326C642870633873F163085D278DB9B7449D9C3','ARCHIVED','2023-09-30 16:34:19',0),
 ('2023_10_06_00_characters.sql','FFAFF1F0916BB9DC58345466E0BB1A15A4611836','ARCHIVED','2023-10-06 00:40:46',0),
-('2023_11_02_00_characters.sql','1A76A843F204901C8598DA5682029E815477E427','RELEASED','2023-11-02 18:59:41',0),
-('2023_11_09_00_characters.sql','1A3D7CA6890353DA55793FE8D925CC8C54965A69','RELEASED','2023-11-09 00:56:31',0),
-('2023_11_16_00_characters.sql','1D200630578074A4E3A373F891323DB867D00B02','RELEASED','2023-11-16 10:29:32',0),
-('2023_11_19_00_characters.sql','F247770A7F116070ABF13E4A61BB8E1693052548','RELEASED','2023-11-19 13:43:39',0),
-('2023_11_20_00_characters.sql','274C157F28DE1DC13F689755793AA2DE675CCC7F','RELEASED','2023-11-20 02:36:26',0),
-('2023_11_21_00_characters.sql','127057D4EFEB5DC63ECB877C1043B4AE996F11FA','RELEASED','2023-11-21 02:36:26',0),
-('2023_11_22_00_characters.sql','DEDDD2774AE3788C45F459B200EE446AD1C7AEE8','RELEASED','2023-11-22 02:36:26',0),
-('2023_11_23_00_characters.sql','4916DECE5A49D23B1DCFA27A713B250BE2A7225A','RELEASED','2023-11-23 21:05:48',0),
-('2023_11_25_00_characters.sql','76CE77D4B1625CE384B01295F4D3FFC16A7F696C','RELEASED','2023-11-25 12:33:10',0),
-('2023_11_27_00_characters.sql','A0CEE90B60612AA7315117FAFF22D14163D4ADF2','RELEASED','2023-11-27 12:33:10',0),
-('2023_12_03_00_characters.sql','C91A51EA86C26F3AB60445FE147B0E4B220716A0','RELEASED','2023-12-03 22:16:45',0);
+('2023_11_02_00_characters.sql','1A76A843F204901C8598DA5682029E815477E427','ARCHIVED','2023-11-02 18:59:41',0),
+('2023_11_09_00_characters.sql','1A3D7CA6890353DA55793FE8D925CC8C54965A69','ARCHIVED','2023-11-09 00:56:31',0),
+('2023_11_16_00_characters.sql','1D200630578074A4E3A373F891323DB867D00B02','ARCHIVED','2023-11-16 10:29:32',0),
+('2023_11_19_00_characters.sql','F247770A7F116070ABF13E4A61BB8E1693052548','ARCHIVED','2023-11-19 13:43:39',0),
+('2023_11_20_00_characters.sql','274C157F28DE1DC13F689755793AA2DE675CCC7F','ARCHIVED','2023-11-20 02:36:26',0),
+('2023_11_21_00_characters.sql','127057D4EFEB5DC63ECB877C1043B4AE996F11FA','ARCHIVED','2023-11-21 02:36:26',0),
+('2023_11_22_00_characters.sql','DEDDD2774AE3788C45F459B200EE446AD1C7AEE8','ARCHIVED','2023-11-22 02:36:26',0),
+('2023_11_23_00_characters.sql','4916DECE5A49D23B1DCFA27A713B250BE2A7225A','ARCHIVED','2023-11-23 21:05:48',0),
+('2023_11_25_00_characters.sql','76CE77D4B1625CE384B01295F4D3FFC16A7F696C','ARCHIVED','2023-11-25 12:33:10',0),
+('2023_11_27_00_characters.sql','A0CEE90B60612AA7315117FAFF22D14163D4ADF2','ARCHIVED','2023-11-27 12:33:10',0),
+('2023_12_03_00_characters.sql','C91A51EA86C26F3AB60445FE147B0E4B220716A0','ARCHIVED','2023-12-03 22:16:45',0),
+('2023_12_20_00_characters.sql','A474833AC43F14B52A6C386673E49E06CFE2A5F0','ARCHIVED','2023-12-20 21:51:28',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3432,6 +3433,7 @@ LOCK TABLES `updates_include` WRITE;
 INSERT INTO `updates_include` VALUES
 ('$/sql/custom/characters','RELEASED'),
 ('$/sql/old/10.x/characters','ARCHIVED'),
+('$/sql/old/3.4.x/characters','ARCHIVED'),
 ('$/sql/old/6.x/characters','ARCHIVED'),
 ('$/sql/old/7/characters','ARCHIVED'),
 ('$/sql/old/8.x/characters','ARCHIVED'),
@@ -3532,4 +3534,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2023-10-06  0:40:49
+-- Dump completed on 2023-12-20 23:09:17
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index 0c290f39e03..839fdba2588 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.34, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.35, for Win64 (x86_64)
 --
 -- Host: localhost    Database: hotfixes
 -- ------------------------------------------------------
--- Server version	8.0.34-0ubuntu0.20.04.1
+-- Server version	8.0.35
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -36,10 +36,8 @@ CREATE TABLE `achievement` (
   `Flags` int NOT NULL DEFAULT '0',
   `UiOrder` smallint NOT NULL DEFAULT '0',
   `IconFileID` int NOT NULL DEFAULT '0',
-  `RewardItemID` int NOT NULL DEFAULT '0',
   `CriteriaTree` int unsigned NOT NULL DEFAULT '0',
   `SharesCriteria` smallint NOT NULL DEFAULT '0',
-  `CovenantID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -138,14 +136,14 @@ CREATE TABLE `adventure_journal` (
   `ButtonActionType` tinyint unsigned NOT NULL DEFAULT '0',
   `TextureFileDataID` int NOT NULL DEFAULT '0',
   `LfgDungeonID` smallint unsigned NOT NULL DEFAULT '0',
-  `QuestID` int NOT NULL DEFAULT '0',
+  `QuestID` int unsigned NOT NULL DEFAULT '0',
   `BattleMasterListID` smallint unsigned NOT NULL DEFAULT '0',
   `PriorityMin` tinyint unsigned NOT NULL DEFAULT '0',
   `PriorityMax` tinyint unsigned NOT NULL DEFAULT '0',
   `ItemID` int NOT NULL DEFAULT '0',
   `ItemQuantity` int unsigned NOT NULL DEFAULT '0',
   `CurrencyType` smallint unsigned NOT NULL DEFAULT '0',
-  `CurrencyQuantity` int unsigned NOT NULL DEFAULT '0',
+  `CurrencyQuantity` tinyint unsigned NOT NULL DEFAULT '0',
   `UiMapID` smallint unsigned NOT NULL DEFAULT '0',
   `BonusPlayerConditionID1` int unsigned NOT NULL DEFAULT '0',
   `BonusPlayerConditionID2` int unsigned NOT NULL DEFAULT '0',
@@ -314,6 +312,7 @@ CREATE TABLE `area_table` (
   `UwAmbience` smallint unsigned NOT NULL DEFAULT '0',
   `ZoneMusic` smallint unsigned NOT NULL DEFAULT '0',
   `UwZoneMusic` smallint unsigned NOT NULL DEFAULT '0',
+  `ExplorationLevel` tinyint NOT NULL DEFAULT '0',
   `IntroSound` smallint unsigned NOT NULL DEFAULT '0',
   `UwIntroSound` int unsigned NOT NULL DEFAULT '0',
   `FactionGroupMask` tinyint unsigned NOT NULL DEFAULT '0',
@@ -323,7 +322,6 @@ CREATE TABLE `area_table` (
   `WildBattlePetLevelMin` tinyint unsigned NOT NULL DEFAULT '0',
   `WildBattlePetLevelMax` tinyint unsigned NOT NULL DEFAULT '0',
   `WindSettingsID` tinyint unsigned NOT NULL DEFAULT '0',
-  `ContentTuningID` int NOT NULL DEFAULT '0',
   `Flags1` int NOT NULL DEFAULT '0',
   `Flags2` int NOT NULL DEFAULT '0',
   `LiquidTypeID1` smallint unsigned NOT NULL DEFAULT '0',
@@ -370,6 +368,7 @@ DROP TABLE IF EXISTS `area_trigger`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `area_trigger` (
+  `Message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `PosX` float NOT NULL DEFAULT '0',
   `PosY` float NOT NULL DEFAULT '0',
   `PosZ` float NOT NULL DEFAULT '0',
@@ -385,7 +384,7 @@ CREATE TABLE `area_trigger` (
   `BoxYaw` float NOT NULL DEFAULT '0',
   `ShapeType` tinyint NOT NULL DEFAULT '0',
   `ShapeID` smallint NOT NULL DEFAULT '0',
-  `AreaTriggerActionSetID` int NOT NULL DEFAULT '0',
+  `AreaTriggerActionSetID` smallint NOT NULL DEFAULT '0',
   `Flags` tinyint NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -393,6 +392,33 @@ CREATE TABLE `area_trigger` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `area_trigger_locale`
+--
+
+DROP TABLE IF EXISTS `area_trigger_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `area_trigger_locale` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Message_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!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 `armor_location`
 --
 
@@ -458,7 +484,6 @@ CREATE TABLE `artifact_appearance` (
   `UiAltItemAppearanceID` int unsigned NOT NULL DEFAULT '0',
   `Flags` tinyint unsigned NOT NULL DEFAULT '0',
   `UiCameraID` smallint unsigned NOT NULL DEFAULT '0',
-  `UsablePlayerConditionID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -966,10 +991,10 @@ DROP TABLE IF EXISTS `azerite_power_set_member`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `azerite_power_set_member` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `AzeritePowerSetID` int NOT NULL DEFAULT '0',
+  `AzeritePowerSetID` int unsigned NOT NULL DEFAULT '0',
   `AzeritePowerID` int NOT NULL DEFAULT '0',
   `Class` int NOT NULL DEFAULT '0',
-  `Tier` tinyint NOT NULL DEFAULT '0',
+  `Tier` tinyint unsigned NOT NULL DEFAULT '0',
   `OrderIndex` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -1068,9 +1093,9 @@ DROP TABLE IF EXISTS `barber_shop_style`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `barber_shop_style` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `DisplayName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `Type` tinyint unsigned NOT NULL DEFAULT '0',
   `CostModifier` float NOT NULL DEFAULT '0',
   `Race` tinyint unsigned NOT NULL DEFAULT '0',
@@ -1167,9 +1192,8 @@ DROP TABLE IF EXISTS `battle_pet_breed_quality`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `battle_pet_breed_quality` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `MaxQualityRoll` int NOT NULL DEFAULT '0',
   `StateMultiplier` float NOT NULL DEFAULT '0',
-  `QualityEnum` tinyint NOT NULL DEFAULT '0',
+  `QualityEnum` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1184,7 +1208,7 @@ DROP TABLE IF EXISTS `battle_pet_breed_state`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `battle_pet_breed_state` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `BattlePetStateID` int NOT NULL DEFAULT '0',
+  `BattlePetStateID` tinyint unsigned NOT NULL DEFAULT '0',
   `Value` smallint unsigned NOT NULL DEFAULT '0',
   `BattlePetBreedID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -1206,12 +1230,11 @@ CREATE TABLE `battle_pet_species` (
   `CreatureID` int NOT NULL DEFAULT '0',
   `SummonSpellID` int NOT NULL DEFAULT '0',
   `IconFileDataID` int NOT NULL DEFAULT '0',
-  `PetTypeEnum` tinyint NOT NULL DEFAULT '0',
+  `PetTypeEnum` tinyint unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `SourceTypeEnum` tinyint NOT NULL DEFAULT '0',
   `CardUIModelSceneID` int NOT NULL DEFAULT '0',
   `LoadoutUIModelSceneID` int NOT NULL DEFAULT '0',
-  `CovenantID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1254,7 +1277,7 @@ DROP TABLE IF EXISTS `battle_pet_species_state`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `battle_pet_species_state` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `BattlePetStateID` smallint unsigned NOT NULL DEFAULT '0',
+  `BattlePetStateID` tinyint unsigned NOT NULL DEFAULT '0',
   `Value` int NOT NULL DEFAULT '0',
   `BattlePetSpeciesID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -1284,7 +1307,7 @@ CREATE TABLE `battlemaster_list` (
   `GroupsAllowed` tinyint NOT NULL DEFAULT '0',
   `MaxGroupSize` tinyint NOT NULL DEFAULT '0',
   `HolidayWorldState` smallint NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Flags` tinyint NOT NULL DEFAULT '0',
   `IconFileDataID` int NOT NULL DEFAULT '0',
   `RequiredPlayerConditionID` int NOT NULL DEFAULT '0',
   `MapID1` smallint NOT NULL DEFAULT '0',
@@ -1422,7 +1445,7 @@ DROP TABLE IF EXISTS `cfg_categories`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `cfg_categories` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `Name` text COLLATE utf8mb4_unicode_ci,
+  `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `LocaleMask` smallint unsigned NOT NULL DEFAULT '0',
   `CreateCharsetMask` tinyint unsigned NOT NULL DEFAULT '0',
   `ExistingCharsetMask` tinyint unsigned NOT NULL DEFAULT '0',
@@ -1442,8 +1465,8 @@ DROP TABLE IF EXISTS `cfg_categories_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `cfg_categories_locale` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `Name_lang` text COLLATE utf8mb4_unicode_ci,
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
@@ -1554,8 +1577,8 @@ DROP TABLE IF EXISTS `character_loadout`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `character_loadout` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `RaceMask` bigint NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `ChrClassID` tinyint NOT NULL DEFAULT '0',
   `Purpose` int NOT NULL DEFAULT '0',
   `ItemContext` tinyint NOT NULL DEFAULT '0',
@@ -1588,9 +1611,9 @@ DROP TABLE IF EXISTS `chat_channels`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `chat_channels` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Shortcut` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `FactionGroup` tinyint NOT NULL DEFAULT '0',
   `Ruleset` int NOT NULL DEFAULT '0',
@@ -1657,40 +1680,26 @@ CREATE TABLE `chr_classes` (
   `NameMale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `NameFemale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `PetNameToken` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `RoleInfoString` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `DisabledString` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `HyphenatedNameMale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `HyphenatedNameFemale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
   `CreateScreenFileDataID` int unsigned NOT NULL DEFAULT '0',
   `SelectScreenFileDataID` int unsigned NOT NULL DEFAULT '0',
   `IconFileDataID` int unsigned NOT NULL DEFAULT '0',
   `LowResScreenFileDataID` int unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
-  `SpellTextureBlobFileDataID` int unsigned NOT NULL DEFAULT '0',
+  `StartingLevel` int NOT NULL DEFAULT '0',
   `ArmorTypeMask` int unsigned NOT NULL DEFAULT '0',
-  `CharStartKitUnknown901` int NOT NULL DEFAULT '0',
-  `MaleCharacterCreationVisualFallback` int NOT NULL DEFAULT '0',
-  `MaleCharacterCreationIdleVisualFallback` int NOT NULL DEFAULT '0',
-  `FemaleCharacterCreationVisualFallback` int NOT NULL DEFAULT '0',
-  `FemaleCharacterCreationIdleVisualFallback` int NOT NULL DEFAULT '0',
-  `CharacterCreationIdleGroundVisualFallback` int NOT NULL DEFAULT '0',
-  `CharacterCreationGroundVisualFallback` int NOT NULL DEFAULT '0',
-  `AlteredFormCharacterCreationIdleVisualFallback` int NOT NULL DEFAULT '0',
-  `CharacterCreationAnimLoopWaitTimeMsFallback` int NOT NULL DEFAULT '0',
   `CinematicSequenceID` smallint unsigned NOT NULL DEFAULT '0',
   `DefaultSpec` smallint unsigned NOT NULL DEFAULT '0',
+  `HasStrengthAttackBonus` tinyint unsigned NOT NULL DEFAULT '0',
   `PrimaryStatPriority` tinyint unsigned NOT NULL DEFAULT '0',
   `DisplayPower` tinyint unsigned NOT NULL DEFAULT '0',
   `RangedAttackPowerPerAgility` tinyint unsigned NOT NULL DEFAULT '0',
   `AttackPowerPerAgility` tinyint unsigned NOT NULL DEFAULT '0',
   `AttackPowerPerStrength` tinyint unsigned NOT NULL DEFAULT '0',
   `SpellClassSet` tinyint unsigned NOT NULL DEFAULT '0',
-  `ClassColorR` tinyint unsigned NOT NULL DEFAULT '0',
-  `ClassColorG` tinyint unsigned NOT NULL DEFAULT '0',
-  `ClassColorB` tinyint unsigned NOT NULL DEFAULT '0',
   `RolesMask` tinyint unsigned NOT NULL DEFAULT '0',
+  `DamageBonusStat` tinyint unsigned NOT NULL DEFAULT '0',
+  `HasRelicSlot` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1709,11 +1718,6 @@ CREATE TABLE `chr_classes_locale` (
   `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `NameMale_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `NameFemale_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `Description_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `RoleInfoString_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `DisabledString_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `HyphenatedNameMale_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `HyphenatedNameFemale_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
@@ -1862,7 +1866,6 @@ CREATE TABLE `chr_customization_option` (
   `ChrCustomizationID` int NOT NULL DEFAULT '0',
   `ChrCustomizationReqID` int NOT NULL DEFAULT '0',
   `UiOrderIndex` int NOT NULL DEFAULT '0',
-  `AddedInPatch` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1903,9 +1906,9 @@ DROP TABLE IF EXISTS `chr_customization_req`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `chr_customization_req` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `RaceMask` bigint NOT NULL DEFAULT '0',
   `ReqSource` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `ClassMask` int NOT NULL DEFAULT '0',
   `AchievementID` int NOT NULL DEFAULT '0',
@@ -2037,35 +2040,29 @@ CREATE TABLE `chr_races` (
   `ShortNameLower` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ShortNameLowerFemale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Flags` int NOT NULL DEFAULT '0',
-  `FactionID` int NOT NULL DEFAULT '0',
-  `CinematicSequenceID` int NOT NULL DEFAULT '0',
+  `MaleDisplayID` int unsigned NOT NULL DEFAULT '0',
+  `FemaleDisplayID` int unsigned NOT NULL DEFAULT '0',
+  `HighResMaleDisplayID` int unsigned NOT NULL DEFAULT '0',
+  `HighResFemaleDisplayID` int unsigned NOT NULL DEFAULT '0',
   `ResSicknessSpellID` int NOT NULL DEFAULT '0',
   `SplashSoundID` int NOT NULL DEFAULT '0',
-  `Alliance` int NOT NULL DEFAULT '0',
-  `RaceRelated` int NOT NULL DEFAULT '0',
-  `UnalteredVisualRaceID` int NOT NULL DEFAULT '0',
-  `DefaultClassID` int NOT NULL DEFAULT '0',
   `CreateScreenFileDataID` int NOT NULL DEFAULT '0',
   `SelectScreenFileDataID` int NOT NULL DEFAULT '0',
-  `NeutralRaceID` int NOT NULL DEFAULT '0',
   `LowResScreenFileDataID` int NOT NULL DEFAULT '0',
-  `AlteredFormStartVisualKitID1` int NOT NULL DEFAULT '0',
-  `AlteredFormStartVisualKitID2` int NOT NULL DEFAULT '0',
-  `AlteredFormStartVisualKitID3` int NOT NULL DEFAULT '0',
-  `AlteredFormFinishVisualKitID1` int NOT NULL DEFAULT '0',
-  `AlteredFormFinishVisualKitID2` int NOT NULL DEFAULT '0',
-  `AlteredFormFinishVisualKitID3` int NOT NULL DEFAULT '0',
+  `AlteredFormStartVisualKitID1` int unsigned NOT NULL DEFAULT '0',
+  `AlteredFormStartVisualKitID2` int unsigned NOT NULL DEFAULT '0',
+  `AlteredFormStartVisualKitID3` int unsigned NOT NULL DEFAULT '0',
+  `AlteredFormFinishVisualKitID1` int unsigned NOT NULL DEFAULT '0',
+  `AlteredFormFinishVisualKitID2` int unsigned NOT NULL DEFAULT '0',
+  `AlteredFormFinishVisualKitID3` int unsigned NOT NULL DEFAULT '0',
   `HeritageArmorAchievementID` int NOT NULL DEFAULT '0',
   `StartingLevel` int NOT NULL DEFAULT '0',
   `UiDisplayOrder` int NOT NULL DEFAULT '0',
-  `MaleModelFallbackRaceID` int NOT NULL DEFAULT '0',
-  `FemaleModelFallbackRaceID` int NOT NULL DEFAULT '0',
-  `MaleTextureFallbackRaceID` int NOT NULL DEFAULT '0',
-  `FemaleTextureFallbackRaceID` int NOT NULL DEFAULT '0',
   `PlayableRaceBit` int NOT NULL DEFAULT '0',
+  `FemaleSkeletonFileDataID` int NOT NULL DEFAULT '0',
+  `MaleSkeletonFileDataID` int NOT NULL DEFAULT '0',
   `HelmetAnimScalingRaceID` int NOT NULL DEFAULT '0',
   `TransmogrifyDisabledSlotMask` int NOT NULL DEFAULT '0',
-  `UnalteredVisualCustomizationRaceID` int NOT NULL DEFAULT '0',
   `AlteredFormCustomizeOffsetFallback1` float NOT NULL DEFAULT '0',
   `AlteredFormCustomizeOffsetFallback2` float NOT NULL DEFAULT '0',
   `AlteredFormCustomizeOffsetFallback3` float NOT NULL DEFAULT '0',
@@ -2076,13 +2073,24 @@ CREATE TABLE `chr_races` (
   `Unknown910_21` float NOT NULL DEFAULT '0',
   `Unknown910_22` float NOT NULL DEFAULT '0',
   `Unknown910_23` float NOT NULL DEFAULT '0',
-  `Unknown1000` int NOT NULL DEFAULT '0',
+  `FactionID` smallint NOT NULL DEFAULT '0',
+  `CinematicSequenceID` smallint NOT NULL DEFAULT '0',
   `BaseLanguage` tinyint NOT NULL DEFAULT '0',
   `CreatureType` tinyint NOT NULL DEFAULT '0',
+  `Alliance` tinyint NOT NULL DEFAULT '0',
+  `RaceRelated` tinyint NOT NULL DEFAULT '0',
+  `UnalteredVisualRaceID` tinyint NOT NULL DEFAULT '0',
+  `DefaultClassID` tinyint NOT NULL DEFAULT '0',
+  `NeutralRaceID` tinyint NOT NULL DEFAULT '0',
+  `MaleModelFallbackRaceID` tinyint NOT NULL DEFAULT '0',
   `MaleModelFallbackSex` tinyint NOT NULL DEFAULT '0',
+  `FemaleModelFallbackRaceID` tinyint NOT NULL DEFAULT '0',
   `FemaleModelFallbackSex` tinyint NOT NULL DEFAULT '0',
+  `MaleTextureFallbackRaceID` tinyint NOT NULL DEFAULT '0',
   `MaleTextureFallbackSex` tinyint NOT NULL DEFAULT '0',
+  `FemaleTextureFallbackRaceID` tinyint NOT NULL DEFAULT '0',
   `FemaleTextureFallbackSex` tinyint NOT NULL DEFAULT '0',
+  `UnalteredVisualCustomizationRaceID` tinyint NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2139,7 +2147,7 @@ CREATE TABLE `chr_specialization` (
   `FemaleName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `ClassID` tinyint NOT NULL DEFAULT '0',
+  `ClassID` tinyint unsigned NOT NULL DEFAULT '0',
   `OrderIndex` tinyint NOT NULL DEFAULT '0',
   `PetTalentType` tinyint NOT NULL DEFAULT '0',
   `Role` tinyint NOT NULL DEFAULT '0',
@@ -2198,7 +2206,6 @@ CREATE TABLE `cinematic_camera` (
   `SoundID` int unsigned NOT NULL DEFAULT '0',
   `OriginFacing` float NOT NULL DEFAULT '0',
   `FileDataID` int unsigned NOT NULL DEFAULT '0',
-  `ConversationID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2273,18 +2280,11 @@ DROP TABLE IF EXISTS `content_tuning`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `content_tuning` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
-  `ExpansionID` int NOT NULL DEFAULT '0',
   `MinLevel` int NOT NULL DEFAULT '0',
   `MaxLevel` int NOT NULL DEFAULT '0',
-  `MinLevelType` int NOT NULL DEFAULT '0',
-  `MaxLevelType` int NOT NULL DEFAULT '0',
-  `TargetLevelDelta` int NOT NULL DEFAULT '0',
-  `TargetLevelMaxDelta` int NOT NULL DEFAULT '0',
-  `TargetLevelMin` int NOT NULL DEFAULT '0',
-  `TargetLevelMax` int NOT NULL DEFAULT '0',
-  `MinItemLevel` int NOT NULL DEFAULT '0',
-  `QuestXpMultiplier` float NOT NULL DEFAULT '0',
+  `Flags` int NOT NULL DEFAULT '0',
+  `ExpectedStatModID` int NOT NULL DEFAULT '0',
+  `DifficultyESMID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2477,9 +2477,17 @@ CREATE TABLE `creature_display_info_extra` (
   `DisplayRaceID` tinyint NOT NULL DEFAULT '0',
   `DisplaySexID` tinyint NOT NULL DEFAULT '0',
   `DisplayClassID` tinyint NOT NULL DEFAULT '0',
+  `SkinID` tinyint NOT NULL DEFAULT '0',
+  `FaceID` tinyint NOT NULL DEFAULT '0',
+  `HairStyleID` tinyint NOT NULL DEFAULT '0',
+  `HairColorID` tinyint NOT NULL DEFAULT '0',
+  `FacialHairID` tinyint NOT NULL DEFAULT '0',
   `Flags` tinyint NOT NULL DEFAULT '0',
   `BakeMaterialResourcesID` int NOT NULL DEFAULT '0',
   `HDBakeMaterialResourcesID` int NOT NULL DEFAULT '0',
+  `CustomDisplayOption1` tinyint unsigned NOT NULL DEFAULT '0',
+  `CustomDisplayOption2` tinyint unsigned NOT NULL DEFAULT '0',
+  `CustomDisplayOption3` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2501,6 +2509,7 @@ CREATE TABLE `creature_family` (
   `MaxScaleLevel` tinyint NOT NULL DEFAULT '0',
   `PetFoodMask` smallint NOT NULL DEFAULT '0',
   `PetTalentType` tinyint NOT NULL DEFAULT '0',
+  `CategoryEnumID` int NOT NULL DEFAULT '0',
   `IconFileID` int NOT NULL DEFAULT '0',
   `SkillLine1` smallint NOT NULL DEFAULT '0',
   `SkillLine2` smallint NOT NULL DEFAULT '0',
@@ -2553,8 +2562,6 @@ CREATE TABLE `creature_model_data` (
   `GeoBox6` float NOT NULL DEFAULT '0',
   `Flags` int unsigned NOT NULL DEFAULT '0',
   `FileDataID` int unsigned NOT NULL DEFAULT '0',
-  `WalkSpeed` float NOT NULL DEFAULT '0',
-  `RunSpeed` float NOT NULL DEFAULT '0',
   `BloodID` int unsigned NOT NULL DEFAULT '0',
   `FootprintTextureID` int unsigned NOT NULL DEFAULT '0',
   `FootprintTextureLength` float NOT NULL DEFAULT '0',
@@ -2580,10 +2587,6 @@ CREATE TABLE `creature_model_data` (
   `OverrideNameScale` float NOT NULL DEFAULT '0',
   `OverrideSelectionRadius` float NOT NULL DEFAULT '0',
   `TamedPetBaseScale` float NOT NULL DEFAULT '0',
-  `Unknown820_1` tinyint NOT NULL DEFAULT '0',
-  `Unknown820_2` float NOT NULL DEFAULT '0',
-  `Unknown820_31` float NOT NULL DEFAULT '0',
-  `Unknown820_32` float NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2719,7 +2722,7 @@ CREATE TABLE `currency_container` (
   `MinAmount` int NOT NULL DEFAULT '0',
   `MaxAmount` int NOT NULL DEFAULT '0',
   `ContainerIconID` int NOT NULL DEFAULT '0',
-  `ContainerQuality` tinyint NOT NULL DEFAULT '0',
+  `ContainerQuality` int NOT NULL DEFAULT '0',
   `OnLootSpellVisualKitID` int NOT NULL DEFAULT '0',
   `CurrencyTypesID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -2766,7 +2769,7 @@ CREATE TABLE `currency_types` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `CategoryID` int NOT NULL DEFAULT '0',
+  `CategoryID` tinyint unsigned NOT NULL DEFAULT '0',
   `InventoryIconFileID` int NOT NULL DEFAULT '0',
   `SpellWeight` int unsigned NOT NULL DEFAULT '0',
   `SpellCategory` tinyint unsigned NOT NULL DEFAULT '0',
@@ -2774,12 +2777,7 @@ CREATE TABLE `currency_types` (
   `MaxEarnablePerWeek` int unsigned NOT NULL DEFAULT '0',
   `Quality` tinyint NOT NULL DEFAULT '0',
   `FactionID` int NOT NULL DEFAULT '0',
-  `ItemGroupSoundsID` int NOT NULL DEFAULT '0',
-  `XpQuestDifficulty` int NOT NULL DEFAULT '0',
   `AwardConditionID` int NOT NULL DEFAULT '0',
-  `MaxQtyWorldStateID` int NOT NULL DEFAULT '0',
-  `RechargingAmountPerCycle` int unsigned NOT NULL DEFAULT '0',
-  `RechargingCycleDurationMS` int unsigned NOT NULL DEFAULT '0',
   `Flags1` int NOT NULL DEFAULT '0',
   `Flags2` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -2862,20 +2860,20 @@ CREATE TABLE `destructible_model_data` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `State0ImpactEffectDoodadSet` tinyint NOT NULL DEFAULT '0',
   `State0AmbientDoodadSet` tinyint unsigned NOT NULL DEFAULT '0',
-  `State1Wmo` int NOT NULL DEFAULT '0',
+  `State1Wmo` int unsigned NOT NULL DEFAULT '0',
   `State1DestructionDoodadSet` tinyint NOT NULL DEFAULT '0',
   `State1ImpactEffectDoodadSet` tinyint NOT NULL DEFAULT '0',
   `State1AmbientDoodadSet` tinyint unsigned NOT NULL DEFAULT '0',
-  `State2Wmo` int NOT NULL DEFAULT '0',
+  `State2Wmo` int unsigned NOT NULL DEFAULT '0',
   `State2DestructionDoodadSet` tinyint NOT NULL DEFAULT '0',
   `State2ImpactEffectDoodadSet` tinyint NOT NULL DEFAULT '0',
   `State2AmbientDoodadSet` tinyint unsigned NOT NULL DEFAULT '0',
-  `State3Wmo` int NOT NULL DEFAULT '0',
+  `State3Wmo` int unsigned NOT NULL DEFAULT '0',
   `State3InitDoodadSet` tinyint unsigned NOT NULL DEFAULT '0',
   `State3AmbientDoodadSet` tinyint unsigned NOT NULL DEFAULT '0',
   `EjectDirection` tinyint unsigned NOT NULL DEFAULT '0',
   `DoNotHighlight` tinyint unsigned NOT NULL DEFAULT '0',
-  `State0Wmo` int NOT NULL DEFAULT '0',
+  `State0Wmo` int unsigned NOT NULL DEFAULT '0',
   `HealEffect` tinyint unsigned NOT NULL DEFAULT '0',
   `HealEffectSpeed` smallint unsigned NOT NULL DEFAULT '0',
   `State0NameSet` tinyint NOT NULL DEFAULT '0',
@@ -2903,12 +2901,12 @@ CREATE TABLE `difficulty` (
   `FallbackDifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
   `MinPlayers` tinyint unsigned NOT NULL DEFAULT '0',
   `MaxPlayers` tinyint unsigned NOT NULL DEFAULT '0',
-  `Flags` smallint unsigned NOT NULL DEFAULT '0',
+  `Flags` tinyint unsigned NOT NULL DEFAULT '0',
   `ItemContext` tinyint unsigned NOT NULL DEFAULT '0',
   `ToggleDifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
-  `GroupSizeHealthCurveID` int unsigned NOT NULL DEFAULT '0',
-  `GroupSizeDmgCurveID` int unsigned NOT NULL DEFAULT '0',
-  `GroupSizeSpellPointsCurveID` int unsigned NOT NULL DEFAULT '0',
+  `GroupSizeHealthCurveID` smallint unsigned NOT NULL DEFAULT '0',
+  `GroupSizeDmgCurveID` smallint unsigned NOT NULL DEFAULT '0',
+  `GroupSizeSpellPointsCurveID` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2954,10 +2952,8 @@ CREATE TABLE `dungeon_encounter` (
   `MapID` smallint NOT NULL DEFAULT '0',
   `DifficultyID` int NOT NULL DEFAULT '0',
   `OrderIndex` int NOT NULL DEFAULT '0',
-  `CompleteWorldStateID` int NOT NULL DEFAULT '0',
   `Bit` tinyint NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
-  `SpellIconFileID` int NOT NULL DEFAULT '0',
   `Faction` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -3163,17 +3159,17 @@ DROP TABLE IF EXISTS `faction`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `faction` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `ReputationRaceMask1` bigint NOT NULL DEFAULT '0',
   `ReputationRaceMask2` bigint NOT NULL DEFAULT '0',
   `ReputationRaceMask3` bigint NOT NULL DEFAULT '0',
   `ReputationRaceMask4` bigint NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `ReputationIndex` smallint NOT NULL DEFAULT '0',
   `ParentFactionID` smallint unsigned NOT NULL DEFAULT '0',
   `Expansion` tinyint unsigned NOT NULL DEFAULT '0',
-  `FriendshipRepID` int unsigned NOT NULL DEFAULT '0',
+  `FriendshipRepID` tinyint unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `ParagonFactionID` smallint unsigned NOT NULL DEFAULT '0',
   `RenownFactionID` int NOT NULL DEFAULT '0',
@@ -3276,9 +3272,8 @@ DROP TABLE IF EXISTS `friendship_rep_reaction`;
 CREATE TABLE `friendship_rep_reaction` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Reaction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `FriendshipRepID` int unsigned NOT NULL DEFAULT '0',
+  `FriendshipRepID` tinyint unsigned NOT NULL DEFAULT '0',
   `ReactionThreshold` smallint unsigned NOT NULL DEFAULT '0',
-  `OverrideColor` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3320,12 +3315,9 @@ DROP TABLE IF EXISTS `friendship_reputation`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `friendship_reputation` (
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `StandingModified` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `StandingChanged` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `FactionID` int NOT NULL DEFAULT '0',
-  `TextureFileID` int NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Field34146722002` int NOT NULL DEFAULT '0',
+  `Field34146722003` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3342,8 +3334,6 @@ CREATE TABLE `friendship_reputation_locale` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
   `Description_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `StandingModified_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `StandingChanged_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
@@ -3387,6 +3377,7 @@ DROP TABLE IF EXISTS `gameobject_display_info`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gameobject_display_info` (
   `ID` int unsigned NOT NULL DEFAULT '0',
+  `ModelName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `GeoBoxMinX` float NOT NULL DEFAULT '0',
   `GeoBoxMinY` float NOT NULL DEFAULT '0',
   `GeoBoxMinZ` float NOT NULL DEFAULT '0',
@@ -3397,9 +3388,6 @@ CREATE TABLE `gameobject_display_info` (
   `ObjectEffectPackageID` smallint NOT NULL DEFAULT '0',
   `OverrideLootEffectScale` float NOT NULL DEFAULT '0',
   `OverrideNameScale` float NOT NULL DEFAULT '0',
-  `AlternateDisplayType` int NOT NULL DEFAULT '0',
-  `ClientCreatureDisplayInfoID` int NOT NULL DEFAULT '0',
-  `ClientItemID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3422,13 +3410,13 @@ CREATE TABLE `gameobjects` (
   `Rot3` float NOT NULL DEFAULT '0',
   `Rot4` float NOT NULL DEFAULT '0',
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `OwnerID` int NOT NULL DEFAULT '0',
-  `DisplayID` int NOT NULL DEFAULT '0',
+  `OwnerID` smallint unsigned NOT NULL DEFAULT '0',
+  `DisplayID` int unsigned NOT NULL DEFAULT '0',
   `Scale` float NOT NULL DEFAULT '0',
-  `TypeID` int NOT NULL DEFAULT '0',
-  `PhaseUseFlags` int NOT NULL DEFAULT '0',
-  `PhaseID` int NOT NULL DEFAULT '0',
-  `PhaseGroupID` int NOT NULL DEFAULT '0',
+  `TypeID` tinyint unsigned NOT NULL DEFAULT '0',
+  `PhaseUseFlags` tinyint unsigned NOT NULL DEFAULT '0',
+  `PhaseID` smallint unsigned NOT NULL DEFAULT '0',
+  `PhaseGroupID` smallint unsigned NOT NULL DEFAULT '0',
   `PropValue1` int NOT NULL DEFAULT '0',
   `PropValue2` int NOT NULL DEFAULT '0',
   `PropValue3` int NOT NULL DEFAULT '0',
@@ -3477,14 +3465,14 @@ DROP TABLE IF EXISTS `garr_ability`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `garr_ability` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `GarrAbilityCategoryID` tinyint unsigned NOT NULL DEFAULT '0',
-  `GarrFollowerTypeID` tinyint NOT NULL DEFAULT '0',
+  `GarrFollowerTypeID` tinyint unsigned NOT NULL DEFAULT '0',
   `IconFileDataID` int NOT NULL DEFAULT '0',
   `FactionChangeGarrAbilityID` smallint unsigned NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Flags` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3531,11 +3519,11 @@ CREATE TABLE `garr_building` (
   `AllianceName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Tooltip` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `GarrTypeID` tinyint NOT NULL DEFAULT '0',
-  `BuildingType` tinyint NOT NULL DEFAULT '0',
+  `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0',
+  `BuildingType` tinyint unsigned NOT NULL DEFAULT '0',
   `HordeGameObjectID` int NOT NULL DEFAULT '0',
   `AllianceGameObjectID` int NOT NULL DEFAULT '0',
-  `GarrSiteID` int NOT NULL DEFAULT '0',
+  `GarrSiteID` tinyint unsigned NOT NULL DEFAULT '0',
   `UpgradeLevel` tinyint unsigned NOT NULL DEFAULT '0',
   `BuildSeconds` int NOT NULL DEFAULT '0',
   `CurrencyTypeID` smallint unsigned NOT NULL DEFAULT '0',
@@ -3550,7 +3538,7 @@ CREATE TABLE `garr_building` (
   `GarrAbilityID` smallint unsigned NOT NULL DEFAULT '0',
   `BonusGarrAbilityID` smallint unsigned NOT NULL DEFAULT '0',
   `GoldCost` smallint unsigned NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Flags` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3613,14 +3601,14 @@ DROP TABLE IF EXISTS `garr_class_spec`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `garr_class_spec` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `ClassSpec` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ClassSpecMale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ClassSpecFemale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `UiTextureAtlasMemberID` smallint unsigned NOT NULL DEFAULT '0',
   `GarrFollItemSetID` smallint unsigned NOT NULL DEFAULT '0',
   `FollowerClassLimit` tinyint unsigned NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Flags` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3663,19 +3651,19 @@ DROP TABLE IF EXISTS `garr_follower`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `garr_follower` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `HordeSourceText` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `AllianceSourceText` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `TitleName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `GarrTypeID` tinyint NOT NULL DEFAULT '0',
-  `GarrFollowerTypeID` tinyint NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0',
+  `GarrFollowerTypeID` tinyint unsigned NOT NULL DEFAULT '0',
   `HordeCreatureID` int NOT NULL DEFAULT '0',
   `AllianceCreatureID` int NOT NULL DEFAULT '0',
   `HordeGarrFollRaceID` tinyint unsigned NOT NULL DEFAULT '0',
   `AllianceGarrFollRaceID` tinyint unsigned NOT NULL DEFAULT '0',
-  `HordeGarrClassSpecID` int NOT NULL DEFAULT '0',
-  `AllianceGarrClassSpecID` int NOT NULL DEFAULT '0',
-  `Quality` tinyint NOT NULL DEFAULT '0',
+  `HordeGarrClassSpecID` tinyint unsigned NOT NULL DEFAULT '0',
+  `AllianceGarrClassSpecID` tinyint unsigned NOT NULL DEFAULT '0',
+  `Quality` tinyint unsigned NOT NULL DEFAULT '0',
   `FollowerLevel` tinyint unsigned NOT NULL DEFAULT '0',
   `ItemLevelWeapon` smallint unsigned NOT NULL DEFAULT '0',
   `ItemLevelArmor` smallint unsigned NOT NULL DEFAULT '0',
@@ -3693,10 +3681,8 @@ CREATE TABLE `garr_follower` (
   `HordeSlottingBroadcastTextID` int unsigned NOT NULL DEFAULT '0',
   `AllySlottingBroadcastTextID` int unsigned NOT NULL DEFAULT '0',
   `ChrClassID` tinyint unsigned NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Flags` tinyint unsigned NOT NULL DEFAULT '0',
   `Gender` tinyint unsigned NOT NULL DEFAULT '0',
-  `AutoCombatantID` int NOT NULL DEFAULT '0',
-  `CovenantID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3757,7 +3743,6 @@ DROP TABLE IF EXISTS `garr_mission`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `garr_mission` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
@@ -3765,7 +3750,8 @@ CREATE TABLE `garr_mission` (
   `MapPosY` float NOT NULL DEFAULT '0',
   `WorldPosX` float NOT NULL DEFAULT '0',
   `WorldPosY` float NOT NULL DEFAULT '0',
-  `GarrTypeID` tinyint NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0',
   `GarrMissionTypeID` tinyint unsigned NOT NULL DEFAULT '0',
   `GarrFollowerTypeID` tinyint unsigned NOT NULL DEFAULT '0',
   `MaxFollowers` tinyint unsigned NOT NULL DEFAULT '0',
@@ -3774,9 +3760,8 @@ CREATE TABLE `garr_mission` (
   `OfferedGarrMissionTextureID` tinyint unsigned NOT NULL DEFAULT '0',
   `UiTextureKitID` smallint unsigned NOT NULL DEFAULT '0',
   `EnvGarrMechanicID` int unsigned NOT NULL DEFAULT '0',
-  `EnvGarrMechanicTypeID` int NOT NULL DEFAULT '0',
+  `EnvGarrMechanicTypeID` tinyint unsigned NOT NULL DEFAULT '0',
   `PlayerConditionID` int unsigned NOT NULL DEFAULT '0',
-  `GarrMissionSetID` int NOT NULL DEFAULT '0',
   `TargetLevel` tinyint NOT NULL DEFAULT '0',
   `TargetItemLevel` smallint unsigned NOT NULL DEFAULT '0',
   `MissionDuration` int NOT NULL DEFAULT '0',
@@ -3787,10 +3772,8 @@ CREATE TABLE `garr_mission` (
   `OvermaxRewardPackID` int unsigned NOT NULL DEFAULT '0',
   `FollowerDeathChance` tinyint unsigned NOT NULL DEFAULT '0',
   `AreaID` int unsigned NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
-  `AutoMissionScalar` float NOT NULL DEFAULT '0',
-  `AutoMissionScalarCurveID` int NOT NULL DEFAULT '0',
-  `AutoCombatantEnvCasterID` int NOT NULL DEFAULT '0',
+  `Flags` int unsigned NOT NULL DEFAULT '0',
+  `GarrMissionSetID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3932,17 +3915,12 @@ DROP TABLE IF EXISTS `garr_talent_tree`;
 CREATE TABLE `garr_talent_tree` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `GarrTypeID` tinyint NOT NULL DEFAULT '0',
+  `GarrTypeID` int NOT NULL DEFAULT '0',
   `ClassID` int NOT NULL DEFAULT '0',
   `MaxTiers` tinyint NOT NULL DEFAULT '0',
   `UiOrder` tinyint NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Flags` tinyint NOT NULL DEFAULT '0',
   `UiTextureKitID` smallint unsigned NOT NULL DEFAULT '0',
-  `GarrTalentTreeType` int NOT NULL DEFAULT '0',
-  `PlayerConditionID` int NOT NULL DEFAULT '0',
-  `FeatureTypeIndex` tinyint unsigned NOT NULL DEFAULT '0',
-  `FeatureSubtypeIndex` tinyint NOT NULL DEFAULT '0',
-  `CurrencyID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3986,6 +3964,7 @@ CREATE TABLE `gem_properties` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `EnchantId` smallint unsigned NOT NULL DEFAULT '0',
   `Type` int NOT NULL DEFAULT '0',
+  `MinItemLevel` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -4036,6 +4015,7 @@ CREATE TABLE `glyph_properties` (
   `GlyphType` tinyint unsigned NOT NULL DEFAULT '0',
   `GlyphExclusiveCategoryID` tinyint unsigned NOT NULL DEFAULT '0',
   `SpellIconFileDataID` int NOT NULL DEFAULT '0',
+  `GlyphSlotFlags` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -4058,6 +4038,22 @@ CREATE TABLE `glyph_required_spec` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `glyph_slot`
+--
+
+DROP TABLE IF EXISTS `glyph_slot`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `glyph_slot` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Tooltip` int NOT NULL DEFAULT '0',
+  `Type` int unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `gossip_npc_option`
 --
 
@@ -4068,19 +4064,16 @@ CREATE TABLE `gossip_npc_option` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `GossipNpcOption` int NOT NULL DEFAULT '0',
   `LFGDungeonsID` int NOT NULL DEFAULT '0',
-  `TrainerID` int NOT NULL DEFAULT '0',
-  `GarrFollowerTypeID` int NOT NULL DEFAULT '0',
-  `CharShipmentID` int NOT NULL DEFAULT '0',
-  `GarrTalentTreeID` int NOT NULL DEFAULT '0',
-  `UiMapID` int NOT NULL DEFAULT '0',
-  `UiItemInteractionID` int NOT NULL DEFAULT '0',
-  `Unknown_1000_8` int NOT NULL DEFAULT '0',
-  `Unknown_1000_9` int NOT NULL DEFAULT '0',
-  `CovenantID` int NOT NULL DEFAULT '0',
+  `Unk341_1` int NOT NULL DEFAULT '0',
+  `Unk341_2` int NOT NULL DEFAULT '0',
+  `Unk341_3` int NOT NULL DEFAULT '0',
+  `Unk341_4` int NOT NULL DEFAULT '0',
+  `Unk341_5` int NOT NULL DEFAULT '0',
+  `Unk341_6` int NOT NULL DEFAULT '0',
+  `Unk341_7` int NOT NULL DEFAULT '0',
+  `Unk341_8` int NOT NULL DEFAULT '0',
+  `Unk341_9` int NOT NULL DEFAULT '0',
   `GossipOptionID` int NOT NULL DEFAULT '0',
-  `TraitTreeID` int NOT NULL DEFAULT '0',
-  `ProfessionID` int NOT NULL DEFAULT '0',
-  `Unknown_1002_14` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -4228,6 +4221,7 @@ CREATE TABLE `holidays` (
   `Priority` tinyint unsigned NOT NULL DEFAULT '0',
   `CalendarFilterType` tinyint NOT NULL DEFAULT '0',
   `Flags` tinyint unsigned NOT NULL DEFAULT '0',
+  `WorldStateExpressionID` int unsigned NOT NULL DEFAULT '0',
   `Duration1` smallint unsigned NOT NULL DEFAULT '0',
   `Duration2` smallint unsigned NOT NULL DEFAULT '0',
   `Duration3` smallint unsigned NOT NULL DEFAULT '0',
@@ -4254,16 +4248,6 @@ CREATE TABLE `holidays` (
   `Date14` int unsigned NOT NULL DEFAULT '0',
   `Date15` int unsigned NOT NULL DEFAULT '0',
   `Date16` int unsigned NOT NULL DEFAULT '0',
-  `Date17` int unsigned NOT NULL DEFAULT '0',
-  `Date18` int unsigned NOT NULL DEFAULT '0',
-  `Date19` int unsigned NOT NULL DEFAULT '0',
-  `Date20` int unsigned NOT NULL DEFAULT '0',
-  `Date21` int unsigned NOT NULL DEFAULT '0',
-  `Date22` int unsigned NOT NULL DEFAULT '0',
-  `Date23` int unsigned NOT NULL DEFAULT '0',
-  `Date24` int unsigned NOT NULL DEFAULT '0',
-  `Date25` int unsigned NOT NULL DEFAULT '0',
-  `Date26` int unsigned NOT NULL DEFAULT '0',
   `CalendarFlags1` tinyint unsigned NOT NULL DEFAULT '0',
   `CalendarFlags2` tinyint unsigned NOT NULL DEFAULT '0',
   `CalendarFlags3` tinyint unsigned NOT NULL DEFAULT '0',
@@ -4410,13 +4394,40 @@ CREATE TABLE `item` (
   `SubclassID` tinyint unsigned NOT NULL DEFAULT '0',
   `Material` tinyint unsigned NOT NULL DEFAULT '0',
   `InventoryType` tinyint NOT NULL DEFAULT '0',
+  `RequiredLevel` int NOT NULL DEFAULT '0',
   `SheatheType` tinyint unsigned NOT NULL DEFAULT '0',
+  `RandomSelect` smallint unsigned NOT NULL DEFAULT '0',
+  `ItemRandomSuffixGroupID` smallint unsigned NOT NULL DEFAULT '0',
   `SoundOverrideSubclassID` tinyint NOT NULL DEFAULT '0',
+  `ScalingStatDistributionID` smallint unsigned NOT NULL DEFAULT '0',
   `IconFileDataID` int NOT NULL DEFAULT '0',
   `ItemGroupSoundsID` tinyint unsigned NOT NULL DEFAULT '0',
   `ContentTuningID` int NOT NULL DEFAULT '0',
-  `ModifiedCraftingReagentItemID` int NOT NULL DEFAULT '0',
-  `CraftingQualityID` int NOT NULL DEFAULT '0',
+  `MaxDurability` int unsigned NOT NULL DEFAULT '0',
+  `AmmunitionType` tinyint unsigned NOT NULL DEFAULT '0',
+  `ScalingStatValue` int NOT NULL DEFAULT '0',
+  `DamageType1` tinyint unsigned NOT NULL DEFAULT '0',
+  `DamageType2` tinyint unsigned NOT NULL DEFAULT '0',
+  `DamageType3` tinyint unsigned NOT NULL DEFAULT '0',
+  `DamageType4` tinyint unsigned NOT NULL DEFAULT '0',
+  `DamageType5` tinyint unsigned NOT NULL DEFAULT '0',
+  `Resistances1` smallint NOT NULL DEFAULT '0',
+  `Resistances2` smallint NOT NULL DEFAULT '0',
+  `Resistances3` smallint NOT NULL DEFAULT '0',
+  `Resistances4` smallint NOT NULL DEFAULT '0',
+  `Resistances5` smallint NOT NULL DEFAULT '0',
+  `Resistances6` smallint NOT NULL DEFAULT '0',
+  `Resistances7` smallint NOT NULL DEFAULT '0',
+  `MinDamage1` smallint unsigned NOT NULL DEFAULT '0',
+  `MinDamage2` smallint unsigned NOT NULL DEFAULT '0',
+  `MinDamage3` smallint unsigned NOT NULL DEFAULT '0',
+  `MinDamage4` smallint unsigned NOT NULL DEFAULT '0',
+  `MinDamage5` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxDamage1` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxDamage2` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxDamage3` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxDamage4` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxDamage5` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -4431,11 +4442,10 @@ DROP TABLE IF EXISTS `item_appearance`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_appearance` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `DisplayType` int NOT NULL DEFAULT '0',
+  `DisplayType` tinyint unsigned NOT NULL DEFAULT '0',
   `ItemDisplayInfoID` int NOT NULL DEFAULT '0',
   `DefaultIconFileDataID` int NOT NULL DEFAULT '0',
   `UiOrder` int NOT NULL DEFAULT '0',
-  `PlayerConditionID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -4632,10 +4642,6 @@ CREATE TABLE `item_bonus_tree_node` (
   `ChildItemBonusTreeID` smallint unsigned NOT NULL DEFAULT '0',
   `ChildItemBonusListID` smallint unsigned NOT NULL DEFAULT '0',
   `ChildItemLevelSelectorID` smallint unsigned NOT NULL DEFAULT '0',
-  `ChildItemBonusListGroupID` int NOT NULL DEFAULT '0',
-  `IblGroupPointsModSetID` int NOT NULL DEFAULT '0',
-  `MinMythicPlusLevel` int NOT NULL DEFAULT '0',
-  `MaxMythicPlusLevel` int NOT NULL DEFAULT '0',
   `ParentItemBonusTreeID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -4651,9 +4657,9 @@ DROP TABLE IF EXISTS `item_child_equipment`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_child_equipment` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `ParentItemID` int NOT NULL DEFAULT '0',
   `ChildItemID` int NOT NULL DEFAULT '0',
   `ChildItemEquipSlot` tinyint unsigned NOT NULL DEFAULT '0',
+  `ParentItemID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -4716,7 +4722,6 @@ CREATE TABLE `item_context_picker_entry` (
   `ItemCreationContext` tinyint unsigned NOT NULL DEFAULT '0',
   `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0',
   `PVal` int NOT NULL DEFAULT '0',
-  `LabelID` int NOT NULL DEFAULT '0',
   `Flags` int unsigned NOT NULL DEFAULT '0',
   `PlayerConditionID` int unsigned NOT NULL DEFAULT '0',
   `ItemContextPickerID` int unsigned NOT NULL DEFAULT '0',
@@ -4888,6 +4893,7 @@ CREATE TABLE `item_effect` (
   `SpellCategoryID` smallint unsigned NOT NULL DEFAULT '0',
   `SpellID` int NOT NULL DEFAULT '0',
   `ChrSpecializationID` smallint unsigned NOT NULL DEFAULT '0',
+  `ParentItemID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -4944,7 +4950,6 @@ CREATE TABLE `item_level_selector` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `MinItemLevel` smallint unsigned NOT NULL DEFAULT '0',
   `ItemLevelSelectorQualitySetID` smallint unsigned NOT NULL DEFAULT '0',
-  `AzeriteUnlockMappingSet` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -5057,7 +5062,7 @@ CREATE TABLE `item_modified_appearance` (
   `ItemAppearanceModifierID` int NOT NULL DEFAULT '0',
   `ItemAppearanceID` int NOT NULL DEFAULT '0',
   `OrderIndex` int NOT NULL DEFAULT '0',
-  `TransmogSourceTypeEnum` tinyint unsigned NOT NULL DEFAULT '0',
+  `TransmogSourceTypeEnum` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -5143,6 +5148,105 @@ CREATE TABLE `item_price_base` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `item_random_properties`
+--
+
+DROP TABLE IF EXISTS `item_random_properties`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `item_random_properties` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Enchantment1` smallint unsigned NOT NULL DEFAULT '0',
+  `Enchantment2` smallint unsigned NOT NULL DEFAULT '0',
+  `Enchantment3` smallint unsigned NOT NULL DEFAULT '0',
+  `Enchantment4` smallint unsigned NOT NULL DEFAULT '0',
+  `Enchantment5` smallint unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_random_properties_locale`
+--
+
+DROP TABLE IF EXISTS `item_random_properties_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `item_random_properties_locale` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!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 `item_random_suffix`
+--
+
+DROP TABLE IF EXISTS `item_random_suffix`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `item_random_suffix` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Enchantment1` smallint unsigned NOT NULL DEFAULT '0',
+  `Enchantment2` smallint unsigned NOT NULL DEFAULT '0',
+  `Enchantment3` smallint unsigned NOT NULL DEFAULT '0',
+  `Enchantment4` smallint unsigned NOT NULL DEFAULT '0',
+  `Enchantment5` smallint unsigned NOT NULL DEFAULT '0',
+  `AllocationPct1` smallint unsigned NOT NULL DEFAULT '0',
+  `AllocationPct2` smallint unsigned NOT NULL DEFAULT '0',
+  `AllocationPct3` smallint unsigned NOT NULL DEFAULT '0',
+  `AllocationPct4` smallint unsigned NOT NULL DEFAULT '0',
+  `AllocationPct5` smallint unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `item_random_suffix_locale`
+--
+
+DROP TABLE IF EXISTS `item_random_suffix_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `item_random_suffix_locale` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!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 `item_search_name`
 --
 
@@ -5150,11 +5254,11 @@ DROP TABLE IF EXISTS `item_search_name`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_search_name` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `AllowableRace` bigint NOT NULL DEFAULT '0',
   `Display` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `OverallQualityID` tinyint unsigned NOT NULL DEFAULT '0',
-  `ExpansionID` int NOT NULL DEFAULT '0',
+  `ExpansionID` tinyint NOT NULL DEFAULT '0',
   `MinFactionID` smallint unsigned NOT NULL DEFAULT '0',
   `MinReputation` int NOT NULL DEFAULT '0',
   `AllowableClass` int NOT NULL DEFAULT '0',
@@ -5294,14 +5398,11 @@ CREATE TABLE `item_sparse` (
   `Display2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Display1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Display` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `ExpansionID` int NOT NULL DEFAULT '0',
   `DmgVariance` float NOT NULL DEFAULT '0',
-  `LimitCategory` int NOT NULL DEFAULT '0',
   `DurationInInventory` int unsigned NOT NULL DEFAULT '0',
   `QualityModifier` float NOT NULL DEFAULT '0',
   `BagFamily` int unsigned NOT NULL DEFAULT '0',
   `StartQuestID` int NOT NULL DEFAULT '0',
-  `LanguageID` int NOT NULL DEFAULT '0',
   `ItemRange` float NOT NULL DEFAULT '0',
   `StatPercentageOfSocket1` float NOT NULL DEFAULT '0',
   `StatPercentageOfSocket2` float NOT NULL DEFAULT '0',
@@ -5340,9 +5441,11 @@ CREATE TABLE `item_sparse` (
   `ModifiedCraftingReagentItemID` int NOT NULL DEFAULT '0',
   `ContentTuningID` int NOT NULL DEFAULT '0',
   `PlayerLevelToItemLevelCurveID` int NOT NULL DEFAULT '0',
+  `MaxDurability` int unsigned NOT NULL DEFAULT '0',
   `ItemNameDescriptionID` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredTransmogHoliday` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredHoliday` smallint unsigned NOT NULL DEFAULT '0',
+  `LimitCategory` smallint unsigned NOT NULL DEFAULT '0',
   `GemProperties` smallint unsigned NOT NULL DEFAULT '0',
   `SocketMatchEnchantmentId` smallint unsigned NOT NULL DEFAULT '0',
   `TotemCategoryID` smallint unsigned NOT NULL DEFAULT '0',
@@ -5358,6 +5461,37 @@ CREATE TABLE `item_sparse` (
   `RequiredSkill` smallint unsigned NOT NULL DEFAULT '0',
   `ItemLevel` smallint unsigned NOT NULL DEFAULT '0',
   `AllowableClass` smallint NOT NULL DEFAULT '0',
+  `ItemRandomSuffixGroupID` smallint unsigned NOT NULL DEFAULT '0',
+  `RandomSelect` smallint unsigned NOT NULL DEFAULT '0',
+  `MinDamage1` smallint unsigned NOT NULL DEFAULT '0',
+  `MinDamage2` smallint unsigned NOT NULL DEFAULT '0',
+  `MinDamage3` smallint unsigned NOT NULL DEFAULT '0',
+  `MinDamage4` smallint unsigned NOT NULL DEFAULT '0',
+  `MinDamage5` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxDamage1` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxDamage2` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxDamage3` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxDamage4` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxDamage5` smallint unsigned NOT NULL DEFAULT '0',
+  `Resistances1` smallint NOT NULL DEFAULT '0',
+  `Resistances2` smallint NOT NULL DEFAULT '0',
+  `Resistances3` smallint NOT NULL DEFAULT '0',
+  `Resistances4` smallint NOT NULL DEFAULT '0',
+  `Resistances5` smallint NOT NULL DEFAULT '0',
+  `Resistances6` smallint NOT NULL DEFAULT '0',
+  `Resistances7` smallint NOT NULL DEFAULT '0',
+  `ScalingStatDistributionID` smallint unsigned NOT NULL DEFAULT '0',
+  `StatModifierBonusAmount1` smallint NOT NULL DEFAULT '0',
+  `StatModifierBonusAmount2` smallint NOT NULL DEFAULT '0',
+  `StatModifierBonusAmount3` smallint NOT NULL DEFAULT '0',
+  `StatModifierBonusAmount4` smallint NOT NULL DEFAULT '0',
+  `StatModifierBonusAmount5` smallint NOT NULL DEFAULT '0',
+  `StatModifierBonusAmount6` smallint NOT NULL DEFAULT '0',
+  `StatModifierBonusAmount7` smallint NOT NULL DEFAULT '0',
+  `StatModifierBonusAmount8` smallint NOT NULL DEFAULT '0',
+  `StatModifierBonusAmount9` smallint NOT NULL DEFAULT '0',
+  `StatModifierBonusAmount10` smallint NOT NULL DEFAULT '0',
+  `ExpansionID` tinyint unsigned NOT NULL DEFAULT '0',
   `ArtifactID` tinyint unsigned NOT NULL DEFAULT '0',
   `SpellWeight` tinyint unsigned NOT NULL DEFAULT '0',
   `SpellWeightCategory` tinyint unsigned NOT NULL DEFAULT '0',
@@ -5367,6 +5501,7 @@ CREATE TABLE `item_sparse` (
   `SheatheType` tinyint unsigned NOT NULL DEFAULT '0',
   `Material` tinyint unsigned NOT NULL DEFAULT '0',
   `PageMaterialID` tinyint unsigned NOT NULL DEFAULT '0',
+  `LanguageID` tinyint unsigned NOT NULL DEFAULT '0',
   `Bonding` tinyint unsigned NOT NULL DEFAULT '0',
   `DamageDamageType` tinyint unsigned NOT NULL DEFAULT '0',
   `StatModifierBonusStat1` tinyint NOT NULL DEFAULT '0',
@@ -5382,9 +5517,10 @@ CREATE TABLE `item_sparse` (
   `ContainerSlots` tinyint unsigned NOT NULL DEFAULT '0',
   `RequiredPVPMedal` tinyint unsigned NOT NULL DEFAULT '0',
   `RequiredPVPRank` tinyint unsigned NOT NULL DEFAULT '0',
-  `RequiredLevel` tinyint NOT NULL DEFAULT '0',
   `InventoryType` tinyint NOT NULL DEFAULT '0',
   `OverallQualityID` tinyint NOT NULL DEFAULT '0',
+  `AmmunitionType` tinyint unsigned NOT NULL DEFAULT '0',
+  `RequiredLevel` tinyint NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -5497,13 +5633,12 @@ DROP TABLE IF EXISTS `journal_encounter`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `journal_encounter` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `MapX` float NOT NULL DEFAULT '0',
   `MapY` float NOT NULL DEFAULT '0',
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `JournalInstanceID` smallint unsigned NOT NULL DEFAULT '0',
-  `DungeonEncounterID` smallint unsigned NOT NULL DEFAULT '0',
   `OrderIndex` int unsigned NOT NULL DEFAULT '0',
   `FirstSectionID` smallint unsigned NOT NULL DEFAULT '0',
   `UiMapID` smallint unsigned NOT NULL DEFAULT '0',
@@ -5608,9 +5743,9 @@ DROP TABLE IF EXISTS `journal_instance`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `journal_instance` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `MapID` smallint unsigned NOT NULL DEFAULT '0',
   `BackgroundFileDataID` int NOT NULL DEFAULT '0',
   `ButtonFileDataID` int NOT NULL DEFAULT '0',
@@ -5661,7 +5796,6 @@ DROP TABLE IF EXISTS `journal_tier`;
 CREATE TABLE `journal_tier` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `PlayerConditionID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -5795,7 +5929,7 @@ DROP TABLE IF EXISTS `language_words`;
 CREATE TABLE `language_words` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Word` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `LanguageID` int unsigned NOT NULL DEFAULT '0',
+  `LanguageID` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -5858,8 +5992,10 @@ CREATE TABLE `lfg_dungeons` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `MinLevel` tinyint unsigned NOT NULL DEFAULT '0',
+  `MaxLevel` smallint unsigned NOT NULL DEFAULT '0',
   `TypeID` tinyint unsigned NOT NULL DEFAULT '0',
-  `Subtype` tinyint NOT NULL DEFAULT '0',
+  `Subtype` tinyint unsigned NOT NULL DEFAULT '0',
   `Faction` tinyint NOT NULL DEFAULT '0',
   `IconTextureFileID` int NOT NULL DEFAULT '0',
   `RewardsBgTextureFileID` int NOT NULL DEFAULT '0',
@@ -5871,6 +6007,9 @@ CREATE TABLE `lfg_dungeons` (
   `GroupID` tinyint unsigned NOT NULL DEFAULT '0',
   `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0',
   `RequiredPlayerConditionId` int unsigned NOT NULL DEFAULT '0',
+  `TargetLevel` tinyint unsigned NOT NULL DEFAULT '0',
+  `TargetLevelMin` tinyint unsigned NOT NULL DEFAULT '0',
+  `TargetLevelMax` smallint unsigned NOT NULL DEFAULT '0',
   `RandomID` smallint unsigned NOT NULL DEFAULT '0',
   `ScenarioID` smallint unsigned NOT NULL DEFAULT '0',
   `FinalEncounterID` smallint unsigned NOT NULL DEFAULT '0',
@@ -5883,7 +6022,6 @@ CREATE TABLE `lfg_dungeons` (
   `BonusReputationAmount` smallint unsigned NOT NULL DEFAULT '0',
   `MentorItemLevel` smallint unsigned NOT NULL DEFAULT '0',
   `MentorCharLevel` tinyint unsigned NOT NULL DEFAULT '0',
-  `ContentTuningID` int NOT NULL DEFAULT '0',
   `Flags1` int NOT NULL DEFAULT '0',
   `Flags2` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -6025,7 +6163,6 @@ DROP TABLE IF EXISTS `lock`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `lock` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
   `Index1` int NOT NULL DEFAULT '0',
   `Index2` int NOT NULL DEFAULT '0',
   `Index3` int NOT NULL DEFAULT '0',
@@ -6120,8 +6257,6 @@ CREATE TABLE `map` (
   `MapDescription1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `PvpShortDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `PvpLongDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `CorpseX` float NOT NULL DEFAULT '0',
-  `CorpseY` float NOT NULL DEFAULT '0',
   `MapType` tinyint unsigned NOT NULL DEFAULT '0',
   `InstanceType` tinyint NOT NULL DEFAULT '0',
   `ExpansionID` tinyint unsigned NOT NULL DEFAULT '0',
@@ -6132,12 +6267,11 @@ CREATE TABLE `map` (
   `CosmeticParentMapID` smallint NOT NULL DEFAULT '0',
   `TimeOffset` tinyint unsigned NOT NULL DEFAULT '0',
   `MinimapIconScale` float NOT NULL DEFAULT '0',
+  `RaidOffset` int NOT NULL DEFAULT '0',
   `CorpseMapID` smallint NOT NULL DEFAULT '0',
   `MaxPlayers` tinyint unsigned NOT NULL DEFAULT '0',
   `WindSettingsID` smallint NOT NULL DEFAULT '0',
   `ZmpFileDataID` int NOT NULL DEFAULT '0',
-  `WdtFileDataID` int NOT NULL DEFAULT '0',
-  `NavigationMaxDistance` int NOT NULL DEFAULT '0',
   `Flags1` int NOT NULL DEFAULT '0',
   `Flags2` int NOT NULL DEFAULT '0',
   `Flags3` int NOT NULL DEFAULT '0',
@@ -6205,14 +6339,14 @@ DROP TABLE IF EXISTS `map_difficulty`;
 CREATE TABLE `map_difficulty` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `DifficultyID` int NOT NULL DEFAULT '0',
-  `LockID` int NOT NULL DEFAULT '0',
-  `ResetInterval` tinyint NOT NULL DEFAULT '0',
-  `MaxPlayers` int NOT NULL DEFAULT '0',
-  `ItemContext` int NOT NULL DEFAULT '0',
-  `ItemContextPickerID` int NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `ItemContextPickerID` int unsigned NOT NULL DEFAULT '0',
   `ContentTuningID` int NOT NULL DEFAULT '0',
+  `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
+  `LockID` tinyint unsigned NOT NULL DEFAULT '0',
+  `ResetInterval` tinyint unsigned NOT NULL DEFAULT '0',
+  `MaxPlayers` tinyint unsigned NOT NULL DEFAULT '0',
+  `ItemContext` tinyint unsigned NOT NULL DEFAULT '0',
+  `Flags` tinyint unsigned NOT NULL DEFAULT '0',
   `MapID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -6353,7 +6487,7 @@ CREATE TABLE `modifier_tree` (
   `Type` int NOT NULL DEFAULT '0',
   `Asset` int NOT NULL DEFAULT '0',
   `SecondaryAsset` int NOT NULL DEFAULT '0',
-  `TertiaryAsset` int NOT NULL DEFAULT '0',
+  `TertiaryAsset` tinyint NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6378,8 +6512,6 @@ CREATE TABLE `mount` (
   `PlayerConditionID` int unsigned NOT NULL DEFAULT '0',
   `MountFlyRideHeight` float NOT NULL DEFAULT '0',
   `UiModelSceneID` int NOT NULL DEFAULT '0',
-  `MountSpecialRiderAnimKitID` int NOT NULL DEFAULT '0',
-  `MountSpecialSpellVisualKitID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6401,8 +6533,6 @@ CREATE TABLE `mount_capability` (
   `ReqSpellKnownID` int NOT NULL DEFAULT '0',
   `ModSpellAuraID` int NOT NULL DEFAULT '0',
   `ReqMapID` smallint NOT NULL DEFAULT '0',
-  `PlayerConditionID` int NOT NULL DEFAULT '0',
-  `FlightCapabilityID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6484,7 +6614,6 @@ CREATE TABLE `movie` (
   `KeyID` tinyint unsigned NOT NULL DEFAULT '0',
   `AudioFileDataID` int unsigned NOT NULL DEFAULT '0',
   `SubtitleFileDataID` int unsigned NOT NULL DEFAULT '0',
-  `SubtitleFileFormat` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6670,12 +6799,14 @@ DROP TABLE IF EXISTS `player_condition`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `player_condition` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `RaceMask` bigint NOT NULL DEFAULT '0',
   `FailureDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `MinLevel` smallint unsigned NOT NULL DEFAULT '0',
+  `MaxLevel` smallint unsigned NOT NULL DEFAULT '0',
   `ClassMask` int NOT NULL DEFAULT '0',
   `SkillLogic` int unsigned NOT NULL DEFAULT '0',
-  `LanguageID` int NOT NULL DEFAULT '0',
+  `LanguageID` tinyint unsigned NOT NULL DEFAULT '0',
   `MinLanguage` tinyint unsigned NOT NULL DEFAULT '0',
   `MaxLanguage` int NOT NULL DEFAULT '0',
   `MaxFactionID` smallint unsigned NOT NULL DEFAULT '0',
@@ -6691,7 +6822,7 @@ CREATE TABLE `player_condition` (
   `ItemFlags` tinyint unsigned NOT NULL DEFAULT '0',
   `AuraSpellLogic` int unsigned NOT NULL DEFAULT '0',
   `WorldStateExpressionID` smallint unsigned NOT NULL DEFAULT '0',
-  `WeatherID` int NOT NULL DEFAULT '0',
+  `WeatherID` tinyint unsigned NOT NULL DEFAULT '0',
   `PartyStatus` tinyint unsigned NOT NULL DEFAULT '0',
   `LifetimeMaxPVPRank` tinyint unsigned NOT NULL DEFAULT '0',
   `AchievementLogic` int unsigned NOT NULL DEFAULT '0',
@@ -6700,7 +6831,7 @@ CREATE TABLE `player_condition` (
   `AreaLogic` int unsigned NOT NULL DEFAULT '0',
   `LfgLogic` int unsigned NOT NULL DEFAULT '0',
   `CurrencyLogic` int unsigned NOT NULL DEFAULT '0',
-  `QuestKillID` int NOT NULL DEFAULT '0',
+  `QuestKillID` int unsigned NOT NULL DEFAULT '0',
   `QuestKillLogic` int unsigned NOT NULL DEFAULT '0',
   `MinExpansionLevel` tinyint NOT NULL DEFAULT '0',
   `MaxExpansionLevel` tinyint NOT NULL DEFAULT '0',
@@ -6711,7 +6842,7 @@ CREATE TABLE `player_condition` (
   `PhaseUseFlags` tinyint unsigned NOT NULL DEFAULT '0',
   `PhaseID` smallint unsigned NOT NULL DEFAULT '0',
   `PhaseGroupID` int unsigned NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Flags` tinyint unsigned NOT NULL DEFAULT '0',
   `ChrSpecializationIndex` tinyint NOT NULL DEFAULT '0',
   `ChrSpecializationRole` tinyint NOT NULL DEFAULT '0',
   `ModifierTreeID` int unsigned NOT NULL DEFAULT '0',
@@ -6725,9 +6856,6 @@ CREATE TABLE `player_condition` (
   `MinExpansionTier` tinyint NOT NULL DEFAULT '0',
   `MinPVPRank` tinyint unsigned NOT NULL DEFAULT '0',
   `MaxPVPRank` tinyint unsigned NOT NULL DEFAULT '0',
-  `ContentTuningID` int NOT NULL DEFAULT '0',
-  `CovenantID` int NOT NULL DEFAULT '0',
-  `TraitNodeEntryLogic` int unsigned NOT NULL DEFAULT '0',
   `SkillID1` smallint unsigned NOT NULL DEFAULT '0',
   `SkillID2` smallint unsigned NOT NULL DEFAULT '0',
   `SkillID3` smallint unsigned NOT NULL DEFAULT '0',
@@ -6746,18 +6874,18 @@ CREATE TABLE `player_condition` (
   `MinReputation1` tinyint unsigned NOT NULL DEFAULT '0',
   `MinReputation2` tinyint unsigned NOT NULL DEFAULT '0',
   `MinReputation3` tinyint unsigned NOT NULL DEFAULT '0',
-  `PrevQuestID1` int NOT NULL DEFAULT '0',
-  `PrevQuestID2` int NOT NULL DEFAULT '0',
-  `PrevQuestID3` int NOT NULL DEFAULT '0',
-  `PrevQuestID4` int NOT NULL DEFAULT '0',
-  `CurrQuestID1` int NOT NULL DEFAULT '0',
-  `CurrQuestID2` int NOT NULL DEFAULT '0',
-  `CurrQuestID3` int NOT NULL DEFAULT '0',
-  `CurrQuestID4` int NOT NULL DEFAULT '0',
-  `CurrentCompletedQuestID1` int NOT NULL DEFAULT '0',
-  `CurrentCompletedQuestID2` int NOT NULL DEFAULT '0',
-  `CurrentCompletedQuestID3` int NOT NULL DEFAULT '0',
-  `CurrentCompletedQuestID4` int NOT NULL DEFAULT '0',
+  `PrevQuestID1` int unsigned NOT NULL DEFAULT '0',
+  `PrevQuestID2` int unsigned NOT NULL DEFAULT '0',
+  `PrevQuestID3` int unsigned NOT NULL DEFAULT '0',
+  `PrevQuestID4` int unsigned NOT NULL DEFAULT '0',
+  `CurrQuestID1` int unsigned NOT NULL DEFAULT '0',
+  `CurrQuestID2` int unsigned NOT NULL DEFAULT '0',
+  `CurrQuestID3` int unsigned NOT NULL DEFAULT '0',
+  `CurrQuestID4` int unsigned NOT NULL DEFAULT '0',
+  `CurrentCompletedQuestID1` int unsigned NOT NULL DEFAULT '0',
+  `CurrentCompletedQuestID2` int unsigned NOT NULL DEFAULT '0',
+  `CurrentCompletedQuestID3` int unsigned NOT NULL DEFAULT '0',
+  `CurrentCompletedQuestID4` int unsigned NOT NULL DEFAULT '0',
   `SpellID1` int NOT NULL DEFAULT '0',
   `SpellID2` int NOT NULL DEFAULT '0',
   `SpellID3` int NOT NULL DEFAULT '0',
@@ -6818,18 +6946,6 @@ CREATE TABLE `player_condition` (
   `QuestKillMonster6` int unsigned NOT NULL DEFAULT '0',
   `MovementFlags1` int NOT NULL DEFAULT '0',
   `MovementFlags2` int NOT NULL DEFAULT '0',
-  `TraitNodeEntryID1` int NOT NULL DEFAULT '0',
-  `TraitNodeEntryID2` int NOT NULL DEFAULT '0',
-  `TraitNodeEntryID3` int NOT NULL DEFAULT '0',
-  `TraitNodeEntryID4` int NOT NULL DEFAULT '0',
-  `TraitNodeEntryMinRank1` smallint unsigned NOT NULL DEFAULT '0',
-  `TraitNodeEntryMinRank2` smallint unsigned NOT NULL DEFAULT '0',
-  `TraitNodeEntryMinRank3` smallint unsigned NOT NULL DEFAULT '0',
-  `TraitNodeEntryMinRank4` smallint unsigned NOT NULL DEFAULT '0',
-  `TraitNodeEntryMaxRank1` smallint unsigned NOT NULL DEFAULT '0',
-  `TraitNodeEntryMaxRank2` smallint unsigned NOT NULL DEFAULT '0',
-  `TraitNodeEntryMaxRank3` smallint unsigned NOT NULL DEFAULT '0',
-  `TraitNodeEntryMaxRank4` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -6889,9 +7005,9 @@ DROP TABLE IF EXISTS `power_type`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `power_type` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `NameGlobalStringTag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `CostGlobalStringTag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `PowerTypeEnum` tinyint NOT NULL DEFAULT '0',
   `MinPower` int NOT NULL DEFAULT '0',
   `MaxBasePower` int NOT NULL DEFAULT '0',
@@ -7014,14 +7130,13 @@ DROP TABLE IF EXISTS `pvp_talent`;
 CREATE TABLE `pvp_talent` (
   `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `SpecID` int NOT NULL DEFAULT '0',
+  `SpecID` int unsigned NOT NULL DEFAULT '0',
   `SpellID` int NOT NULL DEFAULT '0',
   `OverridesSpellID` int NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `ActionBarSpellID` int NOT NULL DEFAULT '0',
   `PvpTalentCategoryID` int NOT NULL DEFAULT '0',
   `LevelRequired` int NOT NULL DEFAULT '0',
-  `PlayerConditionID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -7095,13 +7210,13 @@ DROP TABLE IF EXISTS `pvp_tier`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `pvp_tier` (
-  `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
+  `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `MinRating` smallint NOT NULL DEFAULT '0',
   `MaxRating` smallint NOT NULL DEFAULT '0',
   `PrevTier` int NOT NULL DEFAULT '0',
   `NextTier` int NOT NULL DEFAULT '0',
-  `BracketID` tinyint NOT NULL DEFAULT '0',
+  `BracketID` tinyint unsigned NOT NULL DEFAULT '0',
   `Rank` tinyint NOT NULL DEFAULT '0',
   `RankIconFileDataID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -7217,7 +7332,6 @@ CREATE TABLE `quest_line_x_quest` (
   `QuestLineID` int unsigned NOT NULL DEFAULT '0',
   `QuestID` int unsigned NOT NULL DEFAULT '0',
   `OrderIndex` int unsigned NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -7318,7 +7432,6 @@ DROP TABLE IF EXISTS `quest_v2`;
 CREATE TABLE `quest_v2` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `UniqueBitFlag` smallint unsigned NOT NULL DEFAULT '0',
-  `UiQuestDetailsTheme` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -7357,25 +7470,7 @@ DROP TABLE IF EXISTS `rand_prop_points`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `rand_prop_points` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `DamageReplaceStatF` float NOT NULL DEFAULT '0',
-  `DamageSecondaryF` float NOT NULL DEFAULT '0',
   `DamageReplaceStat` int NOT NULL DEFAULT '0',
-  `DamageSecondary` int NOT NULL DEFAULT '0',
-  `EpicF1` float NOT NULL DEFAULT '0',
-  `EpicF2` float NOT NULL DEFAULT '0',
-  `EpicF3` float NOT NULL DEFAULT '0',
-  `EpicF4` float NOT NULL DEFAULT '0',
-  `EpicF5` float NOT NULL DEFAULT '0',
-  `SuperiorF1` float NOT NULL DEFAULT '0',
-  `SuperiorF2` float NOT NULL DEFAULT '0',
-  `SuperiorF3` float NOT NULL DEFAULT '0',
-  `SuperiorF4` float NOT NULL DEFAULT '0',
-  `SuperiorF5` float NOT NULL DEFAULT '0',
-  `GoodF1` float NOT NULL DEFAULT '0',
-  `GoodF2` float NOT NULL DEFAULT '0',
-  `GoodF3` float NOT NULL DEFAULT '0',
-  `GoodF4` float NOT NULL DEFAULT '0',
-  `GoodF5` float NOT NULL DEFAULT '0',
   `Epic1` int unsigned NOT NULL DEFAULT '0',
   `Epic2` int unsigned NOT NULL DEFAULT '0',
   `Epic3` int unsigned NOT NULL DEFAULT '0',
@@ -7451,6 +7546,80 @@ CREATE TABLE `reward_pack_x_item` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `scaling_stat_distribution`
+--
+
+DROP TABLE IF EXISTS `scaling_stat_distribution`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `scaling_stat_distribution` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `PlayerLevelToItemLevelCurveID` smallint unsigned NOT NULL DEFAULT '0',
+  `MinLevel` int NOT NULL DEFAULT '0',
+  `MaxLevel` int NOT NULL DEFAULT '0',
+  `Bonus1` int NOT NULL DEFAULT '0',
+  `Bonus2` int NOT NULL DEFAULT '0',
+  `Bonus3` int NOT NULL DEFAULT '0',
+  `Bonus4` int NOT NULL DEFAULT '0',
+  `Bonus5` int NOT NULL DEFAULT '0',
+  `Bonus6` int NOT NULL DEFAULT '0',
+  `Bonus7` int NOT NULL DEFAULT '0',
+  `Bonus8` int NOT NULL DEFAULT '0',
+  `Bonus9` int NOT NULL DEFAULT '0',
+  `Bonus10` int NOT NULL DEFAULT '0',
+  `StatID1` int NOT NULL DEFAULT '0',
+  `StatID2` int NOT NULL DEFAULT '0',
+  `StatID3` int NOT NULL DEFAULT '0',
+  `StatID4` int NOT NULL DEFAULT '0',
+  `StatID5` int NOT NULL DEFAULT '0',
+  `StatID6` int NOT NULL DEFAULT '0',
+  `StatID7` int NOT NULL DEFAULT '0',
+  `StatID8` int NOT NULL DEFAULT '0',
+  `StatID9` int NOT NULL DEFAULT '0',
+  `StatID10` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `scaling_stat_values`
+--
+
+DROP TABLE IF EXISTS `scaling_stat_values`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `scaling_stat_values` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Charlevel` int NOT NULL DEFAULT '0',
+  `WeaponDPS1H` int NOT NULL DEFAULT '0',
+  `WeaponDPS2H` int NOT NULL DEFAULT '0',
+  `SpellcasterDPS1H` int NOT NULL DEFAULT '0',
+  `SpellcasterDPS2H` int NOT NULL DEFAULT '0',
+  `RangedDPS` int NOT NULL DEFAULT '0',
+  `WandDPS` int NOT NULL DEFAULT '0',
+  `SpellPower` int NOT NULL DEFAULT '0',
+  `ShoulderBudget` int NOT NULL DEFAULT '0',
+  `TrinketBudget` int NOT NULL DEFAULT '0',
+  `WeaponBudget1H` int NOT NULL DEFAULT '0',
+  `PrimaryBudget` int NOT NULL DEFAULT '0',
+  `RangedBudget` int NOT NULL DEFAULT '0',
+  `TertiaryBudget` int NOT NULL DEFAULT '0',
+  `ClothShoulderArmor` int NOT NULL DEFAULT '0',
+  `LeatherShoulderArmor` int NOT NULL DEFAULT '0',
+  `MailShoulderArmor` int NOT NULL DEFAULT '0',
+  `PlateShoulderArmor` int NOT NULL DEFAULT '0',
+  `ClothCloakArmor` int NOT NULL DEFAULT '0',
+  `ClothChestArmor` int NOT NULL DEFAULT '0',
+  `LeatherChestArmor` int NOT NULL DEFAULT '0',
+  `MailChestArmor` int NOT NULL DEFAULT '0',
+  `PlateChestArmor` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `scenario`
 --
 
@@ -7509,7 +7678,7 @@ CREATE TABLE `scenario_step` (
   `Title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ScenarioID` smallint unsigned NOT NULL DEFAULT '0',
   `Criteriatreeid` int unsigned NOT NULL DEFAULT '0',
-  `RewardQuestID` int NOT NULL DEFAULT '0',
+  `RewardQuestID` int unsigned NOT NULL DEFAULT '0',
   `RelatedStep` int NOT NULL DEFAULT '0',
   `Supersedes` smallint unsigned NOT NULL DEFAULT '0',
   `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0',
@@ -7592,7 +7761,6 @@ DROP TABLE IF EXISTS `scene_script_package`;
 CREATE TABLE `scene_script_package` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `Unknown915` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -7615,6 +7783,48 @@ CREATE TABLE `scene_script_text` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `server_messages`
+--
+
+DROP TABLE IF EXISTS `server_messages`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `server_messages` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `server_messages_locale`
+--
+
+DROP TABLE IF EXISTS `server_messages_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `server_messages_locale` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!50500 PARTITION BY LIST  COLUMNS(locale)
+(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB,
+ PARTITION esES VALUES IN ('esES') ENGINE = InnoDB,
+ PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB,
+ PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB,
+ PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB,
+ PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB,
+ PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB,
+ PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB,
+ PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB,
+ PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `skill_line`
 --
 
@@ -7635,8 +7845,6 @@ CREATE TABLE `skill_line` (
   `ParentTierIndex` int NOT NULL DEFAULT '0',
   `Flags` smallint unsigned NOT NULL DEFAULT '0',
   `SpellBookSpellID` int NOT NULL DEFAULT '0',
-  `ExpansionNameSharedStringID` int NOT NULL DEFAULT '0',
-  `HordeExpansionNameSharedStringID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -7651,8 +7859,6 @@ DROP TABLE IF EXISTS `skill_line_ability`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `skill_line_ability` (
   `RaceMask` bigint NOT NULL DEFAULT '0',
-  `AbilityVerb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `AbilityAllVerb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
   `SkillLine` smallint NOT NULL DEFAULT '0',
   `Spell` int NOT NULL DEFAULT '0',
@@ -7662,11 +7868,13 @@ CREATE TABLE `skill_line_ability` (
   `AcquireMethod` tinyint NOT NULL DEFAULT '0',
   `TrivialSkillLineRankHigh` smallint NOT NULL DEFAULT '0',
   `TrivialSkillLineRankLow` smallint NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Flags` tinyint NOT NULL DEFAULT '0',
   `NumSkillUps` tinyint NOT NULL DEFAULT '0',
   `UniqueBit` smallint NOT NULL DEFAULT '0',
   `TradeSkillCategoryID` smallint NOT NULL DEFAULT '0',
   `SkillupSkillLineID` smallint NOT NULL DEFAULT '0',
+  `CharacterPoints1` int NOT NULL DEFAULT '0',
+  `CharacterPoints2` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -7739,7 +7947,7 @@ DROP TABLE IF EXISTS `skill_line_x_trait_tree`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `skill_line_x_trait_tree` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `SkillLineID` int NOT NULL DEFAULT '0',
+  `SkillLineID` int unsigned NOT NULL DEFAULT '0',
   `TraitTreeID` int NOT NULL DEFAULT '0',
   `OrderIndex` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -7795,9 +8003,9 @@ DROP TABLE IF EXISTS `sound_kit`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `sound_kit` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `SoundType` int NOT NULL DEFAULT '0',
+  `SoundType` tinyint unsigned NOT NULL DEFAULT '0',
   `VolumeFloat` float NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Flags` smallint unsigned NOT NULL DEFAULT '0',
   `MinDistance` float NOT NULL DEFAULT '0',
   `DistanceCutoff` float NOT NULL DEFAULT '0',
   `EAXDef` tinyint unsigned NOT NULL DEFAULT '0',
@@ -7888,7 +8096,7 @@ DROP TABLE IF EXISTS `spell_aura_options`;
 CREATE TABLE `spell_aura_options` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
-  `CumulativeAura` smallint unsigned NOT NULL DEFAULT '0',
+  `CumulativeAura` int unsigned NOT NULL DEFAULT '0',
   `ProcCategoryRecovery` int NOT NULL DEFAULT '0',
   `ProcChance` tinyint unsigned NOT NULL DEFAULT '0',
   `ProcCharges` int NOT NULL DEFAULT '0',
@@ -7910,19 +8118,15 @@ DROP TABLE IF EXISTS `spell_aura_restrictions`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_aura_restrictions` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `DifficultyID` int NOT NULL DEFAULT '0',
-  `CasterAuraState` int NOT NULL DEFAULT '0',
-  `TargetAuraState` int NOT NULL DEFAULT '0',
-  `ExcludeCasterAuraState` int NOT NULL DEFAULT '0',
-  `ExcludeTargetAuraState` int NOT NULL DEFAULT '0',
+  `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
+  `CasterAuraState` tinyint unsigned NOT NULL DEFAULT '0',
+  `TargetAuraState` tinyint unsigned NOT NULL DEFAULT '0',
+  `ExcludeCasterAuraState` tinyint unsigned NOT NULL DEFAULT '0',
+  `ExcludeTargetAuraState` tinyint unsigned NOT NULL DEFAULT '0',
   `CasterAuraSpell` int NOT NULL DEFAULT '0',
   `TargetAuraSpell` int NOT NULL DEFAULT '0',
   `ExcludeCasterAuraSpell` int NOT NULL DEFAULT '0',
   `ExcludeTargetAuraSpell` int NOT NULL DEFAULT '0',
-  `CasterAuraType` int NOT NULL DEFAULT '0',
-  `TargetAuraType` int NOT NULL DEFAULT '0',
-  `ExcludeCasterAuraType` int NOT NULL DEFAULT '0',
-  `ExcludeTargetAuraType` int NOT NULL DEFAULT '0',
   `SpellID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -7939,6 +8143,7 @@ DROP TABLE IF EXISTS `spell_cast_times`;
 CREATE TABLE `spell_cast_times` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Base` int NOT NULL DEFAULT '0',
+  `PerLevel` smallint NOT NULL DEFAULT '0',
   `Minimum` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -8070,7 +8275,6 @@ CREATE TABLE `spell_cooldowns` (
   `CategoryRecoveryTime` int NOT NULL DEFAULT '0',
   `RecoveryTime` int NOT NULL DEFAULT '0',
   `StartRecoveryTime` int NOT NULL DEFAULT '0',
-  `AuraSpellID` int NOT NULL DEFAULT '0',
   `SpellID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -8087,6 +8291,7 @@ DROP TABLE IF EXISTS `spell_duration`;
 CREATE TABLE `spell_duration` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Duration` int NOT NULL DEFAULT '0',
+  `DurationPerLevel` int unsigned NOT NULL DEFAULT '0',
   `MaxDuration` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -8102,16 +8307,18 @@ DROP TABLE IF EXISTS `spell_effect`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_effect` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `EffectAura` smallint NOT NULL DEFAULT '0',
   `DifficultyID` int NOT NULL DEFAULT '0',
   `EffectIndex` int NOT NULL DEFAULT '0',
   `Effect` int unsigned NOT NULL DEFAULT '0',
   `EffectAmplitude` float NOT NULL DEFAULT '0',
   `EffectAttributes` int NOT NULL DEFAULT '0',
+  `EffectAura` smallint NOT NULL DEFAULT '0',
   `EffectAuraPeriod` int NOT NULL DEFAULT '0',
+  `EffectBasePoints` int NOT NULL DEFAULT '0',
   `EffectBonusCoefficient` float NOT NULL DEFAULT '0',
   `EffectChainAmplitude` float NOT NULL DEFAULT '0',
   `EffectChainTargets` int NOT NULL DEFAULT '0',
+  `EffectDieSides` int NOT NULL DEFAULT '0',
   `EffectItemType` int NOT NULL DEFAULT '0',
   `EffectMechanic` int NOT NULL DEFAULT '0',
   `EffectPointsPerResource` float NOT NULL DEFAULT '0',
@@ -8124,8 +8331,6 @@ CREATE TABLE `spell_effect` (
   `Variance` float NOT NULL DEFAULT '0',
   `ResourceCoefficient` float NOT NULL DEFAULT '0',
   `GroupSizeBasePointsCoefficient` float NOT NULL DEFAULT '0',
-  `EffectBasePoints` float NOT NULL DEFAULT '0',
-  `ScalingClass` int NOT NULL DEFAULT '0',
   `EffectMiscValue1` int NOT NULL DEFAULT '0',
   `EffectMiscValue2` int NOT NULL DEFAULT '0',
   `EffectRadiusIndex1` int unsigned NOT NULL DEFAULT '0',
@@ -8234,18 +8439,16 @@ CREATE TABLE `spell_item_enchantment` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `HordeName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  `Duration` int NOT NULL DEFAULT '0',
   `EffectArg1` int unsigned NOT NULL DEFAULT '0',
   `EffectArg2` int unsigned NOT NULL DEFAULT '0',
   `EffectArg3` int unsigned NOT NULL DEFAULT '0',
   `EffectScalingPoints1` float NOT NULL DEFAULT '0',
   `EffectScalingPoints2` float NOT NULL DEFAULT '0',
   `EffectScalingPoints3` float NOT NULL DEFAULT '0',
-  `IconFileDataID` int unsigned NOT NULL DEFAULT '0',
-  `MinItemLevel` int NOT NULL DEFAULT '0',
-  `MaxItemLevel` int NOT NULL DEFAULT '0',
-  `TransmogUseConditionID` int unsigned NOT NULL DEFAULT '0',
+  `GemItemID` int unsigned NOT NULL DEFAULT '0',
+  `TransmogUnlockConditionID` int unsigned NOT NULL DEFAULT '0',
   `TransmogCost` int unsigned NOT NULL DEFAULT '0',
+  `IconFileDataID` int unsigned NOT NULL DEFAULT '0',
   `EffectPointsMin1` smallint NOT NULL DEFAULT '0',
   `EffectPointsMin2` smallint NOT NULL DEFAULT '0',
   `EffectPointsMin3` smallint NOT NULL DEFAULT '0',
@@ -8401,10 +8604,10 @@ DROP TABLE IF EXISTS `spell_levels`;
 CREATE TABLE `spell_levels` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
+  `BaseLevel` smallint NOT NULL DEFAULT '0',
   `MaxLevel` smallint NOT NULL DEFAULT '0',
+  `SpellLevel` smallint NOT NULL DEFAULT '0',
   `MaxPassiveAuraLevel` tinyint unsigned NOT NULL DEFAULT '0',
-  `BaseLevel` int NOT NULL DEFAULT '0',
-  `SpellLevel` int NOT NULL DEFAULT '0',
   `SpellID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -8447,8 +8650,6 @@ CREATE TABLE `spell_misc` (
   `ActiveIconFileDataID` int NOT NULL DEFAULT '0',
   `ContentTuningID` int NOT NULL DEFAULT '0',
   `ShowFutureSpellPlayerConditionID` int NOT NULL DEFAULT '0',
-  `SpellVisualScript` int NOT NULL DEFAULT '0',
-  `ActiveSpellVisualScript` int NOT NULL DEFAULT '0',
   `SpellID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -8514,7 +8715,6 @@ CREATE TABLE `spell_power` (
   `AltPowerBarID` int NOT NULL DEFAULT '0',
   `PowerCostPct` float NOT NULL DEFAULT '0',
   `PowerCostMaxPct` float NOT NULL DEFAULT '0',
-  `OptionalCostPct` float NOT NULL DEFAULT '0',
   `PowerPctPerSecond` float NOT NULL DEFAULT '0',
   `PowerType` tinyint NOT NULL DEFAULT '0',
   `RequiredAuraSpellID` int NOT NULL DEFAULT '0',
@@ -8567,7 +8767,7 @@ DROP TABLE IF EXISTS `spell_procs_per_minute_mod`;
 CREATE TABLE `spell_procs_per_minute_mod` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Type` tinyint unsigned NOT NULL DEFAULT '0',
-  `Param` int NOT NULL DEFAULT '0',
+  `Param` smallint NOT NULL DEFAULT '0',
   `Coeff` float NOT NULL DEFAULT '0',
   `SpellProcsPerMinuteID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -8668,22 +8868,6 @@ CREATE TABLE `spell_reagents` (
   `ReagentCount6` smallint NOT NULL DEFAULT '0',
   `ReagentCount7` smallint NOT NULL DEFAULT '0',
   `ReagentCount8` smallint NOT NULL DEFAULT '0',
-  `ReagentRecraftCount1` smallint NOT NULL DEFAULT '0',
-  `ReagentRecraftCount2` smallint NOT NULL DEFAULT '0',
-  `ReagentRecraftCount3` smallint NOT NULL DEFAULT '0',
-  `ReagentRecraftCount4` smallint NOT NULL DEFAULT '0',
-  `ReagentRecraftCount5` smallint NOT NULL DEFAULT '0',
-  `ReagentRecraftCount6` smallint NOT NULL DEFAULT '0',
-  `ReagentRecraftCount7` smallint NOT NULL DEFAULT '0',
-  `ReagentRecraftCount8` smallint NOT NULL DEFAULT '0',
-  `ReagentSource1` tinyint unsigned NOT NULL DEFAULT '0',
-  `ReagentSource2` tinyint unsigned NOT NULL DEFAULT '0',
-  `ReagentSource3` tinyint unsigned NOT NULL DEFAULT '0',
-  `ReagentSource4` tinyint unsigned NOT NULL DEFAULT '0',
-  `ReagentSource5` tinyint unsigned NOT NULL DEFAULT '0',
-  `ReagentSource6` tinyint unsigned NOT NULL DEFAULT '0',
-  `ReagentSource7` tinyint unsigned NOT NULL DEFAULT '0',
-  `ReagentSource8` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -8698,7 +8882,7 @@ DROP TABLE IF EXISTS `spell_reagents_currency`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_reagents_currency` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `SpellID` int NOT NULL DEFAULT '0',
+  `SpellID` int unsigned NOT NULL DEFAULT '0',
   `CurrencyTypesID` smallint unsigned NOT NULL DEFAULT '0',
   `CurrencyCount` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -8716,6 +8900,7 @@ DROP TABLE IF EXISTS `spell_scaling`;
 CREATE TABLE `spell_scaling` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `SpellID` int NOT NULL DEFAULT '0',
+  `Class` int NOT NULL DEFAULT '0',
   `MinScalingLevel` int unsigned NOT NULL DEFAULT '0',
   `MaxScalingLevel` int unsigned NOT NULL DEFAULT '0',
   `ScalesFromItemLevel` smallint NOT NULL DEFAULT '0',
@@ -8875,6 +9060,8 @@ CREATE TABLE `spell_visual` (
   `LowViolenceSpellVisualID` int unsigned NOT NULL DEFAULT '0',
   `RaidSpellVisualMissileSetID` int unsigned NOT NULL DEFAULT '0',
   `ReducedUnexpectedCameraMovementSpellVisualID` int NOT NULL DEFAULT '0',
+  `AreaModel` smallint unsigned NOT NULL DEFAULT '0',
+  `HasMissile` tinyint NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -8903,7 +9090,6 @@ CREATE TABLE `spell_visual_effect_name` (
   `RibbonQualityID` int unsigned NOT NULL DEFAULT '0',
   `DissolveEffectID` int NOT NULL DEFAULT '0',
   `ModelPosition` int NOT NULL DEFAULT '0',
-  `Unknown901` tinyint NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -8918,10 +9104,10 @@ DROP TABLE IF EXISTS `spell_visual_kit`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_visual_kit` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `FallbackPriority` tinyint NOT NULL DEFAULT '0',
-  `FallbackSpellVisualKitId` int NOT NULL DEFAULT '0',
+  `FallbackSpellVisualKitId` int unsigned NOT NULL DEFAULT '0',
   `DelayMin` smallint unsigned NOT NULL DEFAULT '0',
   `DelayMax` smallint unsigned NOT NULL DEFAULT '0',
+  `FallbackPriority` float NOT NULL DEFAULT '0',
   `Flags1` int NOT NULL DEFAULT '0',
   `Flags2` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -8956,8 +9142,6 @@ CREATE TABLE `spell_visual_missile` (
   `Flags` int unsigned NOT NULL DEFAULT '0',
   `SpellMissileMotionID` smallint unsigned NOT NULL DEFAULT '0',
   `AnimKitID` int unsigned NOT NULL DEFAULT '0',
-  `ClutterLevel` tinyint NOT NULL DEFAULT '0',
-  `DecayTimeAfterImpact` int NOT NULL DEFAULT '0',
   `SpellVisualMissileSetID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -8976,7 +9160,7 @@ CREATE TABLE `spell_x_spell_visual` (
   `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
   `SpellVisualID` int unsigned NOT NULL DEFAULT '0',
   `Probability` float NOT NULL DEFAULT '0',
-  `Flags` int NOT NULL DEFAULT '0',
+  `Flags` tinyint unsigned NOT NULL DEFAULT '0',
   `Priority` int NOT NULL DEFAULT '0',
   `SpellIconFileID` int NOT NULL DEFAULT '0',
   `ActiveIconFileID` int NOT NULL DEFAULT '0',
@@ -9053,12 +9237,29 @@ CREATE TABLE `talent` (
   `TierID` tinyint unsigned NOT NULL DEFAULT '0',
   `Flags` tinyint unsigned NOT NULL DEFAULT '0',
   `ColumnIndex` tinyint unsigned NOT NULL DEFAULT '0',
+  `TabID` smallint unsigned NOT NULL DEFAULT '0',
   `ClassID` tinyint unsigned NOT NULL DEFAULT '0',
   `SpecID` smallint unsigned NOT NULL DEFAULT '0',
-  `SpellID` int unsigned NOT NULL DEFAULT '0',
-  `OverridesSpellID` int unsigned NOT NULL DEFAULT '0',
-  `CategoryMask1` tinyint unsigned NOT NULL DEFAULT '0',
-  `CategoryMask2` tinyint unsigned NOT NULL DEFAULT '0',
+  `SpellID` int NOT NULL DEFAULT '0',
+  `OverridesSpellID` int NOT NULL DEFAULT '0',
+  `RequiredSpellID` int NOT NULL DEFAULT '0',
+  `CategoryMask1` int NOT NULL DEFAULT '0',
+  `CategoryMask2` int NOT NULL DEFAULT '0',
+  `SpellRank1` int NOT NULL DEFAULT '0',
+  `SpellRank2` int NOT NULL DEFAULT '0',
+  `SpellRank3` int NOT NULL DEFAULT '0',
+  `SpellRank4` int NOT NULL DEFAULT '0',
+  `SpellRank5` int NOT NULL DEFAULT '0',
+  `SpellRank6` int NOT NULL DEFAULT '0',
+  `SpellRank7` int NOT NULL DEFAULT '0',
+  `SpellRank8` int NOT NULL DEFAULT '0',
+  `SpellRank9` int NOT NULL DEFAULT '0',
+  `PrereqTalent1` int NOT NULL DEFAULT '0',
+  `PrereqTalent2` int NOT NULL DEFAULT '0',
+  `PrereqTalent3` int NOT NULL DEFAULT '0',
+  `PrereqRank1` int NOT NULL DEFAULT '0',
+  `PrereqRank2` int NOT NULL DEFAULT '0',
+  `PrereqRank3` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -9092,6 +9293,54 @@ CREATE TABLE `talent_locale` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `talent_tab`
+--
+
+DROP TABLE IF EXISTS `talent_tab`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `talent_tab` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `BackgroundFile` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `OrderIndex` int NOT NULL DEFAULT '0',
+  `RaceMask` int NOT NULL DEFAULT '0',
+  `ClassMask` int NOT NULL DEFAULT '0',
+  `PetTalentMask` int NOT NULL DEFAULT '0',
+  `SpellIconID` int NOT NULL DEFAULT '0',
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `talent_tab_locale`
+--
+
+DROP TABLE IF EXISTS `talent_tab_locale`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `talent_tab_locale` (
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
+/*!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 `taxi_nodes`
 --
 
@@ -9108,12 +9357,11 @@ CREATE TABLE `taxi_nodes` (
   `FlightMapOffsetX` float NOT NULL DEFAULT '0',
   `FlightMapOffsetY` float NOT NULL DEFAULT '0',
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `ContinentID` smallint unsigned NOT NULL DEFAULT '0',
-  `ConditionID` int NOT NULL DEFAULT '0',
+  `ContinentID` int unsigned NOT NULL DEFAULT '0',
+  `ConditionID` int unsigned NOT NULL DEFAULT '0',
   `CharacterBitNumber` smallint unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `UiTextureKitID` int NOT NULL DEFAULT '0',
-  `MinimapAtlasMemberID` int NOT NULL DEFAULT '0',
   `Facing` float NOT NULL DEFAULT '0',
   `SpecialIconConditionID` int unsigned NOT NULL DEFAULT '0',
   `VisibilityConditionID` int unsigned NOT NULL DEFAULT '0',
@@ -9185,8 +9433,8 @@ CREATE TABLE `taxi_path_node` (
   `ContinentID` smallint unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `Delay` int unsigned NOT NULL DEFAULT '0',
-  `ArrivalEventID` int NOT NULL DEFAULT '0',
-  `DepartureEventID` int NOT NULL DEFAULT '0',
+  `ArrivalEventID` int unsigned NOT NULL DEFAULT '0',
+  `DepartureEventID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -9291,7 +9539,7 @@ DROP TABLE IF EXISTS `trait_cond`;
 CREATE TABLE `trait_cond` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `CondType` int NOT NULL DEFAULT '0',
-  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
   `GrantedRanks` int NOT NULL DEFAULT '0',
   `QuestID` int NOT NULL DEFAULT '0',
   `AchievementID` int NOT NULL DEFAULT '0',
@@ -9354,7 +9602,7 @@ DROP TABLE IF EXISTS `trait_currency_source`;
 CREATE TABLE `trait_currency_source` (
   `Requirement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitCurrencyID` int NOT NULL DEFAULT '0',
+  `TraitCurrencyID` int unsigned NOT NULL DEFAULT '0',
   `Amount` int NOT NULL DEFAULT '0',
   `QuestID` int NOT NULL DEFAULT '0',
   `AchievementID` int NOT NULL DEFAULT '0',
@@ -9423,7 +9671,7 @@ DROP TABLE IF EXISTS `trait_definition_effect_points`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_definition_effect_points` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitDefinitionID` int NOT NULL DEFAULT '0',
+  `TraitDefinitionID` int unsigned NOT NULL DEFAULT '0',
   `EffectIndex` int NOT NULL DEFAULT '0',
   `OperationType` int NOT NULL DEFAULT '0',
   `CurveID` int NOT NULL DEFAULT '0',
@@ -9471,7 +9719,7 @@ DROP TABLE IF EXISTS `trait_edge`;
 CREATE TABLE `trait_edge` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `VisualStyle` int NOT NULL DEFAULT '0',
-  `LeftTraitNodeID` int NOT NULL DEFAULT '0',
+  `LeftTraitNodeID` int unsigned NOT NULL DEFAULT '0',
   `RightTraitNodeID` int NOT NULL DEFAULT '0',
   `Type` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -9488,10 +9736,10 @@ DROP TABLE IF EXISTS `trait_node`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_node` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
   `PosX` int NOT NULL DEFAULT '0',
   `PosY` int NOT NULL DEFAULT '0',
-  `Type` tinyint NOT NULL DEFAULT '0',
+  `Type` tinyint unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9540,7 +9788,7 @@ DROP TABLE IF EXISTS `trait_node_entry_x_trait_cost`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_node_entry_x_trait_cost` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitNodeEntryID` int NOT NULL DEFAULT '0',
+  `TraitNodeEntryID` int unsigned NOT NULL DEFAULT '0',
   `TraitCostID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9556,7 +9804,7 @@ DROP TABLE IF EXISTS `trait_node_group`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_node_group` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9573,7 +9821,7 @@ DROP TABLE IF EXISTS `trait_node_group_x_trait_cond`;
 CREATE TABLE `trait_node_group_x_trait_cond` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `TraitCondID` int NOT NULL DEFAULT '0',
-  `TraitNodeGroupID` int NOT NULL DEFAULT '0',
+  `TraitNodeGroupID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -9588,7 +9836,7 @@ DROP TABLE IF EXISTS `trait_node_group_x_trait_cost`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_node_group_x_trait_cost` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitNodeGroupID` int NOT NULL DEFAULT '0',
+  `TraitNodeGroupID` int unsigned NOT NULL DEFAULT '0',
   `TraitCostID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9604,7 +9852,7 @@ DROP TABLE IF EXISTS `trait_node_group_x_trait_node`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_node_group_x_trait_node` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitNodeGroupID` int NOT NULL DEFAULT '0',
+  `TraitNodeGroupID` int unsigned NOT NULL DEFAULT '0',
   `TraitNodeID` int NOT NULL DEFAULT '0',
   `Index` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -9622,7 +9870,7 @@ DROP TABLE IF EXISTS `trait_node_x_trait_cond`;
 CREATE TABLE `trait_node_x_trait_cond` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `TraitCondID` int NOT NULL DEFAULT '0',
-  `TraitNodeID` int NOT NULL DEFAULT '0',
+  `TraitNodeID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -9637,7 +9885,7 @@ DROP TABLE IF EXISTS `trait_node_x_trait_cost`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_node_x_trait_cost` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitNodeID` int NOT NULL DEFAULT '0',
+  `TraitNodeID` int unsigned NOT NULL DEFAULT '0',
   `TraitCostID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9653,7 +9901,7 @@ DROP TABLE IF EXISTS `trait_node_x_trait_node_entry`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_node_x_trait_node_entry` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitNodeID` int NOT NULL DEFAULT '0',
+  `TraitNodeID` int unsigned NOT NULL DEFAULT '0',
   `TraitNodeEntryID` int NOT NULL DEFAULT '0',
   `Index` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
@@ -9670,7 +9918,7 @@ DROP TABLE IF EXISTS `trait_tree`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_tree` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitSystemID` int NOT NULL DEFAULT '0',
+  `TraitSystemID` int unsigned NOT NULL DEFAULT '0',
   `Unused1000_1` int NOT NULL DEFAULT '0',
   `FirstTraitNodeID` int NOT NULL DEFAULT '0',
   `PlayerConditionID` int NOT NULL DEFAULT '0',
@@ -9691,7 +9939,7 @@ DROP TABLE IF EXISTS `trait_tree_loadout`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_tree_loadout` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
   `ChrSpecializationID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9707,7 +9955,7 @@ DROP TABLE IF EXISTS `trait_tree_loadout_entry`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trait_tree_loadout_entry` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `TraitTreeLoadoutID` int NOT NULL DEFAULT '0',
+  `TraitTreeLoadoutID` int unsigned NOT NULL DEFAULT '0',
   `SelectedTraitNodeID` int NOT NULL DEFAULT '0',
   `SelectedTraitNodeEntryID` int NOT NULL DEFAULT '0',
   `NumPoints` int NOT NULL DEFAULT '0',
@@ -9743,7 +9991,7 @@ DROP TABLE IF EXISTS `trait_tree_x_trait_currency`;
 CREATE TABLE `trait_tree_x_trait_currency` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Index` int NOT NULL DEFAULT '0',
-  `TraitTreeID` int NOT NULL DEFAULT '0',
+  `TraitTreeID` int unsigned NOT NULL DEFAULT '0',
   `TraitCurrencyID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -9799,11 +10047,8 @@ CREATE TABLE `transmog_set` (
   `TransmogSetGroupID` int unsigned NOT NULL DEFAULT '0',
   `ItemNameDescriptionID` int NOT NULL DEFAULT '0',
   `ParentTransmogSetID` smallint unsigned NOT NULL DEFAULT '0',
-  `Unknown810` tinyint unsigned NOT NULL DEFAULT '0',
   `ExpansionID` tinyint unsigned NOT NULL DEFAULT '0',
-  `PatchID` int NOT NULL DEFAULT '0',
   `UiOrder` smallint NOT NULL DEFAULT '0',
-  `PlayerConditionID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -9817,8 +10062,8 @@ DROP TABLE IF EXISTS `transmog_set_group`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `transmog_set_group` (
-  `ID` int unsigned NOT NULL DEFAULT '0',
   `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -9947,7 +10192,7 @@ CREATE TABLE `ui_map` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `ParentUiMapID` int NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
-  `System` tinyint unsigned NOT NULL DEFAULT '0',
+  `System` tinyint NOT NULL DEFAULT '0',
   `Type` tinyint unsigned NOT NULL DEFAULT '0',
   `BountySetID` int NOT NULL DEFAULT '0',
   `BountyDisplayLocation` int unsigned NOT NULL DEFAULT '0',
@@ -9955,8 +10200,8 @@ CREATE TABLE `ui_map` (
   `VisibilityPlayerConditionID` int NOT NULL DEFAULT '0',
   `HelpTextPosition` tinyint NOT NULL DEFAULT '0',
   `BkgAtlasID` int NOT NULL DEFAULT '0',
-  `AlternateUiMapGroup` int NOT NULL DEFAULT '0',
-  `ContentTuningID` int NOT NULL DEFAULT '0',
+  `AlternateUiMapGroup` int unsigned NOT NULL DEFAULT '0',
+  `ContentTuningID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`VerifiedBuild`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -10008,7 +10253,6 @@ CREATE TABLE `ui_map_link` (
   `ParentUiMapID` int NOT NULL DEFAULT '0',
   `OrderIndex` int NOT NULL DEFAULT '0',
   `ChildUiMapID` int NOT NULL DEFAULT '0',
-  `PlayerConditionID` int NOT NULL DEFAULT '0',
   `OverrideHighlightFileDataID` int NOT NULL DEFAULT '0',
   `OverrideHighlightAtlasID` int NOT NULL DEFAULT '0',
   `Flags` int NOT NULL DEFAULT '0',
@@ -10177,7 +10421,7 @@ CREATE TABLE `unit_power_bar` (
   `ToolTip` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `MinPower` int unsigned NOT NULL DEFAULT '0',
   `MaxPower` int unsigned NOT NULL DEFAULT '0',
-  `StartPower` int unsigned NOT NULL DEFAULT '0',
+  `StartPower` smallint unsigned NOT NULL DEFAULT '0',
   `CenterPower` tinyint unsigned NOT NULL DEFAULT '0',
   `RegenerationPeace` float NOT NULL DEFAULT '0',
   `RegenerationCombat` float NOT NULL DEFAULT '0',
@@ -10288,6 +10532,7 @@ CREATE TABLE `vehicle` (
   `VehicleUIIndicatorID` smallint unsigned NOT NULL DEFAULT '0',
   `MissileTargetingID` int NOT NULL DEFAULT '0',
   `VehiclePOITypeID` smallint unsigned NOT NULL DEFAULT '0',
+  `UiLocomotionType` int NOT NULL DEFAULT '0',
   `SeatID1` smallint unsigned NOT NULL DEFAULT '0',
   `SeatID2` smallint unsigned NOT NULL DEFAULT '0',
   `SeatID3` smallint unsigned NOT NULL DEFAULT '0',
@@ -10362,6 +10607,7 @@ CREATE TABLE `vehicle_seat` (
   `EnterUISoundID` int unsigned NOT NULL DEFAULT '0',
   `ExitUISoundID` int unsigned NOT NULL DEFAULT '0',
   `UiSkinFileDataID` int NOT NULL DEFAULT '0',
+  `UiSkin` int NOT NULL DEFAULT '0',
   `CameraEnteringDelay` float NOT NULL DEFAULT '0',
   `CameraEnteringDuration` float NOT NULL DEFAULT '0',
   `CameraExitingDelay` float NOT NULL DEFAULT '0',
@@ -10515,4 +10761,4 @@ CREATE TABLE `world_state_expression` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2023-10-06  0:40:56
+-- Dump completed on 2023-12-20 23:19:40
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 42eb0f2d5b0..f63f9d391ee 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.34, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.35, for Win64 (x86_64)
 --
 -- Host: localhost    Database: world
 -- ------------------------------------------------------
--- Server version	8.0.34-0ubuntu0.20.04.1
+-- Server version	8.0.35
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -654,11 +654,18 @@ DROP TABLE IF EXISTS `creature_classlevelstats`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_classlevelstats` (
-  `level` tinyint NOT NULL,
-  `class` tinyint NOT NULL,
-  `basemana` int unsigned NOT NULL DEFAULT '1',
-  `attackpower` smallint NOT NULL DEFAULT '0',
-  `rangedattackpower` smallint NOT NULL DEFAULT '0',
+  `level` tinyint unsigned NOT NULL,
+  `class` tinyint unsigned NOT NULL,
+  `basehp0` smallint unsigned NOT NULL DEFAULT '1',
+  `basehp1` smallint unsigned NOT NULL DEFAULT '1',
+  `basehp2` smallint unsigned NOT NULL DEFAULT '1',
+  `basemana` smallint unsigned NOT NULL DEFAULT '0',
+  `basearmor` smallint unsigned NOT NULL DEFAULT '1',
+  `attackpower` smallint unsigned NOT NULL DEFAULT '0',
+  `rangedattackpower` smallint unsigned NOT NULL DEFAULT '0',
+  `damage_base` float NOT NULL DEFAULT '0',
+  `damage_exp1` float NOT NULL DEFAULT '0',
+  `damage_exp2` float NOT NULL DEFAULT '0',
   `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`level`,`class`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -924,10 +931,12 @@ CREATE TABLE `creature_template` (
   `family` int NOT NULL DEFAULT '0',
   `trainer_class` tinyint unsigned NOT NULL DEFAULT '0',
   `type` tinyint unsigned NOT NULL DEFAULT '0',
+  `PetSpellDataId` int unsigned NOT NULL DEFAULT '0',
   `VehicleId` int unsigned NOT NULL DEFAULT '0',
   `AIName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `MovementType` tinyint unsigned NOT NULL DEFAULT '0',
   `ExperienceModifier` float NOT NULL DEFAULT '1',
+  `Civilian` tinyint unsigned NOT NULL DEFAULT '0',
   `RacialLeader` tinyint unsigned NOT NULL DEFAULT '0',
   `movementId` int unsigned NOT NULL DEFAULT '0',
   `WidgetSetID` int NOT NULL DEFAULT '0',
@@ -980,9 +989,8 @@ DROP TABLE IF EXISTS `creature_template_difficulty`;
 CREATE TABLE `creature_template_difficulty` (
   `Entry` int unsigned NOT NULL,
   `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
-  `LevelScalingDeltaMin` smallint NOT NULL DEFAULT '0',
-  `LevelScalingDeltaMax` smallint NOT NULL DEFAULT '0',
-  `ContentTuningID` int NOT NULL DEFAULT '0',
+  `MinLevel` tinyint NOT NULL DEFAULT '1',
+  `MaxLevel` tinyint NOT NULL DEFAULT '1',
   `HealthScalingExpansion` int NOT NULL DEFAULT '0',
   `HealthModifier` float NOT NULL DEFAULT '1',
   `ManaModifier` float NOT NULL DEFAULT '1',
@@ -2060,6 +2068,21 @@ CREATE TABLE `item_random_bonus_list_template` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `item_random_enchantment_template`
+--
+
+DROP TABLE IF EXISTS `item_random_enchantment_template`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `item_random_enchantment_template` (
+  `Id` int unsigned NOT NULL DEFAULT '0',
+  `EnchantmentId` int unsigned NOT NULL DEFAULT '0',
+  `Chance` float unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`Id`,`EnchantmentId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Random Enchantment System';
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `item_script_names`
 --
 
@@ -2087,7 +2110,6 @@ CREATE TABLE `item_template_addon` (
   `MinMoneyLoot` int unsigned NOT NULL DEFAULT '0',
   `MaxMoneyLoot` int unsigned NOT NULL DEFAULT '0',
   `SpellPPMChance` float NOT NULL DEFAULT '0',
-  `RandomBonusListTemplateId` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`Id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2201,6 +2223,21 @@ CREATE TABLE `mail_loot_template` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `map_corpse_position`
+--
+
+DROP TABLE IF EXISTS `map_corpse_position`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `map_corpse_position` (
+  `MapId` int unsigned NOT NULL DEFAULT '0',
+  `CorpseX` float NOT NULL DEFAULT '0',
+  `CorpseY` float NOT NULL DEFAULT '0',
+  PRIMARY KEY (`MapId`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `milling_loot_template`
 --
 
@@ -2458,6 +2495,7 @@ CREATE TABLE `player_classlevelstats` (
   `agi` smallint unsigned NOT NULL COMMENT 'agility',
   `sta` smallint unsigned NOT NULL COMMENT 'stamina',
   `inte` smallint unsigned NOT NULL COMMENT 'intellect',
+  `spi` smallint NOT NULL COMMENT 'spirit',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`class`,`level`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Stores levels stats.';
@@ -2548,6 +2586,8 @@ CREATE TABLE `player_racestats` (
   `agi` smallint NOT NULL COMMENT 'agility',
   `sta` smallint NOT NULL COMMENT 'stamina',
   `inte` smallint NOT NULL COMMENT 'intellect',
+  `spi` smallint NOT NULL COMMENT 'spirit',
+  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`race`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Stores race stats.';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3371,8 +3411,11 @@ DROP TABLE IF EXISTS `quest_template`;
 CREATE TABLE `quest_template` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `QuestType` tinyint unsigned NOT NULL DEFAULT '2',
+  `QuestLevel` int NOT NULL DEFAULT '0',
+  `QuestScalingFactionGroup` int NOT NULL DEFAULT '0',
+  `QuestMaxScalingLevel` int NOT NULL DEFAULT '0',
   `QuestPackageID` int unsigned NOT NULL DEFAULT '0',
-  `ContentTuningID` int unsigned NOT NULL DEFAULT '0',
+  `QuestMinLevel` int unsigned NOT NULL DEFAULT '0',
   `QuestSortID` smallint NOT NULL DEFAULT '0',
   `QuestInfoID` smallint unsigned NOT NULL DEFAULT '0',
   `SuggestedGroupNum` tinyint unsigned NOT NULL DEFAULT '0',
@@ -4027,6 +4070,7 @@ CREATE TABLE `smart_scripts` (
   `source_type` tinyint unsigned NOT NULL DEFAULT '0',
   `id` smallint unsigned NOT NULL DEFAULT '0',
   `link` smallint unsigned NOT NULL DEFAULT '0',
+  `Difficulties` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `event_type` tinyint unsigned NOT NULL DEFAULT '0',
   `event_phase_mask` smallint unsigned NOT NULL DEFAULT '0',
   `event_chance` tinyint unsigned NOT NULL DEFAULT '100',
@@ -4734,38 +4778,12 @@ CREATE TABLE `waypoint_data` (
   `orientation` float DEFAULT NULL,
   `delay` int unsigned NOT NULL DEFAULT '0',
   `move_type` int NOT NULL DEFAULT '0',
-  `action` int NOT NULL DEFAULT '0',
-  `action_chance` smallint NOT NULL DEFAULT '100',
   `wpguid` bigint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`point`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
--- Table structure for table `waypoint_scripts`
---
-
-DROP TABLE IF EXISTS `waypoint_scripts`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `waypoint_scripts` (
-  `id` int unsigned NOT NULL DEFAULT '0',
-  `delay` int unsigned NOT NULL DEFAULT '0',
-  `command` int unsigned NOT NULL DEFAULT '0',
-  `datalong` int unsigned NOT NULL DEFAULT '0',
-  `datalong2` int unsigned NOT NULL DEFAULT '0',
-  `dataint` int unsigned NOT NULL DEFAULT '0',
-  `x` float NOT NULL DEFAULT '0',
-  `y` float NOT NULL DEFAULT '0',
-  `z` float NOT NULL DEFAULT '0',
-  `o` float NOT NULL DEFAULT '0',
-  `guid` int NOT NULL DEFAULT '0',
-  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
-  PRIMARY KEY (`guid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
 -- Table structure for table `world_safe_locs`
 --
 
@@ -4869,4 +4887,4 @@ CREATE TABLE `world_state` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2023-10-06  0:40:52
+-- Dump completed on 2023-12-20 23:18:00
diff --git a/sql/updates/auth/master/2023_10_06_00_auth.sql b/sql/old/10.x/auth/23101_2023_12_20/2023_10_06_00_auth.sql
index 1f1bdec7024..1f1bdec7024 100644
--- a/sql/updates/auth/master/2023_10_06_00_auth.sql
+++ b/sql/old/10.x/auth/23101_2023_12_20/2023_10_06_00_auth.sql
diff --git a/sql/updates/auth/master/2023_10_17_00_auth.sql b/sql/old/10.x/auth/23101_2023_12_20/2023_10_17_00_auth.sql
index fab4b5e6fd5..fab4b5e6fd5 100644
--- a/sql/updates/auth/master/2023_10_17_00_auth.sql
+++ b/sql/old/10.x/auth/23101_2023_12_20/2023_10_17_00_auth.sql
diff --git a/sql/updates/auth/master/2023_10_25_00_auth.sql b/sql/old/10.x/auth/23101_2023_12_20/2023_10_25_00_auth.sql
index 5c959d21545..5c959d21545 100644
--- a/sql/updates/auth/master/2023_10_25_00_auth.sql
+++ b/sql/old/10.x/auth/23101_2023_12_20/2023_10_25_00_auth.sql
diff --git a/sql/updates/auth/master/2023_11_01_00_auth.sql b/sql/old/10.x/auth/23101_2023_12_20/2023_11_01_00_auth.sql
index 4d6bf28dade..4d6bf28dade 100644
--- a/sql/updates/auth/master/2023_11_01_00_auth.sql
+++ b/sql/old/10.x/auth/23101_2023_12_20/2023_11_01_00_auth.sql
diff --git a/sql/updates/auth/master/2023_11_09_00_auth.sql b/sql/old/10.x/auth/23101_2023_12_20/2023_11_09_00_auth.sql
index ca462a6d2e2..ca462a6d2e2 100644
--- a/sql/updates/auth/master/2023_11_09_00_auth.sql
+++ b/sql/old/10.x/auth/23101_2023_12_20/2023_11_09_00_auth.sql
diff --git a/sql/updates/auth/master/2023_11_09_01_auth.sql b/sql/old/10.x/auth/23101_2023_12_20/2023_11_09_01_auth.sql
index f9dece9af4d..f9dece9af4d 100644
--- a/sql/updates/auth/master/2023_11_09_01_auth.sql
+++ b/sql/old/10.x/auth/23101_2023_12_20/2023_11_09_01_auth.sql
diff --git a/sql/updates/auth/master/2023_11_14_00_auth.sql b/sql/old/10.x/auth/23101_2023_12_20/2023_11_14_00_auth.sql
index 3f904970618..3f904970618 100644
--- a/sql/updates/auth/master/2023_11_14_00_auth.sql
+++ b/sql/old/10.x/auth/23101_2023_12_20/2023_11_14_00_auth.sql
diff --git a/sql/updates/auth/master/2023_11_21_00_auth.sql b/sql/old/10.x/auth/23101_2023_12_20/2023_11_21_00_auth.sql
index 1dc190782d7..1dc190782d7 100644
--- a/sql/updates/auth/master/2023_11_21_00_auth.sql
+++ b/sql/old/10.x/auth/23101_2023_12_20/2023_11_21_00_auth.sql
diff --git a/sql/updates/auth/master/2023_11_24_00_auth.sql b/sql/old/10.x/auth/23101_2023_12_20/2023_11_24_00_auth.sql
index 24ceeb979c7..24ceeb979c7 100644
--- a/sql/updates/auth/master/2023_11_24_00_auth.sql
+++ b/sql/old/10.x/auth/23101_2023_12_20/2023_11_24_00_auth.sql
diff --git a/sql/updates/characters/master/2023_10_06_00_characters.sql b/sql/old/10.x/characters/23101_2023_12_20/2023_10_06_00_characters.sql
index 89ca5b774ad..89ca5b774ad 100644
--- a/sql/updates/characters/master/2023_10_06_00_characters.sql
+++ b/sql/old/10.x/characters/23101_2023_12_20/2023_10_06_00_characters.sql
diff --git a/sql/updates/characters/master/2023_11_02_00_characters.sql b/sql/old/10.x/characters/23101_2023_12_20/2023_11_02_00_characters.sql
index 1c06a0785a4..1c06a0785a4 100644
--- a/sql/updates/characters/master/2023_11_02_00_characters.sql
+++ b/sql/old/10.x/characters/23101_2023_12_20/2023_11_02_00_characters.sql
diff --git a/sql/updates/characters/master/2023_11_09_00_characters.sql b/sql/old/10.x/characters/23101_2023_12_20/2023_11_09_00_characters.sql
index dec6bfc0432..dec6bfc0432 100644
--- a/sql/updates/characters/master/2023_11_09_00_characters.sql
+++ b/sql/old/10.x/characters/23101_2023_12_20/2023_11_09_00_characters.sql
diff --git a/sql/updates/hotfixes/master/2023_10_06_00_hotfixes.sql b/sql/old/10.x/hotfixes/23101_2023_12_20/2023_10_06_00_hotfixes.sql
index fecb5b35fd2..fecb5b35fd2 100644
--- a/sql/updates/hotfixes/master/2023_10_06_00_hotfixes.sql
+++ b/sql/old/10.x/hotfixes/23101_2023_12_20/2023_10_06_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2023_10_15_00_hotfixes.sql b/sql/old/10.x/hotfixes/23101_2023_12_20/2023_10_15_00_hotfixes.sql
index 1df3ac49960..1df3ac49960 100644
--- a/sql/updates/hotfixes/master/2023_10_15_00_hotfixes.sql
+++ b/sql/old/10.x/hotfixes/23101_2023_12_20/2023_10_15_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2023_11_09_00_hotfixes.sql b/sql/old/10.x/hotfixes/23101_2023_12_20/2023_11_09_00_hotfixes.sql
index 457783c0295..457783c0295 100644
--- a/sql/updates/hotfixes/master/2023_11_09_00_hotfixes.sql
+++ b/sql/old/10.x/hotfixes/23101_2023_12_20/2023_11_09_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/master/2023_11_10_00_hotfixes.sql b/sql/old/10.x/hotfixes/23101_2023_12_20/2023_11_10_00_hotfixes.sql
index 2f9c8e39795..2f9c8e39795 100644
--- a/sql/updates/hotfixes/master/2023_11_10_00_hotfixes.sql
+++ b/sql/old/10.x/hotfixes/23101_2023_12_20/2023_11_10_00_hotfixes.sql
diff --git a/sql/updates/world/master/2023_10_06_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_06_00_world.sql
index 77ca0433031..77ca0433031 100644
--- a/sql/updates/world/master/2023_10_06_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_06_00_world.sql
diff --git a/sql/updates/world/master/2023_10_08_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_08_00_world.sql
index d6b2841a238..d6b2841a238 100644
--- a/sql/updates/world/master/2023_10_08_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_08_00_world.sql
diff --git a/sql/updates/world/master/2023_10_09_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_09_00_world.sql
index abc43a46c97..abc43a46c97 100644
--- a/sql/updates/world/master/2023_10_09_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_09_00_world.sql
diff --git a/sql/updates/world/master/2023_10_12_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_12_00_world.sql
index bb937af05fd..bb937af05fd 100644
--- a/sql/updates/world/master/2023_10_12_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_12_00_world.sql
diff --git a/sql/updates/world/master/2023_10_13_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_13_00_world.sql
index cabfd8c1048..cabfd8c1048 100644
--- a/sql/updates/world/master/2023_10_13_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_13_00_world.sql
diff --git a/sql/updates/world/master/2023_10_15_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_15_00_world.sql
index 18482ffce46..18482ffce46 100644
--- a/sql/updates/world/master/2023_10_15_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_15_00_world.sql
diff --git a/sql/updates/world/master/2023_10_15_01_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_15_01_world.sql
index 6fbca6308bc..6fbca6308bc 100644
--- a/sql/updates/world/master/2023_10_15_01_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_15_01_world.sql
diff --git a/sql/updates/world/master/2023_10_17_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_00_world.sql
index 820e606fe28..820e606fe28 100644
--- a/sql/updates/world/master/2023_10_17_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_00_world.sql
diff --git a/sql/updates/world/master/2023_10_17_01_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_01_world.sql
index ed553fb846a..ed553fb846a 100644
--- a/sql/updates/world/master/2023_10_17_01_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_01_world.sql
diff --git a/sql/updates/world/master/2023_10_17_02_world_warrior.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_02_world_warrior.sql
index a434168a2b2..a434168a2b2 100644
--- a/sql/updates/world/master/2023_10_17_02_world_warrior.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_02_world_warrior.sql
diff --git a/sql/updates/world/master/2023_10_17_03_world_paladin.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_03_world_paladin.sql
index f76d918c7fe..f76d918c7fe 100644
--- a/sql/updates/world/master/2023_10_17_03_world_paladin.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_03_world_paladin.sql
diff --git a/sql/updates/world/master/2023_10_17_04_world_hunter.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_04_world_hunter.sql
index 4f00869180d..4f00869180d 100644
--- a/sql/updates/world/master/2023_10_17_04_world_hunter.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_04_world_hunter.sql
diff --git a/sql/updates/world/master/2023_10_17_05_world_rogue.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_05_world_rogue.sql
index bd5426356b5..bd5426356b5 100644
--- a/sql/updates/world/master/2023_10_17_05_world_rogue.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_05_world_rogue.sql
diff --git a/sql/updates/world/master/2023_10_17_06_world_priest.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_06_world_priest.sql
index ee56a337d58..ee56a337d58 100644
--- a/sql/updates/world/master/2023_10_17_06_world_priest.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_06_world_priest.sql
diff --git a/sql/updates/world/master/2023_10_17_07_world_deathknight.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_07_world_deathknight.sql
index e836f625934..e836f625934 100644
--- a/sql/updates/world/master/2023_10_17_07_world_deathknight.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_07_world_deathknight.sql
diff --git a/sql/updates/world/master/2023_10_17_08_world_shaman.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_08_world_shaman.sql
index 68d24f89cec..68d24f89cec 100644
--- a/sql/updates/world/master/2023_10_17_08_world_shaman.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_08_world_shaman.sql
diff --git a/sql/updates/world/master/2023_10_17_09_world_mage.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_09_world_mage.sql
index 87abdd8ce2c..87abdd8ce2c 100644
--- a/sql/updates/world/master/2023_10_17_09_world_mage.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_09_world_mage.sql
diff --git a/sql/updates/world/master/2023_10_17_10_world_warlock.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_10_world_warlock.sql
index 0417796060a..0417796060a 100644
--- a/sql/updates/world/master/2023_10_17_10_world_warlock.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_10_world_warlock.sql
diff --git a/sql/updates/world/master/2023_10_17_11_world_monk.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_11_world_monk.sql
index 20907b22223..20907b22223 100644
--- a/sql/updates/world/master/2023_10_17_11_world_monk.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_11_world_monk.sql
diff --git a/sql/updates/world/master/2023_10_17_12_world_druid.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_12_world_druid.sql
index 851759d1db7..851759d1db7 100644
--- a/sql/updates/world/master/2023_10_17_12_world_druid.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_12_world_druid.sql
diff --git a/sql/updates/world/master/2023_10_17_13_world_demonhunter.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_13_world_demonhunter.sql
index c5bc06563d7..c5bc06563d7 100644
--- a/sql/updates/world/master/2023_10_17_13_world_demonhunter.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_13_world_demonhunter.sql
diff --git a/sql/updates/world/master/2023_10_17_14_world_evoker.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_14_world_evoker.sql
index a55f8eaf942..a55f8eaf942 100644
--- a/sql/updates/world/master/2023_10_17_14_world_evoker.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_17_14_world_evoker.sql
diff --git a/sql/updates/world/master/2023_10_20_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_20_00_world.sql
index f660515fdce..f660515fdce 100644
--- a/sql/updates/world/master/2023_10_20_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_20_00_world.sql
diff --git a/sql/updates/world/master/2023_10_21_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_21_00_world.sql
index c3b937ca035..c3b937ca035 100644
--- a/sql/updates/world/master/2023_10_21_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_21_00_world.sql
diff --git a/sql/updates/world/master/2023_10_22_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_22_00_world.sql
index e58a2f2cbbc..e58a2f2cbbc 100644
--- a/sql/updates/world/master/2023_10_22_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_22_00_world.sql
diff --git a/sql/updates/world/master/2023_10_22_01_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_22_01_world.sql
index 395fac72dac..395fac72dac 100644
--- a/sql/updates/world/master/2023_10_22_01_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_22_01_world.sql
diff --git a/sql/updates/world/master/2023_10_22_02_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_22_02_world.sql
index f648851661e..f648851661e 100644
--- a/sql/updates/world/master/2023_10_22_02_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_22_02_world.sql
diff --git a/sql/updates/world/master/2023_10_23_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_00_world.sql
index cd2414f60d6..cd2414f60d6 100644
--- a/sql/updates/world/master/2023_10_23_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_00_world.sql
diff --git a/sql/updates/world/master/2023_10_23_01_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_01_world.sql
index 89effbda05b..89effbda05b 100644
--- a/sql/updates/world/master/2023_10_23_01_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_01_world.sql
diff --git a/sql/updates/world/master/2023_10_23_02_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_02_world.sql
index 69ea0da3c44..69ea0da3c44 100644
--- a/sql/updates/world/master/2023_10_23_02_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_02_world.sql
diff --git a/sql/updates/world/master/2023_10_23_03_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_03_world.sql
index b3b46e71aeb..b3b46e71aeb 100644
--- a/sql/updates/world/master/2023_10_23_03_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_03_world.sql
diff --git a/sql/updates/world/master/2023_10_23_04_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_04_world.sql
index 534b887db72..534b887db72 100644
--- a/sql/updates/world/master/2023_10_23_04_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_04_world.sql
diff --git a/sql/updates/world/master/2023_10_23_05_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_05_world.sql
index 01fdfe42f8c..01fdfe42f8c 100644
--- a/sql/updates/world/master/2023_10_23_05_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_23_05_world.sql
diff --git a/sql/updates/world/master/2023_10_28_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_28_00_world.sql
index 35348018a88..35348018a88 100644
--- a/sql/updates/world/master/2023_10_28_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_28_00_world.sql
diff --git a/sql/updates/world/master/2023_10_28_01_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_28_01_world.sql
index 34c755e0f6a..34c755e0f6a 100644
--- a/sql/updates/world/master/2023_10_28_01_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_28_01_world.sql
diff --git a/sql/updates/world/master/2023_10_29_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_29_00_world.sql
index bf4736291f2..bf4736291f2 100644
--- a/sql/updates/world/master/2023_10_29_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_29_00_world.sql
diff --git a/sql/updates/world/master/2023_10_29_01_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_29_01_world.sql
index 643cd8ddf3b..643cd8ddf3b 100644
--- a/sql/updates/world/master/2023_10_29_01_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_29_01_world.sql
diff --git a/sql/updates/world/master/2023_10_29_02_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_29_02_world.sql
index 13cf11a129e..13cf11a129e 100644
--- a/sql/updates/world/master/2023_10_29_02_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_29_02_world.sql
diff --git a/sql/updates/world/master/2023_10_30_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_10_30_00_world.sql
index 1ec6502f89c..1ec6502f89c 100644
--- a/sql/updates/world/master/2023_10_30_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_10_30_00_world.sql
diff --git a/sql/updates/world/master/2023_11_02_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_02_00_world.sql
index b76f1a5f848..b76f1a5f848 100644
--- a/sql/updates/world/master/2023_11_02_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_02_00_world.sql
diff --git a/sql/updates/world/master/2023_11_03_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_03_00_world.sql
index 22817cb36dd..22817cb36dd 100644
--- a/sql/updates/world/master/2023_11_03_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_03_00_world.sql
diff --git a/sql/updates/world/master/2023_11_05_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_05_00_world.sql
index 62f75af9ef7..62f75af9ef7 100644
--- a/sql/updates/world/master/2023_11_05_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_05_00_world.sql
diff --git a/sql/updates/world/master/2023_11_06_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_00_world.sql
index 69ab13ce5d9..69ab13ce5d9 100644
--- a/sql/updates/world/master/2023_11_06_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_00_world.sql
diff --git a/sql/updates/world/master/2023_11_06_01_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_01_world.sql
index 4c15c5b057d..4c15c5b057d 100644
--- a/sql/updates/world/master/2023_11_06_01_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_01_world.sql
diff --git a/sql/updates/world/master/2023_11_06_02_world_eversong_woods_silvermoon_city.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_02_world_eversong_woods_silvermoon_city.sql
index efad3a248a3..efad3a248a3 100644
--- a/sql/updates/world/master/2023_11_06_02_world_eversong_woods_silvermoon_city.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_02_world_eversong_woods_silvermoon_city.sql
diff --git a/sql/updates/world/master/2023_11_06_03_world_eversong_woods_falconwing_square.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_03_world_eversong_woods_falconwing_square.sql
index 2c538d582f2..2c538d582f2 100644
--- a/sql/updates/world/master/2023_11_06_03_world_eversong_woods_falconwing_square.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_03_world_eversong_woods_falconwing_square.sql
diff --git a/sql/updates/world/master/2023_11_06_04_world_eversong_woods_fairbreeze_village.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_04_world_eversong_woods_fairbreeze_village.sql
index 28dd67f0389..28dd67f0389 100644
--- a/sql/updates/world/master/2023_11_06_04_world_eversong_woods_fairbreeze_village.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_04_world_eversong_woods_fairbreeze_village.sql
diff --git a/sql/updates/world/master/2023_11_06_05_world_ghostlands_tranquillien.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_05_world_ghostlands_tranquillien.sql
index c7841352dd9..c7841352dd9 100644
--- a/sql/updates/world/master/2023_11_06_05_world_ghostlands_tranquillien.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_05_world_ghostlands_tranquillien.sql
diff --git a/sql/updates/world/master/2023_11_06_06_world_eastern_plaguelands_lights_hope_chapel.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_06_world_eastern_plaguelands_lights_hope_chapel.sql
index 3e4d295d636..3e4d295d636 100644
--- a/sql/updates/world/master/2023_11_06_06_world_eastern_plaguelands_lights_hope_chapel.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_06_world_eastern_plaguelands_lights_hope_chapel.sql
diff --git a/sql/updates/world/master/2023_11_06_07_world_western_plaguelands_andorhal.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_07_world_western_plaguelands_andorhal.sql
index 19e981c2b75..19e981c2b75 100644
--- a/sql/updates/world/master/2023_11_06_07_world_western_plaguelands_andorhal.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_07_world_western_plaguelands_andorhal.sql
diff --git a/sql/updates/world/master/2023_11_06_08_world_western_plaguelands_chillwind_camp.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_08_world_western_plaguelands_chillwind_camp.sql
index 5dafdc124ed..5dafdc124ed 100644
--- a/sql/updates/world/master/2023_11_06_08_world_western_plaguelands_chillwind_camp.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_08_world_western_plaguelands_chillwind_camp.sql
diff --git a/sql/updates/world/master/2023_11_06_09_world_tirisfal_glades_undercity.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_09_world_tirisfal_glades_undercity.sql
index 50daaa997e0..50daaa997e0 100644
--- a/sql/updates/world/master/2023_11_06_09_world_tirisfal_glades_undercity.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_09_world_tirisfal_glades_undercity.sql
diff --git a/sql/updates/world/master/2023_11_06_10_world_tirisfal_glades_brill.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_10_world_tirisfal_glades_brill.sql
index 4fcaf8b85b1..4fcaf8b85b1 100644
--- a/sql/updates/world/master/2023_11_06_10_world_tirisfal_glades_brill.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_10_world_tirisfal_glades_brill.sql
diff --git a/sql/updates/world/master/2023_11_06_11_world_tirisfal_glades_the_bulwark.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_11_world_tirisfal_glades_the_bulwark.sql
index 9cc7357d65c..9cc7357d65c 100644
--- a/sql/updates/world/master/2023_11_06_11_world_tirisfal_glades_the_bulwark.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_11_world_tirisfal_glades_the_bulwark.sql
diff --git a/sql/updates/world/master/2023_11_06_12_world_silverpine_forest_forsaken_rear_guard.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_12_world_silverpine_forest_forsaken_rear_guard.sql
index 59a315356ed..59a315356ed 100644
--- a/sql/updates/world/master/2023_11_06_12_world_silverpine_forest_forsaken_rear_guard.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_12_world_silverpine_forest_forsaken_rear_guard.sql
diff --git a/sql/updates/world/master/2023_11_06_13_world_silverpine_forest_the_sepulcher.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_13_world_silverpine_forest_the_sepulcher.sql
index 4b941afbe6d..4b941afbe6d 100644
--- a/sql/updates/world/master/2023_11_06_13_world_silverpine_forest_the_sepulcher.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_13_world_silverpine_forest_the_sepulcher.sql
diff --git a/sql/updates/world/master/2023_11_06_14_world_hillsbrad_foothills_tarren_mill.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_14_world_hillsbrad_foothills_tarren_mill.sql
index 57a4697477e..57a4697477e 100644
--- a/sql/updates/world/master/2023_11_06_14_world_hillsbrad_foothills_tarren_mill.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_14_world_hillsbrad_foothills_tarren_mill.sql
diff --git a/sql/updates/world/master/2023_11_06_15_world_hillsbrad_foothills_eastpoint_tower.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_15_world_hillsbrad_foothills_eastpoint_tower.sql
index be34d671247..be34d671247 100644
--- a/sql/updates/world/master/2023_11_06_15_world_hillsbrad_foothills_eastpoint_tower.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_15_world_hillsbrad_foothills_eastpoint_tower.sql
diff --git a/sql/updates/world/master/2023_11_06_16_world_hinterlands_hiriwatha_research_station.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_16_world_hinterlands_hiriwatha_research_station.sql
index c83e7fc6ad5..c83e7fc6ad5 100644
--- a/sql/updates/world/master/2023_11_06_16_world_hinterlands_hiriwatha_research_station.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_16_world_hinterlands_hiriwatha_research_station.sql
diff --git a/sql/updates/world/master/2023_11_06_17_world_hinterlands_revantusk_village.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_17_world_hinterlands_revantusk_village.sql
index 2246d7d5972..2246d7d5972 100644
--- a/sql/updates/world/master/2023_11_06_17_world_hinterlands_revantusk_village.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_17_world_hinterlands_revantusk_village.sql
diff --git a/sql/updates/world/master/2023_11_06_18_world_hinterlands_aerie_peak.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_18_world_hinterlands_aerie_peak.sql
index 61f58f7f195..61f58f7f195 100644
--- a/sql/updates/world/master/2023_11_06_18_world_hinterlands_aerie_peak.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_18_world_hinterlands_aerie_peak.sql
diff --git a/sql/updates/world/master/2023_11_06_19_world_hinterlands_stormfeather_outpost.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_19_world_hinterlands_stormfeather_outpost.sql
index 1544132032f..1544132032f 100644
--- a/sql/updates/world/master/2023_11_06_19_world_hinterlands_stormfeather_outpost.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_19_world_hinterlands_stormfeather_outpost.sql
diff --git a/sql/updates/world/master/2023_11_06_20_world_arathi_highlands_hammerfall.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_20_world_arathi_highlands_hammerfall.sql
index d50f8a549aa..d50f8a549aa 100644
--- a/sql/updates/world/master/2023_11_06_20_world_arathi_highlands_hammerfall.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_20_world_arathi_highlands_hammerfall.sql
diff --git a/sql/updates/world/master/2023_11_06_21_world_arathi_highlands_refuge_pointe.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_21_world_arathi_highlands_refuge_pointe.sql
index 1e3ab7265c9..1e3ab7265c9 100644
--- a/sql/updates/world/master/2023_11_06_21_world_arathi_highlands_refuge_pointe.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_06_21_world_arathi_highlands_refuge_pointe.sql
diff --git a/sql/updates/world/master/2023_11_07_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_07_00_world.sql
index 2af4aca976a..2af4aca976a 100644
--- a/sql/updates/world/master/2023_11_07_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_07_00_world.sql
diff --git a/sql/updates/world/master/2023_11_08_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_00_world.sql
index 874d7985f3f..874d7985f3f 100644
--- a/sql/updates/world/master/2023_11_08_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_00_world.sql
diff --git a/sql/updates/world/master/2023_11_08_01_world_wetlands_swiftgear_station.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_01_world_wetlands_swiftgear_station.sql
index b6c6ea0a2f8..b6c6ea0a2f8 100644
--- a/sql/updates/world/master/2023_11_08_01_world_wetlands_swiftgear_station.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_01_world_wetlands_swiftgear_station.sql
diff --git a/sql/updates/world/master/2023_11_08_02_world_wetlands_greenwardens_grove.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_02_world_wetlands_greenwardens_grove.sql
index 6b49ecb4766..6b49ecb4766 100644
--- a/sql/updates/world/master/2023_11_08_02_world_wetlands_greenwardens_grove.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_02_world_wetlands_greenwardens_grove.sql
diff --git a/sql/updates/world/master/2023_11_08_03_world_wetlands_menethil_harbor.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_03_world_wetlands_menethil_harbor.sql
index e69999267a6..e69999267a6 100644
--- a/sql/updates/world/master/2023_11_08_03_world_wetlands_menethil_harbor.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_03_world_wetlands_menethil_harbor.sql
diff --git a/sql/updates/world/master/2023_11_08_04_world_dun_morogh_ironforge.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_04_world_dun_morogh_ironforge.sql
index b13ee5815ef..b13ee5815ef 100644
--- a/sql/updates/world/master/2023_11_08_04_world_dun_morogh_ironforge.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_04_world_dun_morogh_ironforge.sql
diff --git a/sql/updates/world/master/2023_11_08_05_world_dun_morogh_kharanos.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_05_world_dun_morogh_kharanos.sql
index 64b967060c6..64b967060c6 100644
--- a/sql/updates/world/master/2023_11_08_05_world_dun_morogh_kharanos.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_05_world_dun_morogh_kharanos.sql
diff --git a/sql/updates/world/master/2023_11_08_06_world_loch_modan_thelsamar.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_06_world_loch_modan_thelsamar.sql
index cee65358033..cee65358033 100644
--- a/sql/updates/world/master/2023_11_08_06_world_loch_modan_thelsamar.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_06_world_loch_modan_thelsamar.sql
diff --git a/sql/updates/world/master/2023_11_08_07_world_loch_modan_farstrider_lodge.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_07_world_loch_modan_farstrider_lodge.sql
index 29f76f1993b..29f76f1993b 100644
--- a/sql/updates/world/master/2023_11_08_07_world_loch_modan_farstrider_lodge.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_07_world_loch_modan_farstrider_lodge.sql
diff --git a/sql/updates/world/master/2023_11_08_08_world_searing_gorge_iron_summit.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_08_world_searing_gorge_iron_summit.sql
index 34659bf644b..34659bf644b 100644
--- a/sql/updates/world/master/2023_11_08_08_world_searing_gorge_iron_summit.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_08_world_searing_gorge_iron_summit.sql
diff --git a/sql/updates/world/master/2023_11_08_09_world_badlands_fuselight.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_09_world_badlands_fuselight.sql
index f8131965492..f8131965492 100644
--- a/sql/updates/world/master/2023_11_08_09_world_badlands_fuselight.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_09_world_badlands_fuselight.sql
diff --git a/sql/updates/world/master/2023_11_08_10_world_badlands_new_kargath.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_10_world_badlands_new_kargath.sql
index d823fe28283..d823fe28283 100644
--- a/sql/updates/world/master/2023_11_08_10_world_badlands_new_kargath.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_10_world_badlands_new_kargath.sql
diff --git a/sql/updates/world/master/2023_11_08_11_world_badlands_dragons_mouth.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_11_world_badlands_dragons_mouth.sql
index b0df4b9f9ed..b0df4b9f9ed 100644
--- a/sql/updates/world/master/2023_11_08_11_world_badlands_dragons_mouth.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_11_world_badlands_dragons_mouth.sql
diff --git a/sql/updates/world/master/2023_11_08_12_world_elwynn_forest_goldshire.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_12_world_elwynn_forest_goldshire.sql
index ed42e2e7206..ed42e2e7206 100644
--- a/sql/updates/world/master/2023_11_08_12_world_elwynn_forest_goldshire.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_12_world_elwynn_forest_goldshire.sql
diff --git a/sql/updates/world/master/2023_11_08_13_world_the_stockade.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_13_world_the_stockade.sql
index febc7445b77..febc7445b77 100644
--- a/sql/updates/world/master/2023_11_08_13_world_the_stockade.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_13_world_the_stockade.sql
diff --git a/sql/updates/world/master/2023_11_08_14_world_redridge_mountains_lakeshire.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_14_world_redridge_mountains_lakeshire.sql
index 9aec3272d15..9aec3272d15 100644
--- a/sql/updates/world/master/2023_11_08_14_world_redridge_mountains_lakeshire.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_14_world_redridge_mountains_lakeshire.sql
diff --git a/sql/updates/world/master/2023_11_08_15_world_westfall_sentinel_hill.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_15_world_westfall_sentinel_hill.sql
index 4961c885e72..4961c885e72 100644
--- a/sql/updates/world/master/2023_11_08_15_world_westfall_sentinel_hill.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_15_world_westfall_sentinel_hill.sql
diff --git a/sql/updates/world/master/2023_11_08_16_world_the_deadmines.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_16_world_the_deadmines.sql
index d08dbef68dd..d08dbef68dd 100644
--- a/sql/updates/world/master/2023_11_08_16_world_the_deadmines.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_16_world_the_deadmines.sql
diff --git a/sql/updates/world/master/2023_11_08_17_world_duskwood_darkshire.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_17_world_duskwood_darkshire.sql
index c77ad29bf26..c77ad29bf26 100644
--- a/sql/updates/world/master/2023_11_08_17_world_duskwood_darkshire.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_17_world_duskwood_darkshire.sql
diff --git a/sql/updates/world/master/2023_11_08_18_world_swamp_of_sorrows_bogpaddle.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_18_world_swamp_of_sorrows_bogpaddle.sql
index 9bfd69b322e..9bfd69b322e 100644
--- a/sql/updates/world/master/2023_11_08_18_world_swamp_of_sorrows_bogpaddle.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_18_world_swamp_of_sorrows_bogpaddle.sql
diff --git a/sql/updates/world/master/2023_11_08_19_world_swamp_of_sorrows_stonard.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_19_world_swamp_of_sorrows_stonard.sql
index c4223a67b1c..c4223a67b1c 100644
--- a/sql/updates/world/master/2023_11_08_19_world_swamp_of_sorrows_stonard.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_19_world_swamp_of_sorrows_stonard.sql
diff --git a/sql/updates/world/master/2023_11_08_20_world_swamp_of_sorrows_the_harborage.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_20_world_swamp_of_sorrows_the_harborage.sql
index 225193f81a0..225193f81a0 100644
--- a/sql/updates/world/master/2023_11_08_20_world_swamp_of_sorrows_the_harborage.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_20_world_swamp_of_sorrows_the_harborage.sql
diff --git a/sql/updates/world/master/2023_11_08_21_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_21_world.sql
index bcb22b59e08..bcb22b59e08 100644
--- a/sql/updates/world/master/2023_11_08_21_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_08_21_world.sql
diff --git a/sql/updates/world/master/2023_11_10_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_10_00_world.sql
index a773bd7d9fd..a773bd7d9fd 100644
--- a/sql/updates/world/master/2023_11_10_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_10_00_world.sql
diff --git a/sql/updates/world/master/2023_11_12_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_12_00_world.sql
index 35f4b65c079..35f4b65c079 100644
--- a/sql/updates/world/master/2023_11_12_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_12_00_world.sql
diff --git a/sql/updates/world/master/2023_11_12_01_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_12_01_world.sql
index 3567eb7a79c..3567eb7a79c 100644
--- a/sql/updates/world/master/2023_11_12_01_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_12_01_world.sql
diff --git a/sql/updates/world/master/2023_11_13_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_13_00_world.sql
index 1d85e30c965..1d85e30c965 100644
--- a/sql/updates/world/master/2023_11_13_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_13_00_world.sql
diff --git a/sql/updates/world/master/2023_11_13_01_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_13_01_world.sql
index df04993e02d..df04993e02d 100644
--- a/sql/updates/world/master/2023_11_13_01_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_13_01_world.sql
diff --git a/sql/updates/world/master/2023_11_13_02_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_13_02_world.sql
index 8218c4b8921..8218c4b8921 100644
--- a/sql/updates/world/master/2023_11_13_02_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_13_02_world.sql
diff --git a/sql/updates/world/master/2023_11_14_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_14_00_world.sql
index 92e900af808..92e900af808 100644
--- a/sql/updates/world/master/2023_11_14_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_14_00_world.sql
diff --git a/sql/updates/world/master/2023_11_24_00_world.sql b/sql/old/10.x/world/23101_2023_12_20/2023_11_24_00_world.sql
index b35bbb08864..b35bbb08864 100644
--- a/sql/updates/world/master/2023_11_24_00_world.sql
+++ b/sql/old/10.x/world/23101_2023_12_20/2023_11_24_00_world.sql
diff --git a/sql/updates/auth/wotlk_classic/2023_11_15_00_auth.sql b/sql/old/3.4.x/auth/23101_2023_12_20/2023_11_15_00_auth.sql
index 3cbe2e9f89c..3cbe2e9f89c 100644
--- a/sql/updates/auth/wotlk_classic/2023_11_15_00_auth.sql
+++ b/sql/old/3.4.x/auth/23101_2023_12_20/2023_11_15_00_auth.sql
diff --git a/sql/updates/auth/wotlk_classic/2023_11_23_00_auth.sql b/sql/old/3.4.x/auth/23101_2023_12_20/2023_11_23_00_auth.sql
index cce0096b20c..cce0096b20c 100644
--- a/sql/updates/auth/wotlk_classic/2023_11_23_00_auth.sql
+++ b/sql/old/3.4.x/auth/23101_2023_12_20/2023_11_23_00_auth.sql
diff --git a/sql/updates/characters/wotlk_classic/2023_11_16_00_characters.sql b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_16_00_characters.sql
index f770c867236..f770c867236 100644
--- a/sql/updates/characters/wotlk_classic/2023_11_16_00_characters.sql
+++ b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_16_00_characters.sql
diff --git a/sql/updates/characters/wotlk_classic/2023_11_19_00_characters.sql b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_19_00_characters.sql
index aabb3180e67..aabb3180e67 100644
--- a/sql/updates/characters/wotlk_classic/2023_11_19_00_characters.sql
+++ b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_19_00_characters.sql
diff --git a/sql/updates/characters/wotlk_classic/2023_11_20_00_characters.sql b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_20_00_characters.sql
index 3c8be1ba07d..3c8be1ba07d 100644
--- a/sql/updates/characters/wotlk_classic/2023_11_20_00_characters.sql
+++ b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_20_00_characters.sql
diff --git a/sql/updates/characters/wotlk_classic/2023_11_21_00_characters.sql b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_21_00_characters.sql
index d0c3dae0e4d..d0c3dae0e4d 100644
--- a/sql/updates/characters/wotlk_classic/2023_11_21_00_characters.sql
+++ b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_21_00_characters.sql
diff --git a/sql/updates/characters/wotlk_classic/2023_11_22_00_characters.sql b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_22_00_characters.sql
index 97c316db5ce..97c316db5ce 100644
--- a/sql/updates/characters/wotlk_classic/2023_11_22_00_characters.sql
+++ b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_22_00_characters.sql
diff --git a/sql/updates/characters/wotlk_classic/2023_11_23_00_characters.sql b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_23_00_characters.sql
index f76ebf7bcba..f76ebf7bcba 100644
--- a/sql/updates/characters/wotlk_classic/2023_11_23_00_characters.sql
+++ b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_23_00_characters.sql
diff --git a/sql/updates/characters/wotlk_classic/2023_11_25_00_characters.sql b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_25_00_characters.sql
index 32bd61292c1..32bd61292c1 100644
--- a/sql/updates/characters/wotlk_classic/2023_11_25_00_characters.sql
+++ b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_25_00_characters.sql
diff --git a/sql/updates/characters/wotlk_classic/2023_11_27_00_characters.sql b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_27_00_characters.sql
index 12c5f735bf0..12c5f735bf0 100644
--- a/sql/updates/characters/wotlk_classic/2023_11_27_00_characters.sql
+++ b/sql/old/3.4.x/characters/23101_2023_12_20/2023_11_27_00_characters.sql
diff --git a/sql/updates/characters/wotlk_classic/2023_12_03_00_characters.sql b/sql/old/3.4.x/characters/23101_2023_12_20/2023_12_03_00_characters.sql
index f5989d6dcc5..f5989d6dcc5 100644
--- a/sql/updates/characters/wotlk_classic/2023_12_03_00_characters.sql
+++ b/sql/old/3.4.x/characters/23101_2023_12_20/2023_12_03_00_characters.sql
diff --git a/sql/updates/hotfixes/wotlk_classic/2023_11_15_00_hotfixes.sql b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_15_00_hotfixes.sql
index 5275cc44d73..5275cc44d73 100644
--- a/sql/updates/hotfixes/wotlk_classic/2023_11_15_00_hotfixes.sql
+++ b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_15_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/wotlk_classic/2023_11_15_01_hotfixes.sql b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_15_01_hotfixes.sql
index 777c4d6e86d..777c4d6e86d 100644
--- a/sql/updates/hotfixes/wotlk_classic/2023_11_15_01_hotfixes.sql
+++ b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_15_01_hotfixes.sql
diff --git a/sql/updates/hotfixes/wotlk_classic/2023_11_15_02_hotfixes.sql b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_15_02_hotfixes.sql
index fa42068b854..fa42068b854 100644
--- a/sql/updates/hotfixes/wotlk_classic/2023_11_15_02_hotfixes.sql
+++ b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_15_02_hotfixes.sql
diff --git a/sql/updates/hotfixes/wotlk_classic/2023_11_23_00_hotfixes.sql b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_23_00_hotfixes.sql
index 542e3ef69d1..542e3ef69d1 100644
--- a/sql/updates/hotfixes/wotlk_classic/2023_11_23_00_hotfixes.sql
+++ b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_23_00_hotfixes.sql
diff --git a/sql/updates/hotfixes/wotlk_classic/2023_11_23_01_hotfixes.sql b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_23_01_hotfixes.sql
index 7d5941f0dbb..7d5941f0dbb 100644
--- a/sql/updates/hotfixes/wotlk_classic/2023_11_23_01_hotfixes.sql
+++ b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_23_01_hotfixes.sql
diff --git a/sql/updates/hotfixes/wotlk_classic/2023_11_23_02_hotfixes.sql b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_23_02_hotfixes.sql
index d3d38898cb3..d3d38898cb3 100644
--- a/sql/updates/hotfixes/wotlk_classic/2023_11_23_02_hotfixes.sql
+++ b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_23_02_hotfixes.sql
diff --git a/sql/updates/hotfixes/wotlk_classic/2023_11_23_03_hotfixes.sql b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_23_03_hotfixes.sql
index e5d2bdbe6ee..e5d2bdbe6ee 100644
--- a/sql/updates/hotfixes/wotlk_classic/2023_11_23_03_hotfixes.sql
+++ b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_23_03_hotfixes.sql
diff --git a/sql/updates/hotfixes/wotlk_classic/2023_11_27_00_hotfixes.sql b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_27_00_hotfixes.sql
index 2f939e108a9..2f939e108a9 100644
--- a/sql/updates/hotfixes/wotlk_classic/2023_11_27_00_hotfixes.sql
+++ b/sql/old/3.4.x/hotfixes/23101_2023_12_20/2023_11_27_00_hotfixes.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_16_00_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_16_00_world.sql
index 47b00ad137d..47b00ad137d 100644
--- a/sql/updates/world/wotlk_classic/2023_11_16_00_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_16_00_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_16_01_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_16_01_world.sql
index b48518e8504..b48518e8504 100644
--- a/sql/updates/world/wotlk_classic/2023_11_16_01_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_16_01_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_17_00_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_17_00_world.sql
index ccec38034c1..ccec38034c1 100644
--- a/sql/updates/world/wotlk_classic/2023_11_17_00_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_17_00_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_20_00_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_20_00_world.sql
index a994f00ea25..a994f00ea25 100644
--- a/sql/updates/world/wotlk_classic/2023_11_20_00_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_20_00_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_20_01_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_20_01_world.sql
index e54ba888bb1..e54ba888bb1 100644
--- a/sql/updates/world/wotlk_classic/2023_11_20_01_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_20_01_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_23_00_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_23_00_world.sql
index c47c16caa9f..c47c16caa9f 100644
--- a/sql/updates/world/wotlk_classic/2023_11_23_00_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_23_00_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_25_00_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_25_00_world.sql
index 9dcf448ab10..9dcf448ab10 100644
--- a/sql/updates/world/wotlk_classic/2023_11_25_00_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_25_00_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_27_00_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_27_00_world.sql
index 5b6606a34a8..5b6606a34a8 100644
--- a/sql/updates/world/wotlk_classic/2023_11_27_00_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_27_00_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_29_00_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_29_00_world.sql
index 10bcdb2d16e..10bcdb2d16e 100644
--- a/sql/updates/world/wotlk_classic/2023_11_29_00_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_29_00_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_29_01_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_29_01_world.sql
index 490bc20e852..490bc20e852 100644
--- a/sql/updates/world/wotlk_classic/2023_11_29_01_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_29_01_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_29_02_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_29_02_world.sql
index 1acaedac3a3..1acaedac3a3 100644
--- a/sql/updates/world/wotlk_classic/2023_11_29_02_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_29_02_world.sql
diff --git a/sql/updates/world/wotlk_classic/2023_11_29_03_world..sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_29_03_world..sql
index 29b36e8664d..29b36e8664d 100644
--- a/sql/updates/world/wotlk_classic/2023_11_29_03_world..sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_11_29_03_world..sql
diff --git a/sql/updates/world/wotlk_classic/2023_12_04_00_world.sql b/sql/old/3.4.x/world/23101_2023_12_20/2023_12_04_00_world.sql
index f0760a008a3..f0760a008a3 100644
--- a/sql/updates/world/wotlk_classic/2023_12_04_00_world.sql
+++ b/sql/old/3.4.x/world/23101_2023_12_20/2023_12_04_00_world.sql
diff --git a/sql/updates/auth/wotlk_classic/2023_12_20_00_auth.sql b/sql/updates/auth/wotlk_classic/2023_12_20_00_auth.sql
new file mode 100644
index 00000000000..6f547c8feb8
--- /dev/null
+++ b/sql/updates/auth/wotlk_classic/2023_12_20_00_auth.sql
@@ -0,0 +1,4 @@
+-- TDB 343.23121 auth
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED');
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/3.4.x/auth', 'ARCHIVED');
diff --git a/sql/updates/characters/wotlk_classic/2023_12_20_00_characters.sql b/sql/updates/characters/wotlk_classic/2023_12_20_00_characters.sql
new file mode 100644
index 00000000000..7a085e369cb
--- /dev/null
+++ b/sql/updates/characters/wotlk_classic/2023_12_20_00_characters.sql
@@ -0,0 +1,4 @@
+-- TDB 343.23121 characters
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/characters', 'ARCHIVED');
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/3.4.x/characters', 'ARCHIVED');
diff --git a/sql/updates/hotfixes/wotlk_classic/2023_12_20_00_hotfixes.sql b/sql/updates/hotfixes/wotlk_classic/2023_12_20_00_hotfixes.sql
new file mode 100644
index 00000000000..b6b82a76538
--- /dev/null
+++ b/sql/updates/hotfixes/wotlk_classic/2023_12_20_00_hotfixes.sql
@@ -0,0 +1,4 @@
+-- TDB 343.23121 hotfixes
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/hotfixes', 'ARCHIVED');
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/3.4.x/hotfixes', 'ARCHIVED');
diff --git a/sql/updates/world/wotlk_classic/2023_12_20_00_world.sql b/sql/updates/world/wotlk_classic/2023_12_20_00_world.sql
new file mode 100644
index 00000000000..0498f96dce0
--- /dev/null
+++ b/sql/updates/world/wotlk_classic/2023_12_20_00_world.sql
@@ -0,0 +1,4 @@
+-- TDB 343.23121 world
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/world', 'ARCHIVED');
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/3.4.x/world', 'ARCHIVED');
author	funjoker <funjoker109@gmail.com>	2023-12-21 00:28:23 +0100
committer	funjoker <funjoker109@gmail.com>	2023-12-21 00:28:23 +0100
commit	f5c8b53b2e3d4203d74ba1af2b0345efe7609db3 (patch)
tree	00ac035c9629feb07060c3a3a4dac1a247cac36d /sql
parent	e5bf7ab086b51601985f2bbcafa62beee23be166 (diff)