Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-drop-minfo.sql @ 2812:a36a5407acbf
Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
flys-backend/trunk@4228 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Fri, 13 Apr 2012 08:16:55 +0000 |
| parents | f283212966e8 |
| children | 70b4a31a3306 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql Fri Apr 13 07:24:55 2012 +0000 +++ b/flys-backend/doc/schema/oracle-drop-minfo.sql Fri Apr 13 08:16:55 2012 +0000 @@ -12,6 +12,10 @@ ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model; ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model; ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range; +ALTER TABLE depths DROP CONSTRAINT fk_depths_unit_id; +ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id; +ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id; +ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_station_id; DROP TABLE bed_height_type; DROP TABLE location_system; @@ -20,6 +24,9 @@ DROP TABLE bed_height_single_values; DROP TABLE bed_height_epoch_values; DROP TABLE bed_height_epoch; +DROP TABLE depths; +DROP TABLE sediment_density; +DROP TABLE sediment_density_values; DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; DROP SEQUENCE LOCATION_SYSTEM_SEQ; @@ -28,4 +35,7 @@ DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ; DROP SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ; +DROP SEQUENCE DEPTHS_ID_SEQ; +DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ; +DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ;