Mercurial > gemma

changeset 2444:7ca6bdb2d174

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
depth_reference in sounding data must be more permissive. Basically this must match a depth_reference in gauges_reference_water_levels, and therefor must be equally permissive.
author Sascha Wilde <wilde@intevation.de>
date Fri, 01 Mar 2019 12:24:37 +0100
parents 6694603471a5
children e0f423606929
files schema/gemma.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Mar 01 12:14:36 2019 +0100
+++ b/schema/gemma.sql	Fri Mar 01 12:24:37 2019 +0100
@@ -482,7 +482,7 @@
             CHECK(ST_IsValid(CAST(area AS geometry))),
         surtyp varchar REFERENCES survey_types,
         coverage varchar REFERENCES coverage_types,
-        depth_reference varchar(4) NOT NULL REFERENCES depth_references,
+        depth_reference varchar(4) NOT NULL, -- REFERENCES depth_references,
         point_cloud geography(MULTIPOINTZ, 4326) NOT NULL
             CHECK(ST_IsSimple(CAST(point_cloud AS geometry))),
         octree_checksum varchar,