Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-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 |