Mercurial > gemma
changeset 437:b8366b24dc55
Added two tables to configure the WFS/WMS services of gemma.
* sys_admin.external_services maps a local name to an external URL.
* sys_admin.published_services publishes tables from the database
with an optional style as WMS and/or WFS.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 20 Aug 2018 18:10:55 +0200 |
parents | 8feb64128c34 |
children | ffdb507d5b42 |
files | schema/gemma.sql |
diffstat | 1 files changed, 13 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Mon Aug 20 17:58:56 2018 +0200 +++ b/schema/gemma.sql Mon Aug 20 18:10:55 2018 +0200 @@ -55,6 +55,19 @@ config_key varchar PRIMARY KEY, config_val varchar ) + + CREATE TABLE sys_admin.external_services ( + local_name varchar PRIMARY KEY, + remote_url varchar NOT NULL, + is_wfs boolean NOT NULL DEFAULT TRUE + ) + + CREATE TABLE sys_admin.published_services ( + name varchar PRIMARY KEY, + style bytea, + as_wms boolean NOT NULL DEFAULT TRUE, + as_wfs boolean NOT NULL DEFAULT TRUE + ) ; --