Mercurial > dive4elements > river
changeset 173:8e2f2ddc507f
Fixed wrong spelled column references in foreign keys introduces with last change.
flys-backend/trunk@1465 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 14 Mar 2011 15:40:14 +0000 |
| parents | 605320b7df94 |
| children | 249390dd24e7 |
| files | flys-backend/ChangeLog flys-backend/doc/schema/postgresql.sql |
| diffstat | 2 files changed, 8 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Mon Mar 14 15:29:00 2011 +0000 +++ b/flys-backend/ChangeLog Mon Mar 14 15:40:14 2011 +0000 @@ -1,3 +1,9 @@ +2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de> + + * doc/schema/postgresql.sql: Fixed wrong spelled + column references in foreign keys introduces with + last change. + 2011-03-14 Sascha L. Teichmann <sascha.teichmann@intevation.de> * src/main/java/de/intevation/flys/model/*.java: Added
--- a/flys-backend/doc/schema/postgresql.sql Mon Mar 14 15:29:00 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Mon Mar 14 15:40:14 2011 +0000 @@ -149,7 +149,7 @@ CREATE TABLE wst_columns ( id int PRIMARY KEY NOT NULL, - wst_id int NOT NULL REFERENCES wst(id), + wst_id int NOT NULL REFERENCES wsts(id), name VARCHAR(256) NOT NULL, description VARCHAR, @@ -185,7 +185,7 @@ CREATE TABLE wst_column_q_ranges ( id int PRIMARY KEY NOT NULL, - wst_column_id int NOT NULL REFERENCES wst_column(id), + wst_column_id int NOT NULL REFERENCES wst_columns(id), wst_q_range_id int NOT NULL REFERENCES wst_q_ranges(id), UNIQUE (wst_column_id, wst_q_range_id)