diff options
| author | Shauren <shauren.trinity@gmail.com> | 2023-05-19 18:42:19 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2023-05-19 18:43:53 +0200 |
| commit | fb388298a0bf76402a6f1de35bdfcb33223d51bb (patch) | |
| tree | eb14b0ad2fd01fc22155e00c74fec90842fd1776 | |
| parent | ad44c19ed70461ba1533131e8bfe8b553af76a90 (diff) | |
DB: Fixed player name uniqueness checks
(cherry picked from commit 40361a95dadb7bd6e760d684a23ba19e544ca40f)
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/master/2023_05_19_00_characters.sql | 1 |
2 files changed, 4 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index a517c89c8ac..b2dc3eaa1cf 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1340,7 +1340,7 @@ DROP TABLE IF EXISTS `characters`; CREATE TABLE `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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `race` tinyint unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', `gender` tinyint unsigned NOT NULL DEFAULT '0', @@ -2679,7 +2679,8 @@ INSERT INTO `updates` VALUES ('2022_10_17_00_characters.sql','3E50C54495FE2653EB2F5F9120B17D124D70CEDE','ARCHIVED','2022-10-17 09:02:28',0), ('2023_01_16_00_characters.sql','2667390C8E0EC1E5CDE16784BFCD8F8749C7D73E','ARCHIVED','2023-01-16 11:06:30',0), ('2023_02_05_00_characters.sql','DD3F2181CC472A040EC4AE49EBB057C1FAA5BE10','RELEASED','2023-01-16 14:51:30',0), -('2023_02_05_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','RELEASED','2023-02-05 15:58:32',0); +('2023_02_05_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','RELEASED','2023-02-05 15:58:32',0), +('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','RELEASED','2023-05-19 18:40:42',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2023_05_19_00_characters.sql b/sql/updates/characters/master/2023_05_19_00_characters.sql new file mode 100644 index 00000000000..5ee51f5062b --- /dev/null +++ b/sql/updates/characters/master/2023_05_19_00_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `characters` MODIFY `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL AFTER `account`; |