Mercurial > dive4elements > river
annotate flys-backend/doc/schema/oracle-drop-minfo.sql @ 5353:d086ce6c13d3
Add jetties importer
author | Andre Heinecke <aheinecke@intevation.de> |
---|---|
date | Wed, 20 Mar 2013 17:55:53 +0100 |
parents | 6dd354e7abfc |
children | e88d55d01cf5 |
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_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
|
24 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
|
25 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
|
26 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
|
27 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
|
28 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
|
29 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_time_interval_id; |
2836
6b541d85c5cf
Added missing river_id column to sediment_yield relation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2834
diff
changeset
|
30 ALTER TABLE sediment_yield DROP CONSTRAINT fk_sy_river_id; |
2834
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_values DROP CONSTRAINT fk_syv_sediment_yield_id; |
2841
6be2bf2492f9
Added MINFO specific waterlevel relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2836
diff
changeset
|
32 ALTER TABLE waterlevel DROP CONSTRAINT fk_w_river_id; |
6be2bf2492f9
Added MINFO specific waterlevel relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2836
diff
changeset
|
33 ALTER TABLE waterlevel DROP CONSTRAINT fk_w_unit_id; |
6be2bf2492f9
Added MINFO specific waterlevel relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2836
diff
changeset
|
34 ALTER TABLE waterlevel_q_range DROP CONSTRAINT fk_wqr_waterlevel_id; |
6be2bf2492f9
Added MINFO specific waterlevel relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2836
diff
changeset
|
35 ALTER TABLE waterlevel_values DROP CONSTRAINT fk_wv_waterlevel_q_range_id; |
2846
c1c6c9190636
Improved the db schema to store MINFO specific waterlevel differences.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2841
diff
changeset
|
36 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_river_id; |
2849
c36106f15ac9
Added missing constraint to relation 'waterlevel_difference'.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2846
diff
changeset
|
37 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_unit_id; |
2846
c1c6c9190636
Improved the db schema to store MINFO specific waterlevel differences.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2841
diff
changeset
|
38 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id; |
c1c6c9190636
Improved the db schema to store MINFO specific waterlevel differences.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2841
diff
changeset
|
39 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id; |
3321
a2a33eff93aa
Improved minfo db schema and added model classes for s/q relation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2849
diff
changeset
|
40 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; |
3329
cc8fc6b29649
Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3321
diff
changeset
|
41 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_river_id; |
3321
a2a33eff93aa
Improved minfo db schema and added model classes for s/q relation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2849
diff
changeset
|
42 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; |
5206
8667f629d238
SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
Andre Heinecke <aheinecke@intevation.de>
parents:
3329
diff
changeset
|
43 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_river_id; |
8667f629d238
SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
Andre Heinecke <aheinecke@intevation.de>
parents:
3329
diff
changeset
|
44 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_range_id; |
8667f629d238
SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
Andre Heinecke <aheinecke@intevation.de>
parents:
3329
diff
changeset
|
45 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_reference_gauge_id; |
8667f629d238
SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
Andre Heinecke <aheinecke@intevation.de>
parents:
3329
diff
changeset
|
46 ALTER TABLE measurement_station DROP CONSTRAINT fk_ms_observation_timerange_id; |
2805
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
47 |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
48 DROP TABLE bed_height_type; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
49 DROP TABLE location_system; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
50 DROP TABLE elevation_model; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
51 DROP TABLE bed_height_single; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
52 DROP TABLE bed_height_single_values; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
53 DROP TABLE bed_height_epoch_values; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
54 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
|
55 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
|
56 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
|
57 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
|
58 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
|
59 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
|
60 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
|
61 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
|
62 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
|
63 DROP TABLE flow_velocity_measurements; |
4074777afcfa
Added MINFO specific relations for flow velocity measurements.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2824
diff
changeset
|
64 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
|
65 DROP TABLE grain_fraction; |
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
66 DROP TABLE sediment_yield; |
daba3f895eb3
Improved the db schema to store sediment yield values.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2833
diff
changeset
|
67 DROP TABLE sediment_yield_values; |
2841
6be2bf2492f9
Added MINFO specific waterlevel relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2836
diff
changeset
|
68 DROP TABLE waterlevel; |
6be2bf2492f9
Added MINFO specific waterlevel relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2836
diff
changeset
|
69 DROP TABLE waterlevel_q_range; |
6be2bf2492f9
Added MINFO specific waterlevel relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2836
diff
changeset
|
70 DROP TABLE waterlevel_values; |
2846
c1c6c9190636
Improved the db schema to store MINFO specific waterlevel differences.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2841
diff
changeset
|
71 DROP TABLE waterlevel_difference; |
c1c6c9190636
Improved the db schema to store MINFO specific waterlevel differences.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2841
diff
changeset
|
72 DROP TABLE waterlevel_difference_column; |
c1c6c9190636
Improved the db schema to store MINFO specific waterlevel differences.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2841
diff
changeset
|
73 DROP TABLE waterlevel_difference_values; |
5206
8667f629d238
SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
Andre Heinecke <aheinecke@intevation.de>
parents:
3329
diff
changeset
|
74 DROP TABLE measurement_station; |
3329
cc8fc6b29649
Store sq relations into database after parsing.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
3321
diff
changeset
|
75 DROP TABLE sq_relation_value; |
3321
a2a33eff93aa
Improved minfo db schema and added model classes for s/q relation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2849
diff
changeset
|
76 DROP TABLE sq_relation; |
2805
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
77 |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
78 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
79 DROP SEQUENCE LOCATION_SYSTEM_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
80 DROP SEQUENCE ELEVATION_MODEL_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
81 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
82 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
83 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
84 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
|
85 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
|
86 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
|
87 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
|
88 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
|
89 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
|
90 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
|
91 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
|
92 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
|
93 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
|
94 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
|
95 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
|
96 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
|
97 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; |
2841
6be2bf2492f9
Added MINFO specific waterlevel relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2836
diff
changeset
|
98 DROP SEQUENCE WATERLEVEL_ID_SEQ; |
6be2bf2492f9
Added MINFO specific waterlevel relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2836
diff
changeset
|
99 DROP SEQUENCE WATERLEVEL_Q_RANGES_ID_SEQ; |
6be2bf2492f9
Added MINFO specific waterlevel relations.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2836
diff
changeset
|
100 DROP SEQUENCE WATERLEVEL_VALUES_ID_SEQ; |
2846
c1c6c9190636
Improved the db schema to store MINFO specific waterlevel differences.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2841
diff
changeset
|
101 DROP SEQUENCE WATERLEVEL_DIFFERENCE_ID_SEQ; |
c1c6c9190636
Improved the db schema to store MINFO specific waterlevel differences.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2841
diff
changeset
|
102 DROP SEQUENCE WATERLEVEL_DIFF_COLUMN_ID_SEQ; |
c1c6c9190636
Improved the db schema to store MINFO specific waterlevel differences.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2841
diff
changeset
|
103 DROP SEQUENCE WATERLEVEL_DIFF_VALUES_ID_SEQ; |
3321
a2a33eff93aa
Improved minfo db schema and added model classes for s/q relation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2849
diff
changeset
|
104 DROP SEQUENCE SQ_RELATION_ID_SEQ; |
a2a33eff93aa
Improved minfo db schema and added model classes for s/q relation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
2849
diff
changeset
|
105 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ; |