Mercurial > gemma

changeset 91:c38edd879e2e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add profile attributes.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jun 2018 19:50:58 +0200
parents a8878834adfb
children f11366b419ae
files wamos.sql
diffstat 1 files changed, 13 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Fri Jun 01 19:32:44 2018 +0200
+++ b/wamos.sql	Fri Jun 01 19:50:58 2018 +0200
@@ -195,10 +195,20 @@
        FOR EACH ROW EXECUTE PROCEDURE update_date_info();
 
 CREATE TABLE wamos_waterway.waterway_profiles (
-       dummy_attrib varchar,
-       "..." varchar
-       -- TODO: add real profile attributes (DRC 2.2.3)
+       location isrs NOT NULL,
+       validity tstzrange NOT NULL,
+       EXCLUDE USING GIST (validity WITH &&),
+       PRIMARY KEY (location, validity),
+       lnwl smallint,
+       mwl smallint,
+       hnwl smallint,
+       fe30 smallint,
+       fe100 smallint,
+       date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
+       source_organization varchar NOT NULL
        );
+CREATE TRIGGER waterway_profiles_date_info BEFORE UPDATE ON waterway_profiles
+       FOR EACH ROW EXECUTE PROCEDURE update_date_info();
 
 CREATE TABLE wamos_waterway.levels_of_service (
        level_of_service smallint PRIMARY KEY