diff options
| author | Martin Willi <martin@strongswan.org> | 2008-03-15 14:17:09 +0000 |
|---|---|---|
| committer | Martin Willi <martin@strongswan.org> | 2008-03-15 14:17:09 +0000 |
| commit | 933f80c3914b0cd973e53b2bcb17f05a5763f03f (patch) | |
| tree | 3da831084360a6e117478ffdd7f4a318c8524ff5 /src/charon/plugins/sql/mysql.sql | |
| parent | 72d68379dc36393ab5b964ff19b9801a2ba5bc4d (diff) | |
| download | strongswan-933f80c3914b0cd973e53b2bcb17f05a5763f03f.tar.bz2 strongswan-933f80c3914b0cd973e53b2bcb17f05a5763f03f.tar.xz | |
logging to SQL database
Diffstat (limited to 'src/charon/plugins/sql/mysql.sql')
| -rw-r--r-- | src/charon/plugins/sql/mysql.sql | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/src/charon/plugins/sql/mysql.sql b/src/charon/plugins/sql/mysql.sql index 4fee18dbe..72a775090 100644 --- a/src/charon/plugins/sql/mysql.sql +++ b/src/charon/plugins/sql/mysql.sql @@ -114,3 +114,28 @@ CREATE TABLE private_keys ( PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +DROP TABLE IF EXISTS ike_sas; +CREATE TABLE ike_sas ( + `local_spi` BLOB(8) NOT NULL, + `remote_spi` BLOB(8) NOT NULL, + `id` int(10) unsigned NOT NULL, + `initiator` tinyint(1) NOT NULL, + `local_id` varchar(64) collate utf8_unicode_ci default NULL, + `remote_id` varchar(64) collate utf8_unicode_ci default NULL, + `local` varchar(64) collate utf8_unicode_ci NOT NULL, + `remote` varchar(64) collate utf8_unicode_ci NOT NULL, + PRIMARY KEY (local_spi(8)) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + +DROP TABLE IF EXISTS logs; +CREATE TABLE logs ( + `id` int(10) unsigned NOT NULL auto_increment, + `local_spi` BLOB(8) NOT NULL, + `signal` tinyint(3) NOT NULL, + `level` tinyint(3) NOT NULL, + `msg`varchar(256) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; + + |