Mercurial > gemma

comparison wamos.sql @ 92:f11366b419ae

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix profile constraints.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jun 2018 20:08:47 +0200
parents c38edd879e2e
children 765906789840
comparison
equal deleted inserted replaced
91:c38edd879e2e 92:f11366b419ae
194 CREATE TRIGGER sections_stretches_date_info BEFORE UPDATE ON sections_stretches 194 CREATE TRIGGER sections_stretches_date_info BEFORE UPDATE ON sections_stretches
195 FOR EACH ROW EXECUTE PROCEDURE update_date_info(); 195 FOR EACH ROW EXECUTE PROCEDURE update_date_info();
196 196
197 CREATE TABLE wamos_waterway.waterway_profiles ( 197 CREATE TABLE wamos_waterway.waterway_profiles (
198 location isrs NOT NULL, 198 location isrs NOT NULL,
199 validity tstzrange NOT NULL, 199 validity tstzrange,
200 EXCLUDE USING GIST (validity WITH &&), 200 EXCLUDE USING GIST (validity WITH &&),
201 PRIMARY KEY (location, validity), 201 PRIMARY KEY (location, validity),
202 lnwl smallint, 202 lnwl smallint,
203 mwl smallint, 203 mwl smallint,
204 hnwl smallint, 204 hnwl smallint,
205 fe30 smallint, 205 fe30 smallint,
206 fe100 smallint, 206 fe100 smallint,
207 -- XXX: further normalise using reference_water_levels?
208 CHECK(COALESCE(lnwl, mwl, hnwl, fe30, fe100) IS NULL
209 OR validity IS NOT NULL),
207 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP, 210 date_info timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
208 source_organization varchar NOT NULL 211 source_organization varchar NOT NULL
209 ); 212 );
210 CREATE TRIGGER waterway_profiles_date_info BEFORE UPDATE ON waterway_profiles 213 CREATE TRIGGER waterway_profiles_date_info BEFORE UPDATE ON waterway_profiles
211 FOR EACH ROW EXECUTE PROCEDURE update_date_info(); 214 FOR EACH ROW EXECUTE PROCEDURE update_date_info();