comparison flys-backend/doc/schema/oracle-minfo.sql @ 5478:5bb3610b94f7

Schema Change: removed constraint that did not allow to have more than one measurement_type per station
author Tom Gottfried <tom.gottfried@intevation.de>
date Wed, 27 Mar 2013 19:23:57 +0100
parents b6a6d13eec41
children d459a885c51f
comparison
equal deleted inserted replaced
5477:ae60bb7b8085 5478:5bb3610b94f7
294 description VARCHAR(512), 294 description VARCHAR(512),
295 PRIMARY KEY (id), 295 PRIMARY KEY (id),
296 CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE, 296 CONSTRAINT fk_ms_river_id FOREIGN KEY (river_id) REFERENCES rivers(id) ON DELETE CASCADE,
297 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE, 297 CONSTRAINT fk_ms_range_id FOREIGN KEY (range_id) REFERENCES ranges(id) ON DELETE CASCADE,
298 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) REFERENCES gauges(id) ON DELETE CASCADE, 298 CONSTRAINT fk_ms_reference_gauge_id FOREIGN KEY (reference_gauge_id) REFERENCES gauges(id) ON DELETE CASCADE,
299 CONSTRAINT fk_ms_observation_timerange_id FOREIGN KEY (observation_timerange_id) REFERENCES time_intervals(id), 299 CONSTRAINT fk_ms_observation_timerange_id FOREIGN KEY (observation_timerange_id) REFERENCES time_intervals(id)
300 UNIQUE (river_id, station)
301 ); 300 );
302 301
303 302
304 CREATE SEQUENCE SQ_RELATION_ID_SEQ; 303 CREATE SEQUENCE SQ_RELATION_ID_SEQ;
305 304

http://dive4elements.wald.intevation.org