Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2818:25ed1f18fcc4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improved the MIFNO DB schema for morphological width and added model classes. flys-backend/trunk@4235 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Fri, 13 Apr 2012 12:33:26 +0000
parents 70b4a31a3306
children 85b2b5e7377f
comparison
equal deleted inserted replaced
2817:8979f2294af9 2818:25ed1f18fcc4
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; 15 ALTER TABLE depths DROP CONSTRAINT fk_depths_unit_id;
16 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id; 16 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id;
17 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_unit_id; 17 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_unit_id;
18 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id; 18 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id;
19 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
20 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id;
21 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id;
19 22
20 DROP TABLE bed_height_type; 23 DROP TABLE bed_height_type;
21 DROP TABLE location_system; 24 DROP TABLE location_system;
22 DROP TABLE elevation_model; 25 DROP TABLE elevation_model;
23 DROP TABLE bed_height_single; 26 DROP TABLE bed_height_single;
25 DROP TABLE bed_height_epoch_values; 28 DROP TABLE bed_height_epoch_values;
26 DROP TABLE bed_height_epoch; 29 DROP TABLE bed_height_epoch;
27 DROP TABLE depths; 30 DROP TABLE depths;
28 DROP TABLE sediment_density; 31 DROP TABLE sediment_density;
29 DROP TABLE sediment_density_values; 32 DROP TABLE sediment_density_values;
33 DROP TABLE morphologic_width;
34 DROP TABLE morphologic_width_values;
30 35
31 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; 36 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
32 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 37 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
33 DROP SEQUENCE ELEVATION_MODEL_SEQ; 38 DROP SEQUENCE ELEVATION_MODEL_SEQ;
34 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 39 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
36 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ; 41 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ;
37 DROP SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ; 42 DROP SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ;
38 DROP SEQUENCE DEPTHS_ID_SEQ; 43 DROP SEQUENCE DEPTHS_ID_SEQ;
39 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ; 44 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ;
40 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ; 45 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ;
46 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ;
47 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ;
41 48
http://dive4elements.wald.intevation.org