Mercurial > dive4elements > river
comparison backend/doc/schema/oracle.sql @ 8411:b8c6cb36607e
SCHEMA CHANGE: There is no boolean data type in oracle, and therefore it's no good idea to use it in postgresql.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 15 Oct 2014 14:58:46 +0200 |
| parents | a67bd7744827 |
| children | 3531f0cee5e1 |
comparison
equal
deleted
inserted
replaced
| 8410:0ac11615a2a3 | 8411:b8c6cb36607e |
|---|---|
| 262 | 262 |
| 263 CREATE TABLE rivers ( | 263 CREATE TABLE rivers ( |
| 264 id NUMBER(38,0) NOT NULL, | 264 id NUMBER(38,0) NOT NULL, |
| 265 model_uuid CHAR(36 CHAR) UNIQUE, | 265 model_uuid CHAR(36 CHAR) UNIQUE, |
| 266 official_number NUMBER(38,0), | 266 official_number NUMBER(38,0), |
| 267 km_up NUMBER(38,0) DEFAULT 0 NOT NULL, | 267 km_up int DEFAULT 0 NOT NULL, |
| 268 name VARCHAR2(255) NOT NULL UNIQUE, | 268 name VARCHAR2(255) NOT NULL UNIQUE, |
| 269 wst_unit_id NUMBER(38,0) NOT NULL, | 269 wst_unit_id NUMBER(38,0) NOT NULL, |
| 270 PRIMARY KEY (id) | 270 PRIMARY KEY (id), |
| 271 CHECK(km_up IN(0,1)) | |
| 271 ); | 272 ); |
| 272 | 273 |
| 273 | 274 |
| 274 -- TIME_INTERVALS | 275 -- TIME_INTERVALS |
| 275 CREATE SEQUENCE TIME_INTERVALS_ID_SEQ; | 276 CREATE SEQUENCE TIME_INTERVALS_ID_SEQ; |