diff options
author | Justus Winter <justus@sequoia-pgp.org> | 2018-09-06 16:06:28 +0200 |
---|---|---|
committer | Justus Winter <justus@sequoia-pgp.org> | 2018-09-06 16:06:28 +0200 |
commit | 69cc30f9a5cfe43c3cb4a6886ef0667e509f5820 (patch) | |
tree | 4e56d8f5301ddc2b0515c64e319ffa2cc9cc8df2 | |
parent | 5c7298150ca3d3c51c3cec030d24d5cc69d8342f (diff) |
store: Delete logs once binding, store, or key is deleted.
- Fixes #85.
-rw-r--r-- | store/src/backend/mod.rs | 6 |
1 files 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. */ |