Mercurial > gemma
changeset 2369:89a3096e1988
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 )