aboutsummaryrefslogtreecommitdiff
path: root/sql/lite.sql
diff options
context:
space:
mode:
authorBadlop <badlop@process-one.net>2016-03-29 12:37:49 +0200
committerBadlop <badlop@process-one.net>2016-03-29 12:37:49 +0200
commite386bf6b58876436e8048ab327da883cc3dfb108 (patch)
treebe09e32706aa453f63c17086ab5c234fbad01c2c /sql/lite.sql
parentMerge branch 'master' of github.com:processone/ejabberd (diff)
In SQL files create Users table with SCRAM support by default (#956)
Diffstat (limited to 'sql/lite.sql')
-rw-r--r--sql/lite.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/lite.sql b/sql/lite.sql
index 0cf7ff414..1741ea950 100644
--- a/sql/lite.sql
+++ b/sql/lite.sql
@@ -19,6 +19,9 @@
CREATE TABLE users (
username text PRIMARY KEY,
password text NOT NULL,
+ serverkey text NOT NULL DEFAULT '',
+ salt text NOT NULL DEFAULT '',
+ iterationcount integer NOT NULL DEFAULT 0,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);