changeset 6012:da58da430bed

merged
author Tom Gottfried <tom@intevation.de>
date Mon, 13 May 2013 18:22:58 +0200
parents d9a1cf0438a5 (diff) db1bb9d44722 (current diff)
children cf7cf3fc3d8e
files
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle.sql	Mon May 13 18:16:40 2013 +0200
+++ b/backend/doc/schema/oracle.sql	Mon May 13 18:22:58 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) NOT NULL,
+    time_interval_id    NUMBER(38,0),
     wst_id              NUMBER(38,0) NOT NULL,
     UNIQUE (wst_id, name),
     UNIQUE (wst_id, position),
--- a/backend/doc/schema/postgresql.sql	Mon May 13 18:16:40 2013 +0200
+++ b/backend/doc/schema/postgresql.sql	Mon May 13 18:22:58 2013 +0200
@@ -203,7 +203,7 @@
     description VARCHAR(256),
     position    int NOT NULL DEFAULT 0,
 
-    time_interval_id int NOT NULL REFERENCES time_intervals(id),
+    time_interval_id int REFERENCES time_intervals(id),
 
     UNIQUE (wst_id, name),
     UNIQUE (wst_id, position)

http://dive4elements.wald.intevation.org