INSERT INTO `providers`(`id`,`name` ,`tech`,`login`,`password`,`server_ip`,`port`,`priority`,`quality`,`tariff_id`,`cut_a`,`cut_b`,`device_id`,`terminator_id`, `user_id`) VALUES ( 2 , 'provider_id_2','SIP' ,'pro2' ,'aredfkjh','0.2.0.0' ,'5060', 1 , 1 , 1 , 0 , 0 , 8 , 1 , 0 ), ( 3 , 'provider_id_3','SIP' ,'pro3' ,'trytbrsh','0.0.2.0' ,'5060', 1 , 1 , 1 , 0 , 0 , 9 , 1 , 0 ), ( 4 , 'provider_id_4','SIP' ,'pro4' ,'oikjuhhy','0.0.0.2' ,'5060', 1 , 1 , 1 , 0 , 0 , 10 , 2 , 0 ), ( 5 , 'provider_id_5','SIP' ,'pro5' ,'iuhynbtr','0.4.0.0' ,'5060', 1 , 1 , 1 , 0 , 0 , 11 , 2 , 0 ), ( 6 , 'provider_id_6','SIP' ,'pro6' ,'jmnfdtet','5.0.0.0' ,'5060', 1 , 1 , 1 , 0 , 0 , 12 , 3 , 0 ), ( 7 , 'provider_id_7','SIP' ,'pro7' ,'iuhyyutr','0.6.0.0' ,'5060', 1 , 1 , 1 , 0 , 0 , 13 , 3 , 0 ), ( 8 , 'provider_id_8','SIP' ,'pro8' ,'jmnyutet','0.0.7.0' ,'5060', 1 , 1 , 1 , 0 , 0 , 14 , 3 , 0 ); INSERT INTO `terminators`(`id`,`name`,`user_id`) VALUES (1,'terminator_id_1',0), (2,'terminator_id_2',0), (3,'terminator_id_3',0); 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`,`real_duration`, `real_billsec`,`provider_id`,`prefix`) VALUES # outgoing 2009-01-01 (1119 ,'2009-01-01 00:00:01','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,10 ,20 ,'ANSWERED' ,0 ,'2' ,'1232113370.3','' ,5 ,0 ,0 ,0 ,0 ,0 ,0 ,2 ,'370'), (110 ,'2009-01-01 00:00:02','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,20 ,30 ,'ANSWERED' ,0 ,'2' ,'1232113371.3','' ,6 ,0 ,0 ,0 ,0 ,0 ,0 ,3 ,'370'), (111 ,'2009-01-01 00:00:03','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,30 ,40 ,'ANSWERED' ,0 ,'2' ,'1232113372.3','' ,7 ,0 ,0 ,0 ,0 ,0 ,0 ,4 ,'370'), (112 ,'2009-01-01 00:00:04','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113373.3','' ,2 ,0 ,0 ,0 ,0 ,0 ,0 ,5 ,'370'), # incoming 2009-01-02 # call to admins device (113 ,'2009-01-02 00:00:01','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,10 ,20 ,'ANSWERED' ,0 ,'2' ,'1232113374.3','' ,1 ,5 ,0 ,1 ,0 ,0 ,0 ,6 ,'370'), # call to users device (114 ,'2009-01-02 00:00:02','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,20 ,30 ,'ANSWERED' ,0 ,'2' ,'1232113375.3','' ,1 ,4 ,0 ,1 ,0 ,0 ,0 ,7 ,'370'), # call to resellers device (115 ,'2009-01-02 00:00:03','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,30 ,40 ,'ANSWERED' ,0 ,'2' ,'1232113376.3','' ,1 ,6 ,0 ,1 ,0 ,0 ,0 ,8 ,'370'), # call to resellers users device (116 ,'2009-01-02 00:00:04','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113377.3','' ,1 ,7 ,0 ,1 ,0 ,0 ,0 ,2 ,'370'), # incoming 2008-01-01 by did_inc_price # call to admins device (117 ,'2008-01-01 00:00:01','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,10 ,20 ,'ANSWERED' ,0 ,'2' ,'1232113374.3','' ,5 ,0 ,0 ,0 ,0 ,0 ,0 ,3 ,'370'), # call to users device (118 ,'2008-01-01 00:00:02','37046246362' ,'37046246362','35563042438','' ,'' ,'' ,'' ,'' ,20 ,30 ,'ANSWERED' ,0 ,'2' ,'1232113375.3','' ,4 ,0 ,0 ,0 ,0 ,0 ,0 ,4 ,'355'), # call to resellers device (119 ,'2008-01-01 00:00:03','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,30 ,40 ,'ANSWERED' ,0 ,'2' ,'1232113376.3','' ,6 ,0 ,0 ,0 ,0 ,0 ,0 ,5 ,'370'), # call to resellers users device (120 ,'2008-01-01 00:00:04','37046246362' ,'37046246362','9363042438','' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113377.3','' ,7 ,0 ,0 ,0 ,0 ,0 ,0 ,6 ,'93'), # incoming 2007-01-02 # call to users device for clid test (121 ,'2007-01-02 00:00:02','"Test"<37046246362>','37046246362','37063042438','' ,'' ,'' ,'' ,'' ,20 ,30 ,'ANSWERED' ,0 ,'2' ,'1232113375.3','' ,1 ,4 ,0 ,1 ,0 ,0 ,0 ,7 ,'370'), (122 ,'2010-02-18 00:00:01','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,40 ,50 ,'BUSY' ,0 ,'2' ,'1232113377.3','' ,2 ,0 ,0 ,0 ,0 ,0 ,0 ,8 ,'370'), (123 ,'2008-01-01 00:00:04','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113377.3','' ,2 ,0 ,0 ,0 ,0 ,0 ,0 ,2 ,'370'), (124 ,'2010-02-18 00:00:01','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,40 ,50 ,'BUSY' ,0 ,'2' ,'1232113377.3','' ,7 ,0 ,0 ,0 ,0 ,0 ,88 ,3 ,'370'), (125 ,'2010-02-18 00:00:01','37046246362' ,'37046246362','37063042438','' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113377.3','' ,7 ,0 ,0 ,0 ,0 ,0 ,0 ,4 ,'370'), (126 ,'2010-03-17 00:00:01','37046246362' ,'37046246362','35563042438','' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113377.3','' ,7 ,0 ,0 ,0 ,0 ,0 ,0 ,5 ,'355'), # cards calls (127 ,'2010-03-17 00:00:01','37046246362' ,'37046246362','9363042438','' ,'' ,'' ,'' ,'' ,40 ,50 ,'ANSWERED' ,0 ,'2' ,'1232113377.3','' ,7 ,0 ,0 ,0 ,22 ,0 ,0 ,6 ,'93'), # dst whit # (128 ,'2010-06-22 00:00:01','' ,'101' ,'123#123' ,'' ,'' ,'' ,'' ,'' ,20 ,30 ,'ANSWERED' ,0 ,'2' ,'1232113371.3','' ,6 ,0 ,0 ,0 ,0 ,0 ,0 ,7 ,'370');