From b2cd0870a3379cc378cb460c6e66af788b62fed5 Mon Sep 17 00:00:00 2001 From: Tobias Brunner Date: Tue, 11 Feb 2014 20:50:32 +0100 Subject: sql: Set default values for some fields in addresses table --- src/libcharon/plugins/sql/mysql.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'src/libcharon/plugins/sql/mysql.sql') diff --git a/src/libcharon/plugins/sql/mysql.sql b/src/libcharon/plugins/sql/mysql.sql index 0d1468176..1b437593d 100644 --- a/src/libcharon/plugins/sql/mysql.sql +++ b/src/libcharon/plugins/sql/mysql.sql @@ -211,9 +211,9 @@ CREATE TABLE addresses ( `id` int(10) unsigned NOT NULL auto_increment, `pool` int(10) unsigned NOT NULL, `address` varbinary(16) NOT NULL, - `identity` int(10) unsigned NOT NULL, - `acquired` int(10) unsigned NOT NULL, - `released` int(10) unsigned DEFAULT NULL, + `identity` int(10) unsigned NOT NULL DEFAULT 0, + `acquired` int(10) unsigned NOT NULL DEFAULT 0, + `released` int(10) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`id`), INDEX (`pool`), INDEX (`identity`), -- cgit v1.2.3