diff options
| author | Badlop <badlop@process-one.net> | 2016-03-29 12:37:49 +0200 |
|---|---|---|
| committer | Badlop <badlop@process-one.net> | 2016-03-29 12:37:49 +0200 |
| commit | e386bf6b58876436e8048ab327da883cc3dfb108 (patch) | |
| tree | be09e32706aa453f63c17086ab5c234fbad01c2c /sql/mssql.sql | |
| parent | Merge branch 'master' of github.com:processone/ejabberd (diff) | |
In SQL files create Users table with SCRAM support by default (#956)
Diffstat (limited to '')
| -rw-r--r-- | sql/mssql.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/mssql.sql b/sql/mssql.sql index 155ea64a0..675542b68 100644 --- a/sql/mssql.sql +++ b/sql/mssql.sql @@ -362,6 +362,9 @@ WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW CREATE TABLE [dbo].[users] (
[username] [varchar] (250) NOT NULL,
[password] [text] NOT NULL,
+ [serverkey] [text] NOT NULL,
+ [salt] [text] NOT NULL,
+ [iterationcount] [smallint] NOT NULL DEFAULT 0,
[created_at] [datetime] NOT NULL DEFAULT GETDATE(),
CONSTRAINT [users_PRIMARY] PRIMARY KEY CLUSTERED
(
|