Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2849:c36106f15ac9
Added missing constraint to relation 'waterlevel_difference'.
flys-backend/trunk@4303 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Thu, 26 Apr 2012 09:44:39 +0000 |
| parents | c1c6c9190636 |
| children | a2a33eff93aa |
comparison
equal
deleted
inserted
replaced
| 2848:e7a1d78b66d8 | 2849:c36106f15ac9 |
|---|---|
| 34 ALTER TABLE waterlevel DROP CONSTRAINT fk_w_river_id; | 34 ALTER TABLE waterlevel DROP CONSTRAINT fk_w_river_id; |
| 35 ALTER TABLE waterlevel DROP CONSTRAINT fk_w_unit_id; | 35 ALTER TABLE waterlevel DROP CONSTRAINT fk_w_unit_id; |
| 36 ALTER TABLE waterlevel_q_range DROP CONSTRAINT fk_wqr_waterlevel_id; | 36 ALTER TABLE waterlevel_q_range DROP CONSTRAINT fk_wqr_waterlevel_id; |
| 37 ALTER TABLE waterlevel_values DROP CONSTRAINT fk_wv_waterlevel_q_range_id; | 37 ALTER TABLE waterlevel_values DROP CONSTRAINT fk_wv_waterlevel_q_range_id; |
| 38 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_river_id; | 38 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_river_id; |
| 39 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_unit_id; | |
| 39 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id; | 40 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id; |
| 40 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id; | 41 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id; |
| 41 | 42 |
| 42 DROP TABLE bed_height_type; | 43 DROP TABLE bed_height_type; |
| 43 DROP TABLE location_system; | 44 DROP TABLE location_system; |