Mercurial > dive4elements > river
changeset 2849:c36106f15ac9
Added missing constraint to relation 'waterlevel_difference'.
flys-backend/trunk@4303 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Thu, 26 Apr 2012 09:44:39 +0000 (2012-04-26) |
parents | e7a1d78b66d8 |
children | a1402c16152f |
files | flys-backend/ChangeLog flys-backend/doc/schema/oracle-drop-minfo.sql flys-backend/doc/schema/oracle-minfo.sql |
diffstat | 3 files changed, 11 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Wed Apr 25 06:47:53 2012 +0000 +++ b/flys-backend/ChangeLog Thu Apr 26 09:44:39 2012 +0000 @@ -1,3 +1,10 @@ +2012-04-26 Ingo Weinzierl <ingo@intevation.de> + + * doc/schema/oracle-minfo.sql, + doc/schema/oracle-drop-minfo.sql: Added a missing constraint to + 'waterlevel_difference' relation. Remove that constraint in + oracle-drop-minfo.sql. + 2012-04-25 Felix Wolfsteller <felix@intevation.de> * src/main/java/de/intevation/flys/model/WaterlevelDifferenceValue.java:
--- a/flys-backend/doc/schema/oracle-drop-minfo.sql Wed Apr 25 06:47:53 2012 +0000 +++ b/flys-backend/doc/schema/oracle-drop-minfo.sql Thu Apr 26 09:44:39 2012 +0000 @@ -36,6 +36,7 @@ ALTER TABLE waterlevel_q_range DROP CONSTRAINT fk_wqr_waterlevel_id; ALTER TABLE waterlevel_values DROP CONSTRAINT fk_wv_waterlevel_q_range_id; ALTER TABLE waterlevel_difference DROP CONSTRAINT fk_wd_river_id; +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;
--- a/flys-backend/doc/schema/oracle-minfo.sql Wed Apr 25 06:47:53 2012 +0000 +++ b/flys-backend/doc/schema/oracle-minfo.sql Thu Apr 26 09:44:39 2012 +0000 @@ -321,10 +321,11 @@ CREATE TABLE waterlevel_difference ( id NUMBER(38,0) NOT NULL, river_id NUMBER(38,0) NOT NULL, - unit NUMBER(38,0) NOT NULL, + unit_id NUMBER(38,0) NOT NULL, description VARCHAR(256), PRIMARY KEY (id), - CONSTRAINT fk_wd_river_id FOREIGN KEY (river_id) REFERENCES rivers (id) + CONSTRAINT fk_wd_river_id FOREIGN KEY (river_id) REFERENCES rivers (id), + CONSTRAINT fk_wd_unit_id FOREIGN KEY (unit_id) REFERENCES units(id) );