diff options
| author | Kitzunu <24550914+Kitzunu@users.noreply.github.com> | 2023-09-10 12:25:32 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2023-09-10 12:25:32 +0200 |
| commit | fe084836c5686e4494429e8e11277c74d63d5dd1 (patch) | |
| tree | ed12b648bf4eb4223df2fe557cf673915826fcb6 | |
| parent | dc995447767ba06a1293ad50a36ef4be93131d0e (diff) | |
DB: Allow reserved_name to be accent-sensitive
Closes #29310
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/3.3.5/2023_09_10_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 7edbe051fa2..42411ef0c95 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2535,7 +2535,7 @@ DROP TABLE IF EXISTS `reserved_name`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reserved_name` ( - `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `name` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player Reserved Names'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2681,7 +2681,8 @@ INSERT INTO `updates` VALUES ('2023_02_05_00_characters.sql','DD3F2181CC472A040EC4AE49EBB057C1FAA5BE10','ARCHIVED','2023-01-16 14:51:30',0), ('2023_02_05_01_characters.sql','336E62A8850A3E78A1D0BD3E81FFD5769184BDF8','ARCHIVED','2023-02-05 15:58:32',0), ('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','ARCHIVED','2023-05-19 18:40:42',0), -('2023_06_14_00_characters.sql','0595B21DCFC0A04F2D8DF1F7BC018C758895DBE5','ARCHIVED','2023-06-14 19:34:24',0); +('2023_06_14_00_characters.sql','0595B21DCFC0A04F2D8DF1F7BC018C758895DBE5','ARCHIVED','2023-06-14 19:34:24',0), +('2023_09_10_00_characters.sql','5DE09CA31B5168CF3622CB462816B6C598893D96','RELEASED','2023-09-10 12:23:34',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/3.3.5/2023_09_10_00_characters.sql b/sql/updates/characters/3.3.5/2023_09_10_00_characters.sql new file mode 100644 index 00000000000..32fc15f8809 --- /dev/null +++ b/sql/updates/characters/3.3.5/2023_09_10_00_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `reserved_name` MODIFY `name` VARCHAR(12) NOT NULL COLLATE utf8mb4_bin; |