Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop-minfo.sql @ 8018:ad614eff7a9b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
author Tom Gottfried <tom@intevation.de>
date Wed, 09 Jul 2014 15:51:31 +0200
parents 765944ca6df0
children 5f28aa1be795
comparison
equal deleted inserted replaced
8017:bcb05a98bb3f 8018:ad614eff7a9b
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 sediment_load DROP CONSTRAINT fk_sl_kind_id;
31 ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_grain_fraction_id;
32 ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_time_interval_id;
33 ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_sq_time_interval_id;
34 ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_sediment_load_id;
35 ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_m_station_id;
30 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; 36 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id;
31 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id; 37 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id;
32 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; 38 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id;
33 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id; 39 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id;
34 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id; 40 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id;
54 DROP TABLE flow_velocity_measurements PURGE; 60 DROP TABLE flow_velocity_measurements PURGE;
55 DROP TABLE flow_velocity_measure_values PURGE; 61 DROP TABLE flow_velocity_measure_values PURGE;
56 DROP TABLE grain_fraction PURGE; 62 DROP TABLE grain_fraction PURGE;
57 DROP TABLE sediment_yield PURGE; 63 DROP TABLE sediment_yield PURGE;
58 DROP TABLE sediment_yield_values PURGE; 64 DROP TABLE sediment_yield_values PURGE;
65 DROP TABLE sediment_load PURGE;
66 DROP TABLE sediment_load_values PURGE;
59 DROP TABLE measurement_station PURGE; 67 DROP TABLE measurement_station PURGE;
60 DROP TABLE sq_relation_value PURGE; 68 DROP TABLE sq_relation_value PURGE;
61 DROP TABLE sq_relation PURGE; 69 DROP TABLE sq_relation PURGE;
62 70
63 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 71 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
77 DROP SEQUENCE FV_MEASURE_ID_SEQ; 85 DROP SEQUENCE FV_MEASURE_ID_SEQ;
78 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ; 86 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ;
79 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ; 87 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ;
80 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ; 88 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ;
81 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; 89 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ;
90 DROP SEQUENCE SEDIMENT_LOAD_ID_SEQ;
91 DROP SEQUENCE SEDIMENT_LOAD_VALUES_ID_SEQ;
82 DROP SEQUENCE MEASUREMENT_STATION_ID_SEQ; 92 DROP SEQUENCE MEASUREMENT_STATION_ID_SEQ;
83 DROP SEQUENCE SQ_RELATION_ID_SEQ; 93 DROP SEQUENCE SQ_RELATION_ID_SEQ;
84 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ; 94 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ;
http://dive4elements.wald.intevation.org