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/mysql.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'src/libcharon/plugins/sql/mysql.sql') diff --git a/src/libcharon/plugins/sql/mysql.sql b/src/libcharon/plugins/sql/mysql.sql index 668d9d0b1..a09cbeaa7 100644 --- a/src/libcharon/plugins/sql/mysql.sql +++ b/src/libcharon/plugins/sql/mysql.sql @@ -175,6 +175,24 @@ CREATE TABLE shared_secret_identity ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; +DROP TABLE IF EXISTS certificate_authorities; +CREATE TABLE certificate_authorities ( + `id` int(10) unsigned NOT NULL auto_increment, + `certificate` int(10) unsigned NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + + +DROP TABLE IF EXISTS certificate_distribution_points; +CREATE TABLE certificate_distribution_points ( + `id` int(10) unsigned NOT NULL auto_increment, + `ca` int(10) unsigned NOT NULL, + `type` tinyint(3) unsigned NOT NULL, + `uri` varchar(256) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + + DROP TABLE IF EXISTS pools; CREATE TABLE pools ( `id` int(10) unsigned NOT NULL auto_increment, -- cgit v1.2.3