From e0d36be56ec2b7c7c88c7b86b81512106cef535e Mon Sep 17 00:00:00 2001 From: Kitzunu <24550914+Kitzunu@users.noreply.github.com> Date: Wed, 24 Mar 2021 15:50:06 +0100 Subject: refactor(DB/SQL): Update integer & utf to MySQL's new standards (#4929) --- data/sql/base/db_auth/account.sql | 22 +++++++++++----------- data/sql/base/db_auth/account_access.sql | 10 +++++----- data/sql/base/db_auth/account_banned.sql | 12 ++++++------ data/sql/base/db_auth/account_muted.sql | 8 ++++---- data/sql/base/db_auth/autobroadcast.sql | 10 +++++----- data/sql/base/db_auth/ip2nation.sql | 6 +++--- data/sql/base/db_auth/ip2nationCountries.sql | 4 ++-- data/sql/base/db_auth/ip_banned.sql | 8 ++++---- data/sql/base/db_auth/logs.sql | 10 +++++----- data/sql/base/db_auth/logs_ip_actions.sql | 14 +++++++------- data/sql/base/db_auth/realmcharacters.sql | 10 +++++----- data/sql/base/db_auth/realmlist.sql | 21 +++++++++++---------- data/sql/base/db_auth/uptime.sql | 12 ++++++------ data/sql/base/db_auth/version_db_auth.sql | 4 ++-- 14 files changed, 76 insertions(+), 75 deletions(-) (limited to 'data/sql/base/db_auth') 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; -- cgit v1.2.3