summaryrefslogtreecommitdiff
path: root/sql/pg.sql
diff options
context:
space:
mode:
authorAlexey Shchepin <alexey@process-one.net>2019-09-27 20:36:35 +0300
committerAlexey Shchepin <alexey@process-one.net>2019-09-27 20:36:58 +0300
commit8f7fa3894902ed2181b45723388ee9087b92c18a (patch)
treeb4d448d361f7de5ea3886592a840a6b7d252e73e /sql/pg.sql
parentAdvertise muc#roominfo_logs in disco#info of the room (diff)
Support OAUTH client authentication
Diffstat (limited to '')
-rw-r--r--sql/pg.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/pg.sql b/sql/pg.sql
index eae98d3f..0f87fd5d 100644
--- a/sql/pg.sql
+++ b/sql/pg.sql
@@ -358,6 +358,13 @@ CREATE TABLE oauth_token (
CREATE UNIQUE INDEX i_oauth_token_token ON oauth_token USING btree (token);
+CREATE TABLE oauth_client (
+ client text PRIMARY KEY,
+ secret text NOT NULL,
+ grant_type text NOT NULL,
+ options text NOT NULL
+);
+
CREATE TABLE route (
domain text NOT NULL,
server_host text NOT NULL,