diff options
author | Jesusaves <cpntb1@ymail.com> | 2022-02-06 15:12:29 -0300 |
---|---|---|
committer | Jesusaves <cpntb1@ymail.com> | 2022-02-06 15:12:29 -0300 |
commit | d6413381ca726a8359a168260f3a0a5db6e8c4db (patch) | |
tree | 4e401ca180cb36661ff5b12b4e3b9db5842edb16 | |
parent | 0b9d7bd56357a46c3d759648a9059f65eaacb444 (diff) | |
download | serverdata-d6413381ca726a8359a168260f3a0a5db6e8c4db.tar.gz serverdata-d6413381ca726a8359a168260f3a0a5db6e8c4db.tar.bz2 serverdata-d6413381ca726a8359a168260f3a0a5db6e8c4db.tar.xz serverdata-d6413381ca726a8359a168260f3a0a5db6e8c4db.zip |
Discord name tag cannot be longer than 32 chars + tag, so 40 should be OK.
See-Also: https://bugs.mysql.com/bug.php?id=4541
-rw-r--r-- | .gitlab-ci.yml | 2 | ||||
-rw-r--r-- | sql-files/main.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/.gitlab-ci.yml b/.gitlab-ci.yml index c6c3d0555..350b1c58e 100644 --- a/.gitlab-ci.yml +++ b/.gitlab-ci.yml @@ -87,7 +87,7 @@ mysql_run_5.7: gcc-7 git-core make autoconf automake autopoint apt-utils - libssl1.0-dev libtool libmysqlclient-dev libz-dev libpcre3-dev" + libssl-dev openssl libtool libmysqlclient-dev libz-dev libpcre3-dev" - ls /usr/include/openssl/ - grep -nR CRYPTO_new_ex_data /usr/include/openssl/ - ls /usr/lib/x86_64-linux-gnu/ | grep libcrypto #locate libcrypto.so diff --git a/sql-files/main.sql b/sql-files/main.sql index 89fd5b1ed..2cd86f6fd 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -313,7 +313,7 @@ CREATE TABLE IF NOT EXISTS `discord` ( `discord_name` VARCHAR(255) NOT NULL DEFAULT '', `verified` ENUM('0', '1') NOT NULL DEFAULT '0', PRIMARY KEY (`account_id`), - UNIQUE KEY `name_key` (`discord_name`) + UNIQUE KEY `name_key` (`discord_name`(40)) ) ENGINE=MyISAM; -- |