diff options
Diffstat (limited to 'sql/base/auth_database.sql')
| -rw-r--r-- | sql/base/auth_database.sql | 121 |
1 files changed, 61 insertions, 60 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 |