From d6413381ca726a8359a168260f3a0a5db6e8c4db Mon Sep 17 00:00:00 2001
From: Jesusaves <cpntb1@ymail.com>
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

