diff options
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, |