Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop-minfo.sql @ 7352:c6825778de1f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged double-precision branch.
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 16 Oct 2013 13:03:13 +0200
parents 765944ca6df0
children ad614eff7a9b
comparison
equal deleted inserted replaced
7350:760ea7f08455 7352:c6825778de1f
25 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id; 25 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id;
26 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id; 26 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id;
27 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id; 27 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id;
28 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id; 28 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id;
29 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id; 29 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id;
30 ALTER TABLE waterlevel DROP CONSTRAINT fk_w_river_id;
31 ALTER TABLE waterlevel DROP CONSTRAINT fk_w_unit_id;
32 ALTER TABLE waterlevel_q_range DROP CONSTRAINT fk_wqr_waterlevel_id;
33 ALTER TABLE waterlevel_values DROP CONSTRAINT fk_wv_waterlevel_q_range_id;
34 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_river_id;
35 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_unit_id;
36 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id;
37 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id;
38 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; 30 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id;
39 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id; 31 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id;
40 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; 32 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id;
41 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id; 33 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id;
42 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id; 34 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id;
43 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id; 35 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id;
44 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id; 36 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id;
45 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id; 37 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id;
46 38
47 DROP TABLE bed_height_type; 39 DROP TABLE bed_height_type PURGE;
48 DROP TABLE location_system; 40 DROP TABLE location_system PURGE;
49 DROP TABLE elevation_model; 41 DROP TABLE elevation_model PURGE;
50 DROP TABLE bed_height_single; 42 DROP TABLE bed_height_single PURGE;
51 DROP TABLE bed_height_single_values; 43 DROP TABLE bed_height_single_values PURGE;
52 DROP TABLE bed_height_epoch_values; 44 DROP TABLE bed_height_epoch_values PURGE;
53 DROP TABLE bed_height_epoch; 45 DROP TABLE bed_height_epoch PURGE;
54 DROP TABLE depths; 46 DROP TABLE depths PURGE;
55 DROP TABLE sediment_density; 47 DROP TABLE sediment_density PURGE;
56 DROP TABLE sediment_density_values; 48 DROP TABLE sediment_density_values PURGE;
57 DROP TABLE morphologic_width; 49 DROP TABLE morphologic_width PURGE;
58 DROP TABLE morphologic_width_values; 50 DROP TABLE morphologic_width_values PURGE;
59 DROP TABLE discharge_zone; 51 DROP TABLE discharge_zone PURGE;
60 DROP TABLE flow_velocity_model; 52 DROP TABLE flow_velocity_model PURGE;
61 DROP TABLE flow_velocity_model_values; 53 DROP TABLE flow_velocity_model_values PURGE;
62 DROP TABLE flow_velocity_measurements; 54 DROP TABLE flow_velocity_measurements PURGE;
63 DROP TABLE flow_velocity_measure_values; 55 DROP TABLE flow_velocity_measure_values PURGE;
64 DROP TABLE grain_fraction; 56 DROP TABLE grain_fraction PURGE;
65 DROP TABLE sediment_yield; 57 DROP TABLE sediment_yield PURGE;
66 DROP TABLE sediment_yield_values; 58 DROP TABLE sediment_yield_values PURGE;
67 DROP TABLE waterlevel; 59 DROP TABLE measurement_station PURGE;
68 DROP TABLE waterlevel_q_range; 60 DROP TABLE sq_relation_value PURGE;
69 DROP TABLE waterlevel_values; 61 DROP TABLE sq_relation PURGE;
70 DROP TABLE waterlevel_difference;
71 DROP TABLE waterlevel_difference_column;
72 DROP TABLE waterlevel_difference_values;
73 DROP TABLE measurement_station;
74 DROP TABLE sq_relation_value;
75 DROP TABLE sq_relation;
76 62
77 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
78 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 63 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
79 DROP SEQUENCE ELEVATION_MODEL_SEQ; 64 DROP SEQUENCE ELEVATION_MODEL_SEQ;
80 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 65 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
81 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; 66 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ;
82 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ; 67 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ;
92 DROP SEQUENCE FV_MEASURE_ID_SEQ; 77 DROP SEQUENCE FV_MEASURE_ID_SEQ;
93 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ; 78 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ;
94 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ; 79 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ;
95 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ; 80 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ;
96 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; 81 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ;
97 DROP SEQUENCE WATERLEVEL_ID_SEQ; 82 DROP SEQUENCE MEASUREMENT_STATION_ID_SEQ;
98 DROP SEQUENCE WATERLEVEL_Q_RANGES_ID_SEQ;
99 DROP SEQUENCE WATERLEVEL_VALUES_ID_SEQ;
100 DROP SEQUENCE WATERLEVEL_DIFFERENCE_ID_SEQ;
101 DROP SEQUENCE WATERLEVEL_DIFF_COLUMN_ID_SEQ;
102 DROP SEQUENCE WATERLEVEL_DIFF_VALUES_ID_SEQ;
103 DROP SEQUENCE SQ_RELATION_ID_SEQ; 83 DROP SEQUENCE SQ_RELATION_ID_SEQ;
104 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ; 84 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ;
http://dive4elements.wald.intevation.org