diff options
| -rw-r--r-- | sql-files/main.sql | 6 |
1 files 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; -- |