diff options
| author | Kitzunu <24550914+Kitzunu@users.noreply.github.com> | 2021-03-24 15:50:06 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-03-24 15:50:06 +0100 |
| commit | e0d36be56ec2b7c7c88c7b86b81512106cef535e (patch) | |
| tree | f80ad701749b461e79f76f4d60467cfeeca74109 /data/sql/base/db_characters | |
| parent | 2105305f5567e14c6c00fa8f84faffe4efda596d (diff) | |
refactor(DB/SQL): Update integer & utf to MySQL's new standards (#4929)
Diffstat (limited to 'data/sql/base/db_characters')
95 files changed, 776 insertions, 775 deletions
diff --git a/data/sql/base/db_characters/account_data.sql b/data/sql/base/db_characters/account_data.sql index 67890db458..7dde251b33 100644 --- a/data/sql/base/db_characters/account_data.sql +++ b/data/sql/base/db_characters/account_data.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `account_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `account_data` ( - `accountId` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Account Identifier', - `type` tinyint(3) unsigned NOT NULL DEFAULT 0, - `time` int(10) unsigned NOT NULL DEFAULT 0, + `accountId` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Account Identifier', + `type` TINYINT unsigned NOT NULL DEFAULT 0, + `time` INT unsigned NOT NULL DEFAULT 0, `data` blob NOT NULL, PRIMARY KEY (`accountId`,`type`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `account_data` WRITE; diff --git a/data/sql/base/db_characters/account_instance_times.sql b/data/sql/base/db_characters/account_instance_times.sql index 348484b88d..2d31b5ad59 100644 --- a/data/sql/base/db_characters/account_instance_times.sql +++ b/data/sql/base/db_characters/account_instance_times.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `account_instance_times`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `account_instance_times` ( - `accountId` int(10) unsigned NOT NULL, - `instanceId` int(10) unsigned NOT NULL DEFAULT 0, - `releaseTime` bigint(20) unsigned NOT NULL DEFAULT 0, + `accountId` INT unsigned NOT NULL, + `instanceId` INT unsigned NOT NULL DEFAULT 0, + `releaseTime` BIGINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`accountId`,`instanceId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `account_instance_times` WRITE; diff --git a/data/sql/base/db_characters/account_tutorial.sql b/data/sql/base/db_characters/account_tutorial.sql index a936f13e41..d6b8511d2d 100644 --- a/data/sql/base/db_characters/account_tutorial.sql +++ b/data/sql/base/db_characters/account_tutorial.sql @@ -6,20 +6,20 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `account_tutorial`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `account_tutorial` ( - `accountId` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Account Identifier', - `tut0` int(10) unsigned NOT NULL DEFAULT 0, - `tut1` int(10) unsigned NOT NULL DEFAULT 0, - `tut2` int(10) unsigned NOT NULL DEFAULT 0, - `tut3` int(10) unsigned NOT NULL DEFAULT 0, - `tut4` int(10) unsigned NOT NULL DEFAULT 0, - `tut5` int(10) unsigned NOT NULL DEFAULT 0, - `tut6` int(10) unsigned NOT NULL DEFAULT 0, - `tut7` int(10) unsigned NOT NULL DEFAULT 0, + `accountId` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Account Identifier', + `tut0` INT unsigned NOT NULL DEFAULT 0, + `tut1` INT unsigned NOT NULL DEFAULT 0, + `tut2` INT unsigned NOT NULL DEFAULT 0, + `tut3` INT unsigned NOT NULL DEFAULT 0, + `tut4` INT unsigned NOT NULL DEFAULT 0, + `tut5` INT unsigned NOT NULL DEFAULT 0, + `tut6` INT unsigned NOT NULL DEFAULT 0, + `tut7` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`accountId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `account_tutorial` WRITE; diff --git a/data/sql/base/db_characters/addons.sql b/data/sql/base/db_characters/addons.sql index 3971590c9b..f3fa8c0e67 100644 --- a/data/sql/base/db_characters/addons.sql +++ b/data/sql/base/db_characters/addons.sql @@ -6,13 +6,13 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `addons`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `addons` ( `name` varchar(120) NOT NULL DEFAULT '', - `crc` int(10) unsigned NOT NULL DEFAULT 0, + `crc` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Addons'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Addons'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `addons` WRITE; diff --git a/data/sql/base/db_characters/arena_team.sql b/data/sql/base/db_characters/arena_team.sql index 9682f8210e..b2c9af8c82 100644 --- a/data/sql/base/db_characters/arena_team.sql +++ b/data/sql/base/db_characters/arena_team.sql @@ -6,26 +6,26 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `arena_team`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `arena_team` ( - `arenaTeamId` int(10) unsigned NOT NULL DEFAULT 0, + `arenaTeamId` INT unsigned NOT NULL DEFAULT 0, `name` varchar(24) NOT NULL, - `captainGuid` int(10) unsigned NOT NULL DEFAULT 0, - `type` tinyint(3) unsigned NOT NULL DEFAULT 0, - `rating` smallint(5) unsigned NOT NULL DEFAULT 0, - `seasonGames` smallint(5) unsigned NOT NULL DEFAULT 0, - `seasonWins` smallint(5) unsigned NOT NULL DEFAULT 0, - `weekGames` smallint(5) unsigned NOT NULL DEFAULT 0, - `weekWins` smallint(5) unsigned NOT NULL DEFAULT 0, - `rank` int(10) unsigned NOT NULL DEFAULT 0, - `backgroundColor` int(10) unsigned NOT NULL DEFAULT 0, - `emblemStyle` tinyint(3) unsigned NOT NULL DEFAULT 0, - `emblemColor` int(10) unsigned NOT NULL DEFAULT 0, - `borderStyle` tinyint(3) unsigned NOT NULL DEFAULT 0, - `borderColor` int(10) unsigned NOT NULL DEFAULT 0, + `captainGuid` INT unsigned NOT NULL DEFAULT 0, + `type` TINYINT unsigned NOT NULL DEFAULT 0, + `rating` SMALLINT unsigned NOT NULL DEFAULT 0, + `seasonGames` SMALLINT unsigned NOT NULL DEFAULT 0, + `seasonWins` SMALLINT unsigned NOT NULL DEFAULT 0, + `weekGames` SMALLINT unsigned NOT NULL DEFAULT 0, + `weekWins` SMALLINT unsigned NOT NULL DEFAULT 0, + `rank` INT unsigned NOT NULL DEFAULT 0, + `backgroundColor` INT unsigned NOT NULL DEFAULT 0, + `emblemStyle` TINYINT unsigned NOT NULL DEFAULT 0, + `emblemColor` INT unsigned NOT NULL DEFAULT 0, + `borderStyle` TINYINT unsigned NOT NULL DEFAULT 0, + `borderColor` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`arenaTeamId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `arena_team` WRITE; diff --git a/data/sql/base/db_characters/arena_team_member.sql b/data/sql/base/db_characters/arena_team_member.sql index b2f6de7635..f5622804f5 100644 --- a/data/sql/base/db_characters/arena_team_member.sql +++ b/data/sql/base/db_characters/arena_team_member.sql @@ -6,18 +6,18 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `arena_team_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `arena_team_member` ( - `arenaTeamId` int(10) unsigned NOT NULL DEFAULT 0, - `guid` int(10) unsigned NOT NULL DEFAULT 0, - `weekGames` smallint(5) unsigned NOT NULL DEFAULT 0, - `weekWins` smallint(5) unsigned NOT NULL DEFAULT 0, - `seasonGames` smallint(5) unsigned NOT NULL DEFAULT 0, - `seasonWins` smallint(5) unsigned NOT NULL DEFAULT 0, - `personalRating` smallint(5) NOT NULL DEFAULT 0, + `arenaTeamId` INT unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0, + `weekGames` SMALLINT unsigned NOT NULL DEFAULT 0, + `weekWins` SMALLINT unsigned NOT NULL DEFAULT 0, + `seasonGames` SMALLINT unsigned NOT NULL DEFAULT 0, + `seasonWins` SMALLINT unsigned NOT NULL DEFAULT 0, + `personalRating` SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (`arenaTeamId`,`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `arena_team_member` WRITE; diff --git a/data/sql/base/db_characters/auctionhouse.sql b/data/sql/base/db_characters/auctionhouse.sql index 0e639f0da8..9815f2fb23 100644 --- a/data/sql/base/db_characters/auctionhouse.sql +++ b/data/sql/base/db_characters/auctionhouse.sql @@ -6,22 +6,22 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `auctionhouse`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `auctionhouse` ( - `id` int(10) unsigned NOT NULL DEFAULT 0, - `auctioneerguid` int(10) unsigned NOT NULL DEFAULT 0, - `itemguid` int(10) unsigned NOT NULL DEFAULT 0, - `itemowner` int(10) unsigned NOT NULL DEFAULT 0, - `buyoutprice` int(10) unsigned NOT NULL DEFAULT 0, - `time` int(10) unsigned NOT NULL DEFAULT 0, - `buyguid` int(10) unsigned NOT NULL DEFAULT 0, - `lastbid` int(10) unsigned NOT NULL DEFAULT 0, - `startbid` int(10) unsigned NOT NULL DEFAULT 0, - `deposit` int(10) unsigned NOT NULL DEFAULT 0, + `id` INT unsigned NOT NULL DEFAULT 0, + `auctioneerguid` INT unsigned NOT NULL DEFAULT 0, + `itemguid` INT unsigned NOT NULL DEFAULT 0, + `itemowner` INT unsigned NOT NULL DEFAULT 0, + `buyoutprice` INT unsigned NOT NULL DEFAULT 0, + `time` INT unsigned NOT NULL DEFAULT 0, + `buyguid` INT unsigned NOT NULL DEFAULT 0, + `lastbid` INT unsigned NOT NULL DEFAULT 0, + `startbid` INT unsigned NOT NULL DEFAULT 0, + `deposit` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `item_guid` (`itemguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `auctionhouse` WRITE; diff --git a/data/sql/base/db_characters/banned_addons.sql b/data/sql/base/db_characters/banned_addons.sql index 76cd90443c..5a2c8cafd3 100644 --- a/data/sql/base/db_characters/banned_addons.sql +++ b/data/sql/base/db_characters/banned_addons.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `banned_addons`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `banned_addons` ( - `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `Id` INT unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(255) NOT NULL, `Version` varchar(255) NOT NULL DEFAULT '', `Timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`Id`), UNIQUE KEY `idx_name_ver` (`Name`,`Version`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `banned_addons` WRITE; diff --git a/data/sql/base/db_characters/battleground_deserters.sql b/data/sql/base/db_characters/battleground_deserters.sql index 5a9e58427f..ba10ad44e7 100644 --- a/data/sql/base/db_characters/battleground_deserters.sql +++ b/data/sql/base/db_characters/battleground_deserters.sql @@ -6,11 +6,11 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `battleground_deserters`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `battleground_deserters` ( - `guid` int(10) unsigned NOT NULL COMMENT 'characters.guid', - `type` tinyint(3) unsigned NOT NULL COMMENT 'type of the desertion', + `guid` INT unsigned NOT NULL COMMENT 'characters.guid', + `type` TINYINT unsigned NOT NULL COMMENT 'type of the desertion', `datetime` datetime NOT NULL COMMENT 'datetime of the desertion' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/data/sql/base/db_characters/bugreport.sql b/data/sql/base/db_characters/bugreport.sql index 0a7f2a83de..8912bbf155 100644 --- a/data/sql/base/db_characters/bugreport.sql +++ b/data/sql/base/db_characters/bugreport.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `bugreport`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `bugreport` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', + `id` INT unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', `type` longtext NOT NULL, `content` longtext NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Debug System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Debug System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `bugreport` WRITE; diff --git a/data/sql/base/db_characters/calendar_events.sql b/data/sql/base/db_characters/calendar_events.sql index 1b9df7371d..66dee0ae51 100644 --- a/data/sql/base/db_characters/calendar_events.sql +++ b/data/sql/base/db_characters/calendar_events.sql @@ -6,20 +6,20 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `calendar_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `calendar_events` ( - `id` bigint(20) unsigned NOT NULL DEFAULT 0, - `creator` int(10) unsigned NOT NULL DEFAULT 0, + `id` BIGINT unsigned NOT NULL DEFAULT 0, + `creator` INT unsigned NOT NULL DEFAULT 0, `title` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', - `type` tinyint(1) unsigned NOT NULL DEFAULT 4, - `dungeon` int(10) NOT NULL DEFAULT -1, - `eventtime` int(10) unsigned NOT NULL DEFAULT 0, - `flags` int(10) unsigned NOT NULL DEFAULT 0, - `time2` int(10) unsigned NOT NULL DEFAULT 0, + `type` TINYINT unsigned NOT NULL DEFAULT 4, + `dungeon` INT NOT NULL DEFAULT -1, + `eventtime` INT unsigned NOT NULL DEFAULT 0, + `flags` INT unsigned NOT NULL DEFAULT 0, + `time2` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `calendar_events` WRITE; diff --git a/data/sql/base/db_characters/calendar_invites.sql b/data/sql/base/db_characters/calendar_invites.sql index fff18558bc..83fc2dd039 100644 --- a/data/sql/base/db_characters/calendar_invites.sql +++ b/data/sql/base/db_characters/calendar_invites.sql @@ -6,19 +6,19 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `calendar_invites`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `calendar_invites` ( - `id` bigint(20) unsigned NOT NULL DEFAULT 0, - `event` bigint(20) unsigned NOT NULL DEFAULT 0, - `invitee` int(10) unsigned NOT NULL DEFAULT 0, - `sender` int(10) unsigned NOT NULL DEFAULT 0, - `status` tinyint(1) unsigned NOT NULL DEFAULT 0, - `statustime` int(10) unsigned NOT NULL DEFAULT 0, - `rank` tinyint(1) unsigned NOT NULL DEFAULT 0, + `id` BIGINT unsigned NOT NULL DEFAULT 0, + `event` BIGINT unsigned NOT NULL DEFAULT 0, + `invitee` INT unsigned NOT NULL DEFAULT 0, + `sender` INT unsigned NOT NULL DEFAULT 0, + `status` TINYINT unsigned NOT NULL DEFAULT 0, + `statustime` INT unsigned NOT NULL DEFAULT 0, + `rank` TINYINT unsigned NOT NULL DEFAULT 0, `text` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `calendar_invites` WRITE; diff --git a/data/sql/base/db_characters/channels.sql b/data/sql/base/db_characters/channels.sql index 8c252c8c96..035ede5e83 100644 --- a/data/sql/base/db_characters/channels.sql +++ b/data/sql/base/db_characters/channels.sql @@ -6,18 +6,18 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `channels` ( - `channelId` int(10) unsigned NOT NULL AUTO_INCREMENT, + `channelId` INT unsigned NOT NULL AUTO_INCREMENT, `name` varchar(128) NOT NULL, - `team` int(10) unsigned NOT NULL, - `announce` tinyint(3) unsigned NOT NULL DEFAULT 1, - `ownership` tinyint(3) unsigned NOT NULL DEFAULT 1, + `team` INT unsigned NOT NULL, + `announce` TINYINT unsigned NOT NULL DEFAULT 1, + `ownership` TINYINT unsigned NOT NULL DEFAULT 1, `password` varchar(32) DEFAULT NULL, - `lastUsed` int(10) unsigned NOT NULL, + `lastUsed` INT unsigned NOT NULL, PRIMARY KEY (`channelId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Channel System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Channel System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `channels` WRITE; diff --git a/data/sql/base/db_characters/channels_bans.sql b/data/sql/base/db_characters/channels_bans.sql index da5d5589e4..889ac30d51 100644 --- a/data/sql/base/db_characters/channels_bans.sql +++ b/data/sql/base/db_characters/channels_bans.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `channels_bans`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `channels_bans` ( - `channelId` int(10) unsigned NOT NULL, - `playerGUID` int(10) unsigned NOT NULL, - `banTime` int(10) unsigned NOT NULL, + `channelId` INT unsigned NOT NULL, + `playerGUID` INT unsigned NOT NULL, + `banTime` INT unsigned NOT NULL, PRIMARY KEY (`channelId`,`playerGUID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `channels_bans` WRITE; diff --git a/data/sql/base/db_characters/channels_rights.sql b/data/sql/base/db_characters/channels_rights.sql index 335cbd4a27..2e0c2e425d 100644 --- a/data/sql/base/db_characters/channels_rights.sql +++ b/data/sql/base/db_characters/channels_rights.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `channels_rights`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `channels_rights` ( `name` varchar(128) NOT NULL, - `flags` int(10) unsigned NOT NULL, - `speakdelay` int(10) unsigned NOT NULL, + `flags` INT unsigned NOT NULL, + `speakdelay` INT unsigned NOT NULL, `joinmessage` varchar(255) NOT NULL DEFAULT '', `delaymessage` varchar(255) NOT NULL DEFAULT '', `moderators` text DEFAULT NULL, PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `channels_rights` WRITE; diff --git a/data/sql/base/db_characters/character_account_data.sql b/data/sql/base/db_characters/character_account_data.sql index ddc50cf5ef..951b6fef2e 100644 --- a/data/sql/base/db_characters/character_account_data.sql +++ b/data/sql/base/db_characters/character_account_data.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_account_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_account_data` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0, - `type` tinyint(3) unsigned NOT NULL DEFAULT 0, - `time` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0, + `type` TINYINT unsigned NOT NULL DEFAULT 0, + `time` INT unsigned NOT NULL DEFAULT 0, `data` blob NOT NULL, PRIMARY KEY (`guid`,`type`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_account_data` WRITE; diff --git a/data/sql/base/db_characters/character_achievement.sql b/data/sql/base/db_characters/character_achievement.sql index 98d3aff8f7..724f56ec3d 100644 --- a/data/sql/base/db_characters/character_achievement.sql +++ b/data/sql/base/db_characters/character_achievement.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_achievement`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_achievement` ( - `guid` int(10) unsigned NOT NULL, - `achievement` smallint(5) unsigned NOT NULL, - `date` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL, + `achievement` SMALLINT unsigned NOT NULL, + `date` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`achievement`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_achievement` WRITE; diff --git a/data/sql/base/db_characters/character_achievement_progress.sql b/data/sql/base/db_characters/character_achievement_progress.sql index 4ca3058bf3..e54957a0ff 100644 --- a/data/sql/base/db_characters/character_achievement_progress.sql +++ b/data/sql/base/db_characters/character_achievement_progress.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_achievement_progress`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_achievement_progress` ( - `guid` int(10) unsigned NOT NULL, - `criteria` smallint(5) unsigned NOT NULL, - `counter` int(10) unsigned NOT NULL, - `date` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL, + `criteria` SMALLINT unsigned NOT NULL, + `counter` INT unsigned NOT NULL, + `date` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`criteria`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_achievement_progress` WRITE; diff --git a/data/sql/base/db_characters/character_action.sql b/data/sql/base/db_characters/character_action.sql index 6529fb88af..4275931cb7 100644 --- a/data/sql/base/db_characters/character_action.sql +++ b/data/sql/base/db_characters/character_action.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_action` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0, - `spec` tinyint(3) unsigned NOT NULL DEFAULT 0, - `button` tinyint(3) unsigned NOT NULL DEFAULT 0, - `action` int(10) unsigned NOT NULL DEFAULT 0, - `type` tinyint(3) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0, + `spec` TINYINT unsigned NOT NULL DEFAULT 0, + `button` TINYINT unsigned NOT NULL DEFAULT 0, + `action` INT unsigned NOT NULL DEFAULT 0, + `type` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`spec`,`button`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_action` WRITE; diff --git a/data/sql/base/db_characters/character_arena_stats.sql b/data/sql/base/db_characters/character_arena_stats.sql index 30444e18af..4ef961ddf4 100644 --- a/data/sql/base/db_characters/character_arena_stats.sql +++ b/data/sql/base/db_characters/character_arena_stats.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_arena_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_arena_stats` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0, - `slot` tinyint(3) unsigned NOT NULL DEFAULT 0, - `matchMakerRating` smallint(5) unsigned NOT NULL DEFAULT 0, - `maxMMR` smallint(5) NOT NULL, + `guid` INT unsigned NOT NULL DEFAULT 0, + `slot` TINYINT unsigned NOT NULL DEFAULT 0, + `matchMakerRating` SMALLINT unsigned NOT NULL DEFAULT 0, + `maxMMR` SMALLINT NOT NULL, PRIMARY KEY (`guid`,`slot`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_arena_stats` WRITE; diff --git a/data/sql/base/db_characters/character_aura.sql b/data/sql/base/db_characters/character_aura.sql index c27ea96a87..88d986b0de 100644 --- a/data/sql/base/db_characters/character_aura.sql +++ b/data/sql/base/db_characters/character_aura.sql @@ -6,27 +6,27 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_aura`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_aura` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `casterGuid` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT 'Full Global Unique Identifier', - `itemGuid` bigint(20) unsigned NOT NULL DEFAULT 0, - `spell` mediumint(8) unsigned NOT NULL DEFAULT 0, - `effectMask` tinyint(3) unsigned NOT NULL DEFAULT 0, - `recalculateMask` tinyint(3) unsigned NOT NULL DEFAULT 0, - `stackCount` tinyint(3) unsigned NOT NULL DEFAULT 1, - `amount0` int(11) NOT NULL DEFAULT 0, - `amount1` int(11) NOT NULL DEFAULT 0, - `amount2` int(11) NOT NULL DEFAULT 0, - `base_amount0` int(11) NOT NULL DEFAULT 0, - `base_amount1` int(11) NOT NULL DEFAULT 0, - `base_amount2` int(11) NOT NULL DEFAULT 0, - `maxDuration` int(11) NOT NULL DEFAULT 0, - `remainTime` int(11) NOT NULL DEFAULT 0, - `remainCharges` tinyint(3) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `casterGuid` BIGINT unsigned NOT NULL DEFAULT 0 COMMENT 'Full Global Unique Identifier', + `itemGuid` BIGINT unsigned NOT NULL DEFAULT 0, + `spell` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `effectMask` TINYINT unsigned NOT NULL DEFAULT 0, + `recalculateMask` TINYINT unsigned NOT NULL DEFAULT 0, + `stackCount` TINYINT unsigned NOT NULL DEFAULT 1, + `amount0` INT NOT NULL DEFAULT 0, + `amount1` INT NOT NULL DEFAULT 0, + `amount2` INT NOT NULL DEFAULT 0, + `base_amount0` INT NOT NULL DEFAULT 0, + `base_amount1` INT NOT NULL DEFAULT 0, + `base_amount2` INT NOT NULL DEFAULT 0, + `maxDuration` INT NOT NULL DEFAULT 0, + `remainTime` INT NOT NULL DEFAULT 0, + `remainCharges` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_aura` WRITE; diff --git a/data/sql/base/db_characters/character_banned.sql b/data/sql/base/db_characters/character_banned.sql index a8b82d4ae9..34f48cf7df 100644 --- a/data/sql/base/db_characters/character_banned.sql +++ b/data/sql/base/db_characters/character_banned.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_banned`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_banned` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `bandate` int(10) unsigned NOT NULL DEFAULT 0, - `unbandate` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `bandate` INT unsigned NOT NULL DEFAULT 0, + `unbandate` INT unsigned NOT NULL DEFAULT 0, `bannedby` varchar(50) NOT NULL, `banreason` varchar(255) NOT NULL, - `active` tinyint(3) unsigned NOT NULL DEFAULT 1, + `active` TINYINT unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`guid`,`bandate`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Ban List'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_banned` WRITE; diff --git a/data/sql/base/db_characters/character_battleground_random.sql b/data/sql/base/db_characters/character_battleground_random.sql index 009baff8dc..e6e02a812a 100644 --- a/data/sql/base/db_characters/character_battleground_random.sql +++ b/data/sql/base/db_characters/character_battleground_random.sql @@ -6,12 +6,12 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_battleground_random`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_battleground_random` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_battleground_random` WRITE; diff --git a/data/sql/base/db_characters/character_brew_of_the_month.sql b/data/sql/base/db_characters/character_brew_of_the_month.sql index c23e9325fd..233ccc4ca4 100644 --- a/data/sql/base/db_characters/character_brew_of_the_month.sql +++ b/data/sql/base/db_characters/character_brew_of_the_month.sql @@ -6,13 +6,13 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_brew_of_the_month`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_brew_of_the_month` ( - `guid` int(10) unsigned NOT NULL, - `lastEventId` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL, + `lastEventId` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_brew_of_the_month` WRITE; diff --git a/data/sql/base/db_characters/character_declinedname.sql b/data/sql/base/db_characters/character_declinedname.sql index 40483c7924..91fcc5e96f 100644 --- a/data/sql/base/db_characters/character_declinedname.sql +++ b/data/sql/base/db_characters/character_declinedname.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_declinedname`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_declinedname` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', `genitive` varchar(15) NOT NULL DEFAULT '', `dative` varchar(15) NOT NULL DEFAULT '', `accusative` varchar(15) NOT NULL DEFAULT '', `instrumental` varchar(15) NOT NULL DEFAULT '', `prepositional` varchar(15) NOT NULL DEFAULT '', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_declinedname` WRITE; diff --git a/data/sql/base/db_characters/character_entry_point.sql b/data/sql/base/db_characters/character_entry_point.sql index 763c78ba01..d6cafe35a9 100644 --- a/data/sql/base/db_characters/character_entry_point.sql +++ b/data/sql/base/db_characters/character_entry_point.sql @@ -6,19 +6,19 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_entry_point`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_entry_point` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', `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` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier', + `joinMapId` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier', `taxiPath` text DEFAULT NULL, - `mountSpell` int(10) unsigned NOT NULL DEFAULT 0, + `mountSpell` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_entry_point` WRITE; diff --git a/data/sql/base/db_characters/character_equipmentsets.sql b/data/sql/base/db_characters/character_equipmentsets.sql index db23d04025..63a4c13752 100644 --- a/data/sql/base/db_characters/character_equipmentsets.sql +++ b/data/sql/base/db_characters/character_equipmentsets.sql @@ -6,38 +6,38 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_equipmentsets`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_equipmentsets` ( - `guid` int(10) NOT NULL DEFAULT 0, - `setguid` bigint(20) NOT NULL AUTO_INCREMENT, - `setindex` tinyint(3) unsigned NOT NULL DEFAULT 0, + `guid` INT NOT NULL DEFAULT 0, + `setguid` BIGINT NOT NULL AUTO_INCREMENT, + `setindex` TINYINT unsigned NOT NULL DEFAULT 0, `name` varchar(31) NOT NULL, `iconname` varchar(100) NOT NULL, - `ignore_mask` int(11) unsigned NOT NULL DEFAULT 0, - `item0` int(11) unsigned NOT NULL DEFAULT 0, - `item1` int(11) unsigned NOT NULL DEFAULT 0, - `item2` int(11) unsigned NOT NULL DEFAULT 0, - `item3` int(11) unsigned NOT NULL DEFAULT 0, - `item4` int(11) unsigned NOT NULL DEFAULT 0, - `item5` int(11) unsigned NOT NULL DEFAULT 0, - `item6` int(11) unsigned NOT NULL DEFAULT 0, - `item7` int(11) unsigned NOT NULL DEFAULT 0, - `item8` int(11) unsigned NOT NULL DEFAULT 0, - `item9` int(11) unsigned NOT NULL DEFAULT 0, - `item10` int(11) unsigned NOT NULL DEFAULT 0, - `item11` int(11) unsigned NOT NULL DEFAULT 0, - `item12` int(11) unsigned NOT NULL DEFAULT 0, - `item13` int(11) unsigned NOT NULL DEFAULT 0, - `item14` int(11) unsigned NOT NULL DEFAULT 0, - `item15` int(11) unsigned NOT NULL DEFAULT 0, - `item16` int(11) unsigned NOT NULL DEFAULT 0, - `item17` int(11) unsigned NOT NULL DEFAULT 0, - `item18` int(11) unsigned NOT NULL DEFAULT 0, + `ignore_mask` INT unsigned NOT NULL DEFAULT 0, + `item0` INT unsigned NOT NULL DEFAULT 0, + `item1` INT unsigned NOT NULL DEFAULT 0, + `item2` INT unsigned NOT NULL DEFAULT 0, + `item3` INT unsigned NOT NULL DEFAULT 0, + `item4` INT unsigned NOT NULL DEFAULT 0, + `item5` INT unsigned NOT NULL DEFAULT 0, + `item6` INT unsigned NOT NULL DEFAULT 0, + `item7` INT unsigned NOT NULL DEFAULT 0, + `item8` INT unsigned NOT NULL DEFAULT 0, + `item9` INT unsigned NOT NULL DEFAULT 0, + `item10` INT unsigned NOT NULL DEFAULT 0, + `item11` INT unsigned NOT NULL DEFAULT 0, + `item12` INT unsigned NOT NULL DEFAULT 0, + `item13` INT unsigned NOT NULL DEFAULT 0, + `item14` INT unsigned NOT NULL DEFAULT 0, + `item15` INT unsigned NOT NULL DEFAULT 0, + `item16` INT unsigned NOT NULL DEFAULT 0, + `item17` INT unsigned NOT NULL DEFAULT 0, + `item18` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`setguid`), UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`), KEY `Idx_setindex` (`setindex`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_equipmentsets` WRITE; diff --git a/data/sql/base/db_characters/character_gifts.sql b/data/sql/base/db_characters/character_gifts.sql index 4d21fa5586..027724fef2 100644 --- a/data/sql/base/db_characters/character_gifts.sql +++ b/data/sql/base/db_characters/character_gifts.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_gifts`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_gifts` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0, - `item_guid` int(10) unsigned NOT NULL DEFAULT 0, - `entry` int(10) unsigned NOT NULL DEFAULT 0, - `flags` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0, + `item_guid` INT unsigned NOT NULL DEFAULT 0, + `entry` INT unsigned NOT NULL DEFAULT 0, + `flags` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`item_guid`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_gifts` WRITE; diff --git a/data/sql/base/db_characters/character_glyphs.sql b/data/sql/base/db_characters/character_glyphs.sql index 1e24c573c8..1b4d800140 100644 --- a/data/sql/base/db_characters/character_glyphs.sql +++ b/data/sql/base/db_characters/character_glyphs.sql @@ -6,19 +6,19 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_glyphs`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_glyphs` ( - `guid` int(10) unsigned NOT NULL, - `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT 0, - `glyph1` smallint(5) unsigned DEFAULT 0, - `glyph2` smallint(5) unsigned DEFAULT 0, - `glyph3` smallint(5) unsigned DEFAULT 0, - `glyph4` smallint(5) unsigned DEFAULT 0, - `glyph5` smallint(5) unsigned DEFAULT 0, - `glyph6` smallint(5) unsigned DEFAULT 0, + `guid` INT unsigned NOT NULL, + `talentGroup` TINYINT unsigned NOT NULL DEFAULT 0, + `glyph1` SMALLINT unsigned DEFAULT 0, + `glyph2` SMALLINT unsigned DEFAULT 0, + `glyph3` SMALLINT unsigned DEFAULT 0, + `glyph4` SMALLINT unsigned DEFAULT 0, + `glyph5` SMALLINT unsigned DEFAULT 0, + `glyph6` SMALLINT unsigned DEFAULT 0, PRIMARY KEY (`guid`,`talentGroup`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_glyphs` WRITE; diff --git a/data/sql/base/db_characters/character_homebind.sql b/data/sql/base/db_characters/character_homebind.sql index cc45d37fe7..d4373b7228 100644 --- a/data/sql/base/db_characters/character_homebind.sql +++ b/data/sql/base/db_characters/character_homebind.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_homebind`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_homebind` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `mapId` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier', - `zoneId` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Zone Identifier', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `mapId` SMALLINT unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier', + `zoneId` SMALLINT unsigned NOT NULL DEFAULT 0 COMMENT 'Zone Identifier', `posX` float NOT NULL DEFAULT 0, `posY` float NOT NULL DEFAULT 0, `posZ` float NOT NULL DEFAULT 0, PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_homebind` WRITE; diff --git a/data/sql/base/db_characters/character_instance.sql b/data/sql/base/db_characters/character_instance.sql index 5169dea3c7..4845bd4353 100644 --- a/data/sql/base/db_characters/character_instance.sql +++ b/data/sql/base/db_characters/character_instance.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_instance` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0, - `instance` int(10) unsigned NOT NULL DEFAULT 0, - `permanent` tinyint(3) unsigned NOT NULL DEFAULT 0, - `extended` tinyint(3) unsigned NOT NULL, + `guid` INT unsigned NOT NULL DEFAULT 0, + `instance` INT unsigned NOT NULL DEFAULT 0, + `permanent` TINYINT unsigned NOT NULL DEFAULT 0, + `extended` TINYINT unsigned NOT NULL, PRIMARY KEY (`guid`,`instance`), KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_instance` WRITE; diff --git a/data/sql/base/db_characters/character_inventory.sql b/data/sql/base/db_characters/character_inventory.sql index 77f302dc6e..d48b111bc3 100644 --- a/data/sql/base/db_characters/character_inventory.sql +++ b/data/sql/base/db_characters/character_inventory.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_inventory`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_inventory` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `bag` int(10) unsigned NOT NULL DEFAULT 0, - `slot` tinyint(3) unsigned NOT NULL DEFAULT 0, - `item` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Item Global Unique Identifier', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `bag` INT unsigned NOT NULL DEFAULT 0, + `slot` TINYINT unsigned NOT NULL DEFAULT 0, + `item` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Item Global Unique Identifier', PRIMARY KEY (`item`), UNIQUE KEY `guid` (`guid`,`bag`,`slot`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_inventory` WRITE; diff --git a/data/sql/base/db_characters/character_pet.sql b/data/sql/base/db_characters/character_pet.sql index 9e9cfa4356..05d9daae79 100644 --- a/data/sql/base/db_characters/character_pet.sql +++ b/data/sql/base/db_characters/character_pet.sql @@ -6,30 +6,30 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_pet`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_pet` ( - `id` int(10) unsigned NOT NULL DEFAULT 0, - `entry` int(10) unsigned NOT NULL DEFAULT 0, - `owner` int(10) unsigned NOT NULL DEFAULT 0, - `modelid` int(10) unsigned DEFAULT 0, - `CreatedBySpell` mediumint(8) unsigned NOT NULL DEFAULT 0, - `PetType` tinyint(3) unsigned NOT NULL DEFAULT 0, - `level` smallint(5) unsigned NOT NULL DEFAULT 1, - `exp` int(10) unsigned NOT NULL DEFAULT 0, - `Reactstate` tinyint(3) unsigned NOT NULL DEFAULT 0, + `id` INT unsigned NOT NULL DEFAULT 0, + `entry` INT unsigned NOT NULL DEFAULT 0, + `owner` INT unsigned NOT NULL DEFAULT 0, + `modelid` INT unsigned DEFAULT 0, + `CreatedBySpell` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `PetType` TINYINT unsigned NOT NULL DEFAULT 0, + `level` SMALLINT unsigned NOT NULL DEFAULT 1, + `exp` INT unsigned NOT NULL DEFAULT 0, + `Reactstate` TINYINT unsigned NOT NULL DEFAULT 0, `name` varchar(21) NOT NULL DEFAULT 'Pet', - `renamed` tinyint(3) unsigned NOT NULL DEFAULT 0, - `slot` tinyint(3) unsigned NOT NULL DEFAULT 0, - `curhealth` int(10) unsigned NOT NULL DEFAULT 1, - `curmana` int(10) unsigned NOT NULL DEFAULT 0, - `curhappiness` int(10) unsigned NOT NULL DEFAULT 0, - `savetime` int(10) unsigned NOT NULL DEFAULT 0, + `renamed` TINYINT unsigned NOT NULL DEFAULT 0, + `slot` TINYINT unsigned NOT NULL DEFAULT 0, + `curhealth` INT unsigned NOT NULL DEFAULT 1, + `curmana` INT unsigned NOT NULL DEFAULT 0, + `curhappiness` INT unsigned NOT NULL DEFAULT 0, + `savetime` INT unsigned NOT NULL DEFAULT 0, `abdata` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `owner` (`owner`), KEY `idx_slot` (`slot`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_pet` WRITE; diff --git a/data/sql/base/db_characters/character_pet_declinedname.sql b/data/sql/base/db_characters/character_pet_declinedname.sql index 19731675c4..0f28f5888b 100644 --- a/data/sql/base/db_characters/character_pet_declinedname.sql +++ b/data/sql/base/db_characters/character_pet_declinedname.sql @@ -6,11 +6,11 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_pet_declinedname`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_pet_declinedname` ( - `id` int(10) unsigned NOT NULL DEFAULT 0, - `owner` int(10) unsigned NOT NULL DEFAULT 0, + `id` INT unsigned NOT NULL DEFAULT 0, + `owner` INT unsigned NOT NULL DEFAULT 0, `genitive` varchar(12) NOT NULL DEFAULT '', `dative` varchar(12) NOT NULL DEFAULT '', `accusative` varchar(12) NOT NULL DEFAULT '', @@ -18,7 +18,7 @@ CREATE TABLE `character_pet_declinedname` `prepositional` varchar(12) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `owner_key` (`owner`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_pet_declinedname` WRITE; diff --git a/data/sql/base/db_characters/character_queststatus.sql b/data/sql/base/db_characters/character_queststatus.sql index 8bf4e48c86..fc75d3da54 100644 --- a/data/sql/base/db_characters/character_queststatus.sql +++ b/data/sql/base/db_characters/character_queststatus.sql @@ -6,27 +6,27 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_queststatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_queststatus` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', - `status` tinyint(3) unsigned NOT NULL DEFAULT 0, - `explored` tinyint(3) unsigned NOT NULL DEFAULT 0, - `timer` int(10) unsigned NOT NULL DEFAULT 0, - `mobcount1` smallint(5) unsigned NOT NULL DEFAULT 0, - `mobcount2` smallint(5) unsigned NOT NULL DEFAULT 0, - `mobcount3` smallint(5) unsigned NOT NULL DEFAULT 0, - `mobcount4` smallint(5) unsigned NOT NULL DEFAULT 0, - `itemcount1` smallint(5) unsigned NOT NULL DEFAULT 0, - `itemcount2` smallint(5) unsigned NOT NULL DEFAULT 0, - `itemcount3` smallint(5) unsigned NOT NULL DEFAULT 0, - `itemcount4` smallint(5) unsigned NOT NULL DEFAULT 0, - `itemcount5` smallint(5) unsigned NOT NULL DEFAULT 0, - `itemcount6` smallint(5) unsigned NOT NULL DEFAULT 0, - `playercount` smallint(5) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `quest` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', + `status` TINYINT unsigned NOT NULL DEFAULT 0, + `explored` TINYINT unsigned NOT NULL DEFAULT 0, + `timer` INT unsigned NOT NULL DEFAULT 0, + `mobcount1` SMALLINT unsigned NOT NULL DEFAULT 0, + `mobcount2` SMALLINT unsigned NOT NULL DEFAULT 0, + `mobcount3` SMALLINT unsigned NOT NULL DEFAULT 0, + `mobcount4` SMALLINT unsigned NOT NULL DEFAULT 0, + `itemcount1` SMALLINT unsigned NOT NULL DEFAULT 0, + `itemcount2` SMALLINT unsigned NOT NULL DEFAULT 0, + `itemcount3` SMALLINT unsigned NOT NULL DEFAULT 0, + `itemcount4` SMALLINT unsigned NOT NULL DEFAULT 0, + `itemcount5` SMALLINT unsigned NOT NULL DEFAULT 0, + `itemcount6` SMALLINT unsigned NOT NULL DEFAULT 0, + `playercount` SMALLINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`quest`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_queststatus` WRITE; diff --git a/data/sql/base/db_characters/character_queststatus_daily.sql b/data/sql/base/db_characters/character_queststatus_daily.sql index e2c92849ff..189130bc5a 100644 --- a/data/sql/base/db_characters/character_queststatus_daily.sql +++ b/data/sql/base/db_characters/character_queststatus_daily.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_queststatus_daily`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_queststatus_daily` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', - `time` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `quest` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', + `time` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_queststatus_daily` WRITE; diff --git a/data/sql/base/db_characters/character_queststatus_monthly.sql b/data/sql/base/db_characters/character_queststatus_monthly.sql index fd1bda8cd3..07f6f32d21 100644 --- a/data/sql/base/db_characters/character_queststatus_monthly.sql +++ b/data/sql/base/db_characters/character_queststatus_monthly.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_queststatus_monthly`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_queststatus_monthly` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `quest` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_queststatus_monthly` WRITE; diff --git a/data/sql/base/db_characters/character_queststatus_rewarded.sql b/data/sql/base/db_characters/character_queststatus_rewarded.sql index 63029cae3b..954d7d4265 100644 --- a/data/sql/base/db_characters/character_queststatus_rewarded.sql +++ b/data/sql/base/db_characters/character_queststatus_rewarded.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_queststatus_rewarded`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_queststatus_rewarded` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', - `active` tinyint(3) unsigned NOT NULL DEFAULT 1, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `quest` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', + `active` TINYINT unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`guid`,`quest`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_queststatus_rewarded` WRITE; diff --git a/data/sql/base/db_characters/character_queststatus_seasonal.sql b/data/sql/base/db_characters/character_queststatus_seasonal.sql index ccb69a997c..b892c5d47e 100644 --- a/data/sql/base/db_characters/character_queststatus_seasonal.sql +++ b/data/sql/base/db_characters/character_queststatus_seasonal.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_queststatus_seasonal`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_queststatus_seasonal` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', - `event` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Event Identifier', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `quest` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', + `event` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Event Identifier', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_queststatus_seasonal` WRITE; diff --git a/data/sql/base/db_characters/character_queststatus_weekly.sql b/data/sql/base/db_characters/character_queststatus_weekly.sql index 7ffae0eb09..9c5dcf7cf4 100644 --- a/data/sql/base/db_characters/character_queststatus_weekly.sql +++ b/data/sql/base/db_characters/character_queststatus_weekly.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_queststatus_weekly`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_queststatus_weekly` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `quest` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `quest` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Quest Identifier', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_queststatus_weekly` WRITE; diff --git a/data/sql/base/db_characters/character_reputation.sql b/data/sql/base/db_characters/character_reputation.sql index 116a0afa68..b38984f4d5 100644 --- a/data/sql/base/db_characters/character_reputation.sql +++ b/data/sql/base/db_characters/character_reputation.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_reputation`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_reputation` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `faction` smallint(5) unsigned NOT NULL DEFAULT 0, - `standing` int(11) NOT NULL DEFAULT 0, - `flags` smallint(5) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `faction` SMALLINT unsigned NOT NULL DEFAULT 0, + `standing` INT NOT NULL DEFAULT 0, + `flags` SMALLINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`faction`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_reputation` WRITE; diff --git a/data/sql/base/db_characters/character_skills.sql b/data/sql/base/db_characters/character_skills.sql index 07214ae883..f23dd3a5f0 100644 --- a/data/sql/base/db_characters/character_skills.sql +++ b/data/sql/base/db_characters/character_skills.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_skills`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_skills` ( - `guid` int(10) unsigned NOT NULL COMMENT 'Global Unique Identifier', - `skill` smallint(5) unsigned NOT NULL, - `value` smallint(5) unsigned NOT NULL, - `max` smallint(5) unsigned NOT NULL, + `guid` INT unsigned NOT NULL COMMENT 'Global Unique Identifier', + `skill` SMALLINT unsigned NOT NULL, + `value` SMALLINT unsigned NOT NULL, + `max` SMALLINT unsigned NOT NULL, PRIMARY KEY (`guid`,`skill`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_skills` WRITE; diff --git a/data/sql/base/db_characters/character_social.sql b/data/sql/base/db_characters/character_social.sql index a050aa0573..24b980b78e 100644 --- a/data/sql/base/db_characters/character_social.sql +++ b/data/sql/base/db_characters/character_social.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_social`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_social` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', - `friend` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Friend Global Unique Identifier', - `flags` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Friend Flags', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', + `friend` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Friend Global Unique Identifier', + `flags` TINYINT unsigned NOT NULL DEFAULT 0 COMMENT 'Friend Flags', `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note', PRIMARY KEY (`guid`,`friend`,`flags`), KEY `friend` (`friend`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_social` WRITE; diff --git a/data/sql/base/db_characters/character_spell.sql b/data/sql/base/db_characters/character_spell.sql index e19374633b..e3088f1c29 100644 --- a/data/sql/base/db_characters/character_spell.sql +++ b/data/sql/base/db_characters/character_spell.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_spell` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `spell` mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 'Spell Identifier', - `specMask` tinyint(3) unsigned NOT NULL DEFAULT 1, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `spell` MEDIUMINT unsigned NOT NULL DEFAULT 0 COMMENT 'Spell Identifier', + `specMask` TINYINT unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_spell` WRITE; diff --git a/data/sql/base/db_characters/character_spell_cooldown.sql b/data/sql/base/db_characters/character_spell_cooldown.sql index 845f7af2b5..af9fd3d925 100644 --- a/data/sql/base/db_characters/character_spell_cooldown.sql +++ b/data/sql/base/db_characters/character_spell_cooldown.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_spell_cooldown`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_spell_cooldown` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part', - `spell` mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 'Spell Identifier', - `item` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Item Identifier', - `time` int(10) unsigned NOT NULL DEFAULT 0, - `needSend` tinyint(3) unsigned NOT NULL DEFAULT 1, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part', + `spell` MEDIUMINT unsigned NOT NULL DEFAULT 0 COMMENT 'Spell Identifier', + `item` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Item Identifier', + `time` INT unsigned NOT NULL DEFAULT 0, + `needSend` TINYINT unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_spell_cooldown` WRITE; diff --git a/data/sql/base/db_characters/character_stats.sql b/data/sql/base/db_characters/character_stats.sql index 5f2c783607..bbd7ec03b7 100644 --- a/data/sql/base/db_characters/character_stats.sql +++ b/data/sql/base/db_characters/character_stats.sql @@ -6,42 +6,43 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_stats` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part', - `maxhealth` int(10) unsigned NOT NULL DEFAULT 0, - `maxpower1` int(10) unsigned NOT NULL DEFAULT 0, - `maxpower2` int(10) unsigned NOT NULL DEFAULT 0, - `maxpower3` int(10) unsigned NOT NULL DEFAULT 0, - `maxpower4` int(10) unsigned NOT NULL DEFAULT 0, - `maxpower5` int(10) unsigned NOT NULL DEFAULT 0, - `maxpower6` int(10) unsigned NOT NULL DEFAULT 0, - `maxpower7` int(10) unsigned NOT NULL DEFAULT 0, - `strength` int(10) unsigned NOT NULL DEFAULT 0, - `agility` int(10) unsigned NOT NULL DEFAULT 0, - `stamina` int(10) unsigned NOT NULL DEFAULT 0, - `intellect` int(10) unsigned NOT NULL DEFAULT 0, - `spirit` int(10) unsigned NOT NULL DEFAULT 0, - `armor` int(10) unsigned NOT NULL DEFAULT 0, - `resHoly` int(10) unsigned NOT NULL DEFAULT 0, - `resFire` int(10) unsigned NOT NULL DEFAULT 0, - `resNature` int(10) unsigned NOT NULL DEFAULT 0, - `resFrost` int(10) unsigned NOT NULL DEFAULT 0, - `resShadow` int(10) unsigned NOT NULL DEFAULT 0, - `resArcane` int(10) unsigned NOT NULL DEFAULT 0, - `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, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part', + `maxhealth` INT unsigned NOT NULL DEFAULT 0, + `maxpower1` INT unsigned NOT NULL DEFAULT 0, + `maxpower2` INT unsigned NOT NULL DEFAULT 0, + `maxpower3` INT unsigned NOT NULL DEFAULT 0, + `maxpower4` INT unsigned NOT NULL DEFAULT 0, + `maxpower5` INT unsigned NOT NULL DEFAULT 0, + `maxpower6` INT unsigned NOT NULL DEFAULT 0, + `maxpower7` INT unsigned NOT NULL DEFAULT 0, + `strength` INT unsigned NOT NULL DEFAULT 0, + `agility` INT unsigned NOT NULL DEFAULT 0, + `stamina` INT unsigned NOT NULL DEFAULT 0, + `intellect` INT unsigned NOT NULL DEFAULT 0, + `spirit` INT unsigned NOT NULL DEFAULT 0, + `armor` INT unsigned NOT NULL DEFAULT 0, + `resHoly` INT unsigned NOT NULL DEFAULT 0, + `resFire` INT unsigned NOT NULL DEFAULT 0, + `resNature` INT unsigned NOT NULL DEFAULT 0, + `resFrost` INT unsigned NOT NULL DEFAULT 0, + `resShadow` INT unsigned NOT NULL DEFAULT 0, + `resArcane` INT unsigned NOT NULL DEFAULT 0, + `blockPct` FLOAT NOT NULL DEFAULT 0, + `dodgePct` FLOAT NOT NULL DEFAULT 0, + `parryPct` FLOAT NOT NULL DEFAULT 0, + `critPct` FLOAT NOT NULL DEFAULT 0, + `rangedCritPct` FLOAT NOT NULL DEFAULT 0, + `spellCritPct` FLOAT 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, + CHECK (`blockPct`>=0 AND `dodgePct`>=0 AND `parryPct`>=0 AND `critPct`>=0 AND `rangedCritPct`>=0 AND `spellCritPct`>=0), PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_stats` WRITE; diff --git a/data/sql/base/db_characters/character_talent.sql b/data/sql/base/db_characters/character_talent.sql index b964e64173..359119331f 100644 --- a/data/sql/base/db_characters/character_talent.sql +++ b/data/sql/base/db_characters/character_talent.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `character_talent`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `character_talent` ( - `guid` int(10) unsigned NOT NULL, - `spell` mediumint(8) unsigned NOT NULL, - `specMask` tinyint(3) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL, + `spell` MEDIUMINT unsigned NOT NULL, + `specMask` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `character_talent` WRITE; diff --git a/data/sql/base/db_characters/characters.sql b/data/sql/base/db_characters/characters.sql index 010afb1b5f..a09264a0a5 100644 --- a/data/sql/base/db_characters/characters.sql +++ b/data/sql/base/db_characters/characters.sql @@ -6,91 +6,91 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `characters`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `characters` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `account` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Account Identifier', - `name` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, - `race` tinyint(3) unsigned NOT NULL DEFAULT 0, - `class` tinyint(3) unsigned NOT NULL DEFAULT 0, - `gender` tinyint(3) unsigned NOT NULL DEFAULT 0, - `level` tinyint(3) unsigned NOT NULL DEFAULT 0, - `xp` int(10) unsigned NOT NULL DEFAULT 0, - `money` int(10) unsigned NOT NULL DEFAULT 0, - `skin` tinyint(3) unsigned NOT NULL DEFAULT 0, - `face` tinyint(3) unsigned NOT NULL DEFAULT 0, - `hairStyle` tinyint(3) unsigned NOT NULL DEFAULT 0, - `hairColor` tinyint(3) unsigned NOT NULL DEFAULT 0, - `facialStyle` tinyint(3) unsigned NOT NULL DEFAULT 0, - `bankSlots` tinyint(3) unsigned NOT NULL DEFAULT 0, - `restState` tinyint(3) unsigned NOT NULL DEFAULT 0, - `playerFlags` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `account` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Account Identifier', + `name` varchar(12) CHARACTER SET UTF8MB4 COLLATE utf8mb4_bin NOT NULL, + `race` TINYINT unsigned NOT NULL DEFAULT 0, + `class` TINYINT unsigned NOT NULL DEFAULT 0, + `gender` TINYINT unsigned NOT NULL DEFAULT 0, + `level` TINYINT unsigned NOT NULL DEFAULT 0, + `xp` INT unsigned NOT NULL DEFAULT 0, + `money` INT unsigned NOT NULL DEFAULT 0, + `skin` TINYINT unsigned NOT NULL DEFAULT 0, + `face` TINYINT unsigned NOT NULL DEFAULT 0, + `hairStyle` TINYINT unsigned NOT NULL DEFAULT 0, + `hairColor` TINYINT unsigned NOT NULL DEFAULT 0, + `facialStyle` TINYINT unsigned NOT NULL DEFAULT 0, + `bankSlots` TINYINT unsigned NOT NULL DEFAULT 0, + `restState` TINYINT unsigned NOT NULL DEFAULT 0, + `playerFlags` INT unsigned NOT NULL DEFAULT 0, `position_x` float NOT NULL DEFAULT 0, `position_y` float NOT NULL DEFAULT 0, `position_z` float NOT NULL DEFAULT 0, - `map` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier', - `instance_id` int(10) unsigned NOT NULL DEFAULT 0, - `instance_mode_mask` tinyint(3) unsigned NOT NULL DEFAULT 0, + `map` SMALLINT unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier', + `instance_id` INT unsigned NOT NULL DEFAULT 0, + `instance_mode_mask` TINYINT unsigned NOT NULL DEFAULT 0, `orientation` float NOT NULL DEFAULT 0, `taximask` text NOT NULL, - `online` tinyint(3) unsigned NOT NULL DEFAULT 0, - `cinematic` tinyint(3) unsigned NOT NULL DEFAULT 0, - `totaltime` int(10) unsigned NOT NULL DEFAULT 0, - `leveltime` int(10) unsigned NOT NULL DEFAULT 0, - `logout_time` int(10) unsigned NOT NULL DEFAULT 0, - `is_logout_resting` tinyint(3) unsigned NOT NULL DEFAULT 0, + `online` TINYINT unsigned NOT NULL DEFAULT 0, + `cinematic` TINYINT unsigned NOT NULL DEFAULT 0, + `totaltime` INT unsigned NOT NULL DEFAULT 0, + `leveltime` INT unsigned NOT NULL DEFAULT 0, + `logout_time` INT unsigned NOT NULL DEFAULT 0, + `is_logout_resting` TINYINT unsigned NOT NULL DEFAULT 0, `rest_bonus` float NOT NULL DEFAULT 0, - `resettalents_cost` int(10) unsigned NOT NULL DEFAULT 0, - `resettalents_time` int(10) unsigned NOT NULL DEFAULT 0, + `resettalents_cost` INT unsigned NOT NULL DEFAULT 0, + `resettalents_time` INT unsigned NOT NULL DEFAULT 0, `trans_x` float NOT NULL DEFAULT 0, `trans_y` float NOT NULL DEFAULT 0, `trans_z` float NOT NULL DEFAULT 0, `trans_o` float NOT NULL DEFAULT 0, - `transguid` mediumint(8) unsigned NOT NULL DEFAULT 0, - `extra_flags` smallint(5) unsigned NOT NULL DEFAULT 0, - `stable_slots` tinyint(3) unsigned NOT NULL DEFAULT 0, - `at_login` smallint(5) unsigned NOT NULL DEFAULT 0, - `zone` smallint(5) unsigned NOT NULL DEFAULT 0, - `death_expire_time` int(10) unsigned NOT NULL DEFAULT 0, + `transguid` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `extra_flags` SMALLINT unsigned NOT NULL DEFAULT 0, + `stable_slots` TINYINT unsigned NOT NULL DEFAULT 0, + `at_login` SMALLINT unsigned NOT NULL DEFAULT 0, + `zone` SMALLINT unsigned NOT NULL DEFAULT 0, + `death_expire_time` INT unsigned NOT NULL DEFAULT 0, `taxi_path` text DEFAULT NULL, - `arenaPoints` int(10) unsigned NOT NULL DEFAULT 0, - `totalHonorPoints` int(10) unsigned NOT NULL DEFAULT 0, - `todayHonorPoints` int(10) unsigned NOT NULL DEFAULT 0, - `yesterdayHonorPoints` int(10) unsigned NOT NULL DEFAULT 0, - `totalKills` int(10) unsigned NOT NULL DEFAULT 0, - `todayKills` smallint(5) unsigned NOT NULL DEFAULT 0, - `yesterdayKills` smallint(5) unsigned NOT NULL DEFAULT 0, - `chosenTitle` int(10) unsigned NOT NULL DEFAULT 0, - `knownCurrencies` bigint(20) unsigned NOT NULL DEFAULT 0, - `watchedFaction` int(10) unsigned NOT NULL DEFAULT 0, - `drunk` tinyint(3) unsigned NOT NULL DEFAULT 0, - `health` int(10) unsigned NOT NULL DEFAULT 0, - `power1` int(10) unsigned NOT NULL DEFAULT 0, - `power2` int(10) unsigned NOT NULL DEFAULT 0, - `power3` int(10) unsigned NOT NULL DEFAULT 0, - `power4` int(10) unsigned NOT NULL DEFAULT 0, - `power5` int(10) unsigned NOT NULL DEFAULT 0, - `power6` int(10) unsigned NOT NULL DEFAULT 0, - `power7` int(10) unsigned NOT NULL DEFAULT 0, - `latency` mediumint(8) unsigned NOT NULL DEFAULT 0, - `talentGroupsCount` tinyint(3) unsigned NOT NULL DEFAULT 1, - `activeTalentGroup` tinyint(3) unsigned NOT NULL DEFAULT 0, + `arenaPoints` INT unsigned NOT NULL DEFAULT 0, + `totalHonorPoints` INT unsigned NOT NULL DEFAULT 0, + `todayHonorPoints` INT unsigned NOT NULL DEFAULT 0, + `yesterdayHonorPoints` INT unsigned NOT NULL DEFAULT 0, + `totalKills` INT unsigned NOT NULL DEFAULT 0, + `todayKills` SMALLINT unsigned NOT NULL DEFAULT 0, + `yesterdayKills` SMALLINT unsigned NOT NULL DEFAULT 0, + `chosenTitle` INT unsigned NOT NULL DEFAULT 0, + `knownCurrencies` BIGINT unsigned NOT NULL DEFAULT 0, + `watchedFaction` INT unsigned NOT NULL DEFAULT 0, + `drunk` TINYINT unsigned NOT NULL DEFAULT 0, + `health` INT unsigned NOT NULL DEFAULT 0, + `power1` INT unsigned NOT NULL DEFAULT 0, + `power2` INT unsigned NOT NULL DEFAULT 0, + `power3` INT unsigned NOT NULL DEFAULT 0, + `power4` INT unsigned NOT NULL DEFAULT 0, + `power5` INT unsigned NOT NULL DEFAULT 0, + `power6` INT unsigned NOT NULL DEFAULT 0, + `power7` INT unsigned NOT NULL DEFAULT 0, + `latency` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `talentGroupsCount` TINYINT unsigned NOT NULL DEFAULT 1, + `activeTalentGroup` TINYINT unsigned NOT NULL DEFAULT 0, `exploredZones` longtext DEFAULT NULL, `equipmentCache` longtext DEFAULT NULL, - `ammoId` int(10) unsigned NOT NULL DEFAULT 0, + `ammoId` INT unsigned NOT NULL DEFAULT 0, `knownTitles` longtext DEFAULT NULL, - `actionBars` tinyint(3) unsigned NOT NULL DEFAULT 0, - `grantableLevels` tinyint(3) unsigned NOT NULL DEFAULT 0, + `actionBars` TINYINT unsigned NOT NULL DEFAULT 0, + `grantableLevels` TINYINT unsigned NOT NULL DEFAULT 0, `creation_date` timestamp NOT NULL DEFAULT current_timestamp(), - `deleteInfos_Account` int(10) unsigned DEFAULT NULL, + `deleteInfos_Account` INT unsigned DEFAULT NULL, `deleteInfos_Name` varchar(12) DEFAULT NULL, - `deleteDate` int(10) unsigned DEFAULT NULL, + `deleteDate` INT unsigned DEFAULT NULL, PRIMARY KEY (`guid`), KEY `idx_account` (`account`), KEY `idx_online` (`online`), KEY `idx_name` (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `characters` WRITE; diff --git a/data/sql/base/db_characters/corpse.sql b/data/sql/base/db_characters/corpse.sql index 48ac7a1380..dc08e5b7fd 100644 --- a/data/sql/base/db_characters/corpse.sql +++ b/data/sql/base/db_characters/corpse.sql @@ -6,33 +6,33 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `corpse`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `corpse` ( - `corpseGuid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', + `corpseGuid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', `posX` float NOT NULL DEFAULT 0, `posY` float NOT NULL DEFAULT 0, `posZ` float NOT NULL DEFAULT 0, `orientation` float NOT NULL DEFAULT 0, - `mapId` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier', - `phaseMask` int(10) unsigned NOT NULL DEFAULT 1, - `displayId` int(10) unsigned NOT NULL DEFAULT 0, + `mapId` SMALLINT unsigned NOT NULL DEFAULT 0 COMMENT 'Map Identifier', + `phaseMask` INT unsigned NOT NULL DEFAULT 1, + `displayId` INT unsigned NOT NULL DEFAULT 0, `itemCache` text NOT NULL, - `bytes1` int(10) unsigned NOT NULL DEFAULT 0, - `bytes2` int(10) unsigned NOT NULL DEFAULT 0, - `guildId` int(10) unsigned NOT NULL DEFAULT 0, - `flags` tinyint(3) unsigned NOT NULL DEFAULT 0, - `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT 0, - `time` int(10) unsigned NOT NULL DEFAULT 0, - `corpseType` tinyint(3) unsigned NOT NULL DEFAULT 0, - `instanceId` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Instance Identifier', + `bytes1` INT unsigned NOT NULL DEFAULT 0, + `bytes2` INT unsigned NOT NULL DEFAULT 0, + `guildId` INT unsigned NOT NULL DEFAULT 0, + `flags` TINYINT unsigned NOT NULL DEFAULT 0, + `dynFlags` TINYINT unsigned NOT NULL DEFAULT 0, + `time` INT unsigned NOT NULL DEFAULT 0, + `corpseType` TINYINT unsigned NOT NULL DEFAULT 0, + `instanceId` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Instance Identifier', PRIMARY KEY (`corpseGuid`), KEY `idx_type` (`corpseType`), KEY `idx_instance` (`instanceId`), KEY `idx_player` (`guid`), KEY `idx_time` (`time`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Death System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `corpse` WRITE; diff --git a/data/sql/base/db_characters/creature_respawn.sql b/data/sql/base/db_characters/creature_respawn.sql index 177fa42082..358639cb24 100644 --- a/data/sql/base/db_characters/creature_respawn.sql +++ b/data/sql/base/db_characters/creature_respawn.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `creature_respawn`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `creature_respawn` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `respawnTime` int(10) unsigned NOT NULL DEFAULT 0, - `mapId` smallint(10) unsigned NOT NULL DEFAULT 0, - `instanceId` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Instance Identifier', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `respawnTime` INT unsigned NOT NULL DEFAULT 0, + `mapId` SMALLINT unsigned NOT NULL DEFAULT 0, + `instanceId` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Instance Identifier', PRIMARY KEY (`guid`,`instanceId`), KEY `idx_instance` (`instanceId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Grid Loading System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `creature_respawn` WRITE; diff --git a/data/sql/base/db_characters/game_event_condition_save.sql b/data/sql/base/db_characters/game_event_condition_save.sql index ef7c8b2db6..5635ba2e7d 100644 --- a/data/sql/base/db_characters/game_event_condition_save.sql +++ b/data/sql/base/db_characters/game_event_condition_save.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `game_event_condition_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `game_event_condition_save` ( - `eventEntry` tinyint(3) unsigned NOT NULL, - `condition_id` int(10) unsigned NOT NULL DEFAULT 0, + `eventEntry` TINYINT unsigned NOT NULL, + `condition_id` INT unsigned NOT NULL DEFAULT 0, `done` float DEFAULT 0, PRIMARY KEY (`eventEntry`,`condition_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `game_event_condition_save` WRITE; diff --git a/data/sql/base/db_characters/game_event_save.sql b/data/sql/base/db_characters/game_event_save.sql index 11f60e1797..e760166cf9 100644 --- a/data/sql/base/db_characters/game_event_save.sql +++ b/data/sql/base/db_characters/game_event_save.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `game_event_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `game_event_save` ( - `eventEntry` tinyint(3) unsigned NOT NULL, - `state` tinyint(3) unsigned NOT NULL DEFAULT 1, - `next_start` int(10) unsigned NOT NULL DEFAULT 0, + `eventEntry` TINYINT unsigned NOT NULL, + `state` TINYINT unsigned NOT NULL DEFAULT 1, + `next_start` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`eventEntry`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `game_event_save` WRITE; diff --git a/data/sql/base/db_characters/gameobject_respawn.sql b/data/sql/base/db_characters/gameobject_respawn.sql index df7559634b..16eab7e4cb 100644 --- a/data/sql/base/db_characters/gameobject_respawn.sql +++ b/data/sql/base/db_characters/gameobject_respawn.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `gameobject_respawn`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `gameobject_respawn` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `respawnTime` int(10) unsigned NOT NULL DEFAULT 0, - `mapId` smallint(10) unsigned NOT NULL DEFAULT 0, - `instanceId` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Instance Identifier', + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `respawnTime` INT unsigned NOT NULL DEFAULT 0, + `mapId` SMALLINT unsigned NOT NULL DEFAULT 0, + `instanceId` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Instance Identifier', PRIMARY KEY (`guid`,`instanceId`), KEY `idx_instance` (`instanceId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Grid Loading System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `gameobject_respawn` WRITE; diff --git a/data/sql/base/db_characters/gm_subsurvey.sql b/data/sql/base/db_characters/gm_subsurvey.sql index 353427bed1..fe27f4e985 100644 --- a/data/sql/base/db_characters/gm_subsurvey.sql +++ b/data/sql/base/db_characters/gm_subsurvey.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `gm_subsurvey`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `gm_subsurvey` ( - `surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT, - `questionId` int(10) unsigned NOT NULL DEFAULT 0, - `answer` int(10) unsigned NOT NULL DEFAULT 0, + `surveyId` INT unsigned NOT NULL AUTO_INCREMENT, + `questionId` INT unsigned NOT NULL DEFAULT 0, + `answer` INT unsigned NOT NULL DEFAULT 0, `answerComment` text NOT NULL, PRIMARY KEY (`surveyId`,`questionId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `gm_subsurvey` WRITE; diff --git a/data/sql/base/db_characters/gm_survey.sql b/data/sql/base/db_characters/gm_survey.sql index 44d9043929..61852010fe 100644 --- a/data/sql/base/db_characters/gm_survey.sql +++ b/data/sql/base/db_characters/gm_survey.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `gm_survey`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `gm_survey` ( - `surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT, - `guid` int(10) unsigned NOT NULL DEFAULT 0, - `mainSurvey` int(10) unsigned NOT NULL DEFAULT 0, + `surveyId` INT unsigned NOT NULL AUTO_INCREMENT, + `guid` INT unsigned NOT NULL DEFAULT 0, + `mainSurvey` INT unsigned NOT NULL DEFAULT 0, `comment` longtext NOT NULL, - `createTime` int(10) unsigned NOT NULL DEFAULT 0, - `maxMMR` smallint(5) NOT NULL, + `createTime` INT unsigned NOT NULL DEFAULT 0, + `maxMMR` SMALLINT NOT NULL, PRIMARY KEY (`surveyId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `gm_survey` WRITE; diff --git a/data/sql/base/db_characters/gm_ticket.sql b/data/sql/base/db_characters/gm_ticket.sql index 4994d3e5b6..53359dbc6d 100644 --- a/data/sql/base/db_characters/gm_ticket.sql +++ b/data/sql/base/db_characters/gm_ticket.sql @@ -6,31 +6,31 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `gm_ticket`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `gm_ticket` ( - `id` int(10) unsigned NOT NULL AUTO_INCREMENT, - `type` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT '0 open, 1 closed, 2 character deleted', - `playerGuid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier of ticket creator', + `id` INT unsigned NOT NULL AUTO_INCREMENT, + `type` TINYINT unsigned NOT NULL DEFAULT 0 COMMENT '0 open, 1 closed, 2 character deleted', + `playerGuid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier of ticket creator', `name` varchar(12) NOT NULL COMMENT 'Name of ticket creator', `description` text NOT NULL, - `createTime` int(10) unsigned NOT NULL DEFAULT 0, - `mapId` smallint(5) unsigned NOT NULL DEFAULT 0, + `createTime` INT unsigned NOT NULL DEFAULT 0, + `mapId` SMALLINT unsigned NOT NULL DEFAULT 0, `posX` float NOT NULL DEFAULT 0, `posY` float NOT NULL DEFAULT 0, `posZ` float NOT NULL DEFAULT 0, - `lastModifiedTime` int(10) unsigned NOT NULL DEFAULT 0, - `closedBy` int(10) unsigned NOT NULL DEFAULT 0, - `assignedTo` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'GUID of admin to whom ticket is assigned', + `lastModifiedTime` INT unsigned NOT NULL DEFAULT 0, + `closedBy` INT unsigned NOT NULL DEFAULT 0, + `assignedTo` INT unsigned NOT NULL DEFAULT 0 COMMENT 'GUID of admin to whom ticket is assigned', `comment` text NOT NULL, `response` text NOT NULL, - `completed` tinyint(3) unsigned NOT NULL DEFAULT 0, - `escalated` tinyint(3) unsigned NOT NULL DEFAULT 0, - `viewed` tinyint(3) unsigned NOT NULL DEFAULT 0, - `needMoreHelp` tinyint(3) unsigned NOT NULL DEFAULT 0, - `resolvedBy` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'GUID of GM who resolved the ticket', + `completed` TINYINT unsigned NOT NULL DEFAULT 0, + `escalated` TINYINT unsigned NOT NULL DEFAULT 0, + `viewed` TINYINT unsigned NOT NULL DEFAULT 0, + `needMoreHelp` TINYINT unsigned NOT NULL DEFAULT 0, + `resolvedBy` INT unsigned NOT NULL DEFAULT 0 COMMENT 'GUID of GM who resolved the ticket', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `gm_ticket` WRITE; diff --git a/data/sql/base/db_characters/group_member.sql b/data/sql/base/db_characters/group_member.sql index 5eaa2ee281..49392266c6 100644 --- a/data/sql/base/db_characters/group_member.sql +++ b/data/sql/base/db_characters/group_member.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `group_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `group_member` ( - `guid` int(10) unsigned NOT NULL, - `memberGuid` int(10) unsigned NOT NULL, - `memberFlags` tinyint(3) unsigned NOT NULL DEFAULT 0, - `subgroup` tinyint(3) unsigned NOT NULL DEFAULT 0, - `roles` tinyint(3) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL, + `memberGuid` INT unsigned NOT NULL, + `memberFlags` TINYINT unsigned NOT NULL DEFAULT 0, + `subgroup` TINYINT unsigned NOT NULL DEFAULT 0, + `roles` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`memberGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Groups'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `group_member` WRITE; diff --git a/data/sql/base/db_characters/groups.sql b/data/sql/base/db_characters/groups.sql index efca649aa1..a8a5a1f8c1 100644 --- a/data/sql/base/db_characters/groups.sql +++ b/data/sql/base/db_characters/groups.sql @@ -6,29 +6,29 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `groups` ( - `guid` int(10) unsigned NOT NULL, - `leaderGuid` int(10) unsigned NOT NULL, - `lootMethod` tinyint(3) unsigned NOT NULL, - `looterGuid` int(10) unsigned NOT NULL, - `lootThreshold` tinyint(3) unsigned NOT NULL, - `icon1` int(10) unsigned NOT NULL, - `icon2` int(10) unsigned NOT NULL, - `icon3` int(10) unsigned NOT NULL, - `icon4` int(10) unsigned NOT NULL, - `icon5` int(10) unsigned NOT NULL, - `icon6` int(10) unsigned NOT NULL, - `icon7` int(10) unsigned NOT NULL, - `icon8` int(10) unsigned NOT NULL, - `groupType` tinyint(3) unsigned NOT NULL, - `difficulty` tinyint(3) unsigned NOT NULL DEFAULT 0, - `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT 0, - `masterLooterGuid` int(10) unsigned NOT NULL, + `guid` INT unsigned NOT NULL, + `leaderGuid` INT unsigned NOT NULL, + `lootMethod` TINYINT unsigned NOT NULL, + `looterGuid` INT unsigned NOT NULL, + `lootThreshold` TINYINT unsigned NOT NULL, + `icon1` INT unsigned NOT NULL, + `icon2` INT unsigned NOT NULL, + `icon3` INT unsigned NOT NULL, + `icon4` INT unsigned NOT NULL, + `icon5` INT unsigned NOT NULL, + `icon6` INT unsigned NOT NULL, + `icon7` INT unsigned NOT NULL, + `icon8` INT unsigned NOT NULL, + `groupType` TINYINT unsigned NOT NULL, + `difficulty` TINYINT unsigned NOT NULL DEFAULT 0, + `raidDifficulty` TINYINT unsigned NOT NULL DEFAULT 0, + `masterLooterGuid` INT unsigned NOT NULL, PRIMARY KEY (`guid`), KEY `leaderGuid` (`leaderGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Groups'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `groups` WRITE; diff --git a/data/sql/base/db_characters/guild.sql b/data/sql/base/db_characters/guild.sql index 2ed57d09b5..92b09ce28c 100644 --- a/data/sql/base/db_characters/guild.sql +++ b/data/sql/base/db_characters/guild.sql @@ -6,23 +6,23 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `guild`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `guild` ( - `guildid` int(10) unsigned NOT NULL DEFAULT 0, + `guildid` INT unsigned NOT NULL DEFAULT 0, `name` varchar(24) NOT NULL DEFAULT '', - `leaderguid` int(10) unsigned NOT NULL DEFAULT 0, - `EmblemStyle` tinyint(3) unsigned NOT NULL DEFAULT 0, - `EmblemColor` tinyint(3) unsigned NOT NULL DEFAULT 0, - `BorderStyle` tinyint(3) unsigned NOT NULL DEFAULT 0, - `BorderColor` tinyint(3) unsigned NOT NULL DEFAULT 0, - `BackgroundColor` tinyint(3) unsigned NOT NULL DEFAULT 0, + `leaderguid` INT unsigned NOT NULL DEFAULT 0, + `EmblemStyle` TINYINT unsigned NOT NULL DEFAULT 0, + `EmblemColor` TINYINT unsigned NOT NULL DEFAULT 0, + `BorderStyle` TINYINT unsigned NOT NULL DEFAULT 0, + `BorderColor` TINYINT unsigned NOT NULL DEFAULT 0, + `BackgroundColor` TINYINT unsigned NOT NULL DEFAULT 0, `info` varchar(500) NOT NULL DEFAULT '', `motd` varchar(128) NOT NULL DEFAULT '', - `createdate` int(10) unsigned NOT NULL DEFAULT 0, - `BankMoney` bigint(20) unsigned NOT NULL DEFAULT 0, + `createdate` INT unsigned NOT NULL DEFAULT 0, + `BankMoney` BIGINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `guild` WRITE; diff --git a/data/sql/base/db_characters/guild_bank_eventlog.sql b/data/sql/base/db_characters/guild_bank_eventlog.sql index 07882e1e28..a522911236 100644 --- a/data/sql/base/db_characters/guild_bank_eventlog.sql +++ b/data/sql/base/db_characters/guild_bank_eventlog.sql @@ -6,23 +6,23 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `guild_bank_eventlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `guild_bank_eventlog` ( - `guildid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Guild Identificator', - `LogGuid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Log record identificator - auxiliary column', - `TabId` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Guild bank TabId', - `EventType` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Event type', - `PlayerGuid` int(10) unsigned NOT NULL DEFAULT 0, - `ItemOrMoney` int(10) unsigned NOT NULL DEFAULT 0, - `ItemStackCount` smallint(5) unsigned NOT NULL DEFAULT 0, - `DestTabId` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Destination Tab Id', - `TimeStamp` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Event UNIX time', + `guildid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Guild Identificator', + `LogGuid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Log record identificator - auxiliary column', + `TabId` TINYINT unsigned NOT NULL DEFAULT 0 COMMENT 'Guild bank TabId', + `EventType` TINYINT unsigned NOT NULL DEFAULT 0 COMMENT 'Event type', + `PlayerGuid` INT unsigned NOT NULL DEFAULT 0, + `ItemOrMoney` INT unsigned NOT NULL DEFAULT 0, + `ItemStackCount` SMALLINT unsigned NOT NULL DEFAULT 0, + `DestTabId` TINYINT unsigned NOT NULL DEFAULT 0 COMMENT 'Destination Tab Id', + `TimeStamp` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`,`TabId`), KEY `guildid_key` (`guildid`), KEY `Idx_PlayerGuid` (`PlayerGuid`), KEY `Idx_LogGuid` (`LogGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `guild_bank_eventlog` WRITE; diff --git a/data/sql/base/db_characters/guild_bank_item.sql b/data/sql/base/db_characters/guild_bank_item.sql index 06c53b6c41..eabfa77078 100644 --- a/data/sql/base/db_characters/guild_bank_item.sql +++ b/data/sql/base/db_characters/guild_bank_item.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `guild_bank_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `guild_bank_item` ( - `guildid` int(10) unsigned NOT NULL DEFAULT 0, - `TabId` tinyint(3) unsigned NOT NULL DEFAULT 0, - `SlotId` tinyint(3) unsigned NOT NULL DEFAULT 0, - `item_guid` int(10) unsigned NOT NULL DEFAULT 0, + `guildid` INT unsigned NOT NULL DEFAULT 0, + `TabId` TINYINT unsigned NOT NULL DEFAULT 0, + `SlotId` TINYINT unsigned NOT NULL DEFAULT 0, + `item_guid` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guildid`,`TabId`,`SlotId`), KEY `guildid_key` (`guildid`), KEY `Idx_item_guid` (`item_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `guild_bank_item` WRITE; diff --git a/data/sql/base/db_characters/guild_bank_right.sql b/data/sql/base/db_characters/guild_bank_right.sql index 0a0c96f811..4e80037992 100644 --- a/data/sql/base/db_characters/guild_bank_right.sql +++ b/data/sql/base/db_characters/guild_bank_right.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `guild_bank_right`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `guild_bank_right` ( - `guildid` int(10) unsigned NOT NULL DEFAULT 0, - `TabId` tinyint(3) unsigned NOT NULL DEFAULT 0, - `rid` tinyint(3) unsigned NOT NULL DEFAULT 0, - `gbright` tinyint(3) unsigned NOT NULL DEFAULT 0, - `SlotPerDay` int(10) unsigned NOT NULL DEFAULT 0, + `guildid` INT unsigned NOT NULL DEFAULT 0, + `TabId` TINYINT unsigned NOT NULL DEFAULT 0, + `rid` TINYINT unsigned NOT NULL DEFAULT 0, + `gbright` TINYINT unsigned NOT NULL DEFAULT 0, + `SlotPerDay` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guildid`,`TabId`,`rid`), KEY `guildid_key` (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `guild_bank_right` WRITE; diff --git a/data/sql/base/db_characters/guild_bank_tab.sql b/data/sql/base/db_characters/guild_bank_tab.sql index 3af92a59af..4003a1a1b8 100644 --- a/data/sql/base/db_characters/guild_bank_tab.sql +++ b/data/sql/base/db_characters/guild_bank_tab.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `guild_bank_tab`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `guild_bank_tab` ( - `guildid` int(10) unsigned NOT NULL DEFAULT 0, - `TabId` tinyint(3) unsigned NOT NULL DEFAULT 0, + `guildid` INT unsigned NOT NULL DEFAULT 0, + `TabId` TINYINT unsigned NOT NULL DEFAULT 0, `TabName` varchar(16) NOT NULL DEFAULT '', `TabIcon` varchar(100) NOT NULL DEFAULT '', `TabText` varchar(500) DEFAULT NULL, PRIMARY KEY (`guildid`,`TabId`), KEY `guildid_key` (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `guild_bank_tab` WRITE; diff --git a/data/sql/base/db_characters/guild_eventlog.sql b/data/sql/base/db_characters/guild_eventlog.sql index 12c220b403..7b43b424bc 100644 --- a/data/sql/base/db_characters/guild_eventlog.sql +++ b/data/sql/base/db_characters/guild_eventlog.sql @@ -6,21 +6,21 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `guild_eventlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `guild_eventlog` ( - `guildid` int(10) unsigned NOT NULL COMMENT 'Guild Identificator', - `LogGuid` int(10) unsigned NOT NULL COMMENT 'Log record identificator - auxiliary column', - `EventType` tinyint(3) unsigned NOT NULL COMMENT 'Event type', - `PlayerGuid1` int(10) unsigned NOT NULL COMMENT 'Player 1', - `PlayerGuid2` int(10) unsigned NOT NULL COMMENT 'Player 2', - `NewRank` tinyint(3) unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)', - `TimeStamp` int(10) unsigned NOT NULL COMMENT 'Event UNIX time', + `guildid` INT unsigned NOT NULL COMMENT 'Guild Identificator', + `LogGuid` INT unsigned NOT NULL COMMENT 'Log record identificator - auxiliary column', + `EventType` TINYINT unsigned NOT NULL COMMENT 'Event type', + `PlayerGuid1` INT unsigned NOT NULL COMMENT 'Player 1', + `PlayerGuid2` INT unsigned NOT NULL COMMENT 'Player 2', + `NewRank` TINYINT unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)', + `TimeStamp` INT unsigned NOT NULL COMMENT 'Event UNIX time', PRIMARY KEY (`guildid`,`LogGuid`), KEY `Idx_PlayerGuid1` (`PlayerGuid1`), KEY `Idx_PlayerGuid2` (`PlayerGuid2`), KEY `Idx_LogGuid` (`LogGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild Eventlog'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Guild Eventlog'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `guild_eventlog` WRITE; diff --git a/data/sql/base/db_characters/guild_member.sql b/data/sql/base/db_characters/guild_member.sql index 838cc7e532..4872f82e3e 100644 --- a/data/sql/base/db_characters/guild_member.sql +++ b/data/sql/base/db_characters/guild_member.sql @@ -6,18 +6,18 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `guild_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `guild_member` ( - `guildid` int(10) unsigned NOT NULL COMMENT 'Guild Identificator', - `guid` int(10) unsigned NOT NULL, - `rank` tinyint(3) unsigned NOT NULL, + `guildid` INT unsigned NOT NULL COMMENT 'Guild Identificator', + `guid` INT unsigned NOT NULL, + `rank` TINYINT unsigned NOT NULL, `pnote` varchar(31) NOT NULL DEFAULT '', `offnote` varchar(31) NOT NULL DEFAULT '', UNIQUE KEY `guid_key` (`guid`), KEY `guildid_key` (`guildid`), KEY `guildid_rank_key` (`guildid`,`rank`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `guild_member` WRITE; diff --git a/data/sql/base/db_characters/guild_member_withdraw.sql b/data/sql/base/db_characters/guild_member_withdraw.sql index a2b9b8c4fb..ffc7c4f05a 100644 --- a/data/sql/base/db_characters/guild_member_withdraw.sql +++ b/data/sql/base/db_characters/guild_member_withdraw.sql @@ -6,19 +6,19 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `guild_member_withdraw`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `guild_member_withdraw` ( - `guid` int(10) unsigned NOT NULL, - `tab0` int(10) unsigned NOT NULL DEFAULT 0, - `tab1` int(10) unsigned NOT NULL DEFAULT 0, - `tab2` int(10) unsigned NOT NULL DEFAULT 0, - `tab3` int(10) unsigned NOT NULL DEFAULT 0, - `tab4` int(10) unsigned NOT NULL DEFAULT 0, - `tab5` int(10) unsigned NOT NULL DEFAULT 0, - `money` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL, + `tab0` INT unsigned NOT NULL DEFAULT 0, + `tab1` INT unsigned NOT NULL DEFAULT 0, + `tab2` INT unsigned NOT NULL DEFAULT 0, + `tab3` INT unsigned NOT NULL DEFAULT 0, + `tab4` INT unsigned NOT NULL DEFAULT 0, + `tab5` INT unsigned NOT NULL DEFAULT 0, + `money` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild Member Daily Withdraws'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Guild Member Daily Withdraws'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `guild_member_withdraw` WRITE; diff --git a/data/sql/base/db_characters/guild_rank.sql b/data/sql/base/db_characters/guild_rank.sql index 5e153692da..4d0f637b9f 100644 --- a/data/sql/base/db_characters/guild_rank.sql +++ b/data/sql/base/db_characters/guild_rank.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `guild_rank`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `guild_rank` ( - `guildid` int(10) unsigned NOT NULL DEFAULT 0, - `rid` tinyint(3) unsigned NOT NULL, + `guildid` INT unsigned NOT NULL DEFAULT 0, + `rid` TINYINT unsigned NOT NULL, `rname` varchar(20) NOT NULL DEFAULT '', - `rights` mediumint(8) unsigned NOT NULL DEFAULT 0, - `BankMoneyPerDay` int(10) unsigned NOT NULL DEFAULT 0, + `rights` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `BankMoneyPerDay` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guildid`,`rid`), KEY `Idx_rid` (`rid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `guild_rank` WRITE; diff --git a/data/sql/base/db_characters/instance.sql b/data/sql/base/db_characters/instance.sql index 7971e9d6b0..4a7f0d2358 100644 --- a/data/sql/base/db_characters/instance.sql +++ b/data/sql/base/db_characters/instance.sql @@ -6,20 +6,20 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 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` int(10) unsigned NOT NULL DEFAULT 0, - `difficulty` tinyint(3) unsigned NOT NULL DEFAULT 0, - `completedEncounters` int(10) unsigned NOT NULL DEFAULT 0, + `id` INT unsigned NOT NULL DEFAULT 0, + `map` SMALLINT unsigned NOT NULL DEFAULT 0, + `resettime` INT unsigned NOT NULL DEFAULT 0, + `difficulty` TINYINT unsigned NOT NULL DEFAULT 0, + `completedEncounters` INT unsigned NOT NULL DEFAULT 0, `data` tinytext NOT NULL, PRIMARY KEY (`id`), KEY `map` (`map`), KEY `resettime` (`resettime`), KEY `difficulty` (`difficulty`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `instance` WRITE; diff --git a/data/sql/base/db_characters/instance_reset.sql b/data/sql/base/db_characters/instance_reset.sql index 5495b4a36d..dca4672968 100644 --- a/data/sql/base/db_characters/instance_reset.sql +++ b/data/sql/base/db_characters/instance_reset.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `instance_reset`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 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` int(10) unsigned NOT NULL DEFAULT 0, + `mapid` SMALLINT unsigned NOT NULL DEFAULT 0, + `difficulty` TINYINT unsigned NOT NULL DEFAULT 0, + `resettime` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`mapid`,`difficulty`), KEY `difficulty` (`difficulty`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `instance_reset` WRITE; diff --git a/data/sql/base/db_characters/item_instance.sql b/data/sql/base/db_characters/item_instance.sql index d1f041301d..a683369743 100644 --- a/data/sql/base/db_characters/item_instance.sql +++ b/data/sql/base/db_characters/item_instance.sql @@ -6,26 +6,26 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `item_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `item_instance` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0, - `itemEntry` mediumint(8) unsigned NOT NULL DEFAULT 0, - `owner_guid` int(10) unsigned NOT NULL DEFAULT 0, - `creatorGuid` int(10) unsigned NOT NULL DEFAULT 0, - `giftCreatorGuid` int(10) unsigned NOT NULL DEFAULT 0, - `count` int(10) unsigned NOT NULL DEFAULT 1, - `duration` int(10) NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0, + `itemEntry` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `owner_guid` INT unsigned NOT NULL DEFAULT 0, + `creatorGuid` INT unsigned NOT NULL DEFAULT 0, + `giftCreatorGuid` INT unsigned NOT NULL DEFAULT 0, + `count` INT unsigned NOT NULL DEFAULT 1, + `duration` INT NOT NULL DEFAULT 0, `charges` tinytext DEFAULT NULL, - `flags` mediumint(8) unsigned NOT NULL DEFAULT 0, + `flags` MEDIUMINT unsigned NOT NULL DEFAULT 0, `enchantments` text NOT NULL, - `randomPropertyId` smallint(5) NOT NULL DEFAULT 0, - `durability` smallint(5) unsigned NOT NULL DEFAULT 0, - `playedTime` int(10) unsigned NOT NULL DEFAULT 0, + `randomPropertyId` SMALLINT NOT NULL DEFAULT 0, + `durability` SMALLINT unsigned NOT NULL DEFAULT 0, + `playedTime` INT unsigned NOT NULL DEFAULT 0, `text` text DEFAULT NULL, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `item_instance` WRITE; diff --git a/data/sql/base/db_characters/item_loot_storage.sql b/data/sql/base/db_characters/item_loot_storage.sql index 15cbb3e76a..1d907ad382 100644 --- a/data/sql/base/db_characters/item_loot_storage.sql +++ b/data/sql/base/db_characters/item_loot_storage.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `item_loot_storage`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `item_loot_storage` ( - `containerGUID` int(10) unsigned NOT NULL, - `itemid` int(10) unsigned NOT NULL, - `count` int(10) unsigned NOT NULL, - `randomPropertyId` int(10) NOT NULL, - `randomSuffix` int(10) unsigned NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8; + `containerGUID` INT unsigned NOT NULL, + `itemid` INT unsigned NOT NULL, + `count` INT unsigned NOT NULL, + `randomPropertyId` INT NOT NULL, + `randomSuffix` INT unsigned NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `item_loot_storage` WRITE; diff --git a/data/sql/base/db_characters/item_refund_instance.sql b/data/sql/base/db_characters/item_refund_instance.sql index 81a714bf3f..eeb2612a14 100644 --- a/data/sql/base/db_characters/item_refund_instance.sql +++ b/data/sql/base/db_characters/item_refund_instance.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `item_refund_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `item_refund_instance` ( - `item_guid` int(10) unsigned NOT NULL COMMENT 'Item GUID', - `player_guid` int(10) unsigned NOT NULL COMMENT 'Player GUID', - `paidMoney` int(10) unsigned NOT NULL DEFAULT 0, - `paidExtendedCost` smallint(5) unsigned NOT NULL DEFAULT 0, + `item_guid` INT unsigned NOT NULL COMMENT 'Item GUID', + `player_guid` INT unsigned NOT NULL COMMENT 'Player GUID', + `paidMoney` INT unsigned NOT NULL DEFAULT 0, + `paidExtendedCost` SMALLINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`item_guid`,`player_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item Refund System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Item Refund System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `item_refund_instance` WRITE; diff --git a/data/sql/base/db_characters/item_soulbound_trade_data.sql b/data/sql/base/db_characters/item_soulbound_trade_data.sql index 7c6d477ab7..a3c7c424eb 100644 --- a/data/sql/base/db_characters/item_soulbound_trade_data.sql +++ b/data/sql/base/db_characters/item_soulbound_trade_data.sql @@ -6,13 +6,13 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `item_soulbound_trade_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `item_soulbound_trade_data` ( - `itemGuid` int(10) unsigned NOT NULL COMMENT 'Item GUID', + `itemGuid` INT unsigned NOT NULL COMMENT 'Item GUID', `allowedPlayers` text NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', PRIMARY KEY (`itemGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item Refund System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Item Refund System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `item_soulbound_trade_data` WRITE; diff --git a/data/sql/base/db_characters/lag_reports.sql b/data/sql/base/db_characters/lag_reports.sql index e18a3c0141..3817354a45 100644 --- a/data/sql/base/db_characters/lag_reports.sql +++ b/data/sql/base/db_characters/lag_reports.sql @@ -6,20 +6,20 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `lag_reports`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `lag_reports` ( - `reportId` int(10) unsigned NOT NULL AUTO_INCREMENT, - `guid` int(10) unsigned NOT NULL DEFAULT 0, - `lagType` tinyint(3) unsigned NOT NULL DEFAULT 0, - `mapId` smallint(5) unsigned NOT NULL DEFAULT 0, + `reportId` INT unsigned NOT NULL AUTO_INCREMENT, + `guid` INT unsigned NOT NULL DEFAULT 0, + `lagType` TINYINT unsigned NOT NULL DEFAULT 0, + `mapId` SMALLINT unsigned NOT NULL DEFAULT 0, `posX` float NOT NULL DEFAULT 0, `posY` float NOT NULL DEFAULT 0, `posZ` float NOT NULL DEFAULT 0, - `latency` int(10) unsigned NOT NULL DEFAULT 0, - `createTime` int(10) unsigned NOT NULL DEFAULT 0, + `latency` INT unsigned NOT NULL DEFAULT 0, + `createTime` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`reportId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `lag_reports` WRITE; diff --git a/data/sql/base/db_characters/lfg_data.sql b/data/sql/base/db_characters/lfg_data.sql index b2decaf5e0..7f8c25b9eb 100644 --- a/data/sql/base/db_characters/lfg_data.sql +++ b/data/sql/base/db_characters/lfg_data.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `lfg_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `lfg_data` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `dungeon` int(10) unsigned NOT NULL DEFAULT 0, - `state` tinyint(3) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `dungeon` INT unsigned NOT NULL DEFAULT 0, + `state` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='LFG Data'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='LFG Data'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `lfg_data` WRITE; diff --git a/data/sql/base/db_characters/log_arena_fights.sql b/data/sql/base/db_characters/log_arena_fights.sql index 7f540befc3..622f446d1c 100644 --- a/data/sql/base/db_characters/log_arena_fights.sql +++ b/data/sql/base/db_characters/log_arena_fights.sql @@ -6,24 +6,24 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `log_arena_fights`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `log_arena_fights` ( - `fight_id` int(10) unsigned NOT NULL, + `fight_id` INT unsigned NOT NULL, `time` datetime NOT NULL, - `type` tinyint(3) unsigned NOT NULL, - `duration` int(10) unsigned NOT NULL, - `winner` int(10) unsigned NOT NULL, - `loser` int(10) unsigned NOT NULL, - `winner_tr` smallint(5) unsigned NOT NULL, - `winner_mmr` smallint(5) unsigned NOT NULL, - `winner_tr_change` smallint(6) NOT NULL, - `loser_tr` smallint(5) unsigned NOT NULL, - `loser_mmr` smallint(5) unsigned NOT NULL, - `loser_tr_change` smallint(6) NOT NULL, - `currOnline` int(10) unsigned NOT NULL, + `type` TINYINT unsigned NOT NULL, + `duration` INT unsigned NOT NULL, + `winner` INT unsigned NOT NULL, + `loser` INT unsigned NOT NULL, + `winner_tr` SMALLINT unsigned NOT NULL, + `winner_mmr` SMALLINT unsigned NOT NULL, + `winner_tr_change` SMALLINT NOT NULL, + `loser_tr` SMALLINT unsigned NOT NULL, + `loser_mmr` SMALLINT unsigned NOT NULL, + `loser_tr_change` SMALLINT NOT NULL, + `currOnline` INT unsigned NOT NULL, PRIMARY KEY (`fight_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `log_arena_fights` WRITE; diff --git a/data/sql/base/db_characters/log_arena_memberstats.sql b/data/sql/base/db_characters/log_arena_memberstats.sql index ca9462abb6..bbf3ddd96d 100644 --- a/data/sql/base/db_characters/log_arena_memberstats.sql +++ b/data/sql/base/db_characters/log_arena_memberstats.sql @@ -6,21 +6,21 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `log_arena_memberstats`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `log_arena_memberstats` ( - `fight_id` int(10) unsigned NOT NULL, - `member_id` tinyint(3) unsigned NOT NULL, + `fight_id` INT unsigned NOT NULL, + `member_id` TINYINT unsigned NOT NULL, `name` char(20) NOT NULL, - `guid` int(10) unsigned NOT NULL, - `team` int(10) unsigned NOT NULL, - `account` int(10) unsigned NOT NULL, + `guid` INT unsigned NOT NULL, + `team` INT unsigned NOT NULL, + `account` INT unsigned NOT NULL, `ip` char(15) NOT NULL, - `damage` int(10) unsigned NOT NULL, - `heal` int(10) unsigned NOT NULL, - `kblows` int(10) unsigned NOT NULL, + `damage` INT unsigned NOT NULL, + `heal` INT unsigned NOT NULL, + `kblows` INT unsigned NOT NULL, PRIMARY KEY (`fight_id`,`member_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `log_arena_memberstats` WRITE; diff --git a/data/sql/base/db_characters/log_encounter.sql b/data/sql/base/db_characters/log_encounter.sql index 1dbefd7fb2..e90bacfd13 100644 --- a/data/sql/base/db_characters/log_encounter.sql +++ b/data/sql/base/db_characters/log_encounter.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `log_encounter`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `log_encounter` ( `time` datetime NOT NULL, - `map` smallint(5) unsigned NOT NULL, - `difficulty` tinyint(3) unsigned NOT NULL, - `creditType` tinyint(3) unsigned NOT NULL, - `creditEntry` int(10) unsigned NOT NULL, + `map` SMALLINT unsigned NOT NULL, + `difficulty` TINYINT unsigned NOT NULL, + `creditType` TINYINT unsigned NOT NULL, + `creditEntry` INT unsigned NOT NULL, `playersInfo` text NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=MyISAM DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `log_encounter` WRITE; diff --git a/data/sql/base/db_characters/log_money.sql b/data/sql/base/db_characters/log_money.sql index 94f57ce0b7..e688b91f2e 100644 --- a/data/sql/base/db_characters/log_money.sql +++ b/data/sql/base/db_characters/log_money.sql @@ -6,17 +6,17 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `log_money`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `log_money` ( - `sender_acc` int(11) unsigned NOT NULL, - `sender_guid` int(11) unsigned NOT NULL, - `sender_name` char(32) CHARACTER SET utf8 NOT NULL, - `sender_ip` char(32) CHARACTER SET utf8 NOT NULL, - `receiver_acc` int(11) unsigned NOT NULL, - `receiver_name` char(32) CHARACTER SET utf8 NOT NULL, - `money` bigint(20) unsigned NOT NULL, - `topic` char(255) CHARACTER SET utf8 NOT NULL, + `sender_acc` INT unsigned NOT NULL, + `sender_guid` INT unsigned NOT NULL, + `sender_name` char(32) CHARACTER SET UTF8MB4 NOT NULL, + `sender_ip` char(32) CHARACTER SET UTF8MB4 NOT NULL, + `receiver_acc` INT unsigned NOT NULL, + `receiver_name` char(32) CHARACTER SET UTF8MB4 NOT NULL, + `money` BIGINT unsigned NOT NULL, + `topic` char(255) CHARACTER SET UTF8MB4 NOT NULL, `date` datetime NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/data/sql/base/db_characters/mail.sql b/data/sql/base/db_characters/mail.sql index f6b66fb8f8..a556b61ed4 100644 --- a/data/sql/base/db_characters/mail.sql +++ b/data/sql/base/db_characters/mail.sql @@ -6,26 +6,26 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `mail`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `mail` ( - `id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Identifier', - `messageType` tinyint(3) unsigned NOT NULL DEFAULT 0, - `stationery` tinyint(3) NOT NULL DEFAULT 41, - `mailTemplateId` smallint(5) unsigned NOT NULL DEFAULT 0, - `sender` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', - `receiver` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', + `id` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Identifier', + `messageType` TINYINT unsigned NOT NULL DEFAULT 0, + `stationery` TINYINT NOT NULL DEFAULT 41, + `mailTemplateId` SMALLINT unsigned NOT NULL DEFAULT 0, + `sender` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', + `receiver` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', `subject` longtext DEFAULT NULL, `body` longtext DEFAULT NULL, - `has_items` tinyint(3) unsigned NOT NULL DEFAULT 0, - `expire_time` int(10) unsigned NOT NULL DEFAULT 0, - `deliver_time` int(10) unsigned NOT NULL DEFAULT 0, - `money` int(10) unsigned NOT NULL DEFAULT 0, - `cod` int(10) unsigned NOT NULL DEFAULT 0, - `checked` tinyint(3) unsigned NOT NULL DEFAULT 0, + `has_items` TINYINT unsigned NOT NULL DEFAULT 0, + `expire_time` INT unsigned NOT NULL DEFAULT 0, + `deliver_time` INT unsigned NOT NULL DEFAULT 0, + `money` INT unsigned NOT NULL DEFAULT 0, + `cod` INT unsigned NOT NULL DEFAULT 0, + `checked` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_receiver` (`receiver`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Mail System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Mail System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `mail` WRITE; diff --git a/data/sql/base/db_characters/mail_items.sql b/data/sql/base/db_characters/mail_items.sql index 814e924d7f..75794bd5d6 100644 --- a/data/sql/base/db_characters/mail_items.sql +++ b/data/sql/base/db_characters/mail_items.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `mail_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `mail_items` ( - `mail_id` int(10) unsigned NOT NULL DEFAULT 0, - `item_guid` int(10) unsigned NOT NULL DEFAULT 0, - `receiver` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', + `mail_id` INT unsigned NOT NULL DEFAULT 0, + `item_guid` INT unsigned NOT NULL DEFAULT 0, + `receiver` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Character Global Unique Identifier', PRIMARY KEY (`item_guid`), KEY `idx_receiver` (`receiver`), KEY `idx_mail_id` (`mail_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `mail_items` WRITE; diff --git a/data/sql/base/db_characters/pet_aura.sql b/data/sql/base/db_characters/pet_aura.sql index c2a3d8ed43..2eeca26b68 100644 --- a/data/sql/base/db_characters/pet_aura.sql +++ b/data/sql/base/db_characters/pet_aura.sql @@ -6,26 +6,26 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `pet_aura`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `pet_aura` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `casterGuid` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT 'Full Global Unique Identifier', - `spell` mediumint(8) unsigned NOT NULL DEFAULT 0, - `effectMask` tinyint(3) unsigned NOT NULL DEFAULT 0, - `recalculateMask` tinyint(3) unsigned NOT NULL DEFAULT 0, - `stackCount` tinyint(3) unsigned NOT NULL DEFAULT 1, - `amount0` mediumint(8) NOT NULL, - `amount1` mediumint(8) NOT NULL, - `amount2` mediumint(8) NOT NULL, - `base_amount0` mediumint(8) NOT NULL, - `base_amount1` mediumint(8) NOT NULL, - `base_amount2` mediumint(8) NOT NULL, - `maxDuration` int(11) NOT NULL DEFAULT 0, - `remainTime` int(11) NOT NULL DEFAULT 0, - `remainCharges` tinyint(3) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `casterGuid` BIGINT unsigned NOT NULL DEFAULT 0 COMMENT 'Full Global Unique Identifier', + `spell` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `effectMask` TINYINT unsigned NOT NULL DEFAULT 0, + `recalculateMask` TINYINT unsigned NOT NULL DEFAULT 0, + `stackCount` TINYINT unsigned NOT NULL DEFAULT 1, + `amount0` MEDIUMINT NOT NULL, + `amount1` MEDIUMINT NOT NULL, + `amount2` MEDIUMINT NOT NULL, + `base_amount0` MEDIUMINT NOT NULL, + `base_amount1` MEDIUMINT NOT NULL, + `base_amount2` MEDIUMINT NOT NULL, + `maxDuration` INT NOT NULL DEFAULT 0, + `remainTime` INT NOT NULL DEFAULT 0, + `remainCharges` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`spell`,`effectMask`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `pet_aura` WRITE; diff --git a/data/sql/base/db_characters/pet_spell.sql b/data/sql/base/db_characters/pet_spell.sql index ce2ee9564c..9f579c979f 100644 --- a/data/sql/base/db_characters/pet_spell.sql +++ b/data/sql/base/db_characters/pet_spell.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `pet_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `pet_spell` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', - `spell` mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 'Spell Identifier', - `active` tinyint(3) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier', + `spell` MEDIUMINT unsigned NOT NULL DEFAULT 0 COMMENT 'Spell Identifier', + `active` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Pet System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `pet_spell` WRITE; diff --git a/data/sql/base/db_characters/pet_spell_cooldown.sql b/data/sql/base/db_characters/pet_spell_cooldown.sql index 3fcd4b51a1..ef27ac77c9 100644 --- a/data/sql/base/db_characters/pet_spell_cooldown.sql +++ b/data/sql/base/db_characters/pet_spell_cooldown.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `pet_spell_cooldown`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `pet_spell_cooldown` ( - `guid` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part', - `spell` mediumint(8) unsigned NOT NULL DEFAULT 0 COMMENT 'Spell Identifier', - `time` int(10) unsigned NOT NULL DEFAULT 0, + `guid` INT unsigned NOT NULL DEFAULT 0 COMMENT 'Global Unique Identifier, Low part', + `spell` MEDIUMINT unsigned NOT NULL DEFAULT 0 COMMENT 'Spell Identifier', + `time` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `pet_spell_cooldown` WRITE; diff --git a/data/sql/base/db_characters/petition.sql b/data/sql/base/db_characters/petition.sql index 8cd6148bd0..e2953ce646 100644 --- a/data/sql/base/db_characters/petition.sql +++ b/data/sql/base/db_characters/petition.sql @@ -6,16 +6,16 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `petition`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `petition` ( - `ownerguid` int(10) unsigned NOT NULL, - `petitionguid` int(10) unsigned DEFAULT 0, + `ownerguid` INT unsigned NOT NULL, + `petitionguid` INT unsigned DEFAULT 0, `name` varchar(24) NOT NULL, - `type` tinyint(3) unsigned NOT NULL DEFAULT 0, + `type` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`ownerguid`,`type`), UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `petition` WRITE; diff --git a/data/sql/base/db_characters/petition_sign.sql b/data/sql/base/db_characters/petition_sign.sql index fb8c7270bf..148651bd93 100644 --- a/data/sql/base/db_characters/petition_sign.sql +++ b/data/sql/base/db_characters/petition_sign.sql @@ -6,18 +6,18 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `petition_sign`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `petition_sign` ( - `ownerguid` int(10) unsigned NOT NULL, - `petitionguid` int(10) unsigned NOT NULL DEFAULT 0, - `playerguid` int(10) unsigned NOT NULL DEFAULT 0, - `player_account` int(10) unsigned NOT NULL DEFAULT 0, - `type` tinyint(3) unsigned NOT NULL DEFAULT 0, + `ownerguid` INT unsigned NOT NULL, + `petitionguid` INT unsigned NOT NULL DEFAULT 0, + `playerguid` INT unsigned NOT NULL DEFAULT 0, + `player_account` INT unsigned NOT NULL DEFAULT 0, + `type` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`petitionguid`,`playerguid`), KEY `Idx_playerguid` (`playerguid`), KEY `Idx_ownerguid` (`ownerguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Guild System'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `petition_sign` WRITE; diff --git a/data/sql/base/db_characters/pool_quest_save.sql b/data/sql/base/db_characters/pool_quest_save.sql index 283ad5f23f..126cb2aeb1 100644 --- a/data/sql/base/db_characters/pool_quest_save.sql +++ b/data/sql/base/db_characters/pool_quest_save.sql @@ -6,13 +6,13 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `pool_quest_save`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `pool_quest_save` ( - `pool_id` int(10) unsigned NOT NULL DEFAULT 0, - `quest_id` int(10) unsigned NOT NULL DEFAULT 0, + `pool_id` INT unsigned NOT NULL DEFAULT 0, + `quest_id` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`pool_id`,`quest_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `pool_quest_save` WRITE; diff --git a/data/sql/base/db_characters/pvpstats_battlegrounds.sql b/data/sql/base/db_characters/pvpstats_battlegrounds.sql index 34f7f166bb..811127e160 100644 --- a/data/sql/base/db_characters/pvpstats_battlegrounds.sql +++ b/data/sql/base/db_characters/pvpstats_battlegrounds.sql @@ -6,13 +6,13 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `pvpstats_battlegrounds`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `pvpstats_battlegrounds` ( - `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, - `winner_faction` tinyint(4) NOT NULL, - `bracket_id` tinyint(3) unsigned NOT NULL, - `type` tinyint(3) unsigned NOT NULL, + `id` BIGINT unsigned NOT NULL AUTO_INCREMENT, + `winner_faction` TINYINT NOT NULL, + `bracket_id` TINYINT unsigned NOT NULL, + `type` TINYINT unsigned NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; diff --git a/data/sql/base/db_characters/pvpstats_players.sql b/data/sql/base/db_characters/pvpstats_players.sql index fabc983816..61c956d08e 100644 --- a/data/sql/base/db_characters/pvpstats_players.sql +++ b/data/sql/base/db_characters/pvpstats_players.sql @@ -6,23 +6,23 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `pvpstats_players`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `pvpstats_players` ( - `battleground_id` bigint(20) unsigned NOT NULL, - `character_guid` int(10) unsigned NOT NULL, + `battleground_id` BIGINT unsigned NOT NULL, + `character_guid` INT unsigned NOT NULL, `winner` bit(1) NOT NULL, - `score_killing_blows` mediumint(8) unsigned NOT NULL, - `score_deaths` mediumint(8) unsigned NOT NULL, - `score_honorable_kills` mediumint(8) unsigned NOT NULL, - `score_bonus_honor` mediumint(8) unsigned NOT NULL, - `score_damage_done` mediumint(8) unsigned NOT NULL, - `score_healing_done` mediumint(8) unsigned NOT NULL, - `attr_1` mediumint(8) unsigned NOT NULL DEFAULT 0, - `attr_2` mediumint(8) unsigned NOT NULL DEFAULT 0, - `attr_3` mediumint(8) unsigned NOT NULL DEFAULT 0, - `attr_4` mediumint(8) unsigned NOT NULL DEFAULT 0, - `attr_5` mediumint(8) unsigned NOT NULL DEFAULT 0, + `score_killing_blows` MEDIUMINT unsigned NOT NULL, + `score_deaths` MEDIUMINT unsigned NOT NULL, + `score_honorable_kills` MEDIUMINT unsigned NOT NULL, + `score_bonus_honor` MEDIUMINT unsigned NOT NULL, + `score_damage_done` MEDIUMINT unsigned NOT NULL, + `score_healing_done` MEDIUMINT unsigned NOT NULL, + `attr_1` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `attr_2` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `attr_3` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `attr_4` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `attr_5` MEDIUMINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`battleground_id`,`character_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/data/sql/base/db_characters/quest_tracker.sql b/data/sql/base/db_characters/quest_tracker.sql index 2ebefdde42..bf3f6d833e 100644 --- a/data/sql/base/db_characters/quest_tracker.sql +++ b/data/sql/base/db_characters/quest_tracker.sql @@ -6,15 +6,15 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `quest_tracker`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `quest_tracker` ( - `id` mediumint(8) unsigned NOT NULL DEFAULT 0, - `character_guid` int(10) unsigned NOT NULL DEFAULT 0, + `id` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `character_guid` INT unsigned NOT NULL DEFAULT 0, `quest_accept_time` datetime NOT NULL, `quest_complete_time` datetime DEFAULT NULL, `quest_abandon_time` datetime DEFAULT NULL, - `completed_by_gm` tinyint(1) NOT NULL DEFAULT 0, + `completed_by_gm` TINYINT NOT NULL DEFAULT 0, `core_hash` varchar(120) NOT NULL DEFAULT '0', `core_revision` varchar(120) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; diff --git a/data/sql/base/db_characters/recovery_item.sql b/data/sql/base/db_characters/recovery_item.sql index 96f6cf58b8..010bd425db 100644 --- a/data/sql/base/db_characters/recovery_item.sql +++ b/data/sql/base/db_characters/recovery_item.sql @@ -6,13 +6,13 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `recovery_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `recovery_item` ( - `Id` int(11) unsigned NOT NULL AUTO_INCREMENT, - `Guid` int(11) unsigned NOT NULL DEFAULT 0, - `ItemEntry` mediumint(8) unsigned NOT NULL DEFAULT 0, - `Count` int(11) unsigned NOT NULL DEFAULT 0, + `Id` INT unsigned NOT NULL AUTO_INCREMENT, + `Guid` INT unsigned NOT NULL DEFAULT 0, + `ItemEntry` MEDIUMINT unsigned NOT NULL DEFAULT 0, + `Count` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`Id`), KEY `idx_guid` (`Guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/data/sql/base/db_characters/reserved_name.sql b/data/sql/base/db_characters/reserved_name.sql index e146711a49..8baeb14660 100644 --- a/data/sql/base/db_characters/reserved_name.sql +++ b/data/sql/base/db_characters/reserved_name.sql @@ -6,12 +6,12 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `reserved_name`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `reserved_name` ( `name` varchar(12) NOT NULL DEFAULT '', PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player Reserved Names'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Player Reserved Names'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `reserved_name` WRITE; diff --git a/data/sql/base/db_characters/version_db_characters.sql b/data/sql/base/db_characters/version_db_characters.sql index 641b4fcc54..e1c7be4871 100644 --- a/data/sql/base/db_characters/version_db_characters.sql +++ b/data/sql/base/db_characters/version_db_characters.sql @@ -6,7 +6,7 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `version_db_characters`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `version_db_characters` ( `sql_rev` varchar(100) NOT NULL, @@ -15,7 +15,7 @@ CREATE TABLE `version_db_characters` PRIMARY KEY (`sql_rev`), KEY `required` (`required_rev`), CONSTRAINT `required` FOREIGN KEY (`required_rev`) REFERENCES `version_db_characters` (`sql_rev`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Last applied sql update to DB'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 ROW_FORMAT=DYNAMIC COMMENT='Last applied sql update to DB'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `version_db_characters` WRITE; diff --git a/data/sql/base/db_characters/warden_action.sql b/data/sql/base/db_characters/warden_action.sql index 84bc37e95f..a925d486a3 100644 --- a/data/sql/base/db_characters/warden_action.sql +++ b/data/sql/base/db_characters/warden_action.sql @@ -6,13 +6,13 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `warden_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `warden_action` ( - `wardenId` smallint(5) unsigned NOT NULL, - `action` tinyint(3) unsigned DEFAULT NULL, + `wardenId` SMALLINT unsigned NOT NULL, + `action` TINYINT unsigned DEFAULT NULL, PRIMARY KEY (`wardenId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `warden_action` WRITE; diff --git a/data/sql/base/db_characters/worldstates.sql b/data/sql/base/db_characters/worldstates.sql index 190f75bf46..e641a7ace1 100644 --- a/data/sql/base/db_characters/worldstates.sql +++ b/data/sql/base/db_characters/worldstates.sql @@ -6,14 +6,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `worldstates`; /*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; +/*!40101 SET character_set_client = UTF8MB4 */; CREATE TABLE `worldstates` ( - `entry` int(10) unsigned NOT NULL DEFAULT 0, - `value` int(10) unsigned NOT NULL DEFAULT 0, + `entry` INT unsigned NOT NULL DEFAULT 0, + `value` INT unsigned NOT NULL DEFAULT 0, `comment` tinytext DEFAULT NULL, PRIMARY KEY (`entry`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Variable Saves'; +) ENGINE=InnoDB DEFAULT CHARSET=UTF8MB4 COMMENT='Variable Saves'; /*!40101 SET character_set_client = @saved_cs_client */; LOCK TABLES `worldstates` WRITE; |