refactor(DB/SQL): Update integer & utf to MySQL's new standards (#4929)

14 files changed, 76 insertions, 75 deletions

diff --git a/data/sql/base/db_auth/account.sql b/data/sql/base/db_auth/account.sql
index 28d12fedc8..3d7ab68d18 100644
--- a/data/sql/base/db_auth/account.sql
+++ b/data/sql/base/db_auth/account.sql
@@ -6,10 +6,10 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `account`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `account` 
 (
-  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
+  `id` INT unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
   `username` varchar(32) NOT NULL DEFAULT '',
   `sha_pass_hash` varchar(40) NOT NULL DEFAULT '',
   `sessionkey` varchar(80) NOT NULL DEFAULT '',
@@ -21,22 +21,22 @@ CREATE TABLE `account`
   `joindate` timestamp NOT NULL DEFAULT current_timestamp(),
   `last_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
   `last_attempt_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
-  `failed_logins` int(10) unsigned NOT NULL DEFAULT 0,
-  `locked` tinyint(3) unsigned NOT NULL DEFAULT 0,
+  `failed_logins` INT unsigned NOT NULL DEFAULT 0,
+  `locked` TINYINT unsigned NOT NULL DEFAULT 0,
   `lock_country` varchar(2) NOT NULL DEFAULT '00',
   `last_login` timestamp NULL DEFAULT NULL,
-  `online` int(10) unsigned NOT NULL DEFAULT 0,
-  `expansion` tinyint(3) unsigned NOT NULL DEFAULT 2,
-  `mutetime` bigint(20) NOT NULL DEFAULT 0,
+  `online` INT unsigned NOT NULL DEFAULT 0,
+  `expansion` TINYINT unsigned NOT NULL DEFAULT 2,
+  `mutetime` BIGINT NOT NULL DEFAULT 0,
   `mutereason` varchar(255) NOT NULL DEFAULT '',
   `muteby` varchar(50) NOT NULL DEFAULT '',
-  `locale` tinyint(3) unsigned NOT NULL DEFAULT 0,
+  `locale` TINYINT unsigned NOT NULL DEFAULT 0,
   `os` varchar(3) NOT NULL DEFAULT '',
-  `recruiter` int(10) unsigned NOT NULL DEFAULT 0,
-  `totaltime` int(10) unsigned NOT NULL DEFAULT 0,
+  `recruiter` INT unsigned NOT NULL DEFAULT 0,
+  `totaltime` INT unsigned NOT NULL DEFAULT 0,
   PRIMARY KEY (`id`),
   UNIQUE KEY `idx_username` (`username`)
-) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Account System';
+) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=UTF8MB4 COMMENT='Account System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `account` WRITE;
diff --git a/data/sql/base/db_auth/account_access.sql b/data/sql/base/db_auth/account_access.sql
index df0bebc46d..60dd5387e0 100644
--- a/data/sql/base/db_auth/account_access.sql
+++ b/data/sql/base/db_auth/account_access.sql
@@ -6,15 +6,15 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `account_access`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `account_access` 
 (
-  `id` int(10) unsigned NOT NULL,
-  `gmlevel` tinyint(3) unsigned NOT NULL,
-  `RealmID` int(11) NOT NULL DEFAULT -1,
+  `id` INT unsigned NOT NULL,
+  `gmlevel` TINYINT unsigned NOT NULL,
+  `RealmID` INT NOT NULL DEFAULT -1,
   `comment` varchar(255) DEFAULT '',
   PRIMARY KEY (`id`,`RealmID`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `account_access` WRITE;
diff --git a/data/sql/base/db_auth/account_banned.sql b/data/sql/base/db_auth/account_banned.sql
index cebaff245e..272d714317 100644
--- a/data/sql/base/db_auth/account_banned.sql
+++ b/data/sql/base/db_auth/account_banned.sql
@@ -6,17 +6,17 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `account_banned`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `account_banned` 
 (
-  `id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Account id',
-  `bandate` int(10) unsigned NOT NULL DEFAULT 0,
-  `unbandate` int(10) unsigned NOT NULL DEFAULT 0,
+  `id` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Account id',
+  `bandate` INT unsigned NOT NULL DEFAULT 0,
+  `unbandate` INT unsigned NOT NULL DEFAULT 0,
   `bannedby` varchar(50) NOT NULL,
   `banreason` varchar(255) NOT NULL,
-  `active` tinyint(3) unsigned NOT NULL DEFAULT 1,
+  `active` TINYINT unsigned NOT NULL DEFAULT 1,
   PRIMARY KEY (`id`,`bandate`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List';
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Ban List';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `account_banned` WRITE;
diff --git a/data/sql/base/db_auth/account_muted.sql b/data/sql/base/db_auth/account_muted.sql
index bf2bffe42a..256fcba7c9 100644
--- a/data/sql/base/db_auth/account_muted.sql
+++ b/data/sql/base/db_auth/account_muted.sql
@@ -6,12 +6,12 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `account_muted`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `account_muted` 
 (
-  `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier',
-  `mutedate` int(10) unsigned NOT NULL DEFAULT 0,
-  `mutetime` int(10) unsigned NOT NULL DEFAULT 0,
+  `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier',
+  `mutedate` INT unsigned NOT NULL DEFAULT 0,
+  `mutetime` INT unsigned NOT NULL DEFAULT 0,
   `mutedby` varchar(50) NOT NULL,
   `mutereason` varchar(255) NOT NULL,
   PRIMARY KEY (`guid`,`mutedate`)
diff --git a/data/sql/base/db_auth/autobroadcast.sql b/data/sql/base/db_auth/autobroadcast.sql
index e78521cb96..d638dd1d59 100644
--- a/data/sql/base/db_auth/autobroadcast.sql
+++ b/data/sql/base/db_auth/autobroadcast.sql
@@ -6,15 +6,15 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `autobroadcast`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `autobroadcast` 
 (
-  `realmid` int(11) NOT NULL DEFAULT -1,
-  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
-  `weight` tinyint(3) unsigned DEFAULT 1,
+  `realmid` INT NOT NULL DEFAULT -1,
+  `id` TINYINT unsigned NOT NULL AUTO_INCREMENT,
+  `weight` TINYINT unsigned DEFAULT 1,
   `text` longtext NOT NULL,
   PRIMARY KEY (`id`,`realmid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `autobroadcast` WRITE;
diff --git a/data/sql/base/db_auth/ip2nation.sql b/data/sql/base/db_auth/ip2nation.sql
index ad490dc645..ba1aebf717 100644
--- a/data/sql/base/db_auth/ip2nation.sql
+++ b/data/sql/base/db_auth/ip2nation.sql
@@ -6,13 +6,13 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `ip2nation`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `ip2nation` 
 (
-  `ip` int(11) unsigned NOT NULL DEFAULT 0,
+  `ip` INT unsigned NOT NULL DEFAULT 0,
   `country` char(2) NOT NULL DEFAULT '',
   KEY `ip` (`ip`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `ip2nation` WRITE;
diff --git a/data/sql/base/db_auth/ip2nationCountries.sql b/data/sql/base/db_auth/ip2nationCountries.sql
index 66251dd5a3..a14ddd46c6 100644
--- a/data/sql/base/db_auth/ip2nationCountries.sql
+++ b/data/sql/base/db_auth/ip2nationCountries.sql
@@ -6,7 +6,7 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `ip2nationCountries`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `ip2nationCountries`
 (
   `code` varchar(4) NOT NULL DEFAULT '',
@@ -18,7 +18,7 @@ CREATE TABLE `ip2nationCountries`
   `lon` float NOT NULL DEFAULT 0,
   PRIMARY KEY (`code`),
   KEY `code` (`code`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `ip2nationCountries` WRITE;
diff --git a/data/sql/base/db_auth/ip_banned.sql b/data/sql/base/db_auth/ip_banned.sql
index abe5b6aba4..56b80d1798 100644
--- a/data/sql/base/db_auth/ip_banned.sql
+++ b/data/sql/base/db_auth/ip_banned.sql
@@ -6,16 +6,16 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `ip_banned`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `ip_banned` 
 (
   `ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
-  `bandate` int(10) unsigned NOT NULL,
-  `unbandate` int(10) unsigned NOT NULL,
+  `bandate` INT unsigned NOT NULL,
+  `unbandate` INT unsigned NOT NULL,
   `bannedby` varchar(50) NOT NULL DEFAULT '[Console]',
   `banreason` varchar(255) NOT NULL DEFAULT 'no reason',
   PRIMARY KEY (`ip`,`bandate`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Banned IPs';
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Banned IPs';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `ip_banned` WRITE;
diff --git a/data/sql/base/db_auth/logs.sql b/data/sql/base/db_auth/logs.sql
index fb2150bc85..ff2d735a12 100644
--- a/data/sql/base/db_auth/logs.sql
+++ b/data/sql/base/db_auth/logs.sql
@@ -6,15 +6,15 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `logs`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `logs` 
 (
-  `time` int(10) unsigned NOT NULL,
-  `realm` int(10) unsigned NOT NULL,
+  `time` INT unsigned NOT NULL,
+  `realm` INT unsigned NOT NULL,
   `type` varchar(250) NOT NULL,
-  `level` tinyint(3) unsigned NOT NULL DEFAULT 0,
+  `level` TINYINT unsigned NOT NULL DEFAULT 0,
   `string` text CHARACTER SET latin1 DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `logs` WRITE;
diff --git a/data/sql/base/db_auth/logs_ip_actions.sql b/data/sql/base/db_auth/logs_ip_actions.sql
index 5eb2430001..baafe28e4d 100644
--- a/data/sql/base/db_auth/logs_ip_actions.sql
+++ b/data/sql/base/db_auth/logs_ip_actions.sql
@@ -6,20 +6,20 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `logs_ip_actions`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `logs_ip_actions` 
 (
-  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier',
-  `account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
-  `character_guid` int(10) unsigned NOT NULL COMMENT 'Character Guid',
-  `type` tinyint(3) unsigned NOT NULL,
+  `id` INT unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier',
+  `account_id` INT unsigned NOT NULL COMMENT 'Account ID',
+  `character_guid` INT unsigned NOT NULL COMMENT 'Character Guid',
+  `type` TINYINT unsigned NOT NULL,
   `ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
   `systemnote` text DEFAULT NULL COMMENT 'Notes inserted by system',
-  `unixtime` int(10) unsigned NOT NULL COMMENT 'Unixtime',
+  `unixtime` INT unsigned NOT NULL COMMENT 'Unixtime',
   `time` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Timestamp',
   `comment` text DEFAULT NULL COMMENT 'Allows users to add a comment',
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used to log ips of individual actions';
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Used to log ips of individual actions';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `logs_ip_actions` WRITE;
diff --git a/data/sql/base/db_auth/realmcharacters.sql b/data/sql/base/db_auth/realmcharacters.sql
index 7e5c7abf8d..dff2b12f3b 100644
--- a/data/sql/base/db_auth/realmcharacters.sql
+++ b/data/sql/base/db_auth/realmcharacters.sql
@@ -6,15 +6,15 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `realmcharacters`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `realmcharacters` 
 (
-  `realmid` int(10) unsigned NOT NULL DEFAULT 0,
-  `acctid` int(10) unsigned NOT NULL,
-  `numchars` tinyint(3) unsigned NOT NULL DEFAULT 0,
+  `realmid` INT unsigned NOT NULL DEFAULT 0,
+  `acctid` INT unsigned NOT NULL,
+  `numchars` TINYINT unsigned NOT NULL DEFAULT 0,
   PRIMARY KEY (`realmid`,`acctid`),
   KEY `acctid` (`acctid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Realm Character Tracker';
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Realm Character Tracker';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `realmcharacters` WRITE;
diff --git a/data/sql/base/db_auth/realmlist.sql b/data/sql/base/db_auth/realmlist.sql
index 2db9a56ae9..ecd0b054ad 100644
--- a/data/sql/base/db_auth/realmlist.sql
+++ b/data/sql/base/db_auth/realmlist.sql
@@ -6,24 +6,25 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `realmlist`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `realmlist` 
 (
-  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `id` INT unsigned NOT NULL AUTO_INCREMENT,
   `name` varchar(32) NOT NULL DEFAULT '',
   `address` varchar(255) NOT NULL DEFAULT '127.0.0.1',
   `localAddress` varchar(255) NOT NULL DEFAULT '127.0.0.1',
   `localSubnetMask` varchar(255) NOT NULL DEFAULT '255.255.255.0',
-  `port` smallint(5) unsigned NOT NULL DEFAULT 8085,
-  `icon` tinyint(3) unsigned NOT NULL DEFAULT 0,
-  `flag` tinyint(3) unsigned NOT NULL DEFAULT 2,
-  `timezone` tinyint(3) unsigned NOT NULL DEFAULT 0,
-  `allowedSecurityLevel` tinyint(3) unsigned NOT NULL DEFAULT 0,
-  `population` float unsigned NOT NULL DEFAULT 0,
-  `gamebuild` int(10) unsigned NOT NULL DEFAULT 12340,
+  `port` SMALLINT unsigned NOT NULL DEFAULT 8085,
+  `icon` TINYINT unsigned NOT NULL DEFAULT 0,
+  `flag` TINYINT unsigned NOT NULL DEFAULT 2,
+  `timezone` TINYINT unsigned NOT NULL DEFAULT 0,
+  `allowedSecurityLevel` TINYINT unsigned NOT NULL DEFAULT 0,
+  `population` FLOAT NOT NULL DEFAULT 0,
+  `gamebuild` INT unsigned NOT NULL DEFAULT 12340,
+  CHECK (`population`>=0),
   PRIMARY KEY (`id`),
   UNIQUE KEY `idx_name` (`name`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Realm System';
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=UTF8MB4 COMMENT='Realm System';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `realmlist` WRITE;
diff --git a/data/sql/base/db_auth/uptime.sql b/data/sql/base/db_auth/uptime.sql
index 61dd0eb5b6..9e01895b93 100644
--- a/data/sql/base/db_auth/uptime.sql
+++ b/data/sql/base/db_auth/uptime.sql
@@ -6,16 +6,16 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `uptime`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `uptime` 
 (
-  `realmid` int(10) unsigned NOT NULL,
-  `starttime` int(10) unsigned NOT NULL DEFAULT 0,
-  `uptime` int(10) unsigned NOT NULL DEFAULT 0,
-  `maxplayers` smallint(5) unsigned NOT NULL DEFAULT 0,
+  `realmid` INT unsigned NOT NULL,
+  `starttime` INT unsigned NOT NULL DEFAULT 0,
+  `uptime` INT unsigned NOT NULL DEFAULT 0,
+  `maxplayers` SMALLINT unsigned NOT NULL DEFAULT 0,
   `revision` varchar(255) NOT NULL DEFAULT 'AzerothCore',
   PRIMARY KEY (`realmid`,`starttime`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Uptime system';
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Uptime system';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `uptime` WRITE;
diff --git a/data/sql/base/db_auth/version_db_auth.sql b/data/sql/base/db_auth/version_db_auth.sql
index e44bd86e2c..57de0eceda 100644
--- a/data/sql/base/db_auth/version_db_auth.sql
+++ b/data/sql/base/db_auth/version_db_auth.sql
@@ -6,7 +6,7 @@
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 DROP TABLE IF EXISTS `version_db_auth`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
+/*!40101 SET character_set_client = UTF8MB4 */;
 CREATE TABLE `version_db_auth` 
 (
   `sql_rev` varchar(100) NOT NULL,
@@ -15,7 +15,7 @@ CREATE TABLE `version_db_auth`
   PRIMARY KEY (`sql_rev`),
   KEY `required` (`required_rev`),
   CONSTRAINT `required` FOREIGN KEY (`required_rev`) REFERENCES `version_db_auth` (`sql_rev`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Last applied sql update to DB';
+) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 ROW_FORMAT=DYNAMIC COMMENT='Last applied sql update to DB';
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 LOCK TABLES `version_db_auth` WRITE;