Mercurial > dive4elements > river
diff backend/doc/schema/oracle.sql @ 6642:b1fa193fa5db double-precision
Schema change: droped NOT NULL constraint from attributes.value because empty string is silently converted to NULL in Oracle but needed here.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Tue, 23 Jul 2013 18:05:11 +0200 |
| parents | 97145ec4e33c |
| children | 839f1a889c4a |
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql Tue Jul 23 11:59:07 2013 +0200 +++ b/backend/doc/schema/oracle.sql Tue Jul 23 18:05:11 2013 +0200 @@ -27,10 +27,11 @@ CREATE TABLE attributes ( id NUMBER(38,0) NOT NULL, - value VARCHAR2(255) NOT NULL UNIQUE, + value VARCHAR2(255) UNIQUE, primary key (id) ); - +-- value can not be NOT NULL in Oracle: +-- '' is needed here and silently converted to NULL in Oracle -- CROSS_SECTION_LINES CREATE SEQUENCE CROSS_SECTION_LINES_ID_SEQ;