Ok, try adding optional no_certs arg to PKCS7.sign()

svn path=/docs/rpki-db-schema.sql; revision=1557

1 files changed, 11 insertions, 1 deletions

diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql
index 17fa1541..90dbb5fd 100644
--- a/docs/rpki-db-schema.sql
+++ b/docs/rpki-db-schema.sql
@@ -123,6 +123,17 @@ CREATE TABLE ca_detail (
        FOREIGN KEY              (ca_id) REFERENCES ca
 );
 
+DROP TABLE IF EXISTS revoked;
+
+CREATE TABLE revoked (
+       revoked_id           SERIAL NOT NULL,
+       serial               BIGINT unsigned NOT NULL,
+       expires              DATETIME NOT NULL,
+       ca_detail_id         BIGINT unsigned NOT NULL,
+       PRIMARY KEY          (revoked_id),
+       FOREIGN KEY          (ca_detail_id) REFERENCES ca_detail
+);
+
 DROP TABLE IF EXISTS child;
 
 CREATE TABLE child (
@@ -141,7 +152,6 @@ CREATE TABLE child_cert (
        child_cert_id        SERIAL NOT NULL,
        cert                 LONGBLOB NOT NULL,
        ski                  TINYBLOB NOT NULL,
-       revoked              DATETIME,
        child_id             BIGINT unsigned NOT NULL,
        ca_detail_id         BIGINT unsigned NOT NULL,
        PRIMARY KEY          (child_cert_id),