Mercurial > gemma

changeset 88:a96fee9654db

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add sections and stretches attributes.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jun 2018 19:18:18 +0200
parents c46fb3f1faeb
children a36bfec5edd3
files wamos.sql
diffstat 1 files changed, 6 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Fri Jun 01 19:12:31 2018 +0200
+++ b/wamos.sql	Fri Jun 01 19:18:18 2018 +0200
@@ -186,10 +186,13 @@
        id varchar PRIMARY KEY,
        is_section boolean NOT NULL, -- maps 'function' from interface
        stretch isrsrange,
-       dummy_attrib varchar,
-       "..." varchar
-       -- TODO: add real section/stretch attributes (DRC 2.2.1)
+       objnam varchar NOT NULL,
+       nobjnam varchar,
+       date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
+       source_organization varchar NOT NULL
        );
+CREATE TRIGGER sections_stretches_date_info BEFORE UPDATE ON sections_stretches
+       FOR EACH ROW EXECUTE PROCEDURE update_date_info();
 
 CREATE TABLE wamos_waterway.waterway_profiles (
        dummy_attrib varchar,