Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 1217:d5e39c16fd2a
Schema: Fixed location of 'Peilungsjahre' in HYKs
flys-backend/trunk@2343 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sun, 17 Jul 2011 10:24:20 +0000 |
| parents | 32ee9babe42c |
| children | 1dbafbba50ea |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Sun Jul 17 10:00:13 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Sun Jul 17 10:24:20 2011 +0000 @@ -298,7 +298,6 @@ CREATE TABLE hyks ( id int PRIMARY KEY NOT NULL, river_id int NOT NULL, - measure TIMESTAMP, description VARCHAR(256) NOT NULL ); @@ -308,6 +307,7 @@ id int PRIMARY KEY NOT NULL, hyk_id int NOT NULL REFERENCES hyks(id), km NUMERIC NOT NULL, + measure TIMESTAMP, UNIQUE (hyk_id, km) );