Mercurial > gemma
changeset 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 | 56fa02c93766 |
| children | d9da1ea14abf |
| files | schema/default_sysconfig.sql schema/gemma.sql schema/install-db.sh |
| diffstat | 3 files changed, 27 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- /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;
--- 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
--- 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" \