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);
