Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 6011:d9a1cf0438a5
backout 6009:6ea171b6d8d2 because this was only really valid for fixations
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 13 May 2013 18:21:55 +0200 |
| parents | 6ea171b6d8d2 |
| children | d12f920bbf00 |
comparison
equal
deleted
inserted
replaced
| 6009:6ea171b6d8d2 | 6011:d9a1cf0438a5 |
|---|---|
| 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) NOT NULL, | 328 time_interval_id NUMBER(38,0), |
| 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 ); |