liquid_feedback_core
changeset 548:1adb0ad5900c
Added "discovery_baseurl" for system applications
author | jbe |
---|---|
date | Sat Aug 05 16:10:43 2017 +0200 (2017-08-05) |
parents | 3cde0bb68adf |
children | 81a35235b450 |
files | core.sql update/core-update.v3.2.2-v4.0.0.sql |
line diff
1.1 --- a/core.sql Tue Jul 18 12:28:45 2017 +0200 1.2 +++ b/core.sql Sat Aug 05 16:10:43 2017 +0200 1.3 @@ -342,6 +342,7 @@ 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 "client_id" TEXT NOT NULL UNIQUE, 1.9 "default_redirect_uri" TEXT NOT NULL, 1.10 "cert_common_name" TEXT, 1.11 @@ -354,6 +355,7 @@ 1.12 COMMENT ON TABLE "system_application" IS 'OAuth 2.0 clients that are registered by the system administrator'; 1.13 1.14 COMMENT ON COLUMN "system_application"."name" IS 'Human readable name of application'; 1.15 +COMMENT ON COLUMN "system_application"."discovery_baseurl" IS 'Base URL for application discovery; NULL for hidden application'; 1.16 COMMENT ON COLUMN "system_application"."client_id" IS 'OAuth 2.0 "client_id"'; 1.17 COMMENT ON COLUMN "system_application"."cert_common_name" IS 'Value for CN field of TLS client certificate'; 1.18 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.v3.2.2-v4.0.0.sql Tue Jul 18 12:28:45 2017 +0200 2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Sat Aug 05 16:10:43 2017 +0200 2.3 @@ -269,6 +269,7 @@ 2.4 CREATE TABLE "system_application" ( 2.5 "id" SERIAL4 PRIMARY KEY, 2.6 "name" TEXT NOT NULL, 2.7 + "discovery_baseurl" TEXT, 2.8 "client_id" TEXT NOT NULL UNIQUE, 2.9 "default_redirect_uri" TEXT NOT NULL, 2.10 "cert_common_name" TEXT, 2.11 @@ -281,6 +282,7 @@ 2.12 COMMENT ON TABLE "system_application" IS 'OAuth 2.0 clients that are registered by the system administrator'; 2.13 2.14 COMMENT ON COLUMN "system_application"."name" IS 'Human readable name of application'; 2.15 +COMMENT ON COLUMN "system_application"."discovery_baseurl" IS 'Base URL for application discovery; NULL for hidden application'; 2.16 COMMENT ON COLUMN "system_application"."client_id" IS 'OAuth 2.0 "client_id"'; 2.17 COMMENT ON COLUMN "system_application"."cert_common_name" IS 'Value for CN field of TLS client certificate'; 2.18 COMMENT ON COLUMN "system_application"."client_cred_scope" IS 'Space-separated list of scopes; If set, Client Credentials Grant is allowed; value determines scope';