diff options
| author | Alexey Shchepin <alexey@process-one.net> | 2019-09-27 20:36:35 +0300 |
|---|---|---|
| committer | Alexey Shchepin <alexey@process-one.net> | 2019-09-27 20:36:58 +0300 |
| commit | 8f7fa3894902ed2181b45723388ee9087b92c18a (patch) | |
| tree | b4d448d361f7de5ea3886592a840a6b7d252e73e /sql | |
| parent | Advertise muc#roominfo_logs in disco#info of the room (diff) | |
Support OAUTH client authentication
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/lite.sql | 7 | ||||
| -rw-r--r-- | sql/mysql.sql | 7 | ||||
| -rw-r--r-- | sql/pg.sql | 7 |
3 files changed, 21 insertions, 0 deletions
diff --git a/sql/lite.sql b/sql/lite.sql index e8755029c..c77922c20 100644 --- a/sql/lite.sql +++ b/sql/lite.sql @@ -338,6 +338,13 @@ CREATE TABLE oauth_token ( expire bigint NOT NULL ); +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, diff --git a/sql/mysql.sql b/sql/mysql.sql index a05f8c86c..7f415a2e4 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -354,6 +354,13 @@ CREATE TABLE oauth_token ( expire bigint NOT NULL ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +CREATE TABLE oauth_client ( + client varchar(191) NOT NULL PRIMARY KEY, + secret text NOT NULL, + grant_type text NOT NULL, + options text NOT NULL +) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + CREATE TABLE route ( domain text NOT NULL, server_host text NOT NULL, diff --git a/sql/pg.sql b/sql/pg.sql index eae98d3f0..0f87fd5d8 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, |