Mercurial > gemma

changeset 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 da04fa72cee8
children 1a565f8a935a
files schema/gemma.sql schema/updates/1440/01.add_zpg_exception.sql schema/version.sql
diffstat 3 files changed, 3 insertions(+), 1 deletions(-) [+]
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,
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema/updates/1440/01.add_zpg_exception.sql	Wed May 19 16:48:04 2021 +0200
@@ -0,0 +1,1 @@
+ALTER TABLE waterway.sounding_results ADD COLUMN zpg_exception bool NOT NULL DEFAULT FALSE;
--- a/schema/version.sql	Tue Mar 02 15:11:15 2021 +0100
+++ b/schema/version.sql	Wed May 19 16:48:04 2021 +0200
@@ -1,1 +1,1 @@
-INSERT INTO gemma_schema_version(version) VALUES (1439);
+INSERT INTO gemma_schema_version(version) VALUES (1440);