Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 5893:c1abd48a03e2
Schema change: remove UNIQUE-constraint from rivers.official number as we have different representations of the same river (e.g. for sommer and winter)
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 03 May 2013 07:47:15 +0200 |
| parents | 4f35b34f4efa |
| children | 62e6598a2c4b |
comparison
equal
deleted
inserted
replaced
| 5892:9a3ca7532f2a | 5893:c1abd48a03e2 |
|---|---|
| 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 official_number int8 UNIQUE, | 15 official_number int8, |
| 16 name VARCHAR(256) NOT NULL UNIQUE, | 16 name VARCHAR(256) NOT NULL UNIQUE, |
| 17 km_up BOOLEAN NOT NULL DEFAULT true, | 17 km_up BOOLEAN NOT NULL DEFAULT true, |
| 18 wst_unit_id int NOT NULL REFERENCES units(id) | 18 wst_unit_id int NOT NULL REFERENCES units(id) |
| 19 ); | 19 ); |
| 20 | 20 |