Mercurial > dive4elements > river
diff backend/doc/schema/postgresql.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/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.