Mercurial > dive4elements > river
annotate flys-backend/doc/schema/oracle-drop-minfo.sql @ 2835:8649e4ed01ec
Removed superflous imports.
flys-backend/trunk@4267 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Wed, 18 Apr 2012 12:29:05 +0000 |
parents | daba3f895eb3 |
children | 6b541d85c5cf |
rev | line source |
---|---|
2805
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
1 SET AUTOCOMMIT ON; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
2 |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
3 ALTER TABLE elevation_model DROP CONSTRAINT fk_unit; |
2809
f283212966e8
Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2807
diff
changeset
|
4 ALTER TABLE bed_height_single DROP CONSTRAINT fk_bed_single_river_id; |
2805
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
5 ALTER TABLE bed_height_single DROP CONSTRAINT fk_type; |
2807
5ac1db5156be
Some oracle db schema adaptions specific to bed heights in MINFO.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2805
diff
changeset
|
6 ALTER TABLE bed_height_single DROP CONSTRAINT fk_location_system; |
2805
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
7 ALTER TABLE bed_height_single DROP CONSTRAINT fk_cur_elevation_model; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
8 ALTER TABLE bed_height_single DROP CONSTRAINT fk_old_elevation_model; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
9 ALTER TABLE bed_height_single DROP CONSTRAINT fk_range; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
10 ALTER TABLE bed_height_single_values DROP CONSTRAINT fk_bed_single_values_parent; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
11 ALTER TABLE bed_height_epoch_values DROP CONSTRAINT fk_bed_epoch_values_parent; |
2809
f283212966e8
Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2807
diff
changeset
|
12 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_cur_elevation_model; |
f283212966e8
Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2807
diff
changeset
|
13 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_old_elevation_model; |
f283212966e8
Finished work on MINFO bed heights (single).
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2807
diff
changeset
|
14 ALTER TABLE bed_height_epoch DROP CONSTRAINT fk_epoch_range; |
2812
a36a5407acbf
Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2809
diff
changeset
|
15 ALTER TABLE depths DROP CONSTRAINT fk_depths_unit_id; |
a36a5407acbf
Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2809
diff
changeset
|
16 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_depth_id; |
2816
70b4a31a3306
Implemented the method stubs of the parser for sediment density and made some db schema adaptions.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2812
diff
changeset
|
17 ALTER TABLE sediment_density DROP CONSTRAINT fk_sd_unit_id; |
2812
a36a5407acbf
Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2809
diff
changeset
|
18 ALTER TABLE sediment_density_values DROP CONSTRAINT fk_sdv_sediment_density_id; |
2818
25ed1f18fcc4
Improved the MIFNO DB schema for morphological width and added model classes.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2816
diff
changeset
|
19 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_river_id; |
25ed1f18fcc4
Improved the MIFNO DB schema for morphological width and added model classes.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2816
diff
changeset
|
20 ALTER TABLE morphologic_width DROP CONSTRAINT fk_mw_unit_id; |
25ed1f18fcc4
Improved the MIFNO DB schema for morphological width and added model classes.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2816
diff
changeset
|
21 ALTER TABLE morphologic_width_values DROP CONSTRAINT fk_mwv_morphologic_width_id; |
2824
85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2818
diff
changeset
|
22 ALTER TABLE flow_velocity_model_values DROP CONSTRAINT fk_fvv_flow_velocity_model_id; |
85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2818
diff
changeset
|
23 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_river_id; |
85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2818
diff
changeset
|
24 ALTER TABLE flow_velocity_model DROP CONSTRAINT fk_fvm_discharge_zone_id; |
85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2818
diff
changeset
|
25 ALTER TABLE discharge_zone DROP CONSTRAINT fk_dz_river_id; |
2829
4074777afcfa
Added MINFO specific relations for flow velocity measurements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2824
diff
changeset
|
26 ALTER TABLE flow_velocity_measurements DROP CONSTRAINT fk_fvm_rivers_id; |
4074777afcfa
Added MINFO specific relations for flow velocity measurements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2824
diff
changeset
|
27 ALTER TABLE flow_velocity_measure_values DROP CONSTRAINT fk_fvmv_measurements_id; |
2834
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
28 ALTER TABLE grain_fraction DROP CONSTRAINT fk_gf_unit_id; |
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
29 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_grain_fraction_id; |
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
30 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_unit_id; |
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
31 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id; |
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
32 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_id; |
2805
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
33 |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
34 DROP TABLE bed_height_type; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
35 DROP TABLE location_system; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
36 DROP TABLE elevation_model; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
37 DROP TABLE bed_height_single; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
38 DROP TABLE bed_height_single_values; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
39 DROP TABLE bed_height_epoch_values; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
40 DROP TABLE bed_height_epoch; |
2812
a36a5407acbf
Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2809
diff
changeset
|
41 DROP TABLE depths; |
a36a5407acbf
Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2809
diff
changeset
|
42 DROP TABLE sediment_density; |
a36a5407acbf
Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2809
diff
changeset
|
43 DROP TABLE sediment_density_values; |
2818
25ed1f18fcc4
Improved the MIFNO DB schema for morphological width and added model classes.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2816
diff
changeset
|
44 DROP TABLE morphologic_width; |
25ed1f18fcc4
Improved the MIFNO DB schema for morphological width and added model classes.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2816
diff
changeset
|
45 DROP TABLE morphologic_width_values; |
2824
85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2818
diff
changeset
|
46 DROP TABLE discharge_zone; |
85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2818
diff
changeset
|
47 DROP TABLE flow_velocity_model; |
85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2818
diff
changeset
|
48 DROP TABLE flow_velocity_model_values; |
2829
4074777afcfa
Added MINFO specific relations for flow velocity measurements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2824
diff
changeset
|
49 DROP TABLE flow_velocity_measurements; |
4074777afcfa
Added MINFO specific relations for flow velocity measurements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2824
diff
changeset
|
50 DROP TABLE flow_velocity_measure_values; |
2834
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
51 DROP TABLE grain_fraction; |
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
52 DROP TABLE sediment_yield; |
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
53 DROP TABLE sediment_yield_values; |
2805
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
54 |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
55 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
56 DROP SEQUENCE LOCATION_SYSTEM_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
57 DROP SEQUENCE ELEVATION_MODEL_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
58 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
59 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
60 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
61 DROP SEQUENCE BED_HEIGHT_EPOCH_ID_SEQ; |
2812
a36a5407acbf
Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2809
diff
changeset
|
62 DROP SEQUENCE DEPTHS_ID_SEQ; |
a36a5407acbf
Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2809
diff
changeset
|
63 DROP SEQUENCE SEDIMENT_DENSITY_ID_SEQ; |
a36a5407acbf
Improved the MINFO db schema and added model classes for storing sediment density values specific to a river and depth.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2809
diff
changeset
|
64 DROP SEQUENCE SEDIMENT_DENSITY_VALUES_ID_SEQ; |
2818
25ed1f18fcc4
Improved the MIFNO DB schema for morphological width and added model classes.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2816
diff
changeset
|
65 DROP SEQUENCE MORPHOLOGIC_WIDTH_ID_SEQ; |
25ed1f18fcc4
Improved the MIFNO DB schema for morphological width and added model classes.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2816
diff
changeset
|
66 DROP SEQUENCE MORPH_WIDTH_VALUES_ID_SEQ; |
2824
85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2818
diff
changeset
|
67 DROP SEQUENCE DISCHARGE_ZONE_ID_SEQ; |
85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2818
diff
changeset
|
68 DROP SEQUENCE FLOW_VELOCITY_MODEL_ID_SEQ; |
85b2b5e7377f
Improved the oracle db schema for MINFO specific flow velocity values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2818
diff
changeset
|
69 DROP SEQUENCE FLOW_VELOCITY_M_VALUES_ID_SEQ; |
2829
4074777afcfa
Added MINFO specific relations for flow velocity measurements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2824
diff
changeset
|
70 DROP SEQUENCE FV_MEASURE_ID_SEQ; |
4074777afcfa
Added MINFO specific relations for flow velocity measurements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2824
diff
changeset
|
71 DROP SEQUENCE FV_MEASURE_VALUES_ID_SEQ; |
2834
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
72 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ; |
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
73 DROP SEQUENCE SEDIMENT_YIELD_ID_SEQ; |
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
74 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; |
2805
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
75 |