diff flys-backend/doc/schema/oracle-drop-minfo.sql @ 5540:25c2505df28f

Merged
author Christian Lins <christian.lins@intevation.de>
date Wed, 03 Apr 2013 16:00:21 +0200
parents 7c1dd9c3f6bd
children
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql	Wed Apr 03 15:59:01 2013 +0200
+++ b/flys-backend/doc/schema/oracle-drop-minfo.sql	Wed Apr 03 16:00:21 2013 +0200
@@ -12,9 +12,7 @@
 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model;
 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model;
 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range;
-ALTER TABLE depths DROP CONSTRAINT fk_depths_unit_id;
 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
-ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_unit_id;
 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id;
 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id;
@@ -40,6 +38,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;

http://dive4elements.wald.intevation.org