TDB 335.23011 - 2023/01/16TDB335.23011

author: TDB Release <tdb-release@build.bot> 2023-01-16 11:10:56 +0000
committer: TDB Release <tdb-release@build.bot> 2023-01-16 11:10:56 +0000
commit: 80884e32ef6e79b6de66fe02a16b0546282f75bb (patch)
tree: 0d59fc54d662976e46d843cc6295a0355d6a17d7 /sql
parent: 128339730cafefba04ca8b1b6c72ed4ea9315bd3 (diff)
61 files changed, 754 insertions, 739 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index d14a8d60d2f..526a7e48d3c 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.30, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.31, for Linux (x86_64)
 --
 -- Host: localhost    Database: auth
 -- ------------------------------------------------------
--- Server version	8.0.30-0ubuntu0.20.04.2
+-- Server version	8.0.31-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2003,7 +2003,8 @@ INSERT INTO `updates` VALUES
 ('2022_04_14_00_auth.sql','B1ED102EB7C9A2A0BDA866201960E70CCCA22FB5','ARCHIVED','2022-04-14 16:24:35',0),
 ('2022_06_01_00_auth.sql','351FA0BEE4F99B4EF451D0B1B6D822376DE4C26C','ARCHIVED','2022-06-01 10:50:50',0),
 ('2022_08_15_00_auth.sql','9EED4B445CAEC5337879206849A5C194872F228D','ARCHIVED','2022-08-15 11:21:17',0),
-('2022_10_17_00_auth.sql','EB711C5B9B3272A05DDF47CA998F87E5DE6DE238','ARCHIVED','2022-10-17 09:02:28',0);
+('2022_10_17_00_auth.sql','EB711C5B9B3272A05DDF47CA998F87E5DE6DE238','ARCHIVED','2022-10-17 09:02:28',0),
+('2023_01_16_00_auth.sql','8431F03DE6A036BEED6682C21F4B67F384390905','ARCHIVED','2023-01-16 11:06:30',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2142,4 +2143,4 @@ SET character_set_client = @saved_cs_client;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-10-17  9:02:31
+-- Dump completed on 2023-01-16 11:08:17
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 7fda6da21ee..f5955382dc4 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13  Distrib 8.0.30, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.31, for Linux (x86_64)
 --
 -- Host: localhost    Database: characters
 -- ------------------------------------------------------
--- Server version	8.0.30-0ubuntu0.20.04.2
+-- Server version	8.0.31-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2676,7 +2676,8 @@ INSERT INTO `updates` VALUES
 ('2022_04_14_00_characters.sql','FFFF611BE95F047CD853701136452BF8D28C3130','ARCHIVED','2022-04-14 16:24:35',0),
 ('2022_06_01_00_characters.sql','F33CA4F6F0A685CE1F42F0106269F3C39E31F1B0','ARCHIVED','2022-06-01 10:50:50',0),
 ('2022_08_15_00_characters.sql','B2468D3323AB51872385A0B36EF66688C4F661EA','ARCHIVED','2022-08-15 11:21:17',0),
-('2022_10_17_00_characters.sql','3E50C54495FE2653EB2F5F9120B17D124D70CEDE','ARCHIVED','2022-10-17 09:02:28',0);
+('2022_10_17_00_characters.sql','3E50C54495FE2653EB2F5F9120B17D124D70CEDE','ARCHIVED','2022-10-17 09:02:28',0),
+('2023_01_16_00_characters.sql','2667390C8E0EC1E5CDE16784BFCD8F8749C7D73E','ARCHIVED','2023-01-16 11:06:30',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2847,4 +2848,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-10-17  9:02:31
+-- Dump completed on 2023-01-16 11:08:17
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index e421bd4ebf3..6136160325f 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.30, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.31, for Linux (x86_64)
 --
 -- Host: localhost    Database: world
 -- ------------------------------------------------------
--- Server version	8.0.30-0ubuntu0.20.04.2
+-- Server version	8.0.31-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -23,20 +23,20 @@ DROP TABLE IF EXISTS `access_requirement`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `access_requirement` (
-  `mapId` mediumint unsigned NOT NULL,
+  `mapId` int unsigned NOT NULL,
   `difficulty` tinyint unsigned NOT NULL DEFAULT '0',
   `level_min` tinyint unsigned NOT NULL DEFAULT '0',
   `level_max` tinyint unsigned NOT NULL DEFAULT '0',
   `item_level` smallint unsigned NOT NULL DEFAULT '0',
-  `item` mediumint unsigned NOT NULL DEFAULT '0',
-  `item2` mediumint unsigned NOT NULL DEFAULT '0',
-  `quest_done_A` mediumint unsigned NOT NULL DEFAULT '0',
-  `quest_done_H` mediumint unsigned NOT NULL DEFAULT '0',
-  `completed_achievement` mediumint unsigned NOT NULL DEFAULT '0',
-  `quest_failed_text` text,
-  `comment` text,
+  `item` int unsigned NOT NULL DEFAULT '0',
+  `item2` int unsigned NOT NULL DEFAULT '0',
+  `quest_done_A` int unsigned NOT NULL DEFAULT '0',
+  `quest_done_H` int unsigned NOT NULL DEFAULT '0',
+  `completed_achievement` int unsigned NOT NULL DEFAULT '0',
+  `quest_failed_text` mediumtext COLLATE utf8mb4_unicode_ci,
+  `comment` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`mapId`,`difficulty`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Access Requirements';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Access Requirements';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -47,13 +47,13 @@ DROP TABLE IF EXISTS `achievement_criteria_data`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `achievement_criteria_data` (
-  `criteria_id` mediumint NOT NULL,
+  `criteria_id` int NOT NULL,
   `type` tinyint unsigned NOT NULL DEFAULT '0',
-  `value1` mediumint unsigned NOT NULL DEFAULT '0',
-  `value2` mediumint unsigned NOT NULL DEFAULT '0',
-  `ScriptName` char(64) NOT NULL DEFAULT '',
+  `value1` int unsigned NOT NULL DEFAULT '0',
+  `value2` int unsigned NOT NULL DEFAULT '0',
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`criteria_id`,`type`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Achievment system';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Achievment system';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -72,7 +72,7 @@ CREATE TABLE `achievement_dbc` (
   `count` int unsigned NOT NULL DEFAULT '0',
   `refAchievement` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -83,16 +83,16 @@ DROP TABLE IF EXISTS `achievement_reward`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `achievement_reward` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `TitleA` mediumint unsigned NOT NULL DEFAULT '0',
-  `TitleH` mediumint unsigned NOT NULL DEFAULT '0',
-  `ItemID` mediumint unsigned NOT NULL DEFAULT '0',
-  `Sender` mediumint unsigned NOT NULL DEFAULT '0',
-  `Subject` varchar(255) DEFAULT NULL,
-  `Body` text,
-  `MailTemplateID` mediumint unsigned DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `TitleA` int unsigned NOT NULL DEFAULT '0',
+  `TitleH` int unsigned NOT NULL DEFAULT '0',
+  `ItemID` int unsigned NOT NULL DEFAULT '0',
+  `Sender` int unsigned NOT NULL DEFAULT '0',
+  `Subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Body` mediumtext COLLATE utf8mb4_unicode_ci,
+  `MailTemplateID` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -103,12 +103,12 @@ DROP TABLE IF EXISTS `achievement_reward_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `achievement_reward_locale` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `Locale` varchar(4) NOT NULL,
-  `Subject` text,
-  `Body` text,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Subject` mediumtext COLLATE utf8mb4_unicode_ci,
+  `Body` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`ID`,`Locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -119,10 +119,10 @@ DROP TABLE IF EXISTS `areatrigger_involvedrelation`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `areatrigger_involvedrelation` (
-  `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
-  `quest` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
+  `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
+  `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Trigger System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -133,10 +133,10 @@ DROP TABLE IF EXISTS `areatrigger_scripts`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `areatrigger_scripts` (
-  `entry` mediumint NOT NULL,
-  `ScriptName` char(64) NOT NULL,
+  `entry` int NOT NULL,
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL,
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -147,10 +147,10 @@ DROP TABLE IF EXISTS `areatrigger_tavern`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `areatrigger_tavern` (
-  `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
-  `name` text,
+  `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
+  `name` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Trigger System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -161,8 +161,8 @@ DROP TABLE IF EXISTS `areatrigger_teleport`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `areatrigger_teleport` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `Name` text,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Name` mediumtext COLLATE utf8mb4_unicode_ci,
   `target_map` smallint unsigned NOT NULL DEFAULT '0',
   `target_position_x` float NOT NULL DEFAULT '0',
   `target_position_y` float NOT NULL DEFAULT '0',
@@ -171,7 +171,7 @@ CREATE TABLE `areatrigger_teleport` (
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`),
   FULLTEXT KEY `name` (`Name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Trigger System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -183,9 +183,9 @@ DROP TABLE IF EXISTS `battlefield_template`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `battlefield_template` (
   `TypeId` tinyint unsigned NOT NULL,
-  `ScriptName` varchar(64) NOT NULL DEFAULT '',
-  `comment` text
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+  `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `comment` mediumtext COLLATE utf8mb4_unicode_ci
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -196,21 +196,21 @@ DROP TABLE IF EXISTS `battleground_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `battleground_template` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `MinPlayersPerTeam` smallint unsigned NOT NULL DEFAULT '0',
   `MaxPlayersPerTeam` smallint unsigned NOT NULL DEFAULT '0',
   `MinLvl` tinyint unsigned NOT NULL DEFAULT '0',
   `MaxLvl` tinyint unsigned NOT NULL DEFAULT '0',
-  `AllianceStartLoc` mediumint unsigned NOT NULL,
+  `AllianceStartLoc` int unsigned NOT NULL,
   `AllianceStartO` float NOT NULL,
-  `HordeStartLoc` mediumint unsigned NOT NULL,
+  `HordeStartLoc` int unsigned NOT NULL,
   `HordeStartO` float NOT NULL,
   `StartMaxDist` float NOT NULL DEFAULT '0',
   `Weight` tinyint unsigned NOT NULL DEFAULT '1',
-  `ScriptName` char(64) NOT NULL DEFAULT '',
-  `Comment` char(32) NOT NULL,
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `Comment` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -221,10 +221,10 @@ DROP TABLE IF EXISTS `battlemaster_entry`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `battlemaster_entry` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of a creature',
-  `bg_template` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Battleground template id',
+  `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of a creature',
+  `bg_template` int unsigned NOT NULL DEFAULT '0' COMMENT 'Battleground template id',
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -235,22 +235,22 @@ DROP TABLE IF EXISTS `broadcast_text`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `broadcast_text` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `LanguageID` mediumint unsigned NOT NULL DEFAULT '0',
-  `Text` longtext,
-  `Text1` longtext,
-  `EmoteID1` mediumint unsigned NOT NULL DEFAULT '0',
-  `EmoteID2` mediumint unsigned NOT NULL DEFAULT '0',
-  `EmoteID3` mediumint unsigned NOT NULL DEFAULT '0',
-  `EmoteDelay1` mediumint unsigned NOT NULL DEFAULT '0',
-  `EmoteDelay2` mediumint unsigned NOT NULL DEFAULT '0',
-  `EmoteDelay3` mediumint unsigned NOT NULL DEFAULT '0',
-  `SoundEntriesID` mediumint unsigned NOT NULL DEFAULT '0',
-  `EmotesID` mediumint unsigned NOT NULL DEFAULT '0',
-  `Flags` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `LanguageID` int unsigned NOT NULL DEFAULT '0',
+  `Text` longtext COLLATE utf8mb4_unicode_ci,
+  `Text1` longtext COLLATE utf8mb4_unicode_ci,
+  `EmoteID1` int unsigned NOT NULL DEFAULT '0',
+  `EmoteID2` int unsigned NOT NULL DEFAULT '0',
+  `EmoteID3` int unsigned NOT NULL DEFAULT '0',
+  `EmoteDelay1` int unsigned NOT NULL DEFAULT '0',
+  `EmoteDelay2` int unsigned NOT NULL DEFAULT '0',
+  `EmoteDelay3` int unsigned NOT NULL DEFAULT '0',
+  `SoundEntriesID` int unsigned NOT NULL DEFAULT '0',
+  `EmotesID` int unsigned NOT NULL DEFAULT '0',
+  `Flags` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -261,13 +261,13 @@ DROP TABLE IF EXISTS `broadcast_text_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `broadcast_text_locale` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `Text` text,
-  `Text1` text,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` mediumtext COLLATE utf8mb4_unicode_ci,
+  `Text1` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -278,10 +278,10 @@ DROP TABLE IF EXISTS `command`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `command` (
-  `name` varchar(50) NOT NULL DEFAULT '',
-  `help` longtext,
+  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `help` longtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Chat System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Chat System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -292,23 +292,23 @@ DROP TABLE IF EXISTS `conditions`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `conditions` (
-  `SourceTypeOrReferenceId` mediumint NOT NULL DEFAULT '0',
-  `SourceGroup` mediumint unsigned NOT NULL DEFAULT '0',
-  `SourceEntry` mediumint NOT NULL DEFAULT '0',
+  `SourceTypeOrReferenceId` int NOT NULL DEFAULT '0',
+  `SourceGroup` int unsigned NOT NULL DEFAULT '0',
+  `SourceEntry` int NOT NULL DEFAULT '0',
   `SourceId` int NOT NULL DEFAULT '0',
-  `ElseGroup` mediumint unsigned NOT NULL DEFAULT '0',
-  `ConditionTypeOrReference` mediumint NOT NULL DEFAULT '0',
+  `ElseGroup` int unsigned NOT NULL DEFAULT '0',
+  `ConditionTypeOrReference` int NOT NULL DEFAULT '0',
   `ConditionTarget` tinyint unsigned NOT NULL DEFAULT '0',
-  `ConditionValue1` mediumint unsigned NOT NULL DEFAULT '0',
-  `ConditionValue2` mediumint unsigned NOT NULL DEFAULT '0',
-  `ConditionValue3` mediumint unsigned NOT NULL DEFAULT '0',
+  `ConditionValue1` int unsigned NOT NULL DEFAULT '0',
+  `ConditionValue2` int unsigned NOT NULL DEFAULT '0',
+  `ConditionValue3` int unsigned NOT NULL DEFAULT '0',
   `NegativeCondition` tinyint unsigned NOT NULL DEFAULT '0',
-  `ErrorType` mediumint unsigned NOT NULL DEFAULT '0',
-  `ErrorTextId` mediumint unsigned NOT NULL DEFAULT '0',
-  `ScriptName` char(64) NOT NULL DEFAULT '',
-  `Comment` varchar(255) DEFAULT NULL,
+  `ErrorType` int unsigned NOT NULL DEFAULT '0',
+  `ErrorTextId` int unsigned NOT NULL DEFAULT '0',
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Condition System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Condition System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -320,13 +320,13 @@ DROP TABLE IF EXISTS `creature`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature` (
   `guid` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier',
-  `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier',
+  `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier',
   `map` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
   `zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
   `areaId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Area Identifier',
   `spawnMask` tinyint unsigned NOT NULL DEFAULT '1',
   `phaseMask` int unsigned NOT NULL DEFAULT '1',
-  `modelid` mediumint unsigned NOT NULL DEFAULT '0',
+  `modelid` int unsigned NOT NULL DEFAULT '0',
   `equipment_id` tinyint NOT NULL DEFAULT '0',
   `position_x` float NOT NULL DEFAULT '0',
   `position_y` float NOT NULL DEFAULT '0',
@@ -334,19 +334,19 @@ CREATE TABLE `creature` (
   `orientation` float NOT NULL DEFAULT '0',
   `spawntimesecs` int unsigned NOT NULL DEFAULT '120',
   `wander_distance` float NOT NULL DEFAULT '0',
-  `currentwaypoint` mediumint unsigned NOT NULL DEFAULT '0',
+  `currentwaypoint` int unsigned NOT NULL DEFAULT '0',
   `curhealth` int unsigned NOT NULL DEFAULT '1',
   `curmana` int unsigned NOT NULL DEFAULT '0',
   `MovementType` tinyint unsigned NOT NULL DEFAULT '0',
   `npcflag` int unsigned NOT NULL DEFAULT '0',
   `unit_flags` int unsigned NOT NULL DEFAULT '0',
   `dynamicflags` int unsigned NOT NULL DEFAULT '0',
-  `ScriptName` char(64) DEFAULT '',
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci DEFAULT '',
   `VerifiedBuild` int DEFAULT '0',
   PRIMARY KEY (`guid`),
   KEY `idx_map` (`map`),
   KEY `idx_id` (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1022682 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Creature System';
+) ENGINE=InnoDB AUTO_INCREMENT=1022682 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -359,15 +359,18 @@ DROP TABLE IF EXISTS `creature_addon`;
 CREATE TABLE `creature_addon` (
   `guid` int unsigned NOT NULL DEFAULT '0',
   `path_id` int unsigned NOT NULL DEFAULT '0',
-  `mount` mediumint unsigned NOT NULL DEFAULT '0',
+  `mount` int unsigned NOT NULL DEFAULT '0',
   `MountCreatureID` int unsigned NOT NULL DEFAULT '0',
-  `bytes1` int unsigned NOT NULL DEFAULT '0',
-  `bytes2` int unsigned NOT NULL DEFAULT '1',
+  `StandState` tinyint unsigned NOT NULL DEFAULT '0',
+  `AnimTier` tinyint unsigned NOT NULL DEFAULT '0',
+  `VisFlags` tinyint unsigned NOT NULL DEFAULT '0',
+  `SheathState` tinyint unsigned NOT NULL DEFAULT '1',
+  `PvPFlags` tinyint unsigned NOT NULL DEFAULT '0',
   `emote` int unsigned NOT NULL DEFAULT '0',
   `visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0',
-  `auras` text,
+  `auras` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -390,9 +393,9 @@ CREATE TABLE `creature_classlevelstats` (
   `damage_base` float NOT NULL DEFAULT '0',
   `damage_exp1` float NOT NULL DEFAULT '0',
   `damage_exp2` float NOT NULL DEFAULT '0',
-  `comment` text,
+  `comment` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`level`,`class`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -406,7 +409,7 @@ CREATE TABLE `creature_default_trainer` (
   `CreatureId` int unsigned NOT NULL,
   `TrainerId` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`CreatureId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -417,14 +420,14 @@ DROP TABLE IF EXISTS `creature_equip_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_equip_template` (
-  `CreatureID` mediumint unsigned NOT NULL DEFAULT '0',
+  `CreatureID` int unsigned NOT NULL DEFAULT '0',
   `ID` tinyint unsigned NOT NULL DEFAULT '1',
-  `ItemID1` mediumint unsigned NOT NULL DEFAULT '0',
-  `ItemID2` mediumint unsigned NOT NULL DEFAULT '0',
-  `ItemID3` mediumint unsigned NOT NULL DEFAULT '0',
+  `ItemID1` int unsigned NOT NULL DEFAULT '0',
+  `ItemID2` int unsigned NOT NULL DEFAULT '0',
+  `ItemID3` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`CreatureID`,`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -443,7 +446,7 @@ CREATE TABLE `creature_formations` (
   `point_1` smallint unsigned NOT NULL DEFAULT '0',
   `point_2` smallint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`memberGUID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -454,18 +457,18 @@ DROP TABLE IF EXISTS `creature_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -476,13 +479,13 @@ DROP TABLE IF EXISTS `creature_model_info`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_model_info` (
-  `DisplayID` mediumint unsigned NOT NULL DEFAULT '0',
+  `DisplayID` int unsigned NOT NULL DEFAULT '0',
   `BoundingRadius` float NOT NULL DEFAULT '0',
   `CombatReach` float NOT NULL DEFAULT '0',
   `Gender` tinyint unsigned NOT NULL DEFAULT '2',
-  `DisplayID_Other_Gender` mediumint unsigned NOT NULL DEFAULT '0',
+  `DisplayID_Other_Gender` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`DisplayID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Creature System (Model related info)';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System (Model related info)';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -497,7 +500,7 @@ CREATE TABLE `creature_movement_info` (
   `WalkSpeed` float unsigned DEFAULT NULL,
   `RunSpeed` float unsigned DEFAULT NULL,
   PRIMARY KEY (`MovementID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -517,7 +520,7 @@ CREATE TABLE `creature_movement_override` (
   `Random` tinyint unsigned DEFAULT NULL,
   `InteractionPauseTimer` int unsigned DEFAULT NULL COMMENT 'Time (in milliseconds) during which creature will not move after interaction with player',
   PRIMARY KEY (`SpawnId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -528,18 +531,18 @@ DROP TABLE IF EXISTS `creature_onkill_reputation`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_onkill_reputation` (
-  `creature_id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier',
+  `creature_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier',
   `RewOnKillRepFaction1` smallint NOT NULL DEFAULT '0',
   `RewOnKillRepFaction2` smallint NOT NULL DEFAULT '0',
   `MaxStanding1` tinyint NOT NULL DEFAULT '0',
   `IsTeamAward1` tinyint NOT NULL DEFAULT '0',
-  `RewOnKillRepValue1` mediumint NOT NULL DEFAULT '0',
+  `RewOnKillRepValue1` int NOT NULL DEFAULT '0',
   `MaxStanding2` tinyint NOT NULL DEFAULT '0',
   `IsTeamAward2` tinyint NOT NULL DEFAULT '0',
-  `RewOnKillRepValue2` mediumint NOT NULL DEFAULT '0',
+  `RewOnKillRepValue2` int NOT NULL DEFAULT '0',
   `TeamDependent` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`creature_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Creature OnKill Reputation gain';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature OnKill Reputation gain';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -550,10 +553,10 @@ DROP TABLE IF EXISTS `creature_questender`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_questender` (
-  `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
-  `quest` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
+  `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
+  `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
   PRIMARY KEY (`id`,`quest`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Creature System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -569,7 +572,7 @@ CREATE TABLE `creature_questitem` (
   `ItemId` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` smallint NOT NULL DEFAULT '0',
   PRIMARY KEY (`CreatureEntry`,`Idx`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -580,10 +583,10 @@ DROP TABLE IF EXISTS `creature_queststarter`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_queststarter` (
-  `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
-  `quest` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
+  `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
+  `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
   PRIMARY KEY (`id`,`quest`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Creature System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -594,18 +597,18 @@ DROP TABLE IF EXISTS `creature_summon_groups`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_summon_groups` (
-  `summonerId` mediumint unsigned NOT NULL DEFAULT '0',
+  `summonerId` int unsigned NOT NULL DEFAULT '0',
   `summonerType` tinyint unsigned NOT NULL DEFAULT '0',
   `groupId` tinyint unsigned NOT NULL DEFAULT '0',
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
   `position_x` float NOT NULL DEFAULT '0',
   `position_y` float NOT NULL DEFAULT '0',
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float NOT NULL DEFAULT '0',
   `summonType` tinyint unsigned NOT NULL DEFAULT '0',
   `summonTime` int unsigned NOT NULL DEFAULT '0',
-  `Comment` varchar(255) NOT NULL DEFAULT ''
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -616,20 +619,20 @@ DROP TABLE IF EXISTS `creature_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_template` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `difficulty_entry_1` mediumint unsigned NOT NULL DEFAULT '0',
-  `difficulty_entry_2` mediumint unsigned NOT NULL DEFAULT '0',
-  `difficulty_entry_3` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
+  `difficulty_entry_1` int unsigned NOT NULL DEFAULT '0',
+  `difficulty_entry_2` int unsigned NOT NULL DEFAULT '0',
+  `difficulty_entry_3` int unsigned NOT NULL DEFAULT '0',
   `KillCredit1` int unsigned NOT NULL DEFAULT '0',
   `KillCredit2` int unsigned NOT NULL DEFAULT '0',
-  `modelid1` mediumint unsigned NOT NULL DEFAULT '0',
-  `modelid2` mediumint unsigned NOT NULL DEFAULT '0',
-  `modelid3` mediumint unsigned NOT NULL DEFAULT '0',
-  `modelid4` mediumint unsigned NOT NULL DEFAULT '0',
-  `name` char(100) NOT NULL DEFAULT '0',
-  `subname` char(100) DEFAULT NULL,
-  `IconName` char(100) DEFAULT NULL,
-  `gossip_menu_id` mediumint unsigned NOT NULL DEFAULT '0',
+  `modelid1` int unsigned NOT NULL DEFAULT '0',
+  `modelid2` int unsigned NOT NULL DEFAULT '0',
+  `modelid3` int unsigned NOT NULL DEFAULT '0',
+  `modelid4` int unsigned NOT NULL DEFAULT '0',
+  `name` char(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
+  `subname` char(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `IconName` char(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `gossip_menu_id` int unsigned NOT NULL DEFAULT '0',
   `minlevel` tinyint unsigned NOT NULL DEFAULT '1',
   `maxlevel` tinyint unsigned NOT NULL DEFAULT '1',
   `exp` smallint NOT NULL DEFAULT '0',
@@ -651,14 +654,14 @@ CREATE TABLE `creature_template` (
   `family` tinyint NOT NULL DEFAULT '0',
   `type` tinyint unsigned NOT NULL DEFAULT '0',
   `type_flags` int unsigned NOT NULL DEFAULT '0',
-  `lootid` mediumint unsigned NOT NULL DEFAULT '0',
-  `pickpocketloot` mediumint unsigned NOT NULL DEFAULT '0',
-  `skinloot` mediumint unsigned NOT NULL DEFAULT '0',
-  `PetSpellDataId` mediumint unsigned NOT NULL DEFAULT '0',
-  `VehicleId` mediumint unsigned NOT NULL DEFAULT '0',
-  `mingold` mediumint unsigned NOT NULL DEFAULT '0',
-  `maxgold` mediumint unsigned NOT NULL DEFAULT '0',
-  `AIName` char(64) NOT NULL DEFAULT '',
+  `lootid` int unsigned NOT NULL DEFAULT '0',
+  `pickpocketloot` int unsigned NOT NULL DEFAULT '0',
+  `skinloot` int unsigned NOT NULL DEFAULT '0',
+  `PetSpellDataId` int unsigned NOT NULL DEFAULT '0',
+  `VehicleId` int unsigned NOT NULL DEFAULT '0',
+  `mingold` int unsigned NOT NULL DEFAULT '0',
+  `maxgold` int unsigned NOT NULL DEFAULT '0',
+  `AIName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `MovementType` tinyint unsigned NOT NULL DEFAULT '0',
   `HoverHeight` float NOT NULL DEFAULT '1',
   `HealthModifier` float NOT NULL DEFAULT '1',
@@ -672,11 +675,11 @@ CREATE TABLE `creature_template` (
   `mechanic_immune_mask` int unsigned NOT NULL DEFAULT '0',
   `spell_school_immune_mask` int unsigned NOT NULL DEFAULT '0',
   `flags_extra` int unsigned NOT NULL DEFAULT '0',
-  `ScriptName` char(64) NOT NULL DEFAULT '',
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`entry`),
   KEY `idx_name` (`name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Creature System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -687,17 +690,20 @@ DROP TABLE IF EXISTS `creature_template_addon`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_template_addon` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
   `path_id` int unsigned NOT NULL DEFAULT '0',
-  `mount` mediumint unsigned NOT NULL DEFAULT '0',
+  `mount` int unsigned NOT NULL DEFAULT '0',
   `MountCreatureID` int unsigned NOT NULL DEFAULT '0',
-  `bytes1` int unsigned NOT NULL DEFAULT '0',
-  `bytes2` int unsigned NOT NULL DEFAULT '1',
-  `emote` mediumint unsigned NOT NULL DEFAULT '0',
+  `StandState` tinyint unsigned NOT NULL DEFAULT '0',
+  `AnimTier` tinyint unsigned NOT NULL DEFAULT '0',
+  `VisFlags` tinyint unsigned NOT NULL DEFAULT '0',
+  `SheathState` tinyint unsigned NOT NULL DEFAULT '1',
+  `PvPFlags` tinyint unsigned NOT NULL DEFAULT '0',
+  `emote` int unsigned NOT NULL DEFAULT '0',
   `visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0',
-  `auras` text,
+  `auras` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -708,13 +714,13 @@ DROP TABLE IF EXISTS `creature_template_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_template_locale` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `Name` text,
-  `Title` text,
+  `entry` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name` mediumtext COLLATE utf8mb4_unicode_ci,
+  `Title` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`entry`,`locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -734,7 +740,7 @@ CREATE TABLE `creature_template_movement` (
   `Random` tinyint unsigned DEFAULT NULL,
   `InteractionPauseTimer` int unsigned DEFAULT NULL COMMENT 'Time (in milliseconds) during which creature will not move after interaction with player',
   PRIMARY KEY (`CreatureId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -745,12 +751,12 @@ DROP TABLE IF EXISTS `creature_template_resistance`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_template_resistance` (
-  `CreatureID` mediumint unsigned NOT NULL,
+  `CreatureID` int unsigned NOT NULL,
   `School` tinyint unsigned NOT NULL,
   `Resistance` smallint DEFAULT NULL,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`CreatureID`,`School`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -761,12 +767,12 @@ DROP TABLE IF EXISTS `creature_template_spell`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_template_spell` (
-  `CreatureID` mediumint unsigned NOT NULL,
+  `CreatureID` int unsigned NOT NULL,
   `Index` tinyint unsigned NOT NULL DEFAULT '0',
-  `Spell` mediumint unsigned DEFAULT NULL,
+  `Spell` int unsigned NOT NULL,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`CreatureID`,`Index`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -777,21 +783,21 @@ DROP TABLE IF EXISTS `creature_text`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_text` (
-  `CreatureID` mediumint unsigned NOT NULL DEFAULT '0',
+  `CreatureID` int unsigned NOT NULL DEFAULT '0',
   `GroupID` tinyint unsigned NOT NULL DEFAULT '0',
   `ID` tinyint unsigned NOT NULL DEFAULT '0',
-  `Text` longtext,
+  `Text` longtext COLLATE utf8mb4_unicode_ci,
   `Type` tinyint unsigned NOT NULL DEFAULT '0',
   `Language` tinyint NOT NULL DEFAULT '0',
   `Probability` float unsigned NOT NULL DEFAULT '0',
-  `Emote` mediumint unsigned NOT NULL DEFAULT '0',
-  `Duration` mediumint unsigned NOT NULL DEFAULT '0',
-  `Sound` mediumint unsigned NOT NULL DEFAULT '0',
-  `BroadcastTextId` mediumint NOT NULL DEFAULT '0',
+  `Emote` int unsigned NOT NULL DEFAULT '0',
+  `Duration` int unsigned NOT NULL DEFAULT '0',
+  `Sound` int unsigned NOT NULL DEFAULT '0',
+  `BroadcastTextId` int NOT NULL DEFAULT '0',
   `TextRange` tinyint unsigned NOT NULL DEFAULT '0',
-  `comment` varchar(255) DEFAULT '',
+  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
   PRIMARY KEY (`CreatureID`,`GroupID`,`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -802,13 +808,13 @@ DROP TABLE IF EXISTS `creature_text_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_text_locale` (
-  `CreatureID` mediumint unsigned NOT NULL DEFAULT '0',
+  `CreatureID` int unsigned NOT NULL DEFAULT '0',
   `GroupID` tinyint unsigned NOT NULL DEFAULT '0',
   `ID` tinyint unsigned NOT NULL DEFAULT '0',
-  `Locale` varchar(4) NOT NULL,
-  `Text` text,
+  `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`CreatureID`,`GroupID`,`ID`,`Locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -822,11 +828,11 @@ CREATE TABLE `disables` (
   `sourceType` int unsigned NOT NULL,
   `entry` int unsigned NOT NULL,
   `flags` smallint NOT NULL,
-  `params_0` varchar(255) NOT NULL DEFAULT '',
-  `params_1` varchar(255) NOT NULL DEFAULT '',
-  `comment` varchar(255) NOT NULL DEFAULT '',
+  `params_0` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `params_1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`sourceType`,`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -837,18 +843,18 @@ DROP TABLE IF EXISTS `disenchant_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `disenchant_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -859,18 +865,18 @@ DROP TABLE IF EXISTS `event_scripts`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `event_scripts` (
-  `id` mediumint unsigned NOT NULL DEFAULT '0',
+  `id` int unsigned NOT NULL DEFAULT '0',
   `delay` int unsigned NOT NULL DEFAULT '0',
-  `command` mediumint unsigned NOT NULL DEFAULT '0',
-  `datalong` mediumint 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 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',
-  `Comment` varchar(255) NOT NULL DEFAULT ''
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -882,9 +888,9 @@ DROP TABLE IF EXISTS `exploration_basexp`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `exploration_basexp` (
   `level` tinyint unsigned NOT NULL DEFAULT '0',
-  `basexp` mediumint NOT NULL DEFAULT '0',
+  `basexp` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`level`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Exploration System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Exploration System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -895,18 +901,18 @@ DROP TABLE IF EXISTS `fishing_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `fishing_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -922,13 +928,13 @@ CREATE TABLE `game_event` (
   `end_time` timestamp NULL DEFAULT NULL COMMENT 'Absolute end date, the event will never start after',
   `occurence` bigint unsigned NOT NULL DEFAULT '5184000' COMMENT 'Delay in minutes between occurences of the event',
   `length` bigint unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event',
-  `holiday` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id',
+  `holiday` int unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id',
   `holidayStage` tinyint unsigned NOT NULL DEFAULT '0',
-  `description` varchar(255) DEFAULT NULL COMMENT 'Description of the event displayed in console',
+  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the event displayed in console',
   `world_event` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0 if normal event, 1 if world event',
   `announce` tinyint unsigned DEFAULT '2' COMMENT '0 dont announce, 1 announce, 2 value from config',
   PRIMARY KEY (`eventEntry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -942,7 +948,7 @@ CREATE TABLE `game_event_arena_seasons` (
   `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event',
   `season` tinyint unsigned NOT NULL COMMENT 'Arena season number',
   UNIQUE KEY `season` (`season`,`eventEntry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -956,7 +962,7 @@ CREATE TABLE `game_event_battleground_holiday` (
   `EventEntry` tinyint unsigned NOT NULL COMMENT 'game_event EventEntry identifier',
   `BattlegroundID` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`EventEntry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -968,13 +974,13 @@ DROP TABLE IF EXISTS `game_event_condition`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_event_condition` (
   `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event',
-  `condition_id` mediumint unsigned NOT NULL DEFAULT '0',
+  `condition_id` int unsigned NOT NULL DEFAULT '0',
   `req_num` float DEFAULT '0',
   `max_world_state_field` smallint unsigned NOT NULL DEFAULT '0',
   `done_world_state_field` smallint unsigned NOT NULL DEFAULT '0',
-  `description` varchar(25) NOT NULL DEFAULT '',
+  `description` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`eventEntry`,`condition_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -988,7 +994,7 @@ CREATE TABLE `game_event_creature` (
   `eventEntry` tinyint NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.',
   `guid` int unsigned NOT NULL,
   PRIMARY KEY (`guid`,`eventEntry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1000,10 +1006,10 @@ DROP TABLE IF EXISTS `game_event_creature_quest`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_event_creature_quest` (
   `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event.',
-  `id` mediumint unsigned NOT NULL DEFAULT '0',
-  `quest` mediumint unsigned NOT NULL DEFAULT '0',
+  `id` int unsigned NOT NULL DEFAULT '0',
+  `quest` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`quest`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1017,7 +1023,7 @@ CREATE TABLE `game_event_gameobject` (
   `eventEntry` tinyint NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.',
   `guid` int unsigned NOT NULL,
   PRIMARY KEY (`guid`,`eventEntry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1029,10 +1035,10 @@ DROP TABLE IF EXISTS `game_event_gameobject_quest`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_event_gameobject_quest` (
   `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event',
-  `id` mediumint unsigned NOT NULL DEFAULT '0',
-  `quest` mediumint unsigned NOT NULL DEFAULT '0',
+  `id` int unsigned NOT NULL DEFAULT '0',
+  `quest` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`quest`,`eventEntry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1045,10 +1051,10 @@ DROP TABLE IF EXISTS `game_event_model_equip`;
 CREATE TABLE `game_event_model_equip` (
   `eventEntry` tinyint NOT NULL COMMENT 'Entry of the game event.',
   `guid` int unsigned NOT NULL DEFAULT '0',
-  `modelid` mediumint unsigned NOT NULL DEFAULT '0',
+  `modelid` int unsigned NOT NULL DEFAULT '0',
   `equipment_id` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1060,15 +1066,15 @@ DROP TABLE IF EXISTS `game_event_npc_vendor`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_event_npc_vendor` (
   `eventEntry` tinyint NOT NULL COMMENT 'Entry of the game event.',
-  `guid` mediumint unsigned NOT NULL DEFAULT '0',
+  `guid` int unsigned NOT NULL DEFAULT '0',
   `slot` smallint NOT NULL DEFAULT '0',
-  `item` mediumint unsigned NOT NULL DEFAULT '0',
-  `maxcount` mediumint unsigned NOT NULL DEFAULT '0',
-  `incrtime` mediumint unsigned NOT NULL DEFAULT '0',
-  `ExtendedCost` mediumint unsigned NOT NULL DEFAULT '0',
+  `item` int unsigned NOT NULL DEFAULT '0',
+  `maxcount` int unsigned NOT NULL DEFAULT '0',
+  `incrtime` int unsigned NOT NULL DEFAULT '0',
+  `ExtendedCost` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`item`),
   KEY `slot` (`slot`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1080,10 +1086,10 @@ DROP TABLE IF EXISTS `game_event_npcflag`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_event_npcflag` (
   `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event',
-  `guid` mediumint unsigned NOT NULL DEFAULT '0',
+  `guid` int unsigned NOT NULL DEFAULT '0',
   `npcflag` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`eventEntry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1095,9 +1101,9 @@ DROP TABLE IF EXISTS `game_event_pool`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_event_pool` (
   `eventEntry` tinyint NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.',
-  `pool_entry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Id of the pool',
+  `pool_entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Id of the pool',
   PRIMARY KEY (`pool_entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1109,9 +1115,9 @@ DROP TABLE IF EXISTS `game_event_prerequisite`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_event_prerequisite` (
   `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event',
-  `prerequisite_event` mediumint unsigned NOT NULL,
+  `prerequisite_event` int unsigned NOT NULL,
   PRIMARY KEY (`eventEntry`,`prerequisite_event`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1123,11 +1129,11 @@ DROP TABLE IF EXISTS `game_event_quest_condition`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_event_quest_condition` (
   `eventEntry` tinyint unsigned NOT NULL COMMENT 'Entry of the game event.',
-  `quest` mediumint unsigned NOT NULL DEFAULT '0',
-  `condition_id` mediumint unsigned NOT NULL DEFAULT '0',
+  `quest` int unsigned NOT NULL DEFAULT '0',
+  `condition_id` int unsigned NOT NULL DEFAULT '0',
   `num` float DEFAULT '0',
   PRIMARY KEY (`quest`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1139,10 +1145,10 @@ DROP TABLE IF EXISTS `game_event_seasonal_questrelation`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_event_seasonal_questrelation` (
   `questId` int unsigned NOT NULL COMMENT 'Quest Identifier',
-  `eventEntry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of the game event',
+  `eventEntry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of the game event',
   PRIMARY KEY (`questId`,`eventEntry`),
   KEY `idx_quest` (`questId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Player System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1153,15 +1159,15 @@ DROP TABLE IF EXISTS `game_tele`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_tele` (
-  `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
+  `id` int unsigned NOT NULL,
   `position_x` float NOT NULL DEFAULT '0',
   `position_y` float NOT NULL DEFAULT '0',
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float NOT NULL DEFAULT '0',
   `map` smallint unsigned NOT NULL DEFAULT '0',
-  `name` varchar(100) NOT NULL DEFAULT '',
+  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1517 DEFAULT CHARSET=utf8mb3 COMMENT='Tele Command';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1172,7 +1178,7 @@ DROP TABLE IF EXISTS `game_weather`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `game_weather` (
-  `zone` mediumint unsigned NOT NULL DEFAULT '0',
+  `zone` int unsigned NOT NULL DEFAULT '0',
   `spring_rain_chance` tinyint unsigned NOT NULL DEFAULT '25',
   `spring_snow_chance` tinyint unsigned NOT NULL DEFAULT '25',
   `spring_storm_chance` tinyint unsigned NOT NULL DEFAULT '25',
@@ -1185,9 +1191,9 @@ CREATE TABLE `game_weather` (
   `winter_rain_chance` tinyint unsigned NOT NULL DEFAULT '25',
   `winter_snow_chance` tinyint unsigned NOT NULL DEFAULT '25',
   `winter_storm_chance` tinyint unsigned NOT NULL DEFAULT '25',
-  `ScriptName` char(64) NOT NULL DEFAULT '',
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`zone`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Weather System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Weather System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1199,7 +1205,7 @@ DROP TABLE IF EXISTS `gameobject`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gameobject` (
   `guid` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier',
-  `id` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Gameobject Identifier',
+  `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Gameobject Identifier',
   `map` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
   `zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
   `areaId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Area Identifier',
@@ -1216,10 +1222,10 @@ CREATE TABLE `gameobject` (
   `spawntimesecs` int NOT NULL DEFAULT '0',
   `animprogress` tinyint unsigned NOT NULL DEFAULT '0',
   `state` tinyint unsigned NOT NULL DEFAULT '0',
-  `ScriptName` char(64) DEFAULT '',
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci DEFAULT '',
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`guid`)
-) ENGINE=MyISAM AUTO_INCREMENT=255094 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Gameobject System';
+) ENGINE=InnoDB AUTO_INCREMENT=2134507 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1238,7 +1244,7 @@ CREATE TABLE `gameobject_addon` (
   `invisibilityType` tinyint unsigned NOT NULL DEFAULT '0',
   `invisibilityValue` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1249,18 +1255,18 @@ DROP TABLE IF EXISTS `gameobject_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gameobject_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1275,7 +1281,7 @@ CREATE TABLE `gameobject_overrides` (
   `faction` smallint unsigned NOT NULL DEFAULT '0',
   `flags` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`spawnId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1286,10 +1292,10 @@ DROP TABLE IF EXISTS `gameobject_questender`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gameobject_questender` (
-  `id` mediumint unsigned NOT NULL DEFAULT '0',
-  `quest` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
+  `id` int unsigned NOT NULL DEFAULT '0',
+  `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
   PRIMARY KEY (`id`,`quest`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1305,7 +1311,7 @@ CREATE TABLE `gameobject_questitem` (
   `ItemId` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` smallint NOT NULL DEFAULT '0',
   PRIMARY KEY (`GameObjectEntry`,`Idx`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1316,10 +1322,10 @@ DROP TABLE IF EXISTS `gameobject_queststarter`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gameobject_queststarter` (
-  `id` mediumint unsigned NOT NULL DEFAULT '0',
-  `quest` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
+  `id` int unsigned NOT NULL DEFAULT '0',
+  `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
   PRIMARY KEY (`id`,`quest`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1330,13 +1336,13 @@ DROP TABLE IF EXISTS `gameobject_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gameobject_template` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
   `type` tinyint unsigned NOT NULL DEFAULT '0',
-  `displayId` mediumint unsigned NOT NULL DEFAULT '0',
-  `name` varchar(100) NOT NULL DEFAULT '',
-  `IconName` varchar(100) NOT NULL DEFAULT '',
-  `castBarCaption` varchar(100) NOT NULL DEFAULT '',
-  `unk1` varchar(100) NOT NULL DEFAULT '',
+  `displayId` int unsigned NOT NULL DEFAULT '0',
+  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `IconName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `castBarCaption` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `unk1` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `size` float NOT NULL DEFAULT '1',
   `Data0` int unsigned NOT NULL DEFAULT '0',
   `Data1` int NOT NULL DEFAULT '0',
@@ -1362,12 +1368,12 @@ CREATE TABLE `gameobject_template` (
   `Data21` int unsigned NOT NULL DEFAULT '0',
   `Data22` int unsigned NOT NULL DEFAULT '0',
   `Data23` int unsigned NOT NULL DEFAULT '0',
-  `AIName` char(64) NOT NULL DEFAULT '',
-  `ScriptName` varchar(64) NOT NULL DEFAULT '',
+  `AIName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`entry`),
   KEY `idx_name` (`name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Gameobject System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1378,17 +1384,17 @@ DROP TABLE IF EXISTS `gameobject_template_addon`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gameobject_template_addon` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
   `faction` smallint unsigned NOT NULL DEFAULT '0',
   `flags` int unsigned NOT NULL DEFAULT '0',
-  `mingold` mediumint unsigned NOT NULL DEFAULT '0',
-  `maxgold` mediumint unsigned NOT NULL DEFAULT '0',
+  `mingold` int unsigned NOT NULL DEFAULT '0',
+  `maxgold` int unsigned NOT NULL DEFAULT '0',
   `artkit0` int NOT NULL DEFAULT '0',
   `artkit1` int NOT NULL DEFAULT '0',
   `artkit2` int NOT NULL DEFAULT '0',
   `artkit3` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1399,13 +1405,13 @@ DROP TABLE IF EXISTS `gameobject_template_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gameobject_template_locale` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `name` text,
-  `castBarCaption` text,
+  `entry` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `name` mediumtext COLLATE utf8mb4_unicode_ci,
+  `castBarCaption` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`entry`,`locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1417,10 +1423,10 @@ DROP TABLE IF EXISTS `gossip_menu`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gossip_menu` (
   `MenuID` smallint unsigned NOT NULL DEFAULT '0',
-  `TextID` mediumint unsigned NOT NULL DEFAULT '0',
+  `TextID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`MenuID`,`TextID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1433,20 +1439,20 @@ DROP TABLE IF EXISTS `gossip_menu_option`;
 CREATE TABLE `gossip_menu_option` (
   `MenuID` smallint unsigned NOT NULL DEFAULT '0',
   `OptionID` smallint unsigned NOT NULL DEFAULT '0',
-  `OptionIcon` mediumint unsigned NOT NULL DEFAULT '0',
-  `OptionText` text,
-  `OptionBroadcastTextID` mediumint NOT NULL DEFAULT '0',
+  `OptionIcon` int unsigned NOT NULL DEFAULT '0',
+  `OptionText` mediumtext COLLATE utf8mb4_unicode_ci,
+  `OptionBroadcastTextID` int NOT NULL DEFAULT '0',
   `OptionType` tinyint unsigned NOT NULL DEFAULT '0',
   `OptionNpcFlag` int unsigned NOT NULL DEFAULT '0',
   `ActionMenuID` int unsigned NOT NULL DEFAULT '0',
-  `ActionPoiID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ActionPoiID` int unsigned NOT NULL DEFAULT '0',
   `BoxCoded` tinyint unsigned NOT NULL DEFAULT '0',
   `BoxMoney` int unsigned NOT NULL DEFAULT '0',
-  `BoxText` text,
-  `BoxBroadcastTextID` mediumint NOT NULL DEFAULT '0',
+  `BoxText` mediumtext COLLATE utf8mb4_unicode_ci,
+  `BoxBroadcastTextID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`MenuID`,`OptionID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1459,11 +1465,11 @@ DROP TABLE IF EXISTS `gossip_menu_option_locale`;
 CREATE TABLE `gossip_menu_option_locale` (
   `MenuID` smallint unsigned NOT NULL DEFAULT '0',
   `OptionID` smallint unsigned NOT NULL DEFAULT '0',
-  `Locale` varchar(4) NOT NULL,
-  `OptionText` text,
-  `BoxText` text,
+  `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `OptionText` mediumtext COLLATE utf8mb4_unicode_ci,
+  `BoxText` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`MenuID`,`OptionID`,`Locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1474,12 +1480,12 @@ DROP TABLE IF EXISTS `graveyard_zone`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `graveyard_zone` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `GhostZone` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `GhostZone` int unsigned NOT NULL DEFAULT '0',
   `Faction` smallint unsigned NOT NULL DEFAULT '0',
-  `Comment` text,
+  `Comment` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`ID`,`GhostZone`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Trigger System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1495,7 +1501,7 @@ CREATE TABLE `holiday_dates` (
   `date_value` int unsigned NOT NULL,
   `holiday_duration` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`date_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1510,9 +1516,9 @@ CREATE TABLE `instance_encounters` (
   `creditType` tinyint unsigned NOT NULL DEFAULT '0',
   `creditEntry` int unsigned NOT NULL DEFAULT '0',
   `lastEncounterDungeon` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'If not 0, LfgDungeon.dbc entry for the instance it is last encounter in',
-  `comment` varchar(255) NOT NULL DEFAULT '',
+  `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1529,7 +1535,7 @@ CREATE TABLE `instance_spawn_groups` (
   `spawnGroupId` int unsigned NOT NULL,
   `flags` tinyint unsigned NOT NULL,
   PRIMARY KEY (`instanceMapId`,`bossStateId`,`spawnGroupId`,`bossStates`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1542,10 +1548,10 @@ DROP TABLE IF EXISTS `instance_template`;
 CREATE TABLE `instance_template` (
   `map` smallint unsigned NOT NULL,
   `parent` smallint unsigned NOT NULL,
-  `script` varchar(128) NOT NULL DEFAULT '',
+  `script` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `allowMount` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`map`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1556,11 +1562,11 @@ DROP TABLE IF EXISTS `item_enchantment_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_enchantment_template` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `ench` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
+  `ench` int unsigned NOT NULL DEFAULT '0',
   `chance` float unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`entry`,`ench`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Item Random Enchantment System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Random Enchantment System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1571,18 +1577,18 @@ DROP TABLE IF EXISTS `item_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1593,12 +1599,12 @@ DROP TABLE IF EXISTS `item_set_names`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_set_names` (
-  `entry` mediumint unsigned NOT NULL,
-  `name` varchar(255) NOT NULL DEFAULT '',
+  `entry` int unsigned NOT NULL,
+  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `InventoryType` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1609,12 +1615,12 @@ DROP TABLE IF EXISTS `item_set_names_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_set_names_locale` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `Name` text,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1625,12 +1631,12 @@ DROP TABLE IF EXISTS `item_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_template` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
   `class` tinyint unsigned NOT NULL DEFAULT '0',
   `subclass` tinyint unsigned NOT NULL DEFAULT '0',
   `SoundOverrideSubclass` tinyint NOT NULL DEFAULT '-1',
-  `name` varchar(255) NOT NULL DEFAULT '',
-  `displayid` mediumint unsigned NOT NULL DEFAULT '0',
+  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `displayid` int unsigned NOT NULL DEFAULT '0',
   `Quality` tinyint unsigned NOT NULL DEFAULT '0',
   `Flags` int unsigned NOT NULL DEFAULT '0',
   `FlagsExtra` int unsigned NOT NULL DEFAULT '0',
@@ -1644,9 +1650,9 @@ CREATE TABLE `item_template` (
   `RequiredLevel` tinyint unsigned NOT NULL DEFAULT '0',
   `RequiredSkill` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredSkillRank` smallint unsigned NOT NULL DEFAULT '0',
-  `requiredspell` mediumint unsigned NOT NULL DEFAULT '0',
-  `requiredhonorrank` mediumint unsigned NOT NULL DEFAULT '0',
-  `RequiredCityRank` mediumint unsigned NOT NULL DEFAULT '0',
+  `requiredspell` int unsigned NOT NULL DEFAULT '0',
+  `requiredhonorrank` int unsigned NOT NULL DEFAULT '0',
+  `RequiredCityRank` int unsigned NOT NULL DEFAULT '0',
   `RequiredReputationFaction` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredReputationRank` smallint unsigned NOT NULL DEFAULT '0',
   `maxcount` int NOT NULL DEFAULT '0',
@@ -1691,35 +1697,35 @@ CREATE TABLE `item_template` (
   `delay` smallint unsigned NOT NULL DEFAULT '1000',
   `ammo_type` tinyint unsigned NOT NULL DEFAULT '0',
   `RangedModRange` float NOT NULL DEFAULT '0',
-  `spellid_1` mediumint NOT NULL DEFAULT '0',
+  `spellid_1` int NOT NULL DEFAULT '0',
   `spelltrigger_1` tinyint unsigned NOT NULL DEFAULT '0',
   `spellcharges_1` smallint NOT NULL DEFAULT '0',
   `spellppmRate_1` float NOT NULL DEFAULT '0',
   `spellcooldown_1` int NOT NULL DEFAULT '-1',
   `spellcategory_1` smallint unsigned NOT NULL DEFAULT '0',
   `spellcategorycooldown_1` int NOT NULL DEFAULT '-1',
-  `spellid_2` mediumint NOT NULL DEFAULT '0',
+  `spellid_2` int NOT NULL DEFAULT '0',
   `spelltrigger_2` tinyint unsigned NOT NULL DEFAULT '0',
   `spellcharges_2` smallint NOT NULL DEFAULT '0',
   `spellppmRate_2` float NOT NULL DEFAULT '0',
   `spellcooldown_2` int NOT NULL DEFAULT '-1',
   `spellcategory_2` smallint unsigned NOT NULL DEFAULT '0',
   `spellcategorycooldown_2` int NOT NULL DEFAULT '-1',
-  `spellid_3` mediumint NOT NULL DEFAULT '0',
+  `spellid_3` int NOT NULL DEFAULT '0',
   `spelltrigger_3` tinyint unsigned NOT NULL DEFAULT '0',
   `spellcharges_3` smallint NOT NULL DEFAULT '0',
   `spellppmRate_3` float NOT NULL DEFAULT '0',
   `spellcooldown_3` int NOT NULL DEFAULT '-1',
   `spellcategory_3` smallint unsigned NOT NULL DEFAULT '0',
   `spellcategorycooldown_3` int NOT NULL DEFAULT '-1',
-  `spellid_4` mediumint NOT NULL DEFAULT '0',
+  `spellid_4` int NOT NULL DEFAULT '0',
   `spelltrigger_4` tinyint unsigned NOT NULL DEFAULT '0',
   `spellcharges_4` smallint NOT NULL DEFAULT '0',
   `spellppmRate_4` float NOT NULL DEFAULT '0',
   `spellcooldown_4` int NOT NULL DEFAULT '-1',
   `spellcategory_4` smallint unsigned NOT NULL DEFAULT '0',
   `spellcategorycooldown_4` int NOT NULL DEFAULT '-1',
-  `spellid_5` mediumint NOT NULL DEFAULT '0',
+  `spellid_5` int NOT NULL DEFAULT '0',
   `spelltrigger_5` tinyint unsigned NOT NULL DEFAULT '0',
   `spellcharges_5` smallint NOT NULL DEFAULT '0',
   `spellppmRate_5` float NOT NULL DEFAULT '0',
@@ -1727,38 +1733,38 @@ CREATE TABLE `item_template` (
   `spellcategory_5` smallint unsigned NOT NULL DEFAULT '0',
   `spellcategorycooldown_5` int NOT NULL DEFAULT '-1',
   `bonding` tinyint unsigned NOT NULL DEFAULT '0',
-  `description` varchar(255) NOT NULL DEFAULT '',
-  `PageText` mediumint unsigned NOT NULL DEFAULT '0',
+  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `PageText` int unsigned NOT NULL DEFAULT '0',
   `LanguageID` tinyint unsigned NOT NULL DEFAULT '0',
   `PageMaterial` tinyint unsigned NOT NULL DEFAULT '0',
-  `startquest` mediumint unsigned NOT NULL DEFAULT '0',
-  `lockid` mediumint unsigned NOT NULL DEFAULT '0',
+  `startquest` int unsigned NOT NULL DEFAULT '0',
+  `lockid` int unsigned NOT NULL DEFAULT '0',
   `Material` tinyint NOT NULL DEFAULT '0',
   `sheath` tinyint unsigned NOT NULL DEFAULT '0',
-  `RandomProperty` mediumint NOT NULL DEFAULT '0',
-  `RandomSuffix` mediumint unsigned NOT NULL DEFAULT '0',
-  `block` mediumint unsigned NOT NULL DEFAULT '0',
-  `itemset` mediumint unsigned NOT NULL DEFAULT '0',
+  `RandomProperty` int NOT NULL DEFAULT '0',
+  `RandomSuffix` int unsigned NOT NULL DEFAULT '0',
+  `block` int unsigned NOT NULL DEFAULT '0',
+  `itemset` int unsigned NOT NULL DEFAULT '0',
   `MaxDurability` smallint unsigned NOT NULL DEFAULT '0',
-  `area` mediumint unsigned NOT NULL DEFAULT '0',
+  `area` int unsigned NOT NULL DEFAULT '0',
   `Map` smallint NOT NULL DEFAULT '0',
-  `BagFamily` mediumint NOT NULL DEFAULT '0',
-  `TotemCategory` mediumint NOT NULL DEFAULT '0',
+  `BagFamily` int NOT NULL DEFAULT '0',
+  `TotemCategory` int NOT NULL DEFAULT '0',
   `socketColor_1` tinyint NOT NULL DEFAULT '0',
-  `socketContent_1` mediumint NOT NULL DEFAULT '0',
+  `socketContent_1` int NOT NULL DEFAULT '0',
   `socketColor_2` tinyint NOT NULL DEFAULT '0',
-  `socketContent_2` mediumint NOT NULL DEFAULT '0',
+  `socketContent_2` int NOT NULL DEFAULT '0',
   `socketColor_3` tinyint NOT NULL DEFAULT '0',
-  `socketContent_3` mediumint NOT NULL DEFAULT '0',
-  `socketBonus` mediumint NOT NULL DEFAULT '0',
-  `GemProperties` mediumint NOT NULL DEFAULT '0',
+  `socketContent_3` int NOT NULL DEFAULT '0',
+  `socketBonus` int NOT NULL DEFAULT '0',
+  `GemProperties` int NOT NULL DEFAULT '0',
   `RequiredDisenchantSkill` smallint NOT NULL DEFAULT '-1',
   `ArmorDamageModifier` float NOT NULL DEFAULT '0',
   `duration` int unsigned NOT NULL DEFAULT '0',
   `ItemLimitCategory` smallint NOT NULL DEFAULT '0',
   `HolidayId` int unsigned NOT NULL DEFAULT '0',
-  `ScriptName` varchar(64) NOT NULL DEFAULT '',
-  `DisenchantID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `DisenchantID` int unsigned NOT NULL DEFAULT '0',
   `FoodType` tinyint unsigned NOT NULL DEFAULT '0',
   `minMoneyLoot` int unsigned NOT NULL DEFAULT '0',
   `maxMoneyLoot` int unsigned NOT NULL DEFAULT '0',
@@ -1767,7 +1773,7 @@ CREATE TABLE `item_template` (
   PRIMARY KEY (`entry`),
   KEY `idx_name` (`name`),
   KEY `items_index` (`class`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Item System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1778,13 +1784,13 @@ DROP TABLE IF EXISTS `item_template_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_template_locale` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `Name` text,
-  `Description` text,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name` mediumtext COLLATE utf8mb4_unicode_ci,
+  `Description` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1800,7 +1806,7 @@ CREATE TABLE `lfg_dungeon_rewards` (
   `firstQuestId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for first dungeon this day',
   `otherQuestId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for Nth dungeon this day',
   PRIMARY KEY (`dungeonId`,`maxLevel`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1812,14 +1818,14 @@ DROP TABLE IF EXISTS `lfg_dungeon_template`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `lfg_dungeon_template` (
   `dungeonId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Unique id from LFGDungeons.dbc',
-  `name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
+  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `position_x` float NOT NULL DEFAULT '0',
   `position_y` float NOT NULL DEFAULT '0',
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float NOT NULL DEFAULT '0',
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`dungeonId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1834,7 +1840,7 @@ CREATE TABLE `linked_respawn` (
   `linkedGuid` int unsigned NOT NULL COMMENT 'master creature',
   `linkType` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`guid`,`linkType`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Creature Respawn Link System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature Respawn Link System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1846,11 +1852,11 @@ DROP TABLE IF EXISTS `mail_level_reward`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `mail_level_reward` (
   `level` tinyint unsigned NOT NULL DEFAULT '0',
-  `raceMask` mediumint unsigned NOT NULL DEFAULT '0',
-  `mailTemplateId` mediumint unsigned NOT NULL DEFAULT '0',
-  `senderEntry` mediumint unsigned NOT NULL DEFAULT '0',
+  `raceMask` int unsigned NOT NULL DEFAULT '0',
+  `mailTemplateId` int unsigned NOT NULL DEFAULT '0',
+  `senderEntry` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`level`,`raceMask`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Mail System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Mail System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1861,18 +1867,18 @@ DROP TABLE IF EXISTS `mail_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `mail_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1883,18 +1889,18 @@ DROP TABLE IF EXISTS `milling_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `milling_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1910,7 +1916,7 @@ CREATE TABLE `npc_spellclick_spells` (
   `cast_flags` tinyint unsigned NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit',
   `user_type` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'relation with summoner: 0-no 1-friendly 2-raid 3-party player can click',
   PRIMARY KEY (`npc_entry`,`spell_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1921,10 +1927,10 @@ DROP TABLE IF EXISTS `npc_text`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `npc_text` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `text0_0` longtext,
-  `text0_1` longtext,
-  `BroadcastTextID0` mediumint NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `text0_0` longtext COLLATE utf8mb4_unicode_ci,
+  `text0_1` longtext COLLATE utf8mb4_unicode_ci,
+  `BroadcastTextID0` int NOT NULL DEFAULT '0',
   `lang0` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability0` float NOT NULL DEFAULT '0',
   `EmoteDelay0_0` smallint unsigned NOT NULL DEFAULT '0',
@@ -1933,9 +1939,9 @@ CREATE TABLE `npc_text` (
   `Emote0_1` smallint unsigned NOT NULL DEFAULT '0',
   `EmoteDelay0_2` smallint unsigned NOT NULL DEFAULT '0',
   `Emote0_2` smallint unsigned NOT NULL DEFAULT '0',
-  `text1_0` longtext,
-  `text1_1` longtext,
-  `BroadcastTextID1` mediumint NOT NULL DEFAULT '0',
+  `text1_0` longtext COLLATE utf8mb4_unicode_ci,
+  `text1_1` longtext COLLATE utf8mb4_unicode_ci,
+  `BroadcastTextID1` int NOT NULL DEFAULT '0',
   `lang1` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability1` float NOT NULL DEFAULT '0',
   `EmoteDelay1_0` smallint unsigned NOT NULL DEFAULT '0',
@@ -1944,9 +1950,9 @@ CREATE TABLE `npc_text` (
   `Emote1_1` smallint unsigned NOT NULL DEFAULT '0',
   `EmoteDelay1_2` smallint unsigned NOT NULL DEFAULT '0',
   `Emote1_2` smallint unsigned NOT NULL DEFAULT '0',
-  `text2_0` longtext,
-  `text2_1` longtext,
-  `BroadcastTextID2` mediumint NOT NULL DEFAULT '0',
+  `text2_0` longtext COLLATE utf8mb4_unicode_ci,
+  `text2_1` longtext COLLATE utf8mb4_unicode_ci,
+  `BroadcastTextID2` int NOT NULL DEFAULT '0',
   `lang2` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability2` float NOT NULL DEFAULT '0',
   `EmoteDelay2_0` smallint unsigned NOT NULL DEFAULT '0',
@@ -1955,9 +1961,9 @@ CREATE TABLE `npc_text` (
   `Emote2_1` smallint unsigned NOT NULL DEFAULT '0',
   `EmoteDelay2_2` smallint unsigned NOT NULL DEFAULT '0',
   `Emote2_2` smallint unsigned NOT NULL DEFAULT '0',
-  `text3_0` longtext,
-  `text3_1` longtext,
-  `BroadcastTextID3` mediumint NOT NULL DEFAULT '0',
+  `text3_0` longtext COLLATE utf8mb4_unicode_ci,
+  `text3_1` longtext COLLATE utf8mb4_unicode_ci,
+  `BroadcastTextID3` int NOT NULL DEFAULT '0',
   `lang3` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability3` float NOT NULL DEFAULT '0',
   `EmoteDelay3_0` smallint unsigned NOT NULL DEFAULT '0',
@@ -1966,9 +1972,9 @@ CREATE TABLE `npc_text` (
   `Emote3_1` smallint unsigned NOT NULL DEFAULT '0',
   `EmoteDelay3_2` smallint unsigned NOT NULL DEFAULT '0',
   `Emote3_2` smallint unsigned NOT NULL DEFAULT '0',
-  `text4_0` longtext,
-  `text4_1` longtext,
-  `BroadcastTextID4` mediumint NOT NULL DEFAULT '0',
+  `text4_0` longtext COLLATE utf8mb4_unicode_ci,
+  `text4_1` longtext COLLATE utf8mb4_unicode_ci,
+  `BroadcastTextID4` int NOT NULL DEFAULT '0',
   `lang4` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability4` float NOT NULL DEFAULT '0',
   `EmoteDelay4_0` smallint unsigned NOT NULL DEFAULT '0',
@@ -1977,9 +1983,9 @@ CREATE TABLE `npc_text` (
   `Emote4_1` smallint unsigned NOT NULL DEFAULT '0',
   `EmoteDelay4_2` smallint unsigned NOT NULL DEFAULT '0',
   `Emote4_2` smallint unsigned NOT NULL DEFAULT '0',
-  `text5_0` longtext,
-  `text5_1` longtext,
-  `BroadcastTextID5` mediumint NOT NULL DEFAULT '0',
+  `text5_0` longtext COLLATE utf8mb4_unicode_ci,
+  `text5_1` longtext COLLATE utf8mb4_unicode_ci,
+  `BroadcastTextID5` int NOT NULL DEFAULT '0',
   `lang5` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability5` float NOT NULL DEFAULT '0',
   `EmoteDelay5_0` smallint unsigned NOT NULL DEFAULT '0',
@@ -1988,9 +1994,9 @@ CREATE TABLE `npc_text` (
   `Emote5_1` smallint unsigned NOT NULL DEFAULT '0',
   `EmoteDelay5_2` smallint unsigned NOT NULL DEFAULT '0',
   `Emote5_2` smallint unsigned NOT NULL DEFAULT '0',
-  `text6_0` longtext,
-  `text6_1` longtext,
-  `BroadcastTextID6` mediumint NOT NULL DEFAULT '0',
+  `text6_0` longtext COLLATE utf8mb4_unicode_ci,
+  `text6_1` longtext COLLATE utf8mb4_unicode_ci,
+  `BroadcastTextID6` int NOT NULL DEFAULT '0',
   `lang6` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability6` float NOT NULL DEFAULT '0',
   `EmoteDelay6_0` smallint unsigned NOT NULL DEFAULT '0',
@@ -1999,9 +2005,9 @@ CREATE TABLE `npc_text` (
   `Emote6_1` smallint unsigned NOT NULL DEFAULT '0',
   `EmoteDelay6_2` smallint unsigned NOT NULL DEFAULT '0',
   `Emote6_2` smallint unsigned NOT NULL DEFAULT '0',
-  `text7_0` longtext,
-  `text7_1` longtext,
-  `BroadcastTextID7` mediumint NOT NULL DEFAULT '0',
+  `text7_0` longtext COLLATE utf8mb4_unicode_ci,
+  `text7_1` longtext COLLATE utf8mb4_unicode_ci,
+  `BroadcastTextID7` int NOT NULL DEFAULT '0',
   `lang7` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability7` float NOT NULL DEFAULT '0',
   `EmoteDelay7_0` smallint unsigned NOT NULL DEFAULT '0',
@@ -2012,7 +2018,7 @@ CREATE TABLE `npc_text` (
   `Emote7_2` smallint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2023,26 +2029,26 @@ DROP TABLE IF EXISTS `npc_text_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `npc_text_locale` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `Locale` varchar(4) NOT NULL,
-  `Text0_0` longtext,
-  `Text0_1` longtext,
-  `Text1_0` longtext,
-  `Text1_1` longtext,
-  `Text2_0` longtext,
-  `Text2_1` longtext,
-  `Text3_0` longtext,
-  `Text3_1` longtext,
-  `Text4_0` longtext,
-  `Text4_1` longtext,
-  `Text5_0` longtext,
-  `Text5_1` longtext,
-  `Text6_0` longtext,
-  `Text6_1` longtext,
-  `Text7_0` longtext,
-  `Text7_1` longtext,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text0_0` longtext COLLATE utf8mb4_unicode_ci,
+  `Text0_1` longtext COLLATE utf8mb4_unicode_ci,
+  `Text1_0` longtext COLLATE utf8mb4_unicode_ci,
+  `Text1_1` longtext COLLATE utf8mb4_unicode_ci,
+  `Text2_0` longtext COLLATE utf8mb4_unicode_ci,
+  `Text2_1` longtext COLLATE utf8mb4_unicode_ci,
+  `Text3_0` longtext COLLATE utf8mb4_unicode_ci,
+  `Text3_1` longtext COLLATE utf8mb4_unicode_ci,
+  `Text4_0` longtext COLLATE utf8mb4_unicode_ci,
+  `Text4_1` longtext COLLATE utf8mb4_unicode_ci,
+  `Text5_0` longtext COLLATE utf8mb4_unicode_ci,
+  `Text5_1` longtext COLLATE utf8mb4_unicode_ci,
+  `Text6_0` longtext COLLATE utf8mb4_unicode_ci,
+  `Text6_1` longtext COLLATE utf8mb4_unicode_ci,
+  `Text7_0` longtext COLLATE utf8mb4_unicode_ci,
+  `Text7_1` longtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`ID`,`Locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2053,16 +2059,16 @@ DROP TABLE IF EXISTS `npc_vendor`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `npc_vendor` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
   `slot` smallint NOT NULL DEFAULT '0',
-  `item` mediumint NOT NULL DEFAULT '0',
+  `item` int NOT NULL DEFAULT '0',
   `maxcount` tinyint unsigned NOT NULL DEFAULT '0',
   `incrtime` int unsigned NOT NULL DEFAULT '0',
-  `ExtendedCost` mediumint unsigned NOT NULL DEFAULT '0',
+  `ExtendedCost` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`entry`,`item`,`ExtendedCost`),
   KEY `slot` (`slot`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Npc System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Npc System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2074,10 +2080,10 @@ DROP TABLE IF EXISTS `outdoorpvp_template`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `outdoorpvp_template` (
   `TypeId` tinyint unsigned NOT NULL,
-  `ScriptName` char(64) NOT NULL DEFAULT '',
-  `comment` text,
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `comment` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`TypeId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='OutdoorPvP Templates';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='OutdoorPvP Templates';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2088,12 +2094,12 @@ DROP TABLE IF EXISTS `page_text`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `page_text` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `Text` longtext NOT NULL,
-  `NextPageID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `Text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
+  `NextPageID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Item System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2104,12 +2110,12 @@ DROP TABLE IF EXISTS `page_text_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `page_text_locale` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `Text` text,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2120,7 +2126,7 @@ DROP TABLE IF EXISTS `pet_levelstats`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `pet_levelstats` (
-  `creature_entry` mediumint unsigned NOT NULL,
+  `creature_entry` int unsigned NOT NULL,
   `level` tinyint unsigned NOT NULL,
   `hp` smallint unsigned NOT NULL,
   `mana` smallint unsigned NOT NULL,
@@ -2133,7 +2139,7 @@ CREATE TABLE `pet_levelstats` (
   `min_dmg` smallint unsigned NOT NULL DEFAULT '0',
   `max_dmg` smallint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`creature_entry`,`level`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 PACK_KEYS=0 COMMENT='Stores pet levels stats.';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=0 COMMENT='Stores pet levels stats.';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2144,12 +2150,12 @@ DROP TABLE IF EXISTS `pet_name_generation`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `pet_name_generation` (
-  `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
-  `word` tinytext NOT NULL,
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
+  `id` int unsigned NOT NULL,
+  `word` text COLLATE utf8mb4_unicode_ci NOT NULL,
+  `entry` int unsigned NOT NULL DEFAULT '0',
   `half` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=314 DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2160,18 +2166,18 @@ DROP TABLE IF EXISTS `pickpocketing_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `pickpocketing_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2187,7 +2193,7 @@ CREATE TABLE `player_classlevelstats` (
   `basehp` smallint unsigned NOT NULL,
   `basemana` smallint unsigned NOT NULL,
   PRIMARY KEY (`class`,`level`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 PACK_KEYS=0 COMMENT='Stores levels stats.';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=0 COMMENT='Stores levels stats.';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2201,7 +2207,7 @@ CREATE TABLE `player_factionchange_achievement` (
   `alliance_id` int unsigned NOT NULL,
   `horde_id` int unsigned NOT NULL,
   PRIMARY KEY (`alliance_id`,`horde_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2214,12 +2220,12 @@ DROP TABLE IF EXISTS `player_factionchange_items`;
 CREATE TABLE `player_factionchange_items` (
   `race_A` int unsigned NOT NULL,
   `alliance_id` int unsigned NOT NULL,
-  `commentA` text,
+  `commentA` mediumtext COLLATE utf8mb4_unicode_ci,
   `race_H` int unsigned NOT NULL,
   `horde_id` int unsigned NOT NULL,
-  `commentH` text,
+  `commentH` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`alliance_id`,`horde_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2235,7 +2241,7 @@ CREATE TABLE `player_factionchange_quests` (
   PRIMARY KEY (`alliance_id`,`horde_id`),
   UNIQUE KEY `alliance_uniq` (`alliance_id`),
   UNIQUE KEY `horde_uniq` (`horde_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2249,7 +2255,7 @@ CREATE TABLE `player_factionchange_reputations` (
   `alliance_id` int unsigned NOT NULL,
   `horde_id` int unsigned NOT NULL,
   PRIMARY KEY (`alliance_id`,`horde_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2263,7 +2269,7 @@ CREATE TABLE `player_factionchange_spells` (
   `alliance_id` int unsigned NOT NULL,
   `horde_id` int unsigned NOT NULL,
   PRIMARY KEY (`alliance_id`,`horde_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2277,7 +2283,7 @@ CREATE TABLE `player_factionchange_titles` (
   `alliance_id` int NOT NULL,
   `horde_id` int NOT NULL,
   PRIMARY KEY (`alliance_id`,`horde_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2297,7 +2303,7 @@ CREATE TABLE `player_levelstats` (
   `inte` tinyint unsigned NOT NULL,
   `spi` tinyint unsigned NOT NULL,
   PRIMARY KEY (`race`,`class`,`level`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 PACK_KEYS=0 COMMENT='Stores levels stats.';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PACK_KEYS=0 COMMENT='Stores levels stats.';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2312,7 +2318,7 @@ CREATE TABLE `player_totem_model` (
   `RaceId` tinyint unsigned NOT NULL,
   `DisplayId` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`TotemSlot`,`RaceId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2326,7 +2332,7 @@ CREATE TABLE `player_xp_for_level` (
   `Level` tinyint unsigned NOT NULL,
   `Experience` int unsigned NOT NULL,
   PRIMARY KEY (`Level`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2340,13 +2346,13 @@ CREATE TABLE `playercreateinfo` (
   `race` tinyint unsigned NOT NULL DEFAULT '0',
   `class` tinyint unsigned NOT NULL DEFAULT '0',
   `map` smallint unsigned NOT NULL DEFAULT '0',
-  `zone` mediumint unsigned NOT NULL DEFAULT '0',
+  `zone` int unsigned NOT NULL DEFAULT '0',
   `position_x` float NOT NULL DEFAULT '0',
   `position_y` float NOT NULL DEFAULT '0',
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float NOT NULL DEFAULT '0',
   PRIMARY KEY (`race`,`class`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2364,7 +2370,7 @@ CREATE TABLE `playercreateinfo_action` (
   `type` smallint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`race`,`class`,`button`),
   KEY `playercreateinfo_race_class_index` (`race`,`class`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2377,9 +2383,9 @@ DROP TABLE IF EXISTS `playercreateinfo_cast_spell`;
 CREATE TABLE `playercreateinfo_cast_spell` (
   `raceMask` int unsigned NOT NULL DEFAULT '0',
   `classMask` int unsigned NOT NULL DEFAULT '0',
-  `spell` mediumint unsigned NOT NULL DEFAULT '0',
-  `note` varchar(255) DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+  `spell` int unsigned NOT NULL DEFAULT '0',
+  `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2392,11 +2398,11 @@ DROP TABLE IF EXISTS `playercreateinfo_item`;
 CREATE TABLE `playercreateinfo_item` (
   `race` tinyint unsigned NOT NULL DEFAULT '0',
   `class` tinyint unsigned NOT NULL DEFAULT '0',
-  `itemid` mediumint unsigned NOT NULL DEFAULT '0',
+  `itemid` int unsigned NOT NULL DEFAULT '0',
   `amount` tinyint NOT NULL DEFAULT '1',
   PRIMARY KEY (`race`,`class`,`itemid`),
   KEY `playercreateinfo_race_class_index` (`race`,`class`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2411,9 +2417,9 @@ CREATE TABLE `playercreateinfo_skills` (
   `classMask` int unsigned NOT NULL,
   `skill` smallint unsigned NOT NULL,
   `rank` smallint unsigned NOT NULL DEFAULT '0',
-  `comment` varchar(255) DEFAULT NULL,
+  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`raceMask`,`classMask`,`skill`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2426,10 +2432,10 @@ DROP TABLE IF EXISTS `playercreateinfo_spell_custom`;
 CREATE TABLE `playercreateinfo_spell_custom` (
   `racemask` int unsigned NOT NULL DEFAULT '0',
   `classmask` int unsigned NOT NULL DEFAULT '0',
-  `Spell` mediumint unsigned NOT NULL DEFAULT '0',
-  `Note` varchar(255) DEFAULT NULL,
+  `Spell` int unsigned NOT NULL DEFAULT '0',
+  `Note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`racemask`,`classmask`,`Spell`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2440,16 +2446,16 @@ DROP TABLE IF EXISTS `points_of_interest`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `points_of_interest` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `PositionX` float NOT NULL DEFAULT '0',
   `PositionY` float NOT NULL DEFAULT '0',
-  `Icon` mediumint unsigned NOT NULL DEFAULT '0',
-  `Flags` mediumint unsigned NOT NULL DEFAULT '0',
-  `Importance` mediumint unsigned NOT NULL DEFAULT '0',
-  `Name` text NOT NULL,
+  `Icon` int unsigned NOT NULL DEFAULT '0',
+  `Flags` int unsigned NOT NULL DEFAULT '0',
+  `Importance` int unsigned NOT NULL DEFAULT '0',
+  `Name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2460,12 +2466,12 @@ DROP TABLE IF EXISTS `points_of_interest_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `points_of_interest_locale` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `Name` text,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2480,9 +2486,9 @@ CREATE TABLE `pool_members` (
   `spawnId` int unsigned NOT NULL,
   `poolSpawnId` int unsigned NOT NULL,
   `chance` float NOT NULL,
-  `description` varchar(255) DEFAULT NULL,
+  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`type`,`spawnId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2493,11 +2499,11 @@ DROP TABLE IF EXISTS `pool_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `pool_template` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry',
+  `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry',
   `max_limit` int unsigned NOT NULL DEFAULT '0' COMMENT 'Max number of objects (0) is no limit',
-  `description` varchar(255) DEFAULT NULL,
+  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2508,18 +2514,18 @@ DROP TABLE IF EXISTS `prospecting_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `prospecting_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2530,7 +2536,7 @@ DROP TABLE IF EXISTS `quest_details`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_details` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `Emote1` smallint unsigned NOT NULL DEFAULT '0',
   `Emote2` smallint unsigned NOT NULL DEFAULT '0',
   `Emote3` smallint unsigned NOT NULL DEFAULT '0',
@@ -2541,7 +2547,7 @@ CREATE TABLE `quest_details` (
   `EmoteDelay4` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2552,14 +2558,14 @@ DROP TABLE IF EXISTS `quest_greeting`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_greeting` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `Type` tinyint unsigned NOT NULL DEFAULT '0',
   `GreetEmoteType` smallint unsigned NOT NULL DEFAULT '0',
   `GreetEmoteDelay` int unsigned NOT NULL DEFAULT '0',
-  `Greeting` text,
+  `Greeting` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`Type`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2570,13 +2576,13 @@ DROP TABLE IF EXISTS `quest_greeting_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_greeting_locale` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `Type` tinyint unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `Greeting` text,
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Greeting` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`,`Type`,`locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2590,7 +2596,7 @@ CREATE TABLE `quest_mail_sender` (
   `QuestId` int unsigned NOT NULL DEFAULT '0',
   `RewardMailSenderEntry` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`QuestId`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2601,7 +2607,7 @@ DROP TABLE IF EXISTS `quest_offer_reward`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_offer_reward` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `Emote1` smallint unsigned NOT NULL DEFAULT '0',
   `Emote2` smallint unsigned NOT NULL DEFAULT '0',
   `Emote3` smallint unsigned NOT NULL DEFAULT '0',
@@ -2610,10 +2616,10 @@ CREATE TABLE `quest_offer_reward` (
   `EmoteDelay2` int unsigned NOT NULL DEFAULT '0',
   `EmoteDelay3` int unsigned NOT NULL DEFAULT '0',
   `EmoteDelay4` int unsigned NOT NULL DEFAULT '0',
-  `RewardText` text,
+  `RewardText` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2625,11 +2631,11 @@ DROP TABLE IF EXISTS `quest_offer_reward_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_offer_reward_locale` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `RewardText` text,
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `RewardText` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2651,7 +2657,7 @@ CREATE TABLE `quest_poi` (
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`QuestID`,`id`),
   KEY `idx` (`QuestID`,`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2670,7 +2676,7 @@ CREATE TABLE `quest_poi_points` (
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`QuestID`,`Idx1`,`Idx2`),
   KEY `questId_id` (`QuestID`,`Idx1`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2684,9 +2690,9 @@ CREATE TABLE `quest_pool_members` (
   `questId` int unsigned NOT NULL,
   `poolId` int unsigned NOT NULL,
   `poolIndex` tinyint unsigned NOT NULL COMMENT 'Multiple quests with the same index will always spawn together!',
-  `description` varchar(255) DEFAULT NULL,
+  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`questId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2697,11 +2703,11 @@ DROP TABLE IF EXISTS `quest_pool_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_pool_template` (
-  `poolId` mediumint unsigned NOT NULL,
+  `poolId` int unsigned NOT NULL,
   `numActive` int unsigned NOT NULL COMMENT 'Number of indices to have active at any time',
-  `description` varchar(255) DEFAULT NULL,
+  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`poolId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2712,13 +2718,13 @@ DROP TABLE IF EXISTS `quest_request_items`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_request_items` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `EmoteOnComplete` smallint unsigned NOT NULL DEFAULT '0',
   `EmoteOnIncomplete` smallint unsigned NOT NULL DEFAULT '0',
-  `CompletionText` text,
+  `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2730,11 +2736,11 @@ DROP TABLE IF EXISTS `quest_request_items_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_request_items_locale` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `CompletionText` text,
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2745,7 +2751,7 @@ DROP TABLE IF EXISTS `quest_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_template` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `QuestType` tinyint unsigned NOT NULL DEFAULT '2',
   `QuestLevel` smallint NOT NULL DEFAULT '1',
   `MinLevel` tinyint unsigned NOT NULL DEFAULT '0',
@@ -2754,90 +2760,90 @@ CREATE TABLE `quest_template` (
   `SuggestedGroupNum` tinyint unsigned NOT NULL DEFAULT '0',
   `RequiredFactionId1` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredFactionId2` smallint unsigned NOT NULL DEFAULT '0',
-  `RequiredFactionValue1` mediumint NOT NULL DEFAULT '0',
-  `RequiredFactionValue2` mediumint NOT NULL DEFAULT '0',
-  `RewardNextQuest` mediumint unsigned NOT NULL DEFAULT '0',
+  `RequiredFactionValue1` int NOT NULL DEFAULT '0',
+  `RequiredFactionValue2` int NOT NULL DEFAULT '0',
+  `RewardNextQuest` int unsigned NOT NULL DEFAULT '0',
   `RewardXPDifficulty` tinyint unsigned NOT NULL DEFAULT '0',
   `RewardMoney` int NOT NULL DEFAULT '0',
   `RewardBonusMoney` int unsigned NOT NULL DEFAULT '0',
-  `RewardDisplaySpell` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardDisplaySpell` int unsigned NOT NULL DEFAULT '0',
   `RewardSpell` int NOT NULL DEFAULT '0',
   `RewardHonor` int NOT NULL DEFAULT '0',
   `RewardKillHonor` float NOT NULL DEFAULT '0',
-  `StartItem` mediumint unsigned NOT NULL DEFAULT '0',
+  `StartItem` int unsigned NOT NULL DEFAULT '0',
   `Flags` int unsigned NOT NULL DEFAULT '0',
   `RequiredPlayerKills` tinyint unsigned NOT NULL DEFAULT '0',
-  `RewardItem1` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardItem1` int unsigned NOT NULL DEFAULT '0',
   `RewardAmount1` smallint unsigned NOT NULL DEFAULT '0',
-  `RewardItem2` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardItem2` int unsigned NOT NULL DEFAULT '0',
   `RewardAmount2` smallint unsigned NOT NULL DEFAULT '0',
-  `RewardItem3` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardItem3` int unsigned NOT NULL DEFAULT '0',
   `RewardAmount3` smallint unsigned NOT NULL DEFAULT '0',
-  `RewardItem4` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardItem4` int unsigned NOT NULL DEFAULT '0',
   `RewardAmount4` smallint unsigned NOT NULL DEFAULT '0',
-  `ItemDrop1` mediumint unsigned NOT NULL DEFAULT '0',
+  `ItemDrop1` int unsigned NOT NULL DEFAULT '0',
   `ItemDropQuantity1` smallint unsigned NOT NULL DEFAULT '0',
-  `ItemDrop2` mediumint unsigned NOT NULL DEFAULT '0',
+  `ItemDrop2` int unsigned NOT NULL DEFAULT '0',
   `ItemDropQuantity2` smallint unsigned NOT NULL DEFAULT '0',
-  `ItemDrop3` mediumint unsigned NOT NULL DEFAULT '0',
+  `ItemDrop3` int unsigned NOT NULL DEFAULT '0',
   `ItemDropQuantity3` smallint unsigned NOT NULL DEFAULT '0',
-  `ItemDrop4` mediumint unsigned NOT NULL DEFAULT '0',
+  `ItemDrop4` int unsigned NOT NULL DEFAULT '0',
   `ItemDropQuantity4` smallint unsigned NOT NULL DEFAULT '0',
-  `RewardChoiceItemID1` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardChoiceItemID1` int unsigned NOT NULL DEFAULT '0',
   `RewardChoiceItemQuantity1` smallint unsigned NOT NULL DEFAULT '0',
-  `RewardChoiceItemID2` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardChoiceItemID2` int unsigned NOT NULL DEFAULT '0',
   `RewardChoiceItemQuantity2` smallint unsigned NOT NULL DEFAULT '0',
-  `RewardChoiceItemID3` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardChoiceItemID3` int unsigned NOT NULL DEFAULT '0',
   `RewardChoiceItemQuantity3` smallint unsigned NOT NULL DEFAULT '0',
-  `RewardChoiceItemID4` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardChoiceItemID4` int unsigned NOT NULL DEFAULT '0',
   `RewardChoiceItemQuantity4` smallint unsigned NOT NULL DEFAULT '0',
-  `RewardChoiceItemID5` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardChoiceItemID5` int unsigned NOT NULL DEFAULT '0',
   `RewardChoiceItemQuantity5` smallint unsigned NOT NULL DEFAULT '0',
-  `RewardChoiceItemID6` mediumint unsigned NOT NULL DEFAULT '0',
+  `RewardChoiceItemID6` int unsigned NOT NULL DEFAULT '0',
   `RewardChoiceItemQuantity6` smallint unsigned NOT NULL DEFAULT '0',
   `POIContinent` smallint unsigned NOT NULL DEFAULT '0',
   `POIx` float NOT NULL DEFAULT '0',
   `POIy` float NOT NULL DEFAULT '0',
-  `POIPriority` mediumint unsigned NOT NULL DEFAULT '0',
+  `POIPriority` int unsigned NOT NULL DEFAULT '0',
   `RewardTitle` tinyint unsigned NOT NULL DEFAULT '0',
   `RewardTalents` tinyint unsigned NOT NULL DEFAULT '0',
   `RewardArenaPoints` smallint unsigned NOT NULL DEFAULT '0',
   `RewardFactionID1` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
-  `RewardFactionValue1` mediumint NOT NULL DEFAULT '0',
-  `RewardFactionOverride1` mediumint NOT NULL DEFAULT '0',
+  `RewardFactionValue1` int NOT NULL DEFAULT '0',
+  `RewardFactionOverride1` int NOT NULL DEFAULT '0',
   `RewardFactionID2` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
-  `RewardFactionValue2` mediumint NOT NULL DEFAULT '0',
-  `RewardFactionOverride2` mediumint NOT NULL DEFAULT '0',
+  `RewardFactionValue2` int NOT NULL DEFAULT '0',
+  `RewardFactionOverride2` int NOT NULL DEFAULT '0',
   `RewardFactionID3` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
-  `RewardFactionValue3` mediumint NOT NULL DEFAULT '0',
-  `RewardFactionOverride3` mediumint NOT NULL DEFAULT '0',
+  `RewardFactionValue3` int NOT NULL DEFAULT '0',
+  `RewardFactionOverride3` int NOT NULL DEFAULT '0',
   `RewardFactionID4` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
-  `RewardFactionValue4` mediumint NOT NULL DEFAULT '0',
-  `RewardFactionOverride4` mediumint NOT NULL DEFAULT '0',
+  `RewardFactionValue4` int NOT NULL DEFAULT '0',
+  `RewardFactionOverride4` int NOT NULL DEFAULT '0',
   `RewardFactionID5` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
-  `RewardFactionValue5` mediumint NOT NULL DEFAULT '0',
-  `RewardFactionOverride5` mediumint NOT NULL DEFAULT '0',
+  `RewardFactionValue5` int NOT NULL DEFAULT '0',
+  `RewardFactionOverride5` int NOT NULL DEFAULT '0',
   `TimeAllowed` int unsigned NOT NULL DEFAULT '0',
   `AllowableRaces` smallint unsigned NOT NULL DEFAULT '0',
-  `LogTitle` text,
-  `LogDescription` text,
-  `QuestDescription` text,
-  `AreaDescription` text,
-  `QuestCompletionLog` text,
-  `RequiredNpcOrGo1` mediumint NOT NULL DEFAULT '0',
-  `RequiredNpcOrGo2` mediumint NOT NULL DEFAULT '0',
-  `RequiredNpcOrGo3` mediumint NOT NULL DEFAULT '0',
-  `RequiredNpcOrGo4` mediumint NOT NULL DEFAULT '0',
+  `LogTitle` mediumtext COLLATE utf8mb4_unicode_ci,
+  `LogDescription` mediumtext COLLATE utf8mb4_unicode_ci,
+  `QuestDescription` mediumtext COLLATE utf8mb4_unicode_ci,
+  `AreaDescription` mediumtext COLLATE utf8mb4_unicode_ci,
+  `QuestCompletionLog` mediumtext COLLATE utf8mb4_unicode_ci,
+  `RequiredNpcOrGo1` int NOT NULL DEFAULT '0',
+  `RequiredNpcOrGo2` int NOT NULL DEFAULT '0',
+  `RequiredNpcOrGo3` int NOT NULL DEFAULT '0',
+  `RequiredNpcOrGo4` int NOT NULL DEFAULT '0',
   `RequiredNpcOrGoCount1` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredNpcOrGoCount2` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredNpcOrGoCount3` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredNpcOrGoCount4` smallint unsigned NOT NULL DEFAULT '0',
-  `RequiredItemId1` mediumint unsigned NOT NULL DEFAULT '0',
-  `RequiredItemId2` mediumint unsigned NOT NULL DEFAULT '0',
-  `RequiredItemId3` mediumint unsigned NOT NULL DEFAULT '0',
-  `RequiredItemId4` mediumint unsigned NOT NULL DEFAULT '0',
-  `RequiredItemId5` mediumint unsigned NOT NULL DEFAULT '0',
-  `RequiredItemId6` mediumint unsigned NOT NULL DEFAULT '0',
+  `RequiredItemId1` int unsigned NOT NULL DEFAULT '0',
+  `RequiredItemId2` int unsigned NOT NULL DEFAULT '0',
+  `RequiredItemId3` int unsigned NOT NULL DEFAULT '0',
+  `RequiredItemId4` int unsigned NOT NULL DEFAULT '0',
+  `RequiredItemId5` int unsigned NOT NULL DEFAULT '0',
+  `RequiredItemId6` int unsigned NOT NULL DEFAULT '0',
   `RequiredItemCount1` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredItemCount2` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredItemCount3` smallint unsigned NOT NULL DEFAULT '0',
@@ -2845,13 +2851,13 @@ CREATE TABLE `quest_template` (
   `RequiredItemCount5` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredItemCount6` smallint unsigned NOT NULL DEFAULT '0',
   `Unknown0` tinyint unsigned NOT NULL DEFAULT '0',
-  `ObjectiveText1` text,
-  `ObjectiveText2` text,
-  `ObjectiveText3` text,
-  `ObjectiveText4` text,
+  `ObjectiveText1` mediumtext COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText2` mediumtext COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText3` mediumtext COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText4` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Quest System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Quest System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2862,26 +2868,26 @@ DROP TABLE IF EXISTS `quest_template_addon`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_template_addon` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
+  `ID` int unsigned NOT NULL DEFAULT '0',
   `MaxLevel` tinyint unsigned NOT NULL DEFAULT '0',
   `AllowableClasses` int unsigned NOT NULL DEFAULT '0',
-  `SourceSpellID` mediumint unsigned NOT NULL DEFAULT '0',
-  `PrevQuestID` mediumint NOT NULL DEFAULT '0',
-  `NextQuestID` mediumint unsigned NOT NULL DEFAULT '0',
-  `ExclusiveGroup` mediumint NOT NULL DEFAULT '0',
-  `BreadcrumbForQuestId` mediumint NOT NULL DEFAULT '0',
-  `RewardMailTemplateID` mediumint unsigned NOT NULL DEFAULT '0',
+  `SourceSpellID` int unsigned NOT NULL DEFAULT '0',
+  `PrevQuestID` int NOT NULL DEFAULT '0',
+  `NextQuestID` int unsigned NOT NULL DEFAULT '0',
+  `ExclusiveGroup` int NOT NULL DEFAULT '0',
+  `BreadcrumbForQuestId` int NOT NULL DEFAULT '0',
+  `RewardMailTemplateID` int unsigned NOT NULL DEFAULT '0',
   `RewardMailDelay` int unsigned NOT NULL DEFAULT '0',
   `RequiredSkillID` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredSkillPoints` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredMinRepFaction` smallint unsigned NOT NULL DEFAULT '0',
   `RequiredMaxRepFaction` smallint unsigned NOT NULL DEFAULT '0',
-  `RequiredMinRepValue` mediumint NOT NULL DEFAULT '0',
-  `RequiredMaxRepValue` mediumint NOT NULL DEFAULT '0',
+  `RequiredMinRepValue` int NOT NULL DEFAULT '0',
+  `RequiredMaxRepValue` int NOT NULL DEFAULT '0',
   `ProvidedItemCount` tinyint unsigned NOT NULL DEFAULT '0',
   `SpecialFlags` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2892,20 +2898,20 @@ DROP TABLE IF EXISTS `quest_template_locale`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_template_locale` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `Title` text,
-  `Details` text,
-  `Objectives` text,
-  `EndText` text,
-  `CompletedText` text,
-  `ObjectiveText1` text,
-  `ObjectiveText2` text,
-  `ObjectiveText3` text,
-  `ObjectiveText4` text,
+  `ID` int unsigned NOT NULL DEFAULT '0',
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Title` mediumtext COLLATE utf8mb4_unicode_ci,
+  `Details` mediumtext COLLATE utf8mb4_unicode_ci,
+  `Objectives` mediumtext COLLATE utf8mb4_unicode_ci,
+  `EndText` mediumtext COLLATE utf8mb4_unicode_ci,
+  `CompletedText` mediumtext COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText1` mediumtext COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText2` mediumtext COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText3` mediumtext COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText4` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`,`locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2916,18 +2922,18 @@ DROP TABLE IF EXISTS `reference_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `reference_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2938,7 +2944,7 @@ DROP TABLE IF EXISTS `reputation_reward_rate`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `reputation_reward_rate` (
-  `faction` mediumint unsigned NOT NULL DEFAULT '0',
+  `faction` int unsigned NOT NULL DEFAULT '0',
   `quest_rate` float NOT NULL DEFAULT '1',
   `quest_daily_rate` float NOT NULL DEFAULT '1',
   `quest_weekly_rate` float NOT NULL DEFAULT '1',
@@ -2947,7 +2953,7 @@ CREATE TABLE `reputation_reward_rate` (
   `creature_rate` float NOT NULL DEFAULT '1',
   `spell_rate` float NOT NULL DEFAULT '1',
   PRIMARY KEY (`faction`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2972,7 +2978,7 @@ CREATE TABLE `reputation_spillover_template` (
   `rate_4` float NOT NULL DEFAULT '0',
   `rank_4` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`faction`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Reputation spillover reputation gain';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Reputation spillover reputation gain';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -2990,7 +2996,7 @@ CREATE TABLE `script_spline_chain_meta` (
   `msUntilNext` int unsigned NOT NULL,
   `velocity` float unsigned DEFAULT '0',
   PRIMARY KEY (`entry`,`chainId`,`splineId`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3009,7 +3015,7 @@ CREATE TABLE `script_spline_chain_waypoints` (
   `y` float NOT NULL,
   `z` float NOT NULL,
   PRIMARY KEY (`entry`,`chainId`,`splineId`,`wpId`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3020,15 +3026,15 @@ DROP TABLE IF EXISTS `script_waypoint`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `script_waypoint` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry',
-  `pointid` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry',
+  `pointid` int unsigned NOT NULL DEFAULT '0',
   `location_x` float NOT NULL DEFAULT '0',
   `location_y` float NOT NULL DEFAULT '0',
   `location_z` float NOT NULL DEFAULT '0',
   `waittime` int unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs',
-  `point_comment` text,
+  `point_comment` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`entry`,`pointid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Script Creature waypoints';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3039,12 +3045,12 @@ DROP TABLE IF EXISTS `skill_discovery_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `skill_discovery_template` (
-  `spellId` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the discoverable spell',
-  `reqSpell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'spell requirement',
+  `spellId` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the discoverable spell',
+  `reqSpell` int unsigned NOT NULL DEFAULT '0' COMMENT 'spell requirement',
   `reqSkillValue` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'skill points requirement',
   `chance` float NOT NULL DEFAULT '0' COMMENT 'chance to discover',
   PRIMARY KEY (`spellId`,`reqSpell`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Skill Discovery System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Skill Discovery System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3055,12 +3061,12 @@ DROP TABLE IF EXISTS `skill_extra_item_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `skill_extra_item_template` (
-  `spellId` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell',
-  `requiredSpecialization` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id',
+  `spellId` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell',
+  `requiredSpecialization` int unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id',
   `additionalCreateChance` float NOT NULL DEFAULT '0' COMMENT 'chance to create add',
   `additionalMaxNum` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'max num of adds',
   PRIMARY KEY (`spellId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Skill Specialization System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Skill Specialization System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3071,10 +3077,10 @@ DROP TABLE IF EXISTS `skill_fishing_base_level`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `skill_fishing_base_level` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Area identifier',
+  `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Area identifier',
   `skill` smallint NOT NULL DEFAULT '0' COMMENT 'Base skill level requirement',
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Fishing system';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Fishing system';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3085,12 +3091,12 @@ DROP TABLE IF EXISTS `skill_perfect_item_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `skill_perfect_item_template` (
-  `spellId` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell',
-  `requiredSpecialization` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id',
+  `spellId` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell',
+  `requiredSpecialization` int unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id',
   `perfectCreateChance` float NOT NULL DEFAULT '0' COMMENT 'chance to create the perfect item instead',
-  `perfectItemType` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'perfect item type to create instead',
+  `perfectItemType` int unsigned NOT NULL DEFAULT '0' COMMENT 'perfect item type to create instead',
   PRIMARY KEY (`spellId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Crafting Perfection System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Crafting Perfection System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3101,18 +3107,18 @@ DROP TABLE IF EXISTS `skinning_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `skinning_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3152,9 +3158,9 @@ CREATE TABLE `smart_scripts` (
   `target_y` float NOT NULL DEFAULT '0',
   `target_z` float NOT NULL DEFAULT '0',
   `target_o` float NOT NULL DEFAULT '0',
-  `comment` text NOT NULL COMMENT 'Event Comment',
+  `comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment',
   PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3169,7 +3175,7 @@ CREATE TABLE `spawn_group` (
   `spawnType` tinyint unsigned NOT NULL,
   `spawnId` int unsigned NOT NULL,
   PRIMARY KEY (`groupId`,`spawnType`,`spawnId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3181,10 +3187,10 @@ DROP TABLE IF EXISTS `spawn_group_template`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spawn_group_template` (
   `groupId` int unsigned NOT NULL,
-  `groupName` varchar(100) NOT NULL,
+  `groupName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
   `groupFlags` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`groupId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3195,18 +3201,18 @@ DROP TABLE IF EXISTS `spell_area`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_area` (
-  `spell` mediumint unsigned NOT NULL DEFAULT '0',
-  `area` mediumint unsigned NOT NULL DEFAULT '0',
-  `quest_start` mediumint unsigned NOT NULL DEFAULT '0',
-  `quest_end` mediumint unsigned NOT NULL DEFAULT '0',
-  `aura_spell` mediumint NOT NULL DEFAULT '0',
-  `racemask` mediumint unsigned NOT NULL DEFAULT '0',
+  `spell` int unsigned NOT NULL DEFAULT '0',
+  `area` int unsigned NOT NULL DEFAULT '0',
+  `quest_start` int unsigned NOT NULL DEFAULT '0',
+  `quest_end` int unsigned NOT NULL DEFAULT '0',
+  `aura_spell` int NOT NULL DEFAULT '0',
+  `racemask` int unsigned NOT NULL DEFAULT '0',
   `gender` tinyint unsigned NOT NULL DEFAULT '2',
   `autocast` tinyint unsigned NOT NULL DEFAULT '0',
   `quest_start_status` int NOT NULL DEFAULT '64',
   `quest_end_status` int NOT NULL DEFAULT '11',
   PRIMARY KEY (`spell`,`area`,`quest_start`,`aura_spell`,`racemask`,`gender`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3217,14 +3223,14 @@ DROP TABLE IF EXISTS `spell_bonus_data`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_bonus_data` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
   `direct_bonus` float NOT NULL DEFAULT '0',
   `dot_bonus` float NOT NULL DEFAULT '0',
   `ap_bonus` float NOT NULL DEFAULT '0',
   `ap_dot_bonus` float NOT NULL DEFAULT '0',
-  `comments` varchar(255) DEFAULT NULL,
+  `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3238,7 +3244,7 @@ CREATE TABLE `spell_custom_attr` (
   `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'spell id',
   `attributes` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCustomAttributes',
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='SpellInfo custom attributes';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='SpellInfo custom attributes';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3331,7 +3337,7 @@ CREATE TABLE `spell_dbc` (
   `EffectSpellClassMaskC1` int unsigned NOT NULL DEFAULT '0',
   `EffectSpellClassMaskC2` int unsigned NOT NULL DEFAULT '0',
   `EffectSpellClassMaskC3` int unsigned NOT NULL DEFAULT '0',
-  `SpellName` varchar(100) DEFAULT NULL,
+  `SpellName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `MaxTargetLevel` int unsigned NOT NULL DEFAULT '0',
   `SpellFamilyName` int unsigned NOT NULL DEFAULT '0',
   `SpellFamilyFlags1` int unsigned NOT NULL DEFAULT '0',
@@ -3346,7 +3352,7 @@ CREATE TABLE `spell_dbc` (
   `AreaGroupId` int NOT NULL DEFAULT '0',
   `SchoolMask` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`Id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Custom spell.dbc entries';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3363,7 +3369,7 @@ CREATE TABLE `spell_enchant_proc_data` (
   `HitMask` int unsigned NOT NULL DEFAULT '0',
   `AttributesMask` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`EnchantID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell enchant proc data';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3377,7 +3383,7 @@ CREATE TABLE `spell_group` (
   `id` int unsigned NOT NULL DEFAULT '0',
   `spell_id` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`spell_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Spell System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3391,7 +3397,7 @@ CREATE TABLE `spell_group_stack_rules` (
   `group_id` int unsigned NOT NULL DEFAULT '0',
   `stack_rule` tinyint NOT NULL DEFAULT '0',
   PRIMARY KEY (`group_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3406,7 +3412,7 @@ CREATE TABLE `spell_learn_spell` (
   `SpellID` int unsigned NOT NULL DEFAULT '0',
   `Active` tinyint unsigned NOT NULL DEFAULT '1',
   PRIMARY KEY (`entry`,`SpellID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Item System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3417,12 +3423,12 @@ DROP TABLE IF EXISTS `spell_linked_spell`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_linked_spell` (
-  `spell_trigger` mediumint NOT NULL,
-  `spell_effect` mediumint NOT NULL DEFAULT '0',
+  `spell_trigger` int NOT NULL,
+  `spell_effect` int NOT NULL DEFAULT '0',
   `type` tinyint unsigned NOT NULL DEFAULT '0',
-  `comment` text NOT NULL,
+  `comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
   UNIQUE KEY `trigger_effect_type` (`spell_trigger`,`spell_effect`,`type`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='Spell System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3433,18 +3439,18 @@ DROP TABLE IF EXISTS `spell_loot_template`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_loot_template` (
-  `Entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `Item` mediumint unsigned NOT NULL DEFAULT '0',
-  `Reference` mediumint unsigned NOT NULL DEFAULT '0',
+  `Entry` int unsigned NOT NULL DEFAULT '0',
+  `Item` int unsigned NOT NULL DEFAULT '0',
+  `Reference` int unsigned NOT NULL DEFAULT '0',
   `Chance` float NOT NULL DEFAULT '100',
   `QuestRequired` tinyint(1) NOT NULL DEFAULT '0',
   `LootMode` smallint unsigned NOT NULL DEFAULT '1',
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) DEFAULT NULL,
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Loot System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3455,12 +3461,12 @@ DROP TABLE IF EXISTS `spell_pet_auras`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_pet_auras` (
-  `spell` mediumint unsigned NOT NULL COMMENT 'dummy spell id',
+  `spell` int unsigned NOT NULL COMMENT 'dummy spell id',
   `effectId` tinyint unsigned NOT NULL DEFAULT '0',
-  `pet` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'pet id; 0 = all',
-  `aura` mediumint unsigned NOT NULL COMMENT 'pet aura id',
+  `pet` int unsigned NOT NULL DEFAULT '0' COMMENT 'pet id; 0 = all',
+  `aura` int unsigned NOT NULL COMMENT 'pet aura id',
   PRIMARY KEY (`spell`,`effectId`,`pet`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3488,7 +3494,7 @@ CREATE TABLE `spell_proc` (
   `Cooldown` int unsigned NOT NULL DEFAULT '0',
   `Charges` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`SpellId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3504,7 +3510,7 @@ CREATE TABLE `spell_ranks` (
   `rank` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`first_spell_id`,`rank`),
   UNIQUE KEY `spell_id` (`spell_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Spell Rank Data';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell Rank Data';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3515,10 +3521,10 @@ DROP TABLE IF EXISTS `spell_required`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_required` (
-  `spell_id` mediumint NOT NULL DEFAULT '0',
-  `req_spell` mediumint NOT NULL DEFAULT '0',
+  `spell_id` int NOT NULL DEFAULT '0',
+  `req_spell` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`spell_id`,`req_spell`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Spell Additinal Data';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell Additinal Data';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3530,9 +3536,9 @@ DROP TABLE IF EXISTS `spell_script_names`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_script_names` (
   `spell_id` int NOT NULL,
-  `ScriptName` char(64) NOT NULL,
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL,
   UNIQUE KEY `spell_id` (`spell_id`,`ScriptName`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3543,19 +3549,19 @@ DROP TABLE IF EXISTS `spell_scripts`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_scripts` (
-  `id` mediumint unsigned NOT NULL DEFAULT '0',
+  `id` int unsigned NOT NULL DEFAULT '0',
   `effIndex` tinyint unsigned NOT NULL DEFAULT '0',
   `delay` int unsigned NOT NULL DEFAULT '0',
-  `command` mediumint unsigned NOT NULL DEFAULT '0',
-  `datalong` mediumint 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 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',
-  `Comment` varchar(255) NOT NULL DEFAULT ''
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3566,7 +3572,7 @@ DROP TABLE IF EXISTS `spell_target_position`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_target_position` (
-  `ID` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
+  `ID` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
   `EffectIndex` tinyint unsigned NOT NULL DEFAULT '0',
   `MapID` smallint unsigned NOT NULL DEFAULT '0',
   `PositionX` float NOT NULL DEFAULT '0',
@@ -3575,7 +3581,7 @@ CREATE TABLE `spell_target_position` (
   `Orientation` float NOT NULL DEFAULT '0',
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`ID`,`EffectIndex`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Spell System';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3586,12 +3592,12 @@ DROP TABLE IF EXISTS `spell_threat`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `spell_threat` (
-  `entry` mediumint unsigned NOT NULL,
+  `entry` int unsigned NOT NULL,
   `flatMod` int DEFAULT NULL,
   `pctMod` float NOT NULL DEFAULT '1' COMMENT 'threat multiplier for damage/healing',
   `apPctMod` float NOT NULL DEFAULT '0' COMMENT 'additional threat bonus from attack power',
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3608,7 +3614,7 @@ CREATE TABLE `spelldifficulty_dbc` (
   `spellid2` int unsigned NOT NULL DEFAULT '0',
   `spellid3` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3621,11 +3627,11 @@ DROP TABLE IF EXISTS `trainer`;
 CREATE TABLE `trainer` (
   `Id` int unsigned NOT NULL DEFAULT '0',
   `Type` tinyint unsigned NOT NULL DEFAULT '2',
-  `Requirement` mediumint unsigned NOT NULL DEFAULT '0',
-  `Greeting` text,
+  `Requirement` int unsigned NOT NULL DEFAULT '0',
+  `Greeting` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`Id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3637,11 +3643,11 @@ DROP TABLE IF EXISTS `trainer_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trainer_locale` (
   `Id` int unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) NOT NULL,
-  `Greeting_lang` text,
+  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Greeting_lang` mediumtext COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`Id`,`locale`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3663,7 +3669,7 @@ CREATE TABLE `trainer_spell` (
   `ReqLevel` tinyint unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` smallint DEFAULT '0',
   PRIMARY KEY (`TrainerId`,`SpellId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3675,12 +3681,12 @@ DROP TABLE IF EXISTS `transports`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `transports` (
   `guid` int unsigned NOT NULL AUTO_INCREMENT,
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `name` text,
-  `ScriptName` char(64) NOT NULL DEFAULT '',
+  `entry` int unsigned NOT NULL DEFAULT '0',
+  `name` mediumtext COLLATE utf8mb4_unicode_ci,
+  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`guid`),
   UNIQUE KEY `idx_entry` (`entry`)
-) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Transports';
+) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Transports';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3691,18 +3697,18 @@ DROP TABLE IF EXISTS `trinity_string`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trinity_string` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `content_default` text NOT NULL,
-  `content_loc1` text,
-  `content_loc2` text,
-  `content_loc3` text,
-  `content_loc4` text,
-  `content_loc5` text,
-  `content_loc6` text,
-  `content_loc7` text,
-  `content_loc8` text,
+  `entry` int unsigned NOT NULL DEFAULT '0',
+  `content_default` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
+  `content_loc1` mediumtext COLLATE utf8mb4_unicode_ci,
+  `content_loc2` mediumtext COLLATE utf8mb4_unicode_ci,
+  `content_loc3` mediumtext COLLATE utf8mb4_unicode_ci,
+  `content_loc4` mediumtext COLLATE utf8mb4_unicode_ci,
+  `content_loc5` mediumtext COLLATE utf8mb4_unicode_ci,
+  `content_loc6` mediumtext COLLATE utf8mb4_unicode_ci,
+  `content_loc7` mediumtext COLLATE utf8mb4_unicode_ci,
+  `content_loc8` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3713,13 +3719,13 @@ DROP TABLE IF EXISTS `updates`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `updates` (
-  `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.',
-  `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.',
-  `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.',
+  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.',
+  `hash` char(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.',
+  `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.',
   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.',
   `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.',
   PRIMARY KEY (`name`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='List of all applied updates in this database.';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of all applied updates in this database.';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3730,10 +3736,10 @@ DROP TABLE IF EXISTS `updates_include`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `updates_include` (
-  `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
-  `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
+  `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
+  `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
   PRIMARY KEY (`path`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='List of directories where we want to include sql updates.';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3744,15 +3750,15 @@ DROP TABLE IF EXISTS `vehicle_accessory`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `vehicle_accessory` (
-  `guid` mediumint unsigned NOT NULL DEFAULT '0',
-  `accessory_entry` mediumint unsigned NOT NULL DEFAULT '0',
+  `guid` int unsigned NOT NULL DEFAULT '0',
+  `accessory_entry` int unsigned NOT NULL DEFAULT '0',
   `seat_id` tinyint NOT NULL DEFAULT '0',
   `minion` tinyint unsigned NOT NULL DEFAULT '0',
-  `description` text NOT NULL,
+  `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
   `summontype` tinyint unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType',
   `summontimer` int unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes',
   PRIMARY KEY (`guid`,`seat_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3771,7 +3777,7 @@ CREATE TABLE `vehicle_seat_addon` (
   `ExitParamO` float DEFAULT '0',
   `ExitParamValue` tinyint(1) DEFAULT '0',
   PRIMARY KEY (`SeatEntry`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3785,7 +3791,7 @@ CREATE TABLE `vehicle_template` (
   `creatureId` int unsigned NOT NULL,
   `despawnDelayMs` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`creatureId`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3796,15 +3802,15 @@ DROP TABLE IF EXISTS `vehicle_template_accessory`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `vehicle_template_accessory` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `accessory_entry` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
+  `accessory_entry` int unsigned NOT NULL DEFAULT '0',
   `seat_id` tinyint NOT NULL DEFAULT '0',
   `minion` tinyint unsigned NOT NULL DEFAULT '0',
-  `description` text NOT NULL,
+  `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
   `summontype` tinyint unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType',
   `summontimer` int unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes',
   PRIMARY KEY (`entry`,`seat_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3815,12 +3821,12 @@ DROP TABLE IF EXISTS `version`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `version` (
-  `core_version` varchar(255) NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.',
-  `core_revision` varchar(120) DEFAULT NULL,
-  `db_version` varchar(120) DEFAULT NULL COMMENT 'Version of world DB.',
+  `core_version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.',
+  `core_revision` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `db_version` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Version of world DB.',
   `cache_id` int DEFAULT '0',
   PRIMARY KEY (`core_version`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Version Notes';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Version Notes';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3917,14 +3923,14 @@ DROP TABLE IF EXISTS `warden_checks`;
 CREATE TABLE `warden_checks` (
   `id` smallint unsigned NOT NULL AUTO_INCREMENT,
   `type` tinyint unsigned DEFAULT NULL,
-  `str` varchar(170) DEFAULT NULL,
+  `str` varchar(170) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `address` int unsigned DEFAULT NULL,
   `length` tinyint unsigned DEFAULT NULL,
-  `comment` varchar(50) DEFAULT NULL,
+  `comment` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `data` binary(24) DEFAULT NULL,
   `result` varbinary(24) DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=791 DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB AUTO_INCREMENT=791 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3936,7 +3942,7 @@ DROP TABLE IF EXISTS `waypoint_data`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `waypoint_data` (
   `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Creature GUID',
-  `point` mediumint unsigned NOT NULL DEFAULT '0',
+  `point` int unsigned NOT NULL DEFAULT '0',
   `position_x` float NOT NULL DEFAULT '0',
   `position_y` float NOT NULL DEFAULT '0',
   `position_z` float NOT NULL DEFAULT '0',
@@ -3947,7 +3953,7 @@ CREATE TABLE `waypoint_data` (
   `action_chance` smallint NOT NULL DEFAULT '100',
   `wpguid` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`point`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3969,9 +3975,9 @@ CREATE TABLE `waypoint_scripts` (
   `z` float NOT NULL DEFAULT '0',
   `o` float NOT NULL DEFAULT '0',
   `guid` int NOT NULL DEFAULT '0',
-  `Comment` varchar(255) NOT NULL DEFAULT '',
+  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3982,16 +3988,16 @@ DROP TABLE IF EXISTS `waypoints`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `waypoints` (
-  `entry` mediumint unsigned NOT NULL DEFAULT '0',
-  `pointid` mediumint unsigned NOT NULL DEFAULT '0',
+  `entry` int unsigned NOT NULL DEFAULT '0',
+  `pointid` int unsigned NOT NULL DEFAULT '0',
   `position_x` float NOT NULL DEFAULT '0',
   `position_y` float NOT NULL DEFAULT '0',
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float DEFAULT NULL,
   `delay` int unsigned NOT NULL DEFAULT '0',
-  `point_comment` text,
+  `point_comment` mediumtext COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`entry`,`pointid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 ROW_FORMAT=FIXED COMMENT='Creature waypoints';
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature waypoints';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -4061,4 +4067,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2022-10-17  9:02:33
+-- Dump completed on 2023-01-16 11:08:18
diff --git a/sql/updates/auth/3.3.5/2022_10_17_00_auth.sql b/sql/old/3.3.5a/auth/22101_2023_01_16/2022_10_17_00_auth.sql
index 02cc540baa3..02cc540baa3 100644
--- a/sql/updates/auth/3.3.5/2022_10_17_00_auth.sql
+++ b/sql/old/3.3.5a/auth/22101_2023_01_16/2022_10_17_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2022_10_17_00_characters.sql b/sql/old/3.3.5a/characters/22101_2023_01_16/2022_10_17_00_characters.sql
index ac8408da8ce..ac8408da8ce 100644
--- a/sql/updates/characters/3.3.5/2022_10_17_00_characters.sql
+++ b/sql/old/3.3.5a/characters/22101_2023_01_16/2022_10_17_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2022_10_17_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_17_00_world.sql
index 71f98c6718c..71f98c6718c 100644
--- a/sql/updates/world/3.3.5/2022_10_17_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_17_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_30_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_00_world.sql
index fb98d2a87a2..fb98d2a87a2 100644
--- a/sql/updates/world/3.3.5/2022_10_30_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_30_01_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_01_world.sql
index 9e69a6d6011..9e69a6d6011 100644
--- a/sql/updates/world/3.3.5/2022_10_30_01_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_30_02_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_02_world.sql
index a01a1becb18..a01a1becb18 100644
--- a/sql/updates/world/3.3.5/2022_10_30_02_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_30_03_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_03_world.sql
index a7803348158..a7803348158 100644
--- a/sql/updates/world/3.3.5/2022_10_30_03_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_03_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_30_04_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_04_world.sql
index 2f5868f8101..2f5868f8101 100644
--- a/sql/updates/world/3.3.5/2022_10_30_04_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_04_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_30_05_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_05_world.sql
index b652c58ef99..b652c58ef99 100644
--- a/sql/updates/world/3.3.5/2022_10_30_05_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_05_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_30_06_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_06_world.sql
index 1f96f72b667..1f96f72b667 100644
--- a/sql/updates/world/3.3.5/2022_10_30_06_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_06_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_30_07_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_07_world.sql
index 8af253a2dbb..8af253a2dbb 100644
--- a/sql/updates/world/3.3.5/2022_10_30_07_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_07_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_30_08_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_08_world.sql
index 2f1033816fe..2f1033816fe 100644
--- a/sql/updates/world/3.3.5/2022_10_30_08_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_08_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_30_09_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_09_world.sql
index 898d58bb7f0..898d58bb7f0 100644
--- a/sql/updates/world/3.3.5/2022_10_30_09_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_30_09_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_31_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_31_00_world.sql
index 1777c7c3564..1777c7c3564 100644
--- a/sql/updates/world/3.3.5/2022_10_31_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_31_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_31_01_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_31_01_world.sql
index c8ecca5761e..c8ecca5761e 100644
--- a/sql/updates/world/3.3.5/2022_10_31_01_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_31_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_31_02_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_31_02_world.sql
index ec2504cce48..ec2504cce48 100644
--- a/sql/updates/world/3.3.5/2022_10_31_02_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_31_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_31_03_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_31_03_world.sql
index bba85cd1c62..bba85cd1c62 100644
--- a/sql/updates/world/3.3.5/2022_10_31_03_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_31_03_world.sql
diff --git a/sql/updates/world/3.3.5/2022_10_31_04_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_31_04_world.sql
index 7e302f0ca89..7e302f0ca89 100644
--- a/sql/updates/world/3.3.5/2022_10_31_04_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_10_31_04_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_01_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_01_00_world.sql
index 3f2f08bda4b..3f2f08bda4b 100644
--- a/sql/updates/world/3.3.5/2022_11_01_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_01_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_01_01_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_01_01_world.sql
index 67fb585d7e3..67fb585d7e3 100644
--- a/sql/updates/world/3.3.5/2022_11_01_01_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_01_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_01_02_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_01_02_world.sql
index 5d5f4673e78..5d5f4673e78 100644
--- a/sql/updates/world/3.3.5/2022_11_01_02_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_01_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_01_03_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_01_03_world.sql
index 7a46ebda2e3..7a46ebda2e3 100644
--- a/sql/updates/world/3.3.5/2022_11_01_03_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_01_03_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_01_04_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_01_04_world.sql
index 465305af853..465305af853 100644
--- a/sql/updates/world/3.3.5/2022_11_01_04_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_01_04_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_04_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_00_world.sql
index 6a6e9fe1c26..6a6e9fe1c26 100644
--- a/sql/updates/world/3.3.5/2022_11_04_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_04_01_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_01_world.sql
index cd301493e07..cd301493e07 100644
--- a/sql/updates/world/3.3.5/2022_11_04_01_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_04_02_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_02_world.sql
index 7604f54c32d..7604f54c32d 100644
--- a/sql/updates/world/3.3.5/2022_11_04_02_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_04_03_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_03_world.sql
index 482b1caeeac..482b1caeeac 100644
--- a/sql/updates/world/3.3.5/2022_11_04_03_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_03_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_04_04_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_04_world.sql
index d02b781ec1a..d02b781ec1a 100644
--- a/sql/updates/world/3.3.5/2022_11_04_04_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_04_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_04_05_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_05_world.sql
index 80eb5a4a0d6..80eb5a4a0d6 100644
--- a/sql/updates/world/3.3.5/2022_11_04_05_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_05_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_04_06_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_06_world.sql
index 1d01d9086b8..1d01d9086b8 100644
--- a/sql/updates/world/3.3.5/2022_11_04_06_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_06_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_04_07_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_07_world.sql
index cf9b2e08741..cf9b2e08741 100644
--- a/sql/updates/world/3.3.5/2022_11_04_07_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_07_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_04_08_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_08_world.sql
index b789f0ee862..b789f0ee862 100644
--- a/sql/updates/world/3.3.5/2022_11_04_08_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_08_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_04_09_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_09_world.sql
index d19873e1d17..d19873e1d17 100644
--- a/sql/updates/world/3.3.5/2022_11_04_09_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_04_09_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_05_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_05_00_world.sql
index f1d02038102..f1d02038102 100644
--- a/sql/updates/world/3.3.5/2022_11_05_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_05_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_05_01_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_05_01_world.sql
index 83b16389383..83b16389383 100644
--- a/sql/updates/world/3.3.5/2022_11_05_01_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_05_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_05_02_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_05_02_world.sql
index bd90c3bda97..bd90c3bda97 100644
--- a/sql/updates/world/3.3.5/2022_11_05_02_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_05_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_05_03_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_05_03_world.sql
index 7cd6cd71fbc..7cd6cd71fbc 100644
--- a/sql/updates/world/3.3.5/2022_11_05_03_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_05_03_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_06_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_06_00_world.sql
index 02bd90f8d9b..02bd90f8d9b 100644
--- a/sql/updates/world/3.3.5/2022_11_06_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_06_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_06_01_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_06_01_world.sql
index 225d3e9b471..225d3e9b471 100644
--- a/sql/updates/world/3.3.5/2022_11_06_01_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_06_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_06_02_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_06_02_world.sql
index b28802fb164..b28802fb164 100644
--- a/sql/updates/world/3.3.5/2022_11_06_02_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_06_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_07_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_07_00_world.sql
index daf7f53fe84..daf7f53fe84 100644
--- a/sql/updates/world/3.3.5/2022_11_07_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_07_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_07_01_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_07_01_world.sql
index 490c6e945bd..490c6e945bd 100644
--- a/sql/updates/world/3.3.5/2022_11_07_01_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_07_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_08_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_08_00_world.sql
index 69e6ed4bfa1..69e6ed4bfa1 100644
--- a/sql/updates/world/3.3.5/2022_11_08_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_08_01_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_08_01_world.sql
index c6b97275c14..c6b97275c14 100644
--- a/sql/updates/world/3.3.5/2022_11_08_01_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_08_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_08_02_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_08_02_world.sql
index d36146a33a0..d36146a33a0 100644
--- a/sql/updates/world/3.3.5/2022_11_08_02_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_08_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_15_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_15_00_world.sql
index 54be5c4cfc2..54be5c4cfc2 100644
--- a/sql/updates/world/3.3.5/2022_11_15_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_15_01_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_15_01_world.sql
index 13d3c03bdc9..13d3c03bdc9 100644
--- a/sql/updates/world/3.3.5/2022_11_15_01_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_15_01_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_15_02_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_15_02_world.sql
index 1dbf1bb27d1..1dbf1bb27d1 100644
--- a/sql/updates/world/3.3.5/2022_11_15_02_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_15_02_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_15_03_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_15_03_world.sql
index ade3ff34647..ade3ff34647 100644
--- a/sql/updates/world/3.3.5/2022_11_15_03_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_15_03_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_15_04_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_15_04_world.sql
index 9c648fcdb17..9c648fcdb17 100644
--- a/sql/updates/world/3.3.5/2022_11_15_04_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_15_04_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_17_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_17_00_world.sql
index 0b766369eb2..0b766369eb2 100644
--- a/sql/updates/world/3.3.5/2022_11_17_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_17_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_20_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_20_00_world.sql
index 02874836926..02874836926 100644
--- a/sql/updates/world/3.3.5/2022_11_20_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_11_27_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_27_00_world.sql
index 1ee9ae746ce..1ee9ae746ce 100644
--- a/sql/updates/world/3.3.5/2022_11_27_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_11_27_00_world.sql
diff --git a/sql/updates/world/3.3.5/2022_12_23_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2022_12_23_00_world.sql
index 852260c1f51..852260c1f51 100644
--- a/sql/updates/world/3.3.5/2022_12_23_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2022_12_23_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_01_09_00_world.sql b/sql/old/3.3.5a/world/22101_2023_01_16/2023_01_09_00_world.sql
index c58503cbc0c..c58503cbc0c 100644
--- a/sql/updates/world/3.3.5/2023_01_09_00_world.sql
+++ b/sql/old/3.3.5a/world/22101_2023_01_16/2023_01_09_00_world.sql
diff --git a/sql/updates/auth/3.3.5/2023_01_16_00_auth.sql b/sql/updates/auth/3.3.5/2023_01_16_00_auth.sql
new file mode 100644
index 00000000000..2b56c992617
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2023_01_16_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.23011 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2023_01_16_00_characters.sql b/sql/updates/characters/3.3.5/2023_01_16_00_characters.sql
new file mode 100644
index 00000000000..518902308ae
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2023_01_16_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.23011 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2023_01_16_00_world.sql b/sql/updates/world/3.3.5/2023_01_16_00_world.sql
new file mode 100644
index 00000000000..425832740e8
--- /dev/null
+++ b/sql/updates/world/3.3.5/2023_01_16_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.23011 world
+UPDATE `version` SET `db_version`='TDB 335.23011', `cache_id`=23011 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';
author	TDB Release <tdb-release@build.bot>	2023-01-16 11:10:56 +0000
committer	TDB Release <tdb-release@build.bot>	2023-01-16 11:10:56 +0000
commit	80884e32ef6e79b6de66fe02a16b0546282f75bb (patch)
tree	0d59fc54d662976e46d843cc6295a0355d6a17d7 /sql
parent	128339730cafefba04ca8b1b6c72ed4ea9315bd3 (diff)