# HG changeset patch
# User jbe
# Date 1501942243 -7200
# Node ID 1adb0ad5900cc8e7a66db104cc87de5ce2dd6cee
# Parent  3cde0bb68adf5698080f1c17a9cdeb7d1596054c
Added "discovery_baseurl" for system applications

diff -r 3cde0bb68adf -r 1adb0ad5900c core.sql
--- a/core.sql	Tue Jul 18 12:28:45 2017 +0200
+++ b/core.sql	Sat Aug 05 16:10:43 2017 +0200
@@ -342,6 +342,7 @@
 CREATE TABLE "system_application" (
         "id"                    SERIAL4         PRIMARY KEY,
         "name"                  TEXT            NOT NULL,
+        "discovery_baseurl"     TEXT,
         "client_id"             TEXT            NOT NULL UNIQUE,
         "default_redirect_uri"  TEXT            NOT NULL,
         "cert_common_name"      TEXT,
@@ -354,6 +355,7 @@
 COMMENT ON TABLE "system_application" IS 'OAuth 2.0 clients that are registered by the system administrator';
 
 COMMENT ON COLUMN "system_application"."name"              IS 'Human readable name of application';
+COMMENT ON COLUMN "system_application"."discovery_baseurl" IS 'Base URL for application discovery; NULL for hidden application';
 COMMENT ON COLUMN "system_application"."client_id"         IS 'OAuth 2.0 "client_id"';
 COMMENT ON COLUMN "system_application"."cert_common_name"  IS 'Value for CN field of TLS client certificate';
 COMMENT ON COLUMN "system_application"."client_cred_scope" IS 'Space-separated list of scopes; If set, Client Credentials Grant is allowed; value determines scope';
diff -r 3cde0bb68adf -r 1adb0ad5900c update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Tue Jul 18 12:28:45 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Sat Aug 05 16:10:43 2017 +0200
@@ -269,6 +269,7 @@
 CREATE TABLE "system_application" (
         "id"                    SERIAL4         PRIMARY KEY,
         "name"                  TEXT            NOT NULL,
+        "discovery_baseurl"     TEXT,
         "client_id"             TEXT            NOT NULL UNIQUE,
         "default_redirect_uri"  TEXT            NOT NULL,
         "cert_common_name"      TEXT,
@@ -281,6 +282,7 @@
 COMMENT ON TABLE "system_application" IS 'OAuth 2.0 clients that are registered by the system administrator';
 
 COMMENT ON COLUMN "system_application"."name"              IS 'Human readable name of application';
+COMMENT ON COLUMN "system_application"."discovery_baseurl" IS 'Base URL for application discovery; NULL for hidden application';
 COMMENT ON COLUMN "system_application"."client_id"         IS 'OAuth 2.0 "client_id"';
 COMMENT ON COLUMN "system_application"."cert_common_name"  IS 'Value for CN field of TLS client certificate';
 COMMENT ON COLUMN "system_application"."client_cred_scope" IS 'Space-separated list of scopes; If set, Client Credentials Grant is allowed; value determines scope';