annotate backend/doc/schema/oracle-drop-minfo.sql @ 8234:b6371be363b1

(issue1448) Carry sq_ti_date in artifact description anf fix sqtipanel The sq ti panel no longer inherits from SQOffEpoch panel as it is now to different for that to make sense. This commit also implements createOld for the SQ Ti panel.
author Andre Heinecke <andre.heinecke@intevation.de>
date Mon, 08 Sep 2014 17:52:52 +0200
parents 5f28aa1be795
children a846a3d910a0
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;
8072
5f28aa1be795 SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
Tom Gottfried <tom@intevation.de>
parents: 8018
diff changeset
25 ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_grain_fraction_id;
5f28aa1be795 SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
Tom Gottfried <tom@intevation.de>
parents: 8018
diff changeset
26 ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_unit_id;
5f28aa1be795 SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
Tom Gottfried <tom@intevation.de>
parents: 8018
diff changeset
27 ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_time_interval_id;
5f28aa1be795 SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
Tom Gottfried <tom@intevation.de>
parents: 8018
diff changeset
28 ALTER TABLE sediment_load_ls DROP CONSTRAINT fk_slls_river_id;
5f28aa1be795 SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
Tom Gottfried <tom@intevation.de>
parents: 8018
diff changeset
29 ALTER TABLE sediment_load_ls_values DROP CONSTRAINT fk_sllsv_sediment_load_ls_id;
8018
ad614eff7a9b SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tom Gottfried <tom@intevation.de>
parents: 6652
diff changeset
30 ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_kind_id;
ad614eff7a9b SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tom Gottfried <tom@intevation.de>
parents: 6652
diff changeset
31 ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_grain_fraction_id;
ad614eff7a9b SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tom Gottfried <tom@intevation.de>
parents: 6652
diff changeset
32 ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_time_interval_id;
ad614eff7a9b SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tom Gottfried <tom@intevation.de>
parents: 6652
diff changeset
33 ALTER TABLE sediment_load DROP CONSTRAINT fk_sl_sq_time_interval_id;
ad614eff7a9b SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tom Gottfried <tom@intevation.de>
parents: 6652
diff changeset
34 ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_sediment_load_id;
ad614eff7a9b SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tom Gottfried <tom@intevation.de>
parents: 6652
diff changeset
35 ALTER TABLE sediment_load_values DROP CONSTRAINT fk_slv_m_station_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
36 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
37 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
38 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
39 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
40 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
41 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
42 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
43 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
44
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
45 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
46 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
47 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
48 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
49 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
50 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
51 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
52 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
53 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
54 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
55 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
56 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
57 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
58 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
59 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
60 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
61 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
62 DROP TABLE grain_fraction PURGE;
8072
5f28aa1be795 SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
Tom Gottfried <tom@intevation.de>
parents: 8018
diff changeset
63 DROP TABLE sediment_load_ls PURGE;
5f28aa1be795 SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
Tom Gottfried <tom@intevation.de>
parents: 8018
diff changeset
64 DROP TABLE sediment_load_ls_values PURGE;
8018
ad614eff7a9b SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tom Gottfried <tom@intevation.de>
parents: 6652
diff changeset
65 DROP TABLE sediment_load PURGE;
ad614eff7a9b SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tom Gottfried <tom@intevation.de>
parents: 6652
diff changeset
66 DROP TABLE sediment_load_values PURGE;
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
67 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
68 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
69 DROP TABLE sq_relation PURGE;
2805
a55b7b35cc3a First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
70
a55b7b35cc3a First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
71 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
a55b7b35cc3a First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
72 DROP SEQUENCE ELEVATION_MODEL_SEQ;
a55b7b35cc3a First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
73 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
a55b7b35cc3a First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
74 DROP SEQUENCE BED_SINGLE_VALUES_ID_SEQ;
a55b7b35cc3a First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
75 DROP SEQUENCE BED_EPOCH_VALUES_ID_SEQ;
a55b7b35cc3a First things for MINFO specific database schema.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
76 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
77 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
78 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
79 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
80 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
81 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
82 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
83 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
84 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
85 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
86 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
87 DROP SEQUENCE GRAIN_FRACTION_ID_SEQ;
8072
5f28aa1be795 SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
Tom Gottfried <tom@intevation.de>
parents: 8018
diff changeset
88 DROP SEQUENCE SEDIMENT_LOAD_LS_ID_SEQ;
5f28aa1be795 SCHEMA CHANGE: rename database tables from yield to load_ls according to respective classes.
Tom Gottfried <tom@intevation.de>
parents: 8018
diff changeset
89 DROP SEQUENCE SEDIMENT_LOAD_LS_VALUES_ID_SEQ;
8018
ad614eff7a9b SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tom Gottfried <tom@intevation.de>
parents: 6652
diff changeset
90 DROP SEQUENCE SEDIMENT_LOAD_ID_SEQ;
ad614eff7a9b SCHEMA CHANGE: consistent naming scheme and drop script for sediment load at measurement stations.
Tom Gottfried <tom@intevation.de>
parents: 6652
diff changeset
91 DROP SEQUENCE SEDIMENT_LOAD_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
92 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
93 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
94 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ;

http://dive4elements.wald.intevation.org