Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 3946:948c7289fc42
Backend: Added 'official_number' column to rivers table to model the 'Bundeswasserstrassen Identnummer'.
flys-backend/trunk@5571 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Sat, 22 Sep 2012 13:45:51 +0000 |
| parents | 61195d14b844 |
| children | 83a42e6a562d |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Fri Sep 21 10:47:32 2012 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Sat Sep 22 13:45:51 2012 +0000 @@ -11,10 +11,11 @@ CREATE SEQUENCE RIVERS_ID_SEQ; CREATE TABLE rivers ( - id int PRIMARY KEY NOT NULL, - name VARCHAR(256) NOT NULL UNIQUE, - km_up BOOLEAN NOT NULL DEFAULT true, - wst_unit_id int NOT NULL REFERENCES units(id) + id int PRIMARY KEY NOT NULL, + official_number int8 UNIQUE, + name VARCHAR(256) NOT NULL UNIQUE, + km_up BOOLEAN NOT NULL DEFAULT true, + wst_unit_id int NOT NULL REFERENCES units(id) ); -- Bruecke, Haefen, etc.