From 8f7fa3894902ed2181b45723388ee9087b92c18a Mon Sep 17 00:00:00 2001
From: Alexey Shchepin <alexey@process-one.net>
Date: Fri, 27 Sep 2019 20:36:35 +0300
Subject: Support OAUTH client authentication

---
 sql/lite.sql  | 7 +++++++
 sql/mysql.sql | 7 +++++++
 sql/pg.sql    | 7 +++++++
 3 files changed, 21 insertions(+)

(limited to 'sql')

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