From 13a7f5f3e362a8c699f7fd3a08ff8d3d9402cc53 Mon Sep 17 00:00:00 2001 From: Andreas Steffen Date: Sun, 5 Dec 2010 11:30:06 +0100 Subject: [PATCH] added certificate_authorities and certificate_distribution_points tables --- testing/hosts/default/etc/ipsec.d/tables.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/testing/hosts/default/etc/ipsec.d/tables.sql b/testing/hosts/default/etc/ipsec.d/tables.sql index 9d045e0..2917fc3 100644 --- a/testing/hosts/default/etc/ipsec.d/tables.sql +++ b/testing/hosts/default/etc/ipsec.d/tables.sql @@ -161,6 +161,20 @@ CREATE TABLE shared_secret_identity ( PRIMARY KEY (shared_secret, identity) ); +DROP TABLE IF EXISTS certificate_authorities; +CREATE TABLE certificate_authorities ( + id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + certificate INTEGER NOT NULL +); + +DROP TABLE IF EXISTS certificate_distribution_points; +CREATE TABLE certificate_distribution_points ( + id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ca INTEGER NOT NULL, + type INTEGER NOT NULL, + uri TEXT NOT NULL +); + DROP TABLE IF EXISTS pools; CREATE TABLE pools ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, -- 2.7.4