Mercurial > gemma

diff schema/gemma.sql @ 5304:6cf4fdaa93f9 zpg-exception

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added new ZPG exception column to sounding result table.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 19 May 2021 16:48:04 +0200
parents f11b9b50fcc9
children 4a6feb5d3727 ac1986c23889
line wrap: on
line diff
--- a/schema/gemma.sql	Tue Mar 02 15:11:15 2021 +0100
+++ b/schema/gemma.sql	Wed May 19 16:48:04 2021 +0200
@@ -798,6 +798,7 @@
         surtyp varchar REFERENCES survey_types,
         coverage varchar REFERENCES coverage_types,
         depth_reference varchar NOT NULL, -- REFERENCES depth_references,
+        zpg_exception bool NOT NULL DEFAULT FALSE, -- Found no LDC in ZPG case.
         octree_checksum varchar,
         octree_index bytea,
         mesh_checksum varchar,