Mercurial > dive4elements > river
diff 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 |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Tue Oct 14 19:21:33 2014 +0200 +++ b/backend/doc/schema/oracle.sql Wed Oct 15 14:58:46 2014 +0200 @@ -264,10 +264,11 @@ id NUMBER(38,0) NOT NULL, model_uuid CHAR(36 CHAR) UNIQUE, official_number NUMBER(38,0), - km_up NUMBER(38,0) DEFAULT 0 NOT NULL, + km_up int DEFAULT 0 NOT NULL, name VARCHAR2(255) NOT NULL UNIQUE, wst_unit_id NUMBER(38,0) NOT NULL, - PRIMARY KEY (id) + PRIMARY KEY (id), + CHECK(km_up IN(0,1)) );