Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-drop-minfo.sql @ 3321:a2a33eff93aa
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 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql Tue Jun 05 16:57:01 2012 +0000 +++ b/flys-backend/doc/schema/oracle-drop-minfo.sql Thu Jun 07 09:52:44 2012 +0000 @@ -39,6 +39,8 @@ ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_unit_id; ALTER TABLE waterlevel_difference_column DROP CONSTRAINT fk_wdc_difference_id; ALTER TABLE waterlevel_difference_values DROP CONSTRAINT fk_wdv_column_id; +ALTER TABLE sq_relation DROP CONSTRAINT fk_sqr_tinterval_id; +ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; DROP TABLE bed_height_type; DROP TABLE location_system; @@ -66,6 +68,8 @@ DROP TABLE waterlevel_difference; DROP TABLE waterlevel_difference_column; DROP TABLE waterlevel_difference_values; +DROP TABLE sq_relation; +DROP TABLE sq_relation_value; DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; DROP SEQUENCE LOCATION_SYSTEM_SEQ; @@ -93,4 +97,5 @@ DROP SEQUENCE WATERLEVEL_DIFFERENCE_ID_SEQ; DROP SEQUENCE WATERLEVEL_DIFF_COLUMN_ID_SEQ; DROP SEQUENCE WATERLEVEL_DIFF_VALUES_ID_SEQ; - +DROP SEQUENCE SQ_RELATION_ID_SEQ; +DROP SEQUENCE SQ_RELATION_VALUES_ID_SEQ;