Mercurial > gemma

changeset 60:f0ca64da9446

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add attribute to mark data sets as checked in staging area.
author Tom Gottfried <tom@intevation.de>
date Fri, 25 May 2018 15:42:57 +0200
parents 37faa7359ea6
children a5749fd004c3
files wamos.sql
diffstat 1 files changed, 4 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Thu May 24 14:41:41 2018 +0200
+++ b/wamos.sql	Fri May 25 15:42:57 2018 +0200
@@ -113,8 +113,9 @@
        depth_reference char(3) NOT NULL REFERENCES depth_references,
        -- XXX: Also an attribut of sounding result?
        date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
-       source_organization varchar NOT NULL
+       source_organization varchar NOT NULL,
        -- additional_data xml -- Currently not relevant for WAMOS
+       staging_done boolean NOT NULL DEFAULT false
        );
 CREATE TRIGGER bottleneck_date_info BEFORE UPDATE ON bottlenecks
        FOR EACH ROW EXECUTE PROCEDURE update_date_info();
@@ -134,7 +135,8 @@
        surtyp varchar NOT NULL REFERENCES survey_types,
        coverage varchar REFERENCES coverage_types,
        depth_reference char(3) NOT NULL REFERENCES depth_references,
-       sounding_data raster NOT NULL
+       sounding_data raster NOT NULL,
+       staging_done boolean NOT NULL DEFAULT false
        );
 
 --