changeset 5115:c4b28de753de dami

removed unnecessary NOT NULL constraints from dem-table
author Tom Gottfried <tom@intevation.de>
date Wed, 27 Feb 2013 15:26:47 +0100
parents 3003c45f8a00
children 94ce92e73603
files flys-backend/doc/schema/oracle-spatial.sql
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/doc/schema/oracle-spatial.sql	Wed Feb 27 12:55:38 2013 +0100
+++ b/flys-backend/doc/schema/oracle-spatial.sql	Wed Feb 27 15:26:47 2013 +0100
@@ -132,9 +132,9 @@
     name            VARCHAR(64),
     lower           NUMBER(19,5),
     upper           NUMBER(19,5),
-    year_from       VARCHAR(32) NOT NULL,
-    year_to         VARCHAR(32) NOT NULL,
-    projection      VARCHAR(32) NOT NULL,
+    year_from       VARCHAR(32),
+    year_to         VARCHAR(32),
+    projection      VARCHAR(32),
     elevation_state VARCHAR(32),
     srid            NUMBER NOT NULL,
     format          VARCHAR(32),

http://dive4elements.wald.intevation.org