# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1376926192 -7200
# Node ID 5ce6a3d7d63200e8fa9d1ed31f12a9d9be8d5bbc
# Parent  3aff1b00618ad4bfe0e3fe022c6f6bce1a2671f0
Undo misguided schema change from r5207

diff -r 3aff1b00618a -r 5ce6a3d7d632 backend/doc/schema/oracle.sql
--- a/backend/doc/schema/oracle.sql	Wed Aug 14 12:54:00 2013 +0200
+++ b/backend/doc/schema/oracle.sql	Mon Aug 19 17:29:52 2013 +0200
@@ -124,7 +124,7 @@
     name                VARCHAR2(255) NOT NULL,
     station             NUMBER(38,2) NOT NULL,
     official_number     NUMBER(38,0),
-    range_id            NUMBER(38,0) NOT NULL,
+    range_id            NUMBER(38,0),
     -- TODO: remove river id here because range_id references river already
     river_id            NUMBER(38,0) NOT NULL,
     PRIMARY KEY         (id),
diff -r 3aff1b00618a -r 5ce6a3d7d632 backend/doc/schema/postgresql.sql
--- a/backend/doc/schema/postgresql.sql	Wed Aug 14 12:54:00 2013 +0200
+++ b/backend/doc/schema/postgresql.sql	Mon Aug 19 17:29:52 2013 +0200
@@ -91,7 +91,7 @@
     -- Pegelnullpunkt
     datum    NUMERIC NOT NULL,
     -- Streckengueltigkeit
-    range_id int NOT NULL REFERENCES ranges (id) ON DELETE CASCADE,
+    range_id int REFERENCES ranges (id) ON DELETE CASCADE,
 
     UNIQUE (name, river_id),
     UNIQUE (official_number, river_id),