From d6413381ca726a8359a168260f3a0a5db6e8c4db Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Sun, 6 Feb 2022 15:12:29 -0300 Subject: Discord name tag cannot be longer than 32 chars + tag, so 40 should be OK. See-Also: https://bugs.mysql.com/bug.php?id=4541 --- sql-files/main.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql-files/main.sql') diff --git a/sql-files/main.sql b/sql-files/main.sql index 89fd5b1ed..2cd86f6fd 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -313,7 +313,7 @@ CREATE TABLE IF NOT EXISTS `discord` ( `discord_name` VARCHAR(255) NOT NULL DEFAULT '', `verified` ENUM('0', '1') NOT NULL DEFAULT '0', PRIMARY KEY (`account_id`), - UNIQUE KEY `name_key` (`discord_name`) + UNIQUE KEY `name_key` (`discord_name`(40)) ) ENGINE=MyISAM; -- -- cgit v1.2.3-70-g09d2