Added indexes to IP Pool table

[freeradius.git] / raddb / sql / mysql / ippool.sql

diff --git a/raddb/sql/mysql/ippool.sql b/raddb/sql/mysql/ippool.sql
index 780d3cd..8e94f82 100644 (file)
--- 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;