Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 5321:6dd354e7abfc

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
5320:a7778435a4af 5321:6dd354e7abfc
18 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id; 18 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id;
19 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id; 19 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
20 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id; 20 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id;
21 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id; 21 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id;
22 ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id; 22 ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id;
23 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_river_id;
24 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_discharge_zone_id; 23 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_discharge_zone_id;
25 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id; 24 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id;
26 ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id; 25 ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id;
27 ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id; 26 ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id;
28 ALTER TABLE grain_fraction DROP CONSTRAINT fk_gf_unit_id;
29 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id; 27 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id;
30 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id; 28 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id;
31 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id; 29 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id;
32 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id; 30 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id;
33 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id; 31 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id;
http://dive4elements.wald.intevation.org