Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 5441:7c1dd9c3f6bd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
remove unit from sediment density and depths (always t/m3 respectively cm, otherwise a typo)
author Tom Gottfried <tom.gottfried@intevation.de>
date Tue, 26 Mar 2013 19:29:39 +0100
parents e88d55d01cf5
children
comparison
equal deleted inserted replaced
5440:765013c837b1 5441:7c1dd9c3f6bd
10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; 10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent;
11 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent; 11 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent;
12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model; 12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model;
13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model; 13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model;
14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range; 14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range;
15 ALTER TABLE depths DROP CONSTRAINT fk_depths_unit_id;
16 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id; 15 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
17 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_unit_id;
18 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id; 16 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id;
19 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id; 17 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
20 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id; 18 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id;
21 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id; 19 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; 20 ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id;
http://dive4elements.wald.intevation.org