projects
/
freeradius.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
dfb9de8
)
Added indexes to IP Pool table
author
Alan T. DeKok
<aland@freeradius.org>
Tue, 10 Aug 2010 06:13:32 +0000
(08:13 +0200)
committer
Alan T. DeKok
<aland@freeradius.org>
Thu, 12 Aug 2010 08:00:38 +0000
(10:00 +0200)
raddb/sql/mysql/ippool.sql
patch
|
blob
|
history
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;