From 933f80c3914b0cd973e53b2bcb17f05a5763f03f Mon Sep 17 00:00:00 2001
From: Martin Willi <martin@strongswan.org>
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

