From ab635e029ec5a88d41aaa3dbf864d1ae6bd9a982 Mon Sep 17 00:00:00 2001
From: Andreas Steffen <andreas.steffen@strongswan.org>
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

