Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 2371:fe89d6cf55fb
Added support for official gauge numbers.
flys-backend/trunk@3464 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 19 Dec 2011 11:21:25 +0000 |
parents | 0acf28a3d28a |
children | 056b3a5aa181 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Wed Nov 30 12:14:41 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Mon Dec 19 11:21:25 2011 +0000 @@ -78,11 +78,12 @@ CREATE SEQUENCE GAUGES_ID_SEQ; CREATE TABLE gauges ( - id int PRIMARY KEY NOT NULL, - name VARCHAR(256) NOT NULL, - river_id int NOT NULL REFERENCES rivers(id), - station NUMERIC NOT NULL UNIQUE, - aeo NUMERIC NOT NULL, + id int PRIMARY KEY NOT NULL, + name VARCHAR(256) NOT NULL, + river_id int NOT NULL REFERENCES rivers(id), + station NUMERIC NOT NULL UNIQUE, + aeo NUMERIC NOT NULL, + official_number int8 UNIQUE, -- Pegelnullpunkt datum NUMERIC NOT NULL,