Mercurial > dive4elements > river

comparison flys-backend/doc/schema/oracle-drop-minfo.sql @ 3321:a2a33eff93aa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Improved minfo db schema and added model classes for s/q relation. flys-backend/trunk@4622 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Thu, 07 Jun 2012 09:52:44 +0000
parents c36106f15ac9
children cc8fc6b29649
comparison
equal deleted inserted replaced
3320:8f905390c10d 3321:a2a33eff93aa
37 ALTER TABLE waterlevel_values DROP CONSTRAINT fk_wv_waterlevel_q_range_id; 37 ALTER TABLE waterlevel_values DROP CONSTRAINT fk_wv_waterlevel_q_range_id;
38 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_river_id; 38 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_river_id;
39 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_unit_id; 39 ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_unit_id;
40 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id; 40 ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id;
41 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id; 41 ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id;
42 ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id;
43 ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id;
42 44
43 DROP TABLE bed_height_type; 45 DROP TABLE bed_height_type;
44 DROP TABLE location_system; 46 DROP TABLE location_system;
45 DROP TABLE elevation_model; 47 DROP TABLE elevation_model;
46 DROP TABLE bed_height_single; 48 DROP TABLE bed_height_single;
64 DROP TABLE waterlevel_q_range; 66 DROP TABLE waterlevel_q_range;
65 DROP TABLE waterlevel_values; 67 DROP TABLE waterlevel_values;
66 DROP TABLE waterlevel_difference; 68 DROP TABLE waterlevel_difference;
67 DROP TABLE waterlevel_difference_column; 69 DROP TABLE waterlevel_difference_column;
68 DROP TABLE waterlevel_difference_values; 70 DROP TABLE waterlevel_difference_values;
71 DROP TABLE sq_relation;
72 DROP TABLE sq_relation_value;
69 73
70 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; 74 DROP SEQUENCE BED_HEIGHT_TYPE_SEQ;
71 DROP SEQUENCE LOCATION_SYSTEM_SEQ; 75 DROP SEQUENCE LOCATION_SYSTEM_SEQ;
72 DROP SEQUENCE ELEVATION_MODEL_SEQ; 76 DROP SEQUENCE ELEVATION_MODEL_SEQ;
73 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ; 77 DROP SEQUENCE BED_HEIGHT_SINGLE_ID_SEQ;
91 DROP SEQUENCE WATERLEVEL_Q_RANGES_ID_SEQ; 95 DROP SEQUENCE WATERLEVEL_Q_RANGES_ID_SEQ;
92 DROP SEQUENCE WATERLEVEL_VALUES_ID_SEQ; 96 DROP SEQUENCE WATERLEVEL_VALUES_ID_SEQ;
93 DROP SEQUENCE WATERLEVEL_DIFFERENCE_ID_SEQ; 97 DROP SEQUENCE WATERLEVEL_DIFFERENCE_ID_SEQ;
94 DROP SEQUENCE WATERLEVEL_DIFF_COLUMN_ID_SEQ; 98 DROP SEQUENCE WATERLEVEL_DIFF_COLUMN_ID_SEQ;
95 DROP SEQUENCE WATERLEVEL_DIFF_VALUES_ID_SEQ; 99 DROP SEQUENCE WATERLEVEL_DIFF_VALUES_ID_SEQ;
96 100 DROP SEQUENCE SQ_RELATION_ID_SEQ;
101 DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ;
http://dive4elements.wald.intevation.org