summaryrefslogtreecommitdiff
path: root/data/sql/base/db_auth
diff options
context:
space:
mode:
authorKitzunu <24550914+Kitzunu@users.noreply.github.com>2024-01-20 17:17:44 +0100
committerGitHub <noreply@github.com>2024-01-20 17:17:44 +0100
commit7f7f18e48906959460171e05733baa736a730048 (patch)
treedf58913a65fc2355a3f3d888876b2c792f720fb1 /data/sql/base/db_auth
parentf60fb6307dc674e14190c08d12a3d71d8219b851 (diff)
feat(DB): Release ACDB 10.0.0 (#18197)
* move archived files into old dir * auth * characters * world * mistake * revert some stuff * Squash time! * newline
Diffstat (limited to 'data/sql/base/db_auth')
-rw-r--r--data/sql/base/db_auth/account.sql22
-rw-r--r--data/sql/base/db_auth/account_access.sql6
-rw-r--r--data/sql/base/db_auth/account_banned.sql8
-rw-r--r--data/sql/base/db_auth/account_muted.sql8
-rw-r--r--data/sql/base/db_auth/autobroadcast.sql6
-rw-r--r--data/sql/base/db_auth/build_info.sql16
-rw-r--r--data/sql/base/db_auth/ip_banned.sql10
-rw-r--r--data/sql/base/db_auth/logs.sql8
-rw-r--r--data/sql/base/db_auth/logs_ip_actions.sql10
-rw-r--r--data/sql/base/db_auth/motd.sql6
-rw-r--r--data/sql/base/db_auth/realmcharacters.sql4
-rw-r--r--data/sql/base/db_auth/realmlist.sql14
-rw-r--r--data/sql/base/db_auth/secret_digest.sql6
-rw-r--r--data/sql/base/db_auth/updates.sql49
-rw-r--r--data/sql/base/db_auth/updates_include.sql8
-rw-r--r--data/sql/base/db_auth/uptime.sql13
16 files changed, 82 insertions, 112 deletions
diff --git a/data/sql/base/db_auth/account.sql b/data/sql/base/db_auth/account.sql
index bcc077b9a9..4b846b818a 100644
--- a/data/sql/base/db_auth/account.sql
+++ b/data/sql/base/db_auth/account.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -18,27 +18,27 @@
DROP TABLE IF EXISTS `account`;
CREATE TABLE IF NOT EXISTS `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) NOT NULL,
`verifier` binary(32) NOT NULL,
`session_key` binary(40) DEFAULT NULL,
`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` int unsigned NOT NULL DEFAULT '0',
`expansion` tinyint unsigned NOT NULL DEFAULT '2',
`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(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
+ `os` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`recruiter` int unsigned NOT NULL DEFAULT '0',
`totaltime` int unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
diff --git a/data/sql/base/db_auth/account_access.sql b/data/sql/base/db_auth/account_access.sql
index 0a56021dc7..1d406b973c 100644
--- a/data/sql/base/db_auth/account_access.sql
+++ b/data/sql/base/db_auth/account_access.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `account_access` (
`id` int unsigned NOT NULL,
`gmlevel` tinyint unsigned NOT NULL,
`RealmID` int NOT NULL DEFAULT '-1',
- `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
+ `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
PRIMARY KEY (`id`,`RealmID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
diff --git a/data/sql/base/db_auth/account_banned.sql b/data/sql/base/db_auth/account_banned.sql
index 06e07bfd70..2fe1f7ecbf 100644
--- a/data/sql/base/db_auth/account_banned.sql
+++ b/data/sql/base/db_auth/account_banned.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -20,8 +20,8 @@ CREATE TABLE IF NOT EXISTS `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';
diff --git a/data/sql/base/db_auth/account_muted.sql b/data/sql/base/db_auth/account_muted.sql
index 00f37282e9..fa5db5d239 100644
--- a/data/sql/base/db_auth/account_muted.sql
+++ b/data/sql/base/db_auth/account_muted.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -20,8 +20,8 @@ CREATE TABLE IF NOT EXISTS `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';
diff --git a/data/sql/base/db_auth/autobroadcast.sql b/data/sql/base/db_auth/autobroadcast.sql
index 0037e072c2..b908026c33 100644
--- a/data/sql/base/db_auth/autobroadcast.sql
+++ b/data/sql/base/db_auth/autobroadcast.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `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;
diff --git a/data/sql/base/db_auth/build_info.sql b/data/sql/base/db_auth/build_info.sql
index f38038b8d2..a1277492bb 100644
--- a/data/sql/base/db_auth/build_info.sql
+++ b/data/sql/base/db_auth/build_info.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -21,12 +21,12 @@ CREATE TABLE IF NOT EXISTS `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;
diff --git a/data/sql/base/db_auth/ip_banned.sql b/data/sql/base/db_auth/ip_banned.sql
index 72320b5287..d466ca2002 100644
--- a/data/sql/base/db_auth/ip_banned.sql
+++ b/data/sql/base/db_auth/ip_banned.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -17,11 +17,11 @@
-- Dumping structure for table acore_auth.ip_banned
DROP TABLE IF EXISTS `ip_banned`;
CREATE TABLE IF NOT EXISTS `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';
diff --git a/data/sql/base/db_auth/logs.sql b/data/sql/base/db_auth/logs.sql
index 770e8f4840..f616085c98 100644
--- a/data/sql/base/db_auth/logs.sql
+++ b/data/sql/base/db_auth/logs.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -19,9 +19,9 @@ DROP TABLE IF EXISTS `logs`;
CREATE TABLE IF NOT EXISTS `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` text COLLATE utf8mb4_unicode_ci
+ `string` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Dumping data for table acore_auth.logs: ~0 rows (approximately)
diff --git a/data/sql/base/db_auth/logs_ip_actions.sql b/data/sql/base/db_auth/logs_ip_actions.sql
index 25d05602d1..ba5c87bb36 100644
--- a/data/sql/base/db_auth/logs_ip_actions.sql
+++ b/data/sql/base/db_auth/logs_ip_actions.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -21,11 +21,11 @@ CREATE TABLE IF NOT EXISTS `logs_ip_actions` (
`account_id` int unsigned NOT NULL COMMENT 'Account ID',
`character_guid` int unsigned NOT NULL COMMENT 'Character Guid',
`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';
diff --git a/data/sql/base/db_auth/motd.sql b/data/sql/base/db_auth/motd.sql
index a88d71b5e9..ac5066cbce 100644
--- a/data/sql/base/db_auth/motd.sql
+++ b/data/sql/base/db_auth/motd.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -18,7 +18,7 @@
DROP TABLE IF EXISTS `motd`;
CREATE TABLE IF NOT EXISTS `motd` (
`realmid` int NOT NULL,
- `text` longtext COLLATE utf8mb4_unicode_ci,
+ `text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`realmid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
diff --git a/data/sql/base/db_auth/realmcharacters.sql b/data/sql/base/db_auth/realmcharacters.sql
index 1ff24de8d9..127806fbbc 100644
--- a/data/sql/base/db_auth/realmcharacters.sql
+++ b/data/sql/base/db_auth/realmcharacters.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
diff --git a/data/sql/base/db_auth/realmlist.sql b/data/sql/base/db_auth/realmlist.sql
index c9699dbeed..d7da2e52af 100644
--- a/data/sql/base/db_auth/realmlist.sql
+++ b/data/sql/base/db_auth/realmlist.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -18,10 +18,10 @@
DROP TABLE IF EXISTS `realmlist`;
CREATE TABLE IF NOT EXISTS `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',
@@ -34,7 +34,7 @@ CREATE TABLE IF NOT EXISTS `realmlist` (
CONSTRAINT `realmlist_chk_1` CHECK ((`population` >= 0))
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Realm System';
--- Dumping data for table acore_auth.realmlist: ~0 rows (approximately)
+-- Dumping data for table acore_auth.realmlist: ~1 rows (approximately)
DELETE FROM `realmlist`;
INSERT INTO `realmlist` (`id`, `name`, `address`, `localAddress`, `localSubnetMask`, `port`, `icon`, `flag`, `timezone`, `allowedSecurityLevel`, `population`, `gamebuild`) VALUES
(1, 'AzerothCore', '127.0.0.1', '127.0.0.1', '255.255.255.0', 8085, 0, 0, 1, 0, 0, 12340);
diff --git a/data/sql/base/db_auth/secret_digest.sql b/data/sql/base/db_auth/secret_digest.sql
index aab9825bd4..a03ea9a464 100644
--- a/data/sql/base/db_auth/secret_digest.sql
+++ b/data/sql/base/db_auth/secret_digest.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -18,7 +18,7 @@
DROP TABLE IF EXISTS `secret_digest`;
CREATE TABLE IF NOT EXISTS `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;
diff --git a/data/sql/base/db_auth/updates.sql b/data/sql/base/db_auth/updates.sql
index 48205bcfdf..d2a1985a77 100644
--- a/data/sql/base/db_auth/updates.sql
+++ b/data/sql/base/db_auth/updates.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -17,52 +17,19 @@
-- Dumping structure for table acore_auth.updates
DROP TABLE IF EXISTS `updates`;
CREATE TABLE IF NOT EXISTS `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','CUSTOM','MODULE','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','CUSTOM','MODULE','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`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of all applied updates in this database.';
--- Dumping data for table acore_auth.updates: ~35 rows (approximately)
+-- Dumping data for table acore_auth.updates: ~2 rows (approximately)
DELETE FROM `updates`;
INSERT INTO `updates` (`name`, `hash`, `state`, `timestamp`, `speed`) VALUES
- ('2016_07_09_00.sql', 'B692C4D5E96D26616E1E655D99DD27F6AC4FFDA6', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2016_07_09_01.sql', 'DE551E4708FE31AAC60CEF69466BBC5DFAC46F79', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2016_07_10_00.sql', '0AE2F7FB1E9C1E2BC2870D0EB817F3C87E0A39B3', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2016_08_25_00.sql', '707016C338350676C814D7926DFB6081E57091C3', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2016_08_25_01.sql', 'A5A2BE04C8E8E85CD177B8684DFFEACF71C9CF69', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2016_09_04_00.sql', '420ACF7160BF5549BC298EB6A1319969789DA140', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2016_11_18_00.sql', '92D22B3A45466470239402367D94C3791A243EF7', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2016_11_19_00.sql', 'C55E73648F661F40237B03F266F7169D231B3D8D', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2017_08_19_00.sql', 'E4457FFFFC0D3F86750F07CF88F549529E1B27E5', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2017_08_20_01.sql', 'E6190311E1A12E259C6CD21ACFC8BAA1D3F597DF', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2017_12_05_00.sql', '475860B881DE6E9CAC93AD3B37E7AAA8D63FB1B9', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2018_01_21_00.sql', '570FC5FC653D81B0E498E3EAB6706C9868CE8079', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2018_09_17_00.sql', '31743E771FFA4C92D6B6CF747DE4302814BDF257', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2019_01_05_00.sql', '2449121ABB0D5004BF6941B340F5C294AD95EBE9', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2019_02_08_00.sql', '18FF48FC1B1C238D44198FA1E2D422BAB4C9C338', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2019_02_17_00.sql', '1F4C4A15313A261088E40909DCCAA068EAAAAAAE', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2019_04_13_00.sql', '183C28E079DAB46AD6F7C0617E19346CAD043141', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2020_02_07_00.sql', '9549BF7354B4FA5A661EC094A2C3AAF665678152', 'ARCHIVED', '2021-10-14 07:13:44', 1),
- ('2021_01_25_00.sql', '5FA7F802E04CBF66848938FE7FC14FC4CC815F3C', 'ARCHIVED', '2021-10-15 00:59:32', 51),
- ('2021_03_21_00.sql', '1E98E516DAD70DC101E339950C1BCC1D15BE78B6', 'ARCHIVED', '2021-10-15 00:59:32', 102),
- ('2021_03_23_00.sql', '0EA578B7108559B4E54CAE99714F695659EDE6E5', 'ARCHIVED', '2021-10-15 00:59:32', 77),
- ('2021_05_13_00.sql', 'B9CABD6897489B20D6523AEDC61AD9075BCA398A', 'ARCHIVED', '2021-10-15 00:59:32', 104),
- ('2021_05_26_00.sql', '435822D9482BA2C5F0D8E54E3A587611A453B0FA', 'ARCHIVED', '2021-10-15 00:59:32', 71),
- ('2021_05_30_00.sql', 'E70A61123CBE2DC8AF332D03DF1889EB0DF3CEAB', 'ARCHIVED', '2021-10-15 00:59:32', 64),
- ('2021_06_17_00.sql', '36686970C025046FD49FA4BF6F8283A1AE2BE8F3', 'ARCHIVED', '2021-10-15 00:59:33', 52),
- ('2021_10_14_00.sql', 'D4378AFC454DF8351A6DE6C6B6144F82C62980A5', 'ARCHIVED', '2021-10-15 00:59:33', 53),
- ('2021_10_14_01_auth.sql', 'A4495131ADD2AB4AB6682C1621683963247368F0', 'ARCHIVED', '2022-01-22 02:36:20', 20),
- ('2021_11_06_00.sql', 'E08D11C492289879C460BB063457DAD968545752', 'ARCHIVED', '2022-01-22 02:36:20', 39),
- ('2022_01_23_00.sql', '6291006CD2B38EEE02EDDD8AEB6A952477854C77', 'ARCHIVED', '2022-04-24 18:19:14', 28),
- ('2022_04_24_00.sql', 'CFB8D5B896B2A5900F5E5A2262B356E0842405BB', 'ARCHIVED', '2022-08-21 12:56:35', 34),
- ('2022_04_28_00.sql', '26108CBD35D4B885A90CEC25665DCBC00FD06809', 'ARCHIVED', '2022-08-21 12:56:35', 30),
- ('2022_08_21_00.sql', 'E333B1A3FD1A25298D29B8FCAA0EE8AE5985202F', 'ARCHIVED', '2023-01-31 23:19:58', 28),
- ('2023_01_31_00.sql', '0ACDD35EC9745231BCFA701B78056DEF94D0CC53', 'RELEASED', '2023-04-23 21:18:58', 36),
- ('2023_02_20_00.sql', 'B2A8F337A3699322D19729AF07ADC5607FAEEF83', 'RELEASED', '2023-04-23 21:18:58', 56),
- ('2023_04_23_00.sql', 'F853503AAFB22DB3493F2ADC8B6BBB7B648EDBA9', 'RELEASED', '2023-04-23 21:18:59', 522);
+ ('2023_04_24_00.sql', 'D164A70B22B2462464484614018C3218B3259AE4', 'RELEASED', '2024-01-20 13:23:45', 26),
+ ('2024_01_20_00.sql', '41678119235D993DEF719C168B20867F781A3A5F', 'RELEASED', '2024-01-20 13:23:45', 36);
/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
diff --git a/data/sql/base/db_auth/updates_include.sql b/data/sql/base/db_auth/updates_include.sql
index 92e16be19d..847e630752 100644
--- a/data/sql/base/db_auth/updates_include.sql
+++ b/data/sql/base/db_auth/updates_include.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -17,8 +17,8 @@
-- Dumping structure for table acore_auth.updates_include
DROP TABLE IF EXISTS `updates_include`;
CREATE TABLE IF NOT EXISTS `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','CUSTOM') 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','CUSTOM') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
PRIMARY KEY (`path`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.';
diff --git a/data/sql/base/db_auth/uptime.sql b/data/sql/base/db_auth/uptime.sql
index dfa1fe4160..1df30bceab 100644
--- a/data/sql/base/db_auth/uptime.sql
+++ b/data/sql/base/db_auth/uptime.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
-- Host: 127.0.0.1
--- Server version: 8.0.29 - MySQL Community Server - GPL
+-- Server version: 8.1.0 - MySQL Community Server - GPL
-- Server OS: Win64
--- HeidiSQL Version: 12.0.0.6468
+-- HeidiSQL Version: 12.3.0.6589
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -21,18 +21,21 @@ CREATE TABLE IF NOT EXISTS `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 'AzerothCore',
+ `revision` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'AzerothCore',
PRIMARY KEY (`realmid`,`starttime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Uptime system';
--- Dumping data for table acore_auth.uptime: ~5 rows (approximately)
+-- Dumping data for table acore_auth.uptime: ~8 rows (approximately)
DELETE FROM `uptime`;
INSERT INTO `uptime` (`realmid`, `starttime`, `uptime`, `maxplayers`, `revision`) VALUES
(1, 1550400304, 121, 0, 'AzerothCore rev. 2bcedc2859e7 2019-02-17 10:04:09 +0100 (master branch) (Unix, Debug)'),
(1, 1550400454, 1440, 0, 'AzerothCore rev. 2bcedc2859e7 2019-02-17 10:04:09 +0100 (master branch) (Unix, Debug)'),
(1, 1661068597, 0, 0, 'AzerothCore rev. 5d6dfca80cf1 2022-08-21 09:48:09 +0200 (new-squash-POGGIES branch) (Win64, RelWithDebInfo, Static)'),
(1, 1675207201, 0, 0, 'AzerothCore rev. e7cbc80a913b 2023-01-31 22:22:22 +0000 (master branch) (Win64, RelWithDebInfo, Static)'),
- (1, 1682284745, 0, 0, 'AzerothCore rev. 5dc6f9cf78f1 2023-04-23 21:03:18 +0000 (master branch) (Win64, RelWithDebInfo, Static)');
+ (1, 1682284745, 0, 0, 'AzerothCore rev. 5dc6f9cf78f1 2023-04-23 21:03:18 +0000 (master branch) (Win64, RelWithDebInfo, Static)'),
+ (1, 1705757024, 0, 0, 'AzerothCore rev. e6a98aa294c0 2024-01-20 14:06:59 +0100 (checkarchive branch) (Win64, RelWithDebInfo, Static)'),
+ (1, 1705757166, 0, 0, 'AzerothCore rev. f60fb6307dc6 2024-01-20 13:20:35 +0000 (it-is-time-for-the-yearly-squash!-hopefully-the-archive-skipping-between-commits-issue-is-solved-now.-only-time-will-tell.-HAPPY-NEW-2024 branch) (Win64, RelWithDebInfo, Static)'),
+ (1, 1705764139, 0, 0, 'AzerothCore rev. bd8a08e50dfe+ 2024-01-20 14:48:23 +0100 (it-is-time-for-the-yearly-squash!-hopefully-the-archive-skipping-between-commits-issue-is-solved-now.-only-time-will-tell.-HAPPY-NEW-2024 branch) (Win64, RelWithDebInfo, Static)');
/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;