Mercurial > dive4elements > river
diff flys-backend/doc/schema/oracle-drop-minfo.sql @ 3329:cc8fc6b29649
Store sq relations into database after parsing.
flys-backend/trunk@4647 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 13 Jun 2012 08:12:00 +0000 |
| parents | a2a33eff93aa |
| children | 8667f629d238 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql Wed Jun 13 06:22:04 2012 +0000 +++ b/flys-backend/doc/schema/oracle-drop-minfo.sql Wed Jun 13 08:12:00 2012 +0000 @@ -40,6 +40,7 @@ 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 DROP CONSTRAINT fk_sqr_river_id; ALTER TABLE sq_relation_value DROP CONSTRAINT fk_sqr_id; DROP TABLE bed_height_type; @@ -68,8 +69,8 @@ DROP TABLE waterlevel_difference; DROP TABLE waterlevel_difference_column; DROP TABLE waterlevel_difference_values; +DROP TABLE sq_relation_value; DROP TABLE sq_relation; -DROP TABLE sq_relation_value; DROP SEQUENCE BED_HEIGHT_TYPE_SEQ; DROP SEQUENCE LOCATION_SYSTEM_SEQ;