Mercurial > dive4elements > river

annotate backend/doc/schema/oracle-drop-minfo.sql @ 7483:f206f6049b2b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Dont assume that wqdays are always of none zero length.
author Sascha L. Teichmann <teichmann@intevation.de>
date Thu, 31 Oct 2013 18:26:49 +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;
http://dive4elements.wald.intevation.org