Chetan Gaonker | 7f4bf74 | 2016-05-04 15:56:08 -0700 | [diff] [blame^] | 1 | CREATE TABLE radippool ( |
| 2 | id int PRIMARY KEY, |
| 3 | pool_name varchar(30) NOT NULL, |
| 4 | framedipaddress varchar(30) NOT NULL, |
| 5 | nasipaddress varchar(30) NOT NULL DEFAULT '', |
| 6 | pool_key varchar(64) NOT NULL DEFAULT '', |
| 7 | calledstationid varchar(64), |
| 8 | callingstationid varchar(64) NOT NULL DEFAULT '', |
| 9 | expiry_time timestamp DEFAULT NULL, |
| 10 | username varchar(100) |
| 11 | ); |
| 12 | |
| 13 | -- Example of how to put IPs in the pool |
| 14 | -- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (1, 'local', '192.168.5.10'); |
| 15 | -- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (2, 'local', '192.168.5.11'); |
| 16 | -- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (3, 'local', '192.168.5.12'); |
| 17 | -- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (4, 'local', '192.168.5.13'); |
| 18 | |