Mercurial > gemma

diff schema/updates/1402/01.group_layers.sql @ 4930:8b83b18a1d49 fairway-marks-import

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added database models for group layers.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 14 Feb 2020 17:31:17 +0100
parents
children 45ef039cf4a8
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1402/01.group_layers.sql	Fri Feb 14 17:31:17 2020 +0100
@@ -0,0 +1,14 @@
+CREATE TABLE sys_admin.layer_groups (
+    name varchar PRIMARY KEY
+);
+
+CREATE TABLE sys_admin.grouped_layers (
+    group_name varchar REFERENCES sys_admin.layer_groups ON DELETE CASCADE,
+    schema     varchar,
+    name       varchar,
+    ord        int NOT NULL DEFAULT 0,
+    PRIMARY KEY (group_name, schema, name),
+    UNIQUE (group_name, schema, name, ord),
+    FOREIGN KEY(schema, name) REFERENCES sys_admin.published_services
+);
+