summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorRob Stradling <rob@comodo.com>2016-10-07 12:02:15 +0100
committerRob Stradling <rob@comodo.com>2016-10-07 12:02:15 +0100
commit1dbe13e4fcbe29289cbc01737348cb60c477e1b8 (patch)
tree8f5ca9560906d14b78573b0509459052d6244e4c
parent93adb5cf8d9f6002b9c65b15ad2be0286620b9ea (diff)
downloadcertwatch_db-1dbe13e4fcbe29289cbc01737348cb60c477e1b8.zip
certwatch_db-1dbe13e4fcbe29289cbc01737348cb60c477e1b8.tar.gz
certwatch_db-1dbe13e4fcbe29289cbc01737348cb60c477e1b8.tar.bz2
Support CRLset revocations by SPKI.
-rw-r--r--create_schema.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/create_schema.sql b/create_schema.sql
index b22e3a0..162890a 100644
--- a/create_schema.sql
+++ b/create_schema.sql
@@ -511,8 +511,9 @@ CREATE TABLE google_blacklist_import (
CREATE TABLE google_crlset_import (
ISSUER_SPKI_SHA256 bytea,
SERIAL_NUMBER bytea,
+ SPKI_SHA256 bytea,
CONSTRAINT gci_pk
- PRIMARY KEY (ISSUER_SPKI_SHA256, SERIAL_NUMBER)
+ PRIMARY KEY (ISSUER_SPKI_SHA256, SERIAL_NUMBER, SPKI_SHA256)
);
CREATE TABLE google_revoked (