diff schema/gemma.sql @ 831:fa417ff1f355

Extended schema to save feature style information.
author Sascha Wilde <wilde@intevation.de>
date Thu, 27 Sep 2018 23:59:36 +0200
parents d32516051d08
children f0b6852c14d1 69394644bc73
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Sep 27 23:46:36 2018 +0200
+++ b/schema/gemma.sql	Thu Sep 27 23:59:36 2018 +0200
@@ -176,6 +176,19 @@
     country char(2) NOT NULL REFERENCES users.responsibility_areas;
 
 
+-- Namespace for system wide configuration
+CREATE SCHEMA systemconf
+    CREATE TABLE feature_colours (
+        feature_name varchar,
+        style_attr varchar,
+        r int NOT NULL CHECK (r >= 0 AND r < 256),
+        g int NOT NULL CHECK (g >= 0 AND g < 256),
+        b int NOT NULL CHECK (b >= 0 AND b < 256),
+        a numeric NOT NULL CHECK (a >= 0 AND a <= 1),
+        PRIMARY KEY (feature_name, style_attr)
+    )
+;
+
 -- Namespace for waterway data that can change in a running system
 CREATE SCHEMA waterway