Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 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 | 4a83e14f40f9 |
| children | 249390dd24e7 |
line wrap: on
line diff
--- 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)