Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-drop-minfo.sql @ 5406:e88d55d01cf5
SCHEMA CHANGE: additional columns and FK constraint for SQ-relation
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 25 Mar 2013 15:46:21 +0100 |
| parents | 6dd354e7abfc |
| children | 7c1dd9c3f6bd |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql Mon Mar 25 15:38:54 2013 +0100 +++ b/flys-backend/doc/schema/oracle-drop-minfo.sql Mon Mar 25 15:46:21 2013 +0100 @@ -40,6 +40,7 @@ ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id; ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; +ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id; ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id; ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id; ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id;