Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2846:c1c6c9190636

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improved the db schema to store MINFO specific waterlevel differences. flys-backend/trunk@4289 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Tue, 24 Apr 2012 13:04:30 +0000
parents 6be2bf2492f9
children c36106f15ac9
comparison
equal deleted inserted replaced
2845:a65b5b0ade6f 2846:c1c6c9190636
33 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id; 33 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id;
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;
39 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id;
40 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id;
38 41
39 DROP TABLE bed_height_type; 42 DROP TABLE bed_height_type;
40 DROP TABLE location_system; 43 DROP TABLE location_system;
41 DROP TABLE elevation_model; 44 DROP TABLE elevation_model;
42 DROP TABLE bed_height_single; 45 DROP TABLE bed_height_single;
57 DROP TABLE sediment_yield; 60 DROP TABLE sediment_yield;
58 DROP TABLE sediment_yield_values; 61 DROP TABLE sediment_yield_values;
59 DROP TABLE waterlevel; 62 DROP TABLE waterlevel;
60 DROP TABLE waterlevel_q_range; 63 DROP TABLE waterlevel_q_range;
61 DROP TABLE waterlevel_values; 64 DROP TABLE waterlevel_values;
65 DROP TABLE waterlevel_difference;
66 DROP TABLE waterlevel_difference_column;
67 DROP TABLE waterlevel_difference_values;
62 68
63 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; 69 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
64 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 70 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
65 DROP SEQUENCE ELEVATION_MODEL_SEQ; 71 DROP SEQUENCE ELEVATION_MODEL_SEQ;
66 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 72 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
81 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ; 87 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ;
82 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; 88 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ;
83 DROP SEQUENCE WATERLEVEL_ID_SEQ; 89 DROP SEQUENCE WATERLEVEL_ID_SEQ;
84 DROP SEQUENCE WATERLEVEL_Q_RANGES_ID_SEQ; 90 DROP SEQUENCE WATERLEVEL_Q_RANGES_ID_SEQ;
85 DROP SEQUENCE WATERLEVEL_VALUES_ID_SEQ; 91 DROP SEQUENCE WATERLEVEL_VALUES_ID_SEQ;
92 DROP SEQUENCE WATERLEVEL_DIFFERENCE_ID_SEQ;
93 DROP SEQUENCE WATERLEVEL_DIFF_COLUMN_ID_SEQ;
94 DROP SEQUENCE WATERLEVEL_DIFF_VALUES_ID_SEQ;
95
http://dive4elements.wald.intevation.org