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_ipaadr ON radippool USING btree (pool_name, framedipaddress);
18 CREATE INDEX radippool_poolname_expire ON radippool USING btree (pool_name, expiry_time);
19 CREATE INDEX radippool_nasipaddr_poolkey ON radippool USING btree (nasipaddress, pool_key);
20 CREATE INDEX radippool_nasipaddr_calling ON radippool USING btree (nasipaddress, callingstationid);