Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 6009:6ea171b6d8d2
Schema change because WST-columns without time interval are useless
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 13 May 2013 17:48:32 +0200 |
| parents | 131f5f58ff7d |
| children | d9a1cf0438a5 |
comparison
equal
deleted
inserted
replaced
| 6008:a45da06797c7 | 6009:6ea171b6d8d2 |
|---|---|
| 323 CREATE TABLE wst_columns ( | 323 CREATE TABLE wst_columns ( |
| 324 id NUMBER(38,0) NOT NULL, | 324 id NUMBER(38,0) NOT NULL, |
| 325 description VARCHAR2(255), | 325 description VARCHAR2(255), |
| 326 name VARCHAR2(255) NOT NULL, | 326 name VARCHAR2(255) NOT NULL, |
| 327 position NUMBER(38,0) NOT NULL DEFAULT 0, | 327 position NUMBER(38,0) NOT NULL DEFAULT 0, |
| 328 time_interval_id NUMBER(38,0), | 328 time_interval_id NUMBER(38,0) NOT NULL, |
| 329 wst_id NUMBER(38,0) NOT NULL, | 329 wst_id NUMBER(38,0) NOT NULL, |
| 330 UNIQUE (wst_id, name), | 330 UNIQUE (wst_id, name), |
| 331 UNIQUE (wst_id, position), | 331 UNIQUE (wst_id, position), |
| 332 PRIMARY KEY (id) | 332 PRIMARY KEY (id) |
| 333 ); | 333 ); |