changeset 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 45e6635ef7f5
children 8782ba5cb222
files backend/doc/schema/oracle.sql
diffstat 1 files changed, 3 insertions(+), 2 deletions(-) [+]
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;

http://dive4elements.wald.intevation.org