2 -- Table structure for table 'radippool'
5 id int(11) PRIMARY KEY,
6 pool_name varchar(30) NOT NULL,
7 framedipaddress varchar(15) NOT NULL default '',
8 nasipaddress varchar(15) NOT NULL default '',
9 calledstationid VARCHAR(30) NOT NULL,
10 callingstationid VARCHAR(30) NOT NULL,
11 expiry_time DATETIME NULL default NULL,
12 username varchar(64) NOT NULL default '',
13 pool_key varchar(30) NOT NULL
16 CREATE INDEX radippool_poolname_expire ON radippool(pool_name, expiry_time);
17 CREATE INDEX radippool_framedipaddress ON radippool(framedipaddress);
18 CREATE INDEX radippool_nasip_poolkey_ipaddress ON radippool(nasipaddress, pool_key, framedipaddress);