diff options
| author | Gultask <100873791+Gultask@users.noreply.github.com> | 2023-04-25 01:48:38 -0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-04-25 01:48:38 -0300 |
| commit | 5ca6fe6fda8464cca8bc68659746d8fa79619f21 (patch) | |
| tree | 4b879c0f92fcb8a4629cb9ee380d564be38bf72a /data/sql/base/db_characters | |
| parent | df77b5f4f79dfee4dee4f01e7258e1b4e7c1b7e2 (diff) | |
feat(DB): Release ACDB 9.0.0 (#16069)
* squishy
Diffstat (limited to 'data/sql/base/db_characters')
101 files changed, 359 insertions, 337 deletions
diff --git a/data/sql/base/db_characters/account_data.sql b/data/sql/base/db_characters/account_data.sql index 92bdcbbfe3..d71e6d0d6a 100644 --- a/data/sql/base/db_characters/account_data.sql +++ b/data/sql/base/db_characters/account_data.sql @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `account_data` ( `time` int unsigned NOT NULL DEFAULT '0', `data` blob NOT NULL, PRIMARY KEY (`accountId`,`type`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.account_data: ~0 rows (approximately) DELETE FROM `account_data`; diff --git a/data/sql/base/db_characters/account_instance_times.sql b/data/sql/base/db_characters/account_instance_times.sql index 441334c47d..bfb8d85a10 100644 --- a/data/sql/base/db_characters/account_instance_times.sql +++ b/data/sql/base/db_characters/account_instance_times.sql @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `account_instance_times` ( `instanceId` int unsigned NOT NULL DEFAULT '0', `releaseTime` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`accountId`,`instanceId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.account_instance_times: ~0 rows (approximately) DELETE FROM `account_instance_times`; diff --git a/data/sql/base/db_characters/account_tutorial.sql b/data/sql/base/db_characters/account_tutorial.sql index be49afa6c7..8da477224d 100644 --- a/data/sql/base/db_characters/account_tutorial.sql +++ b/data/sql/base/db_characters/account_tutorial.sql @@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS `account_tutorial` ( `tut6` int unsigned NOT NULL DEFAULT '0', `tut7` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`accountId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.account_tutorial: ~0 rows (approximately) DELETE FROM `account_tutorial`; diff --git a/data/sql/base/db_characters/addons.sql b/data/sql/base/db_characters/addons.sql index 5143e93d2b..37cec5359a 100644 --- a/data/sql/base/db_characters/addons.sql +++ b/data/sql/base/db_characters/addons.sql @@ -17,10 +17,10 @@ -- Dumping structure for table acore_characters.addons DROP TABLE IF EXISTS `addons`; CREATE TABLE IF NOT EXISTS `addons` ( - `name` varchar(120) NOT NULL DEFAULT '', + `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `crc` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Addons'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Addons'; -- Dumping data for table acore_characters.addons: ~23 rows (approximately) DELETE FROM `addons`; diff --git a/data/sql/base/db_characters/arena_team.sql b/data/sql/base/db_characters/arena_team.sql index 641f94d6fc..e1114dea7f 100644 --- a/data/sql/base/db_characters/arena_team.sql +++ b/data/sql/base/db_characters/arena_team.sql @@ -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) NOT NULL, + `name` varchar(24) 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', @@ -33,7 +33,7 @@ CREATE TABLE IF NOT EXISTS `arena_team` ( `borderStyle` tinyint unsigned NOT NULL DEFAULT '0', `borderColor` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`arenaTeamId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.arena_team: ~0 rows (approximately) DELETE FROM `arena_team`; diff --git a/data/sql/base/db_characters/arena_team_member.sql b/data/sql/base/db_characters/arena_team_member.sql index 3dc91b757c..ea421d799e 100644 --- a/data/sql/base/db_characters/arena_team_member.sql +++ b/data/sql/base/db_characters/arena_team_member.sql @@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS `arena_team_member` ( `seasonWins` smallint unsigned NOT NULL DEFAULT '0', `personalRating` smallint NOT NULL DEFAULT '0', PRIMARY KEY (`arenaTeamId`,`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.arena_team_member: ~0 rows (approximately) DELETE FROM `arena_team_member`; diff --git a/data/sql/base/db_characters/auctionhouse.sql b/data/sql/base/db_characters/auctionhouse.sql index d8742f36e4..8e64abf6d5 100644 --- a/data/sql/base/db_characters/auctionhouse.sql +++ b/data/sql/base/db_characters/auctionhouse.sql @@ -29,7 +29,7 @@ CREATE TABLE IF NOT EXISTS `auctionhouse` ( `deposit` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `item_guid` (`itemguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.auctionhouse: ~0 rows (approximately) DELETE FROM `auctionhouse`; diff --git a/data/sql/base/db_characters/banned_addons.sql b/data/sql/base/db_characters/banned_addons.sql index 2e8df126dd..cb7af48acc 100644 --- a/data/sql/base/db_characters/banned_addons.sql +++ b/data/sql/base/db_characters/banned_addons.sql @@ -18,12 +18,12 @@ DROP TABLE IF EXISTS `banned_addons`; CREATE TABLE IF NOT EXISTS `banned_addons` ( `Id` int unsigned NOT NULL AUTO_INCREMENT, - `Name` varchar(255) NOT NULL, - `Version` varchar(255) NOT NULL DEFAULT '', + `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `Version` varchar(255) 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`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.banned_addons: ~0 rows (approximately) DELETE FROM `banned_addons`; diff --git a/data/sql/base/db_characters/battleground_deserters.sql b/data/sql/base/db_characters/battleground_deserters.sql index e3feb31922..eeab4d2ae4 100644 --- a/data/sql/base/db_characters/battleground_deserters.sql +++ b/data/sql/base/db_characters/battleground_deserters.sql @@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `battleground_deserters` ( `guid` int unsigned NOT NULL COMMENT 'characters.guid', `type` tinyint unsigned NOT NULL COMMENT 'type of the desertion', `datetime` datetime NOT NULL COMMENT 'datetime of the desertion' -) ENGINE=InnoDB DEFAULT CHARSET=latin1; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.battleground_deserters: ~0 rows (approximately) DELETE FROM `battleground_deserters`; diff --git a/data/sql/base/db_characters/bugreport.sql b/data/sql/base/db_characters/bugreport.sql index ad8dc3989e..c7ea1b8d4b 100644 --- a/data/sql/base/db_characters/bugreport.sql +++ b/data/sql/base/db_characters/bugreport.sql @@ -18,10 +18,10 @@ DROP TABLE IF EXISTS `bugreport`; CREATE TABLE IF NOT EXISTS `bugreport` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', - `type` longtext NOT NULL, - `content` longtext NOT NULL, + `type` longtext COLLATE utf8mb4_unicode_ci NOT NULL, + `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Debug System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Debug System'; -- Dumping data for table acore_characters.bugreport: ~0 rows (approximately) DELETE FROM `bugreport`; diff --git a/data/sql/base/db_characters/calendar_events.sql b/data/sql/base/db_characters/calendar_events.sql index 5e70f81352..ec8c3c055a 100644 --- a/data/sql/base/db_characters/calendar_events.sql +++ b/data/sql/base/db_characters/calendar_events.sql @@ -19,15 +19,15 @@ 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) NOT NULL DEFAULT '', - `description` varchar(255) NOT NULL DEFAULT '', + `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `description` varchar(255) 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', `flags` int unsigned NOT NULL DEFAULT '0', `time2` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.calendar_events: ~0 rows (approximately) DELETE FROM `calendar_events`; diff --git a/data/sql/base/db_characters/calendar_invites.sql b/data/sql/base/db_characters/calendar_invites.sql index f1bcef0732..6ff31baa21 100644 --- a/data/sql/base/db_characters/calendar_invites.sql +++ b/data/sql/base/db_characters/calendar_invites.sql @@ -24,9 +24,9 @@ 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) NOT NULL DEFAULT '', + `text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.calendar_invites: ~0 rows (approximately) DELETE FROM `calendar_invites`; diff --git a/data/sql/base/db_characters/channels.sql b/data/sql/base/db_characters/channels.sql index 3cf5d00814..2ad30f50a9 100644 --- a/data/sql/base/db_characters/channels.sql +++ b/data/sql/base/db_characters/channels.sql @@ -18,14 +18,14 @@ DROP TABLE IF EXISTS `channels`; CREATE TABLE IF NOT EXISTS `channels` ( `channelId` int unsigned NOT NULL AUTO_INCREMENT, - `name` varchar(128) NOT NULL, + `name` varchar(128) 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) DEFAULT NULL, + `password` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lastUsed` int unsigned NOT NULL, PRIMARY KEY (`channelId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Channel System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Channel System'; -- Dumping data for table acore_characters.channels: ~0 rows (approximately) DELETE FROM `channels`; diff --git a/data/sql/base/db_characters/channels_bans.sql b/data/sql/base/db_characters/channels_bans.sql index d341e1cea6..0cc7f23464 100644 --- a/data/sql/base/db_characters/channels_bans.sql +++ b/data/sql/base/db_characters/channels_bans.sql @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `channels_bans` ( `playerGUID` int unsigned NOT NULL, `banTime` int unsigned NOT NULL, PRIMARY KEY (`channelId`,`playerGUID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.channels_bans: ~0 rows (approximately) DELETE FROM `channels_bans`; diff --git a/data/sql/base/db_characters/channels_rights.sql b/data/sql/base/db_characters/channels_rights.sql index 7b79c77c34..6f4e6cf9a0 100644 --- a/data/sql/base/db_characters/channels_rights.sql +++ b/data/sql/base/db_characters/channels_rights.sql @@ -17,14 +17,14 @@ -- Dumping structure for table acore_characters.channels_rights DROP TABLE IF EXISTS `channels_rights`; CREATE TABLE IF NOT EXISTS `channels_rights` ( - `name` varchar(128) NOT NULL, + `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, `flags` int unsigned NOT NULL, `speakdelay` int unsigned NOT NULL, - `joinmessage` varchar(255) NOT NULL DEFAULT '', - `delaymessage` varchar(255) NOT NULL DEFAULT '', - `moderators` text, + `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, PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.channels_rights: ~0 rows (approximately) DELETE FROM `channels_rights`; diff --git a/data/sql/base/db_characters/character_account_data.sql b/data/sql/base/db_characters/character_account_data.sql index 56b1ea6680..a8c111b7a9 100644 --- a/data/sql/base/db_characters/character_account_data.sql +++ b/data/sql/base/db_characters/character_account_data.sql @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_account_data` ( `time` int unsigned NOT NULL DEFAULT '0', `data` blob NOT NULL, PRIMARY KEY (`guid`,`type`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_account_data: ~0 rows (approximately) DELETE FROM `character_account_data`; diff --git a/data/sql/base/db_characters/character_achievement.sql b/data/sql/base/db_characters/character_achievement.sql index 03605475be..c3e7ace6b3 100644 --- a/data/sql/base/db_characters/character_achievement.sql +++ b/data/sql/base/db_characters/character_achievement.sql @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `character_achievement` ( `achievement` smallint unsigned NOT NULL, `date` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`achievement`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_achievement: ~0 rows (approximately) DELETE FROM `character_achievement`; diff --git a/data/sql/base/db_characters/character_achievement_progress.sql b/data/sql/base/db_characters/character_achievement_progress.sql index b3a6d2b762..dd3f2e22d3 100644 --- a/data/sql/base/db_characters/character_achievement_progress.sql +++ b/data/sql/base/db_characters/character_achievement_progress.sql @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_achievement_progress` ( `counter` int unsigned NOT NULL, `date` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`criteria`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_achievement_progress: ~0 rows (approximately) DELETE FROM `character_achievement_progress`; diff --git a/data/sql/base/db_characters/character_action.sql b/data/sql/base/db_characters/character_action.sql index 58aa735638..363d8e8122 100644 --- a/data/sql/base/db_characters/character_action.sql +++ b/data/sql/base/db_characters/character_action.sql @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `character_action` ( `action` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spec`,`button`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_action: ~0 rows (approximately) DELETE FROM `character_action`; diff --git a/data/sql/base/db_characters/character_arena_stats.sql b/data/sql/base/db_characters/character_arena_stats.sql index 500cdc2d97..0aa41f27d7 100644 --- a/data/sql/base/db_characters/character_arena_stats.sql +++ b/data/sql/base/db_characters/character_arena_stats.sql @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_arena_stats` ( `matchMakerRating` smallint unsigned NOT NULL DEFAULT '0', `maxMMR` smallint NOT NULL, PRIMARY KEY (`guid`,`slot`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_arena_stats: ~0 rows (approximately) DELETE FROM `character_arena_stats`; diff --git a/data/sql/base/db_characters/character_aura.sql b/data/sql/base/db_characters/character_aura.sql index cfea001097..df78354b75 100644 --- a/data/sql/base/db_characters/character_aura.sql +++ b/data/sql/base/db_characters/character_aura.sql @@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `character_aura` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `casterGuid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier', `itemGuid` bigint unsigned NOT NULL DEFAULT '0', - `spell` mediumint unsigned NOT NULL DEFAULT '0', + `spell` int unsigned NOT NULL DEFAULT '0', `effectMask` tinyint unsigned NOT NULL DEFAULT '0', `recalculateMask` tinyint unsigned NOT NULL DEFAULT '0', `stackCount` tinyint unsigned NOT NULL DEFAULT '1', @@ -34,7 +34,7 @@ CREATE TABLE IF NOT EXISTS `character_aura` ( `remainTime` int NOT NULL DEFAULT '0', `remainCharges` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`casterGuid`,`itemGuid`,`spell`,`effectMask`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_aura: ~0 rows (approximately) DELETE FROM `character_aura`; diff --git a/data/sql/base/db_characters/character_banned.sql b/data/sql/base/db_characters/character_banned.sql index 466e5ae719..6aaec4ae2a 100644 --- a/data/sql/base/db_characters/character_banned.sql +++ b/data/sql/base/db_characters/character_banned.sql @@ -20,11 +20,11 @@ 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) NOT NULL, - `banreason` varchar(255) NOT NULL, + `bannedby` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, + `banreason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`guid`,`bandate`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Ban List'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Ban List'; -- Dumping data for table acore_characters.character_banned: ~0 rows (approximately) DELETE FROM `character_banned`; diff --git a/data/sql/base/db_characters/character_battleground_random.sql b/data/sql/base/db_characters/character_battleground_random.sql index 56975c2ec7..b0d22bfa9d 100644 --- a/data/sql/base/db_characters/character_battleground_random.sql +++ b/data/sql/base/db_characters/character_battleground_random.sql @@ -19,7 +19,7 @@ DROP TABLE IF EXISTS `character_battleground_random`; CREATE TABLE IF NOT EXISTS `character_battleground_random` ( `guid` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_battleground_random: ~0 rows (approximately) DELETE FROM `character_battleground_random`; 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 136e5ed84c..3726c12d43 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 @@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `character_brew_of_the_month` ( `guid` int unsigned NOT NULL, `lastEventId` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_brew_of_the_month: ~0 rows (approximately) DELETE FROM `character_brew_of_the_month`; diff --git a/data/sql/base/db_characters/character_declinedname.sql b/data/sql/base/db_characters/character_declinedname.sql index 40982740a1..ad898eaf9b 100644 --- a/data/sql/base/db_characters/character_declinedname.sql +++ b/data/sql/base/db_characters/character_declinedname.sql @@ -18,13 +18,13 @@ 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) NOT NULL DEFAULT '', - `dative` varchar(15) NOT NULL DEFAULT '', - `accusative` varchar(15) NOT NULL DEFAULT '', - `instrumental` varchar(15) NOT NULL DEFAULT '', - `prepositional` varchar(15) NOT NULL DEFAULT '', + `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 '', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_declinedname: ~0 rows (approximately) DELETE FROM `character_declinedname`; diff --git a/data/sql/base/db_characters/character_entry_point.sql b/data/sql/base/db_characters/character_entry_point.sql index 296939d6fb..cc5619a920 100644 --- a/data/sql/base/db_characters/character_entry_point.sql +++ b/data/sql/base/db_characters/character_entry_point.sql @@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS `character_entry_point` ( `taxiPath1` int unsigned NOT NULL DEFAULT '0', `mountSpell` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_entry_point: ~0 rows (approximately) DELETE FROM `character_entry_point`; diff --git a/data/sql/base/db_characters/character_equipmentsets.sql b/data/sql/base/db_characters/character_equipmentsets.sql index 0cfce2d1cc..25a107045a 100644 --- a/data/sql/base/db_characters/character_equipmentsets.sql +++ b/data/sql/base/db_characters/character_equipmentsets.sql @@ -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) NOT NULL, - `iconname` varchar(100) NOT NULL, + `name` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL, + `iconname` varchar(100) 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', @@ -45,7 +45,7 @@ CREATE TABLE IF NOT EXISTS `character_equipmentsets` ( PRIMARY KEY (`setguid`), UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`), KEY `Idx_setindex` (`setindex`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_equipmentsets: ~0 rows (approximately) DELETE FROM `character_equipmentsets`; diff --git a/data/sql/base/db_characters/character_gifts.sql b/data/sql/base/db_characters/character_gifts.sql index ce55c8263f..2ed5f20f7b 100644 --- a/data/sql/base/db_characters/character_gifts.sql +++ b/data/sql/base/db_characters/character_gifts.sql @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `character_gifts` ( `flags` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`item_guid`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_gifts: ~0 rows (approximately) DELETE FROM `character_gifts`; diff --git a/data/sql/base/db_characters/character_glyphs.sql b/data/sql/base/db_characters/character_glyphs.sql index aabe0a9be6..2efc14c5fa 100644 --- a/data/sql/base/db_characters/character_glyphs.sql +++ b/data/sql/base/db_characters/character_glyphs.sql @@ -26,7 +26,7 @@ CREATE TABLE IF NOT EXISTS `character_glyphs` ( `glyph5` smallint unsigned DEFAULT '0', `glyph6` smallint unsigned DEFAULT '0', PRIMARY KEY (`guid`,`talentGroup`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_glyphs: ~0 rows (approximately) DELETE FROM `character_glyphs`; diff --git a/data/sql/base/db_characters/character_homebind.sql b/data/sql/base/db_characters/character_homebind.sql index 34cbb18d74..012d3735d2 100644 --- a/data/sql/base/db_characters/character_homebind.sql +++ b/data/sql/base/db_characters/character_homebind.sql @@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS `character_homebind` ( `posZ` float NOT NULL DEFAULT '0', `posO` float NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_homebind: ~0 rows (approximately) DELETE FROM `character_homebind`; diff --git a/data/sql/base/db_characters/character_instance.sql b/data/sql/base/db_characters/character_instance.sql index 143fd4606a..2658092d53 100644 --- a/data/sql/base/db_characters/character_instance.sql +++ b/data/sql/base/db_characters/character_instance.sql @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `character_instance` ( `extended` tinyint unsigned NOT NULL, PRIMARY KEY (`guid`,`instance`), KEY `instance` (`instance`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_instance: ~0 rows (approximately) DELETE FROM `character_instance`; diff --git a/data/sql/base/db_characters/character_inventory.sql b/data/sql/base/db_characters/character_inventory.sql index 6412e87d2e..819d2d99ce 100644 --- a/data/sql/base/db_characters/character_inventory.sql +++ b/data/sql/base/db_characters/character_inventory.sql @@ -24,7 +24,7 @@ CREATE TABLE IF NOT EXISTS `character_inventory` ( PRIMARY KEY (`item`), UNIQUE KEY `guid` (`guid`,`bag`,`slot`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_inventory: ~0 rows (approximately) DELETE FROM `character_inventory`; diff --git a/data/sql/base/db_characters/character_pet.sql b/data/sql/base/db_characters/character_pet.sql index 599dbc2f5f..b81eeebb1e 100644 --- a/data/sql/base/db_characters/character_pet.sql +++ b/data/sql/base/db_characters/character_pet.sql @@ -21,23 +21,23 @@ CREATE TABLE IF NOT EXISTS `character_pet` ( `entry` int unsigned NOT NULL DEFAULT '0', `owner` int unsigned NOT NULL DEFAULT '0', `modelid` int unsigned DEFAULT '0', - `CreatedBySpell` mediumint unsigned NOT NULL DEFAULT '0', + `CreatedBySpell` int unsigned DEFAULT '0', `PetType` tinyint unsigned NOT NULL DEFAULT '0', `level` smallint unsigned NOT NULL DEFAULT '1', `exp` int unsigned NOT NULL DEFAULT '0', `Reactstate` tinyint unsigned NOT NULL DEFAULT '0', - `name` varchar(21) NOT NULL DEFAULT 'Pet', + `name` varchar(21) 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, + `abdata` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `owner` (`owner`), KEY `idx_slot` (`slot`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Pet System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Pet System'; -- Dumping data for table acore_characters.character_pet: ~0 rows (approximately) DELETE FROM `character_pet`; diff --git a/data/sql/base/db_characters/character_pet_declinedname.sql b/data/sql/base/db_characters/character_pet_declinedname.sql index 9ebdd52ad5..d5871590c6 100644 --- a/data/sql/base/db_characters/character_pet_declinedname.sql +++ b/data/sql/base/db_characters/character_pet_declinedname.sql @@ -19,14 +19,14 @@ 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) NOT NULL DEFAULT '', - `dative` varchar(12) NOT NULL DEFAULT '', - `accusative` varchar(12) NOT NULL DEFAULT '', - `instrumental` varchar(12) NOT NULL DEFAULT '', - `prepositional` varchar(12) NOT NULL DEFAULT '', + `genitive` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `dative` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `accusative` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `instrumental` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `prepositional` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `owner_key` (`owner`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_pet_declinedname: ~0 rows (approximately) DELETE FROM `character_pet_declinedname`; diff --git a/data/sql/base/db_characters/character_queststatus.sql b/data/sql/base/db_characters/character_queststatus.sql index 3ef54adfe4..9f989f0055 100644 --- a/data/sql/base/db_characters/character_queststatus.sql +++ b/data/sql/base/db_characters/character_queststatus.sql @@ -34,7 +34,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus` ( `itemcount6` smallint unsigned NOT NULL DEFAULT '0', `playercount` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_queststatus: ~0 rows (approximately) DELETE FROM `character_queststatus`; diff --git a/data/sql/base/db_characters/character_queststatus_daily.sql b/data/sql/base/db_characters/character_queststatus_daily.sql index 27a4600d92..852b6c5384 100644 --- a/data/sql/base/db_characters/character_queststatus_daily.sql +++ b/data/sql/base/db_characters/character_queststatus_daily.sql @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus_daily` ( `time` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_queststatus_daily: ~0 rows (approximately) DELETE FROM `character_queststatus_daily`; diff --git a/data/sql/base/db_characters/character_queststatus_monthly.sql b/data/sql/base/db_characters/character_queststatus_monthly.sql index d1457874a8..95aeb2f2f2 100644 --- a/data/sql/base/db_characters/character_queststatus_monthly.sql +++ b/data/sql/base/db_characters/character_queststatus_monthly.sql @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus_monthly` ( `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_queststatus_monthly: ~0 rows (approximately) DELETE FROM `character_queststatus_monthly`; diff --git a/data/sql/base/db_characters/character_queststatus_rewarded.sql b/data/sql/base/db_characters/character_queststatus_rewarded.sql index dd2e2ad71f..2d92f14019 100644 --- a/data/sql/base/db_characters/character_queststatus_rewarded.sql +++ b/data/sql/base/db_characters/character_queststatus_rewarded.sql @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus_rewarded` ( `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', `active` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`guid`,`quest`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_queststatus_rewarded: ~0 rows (approximately) DELETE FROM `character_queststatus_rewarded`; diff --git a/data/sql/base/db_characters/character_queststatus_seasonal.sql b/data/sql/base/db_characters/character_queststatus_seasonal.sql index ea6f462c16..1fe5ec0106 100644 --- a/data/sql/base/db_characters/character_queststatus_seasonal.sql +++ b/data/sql/base/db_characters/character_queststatus_seasonal.sql @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus_seasonal` ( `event` int unsigned NOT NULL DEFAULT '0' COMMENT 'Event Identifier', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_queststatus_seasonal: ~0 rows (approximately) DELETE FROM `character_queststatus_seasonal`; diff --git a/data/sql/base/db_characters/character_queststatus_weekly.sql b/data/sql/base/db_characters/character_queststatus_weekly.sql index fececb3e96..6a1359d4b7 100644 --- a/data/sql/base/db_characters/character_queststatus_weekly.sql +++ b/data/sql/base/db_characters/character_queststatus_weekly.sql @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `character_queststatus_weekly` ( `quest` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`guid`,`quest`), KEY `idx_guid` (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_queststatus_weekly: ~0 rows (approximately) DELETE FROM `character_queststatus_weekly`; diff --git a/data/sql/base/db_characters/character_reputation.sql b/data/sql/base/db_characters/character_reputation.sql index 6a788e8b6e..e31bad2c36 100644 --- a/data/sql/base/db_characters/character_reputation.sql +++ b/data/sql/base/db_characters/character_reputation.sql @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_reputation` ( `standing` int NOT NULL DEFAULT '0', `flags` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`faction`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_reputation: ~0 rows (approximately) DELETE FROM `character_reputation`; diff --git a/data/sql/base/db_characters/character_settings.sql b/data/sql/base/db_characters/character_settings.sql index 716e3e6d88..a035684624 100644 --- a/data/sql/base/db_characters/character_settings.sql +++ b/data/sql/base/db_characters/character_settings.sql @@ -18,15 +18,13 @@ DROP TABLE IF EXISTS `character_settings`; CREATE TABLE IF NOT EXISTS `character_settings` ( `guid` int unsigned NOT NULL, - `source` varchar(40) NOT NULL, - `data` text, + `source` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL, + `data` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`,`source`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COMMENT='Player Settings'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player Settings'; --- Dumping data for table acore_characters.character_settings: 0 rows +-- Dumping data for table acore_characters.character_settings: ~0 rows (approximately) DELETE FROM `character_settings`; -/*!40000 ALTER TABLE `character_settings` DISABLE KEYS */; -/*!40000 ALTER TABLE `character_settings` ENABLE KEYS */; /*!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/character_skills.sql b/data/sql/base/db_characters/character_skills.sql index 239fc60bf1..d6db50e4ec 100644 --- a/data/sql/base/db_characters/character_skills.sql +++ b/data/sql/base/db_characters/character_skills.sql @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `character_skills` ( `value` smallint unsigned NOT NULL, `max` smallint unsigned NOT NULL, PRIMARY KEY (`guid`,`skill`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_skills: ~0 rows (approximately) DELETE FROM `character_skills`; diff --git a/data/sql/base/db_characters/character_social.sql b/data/sql/base/db_characters/character_social.sql index 204fdce3d5..9c00d72db0 100644 --- a/data/sql/base/db_characters/character_social.sql +++ b/data/sql/base/db_characters/character_social.sql @@ -20,10 +20,10 @@ 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) NOT NULL DEFAULT '' COMMENT 'Friend Note', + `note` varchar(48) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Friend Note', PRIMARY KEY (`guid`,`friend`,`flags`), KEY `friend` (`friend`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_social: ~0 rows (approximately) DELETE FROM `character_social`; diff --git a/data/sql/base/db_characters/character_spell.sql b/data/sql/base/db_characters/character_spell.sql index f73bf4a38b..8b884dbbc7 100644 --- a/data/sql/base/db_characters/character_spell.sql +++ b/data/sql/base/db_characters/character_spell.sql @@ -18,10 +18,10 @@ DROP TABLE IF EXISTS `character_spell`; CREATE TABLE IF NOT EXISTS `character_spell` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `spell` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', `specMask` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.character_spell: ~0 rows (approximately) DELETE FROM `character_spell`; diff --git a/data/sql/base/db_characters/character_spell_cooldown.sql b/data/sql/base/db_characters/character_spell_cooldown.sql index 802f68e498..b781d8da03 100644 --- a/data/sql/base/db_characters/character_spell_cooldown.sql +++ b/data/sql/base/db_characters/character_spell_cooldown.sql @@ -18,13 +18,13 @@ DROP TABLE IF EXISTS `character_spell_cooldown`; CREATE TABLE IF NOT EXISTS `character_spell_cooldown` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', - `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', - `category` mediumint unsigned NOT NULL DEFAULT '0', + `spell` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `category` int unsigned DEFAULT '0', `item` int unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier', `time` int unsigned NOT NULL DEFAULT '0', `needSend` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_spell_cooldown: ~0 rows (approximately) DELETE FROM `character_spell_cooldown`; diff --git a/data/sql/base/db_characters/character_stats.sql b/data/sql/base/db_characters/character_stats.sql index 30e54b3050..52cad3fb62 100644 --- a/data/sql/base/db_characters/character_stats.sql +++ b/data/sql/base/db_characters/character_stats.sql @@ -50,7 +50,7 @@ CREATE TABLE IF NOT EXISTS `character_stats` ( `resilience` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`), CONSTRAINT `character_stats_chk_1` CHECK (((`blockPct` >= 0) and (`dodgePct` >= 0) and (`parryPct` >= 0) and (`critPct` >= 0) and (`rangedCritPct` >= 0) and (`spellCritPct` >= 0))) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_stats: ~0 rows (approximately) DELETE FROM `character_stats`; diff --git a/data/sql/base/db_characters/character_talent.sql b/data/sql/base/db_characters/character_talent.sql index 6d8f478854..22e668dc3f 100644 --- a/data/sql/base/db_characters/character_talent.sql +++ b/data/sql/base/db_characters/character_talent.sql @@ -18,10 +18,10 @@ DROP TABLE IF EXISTS `character_talent`; CREATE TABLE IF NOT EXISTS `character_talent` ( `guid` int unsigned NOT NULL, - `spell` mediumint unsigned NOT NULL, + `spell` int unsigned NOT NULL, `specMask` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.character_talent: ~0 rows (approximately) DELETE FROM `character_talent`; diff --git a/data/sql/base/db_characters/characters.sql b/data/sql/base/db_characters/characters.sql index 5f56d80795..ce8bb12f64 100644 --- a/data/sql/base/db_characters/characters.sql +++ b/data/sql/base/db_characters/characters.sql @@ -19,7 +19,7 @@ DROP TABLE IF EXISTS `characters`; CREATE TABLE IF NOT EXISTS `characters` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `account` int unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier', - `name` varchar(12) NOT NULL, + `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL, `race` tinyint unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', `gender` tinyint unsigned NOT NULL DEFAULT '0', @@ -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 NOT NULL, + `taximask` text 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', @@ -55,13 +55,13 @@ CREATE TABLE IF NOT EXISTS `characters` ( `trans_y` float NOT NULL DEFAULT '0', `trans_z` float NOT NULL DEFAULT '0', `trans_o` float NOT NULL DEFAULT '0', - `transguid` mediumint NOT NULL DEFAULT '0', + `transguid` int DEFAULT '0', `extra_flags` smallint unsigned NOT NULL DEFAULT '0', `stable_slots` tinyint unsigned NOT NULL DEFAULT '0', `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, + `taxi_path` text 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', @@ -81,26 +81,27 @@ CREATE TABLE IF NOT EXISTS `characters` ( `power5` int unsigned NOT NULL DEFAULT '0', `power6` int unsigned NOT NULL DEFAULT '0', `power7` int unsigned NOT NULL DEFAULT '0', - `latency` mediumint unsigned NOT NULL DEFAULT '0', + `latency` int unsigned DEFAULT '0', `talentGroupsCount` tinyint unsigned NOT NULL DEFAULT '1', `activeTalentGroup` tinyint unsigned NOT NULL DEFAULT '0', - `exploredZones` longtext, - `equipmentCache` longtext, + `exploredZones` longtext COLLATE utf8mb4_unicode_ci, + `equipmentCache` longtext COLLATE utf8mb4_unicode_ci, `ammoId` int unsigned NOT NULL DEFAULT '0', - `knownTitles` longtext, + `knownTitles` longtext 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) DEFAULT NULL, + `deleteInfos_Name` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleteDate` int unsigned DEFAULT NULL, `innTriggerId` int unsigned NOT NULL, + `extraBonusTalentCount` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`), KEY `idx_account` (`account`), KEY `idx_online` (`online`), KEY `idx_name` (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.characters: ~0 rows (approximately) DELETE FROM `characters`; diff --git a/data/sql/base/db_characters/corpse.sql b/data/sql/base/db_characters/corpse.sql index 1de73d779f..56bea9176e 100644 --- a/data/sql/base/db_characters/corpse.sql +++ b/data/sql/base/db_characters/corpse.sql @@ -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 NOT NULL, + `itemCache` text 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', @@ -38,7 +38,7 @@ CREATE TABLE IF NOT EXISTS `corpse` ( KEY `idx_type` (`corpseType`), KEY `idx_instance` (`instanceId`), KEY `idx_time` (`time`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Death System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Death System'; -- Dumping data for table acore_characters.corpse: ~0 rows (approximately) DELETE FROM `corpse`; diff --git a/data/sql/base/db_characters/creature_respawn.sql b/data/sql/base/db_characters/creature_respawn.sql index 1517c8a6ec..fe74eacd46 100644 --- a/data/sql/base/db_characters/creature_respawn.sql +++ b/data/sql/base/db_characters/creature_respawn.sql @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `creature_respawn` ( `instanceId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier', PRIMARY KEY (`guid`,`instanceId`), KEY `idx_instance` (`instanceId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Grid Loading System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Grid Loading System'; -- Dumping data for table acore_characters.creature_respawn: ~0 rows (approximately) DELETE FROM `creature_respawn`; 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 6ea5c43f2e..81f833cc26 100644 --- a/data/sql/base/db_characters/game_event_condition_save.sql +++ b/data/sql/base/db_characters/game_event_condition_save.sql @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `game_event_condition_save` ( `condition_id` int unsigned NOT NULL DEFAULT '0', `done` float DEFAULT '0', PRIMARY KEY (`eventEntry`,`condition_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.game_event_condition_save: ~0 rows (approximately) DELETE FROM `game_event_condition_save`; diff --git a/data/sql/base/db_characters/game_event_save.sql b/data/sql/base/db_characters/game_event_save.sql index af65de3f3e..ff83670efc 100644 --- a/data/sql/base/db_characters/game_event_save.sql +++ b/data/sql/base/db_characters/game_event_save.sql @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `game_event_save` ( `state` tinyint unsigned NOT NULL DEFAULT '1', `next_start` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`eventEntry`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.game_event_save: ~0 rows (approximately) DELETE FROM `game_event_save`; diff --git a/data/sql/base/db_characters/gameobject_respawn.sql b/data/sql/base/db_characters/gameobject_respawn.sql index f8689d4f05..0faf143f65 100644 --- a/data/sql/base/db_characters/gameobject_respawn.sql +++ b/data/sql/base/db_characters/gameobject_respawn.sql @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `gameobject_respawn` ( `instanceId` int unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier', PRIMARY KEY (`guid`,`instanceId`), KEY `idx_instance` (`instanceId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Grid Loading System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Grid Loading System'; -- Dumping data for table acore_characters.gameobject_respawn: ~0 rows (approximately) DELETE FROM `gameobject_respawn`; diff --git a/data/sql/base/db_characters/gm_subsurvey.sql b/data/sql/base/db_characters/gm_subsurvey.sql index 764297f5ed..cdac2f2a64 100644 --- a/data/sql/base/db_characters/gm_subsurvey.sql +++ b/data/sql/base/db_characters/gm_subsurvey.sql @@ -20,9 +20,9 @@ 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 NOT NULL, + `answerComment` text COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`surveyId`,`questionId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.gm_subsurvey: ~0 rows (approximately) DELETE FROM `gm_subsurvey`; diff --git a/data/sql/base/db_characters/gm_survey.sql b/data/sql/base/db_characters/gm_survey.sql index adc437aef7..02b8155f0f 100644 --- a/data/sql/base/db_characters/gm_survey.sql +++ b/data/sql/base/db_characters/gm_survey.sql @@ -20,11 +20,11 @@ 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 NOT NULL, + `comment` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `createTime` int unsigned NOT NULL DEFAULT '0', `maxMMR` smallint NOT NULL, PRIMARY KEY (`surveyId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.gm_survey: ~0 rows (approximately) DELETE FROM `gm_survey`; diff --git a/data/sql/base/db_characters/gm_ticket.sql b/data/sql/base/db_characters/gm_ticket.sql index b4e2de6a81..28f79d07ac 100644 --- a/data/sql/base/db_characters/gm_ticket.sql +++ b/data/sql/base/db_characters/gm_ticket.sql @@ -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) NOT NULL COMMENT 'Name of ticket creator', - `description` text NOT NULL, + `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of ticket creator', + `description` text 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,15 +30,15 @@ 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 NOT NULL, - `response` text NOT NULL, + `comment` text COLLATE utf8mb4_unicode_ci NOT NULL, + `response` text 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', `needMoreHelp` tinyint unsigned NOT NULL DEFAULT '0', `resolvedBy` int NOT NULL DEFAULT '0' COMMENT '-1 Resolved by Console, >0 GUID of GM', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.gm_ticket: ~0 rows (approximately) DELETE FROM `gm_ticket`; diff --git a/data/sql/base/db_characters/group_member.sql b/data/sql/base/db_characters/group_member.sql index d0dae14125..340958efb7 100644 --- a/data/sql/base/db_characters/group_member.sql +++ b/data/sql/base/db_characters/group_member.sql @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `group_member` ( `subgroup` tinyint unsigned NOT NULL DEFAULT '0', `roles` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`memberGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Groups'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Groups'; -- Dumping data for table acore_characters.group_member: ~0 rows (approximately) DELETE FROM `group_member`; diff --git a/data/sql/base/db_characters/groups.sql b/data/sql/base/db_characters/groups.sql index e5ecbd3d8e..b4c9745667 100644 --- a/data/sql/base/db_characters/groups.sql +++ b/data/sql/base/db_characters/groups.sql @@ -36,7 +36,7 @@ CREATE TABLE IF NOT EXISTS `groups` ( `masterLooterGuid` int unsigned NOT NULL, PRIMARY KEY (`guid`), KEY `leaderGuid` (`leaderGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Groups'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Groups'; -- Dumping data for table acore_characters.groups: ~0 rows (approximately) DELETE FROM `groups`; diff --git a/data/sql/base/db_characters/guild.sql b/data/sql/base/db_characters/guild.sql index 8e4135fb20..9a8d361637 100644 --- a/data/sql/base/db_characters/guild.sql +++ b/data/sql/base/db_characters/guild.sql @@ -18,19 +18,19 @@ DROP TABLE IF EXISTS `guild`; CREATE TABLE IF NOT EXISTS `guild` ( `guildid` int unsigned NOT NULL DEFAULT '0', - `name` varchar(24) NOT NULL DEFAULT '', + `name` varchar(24) 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) NOT NULL DEFAULT '', - `motd` varchar(128) NOT NULL DEFAULT '', + `info` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `motd` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `createdate` int unsigned NOT NULL DEFAULT '0', `BankMoney` bigint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; -- Dumping data for table acore_characters.guild: ~0 rows (approximately) DELETE FROM `guild`; diff --git a/data/sql/base/db_characters/guild_bank_eventlog.sql b/data/sql/base/db_characters/guild_bank_eventlog.sql index 39f4786a67..8ff2199d62 100644 --- a/data/sql/base/db_characters/guild_bank_eventlog.sql +++ b/data/sql/base/db_characters/guild_bank_eventlog.sql @@ -30,7 +30,7 @@ CREATE TABLE IF NOT EXISTS `guild_bank_eventlog` ( KEY `guildid_key` (`guildid`), KEY `Idx_PlayerGuid` (`PlayerGuid`), KEY `Idx_LogGuid` (`LogGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.guild_bank_eventlog: ~0 rows (approximately) DELETE FROM `guild_bank_eventlog`; diff --git a/data/sql/base/db_characters/guild_bank_item.sql b/data/sql/base/db_characters/guild_bank_item.sql index ba873569c9..6ccb62b580 100644 --- a/data/sql/base/db_characters/guild_bank_item.sql +++ b/data/sql/base/db_characters/guild_bank_item.sql @@ -24,7 +24,7 @@ CREATE TABLE IF NOT EXISTS `guild_bank_item` ( PRIMARY KEY (`guildid`,`TabId`,`SlotId`), KEY `guildid_key` (`guildid`), KEY `Idx_item_guid` (`item_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.guild_bank_item: ~0 rows (approximately) DELETE FROM `guild_bank_item`; diff --git a/data/sql/base/db_characters/guild_bank_right.sql b/data/sql/base/db_characters/guild_bank_right.sql index f9e3c61529..e8f3e1c9ab 100644 --- a/data/sql/base/db_characters/guild_bank_right.sql +++ b/data/sql/base/db_characters/guild_bank_right.sql @@ -24,7 +24,7 @@ CREATE TABLE IF NOT EXISTS `guild_bank_right` ( `SlotPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`TabId`,`rid`), KEY `guildid_key` (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.guild_bank_right: ~0 rows (approximately) DELETE FROM `guild_bank_right`; diff --git a/data/sql/base/db_characters/guild_bank_tab.sql b/data/sql/base/db_characters/guild_bank_tab.sql index a372181ec0..d05731be64 100644 --- a/data/sql/base/db_characters/guild_bank_tab.sql +++ b/data/sql/base/db_characters/guild_bank_tab.sql @@ -19,12 +19,12 @@ 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) NOT NULL DEFAULT '', - `TabIcon` varchar(100) NOT NULL DEFAULT '', - `TabText` varchar(500) DEFAULT NULL, + `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, PRIMARY KEY (`guildid`,`TabId`), KEY `guildid_key` (`guildid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.guild_bank_tab: ~0 rows (approximately) DELETE FROM `guild_bank_tab`; diff --git a/data/sql/base/db_characters/guild_eventlog.sql b/data/sql/base/db_characters/guild_eventlog.sql index d1fff660b9..9f8b2c87e6 100644 --- a/data/sql/base/db_characters/guild_eventlog.sql +++ b/data/sql/base/db_characters/guild_eventlog.sql @@ -28,7 +28,7 @@ CREATE TABLE IF NOT EXISTS `guild_eventlog` ( KEY `Idx_PlayerGuid1` (`PlayerGuid1`), KEY `Idx_PlayerGuid2` (`PlayerGuid2`), KEY `Idx_LogGuid` (`LogGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild Eventlog'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild Eventlog'; -- Dumping data for table acore_characters.guild_eventlog: ~0 rows (approximately) DELETE FROM `guild_eventlog`; diff --git a/data/sql/base/db_characters/guild_member.sql b/data/sql/base/db_characters/guild_member.sql index 1693c6bdb2..b6a066aa14 100644 --- a/data/sql/base/db_characters/guild_member.sql +++ b/data/sql/base/db_characters/guild_member.sql @@ -20,12 +20,12 @@ 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) NOT NULL DEFAULT '', - `offnote` varchar(31) NOT NULL DEFAULT '', + `pnote` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `offnote` varchar(31) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', UNIQUE KEY `guid_key` (`guid`), KEY `guildid_key` (`guildid`), KEY `guildid_rank_key` (`guildid`,`rank`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; -- Dumping data for table acore_characters.guild_member: ~0 rows (approximately) DELETE FROM `guild_member`; diff --git a/data/sql/base/db_characters/guild_member_withdraw.sql b/data/sql/base/db_characters/guild_member_withdraw.sql index 0f9db9cafe..4736e4ec15 100644 --- a/data/sql/base/db_characters/guild_member_withdraw.sql +++ b/data/sql/base/db_characters/guild_member_withdraw.sql @@ -26,7 +26,7 @@ CREATE TABLE IF NOT EXISTS `guild_member_withdraw` ( `tab5` int unsigned NOT NULL DEFAULT '0', `money` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild Member Daily Withdraws'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild Member Daily Withdraws'; -- Dumping data for table acore_characters.guild_member_withdraw: ~0 rows (approximately) DELETE FROM `guild_member_withdraw`; diff --git a/data/sql/base/db_characters/guild_rank.sql b/data/sql/base/db_characters/guild_rank.sql index d85aa93571..d5c48fa264 100644 --- a/data/sql/base/db_characters/guild_rank.sql +++ b/data/sql/base/db_characters/guild_rank.sql @@ -19,12 +19,12 @@ 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) NOT NULL DEFAULT '', - `rights` mediumint unsigned NOT NULL DEFAULT '0', + `rname` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `rights` int unsigned DEFAULT '0', `BankMoneyPerDay` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guildid`,`rid`), KEY `Idx_rid` (`rid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; -- Dumping data for table acore_characters.guild_rank: ~0 rows (approximately) DELETE FROM `guild_rank`; diff --git a/data/sql/base/db_characters/instance.sql b/data/sql/base/db_characters/instance.sql index 352c56dc27..5574f97d71 100644 --- a/data/sql/base/db_characters/instance.sql +++ b/data/sql/base/db_characters/instance.sql @@ -22,12 +22,12 @@ 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 NOT NULL, + `data` tinytext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `map` (`map`), KEY `resettime` (`resettime`), KEY `difficulty` (`difficulty`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.instance: ~0 rows (approximately) DELETE FROM `instance`; diff --git a/data/sql/base/db_characters/instance_reset.sql b/data/sql/base/db_characters/instance_reset.sql index 983f5a084b..28cc2c98e6 100644 --- a/data/sql/base/db_characters/instance_reset.sql +++ b/data/sql/base/db_characters/instance_reset.sql @@ -22,82 +22,82 @@ CREATE TABLE IF NOT EXISTS `instance_reset` ( `resettime` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`mapid`,`difficulty`), KEY `difficulty` (`difficulty`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- 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, 1675368000), - (249, 1, 1675368000), - (269, 1, 1675166400), - (309, 0, 1675166400), - (409, 0, 1675368000), - (469, 0, 1675368000), - (509, 0, 1675166400), - (531, 0, 1675368000), - (532, 0, 1675368000), - (533, 0, 1675368000), - (533, 1, 1675368000), - (534, 0, 1675368000), - (540, 1, 1675166400), - (542, 1, 1675166400), - (543, 1, 1675166400), - (544, 0, 1675368000), - (545, 1, 1675166400), - (546, 1, 1675166400), - (547, 1, 1675166400), - (548, 0, 1675368000), - (550, 0, 1675368000), - (552, 1, 1675166400), - (553, 1, 1675166400), - (554, 1, 1675166400), - (555, 1, 1675166400), - (556, 1, 1675166400), - (557, 1, 1675166400), - (558, 1, 1675166400), - (560, 1, 1675166400), - (564, 0, 1675368000), - (565, 0, 1675368000), - (568, 0, 1675166400), - (574, 1, 1675166400), - (575, 1, 1675166400), - (576, 1, 1675166400), - (578, 1, 1675195200), - (580, 0, 1675368000), - (585, 1, 1675195200), - (595, 1, 1675195200), - (598, 1, 1675195200), - (599, 1, 1675195200), - (600, 1, 1675195200), - (601, 1, 1675195200), - (602, 1, 1675195200), - (603, 0, 1675368000), - (603, 1, 1675368000), - (604, 1, 1675195200), - (608, 1, 1675195200), - (615, 0, 1675368000), - (615, 1, 1675368000), - (616, 0, 1675368000), - (616, 1, 1675368000), - (619, 1, 1675195200), - (624, 0, 1675368000), - (624, 1, 1675368000), - (631, 0, 1675368000), - (631, 1, 1675368000), - (631, 2, 1675368000), - (631, 3, 1675368000), - (632, 1, 1675195200), - (649, 0, 1675368000), - (649, 1, 1675368000), - (649, 2, 1675368000), - (649, 3, 1675368000), - (650, 1, 1675195200), - (658, 1, 1675195200), - (668, 1, 1675195200), - (724, 0, 1675368000), - (724, 1, 1675368000), - (724, 2, 1675368000), - (724, 3, 1675368000); + (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); /*!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 081a2fb811..0b43674a5d 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 @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `instance_saved_go_state_data` ( `guid` int unsigned NOT NULL COMMENT 'gameobject.guid', `state` tinyint unsigned DEFAULT '0' COMMENT 'gameobject.state', PRIMARY KEY (`id`,`guid`) USING BTREE -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.instance_saved_go_state_data: ~0 rows (approximately) DELETE FROM `instance_saved_go_state_data`; diff --git a/data/sql/base/db_characters/item_instance.sql b/data/sql/base/db_characters/item_instance.sql index babdef8b03..e2a7d498c7 100644 --- a/data/sql/base/db_characters/item_instance.sql +++ b/data/sql/base/db_characters/item_instance.sql @@ -18,22 +18,22 @@ DROP TABLE IF EXISTS `item_instance`; CREATE TABLE IF NOT EXISTS `item_instance` ( `guid` int unsigned NOT NULL DEFAULT '0', - `itemEntry` mediumint unsigned NOT NULL DEFAULT '0', + `itemEntry` int unsigned DEFAULT '0', `owner_guid` int unsigned NOT NULL DEFAULT '0', `creatorGuid` int unsigned NOT NULL DEFAULT '0', `giftCreatorGuid` int unsigned NOT NULL DEFAULT '0', `count` int unsigned NOT NULL DEFAULT '1', `duration` int NOT NULL DEFAULT '0', - `charges` tinytext, - `flags` mediumint unsigned NOT NULL DEFAULT '0', - `enchantments` text NOT NULL, + `charges` tinytext COLLATE utf8mb4_unicode_ci, + `flags` int unsigned DEFAULT '0', + `enchantments` text 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, + `text` text COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`guid`), KEY `idx_owner_guid` (`owner_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Item System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item System'; -- Dumping data for table acore_characters.item_instance: ~0 rows (approximately) DELETE FROM `item_instance`; diff --git a/data/sql/base/db_characters/item_loot_storage.sql b/data/sql/base/db_characters/item_loot_storage.sql index 2109ce26f5..2b4e45767b 100644 --- a/data/sql/base/db_characters/item_loot_storage.sql +++ b/data/sql/base/db_characters/item_loot_storage.sql @@ -30,7 +30,7 @@ CREATE TABLE IF NOT EXISTS `item_loot_storage` ( `is_underthreshold` tinyint unsigned NOT NULL, `needs_quest` tinyint unsigned NOT NULL, `conditionLootId` int NOT NULL DEFAULT '0' -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.item_loot_storage: ~0 rows (approximately) DELETE FROM `item_loot_storage`; diff --git a/data/sql/base/db_characters/item_refund_instance.sql b/data/sql/base/db_characters/item_refund_instance.sql index ec8ff877b4..52c2b25dc8 100644 --- a/data/sql/base/db_characters/item_refund_instance.sql +++ b/data/sql/base/db_characters/item_refund_instance.sql @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS `item_refund_instance` ( `paidMoney` int unsigned NOT NULL DEFAULT '0', `paidExtendedCost` smallint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`item_guid`,`player_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Item Refund System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Refund System'; -- Dumping data for table acore_characters.item_refund_instance: ~0 rows (approximately) DELETE FROM `item_refund_instance`; 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 821b810e11..5933dd64fb 100644 --- a/data/sql/base/db_characters/item_soulbound_trade_data.sql +++ b/data/sql/base/db_characters/item_soulbound_trade_data.sql @@ -18,9 +18,9 @@ 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 NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', + `allowedPlayers` text 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 COMMENT='Item Refund System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Item Refund System'; -- Dumping data for table acore_characters.item_soulbound_trade_data: ~0 rows (approximately) DELETE FROM `item_soulbound_trade_data`; diff --git a/data/sql/base/db_characters/lag_reports.sql b/data/sql/base/db_characters/lag_reports.sql index 8934c974b9..254bb1e207 100644 --- a/data/sql/base/db_characters/lag_reports.sql +++ b/data/sql/base/db_characters/lag_reports.sql @@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS `lag_reports` ( `latency` int unsigned NOT NULL DEFAULT '0', `createTime` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`reportId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System'; -- Dumping data for table acore_characters.lag_reports: ~0 rows (approximately) DELETE FROM `lag_reports`; diff --git a/data/sql/base/db_characters/lfg_data.sql b/data/sql/base/db_characters/lfg_data.sql index ccee2b4c8b..d3f6b9341b 100644 --- a/data/sql/base/db_characters/lfg_data.sql +++ b/data/sql/base/db_characters/lfg_data.sql @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `lfg_data` ( `dungeon` int unsigned NOT NULL DEFAULT '0', `state` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LFG Data'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='LFG Data'; -- Dumping data for table acore_characters.lfg_data: ~0 rows (approximately) DELETE FROM `lfg_data`; diff --git a/data/sql/base/db_characters/log_arena_fights.sql b/data/sql/base/db_characters/log_arena_fights.sql index 2df9eec1c1..7c1c3af5da 100644 --- a/data/sql/base/db_characters/log_arena_fights.sql +++ b/data/sql/base/db_characters/log_arena_fights.sql @@ -31,12 +31,10 @@ CREATE TABLE IF NOT EXISTS `log_arena_fights` ( `loser_tr_change` smallint NOT NULL, `currOnline` int unsigned NOT NULL, PRIMARY KEY (`fight_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; --- Dumping data for table acore_characters.log_arena_fights: 0 rows +-- Dumping data for table acore_characters.log_arena_fights: ~0 rows (approximately) DELETE FROM `log_arena_fights`; -/*!40000 ALTER TABLE `log_arena_fights` DISABLE KEYS */; -/*!40000 ALTER TABLE `log_arena_fights` ENABLE KEYS */; /*!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/log_arena_memberstats.sql b/data/sql/base/db_characters/log_arena_memberstats.sql index 21bf6b7085..7ec0704b59 100644 --- a/data/sql/base/db_characters/log_arena_memberstats.sql +++ b/data/sql/base/db_characters/log_arena_memberstats.sql @@ -19,21 +19,19 @@ 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) NOT NULL, + `name` char(20) COLLATE utf8mb4_unicode_ci NOT NULL, `guid` int unsigned NOT NULL, `team` int unsigned NOT NULL, `account` int unsigned NOT NULL, - `ip` char(15) NOT NULL, + `ip` char(15) COLLATE utf8mb4_unicode_ci NOT NULL, `damage` int unsigned NOT NULL, `heal` int unsigned NOT NULL, `kblows` int unsigned NOT NULL, PRIMARY KEY (`fight_id`,`member_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; --- Dumping data for table acore_characters.log_arena_memberstats: 0 rows +-- Dumping data for table acore_characters.log_arena_memberstats: ~0 rows (approximately) DELETE FROM `log_arena_memberstats`; -/*!40000 ALTER TABLE `log_arena_memberstats` DISABLE KEYS */; -/*!40000 ALTER TABLE `log_arena_memberstats` ENABLE KEYS */; /*!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/log_encounter.sql b/data/sql/base/db_characters/log_encounter.sql index 66afef9297..358b6a073d 100644 --- a/data/sql/base/db_characters/log_encounter.sql +++ b/data/sql/base/db_characters/log_encounter.sql @@ -22,13 +22,11 @@ CREATE TABLE IF NOT EXISTS `log_encounter` ( `difficulty` tinyint unsigned NOT NULL, `creditType` tinyint unsigned NOT NULL, `creditEntry` int unsigned NOT NULL, - `playersInfo` text NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; + `playersInfo` text 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 +-- Dumping data for table acore_characters.log_encounter: ~0 rows (approximately) DELETE FROM `log_encounter`; -/*!40000 ALTER TABLE `log_encounter` DISABLE KEYS */; -/*!40000 ALTER TABLE `log_encounter` ENABLE KEYS */; /*!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/log_money.sql b/data/sql/base/db_characters/log_money.sql index 8d8b4efe66..80f634abdd 100644 --- a/data/sql/base/db_characters/log_money.sql +++ b/data/sql/base/db_characters/log_money.sql @@ -19,20 +19,18 @@ 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 NOT NULL, - `sender_ip` text NOT NULL, + `sender_name` text COLLATE utf8mb4_unicode_ci NOT NULL, + `sender_ip` text COLLATE utf8mb4_unicode_ci NOT NULL, `receiver_acc` int unsigned NOT NULL, - `receiver_name` text NOT NULL, + `receiver_name` text COLLATE utf8mb4_unicode_ci NOT NULL, `money` bigint unsigned NOT NULL, - `topic` text NOT NULL, + `topic` text 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=MyISAM DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; --- Dumping data for table acore_characters.log_money: 0 rows +-- Dumping data for table acore_characters.log_money: ~0 rows (approximately) DELETE FROM `log_money`; -/*!40000 ALTER TABLE `log_money` DISABLE KEYS */; -/*!40000 ALTER TABLE `log_money` ENABLE KEYS */; /*!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/mail.sql b/data/sql/base/db_characters/mail.sql index 61af4366cd..ffeae19fe3 100644 --- a/data/sql/base/db_characters/mail.sql +++ b/data/sql/base/db_characters/mail.sql @@ -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, - `body` longtext, + `subject` longtext COLLATE utf8mb4_unicode_ci, + `body` longtext 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', @@ -33,7 +33,7 @@ CREATE TABLE IF NOT EXISTS `mail` ( `checked` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_receiver` (`receiver`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Mail System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Mail System'; -- Dumping data for table acore_characters.mail: ~0 rows (approximately) DELETE FROM `mail`; diff --git a/data/sql/base/db_characters/mail_items.sql b/data/sql/base/db_characters/mail_items.sql index 257c795673..bc1d646fea 100644 --- a/data/sql/base/db_characters/mail_items.sql +++ b/data/sql/base/db_characters/mail_items.sql @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `mail_items` ( PRIMARY KEY (`item_guid`), KEY `idx_receiver` (`receiver`), KEY `idx_mail_id` (`mail_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.mail_items: ~0 rows (approximately) DELETE FROM `mail_items`; diff --git a/data/sql/base/db_characters/mail_server_character.sql b/data/sql/base/db_characters/mail_server_character.sql index 1086ebd774..d02f6bbadd 100644 --- a/data/sql/base/db_characters/mail_server_character.sql +++ b/data/sql/base/db_characters/mail_server_character.sql @@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `mail_server_character` ( `guid` int unsigned NOT NULL, `mailId` int unsigned NOT NULL, PRIMARY KEY (`guid`,`mailId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.mail_server_character: ~0 rows (approximately) DELETE FROM `mail_server_character`; diff --git a/data/sql/base/db_characters/mail_server_template.sql b/data/sql/base/db_characters/mail_server_template.sql index 34edc0dcfd..ea8e57df48 100644 --- a/data/sql/base/db_characters/mail_server_template.sql +++ b/data/sql/base/db_characters/mail_server_template.sql @@ -26,11 +26,11 @@ 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 NOT NULL, - `body` text NOT NULL, + `subject` text COLLATE utf8mb4_unicode_ci NOT NULL, + `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.mail_server_template: ~0 rows (approximately) DELETE FROM `mail_server_template`; diff --git a/data/sql/base/db_characters/pet_aura.sql b/data/sql/base/db_characters/pet_aura.sql index f863775523..a14174904b 100644 --- a/data/sql/base/db_characters/pet_aura.sql +++ b/data/sql/base/db_characters/pet_aura.sql @@ -19,21 +19,21 @@ DROP TABLE IF EXISTS `pet_aura`; CREATE TABLE IF NOT EXISTS `pet_aura` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', `casterGuid` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier', - `spell` mediumint unsigned NOT NULL DEFAULT '0', + `spell` int unsigned NOT NULL DEFAULT '0', `effectMask` tinyint unsigned NOT NULL DEFAULT '0', `recalculateMask` tinyint unsigned NOT NULL DEFAULT '0', `stackCount` tinyint unsigned NOT NULL DEFAULT '1', - `amount0` mediumint NOT NULL, - `amount1` mediumint NOT NULL, - `amount2` mediumint NOT NULL, - `base_amount0` mediumint NOT NULL, - `base_amount1` mediumint NOT NULL, - `base_amount2` mediumint NOT NULL, + `amount0` int DEFAULT NULL, + `amount1` int DEFAULT NULL, + `amount2` int DEFAULT NULL, + `base_amount0` int DEFAULT NULL, + `base_amount1` int DEFAULT NULL, + `base_amount2` int DEFAULT NULL, `maxDuration` int NOT NULL DEFAULT '0', `remainTime` int NOT NULL DEFAULT '0', `remainCharges` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Pet System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Pet System'; -- Dumping data for table acore_characters.pet_aura: ~0 rows (approximately) DELETE FROM `pet_aura`; diff --git a/data/sql/base/db_characters/pet_spell.sql b/data/sql/base/db_characters/pet_spell.sql index cbc8e6d38b..6b5bfce53b 100644 --- a/data/sql/base/db_characters/pet_spell.sql +++ b/data/sql/base/db_characters/pet_spell.sql @@ -18,10 +18,10 @@ DROP TABLE IF EXISTS `pet_spell`; CREATE TABLE IF NOT EXISTS `pet_spell` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', - `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `spell` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', `active` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Pet System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Pet System'; -- Dumping data for table acore_characters.pet_spell: ~0 rows (approximately) DELETE FROM `pet_spell`; diff --git a/data/sql/base/db_characters/pet_spell_cooldown.sql b/data/sql/base/db_characters/pet_spell_cooldown.sql index ffe1711040..b07ad708b4 100644 --- a/data/sql/base/db_characters/pet_spell_cooldown.sql +++ b/data/sql/base/db_characters/pet_spell_cooldown.sql @@ -18,11 +18,11 @@ DROP TABLE IF EXISTS `pet_spell_cooldown`; CREATE TABLE IF NOT EXISTS `pet_spell_cooldown` ( `guid` int unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part', - `spell` mediumint unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', - `category` mediumint unsigned NOT NULL DEFAULT '0', + `spell` int unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier', + `category` int unsigned DEFAULT '0', `time` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spell`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.pet_spell_cooldown: ~0 rows (approximately) DELETE FROM `pet_spell_cooldown`; diff --git a/data/sql/base/db_characters/petition.sql b/data/sql/base/db_characters/petition.sql index 6a4ee3d221..9d1219a4bc 100644 --- a/data/sql/base/db_characters/petition.sql +++ b/data/sql/base/db_characters/petition.sql @@ -19,11 +19,11 @@ DROP TABLE IF EXISTS `petition`; CREATE TABLE IF NOT EXISTS `petition` ( `ownerguid` int unsigned NOT NULL, `petitionguid` int unsigned DEFAULT '0', - `name` varchar(24) NOT NULL, + `name` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL, `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ownerguid`,`type`), UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; -- Dumping data for table acore_characters.petition: ~0 rows (approximately) DELETE FROM `petition`; diff --git a/data/sql/base/db_characters/petition_sign.sql b/data/sql/base/db_characters/petition_sign.sql index 7dabdb5bc8..b70d50ab3e 100644 --- a/data/sql/base/db_characters/petition_sign.sql +++ b/data/sql/base/db_characters/petition_sign.sql @@ -25,7 +25,7 @@ CREATE TABLE IF NOT EXISTS `petition_sign` ( PRIMARY KEY (`petitionguid`,`playerguid`), KEY `Idx_playerguid` (`playerguid`), KEY `Idx_ownerguid` (`ownerguid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Guild System'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Guild System'; -- Dumping data for table acore_characters.petition_sign: ~0 rows (approximately) DELETE FROM `petition_sign`; diff --git a/data/sql/base/db_characters/pool_quest_save.sql b/data/sql/base/db_characters/pool_quest_save.sql index c18705ace5..98513c3df1 100644 --- a/data/sql/base/db_characters/pool_quest_save.sql +++ b/data/sql/base/db_characters/pool_quest_save.sql @@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `pool_quest_save` ( `pool_id` int unsigned NOT NULL DEFAULT '0', `quest_id` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`pool_id`,`quest_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.pool_quest_save: ~38 rows (approximately) DELETE FROM `pool_quest_save`; diff --git a/data/sql/base/db_characters/profanity_name.sql b/data/sql/base/db_characters/profanity_name.sql new file mode 100644 index 0000000000..4c97724054 --- /dev/null +++ b/data/sql/base/db_characters/profanity_name.sql @@ -0,0 +1,31 @@ +-- -------------------------------------------------------- +-- Host: 127.0.0.1 +-- Server version: 8.0.29 - MySQL Community Server - GPL +-- Server OS: Win64 +-- HeidiSQL Version: 12.0.0.6468 +-- -------------------------------------------------------- + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET NAMES utf8 */; +/*!50503 SET NAMES utf8mb4 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- 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, + PRIMARY KEY (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- Dumping data for table acore_characters.profanity_name: ~0 rows (approximately) +DELETE FROM `profanity_name`; + +/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; +/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; +/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */; diff --git a/data/sql/base/db_characters/pvpstats_battlegrounds.sql b/data/sql/base/db_characters/pvpstats_battlegrounds.sql index ee247af2b0..5924da9390 100644 --- a/data/sql/base/db_characters/pvpstats_battlegrounds.sql +++ b/data/sql/base/db_characters/pvpstats_battlegrounds.sql @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `pvpstats_battlegrounds` ( `type` tinyint unsigned NOT NULL, `date` datetime NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.pvpstats_battlegrounds: ~0 rows (approximately) DELETE FROM `pvpstats_battlegrounds`; diff --git a/data/sql/base/db_characters/pvpstats_players.sql b/data/sql/base/db_characters/pvpstats_players.sql index df55f9817f..666072d0f1 100644 --- a/data/sql/base/db_characters/pvpstats_players.sql +++ b/data/sql/base/db_characters/pvpstats_players.sql @@ -20,19 +20,19 @@ CREATE TABLE IF NOT EXISTS `pvpstats_players` ( `battleground_id` bigint unsigned NOT NULL, `character_guid` int unsigned NOT NULL, `winner` bit(1) NOT NULL, - `score_killing_blows` mediumint unsigned NOT NULL, - `score_deaths` mediumint unsigned NOT NULL, - `score_honorable_kills` mediumint unsigned NOT NULL, - `score_bonus_honor` mediumint unsigned NOT NULL, - `score_damage_done` mediumint unsigned NOT NULL, - `score_healing_done` mediumint unsigned NOT NULL, - `attr_1` mediumint unsigned NOT NULL DEFAULT '0', - `attr_2` mediumint unsigned NOT NULL DEFAULT '0', - `attr_3` mediumint unsigned NOT NULL DEFAULT '0', - `attr_4` mediumint unsigned NOT NULL DEFAULT '0', - `attr_5` mediumint unsigned NOT NULL DEFAULT '0', + `score_killing_blows` int unsigned DEFAULT NULL, + `score_deaths` int unsigned DEFAULT NULL, + `score_honorable_kills` int unsigned DEFAULT NULL, + `score_bonus_honor` int unsigned DEFAULT NULL, + `score_damage_done` int unsigned DEFAULT NULL, + `score_healing_done` int unsigned DEFAULT NULL, + `attr_1` int unsigned DEFAULT '0', + `attr_2` int unsigned DEFAULT '0', + `attr_3` int unsigned DEFAULT '0', + `attr_4` int unsigned DEFAULT '0', + `attr_5` int unsigned DEFAULT '0', PRIMARY KEY (`battleground_id`,`character_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.pvpstats_players: ~0 rows (approximately) DELETE FROM `pvpstats_players`; diff --git a/data/sql/base/db_characters/quest_tracker.sql b/data/sql/base/db_characters/quest_tracker.sql index b560a2a7e2..ecec099b52 100644 --- a/data/sql/base/db_characters/quest_tracker.sql +++ b/data/sql/base/db_characters/quest_tracker.sql @@ -17,15 +17,15 @@ -- Dumping structure for table acore_characters.quest_tracker DROP TABLE IF EXISTS `quest_tracker`; CREATE TABLE IF NOT EXISTS `quest_tracker` ( - `id` mediumint unsigned NOT NULL DEFAULT '0', + `id` int unsigned DEFAULT '0', `character_guid` int unsigned NOT NULL DEFAULT '0', `quest_accept_time` datetime NOT NULL, `quest_complete_time` datetime DEFAULT NULL, `quest_abandon_time` datetime DEFAULT NULL, `completed_by_gm` tinyint NOT NULL DEFAULT '0', - `core_hash` varchar(120) NOT NULL DEFAULT '0', - `core_revision` varchar(120) NOT NULL DEFAULT '0' -) ENGINE=InnoDB DEFAULT CHARSET=latin1; + `core_hash` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', + `core_revision` varchar(120) 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) DELETE FROM `quest_tracker`; diff --git a/data/sql/base/db_characters/recovery_item.sql b/data/sql/base/db_characters/recovery_item.sql index 5f04911486..abde772e58 100644 --- a/data/sql/base/db_characters/recovery_item.sql +++ b/data/sql/base/db_characters/recovery_item.sql @@ -19,11 +19,11 @@ DROP TABLE IF EXISTS `recovery_item`; CREATE TABLE IF NOT EXISTS `recovery_item` ( `Id` int unsigned NOT NULL AUTO_INCREMENT, `Guid` int unsigned NOT NULL DEFAULT '0', - `ItemEntry` mediumint unsigned NOT NULL DEFAULT '0', + `ItemEntry` int unsigned DEFAULT '0', `Count` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`Id`), KEY `idx_guid` (`Guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table acore_characters.recovery_item: ~0 rows (approximately) DELETE FROM `recovery_item`; diff --git a/data/sql/base/db_characters/reserved_name.sql b/data/sql/base/db_characters/reserved_name.sql index 33c86e5056..b2f35a2f58 100644 --- a/data/sql/base/db_characters/reserved_name.sql +++ b/data/sql/base/db_characters/reserved_name.sql @@ -17,9 +17,9 @@ -- Dumping structure for table acore_characters.reserved_name DROP TABLE IF EXISTS `reserved_name`; CREATE TABLE IF NOT EXISTS `reserved_name` ( - `name` varchar(12) NOT NULL DEFAULT '', + `name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`name`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Player Reserved Names'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player Reserved Names'; -- Dumping data for table acore_characters.reserved_name: ~0 rows (approximately) DELETE FROM `reserved_name`; diff --git a/data/sql/base/db_characters/updates.sql b/data/sql/base/db_characters/updates.sql index c6655aae21..a667bcb7e4 100644 --- a/data/sql/base/db_characters/updates.sql +++ b/data/sql/base/db_characters/updates.sql @@ -17,18 +17,39 @@ -- Dumping structure for table acore_characters.updates DROP TABLE IF EXISTS `updates`; CREATE TABLE IF NOT EXISTS `updates` ( - `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.', - `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.', - `state` enum('RELEASED','CUSTOM','MODULE','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', + `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'filename with extension of the update.', + `hash` char(40) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'sha1 hash of the sql file.', + `state` enum('RELEASED','CUSTOM','MODULE','ARCHIVED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.', `speed` int unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) USING BTREE -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='List of all applied updates in this database.'; +) 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: 57 rows +-- Dumping data for table acore_characters.updates: ~61 rows (approximately) DELETE FROM `updates`; -/*!40000 ALTER TABLE `updates` DISABLE KEYS */; 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), @@ -46,28 +67,6 @@ INSERT INTO `updates` (`name`, `hash`, `state`, `timestamp`, `speed`) VALUES ('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), - ('2016_07_09_00.sql', '6CB4253FF700E83A3FCB121714F32E4FFA70F0F4', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_08_14_00.sql', '38462AB366B96C1979F049A5FAF33A1C2DE25E65', '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_08_08_00.sql', '909B26A005C244E715027F8FF31D721D236403AF', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_07_30_00.sql', '7CEA690831DD7B6509FB165BD3C5BFF2138AB867', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2016_08_12_00.sql', '9902E3CD09738DA232C168AA374551C1DB2B902E', '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), - ('2019_12_09_00.sql', '04D33DE31942314C86AC20EA39D74C44228E9819', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2017_09_18_00.sql', '393373BB3CB5525ECF5A69661170AE0B49677AC3', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2018_12_23_00.sql', '0135EE4A7AA472A4BB6F9B76BABE84F8A45645D2', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2018_04_19_00.sql', '1DFB571DEDBACAC579229C7365A2F52330BB84B4', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2019_05_15_00.sql', 'E2D51033471C04D47DA3C091B2FB7D2BBB816E8B', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2019_01_06_00.sql', '043ADFE28ABFBEA7304FCE95183C385646CF78D8', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2018_08_08_00.sql', '8623083F006C05A08D5B1322FF3EFE7304AEB6FC', '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_11_22_00.sql', 'CA433BC426072EF7DDC555B086F65B17BB83CAF5', 'ARCHIVED', '2021-10-14 07:13:44', 1), - ('2020_01_04_00.sql', '7DA0D914F60BE3827068447FE4EA6AA85266E328', 'ARCHIVED', '2021-10-14 07:13:44', 1), ('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), @@ -83,10 +82,13 @@ INSERT INTO `updates` (`name`, `hash`, `state`, `timestamp`, `speed`) VALUES ('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', 'RELEASED', '2023-01-31 23:21:23', 30), - ('2022_10_13_00.sql', '7121BF9B0A15DA47B60438C82F6A8CA382F35D50', 'RELEASED', '2023-01-31 23:21:23', 54), - ('2022_10_20_00.sql', 'BD0C6FF81228F0D56448EBB0648819214835C595', 'RELEASED', '2023-01-31 23:21:23', 33); -/*!40000 ALTER TABLE `updates` ENABLE KEYS */; + ('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); /*!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 621aac3605..1f58762093 100644 --- a/data/sql/base/db_characters/updates_include.sql +++ b/data/sql/base/db_characters/updates_include.sql @@ -17,19 +17,17 @@ -- Dumping structure for table acore_characters.updates_include DROP TABLE IF EXISTS `updates_include`; CREATE TABLE IF NOT EXISTS `updates_include` ( - `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', - `state` enum('RELEASED','ARCHIVED','CUSTOM') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', + `path` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', + `state` enum('RELEASED','ARCHIVED','CUSTOM') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) USING BTREE -) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='List of directories where we want to include sql updates.'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='List of directories where we want to include sql updates.'; --- Dumping data for table acore_characters.updates_include: 3 rows +-- Dumping data for table acore_characters.updates_include: ~3 rows (approximately) DELETE FROM `updates_include`; -/*!40000 ALTER TABLE `updates_include` DISABLE KEYS */; INSERT INTO `updates_include` (`path`, `state`) VALUES - ('$/data/sql/updates/db_characters', 'RELEASED'), + ('$/data/sql/archive/db_characters', 'ARCHIVED'), ('$/data/sql/custom/db_characters', 'CUSTOM'), - ('$/data/sql/archive/db_characters', 'ARCHIVED'); -/*!40000 ALTER TABLE `updates_include` ENABLE KEYS */; + ('$/data/sql/updates/db_characters', 'RELEASED'); /*!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/warden_action.sql b/data/sql/base/db_characters/warden_action.sql index 1ca96fa4c5..0005fa53e0 100644 --- a/data/sql/base/db_characters/warden_action.sql +++ b/data/sql/base/db_characters/warden_action.sql @@ -20,9 +20,9 @@ CREATE TABLE IF NOT EXISTS `warden_action` ( `wardenId` smallint unsigned NOT NULL, `action` tinyint unsigned DEFAULT NULL, PRIMARY KEY (`wardenId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; --- Dumping data for table acore_characters.warden_action: ~0 rows (approximately) +-- Dumping data for table acore_characters.warden_action: ~1 rows (approximately) DELETE FROM `warden_action`; INSERT INTO `warden_action` (`wardenId`, `action`) VALUES (437, 0); diff --git a/data/sql/base/db_characters/worldstates.sql b/data/sql/base/db_characters/worldstates.sql index bd718c70a3..87ee8d847c 100644 --- a/data/sql/base/db_characters/worldstates.sql +++ b/data/sql/base/db_characters/worldstates.sql @@ -19,9 +19,9 @@ 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, + `comment` tinytext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`entry`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Variable Saves'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Variable Saves'; -- Dumping data for table acore_characters.worldstates: ~102 rows (approximately) DELETE FROM `worldstates`; |