Mercurial > dive4elements > river

comparison backend/doc/schema/oracle-drop-minfo.sql @ 8072:5f28aa1be795

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
author Tom Gottfried <tom@intevation.de>
date Wed, 06 Aug 2014 19:17:12 +0200
parents ad614eff7a9b
children a846a3d910a0
comparison
equal deleted inserted replaced
8071:6e6506ec0ae0 8072:5f28aa1be795
20 ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_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; 21 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_discharge_zone_id;
22 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id; 22 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id;
23 ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_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; 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; 25 ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_grain_fraction_id;
26 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id; 26 ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_unit_id;
27 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id; 27 ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_time_interval_id;
28 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id; 28 ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_river_id;
29 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id; 29 ALTER TABLE sediment_load_ls_values DROP CONSTRAINT fk_sllsv_sediment_load_ls_id;
30 ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_kind_id; 30 ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_kind_id;
31 ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_grain_fraction_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; 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; 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; 34 ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_sediment_load_id;
58 DROP TABLE flow_velocity_model PURGE; 58 DROP TABLE flow_velocity_model PURGE;
59 DROP TABLE flow_velocity_model_values PURGE; 59 DROP TABLE flow_velocity_model_values PURGE;
60 DROP TABLE flow_velocity_measurements PURGE; 60 DROP TABLE flow_velocity_measurements PURGE;
61 DROP TABLE flow_velocity_measure_values PURGE; 61 DROP TABLE flow_velocity_measure_values PURGE;
62 DROP TABLE grain_fraction PURGE; 62 DROP TABLE grain_fraction PURGE;
63 DROP TABLE sediment_yield PURGE; 63 DROP TABLE sediment_load_ls PURGE;
64 DROP TABLE sediment_yield_values PURGE; 64 DROP TABLE sediment_load_ls_values PURGE;
65 DROP TABLE sediment_load PURGE; 65 DROP TABLE sediment_load PURGE;
66 DROP TABLE sediment_load_values PURGE; 66 DROP TABLE sediment_load_values PURGE;
67 DROP TABLE measurement_station PURGE; 67 DROP TABLE measurement_station PURGE;
68 DROP TABLE sq_relation_value PURGE; 68 DROP TABLE sq_relation_value PURGE;
69 DROP TABLE sq_relation PURGE; 69 DROP TABLE sq_relation PURGE;
83 DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ; 83 DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ;
84 DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ; 84 DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ;
85 DROP SEQUENCE FV_MEASURE_ID_SEQ; 85 DROP SEQUENCE FV_MEASURE_ID_SEQ;
86 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ; 86 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ;
87 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ; 87 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ;
88 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ; 88 DROP SEQUENCE SEDIMENT_LOAD_LS_ID_SEQ;
89 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; 89 DROP SEQUENCE SEDIMENT_LOAD_LS_VALUES_ID_SEQ;
90 DROP SEQUENCE SEDIMENT_LOAD_ID_SEQ; 90 DROP SEQUENCE SEDIMENT_LOAD_ID_SEQ;
91 DROP SEQUENCE SEDIMENT_LOAD_VALUES_ID_SEQ; 91 DROP SEQUENCE SEDIMENT_LOAD_VALUES_ID_SEQ;
92 DROP SEQUENCE MEASUREMENT_STATION_ID_SEQ; 92 DROP SEQUENCE MEASUREMENT_STATION_ID_SEQ;
93 DROP SEQUENCE SQ_RELATION_ID_SEQ; 93 DROP SEQUENCE SQ_RELATION_ID_SEQ;
94 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ; 94 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ;
http://dive4elements.wald.intevation.org