diff options
Diffstat (limited to 'sql/base/characters_database.sql')
| -rw-r--r-- | sql/base/characters_database.sql | 1929 |
1 files changed, 965 insertions, 964 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index a7ae5bbc070..6e6a0c65399 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 utf8mb4 */; +/*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; @@ -21,11 +21,11 @@ DROP TABLE IF EXISTS `account_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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` bigint(20) NOT NULL DEFAULT '0', + `accountId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', + `type` tinyint unsigned NOT NULL DEFAULT '0', + `time` bigint NOT NULL DEFAULT '0', `data` blob NOT NULL, PRIMARY KEY (`accountId`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -46,11 +46,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `account_instance_times`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -70,17 +70,17 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `account_tutorial`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -100,23 +100,23 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `arena_team`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `arena_team` ( - `arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0', - `name` varchar(24) NOT NULL, - `captainGuid` bigint(20) 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', + `arenaTeamId` int unsigned NOT NULL DEFAULT '0', + `name` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL, + `captainGuid` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -136,15 +136,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `arena_team_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `arena_team_member` ( - `arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0', - `guid` bigint(20) 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` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -164,10 +164,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `auction_bidders`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auction_bidders` ( - `auctionId` int(10) unsigned NOT NULL, - `playerGuid` bigint(20) unsigned NOT NULL, + `auctionId` int unsigned NOT NULL, + `playerGuid` bigint unsigned NOT NULL, PRIMARY KEY (`auctionId`,`playerGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -187,10 +187,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `auction_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auction_items` ( - `auctionId` int(10) unsigned NOT NULL, - `itemGuid` bigint(20) unsigned NOT NULL, + `auctionId` int unsigned NOT NULL, + `itemGuid` bigint unsigned NOT NULL, PRIMARY KEY (`auctionId`,`itemGuid`), UNIQUE KEY `idx_itemGuid` (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -211,18 +211,18 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `auctionhouse`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auctionhouse` ( - `id` int(10) unsigned NOT NULL DEFAULT '0', - `auctionHouseId` int(10) unsigned NOT NULL DEFAULT '0', - `owner` bigint(20) unsigned NOT NULL DEFAULT '0', - `bidder` bigint(20) unsigned NOT NULL DEFAULT '0', - `minBid` bigint(20) unsigned NOT NULL DEFAULT '0', - `buyoutOrUnitPrice` bigint(20) unsigned NOT NULL DEFAULT '0', - `deposit` bigint(20) unsigned NOT NULL DEFAULT '0', - `bidAmount` bigint(20) unsigned NOT NULL DEFAULT '0', - `startTime` bigint(20) NOT NULL DEFAULT '0', - `endTime` bigint(20) NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `auctionHouseId` int unsigned NOT NULL DEFAULT '0', + `owner` bigint unsigned NOT NULL DEFAULT '0', + `bidder` bigint unsigned NOT NULL DEFAULT '0', + `minBid` bigint unsigned NOT NULL DEFAULT '0', + `buyoutOrUnitPrice` bigint unsigned NOT NULL DEFAULT '0', + `deposit` bigint unsigned NOT NULL DEFAULT '0', + `bidAmount` bigint unsigned NOT NULL DEFAULT '0', + `startTime` bigint NOT NULL DEFAULT '0', + `endTime` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -242,13 +242,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `blackmarket_auctions`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blackmarket_auctions` ( - `marketId` int(10) NOT NULL DEFAULT '0', - `currentBid` bigint(20) unsigned NOT NULL DEFAULT '0', - `time` bigint(20) NOT NULL DEFAULT '0', - `numBids` int(10) NOT NULL DEFAULT '0', - `bidder` bigint(20) unsigned NOT NULL DEFAULT '0', + `marketId` int NOT NULL DEFAULT '0', + `currentBid` bigint unsigned NOT NULL DEFAULT '0', + `time` bigint NOT NULL DEFAULT '0', + `numBids` int NOT NULL DEFAULT '0', + `bidder` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`marketId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -268,11 +268,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `bugreport`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `bugreport` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', - `type` longtext NOT NULL, - `content` longtext NOT NULL, + `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', + `type` longtext COLLATE utf8mb4_unicode_ci NOT NULL, + `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Debug System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -292,17 +292,17 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `calendar_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `calendar_events` ( - `EventID` bigint(20) unsigned NOT NULL DEFAULT '0', - `Owner` bigint(20) unsigned NOT NULL DEFAULT '0', - `Title` varchar(255) NOT NULL DEFAULT '', - `Description` varchar(255) NOT NULL DEFAULT '', - `EventType` tinyint(1) unsigned NOT NULL DEFAULT '4', - `TextureID` int(10) NOT NULL DEFAULT '-1', - `Date` bigint(20) NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', - `LockDate` bigint(20) NOT NULL DEFAULT '0', + `EventID` bigint unsigned NOT NULL DEFAULT '0', + `Owner` bigint unsigned NOT NULL DEFAULT '0', + `Title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `EventType` tinyint unsigned NOT NULL DEFAULT '4', + `TextureID` int NOT NULL DEFAULT '-1', + `Date` bigint NOT NULL DEFAULT '0', + `Flags` int unsigned NOT NULL DEFAULT '0', + `LockDate` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`EventID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -322,16 +322,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `calendar_invites`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `calendar_invites` ( - `InviteID` bigint(20) unsigned NOT NULL DEFAULT '0', - `EventID` bigint(20) unsigned NOT NULL DEFAULT '0', - `Invitee` bigint(20) unsigned NOT NULL DEFAULT '0', - `Sender` bigint(20) unsigned NOT NULL DEFAULT '0', - `Status` tinyint(1) unsigned NOT NULL DEFAULT '0', - `ResponseTime` bigint(20) NOT NULL DEFAULT '0', - `ModerationRank` tinyint(1) unsigned NOT NULL DEFAULT '0', - `Note` varchar(255) NOT NULL DEFAULT '', + `InviteID` bigint unsigned NOT NULL DEFAULT '0', + `EventID` bigint unsigned NOT NULL DEFAULT '0', + `Invitee` bigint unsigned NOT NULL DEFAULT '0', + `Sender` bigint unsigned NOT NULL DEFAULT '0', + `Status` tinyint unsigned NOT NULL DEFAULT '0', + `ResponseTime` bigint NOT NULL DEFAULT '0', + `ModerationRank` tinyint unsigned NOT NULL DEFAULT '0', + `Note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`InviteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -351,15 +351,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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', - `password` varchar(128) DEFAULT NULL, - `bannedList` text, - `lastUsed` bigint(20) unsigned NOT NULL, + `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, + `team` int unsigned NOT NULL, + `announce` tinyint unsigned NOT NULL DEFAULT '1', + `ownership` tinyint unsigned NOT NULL DEFAULT '1', + `password` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `bannedList` text COLLATE utf8mb4_unicode_ci, + `lastUsed` bigint unsigned NOT NULL, PRIMARY KEY (`name`,`team`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Channel System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -379,11 +379,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_account_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_account_data` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `time` bigint(20) NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0', + `type` tinyint unsigned NOT NULL DEFAULT '0', + `time` bigint NOT NULL DEFAULT '0', `data` blob NOT NULL, PRIMARY KEY (`guid`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -404,11 +404,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_achievement`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_achievement` ( - `guid` bigint(20) unsigned NOT NULL, - `achievement` int(10) unsigned NOT NULL, - `date` bigint(20) NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `achievement` int unsigned NOT NULL, + `date` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`achievement`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -428,12 +428,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_achievement_progress`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_achievement_progress` ( - `guid` bigint(20) unsigned NOT NULL, - `criteria` int(10) unsigned NOT NULL, - `counter` bigint(20) unsigned NOT NULL, - `date` bigint(20) NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `criteria` int unsigned NOT NULL, + `counter` bigint unsigned NOT NULL, + `date` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`criteria`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -453,13 +453,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_action` ( - `guid` bigint(20) 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` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -479,11 +479,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_arena_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_arena_stats` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', - `matchMakerRating` smallint(5) unsigned NOT NULL DEFAULT '0', + `guid` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -503,21 +503,21 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_aura`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_aura` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier', `itemGuid` binary(16) NOT NULL, - `spell` int(10) unsigned NOT NULL, - `effectMask` int(10) unsigned NOT NULL, - `recalculateMask` int(10) unsigned NOT NULL DEFAULT '0', - `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', - `stackCount` tinyint(3) unsigned NOT NULL DEFAULT '1', - `maxDuration` int(11) NOT NULL DEFAULT '0', - `remainTime` int(11) NOT NULL DEFAULT '0', - `remainCharges` tinyint(3) unsigned NOT NULL DEFAULT '0', - `castItemId` int(10) unsigned NOT NULL DEFAULT '0', - `castItemLevel` int(11) NOT NULL DEFAULT '-1', + `spell` int unsigned NOT NULL, + `effectMask` int unsigned NOT NULL, + `recalculateMask` int unsigned NOT NULL DEFAULT '0', + `difficulty` tinyint unsigned NOT NULL DEFAULT '0', + `stackCount` tinyint unsigned NOT NULL DEFAULT '1', + `maxDuration` int NOT NULL DEFAULT '0', + `remainTime` int NOT NULL DEFAULT '0', + `remainCharges` tinyint unsigned NOT NULL DEFAULT '0', + `castItemId` int unsigned NOT NULL DEFAULT '0', + `castItemLevel` int NOT NULL DEFAULT '-1', PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -537,16 +537,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_aura_effect`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_aura_effect` ( - `guid` bigint(20) unsigned NOT NULL, + `guid` bigint unsigned NOT NULL, `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier', `itemGuid` binary(16) NOT NULL, - `spell` int(10) unsigned NOT NULL, - `effectMask` int(10) unsigned NOT NULL, - `effectIndex` tinyint(3) unsigned NOT NULL, - `amount` int(11) NOT NULL DEFAULT '0', - `baseAmount` int(11) NOT NULL DEFAULT '0', + `spell` int unsigned NOT NULL, + `effectMask` int unsigned NOT NULL, + `effectIndex` tinyint unsigned NOT NULL, + `amount` int NOT NULL DEFAULT '0', + `baseAmount` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`,`effectIndex`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -566,11 +566,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_aura_stored_location`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_aura_stored_location` ( - `Guid` bigint(20) unsigned NOT NULL COMMENT 'Global Unique Identifier of Player', - `Spell` int(10) unsigned NOT NULL COMMENT 'Spell Identifier', - `MapId` int(10) unsigned NOT NULL COMMENT 'Map Id', + `Guid` bigint unsigned NOT NULL COMMENT 'Global Unique Identifier of Player', + `Spell` int unsigned NOT NULL COMMENT 'Spell Identifier', + `MapId` int unsigned NOT NULL COMMENT 'Map Id', `PositionX` float NOT NULL COMMENT 'position x', `PositionY` float NOT NULL COMMENT 'position y', `PositionZ` float NOT NULL COMMENT 'position z', @@ -594,14 +594,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_banned`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_banned` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `bandate` bigint(20) NOT NULL DEFAULT '0', - `unbandate` bigint(20) NOT NULL DEFAULT '0', - `bannedby` varchar(50) NOT NULL, - `banreason` varchar(255) NOT NULL, - `active` tinyint(3) unsigned NOT NULL DEFAULT '1', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `bandate` bigint NOT NULL DEFAULT '0', + `unbandate` bigint NOT NULL DEFAULT '0', + `bannedby` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, + `banreason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `active` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`guid`,`bandate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Ban List'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -621,19 +621,19 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_battleground_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_battleground_data` ( - `guid` bigint(20) 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` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -653,9 +653,9 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_battleground_random`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_battleground_random` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -675,22 +675,22 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_cuf_profiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_cuf_profiles` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Guid', - `id` tinyint(3) unsigned NOT NULL COMMENT 'Profile Id (0-4)', - `name` varchar(12) NOT NULL COMMENT 'Profile Name', - `frameHeight` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Height', - `frameWidth` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Width', - `sortBy` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Sort By', - `healthText` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Health Text', - `boolOptions` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Many Configurable Bool Options', - `topPoint` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame top alignment', - `bottomPoint` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame bottom alignment', - `leftPoint` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame left alignment', - `topOffset` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from top', - `bottomOffset` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from bottom', - `leftOffset` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from left', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Guid', + `id` tinyint unsigned NOT NULL COMMENT 'Profile Id (0-4)', + `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Profile Name', + `frameHeight` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Height', + `frameWidth` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Width', + `sortBy` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Sort By', + `healthText` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Health Text', + `boolOptions` int unsigned NOT NULL DEFAULT '0' COMMENT 'Many Configurable Bool Options', + `topPoint` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame top alignment', + `bottomPoint` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame bottom alignment', + `leftPoint` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame left alignment', + `topOffset` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from top', + `bottomOffset` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from bottom', + `leftOffset` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame position offset from left', PRIMARY KEY (`guid`,`id`), KEY `index` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -711,14 +711,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_currency`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_currency` ( - `CharacterGuid` bigint(20) unsigned NOT NULL DEFAULT '0', - `Currency` smallint(5) unsigned NOT NULL, - `Quantity` int(10) unsigned NOT NULL, - `WeeklyQuantity` int(10) unsigned NOT NULL, - `TrackedQuantity` int(10) unsigned NOT NULL, - `Flags` tinyint(3) unsigned NOT NULL, + `CharacterGuid` bigint unsigned NOT NULL DEFAULT '0', + `Currency` smallint unsigned NOT NULL, + `Quantity` int unsigned NOT NULL, + `WeeklyQuantity` int unsigned NOT NULL, + `TrackedQuantity` int unsigned NOT NULL, + `Flags` tinyint unsigned NOT NULL, PRIMARY KEY (`CharacterGuid`,`Currency`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -738,11 +738,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_customizations`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_customizations` ( - `guid` bigint(20) unsigned NOT NULL, - `chrCustomizationOptionID` int(10) unsigned NOT NULL, - `chrCustomizationChoiceID` int(10) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `chrCustomizationOptionID` int unsigned NOT NULL, + `chrCustomizationChoiceID` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`chrCustomizationOptionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -762,14 +762,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_declinedname`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_declinedname` ( - `guid` bigint(20) 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 '', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `genitive` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `dative` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `accusative` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `instrumental` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `prepositional` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -789,34 +789,34 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_equipmentsets`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_equipmentsets` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `setguid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `setindex` tinyint(3) unsigned NOT NULL DEFAULT '0', - `name` varchar(31) NOT NULL, - `iconname` varchar(100) NOT NULL, - `ignore_mask` int(11) unsigned NOT NULL DEFAULT '0', - `AssignedSpecIndex` int(11) NOT NULL DEFAULT '-1', - `item0` bigint(20) unsigned NOT NULL DEFAULT '0', - `item1` bigint(20) unsigned NOT NULL DEFAULT '0', - `item2` bigint(20) unsigned NOT NULL DEFAULT '0', - `item3` bigint(20) unsigned NOT NULL DEFAULT '0', - `item4` bigint(20) unsigned NOT NULL DEFAULT '0', - `item5` bigint(20) unsigned NOT NULL DEFAULT '0', - `item6` bigint(20) unsigned NOT NULL DEFAULT '0', - `item7` bigint(20) unsigned NOT NULL DEFAULT '0', - `item8` bigint(20) unsigned NOT NULL DEFAULT '0', - `item9` bigint(20) unsigned NOT NULL DEFAULT '0', - `item10` bigint(20) unsigned NOT NULL DEFAULT '0', - `item11` bigint(20) unsigned NOT NULL DEFAULT '0', - `item12` bigint(20) unsigned NOT NULL DEFAULT '0', - `item13` bigint(20) unsigned NOT NULL DEFAULT '0', - `item14` bigint(20) unsigned NOT NULL DEFAULT '0', - `item15` bigint(20) unsigned NOT NULL DEFAULT '0', - `item16` bigint(20) unsigned NOT NULL DEFAULT '0', - `item17` bigint(20) unsigned NOT NULL DEFAULT '0', - `item18` bigint(20) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0', + `setguid` bigint unsigned NOT NULL AUTO_INCREMENT, + `setindex` tinyint unsigned NOT NULL DEFAULT '0', + `name` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL, + `iconname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, + `ignore_mask` int unsigned NOT NULL DEFAULT '0', + `AssignedSpecIndex` int NOT NULL DEFAULT '-1', + `item0` bigint unsigned NOT NULL DEFAULT '0', + `item1` bigint unsigned NOT NULL DEFAULT '0', + `item2` bigint unsigned NOT NULL DEFAULT '0', + `item3` bigint unsigned NOT NULL DEFAULT '0', + `item4` bigint unsigned NOT NULL DEFAULT '0', + `item5` bigint unsigned NOT NULL DEFAULT '0', + `item6` bigint unsigned NOT NULL DEFAULT '0', + `item7` bigint unsigned NOT NULL DEFAULT '0', + `item8` bigint unsigned NOT NULL DEFAULT '0', + `item9` bigint unsigned NOT NULL DEFAULT '0', + `item10` bigint unsigned NOT NULL DEFAULT '0', + `item11` bigint unsigned NOT NULL DEFAULT '0', + `item12` bigint unsigned NOT NULL DEFAULT '0', + `item13` bigint unsigned NOT NULL DEFAULT '0', + `item14` bigint unsigned NOT NULL DEFAULT '0', + `item15` bigint unsigned NOT NULL DEFAULT '0', + `item16` bigint unsigned NOT NULL DEFAULT '0', + `item17` bigint unsigned NOT NULL DEFAULT '0', + `item18` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`setguid`), UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`), KEY `Idx_setindex` (`setindex`) @@ -838,14 +838,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_favorite_auctions`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_favorite_auctions` ( - `guid` bigint(20) unsigned NOT NULL, - `order` int(10) unsigned NOT NULL DEFAULT '0', - `itemId` int(10) unsigned NOT NULL DEFAULT '0', - `itemLevel` int(10) unsigned NOT NULL DEFAULT '0', - `battlePetSpeciesId` int(10) unsigned NOT NULL DEFAULT '0', - `suffixItemNameDescriptionId` int(10) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `order` int unsigned NOT NULL DEFAULT '0', + `itemId` int unsigned NOT NULL DEFAULT '0', + `itemLevel` int unsigned NOT NULL DEFAULT '0', + `battlePetSpeciesId` int unsigned NOT NULL DEFAULT '0', + `suffixItemNameDescriptionId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -865,10 +865,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_fishingsteps`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_fishingsteps` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `fishingSteps` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `fishingSteps` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -888,11 +888,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_garrison`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_garrison` ( - `guid` bigint(20) unsigned NOT NULL, - `siteLevelId` int(10) unsigned NOT NULL DEFAULT '0', - `followerActivationsRemainingToday` int(10) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `siteLevelId` int unsigned NOT NULL DEFAULT '0', + `followerActivationsRemainingToday` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -912,10 +912,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_garrison_blueprints`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_garrison_blueprints` ( - `guid` bigint(20) unsigned NOT NULL, - `buildingId` int(10) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `buildingId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`buildingId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -935,13 +935,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_garrison_buildings`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_garrison_buildings` ( - `guid` bigint(20) unsigned NOT NULL, - `plotInstanceId` int(10) unsigned NOT NULL DEFAULT '0', - `buildingId` int(10) unsigned NOT NULL DEFAULT '0', - `timeBuilt` bigint(20) NOT NULL, - `active` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `plotInstanceId` int unsigned NOT NULL DEFAULT '0', + `buildingId` int unsigned NOT NULL DEFAULT '0', + `timeBuilt` bigint NOT NULL, + `active` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`plotInstanceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -961,11 +961,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_garrison_follower_abilities`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_garrison_follower_abilities` ( - `dbId` bigint(20) unsigned NOT NULL, - `abilityId` int(10) unsigned NOT NULL, - `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', + `dbId` bigint unsigned NOT NULL, + `abilityId` int unsigned NOT NULL, + `slot` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`dbId`,`abilityId`,`slot`), CONSTRAINT `fk_foll_dbid` FOREIGN KEY (`dbId`) REFERENCES `character_garrison_followers` (`dbId`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -986,19 +986,19 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_garrison_followers`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_garrison_followers` ( - `dbId` bigint(20) unsigned NOT NULL, - `guid` bigint(20) unsigned NOT NULL, - `followerId` int(10) unsigned NOT NULL, - `quality` int(10) unsigned NOT NULL DEFAULT '2', - `level` int(10) unsigned NOT NULL DEFAULT '90', - `itemLevelWeapon` int(10) unsigned NOT NULL DEFAULT '600', - `itemLevelArmor` int(10) unsigned NOT NULL DEFAULT '600', - `xp` int(10) unsigned NOT NULL DEFAULT '0', - `currentBuilding` int(10) unsigned NOT NULL DEFAULT '0', - `currentMission` int(10) unsigned NOT NULL DEFAULT '0', - `status` int(10) unsigned NOT NULL DEFAULT '0', + `dbId` bigint unsigned NOT NULL, + `guid` bigint unsigned NOT NULL, + `followerId` int unsigned NOT NULL, + `quality` int unsigned NOT NULL DEFAULT '2', + `level` int unsigned NOT NULL DEFAULT '90', + `itemLevelWeapon` int unsigned NOT NULL DEFAULT '600', + `itemLevelArmor` int unsigned NOT NULL DEFAULT '600', + `xp` int unsigned NOT NULL DEFAULT '0', + `currentBuilding` int unsigned NOT NULL DEFAULT '0', + `currentMission` int unsigned NOT NULL DEFAULT '0', + `status` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`dbId`), UNIQUE KEY `idx_guid_id` (`guid`,`followerId`), CONSTRAINT `fk_foll_owner` FOREIGN KEY (`guid`) REFERENCES `characters` (`guid`) @@ -1020,12 +1020,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_gifts`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_gifts` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `item_guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `entry` int(10) unsigned NOT NULL DEFAULT '0', - `flags` int(10) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0', + `item_guid` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1046,11 +1046,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_glyphs`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_glyphs` ( - `guid` bigint(20) unsigned NOT NULL, - `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', - `glyphId` smallint(5) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `talentGroup` tinyint unsigned NOT NULL DEFAULT '0', + `glyphId` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`talentGroup`,`glyphId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1070,11 +1070,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_homebind`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_homebind` ( - `guid` bigint(20) 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` bigint 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', @@ -1098,12 +1098,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_instance` ( - `guid` bigint(20) 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` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1124,12 +1124,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_inventory`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_inventory` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `bag` bigint(20) unsigned NOT NULL DEFAULT '0', - `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', - `item` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `bag` bigint unsigned NOT NULL DEFAULT '0', + `slot` tinyint unsigned NOT NULL DEFAULT '0', + `item` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier', PRIMARY KEY (`item`), UNIQUE KEY `guid` (`guid`,`bag`,`slot`), KEY `idx_guid` (`guid`) @@ -1151,25 +1151,25 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_pet`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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` bigint(10) unsigned NOT NULL DEFAULT '0', - `modelid` int(10) unsigned DEFAULT '0', - `CreatedBySpell` int(10) 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', - `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', - `savetime` int(10) unsigned NOT NULL DEFAULT '0', - `abdata` text, - `specialization` smallint(5) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `entry` int unsigned NOT NULL DEFAULT '0', + `owner` bigint unsigned NOT NULL DEFAULT '0', + `modelid` int unsigned DEFAULT '0', + `CreatedBySpell` int 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pet', + `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', + `savetime` int unsigned NOT NULL DEFAULT '0', + `abdata` text COLLATE utf8mb4_unicode_ci, + `specialization` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `owner` (`owner`), KEY `idx_slot` (`slot`) @@ -1191,15 +1191,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_pet_declinedname`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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', - `genitive` varchar(12) NOT NULL DEFAULT '', - `dative` varchar(12) NOT NULL DEFAULT '', - `accusative` varchar(12) NOT NULL DEFAULT '', - `instrumental` varchar(12) NOT NULL DEFAULT '', - `prepositional` varchar(12) NOT NULL DEFAULT '', + `id` int unsigned NOT NULL DEFAULT '0', + `owner` int unsigned NOT NULL DEFAULT '0', + `genitive` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `dative` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `accusative` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `instrumental` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `prepositional` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `owner_key` (`owner`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1220,14 +1220,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_pvp_talent`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_pvp_talent` ( - `guid` bigint(20) unsigned NOT NULL, - `talentId0` int(10) unsigned NOT NULL, - `talentId1` int(10) unsigned NOT NULL, - `talentId2` int(10) unsigned NOT NULL, - `talentId3` int(10) unsigned NOT NULL, - `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `talentId0` int unsigned NOT NULL, + `talentId1` int unsigned NOT NULL, + `talentId2` int unsigned NOT NULL, + `talentId3` int unsigned NOT NULL, + `talentGroup` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`talentGroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1247,14 +1247,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `quest` int(10) unsigned NOT NULL DEFAULT '0', - `status` tinyint(3) unsigned NOT NULL DEFAULT '0', - `explored` tinyint(3) unsigned NOT NULL DEFAULT '0', - `acceptTime` bigint(20) NOT NULL DEFAULT '0', - `endTime` bigint(20) NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0', + `quest` int unsigned NOT NULL DEFAULT '0', + `status` tinyint unsigned NOT NULL DEFAULT '0', + `explored` tinyint unsigned NOT NULL DEFAULT '0', + `acceptTime` bigint NOT NULL DEFAULT '0', + `endTime` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1274,11 +1274,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_daily`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_daily` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', - `time` bigint(20) NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `time` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; @@ -1299,10 +1299,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_monthly`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_monthly` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `guid` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; @@ -1323,12 +1323,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_objectives`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_objectives` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `quest` int(10) unsigned NOT NULL DEFAULT '0', - `objective` tinyint(3) unsigned NOT NULL DEFAULT '0', - `data` int(11) NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0', + `quest` int unsigned NOT NULL DEFAULT '0', + `objective` tinyint unsigned NOT NULL DEFAULT '0', + `data` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`,`objective`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1348,10 +1348,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_objectives_criteria`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_objectives_criteria` ( - `guid` bigint(20) unsigned NOT NULL, - `questObjectiveId` int(10) unsigned NOT NULL, + `guid` bigint unsigned NOT NULL, + `questObjectiveId` int unsigned NOT NULL, PRIMARY KEY (`guid`,`questObjectiveId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1371,12 +1371,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_objectives_criteria_progress`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_objectives_criteria_progress` ( - `guid` bigint(20) unsigned NOT NULL, - `criteriaId` int(10) unsigned NOT NULL, - `counter` bigint(20) unsigned NOT NULL, - `date` bigint(20) NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `criteriaId` int unsigned NOT NULL, + `counter` bigint unsigned NOT NULL, + `date` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`criteriaId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1396,11 +1396,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_rewarded`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_rewarded` ( - `guid` bigint(20) 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` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1420,11 +1420,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_seasonal`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_seasonal` ( - `guid` bigint(20) 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` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; @@ -1445,10 +1445,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_queststatus_weekly`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_queststatus_weekly` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `guid` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; @@ -1469,12 +1469,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_reputation`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_reputation` ( - `guid` bigint(20) 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` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1494,12 +1494,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_skills`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_skills` ( - `guid` bigint(20) 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` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1519,12 +1519,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_social`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_social` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', - `friend` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier', - `flags` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags', - `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `friend` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier', + `flags` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags', + `note` varchar(48) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Friend Note', PRIMARY KEY (`guid`,`friend`,`flags`), KEY `friend` (`friend`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; @@ -1545,12 +1545,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_spell` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `spell` int(10) 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` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `spell` int 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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1570,12 +1570,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_spell_charges`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_spell_charges` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', - `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier', - `rechargeStart` bigint(20) NOT NULL DEFAULT '0', - `rechargeEnd` bigint(20) NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', + `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier', + `rechargeStart` bigint NOT NULL DEFAULT '0', + `rechargeEnd` bigint NOT NULL DEFAULT '0', KEY `idx_guid` (`guid`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1595,14 +1595,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_spell_cooldown`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_spell_cooldown` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', - `spell` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', - `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier', - `time` bigint(20) NOT NULL DEFAULT '0', - `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', - `categoryEnd` bigint(20) NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', + `spell` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `item` int unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier', + `time` bigint NOT NULL DEFAULT '0', + `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', + `categoryEnd` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1622,38 +1622,38 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_stats` ( - `guid` bigint(20) 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', - `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` bigint 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', + `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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1673,11 +1673,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_talent`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_talent` ( - `guid` bigint(20) unsigned NOT NULL, - `talentId` int(10) unsigned NOT NULL, - `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL, + `talentId` int unsigned NOT NULL, + `talentGroup` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`talentId`,`talentGroup`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1697,35 +1697,35 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_transmog_outfits`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_transmog_outfits` ( - `guid` bigint(20) NOT NULL DEFAULT '0', - `setguid` bigint(20) NOT NULL AUTO_INCREMENT, - `setindex` tinyint(3) unsigned NOT NULL DEFAULT '0', - `name` varchar(128) NOT NULL, - `iconname` varchar(256) NOT NULL, - `ignore_mask` int(11) NOT NULL DEFAULT '0', - `appearance0` int(10) NOT NULL DEFAULT '0', - `appearance1` int(10) NOT NULL DEFAULT '0', - `appearance2` int(10) NOT NULL DEFAULT '0', - `appearance3` int(10) NOT NULL DEFAULT '0', - `appearance4` int(10) NOT NULL DEFAULT '0', - `appearance5` int(10) NOT NULL DEFAULT '0', - `appearance6` int(10) NOT NULL DEFAULT '0', - `appearance7` int(10) NOT NULL DEFAULT '0', - `appearance8` int(10) NOT NULL DEFAULT '0', - `appearance9` int(10) NOT NULL DEFAULT '0', - `appearance10` int(10) NOT NULL DEFAULT '0', - `appearance11` int(10) NOT NULL DEFAULT '0', - `appearance12` int(10) NOT NULL DEFAULT '0', - `appearance13` int(10) NOT NULL DEFAULT '0', - `appearance14` int(10) NOT NULL DEFAULT '0', - `appearance15` int(10) NOT NULL DEFAULT '0', - `appearance16` int(10) NOT NULL DEFAULT '0', - `appearance17` int(10) NOT NULL DEFAULT '0', - `appearance18` int(10) NOT NULL DEFAULT '0', - `mainHandEnchant` int(10) NOT NULL DEFAULT '0', - `offHandEnchant` int(10) NOT NULL DEFAULT '0', + `guid` bigint NOT NULL DEFAULT '0', + `setguid` bigint NOT NULL AUTO_INCREMENT, + `setindex` tinyint unsigned NOT NULL DEFAULT '0', + `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, + `iconname` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL, + `ignore_mask` int NOT NULL DEFAULT '0', + `appearance0` int NOT NULL DEFAULT '0', + `appearance1` int NOT NULL DEFAULT '0', + `appearance2` int NOT NULL DEFAULT '0', + `appearance3` int NOT NULL DEFAULT '0', + `appearance4` int NOT NULL DEFAULT '0', + `appearance5` int NOT NULL DEFAULT '0', + `appearance6` int NOT NULL DEFAULT '0', + `appearance7` int NOT NULL DEFAULT '0', + `appearance8` int NOT NULL DEFAULT '0', + `appearance9` int NOT NULL DEFAULT '0', + `appearance10` int NOT NULL DEFAULT '0', + `appearance11` int NOT NULL DEFAULT '0', + `appearance12` int NOT NULL DEFAULT '0', + `appearance13` int NOT NULL DEFAULT '0', + `appearance14` int NOT NULL DEFAULT '0', + `appearance15` int NOT NULL DEFAULT '0', + `appearance16` int NOT NULL DEFAULT '0', + `appearance17` int NOT NULL DEFAULT '0', + `appearance18` int NOT NULL DEFAULT '0', + `mainHandEnchant` int NOT NULL DEFAULT '0', + `offHandEnchant` int NOT NULL DEFAULT '0', PRIMARY KEY (`setguid`), UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`), KEY `Idx_setindex` (`setindex`) @@ -1747,18 +1747,18 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `character_void_storage`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_void_storage` ( - `itemId` bigint(20) unsigned NOT NULL, - `playerGuid` bigint(20) unsigned NOT NULL, - `itemEntry` int(10) unsigned NOT NULL, - `slot` tinyint(3) unsigned NOT NULL, - `creatorGuid` bigint(20) unsigned NOT NULL DEFAULT '0', - `randomBonusListId` int(10) unsigned NOT NULL DEFAULT '0', - `fixedScalingLevel` int(10) unsigned DEFAULT '0', - `artifactKnowledgeLevel` int(10) unsigned DEFAULT '0', - `context` tinyint(3) unsigned NOT NULL DEFAULT '0', - `bonusListIDs` text, + `itemId` bigint unsigned NOT NULL, + `playerGuid` bigint unsigned NOT NULL, + `itemEntry` int unsigned NOT NULL, + `slot` tinyint unsigned NOT NULL, + `creatorGuid` bigint unsigned NOT NULL DEFAULT '0', + `randomBonusListId` int unsigned NOT NULL DEFAULT '0', + `fixedScalingLevel` int unsigned DEFAULT '0', + `artifactKnowledgeLevel` int unsigned DEFAULT '0', + `context` tinyint unsigned NOT NULL DEFAULT '0', + `bonusListIDs` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`itemId`), UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`), KEY `idx_player` (`playerGuid`) @@ -1780,86 +1780,86 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `characters`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `characters` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `account` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', - `name` varchar(12) NOT NULL, - `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', - `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` bigint(20) unsigned NOT NULL DEFAULT '0', - `inventorySlots` tinyint(3) unsigned NOT NULL DEFAULT '16', - `bankSlots` tinyint(3) unsigned NOT NULL DEFAULT '0', - `restState` tinyint(3) unsigned NOT NULL DEFAULT '0', - `playerFlags` int(10) unsigned NOT NULL DEFAULT '0', - `playerFlagsEx` int(10) unsigned NOT NULL DEFAULT '0', + `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `account` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', + `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL, + `slot` tinyint 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` bigint unsigned NOT NULL DEFAULT '0', + `inventorySlots` tinyint unsigned NOT NULL DEFAULT '16', + `bankSlots` tinyint unsigned NOT NULL DEFAULT '0', + `restState` tinyint unsigned NOT NULL DEFAULT '0', + `playerFlags` int unsigned NOT NULL DEFAULT '0', + `playerFlagsEx` 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', - `dungeonDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '1', - `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '14', - `legacyRaidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '3', + `map` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `instance_id` int unsigned NOT NULL DEFAULT '0', + `dungeonDifficulty` tinyint unsigned NOT NULL DEFAULT '1', + `raidDifficulty` tinyint unsigned NOT NULL DEFAULT '14', + `legacyRaidDifficulty` tinyint unsigned NOT NULL DEFAULT '3', `orientation` float NOT NULL DEFAULT '0', - `taximask` text NOT NULL, - `online` tinyint(3) unsigned NOT NULL DEFAULT '0', - `createTime` bigint(20) NOT NULL DEFAULT '0', - `createMode` tinyint(4) 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` bigint(20) NOT NULL DEFAULT '0', - `is_logout_resting` tinyint(3) unsigned NOT NULL DEFAULT '0', + `taximask` text COLLATE utf8mb4_unicode_ci NOT NULL, + `online` tinyint unsigned NOT NULL DEFAULT '0', + `createTime` bigint NOT NULL DEFAULT '0', + `createMode` tinyint 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` bigint 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` bigint(20) NOT NULL DEFAULT '0', - `numRespecs` tinyint(3) unsigned NOT NULL DEFAULT '0', - `primarySpecialization` int(10) unsigned NOT NULL DEFAULT '0', + `resettalents_cost` int unsigned NOT NULL DEFAULT '0', + `resettalents_time` bigint NOT NULL DEFAULT '0', + `numRespecs` tinyint unsigned NOT NULL DEFAULT '0', + `primarySpecialization` 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` bigint(20) 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` bigint(20) NOT NULL DEFAULT '0', - `taxi_path` text, - `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', - `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` int(10) unsigned NOT NULL DEFAULT '0', - `activeTalentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', - `lootSpecId` int(10) unsigned NOT NULL DEFAULT '0', - `exploredZones` longtext, - `equipmentCache` longtext, - `knownTitles` longtext, - `actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0', - `deleteInfos_Account` int(10) unsigned DEFAULT NULL, - `deleteInfos_Name` varchar(12) DEFAULT NULL, - `deleteDate` bigint(20) DEFAULT NULL, - `honor` int(10) unsigned NOT NULL DEFAULT '0', - `honorLevel` int(10) unsigned NOT NULL DEFAULT '1', - `honorRestState` tinyint(3) unsigned NOT NULL DEFAULT '2', + `transguid` bigint 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` bigint NOT NULL DEFAULT '0', + `taxi_path` text COLLATE utf8mb4_unicode_ci, + `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', + `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` int unsigned NOT NULL DEFAULT '0', + `activeTalentGroup` tinyint unsigned NOT NULL DEFAULT '0', + `lootSpecId` int unsigned NOT NULL DEFAULT '0', + `exploredZones` longtext COLLATE utf8mb4_unicode_ci, + `equipmentCache` longtext COLLATE utf8mb4_unicode_ci, + `knownTitles` longtext COLLATE utf8mb4_unicode_ci, + `actionBars` tinyint unsigned NOT NULL DEFAULT '0', + `deleteInfos_Account` int unsigned DEFAULT NULL, + `deleteInfos_Name` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `deleteDate` bigint DEFAULT NULL, + `honor` int unsigned NOT NULL DEFAULT '0', + `honorLevel` int unsigned NOT NULL DEFAULT '1', + `honorRestState` tinyint unsigned NOT NULL DEFAULT '2', `honorRestBonus` float NOT NULL DEFAULT '0', - `lastLoginBuild` int(10) unsigned NOT NULL DEFAULT '0', + `lastLoginBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`), KEY `idx_account` (`account`), KEY `idx_online` (`online`), @@ -1882,24 +1882,24 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `corpse`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `corpse` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `guid` bigint 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', - `displayId` int(10) unsigned NOT NULL DEFAULT '0', - `itemCache` text 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', - `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', + `mapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `displayId` int unsigned NOT NULL DEFAULT '0', + `itemCache` text COLLATE utf8mb4_unicode_ci NOT NULL, + `race` tinyint unsigned NOT NULL DEFAULT '0', + `class` tinyint unsigned NOT NULL DEFAULT '0', + `gender` tinyint 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`), @@ -1922,11 +1922,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `corpse_customizations`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `corpse_customizations` ( - `ownerGuid` bigint(20) unsigned NOT NULL, - `chrCustomizationOptionID` int(10) unsigned NOT NULL, - `chrCustomizationChoiceID` int(10) unsigned NOT NULL DEFAULT '0', + `ownerGuid` bigint unsigned NOT NULL, + `chrCustomizationOptionID` int unsigned NOT NULL, + `chrCustomizationChoiceID` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ownerGuid`,`chrCustomizationOptionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1946,10 +1946,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `corpse_phases`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `corpse_phases` ( - `OwnerGuid` bigint(20) unsigned NOT NULL DEFAULT '0', - `PhaseId` int(10) unsigned NOT NULL, + `OwnerGuid` bigint unsigned NOT NULL DEFAULT '0', + `PhaseId` int unsigned NOT NULL, PRIMARY KEY (`OwnerGuid`,`PhaseId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1969,10 +1969,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `game_event_condition_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1993,11 +1993,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `game_event_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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` bigint(20) NOT NULL DEFAULT '0', + `eventEntry` tinyint unsigned NOT NULL, + `state` tinyint unsigned NOT NULL DEFAULT '1', + `next_start` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`eventEntry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2017,20 +2017,20 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `gm_bug`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_bug` ( - `id` int(10) unsigned NOT NULL, - `playerGuid` bigint(20) unsigned NOT NULL, - `note` text NOT NULL, - `createTime` bigint(20) NOT NULL DEFAULT '0', - `mapId` smallint(5) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL, + `playerGuid` bigint unsigned NOT NULL, + `note` text COLLATE utf8mb4_unicode_ci NOT NULL, + `createTime` bigint 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', `facing` float NOT NULL DEFAULT '0', - `closedBy` bigint(20) NOT NULL DEFAULT '0', - `assignedTo` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', - `comment` text NOT NULL, + `closedBy` bigint NOT NULL DEFAULT '0', + `assignedTo` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', + `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2050,23 +2050,23 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `gm_complaint`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_complaint` ( - `id` int(10) unsigned NOT NULL, - `playerGuid` bigint(20) unsigned NOT NULL, - `note` text NOT NULL, - `createTime` bigint(20) NOT NULL DEFAULT '0', - `mapId` smallint(5) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL, + `playerGuid` bigint unsigned NOT NULL, + `note` text COLLATE utf8mb4_unicode_ci NOT NULL, + `createTime` bigint 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', `facing` float NOT NULL DEFAULT '0', - `targetCharacterGuid` bigint(20) unsigned NOT NULL, - `complaintType` smallint(5) unsigned NOT NULL, - `reportLineIndex` int(10) NOT NULL, - `closedBy` bigint(20) NOT NULL DEFAULT '0', - `assignedTo` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', - `comment` text NOT NULL, + `targetCharacterGuid` bigint unsigned NOT NULL, + `complaintType` smallint unsigned NOT NULL, + `reportLineIndex` int NOT NULL, + `closedBy` bigint NOT NULL DEFAULT '0', + `assignedTo` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', + `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2086,12 +2086,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `gm_complaint_chatlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_complaint_chatlog` ( - `complaintId` int(10) unsigned NOT NULL, - `lineId` int(10) unsigned NOT NULL, - `timestamp` bigint(20) NOT NULL, - `text` text NOT NULL, + `complaintId` int unsigned NOT NULL, + `lineId` int unsigned NOT NULL, + `timestamp` bigint NOT NULL, + `text` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`complaintId`,`lineId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2111,20 +2111,20 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `gm_suggestion`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gm_suggestion` ( - `id` int(10) unsigned NOT NULL, - `playerGuid` bigint(20) unsigned NOT NULL, - `note` text NOT NULL, - `createTime` bigint(20) NOT NULL DEFAULT '0', - `mapId` smallint(5) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL, + `playerGuid` bigint unsigned NOT NULL, + `note` text COLLATE utf8mb4_unicode_ci NOT NULL, + `createTime` bigint 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', `facing` float NOT NULL DEFAULT '0', - `closedBy` bigint(20) NOT NULL DEFAULT '0', - `assignedTo` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', - `comment` text NOT NULL, + `closedBy` bigint NOT NULL DEFAULT '0', + `assignedTo` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', + `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2144,11 +2144,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `group_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2169,13 +2169,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `group_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `group_member` ( - `guid` int(10) unsigned NOT NULL, - `memberGuid` bigint(20) 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` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Groups'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2195,13 +2195,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `groups` ( - `guid` int(10) unsigned NOT NULL, - `leaderGuid` bigint(20) unsigned NOT NULL, - `lootMethod` tinyint(3) unsigned NOT NULL, - `looterGuid` bigint(20) unsigned NOT NULL, - `lootThreshold` tinyint(3) unsigned NOT NULL, + `guid` int unsigned NOT NULL, + `leaderGuid` bigint unsigned NOT NULL, + `lootMethod` tinyint unsigned NOT NULL, + `looterGuid` bigint unsigned NOT NULL, + `lootThreshold` tinyint unsigned NOT NULL, `icon1` binary(16) NOT NULL, `icon2` binary(16) NOT NULL, `icon3` binary(16) NOT NULL, @@ -2210,11 +2210,11 @@ CREATE TABLE `groups` ( `icon6` binary(16) NOT NULL, `icon7` binary(16) NOT NULL, `icon8` binary(16) NOT NULL, - `groupType` tinyint(3) unsigned NOT NULL, - `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '1', - `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '14', - `legacyRaidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '3', - `masterLooterGuid` bigint(20) unsigned NOT NULL, + `groupType` tinyint unsigned NOT NULL, + `difficulty` tinyint unsigned NOT NULL DEFAULT '1', + `raidDifficulty` tinyint unsigned NOT NULL DEFAULT '14', + `legacyRaidDifficulty` tinyint unsigned NOT NULL DEFAULT '3', + `masterLooterGuid` bigint unsigned NOT NULL, PRIMARY KEY (`guid`), KEY `leaderGuid` (`leaderGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Groups'; @@ -2235,20 +2235,20 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild` ( - `guildid` bigint(20) unsigned NOT NULL DEFAULT '0', - `name` varchar(24) NOT NULL DEFAULT '', - `leaderguid` bigint(20) 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', - `info` varchar(500) NOT NULL DEFAULT '', - `motd` varchar(256) NOT NULL DEFAULT '', - `createdate` int(10) unsigned NOT NULL DEFAULT '0', - `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0', + `guildid` bigint unsigned NOT NULL DEFAULT '0', + `name` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `leaderguid` bigint 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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `motd` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `createdate` int unsigned NOT NULL DEFAULT '0', + `BankMoney` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2268,12 +2268,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_achievement`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_achievement` ( - `guildId` bigint(20) unsigned NOT NULL, - `achievement` int(10) unsigned NOT NULL, - `date` bigint(20) NOT NULL DEFAULT '0', - `guids` text NOT NULL, + `guildId` bigint unsigned NOT NULL, + `achievement` int unsigned NOT NULL, + `date` bigint NOT NULL DEFAULT '0', + `guids` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`guildId`,`achievement`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2293,13 +2293,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_achievement_progress`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_achievement_progress` ( - `guildId` bigint(20) unsigned NOT NULL, - `criteria` int(10) unsigned NOT NULL, - `counter` bigint(20) unsigned NOT NULL, - `date` bigint(20) NOT NULL DEFAULT '0', - `completedGuid` bigint(20) unsigned NOT NULL DEFAULT '0', + `guildId` bigint unsigned NOT NULL, + `criteria` int unsigned NOT NULL, + `counter` bigint unsigned NOT NULL, + `date` bigint NOT NULL DEFAULT '0', + `completedGuid` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildId`,`criteria`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2319,17 +2319,17 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_bank_eventlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_eventlog` ( - `guildid` bigint(20) 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` bigint(20) unsigned NOT NULL DEFAULT '0', - `ItemOrMoney` bigint(20) 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` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', + `guildid` bigint 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` bigint unsigned NOT NULL DEFAULT '0', + `ItemOrMoney` bigint unsigned NOT NULL DEFAULT '0', + `ItemStackCount` smallint unsigned NOT NULL DEFAULT '0', + `DestTabId` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Destination Tab Id', + `TimeStamp` bigint NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`,`TabId`), KEY `guildid_key` (`guildid`), KEY `Idx_PlayerGuid` (`PlayerGuid`), @@ -2352,12 +2352,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_bank_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_item` ( - `guildid` bigint(20) unsigned NOT NULL DEFAULT '0', - `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0', - `SlotId` tinyint(3) unsigned NOT NULL DEFAULT '0', - `item_guid` bigint(20) unsigned NOT NULL DEFAULT '0', + `guildid` bigint unsigned NOT NULL DEFAULT '0', + `TabId` tinyint unsigned NOT NULL DEFAULT '0', + `SlotId` tinyint unsigned NOT NULL DEFAULT '0', + `item_guid` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`TabId`,`SlotId`), KEY `guildid_key` (`guildid`), KEY `Idx_item_guid` (`item_guid`) @@ -2379,13 +2379,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_bank_right`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_right` ( - `guildid` bigint(20) unsigned NOT NULL DEFAULT '0', - `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0', - `rid` tinyint(3) unsigned NOT NULL DEFAULT '0', - `gbright` tinyint(3) NOT NULL DEFAULT '0', - `SlotPerDay` int(10) NOT NULL DEFAULT '0', + `guildid` bigint unsigned NOT NULL DEFAULT '0', + `TabId` tinyint unsigned NOT NULL DEFAULT '0', + `rid` tinyint unsigned NOT NULL DEFAULT '0', + `gbright` tinyint NOT NULL DEFAULT '0', + `SlotPerDay` int NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`TabId`,`rid`), KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2406,13 +2406,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_bank_tab`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_bank_tab` ( - `guildid` bigint(20) unsigned NOT NULL DEFAULT '0', - `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0', - `TabName` varchar(16) NOT NULL DEFAULT '', - `TabIcon` varchar(100) NOT NULL DEFAULT '', - `TabText` varchar(500) DEFAULT NULL, + `guildid` bigint unsigned NOT NULL DEFAULT '0', + `TabId` tinyint unsigned NOT NULL DEFAULT '0', + `TabName` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `TabIcon` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `TabText` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`guildid`,`TabId`), KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2433,15 +2433,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_eventlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_eventlog` ( - `guildid` bigint(20) 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` bigint(20) unsigned NOT NULL COMMENT 'Player 1', - `PlayerGuid2` bigint(20) unsigned NOT NULL COMMENT 'Player 2', - `NewRank` tinyint(3) unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)', - `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time', + `guildid` bigint 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` bigint unsigned NOT NULL COMMENT 'Player 1', + `PlayerGuid2` bigint unsigned NOT NULL COMMENT 'Player 2', + `NewRank` tinyint unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)', + `TimeStamp` bigint NOT NULL COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`), KEY `Idx_PlayerGuid1` (`PlayerGuid1`), KEY `Idx_PlayerGuid2` (`PlayerGuid2`), @@ -2464,13 +2464,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_member` ( - `guildid` bigint(20) unsigned NOT NULL COMMENT 'Guild Identificator', - `guid` bigint(20) unsigned NOT NULL, - `rank` tinyint(3) unsigned NOT NULL, - `pnote` varchar(31) NOT NULL DEFAULT '', - `offnote` varchar(31) NOT NULL DEFAULT '', + `guildid` bigint unsigned NOT NULL COMMENT 'Guild Identificator', + `guid` bigint unsigned NOT NULL, + `rank` tinyint unsigned NOT NULL, + `pnote` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `offnote` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', UNIQUE KEY `guid_key` (`guid`), KEY `guildid_key` (`guildid`), KEY `guildid_rank_key` (`guildid`,`rank`) @@ -2492,18 +2492,18 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_member_withdraw`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_member_withdraw` ( - `guid` bigint(20) 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', - `tab6` int(10) unsigned NOT NULL DEFAULT '0', - `tab7` int(10) unsigned NOT NULL DEFAULT '0', - `money` bigint(20) unsigned NOT NULL DEFAULT '0', + `guid` bigint 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', + `tab6` int unsigned NOT NULL DEFAULT '0', + `tab7` int unsigned NOT NULL DEFAULT '0', + `money` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild Member Daily Withdraws'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2523,15 +2523,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_newslog`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_newslog` ( - `guildid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator', - `LogGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column', - `EventType` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Event type', - `PlayerGuid` bigint(20) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', - `Value` int(10) unsigned NOT NULL DEFAULT '0', - `TimeStamp` bigint(20) NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', + `guildid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator', + `LogGuid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column', + `EventType` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Event type', + `PlayerGuid` bigint unsigned NOT NULL DEFAULT '0', + `Flags` int unsigned NOT NULL DEFAULT '0', + `Value` int unsigned NOT NULL DEFAULT '0', + `TimeStamp` bigint NOT NULL DEFAULT '0' COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`), KEY `guildid_key` (`guildid`), KEY `Idx_PlayerGuid` (`PlayerGuid`), @@ -2554,13 +2554,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `guild_rank`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild_rank` ( - `guildid` bigint(20) unsigned NOT NULL DEFAULT '0', - `rid` tinyint(3) unsigned NOT NULL, - `rname` varchar(20) NOT NULL DEFAULT '', - `rights` int(10) unsigned NOT NULL DEFAULT '0', - `BankMoneyPerDay` int(10) unsigned NOT NULL DEFAULT '0', + `guildid` bigint unsigned NOT NULL DEFAULT '0', + `rid` tinyint unsigned NOT NULL, + `rname` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `rights` int unsigned NOT NULL DEFAULT '0', + `BankMoneyPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`rid`), KEY `Idx_rid` (`rid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; @@ -2581,15 +2581,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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) NOT NULL DEFAULT '0', - `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', - `completedEncounters` int(10) unsigned NOT NULL DEFAULT '0', - `data` tinytext NOT NULL, - `entranceId` int(10) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `map` smallint unsigned NOT NULL DEFAULT '0', + `resettime` bigint NOT NULL DEFAULT '0', + `difficulty` tinyint unsigned NOT NULL DEFAULT '0', + `completedEncounters` int unsigned NOT NULL DEFAULT '0', + `data` tinytext COLLATE utf8mb4_unicode_ci NOT NULL, + `entranceId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `map` (`map`), KEY `resettime` (`resettime`), @@ -2612,11 +2612,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `instance_reset`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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) NOT NULL DEFAULT '0', + `mapid` smallint unsigned NOT NULL DEFAULT '0', + `difficulty` tinyint unsigned NOT NULL DEFAULT '0', + `resettime` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`mapid`,`difficulty`), KEY `difficulty` (`difficulty`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2637,12 +2637,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `instance_scenario_progress`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `instance_scenario_progress` ( - `id` int(10) unsigned NOT NULL, - `criteria` int(10) unsigned NOT NULL, - `counter` bigint(20) unsigned NOT NULL, - `date` bigint(20) NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL, + `criteria` int unsigned NOT NULL, + `counter` bigint unsigned NOT NULL, + `date` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`criteria`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2662,30 +2662,30 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance` ( - `guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `itemEntry` int(10) unsigned NOT NULL DEFAULT '0', - `owner_guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `creatorGuid` bigint(20) unsigned NOT NULL DEFAULT '0', - `giftCreatorGuid` bigint(20) unsigned NOT NULL DEFAULT '0', - `count` int(10) unsigned NOT NULL DEFAULT '1', - `duration` int(10) NOT NULL DEFAULT '0', - `charges` tinytext, - `flags` int(10) unsigned NOT NULL DEFAULT '0', - `enchantments` text NOT NULL, - `randomBonusListId` int(10) unsigned NOT NULL DEFAULT '0', - `durability` smallint(5) unsigned NOT NULL DEFAULT '0', - `playedTime` int(10) unsigned NOT NULL DEFAULT '0', - `text` text, - `transmogrification` int(10) unsigned NOT NULL DEFAULT '0', - `enchantIllusion` int(10) unsigned NOT NULL DEFAULT '0', - `battlePetSpeciesId` int(10) unsigned NOT NULL DEFAULT '0', - `battlePetBreedData` int(10) unsigned NOT NULL DEFAULT '0', - `battlePetLevel` smallint(5) unsigned NOT NULL DEFAULT '0', - `battlePetDisplayId` int(10) unsigned NOT NULL DEFAULT '0', - `context` tinyint(3) unsigned NOT NULL DEFAULT '0', - `bonusListIDs` text, + `guid` bigint unsigned NOT NULL DEFAULT '0', + `itemEntry` int unsigned NOT NULL DEFAULT '0', + `owner_guid` bigint unsigned NOT NULL DEFAULT '0', + `creatorGuid` bigint unsigned NOT NULL DEFAULT '0', + `giftCreatorGuid` bigint unsigned NOT NULL DEFAULT '0', + `count` int unsigned NOT NULL DEFAULT '1', + `duration` int NOT NULL DEFAULT '0', + `charges` tinytext COLLATE utf8mb4_unicode_ci, + `flags` int unsigned NOT NULL DEFAULT '0', + `enchantments` text COLLATE utf8mb4_unicode_ci NOT NULL, + `randomBonusListId` int unsigned NOT NULL DEFAULT '0', + `durability` smallint unsigned NOT NULL DEFAULT '0', + `playedTime` int unsigned NOT NULL DEFAULT '0', + `text` text COLLATE utf8mb4_unicode_ci, + `transmogrification` int unsigned NOT NULL DEFAULT '0', + `enchantIllusion` int unsigned NOT NULL DEFAULT '0', + `battlePetSpeciesId` int unsigned NOT NULL DEFAULT '0', + `battlePetBreedData` int unsigned NOT NULL DEFAULT '0', + `battlePetLevel` smallint unsigned NOT NULL DEFAULT '0', + `battlePetDisplayId` int unsigned NOT NULL DEFAULT '0', + `context` tinyint unsigned NOT NULL DEFAULT '0', + `bonusListIDs` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System'; @@ -2706,12 +2706,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance_artifact`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_artifact` ( - `itemGuid` bigint(20) unsigned NOT NULL, - `xp` bigint(20) unsigned NOT NULL DEFAULT '0', - `artifactAppearanceId` int(10) unsigned NOT NULL DEFAULT '0', - `artifactTierId` int(10) unsigned NOT NULL DEFAULT '0', + `itemGuid` bigint unsigned NOT NULL, + `xp` bigint unsigned NOT NULL DEFAULT '0', + `artifactAppearanceId` int unsigned NOT NULL DEFAULT '0', + `artifactTierId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2731,11 +2731,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance_artifact_powers`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_artifact_powers` ( - `itemGuid` bigint(20) unsigned NOT NULL, - `artifactPowerId` int(10) unsigned NOT NULL, - `purchasedRank` tinyint(3) unsigned DEFAULT '0', + `itemGuid` bigint unsigned NOT NULL, + `artifactPowerId` int unsigned NOT NULL, + `purchasedRank` tinyint unsigned DEFAULT '0', PRIMARY KEY (`itemGuid`,`artifactPowerId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2755,32 +2755,32 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance_azerite`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_azerite` ( - `itemGuid` bigint(20) unsigned NOT NULL, - `xp` bigint(20) unsigned NOT NULL DEFAULT '0', - `level` int(10) unsigned NOT NULL DEFAULT '1', - `knowledgeLevel` int(10) unsigned NOT NULL DEFAULT '0', - `selectedAzeriteEssences1specId` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences1azeriteEssenceId1` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences1azeriteEssenceId2` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences1azeriteEssenceId3` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences1azeriteEssenceId4` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences2specId` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences2azeriteEssenceId1` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences2azeriteEssenceId2` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences2azeriteEssenceId3` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences2azeriteEssenceId4` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences3specId` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences3azeriteEssenceId1` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences3azeriteEssenceId2` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences3azeriteEssenceId3` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences3azeriteEssenceId4` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences4specId` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences4azeriteEssenceId1` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences4azeriteEssenceId2` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences4azeriteEssenceId3` int(10) unsigned DEFAULT '0', - `selectedAzeriteEssences4azeriteEssenceId4` int(10) unsigned DEFAULT '0', + `itemGuid` bigint unsigned NOT NULL, + `xp` bigint unsigned NOT NULL DEFAULT '0', + `level` int unsigned NOT NULL DEFAULT '1', + `knowledgeLevel` int unsigned NOT NULL DEFAULT '0', + `selectedAzeriteEssences1specId` int unsigned DEFAULT '0', + `selectedAzeriteEssences1azeriteEssenceId1` int unsigned DEFAULT '0', + `selectedAzeriteEssences1azeriteEssenceId2` int unsigned DEFAULT '0', + `selectedAzeriteEssences1azeriteEssenceId3` int unsigned DEFAULT '0', + `selectedAzeriteEssences1azeriteEssenceId4` int unsigned DEFAULT '0', + `selectedAzeriteEssences2specId` int unsigned DEFAULT '0', + `selectedAzeriteEssences2azeriteEssenceId1` int unsigned DEFAULT '0', + `selectedAzeriteEssences2azeriteEssenceId2` int unsigned DEFAULT '0', + `selectedAzeriteEssences2azeriteEssenceId3` int unsigned DEFAULT '0', + `selectedAzeriteEssences2azeriteEssenceId4` int unsigned DEFAULT '0', + `selectedAzeriteEssences3specId` int unsigned DEFAULT '0', + `selectedAzeriteEssences3azeriteEssenceId1` int unsigned DEFAULT '0', + `selectedAzeriteEssences3azeriteEssenceId2` int unsigned DEFAULT '0', + `selectedAzeriteEssences3azeriteEssenceId3` int unsigned DEFAULT '0', + `selectedAzeriteEssences3azeriteEssenceId4` int unsigned DEFAULT '0', + `selectedAzeriteEssences4specId` int unsigned DEFAULT '0', + `selectedAzeriteEssences4azeriteEssenceId1` int unsigned DEFAULT '0', + `selectedAzeriteEssences4azeriteEssenceId2` int unsigned DEFAULT '0', + `selectedAzeriteEssences4azeriteEssenceId3` int unsigned DEFAULT '0', + `selectedAzeriteEssences4azeriteEssenceId4` int unsigned DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2800,14 +2800,14 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance_azerite_empowered`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_azerite_empowered` ( - `itemGuid` bigint(20) unsigned NOT NULL, - `azeritePowerId1` int(11) NOT NULL, - `azeritePowerId2` int(11) NOT NULL, - `azeritePowerId3` int(11) NOT NULL, - `azeritePowerId4` int(11) NOT NULL, - `azeritePowerId5` int(11) NOT NULL, + `itemGuid` bigint unsigned NOT NULL, + `azeritePowerId1` int NOT NULL, + `azeritePowerId2` int NOT NULL, + `azeritePowerId3` int NOT NULL, + `azeritePowerId4` int NOT NULL, + `azeritePowerId5` int NOT NULL, PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2827,10 +2827,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance_azerite_milestone_power`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_azerite_milestone_power` ( - `itemGuid` bigint(20) unsigned NOT NULL, - `azeriteItemMilestonePowerId` int(10) unsigned NOT NULL DEFAULT '0', + `itemGuid` bigint unsigned NOT NULL, + `azeriteItemMilestonePowerId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`,`azeriteItemMilestonePowerId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2850,11 +2850,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance_azerite_unlocked_essence`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_azerite_unlocked_essence` ( - `itemGuid` bigint(20) unsigned NOT NULL, - `azeriteEssenceId` int(10) unsigned NOT NULL DEFAULT '0', - `rank` int(10) unsigned NOT NULL DEFAULT '0', + `itemGuid` bigint unsigned NOT NULL, + `azeriteEssenceId` int unsigned NOT NULL DEFAULT '0', + `rank` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`,`azeriteEssenceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2874,21 +2874,21 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance_gems`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_gems` ( - `itemGuid` bigint(20) unsigned NOT NULL, - `gemItemId1` int(10) unsigned NOT NULL DEFAULT '0', - `gemBonuses1` text, - `gemContext1` tinyint(3) unsigned NOT NULL DEFAULT '0', - `gemScalingLevel1` int(10) unsigned NOT NULL DEFAULT '0', - `gemItemId2` int(10) unsigned NOT NULL DEFAULT '0', - `gemBonuses2` text, - `gemContext2` tinyint(3) unsigned NOT NULL DEFAULT '0', - `gemScalingLevel2` int(10) unsigned NOT NULL DEFAULT '0', - `gemItemId3` int(10) unsigned NOT NULL DEFAULT '0', - `gemBonuses3` text, - `gemContext3` tinyint(3) unsigned NOT NULL DEFAULT '0', - `gemScalingLevel3` int(10) unsigned NOT NULL DEFAULT '0', + `itemGuid` bigint unsigned NOT NULL, + `gemItemId1` int unsigned NOT NULL DEFAULT '0', + `gemBonuses1` text COLLATE utf8mb4_unicode_ci, + `gemContext1` tinyint unsigned NOT NULL DEFAULT '0', + `gemScalingLevel1` int unsigned NOT NULL DEFAULT '0', + `gemItemId2` int unsigned NOT NULL DEFAULT '0', + `gemBonuses2` text COLLATE utf8mb4_unicode_ci, + `gemContext2` tinyint unsigned NOT NULL DEFAULT '0', + `gemScalingLevel2` int unsigned NOT NULL DEFAULT '0', + `gemItemId3` int unsigned NOT NULL DEFAULT '0', + `gemBonuses3` text COLLATE utf8mb4_unicode_ci, + `gemContext3` tinyint unsigned NOT NULL DEFAULT '0', + `gemScalingLevel3` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2908,11 +2908,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance_modifiers`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_modifiers` ( - `itemGuid` bigint(20) unsigned NOT NULL, - `fixedScalingLevel` int(10) unsigned DEFAULT '0', - `artifactKnowledgeLevel` int(10) unsigned DEFAULT '0', + `itemGuid` bigint unsigned NOT NULL, + `fixedScalingLevel` int unsigned DEFAULT '0', + `artifactKnowledgeLevel` int unsigned DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2932,27 +2932,27 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_instance_transmog`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_instance_transmog` ( - `itemGuid` bigint(20) unsigned NOT NULL, - `itemModifiedAppearanceAllSpecs` int(11) NOT NULL DEFAULT '0', - `itemModifiedAppearanceSpec1` int(11) NOT NULL DEFAULT '0', - `itemModifiedAppearanceSpec2` int(11) NOT NULL DEFAULT '0', - `itemModifiedAppearanceSpec3` int(11) NOT NULL DEFAULT '0', - `itemModifiedAppearanceSpec4` int(11) NOT NULL DEFAULT '0', - `itemModifiedAppearanceSpec5` int(11) NOT NULL DEFAULT '0', - `spellItemEnchantmentAllSpecs` int(11) NOT NULL DEFAULT '0', - `spellItemEnchantmentSpec1` int(11) NOT NULL DEFAULT '0', - `spellItemEnchantmentSpec2` int(11) NOT NULL DEFAULT '0', - `spellItemEnchantmentSpec3` int(11) NOT NULL DEFAULT '0', - `spellItemEnchantmentSpec4` int(11) NOT NULL DEFAULT '0', - `spellItemEnchantmentSpec5` int(11) NOT NULL DEFAULT '0', - `secondaryItemModifiedAppearanceAllSpecs` int(11) NOT NULL DEFAULT '0', - `secondaryItemModifiedAppearanceSpec1` int(11) NOT NULL DEFAULT '0', - `secondaryItemModifiedAppearanceSpec2` int(11) NOT NULL DEFAULT '0', - `secondaryItemModifiedAppearanceSpec3` int(11) NOT NULL DEFAULT '0', - `secondaryItemModifiedAppearanceSpec4` int(11) NOT NULL DEFAULT '0', - `secondaryItemModifiedAppearanceSpec5` int(11) NOT NULL DEFAULT '0', + `itemGuid` bigint unsigned NOT NULL, + `itemModifiedAppearanceAllSpecs` int NOT NULL DEFAULT '0', + `itemModifiedAppearanceSpec1` int NOT NULL DEFAULT '0', + `itemModifiedAppearanceSpec2` int NOT NULL DEFAULT '0', + `itemModifiedAppearanceSpec3` int NOT NULL DEFAULT '0', + `itemModifiedAppearanceSpec4` int NOT NULL DEFAULT '0', + `itemModifiedAppearanceSpec5` int NOT NULL DEFAULT '0', + `spellItemEnchantmentAllSpecs` int NOT NULL DEFAULT '0', + `spellItemEnchantmentSpec1` int NOT NULL DEFAULT '0', + `spellItemEnchantmentSpec2` int NOT NULL DEFAULT '0', + `spellItemEnchantmentSpec3` int NOT NULL DEFAULT '0', + `spellItemEnchantmentSpec4` int NOT NULL DEFAULT '0', + `spellItemEnchantmentSpec5` int NOT NULL DEFAULT '0', + `secondaryItemModifiedAppearanceAllSpecs` int NOT NULL DEFAULT '0', + `secondaryItemModifiedAppearanceSpec1` int NOT NULL DEFAULT '0', + `secondaryItemModifiedAppearanceSpec2` int NOT NULL DEFAULT '0', + `secondaryItemModifiedAppearanceSpec3` int NOT NULL DEFAULT '0', + `secondaryItemModifiedAppearanceSpec4` int NOT NULL DEFAULT '0', + `secondaryItemModifiedAppearanceSpec5` int NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2972,20 +2972,20 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_loot_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_loot_items` ( - `container_id` bigint(20) 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', + `container_id` bigint 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', `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_bonus` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'random bonus list added when originally rolled', - `context` tinyint(3) unsigned NOT NULL DEFAULT '0', - `bonus_list_ids` text COMMENT 'Space separated list of bonus list ids', + `rnd_bonus` int unsigned NOT NULL DEFAULT '0' COMMENT 'random bonus list added when originally rolled', + `context` tinyint unsigned NOT NULL DEFAULT '0', + `bonus_list_ids` text COLLATE utf8mb4_unicode_ci COMMENT 'Space separated list of bonus list ids', PRIMARY KEY (`container_id`,`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3005,10 +3005,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_loot_money`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_loot_money` ( - `container_id` bigint(20) 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` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3028,12 +3028,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_refund_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_refund_instance` ( - `item_guid` bigint(20) unsigned NOT NULL COMMENT 'Item GUID', - `player_guid` bigint(20) unsigned NOT NULL COMMENT 'Player GUID', - `paidMoney` bigint(20) unsigned NOT NULL DEFAULT '0', - `paidExtendedCost` smallint(5) unsigned NOT NULL DEFAULT '0', + `item_guid` bigint unsigned NOT NULL COMMENT 'Item GUID', + `player_guid` bigint unsigned NOT NULL COMMENT 'Player GUID', + `paidMoney` bigint unsigned NOT NULL DEFAULT '0', + `paidExtendedCost` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`item_guid`,`player_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Refund System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3053,10 +3053,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `item_soulbound_trade_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_soulbound_trade_data` ( - `itemGuid` bigint(20) unsigned NOT NULL COMMENT 'Item GUID', - `allowedPlayers` text NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', + `itemGuid` bigint unsigned NOT NULL COMMENT 'Item GUID', + `allowedPlayers` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Refund System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3076,11 +3076,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `lfg_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='LFG Data'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3100,22 +3100,22 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `mail`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', - `receiver` bigint(20) 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` bigint(20) NOT NULL DEFAULT '0', - `deliver_time` bigint(20) NOT NULL DEFAULT '0', - `money` bigint(20) unsigned NOT NULL DEFAULT '0', - `cod` bigint(20) unsigned NOT NULL DEFAULT '0', - `checked` tinyint(3) unsigned NOT NULL DEFAULT '0', + `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` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `receiver` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `subject` longtext COLLATE utf8mb4_unicode_ci, + `body` longtext COLLATE utf8mb4_unicode_ci, + `has_items` tinyint unsigned NOT NULL DEFAULT '0', + `expire_time` bigint NOT NULL DEFAULT '0', + `deliver_time` bigint NOT NULL DEFAULT '0', + `money` bigint unsigned NOT NULL DEFAULT '0', + `cod` bigint unsigned NOT NULL DEFAULT '0', + `checked` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_receiver` (`receiver`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Mail System'; @@ -3136,11 +3136,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `mail_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `mail_items` ( - `mail_id` int(10) unsigned NOT NULL DEFAULT '0', - `item_guid` bigint(20) unsigned NOT NULL DEFAULT '0', - `receiver` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', + `mail_id` int unsigned NOT NULL DEFAULT '0', + `item_guid` bigint unsigned NOT NULL DEFAULT '0', + `receiver` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', PRIMARY KEY (`item_guid`), KEY `idx_receiver` (`receiver`), KEY `idx_mail_id` (`mail_id`) @@ -3162,18 +3162,18 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pet_aura`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_aura` ( - `guid` int(10) unsigned NOT NULL COMMENT 'Global Unique Identifier', + `guid` int unsigned NOT NULL COMMENT 'Global Unique Identifier', `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier', - `spell` int(10) unsigned NOT NULL, - `effectMask` int(10) unsigned NOT NULL, - `recalculateMask` int(10) unsigned NOT NULL DEFAULT '0', - `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', - `stackCount` tinyint(3) unsigned NOT NULL DEFAULT '1', - `maxDuration` int(11) NOT NULL DEFAULT '0', - `remainTime` int(11) NOT NULL DEFAULT '0', - `remainCharges` tinyint(3) unsigned NOT NULL DEFAULT '0', + `spell` int unsigned NOT NULL, + `effectMask` int unsigned NOT NULL, + `recalculateMask` int unsigned NOT NULL DEFAULT '0', + `difficulty` tinyint unsigned NOT NULL DEFAULT '0', + `stackCount` tinyint unsigned NOT NULL DEFAULT '1', + `maxDuration` int NOT NULL DEFAULT '0', + `remainTime` int NOT NULL DEFAULT '0', + `remainCharges` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`,`effectMask`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3193,15 +3193,15 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pet_aura_effect`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_aura_effect` ( - `guid` int(10) unsigned NOT NULL COMMENT 'Global Unique Identifier', + `guid` int unsigned NOT NULL COMMENT 'Global Unique Identifier', `casterGuid` binary(16) NOT NULL COMMENT 'Full Global Unique Identifier', - `spell` int(10) unsigned NOT NULL, - `effectMask` int(10) unsigned NOT NULL, - `effectIndex` tinyint(3) unsigned NOT NULL, - `amount` int(11) NOT NULL DEFAULT '0', - `baseAmount` int(11) NOT NULL DEFAULT '0', + `spell` int unsigned NOT NULL, + `effectMask` int unsigned NOT NULL, + `effectIndex` tinyint unsigned NOT NULL, + `amount` int NOT NULL DEFAULT '0', + `baseAmount` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`,`effectIndex`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3221,11 +3221,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pet_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_spell` ( - `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `spell` int(10) 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` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `active` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3245,12 +3245,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pet_spell_charges`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_spell_charges` ( - `guid` int(10) unsigned NOT NULL, - `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier', - `rechargeStart` bigint(20) NOT NULL DEFAULT '0', - `rechargeEnd` bigint(20) NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL, + `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCategory.dbc Identifier', + `rechargeStart` bigint NOT NULL DEFAULT '0', + `rechargeEnd` bigint NOT NULL DEFAULT '0', KEY `idx_guid` (`guid`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3270,13 +3270,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pet_spell_cooldown`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', - `time` bigint(20) NOT NULL DEFAULT '0', - `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', - `categoryEnd` bigint(20) NOT NULL DEFAULT '0', + `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', + `spell` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `time` bigint NOT NULL DEFAULT '0', + `categoryId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id', + `categoryEnd` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3296,11 +3296,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `petition`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `petition` ( - `ownerguid` bigint(20) unsigned NOT NULL, - `petitionguid` bigint(20) unsigned DEFAULT '0', - `name` varchar(24) NOT NULL, + `ownerguid` bigint unsigned NOT NULL, + `petitionguid` bigint unsigned DEFAULT '0', + `name` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`ownerguid`), UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; @@ -3321,12 +3321,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `petition_sign`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `petition_sign` ( - `ownerguid` bigint(20) unsigned NOT NULL, - `petitionguid` bigint(20) unsigned NOT NULL DEFAULT '0', - `playerguid` bigint(20) unsigned NOT NULL DEFAULT '0', - `player_account` int(10) unsigned NOT NULL DEFAULT '0', + `ownerguid` bigint unsigned NOT NULL, + `petitionguid` bigint unsigned NOT NULL DEFAULT '0', + `playerguid` bigint unsigned NOT NULL DEFAULT '0', + `player_account` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`petitionguid`,`playerguid`), KEY `Idx_playerguid` (`playerguid`), KEY `Idx_ownerguid` (`ownerguid`) @@ -3348,10 +3348,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pool_quest_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3371,12 +3371,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pvpstats_battlegrounds`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3397,22 +3397,22 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `pvpstats_players`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pvpstats_players` ( - `battleground_id` bigint(20) unsigned NOT NULL, - `character_guid` bigint(20) unsigned NOT NULL, + `battleground_id` bigint unsigned NOT NULL, + `character_guid` bigint unsigned NOT NULL, `winner` bit(1) NOT NULL, - `score_killing_blows` int(10) unsigned NOT NULL, - `score_deaths` int(10) unsigned NOT NULL, - `score_honorable_kills` int(10) unsigned NOT NULL, - `score_bonus_honor` int(10) unsigned NOT NULL, - `score_damage_done` int(10) unsigned NOT NULL, - `score_healing_done` int(10) unsigned NOT NULL, - `attr_1` int(10) unsigned NOT NULL DEFAULT '0', - `attr_2` int(10) unsigned NOT NULL DEFAULT '0', - `attr_3` int(10) unsigned NOT NULL DEFAULT '0', - `attr_4` int(10) unsigned NOT NULL DEFAULT '0', - `attr_5` int(10) unsigned NOT NULL DEFAULT '0', + `score_killing_blows` int unsigned NOT NULL, + `score_deaths` int unsigned NOT NULL, + `score_honorable_kills` int unsigned NOT NULL, + `score_bonus_honor` int unsigned NOT NULL, + `score_damage_done` int unsigned NOT NULL, + `score_healing_done` int unsigned NOT NULL, + `attr_1` int unsigned NOT NULL DEFAULT '0', + `attr_2` int unsigned NOT NULL DEFAULT '0', + `attr_3` int unsigned NOT NULL DEFAULT '0', + `attr_4` int unsigned NOT NULL DEFAULT '0', + `attr_5` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`battleground_id`,`character_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3432,16 +3432,16 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `quest_tracker`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_tracker` ( - `id` int(10) unsigned NOT NULL DEFAULT '0', - `character_guid` bigint(20) unsigned NOT NULL DEFAULT '0', + `id` int unsigned NOT NULL DEFAULT '0', + `character_guid` bigint unsigned NOT NULL DEFAULT '0', `quest_accept_time` datetime NOT NULL, `quest_complete_time` datetime DEFAULT NULL, `quest_abandon_time` datetime DEFAULT NULL, `completed_by_gm` tinyint(1) NOT NULL DEFAULT '0', - `core_hash` varchar(120) NOT NULL DEFAULT '0', - `core_revision` varchar(120) NOT NULL DEFAULT '0', + `core_hash` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', + `core_revision` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`character_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3461,9 +3461,9 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `reserved_name`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reserved_name` ( - `name` varchar(12) NOT NULL DEFAULT '', + `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player Reserved Names'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3483,13 +3483,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `respawn`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `respawn` ( - `type` smallint(10) unsigned NOT NULL, - `spawnId` bigint(20) unsigned NOT NULL, - `respawnTime` bigint(20) NOT NULL, - `mapId` smallint(10) unsigned NOT NULL, - `instanceId` int(10) unsigned NOT NULL, + `type` smallint unsigned NOT NULL, + `spawnId` bigint unsigned NOT NULL, + `respawnTime` bigint 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=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Stored respawn times'; @@ -3510,13 +3510,13 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates` ( - `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.', - `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.', - `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', + `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', + `hash` char(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', + `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', - `speed` int(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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of all applied updates in this database.'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3650,12 +3650,13 @@ INSERT INTO `updates` VALUES ('2021_11_02_00_characters.sql','A3C0A6DA70CC70803C80685E4E2ED6255156520A','ARCHIVED','2021-11-02 18:11:13',0), ('2021_11_04_00_characters.sql','ED533235ADAD174F91A6B8E51D1046243B78B46D','ARCHIVED','2021-11-04 21:53:04',0), ('2021_11_17_00_characters.sql','03A0AB8ECD8BE5D818D41A8A610097C94A9C7DB9','ARCHIVED','2021-11-17 13:23:17',0), -('2021_12_16_00_characters_2019_07_14_00_characters.sql','DC1A3D3311FCF9106B4D91F8D2C5B893AD66C093','RELEASED','2021-12-16 01:06:53',0), -('2021_12_16_01_characters_2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','RELEASED','2021-12-16 20:16:25',0), -('2021_12_23_00_characters.sql','7F2BD7CA61CD28D74AD9CA9F06FD7E542837ED3F','RELEASED','2021-12-23 19:16:29',0), -('2021_12_31_00_characters.sql','7ECEEB66056C46F89E581ACBB5EC222CB2D8A365','RELEASED','2021-12-31 13:53:23',0), -('2021_12_31_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','RELEASED','2021-12-31 15:58:32',0), -('2021_12_31_02_characters.sql','C66A367F0AD7A9D6837238C21E91298413BD960C','RELEASED','2021-12-31 16:10:30',0); +('2021_12_16_00_characters_2019_07_14_00_characters.sql','DC1A3D3311FCF9106B4D91F8D2C5B893AD66C093','ARCHIVED','2021-12-16 01:06:53',0), +('2021_12_16_01_characters_2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2021-12-16 20:16:25',0), +('2021_12_23_00_characters.sql','7F2BD7CA61CD28D74AD9CA9F06FD7E542837ED3F','ARCHIVED','2021-12-23 19:16:29',0), +('2021_12_31_00_characters.sql','7ECEEB66056C46F89E581ACBB5EC222CB2D8A365','ARCHIVED','2021-12-31 13:53:23',0), +('2021_12_31_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2021-12-31 15:58:32',0), +('2021_12_31_02_characters.sql','C66A367F0AD7A9D6837238C21E91298413BD960C','ARCHIVED','2021-12-31 16:10:30',0), +('2022_01_02_00_characters.sql','5169A5BBACB42E6CEDE405D3C4843FD386CDF92E','ARCHIVED','2022-01-02 21:22:35',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3665,10 +3666,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `updates_include`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates_include` ( - `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', - `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', + `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', + `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3680,12 +3681,12 @@ CREATE TABLE `updates_include` ( LOCK TABLES `updates_include` WRITE; /*!40000 ALTER TABLE `updates_include` DISABLE KEYS */; INSERT INTO `updates_include` VALUES -('$/sql/updates/characters','RELEASED'), ('$/sql/custom/characters','RELEASED'), ('$/sql/old/6.x/characters','ARCHIVED'), ('$/sql/old/7/characters','ARCHIVED'), ('$/sql/old/8.x/characters','ARCHIVED'), -('$/sql/old/9.x/characters','ARCHIVED'); +('$/sql/old/9.x/characters','ARCHIVED'), +('$/sql/updates/characters','RELEASED'); /*!40000 ALTER TABLE `updates_include` ENABLE KEYS */; UNLOCK TABLES; @@ -3695,10 +3696,10 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `warden_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3718,11 +3719,11 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `worldstates`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8mb4 */; +/*!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', - `comment` tinytext, + `entry` int unsigned NOT NULL DEFAULT '0', + `value` int unsigned NOT NULL DEFAULT '0', + `comment` tinytext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Variable Saves'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3757,4 +3758,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2021-11-17 13:23:18 +-- Dump completed on 2022-01-02 21:22:38 |