From 69cc30f9a5cfe43c3cb4a6886ef0667e509f5820 Mon Sep 17 00:00:00 2001 From: Justus Winter Date: Thu, 6 Sep 2018 16:06:28 +0200 Subject: store: Delete logs once binding, store, or key is deleted. - Fixes #85. --- store/src/backend/mod.rs | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/store/src/backend/mod.rs b/store/src/backend/mod.rs index a356fb19..d52d90a3 100644 --- a/store/src/backend/mod.rs +++ b/store/src/backend/mod.rs @@ -1339,9 +1339,9 @@ CREATE TABLE log ( slug TEXT NOT NULL, message TEXT NOT NULL, error TEXT NULL, - FOREIGN KEY (store) REFERENCES stores(id) ON DELETE SET NULL, - FOREIGN KEY (binding) REFERENCES bindings(id) ON DELETE SET NULL, - FOREIGN KEY (key) REFERENCES keys(id) ON DELETE SET NULL); + FOREIGN KEY (store) REFERENCES stores(id) ON DELETE CASCADE, + FOREIGN KEY (binding) REFERENCES bindings(id) ON DELETE CASCADE, + FOREIGN KEY (key) REFERENCES keys(id) ON DELETE CASCADE); "; /* Miscellaneous. */ -- cgit v1.2.3