# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1527255777 -7200
# Node ID f0ca64da944611d84715002193a7ba66461eb0d3
# Parent  37faa7359ea6dcd4efd53ea1924e98bd46d50d61
Add attribute to mark data sets as checked in staging area.

diff -r 37faa7359ea6 -r f0ca64da9446 wamos.sql
--- 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
        );
 
 --