summaryrefslogtreecommitdiff
path: root/sql/lite.sql
diff options
context:
space:
mode:
authorAlexey Shchepin <alexey@process-one.net>2016-08-01 16:53:25 +0300
committerAlexey Shchepin <alexey@process-one.net>2016-08-01 16:55:43 +0300
commit4add262090653e3b2e026f9181247c31acdf6090 (patch)
tree0145c68126a4aebf291217190a2c57241b6bbba6 /sql/lite.sql
parentImplement gen_mod callback in ModPresenceDemo module (diff)
Add OAUTH SQL backend
Diffstat (limited to 'sql/lite.sql')
-rw-r--r--sql/lite.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/lite.sql b/sql/lite.sql
index 1741ea95..aacea11e 100644
--- a/sql/lite.sql
+++ b/sql/lite.sql
@@ -313,3 +313,10 @@ CREATE TABLE sm (
CREATE UNIQUE INDEX i_sm_sid ON sm(usec, pid);
CREATE INDEX i_sm_node ON sm(node);
CREATE INDEX i_sm_username ON sm(username);
+
+CREATE TABLE oauth_token (
+ token text NOT NULL PRIMARY KEY,
+ jid text NOT NULL,
+ scope text NOT NULL,
+ expire bigint NOT NULL
+);