CREATE TABLE radippool (
	id INT(10) NOT NULL auto_increment,
	pool_name VARCHAR(255) NOT NULL,
	ip_address INT(10) UNSIGNED,
	nas_ip_address VARCHAR(20) NOT NULL,
	nas_port INT(5) UNSIGNED,
	calling_station_id VARCHAR(30) NOT NULL default '',
	expiry_time TIMESTAMP default NULL,
	username VARCHAR(20) default '',
	PRIMARY KEY(id),
	UNIQUE KEY ip_address_key (ip_address),
	KEY nasipaddr_calling (nas_ip_address, calling_station_id),
	KEY nasipaddr_port (nas_ip_address, nas_port),
	KEY poolname_expire (pool_name, expiry_time),
	KEY poolname_ipaddr (pool_name, ip_address)
);