Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2824:85b2b5e7377f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improved the oracle db schema for MINFO specific flow velocity values. flys-backend/trunk@4241 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Mon, 16 Apr 2012 09:48:49 +0000
parents 25ed1f18fcc4
children 4074777afcfa
comparison
equal deleted inserted replaced
2823:13b3fcaa1b34 2824:85b2b5e7377f
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; 19 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id;
20 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_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; 21 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id;
22 ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id;
23 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_river_id;
24 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_discharge_zone_id;
25 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id;
26 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_nmv_id;
22 27
23 DROP TABLE bed_height_type; 28 DROP TABLE bed_height_type;
24 DROP TABLE location_system; 29 DROP TABLE location_system;
25 DROP TABLE elevation_model; 30 DROP TABLE elevation_model;
26 DROP TABLE bed_height_single; 31 DROP TABLE bed_height_single;
30 DROP TABLE depths; 35 DROP TABLE depths;
31 DROP TABLE sediment_density; 36 DROP TABLE sediment_density;
32 DROP TABLE sediment_density_values; 37 DROP TABLE sediment_density_values;
33 DROP TABLE morphologic_width; 38 DROP TABLE morphologic_width;
34 DROP TABLE morphologic_width_values; 39 DROP TABLE morphologic_width_values;
40 DROP TABLE discharge_zone;
41 DROP TABLE flow_velocity_model;
42 DROP TABLE flow_velocity_model_values;
35 43
36 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; 44 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
37 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 45 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
38 DROP SEQUENCE ELEVATION_MODEL_SEQ; 46 DROP SEQUENCE ELEVATION_MODEL_SEQ;
39 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 47 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
43 DROP SEQUENCE DEPTHS_ID_SEQ; 51 DROP SEQUENCE DEPTHS_ID_SEQ;
44 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ; 52 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ;
45 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ; 53 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ;
46 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ; 54 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ;
47 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ; 55 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ;
56 DROP SEQUENCE DISCHARGE_ZONE_ID_SEQ;
57 DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ;
58 DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ;
48 59
http://dive4elements.wald.intevation.org