# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1551439477 -3600
# Node ID 7ca6bdb2d1749f1345113a35d7baa1acb21b06af
# Parent  6694603471a53117f4226265d225b97196e6f08d
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.

diff -r 6694603471a5 -r 7ca6bdb2d174 schema/gemma.sql
--- 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,