Mercurial > gemma
changeset 88:a96fee9654db
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,