comparison 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
comparison
equal deleted inserted replaced
5539:8d0af912351c 5540:25c2505df28f
10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; 10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent;
11 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent; 11 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent;
12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model; 12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model;
13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model; 13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model;
14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range; 14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range;
15 ALTER TABLE depths DROP CONSTRAINT fk_depths_unit_id;
16 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id; 15 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
17 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_unit_id;
18 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id; 16 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id;
19 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id; 17 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
20 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id; 18 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id;
21 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id; 19 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id;
22 ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id; 20 ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id;
38 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id; 36 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id;
39 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id; 37 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id;
40 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; 38 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id;
41 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id; 39 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id;
42 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; 40 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id;
41 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id;
43 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id; 42 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id;
44 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id; 43 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id;
45 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id; 44 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id;
46 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id; 45 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id;
47 46

http://dive4elements.wald.intevation.org