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:42:19 +0200 |
| commit | 40361a95dadb7bd6e760d684a23ba19e544ca40f (patch) | |
| tree | f7a1a6cf02d6db0f554d45c0f3733c15eb45f98d /sql/base/characters_database.sql | |
| parent | ecd1903f05c61e28bce1496b29d04f7b6cfb3d1f (diff) | |
DB: Fixed player name uniqueness checks
Diffstat (limited to 'sql/base/characters_database.sql')
| -rw-r--r-- | sql/base/characters_database.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 77de88e7914..a5eb4f7a664 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1879,7 +1879,7 @@ DROP TABLE IF EXISTS `characters`; CREATE TABLE `characters` ( `guid` bigint 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, `slot` tinyint unsigned NOT NULL DEFAULT '0', `race` tinyint unsigned NOT NULL DEFAULT '0', `class` tinyint unsigned NOT NULL DEFAULT '0', @@ -3706,7 +3706,8 @@ INSERT INTO `updates` VALUES ('2023_02_03_00_characters.sql','A04BA4386B3D5C60407D22CA4BF9A4A6258AA39D','ARCHIVED','2023-02-03 01:13:52',0), ('2023_02_08_00_characters.sql','C9DF607CCE99540F613F5E25E17090176C995C7C','ARCHIVED','2023-02-08 21:41:17',0), ('2023_04_02_00_characters.sql','AAC1B81AFE4716CF4DAB6BCF01D22F421BFAD253','ARCHIVED','2023-04-02 01:02:26',0), -('2023_05_04_00_characters.sql','9AC370E51507F5BD368707E90D8F6BF0FF16CA09','RELEASED','2023-05-04 16:17:31',0); +('2023_05_04_00_characters.sql','9AC370E51507F5BD368707E90D8F6BF0FF16CA09','RELEASED','2023-05-04 16:17:31',0), +('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','RELEASED','2023-05-19 18:40:42',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; |