Mercurial > dive4elements > river
comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2834:daba3f895eb3
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 |