# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1538085576 -7200
# Node ID fa417ff1f3556762256c3b45c5f4eb795ab404e9
# Parent  56fa02c937667580f63c1c9798ec353c935579f4
Extended schema to save feature style information.

diff -r 56fa02c93766 -r fa417ff1f355 schema/default_sysconfig.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/default_sysconfig.sql	Thu Sep 27 23:59:36 2018 +0200
@@ -0,0 +1,13 @@
+BEGIN;
+
+--
+-- Default system configurations for the GEMMA database
+--
+
+--
+-- Style definitions
+--
+INSERT INTO systemconf.feature_colours VALUES ('Bottlenecks', 'stroke', 220, 220, 0, 1);
+INSERT INTO systemconf.feature_colours VALUES ('Bottlenecks', 'fill', 230, 230, 10, 0.8);
+
+COMMIT;
diff -r 56fa02c93766 -r fa417ff1f355 schema/gemma.sql
--- 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
 
diff -r 56fa02c93766 -r fa417ff1f355 schema/install-db.sh
--- a/schema/install-db.sh	Thu Sep 27 23:46:36 2018 +0200
+++ b/schema/install-db.sh	Thu Sep 27 23:59:36 2018 +0200
@@ -113,6 +113,7 @@
 
   if [[ $demo -eq 1 ]] ; then
     psql -qv ON_ERROR_STOP= -p "$port" \
+         -f "$BASEDIR/demo-data/default_sysconfig.sql" \
          -f "$BASEDIR/demo-data/responsibility_areas.sql" \
          -f "$BASEDIR/demo-data/users.sql" -d "$db"
     psql -q -p "$port" -f "$BASEDIR/demo-data/roles.sql" \