Mercurial > gemma
changeset 60:f0ca64da9446
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 ); --