Mercurial > gemma
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