Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.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 |
|---|---|
| 258 -- RIVERS | 258 -- RIVERS |
| 259 CREATE SEQUENCE RIVERS_ID_SEQ; | 259 CREATE SEQUENCE RIVERS_ID_SEQ; |
| 260 | 260 |
| 261 CREATE TABLE rivers ( | 261 CREATE TABLE rivers ( |
| 262 id NUMBER(38,0) NOT NULL, | 262 id NUMBER(38,0) NOT NULL, |
| 263 official_number NUMBER(38,0) UNIQUE, | 263 official_number NUMBER(38,0), |
| 264 km_up NUMBER(38,0) NOT NULL DEFAULT 0, | 264 km_up NUMBER(38,0) NOT NULL DEFAULT 0, |
| 265 name VARCHAR2(255) NOT NULL UNIQUE, | 265 name VARCHAR2(255) NOT NULL UNIQUE, |
| 266 wst_unit_id NUMBER(38,0) NOT NULL, | 266 wst_unit_id NUMBER(38,0) NOT NULL, |
| 267 PRIMARY KEY (id) | 267 PRIMARY KEY (id) |
| 268 ); | 268 ); |