From e386bf6b58876436e8048ab327da883cc3dfb108 Mon Sep 17 00:00:00 2001
From: Badlop <badlop@process-one.net>
Date: Tue, 29 Mar 2016 12:37:49 +0200
Subject: In SQL files create Users table with SCRAM support by default (#956)

---
 sql/mssql.sql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'sql/mssql.sql')

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 
 (
-- 
cgit v1.2.3