Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop-minfo.sql @ 5838:5aa05a7a34b7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rename modules to more fitting names.
author Sascha L. Teichmann <teichmann@intevation.de>
date Thu, 25 Apr 2013 15:23:37 +0200
parents flys-backend/doc/schema/oracle-drop-minfo.sql@7c1dd9c3f6bd
children 97145ec4e33c
comparison
equal deleted inserted replaced
5837:d9901a08d0a6 5838:5aa05a7a34b7
1 SET AUTOCOMMIT ON;
2
3 ALTER TABLE elevation_model DROP CONSTRAINT fk_unit;
4 ALTER TABLE bed_height_single DROP CONSTRAINT fk_bed_single_river_id;
5 ALTER TABLE bed_height_single DROP CONSTRAINT fk_type;
6 ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system;
7 ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model;
8 ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model;
9 ALTER TABLE bed_height_single DROP CONSTRAINT fk_range;
10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent;
11 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent;
12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model;
13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model;
14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range;
15 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
16 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id;
17 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
18 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id;
19 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id;
20 ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id;
21 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_discharge_zone_id;
22 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id;
23 ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id;
24 ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id;
25 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id;
26 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id;
27 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_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;
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;
39 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id;
40 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id;
41 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id;
42 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id;
43 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id;
44 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id;
45 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id;
46
47 DROP TABLE bed_height_type;
48 DROP TABLE location_system;
49 DROP TABLE elevation_model;
50 DROP TABLE bed_height_single;
51 DROP TABLE bed_height_single_values;
52 DROP TABLE bed_height_epoch_values;
53 DROP TABLE bed_height_epoch;
54 DROP TABLE depths;
55 DROP TABLE sediment_density;
56 DROP TABLE sediment_density_values;
57 DROP TABLE morphologic_width;
58 DROP TABLE morphologic_width_values;
59 DROP TABLE discharge_zone;
60 DROP TABLE flow_velocity_model;
61 DROP TABLE flow_velocity_model_values;
62 DROP TABLE flow_velocity_measurements;
63 DROP TABLE flow_velocity_measure_values;
64 DROP TABLE grain_fraction;
65 DROP TABLE sediment_yield;
66 DROP TABLE sediment_yield_values;
67 DROP TABLE waterlevel;
68 DROP TABLE waterlevel_q_range;
69 DROP TABLE waterlevel_values;
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
77 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
78 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
79 DROP SEQUENCE ELEVATION_MODEL_SEQ;
80 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
81 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ;
82 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ;
83 DROP SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ;
84 DROP SEQUENCE DEPTHS_ID_SEQ;
85 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ;
86 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ;
87 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ;
88 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ;
89 DROP SEQUENCE DISCHARGE_ZONE_ID_SEQ;
90 DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ;
91 DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ;
92 DROP SEQUENCE FV_MEASURE_ID_SEQ;
93 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ;
94 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ;
95 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ;
96 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ;
97 DROP SEQUENCE WATERLEVEL_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;
104 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ;
http://dive4elements.wald.intevation.org