ingo@2805: SET AUTOCOMMIT ON;
ingo@2805: 
ingo@2805: ALTER TABLE elevation_model DROP CONSTRAINT fk_unit;
tom@8666: ALTER TABLE bed_height DROP CONSTRAINT fk_bh_river_id;
tom@8666: ALTER TABLE bed_height DROP CONSTRAINT fk_bh_type;
tom@8666: ALTER TABLE bed_height DROP CONSTRAINT fk_bh_location_system;
tom@8666: ALTER TABLE bed_height DROP CONSTRAINT fk_bh_cur_elevation_model;
tom@8666: ALTER TABLE bed_height DROP CONSTRAINT fk_bh_old_elevation_model;
tom@8666: ALTER TABLE bed_height DROP CONSTRAINT fk_bh_range;
tom@8666: ALTER TABLE bed_height_values DROP CONSTRAINT fk_bed_values_parent;
ingo@2812: ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
ingo@2812: ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id;
ingo@2818: ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
ingo@2818: ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id;
ingo@2818: ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id;
ingo@2824: ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id;
ingo@2824: ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_discharge_zone_id;
ingo@2824: ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id;
ingo@2829: ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id;
ingo@2829: ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id;
tom@8072: ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_grain_fraction_id;
tom@8072: ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_unit_id;
tom@8072: ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_time_interval_id;
tom@8072: ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_river_id;
tom@8072: ALTER TABLE sediment_load_ls_values DROP CONSTRAINT fk_sllsv_sediment_load_ls_id;
tom@8018: ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_kind_id;
tom@8018: ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_grain_fraction_id;
tom@8018: ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_time_interval_id;
tom@8018: ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_sq_time_interval_id;
tom@8018: ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_sediment_load_id;
tom@8018: ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_m_station_id;
ingo@3321: ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id;
ingo@3329: ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id;
ingo@3321: ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id;
tom@5406: ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id;
aheinecke@5206: ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id;
aheinecke@5206: ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id;
aheinecke@5206: ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id;
aheinecke@5206: ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id;
ingo@2805: 
tom@6652: DROP TABLE bed_height_type PURGE;
tom@6652: DROP TABLE location_system PURGE;
tom@6652: DROP TABLE elevation_model PURGE;
tom@8666: DROP TABLE bed_height PURGE;
tom@8666: DROP TABLE bed_height_values PURGE;
tom@6652: DROP TABLE depths PURGE;
tom@6652: DROP TABLE sediment_density PURGE;
tom@6652: DROP TABLE sediment_density_values PURGE;
tom@6652: DROP TABLE morphologic_width PURGE;
tom@6652: DROP TABLE morphologic_width_values PURGE;
tom@6652: DROP TABLE discharge_zone PURGE;
tom@6652: DROP TABLE flow_velocity_model PURGE;
tom@6652: DROP TABLE flow_velocity_model_values PURGE;
tom@6652: DROP TABLE flow_velocity_measurements PURGE;
tom@6652: DROP TABLE flow_velocity_measure_values PURGE;
tom@6652: DROP TABLE grain_fraction PURGE;
tom@8072: DROP TABLE sediment_load_ls PURGE;
tom@8072: DROP TABLE sediment_load_ls_values PURGE;
tom@8018: DROP TABLE sediment_load PURGE;
tom@8018: DROP TABLE sediment_load_values PURGE;
tom@6652: DROP TABLE measurement_station PURGE;
tom@6652: DROP TABLE sq_relation_value PURGE;
tom@6652: DROP TABLE sq_relation PURGE;
ingo@2805: 
ingo@2805: DROP SEQUENCE LOCATION_SYSTEM_SEQ;
ingo@2805: DROP SEQUENCE ELEVATION_MODEL_SEQ;
tom@8666: DROP SEQUENCE BED_HEIGHT_ID_SEQ;
tom@8666: DROP SEQUENCE BED_HEIGHT_VALUES_ID_SEQ;
ingo@2812: DROP SEQUENCE DEPTHS_ID_SEQ;
ingo@2812: DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ;
ingo@2812: DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ;
ingo@2818: DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ;
ingo@2818: DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ;
ingo@2824: DROP SEQUENCE DISCHARGE_ZONE_ID_SEQ;
ingo@2824: DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ;
ingo@2824: DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ;
ingo@2829: DROP SEQUENCE FV_MEASURE_ID_SEQ;
ingo@2829: DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ;
ingo@2834: DROP SEQUENCE GRAIN_FRACTION_ID_SEQ;
tom@8072: DROP SEQUENCE SEDIMENT_LOAD_LS_ID_SEQ;
tom@8072: DROP SEQUENCE SEDIMENT_LOAD_LS_VALUES_ID_SEQ;
tom@8018: DROP SEQUENCE SEDIMENT_LOAD_ID_SEQ;
tom@8018: DROP SEQUENCE SEDIMENT_LOAD_VALUES_ID_SEQ;
tom@6632: DROP SEQUENCE MEASUREMENT_STATION_ID_SEQ;
ingo@3321: DROP SEQUENCE SQ_RELATION_ID_SEQ;
ingo@3321: DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ;