From 9e9e3e9555693f8eb5da999e05bb792de602f296 Mon Sep 17 00:00:00 2001
From: Jesusaves <cpntb1@ymail.com>
Date: Sat, 15 May 2021 22:16:22 -0300
Subject: Refactor @discord command.

---
 sql-files/main.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'sql-files/main.sql')

diff --git a/sql-files/main.sql b/sql-files/main.sql
index e2280d225..3aebdaba1 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -311,7 +311,9 @@ CREATE TABLE IF NOT EXISTS `discord` (
   `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
   `discord_id` VARCHAR(255) NOT NULL DEFAULT '',
   `discord_name` VARCHAR(255) NOT NULL DEFAULT '',
-  `verified` ENUM('0', '1') NOT NULL DEFAULT '0'
+  `verified` ENUM('0', '1') NOT NULL DEFAULT '0',
+  PRIMARY KEY (`discord_name`),
+  UNIQUE KEY `account_id` (`account_id`)
 ) ENGINE=MyISAM;
 
 --
-- 
cgit v1.2.3-70-g09d2

