Mercurial > gemma

comparison schema/gemma.sql @ 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 0aedae39726e
children 99274fed6f3d
comparison
equal deleted inserted replaced
2368:96b0314f2bd6 2369:89a3096e1988
241 validity tstzrange, 241 validity tstzrange,
242 -- pasted text from a more general specification is given 242 -- pasted text from a more general specification is given
243 -- (a gauge is not a berth!) 243 -- (a gauge is not a berth!)
244 -- TODO: Ranges need a joint exclusion constaint to prevent overlaps? 244 -- TODO: Ranges need a joint exclusion constaint to prevent overlaps?
245 zero_point double precision NOT NULL, 245 zero_point double precision NOT NULL,
246 geodref varchar(4) REFERENCES depth_references, 246 geodref varchar,
247 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, 247 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
248 source_organization varchar 248 source_organization varchar
249 ) 249 )
250 CREATE TRIGGER gauges_date_info BEFORE UPDATE ON gauges 250 CREATE TRIGGER gauges_date_info BEFORE UPDATE ON gauges
251 FOR EACH ROW EXECUTE PROCEDURE update_date_info() 251 FOR EACH ROW EXECUTE PROCEDURE update_date_info()