From: Alan T. DeKok <aland@freeradius.org>
Date: Tue, 10 Aug 2010 06:13:32 +0000 (+0200)
Subject: Added indexes to IP Pool table
X-Git-Tag: release_3_0_0_beta0~1297
X-Git-Url: http://www.project-moonshot.org/gitweb/?p=freeradius.git;a=commitdiff_plain;h=57ec9a57364fe23c83175452029cf2a9cb9b59f5

Added indexes to IP Pool table
---

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;