aboutsummaryrefslogtreecommitdiffstats
path: root/src/libcharon/plugins/sql/mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/libcharon/plugins/sql/mysql.sql')
-rw-r--r--src/libcharon/plugins/sql/mysql.sql6
1 files changed, 3 insertions, 3 deletions
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`),