diff backend/doc/schema/oracle.sql @ 6009:6ea171b6d8d2

Schema change because WST-columns without time interval are useless
author Tom Gottfried <tom@intevation.de>
date Mon, 13 May 2013 17:48:32 +0200
parents 131f5f58ff7d
children d9a1cf0438a5
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql	Mon May 13 15:53:36 2013 +0200
+++ b/backend/doc/schema/oracle.sql	Mon May 13 17:48:32 2013 +0200
@@ -325,7 +325,7 @@
     description         VARCHAR2(255),
     name                VARCHAR2(255) NOT NULL,
     position            NUMBER(38,0) NOT NULL DEFAULT 0,
-    time_interval_id    NUMBER(38,0),
+    time_interval_id    NUMBER(38,0) NOT NULL,
     wst_id              NUMBER(38,0) NOT NULL,
     UNIQUE (wst_id, name),
     UNIQUE (wst_id, position),

http://dive4elements.wald.intevation.org