diff options
Diffstat (limited to 'sql/mysql.sql')
| -rw-r--r-- | sql/mysql.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/mysql.sql b/sql/mysql.sql index e591092f7..c79d3062b 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -22,6 +22,10 @@ CREATE TABLE users ( created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB CHARACTER SET utf8; +-- To support SCRAM auth: +-- ALTER TABLE users ADD COLUMN serverkey text NOT NULL DEFAULT ''; +-- ALTER TABLE users ADD COLUMN salt text NOT NULL DEFAULT ''; +-- ALTER TABLE users ADD COLUMN iterationcount integer NOT NULL DEFAULT 0; CREATE TABLE last ( username varchar(250) PRIMARY KEY, |