liquid_feedback_core

changeset 575:8771e783d898

Split-up "discovery_baseurl" into "base_url" and "manifest_url"
author jbe
date Mon Oct 23 14:35:35 2017 +0200 (2017-10-23)
parents 2cb4a7d9e6e9
children eb5f4e4f17d8
files core.sql update/core-update.v4.0.0-v4.0.1.sql
line diff
     1.1 --- a/core.sql	Mon Oct 02 19:38:04 2017 +0200
     1.2 +++ b/core.sql	Mon Oct 23 14:35:35 2017 +0200
     1.3 @@ -382,7 +382,8 @@
     1.4  CREATE TABLE "system_application" (
     1.5          "id"                    SERIAL4         PRIMARY KEY,
     1.6          "name"                  TEXT            NOT NULL,
     1.7 -        "discovery_baseurl"     TEXT,
     1.8 +        "base_url"              TEXT,
     1.9 +        "manifest_url"          TEXT,
    1.10          "client_id"             TEXT            NOT NULL UNIQUE,
    1.11          "default_redirect_uri"  TEXT            NOT NULL,
    1.12          "cert_common_name"      TEXT,
    1.13 @@ -395,7 +396,8 @@
    1.14  COMMENT ON TABLE "system_application" IS 'OAuth 2.0 clients that are registered by the system administrator';
    1.15  
    1.16  COMMENT ON COLUMN "system_application"."name"              IS 'Human readable name of application';
    1.17 -COMMENT ON COLUMN "system_application"."discovery_baseurl" IS 'Base URL for application discovery; NULL for hidden application';
    1.18 +COMMENT ON COLUMN "system_application"."base_url"          IS 'Base URL for users; NULL for hidden application';
    1.19 +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';
    1.20  COMMENT ON COLUMN "system_application"."client_id"         IS 'OAuth 2.0 "client_id"';
    1.21  COMMENT ON COLUMN "system_application"."cert_common_name"  IS 'Value for CN field of TLS client certificate';
    1.22  COMMENT ON COLUMN "system_application"."client_cred_scope" IS 'Space-separated list of scopes; If set, Client Credentials Grant is allowed; value determines scope';
     2.1 --- a/update/core-update.v4.0.0-v4.0.1.sql	Mon Oct 02 19:38:04 2017 +0200
     2.2 +++ b/update/core-update.v4.0.0-v4.0.1.sql	Mon Oct 23 14:35:35 2017 +0200
     2.3 @@ -10,4 +10,10 @@
     2.4        SELECT NULL FROM "token" AS "other"
     2.5        WHERE "other"."authorization_token_id" = "token"."id" ) );
     2.6  
     2.7 +ALTER TABLE "system_application" RENAME COLUMN "discovery_baseurl" TO "base_url";
     2.8 +ALTER TABLE "system_application" ADD COLUMN "manifest_url" TEXT;
     2.9 +
    2.10 +COMMENT ON COLUMN "system_application"."base_url"     IS 'Base URL for users; NULL for hidden application';
    2.11 +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';
    2.12 +
    2.13  COMMIT;

Impressum / About Us