From 9055894d1026c1c63e3495fc311a405f9c50c182 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Sun, 16 May 2021 02:21:36 -0300 Subject: Try a few changes, see if MariaDB gets happy - but then, we *don't* use MariaDB. --- sql-files/main.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/sql-files/main.sql b/sql-files/main.sql index 65435e710..7e3310d0e 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -309,11 +309,11 @@ CREATE TABLE IF NOT EXISTS `charlog` ( CREATE TABLE IF NOT EXISTS `discord` ( `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', - `discord_id` VARCHAR(255) NOT NULL DEFAULT '', + `discord_id` VARCHAR(25) NOT NULL DEFAULT '', `discord_name` VARCHAR(255) NOT NULL DEFAULT '', `verified` ENUM('0', '1') NOT NULL DEFAULT '0', - PRIMARY KEY (`discord_name`), - UNIQUE KEY (`account_id`) + PRIMARY KEY (`account_id`), + UNIQUE KEY `name_key` (`discord_name`) ) ENGINE=MyISAM; -- -- cgit v1.2.3-60-g2f50