diff options
| author | Martin Willi <martin@strongswan.org> | 2008-04-02 12:25:14 +0000 |
|---|---|---|
| committer | Martin Willi <martin@strongswan.org> | 2008-04-02 12:25:14 +0000 |
| commit | 489e3da0eab6c0fb829b2954c01a3300399c4346 (patch) | |
| tree | d34d0ab91ccb0c34a3e2f1f23bde490c8733fd19 /src/charon/plugins/med_db/mysql.sql | |
| parent | e29ebcb1afee8acb3ae593d99f0323c2d9ee9b4b (diff) | |
| download | strongswan-489e3da0eab6c0fb829b2954c01a3300399c4346.tar.bz2 strongswan-489e3da0eab6c0fb829b2954c01a3300399c4346.tar.xz | |
updated mediation database to public key authentication
added mysql table definition, test data
testcase
Diffstat (limited to 'src/charon/plugins/med_db/mysql.sql')
| -rw-r--r-- | src/charon/plugins/med_db/mysql.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/src/charon/plugins/med_db/mysql.sql b/src/charon/plugins/med_db/mysql.sql new file mode 100644 index 000000000..0fb60dbc6 --- /dev/null +++ b/src/charon/plugins/med_db/mysql.sql @@ -0,0 +1,12 @@ + +CREATE TABLE IF NOT EXISTS `Peer` ( + `IdPeer` int(10) unsigned NOT NULL auto_increment, + `IdUser` int(10) unsigned NOT NULL, + `Alias` varchar(30) collate utf8_unicode_ci NOT NULL, + `KeyId` varbinary(20) NOT NULL, + `PublicKey` blob NOT NULL, + PRIMARY KEY (`IdPeer`), + KEY `KeyId` (`KeyId`), + KEY `IdUser` (`IdUser`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + |