Mercurial > dive4elements > river
diff backend/doc/schema/oracle-drop-minfo.sql @ 8072:5f28aa1be795
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 |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-drop-minfo.sql Tue Aug 05 18:28:04 2014 +0200 +++ b/backend/doc/schema/oracle-drop-minfo.sql Wed Aug 06 19:17:12 2014 +0200 @@ -22,11 +22,11 @@ ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id; ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id; ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id; -ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id; -ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id; -ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id; -ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id; -ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id; +ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_grain_fraction_id; +ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_unit_id; +ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_time_interval_id; +ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_river_id; +ALTER TABLE sediment_load_ls_values DROP CONSTRAINT fk_sllsv_sediment_load_ls_id; ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_kind_id; ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_grain_fraction_id; ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_time_interval_id; @@ -60,8 +60,8 @@ DROP TABLE flow_velocity_measurements PURGE; DROP TABLE flow_velocity_measure_values PURGE; DROP TABLE grain_fraction PURGE; -DROP TABLE sediment_yield PURGE; -DROP TABLE sediment_yield_values PURGE; +DROP TABLE sediment_load_ls PURGE; +DROP TABLE sediment_load_ls_values PURGE; DROP TABLE sediment_load PURGE; DROP TABLE sediment_load_values PURGE; DROP TABLE measurement_station PURGE; @@ -85,8 +85,8 @@ DROP SEQUENCE FV_MEASURE_ID_SEQ; DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ; DROP SEQUENCE GRAIN_FRACTION_ID_SEQ; -DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ; -DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; +DROP SEQUENCE SEDIMENT_LOAD_LS_ID_SEQ; +DROP SEQUENCE SEDIMENT_LOAD_LS_VALUES_ID_SEQ; DROP SEQUENCE SEDIMENT_LOAD_ID_SEQ; DROP SEQUENCE SEDIMENT_LOAD_VALUES_ID_SEQ; DROP SEQUENCE MEASUREMENT_STATION_ID_SEQ;