Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
1225:d859c4bc6ace | 1226:1dbafbba50ea |
---|---|
295 | 295 |
296 CREATE SEQUENCE HYKS_ID_SEQ; | 296 CREATE SEQUENCE HYKS_ID_SEQ; |
297 | 297 |
298 CREATE TABLE hyks ( | 298 CREATE TABLE hyks ( |
299 id int PRIMARY KEY NOT NULL, | 299 id int PRIMARY KEY NOT NULL, |
300 river_id int NOT NULL, | 300 river_id int NOT NULL REFERENCES rivers(id), |
301 description VARCHAR(256) NOT NULL | 301 description VARCHAR(256) NOT NULL |
302 ); | 302 ); |
303 | 303 |
304 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ; | 304 CREATE SEQUENCE HYK_ENTRIES_ID_SEQ; |
305 | 305 |