diff options
| author | Jesusaves <cpntb1@ymail.com> | 2021-05-16 02:21:36 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2021-05-16 02:21:36 -0300 |
| commit | 9055894d1026c1c63e3495fc311a405f9c50c182 (patch) | |
| tree | 7d08adca9ec447f712921790434d1083efe78822 /sql-files/main.sql | |
| parent | ff7c4a84eadd2bfd9b5c3ea4a7ddbc9fcd9bd45b (diff) | |
| download | serverdata-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.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; -- |