changeset 6871:5ce6a3d7d632 double-precision

Undo misguided schema change from r5207
author Tom Gottfried <tom@intevation.de>
date Mon, 19 Aug 2013 17:29:52 +0200
parents 3aff1b00618a
children f1aeb6a60380
files backend/doc/schema/oracle.sql backend/doc/schema/postgresql.sql
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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),
--- 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),

http://dive4elements.wald.intevation.org