summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2022-02-06 15:12:29 -0300
committerJesusaves <cpntb1@ymail.com>2022-02-06 15:12:29 -0300
commitd6413381ca726a8359a168260f3a0a5db6e8c4db (patch)
tree4e401ca180cb36661ff5b12b4e3b9db5842edb16
parent0b9d7bd56357a46c3d759648a9059f65eaacb444 (diff)
downloadserverdata-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.yml2
-rw-r--r--sql-files/main.sql2
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;
--