summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql-files/main.sql6
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;
--