Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2834:daba3f895eb3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improved the db schema to store sediment yield values. flys-backend/trunk@4266 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Wed, 18 Apr 2012 12:12:22 +0000
parents 5b54a648f702
children 6b541d85c5cf
comparison
equal deleted inserted replaced
2833:5b54a648f702 2834:daba3f895eb3
23 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_river_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; 24 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_discharge_zone_id;
25 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id; 25 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id;
26 ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id; 26 ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id;
27 ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id; 27 ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id;
28 ALTER TABLE grain_fraction DROP CONSTRAINT fk_gf_unit_id;
29 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id;
30 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id;
31 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id;
32 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id;
28 33
29 DROP TABLE bed_height_type; 34 DROP TABLE bed_height_type;
30 DROP TABLE location_system; 35 DROP TABLE location_system;
31 DROP TABLE elevation_model; 36 DROP TABLE elevation_model;
32 DROP TABLE bed_height_single; 37 DROP TABLE bed_height_single;
41 DROP TABLE discharge_zone; 46 DROP TABLE discharge_zone;
42 DROP TABLE flow_velocity_model; 47 DROP TABLE flow_velocity_model;
43 DROP TABLE flow_velocity_model_values; 48 DROP TABLE flow_velocity_model_values;
44 DROP TABLE flow_velocity_measurements; 49 DROP TABLE flow_velocity_measurements;
45 DROP TABLE flow_velocity_measure_values; 50 DROP TABLE flow_velocity_measure_values;
51 DROP TABLE grain_fraction;
52 DROP TABLE sediment_yield;
53 DROP TABLE sediment_yield_values;
46 54
47 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; 55 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
48 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 56 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
49 DROP SEQUENCE ELEVATION_MODEL_SEQ; 57 DROP SEQUENCE ELEVATION_MODEL_SEQ;
50 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 58 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
59 DROP SEQUENCE DISCHARGE_ZONE_ID_SEQ; 67 DROP SEQUENCE DISCHARGE_ZONE_ID_SEQ;
60 DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ; 68 DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ;
61 DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ; 69 DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ;
62 DROP SEQUENCE FV_MEASURE_ID_SEQ; 70 DROP SEQUENCE FV_MEASURE_ID_SEQ;
63 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ; 71 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ;
72 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ;
73 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ;
74 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ;
64 75
http://dive4elements.wald.intevation.org