From 37bc3799515725f8cf56021a4ae09d4001fbaf2c Mon Sep 17 00:00:00 2001 From: Tobias Brunner Date: Tue, 30 Nov 2010 18:43:50 +0100 Subject: Tables added for CAs and CDPs. --- src/libcharon/plugins/sql/sqlite.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'src/libcharon/plugins/sql/sqlite.sql') diff --git a/src/libcharon/plugins/sql/sqlite.sql b/src/libcharon/plugins/sql/sqlite.sql index a8c7a53d9..2cb0c23cf 100644 --- a/src/libcharon/plugins/sql/sqlite.sql +++ b/src/libcharon/plugins/sql/sqlite.sql @@ -175,6 +175,22 @@ CREATE TABLE 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, -- cgit v1.2.3