aboutsummaryrefslogtreecommitdiff
path: root/sql/base/auth_database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base/auth_database.sql')
-rw-r--r--sql/base/auth_database.sql461
1 files changed, 231 insertions, 230 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index e92027d02aa..bb93b5d3751 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,13 +1,13 @@
--- MySQL dump 10.13 Distrib 5.7.36, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.26, for Linux (x86_64)
--
-- Host: localhost Database: auth
-- ------------------------------------------------------
--- Server version 5.7.36
+-- Server version 8.0.26
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
-/*!40101 SET NAMES utf8mb4 */;
+/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
@@ -21,37 +21,37 @@
DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
- `username` varchar(32) NOT NULL DEFAULT '',
+ `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
+ `username` varchar(32) 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) NOT NULL DEFAULT '',
- `v` varchar(64) NOT NULL DEFAULT 'dummy value, use `verifier` instead',
- `s` varchar(64) NOT NULL DEFAULT 'dummy value, use `salt` instead',
+ `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',
`totp_secret` varbinary(128) DEFAULT NULL,
- `email` varchar(255) NOT NULL DEFAULT '',
- `reg_mail` varchar(255) NOT NULL DEFAULT '',
+ `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `reg_mail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `last_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
- `last_attempt_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
- `failed_logins` int(10) unsigned NOT NULL DEFAULT '0',
- `locked` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `lock_country` varchar(2) NOT NULL DEFAULT '00',
+ `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',
+ `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',
`last_login` timestamp NULL DEFAULT NULL,
- `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `expansion` tinyint(3) unsigned NOT NULL DEFAULT '8',
- `mutetime` bigint(20) NOT NULL DEFAULT '0',
- `mutereason` varchar(255) NOT NULL DEFAULT '',
- `muteby` varchar(50) NOT NULL DEFAULT '',
- `locale` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `os` varchar(4) NOT NULL DEFAULT '',
- `recruiter` int(10) unsigned NOT NULL DEFAULT '0',
- `battlenet_account` int(10) unsigned DEFAULT NULL,
- `battlenet_index` tinyint(3) unsigned 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 '',
+ `locale` tinyint unsigned NOT NULL DEFAULT '0',
+ `os` varchar(4) 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,
PRIMARY KEY (`id`),
UNIQUE KEY `idx_username` (`username`),
UNIQUE KEY `uk_bnet_acc` (`battlenet_account`,`battlenet_index`),
@@ -74,12 +74,12 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `account_access`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_access` (
- `AccountID` int(10) unsigned NOT NULL,
- `SecurityLevel` tinyint(3) unsigned NOT NULL,
- `RealmID` int(11) NOT NULL DEFAULT '-1',
- `Comment` varchar(255) DEFAULT NULL,
+ `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,
PRIMARY KEY (`AccountID`,`RealmID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -99,14 +99,14 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `account_banned`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_banned` (
- `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account id',
- `bandate` int(10) unsigned NOT NULL DEFAULT '0',
- `unbandate` int(10) unsigned NOT NULL DEFAULT '0',
- `bannedby` varchar(50) NOT NULL,
- `banreason` varchar(255) NOT NULL,
- `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `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,
+ `active` tinyint unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`,`bandate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Ban List';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -126,15 +126,15 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `account_last_played_character`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_last_played_character` (
- `accountId` int(10) unsigned NOT NULL,
- `region` tinyint(3) unsigned NOT NULL,
- `battlegroup` tinyint(3) unsigned NOT NULL,
- `realmId` int(10) unsigned DEFAULT NULL,
- `characterName` varchar(12) DEFAULT NULL,
- `characterGUID` bigint(20) unsigned DEFAULT NULL,
- `lastPlayedTime` int(10) unsigned DEFAULT NULL,
+ `accountId` int unsigned NOT NULL,
+ `region` tinyint unsigned NOT NULL,
+ `battlegroup` tinyint unsigned NOT NULL,
+ `realmId` int unsigned DEFAULT NULL,
+ `characterName` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+ `characterGUID` bigint unsigned DEFAULT NULL,
+ `lastPlayedTime` int unsigned DEFAULT NULL,
PRIMARY KEY (`accountId`,`region`,`battlegroup`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -154,13 +154,13 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `account_muted`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `account_muted` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
- `mutedate` int(10) unsigned NOT NULL DEFAULT '0',
- `mutetime` int(10) unsigned NOT NULL DEFAULT '0',
- `mutedby` varchar(50) NOT NULL,
- `mutereason` varchar(255) NOT NULL,
+ `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,
PRIMARY KEY (`guid`,`mutedate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='mute List';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -180,12 +180,12 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `autobroadcast`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `autobroadcast` (
- `realmid` int(11) NOT NULL DEFAULT '-1',
- `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
- `weight` tinyint(3) unsigned DEFAULT '1',
- `text` longtext NOT NULL,
+ `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,
PRIMARY KEY (`id`,`realmid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -205,14 +205,14 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `battle_pet_declinedname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battle_pet_declinedname` (
- `guid` bigint(20) NOT NULL,
- `genitive` varchar(12) NOT NULL DEFAULT '',
- `dative` varchar(12) NOT NULL DEFAULT '',
- `accusative` varchar(12) NOT NULL DEFAULT '',
- `instrumental` varchar(12) NOT NULL DEFAULT '',
- `prepositional` varchar(12) NOT NULL DEFAULT '',
+ `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 '',
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;
@@ -233,12 +233,12 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `battle_pet_slots`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battle_pet_slots` (
- `id` tinyint(3) NOT NULL,
- `battlenetAccountId` int(10) NOT NULL,
- `battlePetGuid` bigint(20) NOT NULL,
- `locked` tinyint(3) NOT NULL DEFAULT '1',
+ `id` tinyint NOT NULL,
+ `battlenetAccountId` int NOT NULL,
+ `battlePetGuid` bigint NOT NULL,
+ `locked` tinyint NOT NULL DEFAULT '1',
PRIMARY KEY (`id`,`battlenetAccountId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -258,22 +258,22 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `battle_pets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battle_pets` (
- `guid` bigint(20) NOT NULL,
- `battlenetAccountId` int(10) NOT NULL,
- `species` int(10) NOT NULL,
- `breed` smallint(5) NOT NULL,
- `displayId` int(11) NOT NULL DEFAULT '0',
- `level` smallint(5) NOT NULL DEFAULT '1',
- `exp` smallint(5) NOT NULL DEFAULT '0',
- `health` int(10) NOT NULL DEFAULT '1',
- `quality` tinyint(3) NOT NULL DEFAULT '0',
- `flags` smallint(5) NOT NULL DEFAULT '0',
- `name` varchar(12) NOT NULL,
- `nameTimestamp` bigint(20) NOT NULL DEFAULT '0',
- `owner` bigint(20) DEFAULT NULL,
- `ownerRealmId` int(11) DEFAULT NULL,
+ `guid` bigint NOT NULL,
+ `battlenetAccountId` int NOT NULL,
+ `species` int NOT NULL,
+ `breed` smallint NOT NULL,
+ `displayId` int NOT NULL DEFAULT '0',
+ `level` smallint NOT NULL DEFAULT '1',
+ `exp` smallint NOT NULL DEFAULT '0',
+ `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,
+ `nameTimestamp` bigint NOT NULL DEFAULT '0',
+ `owner` bigint DEFAULT NULL,
+ `ownerRealmId` int DEFAULT NULL,
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -293,13 +293,13 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `battlenet_account_bans`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battlenet_account_bans` (
- `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account id',
- `bandate` int(10) unsigned NOT NULL DEFAULT '0',
- `unbandate` int(10) unsigned NOT NULL DEFAULT '0',
- `bannedby` varchar(50) NOT NULL,
- `banreason` varchar(255) NOT NULL,
+ `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,
PRIMARY KEY (`id`,`bandate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Ban List';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -319,11 +319,11 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `battlenet_account_heirlooms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battlenet_account_heirlooms` (
- `accountId` int(10) unsigned NOT NULL,
- `itemId` int(11) unsigned NOT NULL DEFAULT '0',
- `flags` int(10) unsigned NOT NULL DEFAULT '0',
+ `accountId` int unsigned NOT NULL,
+ `itemId` int unsigned NOT NULL DEFAULT '0',
+ `flags` int unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`accountId`,`itemId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -343,11 +343,11 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `battlenet_account_mounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battlenet_account_mounts` (
- `battlenetAccountId` int(10) unsigned NOT NULL,
- `mountSpellId` int(10) unsigned NOT NULL,
- `flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `battlenetAccountId` int unsigned NOT NULL,
+ `mountSpellId` int unsigned NOT NULL,
+ `flags` tinyint unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`battlenetAccountId`,`mountSpellId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -367,10 +367,10 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `battlenet_account_toys`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battlenet_account_toys` (
- `accountId` int(10) unsigned NOT NULL,
- `itemId` int(11) NOT NULL DEFAULT '0',
+ `accountId` int unsigned NOT NULL,
+ `itemId` int NOT NULL DEFAULT '0',
`isFavourite` tinyint(1) DEFAULT '0',
`hasFanfare` tinyint(1) DEFAULT '0',
PRIMARY KEY (`accountId`,`itemId`)
@@ -392,23 +392,23 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `battlenet_accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battlenet_accounts` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
- `email` varchar(320) NOT NULL,
- `sha_pass_hash` varchar(64) NOT NULL DEFAULT '',
+ `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 '',
`joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `last_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
- `failed_logins` int(10) unsigned NOT NULL DEFAULT '0',
- `locked` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `lock_country` varchar(2) NOT NULL DEFAULT '00',
+ `last_ip` varchar(15) 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',
`last_login` timestamp NULL DEFAULT NULL,
- `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `locale` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `os` varchar(4) NOT NULL DEFAULT '',
- `LastCharacterUndelete` int(10) unsigned NOT NULL DEFAULT '0',
- `LoginTicket` varchar(64) DEFAULT NULL,
- `LoginTicketExpiry` int(10) unsigned 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 '',
+ `LastCharacterUndelete` int unsigned NOT NULL DEFAULT '0',
+ `LoginTicket` varchar(64) 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';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -428,11 +428,11 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `battlenet_item_appearances`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battlenet_item_appearances` (
- `battlenetAccountId` int(10) unsigned NOT NULL,
- `blobIndex` smallint(5) unsigned NOT NULL,
- `appearanceMask` int(10) unsigned NOT NULL DEFAULT '0',
+ `battlenetAccountId` int unsigned NOT NULL,
+ `blobIndex` smallint unsigned NOT NULL,
+ `appearanceMask` int unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`battlenetAccountId`,`blobIndex`),
CONSTRAINT `fk_battlenet_item_appearances` FOREIGN KEY (`battlenetAccountId`) REFERENCES `battlenet_accounts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -453,10 +453,10 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `battlenet_item_favorite_appearances`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `battlenet_item_favorite_appearances` (
- `battlenetAccountId` int(10) unsigned NOT NULL,
- `itemModifiedAppearanceId` int(10) unsigned NOT NULL,
+ `battlenetAccountId` int unsigned NOT NULL,
+ `itemModifiedAppearanceId` int unsigned NOT NULL,
PRIMARY KEY (`battlenetAccountId`,`itemModifiedAppearanceId`),
CONSTRAINT `fk_battlenet_item_favorite_appearances` FOREIGN KEY (`battlenetAccountId`) REFERENCES `battlenet_accounts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -477,18 +477,18 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `build_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `build_info` (
- `build` int(11) NOT NULL,
- `majorVersion` int(11) DEFAULT NULL,
- `minorVersion` int(11) DEFAULT NULL,
- `bugfixVersion` int(11) DEFAULT NULL,
- `hotfixVersion` char(3) DEFAULT NULL,
- `winAuthSeed` varchar(32) DEFAULT NULL,
- `win64AuthSeed` varchar(32) DEFAULT NULL,
- `mac64AuthSeed` varchar(32) DEFAULT NULL,
- `winChecksumSeed` varchar(40) DEFAULT NULL,
- `macChecksumSeed` varchar(40) DEFAULT NULL,
+ `build` int NOT NULL,
+ `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,
PRIMARY KEY (`build`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -632,13 +632,13 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `ip_banned`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ip_banned` (
- `ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
- `bandate` int(10) unsigned NOT NULL,
- `unbandate` int(10) unsigned NOT NULL,
- `bannedby` varchar(50) NOT NULL DEFAULT '[Console]',
- `banreason` varchar(255) NOT NULL DEFAULT 'no reason',
+ `ip` varchar(15) 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',
PRIMARY KEY (`ip`,`bandate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Banned IPs';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -658,13 +658,13 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `logs` (
- `time` int(10) unsigned NOT NULL,
- `realm` int(10) unsigned NOT NULL,
- `type` varchar(250) NOT NULL,
- `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `string` text CHARACTER SET latin1
+ `time` int unsigned NOT NULL,
+ `realm` int unsigned NOT NULL,
+ `type` varchar(250) 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;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -683,18 +683,18 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `logs_ip_actions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `logs_ip_actions` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier',
- `account_id` int(10) unsigned NOT NULL COMMENT 'Account ID',
- `character_guid` bigint(20) unsigned NOT NULL COMMENT 'Character Guid',
- `realm_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Realm ID',
- `type` tinyint(3) unsigned NOT NULL,
- `ip` varchar(15) NOT NULL DEFAULT '127.0.0.1',
- `systemnote` text COMMENT 'Notes inserted by system',
- `unixtime` int(10) unsigned NOT NULL COMMENT 'Unixtime',
+ `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier',
+ `account_id` int unsigned NOT NULL COMMENT 'Account ID',
+ `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',
+ `unixtime` int unsigned NOT NULL COMMENT 'Unixtime',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp',
- `comment` text COMMENT 'Allows users to add a comment',
+ `comment` text 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 */;
@@ -714,12 +714,12 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `rbac_account_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rbac_account_permissions` (
- `accountId` int(10) unsigned NOT NULL COMMENT 'Account id',
- `permissionId` int(10) unsigned NOT NULL COMMENT 'Permission id',
+ `accountId` int unsigned NOT NULL COMMENT 'Account id',
+ `permissionId` int unsigned NOT NULL COMMENT 'Permission id',
`granted` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Granted = 1, Denied = 0',
- `realmId` int(11) NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
+ `realmId` int NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
PRIMARY KEY (`accountId`,`permissionId`,`realmId`),
KEY `fk__rbac_account_roles__rbac_permissions` (`permissionId`),
CONSTRAINT `fk__rbac_account_permissions__account` FOREIGN KEY (`accountId`) REFERENCES `account` (`id`) ON DELETE CASCADE,
@@ -742,11 +742,11 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `rbac_default_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rbac_default_permissions` (
- `secId` int(10) unsigned NOT NULL COMMENT 'Security Level id',
- `permissionId` int(10) unsigned NOT NULL COMMENT 'permission id',
- `realmId` int(11) NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
+ `secId` int unsigned NOT NULL COMMENT 'Security Level id',
+ `permissionId` int unsigned NOT NULL COMMENT 'permission id',
+ `realmId` int NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
PRIMARY KEY (`secId`,`permissionId`,`realmId`),
KEY `fk__rbac_default_permissions__rbac_permissions` (`permissionId`),
CONSTRAINT `fk__rbac_default_permissions__rbac_permissions` FOREIGN KEY (`permissionId`) REFERENCES `rbac_permissions` (`id`)
@@ -773,10 +773,10 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `rbac_linked_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rbac_linked_permissions` (
- `id` int(10) unsigned NOT NULL COMMENT 'Permission id',
- `linkedId` int(10) unsigned NOT NULL COMMENT 'Linked Permission id',
+ `id` int unsigned NOT NULL COMMENT 'Permission id',
+ `linkedId` int unsigned NOT NULL COMMENT 'Linked Permission id',
PRIMARY KEY (`id`,`linkedId`),
KEY `fk__rbac_linked_permissions__rbac_permissions1` (`id`),
KEY `fk__rbac_linked_permissions__rbac_permissions2` (`linkedId`),
@@ -1472,10 +1472,10 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `rbac_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rbac_permissions` (
- `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Permission id',
- `name` varchar(100) NOT NULL COMMENT 'Permission name',
+ `id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Permission id',
+ `name` varchar(100) 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 */;
@@ -1494,8 +1494,8 @@ INSERT INTO `rbac_permissions` VALUES
(5,'Join Arenas'),
(6,'Join Dungeon Finder'),
(7,'Skip idle connection check'),
-(8,"Cannot earn achievements"),
-(9,"Cannot earn realm first achievements"),
+(8,'Cannot earn achievements'),
+(9,'Cannot earn realm first achievements'),
(10,'Use character templates'),
(11,'Log GM trades'),
(12,'Skip character creation demon hunter min level check'),
@@ -2188,11 +2188,11 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `realmcharacters`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `realmcharacters` (
- `realmid` int(10) unsigned NOT NULL DEFAULT '0',
- `acctid` int(10) unsigned NOT NULL,
- `numchars` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `realmid` int unsigned NOT NULL DEFAULT '0',
+ `acctid` int unsigned NOT NULL,
+ `numchars` tinyint unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`realmid`,`acctid`),
KEY `acctid` (`acctid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Realm Character Tracker';
@@ -2213,22 +2213,22 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `realmlist`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `realmlist` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(32) NOT NULL DEFAULT '',
- `address` varchar(255) NOT NULL DEFAULT '127.0.0.1',
- `localAddress` varchar(255) NOT NULL DEFAULT '127.0.0.1',
- `localSubnetMask` varchar(255) NOT NULL DEFAULT '255.255.255.0',
- `port` smallint(5) unsigned NOT NULL DEFAULT '8085',
- `icon` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `flag` tinyint(3) unsigned NOT NULL DEFAULT '2',
- `timezone` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `allowedSecurityLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `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',
+ `port` smallint unsigned NOT NULL DEFAULT '8085',
+ `icon` tinyint unsigned NOT NULL DEFAULT '0',
+ `flag` tinyint unsigned NOT NULL DEFAULT '2',
+ `timezone` tinyint unsigned NOT NULL DEFAULT '0',
+ `allowedSecurityLevel` tinyint unsigned NOT NULL DEFAULT '0',
`population` float unsigned NOT NULL DEFAULT '0',
- `gamebuild` int(10) unsigned NOT NULL DEFAULT '41488',
- `Region` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `Battlegroup` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `gamebuild` int unsigned NOT NULL DEFAULT '41488',
+ `Region` tinyint unsigned NOT NULL DEFAULT '1',
+ `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Realm System';
@@ -2251,10 +2251,10 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `secret_digest`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `secret_digest` (
- `id` int(10) unsigned NOT NULL,
- `digest` varchar(100) NOT NULL,
+ `id` int unsigned NOT NULL,
+ `digest` varchar(100) 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 */;
@@ -2274,13 +2274,13 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `updates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `updates` (
- `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.',
- `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.',
- `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.',
+ `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.',
+ `hash` char(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.',
+ `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.',
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.',
- `speed` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.',
+ `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.',
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of all applied updates in this database.';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2298,8 +2298,8 @@ INSERT INTO `updates` VALUES
('2014_11_03_00_auth.sql','5948C9F286CF0FEA8E241785C0259FF36B73BDC5','ARCHIVED','2015-03-21 16:55:52',0),
('2014_11_04_00_auth.sql','3AFC68B2375C2A417DDEA94583C53AFF83DE50DF','ARCHIVED','2015-03-21 16:55:52',0),
('2014_11_09_00_auth.sql','B8DD1A7047C0FDDB80344B239343EC33BF1A0D97','ARCHIVED','2015-03-21 16:55:52',0),
-('2014_11_10_00_auth.sql','8FBA737A1D3FF4631A1E662A5B500A8BD304EC63','ARCHIVED','2015-03-21 16:55:52',0),
('2014_11_10_00_auth_from_335.sql','0E3CB119442D09DD88E967015319BBC8DAFBBFE0','ARCHIVED','2014-11-10 00:00:00',0),
+('2014_11_10_00_auth.sql','8FBA737A1D3FF4631A1E662A5B500A8BD304EC63','ARCHIVED','2015-03-21 16:55:52',0),
('2014_11_10_01_auth.sql','327E77A1DA3546D5275AB249915DD57EDD6FDD3D','ARCHIVED','2014-11-10 00:00:01',0),
('2014_11_23_00_auth.sql','0BBEB3EB3AED0FEF277A062819B6B2C00084A742','ARCHIVED','2015-03-21 16:55:52',0),
('2014_11_25_00_auth.sql','4F45CDB26BDBB3EE83F1988E3D7818C5926ADC02','ARCHIVED','2015-03-21 16:55:52',0),
@@ -2313,10 +2313,10 @@ INSERT INTO `updates` VALUES
('2015_02_22_00_auth.sql','21CCCF8B01252E16CA3D6C9E3E8DAA4C9B28ED6E','ARCHIVED','2015-03-21 16:55:52',0),
('2015_03_01_00_auth.sql','911881E273207FF6182D1FDAC8C85FFAE8F1C852','ARCHIVED','2015-03-21 16:55:52',0),
('2015_03_10_00_auth.sql','2CC8502C11412EFEB5C11BE166761A8754A59009','ARCHIVED','2015-03-21 16:55:52',0),
+('2015_03_15_00_auth.sql','1D8E107FBEFE5E7F47E09F45240DFF499B77CDED','ARCHIVED','2015-05-02 13:57:57',0),
('2015_03_20_00_auth.sql','B761760804EA73BD297F296C5C1919687DF7191C','ARCHIVED','2015-03-21 16:55:52',0),
('2015_03_20_01_auth.sql','5CCEDF20C8189FB1E8DF064A9F0DDC342841FBF0','ARCHIVED','2015-03-21 16:55:52',0),
('2015_03_20_02_auth.sql','85E4ACD9AA099C0C4AC034575F2BB07D348EAC72','ARCHIVED','2015-03-21 16:56:46',0),
-('2015_03_15_00_auth.sql','1D8E107FBEFE5E7F47E09F45240DFF499B77CDED','ARCHIVED','2015-05-02 13:57:57',0),
('2015_03_26_00_auth.sql','34AC8543E6A9C6C832DE58EAB33618EEEF70B9F9','ARCHIVED','2015-05-02 13:57:57',0),
('2015_04_04_00_auth.sql','57146B35E54A2EC7869C945034AB078358020311','ARCHIVED','2015-05-02 13:57:57',0),
('2015_04_06_00_auth.sql','2A8049DC2923420A002D42FB6F02C2FFCC5CDD22','ARCHIVED','2015-05-02 13:57:57',0),
@@ -2395,14 +2395,14 @@ INSERT INTO `updates` VALUES
('2017_05_14_00_auth.sql','B7E76CCDCC9A2C8103427DA4C43C7B0366ECE8B4','ARCHIVED','2017-05-14 12:00:00',0),
('2017_06_12_01_auth.sql','661B4935E101AF188BEBF43203144104E89F8C54','ARCHIVED','2017-06-12 00:00:01',0),
('2017_06_12_02_auth.sql','166F059E411FAA4901BBBA09A41EF07B1CADC4B6','ARCHIVED','2017-06-12 00:00:02',0),
-('2017_06_17_00_auth.sql','4A172895CB9DA8EFE1270434D6ECB22D4F4DCB17','ARCHIVED','2017-06-17 00:00:00',0),
('2017_06_15_00_auth.sql','DD71F25C1E61FD5F836931B02703BE3BD1B4F156','ARCHIVED','2017-06-15 15:20:50',0),
+('2017_06_17_00_auth.sql','4A172895CB9DA8EFE1270434D6ECB22D4F4DCB17','ARCHIVED','2017-06-17 00:00:00',0),
('2017_06_18_00_auth.sql','7200968BFC2D76499149937B19F2153FD2ABC397','ARCHIVED','2017-06-18 22:13:37',0),
('2017_06_25_00_auth.sql','A2DA6A64D4217992EF766915DEBD517DB0834E01','ARCHIVED','2017-06-25 00:54:10',0),
('2017_06_28_00_auth_master.sql','6E58300D4D4DAAEE89107ECB3CB7DA8529DA738F','ARCHIVED','2017-06-28 19:11:09',0),
('2017_06_28_00_auth_rbac.sql','D32EF80F57F629C23395D80F06E91D7E40719F83','ARCHIVED','2017-06-28 00:00:00',0),
-('2017_08_01_00_auth.sql','6ECE808AF52345177189E962C0606B769B6806A6','ARCHIVED','2017-08-01 00:00:00',0),
('2017_06_30_00_auth.sql','C73BD277D211DBE1BB86BB1B443CA8F292D8ADEE','ARCHIVED','2017-06-30 16:18:51',0),
+('2017_08_01_00_auth.sql','6ECE808AF52345177189E962C0606B769B6806A6','ARCHIVED','2017-08-01 00:00:00',0),
('2017_08_04_00_auth.sql','2E994A704C64FECE3CE0883ED0CAC5E5A0E3A36C','ARCHIVED','2017-08-04 23:46:32',0),
('2017_08_13_00_auth_2016_09_22_00_auth.sql','70047954E3556BFA430ADD5680EF8797F74A4B9E','ARCHIVED','2017-08-13 12:00:00',0),
('2017_09_22_00_auth.sql','9313CCE80A18212E6F0C78D83316DE8582AE8084','ARCHIVED','2017-09-22 18:05:17',0),
@@ -2445,7 +2445,7 @@ INSERT INTO `updates` VALUES
('2019_07_16_00_auth.sql','36CB53A9EBD64BFDCF7030083E36E534F1753773','ARCHIVED','2019-07-16 00:00:00',0),
('2019_07_17_00_auth.sql','4F983F039904894ACC483BE885676C5F0A18F06B','ARCHIVED','2019-07-17 00:00:00',0),
('2019_07_26_00_auth.sql','DC9D0651602AE78B1243B40555A1A7B8447D01B2','ARCHIVED','2019-07-26 18:21:34',0),
-('2019_08_10_00_auth.sql','E936802893474BB9B459D01BB5F181F54EDF0653','ARCHIVED','2019-08-10 00:00:00',0),
+('2019_08_10_00_auth.sql','3568A1C9C6D62BBCD470C0623C1580E332D545D2','ARCHIVED','2022-01-02 21:18:52',0),
('2019_08_10_01_auth.sql','C58357260F0C70DA226A71F7E05DE2C49AAEFD74','ARCHIVED','2019-08-10 00:00:00',0),
('2019_08_11_00_auth.sql','04DCC2ABDA15BC7C015E8BFEA383C62A362B166F','ARCHIVED','2019-08-11 10:56:39',0),
('2019_08_18_00_auth.sql','0479A04B669A67D2E5A498CFB91507E742EFB34F','ARCHIVED','2019-08-17 11:51:02',0),
@@ -2517,15 +2517,16 @@ INSERT INTO `updates` VALUES
('2021_11_10_00_auth.sql','EB3D26EFD3109BC17447B3BAC7573473F5103F65','ARCHIVED','2021-11-10 14:07:05',0),
('2021_11_12_00_auth.sql','012C088794362FE57BAEA0C3BD05356B40289028','ARCHIVED','2021-11-12 12:17:24',0),
('2021_11_17_00_auth.sql','298DA8468B30042B15FA17A90325C72879DF6D8E','ARCHIVED','2021-11-17 13:23:17',0),
-('2021_11_19_00_auth.sql','BE4F77E254D76A59DBF28B2CEEA5CAF6777B650E','RELEASED','2021-11-19 00:37:56',0),
-('2021_11_20_00_auth.sql','E476B6DAD9C47FC81E1DA5016DC79AB527F1847A','RELEASED','2021-11-20 18:40:53',0),
-('2021_11_25_00_auth.sql','7A01CEB201CB825BFD565BBF5EED0162BEA733E7','RELEASED','2021-11-25 19:32:21',0),
-('2021_12_02_00_auth.sql','ED40A45A8F5E5B1BB68216A3053D721B3BA3A556','RELEASED','2021-12-02 11:48:11',0),
-('2021_12_04_00_auth.sql','00C4A37A60F53A5E893CAADAC882E5A28375A4D2','RELEASED','2021-12-04 12:49:04',0),
-('2021_12_08_00_auth.sql','9B1A7C86F56159CA50A45B9CB4BC6422A3378231','RELEASED','2021-12-08 00:28:19',0),
-('2021_12_16_00_auth.sql','EF5050D779CC6CEAAFB4C7E0CFA26824D92B675E','RELEASED','2021-12-16 12:21:11',0),
-('2021_12_31_00_auth.sql','1C79640D7A4626EACE1FCE2192206595ADF34CA0','RELEASED','2021-12-31 13:23:04',0),
-('2021_12_31_01_auth.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','RELEASED','2021-12-31 15:58:32',0);
+('2021_11_19_00_auth.sql','BE4F77E254D76A59DBF28B2CEEA5CAF6777B650E','ARCHIVED','2021-11-19 00:37:56',0),
+('2021_11_20_00_auth.sql','E476B6DAD9C47FC81E1DA5016DC79AB527F1847A','ARCHIVED','2021-11-20 18:40:53',0),
+('2021_11_25_00_auth.sql','7A01CEB201CB825BFD565BBF5EED0162BEA733E7','ARCHIVED','2021-11-25 19:32:21',0),
+('2021_12_02_00_auth.sql','ED40A45A8F5E5B1BB68216A3053D721B3BA3A556','ARCHIVED','2021-12-02 11:48:11',0),
+('2021_12_04_00_auth.sql','00C4A37A60F53A5E893CAADAC882E5A28375A4D2','ARCHIVED','2021-12-04 12:49:04',0),
+('2021_12_08_00_auth.sql','9B1A7C86F56159CA50A45B9CB4BC6422A3378231','ARCHIVED','2021-12-08 00:28:19',0),
+('2021_12_16_00_auth.sql','EF5050D779CC6CEAAFB4C7E0CFA26824D92B675E','ARCHIVED','2021-12-16 12:21:11',0),
+('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);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2535,10 +2536,10 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `updates_include`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `updates_include` (
- `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
- `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
+ `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
+ `state` enum('RELEASED','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
PRIMARY KEY (`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2550,12 +2551,12 @@ CREATE TABLE `updates_include` (
LOCK TABLES `updates_include` WRITE;
/*!40000 ALTER TABLE `updates_include` DISABLE KEYS */;
INSERT INTO `updates_include` VALUES
-('$/sql/updates/auth','RELEASED'),
('$/sql/custom/auth','RELEASED'),
('$/sql/old/6.x/auth','ARCHIVED'),
('$/sql/old/7/auth','ARCHIVED'),
('$/sql/old/8.x/auth','ARCHIVED'),
-('$/sql/old/9.x/auth','ARCHIVED');
+('$/sql/old/9.x/auth','ARCHIVED'),
+('$/sql/updates/auth','RELEASED');
/*!40000 ALTER TABLE `updates_include` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2565,13 +2566,13 @@ UNLOCK TABLES;
DROP TABLE IF EXISTS `uptime`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8mb4 */;
+/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `uptime` (
- `realmid` int(10) unsigned NOT NULL,
- `starttime` int(10) unsigned NOT NULL DEFAULT '0',
- `uptime` int(10) unsigned NOT NULL DEFAULT '0',
- `maxplayers` smallint(5) unsigned NOT NULL DEFAULT '0',
- `revision` varchar(255) NOT NULL DEFAULT 'Trinitycore',
+ `realmid` int unsigned NOT NULL,
+ `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',
PRIMARY KEY (`realmid`,`starttime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Uptime system';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2586,13 +2587,13 @@ LOCK TABLES `uptime` WRITE;
UNLOCK TABLES;
--
--- Temporary table structure for view `vw_log_history`
+-- Temporary view structure for view `vw_log_history`
--
DROP TABLE IF EXISTS `vw_log_history`;
/*!50001 DROP VIEW IF EXISTS `vw_log_history`*/;
SET @saved_cs_client = @@character_set_client;
-SET character_set_client = utf8mb4;
+/*!50503 SET character_set_client = utf8mb4 */;
/*!50001 CREATE VIEW `vw_log_history` AS SELECT
1 AS `First Logged`,
1 AS `Last Logged`,
@@ -2604,6 +2605,10 @@ SET character_set_client = utf8mb4;
SET character_set_client = @saved_cs_client;
--
+-- Dumping routines for database 'auth'
+--
+
+--
-- Final view structure for view `vw_log_history`
--
@@ -2616,14 +2621,10 @@ SET character_set_client = @saved_cs_client;
/*!50001 SET collation_connection = utf8mb4_unicode_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 */
-/*!50001 VIEW `vw_log_history` AS (select from_unixtime(min(`logs`.`time`)) AS `First Logged`,from_unixtime(max(`logs`.`time`)) AS `Last Logged`,count(0) AS `Occurrences`,`realmlist`.`name` AS `Realm`,`logs`.`type` AS `type`,`logs`.`level` AS `level`,`logs`.`string` AS `string` from (`logs` left join `realmlist` on((`logs`.`realm` = `realmlist`.`id`))) group by `logs`.`string`,`logs`.`type`,`logs`.`realm`) */;
+/*!50001 VIEW `vw_log_history` AS select from_unixtime(min(`logs`.`time`)) AS `First Logged`,from_unixtime(max(`logs`.`time`)) AS `Last Logged`,count(0) AS `Occurrences`,`realmlist`.`name` AS `Realm`,`logs`.`type` AS `type`,`logs`.`level` AS `level`,`logs`.`string` AS `string` from (`logs` left join `realmlist` on((`logs`.`realm` = `realmlist`.`id`))) group by `logs`.`string`,`logs`.`type`,`logs`.`realm` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
-
---
--- Dumping routines for database 'auth'
---
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
@@ -2634,4 +2635,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 2021-11-17 13:23:18
+-- Dump completed on 2022-01-02 21:22:37