From 57ec9a57364fe23c83175452029cf2a9cb9b59f5 Mon Sep 17 00:00:00 2001 From: "Alan T. DeKok" Date: Tue, 10 Aug 2010 08:13:32 +0200 Subject: [PATCH] Added indexes to IP Pool table --- raddb/sql/mysql/ippool.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/raddb/sql/mysql/ippool.sql b/raddb/sql/mysql/ippool.sql index 780d3cd..8e94f82 100644 --- a/raddb/sql/mysql/ippool.sql +++ b/raddb/sql/mysql/ippool.sql @@ -11,5 +11,8 @@ CREATE TABLE radippool ( expiry_time DATETIME NULL default NULL, username varchar(64) NOT NULL default '', pool_key varchar(30) NOT NULL, - PRIMARY KEY (id) + PRIMARY KEY (id), + KEY radippool_poolname_expire (pool_name, expiry_time), + KEY framedipaddress (framedipaddress), + KEY radippool_nasip_poolkey_ipaddress (nasipaddress, pool_key, framedipaddress) ) ENGINE=InnoDB; -- 2.1.4