diff options
| author | Kitzunu <24550914+Kitzunu@users.noreply.github.com> | 2024-01-20 17:17:44 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-01-20 17:17:44 +0100 |
| commit | 7f7f18e48906959460171e05733baa736a730048 (patch) | |
| tree | df58913a65fc2355a3f3d888876b2c792f720fb1 /data/sql/base/db_characters | |
| parent | f60fb6307dc674e14190c08d12a3d71d8219b851 (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_characters')
101 files changed, 409 insertions, 463 deletions
diff --git a/data/sql/base/db_characters/account_data.sql b/data/sql/base/db_characters/account_data.sql index d71e6d0d6a..0fa5f47daf 100644 --- a/data/sql/base/db_characters/account_data.sql +++ b/data/sql/base/db_characters/account_data.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_characters/account_instance_times.sql b/data/sql/base/db_characters/account_instance_times.sql index bfb8d85a10..1381516fa3 100644 --- a/data/sql/base/db_characters/account_instance_times.sql +++ b/data/sql/base/db_characters/account_instance_times.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_characters/account_tutorial.sql b/data/sql/base/db_characters/account_tutorial.sql index 8da477224d..4ba6893b31 100644 --- a/data/sql/base/db_characters/account_tutorial.sql +++ b/data/sql/base/db_characters/account_tutorial.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_characters/addons.sql b/data/sql/base/db_characters/addons.sql index 37cec5359a..8129ca9389 100644 --- a/data/sql/base/db_characters/addons.sql +++ b/data/sql/base/db_characters/addons.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,7 +17,7 @@ -- Dumping structure for table acore_characters.addons DROP TABLE IF EXISTS `addons`; CREATE TABLE IF NOT EXISTS `addons` ( - `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `crc` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Addons'; diff --git a/data/sql/base/db_characters/arena_team.sql b/data/sql/base/db_characters/arena_team.sql index e1114dea7f..d430188942 100644 --- a/data/sql/base/db_characters/arena_team.sql +++ b/data/sql/base/db_characters/arena_team.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 `arena_team`; CREATE TABLE IF NOT EXISTS `arena_team` ( `arenaTeamId` int unsigned NOT NULL DEFAULT '0', - `name` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `captainGuid` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', `rating` smallint unsigned NOT NULL DEFAULT '0', diff --git a/data/sql/base/db_characters/arena_team_member.sql b/data/sql/base/db_characters/arena_team_member.sql index ea421d799e..3ec2614cb1 100644 --- a/data/sql/base/db_characters/arena_team_member.sql +++ b/data/sql/base/db_characters/arena_team_member.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_characters/auctionhouse.sql b/data/sql/base/db_characters/auctionhouse.sql index 8e64abf6d5..13aabf75d6 100644 --- a/data/sql/base/db_characters/auctionhouse.sql +++ b/data/sql/base/db_characters/auctionhouse.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_characters/banned_addons.sql b/data/sql/base/db_characters/banned_addons.sql index cb7af48acc..9370ddb761 100644 --- a/data/sql/base/db_characters/banned_addons.sql +++ b/data/sql/base/db_characters/banned_addons.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,8 +18,8 @@ DROP TABLE IF EXISTS `banned_addons`; CREATE TABLE IF NOT EXISTS `banned_addons` ( `Id` int unsigned NOT NULL AUTO_INCREMENT, - `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, - `Version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`Id`), UNIQUE KEY `idx_name_ver` (`Name`,`Version`) diff --git a/data/sql/base/db_characters/battleground_deserters.sql b/data/sql/base/db_characters/battleground_deserters.sql index eeab4d2ae4..03e24d235b 100644 --- a/data/sql/base/db_characters/battleground_deserters.sql +++ b/data/sql/base/db_characters/battleground_deserters.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_characters/bugreport.sql b/data/sql/base/db_characters/bugreport.sql index c7ea1b8d4b..e847ecb712 100644 --- a/data/sql/base/db_characters/bugreport.sql +++ b/data/sql/base/db_characters/bugreport.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,8 +18,8 @@ DROP TABLE IF EXISTS `bugreport`; CREATE TABLE IF NOT EXISTS `bugreport` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', - `type` longtext COLLATE utf8mb4_unicode_ci NOT NULL, - `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, + `type` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Debug System'; diff --git a/data/sql/base/db_characters/calendar_events.sql b/data/sql/base/db_characters/calendar_events.sql index ec8c3c055a..687cf81bc1 100644 --- a/data/sql/base/db_characters/calendar_events.sql +++ b/data/sql/base/db_characters/calendar_events.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,8 +19,8 @@ DROP TABLE IF EXISTS `calendar_events`; CREATE TABLE IF NOT EXISTS `calendar_events` ( `id` bigint unsigned NOT NULL DEFAULT '0', `creator` int unsigned NOT NULL DEFAULT '0', - `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `type` tinyint unsigned NOT NULL DEFAULT '4', `dungeon` int NOT NULL DEFAULT '-1', `eventtime` int unsigned NOT NULL DEFAULT '0', diff --git a/data/sql/base/db_characters/calendar_invites.sql b/data/sql/base/db_characters/calendar_invites.sql index 6ff31baa21..d04560517a 100644 --- a/data/sql/base/db_characters/calendar_invites.sql +++ b/data/sql/base/db_characters/calendar_invites.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 */; @@ -24,7 +24,7 @@ CREATE TABLE IF NOT EXISTS `calendar_invites` ( `status` tinyint unsigned NOT NULL DEFAULT '0', `statustime` int unsigned NOT NULL DEFAULT '0', `rank` tinyint unsigned NOT NULL DEFAULT '0', - `text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/data/sql/base/db_characters/channels.sql b/data/sql/base/db_characters/channels.sql index 2ad30f50a9..e86f78422c 100644 --- a/data/sql/base/db_characters/channels.sql +++ b/data/sql/base/db_characters/channels.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,11 +18,11 @@ DROP TABLE IF EXISTS `channels`; CREATE TABLE IF NOT EXISTS `channels` ( `channelId` int unsigned NOT NULL AUTO_INCREMENT, - `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `team` int unsigned NOT NULL, `announce` tinyint unsigned NOT NULL DEFAULT '1', `ownership` tinyint unsigned NOT NULL DEFAULT '1', - `password` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lastUsed` int unsigned NOT NULL, PRIMARY KEY (`channelId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Channel System'; diff --git a/data/sql/base/db_characters/channels_bans.sql b/data/sql/base/db_characters/channels_bans.sql index 0cc7f23464..d8569216bf 100644 --- a/data/sql/base/db_characters/channels_bans.sql +++ b/data/sql/base/db_characters/channels_bans.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_characters/channels_rights.sql b/data/sql/base/db_characters/channels_rights.sql index 6f4e6cf9a0..fbf303a3fc 100644 --- a/data/sql/base/db_characters/channels_rights.sql +++ b/data/sql/base/db_characters/channels_rights.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,12 +17,12 @@ -- Dumping structure for table acore_characters.channels_rights DROP TABLE IF EXISTS `channels_rights`; CREATE TABLE IF NOT EXISTS `channels_rights` ( - `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `flags` int unsigned NOT NULL, `speakdelay` int unsigned NOT NULL, - `joinmessage` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `delaymessage` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `moderators` text COLLATE utf8mb4_unicode_ci, + `joinmessage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `delaymessage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `moderators` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/data/sql/base/db_characters/character_account_data.sql b/data/sql/base/db_characters/character_account_data.sql index a8c111b7a9..72f4d1e368 100644 --- a/data/sql/base/db_characters/character_account_data.sql +++ b/data/sql/base/db_characters/character_account_data.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_characters/character_achievement.sql b/data/sql/base/db_characters/character_achievement.sql index c3e7ace6b3..46171e1979 100644 --- a/data/sql/base/db_characters/character_achievement.sql +++ b/data/sql/base/db_characters/character_achievement.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_characters/character_achievement_progress.sql b/data/sql/base/db_characters/character_achievement_progress.sql index dd3f2e22d3..92a2c3e73d 100644 --- a/data/sql/base/db_characters/character_achievement_progress.sql +++ b/data/sql/base/db_characters/character_achievement_progress.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_characters/character_action.sql b/data/sql/base/db_characters/character_action.sql index 363d8e8122..9533584ca1 100644 --- a/data/sql/base/db_characters/character_action.sql +++ b/data/sql/base/db_characters/character_action.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_characters/character_arena_stats.sql b/data/sql/base/db_characters/character_arena_stats.sql index 0aa41f27d7..8978e19676 100644 --- a/data/sql/base/db_characters/character_arena_stats.sql +++ b/data/sql/base/db_characters/character_arena_stats.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_characters/character_aura.sql b/data/sql/base/db_characters/character_aura.sql index df78354b75..ed2902d05f 100644 --- a/data/sql/base/db_characters/character_aura.sql +++ b/data/sql/base/db_characters/character_aura.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_characters/character_banned.sql b/data/sql/base/db_characters/character_banned.sql index 6aaec4ae2a..36bc803855 100644 --- a/data/sql/base/db_characters/character_banned.sql +++ b/data/sql/base/db_characters/character_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 `character_banned` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `bandate` int unsigned NOT NULL DEFAULT '0', `unbandate` int unsigned NOT NULL DEFAULT '0', - `bannedby` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, - `banreason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `bannedby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `banreason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`guid`,`bandate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Ban List'; diff --git a/data/sql/base/db_characters/character_battleground_random.sql b/data/sql/base/db_characters/character_battleground_random.sql index b0d22bfa9d..05c411e951 100644 --- a/data/sql/base/db_characters/character_battleground_random.sql +++ b/data/sql/base/db_characters/character_battleground_random.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_characters/character_brew_of_the_month.sql b/data/sql/base/db_characters/character_brew_of_the_month.sql index 3726c12d43..6c61bfa1f7 100644 --- a/data/sql/base/db_characters/character_brew_of_the_month.sql +++ b/data/sql/base/db_characters/character_brew_of_the_month.sql @@ -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_characters/character_declinedname.sql b/data/sql/base/db_characters/character_declinedname.sql index ad898eaf9b..c5647af5fe 100644 --- a/data/sql/base/db_characters/character_declinedname.sql +++ b/data/sql/base/db_characters/character_declinedname.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,11 +18,11 @@ DROP TABLE IF EXISTS `character_declinedname`; CREATE TABLE IF NOT EXISTS `character_declinedname` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `genitive` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `dative` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `accusative` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `instrumental` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `prepositional` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `genitive` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `dative` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `accusative` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `instrumental` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `prepositional` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/data/sql/base/db_characters/character_entry_point.sql b/data/sql/base/db_characters/character_entry_point.sql index cc5619a920..534ba29488 100644 --- a/data/sql/base/db_characters/character_entry_point.sql +++ b/data/sql/base/db_characters/character_entry_point.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_characters/character_equipmentsets.sql b/data/sql/base/db_characters/character_equipmentsets.sql index 25a107045a..1c90af32e4 100644 --- a/data/sql/base/db_characters/character_equipmentsets.sql +++ b/data/sql/base/db_characters/character_equipmentsets.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 `character_equipmentsets` ( `guid` int NOT NULL DEFAULT '0', `setguid` bigint NOT NULL AUTO_INCREMENT, `setindex` tinyint unsigned NOT NULL DEFAULT '0', - `name` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL, - `iconname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `iconname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `ignore_mask` int unsigned NOT NULL DEFAULT '0', `item0` int unsigned NOT NULL DEFAULT '0', `item1` int unsigned NOT NULL DEFAULT '0', diff --git a/data/sql/base/db_characters/character_gifts.sql b/data/sql/base/db_characters/character_gifts.sql index 2ed5f20f7b..09705bb32b 100644 --- a/data/sql/base/db_characters/character_gifts.sql +++ b/data/sql/base/db_characters/character_gifts.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_characters/character_glyphs.sql b/data/sql/base/db_characters/character_glyphs.sql index 2efc14c5fa..94837cba40 100644 --- a/data/sql/base/db_characters/character_glyphs.sql +++ b/data/sql/base/db_characters/character_glyphs.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_characters/character_homebind.sql b/data/sql/base/db_characters/character_homebind.sql index 012d3735d2..0d69bd60ca 100644 --- a/data/sql/base/db_characters/character_homebind.sql +++ b/data/sql/base/db_characters/character_homebind.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_characters/character_instance.sql b/data/sql/base/db_characters/character_instance.sql index 2658092d53..34170f3660 100644 --- a/data/sql/base/db_characters/character_instance.sql +++ b/data/sql/base/db_characters/character_instance.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_characters/character_inventory.sql b/data/sql/base/db_characters/character_inventory.sql index 819d2d99ce..95fbf2f958 100644 --- a/data/sql/base/db_characters/character_inventory.sql +++ b/data/sql/base/db_characters/character_inventory.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_characters/character_pet.sql b/data/sql/base/db_characters/character_pet.sql index b81eeebb1e..8de2410bfc 100644 --- a/data/sql/base/db_characters/character_pet.sql +++ b/data/sql/base/db_characters/character_pet.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 */; @@ -26,14 +26,14 @@ CREATE TABLE IF NOT EXISTS `character_pet` ( `level` smallint unsigned NOT NULL DEFAULT '1', `exp` int unsigned NOT NULL DEFAULT '0', `Reactstate` tinyint unsigned NOT NULL DEFAULT '0', - `name` varchar(21) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pet', + `name` varchar(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pet', `renamed` tinyint unsigned NOT NULL DEFAULT '0', `slot` tinyint unsigned NOT NULL DEFAULT '0', `curhealth` int unsigned NOT NULL DEFAULT '1', `curmana` int unsigned NOT NULL DEFAULT '0', `curhappiness` int unsigned NOT NULL DEFAULT '0', `savetime` int unsigned NOT NULL DEFAULT '0', - `abdata` text COLLATE utf8mb4_unicode_ci, + `abdata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `owner` (`owner`), KEY `idx_slot` (`slot`) diff --git a/data/sql/base/db_characters/character_pet_declinedname.sql b/data/sql/base/db_characters/character_pet_declinedname.sql index d5871590c6..b50405c095 100644 --- a/data/sql/base/db_characters/character_pet_declinedname.sql +++ b/data/sql/base/db_characters/character_pet_declinedname.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,11 +19,11 @@ DROP TABLE IF EXISTS `character_pet_declinedname`; CREATE TABLE IF NOT EXISTS `character_pet_declinedname` ( `id` int unsigned NOT NULL DEFAULT '0', `owner` int unsigned NOT NULL DEFAULT '0', - `genitive` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `dative` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `accusative` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `instrumental` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `prepositional` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `genitive` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `dative` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `accusative` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `instrumental` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `prepositional` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `owner_key` (`owner`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/data/sql/base/db_characters/character_queststatus.sql b/data/sql/base/db_characters/character_queststatus.sql index 9f989f0055..c7eeb4af4f 100644 --- a/data/sql/base/db_characters/character_queststatus.sql +++ b/data/sql/base/db_characters/character_queststatus.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_characters/character_queststatus_daily.sql b/data/sql/base/db_characters/character_queststatus_daily.sql index 852b6c5384..8f91824a05 100644 --- a/data/sql/base/db_characters/character_queststatus_daily.sql +++ b/data/sql/base/db_characters/character_queststatus_daily.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_characters/character_queststatus_monthly.sql b/data/sql/base/db_characters/character_queststatus_monthly.sql index 95aeb2f2f2..a316579a52 100644 --- a/data/sql/base/db_characters/character_queststatus_monthly.sql +++ b/data/sql/base/db_characters/character_queststatus_monthly.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_characters/character_queststatus_rewarded.sql b/data/sql/base/db_characters/character_queststatus_rewarded.sql index 2d92f14019..57a52d882b 100644 --- a/data/sql/base/db_characters/character_queststatus_rewarded.sql +++ b/data/sql/base/db_characters/character_queststatus_rewarded.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_characters/character_queststatus_seasonal.sql b/data/sql/base/db_characters/character_queststatus_seasonal.sql index 1fe5ec0106..84233ce975 100644 --- a/data/sql/base/db_characters/character_queststatus_seasonal.sql +++ b/data/sql/base/db_characters/character_queststatus_seasonal.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_characters/character_queststatus_weekly.sql b/data/sql/base/db_characters/character_queststatus_weekly.sql index 6a1359d4b7..d244a76edd 100644 --- a/data/sql/base/db_characters/character_queststatus_weekly.sql +++ b/data/sql/base/db_characters/character_queststatus_weekly.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_characters/character_reputation.sql b/data/sql/base/db_characters/character_reputation.sql index e31bad2c36..dbe8dbc790 100644 --- a/data/sql/base/db_characters/character_reputation.sql +++ b/data/sql/base/db_characters/character_reputation.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_characters/character_settings.sql b/data/sql/base/db_characters/character_settings.sql index a035684624..061a53db3b 100644 --- a/data/sql/base/db_characters/character_settings.sql +++ b/data/sql/base/db_characters/character_settings.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,8 +18,8 @@ DROP TABLE IF EXISTS `character_settings`; CREATE TABLE IF NOT EXISTS `character_settings` ( `guid` int unsigned NOT NULL, - `source` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, - `data` text COLLATE utf8mb4_unicode_ci, + `source` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`,`source`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player Settings'; diff --git a/data/sql/base/db_characters/character_skills.sql b/data/sql/base/db_characters/character_skills.sql index d6db50e4ec..73579ae3d5 100644 --- a/data/sql/base/db_characters/character_skills.sql +++ b/data/sql/base/db_characters/character_skills.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_characters/character_social.sql b/data/sql/base/db_characters/character_social.sql index 9c00d72db0..bb8bed13e6 100644 --- a/data/sql/base/db_characters/character_social.sql +++ b/data/sql/base/db_characters/character_social.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 `character_social` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `friend` int unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier', `flags` tinyint unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags', - `note` varchar(48) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Friend Note', + `note` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Friend Note', PRIMARY KEY (`guid`,`friend`,`flags`), KEY `friend` (`friend`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; diff --git a/data/sql/base/db_characters/character_spell.sql b/data/sql/base/db_characters/character_spell.sql index 8b884dbbc7..7bffe914f8 100644 --- a/data/sql/base/db_characters/character_spell.sql +++ b/data/sql/base/db_characters/character_spell.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_characters/character_spell_cooldown.sql b/data/sql/base/db_characters/character_spell_cooldown.sql index b781d8da03..789269cae7 100644 --- a/data/sql/base/db_characters/character_spell_cooldown.sql +++ b/data/sql/base/db_characters/character_spell_cooldown.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_characters/character_stats.sql b/data/sql/base/db_characters/character_stats.sql index 52cad3fb62..9b3631fe56 100644 --- a/data/sql/base/db_characters/character_stats.sql +++ b/data/sql/base/db_characters/character_stats.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_characters/character_talent.sql b/data/sql/base/db_characters/character_talent.sql index 22e668dc3f..d76ff15a87 100644 --- a/data/sql/base/db_characters/character_talent.sql +++ b/data/sql/base/db_characters/character_talent.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_characters/characters.sql b/data/sql/base/db_characters/characters.sql index 02bcc41d3e..77d988eefe 100644 --- a/data/sql/base/db_characters/characters.sql +++ b/data/sql/base/db_characters/characters.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 */; @@ -41,7 +41,7 @@ CREATE TABLE IF NOT EXISTS `characters` ( `instance_id` int unsigned NOT NULL DEFAULT '0', `instance_mode_mask` tinyint unsigned NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', - `taximask` text COLLATE utf8mb4_unicode_ci NOT NULL, + `taximask` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `online` tinyint unsigned NOT NULL DEFAULT '0', `cinematic` tinyint unsigned NOT NULL DEFAULT '0', `totaltime` int unsigned NOT NULL DEFAULT '0', @@ -61,7 +61,7 @@ CREATE TABLE IF NOT EXISTS `characters` ( `at_login` smallint unsigned NOT NULL DEFAULT '0', `zone` smallint unsigned NOT NULL DEFAULT '0', `death_expire_time` int unsigned NOT NULL DEFAULT '0', - `taxi_path` text COLLATE utf8mb4_unicode_ci, + `taxi_path` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `arenaPoints` int unsigned NOT NULL DEFAULT '0', `totalHonorPoints` int unsigned NOT NULL DEFAULT '0', `todayHonorPoints` int unsigned NOT NULL DEFAULT '0', @@ -84,16 +84,16 @@ CREATE TABLE IF NOT EXISTS `characters` ( `latency` int unsigned DEFAULT '0', `talentGroupsCount` tinyint unsigned NOT NULL DEFAULT '1', `activeTalentGroup` tinyint unsigned NOT NULL DEFAULT '0', - `exploredZones` longtext COLLATE utf8mb4_unicode_ci, - `equipmentCache` longtext COLLATE utf8mb4_unicode_ci, + `exploredZones` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `equipmentCache` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ammoId` int unsigned NOT NULL DEFAULT '0', - `knownTitles` longtext COLLATE utf8mb4_unicode_ci, + `knownTitles` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `actionBars` tinyint unsigned NOT NULL DEFAULT '0', `grantableLevels` tinyint unsigned NOT NULL DEFAULT '0', `order` tinyint DEFAULT NULL, `creation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `deleteInfos_Account` int unsigned DEFAULT NULL, - `deleteInfos_Name` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `deleteInfos_Name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleteDate` int unsigned DEFAULT NULL, `innTriggerId` int unsigned NOT NULL, `extraBonusTalentCount` int NOT NULL DEFAULT '0', diff --git a/data/sql/base/db_characters/corpse.sql b/data/sql/base/db_characters/corpse.sql index 56bea9176e..a6c1ca9298 100644 --- a/data/sql/base/db_characters/corpse.sql +++ b/data/sql/base/db_characters/corpse.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 */; @@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS `corpse` ( `mapId` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `phaseMask` int unsigned NOT NULL DEFAULT '1', `displayId` int unsigned NOT NULL DEFAULT '0', - `itemCache` text COLLATE utf8mb4_unicode_ci NOT NULL, + `itemCache` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `bytes1` int unsigned NOT NULL DEFAULT '0', `bytes2` int unsigned NOT NULL DEFAULT '0', `guildId` int unsigned NOT NULL DEFAULT '0', diff --git a/data/sql/base/db_characters/creature_respawn.sql b/data/sql/base/db_characters/creature_respawn.sql index fe74eacd46..db11609d3a 100644 --- a/data/sql/base/db_characters/creature_respawn.sql +++ b/data/sql/base/db_characters/creature_respawn.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_characters/game_event_condition_save.sql b/data/sql/base/db_characters/game_event_condition_save.sql index 81f833cc26..67356431d2 100644 --- a/data/sql/base/db_characters/game_event_condition_save.sql +++ b/data/sql/base/db_characters/game_event_condition_save.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_characters/game_event_save.sql b/data/sql/base/db_characters/game_event_save.sql index ff83670efc..500357a2d3 100644 --- a/data/sql/base/db_characters/game_event_save.sql +++ b/data/sql/base/db_characters/game_event_save.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_characters/gameobject_respawn.sql b/data/sql/base/db_characters/gameobject_respawn.sql index 0faf143f65..1e3d71c6e1 100644 --- a/data/sql/base/db_characters/gameobject_respawn.sql +++ b/data/sql/base/db_characters/gameobject_respawn.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_characters/gm_subsurvey.sql b/data/sql/base/db_characters/gm_subsurvey.sql index cdac2f2a64..d09dfe0086 100644 --- a/data/sql/base/db_characters/gm_subsurvey.sql +++ b/data/sql/base/db_characters/gm_subsurvey.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 `gm_subsurvey` ( `surveyId` int unsigned NOT NULL AUTO_INCREMENT, `questionId` int unsigned NOT NULL DEFAULT '0', `answer` int unsigned NOT NULL DEFAULT '0', - `answerComment` text COLLATE utf8mb4_unicode_ci NOT NULL, + `answerComment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`surveyId`,`questionId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; diff --git a/data/sql/base/db_characters/gm_survey.sql b/data/sql/base/db_characters/gm_survey.sql index 02b8155f0f..ae974fa6f7 100644 --- a/data/sql/base/db_characters/gm_survey.sql +++ b/data/sql/base/db_characters/gm_survey.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 `gm_survey` ( `surveyId` int unsigned NOT NULL AUTO_INCREMENT, `guid` int unsigned NOT NULL DEFAULT '0', `mainSurvey` int unsigned NOT NULL DEFAULT '0', - `comment` longtext COLLATE utf8mb4_unicode_ci NOT NULL, + `comment` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` int unsigned NOT NULL DEFAULT '0', `maxMMR` smallint NOT NULL, PRIMARY KEY (`surveyId`) diff --git a/data/sql/base/db_characters/gm_ticket.sql b/data/sql/base/db_characters/gm_ticket.sql index 28f79d07ac..dab27515d7 100644 --- a/data/sql/base/db_characters/gm_ticket.sql +++ b/data/sql/base/db_characters/gm_ticket.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 `gm_ticket` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `type` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0 open, 1 closed, 2 character deleted', `playerGuid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier of ticket creator', - `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of ticket creator', - `description` text COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of ticket creator', + `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` int unsigned NOT NULL DEFAULT '0', `mapId` smallint unsigned NOT NULL DEFAULT '0', `posX` float NOT NULL DEFAULT '0', @@ -30,8 +30,8 @@ CREATE TABLE IF NOT EXISTS `gm_ticket` ( `lastModifiedTime` int unsigned NOT NULL DEFAULT '0', `closedBy` int NOT NULL DEFAULT '0' COMMENT '-1 Closed by Console, >0 GUID of GM', `assignedTo` int unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned', - `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, - `response` text COLLATE utf8mb4_unicode_ci NOT NULL, + `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `response` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `completed` tinyint unsigned NOT NULL DEFAULT '0', `escalated` tinyint unsigned NOT NULL DEFAULT '0', `viewed` tinyint unsigned NOT NULL DEFAULT '0', diff --git a/data/sql/base/db_characters/group_member.sql b/data/sql/base/db_characters/group_member.sql index 340958efb7..95afaf88d3 100644 --- a/data/sql/base/db_characters/group_member.sql +++ b/data/sql/base/db_characters/group_member.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_characters/groups.sql b/data/sql/base/db_characters/groups.sql index b4c9745667..be6ad74ac2 100644 --- a/data/sql/base/db_characters/groups.sql +++ b/data/sql/base/db_characters/groups.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_characters/guild.sql b/data/sql/base/db_characters/guild.sql index 9a8d361637..5c985ce9f9 100644 --- a/data/sql/base/db_characters/guild.sql +++ b/data/sql/base/db_characters/guild.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,15 +18,15 @@ DROP TABLE IF EXISTS `guild`; CREATE TABLE IF NOT EXISTS `guild` ( `guildid` int unsigned NOT NULL DEFAULT '0', - `name` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `leaderguid` int unsigned NOT NULL DEFAULT '0', `EmblemStyle` tinyint unsigned NOT NULL DEFAULT '0', `EmblemColor` tinyint unsigned NOT NULL DEFAULT '0', `BorderStyle` tinyint unsigned NOT NULL DEFAULT '0', `BorderColor` tinyint unsigned NOT NULL DEFAULT '0', `BackgroundColor` tinyint unsigned NOT NULL DEFAULT '0', - `info` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `motd` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `info` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `motd` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `createdate` int unsigned NOT NULL DEFAULT '0', `BankMoney` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`) diff --git a/data/sql/base/db_characters/guild_bank_eventlog.sql b/data/sql/base/db_characters/guild_bank_eventlog.sql index 8ff2199d62..e36d848c60 100644 --- a/data/sql/base/db_characters/guild_bank_eventlog.sql +++ b/data/sql/base/db_characters/guild_bank_eventlog.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_characters/guild_bank_item.sql b/data/sql/base/db_characters/guild_bank_item.sql index 6ccb62b580..e08905e621 100644 --- a/data/sql/base/db_characters/guild_bank_item.sql +++ b/data/sql/base/db_characters/guild_bank_item.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_characters/guild_bank_right.sql b/data/sql/base/db_characters/guild_bank_right.sql index e8f3e1c9ab..2f57fd5123 100644 --- a/data/sql/base/db_characters/guild_bank_right.sql +++ b/data/sql/base/db_characters/guild_bank_right.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_characters/guild_bank_tab.sql b/data/sql/base/db_characters/guild_bank_tab.sql index d05731be64..be7f306acd 100644 --- a/data/sql/base/db_characters/guild_bank_tab.sql +++ b/data/sql/base/db_characters/guild_bank_tab.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 `guild_bank_tab`; CREATE TABLE IF NOT EXISTS `guild_bank_tab` ( `guildid` int unsigned NOT NULL DEFAULT '0', `TabId` tinyint unsigned NOT NULL DEFAULT '0', - `TabName` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `TabIcon` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `TabText` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `TabName` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `TabIcon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `TabText` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`guildid`,`TabId`), KEY `guildid_key` (`guildid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/data/sql/base/db_characters/guild_eventlog.sql b/data/sql/base/db_characters/guild_eventlog.sql index 9f8b2c87e6..343d2b1774 100644 --- a/data/sql/base/db_characters/guild_eventlog.sql +++ b/data/sql/base/db_characters/guild_eventlog.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_characters/guild_member.sql b/data/sql/base/db_characters/guild_member.sql index b6a066aa14..e0bdbf2faa 100644 --- a/data/sql/base/db_characters/guild_member.sql +++ b/data/sql/base/db_characters/guild_member.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 `guild_member` ( `guildid` int unsigned NOT NULL COMMENT 'Guild Identificator', `guid` int unsigned NOT NULL, `rank` tinyint unsigned NOT NULL, - `pnote` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `offnote` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `pnote` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `offnote` varchar(31) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', UNIQUE KEY `guid_key` (`guid`), KEY `guildid_key` (`guildid`), KEY `guildid_rank_key` (`guildid`,`rank`) diff --git a/data/sql/base/db_characters/guild_member_withdraw.sql b/data/sql/base/db_characters/guild_member_withdraw.sql index 4736e4ec15..f6fad730e3 100644 --- a/data/sql/base/db_characters/guild_member_withdraw.sql +++ b/data/sql/base/db_characters/guild_member_withdraw.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_characters/guild_rank.sql b/data/sql/base/db_characters/guild_rank.sql index d5c48fa264..89d370ade8 100644 --- a/data/sql/base/db_characters/guild_rank.sql +++ b/data/sql/base/db_characters/guild_rank.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,7 +19,7 @@ DROP TABLE IF EXISTS `guild_rank`; CREATE TABLE IF NOT EXISTS `guild_rank` ( `guildid` int unsigned NOT NULL DEFAULT '0', `rid` tinyint unsigned NOT NULL, - `rname` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `rname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `rights` int unsigned DEFAULT '0', `BankMoneyPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`rid`), diff --git a/data/sql/base/db_characters/instance.sql b/data/sql/base/db_characters/instance.sql index 5574f97d71..039501aee7 100644 --- a/data/sql/base/db_characters/instance.sql +++ b/data/sql/base/db_characters/instance.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 */; @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `instance` ( `resettime` int unsigned NOT NULL DEFAULT '0', `difficulty` tinyint unsigned NOT NULL DEFAULT '0', `completedEncounters` int unsigned NOT NULL DEFAULT '0', - `data` tinytext COLLATE utf8mb4_unicode_ci NOT NULL, + `data` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `map` (`map`), KEY `resettime` (`resettime`), diff --git a/data/sql/base/db_characters/instance_reset.sql b/data/sql/base/db_characters/instance_reset.sql index 28cc2c98e6..4e5db0c842 100644 --- a/data/sql/base/db_characters/instance_reset.sql +++ b/data/sql/base/db_characters/instance_reset.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 */; @@ -27,77 +27,77 @@ CREATE TABLE IF NOT EXISTS `instance_reset` ( -- Dumping data for table acore_characters.instance_reset: ~71 rows (approximately) DELETE FROM `instance_reset`; INSERT INTO `instance_reset` (`mapid`, `difficulty`, `resettime`) VALUES - (249, 0, 1682640000), - (249, 1, 1682640000), - (269, 1, 1682265600), - (309, 0, 1682438400), - (409, 0, 1682640000), - (469, 0, 1682640000), - (509, 0, 1682438400), - (531, 0, 1682640000), - (532, 0, 1682640000), - (533, 0, 1682640000), - (533, 1, 1682640000), - (534, 0, 1682640000), - (540, 1, 1682265600), - (542, 1, 1682265600), - (543, 1, 1682265600), - (544, 0, 1682640000), - (545, 1, 1682265600), - (546, 1, 1682265600), - (547, 1, 1682265600), - (548, 0, 1682640000), - (550, 0, 1682640000), - (552, 1, 1682265600), - (553, 1, 1682265600), - (554, 1, 1682265600), - (555, 1, 1682265600), - (556, 1, 1682265600), - (557, 1, 1682265600), - (558, 1, 1682265600), - (560, 1, 1682265600), - (564, 0, 1682640000), - (565, 0, 1682640000), - (568, 0, 1682438400), - (574, 1, 1682265600), - (575, 1, 1682265600), - (576, 1, 1682265600), - (578, 1, 1682294400), - (580, 0, 1682640000), - (585, 1, 1682294400), - (595, 1, 1682294400), - (598, 1, 1682294400), - (599, 1, 1682294400), - (600, 1, 1682294400), - (601, 1, 1682294400), - (602, 1, 1682294400), - (603, 0, 1682640000), - (603, 1, 1682640000), - (604, 1, 1682294400), - (608, 1, 1682294400), - (615, 0, 1682640000), - (615, 1, 1682640000), - (616, 0, 1682640000), - (616, 1, 1682640000), - (619, 1, 1682294400), - (624, 0, 1682640000), - (624, 1, 1682640000), - (631, 0, 1682640000), - (631, 1, 1682640000), - (631, 2, 1682640000), - (631, 3, 1682640000), - (632, 1, 1682294400), - (649, 0, 1682640000), - (649, 1, 1682640000), - (649, 2, 1682640000), - (649, 3, 1682640000), - (650, 1, 1682294400), - (658, 1, 1682294400), - (668, 1, 1682294400), - (724, 0, 1682640000), - (724, 1, 1682640000), - (724, 2, 1682640000), - (724, 3, 1682640000); + (249, 0, 1706241600), + (249, 1, 1706241600), + (269, 1, 1705780800), + (309, 0, 1705780800), + (409, 0, 1706241600), + (469, 0, 1706241600), + (509, 0, 1705780800), + (531, 0, 1706241600), + (532, 0, 1706241600), + (533, 0, 1706241600), + (533, 1, 1706241600), + (534, 0, 1706241600), + (540, 1, 1705780800), + (542, 1, 1705780800), + (543, 1, 1705780800), + (544, 0, 1706241600), + (545, 1, 1705780800), + (546, 1, 1705780800), + (547, 1, 1705780800), + (548, 0, 1706241600), + (550, 0, 1706241600), + (552, 1, 1705780800), + (553, 1, 1705780800), + (554, 1, 1705780800), + (555, 1, 1705780800), + (556, 1, 1705780800), + (557, 1, 1705780800), + (558, 1, 1705780800), + (560, 1, 1705780800), + (564, 0, 1706241600), + (565, 0, 1706241600), + (568, 0, 1705780800), + (574, 1, 1705780800), + (575, 1, 1705780800), + (576, 1, 1705780800), + (578, 1, 1705809600), + (580, 0, 1706241600), + (585, 1, 1705809600), + (595, 1, 1705809600), + (598, 1, 1705809600), + (599, 1, 1705809600), + (600, 1, 1705809600), + (601, 1, 1705809600), + (602, 1, 1705809600), + (603, 0, 1706241600), + (603, 1, 1706241600), + (604, 1, 1705809600), + (608, 1, 1705809600), + (615, 0, 1706241600), + (615, 1, 1706241600), + (616, 0, 1706241600), + (616, 1, 1706241600), + (619, 1, 1705809600), + (624, 0, 1706241600), + (624, 1, 1706241600), + (631, 0, 1706241600), + (631, 1, 1706241600), + (631, 2, 1706241600), + (631, 3, 1706241600), + (632, 1, 1705809600), + (649, 0, 1706241600), + (649, 1, 1706241600), + (649, 2, 1706241600), + (649, 3, 1706241600), + (650, 1, 1705809600), + (658, 1, 1705809600), + (668, 1, 1705809600), + (724, 0, 1706241600), + (724, 1, 1706241600), + (724, 2, 1706241600), + (724, 3, 1706241600); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; diff --git a/data/sql/base/db_characters/instance_saved_go_state_data.sql b/data/sql/base/db_characters/instance_saved_go_state_data.sql index 0b43674a5d..c9b85ba14f 100644 --- a/data/sql/base/db_characters/instance_saved_go_state_data.sql +++ b/data/sql/base/db_characters/instance_saved_go_state_data.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_characters/item_instance.sql b/data/sql/base/db_characters/item_instance.sql index e2a7d498c7..9b8d07d948 100644 --- a/data/sql/base/db_characters/item_instance.sql +++ b/data/sql/base/db_characters/item_instance.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 */; @@ -24,13 +24,13 @@ CREATE TABLE IF NOT EXISTS `item_instance` ( `giftCreatorGuid` int unsigned NOT NULL DEFAULT '0', `count` int unsigned NOT NULL DEFAULT '1', `duration` int NOT NULL DEFAULT '0', - `charges` tinytext COLLATE utf8mb4_unicode_ci, + `charges` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `flags` int unsigned DEFAULT '0', - `enchantments` text COLLATE utf8mb4_unicode_ci NOT NULL, + `enchantments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `randomPropertyId` smallint NOT NULL DEFAULT '0', `durability` smallint unsigned NOT NULL DEFAULT '0', `playedTime` int unsigned NOT NULL DEFAULT '0', - `text` text COLLATE utf8mb4_unicode_ci, + `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System'; diff --git a/data/sql/base/db_characters/item_loot_storage.sql b/data/sql/base/db_characters/item_loot_storage.sql index 2b4e45767b..682ef77403 100644 --- a/data/sql/base/db_characters/item_loot_storage.sql +++ b/data/sql/base/db_characters/item_loot_storage.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_characters/item_refund_instance.sql b/data/sql/base/db_characters/item_refund_instance.sql index 52c2b25dc8..6bade3925f 100644 --- a/data/sql/base/db_characters/item_refund_instance.sql +++ b/data/sql/base/db_characters/item_refund_instance.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_characters/item_soulbound_trade_data.sql b/data/sql/base/db_characters/item_soulbound_trade_data.sql index 5933dd64fb..f52cbf90c7 100644 --- a/data/sql/base/db_characters/item_soulbound_trade_data.sql +++ b/data/sql/base/db_characters/item_soulbound_trade_data.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 `item_soulbound_trade_data`; CREATE TABLE IF NOT EXISTS `item_soulbound_trade_data` ( `itemGuid` int unsigned NOT NULL COMMENT 'Item GUID', - `allowedPlayers` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', + `allowedPlayers` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', PRIMARY KEY (`itemGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Refund System'; diff --git a/data/sql/base/db_characters/lag_reports.sql b/data/sql/base/db_characters/lag_reports.sql index 254bb1e207..d5cad5f697 100644 --- a/data/sql/base/db_characters/lag_reports.sql +++ b/data/sql/base/db_characters/lag_reports.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_characters/lfg_data.sql b/data/sql/base/db_characters/lfg_data.sql index d3f6b9341b..45c8ef825e 100644 --- a/data/sql/base/db_characters/lfg_data.sql +++ b/data/sql/base/db_characters/lfg_data.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_characters/log_arena_fights.sql b/data/sql/base/db_characters/log_arena_fights.sql index 7c1c3af5da..c8d530b518 100644 --- a/data/sql/base/db_characters/log_arena_fights.sql +++ b/data/sql/base/db_characters/log_arena_fights.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_characters/log_arena_memberstats.sql b/data/sql/base/db_characters/log_arena_memberstats.sql index 7ec0704b59..e800fb7df1 100644 --- a/data/sql/base/db_characters/log_arena_memberstats.sql +++ b/data/sql/base/db_characters/log_arena_memberstats.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,11 +19,11 @@ DROP TABLE IF EXISTS `log_arena_memberstats`; CREATE TABLE IF NOT EXISTS `log_arena_memberstats` ( `fight_id` int unsigned NOT NULL, `member_id` tinyint unsigned NOT NULL, - `name` char(20) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `guid` int unsigned NOT NULL, `team` int unsigned NOT NULL, `account` int unsigned NOT NULL, - `ip` char(15) COLLATE utf8mb4_unicode_ci NOT NULL, + `ip` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `damage` int unsigned NOT NULL, `heal` int unsigned NOT NULL, `kblows` int unsigned NOT NULL, diff --git a/data/sql/base/db_characters/log_encounter.sql b/data/sql/base/db_characters/log_encounter.sql index 358b6a073d..698e02b1e8 100644 --- a/data/sql/base/db_characters/log_encounter.sql +++ b/data/sql/base/db_characters/log_encounter.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 */; @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `log_encounter` ( `difficulty` tinyint unsigned NOT NULL, `creditType` tinyint unsigned NOT NULL, `creditEntry` int unsigned NOT NULL, - `playersInfo` text COLLATE utf8mb4_unicode_ci NOT NULL + `playersInfo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.log_encounter: ~0 rows (approximately) diff --git a/data/sql/base/db_characters/log_money.sql b/data/sql/base/db_characters/log_money.sql index 80f634abdd..03a833ee33 100644 --- a/data/sql/base/db_characters/log_money.sql +++ b/data/sql/base/db_characters/log_money.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,12 +19,12 @@ DROP TABLE IF EXISTS `log_money`; CREATE TABLE IF NOT EXISTS `log_money` ( `sender_acc` int unsigned NOT NULL, `sender_guid` int unsigned NOT NULL, - `sender_name` text COLLATE utf8mb4_unicode_ci NOT NULL, - `sender_ip` text COLLATE utf8mb4_unicode_ci NOT NULL, + `sender_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `sender_ip` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `receiver_acc` int unsigned NOT NULL, - `receiver_name` text COLLATE utf8mb4_unicode_ci NOT NULL, + `receiver_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `money` bigint unsigned NOT NULL, - `topic` text COLLATE utf8mb4_unicode_ci NOT NULL, + `topic` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date` datetime NOT NULL, `type` tinyint NOT NULL COMMENT '1=COD,2=AH,3=GB DEPOSIT,4=GB WITHDRAW,5=MAIL,6=TRADE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/data/sql/base/db_characters/mail.sql b/data/sql/base/db_characters/mail.sql index ffeae19fe3..331a20c030 100644 --- a/data/sql/base/db_characters/mail.sql +++ b/data/sql/base/db_characters/mail.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 */; @@ -23,8 +23,8 @@ CREATE TABLE IF NOT EXISTS `mail` ( `mailTemplateId` smallint unsigned NOT NULL DEFAULT '0', `sender` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', `receiver` int unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier', - `subject` longtext COLLATE utf8mb4_unicode_ci, - `body` longtext COLLATE utf8mb4_unicode_ci, + `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `has_items` tinyint unsigned NOT NULL DEFAULT '0', `expire_time` int unsigned NOT NULL DEFAULT '0', `deliver_time` int unsigned NOT NULL DEFAULT '0', diff --git a/data/sql/base/db_characters/mail_items.sql b/data/sql/base/db_characters/mail_items.sql index bc1d646fea..6049c017c5 100644 --- a/data/sql/base/db_characters/mail_items.sql +++ b/data/sql/base/db_characters/mail_items.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_characters/mail_server_character.sql b/data/sql/base/db_characters/mail_server_character.sql index d02f6bbadd..c8e1a3ee97 100644 --- a/data/sql/base/db_characters/mail_server_character.sql +++ b/data/sql/base/db_characters/mail_server_character.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_characters/mail_server_template.sql b/data/sql/base/db_characters/mail_server_template.sql index ea8e57df48..319947b1cb 100644 --- a/data/sql/base/db_characters/mail_server_template.sql +++ b/data/sql/base/db_characters/mail_server_template.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 */; @@ -26,8 +26,8 @@ CREATE TABLE IF NOT EXISTS `mail_server_template` ( `itemCountA` int unsigned NOT NULL DEFAULT '0', `itemH` int unsigned NOT NULL DEFAULT '0', `itemCountH` int unsigned NOT NULL DEFAULT '0', - `subject` text COLLATE utf8mb4_unicode_ci NOT NULL, - `body` text COLLATE utf8mb4_unicode_ci NOT NULL, + `subject` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/data/sql/base/db_characters/pet_aura.sql b/data/sql/base/db_characters/pet_aura.sql index a14174904b..f235873b8d 100644 --- a/data/sql/base/db_characters/pet_aura.sql +++ b/data/sql/base/db_characters/pet_aura.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_characters/pet_spell.sql b/data/sql/base/db_characters/pet_spell.sql index 6b5bfce53b..ea7dc09ae8 100644 --- a/data/sql/base/db_characters/pet_spell.sql +++ b/data/sql/base/db_characters/pet_spell.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_characters/pet_spell_cooldown.sql b/data/sql/base/db_characters/pet_spell_cooldown.sql index b07ad708b4..d7266e1cef 100644 --- a/data/sql/base/db_characters/pet_spell_cooldown.sql +++ b/data/sql/base/db_characters/pet_spell_cooldown.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_characters/petition.sql b/data/sql/base/db_characters/petition.sql index 9d1219a4bc..1fa8baa638 100644 --- a/data/sql/base/db_characters/petition.sql +++ b/data/sql/base/db_characters/petition.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,7 +19,7 @@ DROP TABLE IF EXISTS `petition`; CREATE TABLE IF NOT EXISTS `petition` ( `ownerguid` int unsigned NOT NULL, `petitionguid` int unsigned DEFAULT '0', - `name` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ownerguid`,`type`), UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) diff --git a/data/sql/base/db_characters/petition_sign.sql b/data/sql/base/db_characters/petition_sign.sql index b70d50ab3e..8b8482d021 100644 --- a/data/sql/base/db_characters/petition_sign.sql +++ b/data/sql/base/db_characters/petition_sign.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_characters/pool_quest_save.sql b/data/sql/base/db_characters/pool_quest_save.sql index 98513c3df1..069a1e6d4f 100644 --- a/data/sql/base/db_characters/pool_quest_save.sql +++ b/data/sql/base/db_characters/pool_quest_save.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 */; @@ -25,44 +25,44 @@ CREATE TABLE IF NOT EXISTS `pool_quest_save` ( -- Dumping data for table acore_characters.pool_quest_save: ~38 rows (approximately) DELETE FROM `pool_quest_save`; INSERT INTO `pool_quest_save` (`pool_id`, `quest_id`) VALUES - (348, 24629), - (349, 14101), - (350, 13889), - (351, 13917), - (352, 11377), - (353, 11666), - (354, 13423), - (356, 11363), - (357, 11385), - (358, 14074), - (359, 14076), - (360, 14140), - (361, 14141), - (362, 12760), - (363, 14107), - (380, 12737), - (381, 12741), - (382, 12762), - (384, 13192), - (385, 236), - (386, 12587), - (5662, 13673), - (5663, 13762), - (5664, 13770), - (5665, 13773), - (5666, 13778), - (5667, 13784), - (5668, 13666), - (5669, 13603), - (5670, 13742), - (5671, 13746), - (5672, 13759), - (5673, 13752), - (5674, 13101), - (5675, 13116), - (5676, 13833), - (5677, 12959), - (5678, 24585); + (348, 24635), + (349, 14105), + (350, 13904), + (351, 13914), + (352, 11381), + (353, 11669), + (354, 13424), + (356, 11368), + (357, 11383), + (358, 14080), + (359, 14090), + (360, 14144), + (361, 14092), + (362, 12703), + (363, 14108), + (380, 12735), + (381, 12732), + (382, 12705), + (384, 13194), + (385, 13156), + (386, 12563), + (5662, 13675), + (5663, 13763), + (5664, 13769), + (5665, 13774), + (5666, 13779), + (5667, 13785), + (5668, 13669), + (5669, 13600), + (5670, 13743), + (5671, 13748), + (5672, 13757), + (5673, 13753), + (5674, 13103), + (5675, 13113), + (5676, 13836), + (5677, 12961), + (5678, 24583); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; diff --git a/data/sql/base/db_characters/profanity_name.sql b/data/sql/base/db_characters/profanity_name.sql index 4c97724054..d61c95795c 100644 --- a/data/sql/base/db_characters/profanity_name.sql +++ b/data/sql/base/db_characters/profanity_name.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,7 +17,7 @@ -- Dumping structure for table acore_characters.profanity_name DROP TABLE IF EXISTS `profanity_name`; CREATE TABLE IF NOT EXISTS `profanity_name` ( - `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/data/sql/base/db_characters/pvpstats_battlegrounds.sql b/data/sql/base/db_characters/pvpstats_battlegrounds.sql index 5924da9390..c495fe6a22 100644 --- a/data/sql/base/db_characters/pvpstats_battlegrounds.sql +++ b/data/sql/base/db_characters/pvpstats_battlegrounds.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_characters/pvpstats_players.sql b/data/sql/base/db_characters/pvpstats_players.sql index 666072d0f1..272a102075 100644 --- a/data/sql/base/db_characters/pvpstats_players.sql +++ b/data/sql/base/db_characters/pvpstats_players.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_characters/quest_tracker.sql b/data/sql/base/db_characters/quest_tracker.sql index ecec099b52..08764a51b1 100644 --- a/data/sql/base/db_characters/quest_tracker.sql +++ b/data/sql/base/db_characters/quest_tracker.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 */; @@ -23,8 +23,8 @@ CREATE TABLE IF NOT EXISTS `quest_tracker` ( `quest_complete_time` datetime DEFAULT NULL, `quest_abandon_time` datetime DEFAULT NULL, `completed_by_gm` tinyint NOT NULL DEFAULT '0', - `core_hash` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', - `core_revision` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' + `core_hash` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', + `core_revision` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.quest_tracker: ~0 rows (approximately) diff --git a/data/sql/base/db_characters/recovery_item.sql b/data/sql/base/db_characters/recovery_item.sql index abde772e58..6ab69e67a6 100644 --- a/data/sql/base/db_characters/recovery_item.sql +++ b/data/sql/base/db_characters/recovery_item.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_characters/reserved_name.sql b/data/sql/base/db_characters/reserved_name.sql index b2f35a2f58..3283ea2e7f 100644 --- a/data/sql/base/db_characters/reserved_name.sql +++ b/data/sql/base/db_characters/reserved_name.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,7 +17,7 @@ -- Dumping structure for table acore_characters.reserved_name DROP TABLE IF EXISTS `reserved_name`; CREATE TABLE IF NOT EXISTS `reserved_name` ( - `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player Reserved Names'; diff --git a/data/sql/base/db_characters/updates.sql b/data/sql/base/db_characters/updates.sql index a667bcb7e4..d79afe79a6 100644 --- a/data/sql/base/db_characters/updates.sql +++ b/data/sql/base/db_characters/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,78 +17,21 @@ -- Dumping structure for table acore_characters.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_characters.updates: ~61 rows (approximately) +-- Dumping data for table acore_characters.updates: ~4 rows (approximately) DELETE FROM `updates`; INSERT INTO `updates` (`name`, `hash`, `state`, `timestamp`, `speed`) VALUES - ('2016_07_09_00.sql', '6CB4253FF700E83A3FCB121714F32E4FFA70F0F4', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_07_09_01.sql', '5A20018FCAEC914DB359E807682F9B826865C2AB', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_07_10_00.sql', 'CA163905843EFB726CA838F463448E3833175F70', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_07_30_00.sql', '7CEA690831DD7B6509FB165BD3C5BFF2138AB867', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_08_08_00.sql', '909B26A005C244E715027F8FF31D721D236403AF', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_08_12_00.sql', '9902E3CD09738DA232C168AA374551C1DB2B902E', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_08_14_00.sql', '38462AB366B96C1979F049A5FAF33A1C2DE25E65', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_08_15_00.sql', '0490565BD304DC7CB73B5A1F4B2348BFD53B9C31', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_08_25_00.sql', '2318A3863066AD26B28F80C6ABC9DCCB86A136BA', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_11_18_00.sql', '0D4DB0CCC7D7ABF467B1B614E7A5FFCDD5E2A5A3', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_11_19_00.sql', '4981B8C9F2368AFB5EDB3160FF9CC63AFD9DB3D9', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2017_09_18_00.sql', '393373BB3CB5525ECF5A69661170AE0B49677AC3', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2018_04_19_00.sql', '1DFB571DEDBACAC579229C7365A2F52330BB84B4', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2018_08_08_00.sql', '8623083F006C05A08D5B1322FF3EFE7304AEB6FC', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2018_12_23_00.sql', '0135EE4A7AA472A4BB6F9B76BABE84F8A45645D2', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2019_01_06_00.sql', '043ADFE28ABFBEA7304FCE95183C385646CF78D8', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2019_02_17_00.sql', 'FF8DE7049A60865CBE70B9736A9B63296A3969DF', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2019_05_12_00.sql', '75DB225858A4D21DA92D21AC292A9DD9A5551BA5', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2019_05_15_00.sql', 'E2D51033471C04D47DA3C091B2FB7D2BBB816E8B', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2019_11_22_00.sql', 'CA433BC426072EF7DDC555B086F65B17BB83CAF5', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2019_12_09_00.sql', '04D33DE31942314C86AC20EA39D74C44228E9819', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2020_01_04_00.sql', '7DA0D914F60BE3827068447FE4EA6AA85266E328', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2021_01_25_00.sql', '64733EF8381E24919D2B80E2E8524EA29651706F', 'ARCHIVED', '2021-10-15 01:01:27', 55), - ('2021_03_28_00.sql', '7CCFD84E6866D3CCD6ED08818C6D2D375C1B4F2F', 'ARCHIVED', '2021-10-15 01:01:27', 46), - ('2021_04_25_00.sql', '10264658F0C3BC460AAE00871DE316D5EB3CE29C', 'ARCHIVED', '2021-10-15 01:01:28', 302), - ('2021_04_27_00.sql', 'A4F55A0714C7A205A3431CD85486AF3DA0EB386D', 'ARCHIVED', '2021-10-15 01:01:28', 68), - ('2021_04_29_00.sql', '2D91E2B5E2930FFFD97686CF164EFBACC4E15D75', 'ARCHIVED', '2021-10-15 01:01:28', 64), - ('2021_05_28_00.sql', '4B2B5E140376765534BBEB646E12C9B0BE21124F', 'ARCHIVED', '2021-10-15 01:01:28', 48), - ('2021_05_30_00.sql', '485DD24DC4BB64E488C9E57EED6AE5599080B9D4', 'ARCHIVED', '2021-10-15 01:01:28', 63), - ('2021_06_08_00.sql', '5F098821777262235B41F8F987D5075290C10B25', 'ARCHIVED', '2021-10-15 01:01:28', 55), - ('2021_06_18_00.sql', 'DDBD76B308AF2913A84F444BE46DBF4D74C7AB7A', 'ARCHIVED', '2021-10-15 01:01:28', 59), - ('2021_06_22_00.sql', 'BDCD91F558FC53DCED73762F2A21383E6727699A', 'ARCHIVED', '2021-10-15 01:01:28', 65), - ('2021_06_23_00.sql', '92354482E2319AC5BC85F186DEEFA856AF20DFA9', 'ARCHIVED', '2021-10-15 01:01:28', 70), - ('2021_06_30_00.sql', '8F7D9659DEBF99A79341ED980434A901E87F6BEE', 'ARCHIVED', '2021-10-15 01:01:28', 71), - ('2021_07_06_00.sql', 'E2B95774C0CD17EE221D575D206B367D7B74D3FE', 'ARCHIVED', '2021-10-15 01:01:28', 45), - ('2021_07_08_00.sql', '524B15817531D3A6220DA7D88FF71C990EAD5EE7', 'ARCHIVED', '2021-10-15 01:01:28', 48), - ('2021_07_21_00.sql', 'F3FAE7AA245D9A98484CF6A010608BD0D3A5CEF8', 'ARCHIVED', '2021-10-15 01:01:28', 63), - ('2021_09_13_00.sql', 'BE22F6D5DACCF11F27B353AAE3A66056A0BC541A', 'ARCHIVED', '2021-10-15 01:01:28', 62), - ('2021_09_25_00.sql', '4A2003C9983E1F775032755E2BF7062CCE99FBB5', 'ARCHIVED', '2021-10-15 01:01:28', 62), - ('2021_10_14_00.sql', 'FD481BA8924F107B9B5B2359999820D57A016907', 'ARCHIVED', '2021-10-15 01:01:28', 46), - ('2021_10_14_01_characters.sql', 'D34A3947055382A390A134D91DD68903CA5FA7C4', 'ARCHIVED', '2022-01-22 02:39:14', 21), - ('2021_11_06_00.sql', 'B36ED498D42A54BC818B6027AB1F92A7ACD0DA25', 'ARCHIVED', '2022-01-22 02:39:14', 70), - ('2021_12_26_00.sql', '089B77AAA7C676D7850070C1C05644CC50EC7F36', 'ARCHIVED', '2022-01-22 02:39:14', 46), - ('2021_12_26_01.sql', '22C450827DB8E89AF4B0F6B23B3D829B96F69B6A', 'ARCHIVED', '2022-01-22 02:39:14', 54), - ('2022_01_25_00.sql', '784BA8C193B91B471A6E6B8C4D5BCA5850AB883A', 'ARCHIVED', '2022-04-24 18:20:00', 51), - ('2022_01_29_00.sql', '1EADA7852AC70F49E8EA0030CC5FA087075F9DD4', 'ARCHIVED', '2022-04-24 18:20:00', 40), - ('2022_02_16_00.sql', '60440F15D2DD99B7327FD5BB77E03B44B29768EE', 'ARCHIVED', '2022-04-24 18:20:00', 33), - ('2022_03_01_00.sql', 'CB1DF259CAF17989F36DC7E24DFA7B08F86AE6FD', 'ARCHIVED', '2022-04-24 18:20:00', 61), - ('2022_04_19_00.sql', '5D7010FF56BC3BDFF19BEEDCE394471F768763FE', 'ARCHIVED', '2022-04-24 18:20:00', 62), - ('2022_04_24_00.sql', 'A2533CA2289827F447D37EDD003F84D44FCB3B98', 'ARCHIVED', '2022-08-21 12:57:27', 48), - ('2022_04_28_00.sql', 'C311595439669E38C754C975DDD0FD0ECCDD446B', 'ARCHIVED', '2022-08-21 12:57:27', 35), - ('2022_05_24_00.sql', '4E4A70F946ECB111D9C2197BB87A3930E5AC5B5C', 'ARCHIVED', '2022-08-21 12:57:27', 38), - ('2022_08_02_00.sql', '91C7A066B1885F9AE59CF74FFF327D9A1875ED8B', 'ARCHIVED', '2022-08-21 12:57:27', 30), - ('2022_08_07_00.sql', 'AC270742E652BFD6AF1A5C7F0DEC943C95CC3880', 'ARCHIVED', '2022-08-21 12:57:27', 46), - ('2022_08_21_00.sql', 'E333B1A3FD1A25298D29B8FCAA0EE8AE5985202F', 'ARCHIVED', '2023-01-31 23:21:23', 30), - ('2022_10_13_00.sql', '7121BF9B0A15DA47B60438C82F6A8CA382F35D50', 'ARCHIVED', '2023-01-31 23:21:23', 54), - ('2022_10_20_00.sql', 'BD0C6FF81228F0D56448EBB0648819214835C595', 'ARCHIVED', '2023-01-31 23:21:23', 33), - ('2023_01_31_00.sql', '0ACDD35EC9745231BCFA701B78056DEF94D0CC53', 'RELEASED', '2023-04-23 21:20:30', 40), - ('2023_03_04_00.sql', '0097D8B1669A50EC995EB20B0C67AB99F397DC62', 'RELEASED', '2023-04-23 21:20:31', 51), - ('2023_04_22_00.sql', '5D186CCA2236120C314CB65A8504B32F8D5E55BC', 'RELEASED', '2023-04-23 21:20:31', 71), - ('2023_04_23_00.sql', '0B1ADB9E87966E0D1740CEFDF984E68E7D2762FE', 'RELEASED', '2023-04-23 21:20:35', 4768); + ('2023_04_24_00.sql', 'D164A70B22B2462464484614018C3218B3259AE4', 'RELEASED', '2024-01-20 13:25:01', 30), + ('2023_05_23_00.sql', 'A1A442D3F5049CDA2C067761F768C08BEFFFD26A', 'RELEASED', '2024-01-20 13:25:01', 35), + ('2023_09_16_00.sql', '5760BA953E3F0C73492B979A33A86771B82CE464', 'RELEASED', '2024-01-20 13:25:01', 68), + ('2024_01_20_00.sql', 'FB9F840C7601C4F0939D23E87377D7DD9D145094', 'RELEASED', '2024-01-20 13:25:01', 26); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; diff --git a/data/sql/base/db_characters/updates_include.sql b/data/sql/base/db_characters/updates_include.sql index 1f58762093..316f7bd88d 100644 --- a/data/sql/base/db_characters/updates_include.sql +++ b/data/sql/base/db_characters/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_characters.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_characters/warden_action.sql b/data/sql/base/db_characters/warden_action.sql index 0005fa53e0..9d88350c57 100644 --- a/data/sql/base/db_characters/warden_action.sql +++ b/data/sql/base/db_characters/warden_action.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_characters/worldstates.sql b/data/sql/base/db_characters/worldstates.sql index 87ee8d847c..9c72e6b0ea 100644 --- a/data/sql/base/db_characters/worldstates.sql +++ b/data/sql/base/db_characters/worldstates.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,11 +19,11 @@ DROP TABLE IF EXISTS `worldstates`; CREATE TABLE IF NOT EXISTS `worldstates` ( `entry` int unsigned NOT NULL DEFAULT '0', `value` int unsigned NOT NULL DEFAULT '0', - `comment` tinytext COLLATE utf8mb4_unicode_ci, + `comment` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Variable Saves'; --- Dumping data for table acore_characters.worldstates: ~102 rows (approximately) +-- Dumping data for table acore_characters.worldstates: ~105 rows (approximately) DELETE FROM `worldstates`; INSERT INTO `worldstates` (`entry`, `value`, `comment`) VALUES (1, 0, NULL), @@ -55,6 +55,7 @@ INSERT INTO `worldstates` (`entry`, `value`, `comment`) VALUES (27, 0, NULL), (28, 0, NULL), (29, 0, NULL), + (30, 0, NULL), (31, 0, NULL), (32, 0, NULL), (33, 0, NULL), @@ -102,6 +103,7 @@ INSERT INTO `worldstates` (`entry`, `value`, `comment`) VALUES (75, 0, NULL), (76, 0, NULL), (77, 0, NULL), + (78, 0, NULL), (79, 0, NULL), (80, 0, NULL), (81, 0, NULL), @@ -113,6 +115,7 @@ INSERT INTO `worldstates` (`entry`, `value`, `comment`) VALUES (87, 0, NULL), (88, 0, NULL), (89, 0, NULL), + (90, 0, NULL), (197, 0, 'Fishing Extravaganza - STV_FISHING_PREV_WIN_TIME'), (198, 0, 'Fishing Extravaganza - STV_FISHING_HAS_WINNER'), (199, 0, 'Fishing Extravaganza - STV_FISHING_ANNOUNCE_EVENT_BEGIN'), @@ -121,13 +124,13 @@ INSERT INTO `worldstates` (`entry`, `value`, `comment`) VALUES (3801, 0, NULL), (3802, 1, NULL), (20001, 1454691600, 'NextArenaPointDistributionTime'), - (20002, 1661400000, 'NextWeeklyQuestResetTime'), - (20003, 1661140800, 'NextBGRandomDailyResetTime'), + (20002, 1706158800, 'NextWeeklyQuestResetTime'), + (20003, 1705813200, 'NextBGRandomDailyResetTime'), (20004, 0, 'cleaning_flags'), - (20005, 1661140800, 'NextDailyQuestResetTime'), - (20006, 1661140800, 'NextGuildDailyResetTime'), - (20007, 1662004800, 'NextMonthlyQuestResetTime'), - (20008, 1661140800, NULL); + (20005, 1705813200, 'NextDailyQuestResetTime'), + (20006, 1705813200, 'NextGuildDailyResetTime'), + (20007, 1706763600, 'NextMonthlyQuestResetTime'), + (20008, 1705813200, NULL); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; |