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