changeset 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 0ac11615a2a3
children 17db08570637
files backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql
diffstat 2 files changed, 6 insertions(+), 4 deletions(-) [+]
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))
 );
 
 
--- a/backend/doc/schema/postgresql.sql	Tue Oct 14 19:21:33 2014 +0200
+++ b/backend/doc/schema/postgresql.sql	Wed Oct 15 14:58:46 2014 +0200
@@ -15,8 +15,9 @@
     model_uuid      CHAR(36)        UNIQUE,
     official_number int8,
     name            VARCHAR(256)    NOT NULL UNIQUE,
-    km_up           BOOLEAN         NOT NULL DEFAULT true,
-    wst_unit_id int                 NOT NULL REFERENCES units(id)
+    km_up           int DEFAULT 0   NOT NULL,
+    wst_unit_id int                 NOT NULL REFERENCES units(id),
+    CHECK(km_up IN(0,1))
 );
 
 -- Bruecke, Haefen, etc.

http://dive4elements.wald.intevation.org