diff options
| author | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2016-04-08 13:02:08 +0300 |
|---|---|---|
| committer | Evgeniy Khramtsov <ekhramtsov@process-one.net> | 2016-04-08 13:02:08 +0300 |
| commit | c5dbdfc71ac8595b6c21e0020f5d41bdbce38e4e (patch) | |
| tree | 40d73b5a644a1ea63eb2b0203990d229b4fed95b /sql | |
| parent | Make sure that ejabberd_sm sid are unique (diff) | |
'serverkey' and 'salt' should have empty string as default
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mssql.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/mssql.sql b/sql/mssql.sql index 675542b68..45378d246 100644 --- a/sql/mssql.sql +++ b/sql/mssql.sql @@ -362,8 +362,8 @@ 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,
+ [serverkey] [text] NOT NULL DEFAULT '',
+ [salt] [text] NOT NULL DEFAULT '',
[iterationcount] [smallint] NOT NULL DEFAULT 0,
[created_at] [datetime] NOT NULL DEFAULT GETDATE(),
CONSTRAINT [users_PRIMARY] PRIMARY KEY CLUSTERED
|