Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-drop-minfo.sql @ 2824:85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
flys-backend/trunk@4241 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Mon, 16 Apr 2012 09:48:49 +0000 |
| parents | 25ed1f18fcc4 |
| children | 4074777afcfa |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql Fri Apr 13 16:15:23 2012 +0000 +++ b/flys-backend/doc/schema/oracle-drop-minfo.sql Mon Apr 16 09:48:49 2012 +0000 @@ -19,6 +19,11 @@ 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; @@ -32,6 +37,9 @@ 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; @@ -45,4 +53,7 @@ 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;