Mercurial > dive4elements > river
changeset 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 | 9a3ca7532f2a |
| children | 62e6598a2c4b |
| files | backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql |
| diffstat | 2 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Thu May 02 21:23:44 2013 +0200 +++ b/backend/doc/schema/oracle.sql Fri May 03 07:47:15 2013 +0200 @@ -260,7 +260,7 @@ CREATE TABLE rivers ( id NUMBER(38,0) NOT NULL, - official_number NUMBER(38,0) UNIQUE, + official_number NUMBER(38,0), km_up NUMBER(38,0) NOT NULL DEFAULT 0, name VARCHAR2(255) NOT NULL UNIQUE, wst_unit_id NUMBER(38,0) NOT NULL,
--- a/backend/doc/schema/postgresql.sql Thu May 02 21:23:44 2013 +0200 +++ b/backend/doc/schema/postgresql.sql Fri May 03 07:47:15 2013 +0200 @@ -12,7 +12,7 @@ CREATE TABLE rivers ( id int PRIMARY KEY NOT NULL, - official_number int8 UNIQUE, + official_number int8, name VARCHAR(256) NOT NULL UNIQUE, km_up BOOLEAN NOT NULL DEFAULT true, wst_unit_id int NOT NULL REFERENCES units(id)