From 81da3d947cfab9356bfbe4bbd68267efb10192b5 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Thu, 16 Dec 2021 21:19:52 +0000 Subject: TDB 335.21121 - 2021/12/16 --- sql/base/characters_database.sql | 1473 +++++++++++++++++++------------------- 1 file changed, 737 insertions(+), 736 deletions(-) (limited to 'sql/base/characters_database.sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index b82bf12edb2..e9b9f6336d0 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1,13 +1,13 @@ --- MySQL dump 10.13 Distrib 5.7.36, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.26, for Linux (x86_64) -- -- Host: localhost Database: characters -- ------------------------------------------------------ --- Server version 5.7.36 +-- Server version 8.0.26 /*!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 */; -/*!40101 SET NAMES utf8 */; +/*!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 */; @@ -21,14 +21,14 @@ DROP TABLE IF EXISTS `account_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `account_data` ( - `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `time` int(10) unsigned NOT NULL DEFAULT '0', + `accountId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', + `type` tinyint unsigned NOT NULL DEFAULT '0', + `time` int unsigned NOT NULL DEFAULT '0', `data` blob NOT NULL, PRIMARY KEY (`accountId`,`type`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -46,13 +46,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `account_instance_times`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `account_instance_times` ( - `accountId` int(10) unsigned NOT NULL, - `instanceId` int(10) unsigned NOT NULL DEFAULT '0', - `releaseTime` bigint(20) unsigned NOT NULL DEFAULT '0', + `accountId` int unsigned NOT NULL, + `instanceId` int unsigned NOT NULL DEFAULT '0', + `releaseTime` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`accountId`,`instanceId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -70,19 +70,19 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `account_tutorial`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `account_tutorial` ( - `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', - `tut0` int(10) unsigned NOT NULL DEFAULT '0', - `tut1` int(10) unsigned NOT NULL DEFAULT '0', - `tut2` int(10) unsigned NOT NULL DEFAULT '0', - `tut3` int(10) unsigned NOT NULL DEFAULT '0', - `tut4` int(10) unsigned NOT NULL DEFAULT '0', - `tut5` int(10) unsigned NOT NULL DEFAULT '0', - `tut6` int(10) unsigned NOT NULL DEFAULT '0', - `tut7` int(10) unsigned NOT NULL DEFAULT '0', + `accountId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', + `tut0` int unsigned NOT NULL DEFAULT '0', + `tut1` int unsigned NOT NULL DEFAULT '0', + `tut2` int unsigned NOT NULL DEFAULT '0', + `tut3` int unsigned NOT NULL DEFAULT '0', + `tut4` int unsigned NOT NULL DEFAULT '0', + `tut5` int unsigned NOT NULL DEFAULT '0', + `tut6` int unsigned NOT NULL DEFAULT '0', + `tut7` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`accountId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -100,12 +100,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `addons`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `addons` ( `name` varchar(120) NOT NULL DEFAULT '', - `crc` int(10) unsigned NOT NULL DEFAULT '0', + `crc` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Addons'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Addons'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -147,25 +147,25 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `arena_team`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `arena_team` ( - `arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0', + `arenaTeamId` int unsigned NOT NULL DEFAULT '0', `name` varchar(24) NOT NULL, - `captainGuid` int(10) unsigned NOT NULL DEFAULT '0', - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `rating` smallint(5) unsigned NOT NULL DEFAULT '0', - `seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0', - `seasonWins` smallint(5) unsigned NOT NULL DEFAULT '0', - `weekGames` smallint(5) unsigned NOT NULL DEFAULT '0', - `weekWins` smallint(5) unsigned NOT NULL DEFAULT '0', - `rank` int(10) unsigned NOT NULL DEFAULT '0', - `backgroundColor` int(10) unsigned NOT NULL DEFAULT '0', - `emblemStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', - `emblemColor` int(10) unsigned NOT NULL DEFAULT '0', - `borderStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', - `borderColor` int(10) unsigned NOT NULL DEFAULT '0', + `captainGuid` int unsigned NOT NULL DEFAULT '0', + `type` tinyint unsigned NOT NULL DEFAULT '0', + `rating` smallint unsigned NOT NULL DEFAULT '0', + `seasonGames` smallint unsigned NOT NULL DEFAULT '0', + `seasonWins` smallint unsigned NOT NULL DEFAULT '0', + `weekGames` smallint unsigned NOT NULL DEFAULT '0', + `weekWins` smallint unsigned NOT NULL DEFAULT '0', + `rank` int unsigned NOT NULL DEFAULT '0', + `backgroundColor` int unsigned NOT NULL DEFAULT '0', + `emblemStyle` tinyint unsigned NOT NULL DEFAULT '0', + `emblemColor` int unsigned NOT NULL DEFAULT '0', + `borderStyle` tinyint unsigned NOT NULL DEFAULT '0', + `borderColor` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`arenaTeamId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -183,17 +183,17 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `arena_team_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `arena_team_member` ( - `arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0', - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `weekGames` smallint(5) unsigned NOT NULL DEFAULT '0', - `weekWins` smallint(5) unsigned NOT NULL DEFAULT '0', - `seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0', - `seasonWins` smallint(5) unsigned NOT NULL DEFAULT '0', - `personalRating` smallint(5) unsigned NOT NULL DEFAULT '0', + `arenaTeamId` int unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', + `weekGames` smallint unsigned NOT NULL DEFAULT '0', + `weekWins` smallint unsigned NOT NULL DEFAULT '0', + `seasonGames` smallint unsigned NOT NULL DEFAULT '0', + `seasonWins` smallint unsigned NOT NULL DEFAULT '0', + `personalRating` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`arenaTeamId`,`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -211,12 +211,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `auctionbidders`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auctionbidders` ( - `id` int(10) unsigned NOT NULL DEFAULT '0', - `bidderguid` int(10) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `bidderguid` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`bidderguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -234,22 +234,22 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `auctionhouse`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auctionhouse` ( - `id` int(10) unsigned NOT NULL DEFAULT '0', - `houseid` tinyint(3) unsigned NOT NULL DEFAULT '7', - `itemguid` int(10) unsigned NOT NULL DEFAULT '0', - `itemowner` int(10) unsigned NOT NULL DEFAULT '0', - `buyoutprice` int(10) unsigned NOT NULL DEFAULT '0', - `time` int(10) unsigned NOT NULL DEFAULT '0', - `buyguid` int(10) unsigned NOT NULL DEFAULT '0', - `lastbid` int(10) unsigned NOT NULL DEFAULT '0', - `startbid` int(10) unsigned NOT NULL DEFAULT '0', - `deposit` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `houseid` tinyint unsigned NOT NULL DEFAULT '7', + `itemguid` int unsigned NOT NULL DEFAULT '0', + `itemowner` int unsigned NOT NULL DEFAULT '0', + `buyoutprice` int unsigned NOT NULL DEFAULT '0', + `time` int unsigned NOT NULL DEFAULT '0', + `buyguid` int unsigned NOT NULL DEFAULT '0', + `lastbid` int unsigned NOT NULL DEFAULT '0', + `startbid` int unsigned NOT NULL DEFAULT '0', + `deposit` int unsigned NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `item_guid` (`itemguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -267,15 +267,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `banned_addons`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `banned_addons` ( - `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `Id` int unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(255) NOT NULL, `Version` varchar(255) NOT NULL DEFAULT '', `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`Id`), UNIQUE KEY `idx_name_ver` (`Name`,`Version`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -293,10 +293,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `battleground_deserters`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battleground_deserters` ( - `guid` int(10) unsigned NOT NULL COMMENT 'characters.guid', - `type` tinyint(3) unsigned NOT NULL COMMENT 'type of the desertion', + `guid` int unsigned NOT NULL COMMENT 'characters.guid', + `type` tinyint unsigned NOT NULL COMMENT 'type of the desertion', `datetime` datetime NOT NULL COMMENT 'datetime of the desertion' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; @@ -316,13 +316,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `bugreport`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `bugreport` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', + `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', `type` longtext NOT NULL, `content` longtext NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Debug System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Debug System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -340,19 +340,19 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `calendar_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `calendar_events` ( - `id` bigint(20) unsigned NOT NULL DEFAULT '0', - `creator` int(10) unsigned NOT NULL DEFAULT '0', + `id` bigint unsigned NOT NULL DEFAULT '0', + `creator` int unsigned NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', - `type` tinyint(1) unsigned NOT NULL DEFAULT '4', - `dungeon` int(10) NOT NULL DEFAULT '-1', - `eventtime` int(10) unsigned NOT NULL DEFAULT '0', - `flags` int(10) unsigned NOT NULL DEFAULT '0', - `time2` int(10) unsigned NOT NULL DEFAULT '0', + `type` tinyint unsigned NOT NULL DEFAULT '4', + `dungeon` int NOT NULL DEFAULT '-1', + `eventtime` int unsigned NOT NULL DEFAULT '0', + `flags` int unsigned NOT NULL DEFAULT '0', + `time2` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -370,18 +370,18 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `calendar_invites`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `calendar_invites` ( - `id` bigint(20) unsigned NOT NULL DEFAULT '0', - `event` bigint(20) unsigned NOT NULL DEFAULT '0', - `invitee` int(10) unsigned NOT NULL DEFAULT '0', - `sender` int(10) unsigned NOT NULL DEFAULT '0', - `status` tinyint(1) unsigned NOT NULL DEFAULT '0', - `statustime` int(10) unsigned NOT NULL DEFAULT '0', - `rank` tinyint(1) unsigned NOT NULL DEFAULT '0', + `id` bigint unsigned NOT NULL DEFAULT '0', + `event` bigint unsigned NOT NULL DEFAULT '0', + `invitee` int unsigned NOT NULL DEFAULT '0', + `sender` int unsigned NOT NULL DEFAULT '0', + `status` tinyint unsigned NOT NULL DEFAULT '0', + `statustime` int unsigned NOT NULL DEFAULT '0', + `rank` tinyint unsigned NOT NULL DEFAULT '0', `text` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -399,17 +399,17 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `channels` ( `name` varchar(128) NOT NULL, - `team` int(10) unsigned NOT NULL, - `announce` tinyint(3) unsigned NOT NULL DEFAULT '1', - `ownership` tinyint(3) unsigned NOT NULL DEFAULT '1', + `team` int unsigned NOT NULL, + `announce` tinyint unsigned NOT NULL DEFAULT '1', + `ownership` tinyint unsigned NOT NULL DEFAULT '1', `password` varchar(32) DEFAULT NULL, `bannedList` text, - `lastUsed` int(10) unsigned NOT NULL, + `lastUsed` int unsigned NOT NULL, PRIMARY KEY (`name`,`team`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Channel System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Channel System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -427,14 +427,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_account_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_account_data` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `time` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', + `type` tinyint unsigned NOT NULL DEFAULT '0', + `time` int unsigned NOT NULL DEFAULT '0', `data` blob NOT NULL, PRIMARY KEY (`guid`,`type`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -452,13 +452,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_achievement`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_achievement` ( - `guid` int(10) unsigned NOT NULL, - `achievement` smallint(5) unsigned NOT NULL, - `date` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL, + `achievement` smallint unsigned NOT NULL, + `date` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`achievement`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -476,14 +476,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_achievement_progress`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_achievement_progress` ( - `guid` int(10) unsigned NOT NULL, - `criteria` smallint(5) unsigned NOT NULL, - `counter` int(10) unsigned NOT NULL, - `date` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL, + `criteria` smallint unsigned NOT NULL, + `counter` int unsigned NOT NULL, + `date` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`criteria`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -501,15 +501,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_action` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `spec` tinyint(3) unsigned NOT NULL DEFAULT '0', - `button` tinyint(3) unsigned NOT NULL DEFAULT '0', - `action` int(10) unsigned NOT NULL DEFAULT '0', - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', + `spec` tinyint unsigned NOT NULL DEFAULT '0', + `button` tinyint unsigned NOT NULL DEFAULT '0', + `action` int unsigned NOT NULL DEFAULT '0', + `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spec`,`button`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -527,13 +527,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_arena_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_arena_stats` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', - `matchMakerRating` smallint(5) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', + `slot` tinyint unsigned NOT NULL DEFAULT '0', + `matchMakerRating` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`slot`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -551,28 +551,28 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_aura`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_aura` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `casterGuid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier', - `itemGuid` bigint(20) unsigned NOT NULL DEFAULT '0', - `spell` mediumint(8) unsigned NOT NULL DEFAULT '0', - `effectMask` tinyint(3) unsigned NOT NULL DEFAULT '0', - `recalculateMask` tinyint(3) unsigned NOT NULL DEFAULT '0', - `stackCount` tinyint(3) unsigned NOT NULL DEFAULT '1', - `amount0` int(11) NOT NULL DEFAULT '0', - `amount1` int(11) NOT NULL DEFAULT '0', - `amount2` int(11) NOT NULL DEFAULT '0', - `base_amount0` int(11) NOT NULL DEFAULT '0', - `base_amount1` int(11) NOT NULL DEFAULT '0', - `base_amount2` int(11) NOT NULL DEFAULT '0', - `maxDuration` int(11) NOT NULL DEFAULT '0', - `remainTime` int(11) NOT NULL DEFAULT '0', - `remainCharges` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `casterGuid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier', + `itemGuid` bigint unsigned NOT NULL DEFAULT '0', + `spell` mediumint unsigned NOT NULL DEFAULT '0', + `effectMask` tinyint unsigned NOT NULL DEFAULT '0', + `recalculateMask` tinyint unsigned NOT NULL DEFAULT '0', + `stackCount` tinyint unsigned NOT NULL DEFAULT '1', + `amount0` int NOT NULL DEFAULT '0', + `amount1` int NOT NULL DEFAULT '0', + `amount2` int NOT NULL DEFAULT '0', + `base_amount0` int NOT NULL DEFAULT '0', + `base_amount1` int NOT NULL DEFAULT '0', + `base_amount2` int NOT NULL DEFAULT '0', + `maxDuration` int NOT NULL DEFAULT '0', + `remainTime` int NOT NULL DEFAULT '0', + `remainCharges` tinyint unsigned NOT NULL DEFAULT '0', `critChance` float NOT NULL DEFAULT '0', - `applyResilience` tinyint(3) NOT NULL DEFAULT '0', + `applyResilience` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -590,16 +590,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_banned`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_banned` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `bandate` int(10) unsigned NOT NULL DEFAULT '0', - `unbandate` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `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 (`guid`,`bandate`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Ban List'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -617,21 +617,21 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_battleground_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_battleground_data` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `instanceId` int(10) unsigned NOT NULL COMMENT 'Instance Identifier', - `team` smallint(5) unsigned NOT NULL, + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `instanceId` int unsigned NOT NULL COMMENT 'Instance Identifier', + `team` smallint unsigned NOT NULL, `joinX` float NOT NULL DEFAULT '0', `joinY` float NOT NULL DEFAULT '0', `joinZ` float NOT NULL DEFAULT '0', `joinO` float NOT NULL DEFAULT '0', - `joinMapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', - `taxiStart` int(10) unsigned NOT NULL DEFAULT '0', - `taxiEnd` int(10) unsigned NOT NULL DEFAULT '0', - `mountSpell` int(10) unsigned NOT NULL DEFAULT '0', + `joinMapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `taxiStart` int unsigned NOT NULL DEFAULT '0', + `taxiEnd` int unsigned NOT NULL DEFAULT '0', + `mountSpell` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -649,11 +649,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_battleground_random`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_battleground_random` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -671,16 +671,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_declinedname`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_declinedname` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `genitive` varchar(15) NOT NULL DEFAULT '', `dative` varchar(15) NOT NULL DEFAULT '', `accusative` varchar(15) NOT NULL DEFAULT '', `instrumental` varchar(15) NOT NULL DEFAULT '', `prepositional` varchar(15) NOT NULL DEFAULT '', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -698,37 +698,37 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_equipmentsets`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_equipmentsets` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `setguid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `setindex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', + `setguid` bigint unsigned NOT NULL AUTO_INCREMENT, + `setindex` tinyint unsigned NOT NULL DEFAULT '0', `name` varchar(31) NOT NULL, `iconname` varchar(100) NOT NULL, - `ignore_mask` int(11) unsigned NOT NULL DEFAULT '0', - `item0` int(11) unsigned NOT NULL DEFAULT '0', - `item1` int(11) unsigned NOT NULL DEFAULT '0', - `item2` int(11) unsigned NOT NULL DEFAULT '0', - `item3` int(11) unsigned NOT NULL DEFAULT '0', - `item4` int(11) unsigned NOT NULL DEFAULT '0', - `item5` int(11) unsigned NOT NULL DEFAULT '0', - `item6` int(11) unsigned NOT NULL DEFAULT '0', - `item7` int(11) unsigned NOT NULL DEFAULT '0', - `item8` int(11) unsigned NOT NULL DEFAULT '0', - `item9` int(11) unsigned NOT NULL DEFAULT '0', - `item10` int(11) unsigned NOT NULL DEFAULT '0', - `item11` int(11) unsigned NOT NULL DEFAULT '0', - `item12` int(11) unsigned NOT NULL DEFAULT '0', - `item13` int(11) unsigned NOT NULL DEFAULT '0', - `item14` int(11) unsigned NOT NULL DEFAULT '0', - `item15` int(11) unsigned NOT NULL DEFAULT '0', - `item16` int(11) unsigned NOT NULL DEFAULT '0', - `item17` int(11) unsigned NOT NULL DEFAULT '0', - `item18` int(11) unsigned NOT NULL DEFAULT '0', + `ignore_mask` int unsigned NOT NULL DEFAULT '0', + `item0` int unsigned NOT NULL DEFAULT '0', + `item1` int unsigned NOT NULL DEFAULT '0', + `item2` int unsigned NOT NULL DEFAULT '0', + `item3` int unsigned NOT NULL DEFAULT '0', + `item4` int unsigned NOT NULL DEFAULT '0', + `item5` int unsigned NOT NULL DEFAULT '0', + `item6` int unsigned NOT NULL DEFAULT '0', + `item7` int unsigned NOT NULL DEFAULT '0', + `item8` int unsigned NOT NULL DEFAULT '0', + `item9` int unsigned NOT NULL DEFAULT '0', + `item10` int unsigned NOT NULL DEFAULT '0', + `item11` int unsigned NOT NULL DEFAULT '0', + `item12` int unsigned NOT NULL DEFAULT '0', + `item13` int unsigned NOT NULL DEFAULT '0', + `item14` int unsigned NOT NULL DEFAULT '0', + `item15` int unsigned NOT NULL DEFAULT '0', + `item16` int unsigned NOT NULL DEFAULT '0', + `item17` int unsigned NOT NULL DEFAULT '0', + `item18` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`setguid`), UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`), KEY `Idx_setindex` (`setindex`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -746,12 +746,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_fishingsteps`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_fishingsteps` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `fishingSteps` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `fishingSteps` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -769,15 +769,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_gifts`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_gifts` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `item_guid` int(10) unsigned NOT NULL DEFAULT '0', - `entry` int(10) unsigned NOT NULL DEFAULT '0', - `flags` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', + `item_guid` int unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', + `flags` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`item_guid`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -795,18 +795,18 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_glyphs`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_glyphs` ( - `guid` int(10) unsigned NOT NULL, - `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', - `glyph1` smallint(5) unsigned DEFAULT '0', - `glyph2` smallint(5) unsigned DEFAULT '0', - `glyph3` smallint(5) unsigned DEFAULT '0', - `glyph4` smallint(5) unsigned DEFAULT '0', - `glyph5` smallint(5) unsigned DEFAULT '0', - `glyph6` smallint(5) unsigned DEFAULT '0', + `guid` int unsigned NOT NULL, + `talentGroup` tinyint unsigned NOT NULL DEFAULT '0', + `glyph1` smallint unsigned DEFAULT '0', + `glyph2` smallint unsigned DEFAULT '0', + `glyph3` smallint unsigned DEFAULT '0', + `glyph4` smallint unsigned DEFAULT '0', + `glyph5` smallint unsigned DEFAULT '0', + `glyph6` smallint unsigned DEFAULT '0', PRIMARY KEY (`guid`,`talentGroup`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -824,16 +824,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_homebind`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_homebind` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', - `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `mapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', `posX` float NOT NULL DEFAULT '0', `posY` float NOT NULL DEFAULT '0', `posZ` float NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -851,15 +851,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_instance` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `instance` int(10) unsigned NOT NULL DEFAULT '0', - `permanent` tinyint(3) unsigned NOT NULL DEFAULT '0', - `extendState` tinyint(2) unsigned NOT NULL DEFAULT '1', + `guid` int unsigned NOT NULL DEFAULT '0', + `instance` int unsigned NOT NULL DEFAULT '0', + `permanent` tinyint unsigned NOT NULL DEFAULT '0', + `extendState` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`guid`,`instance`), KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -877,16 +877,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_inventory`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_inventory` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `bag` int(10) unsigned NOT NULL DEFAULT '0', - `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', - `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `bag` int unsigned NOT NULL DEFAULT '0', + `slot` tinyint unsigned NOT NULL DEFAULT '0', + `item` int unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier', PRIMARY KEY (`item`), UNIQUE KEY `guid` (`guid`,`bag`,`slot`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -904,29 +904,29 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_pet`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_pet` ( - `id` int(10) unsigned NOT NULL DEFAULT '0', - `entry` int(10) unsigned NOT NULL DEFAULT '0', - `owner` int(10) unsigned NOT NULL DEFAULT '0', - `modelid` int(10) unsigned DEFAULT '0', - `CreatedBySpell` mediumint(8) unsigned NOT NULL DEFAULT '0', - `PetType` tinyint(3) unsigned NOT NULL DEFAULT '0', - `level` smallint(5) unsigned NOT NULL DEFAULT '1', - `exp` int(10) unsigned NOT NULL DEFAULT '0', - `Reactstate` tinyint(3) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', + `owner` int unsigned NOT NULL DEFAULT '0', + `modelid` int unsigned DEFAULT '0', + `CreatedBySpell` mediumint unsigned NOT NULL DEFAULT '0', + `PetType` tinyint unsigned NOT NULL DEFAULT '0', + `level` smallint unsigned NOT NULL DEFAULT '1', + `exp` int unsigned NOT NULL DEFAULT '0', + `Reactstate` tinyint unsigned NOT NULL DEFAULT '0', `name` varchar(21) NOT NULL DEFAULT 'Pet', - `renamed` tinyint(3) unsigned NOT NULL DEFAULT '0', - `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', - `curhealth` int(10) unsigned NOT NULL DEFAULT '1', - `curmana` int(10) unsigned NOT NULL DEFAULT '0', - `curhappiness` int(10) unsigned NOT NULL DEFAULT '0', - `savetime` int(10) unsigned NOT NULL DEFAULT '0', + `renamed` tinyint unsigned NOT NULL DEFAULT '0', + `slot` tinyint unsigned NOT NULL DEFAULT '0', + `curhealth` int unsigned NOT NULL DEFAULT '1', + `curmana` int unsigned NOT NULL DEFAULT '0', + `curhappiness` int unsigned NOT NULL DEFAULT '0', + `savetime` int unsigned NOT NULL DEFAULT '0', `abdata` text, PRIMARY KEY (`id`), KEY `owner` (`owner`), KEY `idx_slot` (`slot`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -944,10 +944,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_pet_declinedname`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_pet_declinedname` ( - `id` int(10) unsigned NOT NULL DEFAULT '0', - `owner` int(10) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `owner` int unsigned NOT NULL DEFAULT '0', `genitive` varchar(12) NOT NULL DEFAULT '', `dative` varchar(12) NOT NULL DEFAULT '', `accusative` varchar(12) NOT NULL DEFAULT '', @@ -955,7 +955,7 @@ CREATE TABLE `character_pet_declinedname` ( `prepositional` varchar(12) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `owner_key` (`owner`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -973,26 +973,26 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', - `status` tinyint(3) unsigned NOT NULL DEFAULT '0', - `explored` tinyint(3) unsigned NOT NULL DEFAULT '0', - `timer` int(10) unsigned NOT NULL DEFAULT '0', - `mobcount1` smallint(5) unsigned NOT NULL DEFAULT '0', - `mobcount2` smallint(5) unsigned NOT NULL DEFAULT '0', - `mobcount3` smallint(5) unsigned NOT NULL DEFAULT '0', - `mobcount4` smallint(5) unsigned NOT NULL DEFAULT '0', - `itemcount1` smallint(5) unsigned NOT NULL DEFAULT '0', - `itemcount2` smallint(5) unsigned NOT NULL DEFAULT '0', - `itemcount3` smallint(5) unsigned NOT NULL DEFAULT '0', - `itemcount4` smallint(5) unsigned NOT NULL DEFAULT '0', - `itemcount5` smallint(5) unsigned NOT NULL DEFAULT '0', - `itemcount6` smallint(5) unsigned NOT NULL DEFAULT '0', - `playercount` smallint(5) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `status` tinyint unsigned NOT NULL DEFAULT '0', + `explored` tinyint unsigned NOT NULL DEFAULT '0', + `timer` int unsigned NOT NULL DEFAULT '0', + `mobcount1` smallint unsigned NOT NULL DEFAULT '0', + `mobcount2` smallint unsigned NOT NULL DEFAULT '0', + `mobcount3` smallint unsigned NOT NULL DEFAULT '0', + `mobcount4` smallint unsigned NOT NULL DEFAULT '0', + `itemcount1` smallint unsigned NOT NULL DEFAULT '0', + `itemcount2` smallint unsigned NOT NULL DEFAULT '0', + `itemcount3` smallint unsigned NOT NULL DEFAULT '0', + `itemcount4` smallint unsigned NOT NULL DEFAULT '0', + `itemcount5` smallint unsigned NOT NULL DEFAULT '0', + `itemcount6` smallint unsigned NOT NULL DEFAULT '0', + `playercount` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1010,14 +1010,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_daily`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_daily` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', - `time` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `time` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1035,13 +1035,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_monthly`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_monthly` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1059,13 +1059,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_rewarded`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_rewarded` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', - `active` tinyint(10) unsigned NOT NULL DEFAULT '1', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `active` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`guid`,`quest`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1083,14 +1083,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_seasonal`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_seasonal` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', - `event` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event Identifier', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `event` int unsigned NOT NULL DEFAULT '0' COMMENT 'Event Identifier', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1108,13 +1108,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_weekly`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_weekly` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1132,14 +1132,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_reputation`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_reputation` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `faction` smallint(5) unsigned NOT NULL DEFAULT '0', - `standing` int(11) NOT NULL DEFAULT '0', - `flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `faction` smallint unsigned NOT NULL DEFAULT '0', + `standing` int NOT NULL DEFAULT '0', + `flags` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`faction`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1157,14 +1157,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_skills`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_skills` ( - `guid` int(10) unsigned NOT NULL COMMENT 'Global Unique Identifier', - `skill` smallint(5) unsigned NOT NULL, - `value` smallint(5) unsigned NOT NULL, - `max` smallint(5) unsigned NOT NULL, + `guid` int unsigned NOT NULL COMMENT 'Global Unique Identifier', + `skill` smallint unsigned NOT NULL, + `value` smallint unsigned NOT NULL, + `max` smallint unsigned NOT NULL, PRIMARY KEY (`guid`,`skill`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1182,15 +1182,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_social`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_social` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', - `friend` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier', - `flags` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `friend` int unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier', + `flags` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags', `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note', PRIMARY KEY (`guid`,`friend`,`flags`), KEY `friend` (`friend`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1208,14 +1208,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_spell` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', - `active` tinyint(3) unsigned NOT NULL DEFAULT '1', - `disabled` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `active` tinyint unsigned NOT NULL DEFAULT '1', + `disabled` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1233,16 +1233,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_spell_cooldown`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_spell_cooldown` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', - `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', - `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier', - `time` int(10) unsigned NOT NULL DEFAULT '0', - `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', - `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', + `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `item` int unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier', + `time` int unsigned NOT NULL DEFAULT '0', + `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', + `categoryEnd` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1260,41 +1260,41 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_stats` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', - `maxhealth` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower1` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower2` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower3` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower4` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower5` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower6` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower7` int(10) unsigned NOT NULL DEFAULT '0', - `strength` int(10) unsigned NOT NULL DEFAULT '0', - `agility` int(10) unsigned NOT NULL DEFAULT '0', - `stamina` int(10) unsigned NOT NULL DEFAULT '0', - `intellect` int(10) unsigned NOT NULL DEFAULT '0', - `spirit` int(10) unsigned NOT NULL DEFAULT '0', - `armor` int(10) unsigned NOT NULL DEFAULT '0', - `resHoly` int(10) unsigned NOT NULL DEFAULT '0', - `resFire` int(10) unsigned NOT NULL DEFAULT '0', - `resNature` int(10) unsigned NOT NULL DEFAULT '0', - `resFrost` int(10) unsigned NOT NULL DEFAULT '0', - `resShadow` int(10) unsigned NOT NULL DEFAULT '0', - `resArcane` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', + `maxhealth` int unsigned NOT NULL DEFAULT '0', + `maxpower1` int unsigned NOT NULL DEFAULT '0', + `maxpower2` int unsigned NOT NULL DEFAULT '0', + `maxpower3` int unsigned NOT NULL DEFAULT '0', + `maxpower4` int unsigned NOT NULL DEFAULT '0', + `maxpower5` int unsigned NOT NULL DEFAULT '0', + `maxpower6` int unsigned NOT NULL DEFAULT '0', + `maxpower7` int unsigned NOT NULL DEFAULT '0', + `strength` int unsigned NOT NULL DEFAULT '0', + `agility` int unsigned NOT NULL DEFAULT '0', + `stamina` int unsigned NOT NULL DEFAULT '0', + `intellect` int unsigned NOT NULL DEFAULT '0', + `spirit` int unsigned NOT NULL DEFAULT '0', + `armor` int unsigned NOT NULL DEFAULT '0', + `resHoly` int unsigned NOT NULL DEFAULT '0', + `resFire` int unsigned NOT NULL DEFAULT '0', + `resNature` int unsigned NOT NULL DEFAULT '0', + `resFrost` int unsigned NOT NULL DEFAULT '0', + `resShadow` int unsigned NOT NULL DEFAULT '0', + `resArcane` int unsigned NOT NULL DEFAULT '0', `blockPct` float unsigned NOT NULL DEFAULT '0', `dodgePct` float unsigned NOT NULL DEFAULT '0', `parryPct` float unsigned NOT NULL DEFAULT '0', `critPct` float unsigned NOT NULL DEFAULT '0', `rangedCritPct` float unsigned NOT NULL DEFAULT '0', `spellCritPct` float unsigned NOT NULL DEFAULT '0', - `attackPower` int(10) unsigned NOT NULL DEFAULT '0', - `rangedAttackPower` int(10) unsigned NOT NULL DEFAULT '0', - `spellPower` int(10) unsigned NOT NULL DEFAULT '0', - `resilience` int(10) unsigned NOT NULL DEFAULT '0', + `attackPower` int unsigned NOT NULL DEFAULT '0', + `rangedAttackPower` int unsigned NOT NULL DEFAULT '0', + `spellPower` int unsigned NOT NULL DEFAULT '0', + `resilience` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1312,13 +1312,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_talent`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_talent` ( - `guid` int(10) unsigned NOT NULL, - `spell` mediumint(8) unsigned NOT NULL, - `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL, + `spell` mediumint unsigned NOT NULL, + `talentGroup` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`,`talentGroup`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1336,89 +1336,89 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `characters`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `characters` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `account` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `account` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', `name` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `race` tinyint(3) unsigned NOT NULL DEFAULT '0', - `class` tinyint(3) unsigned NOT NULL DEFAULT '0', - `gender` tinyint(3) unsigned NOT NULL DEFAULT '0', - `level` tinyint(3) unsigned NOT NULL DEFAULT '0', - `xp` int(10) unsigned NOT NULL DEFAULT '0', - `money` int(10) unsigned NOT NULL DEFAULT '0', - `skin` tinyint(3) unsigned NOT NULL DEFAULT '0', - `face` tinyint(3) unsigned NOT NULL DEFAULT '0', - `hairStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', - `hairColor` tinyint(3) unsigned NOT NULL DEFAULT '0', - `facialStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', - `bankSlots` tinyint(3) unsigned NOT NULL DEFAULT '0', - `restState` tinyint(3) unsigned NOT NULL DEFAULT '0', - `playerFlags` int(10) unsigned NOT NULL DEFAULT '0', + `race` tinyint unsigned NOT NULL DEFAULT '0', + `class` tinyint unsigned NOT NULL DEFAULT '0', + `gender` tinyint unsigned NOT NULL DEFAULT '0', + `level` tinyint unsigned NOT NULL DEFAULT '0', + `xp` int unsigned NOT NULL DEFAULT '0', + `money` int unsigned NOT NULL DEFAULT '0', + `skin` tinyint unsigned NOT NULL DEFAULT '0', + `face` tinyint unsigned NOT NULL DEFAULT '0', + `hairStyle` tinyint unsigned NOT NULL DEFAULT '0', + `hairColor` tinyint unsigned NOT NULL DEFAULT '0', + `facialStyle` tinyint unsigned NOT NULL DEFAULT '0', + `bankSlots` tinyint unsigned NOT NULL DEFAULT '0', + `restState` tinyint unsigned NOT NULL DEFAULT '0', + `playerFlags` int unsigned NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', - `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', - `instance_id` int(10) unsigned NOT NULL DEFAULT '0', - `instance_mode_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', + `map` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `instance_id` int unsigned NOT NULL DEFAULT '0', + `instance_mode_mask` tinyint unsigned NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `taximask` text NOT NULL, - `online` tinyint(3) unsigned NOT NULL DEFAULT '0', - `cinematic` tinyint(3) unsigned NOT NULL DEFAULT '0', - `totaltime` int(10) unsigned NOT NULL DEFAULT '0', - `leveltime` int(10) unsigned NOT NULL DEFAULT '0', - `logout_time` int(10) unsigned NOT NULL DEFAULT '0', - `is_logout_resting` tinyint(3) unsigned NOT NULL DEFAULT '0', + `online` tinyint unsigned NOT NULL DEFAULT '0', + `cinematic` tinyint unsigned NOT NULL DEFAULT '0', + `totaltime` int unsigned NOT NULL DEFAULT '0', + `leveltime` int unsigned NOT NULL DEFAULT '0', + `logout_time` int unsigned NOT NULL DEFAULT '0', + `is_logout_resting` tinyint unsigned NOT NULL DEFAULT '0', `rest_bonus` float NOT NULL DEFAULT '0', - `resettalents_cost` int(10) unsigned NOT NULL DEFAULT '0', - `resettalents_time` int(10) unsigned NOT NULL DEFAULT '0', + `resettalents_cost` int unsigned NOT NULL DEFAULT '0', + `resettalents_time` int unsigned NOT NULL DEFAULT '0', `trans_x` float NOT NULL DEFAULT '0', `trans_y` float NOT NULL DEFAULT '0', `trans_z` float NOT NULL DEFAULT '0', `trans_o` float NOT NULL DEFAULT '0', - `transguid` mediumint(8) unsigned NOT NULL DEFAULT '0', - `extra_flags` smallint(5) unsigned NOT NULL DEFAULT '0', - `stable_slots` tinyint(3) unsigned NOT NULL DEFAULT '0', - `at_login` smallint(5) unsigned NOT NULL DEFAULT '0', - `zone` smallint(5) unsigned NOT NULL DEFAULT '0', - `death_expire_time` int(10) unsigned NOT NULL DEFAULT '0', + `transguid` mediumint unsigned NOT NULL DEFAULT '0', + `extra_flags` smallint unsigned NOT NULL DEFAULT '0', + `stable_slots` tinyint unsigned NOT NULL DEFAULT '0', + `at_login` smallint unsigned NOT NULL DEFAULT '0', + `zone` smallint unsigned NOT NULL DEFAULT '0', + `death_expire_time` int unsigned NOT NULL DEFAULT '0', `taxi_path` text, - `arenaPoints` int(10) unsigned NOT NULL DEFAULT '0', - `totalHonorPoints` int(10) unsigned NOT NULL DEFAULT '0', - `todayHonorPoints` int(10) unsigned NOT NULL DEFAULT '0', - `yesterdayHonorPoints` int(10) unsigned NOT NULL DEFAULT '0', - `totalKills` int(10) unsigned NOT NULL DEFAULT '0', - `todayKills` smallint(5) unsigned NOT NULL DEFAULT '0', - `yesterdayKills` smallint(5) unsigned NOT NULL DEFAULT '0', - `chosenTitle` int(10) unsigned NOT NULL DEFAULT '0', - `knownCurrencies` bigint(20) unsigned NOT NULL DEFAULT '0', - `watchedFaction` int(10) unsigned NOT NULL DEFAULT '0', - `drunk` tinyint(3) unsigned NOT NULL DEFAULT '0', - `health` int(10) unsigned NOT NULL DEFAULT '0', - `power1` int(10) unsigned NOT NULL DEFAULT '0', - `power2` int(10) unsigned NOT NULL DEFAULT '0', - `power3` int(10) unsigned NOT NULL DEFAULT '0', - `power4` int(10) unsigned NOT NULL DEFAULT '0', - `power5` int(10) unsigned NOT NULL DEFAULT '0', - `power6` int(10) unsigned NOT NULL DEFAULT '0', - `power7` int(10) unsigned NOT NULL DEFAULT '0', - `latency` mediumint(8) unsigned NOT NULL DEFAULT '0', - `talentGroupsCount` tinyint(3) unsigned NOT NULL DEFAULT '1', - `activeTalentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', + `arenaPoints` int unsigned NOT NULL DEFAULT '0', + `totalHonorPoints` int unsigned NOT NULL DEFAULT '0', + `todayHonorPoints` int unsigned NOT NULL DEFAULT '0', + `yesterdayHonorPoints` int unsigned NOT NULL DEFAULT '0', + `totalKills` int unsigned NOT NULL DEFAULT '0', + `todayKills` smallint unsigned NOT NULL DEFAULT '0', + `yesterdayKills` smallint unsigned NOT NULL DEFAULT '0', + `chosenTitle` int unsigned NOT NULL DEFAULT '0', + `knownCurrencies` bigint unsigned NOT NULL DEFAULT '0', + `watchedFaction` int unsigned NOT NULL DEFAULT '0', + `drunk` tinyint unsigned NOT NULL DEFAULT '0', + `health` int unsigned NOT NULL DEFAULT '0', + `power1` int unsigned NOT NULL DEFAULT '0', + `power2` int unsigned NOT NULL DEFAULT '0', + `power3` int unsigned NOT NULL DEFAULT '0', + `power4` int unsigned NOT NULL DEFAULT '0', + `power5` int unsigned NOT NULL DEFAULT '0', + `power6` int unsigned NOT NULL DEFAULT '0', + `power7` int unsigned NOT NULL DEFAULT '0', + `latency` mediumint unsigned NOT NULL DEFAULT '0', + `talentGroupsCount` tinyint unsigned NOT NULL DEFAULT '1', + `activeTalentGroup` tinyint unsigned NOT NULL DEFAULT '0', `exploredZones` longtext, `equipmentCache` longtext, - `ammoId` int(10) unsigned NOT NULL DEFAULT '0', + `ammoId` int unsigned NOT NULL DEFAULT '0', `knownTitles` longtext, - `actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0', - `grantableLevels` tinyint(3) unsigned NOT NULL DEFAULT '0', - `deleteInfos_Account` int(10) unsigned DEFAULT NULL, + `actionBars` tinyint unsigned NOT NULL DEFAULT '0', + `grantableLevels` tinyint unsigned NOT NULL DEFAULT '0', + `deleteInfos_Account` int unsigned DEFAULT NULL, `deleteInfos_Name` varchar(12) DEFAULT NULL, - `deleteDate` int(10) unsigned DEFAULT NULL, + `deleteDate` int unsigned DEFAULT NULL, PRIMARY KEY (`guid`), KEY `idx_account` (`account`), KEY `idx_online` (`online`), KEY `idx_name` (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1436,30 +1436,30 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `corpse`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `corpse` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `posX` float NOT NULL DEFAULT '0', `posY` float NOT NULL DEFAULT '0', `posZ` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', - `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', - `phaseMask` int(10) unsigned NOT NULL DEFAULT '1', - `displayId` int(10) unsigned NOT NULL DEFAULT '0', + `mapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `phaseMask` int unsigned NOT NULL DEFAULT '1', + `displayId` int unsigned NOT NULL DEFAULT '0', `itemCache` text NOT NULL, - `bytes1` int(10) unsigned NOT NULL DEFAULT '0', - `bytes2` int(10) unsigned NOT NULL DEFAULT '0', - `guildId` int(10) unsigned NOT NULL DEFAULT '0', - `flags` tinyint(3) unsigned NOT NULL DEFAULT '0', - `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', - `time` int(10) unsigned NOT NULL DEFAULT '0', - `corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0', - `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier', + `bytes1` int unsigned NOT NULL DEFAULT '0', + `bytes2` int unsigned NOT NULL DEFAULT '0', + `guildId` int unsigned NOT NULL DEFAULT '0', + `flags` tinyint unsigned NOT NULL DEFAULT '0', + `dynFlags` tinyint unsigned NOT NULL DEFAULT '0', + `time` int unsigned NOT NULL DEFAULT '0', + `corpseType` tinyint unsigned NOT NULL DEFAULT '0', + `instanceId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier', PRIMARY KEY (`guid`), KEY `idx_type` (`corpseType`), KEY `idx_instance` (`instanceId`), KEY `idx_time` (`time`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Death System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1477,13 +1477,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `game_event_condition_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_condition_save` ( - `eventEntry` tinyint(3) unsigned NOT NULL, - `condition_id` int(10) unsigned NOT NULL DEFAULT '0', + `eventEntry` tinyint unsigned NOT NULL, + `condition_id` int unsigned NOT NULL DEFAULT '0', `done` float DEFAULT '0', PRIMARY KEY (`eventEntry`,`condition_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1501,13 +1501,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `game_event_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `game_event_save` ( - `eventEntry` tinyint(3) unsigned NOT NULL, - `state` tinyint(3) unsigned NOT NULL DEFAULT '1', - `next_start` int(10) unsigned NOT NULL DEFAULT '0', + `eventEntry` tinyint unsigned NOT NULL, + `state` tinyint unsigned NOT NULL DEFAULT '1', + `next_start` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`eventEntry`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1525,14 +1525,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `gm_subsurvey`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_subsurvey` ( - `surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT, - `questionId` int(10) unsigned NOT NULL DEFAULT '0', - `answer` int(10) unsigned NOT NULL DEFAULT '0', + `surveyId` int unsigned NOT NULL AUTO_INCREMENT, + `questionId` int unsigned NOT NULL DEFAULT '0', + `answer` int unsigned NOT NULL DEFAULT '0', `answerComment` text NOT NULL, PRIMARY KEY (`surveyId`,`questionId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1550,15 +1550,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `gm_survey`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_survey` ( - `surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT, - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `mainSurvey` int(10) unsigned NOT NULL DEFAULT '0', + `surveyId` int unsigned NOT NULL AUTO_INCREMENT, + `guid` int unsigned NOT NULL DEFAULT '0', + `mainSurvey` int unsigned NOT NULL DEFAULT '0', `comment` longtext NOT NULL, - `createTime` int(10) unsigned NOT NULL DEFAULT '0', + `createTime` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`surveyId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1576,30 +1576,30 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `gm_ticket`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_ticket` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0 open, 1 closed, 2 character deleted', - `playerGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier of ticket creator', + `id` int unsigned NOT NULL AUTO_INCREMENT, + `type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0 open, 1 closed, 2 character deleted', + `playerGuid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier of ticket creator', `name` varchar(12) NOT NULL COMMENT 'Name of ticket creator', `description` text NOT NULL, - `createTime` int(10) unsigned NOT NULL DEFAULT '0', - `mapId` smallint(5) unsigned NOT NULL DEFAULT '0', + `createTime` int unsigned NOT NULL DEFAULT '0', + `mapId` smallint unsigned NOT NULL DEFAULT '0', `posX` float NOT NULL DEFAULT '0', `posY` float NOT NULL DEFAULT '0', `posZ` float NOT NULL DEFAULT '0', - `lastModifiedTime` int(10) unsigned NOT NULL DEFAULT '0', - `closedBy` int(10) NOT NULL DEFAULT '0', - `assignedTo` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', + `lastModifiedTime` int unsigned NOT NULL DEFAULT '0', + `closedBy` int NOT NULL DEFAULT '0', + `assignedTo` int unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', `comment` text NOT NULL, `response` text NOT NULL, - `completed` tinyint(3) unsigned NOT NULL DEFAULT '0', - `escalated` tinyint(3) unsigned NOT NULL DEFAULT '0', - `viewed` tinyint(3) unsigned NOT NULL DEFAULT '0', - `needMoreHelp` tinyint(3) unsigned NOT NULL DEFAULT '0', - `resolvedBy` int(10) NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket', + `completed` tinyint unsigned NOT NULL DEFAULT '0', + `escalated` tinyint unsigned NOT NULL DEFAULT '0', + `viewed` tinyint unsigned NOT NULL DEFAULT '0', + `needMoreHelp` tinyint unsigned NOT NULL DEFAULT '0', + `resolvedBy` int NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1617,14 +1617,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `group_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `group_instance` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `instance` int(10) unsigned NOT NULL DEFAULT '0', - `permanent` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', + `instance` int unsigned NOT NULL DEFAULT '0', + `permanent` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`instance`), KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1642,15 +1642,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `group_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `group_member` ( - `guid` int(10) unsigned NOT NULL, - `memberGuid` int(10) unsigned NOT NULL, - `memberFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', - `subgroup` tinyint(3) unsigned NOT NULL DEFAULT '0', - `roles` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL, + `memberGuid` int unsigned NOT NULL, + `memberFlags` tinyint unsigned NOT NULL DEFAULT '0', + `subgroup` tinyint unsigned NOT NULL DEFAULT '0', + `roles` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`memberGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Groups'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1668,28 +1668,28 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `groups` ( - `guid` int(10) unsigned NOT NULL, - `leaderGuid` int(10) unsigned NOT NULL, - `lootMethod` tinyint(3) unsigned NOT NULL, - `looterGuid` int(10) unsigned NOT NULL, - `lootThreshold` tinyint(3) unsigned NOT NULL, - `icon1` bigint(20) unsigned NOT NULL, - `icon2` bigint(20) unsigned NOT NULL, - `icon3` bigint(20) unsigned NOT NULL, - `icon4` bigint(20) unsigned NOT NULL, - `icon5` bigint(20) unsigned NOT NULL, - `icon6` bigint(20) unsigned NOT NULL, - `icon7` bigint(20) unsigned NOT NULL, - `icon8` bigint(20) unsigned NOT NULL, - `groupType` tinyint(3) unsigned NOT NULL, - `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', - `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', - `masterLooterGuid` int(10) unsigned NOT NULL, + `guid` int unsigned NOT NULL, + `leaderGuid` int unsigned NOT NULL, + `lootMethod` tinyint unsigned NOT NULL, + `looterGuid` int unsigned NOT NULL, + `lootThreshold` tinyint unsigned NOT NULL, + `icon1` bigint unsigned NOT NULL, + `icon2` bigint unsigned NOT NULL, + `icon3` bigint unsigned NOT NULL, + `icon4` bigint unsigned NOT NULL, + `icon5` bigint unsigned NOT NULL, + `icon6` bigint unsigned NOT NULL, + `icon7` bigint unsigned NOT NULL, + `icon8` bigint unsigned NOT NULL, + `groupType` tinyint unsigned NOT NULL, + `difficulty` tinyint unsigned NOT NULL DEFAULT '0', + `raidDifficulty` tinyint unsigned NOT NULL DEFAULT '0', + `masterLooterGuid` int unsigned NOT NULL, PRIMARY KEY (`guid`), KEY `leaderGuid` (`leaderGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Groups'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1707,22 +1707,22 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild` ( - `guildid` int(10) unsigned NOT NULL DEFAULT '0', + `guildid` int unsigned NOT NULL DEFAULT '0', `name` varchar(24) NOT NULL DEFAULT '', - `leaderguid` int(10) unsigned NOT NULL DEFAULT '0', - `EmblemStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', - `EmblemColor` tinyint(3) unsigned NOT NULL DEFAULT '0', - `BorderStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', - `BorderColor` tinyint(3) unsigned NOT NULL DEFAULT '0', - `BackgroundColor` tinyint(3) unsigned NOT NULL DEFAULT '0', + `leaderguid` int unsigned NOT NULL DEFAULT '0', + `EmblemStyle` tinyint unsigned NOT NULL DEFAULT '0', + `EmblemColor` tinyint unsigned NOT NULL DEFAULT '0', + `BorderStyle` tinyint unsigned NOT NULL DEFAULT '0', + `BorderColor` tinyint unsigned NOT NULL DEFAULT '0', + `BackgroundColor` tinyint unsigned NOT NULL DEFAULT '0', `info` varchar(500) NOT NULL DEFAULT '', `motd` varchar(128) NOT NULL DEFAULT '', - `createdate` int(10) unsigned NOT NULL DEFAULT '0', - `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0', + `createdate` int unsigned NOT NULL DEFAULT '0', + `BankMoney` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1740,22 +1740,22 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_bank_eventlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_eventlog` ( - `guildid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator', - `LogGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column', - `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild bank TabId', - `EventType` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Event type', - `PlayerGuid` int(10) unsigned NOT NULL DEFAULT '0', - `ItemOrMoney` int(10) unsigned NOT NULL DEFAULT '0', - `ItemStackCount` smallint(5) unsigned NOT NULL DEFAULT '0', - `DestTabId` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Destination Tab Id', - `TimeStamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', + `guildid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator', + `LogGuid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column', + `TabId` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Guild bank TabId', + `EventType` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Event type', + `PlayerGuid` int unsigned NOT NULL DEFAULT '0', + `ItemOrMoney` int unsigned NOT NULL DEFAULT '0', + `ItemStackCount` smallint unsigned NOT NULL DEFAULT '0', + `DestTabId` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Destination Tab Id', + `TimeStamp` int unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`,`TabId`), KEY `guildid_key` (`guildid`), KEY `Idx_PlayerGuid` (`PlayerGuid`), KEY `Idx_LogGuid` (`LogGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1773,16 +1773,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_bank_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_item` ( - `guildid` int(10) unsigned NOT NULL DEFAULT '0', - `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0', - `SlotId` tinyint(3) unsigned NOT NULL DEFAULT '0', - `item_guid` int(10) unsigned NOT NULL DEFAULT '0', + `guildid` int unsigned NOT NULL DEFAULT '0', + `TabId` tinyint unsigned NOT NULL DEFAULT '0', + `SlotId` tinyint unsigned NOT NULL DEFAULT '0', + `item_guid` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`TabId`,`SlotId`), KEY `guildid_key` (`guildid`), KEY `Idx_item_guid` (`item_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1800,16 +1800,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_bank_right`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_right` ( - `guildid` int(10) unsigned NOT NULL DEFAULT '0', - `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0', - `rid` tinyint(3) unsigned NOT NULL DEFAULT '0', - `gbright` tinyint(3) unsigned NOT NULL DEFAULT '0', - `SlotPerDay` int(10) unsigned NOT NULL DEFAULT '0', + `guildid` int unsigned NOT NULL DEFAULT '0', + `TabId` tinyint unsigned NOT NULL DEFAULT '0', + `rid` tinyint unsigned NOT NULL DEFAULT '0', + `gbright` tinyint unsigned NOT NULL DEFAULT '0', + `SlotPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`TabId`,`rid`), KEY `guildid_key` (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1827,16 +1827,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_bank_tab`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_tab` ( - `guildid` int(10) unsigned NOT NULL DEFAULT '0', - `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guildid` int unsigned NOT NULL DEFAULT '0', + `TabId` tinyint unsigned NOT NULL DEFAULT '0', `TabName` varchar(16) NOT NULL DEFAULT '', `TabIcon` varchar(100) NOT NULL DEFAULT '', `TabText` varchar(500) DEFAULT NULL, PRIMARY KEY (`guildid`,`TabId`), KEY `guildid_key` (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1854,20 +1854,20 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_eventlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_eventlog` ( - `guildid` int(10) unsigned NOT NULL COMMENT 'Guild Identificator', - `LogGuid` int(10) unsigned NOT NULL COMMENT 'Log record identificator - auxiliary column', - `EventType` tinyint(3) unsigned NOT NULL COMMENT 'Event type', - `PlayerGuid1` int(10) unsigned NOT NULL COMMENT 'Player 1', - `PlayerGuid2` int(10) unsigned NOT NULL COMMENT 'Player 2', - `NewRank` tinyint(3) unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)', - `TimeStamp` int(10) unsigned NOT NULL COMMENT 'Event UNIX time', + `guildid` int unsigned NOT NULL COMMENT 'Guild Identificator', + `LogGuid` int unsigned NOT NULL COMMENT 'Log record identificator - auxiliary column', + `EventType` tinyint unsigned NOT NULL COMMENT 'Event type', + `PlayerGuid1` int unsigned NOT NULL COMMENT 'Player 1', + `PlayerGuid2` int unsigned NOT NULL COMMENT 'Player 2', + `NewRank` tinyint unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)', + `TimeStamp` int unsigned NOT NULL COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`), KEY `Idx_PlayerGuid1` (`PlayerGuid1`), KEY `Idx_PlayerGuid2` (`PlayerGuid2`), KEY `Idx_LogGuid` (`LogGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild Eventlog'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Guild Eventlog'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1885,17 +1885,17 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_member` ( - `guildid` int(10) unsigned NOT NULL COMMENT 'Guild Identificator', - `guid` int(10) unsigned NOT NULL, - `rank` tinyint(3) unsigned NOT NULL, + `guildid` int unsigned NOT NULL COMMENT 'Guild Identificator', + `guid` int unsigned NOT NULL, + `rank` tinyint unsigned NOT NULL, `pnote` varchar(31) NOT NULL DEFAULT '', `offnote` varchar(31) NOT NULL DEFAULT '', UNIQUE KEY `guid_key` (`guid`), KEY `guildid_key` (`guildid`), KEY `guildid_rank_key` (`guildid`,`rank`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1913,18 +1913,18 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_member_withdraw`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_member_withdraw` ( - `guid` int(10) unsigned NOT NULL, - `tab0` int(10) unsigned NOT NULL DEFAULT '0', - `tab1` int(10) unsigned NOT NULL DEFAULT '0', - `tab2` int(10) unsigned NOT NULL DEFAULT '0', - `tab3` int(10) unsigned NOT NULL DEFAULT '0', - `tab4` int(10) unsigned NOT NULL DEFAULT '0', - `tab5` int(10) unsigned NOT NULL DEFAULT '0', - `money` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL, + `tab0` int unsigned NOT NULL DEFAULT '0', + `tab1` int unsigned NOT NULL DEFAULT '0', + `tab2` int unsigned NOT NULL DEFAULT '0', + `tab3` int unsigned NOT NULL DEFAULT '0', + `tab4` int unsigned NOT NULL DEFAULT '0', + `tab5` int unsigned NOT NULL DEFAULT '0', + `money` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild Member Daily Withdraws'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Guild Member Daily Withdraws'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1942,16 +1942,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_rank`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_rank` ( - `guildid` int(10) unsigned NOT NULL DEFAULT '0', - `rid` tinyint(3) unsigned NOT NULL, + `guildid` int unsigned NOT NULL DEFAULT '0', + `rid` tinyint unsigned NOT NULL, `rname` varchar(20) NOT NULL DEFAULT '', - `rights` mediumint(8) unsigned NOT NULL DEFAULT '0', - `BankMoneyPerDay` int(10) unsigned NOT NULL DEFAULT '0', + `rights` mediumint unsigned NOT NULL DEFAULT '0', + `BankMoneyPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`rid`), KEY `Idx_rid` (`rid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1969,19 +1969,19 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `instance` ( - `id` int(10) unsigned NOT NULL DEFAULT '0', - `map` smallint(5) unsigned NOT NULL DEFAULT '0', - `resettime` bigint(20) unsigned NOT NULL DEFAULT '0', - `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', - `completedEncounters` int(10) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `map` smallint unsigned NOT NULL DEFAULT '0', + `resettime` bigint unsigned NOT NULL DEFAULT '0', + `difficulty` tinyint unsigned NOT NULL DEFAULT '0', + `completedEncounters` int unsigned NOT NULL DEFAULT '0', `data` tinytext NOT NULL, PRIMARY KEY (`id`), KEY `map` (`map`), KEY `resettime` (`resettime`), KEY `difficulty` (`difficulty`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1999,14 +1999,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `instance_reset`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `instance_reset` ( - `mapid` smallint(5) unsigned NOT NULL DEFAULT '0', - `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', - `resettime` bigint(20) unsigned NOT NULL DEFAULT '0', + `mapid` smallint unsigned NOT NULL DEFAULT '0', + `difficulty` tinyint unsigned NOT NULL DEFAULT '0', + `resettime` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`mapid`,`difficulty`), KEY `difficulty` (`difficulty`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2024,25 +2024,25 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0', - `owner_guid` int(10) unsigned NOT NULL DEFAULT '0', - `creatorGuid` int(10) unsigned NOT NULL DEFAULT '0', - `giftCreatorGuid` int(10) unsigned NOT NULL DEFAULT '0', - `count` int(10) unsigned NOT NULL DEFAULT '1', - `duration` int(10) NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0', + `itemEntry` mediumint unsigned NOT NULL DEFAULT '0', + `owner_guid` int unsigned NOT NULL DEFAULT '0', + `creatorGuid` int unsigned NOT NULL DEFAULT '0', + `giftCreatorGuid` int unsigned NOT NULL DEFAULT '0', + `count` int unsigned NOT NULL DEFAULT '1', + `duration` int NOT NULL DEFAULT '0', `charges` tinytext, - `flags` mediumint(8) unsigned NOT NULL DEFAULT '0', + `flags` mediumint unsigned NOT NULL DEFAULT '0', `enchantments` text NOT NULL, - `randomPropertyId` smallint(5) NOT NULL DEFAULT '0', - `durability` smallint(5) unsigned NOT NULL DEFAULT '0', - `playedTime` int(10) unsigned NOT NULL DEFAULT '0', + `randomPropertyId` smallint NOT NULL DEFAULT '0', + `durability` smallint unsigned NOT NULL DEFAULT '0', + `playedTime` int unsigned NOT NULL DEFAULT '0', `text` text, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2060,20 +2060,20 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_loot_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_loot_items` ( - `container_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)', - `item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'loot item entry (item_instance.itemEntry)', - `item_count` int(10) NOT NULL DEFAULT '0' COMMENT 'stack size', - `item_index` int(10) unsigned NOT NULL DEFAULT '0', + `container_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)', + `item_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'loot item entry (item_instance.itemEntry)', + `item_count` int NOT NULL DEFAULT '0' COMMENT 'stack size', + `item_index` int unsigned NOT NULL DEFAULT '0', `follow_rules` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'follow loot rules', `ffa` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'free-for-all', `blocked` tinyint(1) NOT NULL DEFAULT '0', `counted` tinyint(1) NOT NULL DEFAULT '0', `under_threshold` tinyint(1) NOT NULL DEFAULT '0', `needs_quest` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'quest drop', - `rnd_prop` int(10) NOT NULL DEFAULT '0' COMMENT 'random enchantment added when originally rolled', - `rnd_suffix` int(10) NOT NULL DEFAULT '0' COMMENT 'random suffix added when originally rolled' + `rnd_prop` int NOT NULL DEFAULT '0' COMMENT 'random enchantment added when originally rolled', + `rnd_suffix` int NOT NULL DEFAULT '0' COMMENT 'random suffix added when originally rolled' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2092,10 +2092,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_loot_money`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_loot_money` ( - `container_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)', - `money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'money loot (in copper)', + `container_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)', + `money` int unsigned NOT NULL DEFAULT '0' COMMENT 'money loot (in copper)', PRIMARY KEY (`container_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2115,14 +2115,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_refund_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_refund_instance` ( - `item_guid` int(10) unsigned NOT NULL COMMENT 'Item GUID', - `player_guid` int(10) unsigned NOT NULL COMMENT 'Player GUID', - `paidMoney` int(10) unsigned NOT NULL DEFAULT '0', - `paidExtendedCost` smallint(5) unsigned NOT NULL DEFAULT '0', + `item_guid` int unsigned NOT NULL COMMENT 'Item GUID', + `player_guid` int unsigned NOT NULL COMMENT 'Player GUID', + `paidMoney` int unsigned NOT NULL DEFAULT '0', + `paidExtendedCost` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`item_guid`,`player_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item Refund System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Item Refund System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2140,12 +2140,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_soulbound_trade_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_soulbound_trade_data` ( - `itemGuid` int(10) unsigned NOT NULL COMMENT 'Item GUID', + `itemGuid` int unsigned NOT NULL COMMENT 'Item GUID', `allowedPlayers` text NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', PRIMARY KEY (`itemGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item Refund System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Item Refund System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2163,19 +2163,19 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `lag_reports`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `lag_reports` ( - `reportId` int(10) unsigned NOT NULL AUTO_INCREMENT, - `guid` int(10) unsigned NOT NULL DEFAULT '0', - `lagType` tinyint(3) unsigned NOT NULL DEFAULT '0', - `mapId` smallint(5) unsigned NOT NULL DEFAULT '0', + `reportId` int unsigned NOT NULL AUTO_INCREMENT, + `guid` int unsigned NOT NULL DEFAULT '0', + `lagType` tinyint unsigned NOT NULL DEFAULT '0', + `mapId` smallint unsigned NOT NULL DEFAULT '0', `posX` float NOT NULL DEFAULT '0', `posY` float NOT NULL DEFAULT '0', `posZ` float NOT NULL DEFAULT '0', - `latency` int(10) unsigned NOT NULL DEFAULT '0', - `createTime` int(10) unsigned NOT NULL DEFAULT '0', + `latency` int unsigned NOT NULL DEFAULT '0', + `createTime` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`reportId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2193,13 +2193,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `lfg_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `lfg_data` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `dungeon` int(10) unsigned NOT NULL DEFAULT '0', - `state` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `dungeon` int unsigned NOT NULL DEFAULT '0', + `state` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='LFG Data'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='LFG Data'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2217,25 +2217,25 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `mail`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mail` ( - `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', - `messageType` tinyint(3) unsigned NOT NULL DEFAULT '0', - `stationery` tinyint(3) NOT NULL DEFAULT '41', - `mailTemplateId` smallint(5) unsigned NOT NULL DEFAULT '0', - `sender` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', - `receiver` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `messageType` tinyint unsigned NOT NULL DEFAULT '0', + `stationery` tinyint NOT NULL DEFAULT '41', + `mailTemplateId` smallint unsigned NOT NULL DEFAULT '0', + `sender` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `receiver` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `subject` longtext, `body` longtext, - `has_items` tinyint(3) unsigned NOT NULL DEFAULT '0', - `expire_time` int(10) unsigned NOT NULL DEFAULT '0', - `deliver_time` int(10) unsigned NOT NULL DEFAULT '0', - `money` int(10) unsigned NOT NULL DEFAULT '0', - `cod` int(10) unsigned NOT NULL DEFAULT '0', - `checked` tinyint(3) unsigned NOT NULL DEFAULT '0', + `has_items` tinyint unsigned NOT NULL DEFAULT '0', + `expire_time` int unsigned NOT NULL DEFAULT '0', + `deliver_time` int unsigned NOT NULL DEFAULT '0', + `money` int unsigned NOT NULL DEFAULT '0', + `cod` int unsigned NOT NULL DEFAULT '0', + `checked` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_receiver` (`receiver`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Mail System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Mail System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2253,15 +2253,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `mail_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mail_items` ( - `mail_id` int(10) unsigned NOT NULL DEFAULT '0', - `item_guid` int(10) unsigned NOT NULL DEFAULT '0', - `receiver` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `mail_id` int unsigned NOT NULL DEFAULT '0', + `item_guid` int unsigned NOT NULL DEFAULT '0', + `receiver` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', PRIMARY KEY (`item_guid`), KEY `idx_receiver` (`receiver`), KEY `idx_mail_id` (`mail_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2279,27 +2279,27 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pet_aura`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_aura` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `casterGuid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier', - `spell` mediumint(8) unsigned NOT NULL DEFAULT '0', - `effectMask` tinyint(3) unsigned NOT NULL DEFAULT '0', - `recalculateMask` tinyint(3) unsigned NOT NULL DEFAULT '0', - `stackCount` tinyint(3) unsigned NOT NULL DEFAULT '1', - `amount0` mediumint(8) NOT NULL, - `amount1` mediumint(8) NOT NULL, - `amount2` mediumint(8) NOT NULL, - `base_amount0` mediumint(8) NOT NULL, - `base_amount1` mediumint(8) NOT NULL, - `base_amount2` mediumint(8) NOT NULL, - `maxDuration` int(11) NOT NULL DEFAULT '0', - `remainTime` int(11) NOT NULL DEFAULT '0', - `remainCharges` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `casterGuid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier', + `spell` mediumint unsigned NOT NULL DEFAULT '0', + `effectMask` tinyint unsigned NOT NULL DEFAULT '0', + `recalculateMask` tinyint unsigned NOT NULL DEFAULT '0', + `stackCount` tinyint unsigned NOT NULL DEFAULT '1', + `amount0` mediumint NOT NULL, + `amount1` mediumint NOT NULL, + `amount2` mediumint NOT NULL, + `base_amount0` mediumint NOT NULL, + `base_amount1` mediumint NOT NULL, + `base_amount2` mediumint NOT NULL, + `maxDuration` int NOT NULL DEFAULT '0', + `remainTime` int NOT NULL DEFAULT '0', + `remainCharges` tinyint unsigned NOT NULL DEFAULT '0', `critChance` float NOT NULL DEFAULT '0', - `applyResilience` tinyint(3) NOT NULL DEFAULT '0', + `applyResilience` tinyint NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2317,13 +2317,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pet_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_spell` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', - `active` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `active` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2341,15 +2341,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pet_spell_cooldown`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_spell_cooldown` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', - `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', - `time` int(10) unsigned NOT NULL DEFAULT '0', - `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', - `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', + `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `time` int unsigned NOT NULL DEFAULT '0', + `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', + `categoryEnd` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2367,15 +2367,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `petition`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `petition` ( - `ownerguid` int(10) unsigned NOT NULL, - `petitionguid` int(10) unsigned DEFAULT '0', + `ownerguid` int unsigned NOT NULL, + `petitionguid` int unsigned DEFAULT '0', `name` varchar(24) NOT NULL, - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ownerguid`,`type`), UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2393,17 +2393,17 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `petition_sign`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `petition_sign` ( - `ownerguid` int(10) unsigned NOT NULL, - `petitionguid` int(10) unsigned NOT NULL DEFAULT '0', - `playerguid` int(10) unsigned NOT NULL DEFAULT '0', - `player_account` int(10) unsigned NOT NULL DEFAULT '0', - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ownerguid` int unsigned NOT NULL, + `petitionguid` int unsigned NOT NULL DEFAULT '0', + `playerguid` int unsigned NOT NULL DEFAULT '0', + `player_account` int unsigned NOT NULL DEFAULT '0', + `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`petitionguid`,`playerguid`), KEY `Idx_playerguid` (`playerguid`), KEY `Idx_ownerguid` (`ownerguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2421,12 +2421,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pool_quest_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pool_quest_save` ( - `pool_id` int(10) unsigned NOT NULL DEFAULT '0', - `quest_id` int(10) unsigned NOT NULL DEFAULT '0', + `pool_id` int unsigned NOT NULL DEFAULT '0', + `quest_id` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`pool_id`,`quest_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2444,12 +2444,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pvpstats_battlegrounds`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pvpstats_battlegrounds` ( - `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `winner_faction` tinyint(4) NOT NULL, - `bracket_id` tinyint(3) unsigned NOT NULL, - `type` tinyint(3) unsigned NOT NULL, + `id` bigint unsigned NOT NULL AUTO_INCREMENT, + `winner_faction` tinyint NOT NULL, + `bracket_id` tinyint unsigned NOT NULL, + `type` tinyint unsigned NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; @@ -2470,22 +2470,22 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pvpstats_players`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pvpstats_players` ( - `battleground_id` bigint(20) unsigned NOT NULL, - `character_guid` int(10) unsigned NOT NULL, + `battleground_id` bigint unsigned NOT NULL, + `character_guid` int unsigned NOT NULL, `winner` bit(1) NOT NULL, - `score_killing_blows` mediumint(8) unsigned NOT NULL, - `score_deaths` mediumint(8) unsigned NOT NULL, - `score_honorable_kills` mediumint(8) unsigned NOT NULL, - `score_bonus_honor` mediumint(8) unsigned NOT NULL, - `score_damage_done` mediumint(8) unsigned NOT NULL, - `score_healing_done` mediumint(8) unsigned NOT NULL, - `attr_1` mediumint(8) unsigned NOT NULL DEFAULT '0', - `attr_2` mediumint(8) unsigned NOT NULL DEFAULT '0', - `attr_3` mediumint(8) unsigned NOT NULL DEFAULT '0', - `attr_4` mediumint(8) unsigned NOT NULL DEFAULT '0', - `attr_5` mediumint(8) unsigned NOT NULL DEFAULT '0', + `score_killing_blows` mediumint unsigned NOT NULL, + `score_deaths` mediumint unsigned NOT NULL, + `score_honorable_kills` mediumint unsigned NOT NULL, + `score_bonus_honor` mediumint unsigned NOT NULL, + `score_damage_done` mediumint unsigned NOT NULL, + `score_healing_done` mediumint unsigned NOT NULL, + `attr_1` mediumint unsigned NOT NULL DEFAULT '0', + `attr_2` mediumint unsigned NOT NULL DEFAULT '0', + `attr_3` mediumint unsigned NOT NULL DEFAULT '0', + `attr_4` mediumint unsigned NOT NULL DEFAULT '0', + `attr_5` mediumint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`battleground_id`,`character_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2505,10 +2505,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `quest_tracker`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_tracker` ( - `id` mediumint(8) unsigned NOT NULL DEFAULT '0', - `character_guid` int(10) unsigned NOT NULL DEFAULT '0', + `id` mediumint unsigned NOT NULL DEFAULT '0', + `character_guid` int unsigned NOT NULL DEFAULT '0', `quest_accept_time` datetime NOT NULL, `quest_complete_time` datetime DEFAULT NULL, `quest_abandon_time` datetime DEFAULT NULL, @@ -2533,11 +2533,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `reserved_name`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reserved_name` ( `name` varchar(12) NOT NULL DEFAULT '', PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player Reserved Names'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Player Reserved Names'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2555,16 +2555,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `respawn`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `respawn` ( - `type` smallint(10) unsigned NOT NULL, - `spawnId` int(10) unsigned NOT NULL, - `respawnTime` bigint(20) unsigned NOT NULL, - `mapId` smallint(10) unsigned NOT NULL, - `instanceId` int(10) unsigned NOT NULL, + `type` smallint unsigned NOT NULL, + `spawnId` int unsigned NOT NULL, + `respawnTime` bigint unsigned NOT NULL, + `mapId` smallint unsigned NOT NULL, + `instanceId` int unsigned NOT NULL, PRIMARY KEY (`type`,`spawnId`,`instanceId`), KEY `idx_instance` (`instanceId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stored respawn times'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Stored respawn times'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2582,15 +2582,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates` ( `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.', `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.', `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', - `speed` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', + `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of all applied updates in this database.'; +) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='List of all applied updates in this database.'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2669,7 +2669,8 @@ INSERT INTO `updates` VALUES ('2021_08_15_00_characters.sql','A8A32D47C65FB6A0C7995F8342D85B6A50C6C63F','ARCHIVED','2021-08-15 16:59:31',0), ('2021_09_28_00_characters.sql','A57869AE14FFFA935AB57318F65F4F1217AA2421','ARCHIVED','2021-09-28 20:48:10',0), ('2021_10_15_00_characters.sql','174355CFEA8FADA50B731F54E028561AFCF46AA6','ARCHIVED','2021-10-15 08:43:41',0), -('2021_11_15_00_characters.sql','4C911C08E2E7A22E9A2FFC0AAC05481574D8048E','ARCHIVED','2021-11-15 16:22:37',0); +('2021_11_15_00_characters.sql','4C911C08E2E7A22E9A2FFC0AAC05481574D8048E','ARCHIVED','2021-11-15 16:22:37',0), +('2021_12_16_00_characters.sql','C250DF213B43FC2186520C3901C0A1FBF522BBDF','ARCHIVED','2021-12-16 21:17:10',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2679,12 +2680,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `updates_include`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates_include` ( `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of directories where we want to include sql updates.'; +) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2706,12 +2707,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `warden_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `warden_action` ( - `wardenId` smallint(5) unsigned NOT NULL, - `action` tinyint(3) unsigned DEFAULT NULL, + `wardenId` smallint unsigned NOT NULL, + `action` tinyint unsigned DEFAULT NULL, PRIMARY KEY (`wardenId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2729,13 +2730,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `worldstates`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `worldstates` ( - `entry` int(10) unsigned NOT NULL DEFAULT '0', - `value` int(10) unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', + `value` int unsigned NOT NULL DEFAULT '0', `comment` tinytext, PRIMARY KEY (`entry`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Variable Saves'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Variable Saves'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -2840,4 +2841,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2021-11-15 16:22:43 +-- Dump completed on 2021-12-16 21:17:13 -- cgit v1.2.3