TDB 335.23061 - 2023/06/14TDB335.23061

author: TDB Release <tdb-release@build.bot> 2023-06-14 19:37:17 +0000
committer: TDB Release <tdb-release@build.bot> 2023-06-14 19:37:17 +0000
commit: 40d1f7a2e8fa54b3c9432b4432d6df968ec60cc4 (patch)
tree: c6f405d6af8b24fe8b30807e4d4562a8d7ffffb9
parent: d1c6b9d253faa61246f04058719f7f3c07548165 (diff)
58 files changed, 270 insertions, 261 deletions
diff --git a/revision_data.h.in.cmake b/revision_data.h.in.cmake
index 4e2b74cc38b..4a1c531fcc9 100644
--- a/revision_data.h.in.cmake
+++ b/revision_data.h.in.cmake
@@ -9,7 +9,7 @@
  #define _SOURCE_DIRECTORY          R"(@CMAKE_SOURCE_DIR@)"
  #define _BUILD_DIRECTORY           R"(@BUILDDIR@)"
  #define _MYSQL_EXECUTABLE          R"(@MYSQL_EXECUTABLE@)"
- #define _FULL_DATABASE             "TDB_full_world_335.23011_2023_01_16.sql"
+ #define _FULL_DATABASE             "TDB_full_world_335.23061_2023_06_14.sql"
  #define VER_COMPANYNAME_STR        "TrinityCore Developers"
  #define VER_LEGALCOPYRIGHT_STR     "(c)2008-@rev_year@ TrinityCore"
  #define VER_FILEVERSION            0,0,0
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 876cee1e60a..0018c699df4 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,13 +1,13 @@
--- MySQL dump 10.13  Distrib 8.0.31, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.33, for Linux (x86_64)
 --
 -- Host: localhost    Database: auth
 -- ------------------------------------------------------
--- Server version	8.0.31-0ubuntu0.20.04.2
+-- Server version	8.0.33-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!50503 SET NAMES utf8mb4 */;
+/*!50503 SET NAMES utf8 */;
 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 /*!40103 SET TIME_ZONE='+00:00' */;
 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
@@ -2005,9 +2005,10 @@ INSERT INTO `updates` VALUES
 ('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),
 ('2023_01_16_00_auth.sql','8431F03DE6A036BEED6682C21F4B67F384390905','ARCHIVED','2023-01-16 11:06:30',0),
-('2023_02_05_00_auth.sql','DC8A2046EB4201D55342C541A0E9C398499E12B1','RELEASED','2023-02-05 14:50:30',0),
-('2023_02_05_01_auth.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','RELEASED','2023-02-05 15:58:32',0),
-('2023_05_05_00_auth.sql','DEEB1D5533658E3479FC3C988EF4B9816C511BC3','RELEASED','2023-05-07 11:52:00',0);
+('2023_02_05_00_auth.sql','DC8A2046EB4201D55342C541A0E9C398499E12B1','ARCHIVED','2023-02-05 14:50:30',0),
+('2023_02_05_01_auth.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2023-02-05 15:58:32',0),
+('2023_05_05_00_auth.sql','DEEB1D5533658E3479FC3C988EF4B9816C511BC3','ARCHIVED','2023-05-07 11:52:00',0),
+('2023_06_14_00_auth.sql','BB8A7EB214F4F3632C4F54EA596CB7C8FBA305D5','ARCHIVED','2023-06-14 19:34:24',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2032,9 +2033,9 @@ CREATE TABLE `updates_include` (
 LOCK TABLES `updates_include` WRITE;
 /*!40000 ALTER TABLE `updates_include` DISABLE KEYS */;
 INSERT INTO `updates_include` VALUES
-('$/sql/updates/auth','RELEASED'),
 ('$/sql/custom/auth','RELEASED'),
-('$/sql/old/3.3.5a/auth','ARCHIVED');
+('$/sql/old/3.3.5a/auth','ARCHIVED'),
+('$/sql/updates/auth','RELEASED');
 /*!40000 ALTER TABLE `updates_include` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2146,4 +2147,4 @@ SET character_set_client = @saved_cs_client;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2023-01-16 11:08:17
+-- Dump completed on 2023-06-14 19:34:37
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index b2dc3eaa1cf..7edbe051fa2 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,13 +1,13 @@
--- MySQL dump 10.13  Distrib 8.0.31, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.33, for Linux (x86_64)
 --
 -- Host: localhost    Database: characters
 -- ------------------------------------------------------
--- Server version	8.0.31-0ubuntu0.20.04.2
+-- Server version	8.0.33-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!50503 SET NAMES utf8mb4 */;
+/*!50503 SET NAMES utf8 */;
 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 /*!40103 SET TIME_ZONE='+00:00' */;
 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
@@ -2604,8 +2604,8 @@ INSERT INTO `updates` VALUES
 ('2015_03_20_01_characters.sql','894F08B70449A5481FFAF394EE5571D7FC4D8A3A','ARCHIVED','2015-03-21 21:44:15',0),
 ('2015_03_20_02_characters.sql','97D7BE0CAADC79F3F11B9FD296B8C6CD40FE593B','ARCHIVED','2015-03-21 21:44:51',0),
 ('2015_06_26_00_characters_335.sql','C2CC6E50AFA1ACCBEBF77CC519AAEB09F3BBAEBC','ARCHIVED','2015-07-13 23:49:22',0),
-('2015_09_28_00_characters_335.sql','F8682A431D50E54BDC4AC0E7DBED21AE8AAB6AD4','ARCHIVED','2015-09-28 21:00:00',0),
 ('2015_08_26_00_characters_335.sql','C7D6A3A00FECA3EBFF1E71744CA40D3076582374','ARCHIVED','2015-08-26 21:00:00',0),
+('2015_09_28_00_characters_335.sql','F8682A431D50E54BDC4AC0E7DBED21AE8AAB6AD4','ARCHIVED','2015-09-28 21:00:00',0),
 ('2015_10_06_00_characters.sql','16842FDD7E8547F2260D3312F53EFF8761EFAB35','ARCHIVED','2015-10-06 16:06:38',0),
 ('2015_10_07_00_characters.sql','E15AB463CEBE321001D7BFDEA4B662FF618728FD','ARCHIVED','2015-10-07 23:32:00',0),
 ('2015_10_12_00_characters.sql','D6F9927BDED72AD0A81D6EC2C6500CBC34A39FA2','ARCHIVED','2015-10-12 15:35:47',0),
@@ -2678,9 +2678,10 @@ INSERT INTO `updates` VALUES
 ('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),
 ('2023_01_16_00_characters.sql','2667390C8E0EC1E5CDE16784BFCD8F8749C7D73E','ARCHIVED','2023-01-16 11:06:30',0),
-('2023_02_05_00_characters.sql','DD3F2181CC472A040EC4AE49EBB057C1FAA5BE10','RELEASED','2023-01-16 14:51:30',0),
-('2023_02_05_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','RELEASED','2023-02-05 15:58:32',0),
-('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','RELEASED','2023-05-19 18:40:42',0);
+('2023_02_05_00_characters.sql','DD3F2181CC472A040EC4AE49EBB057C1FAA5BE10','ARCHIVED','2023-01-16 14:51:30',0),
+('2023_02_05_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2023-02-05 15:58:32',0),
+('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','ARCHIVED','2023-05-19 18:40:42',0),
+('2023_06_14_00_characters.sql','0595B21DCFC0A04F2D8DF1F7BC018C758895DBE5','ARCHIVED','2023-06-14 19:34:24',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2705,9 +2706,9 @@ CREATE TABLE `updates_include` (
 LOCK TABLES `updates_include` WRITE;
 /*!40000 ALTER TABLE `updates_include` DISABLE KEYS */;
 INSERT INTO `updates_include` VALUES
-('$/sql/updates/characters','RELEASED'),
 ('$/sql/custom/characters','RELEASED'),
-('$/sql/old/3.3.5a/characters','ARCHIVED');
+('$/sql/old/3.3.5a/characters','ARCHIVED'),
+('$/sql/updates/characters','RELEASED');
 /*!40000 ALTER TABLE `updates_include` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2851,4 +2852,4 @@ UNLOCK TABLES;
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2023-01-16 11:08:17
+-- Dump completed on 2023-06-14 19:34:37
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 6136160325f..15f9e206042 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.31, for Linux (x86_64)
+-- MySQL dump 10.13  Distrib 8.0.33, for Linux (x86_64)
 --
 -- Host: localhost    Database: world
 -- ------------------------------------------------------
--- Server version	8.0.31-0ubuntu0.20.04.2
+-- Server version	8.0.33-0ubuntu0.20.04.2
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -33,8 +33,8 @@ CREATE TABLE `access_requirement` (
   `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,
+  `quest_failed_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`mapId`,`difficulty`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Access Requirements';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -51,7 +51,7 @@ CREATE TABLE `achievement_criteria_data` (
   `type` tinyint unsigned NOT NULL DEFAULT '0',
   `value1` int unsigned NOT NULL DEFAULT '0',
   `value2` int unsigned NOT NULL DEFAULT '0',
-  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`criteria_id`,`type`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Achievment system';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -88,8 +88,8 @@ CREATE TABLE `achievement_reward` (
   `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,
+  `Subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `MailTemplateID` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
@@ -104,9 +104,9 @@ DROP TABLE IF EXISTS `achievement_reward_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `achievement_reward_locale` (
   `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,
+  `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Subject` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`ID`,`Locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -134,7 +134,7 @@ DROP TABLE IF EXISTS `areatrigger_scripts`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `areatrigger_scripts` (
   `entry` int NOT NULL,
-  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
   PRIMARY KEY (`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -148,7 +148,7 @@ DROP TABLE IF EXISTS `areatrigger_tavern`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `areatrigger_tavern` (
   `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
-  `name` mediumtext COLLATE utf8mb4_unicode_ci,
+  `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -162,13 +162,13 @@ DROP TABLE IF EXISTS `areatrigger_teleport`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `areatrigger_teleport` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `Name` mediumtext COLLATE utf8mb4_unicode_ci,
+  `Name` mediumtext CHARACTER SET utf8mb4 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',
   `target_position_z` float NOT NULL DEFAULT '0',
   `target_orientation` float NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`),
   FULLTEXT KEY `name` (`Name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System';
@@ -183,8 +183,8 @@ DROP TABLE IF EXISTS `battlefield_template`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `battlefield_template` (
   `TypeId` tinyint unsigned NOT NULL,
-  `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
-  `comment` mediumtext COLLATE utf8mb4_unicode_ci
+  `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -207,8 +207,8 @@ CREATE TABLE `battleground_template` (
   `HordeStartO` float NOT NULL,
   `StartMaxDist` float NOT NULL DEFAULT '0',
   `Weight` tinyint unsigned NOT NULL DEFAULT '1',
-  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
-  `Comment` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `Comment` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
   PRIMARY KEY (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -237,8 +237,8 @@ DROP TABLE IF EXISTS `broadcast_text`;
 CREATE TABLE `broadcast_text` (
   `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,
+  `Text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text1` longtext CHARACTER SET utf8mb4 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',
@@ -262,10 +262,10 @@ DROP TABLE IF EXISTS `broadcast_text_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `broadcast_text_locale` (
   `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',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -278,8 +278,8 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
-  `help` longtext COLLATE utf8mb4_unicode_ci,
+  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `help` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Chat System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -305,8 +305,8 @@ CREATE TABLE `conditions` (
   `NegativeCondition` tinyint unsigned NOT NULL DEFAULT '0',
   `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,
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Condition System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -341,7 +341,7 @@ CREATE TABLE `creature` (
   `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) COLLATE utf8mb4_unicode_ci DEFAULT '',
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
   `VerifiedBuild` int DEFAULT '0',
   PRIMARY KEY (`guid`),
   KEY `idx_map` (`map`),
@@ -368,7 +368,7 @@ CREATE TABLE `creature_addon` (
   `PvPFlags` tinyint unsigned NOT NULL DEFAULT '0',
   `emote` int unsigned NOT NULL DEFAULT '0',
   `visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0',
-  `auras` mediumtext COLLATE utf8mb4_unicode_ci,
+  `auras` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -393,7 +393,7 @@ 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` mediumtext COLLATE utf8mb4_unicode_ci,
+  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`level`,`class`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -425,7 +425,7 @@ CREATE TABLE `creature_equip_template` (
   `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',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`CreatureID`,`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -466,7 +466,7 @@ CREATE TABLE `creature_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -570,7 +570,7 @@ CREATE TABLE `creature_questitem` (
   `CreatureEntry` int unsigned NOT NULL DEFAULT '0',
   `Idx` int unsigned NOT NULL DEFAULT '0',
   `ItemId` int unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`CreatureEntry`,`Idx`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -607,7 +607,7 @@ CREATE TABLE `creature_summon_groups` (
   `orientation` float NOT NULL DEFAULT '0',
   `summonType` tinyint unsigned NOT NULL DEFAULT '0',
   `summonTime` int unsigned NOT NULL DEFAULT '0',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -629,9 +629,9 @@ CREATE TABLE `creature_template` (
   `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,
+  `name` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
+  `subname` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `IconName` char(100) CHARACTER SET utf8mb4 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',
@@ -661,7 +661,7 @@ CREATE TABLE `creature_template` (
   `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 '',
+  `AIName` char(64) CHARACTER SET utf8mb4 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',
@@ -675,8 +675,8 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`entry`),
   KEY `idx_name` (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System';
@@ -701,7 +701,7 @@ CREATE TABLE `creature_template_addon` (
   `PvPFlags` tinyint unsigned NOT NULL DEFAULT '0',
   `emote` int unsigned NOT NULL DEFAULT '0',
   `visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0',
-  `auras` mediumtext COLLATE utf8mb4_unicode_ci,
+  `auras` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -715,10 +715,10 @@ DROP TABLE IF EXISTS `creature_template_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `creature_template_locale` (
   `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',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Title` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`entry`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -754,7 +754,7 @@ CREATE TABLE `creature_template_resistance` (
   `CreatureID` int unsigned NOT NULL,
   `School` tinyint unsigned NOT NULL,
   `Resistance` smallint DEFAULT NULL,
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`CreatureID`,`School`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -770,7 +770,7 @@ CREATE TABLE `creature_template_spell` (
   `CreatureID` int unsigned NOT NULL,
   `Index` tinyint unsigned NOT NULL DEFAULT '0',
   `Spell` int unsigned NOT NULL,
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`CreatureID`,`Index`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -786,7 +786,7 @@ CREATE TABLE `creature_text` (
   `CreatureID` int unsigned NOT NULL DEFAULT '0',
   `GroupID` tinyint unsigned NOT NULL DEFAULT '0',
   `ID` tinyint unsigned NOT NULL DEFAULT '0',
-  `Text` longtext COLLATE utf8mb4_unicode_ci,
+  `Text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `Type` tinyint unsigned NOT NULL DEFAULT '0',
   `Language` tinyint NOT NULL DEFAULT '0',
   `Probability` float unsigned NOT NULL DEFAULT '0',
@@ -795,7 +795,7 @@ CREATE TABLE `creature_text` (
   `Sound` int unsigned NOT NULL DEFAULT '0',
   `BroadcastTextId` int NOT NULL DEFAULT '0',
   `TextRange` tinyint unsigned NOT NULL DEFAULT '0',
-  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
+  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
   PRIMARY KEY (`CreatureID`,`GroupID`,`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -811,8 +811,8 @@ CREATE TABLE `creature_text_locale` (
   `CreatureID` int unsigned NOT NULL DEFAULT '0',
   `GroupID` tinyint unsigned NOT NULL DEFAULT '0',
   `ID` tinyint unsigned NOT NULL DEFAULT '0',
-  `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `Text` mediumtext COLLATE utf8mb4_unicode_ci,
+  `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`CreatureID`,`GroupID`,`ID`,`Locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -828,9 +828,9 @@ CREATE TABLE `disables` (
   `sourceType` int unsigned NOT NULL,
   `entry` int unsigned NOT NULL,
   `flags` smallint NOT NULL,
-  `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 '',
+  `params_0` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `params_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`sourceType`,`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -852,7 +852,7 @@ CREATE TABLE `disenchant_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -875,7 +875,7 @@ CREATE TABLE `event_scripts` (
   `y` float NOT NULL DEFAULT '0',
   `z` float NOT NULL DEFAULT '0',
   `o` float NOT NULL DEFAULT '0',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -910,7 +910,7 @@ CREATE TABLE `fishing_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -930,7 +930,7 @@ CREATE TABLE `game_event` (
   `length` bigint unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event',
   `holiday` int unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id',
   `holidayStage` tinyint unsigned NOT NULL DEFAULT '0',
-  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the event displayed in console',
+  `description` varchar(255) CHARACTER SET utf8mb4 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`)
@@ -978,7 +978,7 @@ CREATE TABLE `game_event_condition` (
   `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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `description` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`eventEntry`,`condition_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1165,7 +1165,7 @@ CREATE TABLE `game_tele` (
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float NOT NULL DEFAULT '0',
   `map` smallint unsigned NOT NULL DEFAULT '0',
-  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1191,7 +1191,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`zone`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Weather System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1222,8 +1222,8 @@ 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) COLLATE utf8mb4_unicode_ci DEFAULT '',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`guid`)
 ) ENGINE=InnoDB AUTO_INCREMENT=2134507 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1264,7 +1264,7 @@ CREATE TABLE `gameobject_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1309,7 +1309,7 @@ CREATE TABLE `gameobject_questitem` (
   `GameObjectEntry` int unsigned NOT NULL DEFAULT '0',
   `Idx` int unsigned NOT NULL DEFAULT '0',
   `ItemId` int unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`GameObjectEntry`,`Idx`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1339,10 +1339,10 @@ CREATE TABLE `gameobject_template` (
   `entry` int unsigned NOT NULL DEFAULT '0',
   `type` tinyint unsigned NOT NULL DEFAULT '0',
   `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 '',
+  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `IconName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `castBarCaption` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `unk1` varchar(100) CHARACTER SET utf8mb4 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',
@@ -1368,9 +1368,9 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
-  `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `AIName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`entry`),
   KEY `idx_name` (`name`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System';
@@ -1406,10 +1406,10 @@ DROP TABLE IF EXISTS `gameobject_template_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `gameobject_template_locale` (
   `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',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `castBarCaption` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`entry`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1440,7 +1440,7 @@ CREATE TABLE `gossip_menu_option` (
   `MenuID` smallint unsigned NOT NULL DEFAULT '0',
   `OptionID` smallint unsigned NOT NULL DEFAULT '0',
   `OptionIcon` int unsigned NOT NULL DEFAULT '0',
-  `OptionText` mediumtext COLLATE utf8mb4_unicode_ci,
+  `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `OptionBroadcastTextID` int NOT NULL DEFAULT '0',
   `OptionType` tinyint unsigned NOT NULL DEFAULT '0',
   `OptionNpcFlag` int unsigned NOT NULL DEFAULT '0',
@@ -1448,7 +1448,7 @@ CREATE TABLE `gossip_menu_option` (
   `ActionPoiID` int unsigned NOT NULL DEFAULT '0',
   `BoxCoded` tinyint unsigned NOT NULL DEFAULT '0',
   `BoxMoney` int unsigned NOT NULL DEFAULT '0',
-  `BoxText` mediumtext COLLATE utf8mb4_unicode_ci,
+  `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `BoxBroadcastTextID` int NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`MenuID`,`OptionID`)
@@ -1465,9 +1465,9 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `OptionText` mediumtext COLLATE utf8mb4_unicode_ci,
-  `BoxText` mediumtext COLLATE utf8mb4_unicode_ci,
+  `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`MenuID`,`OptionID`,`Locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1483,7 +1483,7 @@ CREATE TABLE `graveyard_zone` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `GhostZone` int unsigned NOT NULL DEFAULT '0',
   `Faction` smallint unsigned NOT NULL DEFAULT '0',
-  `Comment` mediumtext COLLATE utf8mb4_unicode_ci,
+  `Comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`ID`,`GhostZone`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1516,7 +1516,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1548,7 +1548,7 @@ DROP TABLE IF EXISTS `instance_template`;
 CREATE TABLE `instance_template` (
   `map` smallint unsigned NOT NULL,
   `parent` smallint unsigned NOT NULL,
-  `script` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `script` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `allowMount` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`map`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -1586,7 +1586,7 @@ CREATE TABLE `item_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1600,9 +1600,9 @@ DROP TABLE IF EXISTS `item_set_names`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_set_names` (
   `entry` int unsigned NOT NULL,
-  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   `InventoryType` tinyint unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1616,9 +1616,9 @@ DROP TABLE IF EXISTS `item_set_names_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_set_names_locale` (
   `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',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1635,7 +1635,7 @@ CREATE TABLE `item_template` (
   `class` tinyint unsigned NOT NULL DEFAULT '0',
   `subclass` tinyint unsigned NOT NULL DEFAULT '0',
   `SoundOverrideSubclass` tinyint NOT NULL DEFAULT '-1',
-  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `name` varchar(255) CHARACTER SET utf8mb4 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',
@@ -1733,7 +1733,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `description` varchar(255) CHARACTER SET utf8mb4 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',
@@ -1763,13 +1763,13 @@ CREATE TABLE `item_template` (
   `duration` int unsigned NOT NULL DEFAULT '0',
   `ItemLimitCategory` smallint NOT NULL DEFAULT '0',
   `HolidayId` int unsigned NOT NULL DEFAULT '0',
-  `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `ScriptName` varchar(64) CHARACTER SET utf8mb4 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',
   `flagsCustom` int unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`entry`),
   KEY `idx_name` (`name`),
   KEY `items_index` (`class`)
@@ -1785,10 +1785,10 @@ DROP TABLE IF EXISTS `item_template_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `item_template_locale` (
   `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',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1823,7 +1823,7 @@ CREATE TABLE `lfg_dungeon_template` (
   `position_y` float NOT NULL DEFAULT '0',
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`dungeonId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1876,7 +1876,7 @@ CREATE TABLE `mail_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1898,7 +1898,7 @@ CREATE TABLE `milling_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -1928,8 +1928,8 @@ DROP TABLE IF EXISTS `npc_text`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `npc_text` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `text0_0` longtext COLLATE utf8mb4_unicode_ci,
-  `text0_1` longtext COLLATE utf8mb4_unicode_ci,
+  `text0_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `text0_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `BroadcastTextID0` int NOT NULL DEFAULT '0',
   `lang0` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability0` float NOT NULL DEFAULT '0',
@@ -1939,8 +1939,8 @@ 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 COLLATE utf8mb4_unicode_ci,
-  `text1_1` longtext COLLATE utf8mb4_unicode_ci,
+  `text1_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `text1_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `BroadcastTextID1` int NOT NULL DEFAULT '0',
   `lang1` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability1` float NOT NULL DEFAULT '0',
@@ -1950,8 +1950,8 @@ 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 COLLATE utf8mb4_unicode_ci,
-  `text2_1` longtext COLLATE utf8mb4_unicode_ci,
+  `text2_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `text2_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `BroadcastTextID2` int NOT NULL DEFAULT '0',
   `lang2` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability2` float NOT NULL DEFAULT '0',
@@ -1961,8 +1961,8 @@ 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 COLLATE utf8mb4_unicode_ci,
-  `text3_1` longtext COLLATE utf8mb4_unicode_ci,
+  `text3_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `text3_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `BroadcastTextID3` int NOT NULL DEFAULT '0',
   `lang3` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability3` float NOT NULL DEFAULT '0',
@@ -1972,8 +1972,8 @@ 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 COLLATE utf8mb4_unicode_ci,
-  `text4_1` longtext COLLATE utf8mb4_unicode_ci,
+  `text4_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `text4_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `BroadcastTextID4` int NOT NULL DEFAULT '0',
   `lang4` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability4` float NOT NULL DEFAULT '0',
@@ -1983,8 +1983,8 @@ 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 COLLATE utf8mb4_unicode_ci,
-  `text5_1` longtext COLLATE utf8mb4_unicode_ci,
+  `text5_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `text5_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `BroadcastTextID5` int NOT NULL DEFAULT '0',
   `lang5` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability5` float NOT NULL DEFAULT '0',
@@ -1994,8 +1994,8 @@ 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 COLLATE utf8mb4_unicode_ci,
-  `text6_1` longtext COLLATE utf8mb4_unicode_ci,
+  `text6_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `text6_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `BroadcastTextID6` int NOT NULL DEFAULT '0',
   `lang6` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability6` float NOT NULL DEFAULT '0',
@@ -2005,8 +2005,8 @@ 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 COLLATE utf8mb4_unicode_ci,
-  `text7_1` longtext COLLATE utf8mb4_unicode_ci,
+  `text7_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `text7_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `BroadcastTextID7` int NOT NULL DEFAULT '0',
   `lang7` tinyint unsigned NOT NULL DEFAULT '0',
   `Probability7` float NOT NULL DEFAULT '0',
@@ -2016,7 +2016,7 @@ CREATE TABLE `npc_text` (
   `Emote7_1` smallint unsigned NOT NULL DEFAULT '0',
   `EmoteDelay7_2` smallint unsigned NOT NULL DEFAULT '0',
   `Emote7_2` smallint unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2030,23 +2030,23 @@ DROP TABLE IF EXISTS `npc_text_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `npc_text_locale` (
   `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,
+  `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text0_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text0_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text1_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text1_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text2_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text2_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text3_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text3_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text4_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text4_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text5_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text5_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text6_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text6_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text7_0` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Text7_1` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`ID`,`Locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2065,7 +2065,7 @@ CREATE TABLE `npc_vendor` (
   `maxcount` tinyint unsigned NOT NULL DEFAULT '0',
   `incrtime` int unsigned NOT NULL DEFAULT '0',
   `ExtendedCost` int unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`entry`,`item`,`ExtendedCost`),
   KEY `slot` (`slot`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Npc System';
@@ -2080,8 +2080,8 @@ DROP TABLE IF EXISTS `outdoorpvp_template`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `outdoorpvp_template` (
   `TypeId` tinyint unsigned NOT NULL,
-  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
-  `comment` mediumtext COLLATE utf8mb4_unicode_ci,
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`TypeId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='OutdoorPvP Templates';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2095,7 +2095,7 @@ DROP TABLE IF EXISTS `page_text`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `page_text` (
   `ID` int unsigned NOT NULL DEFAULT '0',
-  `Text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
   `NextPageID` int unsigned NOT NULL DEFAULT '0',
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
@@ -2111,9 +2111,9 @@ DROP TABLE IF EXISTS `page_text_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `page_text_locale` (
   `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',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2151,7 +2151,7 @@ DROP TABLE IF EXISTS `pet_name_generation`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `pet_name_generation` (
   `id` int unsigned NOT NULL,
-  `word` text COLLATE utf8mb4_unicode_ci NOT NULL,
+  `word` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
   `entry` int unsigned NOT NULL DEFAULT '0',
   `half` tinyint unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`)
@@ -2175,7 +2175,7 @@ CREATE TABLE `pickpocketing_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2220,10 +2220,10 @@ 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` mediumtext COLLATE utf8mb4_unicode_ci,
+  `commentA` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `race_H` int unsigned NOT NULL,
   `horde_id` int unsigned NOT NULL,
-  `commentH` mediumtext COLLATE utf8mb4_unicode_ci,
+  `commentH` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`alliance_id`,`horde_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2384,7 +2384,7 @@ CREATE TABLE `playercreateinfo_cast_spell` (
   `raceMask` int unsigned NOT NULL DEFAULT '0',
   `classMask` int unsigned NOT NULL DEFAULT '0',
   `spell` int unsigned NOT NULL DEFAULT '0',
-  `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
+  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -2417,7 +2417,7 @@ CREATE TABLE `playercreateinfo_skills` (
   `classMask` int unsigned NOT NULL,
   `skill` smallint unsigned NOT NULL,
   `rank` smallint unsigned NOT NULL DEFAULT '0',
-  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`raceMask`,`classMask`,`skill`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2433,7 +2433,7 @@ CREATE TABLE `playercreateinfo_spell_custom` (
   `racemask` int unsigned NOT NULL DEFAULT '0',
   `classmask` int unsigned NOT NULL DEFAULT '0',
   `Spell` int unsigned NOT NULL DEFAULT '0',
-  `Note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`racemask`,`classmask`,`Spell`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2452,8 +2452,8 @@ CREATE TABLE `points_of_interest` (
   `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',
+  `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2467,9 +2467,9 @@ DROP TABLE IF EXISTS `points_of_interest_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `points_of_interest_locale` (
   `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',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2486,7 +2486,7 @@ CREATE TABLE `pool_members` (
   `spawnId` int unsigned NOT NULL,
   `poolSpawnId` int unsigned NOT NULL,
   `chance` float NOT NULL,
-  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`type`,`spawnId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2501,7 +2501,7 @@ DROP TABLE IF EXISTS `pool_template`;
 CREATE TABLE `pool_template` (
   `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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2523,7 +2523,7 @@ CREATE TABLE `prospecting_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2562,8 +2562,8 @@ CREATE TABLE `quest_greeting` (
   `Type` tinyint unsigned NOT NULL DEFAULT '0',
   `GreetEmoteType` smallint unsigned NOT NULL DEFAULT '0',
   `GreetEmoteDelay` int unsigned NOT NULL DEFAULT '0',
-  `Greeting` mediumtext COLLATE utf8mb4_unicode_ci,
-  `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+  `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`Type`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2578,9 +2578,9 @@ DROP TABLE IF EXISTS `quest_greeting_locale`;
 CREATE TABLE `quest_greeting_locale` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `Type` tinyint unsigned NOT NULL DEFAULT '0',
-  `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `Greeting` mediumtext COLLATE utf8mb4_unicode_ci,
-  `VerifiedBuild` smallint DEFAULT '0',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`Type`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2616,7 +2616,7 @@ 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` mediumtext COLLATE utf8mb4_unicode_ci,
+  `RewardText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2631,9 +2631,9 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `RewardText` mediumtext COLLATE utf8mb4_unicode_ci,
-  `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `RewardText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2654,7 +2654,7 @@ CREATE TABLE `quest_poi` (
   `Floor` int unsigned NOT NULL DEFAULT '0',
   `Priority` int unsigned NOT NULL DEFAULT '0',
   `Flags` int unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`QuestID`,`id`),
   KEY `idx` (`QuestID`,`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2673,7 +2673,7 @@ CREATE TABLE `quest_poi_points` (
   `Idx2` int unsigned NOT NULL DEFAULT '0',
   `X` int NOT NULL DEFAULT '0',
   `Y` int NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`QuestID`,`Idx1`,`Idx2`),
   KEY `questId_id` (`QuestID`,`Idx1`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2690,7 +2690,7 @@ 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`questId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2705,7 +2705,7 @@ DROP TABLE IF EXISTS `quest_pool_template`;
 CREATE TABLE `quest_pool_template` (
   `poolId` int unsigned NOT NULL,
   `numActive` int unsigned NOT NULL COMMENT 'Number of indices to have active at any time',
-  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`poolId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2721,7 +2721,7 @@ CREATE TABLE `quest_request_items` (
   `ID` int unsigned NOT NULL DEFAULT '0',
   `EmoteOnComplete` smallint unsigned NOT NULL DEFAULT '0',
   `EmoteOnIncomplete` smallint unsigned NOT NULL DEFAULT '0',
-  `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci,
+  `CompletionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `VerifiedBuild` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2736,9 +2736,9 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci,
-  `VerifiedBuild` smallint NOT NULL DEFAULT '0',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `CompletionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2825,11 +2825,11 @@ CREATE TABLE `quest_template` (
   `RewardFactionOverride5` int NOT NULL DEFAULT '0',
   `TimeAllowed` int unsigned NOT NULL DEFAULT '0',
   `AllowableRaces` smallint unsigned 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,
+  `LogTitle` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `LogDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `QuestDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `AreaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `QuestCompletionLog` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   `RequiredNpcOrGo1` int NOT NULL DEFAULT '0',
   `RequiredNpcOrGo2` int NOT NULL DEFAULT '0',
   `RequiredNpcOrGo3` int NOT NULL DEFAULT '0',
@@ -2851,11 +2851,11 @@ 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` 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',
+  `ObjectiveText1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText2` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText3` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText4` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Quest System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2899,17 +2899,17 @@ DROP TABLE IF EXISTS `quest_template_locale`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `quest_template_locale` (
   `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',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Title` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Details` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `Objectives` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `EndText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `CompletedText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText2` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText3` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ObjectiveText4` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -2931,7 +2931,7 @@ CREATE TABLE `reference_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3032,7 +3032,7 @@ CREATE TABLE `script_waypoint` (
   `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` mediumtext COLLATE utf8mb4_unicode_ci,
+  `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`entry`,`pointid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Script Creature waypoints';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3116,7 +3116,7 @@ CREATE TABLE `skinning_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3158,7 +3158,7 @@ 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` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment',
+  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment',
   PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3187,7 +3187,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `groupName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
   `groupFlags` int unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`groupId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3228,7 +3228,7 @@ CREATE TABLE `spell_bonus_data` (
   `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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3337,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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `SpellName` varchar(100) CHARACTER SET utf8mb4 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',
@@ -3426,7 +3426,7 @@ CREATE TABLE `spell_linked_spell` (
   `spell_trigger` int NOT NULL,
   `spell_effect` int NOT NULL DEFAULT '0',
   `type` tinyint unsigned NOT NULL DEFAULT '0',
-  `comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
+  `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
   UNIQUE KEY `trigger_effect_type` (`spell_trigger`,`spell_effect`,`type`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3448,7 +3448,7 @@ CREATE TABLE `spell_loot_template` (
   `GroupId` tinyint unsigned NOT NULL DEFAULT '0',
   `MinCount` tinyint unsigned NOT NULL DEFAULT '1',
   `MaxCount` tinyint unsigned NOT NULL DEFAULT '1',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`Entry`,`Item`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3536,7 +3536,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
   UNIQUE KEY `spell_id` (`spell_id`,`ScriptName`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3560,7 +3560,7 @@ CREATE TABLE `spell_scripts` (
   `y` float NOT NULL DEFAULT '0',
   `z` float NOT NULL DEFAULT '0',
   `o` float NOT NULL DEFAULT '0',
-  `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ''
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
@@ -3579,7 +3579,7 @@ CREATE TABLE `spell_target_position` (
   `PositionY` float NOT NULL DEFAULT '0',
   `PositionZ` float NOT NULL DEFAULT '0',
   `Orientation` float NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`ID`,`EffectIndex`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3628,8 +3628,8 @@ CREATE TABLE `trainer` (
   `Id` int unsigned NOT NULL DEFAULT '0',
   `Type` tinyint unsigned NOT NULL DEFAULT '2',
   `Requirement` int unsigned NOT NULL DEFAULT '0',
-  `Greeting` mediumtext COLLATE utf8mb4_unicode_ci,
-  `VerifiedBuild` smallint DEFAULT '0',
+  `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`Id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3643,9 +3643,9 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL,
-  `Greeting_lang` mediumtext COLLATE utf8mb4_unicode_ci,
-  `VerifiedBuild` smallint DEFAULT '0',
+  `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `Greeting_lang` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`Id`,`locale`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3667,7 +3667,7 @@ CREATE TABLE `trainer_spell` (
   `ReqAbility2` int unsigned NOT NULL DEFAULT '0',
   `ReqAbility3` int unsigned NOT NULL DEFAULT '0',
   `ReqLevel` tinyint unsigned NOT NULL DEFAULT '0',
-  `VerifiedBuild` smallint DEFAULT '0',
+  `VerifiedBuild` int DEFAULT NULL,
   PRIMARY KEY (`TrainerId`,`SpellId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3682,8 +3682,8 @@ DROP TABLE IF EXISTS `transports`;
 CREATE TABLE `transports` (
   `guid` int unsigned NOT NULL AUTO_INCREMENT,
   `entry` int unsigned NOT NULL DEFAULT '0',
-  `name` mediumtext COLLATE utf8mb4_unicode_ci,
-  `ScriptName` char(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `ScriptName` char(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`guid`),
   UNIQUE KEY `idx_entry` (`entry`)
 ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Transports';
@@ -3698,15 +3698,15 @@ DROP TABLE IF EXISTS `trinity_string`;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `trinity_string` (
   `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,
+  `content_default` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
+  `content_loc1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `content_loc2` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `content_loc3` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `content_loc4` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `content_loc5` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `content_loc6` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `content_loc7` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+  `content_loc8` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`entry`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3719,9 +3719,9 @@ 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) 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.',
+  `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.',
+  `hash` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.',
+  `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 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`)
@@ -3736,8 +3736,8 @@ 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) 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.',
+  `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
+  `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
   PRIMARY KEY (`path`)
 ) 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 */;
@@ -3754,7 +3754,7 @@ CREATE TABLE `vehicle_accessory` (
   `accessory_entry` int unsigned NOT NULL DEFAULT '0',
   `seat_id` tinyint NOT NULL DEFAULT '0',
   `minion` tinyint unsigned NOT NULL DEFAULT '0',
-  `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
+  `description` mediumtext CHARACTER SET utf8mb4 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`)
@@ -3806,7 +3806,7 @@ CREATE TABLE `vehicle_template_accessory` (
   `accessory_entry` int unsigned NOT NULL DEFAULT '0',
   `seat_id` tinyint NOT NULL DEFAULT '0',
   `minion` tinyint unsigned NOT NULL DEFAULT '0',
-  `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
+  `description` mediumtext CHARACTER SET utf8mb4 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`)
@@ -3821,9 +3821,9 @@ 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) 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.',
+  `core_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.',
+  `core_revision` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `db_version` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Version of world DB.',
   `cache_id` int DEFAULT '0',
   PRIMARY KEY (`core_version`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Version Notes';
@@ -3923,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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `str` varchar(170) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `address` int unsigned DEFAULT NULL,
   `length` tinyint unsigned DEFAULT NULL,
-  `comment` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `comment` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   `data` binary(24) DEFAULT NULL,
   `result` varbinary(24) DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=791 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+) ENGINE=InnoDB AUTO_INCREMENT=812 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -3975,7 +3975,7 @@ 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+  `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
   PRIMARY KEY (`guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3995,7 +3995,7 @@ CREATE TABLE `waypoints` (
   `position_z` float NOT NULL DEFAULT '0',
   `orientation` float DEFAULT NULL,
   `delay` int unsigned NOT NULL DEFAULT '0',
-  `point_comment` mediumtext COLLATE utf8mb4_unicode_ci,
+  `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
   PRIMARY KEY (`entry`,`pointid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature waypoints';
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -4067,4 +4067,4 @@ CREATE TABLE `waypoints` (
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2023-01-16 11:08:18
+-- Dump completed on 2023-06-14 19:34:39
diff --git a/sql/updates/auth/3.3.5/2023_01_16_00_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_01_16_00_auth.sql
index 2b56c992617..2b56c992617 100644
--- a/sql/updates/auth/3.3.5/2023_01_16_00_auth.sql
+++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_01_16_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2023_02_05_00_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_00_auth.sql
index a1db2d6b2a9..a1db2d6b2a9 100644
--- a/sql/updates/auth/3.3.5/2023_02_05_00_auth.sql
+++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2023_02_05_01_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_01_auth.sql
index c1cca3f8c7d..c1cca3f8c7d 100644
--- a/sql/updates/auth/3.3.5/2023_02_05_01_auth.sql
+++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_01_auth.sql
diff --git a/sql/updates/auth/3.3.5/2023_05_05_00_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_05_05_00_auth.sql
index c4b98641686..c4b98641686 100644
--- a/sql/updates/auth/3.3.5/2023_05_05_00_auth.sql
+++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_05_05_00_auth.sql
diff --git a/sql/updates/characters/3.3.5/2023_01_16_00_characters.sql b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_01_16_00_characters.sql
index 518902308ae..518902308ae 100644
--- a/sql/updates/characters/3.3.5/2023_01_16_00_characters.sql
+++ b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_01_16_00_characters.sql
diff --git a/sql/updates/characters/3.3.5/2023_02_05_00_characters.sql b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_00_characters.sql
index 60f84b11235..60f84b11235 100644
--- a/sql/updates/characters/3.3.5/2023_02_05_00_characters.sql
+++ b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_00_characters.sql
diff --git a/sql/updates/characters/3.3.5/2023_02_05_01_characters.sql b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_01_characters.sql
index c1cca3f8c7d..c1cca3f8c7d 100644
--- a/sql/updates/characters/3.3.5/2023_02_05_01_characters.sql
+++ b/sql/old/3.3.5a/characters/23011_2023_06_14/2023_02_05_01_characters.sql
diff --git a/sql/updates/world/3.3.5/2023_01_16_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_01_16_00_world.sql
index 425832740e8..425832740e8 100644
--- a/sql/updates/world/3.3.5/2023_01_16_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_01_16_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_03_24_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_03_24_00_world.sql
index e4e280580b3..e4e280580b3 100644
--- a/sql/updates/world/3.3.5/2023_03_24_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_03_24_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_05_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_00_world.sql
index e6439cc825b..e6439cc825b 100644
--- a/sql/updates/world/3.3.5/2023_04_05_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_05_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_01_world.sql
index 7944655cd89..7944655cd89 100644
--- a/sql/updates/world/3.3.5/2023_04_05_01_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_01_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_05_02_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_02_world.sql
index 4bedfe2136a..4bedfe2136a 100644
--- a/sql/updates/world/3.3.5/2023_04_05_02_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_02_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_05_03_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_03_world.sql
index 29f769d3699..29f769d3699 100644
--- a/sql/updates/world/3.3.5/2023_04_05_03_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_03_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_05_04_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_04_world.sql
index 7c2f16efd45..7c2f16efd45 100644
--- a/sql/updates/world/3.3.5/2023_04_05_04_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_04_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_05_05_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_05_world.sql
index 23daff98f38..23daff98f38 100644
--- a/sql/updates/world/3.3.5/2023_04_05_05_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_05_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_05_06_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_06_world.sql
index 015d1035ff8..015d1035ff8 100644
--- a/sql/updates/world/3.3.5/2023_04_05_06_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_05_06_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_06_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_00_world.sql
index 7515a92ee56..7515a92ee56 100644
--- a/sql/updates/world/3.3.5/2023_04_06_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_06_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_01_world.sql
index c9519266151..c9519266151 100644
--- a/sql/updates/world/3.3.5/2023_04_06_01_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_01_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_06_02_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_02_world.sql
index 4e42780f230..4e42780f230 100644
--- a/sql/updates/world/3.3.5/2023_04_06_02_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_02_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_06_03_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_03_world.sql
index a33546f4630..a33546f4630 100644
--- a/sql/updates/world/3.3.5/2023_04_06_03_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_03_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_06_04_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_04_world.sql
index 47b0d57d8f1..47b0d57d8f1 100644
--- a/sql/updates/world/3.3.5/2023_04_06_04_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_04_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_06_05_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_05_world.sql
index 1f9a88d40bb..1f9a88d40bb 100644
--- a/sql/updates/world/3.3.5/2023_04_06_05_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_05_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_06_06_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_06_world.sql
index 8edd584e63b..8edd584e63b 100644
--- a/sql/updates/world/3.3.5/2023_04_06_06_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_06_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_06_07_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_07_world.sql
index 2d243f0f44f..2d243f0f44f 100644
--- a/sql/updates/world/3.3.5/2023_04_06_07_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_06_07_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_07_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_07_00_world.sql
index 02868a65a30..02868a65a30 100644
--- a/sql/updates/world/3.3.5/2023_04_07_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_07_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_08_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_00_world.sql
index 0f99ce5d67e..0f99ce5d67e 100644
--- a/sql/updates/world/3.3.5/2023_04_08_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_08_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_01_world.sql
index dfffd1ba75a..dfffd1ba75a 100644
--- a/sql/updates/world/3.3.5/2023_04_08_01_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_08_01_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_20_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_20_00_world.sql
index a4d08177da6..a4d08177da6 100644
--- a/sql/updates/world/3.3.5/2023_04_20_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_25_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_25_00_world.sql
index bc794f330b1..bc794f330b1 100644
--- a/sql/updates/world/3.3.5/2023_04_25_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_25_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_28_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_28_00_world.sql
index 891561f3339..891561f3339 100644
--- a/sql/updates/world/3.3.5/2023_04_28_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_28_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_29_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_00_world.sql
index 4a7b0ff9555..4a7b0ff9555 100644
--- a/sql/updates/world/3.3.5/2023_04_29_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_04_29_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_01_world.sql
index e5b278a4c9a..e5b278a4c9a 100644
--- a/sql/updates/world/3.3.5/2023_04_29_01_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_04_29_01_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_05_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_05_00_world.sql
index 64d83138f92..64d83138f92 100644
--- a/sql/updates/world/3.3.5/2023_05_05_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_05_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_07_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_00_world.sql
index 0df13372961..0df13372961 100644
--- a/sql/updates/world/3.3.5/2023_05_07_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_07_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_01_world.sql
index 0bbe58fbbb2..0bbe58fbbb2 100644
--- a/sql/updates/world/3.3.5/2023_05_07_01_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_07_01_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_09_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_00_world.sql
index 1c90a3d9897..1c90a3d9897 100644
--- a/sql/updates/world/3.3.5/2023_05_09_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_09_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_01_world.sql
index 3409c102477..3409c102477 100644
--- a/sql/updates/world/3.3.5/2023_05_09_01_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_09_01_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_10_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_10_00_world.sql
index 7b7494fa4af..7b7494fa4af 100644
--- a/sql/updates/world/3.3.5/2023_05_10_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_10_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_11_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_11_00_world.sql
index cab83f5d0ab..cab83f5d0ab 100644
--- a/sql/updates/world/3.3.5/2023_05_11_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_11_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_14_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_00_world.sql
index 1353b77d46e..1353b77d46e 100644
--- a/sql/updates/world/3.3.5/2023_05_14_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_14_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_01_world.sql
index 6beeb4e0187..6beeb4e0187 100644
--- a/sql/updates/world/3.3.5/2023_05_14_01_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_14_01_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_15_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_00_world.sql
index 84e0462615f..84e0462615f 100644
--- a/sql/updates/world/3.3.5/2023_05_15_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_15_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_01_world.sql
index 0b3876dea7f..0b3876dea7f 100644
--- a/sql/updates/world/3.3.5/2023_05_15_01_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_15_01_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_16_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_16_00_world.sql
index 00737b62d2f..00737b62d2f 100644
--- a/sql/updates/world/3.3.5/2023_05_16_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_16_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_05_17_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_17_00_world.sql
index 699e6fa10f6..699e6fa10f6 100644
--- a/sql/updates/world/3.3.5/2023_05_17_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_05_17_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_06_11_00_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_00_world.sql
index 58b5b980d22..58b5b980d22 100644
--- a/sql/updates/world/3.3.5/2023_06_11_00_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_00_world.sql
diff --git a/sql/updates/world/3.3.5/2023_06_11_01_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_01_world.sql
index e246908b08f..e246908b08f 100644
--- a/sql/updates/world/3.3.5/2023_06_11_01_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_01_world.sql
diff --git a/sql/updates/world/3.3.5/2023_06_11_02_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_02_world.sql
index a3fd03e9080..a3fd03e9080 100644
--- a/sql/updates/world/3.3.5/2023_06_11_02_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_02_world.sql
diff --git a/sql/updates/world/3.3.5/2023_06_11_03_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_03_world.sql
index 1a16ec79528..1a16ec79528 100644
--- a/sql/updates/world/3.3.5/2023_06_11_03_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_03_world.sql
diff --git a/sql/updates/world/3.3.5/2023_06_11_04_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_04_world.sql
index 258d9a16731..258d9a16731 100644
--- a/sql/updates/world/3.3.5/2023_06_11_04_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_04_world.sql
diff --git a/sql/updates/world/3.3.5/2023_06_11_05_world.sql b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_05_world.sql
index b305f47a2f4..b305f47a2f4 100644
--- a/sql/updates/world/3.3.5/2023_06_11_05_world.sql
+++ b/sql/old/3.3.5a/world/23011_2023_06_14/2023_06_11_05_world.sql
diff --git a/sql/updates/auth/3.3.5/2023_06_14_00_auth.sql b/sql/updates/auth/3.3.5/2023_06_14_00_auth.sql
new file mode 100644
index 00000000000..90ead8908c8
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2023_06_14_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.23061 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2023_06_14_00_characters.sql b/sql/updates/characters/3.3.5/2023_06_14_00_characters.sql
new file mode 100644
index 00000000000..49ccffbdc2c
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2023_06_14_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.23061 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2023_06_14_00_world.sql b/sql/updates/world/3.3.5/2023_06_14_00_world.sql
new file mode 100644
index 00000000000..9820cf651bf
--- /dev/null
+++ b/sql/updates/world/3.3.5/2023_06_14_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.23061 world
+UPDATE `version` SET `db_version`='TDB 335.23061', `cache_id`=23061 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';
author	TDB Release <tdb-release@build.bot>	2023-06-14 19:37:17 +0000
committer	TDB Release <tdb-release@build.bot>	2023-06-14 19:37:17 +0000
commit	40d1f7a2e8fa54b3c9432b4432d6df968ec60cc4 (patch)
tree	c6f405d6af8b24fe8b30807e4d4562a8d7ffffb9
parent	d1c6b9d253faa61246f04058719f7f3c07548165 (diff)