Mercurial > gemma

changeset 2369:89a3096e1988

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Schema: Dropped wrong constraints in gauges.geodref.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 21 Feb 2019 14:43:45 +0100
parents 96b0314f2bd6
children 7fe2f5d334dc
files schema/gemma.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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
     )