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 | |
| parent | ece5d52e383ec0f90fd04f2ac42aaeeb75d89181 (diff) | |
| download | strongswan-37bc3799515725f8cf56021a4ae09d4001fbaf2c.tar.bz2 strongswan-37bc3799515725f8cf56021a4ae09d4001fbaf2c.tar.xz | |
Tables added for CAs and CDPs.
| -rw-r--r-- | src/libcharon/plugins/sql/mysql.sql | 18 | ||||
| -rw-r--r-- | src/libcharon/plugins/sql/sqlite.sql | 16 |
2 files changed, 34 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, 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, |