Mercurial > gemma

diff schema/gemma.sql @ 1906:32c56e6c089a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Stretch import: Added forgotten source file.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 18 Jan 2019 17:13:12 +0100
parents d72a1539ef3c
children f538d9a23329
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Jan 18 17:01:19 2019 +0100
+++ b/schema/gemma.sql	Fri Jan 18 17:13:12 2019 +0100
@@ -364,7 +364,8 @@
     )
 
     CREATE TABLE stretch_countries (
-        stretches_id int NOT NULL REFERENCES stretches(id),
+        stretches_id int NOT NULL REFERENCES stretches(id)
+            ON DELETE CASCADE,
         country_code char(2) NOT NULL REFERENCES countries(country_code),
         UNIQUE(stretches_id, country_code)
     )