Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 5406:e88d55d01cf5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SCHEMA CHANGE: additional columns and FK constraint for SQ-relation
author Tom Gottfried <tom@intevation.de>
date Mon, 25 Mar 2013 15:46:21 +0100
parents 6dd354e7abfc
children 7c1dd9c3f6bd
comparison
equal deleted inserted replaced
5405:5ca06120b918 5406:e88d55d01cf5
38 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id; 38 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id;
39 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id; 39 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id;
40 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; 40 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id;
41 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id; 41 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id;
42 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; 42 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id;
43 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id;
43 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id; 44 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id;
44 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id; 45 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id;
45 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id; 46 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id;
46 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id; 47 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id;
47 48
http://dive4elements.wald.intevation.org