diff options
| author | Tobias Brunner <tobias@strongswan.org> | 2010-11-30 18:43:50 +0100 |
|---|---|---|
| committer | Tobias Brunner <tobias@strongswan.org> | 2010-12-03 18:07:17 +0100 |
| commit | 37bc3799515725f8cf56021a4ae09d4001fbaf2c (patch) | |
| tree | 2b9756b68d133e87707d779308f2d82c11745c59 /src/libcharon/plugins/sql/mysql.sql | |
| parent | ece5d52e383ec0f90fd04f2ac42aaeeb75d89181 (diff) | |
| download | strongswan-37bc3799515725f8cf56021a4ae09d4001fbaf2c.tar.bz2 strongswan-37bc3799515725f8cf56021a4ae09d4001fbaf2c.tar.xz | |
Tables added for CAs and CDPs.
Diffstat (limited to 'src/libcharon/plugins/sql/mysql.sql')
| -rw-r--r-- | src/libcharon/plugins/sql/mysql.sql | 18 |
1 files changed, 18 insertions, 0 deletions
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, |