Add revoked_cert table and rototill child_cert revocation code to use

it.  Enable MySQLdb exceptions, whack resulting problem with MySQL
DATETIME object conversion repeatedly with a blunt object.

svn path=/docs/rpki-db-schema.pdf; revision=1564

2 files changed, 12 insertions, 1 deletions

diff --git a/docs/rpki-db-schema.pdf b/docs/rpki-db-schema.pdf
index d8436d26..d9b4e595 100644
--- a/docs/rpki-db-schema.pdf
+++ b/docs/rpki-db-schema.pdf
diff --git a/docs/rpki-db-schema.sql b/docs/rpki-db-schema.sql
index 17fa1541..53421e1f 100644
--- a/docs/rpki-db-schema.sql
+++ b/docs/rpki-db-schema.sql
@@ -141,7 +141,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),
@@ -149,6 +148,18 @@ CREATE TABLE child_cert (
        FOREIGN KEY          (child_id) REFERENCES child
 );
 
+DROP TABLE IF EXISTS revoked_cert;
+
+CREATE TABLE revoked_cert (
+       revoked_cert_id      SERIAL NOT NULL,
+       serial               BIGINT unsigned NOT NULL,
+       revoked              DATETIME NOT NULL,
+       expires              DATETIME NOT NULL,
+       ca_detail_id         BIGINT unsigned NOT NULL,
+       PRIMARY KEY          (revoked_cert_id),
+       FOREIGN KEY          (ca_detail_id) REFERENCES ca_detail
+);
+
 DROP TABLE IF EXISTS route_origin;
 
 CREATE TABLE route_origin (