Mercurial > dive4elements > river
diff backend/doc/schema/oracle-drop-minfo.sql @ 8018:ad614eff7a9b
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 |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-drop-minfo.sql Tue Jul 08 19:44:54 2014 +0200 +++ b/backend/doc/schema/oracle-drop-minfo.sql Wed Jul 09 15:51:31 2014 +0200 @@ -27,6 +27,12 @@ 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 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; +ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_sq_time_interval_id; +ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_sediment_load_id; +ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_m_station_id; ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id; ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; @@ -56,6 +62,8 @@ DROP TABLE grain_fraction PURGE; DROP TABLE sediment_yield PURGE; DROP TABLE sediment_yield_values PURGE; +DROP TABLE sediment_load PURGE; +DROP TABLE sediment_load_values PURGE; DROP TABLE measurement_station PURGE; DROP TABLE sq_relation_value PURGE; DROP TABLE sq_relation PURGE; @@ -79,6 +87,8 @@ DROP SEQUENCE GRAIN_FRACTION_ID_SEQ; DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ; DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; +DROP SEQUENCE SEDIMENT_LOAD_ID_SEQ; +DROP SEQUENCE SEDIMENT_LOAD_VALUES_ID_SEQ; DROP SEQUENCE MEASUREMENT_STATION_ID_SEQ; DROP SEQUENCE SQ_RELATION_ID_SEQ; DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ;