diff options
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/auth_database.sql | 121 | ||||
| -rw-r--r-- | sql/base/characters_database.sql | 161 | ||||
| -rw-r--r-- | sql/base/dev/hotfixes_database.sql | 59 | ||||
| -rw-r--r-- | sql/base/dev/world_database.sql | 407 |
4 files changed, 403 insertions, 345 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 1f5ccf9f069..e29c804468c 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -24,31 +24,31 @@ DROP TABLE IF EXISTS `account`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `account` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', - `username` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `salt` binary(32) DEFAULT NULL, `verifier` binary(32) DEFAULT NULL, `session_key_auth` binary(40) DEFAULT NULL, `session_key_bnet` varbinary(64) DEFAULT NULL, - `sha_pass_hash` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `v` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dummy value, use `verifier` instead', - `s` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dummy value, use `salt` instead', + `sha_pass_hash` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `v` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dummy value, use `verifier` instead', + `s` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dummy value, use `salt` instead', `totp_secret` varbinary(128) DEFAULT NULL, - `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `reg_mail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `reg_mail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `last_ip` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', - `last_attempt_ip` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', + `last_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', + `last_attempt_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', `failed_logins` int unsigned NOT NULL DEFAULT '0', `locked` tinyint unsigned NOT NULL DEFAULT '0', - `lock_country` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '00', + `lock_country` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '00', `last_login` timestamp NULL DEFAULT NULL, `online` tinyint unsigned NOT NULL DEFAULT '0', `expansion` tinyint unsigned NOT NULL DEFAULT '8', `mutetime` bigint NOT NULL DEFAULT '0', - `mutereason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `muteby` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `mutereason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `muteby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `locale` tinyint unsigned NOT NULL DEFAULT '0', - `os` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `os` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `recruiter` int unsigned NOT NULL DEFAULT '0', `battlenet_account` int unsigned DEFAULT NULL, `battlenet_index` tinyint unsigned DEFAULT NULL, @@ -79,7 +79,7 @@ CREATE TABLE `account_access` ( `AccountID` int unsigned NOT NULL, `SecurityLevel` tinyint unsigned NOT NULL, `RealmID` int NOT NULL DEFAULT '-1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`AccountID`,`RealmID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -104,8 +104,8 @@ CREATE TABLE `account_banned` ( `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account id', `bandate` int unsigned NOT NULL DEFAULT '0', `unbandate` int unsigned NOT NULL DEFAULT '0', - `bannedby` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, - `banreason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `bannedby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `banreason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`,`bandate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Ban List'; @@ -132,7 +132,7 @@ CREATE TABLE `account_last_played_character` ( `region` tinyint unsigned NOT NULL, `battlegroup` tinyint unsigned NOT NULL, `realmId` int unsigned DEFAULT NULL, - `characterName` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `characterName` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `characterGUID` bigint unsigned DEFAULT NULL, `lastPlayedTime` int unsigned DEFAULT NULL, PRIMARY KEY (`accountId`,`region`,`battlegroup`) @@ -159,8 +159,8 @@ CREATE TABLE `account_muted` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `mutedate` int unsigned NOT NULL DEFAULT '0', `mutetime` int unsigned NOT NULL DEFAULT '0', - `mutedby` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, - `mutereason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `mutedby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `mutereason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`guid`,`mutedate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mute List'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -185,7 +185,7 @@ CREATE TABLE `autobroadcast` ( `realmid` int NOT NULL DEFAULT '-1', `id` tinyint unsigned NOT NULL AUTO_INCREMENT, `weight` tinyint unsigned DEFAULT '1', - `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL, + `text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`,`realmid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -208,11 +208,11 @@ DROP TABLE IF EXISTS `battle_pet_declinedname`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battle_pet_declinedname` ( `guid` bigint NOT NULL, - `genitive` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `dative` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `accusative` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `instrumental` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `prepositional` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `genitive` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `dative` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `accusative` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `instrumental` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `prepositional` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`), CONSTRAINT `fk_battle_pet__battle_pet_declinedname` FOREIGN KEY (`guid`) REFERENCES `battle_pets` (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -270,7 +270,7 @@ CREATE TABLE `battle_pets` ( `health` int NOT NULL DEFAULT '1', `quality` tinyint NOT NULL DEFAULT '0', `flags` smallint NOT NULL DEFAULT '0', - `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `nameTimestamp` bigint NOT NULL DEFAULT '0', `owner` bigint DEFAULT NULL, `ownerRealmId` int DEFAULT NULL, @@ -298,8 +298,8 @@ CREATE TABLE `battlenet_account_bans` ( `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account id', `bandate` int unsigned NOT NULL DEFAULT '0', `unbandate` int unsigned NOT NULL DEFAULT '0', - `bannedby` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, - `banreason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `bannedby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `banreason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`,`bandate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Ban List'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -395,19 +395,19 @@ DROP TABLE IF EXISTS `battlenet_accounts`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battlenet_accounts` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', - `email` varchar(320) COLLATE utf8mb4_unicode_ci NOT NULL, - `sha_pass_hash` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `email` varchar(320) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `sha_pass_hash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `last_ip` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', + `last_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', `failed_logins` int unsigned NOT NULL DEFAULT '0', `locked` tinyint unsigned NOT NULL DEFAULT '0', - `lock_country` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '00', + `lock_country` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '00', `last_login` timestamp NULL DEFAULT NULL, `online` tinyint unsigned NOT NULL DEFAULT '0', `locale` tinyint unsigned NOT NULL DEFAULT '0', - `os` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `os` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `LastCharacterUndelete` int unsigned NOT NULL DEFAULT '0', - `LoginTicket` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `LoginTicket` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `LoginTicketExpiry` int unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Account System'; @@ -483,12 +483,12 @@ CREATE TABLE `build_info` ( `majorVersion` int DEFAULT NULL, `minorVersion` int DEFAULT NULL, `bugfixVersion` int DEFAULT NULL, - `hotfixVersion` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `winAuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `win64AuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `mac64AuthSeed` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `winChecksumSeed` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `macChecksumSeed` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `hotfixVersion` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `winAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `win64AuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `mac64AuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `winChecksumSeed` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `macChecksumSeed` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`build`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -635,11 +635,11 @@ DROP TABLE IF EXISTS `ip_banned`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `ip_banned` ( - `ip` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', + `ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', `bandate` int unsigned NOT NULL, `unbandate` int unsigned NOT NULL, - `bannedby` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '[Console]', - `banreason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no reason', + `bannedby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '[Console]', + `banreason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no reason', PRIMARY KEY (`ip`,`bandate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Banned IPs'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -663,7 +663,7 @@ DROP TABLE IF EXISTS `logs`; CREATE TABLE `logs` ( `time` int unsigned NOT NULL, `realm` int unsigned NOT NULL, - `type` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, + `type` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `level` tinyint unsigned NOT NULL DEFAULT '0', `string` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -691,11 +691,11 @@ CREATE TABLE `logs_ip_actions` ( `character_guid` bigint unsigned NOT NULL COMMENT 'Character Guid', `realm_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Realm ID', `type` tinyint unsigned NOT NULL, - `ip` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', - `systemnote` text COLLATE utf8mb4_unicode_ci COMMENT 'Notes inserted by system', + `ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', + `systemnote` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Notes inserted by system', `unixtime` int unsigned NOT NULL COMMENT 'Unixtime', `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp', - `comment` text COLLATE utf8mb4_unicode_ci COMMENT 'Allows users to add a comment', + `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Allows users to add a comment', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used to log ips of individual actions'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1476,7 +1476,7 @@ DROP TABLE IF EXISTS `rbac_permissions`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `rbac_permissions` ( `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Permission id', - `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Permission name', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Permission name', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Permission List'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2217,10 +2217,10 @@ DROP TABLE IF EXISTS `realmlist`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `realmlist` ( `id` int unsigned NOT NULL AUTO_INCREMENT, - `name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', - `localAddress` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', - `localSubnetMask` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '255.255.255.0', + `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', + `localAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', + `localSubnetMask` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '255.255.255.0', `port` smallint unsigned NOT NULL DEFAULT '8085', `icon` tinyint unsigned NOT NULL DEFAULT '0', `flag` tinyint unsigned NOT NULL DEFAULT '2', @@ -2255,7 +2255,7 @@ DROP TABLE IF EXISTS `secret_digest`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `secret_digest` ( `id` int unsigned NOT NULL, - `digest` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, + `digest` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2277,9 +2277,9 @@ DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates` ( - `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', - `hash` char(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', - `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', + `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', + `hash` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', + `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) @@ -2528,7 +2528,8 @@ INSERT INTO `updates` VALUES ('2021_12_31_00_auth.sql','16AA1CFB93CC42DC9CC7C0C787C64D3CE9662EE5','ARCHIVED','2022-01-02 21:18:52',0), ('2021_12_31_01_auth.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2021-12-31 15:58:32',0), ('2022_01_02_00_auth.sql','F0AF198C5F7529508A5DB1F29D153256368AD1B4','ARCHIVED','2022-01-02 21:22:35',0), -('2022_01_08_00_auth.sql','460BF77FB1751EB6B914FBA90637C8F266CCDF4D','ARCHIVED','2022-01-08 03:41:46',0); +('2022_01_08_00_auth.sql','3C9853058A77817DD62943D0332418D84CA6BDA1','ARCHIVED','2022-01-15 23:21:37',0), +('2022_01_15_00_auth.sql','11552D29BEDF73626FB8D932AB4362882964B4F0','ARCHIVED','2022-01-15 23:24:57',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2540,8 +2541,8 @@ DROP TABLE IF EXISTS `updates_include`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates_include` ( - `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', - `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', + `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', + `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2574,7 +2575,7 @@ CREATE TABLE `uptime` ( `starttime` int unsigned NOT NULL DEFAULT '0', `uptime` int unsigned NOT NULL DEFAULT '0', `maxplayers` smallint unsigned NOT NULL DEFAULT '0', - `revision` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Trinitycore', + `revision` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Trinitycore', PRIMARY KEY (`realmid`,`starttime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Uptime system'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2637,4 +2638,4 @@ SET character_set_client = @saved_cs_client; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-01-02 21:22:37 +-- Dump completed on 2022-01-15 23:25:00 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index bcb4f2c17e1..26ccf16d8e5 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -103,7 +103,7 @@ DROP TABLE IF EXISTS `arena_team`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `arena_team` ( `arenaTeamId` int unsigned NOT NULL DEFAULT '0', - `name` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `captainGuid` bigint unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', `rating` smallint unsigned NOT NULL DEFAULT '0', @@ -271,8 +271,8 @@ DROP TABLE IF EXISTS `bugreport`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `bugreport` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', - `type` longtext COLLATE utf8mb4_unicode_ci NOT NULL, - `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, + `type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Debug System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -296,8 +296,8 @@ DROP TABLE IF EXISTS `calendar_events`; CREATE TABLE `calendar_events` ( `EventID` bigint unsigned NOT NULL DEFAULT '0', `Owner` bigint unsigned NOT NULL DEFAULT '0', - `Title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `Description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `EventType` tinyint unsigned NOT NULL DEFAULT '4', `TextureID` int NOT NULL DEFAULT '-1', `Date` bigint NOT NULL DEFAULT '0', @@ -331,7 +331,7 @@ CREATE TABLE `calendar_invites` ( `Status` tinyint unsigned NOT NULL DEFAULT '0', `ResponseTime` bigint NOT NULL DEFAULT '0', `ModerationRank` tinyint unsigned NOT NULL DEFAULT '0', - `Note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`InviteID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -353,12 +353,12 @@ DROP TABLE IF EXISTS `channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `channels` ( - `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `team` int unsigned NOT NULL, `announce` tinyint unsigned NOT NULL DEFAULT '1', `ownership` tinyint unsigned NOT NULL DEFAULT '1', - `password` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `bannedList` text COLLATE utf8mb4_unicode_ci, + `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `bannedList` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `lastUsed` bigint unsigned NOT NULL, PRIMARY KEY (`name`,`team`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Channel System'; @@ -599,8 +599,8 @@ CREATE TABLE `character_banned` ( `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `bandate` bigint NOT NULL DEFAULT '0', `unbandate` bigint NOT NULL DEFAULT '0', - `bannedby` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, - `banreason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `bannedby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `banreason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`guid`,`bandate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Ban List'; @@ -679,7 +679,7 @@ DROP TABLE IF EXISTS `character_cuf_profiles`; CREATE TABLE `character_cuf_profiles` ( `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Guid', `id` tinyint unsigned NOT NULL COMMENT 'Profile Id (0-4)', - `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Profile Name', + `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Profile Name', `frameHeight` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Height', `frameWidth` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Profile Frame Width', `sortBy` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Frame Sort By', @@ -765,11 +765,11 @@ DROP TABLE IF EXISTS `character_declinedname`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_declinedname` ( `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `genitive` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `dative` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `accusative` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `instrumental` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `prepositional` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `genitive` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `dative` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `accusative` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `instrumental` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `prepositional` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -794,8 +794,8 @@ CREATE TABLE `character_equipmentsets` ( `guid` bigint unsigned NOT NULL DEFAULT '0', `setguid` bigint unsigned NOT NULL AUTO_INCREMENT, `setindex` tinyint unsigned NOT NULL DEFAULT '0', - `name` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL, - `iconname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `iconname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `ignore_mask` int unsigned NOT NULL DEFAULT '0', `AssignedSpecIndex` int NOT NULL DEFAULT '-1', `item0` bigint unsigned NOT NULL DEFAULT '0', @@ -1162,13 +1162,13 @@ CREATE TABLE `character_pet` ( `level` smallint unsigned NOT NULL DEFAULT '1', `exp` int unsigned NOT NULL DEFAULT '0', `Reactstate` tinyint unsigned NOT NULL DEFAULT '0', - `name` varchar(21) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pet', + `name` varchar(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pet', `renamed` tinyint unsigned NOT NULL DEFAULT '0', `slot` tinyint unsigned NOT NULL DEFAULT '0', `curhealth` int unsigned NOT NULL DEFAULT '1', `curmana` int unsigned NOT NULL DEFAULT '0', `savetime` int unsigned NOT NULL DEFAULT '0', - `abdata` text COLLATE utf8mb4_unicode_ci, + `abdata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `specialization` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `owner` (`owner`), @@ -1195,11 +1195,11 @@ DROP TABLE IF EXISTS `character_pet_declinedname`; CREATE TABLE `character_pet_declinedname` ( `id` int unsigned NOT NULL DEFAULT '0', `owner` int unsigned NOT NULL DEFAULT '0', - `genitive` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `dative` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `accusative` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `instrumental` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `prepositional` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `genitive` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `dative` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `accusative` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `instrumental` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `prepositional` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `owner_key` (`owner`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1524,7 +1524,7 @@ CREATE TABLE `character_social` ( `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `friend` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier', `flags` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags', - `note` varchar(48) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Friend Note', + `note` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Friend Note', PRIMARY KEY (`guid`,`friend`,`flags`), KEY `friend` (`friend`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; @@ -1702,8 +1702,8 @@ CREATE TABLE `character_transmog_outfits` ( `guid` bigint NOT NULL DEFAULT '0', `setguid` bigint NOT NULL AUTO_INCREMENT, `setindex` tinyint unsigned NOT NULL DEFAULT '0', - `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, - `iconname` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `iconname` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `ignore_mask` int NOT NULL DEFAULT '0', `appearance0` int NOT NULL DEFAULT '0', `appearance1` int NOT NULL DEFAULT '0', @@ -1758,7 +1758,7 @@ CREATE TABLE `character_void_storage` ( `fixedScalingLevel` int unsigned DEFAULT '0', `artifactKnowledgeLevel` int unsigned DEFAULT '0', `context` tinyint unsigned NOT NULL DEFAULT '0', - `bonusListIDs` text COLLATE utf8mb4_unicode_ci, + `bonusListIDs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`itemId`), UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`), KEY `idx_player` (`playerGuid`) @@ -1784,7 +1784,7 @@ DROP TABLE IF EXISTS `characters`; CREATE TABLE `characters` ( `guid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `account` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', - `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slot` tinyint unsigned NOT NULL DEFAULT '0', `race` tinyint unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', @@ -1806,7 +1806,7 @@ CREATE TABLE `characters` ( `raidDifficulty` tinyint unsigned NOT NULL DEFAULT '14', `legacyRaidDifficulty` tinyint unsigned NOT NULL DEFAULT '3', `orientation` float NOT NULL DEFAULT '0', - `taximask` text COLLATE utf8mb4_unicode_ci NOT NULL, + `taximask` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `online` tinyint unsigned NOT NULL DEFAULT '0', `createTime` bigint NOT NULL DEFAULT '0', `createMode` tinyint NOT NULL DEFAULT '0', @@ -1830,7 +1830,7 @@ CREATE TABLE `characters` ( `at_login` smallint unsigned NOT NULL DEFAULT '0', `zone` smallint unsigned NOT NULL DEFAULT '0', `death_expire_time` bigint NOT NULL DEFAULT '0', - `taxi_path` text COLLATE utf8mb4_unicode_ci, + `taxi_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `totalKills` int unsigned NOT NULL DEFAULT '0', `todayKills` smallint unsigned NOT NULL DEFAULT '0', `yesterdayKills` smallint unsigned NOT NULL DEFAULT '0', @@ -1848,12 +1848,12 @@ CREATE TABLE `characters` ( `latency` int unsigned NOT NULL DEFAULT '0', `activeTalentGroup` tinyint unsigned NOT NULL DEFAULT '0', `lootSpecId` int unsigned NOT NULL DEFAULT '0', - `exploredZones` longtext COLLATE utf8mb4_unicode_ci, - `equipmentCache` longtext COLLATE utf8mb4_unicode_ci, - `knownTitles` longtext COLLATE utf8mb4_unicode_ci, + `exploredZones` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `equipmentCache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `knownTitles` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `actionBars` tinyint unsigned NOT NULL DEFAULT '0', `deleteInfos_Account` int unsigned DEFAULT NULL, - `deleteInfos_Name` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `deleteInfos_Name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleteDate` bigint DEFAULT NULL, `honor` int unsigned NOT NULL DEFAULT '0', `honorLevel` int unsigned NOT NULL DEFAULT '1', @@ -1891,7 +1891,7 @@ CREATE TABLE `corpse` ( `orientation` float NOT NULL DEFAULT '0', `mapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `displayId` int unsigned NOT NULL DEFAULT '0', - `itemCache` text COLLATE utf8mb4_unicode_ci NOT NULL, + `itemCache` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `race` tinyint unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', `gender` tinyint unsigned NOT NULL DEFAULT '0', @@ -2021,7 +2021,7 @@ DROP TABLE IF EXISTS `gm_bug`; CREATE TABLE `gm_bug` ( `id` int unsigned NOT NULL, `playerGuid` bigint unsigned NOT NULL, - `note` text COLLATE utf8mb4_unicode_ci NOT NULL, + `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` bigint NOT NULL DEFAULT '0', `mapId` smallint unsigned NOT NULL DEFAULT '0', `posX` float NOT NULL DEFAULT '0', @@ -2030,7 +2030,7 @@ CREATE TABLE `gm_bug` ( `facing` float NOT NULL DEFAULT '0', `closedBy` bigint NOT NULL DEFAULT '0', `assignedTo` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', - `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, + `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2054,7 +2054,7 @@ DROP TABLE IF EXISTS `gm_complaint`; CREATE TABLE `gm_complaint` ( `id` int unsigned NOT NULL, `playerGuid` bigint unsigned NOT NULL, - `note` text COLLATE utf8mb4_unicode_ci NOT NULL, + `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` bigint NOT NULL DEFAULT '0', `mapId` smallint unsigned NOT NULL DEFAULT '0', `posX` float NOT NULL DEFAULT '0', @@ -2066,7 +2066,7 @@ CREATE TABLE `gm_complaint` ( `reportLineIndex` int NOT NULL, `closedBy` bigint NOT NULL DEFAULT '0', `assignedTo` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', - `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, + `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2091,7 +2091,7 @@ CREATE TABLE `gm_complaint_chatlog` ( `complaintId` int unsigned NOT NULL, `lineId` int unsigned NOT NULL, `timestamp` bigint NOT NULL, - `text` text COLLATE utf8mb4_unicode_ci NOT NULL, + `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`complaintId`,`lineId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2115,7 +2115,7 @@ DROP TABLE IF EXISTS `gm_suggestion`; CREATE TABLE `gm_suggestion` ( `id` int unsigned NOT NULL, `playerGuid` bigint unsigned NOT NULL, - `note` text COLLATE utf8mb4_unicode_ci NOT NULL, + `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` bigint NOT NULL DEFAULT '0', `mapId` smallint unsigned NOT NULL DEFAULT '0', `posX` float NOT NULL DEFAULT '0', @@ -2124,7 +2124,7 @@ CREATE TABLE `gm_suggestion` ( `facing` float NOT NULL DEFAULT '0', `closedBy` bigint NOT NULL DEFAULT '0', `assignedTo` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', - `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, + `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2238,15 +2238,15 @@ DROP TABLE IF EXISTS `guild`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guild` ( `guildid` bigint unsigned NOT NULL DEFAULT '0', - `name` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `leaderguid` bigint unsigned NOT NULL DEFAULT '0', `EmblemStyle` tinyint unsigned NOT NULL DEFAULT '0', `EmblemColor` tinyint unsigned NOT NULL DEFAULT '0', `BorderStyle` tinyint unsigned NOT NULL DEFAULT '0', `BorderColor` tinyint unsigned NOT NULL DEFAULT '0', `BackgroundColor` tinyint unsigned NOT NULL DEFAULT '0', - `info` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `motd` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `info` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `motd` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `createdate` int unsigned NOT NULL DEFAULT '0', `BankMoney` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`) @@ -2273,7 +2273,7 @@ CREATE TABLE `guild_achievement` ( `guildId` bigint unsigned NOT NULL, `achievement` int unsigned NOT NULL, `date` bigint NOT NULL DEFAULT '0', - `guids` text COLLATE utf8mb4_unicode_ci NOT NULL, + `guids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`guildId`,`achievement`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2410,9 +2410,9 @@ DROP TABLE IF EXISTS `guild_bank_tab`; CREATE TABLE `guild_bank_tab` ( `guildid` bigint unsigned NOT NULL DEFAULT '0', `TabId` tinyint unsigned NOT NULL DEFAULT '0', - `TabName` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `TabIcon` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `TabText` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `TabName` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `TabIcon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `TabText` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`guildid`,`TabId`), KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2469,8 +2469,8 @@ CREATE TABLE `guild_member` ( `guildid` bigint unsigned NOT NULL COMMENT 'Guild Identificator', `guid` bigint unsigned NOT NULL, `rank` tinyint unsigned NOT NULL, - `pnote` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `offnote` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `pnote` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `offnote` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', UNIQUE KEY `guid_key` (`guid`), KEY `guildid_key` (`guildid`), KEY `guildid_rank_key` (`guildid`,`rank`) @@ -2558,8 +2558,8 @@ DROP TABLE IF EXISTS `guild_rank`; CREATE TABLE `guild_rank` ( `guildid` bigint unsigned NOT NULL DEFAULT '0', `rid` tinyint unsigned NOT NULL, - `RankOrder` tinyint(3) unsigned NOT NULL DEFAULT '0', - `rname` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `RankOrder` tinyint unsigned NOT NULL DEFAULT '0', + `rname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `rights` int unsigned NOT NULL DEFAULT '0', `BankMoneyPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`rid`), @@ -2589,7 +2589,7 @@ CREATE TABLE `instance` ( `resettime` bigint NOT NULL DEFAULT '0', `difficulty` tinyint unsigned NOT NULL DEFAULT '0', `completedEncounters` int unsigned NOT NULL DEFAULT '0', - `data` tinytext COLLATE utf8mb4_unicode_ci NOT NULL, + `data` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `entranceId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `map` (`map`), @@ -2672,13 +2672,13 @@ CREATE TABLE `item_instance` ( `giftCreatorGuid` bigint unsigned NOT NULL DEFAULT '0', `count` int unsigned NOT NULL DEFAULT '1', `duration` int NOT NULL DEFAULT '0', - `charges` tinytext COLLATE utf8mb4_unicode_ci, + `charges` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `flags` int unsigned NOT NULL DEFAULT '0', - `enchantments` text COLLATE utf8mb4_unicode_ci NOT NULL, + `enchantments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `randomBonusListId` int unsigned NOT NULL DEFAULT '0', `durability` smallint unsigned NOT NULL DEFAULT '0', `playedTime` int unsigned NOT NULL DEFAULT '0', - `text` text COLLATE utf8mb4_unicode_ci, + `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `transmogrification` int unsigned NOT NULL DEFAULT '0', `enchantIllusion` int unsigned NOT NULL DEFAULT '0', `battlePetSpeciesId` int unsigned NOT NULL DEFAULT '0', @@ -2686,7 +2686,7 @@ CREATE TABLE `item_instance` ( `battlePetLevel` smallint unsigned NOT NULL DEFAULT '0', `battlePetDisplayId` int unsigned NOT NULL DEFAULT '0', `context` tinyint unsigned NOT NULL DEFAULT '0', - `bonusListIDs` text COLLATE utf8mb4_unicode_ci, + `bonusListIDs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System'; @@ -2879,15 +2879,15 @@ DROP TABLE IF EXISTS `item_instance_gems`; CREATE TABLE `item_instance_gems` ( `itemGuid` bigint unsigned NOT NULL, `gemItemId1` int unsigned NOT NULL DEFAULT '0', - `gemBonuses1` text COLLATE utf8mb4_unicode_ci, + `gemBonuses1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `gemContext1` tinyint unsigned NOT NULL DEFAULT '0', `gemScalingLevel1` int unsigned NOT NULL DEFAULT '0', `gemItemId2` int unsigned NOT NULL DEFAULT '0', - `gemBonuses2` text COLLATE utf8mb4_unicode_ci, + `gemBonuses2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `gemContext2` tinyint unsigned NOT NULL DEFAULT '0', `gemScalingLevel2` int unsigned NOT NULL DEFAULT '0', `gemItemId3` int unsigned NOT NULL DEFAULT '0', - `gemBonuses3` text COLLATE utf8mb4_unicode_ci, + `gemBonuses3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `gemContext3` tinyint unsigned NOT NULL DEFAULT '0', `gemScalingLevel3` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemGuid`) @@ -2986,7 +2986,7 @@ CREATE TABLE `item_loot_items` ( `needs_quest` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'quest drop', `rnd_bonus` int unsigned NOT NULL DEFAULT '0' COMMENT 'random bonus list added when originally rolled', `context` tinyint unsigned NOT NULL DEFAULT '0', - `bonus_list_ids` text COLLATE utf8mb4_unicode_ci COMMENT 'Space separated list of bonus list ids', + `bonus_list_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'Space separated list of bonus list ids', PRIMARY KEY (`container_id`,`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3057,7 +3057,7 @@ DROP TABLE IF EXISTS `item_soulbound_trade_data`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_soulbound_trade_data` ( `itemGuid` bigint unsigned NOT NULL COMMENT 'Item GUID', - `allowedPlayers` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', + `allowedPlayers` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Refund System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3109,8 +3109,8 @@ CREATE TABLE `mail` ( `mailTemplateId` smallint unsigned NOT NULL DEFAULT '0', `sender` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `receiver` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', - `subject` longtext COLLATE utf8mb4_unicode_ci, - `body` longtext COLLATE utf8mb4_unicode_ci, + `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `has_items` tinyint unsigned NOT NULL DEFAULT '0', `expire_time` bigint NOT NULL DEFAULT '0', `deliver_time` bigint NOT NULL DEFAULT '0', @@ -3301,7 +3301,7 @@ DROP TABLE IF EXISTS `petition`; CREATE TABLE `petition` ( `ownerguid` bigint unsigned NOT NULL, `petitionguid` bigint unsigned DEFAULT '0', - `name` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`ownerguid`), UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; @@ -3441,8 +3441,8 @@ CREATE TABLE `quest_tracker` ( `quest_complete_time` datetime DEFAULT NULL, `quest_abandon_time` datetime DEFAULT NULL, `completed_by_gm` tinyint(1) NOT NULL DEFAULT '0', - `core_hash` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', - `core_revision` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', + `core_hash` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', + `core_revision` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`character_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3464,7 +3464,7 @@ DROP TABLE IF EXISTS `reserved_name`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reserved_name` ( - `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player Reserved Names'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3513,9 +3513,9 @@ DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates` ( - `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', - `hash` char(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', - `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', + `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', + `hash` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', + `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) @@ -3658,7 +3658,8 @@ INSERT INTO `updates` VALUES ('2021_12_31_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2021-12-31 15:58:32',0), ('2021_12_31_02_characters.sql','C66A367F0AD7A9D6837238C21E91298413BD960C','ARCHIVED','2021-12-31 16:10:30',0), ('2022_01_02_00_characters.sql','5169A5BBACB42E6CEDE405D3C4843FD386CDF92E','ARCHIVED','2022-01-02 21:22:35',0), -('2022_01_09_00_characters.sql','3AC51F589821C17027CBA861EF762A709430CDB3','RELEASED','2022-01-09 21:29:45',0); +('2022_01_09_00_characters.sql','3AC51F589821C17027CBA861EF762A709430CDB3','ARCHIVED','2022-01-09 21:29:45',0), +('2022_01_15_00_characters.sql','884EFB6592DC8A765E0C0BF8BF907B4E4733BB0C','ARCHIVED','2022-01-15 23:24:58',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -3670,8 +3671,8 @@ DROP TABLE IF EXISTS `updates_include`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates_include` ( - `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', - `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', + `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', + `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3725,7 +3726,7 @@ DROP TABLE IF EXISTS `worldstates`; CREATE TABLE `worldstates` ( `entry` int unsigned NOT NULL DEFAULT '0', `value` int unsigned NOT NULL DEFAULT '0', - `comment` tinytext COLLATE utf8mb4_unicode_ci, + `comment` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Variable Saves'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3760,4 +3761,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-01-02 21:22:38 +-- Dump completed on 2022-01-15 23:25:01 diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 390f1df5762..6019c1f03f3 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -2174,10 +2174,10 @@ CREATE TABLE `creature` ( `DisplayIDProbability2` float NOT NULL DEFAULT '0', `DisplayIDProbability3` float NOT NULL DEFAULT '0', `DisplayIDProbability4` float NOT NULL DEFAULT '0', - `Name` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, - `FemaleName` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, - `SubName` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, - `FemaleSubName` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `FemaleName` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `SubName` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `FemaleSubName` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `Type` mediumint unsigned NOT NULL DEFAULT '0', `Family` tinyint unsigned NOT NULL DEFAULT '0', `Classification` tinyint unsigned NOT NULL DEFAULT '0', @@ -9114,6 +9114,45 @@ CREATE TABLE `ui_splash_screen_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `unit_condition` +-- + +DROP TABLE IF EXISTS `unit_condition`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `unit_condition` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `Variable1` tinyint unsigned NOT NULL DEFAULT '0', + `Variable2` tinyint unsigned NOT NULL DEFAULT '0', + `Variable3` tinyint unsigned NOT NULL DEFAULT '0', + `Variable4` tinyint unsigned NOT NULL DEFAULT '0', + `Variable5` tinyint unsigned NOT NULL DEFAULT '0', + `Variable6` tinyint unsigned NOT NULL DEFAULT '0', + `Variable7` tinyint unsigned NOT NULL DEFAULT '0', + `Variable8` tinyint unsigned NOT NULL DEFAULT '0', + `Op1` tinyint NOT NULL DEFAULT '0', + `Op2` tinyint NOT NULL DEFAULT '0', + `Op3` tinyint NOT NULL DEFAULT '0', + `Op4` tinyint NOT NULL DEFAULT '0', + `Op5` tinyint NOT NULL DEFAULT '0', + `Op6` tinyint NOT NULL DEFAULT '0', + `Op7` tinyint NOT NULL DEFAULT '0', + `Op8` tinyint NOT NULL DEFAULT '0', + `Value1` int NOT NULL DEFAULT '0', + `Value2` int NOT NULL DEFAULT '0', + `Value3` int NOT NULL DEFAULT '0', + `Value4` int NOT NULL DEFAULT '0', + `Value5` int NOT NULL DEFAULT '0', + `Value6` int NOT NULL DEFAULT '0', + `Value7` int NOT NULL DEFAULT '0', + `Value8` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `unit_power_bar` -- @@ -9191,9 +9230,9 @@ DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates` ( - `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', - `hash` char(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', - `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', + `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', + `hash` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', + `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) @@ -9208,8 +9247,8 @@ DROP TABLE IF EXISTS `updates_include`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates_include` ( - `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', - `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', + `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', + `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -9466,4 +9505,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-01-02 21:22:42 +-- Dump completed on 2022-01-15 23:25:07 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 2ff8bbe00f9..4b23b02c582 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -32,8 +32,8 @@ CREATE TABLE `access_requirement` ( `quest_done_A` int unsigned NOT NULL DEFAULT '0', `quest_done_H` int unsigned NOT NULL DEFAULT '0', `completed_achievement` int unsigned NOT NULL DEFAULT '0', - `quest_failed_text` mediumtext COLLATE utf8mb4_unicode_ci, - `comment` mediumtext COLLATE utf8mb4_unicode_ci, + `quest_failed_text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`mapId`,`difficulty`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Access Requirements'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -70,8 +70,8 @@ CREATE TABLE `achievement_reward` ( `TitleH` int unsigned NOT NULL DEFAULT '0', `ItemID` int unsigned NOT NULL DEFAULT '0', `Sender` int unsigned NOT NULL DEFAULT '0', - `Subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `Body` mediumtext COLLATE utf8mb4_unicode_ci, + `Subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `MailTemplateID` int unsigned DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=FIXED COMMENT='Loot System'; @@ -86,9 +86,9 @@ DROP TABLE IF EXISTS `achievement_reward_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `achievement_reward_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Subject` mediumtext COLLATE utf8mb4_unicode_ci, - `Body` mediumtext COLLATE utf8mb4_unicode_ci, + `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Subject` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`ID`,`Locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -119,8 +119,8 @@ CREATE TABLE `areatrigger` ( `ShapeData3` float NOT NULL DEFAULT '0', `ShapeData4` float NOT NULL DEFAULT '0', `ShapeData5` float NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`SpawnId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -151,7 +151,7 @@ CREATE TABLE `areatrigger_create_properties` ( `ShapeData3` float NOT NULL DEFAULT '0', `ShapeData4` float NOT NULL DEFAULT '0', `ShapeData5` float NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -238,7 +238,7 @@ DROP TABLE IF EXISTS `areatrigger_scripts`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `areatrigger_scripts` ( `entry` int NOT NULL, - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -252,7 +252,7 @@ DROP TABLE IF EXISTS `areatrigger_tavern`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `areatrigger_tavern` ( `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', - `name` mediumtext COLLATE utf8mb4_unicode_ci, + `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -267,7 +267,7 @@ DROP TABLE IF EXISTS `areatrigger_teleport`; CREATE TABLE `areatrigger_teleport` ( `ID` int unsigned NOT NULL DEFAULT '0', `PortLocID` int unsigned NOT NULL DEFAULT '0', - `Name` mediumtext COLLATE utf8mb4_unicode_ci, + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`ID`), FULLTEXT KEY `name` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; @@ -342,6 +342,21 @@ CREATE TABLE `battle_pet_quality` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `battlefield_template` +-- + +DROP TABLE IF EXISTS `battlefield_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `battlefield_template` ( + `TypeId` tinyint unsigned NOT NULL, + `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, + `comment` text COLLATE utf8mb4_unicode_ci, + PRIMARY KEY (`TypeId`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `battleground_template` -- @@ -354,8 +369,8 @@ CREATE TABLE `battleground_template` ( `HordeStartLoc` int unsigned NOT NULL, `StartMaxDist` float NOT NULL DEFAULT '0', `Weight` tinyint unsigned NOT NULL DEFAULT '1', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `Comment` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -389,7 +404,7 @@ CREATE TABLE `blackmarket_template` ( `minBid` bigint unsigned NOT NULL DEFAULT '0', `duration` int NOT NULL DEFAULT '0', `chance` float NOT NULL DEFAULT '0', - `bonusListIDs` mediumtext COLLATE utf8mb4_unicode_ci, + `bonusListIDs` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`marketId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -403,8 +418,8 @@ DROP TABLE IF EXISTS `character_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_template` ( `Id` int unsigned NOT NULL, - `Name` varchar(70) COLLATE utf8mb4_unicode_ci NOT NULL, - `Description` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Description` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `Level` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -449,9 +464,9 @@ DROP TABLE IF EXISTS `command`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `command` ( - `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `permission` smallint unsigned NOT NULL DEFAULT '0', - `help` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `help` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Chat System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -477,8 +492,8 @@ CREATE TABLE `conditions` ( `NegativeCondition` tinyint unsigned NOT NULL DEFAULT '0', `ErrorType` int unsigned NOT NULL DEFAULT '0', `ErrorTextId` int unsigned NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Condition System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -530,7 +545,7 @@ CREATE TABLE `conversation_template` ( `Id` int unsigned NOT NULL, `FirstLineId` int unsigned NOT NULL, `TextureKitId` int unsigned NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -549,7 +564,7 @@ CREATE TABLE `creature` ( `map` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', `areaId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Area Identifier', - `spawnDifficulties` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', + `spawnDifficulties` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `phaseUseFlags` tinyint unsigned NOT NULL DEFAULT '0', `PhaseId` int DEFAULT '0', `PhaseGroup` int DEFAULT '0', @@ -571,7 +586,7 @@ CREATE TABLE `creature` ( `unit_flags2` int unsigned NOT NULL DEFAULT '0', `unit_flags3` int unsigned NOT NULL DEFAULT '0', `dynamicflags` int unsigned NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`), KEY `idx_map` (`map`), @@ -597,7 +612,7 @@ CREATE TABLE `creature_addon` ( `movementAnimKit` smallint NOT NULL DEFAULT '0', `meleeAnimKit` smallint NOT NULL DEFAULT '0', `visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0', - `auras` mediumtext COLLATE utf8mb4_unicode_ci, + `auras` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -615,7 +630,7 @@ CREATE TABLE `creature_classlevelstats` ( `basemana` int unsigned NOT NULL DEFAULT '1', `attackpower` smallint NOT NULL DEFAULT '0', `rangedattackpower` smallint NOT NULL DEFAULT '0', - `comment` mediumtext COLLATE utf8mb4_unicode_ci, + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`level`,`class`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -680,7 +695,7 @@ CREATE TABLE `creature_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -804,7 +819,8 @@ CREATE TABLE `creature_summon_groups` ( `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `summonType` tinyint unsigned NOT NULL DEFAULT '0', - `summonTime` int unsigned NOT NULL DEFAULT '0' + `summonTime` int unsigned NOT NULL DEFAULT '0', + `Comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -822,11 +838,11 @@ CREATE TABLE `creature_template` ( `difficulty_entry_3` int unsigned NOT NULL DEFAULT '0', `KillCredit1` int unsigned NOT NULL DEFAULT '0', `KillCredit2` int unsigned NOT NULL DEFAULT '0', - `name` mediumtext COLLATE utf8mb4_unicode_ci, - `femaleName` mediumtext COLLATE utf8mb4_unicode_ci, - `subname` mediumtext COLLATE utf8mb4_unicode_ci, - `TitleAlt` mediumtext COLLATE utf8mb4_unicode_ci, - `IconName` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `femaleName` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `subname` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `TitleAlt` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `IconName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gossip_menu_id` int unsigned NOT NULL DEFAULT '0', `minlevel` smallint NOT NULL DEFAULT '1', `maxlevel` smallint NOT NULL DEFAULT '1', @@ -860,7 +876,7 @@ CREATE TABLE `creature_template` ( `VehicleId` int unsigned NOT NULL DEFAULT '0', `mingold` int unsigned NOT NULL DEFAULT '0', `maxgold` int unsigned NOT NULL DEFAULT '0', - `AIName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `AIName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `MovementType` tinyint unsigned NOT NULL DEFAULT '0', `HoverHeight` float NOT NULL DEFAULT '1', `HealthModifier` float NOT NULL DEFAULT '1', @@ -879,7 +895,7 @@ CREATE TABLE `creature_template` ( `mechanic_immune_mask` int unsigned NOT NULL DEFAULT '0', `spell_school_immune_mask` int unsigned NOT NULL DEFAULT '0', `flags_extra` int unsigned NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature System'; @@ -903,7 +919,7 @@ CREATE TABLE `creature_template_addon` ( `movementAnimKit` smallint NOT NULL DEFAULT '0', `meleeAnimKit` smallint NOT NULL DEFAULT '0', `visibilityDistanceType` tinyint unsigned NOT NULL DEFAULT '0', - `auras` mediumtext COLLATE utf8mb4_unicode_ci, + `auras` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -917,11 +933,11 @@ DROP TABLE IF EXISTS `creature_template_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_template_locale` ( `entry` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Name` mediumtext COLLATE utf8mb4_unicode_ci, - `NameAlt` mediumtext COLLATE utf8mb4_unicode_ci, - `Title` mediumtext COLLATE utf8mb4_unicode_ci, - `TitleAlt` mediumtext COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `NameAlt` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Title` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `TitleAlt` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`entry`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1025,7 +1041,7 @@ CREATE TABLE `creature_text` ( `CreatureID` int unsigned NOT NULL DEFAULT '0', `GroupID` tinyint unsigned NOT NULL DEFAULT '0', `ID` tinyint unsigned NOT NULL DEFAULT '0', - `Text` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `Type` tinyint unsigned NOT NULL DEFAULT '0', `Language` tinyint NOT NULL DEFAULT '0', `Probability` float NOT NULL DEFAULT '0', @@ -1035,7 +1051,7 @@ CREATE TABLE `creature_text` ( `SoundPlayType` tinyint unsigned NOT NULL DEFAULT '0', `BroadcastTextId` int NOT NULL DEFAULT '0', `TextRange` tinyint unsigned NOT NULL DEFAULT '0', - `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', + `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', PRIMARY KEY (`CreatureID`,`GroupID`,`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1051,8 +1067,8 @@ CREATE TABLE `creature_text_locale` ( `CreatureID` int unsigned NOT NULL DEFAULT '0', `GroupID` tinyint unsigned NOT NULL DEFAULT '0', `ID` tinyint unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Text` mediumtext COLLATE utf8mb4_unicode_ci, + `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`CreatureID`,`GroupID`,`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1085,7 +1101,7 @@ CREATE TABLE `criteria_data` ( `type` tinyint unsigned NOT NULL DEFAULT '0', `value1` int unsigned NOT NULL DEFAULT '0', `value2` int unsigned NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`criteria_id`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Achievment system'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1101,9 +1117,9 @@ CREATE TABLE `disables` ( `sourceType` int unsigned NOT NULL, `entry` int unsigned NOT NULL, `flags` smallint NOT NULL, - `params_0` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `params_1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `params_0` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `params_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`sourceType`,`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1125,7 +1141,7 @@ CREATE TABLE `disenchant_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1182,7 +1198,7 @@ CREATE TABLE `fishing_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1202,7 +1218,7 @@ CREATE TABLE `game_event` ( `length` bigint unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event', `holiday` int unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id', `holidayStage` tinyint unsigned NOT NULL DEFAULT '0', - `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the event displayed in console', + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the event displayed in console', `world_event` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0 if normal event, 1 if world event', `announce` tinyint unsigned DEFAULT '2' COMMENT '0 dont announce, 1 announce, 2 value from config', PRIMARY KEY (`eventEntry`) @@ -1250,7 +1266,7 @@ CREATE TABLE `game_event_condition` ( `req_num` float DEFAULT '0', `max_world_state_field` smallint unsigned NOT NULL DEFAULT '0', `done_world_state_field` smallint unsigned NOT NULL DEFAULT '0', - `description` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `description` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`eventEntry`,`condition_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1345,7 +1361,7 @@ CREATE TABLE `game_event_npc_vendor` ( `incrtime` int unsigned NOT NULL DEFAULT '0', `ExtendedCost` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '1', - `BonusListIDs` mediumtext COLLATE utf8mb4_unicode_ci, + `BonusListIDs` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `PlayerConditionID` int unsigned NOT NULL DEFAULT '0', `IgnoreFiltering` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`item`,`ExtendedCost`,`type`), @@ -1441,7 +1457,7 @@ CREATE TABLE `game_tele` ( `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `map` smallint unsigned NOT NULL DEFAULT '0', - `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1467,7 +1483,7 @@ CREATE TABLE `game_weather` ( `winter_rain_chance` tinyint unsigned NOT NULL DEFAULT '25', `winter_snow_chance` tinyint unsigned NOT NULL DEFAULT '25', `winter_storm_chance` tinyint unsigned NOT NULL DEFAULT '25', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`zone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Weather System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1485,7 +1501,7 @@ CREATE TABLE `gameobject` ( `map` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `zoneId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier', `areaId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Area Identifier', - `spawnDifficulties` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', + `spawnDifficulties` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `phaseUseFlags` tinyint unsigned NOT NULL DEFAULT '0', `PhaseId` int DEFAULT '0', `PhaseGroup` int DEFAULT '0', @@ -1501,7 +1517,7 @@ CREATE TABLE `gameobject` ( `spawntimesecs` int NOT NULL DEFAULT '0', `animprogress` tinyint unsigned NOT NULL DEFAULT '0', `state` tinyint unsigned NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Gameobject System'; @@ -1545,7 +1561,7 @@ CREATE TABLE `gameobject_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1620,10 +1636,10 @@ CREATE TABLE `gameobject_template` ( `entry` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', `displayId` int unsigned NOT NULL DEFAULT '0', - `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `IconName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `castBarCaption` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `unk1` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `IconName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `castBarCaption` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `unk1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `size` float NOT NULL DEFAULT '1', `Data0` int NOT NULL DEFAULT '0', `Data1` int NOT NULL DEFAULT '0', @@ -1661,8 +1677,8 @@ CREATE TABLE `gameobject_template` ( `Data33` int NOT NULL DEFAULT '0', `Data34` int NOT NULL DEFAULT '0', `ContentTuningId` int NOT NULL DEFAULT '0', - `AIName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `AIName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`entry`), KEY `idx_name` (`name`) @@ -1697,10 +1713,10 @@ DROP TABLE IF EXISTS `gameobject_template_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject_template_locale` ( `entry` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `name` mediumtext COLLATE utf8mb4_unicode_ci, - `castBarCaption` mediumtext COLLATE utf8mb4_unicode_ci, - `unk1` mediumtext COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `castBarCaption` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `unk1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`entry`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1771,7 +1787,7 @@ CREATE TABLE `gossip_menu_option` ( `MenuId` int unsigned NOT NULL DEFAULT '0', `OptionIndex` int unsigned NOT NULL DEFAULT '0', `OptionIcon` tinyint unsigned NOT NULL DEFAULT '0', - `OptionText` mediumtext COLLATE utf8mb4_unicode_ci, + `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `OptionBroadcastTextId` int unsigned NOT NULL DEFAULT '0', `OptionType` int unsigned NOT NULL DEFAULT '0', `OptionNpcFlag` bigint unsigned NOT NULL DEFAULT '0', @@ -1808,7 +1824,7 @@ CREATE TABLE `gossip_menu_option_box` ( `OptionIndex` int unsigned NOT NULL DEFAULT '0', `BoxCoded` tinyint unsigned NOT NULL DEFAULT '0', `BoxMoney` int unsigned NOT NULL DEFAULT '0', - `BoxText` mediumtext COLLATE utf8mb4_unicode_ci, + `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `BoxBroadcastTextId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`MenuId`,`OptionIndex`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1824,9 +1840,9 @@ DROP TABLE IF EXISTS `gossip_menu_option_locale`; CREATE TABLE `gossip_menu_option_locale` ( `MenuId` int unsigned NOT NULL DEFAULT '0', `OptionIndex` int unsigned NOT NULL DEFAULT '0', - `Locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `OptionText` mediumtext COLLATE utf8mb4_unicode_ci, - `BoxText` mediumtext COLLATE utf8mb4_unicode_ci, + `Locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `OptionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `BoxText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`MenuId`,`OptionIndex`,`Locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1842,7 +1858,7 @@ CREATE TABLE `graveyard_zone` ( `ID` int unsigned NOT NULL DEFAULT '0', `GhostZone` int unsigned NOT NULL DEFAULT '0', `Faction` smallint unsigned NOT NULL DEFAULT '0', - `Comment` mediumtext COLLATE utf8mb4_unicode_ci, + `Comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`ID`,`GhostZone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1889,7 +1905,7 @@ CREATE TABLE `instance_encounters` ( `creditType` tinyint unsigned NOT NULL DEFAULT '0', `creditEntry` int unsigned NOT NULL DEFAULT '0', `lastEncounterDungeon` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'If not 0, LfgDungeon.dbc entry for the instance it is last encounter in', - `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1921,7 +1937,7 @@ DROP TABLE IF EXISTS `instance_template`; CREATE TABLE `instance_template` ( `map` smallint unsigned NOT NULL, `parent` smallint unsigned NOT NULL, - `script` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `script` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`map`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1943,7 +1959,7 @@ CREATE TABLE `item_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1972,7 +1988,7 @@ DROP TABLE IF EXISTS `item_script_names`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_script_names` ( `Id` int unsigned NOT NULL, - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2099,7 +2115,7 @@ CREATE TABLE `mail_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2121,7 +2137,7 @@ CREATE TABLE `milling_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2201,7 +2217,7 @@ CREATE TABLE `npc_vendor` ( `incrtime` int unsigned NOT NULL DEFAULT '0', `ExtendedCost` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '1', - `BonusListIDs` mediumtext COLLATE utf8mb4_unicode_ci, + `BonusListIDs` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `PlayerConditionID` int unsigned NOT NULL DEFAULT '0', `IgnoreFiltering` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -2219,8 +2235,8 @@ DROP TABLE IF EXISTS `outdoorpvp_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `outdoorpvp_template` ( `TypeId` tinyint unsigned NOT NULL, - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `comment` mediumtext COLLATE utf8mb4_unicode_ci, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`TypeId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='OutdoorPvP Templates'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2234,7 +2250,7 @@ DROP TABLE IF EXISTS `page_text`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `page_text` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Text` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `NextPageID` int unsigned NOT NULL DEFAULT '0', `PlayerConditionID` int NOT NULL DEFAULT '0', `Flags` tinyint unsigned NOT NULL DEFAULT '0', @@ -2252,8 +2268,8 @@ DROP TABLE IF EXISTS `page_text_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `page_text_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Text` mediumtext COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Text` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2290,7 +2306,7 @@ DROP TABLE IF EXISTS `pet_name_generation`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pet_name_generation` ( `id` int unsigned NOT NULL, - `word` text COLLATE utf8mb4_unicode_ci NOT NULL, + `word` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `entry` int unsigned NOT NULL DEFAULT '0', `half` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) @@ -2307,7 +2323,7 @@ DROP TABLE IF EXISTS `phase_area`; CREATE TABLE `phase_area` ( `AreaId` int unsigned NOT NULL, `PhaseId` int unsigned NOT NULL, - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`AreaId`,`PhaseId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2343,7 +2359,7 @@ CREATE TABLE `pickpocketing_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2480,7 +2496,7 @@ CREATE TABLE `playerchoice` ( `ChoiceId` int NOT NULL, `UiTextureKitId` int NOT NULL DEFAULT '0', `SoundKitId` int unsigned NOT NULL DEFAULT '0', - `Question` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Question` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `HideWarboardHeader` tinyint(1) NOT NULL DEFAULT '0', `KeepOpenAfterChoice` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -2497,8 +2513,8 @@ DROP TABLE IF EXISTS `playerchoice_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `playerchoice_locale` ( `ChoiceId` int NOT NULL, - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Question` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Question` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ChoiceId`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2523,12 +2539,12 @@ CREATE TABLE `playerchoice_response` ( `SoundKitID` int unsigned NOT NULL DEFAULT '0', `GroupID` tinyint unsigned NOT NULL DEFAULT '0', `UiTextureKitID` int NOT NULL DEFAULT '0', - `Header` varchar(511) COLLATE utf8mb4_unicode_ci NOT NULL, - `SubHeader` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `ButtonTooltip` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `Answer` varchar(511) COLLATE utf8mb4_unicode_ci NOT NULL, - `Description` varchar(2047) COLLATE utf8mb4_unicode_ci NOT NULL, - `Confirmation` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL, + `Header` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `SubHeader` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ButtonTooltip` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Answer` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Description` varchar(2047) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Confirmation` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `RewardQuestID` int unsigned DEFAULT NULL, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ChoiceId`,`ResponseId`) @@ -2545,13 +2561,13 @@ DROP TABLE IF EXISTS `playerchoice_response_locale`; CREATE TABLE `playerchoice_response_locale` ( `ChoiceId` int NOT NULL, `ResponseId` int NOT NULL, - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Header` varchar(511) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `SubHeader` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `ButtonTooltip` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `Answer` varchar(511) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `Description` varchar(2047) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `Confirmation` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Header` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `SubHeader` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ButtonTooltip` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Answer` varchar(511) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Description` varchar(2047) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Confirmation` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ChoiceId`,`ResponseId`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2648,7 +2664,7 @@ CREATE TABLE `playerchoice_response_reward_item` ( `ResponseId` int NOT NULL, `Index` int unsigned NOT NULL, `ItemId` int unsigned NOT NULL DEFAULT '0', - `BonusListIDs` mediumtext COLLATE utf8mb4_unicode_ci, + `BonusListIDs` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Quantity` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ChoiceId`,`ResponseId`) @@ -2667,7 +2683,7 @@ CREATE TABLE `playerchoice_response_reward_item_choice` ( `ResponseId` int NOT NULL, `Index` int unsigned NOT NULL, `ItemId` int unsigned NOT NULL DEFAULT '0', - `BonusListIDs` mediumtext COLLATE utf8mb4_unicode_ci, + `BonusListIDs` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Quantity` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ChoiceId`,`ResponseId`) @@ -2730,9 +2746,10 @@ DROP TABLE IF EXISTS `playercreateinfo_cast_spell`; CREATE TABLE `playercreateinfo_cast_spell` ( `raceMask` bigint unsigned NOT NULL, `classMask` int unsigned NOT NULL DEFAULT '0', + `createMode` tinyint NOT NULL DEFAULT '0', `spell` int unsigned NOT NULL DEFAULT '0', - `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - PRIMARY KEY (`raceMask`,`classMask`,`spell`) + `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + PRIMARY KEY (`raceMask`,`classMask`,`createMode`,`spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2764,7 +2781,7 @@ CREATE TABLE `playercreateinfo_spell_custom` ( `racemask` bigint unsigned NOT NULL, `classmask` int unsigned NOT NULL DEFAULT '0', `Spell` int unsigned NOT NULL DEFAULT '0', - `Note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`racemask`,`classmask`,`Spell`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2784,7 +2801,7 @@ CREATE TABLE `points_of_interest` ( `Icon` int unsigned NOT NULL DEFAULT '0', `Flags` int unsigned NOT NULL DEFAULT '0', `Importance` int unsigned NOT NULL DEFAULT '0', - `Name` mediumtext COLLATE utf8mb4_unicode_ci, + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Unknown905` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) @@ -2800,8 +2817,8 @@ DROP TABLE IF EXISTS `points_of_interest_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `points_of_interest_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Name` mediumtext COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2819,7 +2836,7 @@ CREATE TABLE `pool_members` ( `spawnId` int unsigned NOT NULL, `poolSpawnId` int unsigned NOT NULL, `chance` float NOT NULL, - `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`type`,`spawnId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2834,7 +2851,7 @@ DROP TABLE IF EXISTS `pool_template`; CREATE TABLE `pool_template` ( `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry', `max_limit` int unsigned NOT NULL DEFAULT '0' COMMENT 'Max number of objects (0) is no limit', - `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2856,7 +2873,7 @@ CREATE TABLE `prospecting_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2895,7 +2912,7 @@ CREATE TABLE `quest_greeting` ( `Type` tinyint unsigned NOT NULL DEFAULT '0', `GreetEmoteType` smallint unsigned NOT NULL DEFAULT '0', `GreetEmoteDelay` int unsigned NOT NULL DEFAULT '0', - `Greeting` mediumtext COLLATE utf8mb4_unicode_ci, + `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`Type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2911,8 +2928,8 @@ DROP TABLE IF EXISTS `quest_greeting_locale`; CREATE TABLE `quest_greeting_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Greeting` mediumtext COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`type`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2950,7 +2967,7 @@ CREATE TABLE `quest_objectives` ( `Flags` int unsigned NOT NULL DEFAULT '0', `Flags2` int unsigned NOT NULL DEFAULT '0', `ProgressBarWeight` float NOT NULL DEFAULT '0', - `Description` mediumtext COLLATE utf8mb4_unicode_ci, + `Description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2965,10 +2982,10 @@ DROP TABLE IF EXISTS `quest_objectives_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_objectives_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `QuestId` int unsigned NOT NULL DEFAULT '0', `StorageIndex` tinyint NOT NULL DEFAULT '0', - `Description` mediumtext COLLATE utf8mb4_unicode_ci, + `Description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2991,7 +3008,7 @@ CREATE TABLE `quest_offer_reward` ( `EmoteDelay2` int unsigned NOT NULL DEFAULT '0', `EmoteDelay3` int unsigned NOT NULL DEFAULT '0', `EmoteDelay4` int unsigned NOT NULL DEFAULT '0', - `RewardText` mediumtext COLLATE utf8mb4_unicode_ci, + `RewardText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3006,8 +3023,8 @@ DROP TABLE IF EXISTS `quest_offer_reward_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_offer_reward_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `RewardText` mediumtext COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `RewardText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3073,7 +3090,7 @@ CREATE TABLE `quest_pool_members` ( `questId` int unsigned NOT NULL, `poolId` int unsigned NOT NULL, `poolIndex` tinyint unsigned NOT NULL COMMENT 'Multiple quests with the same index will always spawn together!', - `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`questId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3088,7 +3105,7 @@ DROP TABLE IF EXISTS `quest_pool_template`; CREATE TABLE `quest_pool_template` ( `poolId` int unsigned NOT NULL, `numActive` int unsigned NOT NULL COMMENT 'Number of indices to have active at any time', - `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`poolId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3106,7 +3123,7 @@ CREATE TABLE `quest_request_items` ( `EmoteOnIncomplete` smallint unsigned NOT NULL DEFAULT '0', `EmoteOnCompleteDelay` int unsigned NOT NULL DEFAULT '0', `EmoteOnIncompleteDelay` int unsigned NOT NULL DEFAULT '0', - `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci, + `CompletionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3121,8 +3138,8 @@ DROP TABLE IF EXISTS `quest_request_items_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_request_items_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `CompletionText` mediumtext COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `CompletionText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3284,15 +3301,15 @@ CREATE TABLE `quest_template` ( `Expansion` int NOT NULL DEFAULT '0', `ManagedWorldStateID` int NOT NULL DEFAULT '0', `QuestSessionBonus` int NOT NULL DEFAULT '0', - `LogTitle` mediumtext COLLATE utf8mb4_unicode_ci, - `LogDescription` mediumtext COLLATE utf8mb4_unicode_ci, - `QuestDescription` mediumtext COLLATE utf8mb4_unicode_ci, - `AreaDescription` mediumtext COLLATE utf8mb4_unicode_ci, - `PortraitGiverText` mediumtext COLLATE utf8mb4_unicode_ci, - `PortraitGiverName` mediumtext COLLATE utf8mb4_unicode_ci, - `PortraitTurnInText` mediumtext COLLATE utf8mb4_unicode_ci, - `PortraitTurnInName` mediumtext COLLATE utf8mb4_unicode_ci, - `QuestCompletionLog` mediumtext COLLATE utf8mb4_unicode_ci, + `LogTitle` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `LogDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `QuestDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `AreaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `PortraitGiverText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `PortraitGiverName` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `PortraitTurnInText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `PortraitTurnInName` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `QuestCompletionLog` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Quest System'; @@ -3324,7 +3341,7 @@ CREATE TABLE `quest_template_addon` ( `RequiredMaxRepValue` int NOT NULL DEFAULT '0', `ProvidedItemCount` tinyint unsigned NOT NULL DEFAULT '0', `SpecialFlags` tinyint unsigned NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3338,16 +3355,16 @@ DROP TABLE IF EXISTS `quest_template_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `quest_template_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `LogTitle` mediumtext COLLATE utf8mb4_unicode_ci, - `LogDescription` mediumtext COLLATE utf8mb4_unicode_ci, - `QuestDescription` mediumtext COLLATE utf8mb4_unicode_ci, - `AreaDescription` mediumtext COLLATE utf8mb4_unicode_ci, - `PortraitGiverText` mediumtext COLLATE utf8mb4_unicode_ci, - `PortraitGiverName` mediumtext COLLATE utf8mb4_unicode_ci, - `PortraitTurnInText` mediumtext COLLATE utf8mb4_unicode_ci, - `PortraitTurnInName` mediumtext COLLATE utf8mb4_unicode_ci, - `QuestCompletionLog` mediumtext COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `LogTitle` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `LogDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `QuestDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `AreaDescription` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `PortraitGiverText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `PortraitGiverName` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `PortraitTurnInText` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `PortraitTurnInName` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `QuestCompletionLog` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3401,7 +3418,7 @@ CREATE TABLE `reference_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3526,7 +3543,7 @@ CREATE TABLE `scene_template` ( `Flags` int unsigned NOT NULL DEFAULT '0', `ScriptPackageID` int unsigned NOT NULL DEFAULT '0', `Encrypted` tinyint unsigned NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`SceneId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3582,7 +3599,7 @@ CREATE TABLE `script_waypoint` ( `location_y` float NOT NULL DEFAULT '0', `location_z` float NOT NULL DEFAULT '0', `waittime` int unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs', - `point_comment` mediumtext COLLATE utf8mb4_unicode_ci, + `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`,`pointid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Script Creature waypoints'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3829,7 +3846,7 @@ CREATE TABLE `skinning_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3855,7 +3872,7 @@ CREATE TABLE `smart_scripts` ( `event_param3` int unsigned NOT NULL DEFAULT '0', `event_param4` int unsigned NOT NULL DEFAULT '0', `event_param5` int unsigned NOT NULL DEFAULT '0', - `event_param_string` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `event_param_string` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `action_type` tinyint unsigned NOT NULL DEFAULT '0', `action_param1` int unsigned NOT NULL DEFAULT '0', `action_param2` int unsigned NOT NULL DEFAULT '0', @@ -3872,7 +3889,7 @@ CREATE TABLE `smart_scripts` ( `target_y` float NOT NULL DEFAULT '0', `target_z` float NOT NULL DEFAULT '0', `target_o` float NOT NULL DEFAULT '0', - `comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment', + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Event Comment', PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3901,7 +3918,7 @@ DROP TABLE IF EXISTS `spawn_group_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spawn_group_template` ( `groupId` int unsigned NOT NULL, - `groupName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, + `groupName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `groupFlags` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`groupId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4014,7 +4031,7 @@ CREATE TABLE `spell_linked_spell` ( `spell_trigger` int NOT NULL, `spell_effect` int NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', - `comment` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, UNIQUE KEY `trigger_effect_type` (`spell_trigger`,`spell_effect`,`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Spell System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4036,7 +4053,7 @@ CREATE TABLE `spell_loot_template` ( `GroupId` tinyint unsigned NOT NULL DEFAULT '0', `MinCount` tinyint unsigned NOT NULL DEFAULT '1', `MaxCount` tinyint unsigned NOT NULL DEFAULT '1', - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`Entry`,`Item`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4109,7 +4126,7 @@ DROP TABLE IF EXISTS `spell_script_names`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_script_names` ( `spell_id` int NOT NULL, - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, UNIQUE KEY `spell_id` (`spell_id`,`ScriptName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4196,7 +4213,7 @@ DROP TABLE IF EXISTS `terrain_swap_defaults`; CREATE TABLE `terrain_swap_defaults` ( `MapId` int unsigned NOT NULL, `TerrainSwapMap` int unsigned NOT NULL, - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`MapId`,`TerrainSwapMap`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4211,7 +4228,7 @@ DROP TABLE IF EXISTS `terrain_worldmap`; CREATE TABLE `terrain_worldmap` ( `TerrainSwapMap` int unsigned NOT NULL, `UiMapPhaseId` int unsigned NOT NULL, - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`TerrainSwapMap`,`UiMapPhaseId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4226,7 +4243,7 @@ DROP TABLE IF EXISTS `trainer`; CREATE TABLE `trainer` ( `Id` int unsigned NOT NULL DEFAULT '0', `Type` tinyint unsigned NOT NULL DEFAULT '2', - `Greeting` mediumtext COLLATE utf8mb4_unicode_ci, + `Greeting` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4241,8 +4258,8 @@ DROP TABLE IF EXISTS `trainer_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trainer_locale` ( `Id` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Greeting_lang` mediumtext COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Greeting_lang` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`Id`,`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4280,11 +4297,11 @@ DROP TABLE IF EXISTS `transports`; CREATE TABLE `transports` ( `guid` bigint unsigned NOT NULL DEFAULT '0', `entry` int unsigned NOT NULL DEFAULT '0', - `name` mediumtext COLLATE utf8mb4_unicode_ci, + `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `phaseUseFlags` tinyint unsigned NOT NULL DEFAULT '0', `phaseid` int NOT NULL DEFAULT '0', `phasegroup` int NOT NULL DEFAULT '0', - `ScriptName` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`), UNIQUE KEY `idx_entry` (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Transports'; @@ -4299,15 +4316,15 @@ DROP TABLE IF EXISTS `trinity_string`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trinity_string` ( `entry` int unsigned NOT NULL DEFAULT '0', - `content_default` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, - `content_loc1` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc2` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc3` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc4` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc5` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc6` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc7` mediumtext COLLATE utf8mb4_unicode_ci, - `content_loc8` mediumtext COLLATE utf8mb4_unicode_ci, + `content_default` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `content_loc1` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc2` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc3` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc4` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc5` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc6` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc7` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `content_loc8` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4320,9 +4337,9 @@ DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates` ( - `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', - `hash` char(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', - `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', + `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', + `hash` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', + `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) @@ -4337,8 +4354,8 @@ DROP TABLE IF EXISTS `updates_include`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `updates_include` ( - `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', - `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', + `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', + `state` enum('RELEASED','ARCHIVED') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4355,7 +4372,7 @@ CREATE TABLE `vehicle_accessory` ( `accessory_entry` int unsigned NOT NULL DEFAULT '0', `seat_id` tinyint NOT NULL DEFAULT '0', `minion` tinyint unsigned NOT NULL DEFAULT '0', - `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `summontype` tinyint unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType', `summontimer` int unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes', PRIMARY KEY (`guid`,`seat_id`) @@ -4407,7 +4424,7 @@ CREATE TABLE `vehicle_template_accessory` ( `accessory_entry` int unsigned NOT NULL DEFAULT '0', `seat_id` tinyint NOT NULL DEFAULT '0', `minion` tinyint unsigned NOT NULL DEFAULT '0', - `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, + `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `summontype` tinyint unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType', `summontimer` int unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes', PRIMARY KEY (`entry`,`seat_id`) @@ -4422,9 +4439,9 @@ DROP TABLE IF EXISTS `version`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `version` ( - `core_version` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.', - `core_revision` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `db_version` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Version of world DB.', + `core_version` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.', + `core_revision` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `db_version` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Version of world DB.', `cache_id` int DEFAULT '0', PRIMARY KEY (`core_version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Version Notes'; @@ -4440,12 +4457,12 @@ DROP TABLE IF EXISTS `warden_checks`; CREATE TABLE `warden_checks` ( `id` smallint unsigned NOT NULL AUTO_INCREMENT, `type` tinyint unsigned DEFAULT NULL, - `data` varchar(48) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `str` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `data` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `str` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` int unsigned DEFAULT NULL, `length` tinyint unsigned DEFAULT NULL, - `result` varchar(24) COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `comment` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `result` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `comment` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=787 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4509,7 +4526,7 @@ CREATE TABLE `waypoints` ( `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', - `point_comment` mediumtext COLLATE utf8mb4_unicode_ci, + `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`,`pointid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature waypoints'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4528,7 +4545,7 @@ CREATE TABLE `world_safe_locs` ( `LocY` float DEFAULT NULL, `LocZ` float DEFAULT NULL, `Facing` float DEFAULT NULL, - `Comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `Comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -4546,4 +4563,4 @@ CREATE TABLE `world_safe_locs` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-01-02 21:22:39 +-- Dump completed on 2022-01-15 23:25:03 |