diff options
| author | Alexey Shchepin <alexey@process-one.net> | 2015-02-17 23:26:31 +0300 |
|---|---|---|
| committer | Alexey Shchepin <alexey@process-one.net> | 2015-03-20 13:45:24 +0300 |
| commit | e575c87ea2cf56f5bdc604a271cd259387bc927c (patch) | |
| tree | 8638337190540aab2436653efb5f2d5550e63e34 /sql | |
| parent | Add a missed SQL index on privacy_list_data table (diff) | |
Add SCRAM support to ejabberd_auth_odbc
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mysql.sql | 4 | ||||
| -rw-r--r-- | sql/pg.sql | 4 |
2 files changed, 8 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, diff --git a/sql/pg.sql b/sql/pg.sql index 9df8ffd9f..8412c3c6b 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -22,6 +22,10 @@ CREATE TABLE users ( created_at TIMESTAMP NOT NULL DEFAULT now() ); +-- 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 text PRIMARY KEY, |