diff options
| author | Nikat <nikita.a.sergeev@mail.ru> | 2021-05-20 14:32:50 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-05-20 13:32:50 +0200 |
| commit | 7b334998116316d1772b1ce1395818d755308bf0 (patch) | |
| tree | 11c9ea6d3aba66b4642f2b078a0eeaacff4650cf /sql | |
| parent | Align numbers in WebAdmin tables to the right (diff) | |
MySQL Backend Patch for scram-sha512 (#3582)
* Update mysql.new.sql
scram-sha512 does not work, because serverkey is longer, then that array. All passwords was unhashed.
* Update mysql.sql
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mysql.new.sql | 4 | ||||
| -rw-r--r-- | sql/mysql.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql index ed4f93348..c6d74bb91 100644 --- a/sql/mysql.new.sql +++ b/sql/mysql.new.sql @@ -20,8 +20,8 @@ CREATE TABLE users ( username varchar(191) NOT NULL, server_host varchar(191) NOT NULL, password text NOT NULL, - serverkey varchar(64) NOT NULL DEFAULT '', - salt varchar(64) NOT NULL DEFAULT '', + serverkey varchar(128) NOT NULL DEFAULT '', + salt varchar(128) NOT NULL DEFAULT '', iterationcount integer NOT NULL DEFAULT 0, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (server_host(191), username) diff --git a/sql/mysql.sql b/sql/mysql.sql index 33ef98d30..7feaf5d0a 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -19,8 +19,8 @@ CREATE TABLE users ( username varchar(191) PRIMARY KEY, password text NOT NULL, - serverkey varchar(64) NOT NULL DEFAULT '', - salt varchar(64) NOT NULL DEFAULT '', + serverkey varchar(128) NOT NULL DEFAULT '', + salt varchar(128) NOT NULL DEFAULT '', iterationcount integer NOT NULL DEFAULT 0, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; |