Mercurial > dive4elements > river
view flys-backend/doc/schema/oracle-drop-minfo.sql @ 2826:c3f8cf0cdf69
Prepared the importer to parse flow velocity files and added a config option to skip that process.
flys-backend/trunk@4243 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Tue, 17 Apr 2012 06:51:39 +0000 |
parents | 85b2b5e7377f |
children | 4074777afcfa |
line wrap: on
line source
SET AUTOCOMMIT ON; ALTER TABLE elevation_model DROP CONSTRAINT fk_unit; ALTER TABLE bed_height_single DROP CONSTRAINT fk_bed_single_river_id; ALTER TABLE bed_height_single DROP CONSTRAINT fk_type; ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system; ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model; ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model; ALTER TABLE bed_height_single DROP CONSTRAINT fk_range; ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent; 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; ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id; ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id; ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_river_id; ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_discharge_zone_id; ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id; ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_nmv_id; DROP TABLE bed_height_type; DROP TABLE location_system; DROP TABLE elevation_model; DROP TABLE bed_height_single; DROP TABLE bed_height_single_values; DROP TABLE bed_height_epoch_values; DROP TABLE bed_height_epoch; DROP TABLE depths; DROP TABLE sediment_density; DROP TABLE sediment_density_values; DROP TABLE morphologic_width; DROP TABLE morphologic_width_values; DROP TABLE discharge_zone; DROP TABLE flow_velocity_model; DROP TABLE flow_velocity_model_values; DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; DROP SEQUENCE LOCATION_SYSTEM_SEQ; DROP SEQUENCE ELEVATION_MODEL_SEQ; DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ; DROP SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ; DROP SEQUENCE DEPTHS_ID_SEQ; DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ; DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ; DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ; DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ; DROP SEQUENCE DISCHARGE_ZONE_ID_SEQ; DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ; DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ;