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/sqlite.sql | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) (limited to 'src/charon/plugins/sql/sqlite.sql') diff --git a/src/charon/plugins/sql/sqlite.sql b/src/charon/plugins/sql/sqlite.sql index f004534be..8ea1d9041 100644 --- a/src/charon/plugins/sql/sqlite.sql +++ b/src/charon/plugins/sql/sqlite.sql @@ -99,3 +99,27 @@ CREATE TABLE private_keys ( keyid BLOB NOT NULL, data BLOB NOT NULL ); + +DROP TABLE IF EXISTS ike_sas; +CREATE TABLE ike_sas ( + local_spi BLOB NOT NULL PRIMARY KEY, + remote_spi BLOB NOT NULL, + id INTEGER NOT NULL, + initiator INTEGER NOT NULL, + local_id TEXT NOT NULL, + remote_id TEXT NOT NULL, + local TEXT NOT NULL, + remote TEXT NOT NULL +); + +DROP TABLE IF EXISTS logs; +CREATE TABLE logs ( + id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + local_spi BLOB NOT NULL, + signal INTEGER NOT NULL, + level INTEGER NOT NULL, + msg TEXT NOT NULL +); + + + -- cgit v1.2.3