Mercurial > dive4elements > river
diff backend/doc/schema/postgresql-spatial.sql @ 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 | 6a63456b99d9 |
| children | f4e32ac4e55c |
line wrap: on
line diff
--- 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,