# HG changeset patch
# User jbe
# Date 1508762135 -7200
# Node ID 8771e783d89818edc8c0d078be52e9d63cf9d362
# Parent  2cb4a7d9e6e9fb438c2b0384fe31c5db67e7893b
Split-up "discovery_baseurl" into "base_url" and "manifest_url"

diff -r 2cb4a7d9e6e9 -r 8771e783d898 core.sql
--- a/core.sql	Mon Oct 02 19:38:04 2017 +0200
+++ b/core.sql	Mon Oct 23 14:35:35 2017 +0200
@@ -382,7 +382,8 @@
 CREATE TABLE "system_application" (
         "id"                    SERIAL4         PRIMARY KEY,
         "name"                  TEXT            NOT NULL,
-        "discovery_baseurl"     TEXT,
+        "base_url"              TEXT,
+        "manifest_url"          TEXT,
         "client_id"             TEXT            NOT NULL UNIQUE,
         "default_redirect_uri"  TEXT            NOT NULL,
         "cert_common_name"      TEXT,
@@ -395,7 +396,8 @@
 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"."base_url"          IS 'Base URL for users; NULL for hidden application';
+COMMENT ON COLUMN "system_application"."manifest_url"      IS 'URL referring to a manifest that can be used for application (type/version) 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 2cb4a7d9e6e9 -r 8771e783d898 update/core-update.v4.0.0-v4.0.1.sql
--- a/update/core-update.v4.0.0-v4.0.1.sql	Mon Oct 02 19:38:04 2017 +0200
+++ b/update/core-update.v4.0.0-v4.0.1.sql	Mon Oct 23 14:35:35 2017 +0200
@@ -10,4 +10,10 @@
       SELECT NULL FROM "token" AS "other"
       WHERE "other"."authorization_token_id" = "token"."id" ) );
 
+ALTER TABLE "system_application" RENAME COLUMN "discovery_baseurl" TO "base_url";
+ALTER TABLE "system_application" ADD COLUMN "manifest_url" TEXT;
+
+COMMENT ON COLUMN "system_application"."base_url"     IS 'Base URL for users; NULL for hidden application';
+COMMENT ON COLUMN "system_application"."manifest_url" IS 'URL referring to a manifest that can be used for application (type/version) discovery; NULL for hidden application';
+
 COMMIT;