summaryrefslogtreecommitdiff
path: root/sql/mssql.sql
diff options
context:
space:
mode:
authorMickael Remond <mremond@process-one.net>2016-03-29 13:05:22 +0200
committerMickael Remond <mremond@process-one.net>2016-03-29 13:06:13 +0200
commit3b2d0fd24a0203ecf72da19e06d4740a8d33b46e (patch)
treefb00310ec5ce8bc86f3b2c27b32d104efc72c389 /sql/mssql.sql
parentFix commands access check. (diff)
parentPass noauth when auth isn't provided, reverts a1129dc (processone/ejabberd-co... (diff)
Fix commands access check.
Fixes ECS-20
Diffstat (limited to 'sql/mssql.sql')
-rw-r--r--sql/mssql.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/mssql.sql b/sql/mssql.sql
index 155ea64a..675542b6 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
(