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
 );