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/sqlite.sql | |
| parent | 72d68379dc36393ab5b964ff19b9801a2ba5bc4d (diff) | |
| download | strongswan-933f80c3914b0cd973e53b2bcb17f05a5763f03f.tar.bz2 strongswan-933f80c3914b0cd973e53b2bcb17f05a5763f03f.tar.xz | |
logging to SQL database
Diffstat (limited to 'src/charon/plugins/sql/sqlite.sql')
| -rw-r--r-- | src/charon/plugins/sql/sqlite.sql | 24 |
1 files changed, 24 insertions, 0 deletions
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 +); + + + |