From 355c3a66b17ba50a813df62e0e821a1f900c32d9 Mon Sep 17 00:00:00 2001 From: Tobias Brunner Date: Mon, 12 Apr 2010 13:51:10 +0200 Subject: When logging to the database, the IDs of an IKE SA are initially NULL. --- src/libcharon/plugins/sql/mysql.sql | 4 ++-- src/libcharon/plugins/sql/sqlite.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) (limited to 'src/libcharon/plugins/sql') diff --git a/src/libcharon/plugins/sql/mysql.sql b/src/libcharon/plugins/sql/mysql.sql index 1a01394b6..ea4b7e7cb 100644 --- a/src/libcharon/plugins/sql/mysql.sql +++ b/src/libcharon/plugins/sql/mysql.sql @@ -201,9 +201,9 @@ CREATE TABLE ike_sas ( `id` int(10) unsigned NOT NULL, `initiator` tinyint(1) NOT NULL, `local_id_type` tinyint(3) NOT NULL, - `local_id_data` varbinary(64) NOT NULL, + `local_id_data` varbinary(64) DEFAULT NULL, `remote_id_type` tinyint(3) NOT NULL, - `remote_id_data` varbinary(64) NOT NULL, + `remote_id_data` varbinary(64) DEFAULT NULL, `host_family` tinyint(3) NOT NULL, `local_host_data` varbinary(16) NOT NULL, `remote_host_data` varbinary(16) NOT NULL, diff --git a/src/libcharon/plugins/sql/sqlite.sql b/src/libcharon/plugins/sql/sqlite.sql index 53d64dc34..a036eeee8 100644 --- a/src/libcharon/plugins/sql/sqlite.sql +++ b/src/libcharon/plugins/sql/sqlite.sql @@ -206,9 +206,9 @@ CREATE TABLE ike_sas ( id INTEGER NOT NULL, initiator INTEGER NOT NULL, local_id_type INTEGER NOT NULL, - local_id_data BLOB NOT NULL, + local_id_data BLOB DEFAULT NULL, remote_id_type INTEGER NOT NULL, - remote_id_data BLOB NOT NULL, + remote_id_data BLOB DEFAULT NULL, host_family INTEGER NOT NULL, local_host_data BLOB NOT NULL, remote_host_data BLOB NOT NULL, -- cgit v1.2.3