Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2812:a36a5407acbf

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
2811:8926571e47fb 2812:a36a5407acbf
10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; 10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent;
11 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent; 11 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent;
12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model; 12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model;
13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model; 13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model;
14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range; 14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range;
15 ALTER TABLE depths DROP CONSTRAINT fk_depths_unit_id;
16 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
17 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id;
18 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_station_id;
15 19
16 DROP TABLE bed_height_type; 20 DROP TABLE bed_height_type;
17 DROP TABLE location_system; 21 DROP TABLE location_system;
18 DROP TABLE elevation_model; 22 DROP TABLE elevation_model;
19 DROP TABLE bed_height_single; 23 DROP TABLE bed_height_single;
20 DROP TABLE bed_height_single_values; 24 DROP TABLE bed_height_single_values;
21 DROP TABLE bed_height_epoch_values; 25 DROP TABLE bed_height_epoch_values;
22 DROP TABLE bed_height_epoch; 26 DROP TABLE bed_height_epoch;
27 DROP TABLE depths;
28 DROP TABLE sediment_density;
29 DROP TABLE sediment_density_values;
23 30
24 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; 31 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
25 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 32 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
26 DROP SEQUENCE ELEVATION_MODEL_SEQ; 33 DROP SEQUENCE ELEVATION_MODEL_SEQ;
27 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 34 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
28 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; 35 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ;
29 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ; 36 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ;
30 DROP SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ; 37 DROP SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ;
38 DROP SEQUENCE DEPTHS_ID_SEQ;
39 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ;
40 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ;
31 41
http://dive4elements.wald.intevation.org