view flys-backend/doc/schema/oracle-drop-minfo.sql @ 2823:13b3fcaa1b34

Add MINFO schema for PostgreSQL flys-backend/trunk@4240 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 13 Apr 2012 16:15:23 +0000
parents 25ed1f18fcc4
children 85b2b5e7377f
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;

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 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;

http://dive4elements.wald.intevation.org