ingo@2805: SET AUTOCOMMIT ON;
ingo@2805: 
ingo@2805: ALTER TABLE elevation_model DROP CONSTRAINT fk_unit;
ingo@2809: ALTER TABLE bed_height_single DROP CONSTRAINT fk_bed_single_river_id;
ingo@2805: ALTER TABLE bed_height_single DROP CONSTRAINT fk_type;
ingo@2807: ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system;
ingo@2805: ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model;
ingo@2805: ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model;
ingo@2805: ALTER TABLE bed_height_single DROP CONSTRAINT fk_range;
ingo@2805: ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent;
ingo@2805: ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent;
ingo@2809: ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model;
ingo@2809: ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model;
ingo@2809: ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range;
ingo@2812: ALTER TABLE depths DROP CONSTRAINT fk_depths_unit_id;
ingo@2812: ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
ingo@2816: ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_unit_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_river_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@2824: ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_nmv_id;
ingo@2805: 
ingo@2805: DROP TABLE bed_height_type;
ingo@2805: DROP TABLE location_system;
ingo@2805: DROP TABLE elevation_model;
ingo@2805: DROP TABLE bed_height_single;
ingo@2805: DROP TABLE bed_height_single_values;
ingo@2805: DROP TABLE bed_height_epoch_values;
ingo@2805: DROP TABLE bed_height_epoch;
ingo@2812: DROP TABLE depths;
ingo@2812: DROP TABLE sediment_density;
ingo@2812: DROP TABLE sediment_density_values;
ingo@2818: DROP TABLE morphologic_width;
ingo@2818: DROP TABLE morphologic_width_values;
ingo@2824: DROP TABLE discharge_zone;
ingo@2824: DROP TABLE flow_velocity_model;
ingo@2824: DROP TABLE flow_velocity_model_values;
ingo@2805: 
ingo@2805: DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
ingo@2805: DROP SEQUENCE LOCATION_SYSTEM_SEQ;
ingo@2805: DROP SEQUENCE ELEVATION_MODEL_SEQ;
ingo@2805: DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
ingo@2805: DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ;
ingo@2805: DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ;
ingo@2805: DROP SEQUENCE BED_HEIGHT_EPOCH_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@2805: