Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 504:ee693b8fbb55 | 505:ce9c6f05f464 |
|---|---|
| 2 | 2 |
| 3 -- Gewaesser | 3 -- Gewaesser |
| 4 CREATE SEQUENCE RIVERS_ID_SEQ; | 4 CREATE SEQUENCE RIVERS_ID_SEQ; |
| 5 | 5 |
| 6 CREATE TABLE rivers ( | 6 CREATE TABLE rivers ( |
| 7 id int PRIMARY KEY NOT NULL, | 7 id int PRIMARY KEY NOT NULL, |
| 8 name VARCHAR(256) NOT NULL UNIQUE | 8 name VARCHAR(256) NOT NULL UNIQUE, |
| 9 km_up BOOLEAN NOT NULL DEFAULT true | |
| 9 ); | 10 ); |
| 10 | 11 |
| 11 -- Bruecke, Haefen, etc. | 12 -- Bruecke, Haefen, etc. |
| 12 CREATE SEQUENCE ATTRIBUTES_ID_SEQ; | 13 CREATE SEQUENCE ATTRIBUTES_ID_SEQ; |
| 13 | 14 |