diff options
author | Tobias Brunner <tobias@strongswan.org> | 2010-04-12 13:51:10 +0200 |
---|---|---|
committer | Tobias Brunner <tobias@strongswan.org> | 2010-04-12 13:51:10 +0200 |
commit | 355c3a66b17ba50a813df62e0e821a1f900c32d9 (patch) | |
tree | e5bd88eca0f05ecacc275fe209b746e546446313 /src | |
parent | 054fd746583e21000e6f0a5054327d0b2d316f84 (diff) | |
download | strongswan-355c3a66b17ba50a813df62e0e821a1f900c32d9.tar.bz2 strongswan-355c3a66b17ba50a813df62e0e821a1f900c32d9.tar.xz |
When logging to the database, the IDs of an IKE SA are initially NULL.
Diffstat (limited to 'src')
-rw-r--r-- | src/libcharon/plugins/sql/mysql.sql | 4 | ||||
-rw-r--r-- | src/libcharon/plugins/sql/sqlite.sql | 4 |
2 files changed, 4 insertions, 4 deletions
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, |