Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 1226:1dbafbba50ea
Schema: added missing key contraint on hyks table.
flys-backend/trunk@2359 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Tue, 19 Jul 2011 10:10:51 +0000 |
| parents | d5e39c16fd2a |
| children | f834b411ca57 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Mon Jul 18 16:55:32 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Tue Jul 19 10:10:51 2011 +0000 @@ -297,7 +297,7 @@ CREATE TABLE hyks ( id int PRIMARY KEY NOT NULL, - river_id int NOT NULL, + river_id int NOT NULL REFERENCES rivers(id), description VARCHAR(256) NOT NULL );