-- phpMyAdmin SQL Dump -- version 2.8.2.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 06, 2007 at 01:07 AM -- Server version: 4.1.20 -- PHP Version: 4.3.11 -- -- Database: `mya2billing` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_autorefill_report` -- CREATE TABLE `cc_autorefill_report` ( `id` bigint(20) NOT NULL auto_increment, `daterun` timestamp NOT NULL default '0000-00-00 00:00:00', `totalcardperform` int(11) default NULL, `totalcredit` decimal(15,5) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_autorefill_report` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_backup` -- CREATE TABLE `cc_backup` ( `id` bigint(20) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `path` varchar(255) NOT NULL default '', `creationdate` timestamp NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `cons_cc_backup_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_backup` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_call` -- CREATE TABLE `cc_call` ( `id` bigint(20) NOT NULL auto_increment, `sessionid` char(40) NOT NULL default '', `uniqueid` char(30) NOT NULL default '', `username` char(40) NOT NULL default '', `nasipaddress` char(30) default NULL, `starttime` timestamp NOT NULL default '0000-00-00 00:00:00', `stoptime` timestamp NOT NULL default '0000-00-00 00:00:00', `sessiontime` int(11) default NULL, `calledstation` char(30) default NULL, `startdelay` int(11) default NULL, `stopdelay` int(11) default NULL, `terminatecause` char(20) default NULL, `usertariff` char(20) default NULL, `calledprovider` char(20) default NULL, `calledcountry` char(30) default NULL, `calledsub` char(20) default NULL, `calledrate` float default NULL, `sessionbill` float default NULL, `destination` char(40) default NULL, `id_tariffgroup` int(11) default NULL, `id_tariffplan` int(11) default NULL, `id_ratecard` int(11) default NULL, `id_trunk` int(11) default NULL, `sipiax` int(11) default '0', `src` char(40) default NULL, `id_did` int(11) default NULL, `buyrate` decimal(15,5) default '0.00000', `buycost` decimal(15,5) default '0.00000', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ; -- -- Dumping data for table `cc_call` -- INSERT INTO `cc_call` (`id`, `sessionid`, `uniqueid`, `username`, `nasipaddress`, `starttime`, `stoptime`, `sessiontime`, `calledstation`, `startdelay`, `stopdelay`, `terminatecause`, `usertariff`, `calledprovider`, `calledcountry`, `calledsub`, `calledrate`, `sessionbill`, `destination`, `id_tariffgroup`, `id_tariffplan`, `id_ratecard`, `id_trunk`, `sipiax`, `src`, `id_did`, `buyrate`, `buycost`) VALUES (1, 'IAX2/vpcall-6', '1175456572.32', '8197587131', '', '2007-04-01 15:43:51', '2007-04-01 15:44:01', 10, '14044225753', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.05, 0.05, 'default', 1, 1, 1, 2, 0, '4049694508', NULL, 0.02000, 0.00333), (2, 'IAX2/boxA-user-3', '1175538396.57', '3803639308', '', '2007-04-02 14:27:35', '2007-04-02 14:27:35', 0, '01151195565269', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.15, -0, 'International', 1, 1, 2, 2, 0, '827', NULL, 0.10000, 0.00000), (3, 'IAX2/boxA-user-1', '1175538508.59', '1165949135', '', '2007-04-02 14:29:17', '2007-04-02 14:29:29', 12, '0115112758861', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.15, 0.15, 'International', 1, 1, 2, 2, 0, '827', NULL, 0.10000, 0.02000), (4, 'IAX2/boxA-user-1', '1175542043.61', '5953335645', '', '2007-04-02 15:28:07', '2007-04-02 15:28:07', 0, '01151195565269', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.15, -0, 'International', 1, 1, 2, 2, 0, '827', NULL, 0.10000, 0.00000), (5, 'IAX2/boxA-user-3', '1175542799.66', '3803639308', '', '2007-04-02 15:40:39', '2007-04-02 15:40:39', 0, '01151195565269', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.15, -0, 'International', 1, 1, 2, 2, 0, '827', NULL, 0.10000, 0.00000), (6, 'IAX2/boxA-user-4', '1175543207.69', '5953335645', '', '2007-04-02 15:47:31', '2007-04-02 15:47:31', 0, '01151195565269', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.15, -0, 'International', 1, 1, 2, 2, 0, '827', NULL, 0.10000, 0.00000), (7, 'IAX2/boxA-user-3', '2175544004.75', '4330908678', '', '2007-04-02 16:01:01', '2007-04-02 16:01:01', 0, '0115117061948', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.063, -0, 'Peru - Lima Fijos', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.00000), (8, 'IAX2/boxA-user-1', '1175544308.77', '4330908678', '', '2007-04-02 16:06:08', '2007-04-02 16:06:08', 0, '0115117061948', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.063, -0, 'Peru - Lima Fijos', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.00000), (9, 'IAX2/boxA-user-4', '1176746164.243', '3803639308', '', '2007-04-16 13:56:54', '2007-04-16 13:56:54', 0, '01151195565269', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.32, -0, 'International', 1, 1, 2, 2, 0, '827', NULL, 0.28500, 0.00000), (10, 'IAX2/boxA-user-1', '1176746628.247', '3803639308', '', '2007-04-16 14:04:22', '2007-04-16 14:04:22', 0, '01151195565269', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.32, -0, 'International', 1, 1, 2, 2, 0, '827', NULL, 0.28500, 0.00000), (11, 'IAX2/boxA-user-6', '1176780033.251', '3803639308', '', '2007-04-16 23:21:10', '2007-04-16 23:21:10', 0, '01151195565269', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.35, -0, 'Peru - Celular-9', 1, 1, 2, 2, 0, '827', NULL, 0.28500, 0.00000), (12, 'IAX2/boxA-user-1', '1176780119.253', '3803639308', '', '2007-04-16 23:22:32', '2007-04-16 23:22:32', 0, '01151195565269', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.35, -0, 'Peru - Celular-9', 1, 1, 2, 2, 0, '827', NULL, 0.28500, 0.00000), (13, 'IAX2/boxA-user-3', '1176918915.272', '3803639308', '', '2007-04-18 13:56:03', '2007-04-18 13:56:03', 0, '01151195565269', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.35, -0, 'Peru - Celular-9', 1, 1, 2, 2, 0, '827', NULL, 0.28500, 0.00000), (14, 'IAX2/boxA-user-3', '1177199691.316', '0503898228', '', '2007-04-21 19:55:54', '2007-04-21 19:55:54', 0, '01151197924315', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.35, -0, 'Peru - Celular-9', 1, 1, 2, 2, 0, '827', NULL, 0.28500, 0.00000), (15, 'IAX2/boxA-user-2', '1177199763.318', '0503898228', '', '2007-04-21 19:57:13', '2007-04-21 19:57:27', 14, '01151197924351', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.35, 0.35, 'Peru - Celular-9', 1, 1, 2, 2, 0, '827', NULL, 0.28500, 0.06650), (16, 'IAX2/boxA-user-4', '1177200007.321', '0503898228', '', '2007-04-21 20:00:53', '2007-04-21 20:00:57', 4, '01151198074334', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.35, 0.35, 'Peru - Celular-9', 1, 1, 2, 2, 0, '827', NULL, 0.28500, 0.01900), (17, 'IAX2/boxA-user-2', '1177200059.323', '0503898228', '', '2007-04-21 20:01:56', '2007-04-21 20:04:35', 159, '01151198074334', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.35, 0.9275, 'Peru - Celular-9', 1, 1, 2, 2, 0, '827', NULL, 0.28500, 0.75525), (18, 'IAX2/boxa-peer-3', '1177200368.325', '0503898228', '', '2007-04-21 20:07:05', '2007-04-21 20:11:18', 253, '0115112634169', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.2952, 'Peru - Lima', 1, 1, 4, 2, 0, '602', NULL, 0.02600, 0.10963), (19, 'IAX2/boxA-user-6', '1177200919.327', '0503898228', '', '2007-04-21 20:16:09', '2007-04-21 20:22:02', 353, '0115112634169', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.4118, 'Peru - Lima', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.15296), (20, 'IAX2/boxa-peer-6', '1177201401.330', '0503898228', '', '2007-04-21 20:24:05', '2007-04-21 20:27:33', 208, '0115112634169', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.2427, 'Peru - Lima', 1, 1, 4, 2, 0, '602', NULL, 0.02600, 0.09013), (21, 'IAX2/boxa-peer-7', '2177201707.333', '0503898228', '', '2007-04-21 20:29:26', '2007-04-21 20:32:06', 160, '0115112634169', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.1867, 'Peru - Lima', 1, 1, 4, 2, 0, '530', NULL, 0.02600, 0.06933), (22, 'IAX2/boxa-peer-6', '1177202020.335', '0503898228', '', '2007-04-21 20:34:20', '2007-04-21 21:39:41', 3921, '0115112634169', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 4.5745, 'Peru - Lima', 1, 1, 4, 2, 0, '550', NULL, 0.02600, 1.69910), (23, 'IAX2/boxA-user-3', '1177205842.337', '3803639308', '', '2007-04-21 21:38:48', '2007-04-21 21:40:19', 91, '0115117061948', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.1062, 'Peru - Lima', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.03943), (24, 'IAX2/boxa-peer-1', '1177206341.339', '0503898228', '', '2007-04-21 21:46:17', '2007-04-21 22:13:18', 1621, '0115112634169', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 1.8912, 'Peru - Lima', 1, 1, 4, 2, 0, '550', NULL, 0.02600, 0.70243), (25, 'IAX2/boxA-user-2', '1177258950.343', '0503898228', '', '2007-04-22 12:23:41', '2007-04-22 12:23:41', 0, '01151196946792', NULL, NULL, 'NOANSWER', NULL, NULL, '', '', 0.35, -0, 'Peru - Celular-9', 1, 1, 2, 2, 0, '827', NULL, 0.28500, 0.00000), (26, 'IAX2/boxA-user-4', '1177271560.349', '3803639308', '', '2007-04-22 15:53:16', '2007-04-22 15:53:57', 41, '0115112758861', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.07, 'Peru - Lima', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.01776), (27, 'IAX2/boxA-user-5', '1177867376.414', '3803639308', '', '2007-04-29 13:23:49', '2007-04-29 13:25:22', 93, '0115113452231', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.1085, 'Peru - Lima', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.04030), (28, 'IAX2/boxA-user-4', '1177895792.417', '3803639308', '', '2007-04-29 21:17:23', '2007-04-29 21:18:15', 52, '0115112754004', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.07, 'Peru - Lima', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.02253), (29, 'IAX2/boxA-user-1', '1178211142.479', '1846899949', '', '2007-05-03 12:53:14', '2007-05-03 12:53:14', 0, '0115112870284', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.07, -0, 'Peru - Lima', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.00000), (30, 'IAX2/boxA-user-4', '1178211208.481', '1846899949', '', '2007-05-03 12:54:17', '2007-05-03 12:56:02', 105, '0115112758861', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.1225, 'Peru - Lima', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.04550), (31, 'IAX2/boxA-user-1', '2178390030.486', '3803639308', '', '2007-05-05 14:34:47', '2007-05-05 14:34:55', 8, '0115112758861', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.07, 'Peru - Lima', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.00346), (32, 'IAX2/boxA-user-9', '1178390149.489', '3803639308', '', '2007-05-05 14:36:21', '2007-05-05 14:36:26', 5, '0113452231', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.186, 0.186, 'España', 1, 1, 241, 2, 0, '827', NULL, 0.01900, 0.00158), (33, 'IAX2/boxA-user-4', '1178390207.491', '3803639308', '', '2007-05-05 14:37:34', '2007-05-05 14:40:23', 169, '0115113452231', NULL, NULL, 'ANSWER', NULL, NULL, '', '', 0.07, 0.1972, 'Peru - Lima', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.07323), (34, 'IAX2/boxA-user-3', '1178390513.493', '3803639308', '', '2007-05-05 14:42:29', '2007-05-05 14:42:29', 0, '0115112758861', NULL, NULL, 'CANCEL', NULL, NULL, '', '', 0.07, -0, 'Peru - Lima', 1, 1, 4, 2, 0, '827', NULL, 0.02600, 0.00000); -- -------------------------------------------------------- -- -- Table structure for table `cc_callerid` -- CREATE TABLE `cc_callerid` ( `id` bigint(20) NOT NULL auto_increment, `cid` char(100) default NULL, `id_cc_card` bigint(20) NOT NULL default '0', `activated` char(1) NOT NULL default 't', PRIMARY KEY (`id`), UNIQUE KEY `cons_cc_callerid_cid` (`cid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `cc_callerid` -- INSERT INTO `cc_callerid` (`id`, `cid`, `id_cc_card`, `activated`) VALUES (1, '601', 12, 't'); -- -------------------------------------------------------- -- -- Table structure for table `cc_campaign` -- CREATE TABLE `cc_campaign` ( `id` int(11) NOT NULL auto_increment, `campaign_name` varchar(50) NOT NULL default '', `creationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `startingdate` timestamp NOT NULL default '0000-00-00 00:00:00', `expirationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `description` mediumtext, `id_trunk` int(11) default '0', `secondusedreal` int(11) default '0', `nb_callmade` int(11) default '0', `enable` int(11) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `cons_cc_campaign_campaign_name` (`campaign_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_campaign` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_card` -- CREATE TABLE `cc_card` ( `id` bigint(20) NOT NULL auto_increment, `creationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `firstusedate` timestamp NOT NULL default '0000-00-00 00:00:00', `expirationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `enableexpire` int(11) default '0', `expiredays` int(11) default '0', `username` char(50) NOT NULL default '', `useralias` char(50) NOT NULL default '', `userpass` char(50) NOT NULL default '', `uipass` char(50) default NULL, `credit` decimal(15,5) NOT NULL default '0.00000', `tariff` int(11) default '0', `id_didgroup` int(11) default '0', `activated` char(1) NOT NULL default 'f', `lastname` char(50) default NULL, `firstname` char(50) default NULL, `address` char(100) default NULL, `city` char(40) default NULL, `state` char(40) default NULL, `country` char(40) default NULL, `zipcode` char(20) default NULL, `phone` char(20) default NULL, `email` char(70) default NULL, `fax` char(20) default NULL, `inuse` int(11) default '0', `simultaccess` int(11) default '0', `currency` char(3) default 'USD', `lastuse` timestamp NOT NULL default '0000-00-00 00:00:00', `nbused` int(11) default '0', `typepaid` int(11) default '0', `creditlimit` int(11) default '0', `voipcall` int(11) default '0', `sip_buddy` int(11) default '0', `iax_buddy` int(11) default '0', `language` char(5) default 'en', `redial` char(50) default NULL, `runservice` int(11) default '0', `nbservice` int(11) default '0', `id_campaign` int(11) default '0', `num_trials_done` bigint(20) default '0', `callback` char(50) default NULL, `vat` float NOT NULL default '0', `servicelastrun` timestamp NOT NULL default '0000-00-00 00:00:00', `initialbalance` decimal(15,5) NOT NULL default '0.00000', `invoiceday` int(11) default '1', `autorefill` int(11) default '0', `loginkey` char(40) default NULL, `activatedbyuser` char(1) NOT NULL default 't', PRIMARY KEY (`id`), UNIQUE KEY `cons_cc_card_username` (`username`), UNIQUE KEY `cons_cc_card_useralias` (`useralias`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -- Dumping data for table `cc_card` -- INSERT INTO `cc_card` (`id`, `creationdate`, `firstusedate`, `expirationdate`, `enableexpire`, `expiredays`, `username`, `useralias`, `userpass`, `uipass`, `credit`, `tariff`, `id_didgroup`, `activated`, `lastname`, `firstname`, `address`, `city`, `state`, `country`, `zipcode`, `phone`, `email`, `fax`, `inuse`, `simultaccess`, `currency`, `lastuse`, `nbused`, `typepaid`, `creditlimit`, `voipcall`, `sip_buddy`, `iax_buddy`, `language`, `redial`, `runservice`, `nbservice`, `id_campaign`, `num_trials_done`, `callback`, `vat`, `servicelastrun`, `initialbalance`, `invoiceday`, `autorefill`, `loginkey`, `activatedbyuser`) VALUES (1, '2007-04-01 15:39:59', '2007-04-21 21:40:19', '2017-04-01 15:35:41', 0, 0, '3803639308', '276280978973793', '', '6683212545', 19.19210, 1, -1, 't', 'LASTCUST', 'FirstCUST', '620 Peachtree', 'Atlanta, GA. 30308', 'GA', 'USA', '30308', '4047952515', 'admin@itaki.net', '4047952515', 19, 1, 'USD', '2007-05-05 14:40:23', 7, 0, NULL, 0, 1, 1, 'es', '0115113452231', 1, 0, -1, 0, '', 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (2, '2007-04-01 15:41:42', '2007-04-21 19:57:27', '2017-04-01 15:40:36', 0, 0, '0503898228', '698470341715427', '0503898228', '4486127987', 0.77040, 1, -1, 't', 'Vany Sheet', '', '', '', '', '', '', '', '', '', 12, 1, 'USD', '2007-04-21 22:13:18', 9, 0, NULL, 0, 1, 1, 'en', '0115112634169', 1, 0, -1, 0, '', 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (3, '2007-04-01 15:41:42', '2007-04-01 15:44:01', '2017-04-01 15:40:36', 0, 0, '8197587131', '793356370218862', '8197587131', '2827242306', 19.95000, 1, -1, 't', '1175456502', '', '', '', '', '', '', '', '', '', 1, 1, 'USD', '2007-04-01 15:44:01', 1, 0, NULL, 0, 1, 1, 'es', '14044225753', 1, 0, -1, 0, '', 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (4, '2007-04-01 15:41:42', '2007-05-03 12:56:02', '2017-04-01 15:40:36', 0, 0, '1846899949', '210271499359608', '1846899949', '9643158331', 4.87750, 1, -1, 't', 'Magaly Espinoza', '', '', '', '', '', '', '', '', '', 3, 1, 'USD', '2007-05-03 12:56:02', 1, 0, NULL, 0, 1, 1, 'en', '0115112758861', 1, 0, -1, 0, '', 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (5, '2007-04-01 15:41:42', '0000-00-00 00:00:00', '2017-04-01 15:40:36', 0, 0, '9346325598', '303450065478778', '9346325598', '9923067035', 20.00000, 1, 0, 't', '1175456502', '', '', '', '', '', '', '', '', NULL, 0, 1, 'USD', '0000-00-00 00:00:00', 0, 0, 0, 0, 1, 1, 'en', NULL, 1, 0, 0, 0, NULL, 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (6, '2007-04-01 15:41:42', '0000-00-00 00:00:00', '2017-04-01 15:40:36', 0, 0, '4036125355', '967166193875158', '4036125355', '3807125424', 20.00000, 1, 0, 't', '1175456502', '', '', '', '', '', '', '', '', NULL, 0, 1, 'USD', '0000-00-00 00:00:00', 0, 0, 0, 0, 1, 1, 'en', NULL, 1, 0, 0, 0, NULL, 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (7, '2007-04-01 15:41:42', '0000-00-00 00:00:00', '2017-04-01 15:40:36', 0, 0, '9497691349', '868289443239327', '9497691349', '8568020913', 20.00000, 1, 0, 't', '1175456502', '', '', '', '', '', '', '', '', NULL, 0, 1, 'USD', '0000-00-00 00:00:00', 0, 0, 0, 0, 1, 1, 'en', NULL, 1, 0, 0, 0, NULL, 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (8, '2007-04-01 15:41:42', '0000-00-00 00:00:00', '2017-04-01 15:40:36', 0, 0, '5761030398', '946487193773597', '5761030398', '6315633351', 20.00000, 1, 0, 't', '1175456502', '', '', '', '', '', '', '', '', NULL, 0, 1, 'USD', '0000-00-00 00:00:00', 0, 0, 0, 0, 1, 1, 'en', NULL, 1, 0, 0, 0, NULL, 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (9, '2007-04-01 15:41:42', '0000-00-00 00:00:00', '2017-04-01 15:40:36', 0, 0, '3939569763', '241826580622583', '3939569763', '9911546335', 20.00000, 1, 0, 't', '1175456502', '', '', '', '', '', '', '', '', NULL, 0, 1, 'USD', '0000-00-00 00:00:00', 0, 0, 0, 0, 1, 1, 'en', NULL, 1, 0, 0, 0, NULL, 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (10, '2007-04-01 15:41:42', '2007-04-02 14:29:29', '2017-04-01 15:40:36', 0, 0, '1165949135', '786426865078518', '1165949135', '2044660279', 19.85000, 1, 0, 't', '1175456502', '', '', '', '', '', '', '', '', NULL, 1, 1, 'USD', '2007-04-02 14:29:29', 1, 0, 0, 0, 1, 1, 'en', '0115112758861', 1, 0, 0, 0, NULL, 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (11, '2007-04-01 15:41:42', '0000-00-00 00:00:00', '2017-04-01 15:40:36', 0, 0, '7430316433', '823231761595238', '7430316433', '2414132014', 20.00000, 1, 0, 't', '1175456502', '', '', '', '', '', '', '', '', NULL, 0, 1, 'USD', '0000-00-00 00:00:00', 0, 0, 0, 0, 1, 1, 'en', NULL, 1, 0, 0, 0, NULL, 0, '0000-00-00 00:00:00', 0.00000, 1, 0, NULL, 't'), (13, '2007-04-02 15:59:31', '0000-00-00 00:00:00', '2017-04-02 15:58:30', 2, 45, '4330908678', '400471274072389', '', '9323913091', 10.00000, 1, -1, 't', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 1, 'USD', '0000-00-00 00:00:00', 0, 0, 0, 0, 1, 1, 'en', NULL, 1, 0, -1, 0, NULL, 0, '0000-00-00 00:00:00', 0.00000, 1, 1, NULL, 't'); -- -------------------------------------------------------- -- -- Table structure for table `cc_charge` -- CREATE TABLE `cc_charge` ( `id` bigint(20) NOT NULL auto_increment, `id_cc_card` bigint(20) NOT NULL default '0', `iduser` int(11) NOT NULL default '0', `creationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `amount` float NOT NULL default '0', `chargetype` int(11) default '0', `description` mediumtext, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_charge` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_country` -- CREATE TABLE `cc_country` ( `id` bigint(20) NOT NULL auto_increment, `countrycode` char(80) NOT NULL default '', `countryname` char(80) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=246 ; -- -- Dumping data for table `cc_country` -- INSERT INTO `cc_country` (`id`, `countrycode`, `countryname`) VALUES (1, 'AFG', 'Afghanistan'), (2, 'ALB', 'Albania'), (3, 'DZA', 'Algeria'), (4, 'ASM', 'American Samoa'), (5, 'AND', 'Andorra'), (6, 'AGO', 'Angola'), (7, 'AIA', 'Anguilla'), (8, 'ATA', 'Antarctica'), (9, 'ATG', 'Antigua And Barbuda'), (10, 'ARG', 'Argentina'), (11, 'ARM', 'Armenia'), (12, 'ABW', 'Aruba'), (13, 'AUS', 'Australia'), (14, 'AUT', 'Austria'), (15, 'AZE', 'Azerbaijan'), (16, 'BHS', 'Bahamas'), (17, 'BHR', 'Bahrain'), (18, 'BGD', 'Bangladesh'), (19, 'BRB', 'Barbados'), (20, 'BLR', 'Belarus'), (21, 'BEL', 'Belgium'), (22, 'BLZ', 'Belize'), (23, 'BEN', 'Benin'), (24, 'BMU', 'Bermuda'), (25, 'BTN', 'Bhutan'), (26, 'BOL', 'Bolivia'), (27, 'BIH', 'Bosnia And Herzegovina'), (28, 'BWA', 'Botswana'), (29, 'BV', 'Bouvet Island'), (30, 'BRA', 'Brazil'), (31, 'IO', 'British Indian Ocean Territory'), (32, 'BRN', 'Brunei Darussalam'), (33, 'BGR', 'Bulgaria'), (34, 'BFA', 'Burkina Faso'), (35, 'BDI', 'Burundi'), (36, 'KHM', 'Cambodia'), (37, 'CMR', 'Cameroon'), (38, 'CAN', 'Canada'), (39, 'CPV', 'Cape Verde'), (40, 'CYM', 'Cayman Islands'), (41, 'CAF', 'Central African Republic'), (42, 'TCD', 'Chad'), (43, 'CHL', 'Chile'), (44, 'CHN', 'China'), (45, 'CXR', 'Christmas Island'), (46, 'CCK', 'Cocos (Keeling) Islands'), (47, 'COL', 'Colombia'), (48, 'COM', 'Comoros'), (49, 'COG', 'Congo'), (50, 'COD', 'Congo, The Democratic Republic Of The'), (51, 'COK', 'Cook Islands'), (52, 'CRI', 'Costa Rica'), (54, 'HRV', 'Croatia'), (55, 'CUB', 'Cuba'), (56, 'CYP', 'Cyprus'), (57, 'CZE', 'Czech Republic'), (58, 'DNK', 'Denmark'), (59, 'DJI', 'Djibouti'), (60, 'DMA', 'Dominica'), (61, 'DOM', 'Dominican Republic'), (62, 'ECU', 'Ecuador'), (63, 'EGY', 'Egypt'), (64, 'SLV', 'El Salvador'), (65, 'GNQ', 'Equatorial Guinea'), (66, 'ERI', 'Eritrea'), (67, 'EST', 'Estonia'), (68, 'ETH', 'Ethiopia'), (69, 'FLK', 'Falkland Islands (Malvinas)'), (70, 'FRO', 'Faroe Islands'), (71, 'FJI', 'Fiji'), (72, 'FIN', 'Finland'), (73, 'FRA', 'France'), (74, 'GUF', 'French Guiana'), (75, 'PYF', 'French Polynesia'), (76, 'ATF', 'French Southern Territories'), (77, 'GAB', 'Gabon'), (78, 'GMB', 'Gambia'), (79, 'GEO', 'Georgia'), (80, 'DEU', 'Germany'), (81, 'GHA', 'Ghana'), (82, 'GIB', 'Gibraltar'), (83, 'GRC', 'Greece'), (84, 'GRL', 'Greenland'), (85, 'GRD', 'Grenada'), (86, 'GLP', 'Guadeloupe'), (87, 'GUM', 'Guam'), (88, 'GTM', 'Guatemala'), (89, 'GIN', 'Guinea'), (90, 'GNB', 'Guinea-Bissau'), (91, 'GUY', 'Guyana'), (92, 'HTI', 'Haiti'), (93, 'HM', 'Heard Island And McDonald Islands'), (94, 'VAT', 'Holy See (Vatican City State)'), (95, 'HND', 'Honduras'), (96, 'HKG', 'Hong Kong'), (97, 'HUN', 'Hungary'), (98, 'ISL', 'Iceland'), (99, 'IND', 'India'), (100, 'IDN', 'Indonesia'), (101, 'IRN', 'Iran, Islamic Republic Of'), (102, 'IRQ', 'Iraq'), (103, 'IRL', 'Ireland'), (104, 'ISR', 'Israel'), (105, 'ITA', 'Italy'), (106, 'JAM', 'Jamaica'), (107, 'JPN', 'Japan'), (108, 'JOR', 'Jordan'), (109, 'KAZ', 'Kazakhstan'), (110, 'KEN', 'Kenya'), (111, 'KIR', 'Kiribati'), (112, 'PRK', 'Korea, Democratic People''s Republic Of'), (113, 'KOR', 'Korea, Republic of'), (114, 'KWT', 'Kuwait'), (115, 'KGZ', 'Kyrgyzstan'), (116, 'LAO', 'Lao People''s Democratic Republic'), (117, 'LVA', 'Latvia'), (118, 'LBN', 'Lebanon'), (119, 'LSO', 'Lesotho'), (120, 'LBR', 'Liberia'), (121, 'LBY', 'Libyan Arab Jamahiriya'), (122, 'LIE', 'Liechtenstein'), (123, 'LTU', 'Lithuania'), (124, 'LUX', 'Luxembourg'), (125, 'MAC', 'Macao'), (126, 'MKD', 'Macedonia, The Former Yugoslav Republic Of'), (127, 'MDG', 'Madagascar'), (128, 'MWI', 'Malawi'), (129, 'MYS', 'Malaysia'), (130, 'MDV', 'Maldives'), (131, 'MLI', 'Mali'), (132, 'MLT', 'Malta'), (133, 'MHL', 'Marshall islands'), (134, 'MTQ', 'Martinique'), (135, 'MRT', 'Mauritania'), (136, 'MUS', 'Mauritius'), (137, 'MYT', 'Mayotte'), (138, 'MEX', 'Mexico'), (139, 'FSM', 'Micronesia, Federated States Of'), (140, 'MDA', 'Moldova, Republic Of'), (141, 'MCO', 'Monaco'), (142, 'MNG', 'Mongolia'), (143, 'MSR', 'Montserrat'), (144, 'MAR', 'Morocco'), (145, 'MOZ', 'Mozambique'), (146, 'MMR', 'Myanmar'), (147, 'NAM', 'Namibia'), (148, 'NRU', 'Nauru'), (149, 'NPL', 'Nepal'), (150, 'NLD', 'Netherlands'), (151, 'ANT', 'Netherlands Antilles'), (152, 'NCL', 'New Caledonia'), (153, 'NZL', 'New Zealand'), (154, 'NIC', 'Nicaragua'), (155, 'NER', 'Niger'), (156, 'NGA', 'Nigeria'), (157, 'NIU', 'Niue'), (158, 'NFK', 'Norfolk Island'), (159, 'MNP', 'Northern Mariana Islands'), (160, 'NOR', 'Norway'), (161, 'OMN', 'Oman'), (162, 'PAK', 'Pakistan'), (163, 'PLW', 'Palau'), (164, 'PSE', 'Palestinian Territory, Occupied'), (165, 'PAN', 'Panama'), (166, 'PNG', 'Papua New Guinea'), (167, 'PRY', 'Paraguay'), (168, 'PER', 'Peru'), (169, 'PHL', 'Philippines'), (170, 'PN', 'Pitcairn'), (171, 'POL', 'Poland'), (172, 'PRT', 'Portugal'), (173, 'PRI', 'Puerto Rico'), (174, 'QAT', 'Qatar'), (175, 'REU', 'Reunion'), (176, 'ROU', 'Romania'), (177, 'RUS', 'Russian Federation'), (178, 'RWA', 'Rwanda'), (179, 'SHN', 'Saint Helena'), (180, 'KNA', 'Saint Kitts And Nevis'), (181, 'LCA', 'Saint Lucia'), (182, 'SPM', 'Saint Pierre And Miquelon'), (183, 'VCT', 'Saint Vincent And The Grenadines'), (184, 'WSM', 'Samoa'), (185, 'SMR', 'San Marino'), (186, 'STP', 'Sao Tome And Principe'), (187, 'SAU', 'Saudi Arabia'), (188, 'SEN', 'Senegal'), (189, 'SYC', 'Seychelles'), (190, 'SLE', 'Sierra Leone'), (191, 'SGP', 'Singapore'), (192, 'SVK', 'Slovakia'), (193, 'SVN', 'Slovenia'), (194, 'SLB', 'Solomon Islands'), (195, 'SOM', 'Somalia'), (196, 'ZAF', 'South Africa'), (197, 'GS', 'South Georgia And The South Sandwich Islands'), (198, 'ESP', 'Spain'), (199, 'LKA', 'Sri Lanka'), (200, 'SDN', 'Sudan'), (201, 'SUR', 'Suriname'), (202, 'SJ', 'Svalbard and Jan Mayen'), (203, 'SWZ', 'Swaziland'), (204, 'SWE', 'Sweden'), (205, 'CHE', 'Switzerland'), (206, 'SYR', 'Syrian Arab Republic'), (207, 'TWN', 'Taiwan, Province Of China'), (208, 'TJK', 'Tajikistan'), (209, 'TZA', 'Tanzania, United Republic Of'), (210, 'THA', 'Thailand'), (211, 'TL', 'Timor L''Este'), (212, 'TGO', 'Togo'), (213, 'TKL', 'Tokelau'), (214, 'TON', 'Tonga'), (215, 'TTO', 'Trinidad And Tobago'), (216, 'TUN', 'Tunisia'), (217, 'TUR', 'Turkey'), (218, 'TKM', 'Turkmenistan'), (219, 'TCA', 'Turks And Caicos Islands'), (220, 'TUV', 'Tuvalu'), (221, 'UGA', 'Uganda'), (222, 'UKR', 'Ukraine'), (223, 'ARE', 'United Arab Emirates'), (224, 'GBR', 'United Kingdom'), (225, 'USA', 'United States'), (226, 'UM', 'United States Minor Outlying Islands'), (227, 'URY', 'Uruguay'), (228, 'UZB', 'Uzbekistan'), (229, 'VUT', 'Vanuatu'), (230, 'VEN', 'Venezuela'), (231, 'VNM', 'Vietnam'), (232, 'VGB', 'Virgin Islands, British'), (233, 'VIR', 'Virgin Islands, U.S.'), (234, 'WLF', 'Wallis And Futuna'), (235, 'EH', 'Western Sahara'), (236, 'YEM', 'Yemen'), (237, 'YUG', 'Yugoslavia'), (238, 'ZMB', 'Zambia'), (239, 'ZWE', 'Zimbabwe'), (240, 'ASC', 'Ascension Island'), (241, 'DGA', 'Diego Garcia'), (242, 'XNM', 'Inmarsat'), (243, 'TMP', 'East timor'), (244, 'AK', 'Alaska'), (245, 'HI', 'Hawaii'), (53, 'CIV', 'Cote d''Ivoire'); -- -------------------------------------------------------- -- -- Table structure for table `cc_currencies` -- CREATE TABLE `cc_currencies` ( `id` smallint(5) unsigned NOT NULL auto_increment, `currency` char(3) NOT NULL default '', `name` varchar(30) NOT NULL default '', `value` float(7,5) unsigned NOT NULL default '0.00000', `lastupdate` timestamp NOT NULL default '0000-00-00 00:00:00', `basecurrency` char(3) NOT NULL default 'USD', PRIMARY KEY (`id`), UNIQUE KEY `cons_cc_currencies_currency` (`currency`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=150 ; -- -- Dumping data for table `cc_currencies` -- INSERT INTO `cc_currencies` (`id`, `currency`, `name`, `value`, `lastupdate`, `basecurrency`) VALUES (1, 'ALL', 'Albanian Lek (ALL)', 0.00974, '0000-00-00 00:00:00', 'USD'), (2, 'DZD', 'Algerian Dinar (DZD)', 0.01345, '0000-00-00 00:00:00', 'USD'), (3, 'XAL', 'Aluminium Ounces (XAL)', 1.08295, '0000-00-00 00:00:00', 'USD'), (4, 'ARS', 'Argentine Peso (ARS)', 0.32455, '0000-00-00 00:00:00', 'USD'), (5, 'AWG', 'Aruba Florin (AWG)', 0.55866, '0000-00-00 00:00:00', 'USD'), (6, 'AUD', 'Australian Dollar (AUD)', 0.73384, '0000-00-00 00:00:00', 'USD'), (7, 'BSD', 'Bahamian Dollar (BSD)', 1.00000, '0000-00-00 00:00:00', 'USD'), (8, 'BHD', 'Bahraini Dinar (BHD)', 2.65322, '0000-00-00 00:00:00', 'USD'), (9, 'BDT', 'Bangladesh Taka (BDT)', 0.01467, '0000-00-00 00:00:00', 'USD'), (10, 'BBD', 'Barbados Dollar (BBD)', 0.50000, '0000-00-00 00:00:00', 'USD'), (11, 'BYR', 'Belarus Ruble (BYR)', 0.00046, '0000-00-00 00:00:00', 'USD'), (12, 'BZD', 'Belize Dollar (BZD)', 0.50569, '0000-00-00 00:00:00', 'USD'), (13, 'BMD', 'Bermuda Dollar (BMD)', 1.00000, '0000-00-00 00:00:00', 'USD'), (14, 'BTN', 'Bhutan Ngultrum (BTN)', 0.02186, '0000-00-00 00:00:00', 'USD'), (15, 'BOB', 'Bolivian Boliviano (BOB)', 0.12500, '0000-00-00 00:00:00', 'USD'), (16, 'BRL', 'Brazilian Real (BRL)', 0.46030, '0000-00-00 00:00:00', 'USD'), (17, 'GBP', 'British Pound (GBP)', 1.73702, '0000-00-00 00:00:00', 'USD'), (18, 'BND', 'Brunei Dollar (BND)', 0.61290, '0000-00-00 00:00:00', 'USD'), (19, 'BGN', 'Bulgarian Lev (BGN)', 0.60927, '0000-00-00 00:00:00', 'USD'), (20, 'BIF', 'Burundi Franc (BIF)', 0.00103, '0000-00-00 00:00:00', 'USD'), (21, 'KHR', 'Cambodia Riel (KHR)', 0.00000, '0000-00-00 00:00:00', 'USD'), (22, 'CAD', 'Canadian Dollar (CAD)', 0.86386, '0000-00-00 00:00:00', 'USD'), (23, 'KYD', 'Cayman Islands Dollar (KYD)', 1.16496, '0000-00-00 00:00:00', 'USD'), (24, 'XOF', 'CFA Franc (BCEAO) (XOF)', 0.00182, '0000-00-00 00:00:00', 'USD'), (25, 'XAF', 'CFA Franc (BEAC) (XAF)', 0.00182, '0000-00-00 00:00:00', 'USD'), (26, 'CLP', 'Chilean Peso (CLP)', 0.00187, '0000-00-00 00:00:00', 'USD'), (27, 'CNY', 'Chinese Yuan (CNY)', 0.12425, '0000-00-00 00:00:00', 'USD'), (28, 'COP', 'Colombian Peso (COP)', 0.00044, '0000-00-00 00:00:00', 'USD'), (29, 'KMF', 'Comoros Franc (KMF)', 0.00242, '0000-00-00 00:00:00', 'USD'), (30, 'XCP', 'Copper Ounces (XCP)', 2.16403, '0000-00-00 00:00:00', 'USD'), (31, 'CRC', 'Costa Rica Colon (CRC)', 0.00199, '0000-00-00 00:00:00', 'USD'), (32, 'HRK', 'Croatian Kuna (HRK)', 0.16249, '0000-00-00 00:00:00', 'USD'), (33, 'CUP', 'Cuban Peso (CUP)', 1.00000, '0000-00-00 00:00:00', 'USD'), (34, 'CYP', 'Cyprus Pound (CYP)', 2.07426, '0000-00-00 00:00:00', 'USD'), (35, 'CZK', 'Czech Koruna (CZK)', 0.04133, '0000-00-00 00:00:00', 'USD'), (36, 'DKK', 'Danish Krone (DKK)', 0.15982, '0000-00-00 00:00:00', 'USD'), (37, 'DJF', 'Dijibouti Franc (DJF)', 0.00000, '0000-00-00 00:00:00', 'USD'), (38, 'DOP', 'Dominican Peso (DOP)', 0.03035, '0000-00-00 00:00:00', 'USD'), (39, 'XCD', 'East Caribbean Dollar (XCD)', 0.37037, '0000-00-00 00:00:00', 'USD'), (40, 'ECS', 'Ecuador Sucre (ECS)', 0.00004, '0000-00-00 00:00:00', 'USD'), (41, 'EGP', 'Egyptian Pound (EGP)', 0.17433, '0000-00-00 00:00:00', 'USD'), (42, 'SVC', 'El Salvador Colon (SVC)', 0.11426, '0000-00-00 00:00:00', 'USD'), (43, 'ERN', 'Eritrea Nakfa (ERN)', 0.00000, '0000-00-00 00:00:00', 'USD'), (44, 'EEK', 'Estonian Kroon (EEK)', 0.07615, '0000-00-00 00:00:00', 'USD'), (45, 'ETB', 'Ethiopian Birr (ETB)', 0.11456, '0000-00-00 00:00:00', 'USD'), (46, 'EUR', 'Euro (EUR)', 1.19175, '0000-00-00 00:00:00', 'USD'), (47, 'FKP', 'Falkland Islands Pound (FKP)', 0.00000, '0000-00-00 00:00:00', 'USD'), (48, 'GMD', 'Gambian Dalasi (GMD)', 0.03515, '0000-00-00 00:00:00', 'USD'), (49, 'GHC', 'Ghanian Cedi (GHC)', 0.00011, '0000-00-00 00:00:00', 'USD'), (50, 'GIP', 'Gibraltar Pound (GIP)', 0.00000, '0000-00-00 00:00:00', 'USD'), (51, 'XAU', 'Gold Ounces (XAU)', 99.99999, '0000-00-00 00:00:00', 'USD'), (52, 'GTQ', 'Guatemala Quetzal (GTQ)', 0.13103, '0000-00-00 00:00:00', 'USD'), (53, 'GNF', 'Guinea Franc (GNF)', 0.00022, '0000-00-00 00:00:00', 'USD'), (54, 'HTG', 'Haiti Gourde (HTG)', 0.02387, '0000-00-00 00:00:00', 'USD'), (55, 'HNL', 'Honduras Lempira (HNL)', 0.05292, '0000-00-00 00:00:00', 'USD'), (56, 'HKD', 'Hong Kong Dollar (HKD)', 0.12884, '0000-00-00 00:00:00', 'USD'), (57, 'HUF', 'Hungarian Forint (HUF)', 0.00461, '0000-00-00 00:00:00', 'USD'), (58, 'ISK', 'Iceland Krona (ISK)', 0.01436, '0000-00-00 00:00:00', 'USD'), (59, 'INR', 'Indian Rupee (INR)', 0.02253, '0000-00-00 00:00:00', 'USD'), (60, 'IDR', 'Indonesian Rupiah (IDR)', 0.00011, '0000-00-00 00:00:00', 'USD'), (61, 'IRR', 'Iran Rial (IRR)', 0.00011, '0000-00-00 00:00:00', 'USD'), (62, 'ILS', 'Israeli Shekel (ILS)', 0.21192, '0000-00-00 00:00:00', 'USD'), (63, 'JMD', 'Jamaican Dollar (JMD)', 0.01536, '0000-00-00 00:00:00', 'USD'), (64, 'JPY', 'Japanese Yen (JPY)', 0.00849, '0000-00-00 00:00:00', 'USD'), (65, 'JOD', 'Jordanian Dinar (JOD)', 1.41044, '0000-00-00 00:00:00', 'USD'), (66, 'KZT', 'Kazakhstan Tenge (KZT)', 0.00773, '0000-00-00 00:00:00', 'USD'), (67, 'KES', 'Kenyan Shilling (KES)', 0.01392, '0000-00-00 00:00:00', 'USD'), (68, 'KRW', 'Korean Won (KRW)', 0.00102, '0000-00-00 00:00:00', 'USD'), (69, 'KWD', 'Kuwaiti Dinar (KWD)', 3.42349, '0000-00-00 00:00:00', 'USD'), (70, 'LAK', 'Lao Kip (LAK)', 0.00000, '0000-00-00 00:00:00', 'USD'), (71, 'LVL', 'Latvian Lat (LVL)', 1.71233, '0000-00-00 00:00:00', 'USD'), (72, 'LBP', 'Lebanese Pound (LBP)', 0.00067, '0000-00-00 00:00:00', 'USD'), (73, 'LSL', 'Lesotho Loti (LSL)', 0.15817, '0000-00-00 00:00:00', 'USD'), (74, 'LYD', 'Libyan Dinar (LYD)', 0.00000, '0000-00-00 00:00:00', 'USD'), (75, 'LTL', 'Lithuanian Lita (LTL)', 0.34510, '0000-00-00 00:00:00', 'USD'), (76, 'MOP', 'Macau Pataca (MOP)', 0.12509, '0000-00-00 00:00:00', 'USD'), (77, 'MKD', 'Macedonian Denar (MKD)', 0.01945, '0000-00-00 00:00:00', 'USD'), (78, 'MGF', 'Malagasy Franc (MGF)', 0.00011, '0000-00-00 00:00:00', 'USD'), (79, 'MWK', 'Malawi Kwacha (MWK)', 0.00752, '0000-00-00 00:00:00', 'USD'), (80, 'MYR', 'Malaysian Ringgit (MYR)', 0.26889, '0000-00-00 00:00:00', 'USD'), (81, 'MVR', 'Maldives Rufiyaa (MVR)', 0.07813, '0000-00-00 00:00:00', 'USD'), (82, 'MTL', 'Maltese Lira (MTL)', 2.77546, '0000-00-00 00:00:00', 'USD'), (83, 'MRO', 'Mauritania Ougulya (MRO)', 0.00369, '0000-00-00 00:00:00', 'USD'), (84, 'MUR', 'Mauritius Rupee (MUR)', 0.03258, '0000-00-00 00:00:00', 'USD'), (85, 'MXN', 'Mexican Peso (MXN)', 0.09320, '0000-00-00 00:00:00', 'USD'), (86, 'MDL', 'Moldovan Leu (MDL)', 0.07678, '0000-00-00 00:00:00', 'USD'), (87, 'MNT', 'Mongolian Tugrik (MNT)', 0.00084, '0000-00-00 00:00:00', 'USD'), (88, 'MAD', 'Moroccan Dirham (MAD)', 0.10897, '0000-00-00 00:00:00', 'USD'), (89, 'MZM', 'Mozambique Metical (MZM)', 0.00004, '0000-00-00 00:00:00', 'USD'), (90, 'NAD', 'Namibian Dollar (NAD)', 0.15817, '0000-00-00 00:00:00', 'USD'), (91, 'NPR', 'Nepalese Rupee (NPR)', 0.01408, '0000-00-00 00:00:00', 'USD'), (92, 'ANG', 'Neth Antilles Guilder (ANG)', 0.55866, '0000-00-00 00:00:00', 'USD'), (93, 'TRY', 'New Turkish Lira (TRY)', 0.73621, '0000-00-00 00:00:00', 'USD'), (94, 'NZD', 'New Zealand Dollar (NZD)', 0.65096, '0000-00-00 00:00:00', 'USD'), (95, 'NIO', 'Nicaragua Cordoba (NIO)', 0.05828, '0000-00-00 00:00:00', 'USD'), (96, 'NGN', 'Nigerian Naira (NGN)', 0.00777, '0000-00-00 00:00:00', 'USD'), (97, 'NOK', 'Norwegian Krone (NOK)', 0.14867, '0000-00-00 00:00:00', 'USD'), (98, 'OMR', 'Omani Rial (OMR)', 2.59740, '0000-00-00 00:00:00', 'USD'), (99, 'XPF', 'Pacific Franc (XPF)', 0.00999, '0000-00-00 00:00:00', 'USD'), (100, 'PKR', 'Pakistani Rupee (PKR)', 0.01667, '0000-00-00 00:00:00', 'USD'), (101, 'XPD', 'Palladium Ounces (XPD)', 99.99999, '0000-00-00 00:00:00', 'USD'), (102, 'PAB', 'Panama Balboa (PAB)', 1.00000, '0000-00-00 00:00:00', 'USD'), (103, 'PGK', 'Papua New Guinea Kina (PGK)', 0.33125, '0000-00-00 00:00:00', 'USD'), (104, 'PYG', 'Paraguayan Guarani (PYG)', 0.00017, '0000-00-00 00:00:00', 'USD'), (105, 'PEN', 'Peruvian Nuevo Sol (PEN)', 0.29999, '0000-00-00 00:00:00', 'USD'), (106, 'PHP', 'Philippine Peso (PHP)', 0.01945, '0000-00-00 00:00:00', 'USD'), (107, 'XPT', 'Platinum Ounces (XPT)', 99.99999, '0000-00-00 00:00:00', 'USD'), (108, 'PLN', 'Polish Zloty (PLN)', 0.30574, '0000-00-00 00:00:00', 'USD'), (109, 'QAR', 'Qatar Rial (QAR)', 0.27476, '0000-00-00 00:00:00', 'USD'), (110, 'ROL', 'Romanian Leu (ROL)', 0.00000, '0000-00-00 00:00:00', 'USD'), (111, 'RON', 'Romanian New Leu (RON)', 0.34074, '0000-00-00 00:00:00', 'USD'), (112, 'RUB', 'Russian Rouble (RUB)', 0.03563, '0000-00-00 00:00:00', 'USD'), (113, 'RWF', 'Rwanda Franc (RWF)', 0.00185, '0000-00-00 00:00:00', 'USD'), (114, 'WST', 'Samoa Tala (WST)', 0.35492, '0000-00-00 00:00:00', 'USD'), (115, 'STD', 'Sao Tome Dobra (STD)', 0.00000, '0000-00-00 00:00:00', 'USD'), (116, 'SAR', 'Saudi Arabian Riyal (SAR)', 0.26665, '0000-00-00 00:00:00', 'USD'), (117, 'SCR', 'Seychelles Rupee (SCR)', 0.18114, '0000-00-00 00:00:00', 'USD'), (118, 'SLL', 'Sierra Leone Leone (SLL)', 0.00034, '0000-00-00 00:00:00', 'USD'), (119, 'XAG', 'Silver Ounces (XAG)', 9.77517, '0000-00-00 00:00:00', 'USD'), (120, 'SGD', 'Singapore Dollar (SGD)', 0.61290, '0000-00-00 00:00:00', 'USD'), (121, 'SKK', 'Slovak Koruna (SKK)', 0.03157, '0000-00-00 00:00:00', 'USD'), (122, 'SIT', 'Slovenian Tolar (SIT)', 0.00498, '0000-00-00 00:00:00', 'USD'), (123, 'SOS', 'Somali Shilling (SOS)', 0.00000, '0000-00-00 00:00:00', 'USD'), (124, 'ZAR', 'South African Rand (ZAR)', 0.15835, '0000-00-00 00:00:00', 'USD'), (125, 'LKR', 'Sri Lanka Rupee (LKR)', 0.00974, '0000-00-00 00:00:00', 'USD'), (126, 'SHP', 'St Helena Pound (SHP)', 0.00000, '0000-00-00 00:00:00', 'USD'), (127, 'SDD', 'Sudanese Dinar (SDD)', 0.00427, '0000-00-00 00:00:00', 'USD'), (128, 'SRG', 'Surinam Guilder (SRG)', 0.36496, '0000-00-00 00:00:00', 'USD'), (129, 'SZL', 'Swaziland Lilageni (SZL)', 0.15817, '0000-00-00 00:00:00', 'USD'), (130, 'SEK', 'Swedish Krona (SEK)', 0.12609, '0000-00-00 00:00:00', 'USD'), (131, 'CHF', 'Swiss Franc (CHF)', 0.76435, '0000-00-00 00:00:00', 'USD'), (132, 'SYP', 'Syrian Pound (SYP)', 0.00000, '0000-00-00 00:00:00', 'USD'), (133, 'TWD', 'Taiwan Dollar (TWD)', 0.03075, '0000-00-00 00:00:00', 'USD'), (134, 'TZS', 'Tanzanian Shilling (TZS)', 0.00083, '0000-00-00 00:00:00', 'USD'), (135, 'THB', 'Thai Baht (THB)', 0.02546, '0000-00-00 00:00:00', 'USD'), (136, 'TOP', 'Tonga Paanga (TOP)', 0.48244, '0000-00-00 00:00:00', 'USD'), (137, 'TTD', 'Trinidad&Tobago Dollar (TTD)', 0.15863, '0000-00-00 00:00:00', 'USD'), (138, 'TND', 'Tunisian Dinar (TND)', 0.73470, '0000-00-00 00:00:00', 'USD'), (139, 'USD', 'U.S. Dollar (USD)', 1.00000, '0000-00-00 00:00:00', 'USD'), (140, 'AED', 'UAE Dirham (AED)', 0.27228, '0000-00-00 00:00:00', 'USD'), (141, 'UGX', 'Ugandan Shilling (UGX)', 0.00055, '0000-00-00 00:00:00', 'USD'), (142, 'UAH', 'Ukraine Hryvnia (UAH)', 0.19755, '0000-00-00 00:00:00', 'USD'), (143, 'UYU', 'Uruguayan New Peso (UYU)', 0.04119, '0000-00-00 00:00:00', 'USD'), (144, 'VUV', 'Vanuatu Vatu (VUV)', 0.00870, '0000-00-00 00:00:00', 'USD'), (145, 'VEB', 'Venezuelan Bolivar (VEB)', 0.00037, '0000-00-00 00:00:00', 'USD'), (146, 'VND', 'Vietnam Dong (VND)', 0.00006, '0000-00-00 00:00:00', 'USD'), (147, 'YER', 'Yemen Riyal (YER)', 0.00510, '0000-00-00 00:00:00', 'USD'), (148, 'ZMK', 'Zambian Kwacha (ZMK)', 0.00031, '0000-00-00 00:00:00', 'USD'), (149, 'ZWD', 'Zimbabwe Dollar (ZWD)', 0.00001, '0000-00-00 00:00:00', 'USD'); -- -------------------------------------------------------- -- -- Table structure for table `cc_did` -- CREATE TABLE `cc_did` ( `id` bigint(20) NOT NULL auto_increment, `id_cc_didgroup` bigint(20) NOT NULL default '0', `id_cc_country` int(11) NOT NULL default '0', `activated` int(11) NOT NULL default '1', `iduser` int(11) NOT NULL default '0', `did` varchar(50) NOT NULL default '', `creationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `startingdate` timestamp NOT NULL default '0000-00-00 00:00:00', `expirationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `description` mediumtext, `secondusedreal` int(11) default '0', `billingtype` int(11) default '0', `fixrate` float NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `cons_cc_did_did` (`did`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_did` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_did_destination` -- CREATE TABLE `cc_did_destination` ( `id` bigint(20) NOT NULL auto_increment, `destination` char(50) NOT NULL default '', `priority` int(11) NOT NULL default '0', `id_cc_card` bigint(20) NOT NULL default '0', `id_cc_did` bigint(20) NOT NULL default '0', `creationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `activated` int(11) NOT NULL default '1', `secondusedreal` int(11) default '0', `voip_call` int(11) default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_did_destination` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_didgroup` -- CREATE TABLE `cc_didgroup` ( `id` bigint(20) NOT NULL auto_increment, `idreseller` int(11) NOT NULL default '0', `didgroupname` char(50) NOT NULL default '', `creationdate` timestamp NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_didgroup` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_ecommerce_product` -- CREATE TABLE `cc_ecommerce_product` ( `id` bigint(20) NOT NULL auto_increment, `product_name` varchar(255) NOT NULL default '', `creationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `description` mediumtext, `expirationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `enableexpire` int(11) default '0', `expiredays` int(11) default '0', `mailtype` varchar(50) NOT NULL default '', `credit` float NOT NULL default '0', `tariff` int(11) default '0', `id_didgroup` int(11) default '0', `activated` char(1) NOT NULL default 'f', `simultaccess` int(11) default '0', `currency` char(3) default 'USD', `typepaid` int(11) default '0', `creditlimit` int(11) default '0', `language` varchar(5) default 'en', `runservice` int(11) default '0', `sip_friend` int(11) default '0', `iax_friend` int(11) default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_ecommerce_product` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_iax_buddies` -- CREATE TABLE `cc_iax_buddies` ( `id` int(11) NOT NULL auto_increment, `name` char(80) NOT NULL default '', `accountcode` char(20) default NULL, `regexten` char(20) default NULL, `amaflags` char(7) default NULL, `callgroup` char(10) default NULL, `callerid` char(80) default NULL, `canreinvite` char(3) default 'yes', `context` char(80) default NULL, `defaultip` char(15) default NULL, `dtmfmode` char(7) NOT NULL default 'RFC2833', `fromuser` char(80) default NULL, `fromdomain` char(80) default NULL, `host` char(31) NOT NULL default '', `insecure` char(4) default NULL, `language` char(2) default NULL, `mailbox` char(50) default NULL, `md5secret` char(80) default NULL, `nat` char(3) default 'yes', `permit` char(95) default NULL, `deny` char(95) default NULL, `mask` char(95) default NULL, `pickupgroup` char(10) default NULL, `port` char(5) NOT NULL default '', `qualify` char(3) default 'yes', `restrictcid` char(1) default NULL, `rtptimeout` char(3) default NULL, `rtpholdtimeout` char(3) default NULL, `secret` char(80) default NULL, `type` char(6) NOT NULL default 'friend', `username` char(80) NOT NULL default '', `disallow` char(100) default 'all', `allow` char(100) default 'gsm,ulaw,alaw', `musiconhold` char(100) default NULL, `regseconds` int(11) NOT NULL default '0', `ipaddr` char(15) NOT NULL default '', `cancallforward` char(3) default 'yes', PRIMARY KEY (`id`), UNIQUE KEY `cons_cc_iax_buddies_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -- Dumping data for table `cc_iax_buddies` -- INSERT INTO `cc_iax_buddies` (`id`, `name`, `accountcode`, `regexten`, `amaflags`, `callgroup`, `callerid`, `canreinvite`, `context`, `defaultip`, `dtmfmode`, `fromuser`, `fromdomain`, `host`, `insecure`, `language`, `mailbox`, `md5secret`, `nat`, `permit`, `deny`, `mask`, `pickupgroup`, `port`, `qualify`, `restrictcid`, `rtptimeout`, `rtpholdtimeout`, `secret`, `type`, `username`, `disallow`, `allow`, `musiconhold`, `regseconds`, `ipaddr`, `cancallforward`) VALUES (1, '3803639308', '3803639308', '3803639308', 'billing', NULL, '276280978973793', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '6683212545', 'friend', '3803639308', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (2, '0503898228', '0503898228', '0503898228', 'billing', NULL, '0503898228', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '4486127987', 'friend', '0503898228', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (3, '8197587131', '8197587131', '8197587131', 'billing', NULL, '8197587131', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '2827242306', 'friend', '8197587131', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (4, '1846899949', '1846899949', '1846899949', 'billing', NULL, '1846899949', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '9643158331', 'friend', '1846899949', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (5, '9346325598', '9346325598', '9346325598', 'billing', NULL, '9346325598', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '9923067035', 'friend', '9346325598', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (6, '4036125355', '4036125355', '4036125355', 'billing', NULL, '4036125355', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '3807125424', 'friend', '4036125355', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (7, '9497691349', '9497691349', '9497691349', 'billing', NULL, '9497691349', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '8568020913', 'friend', '9497691349', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (8, '5761030398', '5761030398', '5761030398', 'billing', NULL, '5761030398', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '6315633351', 'friend', '5761030398', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (9, '3939569763', '3939569763', '3939569763', 'billing', NULL, '3939569763', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '9911546335', 'friend', '3939569763', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (10, '1165949135', '1165949135', '1165949135', 'billing', NULL, '1165949135', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '2044660279', 'friend', '1165949135', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (11, '7430316433', '7430316433', '7430316433', 'billing', NULL, '7430316433', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '2414132014', 'friend', '7430316433', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (12, '5953335645', '5953335645', '5953335645', 'billing', NULL, '472963258434608', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '6995678105', 'friend', '5953335645', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'), (13, '4330908678', '4330908678', '4330908678', 'billing', NULL, '400471274072389', 'yes', 'a2billing', NULL, 'RFC2833', NULL, NULL, 'dynamic', NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, '', 'yes', NULL, NULL, NULL, '9323913091', 'friend', '4330908678', 'all', 'g729,ulaw,alaw,gsm', NULL, 0, '', 'yes'); -- -------------------------------------------------------- -- -- Table structure for table `cc_logpayment` -- CREATE TABLE `cc_logpayment` ( `id` int(11) NOT NULL auto_increment, `date` timestamp NOT NULL default '0000-00-00 00:00:00', `payment` float NOT NULL default '0', `card_id` bigint(20) NOT NULL default '0', `reseller_id` bigint(20) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_logpayment` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_logrefill` -- CREATE TABLE `cc_logrefill` ( `id` int(11) NOT NULL auto_increment, `date` timestamp NOT NULL default '0000-00-00 00:00:00', `credit` float NOT NULL default '0', `card_id` bigint(20) NOT NULL default '0', `reseller_id` bigint(20) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_logrefill` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_paypal` -- CREATE TABLE `cc_paypal` ( `id` int(11) NOT NULL auto_increment, `payer_id` varchar(60) default NULL, `payment_date` varchar(50) default NULL, `txn_id` varchar(50) default NULL, `first_name` varchar(50) default NULL, `last_name` varchar(50) default NULL, `payer_email` varchar(75) default NULL, `payer_status` varchar(50) default NULL, `payment_type` varchar(50) default NULL, `memo` tinytext, `item_name` varchar(127) default NULL, `item_number` varchar(127) default NULL, `quantity` int(11) NOT NULL default '0', `mc_gross` decimal(9,2) default NULL, `mc_fee` decimal(9,2) default NULL, `tax` decimal(9,2) default NULL, `mc_currency` char(3) default NULL, `address_name` varchar(255) NOT NULL default '', `address_street` varchar(255) NOT NULL default '', `address_city` varchar(255) NOT NULL default '', `address_state` varchar(255) NOT NULL default '', `address_zip` varchar(255) NOT NULL default '', `address_country` varchar(255) NOT NULL default '', `address_status` varchar(255) NOT NULL default '', `payer_business_name` varchar(255) NOT NULL default '', `payment_status` varchar(255) NOT NULL default '', `pending_reason` varchar(255) NOT NULL default '', `reason_code` varchar(255) NOT NULL default '', `txn_type` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `txn_id` (`txn_id`), KEY `txn_id_2` (`txn_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_paypal` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_phonelist` -- CREATE TABLE `cc_phonelist` ( `id` int(11) NOT NULL auto_increment, `id_cc_campaign` int(11) NOT NULL default '0', `id_cc_card` int(11) NOT NULL default '0', `numbertodial` varchar(50) NOT NULL default '', `name` varchar(60) NOT NULL default '', `inuse` int(11) default '0', `enable` int(11) NOT NULL default '1', `num_trials_done` int(11) default '0', `creationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `last_attempt` timestamp NOT NULL default '0000-00-00 00:00:00', `secondusedreal` int(11) default '0', `additionalinfo` mediumtext, PRIMARY KEY (`id`), KEY `ind_cc_phonelist_numbertodial` (`numbertodial`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `cc_phonelist` -- -- -------------------------------------------------------- -- -- Table structure for table `cc_provider` -- CREATE TABLE `cc_provider` ( `id` int(11) NOT NULL auto_increment, `provider_name` varchar(30) NOT NULL default '', `creationdate` timestamp NOT NULL default '0000-00-00 00:00:00', `description` mediumtext, PRIMARY KEY (`id`), UNIQUE KEY `cons_cc_provider_provider_name` (`provider_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `cc_provider` -- INSERT INTO `cc_provider` (`id`, `provider_name`, `creationdate`, `description`) VALUES (1, 'bvoice', '2007-04-01 15:03:40', 'bvoice Trunk'), (2, 'VoicePulse1', '2007-04-01 15:09:31', 'VoicePulse1 Trunk'); -- -------------------------------------------------------- -- -- Table structure for table `cc_ratecard` -- CREATE TABLE `cc_ratecard` ( `id` int(11) NOT NULL auto_increment, `idtariffplan` int(11) NOT NULL default '0', `dialprefix` char(30) NOT NULL default '', `destination` char(50) NOT NULL default '', `buyrate` float NOT NULL default '0', `buyrateinitblock` int(11) NOT NULL default '0', `buyrateincrement` int(11) NOT NULL default '0', `rateinitial` float NOT NULL default '0', `initblock` int(11) NOT NULL default '0', `billingblock` int(11) NOT NULL default '0', `connectcharge` float NOT NULL default '0', `disconnectcharge` float NOT NULL default '0', `stepchargea` float NOT NULL default '0', `chargea` float NOT NULL default '0', `timechargea` int(11) NOT NULL default '0', `billingblocka` int(11) NOT NULL default '0', `stepchargeb` float NOT NULL default '0', `chargeb` float NOT NULL default '0', `timechargeb` int(11) NOT NULL default '0', `billingblockb` int(11) NOT NULL default '0', `stepchargec` float NOT NULL default '0', `chargec` float NOT NULL default '0', `timechargec` int(11) NOT NULL default '0', `billingblockc` int(11) NOT NULL default '0', `startdate` timestamp NOT NULL default '0000-00-00 00:00:00', `stopdate` timestamp NOT NULL default '0000-00-00 00:00:00', `starttime` smallint(5) unsigned default '0', `endtime` smallint(5) unsigned default '10079', `id_trunk` int(11) default '-1', `musiconhold` char(100) NOT NULL default '', PRIMARY KEY (`id`), KEY `ind_cc_ratecard_dialprefix` (`dialprefix`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=580 ; -- -- Dumping data for table `cc_ratecard` -- INSERT INTO `cc_ratecard` (`id`, `idtariffplan`, `dialprefix`, `destination`, `buyrate`, `buyrateinitblock`, `buyrateincrement`, `rateinitial`, `initblock`, `billingblock`, `connectcharge`, `disconnectcharge`, `stepchargea`, `chargea`, `timechargea`, `billingblocka`, `stepchargeb`, `chargeb`, `timechargeb`, `billingblockb`, `stepchargec`, `chargec`, `timechargec`, `billingblockc`, `startdate`, `stopdate`, `starttime`, `endtime`, `id_trunk`, `musiconhold`) VALUES (60, 1, '0114917', 'Alemania - Celular', 0.222, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:51:44', '2017-04-16 17:51:44', 0, 10079, 2, ''), (2, 1, '0115119', 'Peru - Celular-9', 0.285, 0, 0, 0.35, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-01 15:28:31', '2017-04-01 15:28:31', 0, 10079, 2, ''), (3, 1, '0115118', 'Peru - Celular-8', 0.285, 0, 0, 0.35, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-02 15:32:51', '2017-04-02 15:32:51', 0, 10079, 2, ''), (4, 1, '011511', 'Peru - Lima', 0.026, 0, 0, 0.07, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-02 15:52:30', '2017-04-02 15:52:30', 0, 10079, 2, ''), (5, 1, '0115141', 'Peru - Amazonas', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:18:35', '2017-04-16 14:18:35', 0, 10079, 2, ''), (6, 1, '0115143', 'Peru - Ancash', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:41:13', '2017-04-16 14:41:13', 0, 10079, 2, ''), (7, 1, '01151', 'Peru - Apurimac', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:45:11', '2017-04-16 14:45:11', 0, 10079, 2, ''), (8, 1, '0115154', 'Peru - Arequipa', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:47:20', '2017-04-16 14:47:20', 0, 10079, 2, ''), (9, 1, '0115166', 'Peru - Ayacucho', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:48:12', '2017-04-16 14:48:12', 0, 10079, 2, ''), (10, 1, '0115176', 'Peru - Cajamarca', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:49:23', '2017-04-16 14:49:23', 0, 10079, 2, ''), (11, 1, '0115184', 'Peru - Cusco', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:51:45', '2017-04-16 14:51:45', 0, 10079, 2, ''), (12, 1, '0115167', 'Peru - Huancavelica', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:53:09', '2017-04-16 14:53:09', 0, 10079, 2, ''), (13, 1, '0115162', 'Peru - Huanuco', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:55:06', '2017-04-16 14:55:06', 0, 10079, 2, ''), (14, 1, '0115156', 'Peru - Ica', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:56:18', '2017-04-16 14:56:18', 0, 10079, 2, ''), (15, 1, '0115164', 'Peru - Junin', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:57:16', '2017-04-16 14:57:16', 0, 10079, 2, ''), (16, 1, '0115144', 'Peru - La Libertad', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:58:40', '2017-04-16 14:58:40', 0, 10079, 2, ''), (17, 1, '0115174', 'Peru - Lambayeque', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 14:59:45', '2017-04-16 14:59:45', 0, 10079, 2, ''), (18, 1, '0115165', 'Peru - Loreto', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:03:18', '2017-04-16 15:03:18', 0, 10079, 2, ''), (19, 1, '0115182', 'Peru - Madre de Dios', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:04:21', '2017-04-16 15:04:21', 0, 10079, 2, ''), (20, 1, '0115153', 'Peru - Moquegua', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:05:16', '2017-04-16 15:05:16', 0, 10079, 2, ''), (21, 1, '0115163', 'Peru - Pasco', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:06:34', '2017-04-16 15:06:34', 0, 10079, 2, ''), (22, 1, '0115173', 'Peru - Piura', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:07:24', '2017-04-16 15:07:24', 0, 10079, 2, ''), (23, 1, '0115151', 'Peru - Puno', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:08:48', '2017-04-16 15:08:48', 0, 10079, 2, ''), (24, 1, '0115142', 'Peru - San Martin', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:10:03', '2017-04-16 15:10:03', 0, 10079, 2, ''), (25, 1, '0115152', 'Peru - Tacna', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:11:31', '2017-04-16 15:11:31', 0, 10079, 2, ''), (26, 1, '0115172', 'Peru - Tumbes', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:12:38', '2017-04-16 15:12:38', 0, 10079, 2, ''), (27, 1, '0115161', 'Peru - Ucayali', 0.053, 0, 0, 0.123, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:14:30', '2017-04-16 15:14:30', 0, 10079, 2, ''), (110, 1, '0111246', 'Barbados', 0.241, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 14:45:06', '2017-04-17 14:45:06', 0, 10079, 2, ''), (29, 1, '01151160', 'Peru - Rural-1', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:24:11', '2017-04-16 15:24:11', 0, 10079, 2, ''), (30, 1, '01151418', 'Peru - Rural-2', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:33:44', '2017-04-16 15:33:44', 0, 10079, 2, ''), (31, 1, '01151428', 'Peru - Rural-3', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:35:35', '2017-04-16 15:35:35', 0, 10079, 2, ''), (32, 1, '01151438', 'Peru - Rural-4', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:36:50', '2017-04-16 15:36:50', 0, 10079, 2, ''), (33, 1, '01151448', 'Peru - Rural-5', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 15:38:13', '2017-04-16 15:38:13', 0, 10079, 2, ''), (34, 1, '01151518', 'Peru - Rural-6', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 16:45:16', '2017-04-16 16:45:16', 0, 10079, 2, ''), (35, 1, '01151528', 'Peru - Rural-7', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 16:46:57', '2017-04-16 16:46:57', 0, 10079, 2, ''), (36, 1, '01151538', 'Peru - Rural-8', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 16:54:14', '2017-04-16 16:54:14', 0, 10079, 2, ''), (37, 1, '01151548', 'Peru - Rural-9', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 16:55:50', '2017-04-16 16:55:50', 0, 10079, 2, ''), (38, 1, '01151568', 'Peru - Rural-10', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 16:56:54', '2017-04-16 16:56:54', 0, 10079, 2, ''), (39, 1, '01151618', 'Peru - Rural-11', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 16:59:00', '2017-04-16 16:59:00', 0, 10079, 2, ''), (40, 1, '01151628', 'Peru - Rural-12', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:00:27', '2017-04-16 17:00:27', 0, 10079, 2, ''), (41, 1, '01151638', 'Peru - Rural-13', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:01:41', '2017-04-16 17:01:41', 0, 10079, 2, ''), (42, 1, '01151648', 'Peru - Rural-14', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:02:37', '2017-04-16 17:02:37', 0, 10079, 2, ''), (43, 1, '01151658', 'Peru - Rural-15', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:06:37', '2017-04-16 17:06:37', 0, 10079, 2, ''), (44, 1, '01151668', 'Peru - Rural-16', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:08:10', '2017-04-16 17:08:10', 0, 10079, 2, ''), (45, 1, '01151678', 'Peru - Rural-17', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:09:04', '2017-04-16 17:09:04', 0, 10079, 2, ''), (46, 1, '01151728', 'Peru - Rural-18', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:10:19', '2017-04-16 17:10:19', 0, 10079, 2, ''), (47, 1, '01151738', 'Peru - Rural-19', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:12:14', '2017-04-16 17:12:14', 0, 10079, 2, ''), (48, 1, '01151748', 'Peru - Rural-20', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:13:03', '2017-04-16 17:13:03', 0, 10079, 2, ''), (49, 1, '01151768', 'Peru - Rural-21', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:14:22', '2017-04-16 17:14:22', 0, 10079, 2, ''), (50, 1, '01151828', 'Peru - Rural-22', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:15:19', '2017-04-16 17:15:19', 0, 10079, 2, ''), (51, 1, '01151838', 'Peru - Rural-23', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:16:49', '2017-04-16 17:16:49', 0, 10079, 2, ''), (52, 1, '01151848', 'Peru - Rural-24', 0.08, 0, 0, 0.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:17:45', '2017-04-16 17:17:45', 0, 10079, 2, ''), (53, 1, '01193', 'Afghanistan', 0.321, 0, 0, 0.621, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:20:05', '2017-04-16 17:20:05', 0, 10079, 2, ''), (54, 1, '0119370', 'Afghanistan - Celular', 0.321, 0, 0, 0.621, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:24:19', '2017-04-16 17:24:19', 0, 10079, 2, ''), (55, 1, '011355', 'Albania', 0.118, 0, 0, 0.31, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:27:31', '2017-04-16 17:27:31', 0, 10079, 2, ''), (56, 1, '01135568', 'Albania - Celular', 0.22, 0, 0, 0.465, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:41:45', '2017-04-16 17:41:45', 0, 10079, 2, ''), (57, 1, '0113554', 'Albania - Tirania', 0.075, 0, 0, 0.465, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:43:31', '2017-04-16 17:43:31', 0, 10079, 2, ''), (58, 1, '01149', 'Alemania', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:45:15', '2017-04-16 17:45:15', 0, 10079, 2, ''), (59, 1, '0114969', 'Alemania - Frankfurt', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 17:48:18', '2017-04-16 17:48:18', 0, 10079, 2, ''), (61, 1, '01149155', 'Albania - Celular-Eplus', 0.222, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 18:00:23', '2017-04-16 18:00:23', 0, 10079, 2, ''), (62, 1, '0114940', 'Alemania - Hamburgo', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 18:06:22', '2017-04-16 18:06:22', 0, 10079, 2, ''), (63, 1, '011213', 'Algeria', 0.153, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 18:08:00', '2017-04-16 18:08:00', 0, 10079, 2, ''), (64, 1, '0112136', 'Algeria - Celular', 0.183, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 18:10:46', '2017-04-16 18:10:46', 0, 10079, 2, ''), (65, 1, '0112137', 'Algeria - Celular Orascom', 0.183, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 18:13:53', '2017-04-16 18:13:53', 0, 10079, 2, ''), (66, 1, '01121350', 'Algeria - Celular Wataniya', 0.183, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 19:04:00', '2017-04-16 19:04:00', 0, 10079, 2, ''), (67, 1, '011376', 'Andorra', 0.05, 0, 0, 0.23, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 19:09:28', '2017-04-16 19:09:28', 0, 10079, 2, ''), (68, 1, '0113763', 'Andorra - Celular', 0.271, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 19:12:26', '2017-04-16 19:12:26', 0, 10079, 2, ''), (69, 1, '011244', 'Angola', 0.162, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 19:15:24', '2017-04-16 19:15:24', 0, 10079, 2, ''), (70, 1, '0112449', 'Angola - Celular', 0.243, 0, 0, 0.465, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 19:19:14', '2017-04-16 19:19:14', 0, 10079, 2, ''), (71, 1, '1264', 'Angila', 0.198, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 19:20:47', '2017-04-16 19:20:47', 0, 10079, 2, ''), (72, 1, '1264235', 'Angila - Celular', 0.198, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 20:10:22', '2017-04-16 20:10:22', 0, 10079, 2, ''), (73, 1, '011672', 'Antarctica', 10, 0, 0, 12, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 20:16:59', '2017-04-16 20:16:59', 0, 10079, 2, ''), (74, 1, '1268', 'Antigua y Barbuda', 0.161, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 20:25:05', '2017-04-16 20:25:05', 0, 10079, 2, ''), (75, 1, '1268404', 'Antigua y Barbuda - Celular', 0.157, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 20:52:46', '2017-04-16 20:52:46', 0, 10079, 2, ''), (76, 1, '011966', 'Arabia Sudita', 0.299, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 20:54:35', '2017-04-16 20:54:35', 0, 10079, 2, ''), (77, 1, '0119665', 'Arabia Sudita - Celular', 0.299, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 20:58:24', '2017-04-16 20:58:24', 0, 10079, 2, ''), (78, 1, '01154', 'Argentina', 0.026, 0, 0, 0.21, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 21:08:06', '2017-04-16 21:08:06', 0, 10079, 2, ''), (79, 1, '0115411', 'Argentina - Buenos Aires', 0.019, 0, 0, 0.124, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 21:16:30', '2017-04-16 21:16:30', 0, 10079, 2, ''), (80, 1, '011549', 'Argentina - Celular', 0.168, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 21:32:24', '2017-04-16 21:32:24', 0, 10079, 2, ''), (81, 1, '01154351', 'Argentina - Cordova', 0.079, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 21:36:34', '2017-04-16 21:36:34', 0, 10079, 2, ''), (82, 1, '01154291', 'Argentina - Local Cities', 0.079, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 21:39:32', '2017-04-16 21:39:32', 0, 10079, 2, ''), (83, 1, '01154261', 'Argentina - Mendoza', 0.079, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 21:46:39', '2017-04-16 21:46:39', 0, 10079, 2, ''), (84, 1, '01154341', 'Argentina - Rosario', 0.079, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 21:48:58', '2017-04-16 21:48:58', 0, 10079, 2, ''), (85, 1, '011374', 'Armenia', 0.1, 0, 0, 0.275, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 21:51:21', '2017-04-16 21:51:21', 0, 10079, 2, ''), (86, 1, '0113749', 'Armenia - Celular', 0.241, 0, 0, 0.55, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 21:56:35', '2017-04-16 21:56:35', 0, 10079, 2, ''), (87, 1, '0113741', 'Armenia-Yerevan', 0.053, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 22:00:42', '2017-04-16 22:00:42', 0, 10079, 2, ''), (88, 1, '011297', 'Aruba', 0.234, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 22:02:48', '2017-04-16 22:02:48', 0, 10079, 2, ''), (89, 1, '01129756', 'Aruba - Celular', 0.35, 0, 0, 0.465, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 22:11:10', '2017-04-16 22:11:10', 0, 10079, 2, ''), (90, 1, '01161', 'Australia', 0.019, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 22:25:22', '2017-04-16 22:25:22', 0, 10079, 2, ''), (91, 1, '011614', 'Australia - Celular', 0.188, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 22:29:32', '2017-04-16 22:29:32', 0, 10079, 2, ''), (92, 1, '01143', 'Austria', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 22:31:08', '2017-04-16 22:31:08', 0, 10079, 2, ''), (93, 1, '01143663', 'Austria - Celular', 0.258, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 23:42:09', '2017-04-16 23:42:09', 0, 10079, 2, ''), (94, 1, '01143699', 'Austria - Celular Connect', 0.258, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 23:45:18', '2017-04-16 23:45:18', 0, 10079, 2, ''), (95, 1, '01143676', 'Austria - Celular Max', 0.258, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 23:48:05', '2017-04-16 23:48:05', 0, 10079, 2, ''), (96, 1, '01143650', 'Austria - Celular Telering', 0.258, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 23:49:44', '2017-04-16 23:49:44', 0, 10079, 2, ''), (97, 1, '011431', 'Austria - Viena', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 23:52:11', '2017-04-16 23:52:11', 0, 10079, 2, ''), (98, 1, '011970', 'Autoridad Palestina', 0.272, 0, 0, 0.353, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-16 23:54:11', '2017-04-16 23:54:11', 0, 10079, 2, ''), (99, 1, '01197059', 'Autoridad Palestina - Celular', 0.313, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:00:11', '2017-04-17 00:00:11', 0, 10079, 2, ''), (100, 1, '011994', 'Azerbajan', 0.149, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:02:30', '2017-04-17 00:02:30', 0, 10079, 2, ''), (101, 1, '0119945', 'Azerbajan - Celular', 0.196, 0, 0, 0.4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:05:38', '2017-04-17 00:05:38', 0, 10079, 2, ''), (102, 1, '1242', 'Bahamas', 0.058, 0, 0, 0.34, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:13:58', '2017-04-17 00:13:58', 0, 10079, 2, ''), (103, 1, '011973', 'Bahrain', 0.12, 0, 0, 0.465, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:17:46', '2017-04-17 00:17:46', 0, 10079, 2, ''), (104, 1, '01197336', 'Bahrain - Celular', 0.15, 0, 0, 0.465, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:20:26', '2017-04-17 00:20:26', 0, 10079, 2, ''), (105, 1, '011880', 'Bangladesh', 0.073, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:22:16', '2017-04-17 00:22:16', 0, 10079, 2, ''), (106, 1, '0118801', 'Bangladesh - Celular', 0.095, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:28:42', '2017-04-17 00:28:42', 0, 10079, 2, ''), (107, 1, '01188031', 'Bangladesh-Chittagong', 0.036, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:32:30', '2017-04-17 00:32:30', 0, 10079, 2, ''), (108, 1, '0118802', 'Bangladesh-Dhaka', 0.045, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:34:19', '2017-04-17 00:34:19', 0, 10079, 2, ''), (109, 1, '011880821', 'Bangladesh-Syhlet', 0.045, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 00:35:23', '2017-04-17 00:35:23', 0, 10079, 2, ''), (111, 1, '011124623', 'Barbados - Celular', 0.56, 0, 0, 0.71, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 14:57:07', '2017-04-17 14:57:07', 0, 10079, 2, ''), (112, 1, '011375', 'Belarus', 0.243, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 14:58:19', '2017-04-17 14:58:19', 0, 10079, 2, ''), (113, 1, '01137529', 'Belarus - Celular', 0.254, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 15:04:12', '2017-04-17 15:04:12', 0, 10079, 2, ''), (114, 1, '011375172', 'Belarus - Minsk', 0.234, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 15:20:34', '2017-04-17 15:20:34', 0, 10079, 2, ''), (115, 1, '01132', 'Belgica', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 15:22:36', '2017-04-17 15:22:36', 0, 10079, 2, ''), (118, 1, '0113247', 'Belgica - Celular Proximus', 0.26, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 15:34:06', '2017-04-17 15:34:06', 0, 10079, 2, ''), (117, 1, '0113244', 'Belgica - Celular', 0.26, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 15:30:52', '2017-04-17 15:30:52', 0, 10079, 2, ''), (119, 1, '011501', 'Belize', 0.174, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-17 15:36:41', '2017-04-17 15:36:41', 0, 10079, 2, ''), (120, 1, '0115016', 'Belize - Celular', 0.273, 0, 0, 0.869, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 13:08:45', '2017-04-18 13:08:45', 0, 10079, 2, ''), (121, 1, '011229', 'Benin', 0.096, 0, 0, 0.745, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 13:20:10', '2017-04-18 13:20:10', 0, 10079, 2, ''), (122, 1, '0111441', 'Bermuda', 0.086, 0, 0, 0.34, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 13:25:09', '2017-04-18 13:25:09', 0, 10079, 2, ''), (123, 1, '011975', 'Bhutan', 0.173, 0, 0, 1.024, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 13:33:42', '2017-04-18 13:33:42', 0, 10079, 2, ''), (124, 1, '011591', 'Bolivia', 0.153, 0, 0, 0.2795, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 13:50:51', '2017-04-18 13:50:51', 0, 10079, 2, ''), (125, 1, '0115917', 'Bolivia - Celular', 0.13, 0, 0, 0.2795, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 14:19:45', '2017-04-18 14:19:45', 0, 10079, 2, ''), (126, 1, '01159144', 'Bolivia - Cochabamba', 0.066, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 14:21:32', '2017-04-18 14:21:32', 0, 10079, 2, ''), (127, 1, '01159122', 'Bolivia - La Paz', 0.066, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 14:23:03', '2017-04-18 14:23:03', 0, 10079, 2, ''), (128, 1, '01159133', 'Bolivia - Santa Cruz', 0.063, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 14:25:10', '2017-04-18 14:25:10', 0, 10079, 2, ''), (129, 1, '011387', 'Bosnia y Herzegovina', 0.19, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 14:26:15', '2017-04-18 14:26:15', 0, 10079, 2, ''), (130, 1, '01138761', 'Bosnia y Herzegovina - Celular', 0.275, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 14:27:37', '2017-04-18 14:27:37', 0, 10079, 2, ''), (131, 1, '011267', 'Botswana', 0.112, 0, 0, 0.621, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 14:29:13', '2017-04-18 14:29:13', 0, 10079, 2, ''), (132, 1, '01126771', 'Botswana - Celular', 0.257, 0, 0, 0.621, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 14:30:23', '2017-04-18 14:30:23', 0, 10079, 2, ''), (133, 1, '01155', 'Brazil', 0.043, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 14:32:29', '2017-04-18 14:32:29', 0, 10079, 2, ''), (134, 1, '0115591', 'Brazil - Belem', 0.053, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 14:53:49', '2017-04-18 14:53:49', 0, 10079, 2, ''), (135, 1, '0115519', 'Brazil - Campinas', 0.043, 0, 0, 0.34, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 15:12:34', '2017-04-18 15:12:34', 0, 10079, 2, ''), (136, 1, '0115531', 'Brazil - Belo Horizonte', 0.032, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 16:06:45', '2017-04-18 16:06:45', 0, 10079, 2, ''), (137, 1, '0115561', 'Brazil - Brasilia', 0.031, 0, 0, 0.34, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 16:13:49', '2017-04-18 16:13:49', 0, 10079, 2, ''), (138, 1, '01155009', 'Brazil - Celular', 0.121, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 16:23:38', '2017-04-18 16:23:38', 0, 10079, 2, ''), (139, 1, '01155218', 'Brazil - Celular (Telemar Pcs)', 0.121, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 16:26:32', '2017-04-18 16:26:32', 0, 10079, 2, ''), (140, 1, '0115541', 'Brazil - Curitiba', 0.031, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 16:29:07', '2017-04-18 16:29:07', 0, 10079, 2, ''), (141, 1, '0115585', 'Brazil - Fortaleza', 0.033, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 16:37:02', '2017-04-18 16:37:02', 0, 10079, 2, ''), (142, 1, '0115584', 'Brazil - Natal', 0.047, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 21:35:54', '2017-04-18 21:35:54', 0, 10079, 2, ''), (143, 1, '0115551', 'Brazil - Porto Allegre', 0.041, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 21:39:10', '2017-04-18 21:39:10', 0, 10079, 2, ''), (144, 1, '0115581', 'Brazil - Recife', 0.043, 0, 0, 0.34, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 21:42:20', '2017-04-18 21:42:20', 0, 10079, 2, ''), (145, 1, '0115521', 'Brazil - Rio de Janeiro', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 21:44:00', '2017-04-18 21:44:00', 0, 10079, 2, ''), (146, 1, '0115571', 'Brazil - Salvador', 0.037, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 21:48:03', '2017-04-18 21:48:03', 0, 10079, 2, ''), (147, 1, '0115511', 'Brazil - Sao Paulo', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 21:50:18', '2017-04-18 21:50:18', 0, 10079, 2, ''), (148, 1, '01155123009', 'Brazil - Sjc Local', 0.019, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 21:53:08', '2017-04-18 21:53:08', 0, 10079, 2, ''), (149, 1, '0115527', 'Brazil - Vitoria', 0.047, 0, 0, 0.34, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 21:59:11', '2017-04-18 21:59:11', 0, 10079, 2, ''), (150, 1, '011673', 'Brunei', 0.054, 0, 0, 0.6832, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:01:02', '2017-04-18 22:01:02', 0, 10079, 2, ''), (151, 1, '011359', 'Bulgaria', 0.041, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:08:25', '2017-04-18 22:08:25', 0, 10079, 2, ''), (152, 1, '01135989', 'Bulgaria - Celular', 0.303, 0, 0, 0.559, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:17:41', '2017-04-18 22:17:41', 0, 10079, 2, ''), (153, 1, '0113592', 'Bulgaria - Sofia', 0.04, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:22:00', '2017-04-18 22:22:00', 0, 10079, 2, ''), (154, 1, '011226', 'Burkina Faso', 0.308, 0, 0, 0.621, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:24:41', '2017-04-18 22:24:41', 0, 10079, 2, ''), (155, 1, '01122670', 'Burkina Faso - Celular', 0.31, 0, 0, 0.621, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:28:09', '2017-04-18 22:28:09', 0, 10079, 2, ''), (156, 1, '01195', 'Burma (Myanmar)', 1.17, 0, 0, 1.304, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:30:42', '2017-04-18 22:30:42', 0, 10079, 2, ''), (157, 1, '011257', 'Burundi', 0.089, 0, 0, 0.31, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:34:51', '2017-04-18 22:34:51', 0, 10079, 2, ''), (158, 1, '011855', 'Cambodia', 0.183, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:43:16', '2017-04-18 22:43:16', 0, 10079, 2, ''), (159, 1, '0118551', 'Cambodia - Celular', 0.183, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:44:20', '2017-04-18 22:44:20', 0, 10079, 2, ''), (160, 1, '011237', 'Camerun', 0.18, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:45:36', '2017-04-18 22:45:36', 0, 10079, 2, ''), (161, 1, '0112375', 'Camerun - Celular Mtn', 0.201, 0, 0, 1.024, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:50:25', '2017-04-18 22:50:25', 0, 10079, 2, ''), (162, 1, '0112376', 'Camerun - Celular Orange', 0.201, 0, 0, 1.024, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 22:58:47', '2017-04-18 22:58:47', 0, 10079, 2, ''), (163, 1, '204', 'Canada - Manitoba', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-18 23:00:36', '2017-04-18 23:00:36', 0, 10079, 2, ''), (164, 1, '250', 'Canada - British Colombia - Victoria', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:00:17', '2017-04-19 00:00:17', 0, 10079, 2, ''), (165, 1, '289', 'Canada - Ontario - Toronto', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:03:03', '2017-04-19 00:03:03', 0, 10079, 2, ''), (166, 1, '306', 'Canada - Saskatchewan', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:04:47', '2017-04-19 00:04:47', 0, 10079, 2, ''), (167, 1, '403', 'Canada - Alberta - Calgary', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:06:26', '2017-04-19 00:06:26', 0, 10079, 2, ''), (168, 1, '418', 'Canada - Quebec - Quebec City', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:07:58', '2017-04-19 00:07:58', 0, 10079, 2, ''), (169, 1, '450', 'Canada - Quebec - Laval', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:08:31', '2017-04-19 00:08:31', 0, 10079, 2, ''), (170, 1, '506', 'Canada - New Brunswick', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:09:05', '2017-04-19 00:09:05', 0, 10079, 2, ''), (171, 1, '514', 'Canada - Quebec - Montreal', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:10:17', '2017-04-19 00:10:17', 0, 10079, 2, ''), (172, 1, '519', 'Canada - Ontario - London', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:11:36', '2017-04-19 00:11:36', 0, 10079, 2, ''), (173, 1, '604', 'Canada - British Colombia - Vancuver', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:12:47', '2017-04-19 00:12:47', 0, 10079, 2, ''), (174, 1, '613', 'Canada - Ontario - Ottawa', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:13:51', '2017-04-19 00:13:51', 0, 10079, 2, ''), (175, 1, '705', 'Canada - Ontario - North Bay', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:15:09', '2017-04-19 00:15:09', 0, 10079, 2, ''), (176, 1, '709', 'Canada - Newfoundland', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:15:53', '2017-04-19 00:15:53', 0, 10079, 2, ''), (177, 1, '778', 'Canada - British Colombia', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:16:57', '2017-04-19 00:16:57', 0, 10079, 2, ''), (178, 1, '780', 'Canada - Alberta - Edmonton', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:17:49', '2017-04-19 00:17:49', 0, 10079, 2, ''), (179, 1, '807', 'Canada - Ontario - Thunder Bay', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:19:04', '2017-04-19 00:19:04', 0, 10079, 2, ''), (180, 1, '819', 'Canada - Quebec - Sherbrooke', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:19:48', '2017-04-19 00:19:48', 0, 10079, 2, ''), (181, 1, '867', 'Canada - Yukon', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:20:24', '2017-04-19 00:20:24', 0, 10079, 2, ''), (182, 1, '902', 'Canada - Nova Scotia/P.E.I.', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:20:56', '2017-04-19 00:20:56', 0, 10079, 2, ''), (183, 1, '905', 'Canada - Ontario - Hamilton', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:21:42', '2017-04-19 00:21:42', 0, 10079, 2, ''), (184, 1, '011238', 'Islas Cabo Verde', 0.306, 0, 0, 0.776, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:22:11', '2017-04-19 00:22:11', 0, 10079, 2, ''), (185, 1, '0112389', 'Islas Cabo Verde - Celular', 0.304, 0, 0, 0.776, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 00:32:50', '2017-04-19 00:32:50', 0, 10079, 2, ''), (186, 1, '011235', 'Chad', 0.186, 0, 0, 0.559, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 11:46:41', '2017-04-19 11:46:41', 0, 10079, 2, ''), (187, 1, '01156', 'Chile', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 11:50:38', '2017-04-19 11:50:38', 0, 10079, 2, ''), (188, 1, '011569', 'Chile - Celular', 0.196, 0, 0, 0.34, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 11:52:23', '2017-04-19 11:52:23', 0, 10079, 2, ''), (189, 1, '011562', 'Chile - Santiago', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 11:55:15', '2017-04-19 11:55:15', 0, 10079, 2, ''), (190, 1, '01186', 'China', 0.019, 0, 0, 0.155, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 11:55:43', '2017-04-19 11:55:43', 0, 10079, 2, ''), (191, 1, '0118610', 'China - Beijing', 0.019, 0, 0, 0.155, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 12:01:26', '2017-04-19 12:01:26', 0, 10079, 2, ''), (192, 1, '0118613', 'China - Celular', 0.019, 0, 0, 0.155, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 12:06:29', '2017-04-19 12:06:29', 0, 10079, 2, ''), (193, 1, '0118621', 'China - Shanghai', 0.019, 0, 0, 0.155, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 13:07:19', '2017-04-19 13:07:19', 0, 10079, 2, ''), (194, 1, '011357', 'Chipre', 0.26, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 13:10:56', '2017-04-19 13:10:56', 0, 10079, 2, ''), (195, 1, '01135799', 'Chipre - Celular', 0.28, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 13:15:06', '2017-04-19 13:15:06', 0, 10079, 2, ''), (196, 1, '011379', 'Ciudad del Vaticano', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 13:20:14', '2017-04-19 13:20:14', 0, 10079, 2, ''), (197, 1, '01157', 'Colombia', 0.072, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 13:27:45', '2017-04-19 13:27:45', 0, 10079, 2, ''), (198, 1, '0115753', 'Colombia - Barranquilla', 0.032, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 14:00:30', '2017-04-19 14:00:30', 0, 10079, 2, ''), (199, 1, '0115712', 'Colombia - Bogota', 0.031, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 14:06:02', '2017-04-19 14:06:02', 0, 10079, 2, ''), (200, 1, '0115723', 'Colombia - Cali', 0.033, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 14:08:59', '2017-04-19 14:08:59', 0, 10079, 2, ''), (201, 1, '011573', 'Colombia - Celular', 0.126, 0, 0, 0.31, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 14:36:07', '2017-04-19 14:36:07', 0, 10079, 2, ''), (202, 1, '0115742', 'Colombia - Medellin', 0.043, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 14:42:39', '2017-04-19 14:42:39', 0, 10079, 2, ''), (203, 1, '01157631', 'Colombia - Pereira', 0.053, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-19 14:46:16', '2017-04-19 14:46:16', 0, 10079, 2, ''), (204, 1, '011269', 'Comoros Mayotte Islands', 0.408, 0, 0, 0.683, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 19:40:07', '2017-04-20 19:40:07', 0, 10079, 2, ''), (205, 1, '011242', 'Congo', 0.146, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 19:42:45', '2017-04-20 19:42:45', 0, 10079, 2, ''), (206, 1, '011225', 'Costa de Marfil', 0.158, 0, 0, 1.086, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 19:54:24', '2017-04-20 19:54:24', 0, 10079, 2, ''), (207, 1, '0112252', 'Costa de Marfil - Abidjan', 0.159, 0, 0, 1.086, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 19:57:38', '2017-04-20 19:57:38', 0, 10079, 2, ''), (208, 1, '0112250', 'Costa de Marfil - Celular', 0.277, 0, 0, 1.086, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:05:19', '2017-04-20 20:05:19', 0, 10079, 2, ''), (209, 1, '011506', 'Costa Rica', 0.07, 0, 0, 0.34, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:09:02', '2017-04-20 20:09:02', 0, 10079, 2, ''), (210, 1, '0115063', 'Costa Rica - Celular', 0.072, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:10:51', '2017-04-20 20:10:51', 0, 10079, 2, ''), (211, 1, '011385', 'Croacia', 0.051, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:15:40', '2017-04-20 20:15:40', 0, 10079, 2, ''), (212, 1, '01138598', 'Croacia - Celular', 0.218, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:18:00', '2017-04-20 20:18:00', 0, 10079, 2, ''), (213, 1, '01138591', 'Croacia - Celular Vipnet', 0.218, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:19:13', '2017-04-20 20:19:13', 0, 10079, 2, ''), (214, 1, '01153', 'Cuba', 0.947, 0, 0, 1.552, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:21:04', '2017-04-20 20:21:04', 0, 10079, 2, ''), (215, 1, '0115399', 'Cuba - Guantanamo Bay', 0.836, 0, 0, 1.552, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:24:10', '2017-04-20 20:24:10', 0, 10079, 2, ''), (216, 1, '011246', 'Diego Garcia', 0.818, 0, 0, 1.086, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:25:57', '2017-04-20 20:25:57', 0, 10079, 2, ''), (217, 1, '01145', 'Dinamarca', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:41:15', '2017-04-20 20:41:15', 0, 10079, 2, ''), (218, 1, '011452', 'Dinamarca - Celular', 0.238, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:43:53', '2017-04-20 20:43:53', 0, 10079, 2, ''), (219, 1, '011253', 'Djibouti', 0.408, 0, 0, 0.745, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:46:00', '2017-04-20 20:46:00', 0, 10079, 2, ''), (220, 1, '1767', 'Dominica', 0.163, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:48:39', '2017-04-20 20:48:39', 0, 10079, 2, ''), (221, 1, '1767225', 'Dominica - Celular', 0.255, 0, 0, 0.714, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 20:51:22', '2017-04-20 20:51:22', 0, 10079, 2, ''), (222, 1, '011593', 'Ecuador', 0.138, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:01:23', '2017-04-20 21:01:23', 0, 10079, 2, ''), (223, 1, '0115939', 'Ecuador - Celular', 0.258, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:07:13', '2017-04-20 21:07:13', 0, 10079, 2, ''), (224, 1, '011593728', 'Ecuador - Cuenca', 0.132, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:10:25', '2017-04-20 21:10:25', 0, 10079, 2, ''), (225, 1, '0115934', 'Ecuador - Guayaquil', 0.129, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:16:27', '2017-04-20 21:16:27', 0, 10079, 2, ''), (226, 1, '0115932', 'Ecuador - Quito', 0.132, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:18:58', '2017-04-20 21:18:58', 0, 10079, 2, ''), (227, 1, '01120', 'Egipto', 0.202, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:20:56', '2017-04-20 21:20:56', 0, 10079, 2, ''), (228, 1, '0112012', 'Egipto - Celular', 0.172, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:21:59', '2017-04-20 21:21:59', 0, 10079, 2, ''), (229, 1, '011202', 'Egipto - El Cairo', 0.202, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:30:36', '2017-04-20 21:30:36', 0, 10079, 2, ''), (230, 1, '011503', 'El salvador', 0.105, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:31:59', '2017-04-20 21:31:59', 0, 10079, 2, ''), (231, 1, '0115038', 'El salvador - Celular', 0.129, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:34:52', '2017-04-20 21:34:52', 0, 10079, 2, ''), (232, 1, '011971', 'Emiratos Arabes Unidos', 0.242, 0, 0, 0.559, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:37:25', '2017-04-20 21:37:25', 0, 10079, 2, ''), (233, 1, '01197150', 'Emiratos Arabes Unidos - Celular', 0.246, 0, 0, 0.59, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:39:14', '2017-04-20 21:39:14', 0, 10079, 2, ''), (234, 1, '011882', 'Emsat-Thuraya', 7.52, 0, 0, 7.7, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:46:55', '2017-04-20 21:46:55', 0, 10079, 2, ''), (235, 1, '011240', 'Equatorial Guinea', 0.267, 0, 0, 1.086, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:51:35', '2017-04-20 21:51:35', 0, 10079, 2, ''), (236, 1, '011291', 'Eritrea', 0.355, 0, 0, 0.683, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:55:31', '2017-04-20 21:55:31', 0, 10079, 2, ''), (237, 1, '011421', 'Eslovaquia', 0.057, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 21:58:27', '2017-04-20 21:58:27', 0, 10079, 2, ''), (238, 1, '0114219', 'Eslovaquia - Celular', 0.233, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:03:33', '2017-04-20 22:03:33', 0, 10079, 2, ''), (239, 1, '011386', 'Eslovenia', 0.056, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:06:44', '2017-04-20 22:06:44', 0, 10079, 2, ''), (240, 1, '01138640', 'Eslovenia - Celular', 0.056, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:09:05', '2017-04-20 22:09:05', 0, 10079, 2, ''), (241, 1, '01134', 'España', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:10:48', '2017-04-20 22:10:48', 0, 10079, 2, ''), (242, 1, '011346', 'España - Celular', 0.248, 0, 0, 0.37, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:13:20', '2017-04-20 22:13:20', 0, 10079, 2, ''), (243, 1, '011372', 'Estonia', 0.03, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:17:57', '2017-04-20 22:17:57', 0, 10079, 2, ''), (244, 1, '0113725', 'Estonia - Celular', 0.336, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:21:11', '2017-04-20 22:21:11', 0, 10079, 2, ''), (245, 1, '011251', 'Etiopia', 0.336, 0, 0, 0.714, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:24:28', '2017-04-20 22:24:28', 0, 10079, 2, ''), (246, 1, '0112511', 'Etiopia - Addis Ababa', 0.355, 0, 0, 1.211, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:27:30', '2017-04-20 22:27:30', 0, 10079, 2, ''), (247, 1, '0112519', 'Etiopia - Celular', 0.355, 0, 0, 1.211, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:29:58', '2017-04-20 22:29:58', 0, 10079, 2, ''), (248, 1, '01163', 'Filipinas', 0.168, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:32:24', '2017-04-20 22:32:24', 0, 10079, 2, ''), (249, 1, '011639', 'Filipinas - Celular', 0.188, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:33:49', '2017-04-20 22:33:49', 0, 10079, 2, ''), (250, 1, '011358', 'Finlandia', 0.039, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:35:30', '2017-04-20 22:35:30', 0, 10079, 2, ''), (251, 1, '0113584', 'Finlandia - Celular', 0.22, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:40:41', '2017-04-20 22:40:41', 0, 10079, 2, ''), (252, 1, '01133', 'Francia', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:46:42', '2017-04-20 22:46:42', 0, 10079, 2, ''), (253, 1, '011336', 'Francia - Celular', 0.191, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:49:27', '2017-04-20 22:49:27', 0, 10079, 2, ''), (254, 1, '011220', 'Gambia', 0.18, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 22:51:04', '2017-04-20 22:51:04', 0, 10079, 2, ''), (255, 1, '011241', 'Gabon', 0.084, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 23:02:18', '2017-04-20 23:02:18', 0, 10079, 2, ''), (256, 1, '011233', 'Ghana', 0.111, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 23:51:04', '2017-04-20 23:51:04', 0, 10079, 2, ''), (257, 1, '01123321', 'Ghana - Accra', 0.102, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-20 23:57:04', '2017-04-20 23:57:04', 0, 10079, 2, ''), (258, 1, '01123324', 'Ghana - Celular', 0.2, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:04:39', '2017-04-21 00:04:39', 0, 10079, 2, ''), (259, 1, '011350', 'Gibraltar', 0.039, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:07:56', '2017-04-21 00:07:56', 0, 10079, 2, ''), (260, 1, '01135054', 'Gibraltar - Celular', 0.239, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:10:43', '2017-04-21 00:10:43', 0, 10079, 2, ''), (261, 1, '011995', 'Georgia', 0.07, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:12:22', '2017-04-21 00:12:22', 0, 10079, 2, ''), (262, 1, '01199577', 'Georgia - Celular', 0.169, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:14:36', '2017-04-21 00:14:36', 0, 10079, 2, ''), (263, 1, '01199532', 'Georgia - Tbilisi', 0.058, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:16:14', '2017-04-21 00:16:14', 0, 10079, 2, ''), (264, 1, '1473', 'Grenada', 0.15, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:17:44', '2017-04-21 00:17:44', 0, 10079, 2, ''), (265, 1, '1473403', 'Grenada - Celular', 0.442, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:21:29', '2017-04-21 00:21:29', 0, 10079, 2, ''), (266, 1, '01130', 'Grecia', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:24:49', '2017-04-21 00:24:49', 0, 10079, 2, ''), (267, 1, '0113021', 'Grecia - Atenas', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:25:35', '2017-04-21 00:25:35', 0, 10079, 2, ''), (268, 1, '01130693', 'Grecia - Celular', 0.212, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:26:12', '2017-04-21 00:26:12', 0, 10079, 2, ''), (269, 1, '01130699', 'Grecia - Celular Infoquest', 0.212, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:27:33', '2017-04-21 00:27:33', 0, 10079, 2, ''), (270, 1, '011299', 'Groelandia', 0.484, 0, 0, 0.745, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:28:51', '2017-04-21 00:28:51', 0, 10079, 2, ''), (271, 1, '0112994', 'Groelandia - Celular', 0.742, 0, 0, 0.745, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:30:25', '2017-04-21 00:30:25', 0, 10079, 2, ''), (272, 1, '011590', 'Guadalupe', 0.059, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:32:35', '2017-04-21 00:32:35', 0, 10079, 2, ''), (273, 1, '011590690', 'Guadalupe - Celular', 0.34, 0, 0, 0.621, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:33:38', '2017-04-21 00:33:38', 0, 10079, 2, ''), (274, 1, '1671', 'Guam', 0.019, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:34:29', '2017-04-21 00:34:29', 0, 10079, 2, ''), (275, 1, '011502', 'Guatemala', 0.128, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:35:48', '2017-04-21 00:35:48', 0, 10079, 2, ''), (276, 1, '0115025', 'Guatemala - Celular', 0.148, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:36:48', '2017-04-21 00:36:48', 0, 10079, 2, ''), (277, 1, '011594', 'Guyana Francesa', 0.121, 0, 0, 0.559, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:38:47', '2017-04-21 00:38:47', 0, 10079, 2, ''), (278, 1, '011594694', 'Guyana Francesa - Celular', 0.202, 0, 0, 0.559, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:40:08', '2017-04-21 00:40:08', 0, 10079, 2, ''), (279, 1, '011224', 'Ghinea', 0.127, 0, 0, 0.559, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:41:07', '2017-04-21 00:41:07', 0, 10079, 2, ''), (280, 1, '011245', 'Ghinea - Bissau', 0.127, 0, 0, 0.559, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:42:25', '2017-04-21 00:42:25', 0, 10079, 2, ''), (281, 1, '011592', 'Guyana', 0.333, 0, 0, 0.636, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:44:33', '2017-04-21 00:44:33', 0, 10079, 2, ''), (282, 1, '0115926', 'Guyana - Celular', 0.333, 0, 0, 1.024, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:45:35', '2017-04-21 00:45:35', 0, 10079, 2, ''), (283, 1, '011509', 'Haiti', 0.212, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:46:41', '2017-04-21 00:46:41', 0, 10079, 2, ''), (284, 1, '0115095', 'Haiti - Celular', 0.307, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:47:45', '2017-04-21 00:47:45', 0, 10079, 2, ''), (285, 1, '01150921', 'Haiti - Puerto Principe', 0.193, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:48:49', '2017-04-21 00:48:49', 0, 10079, 2, ''), (286, 1, '01131', 'Holanda', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:49:57', '2017-04-21 00:49:57', 0, 10079, 2, ''), (287, 1, '011599', 'Holanda - Antilles', 0.123, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:53:23', '2017-04-21 00:53:23', 0, 10079, 2, ''), (288, 1, '01159951', 'Holanda - Antilles Celular', 0.174, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:54:52', '2017-04-21 00:54:52', 0, 10079, 2, ''), (289, 1, '011316', 'Holanda - Celular', 0.259, 0, 0, 0.559, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:56:24', '2017-04-21 00:56:24', 0, 10079, 2, ''), (290, 1, '011504', 'Honduras', 0.288, 0, 0, 0.683, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:58:05', '2017-04-21 00:58:05', 0, 10079, 2, ''), (291, 1, '0115049', 'Honduras - Celular', 0.318, 0, 0, 0.683, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 00:59:55', '2017-04-21 00:59:55', 0, 10079, 2, ''), (292, 1, '011852', 'Hong Kong', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:01:11', '2017-04-21 01:01:11', 0, 10079, 2, ''), (293, 1, '0118526', 'Hong Kong - Celular', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:02:42', '2017-04-21 01:02:42', 0, 10079, 2, ''), (294, 1, '01136', 'Hungria', 0.026, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:05:56', '2017-04-21 01:05:56', 0, 10079, 2, ''), (295, 1, '011361', 'Hungria - Budapest', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:08:58', '2017-04-21 01:08:58', 0, 10079, 2, ''); INSERT INTO `cc_ratecard` (`id`, `idtariffplan`, `dialprefix`, `destination`, `buyrate`, `buyrateinitblock`, `buyrateincrement`, `rateinitial`, `initblock`, `billingblock`, `connectcharge`, `disconnectcharge`, `stepchargea`, `chargea`, `timechargea`, `billingblocka`, `stepchargeb`, `chargeb`, `timechargeb`, `billingblockb`, `stepchargec`, `chargec`, `timechargec`, `billingblockc`, `startdate`, `stopdate`, `starttime`, `endtime`, `id_trunk`, `musiconhold`) VALUES (296, 1, '0113620', 'Hungria - Celular', 0.235, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:11:00', '2017-04-21 01:11:00', 0, 10079, 2, ''), (297, 1, '01191', 'India', 0.133, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:15:43', '2017-04-21 01:15:43', 0, 10079, 2, ''), (298, 1, '0119179', 'India - Ahmadabad', 0.119, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:18:38', '2017-04-21 01:18:38', 0, 10079, 2, ''), (299, 1, '0119180', 'India - Bangalore', 0.119, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:20:05', '2017-04-21 01:20:05', 0, 10079, 2, ''), (300, 1, '01191265', 'India - Baroda (Vadodara)', 0.119, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:21:28', '2017-04-21 01:21:28', 0, 10079, 2, ''), (301, 1, '0119122', 'India - -Bombay (Mumbai)', 0.133, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:23:32', '2017-04-21 01:23:32', 0, 10079, 2, ''), (302, 1, '0119133', 'India - Calcutta', 0.119, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:26:27', '2017-04-21 01:26:27', 0, 10079, 2, ''), (303, 1, '0119198', 'India - Celular', 0.129, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:27:43', '2017-04-21 01:27:43', 0, 10079, 2, ''), (304, 1, '0119144', 'India - Madras', 0.133, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:28:49', '2017-04-21 01:28:49', 0, 10079, 2, ''), (305, 1, '0119111', 'India - Nueva Delhi', 0.119, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:30:13', '2017-04-21 01:30:13', 0, 10079, 2, ''), (306, 1, '01162', 'Indonesia', 0.099, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:31:19', '2017-04-21 01:31:19', 0, 10079, 2, ''), (307, 1, '011628', 'Indonesia - Celular', 0.156, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:34:16', '2017-04-21 01:34:16', 0, 10079, 2, ''), (308, 1, '0116221', 'Indonesia - Jakarta', 0.042, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:35:30', '2017-04-21 01:35:30', 0, 10079, 2, ''), (309, 1, '0116231', 'Indonesia - Surabaya', 0.042, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:36:53', '2017-04-21 01:36:53', 0, 10079, 2, ''), (310, 1, '011870', 'Inmarsat', 9.19, 0, 0, 10, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:38:21', '2017-04-21 01:38:21', 0, 10079, 2, ''), (311, 1, '011873', 'Inmarsat - Indian Ocean', 9.19, 0, 0, 10, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:40:23', '2017-04-21 01:40:23', 0, 10079, 2, ''), (312, 1, '01198', 'Iran', 0.1, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:41:33', '2017-04-21 01:41:33', 0, 10079, 2, ''), (313, 1, '011989', 'Iran - Celular', 0.146, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:43:13', '2017-04-21 01:43:13', 0, 10079, 2, ''), (314, 1, '0119821', 'Iran - Tehran', 0.044, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:44:08', '2017-04-21 01:44:08', 0, 10079, 2, ''), (315, 1, '011964', 'Irak', 0.227, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:45:13', '2017-04-21 01:45:13', 0, 10079, 2, ''), (316, 1, '011881', 'Iridium - Globastar', 3.929, 0, 0, 4, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:46:09', '2017-04-21 01:46:09', 0, 10079, 2, ''), (317, 1, '011353', 'Irlanda', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:48:39', '2017-04-21 01:48:39', 0, 10079, 2, ''), (318, 1, '01135385', 'Irlanda - Celular', 0.226, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:49:32', '2017-04-21 01:49:32', 0, 10079, 2, ''), (319, 1, '011354', 'Islandia', 0.032, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:50:26', '2017-04-21 01:50:26', 0, 10079, 2, ''), (320, 1, '0113546', 'Islandia - Celular', 0.25, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:51:45', '2017-04-21 01:51:45', 0, 10079, 2, ''), (321, 1, '011247', 'Islas Ascención', 0.84, 0, 0, 1.024, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:52:57', '2017-04-21 01:52:57', 0, 10079, 2, ''), (322, 1, '1345', 'Islas Cayman', 0.204, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:55:23', '2017-04-21 01:55:23', 0, 10079, 2, ''), (323, 1, '1345514', 'Islas Cayman-Celular Atw', 0.35, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:56:32', '2017-04-21 01:56:32', 0, 10079, 2, ''), (324, 1, '1345325', 'Islas Cayman-Celular Digicel', 0.35, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 01:58:10', '2017-04-21 01:58:10', 0, 10079, 2, ''), (325, 1, '1345916', 'Islas Cayman - Celular Otros', 0.35, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:02:30', '2017-04-21 02:02:30', 0, 10079, 2, ''), (326, 1, '011682', 'Islas Cook', 0.818, 0, 0, 1.304, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:05:00', '2017-04-21 02:05:00', 0, 10079, 2, ''), (327, 1, '011298', 'Islas Faroe', 0.199, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:06:15', '2017-04-21 02:06:15', 0, 10079, 2, ''), (328, 1, '011679', 'Islas Fiji', 0.288, 0, 0, 0.621, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:07:51', '2017-04-21 02:07:51', 0, 10079, 2, ''), (329, 1, '011500', 'Islas Malvinas', 0.71, 0, 0, 0.9, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:09:04', '2017-04-21 02:09:04', 0, 10079, 2, ''), (330, 1, '1670', 'Islas Marianas', 0.51, 0, 0, 0.683, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:11:13', '2017-04-21 02:11:13', 0, 10079, 2, ''), (331, 1, '0116723', 'Islas Norfolk', 0.54, 0, 0, 0.714, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:13:13', '2017-04-21 02:13:13', 0, 10079, 2, ''), (332, 1, '011262', 'Islas Reunion', 0.08, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:14:32', '2017-04-21 02:14:32', 0, 10079, 2, ''), (333, 1, '011262692', 'Islas Reunion - Celular', 0.315, 0, 0, 0.869, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:15:31', '2017-04-21 02:15:31', 0, 10079, 2, ''), (334, 1, '011677', 'Islas Salomon', 1.085, 0, 0, 1.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:16:42', '2017-04-21 02:16:42', 0, 10079, 2, ''), (335, 1, '011248', 'Islas Seychelles', 0.179, 0, 0, 1.18, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:18:03', '2017-04-21 02:18:03', 0, 10079, 2, ''), (336, 1, '1649', 'Islas Turkas & Caicos', 0.155, 0, 0, 0.776, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:19:53', '2017-04-21 02:19:53', 0, 10079, 2, ''), (337, 1, '1284', 'Islas Virgenes Britanicas', 0.144, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:21:35', '2017-04-21 02:21:35', 0, 10079, 2, ''), (338, 1, '011972', 'Israel', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:22:56', '2017-04-21 02:22:56', 0, 10079, 2, ''), (339, 1, '0119725', 'Israel - Celular', 0.098, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:23:51', '2017-04-21 02:23:51', 0, 10079, 2, ''), (340, 1, '0119722', 'Israel - Jerusalem', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:24:52', '2017-04-21 02:24:52', 0, 10079, 2, ''), (341, 1, '01197222', 'Israel - Autoridad Palestina', 0.243, 0, 0, 0.315, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:26:11', '2017-04-21 02:26:11', 0, 10079, 2, ''), (342, 1, '01139', 'Italia', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:27:54', '2017-04-21 02:27:54', 0, 10079, 2, ''), (343, 1, '011393', 'Italia - Celular', 0.277, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:29:09', '2017-04-21 02:29:09', 0, 10079, 2, ''), (344, 1, '1876', 'Jamaica', 0.114, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:30:17', '2017-04-21 02:30:17', 0, 10079, 2, ''), (345, 1, '1876301', 'Jamaica - Celular', 0.269, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:31:07', '2017-04-21 02:31:07', 0, 10079, 2, ''), (346, 1, '01181', 'Japon', 0.032, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:32:12', '2017-04-21 02:32:12', 0, 10079, 2, ''), (347, 1, '0118170', 'Japon - Celular', 0.168, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:33:09', '2017-04-21 02:33:09', 0, 10079, 2, ''), (348, 1, '011816', 'Japon - Osaka', 0.032, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:34:18', '2017-04-21 02:34:18', 0, 10079, 2, ''), (349, 1, '011813', 'Japon - Tokio', 0.031, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:35:27', '2017-04-21 02:35:27', 0, 10079, 2, ''), (350, 1, '011962', 'Jordania', 0.146, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:36:19', '2017-04-21 02:36:19', 0, 10079, 2, ''), (351, 1, '0119626', 'Jordania - Amman', 0.121, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:37:22', '2017-04-21 02:37:22', 0, 10079, 2, ''), (352, 1, '01196279', 'Jordania - Celular', 0.152, 0, 0, 1.024, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:38:33', '2017-04-21 02:38:33', 0, 10079, 2, ''), (353, 1, '011731', 'Kazajastan', 0.147, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 02:40:10', '2017-04-21 02:40:10', 0, 10079, 2, ''), (354, 1, '011254', 'Kenja', 0.168, 0, 0, 0.465, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 17:32:04', '2017-04-21 17:32:04', 0, 10079, 2, ''), (355, 1, '0112547', 'Kenja - Celular', 0.268, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 17:42:58', '2017-04-21 17:42:58', 0, 10079, 2, ''), (356, 1, '01125420', 'Kenja - Nairobi', 0.085, 0, 0, 0.683, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 17:46:39', '2017-04-21 17:46:39', 0, 10079, 2, ''), (357, 1, '011686', 'Kiribati', 0.753, 0, 0, 1.211, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 17:48:30', '2017-04-21 17:48:30', 0, 10079, 2, ''), (358, 1, '011850', 'Korea del Norte', 0.483, 0, 0, 1.055, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 17:50:09', '2017-04-21 17:50:09', 0, 10079, 2, ''), (359, 1, '01182', 'Korea del Sur', 0.019, 0, 0, 0.21, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 17:51:25', '2017-04-21 17:51:25', 0, 10079, 2, ''), (360, 1, '011821', 'Korea del Sur - Celular', 0.067, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 17:53:48', '2017-04-21 17:53:48', 0, 10079, 2, ''), (361, 1, '011965', 'Kuwait', 0.105, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 17:57:39', '2017-04-21 17:57:39', 0, 10079, 2, ''), (362, 1, '0119659', 'Kuwait - Celular', 0.105, 0, 0, 0.31, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:11:55', '2017-04-21 18:11:55', 0, 10079, 2, ''), (363, 1, '011996', 'Kyrgyzstan', 0.108, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:18:33', '2017-04-21 18:18:33', 0, 10079, 2, ''), (364, 1, '01199650', 'Kyrgyzstan - Celular', 0.129, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:22:09', '2017-04-21 18:22:09', 0, 10079, 2, ''), (365, 1, '011678', 'La República de Vanuatu', 0.567, 0, 0, 1.118, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:23:33', '2017-04-21 18:23:33', 0, 10079, 2, ''), (366, 1, '011856', 'Laos', 0.072, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:26:38', '2017-04-21 18:26:38', 0, 10079, 2, ''), (367, 1, '011371', 'Latvia', 0.067, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:29:28', '2017-04-21 18:29:28', 0, 10079, 2, ''), (368, 1, '0113716', 'Latvia - Celular', 0.192, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:32:48', '2017-04-21 18:32:48', 0, 10079, 2, ''), (369, 1, '011961', 'Libano', 0.134, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:41:12', '2017-04-21 18:41:12', 0, 10079, 2, ''), (370, 1, '0119613', 'Libano - Celular', 0.24, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:43:18', '2017-04-21 18:43:18', 0, 10079, 2, ''), (371, 1, '011266', 'Lesotho', 0.251, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:44:35', '2017-04-21 18:44:35', 0, 10079, 2, ''), (372, 1, '011231', 'Liberia', 0.278, 0, 0, 0.559, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:45:47', '2017-04-21 18:45:47', 0, 10079, 2, ''), (373, 1, '011218', 'Libia', 0.268, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:51:56', '2017-04-21 18:51:56', 0, 10079, 2, ''), (374, 1, '01121891', 'Libia - Celular', 0.268, 0, 0, 0.621, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 18:52:51', '2017-04-21 18:52:51', 0, 10079, 2, ''), (375, 1, '011423', 'Liechtenstein', 0.059, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 19:01:46', '2017-04-21 19:01:46', 0, 10079, 2, ''), (376, 1, '0114236', 'Liechtenstein - Celular', 0.332, 0, 0, 0.431, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 19:55:46', '2017-04-21 19:55:46', 0, 10079, 2, ''), (377, 1, '011370', 'Lithuania', 0.074, 0, 0, 0.279, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 20:39:32', '2017-04-21 20:39:32', 0, 10079, 2, ''), (378, 1, '0113706', 'Lithuania- Celular', 0.194, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 21:36:19', '2017-04-21 21:36:19', 0, 10079, 2, ''), (379, 1, '011352', 'Luxenburgo', 0.026, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 21:50:10', '2017-04-21 21:50:10', 0, 10079, 2, ''), (380, 1, '01135221', 'Luxenburgo - Celular', 0.264, 0, 0, 0.31, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 21:51:15', '2017-04-21 21:51:15', 0, 10079, 2, ''), (381, 1, '011853', 'Macao', 0.055, 0, 0, 0.341, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 21:54:58', '2017-04-21 21:54:58', 0, 10079, 2, ''), (382, 1, '011389', 'Macedonia', 0.134, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 21:57:05', '2017-04-21 21:57:05', 0, 10079, 2, ''), (383, 1, '0113897', 'Macedonia - Celular', 0.331, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 21:59:00', '2017-04-21 21:59:00', 0, 10079, 2, ''), (384, 1, '0113892', 'Macedonia - Skopje', 0.331, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:01:06', '2017-04-21 22:01:06', 0, 10079, 2, ''), (385, 1, '011261', 'Madagascar', 0.243, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:02:31', '2017-04-21 22:02:31', 0, 10079, 2, ''), (386, 1, '01160', 'Malasia', 0.025, 0, 0, 0.248, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:04:08', '2017-04-21 22:04:08', 0, 10079, 2, ''), (387, 1, '011601', 'Malasia - Celular', 0.057, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:05:33', '2017-04-21 22:05:33', 0, 10079, 2, ''), (388, 1, '011603', 'Malasia - Kuala Lumpur', 0.028, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:06:42', '2017-04-21 22:06:42', 0, 10079, 2, ''), (389, 1, '011265', 'Malawi', 0.065, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:13:21', '2017-04-21 22:13:21', 0, 10079, 2, ''), (390, 1, '011960', 'Maldives', 0.279, 0, 0, 0.496, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:34:57', '2017-04-21 22:34:57', 0, 10079, 2, ''), (391, 1, '011223', 'Mali', 0.313, 0, 0, 1.086, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:44:44', '2017-04-21 22:44:44', 0, 10079, 2, ''), (392, 1, '011356', 'Malta', 0.111, 0, 0, 0.31, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:46:07', '2017-04-21 22:46:07', 0, 10079, 2, ''), (393, 1, '0113569', 'Malta - Celular', 0.326, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:53:55', '2017-04-21 22:53:55', 0, 10079, 2, ''), (394, 1, '011212', 'Marruecos', 0.218, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 22:55:57', '2017-04-21 22:55:57', 0, 10079, 2, ''), (395, 1, '0112126', 'Marruecos - Celular', 0.345, 0, 0, 0.714, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 23:02:44', '2017-04-21 23:02:44', 0, 10079, 2, ''), (396, 1, '011692', 'Islas Marshall', 0.338, 0, 0, 0.9, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 23:08:21', '2017-04-21 23:08:21', 0, 10079, 2, ''), (397, 1, '011596', 'Martinica', 0.37, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 23:16:26', '2017-04-21 23:16:26', 0, 10079, 2, ''), (398, 1, '011596696', 'Martinica - Celular', 0.37, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-21 23:27:42', '2017-04-21 23:27:42', 0, 10079, 2, ''), (399, 1, '011222', 'Mauritania', 0.266, 0, 0, 0.9, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 11:02:57', '2017-04-22 11:02:57', 0, 10079, 2, ''), (400, 1, '011230', 'Mauritius', 0.202, 0, 0, 0.9, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 14:39:42', '2017-04-22 14:39:42', 0, 10079, 2, ''), (401, 1, '0112696', 'Mayotte', 1.02, 0, 0, 0.9, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 14:43:43', '2017-04-22 14:43:43', 0, 10079, 2, ''), (402, 1, '01152', 'Mexico', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 14:46:12', '2017-04-22 14:46:12', 0, 10079, 2, ''), (403, 1, '01152333', 'Mexico - Gudalajara', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 14:48:55', '2017-04-22 14:48:55', 0, 10079, 2, ''), (404, 1, '01152477', 'Mexico - Leon', 0.029, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 16:06:23', '2017-04-22 16:06:23', 0, 10079, 2, ''), (405, 1, '0115255', 'Mexico - Ciudad de Mexico 5255', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:04:23', '2017-04-22 19:04:23', 0, 10079, 2, ''), (406, 1, '0115281', 'Mexico - Monterrey 5281', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:14:07', '2017-04-22 19:14:07', 0, 10079, 2, ''), (407, 1, '01152222', 'Mexico - Puebla', 0.026, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:24:14', '2017-04-22 19:24:14', 0, 10079, 2, ''), (408, 1, '0115212', 'Mexico - Celular', 0.299, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:26:34', '2017-04-22 19:26:34', 0, 10079, 2, ''), (409, 1, '0115213', 'Mexico - Celular', 0.299, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:29:45', '2017-04-22 19:29:45', 0, 10079, 2, ''), (410, 1, '0115214', 'Mexico - Celular', 0.299, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:30:32', '2017-04-22 19:30:32', 0, 10079, 2, ''), (411, 1, '0115216', 'Mexico - Celular', 0.299, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:31:12', '2017-04-22 19:31:12', 0, 10079, 2, ''), (412, 1, '0115218', 'Mexico - Celular', 0.299, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:31:46', '2017-04-22 19:31:46', 0, 10079, 2, ''), (413, 1, '01152777', 'Mexico - Cuernavaca', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:33:53', '2017-04-22 19:33:53', 0, 10079, 2, ''), (414, 1, '0115233', 'Mexico - Gudalajara 5233', 0.069, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:34:57', '2017-04-22 19:34:57', 0, 10079, 2, ''), (415, 1, '01152555', 'Mexico - Ciudad de Mexico', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:36:07', '2017-04-22 19:36:07', 0, 10079, 2, ''), (416, 1, '01152818', 'Mexico - Monterrey', 0.019, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:38:26', '2017-04-22 19:38:26', 0, 10079, 2, ''), (417, 1, '01152443', 'Mexico - Morelia', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:40:32', '2017-04-22 19:40:32', 0, 10079, 2, ''), (418, 1, '01152951', 'Mexico - Oaxaca', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:41:51', '2017-04-22 19:41:51', 0, 10079, 2, ''), (419, 1, '01152322', 'Mexico - Puerto Vallarta', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:43:26', '2017-04-22 19:43:26', 0, 10079, 2, ''), (420, 1, '01152442', 'Mexico - Queretaro', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:44:28', '2017-04-22 19:44:28', 0, 10079, 2, ''), (421, 1, '01152444', 'Mexico - San Luis Potosi', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:45:13', '2017-04-22 19:45:13', 0, 10079, 2, ''), (422, 1, '01152664', 'Mexico - Tijuana', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:45:58', '2017-04-22 19:45:58', 0, 10079, 2, ''), (423, 1, '01152722', 'Mexico - Toluca', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:46:42', '2017-04-22 19:46:42', 0, 10079, 2, ''), (424, 1, '01152871', 'Mexico - Torreon', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:47:31', '2017-04-22 19:47:31', 0, 10079, 2, ''), (425, 1, '01152229', 'Mexico - Veracruz', 0.112, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:48:17', '2017-04-22 19:48:17', 0, 10079, 2, ''), (426, 1, '01152669', 'Mexico - Mazatlan', 0.112, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 19:59:42', '2017-04-22 19:59:42', 0, 10079, 2, ''), (427, 1, '011691', 'Micronesia', 0.305, 0, 0, 0.683, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:05:11', '2017-04-22 20:05:11', 0, 10079, 2, ''), (428, 1, '011373', 'Moldova', 0.141, 0, 0, 0.372, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:07:56', '2017-04-22 20:07:56', 0, 10079, 2, ''), (429, 1, '01137369', 'Moldova - Celular', 0.225, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:11:35', '2017-04-22 20:11:35', 0, 10079, 2, ''), (430, 1, '0113732', 'Moldova - Chisinau', 0.22, 0, 0, 0.403, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:12:42', '2017-04-22 20:12:42', 0, 10079, 2, ''), (431, 1, '011377', 'Monaco', 0.028, 0, 0, 0.217, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:13:41', '2017-04-22 20:13:41', 0, 10079, 2, ''), (432, 1, '0113776', 'Monaco - Celular', 0.272, 0, 0, 0.3536, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:14:33', '2017-04-22 20:14:33', 0, 10079, 2, ''), (433, 1, '0113774', 'Monaco - Celular Kfor', 0.272, 0, 0, 0.3536, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:17:00', '2017-04-22 20:17:00', 0, 10079, 2, ''), (434, 1, '011976', 'Mongolia', 0.047, 0, 0, 0.186, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:18:11', '2017-04-22 20:18:11', 0, 10079, 2, ''), (435, 1, '1664', 'Montserrat', 0.172, 0, 0, 0.434, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:19:04', '2017-04-22 20:19:04', 0, 10079, 2, ''), (436, 1, '166410', 'Montserrat - Celular', 0.5, 0, 0, 0.683, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:20:06', '2017-04-22 20:20:06', 0, 10079, 2, ''), (437, 1, '011258', 'Mozambique', 0.125, 0, 0, 0.527, 60, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2007-04-22 20:21:11',