1 files changed, 11 insertions, 3 deletions
diff --git a/db/cert-checker.sql b/db/cert-checker.sql
index 0103a49..2503e7c 100644
--- a/db/cert-checker.sql
+++ b/db/cert-checker.sql
@@ -21,13 +21,21 @@ CREATE TABLE IF NOT EXISTS ocsp_urls (
   date   INTEGER NOT NULL
 );
 
+-- Table 'chains_to_check'
+CREATE TABLE IF NOT EXISTS chains_to_check (
+  chain_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+  check_id INTEGER NOT NULL,
+
+  FOREIGN KEY (check_id) REFERENCES to_check(check_id) ON DELETE CASCADE
+);
+
 -- Table 'certs_to_check'
 CREATE TABLE IF NOT EXISTS certs_to_check (
-  cert_id     INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-  check_id    INTEGER NOT NULL,
+  chain_id    INTEGER NOT NULL,
   certificate TEXT NOT NULL,
 
-  FOREIGN KEY (check_id) REFERENCES to_check(check_id) ON DELETE CASCADE
+  PRIMARY KEY (chain_id, certificate),
+  FOREIGN KEY (chain_id) REFERENCES chains_to_check(chain_id) ON DELETE CASCADE
 );
 
 COMMIT TRANSACTION;