diff options
| author | Rob Stradling <rob@comodo.com> | 2017-02-24 15:24:18 +0000 |
|---|---|---|
| committer | Rob Stradling <rob@comodo.com> | 2017-02-24 15:24:18 +0000 |
| commit | acedfe99be9a3b9b14210e1dcd448d883db05018 (patch) | |
| tree | bdf0d2e079d4514f64c359cbc03dc279d115d68b | |
| parent | 54cc5a134557d001c79beee183891792b8ac018c (diff) | |
| download | certwatch_db-acedfe99be9a3b9b14210e1dcd448d883db05018.zip certwatch_db-acedfe99be9a3b9b14210e1dcd448d883db05018.tar.gz certwatch_db-acedfe99be9a3b9b14210e1dcd448d883db05018.tar.bz2 | |
Store CRL sizes.
| -rw-r--r-- | create_schema.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/create_schema.sql b/create_schema.sql index 9f3ce28..4d90c21 100644 --- a/create_schema.sql +++ b/create_schema.sql @@ -161,6 +161,7 @@ CREATE TABLE crl ( IS_ACTIVE boolean, ERROR_MESSAGE text, CRL_SHA256 bytea, + CRL_SIZE integer CONSTRAINT crl_pk PRIMARY KEY (CA_ID, DISTRIBUTION_POINT_URL), CONSTRAINT crl_ca_fk @@ -171,6 +172,9 @@ CREATE TABLE crl ( CREATE INDEX crl_ia_lc ON crl (IS_ACTIVE, NEXT_CHECK_DUE, DISTRIBUTION_POINT_URL); +CREATE INDEX crl_sz + ON crl (CRL_SIZE); + CREATE TABLE crl_revoked ( CA_ID integer, SERIAL_NUMBER bytea, |