Copy oauth details from profile_service
@@ -104,3 +104,13 @@ ALTER TABLE `PROCESS_OUTPUT` ADD COLUMN IF NOT EXISTS METADATA VARCHAR(4096);
ALTER TABLE `PROCESS` ADD COLUMN IF NOT EXISTS `GROUP_RESOURCE_PROFILE_ID` varchar(255) DEFAULT NULL;
ALTER TABLE `USER_CONFIGURATION_DATA` ADD IF NOT EXISTS `GROUP_RESOURCE_PROFILE_ID` varchar(255) DEFAULT NULL;
+
+-- Copy OAUTH_CLIENT_ID and OAUTH_CLIENT_SECRET from profile_service.GATEWAY
+update GATEWAY g
+inner join profile_service.GATEWAY pg
+on pg.GATEWAY_ID = g.GATEWAY_ID
+set g.OAUTH_CLIENT_ID = pg.OAUTH_CLIENT_ID,
+ g.OAUTH_CLIENT_SECRET = pg.OAUTH_CLIENT_SECRET
+where
+ g.OAUTH_CLIENT_ID is null
+ or g.OAUTH_CLIENT_SECRET is null;
