diff options
| author | Alexey Shchepin <alexey@process-one.net> | 2019-10-03 06:18:07 +0300 |
|---|---|---|
| committer | Alexey Shchepin <alexey@process-one.net> | 2019-10-03 06:18:48 +0300 |
| commit | 5d549dca96c643345ba92e67504e67eb1b6b0681 (patch) | |
| tree | 8228edfd0595643c869420d1506e76ebf5c45146 /sql | |
| parent | Update Guide links in WebAdmin to website, as local file isn't included (diff) | |
Check redirect_uri for OAUTH implicit grant
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/lite.sql | 4 | ||||
| -rw-r--r-- | sql/mysql.new.sql | 7 | ||||
| -rw-r--r-- | sql/mysql.sql | 4 | ||||
| -rw-r--r-- | sql/pg.new.sql | 7 | ||||
| -rw-r--r-- | sql/pg.sql | 4 |
5 files changed, 20 insertions, 6 deletions
diff --git a/sql/lite.sql b/sql/lite.sql index c77922c20..0b6bb12c1 100644 --- a/sql/lite.sql +++ b/sql/lite.sql @@ -339,8 +339,8 @@ CREATE TABLE oauth_token ( ); CREATE TABLE oauth_client ( - client text PRIMARY KEY, - secret text NOT NULL, + client_id text PRIMARY KEY, + client_name text NOT NULL, grant_type text NOT NULL, options text NOT NULL ); diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql index b2f9acfd4..15843fc7d 100644 --- a/sql/mysql.new.sql +++ b/sql/mysql.new.sql @@ -384,6 +384,13 @@ CREATE TABLE oauth_token ( expire bigint NOT NULL ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +CREATE TABLE oauth_client ( + client_id varchar(191) NOT NULL PRIMARY KEY, + client_name 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 varchar(191) NOT NULL, diff --git a/sql/mysql.sql b/sql/mysql.sql index 7f415a2e4..7afc2cf1a 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -355,8 +355,8 @@ CREATE TABLE oauth_token ( ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; CREATE TABLE oauth_client ( - client varchar(191) NOT NULL PRIMARY KEY, - secret text NOT NULL, + client_id varchar(191) NOT NULL PRIMARY KEY, + client_name text NOT NULL, grant_type text NOT NULL, options text NOT NULL ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; diff --git a/sql/pg.new.sql b/sql/pg.new.sql index c585fd307..1a3d52316 100644 --- a/sql/pg.new.sql +++ b/sql/pg.new.sql @@ -529,6 +529,13 @@ CREATE TABLE oauth_token ( CREATE UNIQUE INDEX i_oauth_token_token ON oauth_token USING btree (token); +CREATE TABLE oauth_client ( + client_id text PRIMARY KEY, + client_name 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/pg.sql b/sql/pg.sql index 0f87fd5d8..34d9a4867 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -359,8 +359,8 @@ 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, + client_id text PRIMARY KEY, + client_name text NOT NULL, grant_type text NOT NULL, options text NOT NULL ); |