From 646b701211bb6e7ad583c27281d67d6cf7065da6 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 17 May 2023 02:54:35 +0300
Subject: Upgrade `oauth2_registered_client` table schema

---
 src/main/resources/db/migration/V1.47__oauth_postlogout.sql | 2 ++
 src/main/resources/schema-h2.sql                            | 1 +
 src/main/resources/schema-mysql.sql                         | 1 +
 src/main/resources/schema-sqlite.sql                        | 1 +
 src/main/resources/schema-sqlserver.sql                     | 1 +
 5 files changed, 6 insertions(+)
 create mode 100644 src/main/resources/db/migration/V1.47__oauth_postlogout.sql

(limited to 'src/main/resources')

diff --git a/src/main/resources/db/migration/V1.47__oauth_postlogout.sql b/src/main/resources/db/migration/V1.47__oauth_postlogout.sql
new file mode 100644
index 00000000..c35bcfbb
--- /dev/null
+++ b/src/main/resources/db/migration/V1.47__oauth_postlogout.sql
@@ -0,0 +1,2 @@
+alter table oauth2_registered_client add column post_logout_redirect_uris varchar (1000) default null
+
diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql
index 8b786382..97b16799 100644
--- a/src/main/resources/schema-h2.sql
+++ b/src/main/resources/schema-h2.sql
@@ -173,6 +173,7 @@ CREATE MEMORY TABLE "PUBLIC"."OAUTH2_REGISTERED_CLIENT"(
     "CLIENT_AUTHENTICATION_METHODS" CHARACTER VARYING(1000) NOT NULL,
     "AUTHORIZATION_GRANT_TYPES" CHARACTER VARYING(1000) NOT NULL,
     "REDIRECT_URIS" CHARACTER VARYING(1000) DEFAULT NULL,
+    "POST_LOGOUT_REDIRECT_URIS" CHARACTER VARYING(1000) DEFAULT NULL,
     "SCOPES" CHARACTER VARYING(1000) NOT NULL,
     "CLIENT_SETTINGS" CHARACTER VARYING(2000) NOT NULL,
     "TOKEN_SETTINGS" CHARACTER VARYING(2000) NOT NULL
diff --git a/src/main/resources/schema-mysql.sql b/src/main/resources/schema-mysql.sql
index d0943254..0bee0ed6 100644
--- a/src/main/resources/schema-mysql.sql
+++ b/src/main/resources/schema-mysql.sql
@@ -281,6 +281,7 @@ CREATE TABLE `oauth2_registered_client` (
   `client_authentication_methods` varchar(1000) NOT NULL,
   `authorization_grant_types` varchar(1000) NOT NULL,
   `redirect_uris` varchar(1000) DEFAULT NULL,
+  `post_logout_redirect_uris` varchar(1000) DEFAULT NULL,
   `scopes` varchar(1000) NOT NULL,
   `client_settings` varchar(2000) NOT NULL,
   `token_settings` varchar(2000) NOT NULL,
diff --git a/src/main/resources/schema-sqlite.sql b/src/main/resources/schema-sqlite.sql
index ae1f4317..2b32635e 100644
--- a/src/main/resources/schema-sqlite.sql
+++ b/src/main/resources/schema-sqlite.sql
@@ -271,6 +271,7 @@ CREATE TABLE oauth2_registered_client (
     client_authentication_methods varchar(1000) NOT NULL,
     authorization_grant_types varchar(1000) NOT NULL,
     redirect_uris varchar(1000) DEFAULT NULL,
+    post_logout_redirect_uris varchar(1000) DEFAULT NULL,
     scopes varchar(1000) NOT NULL,
     client_settings varchar(2000) NOT NULL,
     token_settings varchar(2000) NOT NULL,
diff --git a/src/main/resources/schema-sqlserver.sql b/src/main/resources/schema-sqlserver.sql
index 34032b67..11e07b7b 100644
--- a/src/main/resources/schema-sqlserver.sql
+++ b/src/main/resources/schema-sqlserver.sql
@@ -270,6 +270,7 @@ CREATE TABLE oauth2_registered_client (
     client_authentication_methods varchar(1000) NOT NULL,
     authorization_grant_types varchar(1000) NOT NULL,
     redirect_uris varchar(1000) DEFAULT NULL,
+    post_logout_redirect_uris varchar(1000) DEFAULT NULL,
     scopes varchar(1000) NOT NULL,
     client_settings varchar(2000) NOT NULL,
     token_settings varchar(2000) NOT NULL,
-- 
cgit v1.2.3