From ab635e029ec5a88d41aaa3dbf864d1ae6bd9a982 Mon Sep 17 00:00:00 2001 From: Andreas Steffen Date: Mon, 12 Jul 2010 20:28:24 +0200 Subject: updated SQL templates to support attribute pool and identity parameters --- src/libcharon/plugins/sql/mysql.sql | 14 +++++++++++++- 1 file changed, 13 insertions(+), 1 deletion(-) (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 f4a62a6f8..5a6dd10e9 100644 --- a/src/libcharon/plugins/sql/mysql.sql +++ b/src/libcharon/plugins/sql/mysql.sql @@ -187,11 +187,23 @@ CREATE TABLE leases ( PRIMARY KEY (`id`) ); +DROP TABLE IF EXISTS attribute_pools; +CREATE TABLE attribute_pools ( + `id` int(10) unsigned NOT NULL auto_increment, + `name` varchar(32) NOT NULL, + PRIMARY KEY (`id`) +); + DROP TABLE IF EXISTS attributes; CREATE TABLE attributes ( `id` int(10) unsigned NOT NULL auto_increment, + `identity` int(10) unsigned NOT NULL default '0', + `pool` int(10) unsigned NOT NULL default '0', `type` int(10) unsigned NOT NULL, - `value` varbinary(16) NOT NULL + `value` varbinary(16) NOT NULL, + PRIMARY KEY (`id`), + INDEX (`identity`), + INDEX (`pool`) ); DROP TABLE IF EXISTS ike_sas; -- cgit v1.2.3