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;