1#
2# Table structure for table 'radippool'
3#
4CREATE TABLE IF NOT EXISTS radippool (
5  id                    int(11) unsigned NOT NULL auto_increment,
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 default '',
10  callingstationid      VARCHAR(30) NOT NULL default '',
11  expiry_time           DATETIME NOT NULL default NOW(),
12  username              varchar(64) NOT NULL default '',
13  pool_key              varchar(30) NOT NULL default '',
14  PRIMARY KEY (id),
15  KEY radippool_poolname_expire (pool_name, expiry_time),
16  KEY framedipaddress (framedipaddress),
17  KEY radippool_nasip_poolkey_ipaddress (nasipaddress, pool_key, framedipaddress)
18) ENGINE=InnoDB;
19