From c08aa24ba903a7b161133eb7766f4f404a2356da Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Sat, 1 Feb 2014 00:11:21 +0000 Subject: Checkpoint: Add ee_cert table to rpkid.sql. Corresponding Python class not written yet. svn path=/branches/tk671/; revision=5659 --- rpkid/rpki/sql_schemas.py | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'rpkid/rpki/sql_schemas.py') 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: -- cgit v1.2.3 From 6b136bf5c8d948cb34bb4e42764a591a9d19b140 Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Sat, 1 Feb 2014 00:14:32 +0000 Subject: Oops, smoketest.py depends on the DROP TABLE IF EXISTS statements in rpkid.sql. svn path=/branches/tk671/; revision=5660 --- rpkid/rpki/sql_schemas.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'rpkid/rpki/sql_schemas.py') diff --git a/rpkid/rpki/sql_schemas.py b/rpkid/rpki/sql_schemas.py index a6d54d9d..106237bf 100644 --- a/rpkid/rpki/sql_schemas.py +++ b/rpkid/rpki/sql_schemas.py @@ -2,7 +2,7 @@ ## @var rpkid ## SQL schema rpkid -rpkid = '''-- $Id: rpkid.sql 3745 2011-03-27 00:21:57Z sra $ +rpkid = '''-- $Id: rpkid.sql 5659 2014-02-01 00:11:21Z sra $ -- Copyright (C) 2009--2011 Internet Systems Consortium ("ISC") -- @@ -37,6 +37,7 @@ rpkid = '''-- $Id: rpkid.sql 3745 2011-03-27 00:21:57Z sra $ -- DROP TABLE commands must be in correct (reverse dependency) order -- to satisfy FOREIGN KEY constraints. +DROP TABLE IF EXISTS ee_cert; DROP TABLE IF EXISTS ghostbuster; DROP TABLE IF EXISTS roa_prefix; DROP TABLE IF EXISTS roa; -- cgit v1.2.3 From ffe44eb81854d7e2d852ebfa4410f340ccd4c4bd Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Sat, 15 Feb 2014 02:07:20 +0000 Subject: Regen svn path=/branches/tk671/; revision=5664 --- rpkid/rpki/sql_schemas.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'rpkid/rpki/sql_schemas.py') diff --git a/rpkid/rpki/sql_schemas.py b/rpkid/rpki/sql_schemas.py index 106237bf..554dee0b 100644 --- a/rpkid/rpki/sql_schemas.py +++ b/rpkid/rpki/sql_schemas.py @@ -2,7 +2,7 @@ ## @var rpkid ## SQL schema rpkid -rpkid = '''-- $Id: rpkid.sql 5659 2014-02-01 00:11:21Z sra $ +rpkid = '''-- $Id: rpkid.sql 5660 2014-02-01 00:14:32Z sra $ -- Copyright (C) 2009--2011 Internet Systems Consortium ("ISC") -- -- cgit v1.2.3