Mercurial > gemma

changeset 437:b8366b24dc55

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
+    )
 ;
 
 --