Mercurial > dive4elements > river
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,