Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 2829:4074777afcfa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added MINFO specific relations for flow velocity measurements. flys-backend/trunk@4246 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Tue, 17 Apr 2012 10:16:21 +0000
parents 85b2b5e7377f
children 5b54a648f702
comparison
equal deleted inserted replaced
2828:ac13e466a55e 2829:4074777afcfa
22 ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_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; 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 discharge_zone DROP CONSTRAINT fk_dz_nmv_id; 26 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_nmv_id;
27 ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id;
28 ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id;
27 29
28 DROP TABLE bed_height_type; 30 DROP TABLE bed_height_type;
29 DROP TABLE location_system; 31 DROP TABLE location_system;
30 DROP TABLE elevation_model; 32 DROP TABLE elevation_model;
31 DROP TABLE bed_height_single; 33 DROP TABLE bed_height_single;
38 DROP TABLE morphologic_width; 40 DROP TABLE morphologic_width;
39 DROP TABLE morphologic_width_values; 41 DROP TABLE morphologic_width_values;
40 DROP TABLE discharge_zone; 42 DROP TABLE discharge_zone;
41 DROP TABLE flow_velocity_model; 43 DROP TABLE flow_velocity_model;
42 DROP TABLE flow_velocity_model_values; 44 DROP TABLE flow_velocity_model_values;
45 DROP TABLE flow_velocity_measurements;
46 DROP TABLE flow_velocity_measure_values;
43 47
44 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; 48 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
45 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 49 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
46 DROP SEQUENCE ELEVATION_MODEL_SEQ; 50 DROP SEQUENCE ELEVATION_MODEL_SEQ;
47 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 51 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
54 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ; 58 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ;
55 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ; 59 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ;
56 DROP SEQUENCE DISCHARGE_ZONE_ID_SEQ; 60 DROP SEQUENCE DISCHARGE_ZONE_ID_SEQ;
57 DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ; 61 DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ;
58 DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ; 62 DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ;
63 DROP SEQUENCE FV_MEASURE_ID_SEQ;
64 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ;
59 65
http://dive4elements.wald.intevation.org