Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 3945:26084ee6d352 | 3946:948c7289fc42 |
|---|---|
| 9 | 9 |
| 10 -- Gewaesser | 10 -- Gewaesser |
| 11 CREATE SEQUENCE RIVERS_ID_SEQ; | 11 CREATE SEQUENCE RIVERS_ID_SEQ; |
| 12 | 12 |
| 13 CREATE TABLE rivers ( | 13 CREATE TABLE rivers ( |
| 14 id int PRIMARY KEY NOT NULL, | 14 id int PRIMARY KEY NOT NULL, |
| 15 name VARCHAR(256) NOT NULL UNIQUE, | 15 official_number int8 UNIQUE, |
| 16 km_up BOOLEAN NOT NULL DEFAULT true, | 16 name VARCHAR(256) NOT NULL UNIQUE, |
| 17 wst_unit_id int NOT NULL REFERENCES units(id) | 17 km_up BOOLEAN NOT NULL DEFAULT true, |
| 18 wst_unit_id int NOT NULL REFERENCES units(id) | |
| 18 ); | 19 ); |
| 19 | 20 |
| 20 -- Bruecke, Haefen, etc. | 21 -- Bruecke, Haefen, etc. |
| 21 CREATE SEQUENCE ATTRIBUTES_ID_SEQ; | 22 CREATE SEQUENCE ATTRIBUTES_ID_SEQ; |
| 22 | 23 |