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 (326 ,'2010-09-02 07:20:01','' ,'101' ,'37065512345','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,18 ,10 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,8 ,6 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 ,10 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512345' ,0 ,0 ,'' ,'' ,18 ,10 ,0), (327 ,'2010-10-06 04:00:01','' ,'101' ,'37065512345','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,15 ,1 ,'BUSY' ,0 ,'2' ,'1232113379.3','' ,8 ,2 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 , 1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512345' ,0 ,0 ,'' ,'' ,15 ,1 ,0), (328 ,'2010-11-09 22:51:21','' ,'101' ,'37065512346','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,50 ,1 ,'NO ANSWER' ,0 ,'2' ,'1232113379.3','' ,8 ,3 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 , 1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512346' ,0 ,0 ,'' ,'' ,50 ,1 ,0), (329 ,'2011-02-12 04:24:31','' ,'101' ,'37065512347','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,2 ,1 ,'FAILED' ,0 ,'2' ,'1232113379.3','' ,8 ,5 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 , 1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512347' ,0 ,0 ,'' ,'' ,2 ,1 ,0), (330 ,'2011-03-26 05:42:24','' ,'101' ,'37065512348','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,2 ,1 ,'FAILED' ,0 ,'2' ,'1232113379.3','' ,8 ,6 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 , 1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512348' ,0 ,0 ,'' ,'' ,2 ,1 ,0), (331 ,'2011-04-30 09:23:45','' ,'101' ,'37065512345','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,10 ,1 ,'BUSY' ,0 ,'2' ,'1232113379.3','' ,8 ,2 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 , 1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512345' ,0 ,0 ,'' ,'' ,10 ,1 ,0), (332 ,'2011-08-06 03:52:35','' ,'101' ,'37065512345','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,534 ,500 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,8 ,2 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 , 500 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512345' ,0 ,0 ,'' ,'' ,534 ,500 ,0), (333 ,'2011-10-09 02:45:24','' ,'101' ,'37065512346','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,50 ,1 ,'NO ANSWER' ,0 ,'2' ,'1232113379.3','' ,8 ,3 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 , 1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512346' ,0 ,0 ,'' ,'' ,50 ,1 ,0), (334 ,'2011-11-01 13:34:35','' ,'101' ,'37065512347','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,600 ,544 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,8 ,5 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 , 544 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512347' ,0 ,0 ,'' ,'' ,600 ,544 ,0), (335 ,'2011-11-03 15:06:23','' ,'101' ,'37065512348','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,2 ,1 ,'FAILED' ,0 ,'2' ,'1232113379.3','' ,8 ,6 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 , 1 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512348' ,0 ,0 ,'' ,'' ,2 ,1 ,0), (336 ,'2011-11-14 21:50:43','' ,'101' ,'37065512345','' ,'Local/2348032004079@mor_ad_exec-08df,2' ,'' ,'' ,'' ,60 ,34 ,'ANSWERED' ,0 ,'2' ,'1232113379.3','' ,8 ,2 ,0 ,0 ,0 ,2 ,0 ,0 ,8 ,4 ,4 , 34 ,2 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,7 ,'370' ,1 ,16 ,'Outside' ,'' ,'' ,'' ,'' ,'' ,'' ,0 ,6 ,3 ,'37065512345' ,0 ,0 ,'' ,'' ,60 ,34 ,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' ,0 ,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);