Mercurial > dive4elements > river
annotate backend/doc/schema/oracle-drop-minfo.sql @ 7506:e79e231c864d
Whitespace-cosmetics.
author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
---|---|
date | Fri, 01 Nov 2013 16:38:03 +0100 |
parents | 765944ca6df0 |
children | ad614eff7a9b |
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 sediment_density DROP CONSTRAINT fk_sd_depth_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_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
|
17 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
|
18 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
|
19 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
|
20 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
|
21 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
|
22 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
|
23 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
|
24 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
|
25 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
|
26 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
|
27 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
|
28 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
|
29 ALTER TABLE sediment_yield_values DROP CONSTRAINT fk_syv_sediment_yield_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
|
30 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
|
31 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
|
32 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; |
5406
e88d55d01cf5
SCHEMA CHANGE: additional columns and FK constraint for SQ-relation
Tom Gottfried <tom@intevation.de>
parents:
5321
diff
changeset
|
33 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_mstation_id; |
5206
8667f629d238
SCHEME CHANGE: Add measurement_station to oracle table and rename comment column
Andre Heinecke <aheinecke@intevation.de>
parents:
3329
diff
changeset
|
34 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
|
35 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
|
36 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
|
37 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
|
38 |
6652
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
39 DROP TABLE bed_height_type PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
40 DROP TABLE location_system PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
41 DROP TABLE elevation_model PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
42 DROP TABLE bed_height_single PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
43 DROP TABLE bed_height_single_values PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
44 DROP TABLE bed_height_epoch_values PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
45 DROP TABLE bed_height_epoch PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
46 DROP TABLE depths PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
47 DROP TABLE sediment_density PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
48 DROP TABLE sediment_density_values PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
49 DROP TABLE morphologic_width PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
50 DROP TABLE morphologic_width_values PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
51 DROP TABLE discharge_zone PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
52 DROP TABLE flow_velocity_model PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
53 DROP TABLE flow_velocity_model_values PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
54 DROP TABLE flow_velocity_measurements PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
55 DROP TABLE flow_velocity_measure_values PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
56 DROP TABLE grain_fraction PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
57 DROP TABLE sediment_yield PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
58 DROP TABLE sediment_yield_values PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
59 DROP TABLE measurement_station PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
60 DROP TABLE sq_relation_value PURGE; |
765944ca6df0
Purge tables when droping in Oracle to free space and avoid duplicates in views such as dba_constraints
Tom Gottfried <tom@intevation.de>
parents:
6632
diff
changeset
|
61 DROP TABLE sq_relation PURGE; |
2805
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
62 |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
63 DROP SEQUENCE LOCATION_SYSTEM_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
64 DROP SEQUENCE ELEVATION_MODEL_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
65 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
66 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
67 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ; |
a55b7b35cc3a
First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
68 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
|
69 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
|
70 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
|
71 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
|
72 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
|
73 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
|
74 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
|
75 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
|
76 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
|
77 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
|
78 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
|
79 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
|
80 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
|
81 DROP SEQUENCE SEDIMENT_YIELD_VALUES_ID_SEQ; |
6632
97145ec4e33c
Schema changes: fixed typos, syntax errors and missing or obsolete statements in Oracle schema
Tom Gottfried <tom@intevation.de>
parents:
5838
diff
changeset
|
82 DROP SEQUENCE MEASUREMENT_STATION_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
|
83 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
|
84 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ; |