INSERT INTO `radcheck` (`id`, `username`, `attribute`, `op`, `value`) VALUES
(744, 'device_id00005', 'Cleartext-Password', ':=', 'XXXXXXXXX');

INSERT INTO `radgroupcheck` (`id`, `groupname`, `attribute`, `op`, `value`) VALUES
(3, 'sub1', 'Service-Type', '==', 'Framed-User'),
(4, 'sub1', 'Framed-Protocol', '==', 'PPP');

INSERT INTO `radgroupreply` (`id`, `groupname`, `attribute`, `op`, `value`) VALUES
(2, 'sub1', 'Mikrotik-Rate-Limit', '=', '5M/40M 10M/41M 10M/41M 60/60');

INSERT INTO `radreply` (`id`, `username`, `attribute`, `op`, `value`) VALUES
(1468, 'device_id00005', 'Framed-IP-Address', '=', '10.10.0.4'),
(2748, 'device_id00005', 'Mikrotik-Address-List', '=', 'message');

INSERT INTO `radusergroup` (`username`, `groupname`, `priority`) VALUES
('device_id00005', 'sub1', 1);