Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2841:6be2bf2492f9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added MINFO specific waterlevel relations. flys-backend/trunk@4280 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Fri, 20 Apr 2012 06:59:03 +0000
parents 6b541d85c5cf
children c1c6c9190636
comparison
equal deleted inserted replaced
2840:71175502d868 2841:6be2bf2492f9
29 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id; 29 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id;
30 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id; 30 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id;
31 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id; 31 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id;
32 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id; 32 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id;
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;
35 ALTER TABLE waterlevel DROP CONSTRAINT fk_w_unit_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;
34 38
35 DROP TABLE bed_height_type; 39 DROP TABLE bed_height_type;
36 DROP TABLE location_system; 40 DROP TABLE location_system;
37 DROP TABLE elevation_model; 41 DROP TABLE elevation_model;
38 DROP TABLE bed_height_single; 42 DROP TABLE bed_height_single;
50 DROP TABLE flow_velocity_measurements; 54 DROP TABLE flow_velocity_measurements;
51 DROP TABLE flow_velocity_measure_values; 55 DROP TABLE flow_velocity_measure_values;
52 DROP TABLE grain_fraction; 56 DROP TABLE grain_fraction;
53 DROP TABLE sediment_yield; 57 DROP TABLE sediment_yield;
54 DROP TABLE sediment_yield_values; 58 DROP TABLE sediment_yield_values;
59 DROP TABLE waterlevel;
60 DROP TABLE waterlevel_q_range;
61 DROP TABLE waterlevel_values;
55 62
56 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; 63 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
57 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 64 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
58 DROP SEQUENCE ELEVATION_MODEL_SEQ; 65 DROP SEQUENCE ELEVATION_MODEL_SEQ;
59 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 66 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
71 DROP SEQUENCE FV_MEASURE_ID_SEQ; 78 DROP SEQUENCE FV_MEASURE_ID_SEQ;
72 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ; 79 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ;
73 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ; 80 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ;
74 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ; 81 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ;
75 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; 82 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ;
76 83 DROP SEQUENCE WATERLEVEL_ID_SEQ;
84 DROP SEQUENCE WATERLEVEL_Q_RANGES_ID_SEQ;
85 DROP SEQUENCE WATERLEVEL_VALUES_ID_SEQ;
http://dive4elements.wald.intevation.org