# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1550756625 -3600
# Node ID 89a3096e198831fdc07b9ad020a92b6ce82ebb43
# Parent  96b0314f2bd609293d321a12ef378c33376a7b2b
Schema: Dropped wrong constraints in gauges.geodref.

diff -r 96b0314f2bd6 -r 89a3096e1988 schema/gemma.sql
--- a/schema/gemma.sql	Thu Feb 21 12:21:42 2019 +0100
+++ b/schema/gemma.sql	Thu Feb 21 14:43:45 2019 +0100
@@ -243,7 +243,7 @@
         -- (a gauge is not a berth!)
         -- TODO: Ranges need a joint exclusion constaint to prevent overlaps?
         zero_point double precision NOT NULL,
-        geodref varchar(4) REFERENCES depth_references,
+        geodref varchar,
         date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
         source_organization varchar
     )