Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-minfo.sql @ 5684:88cbe798cbab
Schema change: fixed constraints
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 12 Apr 2013 16:13:23 +0200 |
| parents | db6c7268b08e |
| children | e89d922df8ae |
comparison
equal
deleted
inserted
replaced
| 5683:545a6ace9a19 | 5684:88cbe798cbab |
|---|---|
| 329 noutl int, | 329 noutl int, |
| 330 cferguson NUMERIC, | 330 cferguson NUMERIC, |
| 331 cduan NUMERIC, | 331 cduan NUMERIC, |
| 332 PRIMARY KEY (id), | 332 PRIMARY KEY (id), |
| 333 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) ON DELETE CASCADE, | 333 CONSTRAINT fk_sqr_id FOREIGN KEY (sq_relation_id) REFERENCES sq_relation(id) ON DELETE CASCADE, |
| 334 CONSTRAINT fk_mstation_id FOREIGN KEY (measurement_station_id) REFERENCES measurement_station(id) | 334 CONSTRAINT fk_mstation_id FOREIGN KEY (measurement_station_id) REFERENCES measurement_station(id) ON DELETE CASCADE |
| 335 ); | 335 ); |
| 336 COMMIT; | 336 COMMIT; |