Mercurial > dive4elements > river
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 |