changeset 7001:dcc7a6c8b92c double-precision

Minor schema change: allow to delete ranges with associated DEMs.
author Tom Gottfried <tom.gottfried@intevation.de>
date Fri, 30 Aug 2013 17:31:20 +0200
parents a442cab85198
children 0850a4983fcd
files backend/doc/schema/oracle-spatial.sql backend/doc/schema/postgresql-spatial.sql
diffstat 2 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/backend/doc/schema/oracle-spatial.sql	Wed Aug 28 10:54:21 2013 +0200
+++ b/backend/doc/schema/oracle-spatial.sql	Fri Aug 30 17:31:20 2013 +0200
@@ -165,7 +165,7 @@
     ID               NUMBER PRIMARY KEY NOT NULL,
     river_id         NUMBER(38) REFERENCES rivers(id) ON DELETE CASCADE,
     name             VARCHAR(64),
-    range_id         NUMBER(38) REFERENCES ranges(id),
+    range_id         NUMBER(38) REFERENCES ranges(id) ON DELETE CASCADE,
     time_interval_id NUMBER(38) REFERENCES time_intervals(id),
     projection       VARCHAR(32),
     elevation_state  VARCHAR(32),
--- a/backend/doc/schema/postgresql-spatial.sql	Wed Aug 28 10:54:21 2013 +0200
+++ b/backend/doc/schema/postgresql-spatial.sql	Fri Aug 30 17:31:20 2013 +0200
@@ -123,7 +123,7 @@
     id       int PRIMARY KEY NOT NULL,
     river_id int REFERENCES rivers(id) ON DELETE CASCADE,
     name             VARCHAR(64),
-    range_id         INT REFERENCES ranges(id),
+    range_id         INT REFERENCES ranges(id) ON DELETE CASCADE,
     time_interval_id INT REFERENCES time_intervals(id),
     projection       VARCHAR(32),
     srid	     int NOT NULL,

http://dive4elements.wald.intevation.org