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/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

