Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql.sql @ 505:ce9c6f05f464
Schema: Added a column which tells if a river counts its km up or downwards.
flys-backend/trunk@1894 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 11 May 2011 08:44:14 +0000 |
| parents | 4f2d8980415f |
| children | 5bcf338eadb9 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql.sql Tue May 10 17:31:10 2011 +0000 +++ b/flys-backend/doc/schema/postgresql.sql Wed May 11 08:44:14 2011 +0000 @@ -4,8 +4,9 @@ CREATE SEQUENCE RIVERS_ID_SEQ; CREATE TABLE rivers ( - id int PRIMARY KEY NOT NULL, - name VARCHAR(256) NOT NULL UNIQUE + id int PRIMARY KEY NOT NULL, + name VARCHAR(256) NOT NULL UNIQUE, + km_up BOOLEAN NOT NULL DEFAULT true ); -- Bruecke, Haefen, etc.