# HG changeset patch
# User Tom Gottfried <tom.gottfried@intevation.de>
# Date 1377876680 -7200
# Node ID dcc7a6c8b92c30684410abbfbb958caf22abd1a8
# Parent  a442cab851986ba5d71dd7a0561d870bcfc121a8
Minor schema change: allow to delete ranges with associated DEMs.

diff -r a442cab85198 -r dcc7a6c8b92c backend/doc/schema/oracle-spatial.sql
--- 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),
diff -r a442cab85198 -r dcc7a6c8b92c backend/doc/schema/postgresql-spatial.sql
--- 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,