blob: 9004b36d8a0c0b0cd99bb14c907fb11d12779161 [file] [log] [blame]
CREATE TABLE radippool (
id int PRIMARY KEY,
pool_name varchar(30) NOT NULL,
framedipaddress varchar(30) NOT NULL,
nasipaddress varchar(30) NOT NULL DEFAULT '',
pool_key varchar(64) NOT NULL DEFAULT '',
calledstationid varchar(64),
callingstationid varchar(64) NOT NULL DEFAULT '',
expiry_time timestamp DEFAULT NULL,
username varchar(100)
);
-- Example of how to put IPs in the pool
-- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (1, 'local', '192.168.5.10');
-- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (2, 'local', '192.168.5.11');
-- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (3, 'local', '192.168.5.12');
-- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (4, 'local', '192.168.5.13');