From 933f80c3914b0cd973e53b2bcb17f05a5763f03f Mon Sep 17 00:00:00 2001 From: Martin Willi Date: Sat, 15 Mar 2008 14:17:09 +0000 Subject: logging to SQL database --- src/charon/plugins/sql/mysql.sql | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) (limited to 'src/charon/plugins/sql/mysql.sql') 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; + + -- cgit v1.2.3