2 -- Table structure for table 'radippool'
5 CREATE TABLE radippool (
6 id BIGSERIAL PRIMARY KEY,
7 pool_name varchar(64) NOT NULL,
8 FramedIPAddress INET NOT NULL,
9 NASIPAddress VARCHAR(16) NOT NULL default '',
10 pool_key VARCHAR(64) NOT NULL default 0,
11 CalledStationId VARCHAR(64),
12 CallingStationId text NOT NULL default ''::text,
13 expiry_time TIMESTAMP(0) without time zone NOT NULL default 'now'::timestamp(0),
14 username text DEFAULT ''::text
17 CREATE INDEX radippool_poolname_expire ON radippool USING btree (pool_name, expiry_time);
18 CREATE INDEX radippool_framedipaddress ON radippool USING btree (framedipaddress);
19 CREATE INDEX radippool_nasip_poolkey_ipaddress ON radippool USING btree (nasipaddress, pool_key, framedipaddress);