Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-drop-minfo.sql @ 5321:6dd354e7abfc
SCHEMA CHANGE: removed bad triggers and foreign keys from schema
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 15 Mar 2013 16:43:00 +0100 |
parents | 8667f629d238 |
children | e88d55d01cf5 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql Fri Mar 15 11:04:13 2013 +0100 +++ b/flys-backend/doc/schema/oracle-drop-minfo.sql Fri Mar 15 16:43:00 2013 +0100 @@ -20,12 +20,10 @@ 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 flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id; ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id; -ALTER TABLE grain_fraction DROP CONSTRAINT fk_gf_unit_id; ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id; ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id; ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id;