Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 6502:3b93f439e954 double-precision
Schema change: add new field 'source' to wst_columns, currently only for official lines
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Fri, 28 Jun 2013 16:58:46 +0200 |
| parents | a8b065038c0c |
| children | 97145ec4e33c |
comparison
equal
deleted
inserted
replaced
| 6481:5910ada51a9f | 6502:3b93f439e954 |
|---|---|
| 323 | 323 |
| 324 CREATE TABLE wst_columns ( | 324 CREATE TABLE wst_columns ( |
| 325 id NUMBER(38,0) NOT NULL, | 325 id NUMBER(38,0) NOT NULL, |
| 326 description VARCHAR2(255), | 326 description VARCHAR2(255), |
| 327 name VARCHAR2(255) NOT NULL, | 327 name VARCHAR2(255) NOT NULL, |
| 328 source VARCHAR(256), | |
| 328 position NUMBER(38,0) NOT NULL DEFAULT 0, | 329 position NUMBER(38,0) NOT NULL DEFAULT 0, |
| 329 time_interval_id NUMBER(38,0), | 330 time_interval_id NUMBER(38,0), |
| 330 wst_id NUMBER(38,0) NOT NULL, | 331 wst_id NUMBER(38,0) NOT NULL, |
| 331 UNIQUE (wst_id, name), | 332 UNIQUE (wst_id, name), |
| 332 UNIQUE (wst_id, position), | 333 UNIQUE (wst_id, position), |