Checkpoint: Add ee_cert table to rpkid.sql. Corresponding Python

class not written yet.

svn path=/branches/tk671/; revision=5659

1 files changed, 14 insertions, 0 deletions

diff --git a/rpkid/rpki/sql_schemas.py b/rpkid/rpki/sql_schemas.py
index e7c65299..a6d54d9d 100644
--- a/rpkid/rpki/sql_schemas.py
+++ b/rpkid/rpki/sql_schemas.py
@@ -234,6 +234,20 @@ CREATE TABLE ghostbuster (
         FOREIGN KEY             (ca_detail_id) REFERENCES ca_detail (ca_detail_id) ON DELETE CASCADE
 ) ENGINE=InnoDB;
 
+CREATE TABLE ee_cert (
+        ee_cert_id              SERIAL NOT NULL,
+        ski                     BINARY(20) NOT NULL,
+        cert                    LONGBLOB NOT NULL,
+        published               DATETIME,
+        self_id                 BIGINT UNSIGNED NOT NULL,
+        ca_detail_id            BIGINT UNSIGNED NOT NULL,
+        PRIMARY KEY             (ee_cert_id),
+        CONSTRAINT              ee_cert_self_id
+        FOREIGN KEY             (self_id) REFERENCES self (self_id) ON DELETE CASCADE,
+        CONSTRAINT              ee_cert_ca_detail_id
+        FOREIGN KEY             (ca_detail_id) REFERENCES ca_detail (ca_detail_id) ON DELETE CASCADE
+) ENGINE=InnoDB;
+
 -- Local Variables:
 -- indent-tabs-mode: nil
 -- End: