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 ); |