Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 1212:dd948530fd57
Schema: Added missing columns in HYK tables.
flys-backend/trunk@2338 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Fri, 15 Jul 2011 14:33:12 +0000 |
| parents | c12b5fbd33e8 |
| children | 32ee9babe42c |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Fri Jul 15 13:07:45 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Fri Jul 15 14:33:12 2011 +0000 @@ -298,15 +298,19 @@ CREATE TABLE hyks ( id int PRIMARY KEY NOT NULL, river_id int NOT NULL, + measure TIMESTAMP, description VARCHAR(256) NOT NULL ); CREATE SEQUENCE HYK_ENTRIES_ID_SEQ; CREATE TABLE hyk_entries ( - id int PRIMARY KEY NOT NULL, - hyk_id int NOT NULL REFERENCES hyks(id), - km NUMERIC NOT NULL, + id int PRIMARY KEY NOT NULL, + hyk_id int NOT NULL REFERENCES hyks(id), + km NUMERIC NOT NULL, + distance_vl NUMERIC NOT NULL, + distance_hf NUMERIC NOT NULL, + distance_vr NUMERIC NOT NULL, UNIQUE (hyk_id, km) );