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 |