summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2021-05-16 02:21:36 -0300
committerJesusaves <cpntb1@ymail.com>2021-05-16 02:21:36 -0300
commit9055894d1026c1c63e3495fc311a405f9c50c182 (patch)
tree7d08adca9ec447f712921790434d1083efe78822 /sql-files/main.sql
parentff7c4a84eadd2bfd9b5c3ea4a7ddbc9fcd9bd45b (diff)
downloadserverdata-9055894d1026c1c63e3495fc311a405f9c50c182.tar.gz
serverdata-9055894d1026c1c63e3495fc311a405f9c50c182.tar.bz2
serverdata-9055894d1026c1c63e3495fc311a405f9c50c182.tar.xz
serverdata-9055894d1026c1c63e3495fc311a405f9c50c182.zip
Try a few changes, see if MariaDB gets happy - but then, we *don't* use MariaDB.
Diffstat (limited to 'sql-files/main.sql')
-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;
--