From 5d549dca96c643345ba92e67504e67eb1b6b0681 Mon Sep 17 00:00:00 2001
From: Alexey Shchepin <alexey@process-one.net>
Date: Thu, 3 Oct 2019 06:18:07 +0300
Subject: Check redirect_uri for OAUTH implicit grant

---
 sql/lite.sql      | 4 ++--
 sql/mysql.new.sql | 7 +++++++
 sql/mysql.sql     | 4 ++--
 sql/pg.new.sql    | 7 +++++++
 sql/pg.sql        | 4 ++--
 5 files changed, 20 insertions(+), 6 deletions(-)

(limited to 'sql')

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
 );
-- 
cgit v1.2.3