INSERT INTO `calls` (`id` , `calldate` , `clid` ,`src` ,`dst` ,`dcontext` ,`channel` , `dstchannel`, `lastapp`, `lastdata`, `duration`, `billsec`, `disposition`, `amaflags`, `accountcode`, `uniqueid` , `userfield`, `src_device_id`, `dst_device_id`, `processed`, `did_price`, `card_id`, `provider_id`, `provider_rate`, `provider_billsec`, `provider_price`, `user_id`, `user_rate`, `user_billsec`, `user_price`, `reseller_id`, `reseller_rate`, `reseller_billsec`, `reseller_price`, `partner_id`, `partner_rate`,`partner_billsec`,`partner_price`, `prefix`, `server_id`, `hangupcause`, `callertype`, `peerip`, `recvip`, `sipfrom`, `uri`, `useragent`, `peername`, `t38passthrough`, `did_inc_price`, `did_prov_price`, `localized_dst`, `did_provider_id`, `did_id`, `originator_ip`, `terminator_ip`, `real_duration`, `real_billsec`, `did_billsec`)VALUES (226 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'37011111111','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,18 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,5 ,8 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,0 ,4 ,15 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,12 ,5 ,0), (227 ,DATE_SUB(NOW(), INTERVAL 45 MINUTE),'' ,'101' ,'37065512345','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,18 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,2 ,8 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,2 ,4 ,16 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,12 ,6 ,0), (228 ,DATE_SUB(NOW(), INTERVAL 1 MINUTE),'' ,'101' ,'37065512346','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,18 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,6 ,8 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,3 ,4 ,2 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,12 ,7 ,0), (229 ,DATE_SUB(NOW(), INTERVAL 15 SECOND),'' ,'101' ,'37065512347','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,18 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,8 ,5 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 ,24 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,13 ,8 ,0), (230 ,DATE_SUB(NOW(), INTERVAL 35 MINUTE),'' ,'101' ,'37065512348','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,18 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,5 ,8 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,0 ,4 ,25 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,14 ,9 ,0), (231 ,DATE_SUB(NOW(), INTERVAL 59 SECOND),'' ,'101' ,'37011111111','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,18 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,3 ,8 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,2 ,4 ,7 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,14 ,2 ,0), (232 ,DATE_SUB(NOW(), INTERVAL 33 MINUTE),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,6 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,3 ,4 ,1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (233 ,DATE_SUB(NOW(), INTERVAL 1 MINUTE),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,8 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 ,1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (234 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,7 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,5 ,4 ,1 ,2 ,3 ,0 ,0 ,3 ,3 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (235 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,7 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,5 ,4 ,1 ,2 ,3 ,0 ,0 ,3 ,3 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (236 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,5 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,0 ,4 ,1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (237 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,7 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,5 ,4 ,1 ,2 ,3 ,0 ,0 ,3 ,3 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (238 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,6 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,3 ,4 ,1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (239 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,4 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,2 ,4 ,1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (240 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,2 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,2 ,4 ,1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (241 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,6 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,3 ,4 ,1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (242 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,7 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,5 ,4 ,1 ,2 ,3 ,0 ,0 ,3 ,3 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0), (243 ,DATE_SUB(NOW(), INTERVAL 50 SECOND),'' ,'101' ,'123123' ,'' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,7 ,0 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,5 ,4 ,1 ,2 ,3 ,0 ,0 ,3 ,3 ,0 ,0 ,7 ,'1231' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'123123' ,0 ,0 ,'' ,'' ,0 ,0 ,0); INSERT INTO `devices` (`id`, `name`, `host` , `secret`, `context` , `ipaddr`, `port` , `regseconds`, `accountcode` , `callerid` , `extension`, `voicemail_active`, `username`, `device_type`, `user_id`, `primary_did_id`, `works_not_logged`, `forward_to`, `record`, `transfer`, `disallow`, `allow` , `deny` , `permit`, `nat`, `qualify`, `fullcontact`, `canreinvite`, `devicegroup_id`, `dtmfmode`, `callgroup`, `pickupgroup`, `fromuser`, `fromdomain`, `trustrpid`, `sendrpid`, `insecure`, `progressinband`, `videosupport`, `location_id` , `description`, `istrunk`, `cid_from_dids`, `pin`, `tell_balance`, `tell_time`, `tell_rtime_when_left`, `repeat_rtime_every`, `t38pt_udptl`, `regserver`, `ani`, `promiscredir`, `timeout`, `process_sipchaninfo`, `temporary_id`, `allow_duplicate_calls`, `call_limit`, `faststart`, `h245tunneling`, `latency`, `grace_time`, `recording_to_email`, `recording_keep`, `recording_email`) VALUES (8 ,'108' ,'dynamic','108' ,'mor_local','0.0.0.0',0 ,1175892667 ,2 ,'\"108\" <108>','108' ,0 ,'108' ,'IAX2' ,4 ,0 ,1 ,0 ,0 ,'no' ,'all' ,'all' ,'0.0.0.0/0.0.0.0','0.0.0.0/0.0.0.0','yes' ,'yes' ,'' ,'no' ,NULL ,'rfc2833' ,NULL ,NULL ,NULL ,NULL ,'no' ,'no' ,'no' ,'never' ,'no' ,1 ,'Test Device for Resellers User',0 ,0 ,NULL ,0 ,0 ,60 ,60 ,'no' ,NULL ,0 ,'no' ,60 ,0 ,NULL ,0 ,0 ,'yes' ,'yes' ,0 ,0 ,0 ,0 ,NULL); INSERT INTO `adnumbers`(`id`,`number`,`status`,`campaign_id`,`executed_time`,`completed_time`,`channel`,`user_id`) VALUES (11 ,'37065512345','completed',2,'2011-10-06 16:10:01','2011-10-06 16:10:53','Local/2348032004079@mor_ad_exec-08df,2',4), (12 ,'37065512346','completed',2,'2011-10-06 16:10:02','2011-10-06 16:10:54','Local/2348032004079@mor_ad_exec-08df,2',4), (13 ,'37065512347','completed',2,'2011-10-06 16:10:03','2011-10-06 16:10:55','Local/2348032004079@mor_ad_exec-08df,2',4), (14 ,'37065512348','completed',2,'2011-10-06 16:10:04','2011-10-06 16:10:56','Local/2348032004079@mor_ad_exec-08df,2',4);