INSERT INTO `voip_routes` (`prefix`, `name`, `descr`) VALUES
  ('0093','Afghanistan','Afghanistan'),
  ('00355','Albania','Albania'),
  ('00213','Algeria','Algeria'),
  ('0021361','Algeria - Mobile','Algeria - Mobile'),
  ('0021398','Algeria - Mobile','Algeria - Mobile'),
  ('0021399','Algeria - Mobile','Algeria - Mobile'),
  ('00684','American Samoa','American Samoa'),
  ('00376','Andorra','Andorra'),
  ('003763','Andorra - Mobile','Andorra - Mobile'),
  ('00244','Angola','Angola'),
  ('0024495','Angola - Mobile','Angola - Mobile'),
  ('001264','Anguilla','Anguilla'),
  ('00672','Antarctica. Norfolk. Christmas & Cocos Is.','Antarctica. Norfolk. Christmas & Cocos Is.'),
  ('001268','Antigua','Antigua'),
  ('0054','Argentina','Argentina'),
  ('005411','Argentina - Buenos Aires','Argentina - Buenos Aires'),
  ('00549','Argentina - Mobile','Argentina - Mobile'),
  ('00374','Armenia','Armenia'),
  ('003741','Armenia - Mobile','Armenia - Mobile'),
  ('00297','Aruba','Aruba'),
  ('00247','Ascension Island','Ascension Island'),
  ('0061','Australia','Australia'),
  ('00613','Australia - Melbourne','Australia - Melbourne'),
  ('006107','Australia - Mobile','Australia - Mobile'),
  ('00611','Australia - Mobile','Australia - Mobile'),
  ('00614','Australia - Mobile','Australia - Mobile'),
  ('00615','Australia - Mobile','Australia - Mobile'),
  ('006178','Australia - Mobile','Australia - Mobile'),
  ('006179','Australia - Mobile','Australia - Mobile'),
  ('00612','Australia - Sydney','Australia - Sydney'),
  ('0043','Austria','Austria'),
  ('0043454','Austria - Mobile','Austria - Mobile'),
  ('0043650','Austria - Mobile','Austria - Mobile'),
  ('0043660','Austria - Mobile','Austria - Mobile'),
  ('0043661','Austria - Mobile','Austria - Mobile'),
  ('0043663','Austria - Mobile','Austria - Mobile'),
  ('0043664','Austria - Mobile','Austria - Mobile'),
  ('0043665','Austria - Mobile','Austria - Mobile'),
  ('0043667','Austria - Mobile','Austria - Mobile'),
  ('0043668','Austria - Mobile','Austria - Mobile'),
  ('0043669','Austria - Mobile','Austria - Mobile'),
  ('004367','Austria - Mobile','Austria - Mobile'),
  ('004368','Austria - Mobile','Austria - Mobile'),
  ('004369','Austria - Mobile','Austria - Mobile'),
  ('00431','Austria - Vienna','Austria - Vienna'),
  ('00994','Azerbaijan','Azerbaijan'),
  ('0099450','Azerbaijan - Mobile','Azerbaijan - Mobile'),
  ('001242','Bahamas','Bahamas'),
  ('00973','Bahrain','Bahrain'),
  ('00973945','Bahrain - Mobile','Bahrain - Mobile'),
  ('00973946','Bahrain - Mobile','Bahrain - Mobile'),
  ('00973947','Bahrain - Mobile','Bahrain - Mobile'),
  ('00880','Bangladesh','Bangladesh'),
  ('0088031','Bangladesh - Chittagong','Bangladesh - Chittagong'),
  ('008802','Bangladesh - Dhaka','Bangladesh - Dhaka'),
  ('008801','Bangladesh - Mobile','Bangladesh - Mobile'),
  ('001246','Barbados','Barbados'),
  ('00375','Belarus','Belarus'),
  ('0037529','Belarus Mobile','Belarus Mobile'),
  ('0032','Belgium','Belgium'),
  ('00323','Belgium - Antwerp','Belgium - Antwerp'),
  ('00322','Belgium - Brussels','Belgium - Brussels'),
  ('003217','Belgium - Mobile','Belgium - Mobile'),
  ('003245','Belgium - Mobile','Belgium - Mobile'),
  ('003247','Belgium - Mobile','Belgium - Mobile'),
  ('003248','Belgium - Mobile','Belgium - Mobile'),
  ('003249','Belgium - Mobile','Belgium - Mobile'),
  ('003270','Belgium - Mobile','Belgium - Mobile'),
  ('003288','Belgium - Mobile','Belgium - Mobile'),
  ('003295','Belgium - Mobile','Belgium - Mobile'),
  ('00501','Belize','Belize'),
  ('00229','Benin','Benin'),
  ('001441','Bermuda','Bermuda'),
  ('00975','Bhutan','Bhutan'),
  ('00591','Bolivia','Bolivia'),
  ('005912','Bolivia - La Paz','Bolivia - La Paz'),
  ('005911','Bolivia - Mobile','Bolivia - Mobile'),
  ('005917','Bolivia - Mobile','Bolivia - Mobile'),
  ('005919','Bolivia - Mobile','Bolivia - Mobile'),
  ('00387','Bosnia & Herzegovina','Bosnia & Herzegovina'),
  ('0038766','Bosnia & Herzegovina - Mobile','Bosnia & Herzegovina - Mobile'),
  ('0038790','Bosnia & Herzegovina - Mobile','Bosnia & Herzegovina - Mobile'),
  ('00267','Botswana','Botswana'),
  ('0055','Brazil','Brazil'),
  ('005531','Brazil - Belo Horizonte','Brazil - Belo Horizonte'),
  ('00551181','Brazil - Mobile','Brazil - Mobile'),
  ('0055119','Brazil - Mobile','Brazil - Mobile'),
  ('00551281','Brazil - Mobile','Brazil - Mobile'),
  ('0055129','Brazil - Mobile','Brazil - Mobile'),
  ('00551381','Brazil - Mobile','Brazil - Mobile'),
  ('0055139','Brazil - Mobile','Brazil - Mobile'),
  ('00551481','Brazil - Mobile','Brazil - Mobile'),
  ('0055149','Brazil - Mobile','Brazil - Mobile'),
  ('00551581','Brazil - Mobile','Brazil - Mobile'),
  ('0055159','Brazil - Mobile','Brazil - Mobile'),
  ('00551681','Brazil - Mobile','Brazil - Mobile'),
  ('0055169','Brazil - Mobile','Brazil - Mobile'),
  ('00551781','Brazil - Mobile','Brazil - Mobile'),
  ('0055179','Brazil - Mobile','Brazil - Mobile'),
  ('00551881','Brazil - Mobile','Brazil - Mobile'),
  ('0055189','Brazil - Mobile','Brazil - Mobile'),
  ('00551981','Brazil - Mobile','Brazil - Mobile'),
  ('0055199','Brazil - Mobile','Brazil - Mobile'),
  ('00552188','Brazil - Mobile','Brazil - Mobile'),
  ('00552189','Brazil - Mobile','Brazil - Mobile'),
  ('0055219','Brazil - Mobile','Brazil - Mobile'),
  ('00552288','Brazil - Mobile','Brazil - Mobile'),
  ('00552289','Brazil - Mobile','Brazil - Mobile'),
  ('0055229','Brazil - Mobile','Brazil - Mobile'),
  ('00552488','Brazil - Mobile','Brazil - Mobile'),
  ('00552489','Brazil - Mobile','Brazil - Mobile'),
  ('0055249','Brazil - Mobile','Brazil - Mobile'),
  ('00552788','Brazil - Mobile','Brazil - Mobile'),
  ('00552789','Brazil - Mobile','Brazil - Mobile'),
  ('0055279','Brazil - Mobile','Brazil - Mobile'),
  ('00552888','Brazil - Mobile','Brazil - Mobile'),
  ('0055289','Brazil - Mobile','Brazil - Mobile'),
  ('00553189','Brazil - Mobile','Brazil - Mobile'),
  ('0055319','Brazil - Mobile','Brazil - Mobile'),
  ('00553289','Brazil - Mobile','Brazil - Mobile'),
  ('0055329','Brazil - Mobile','Brazil - Mobile'),
  ('00553389','Brazil - Mobile','Brazil - Mobile'),
  ('0055339','Brazil - Mobile','Brazil - Mobile'),
  ('00553489','Brazil - Mobile','Brazil - Mobile'),
  ('0055349','Brazil - Mobile','Brazil - Mobile'),
  ('00553589','Brazil - Mobile','Brazil - Mobile'),
  ('0055359','Brazil - Mobile','Brazil - Mobile'),
  ('00553789','Brazil - Mobile','Brazil - Mobile'),
  ('0055379','Brazil - Mobile','Brazil - Mobile'),
  ('00553889','Brazil - Mobile','Brazil - Mobile'),
  ('0055389','Brazil - Mobile','Brazil - Mobile'),
  ('0055419','Brazil - Mobile','Brazil - Mobile'),
  ('0055429','Brazil - Mobile','Brazil - Mobile'),
  ('0055439','Brazil - Mobile','Brazil - Mobile'),
  ('0055449','Brazil - Mobile','Brazil - Mobile'),
  ('0055459','Brazil - Mobile','Brazil - Mobile'),
  ('0055469','Brazil - Mobile','Brazil - Mobile'),
  ('0055479','Brazil - Mobile','Brazil - Mobile'),
  ('0055489','Brazil - Mobile','Brazil - Mobile'),
  ('0055499','Brazil - Mobile','Brazil - Mobile'),
  ('00555181','Brazil - Mobile','Brazil - Mobile'),
  ('00555189','Brazil - Mobile','Brazil - Mobile'),
  ('0055519','Brazil - Mobile','Brazil - Mobile'),
  ('0055539','Brazil - Mobile','Brazil - Mobile'),
  ('00555489','Brazil - Mobile','Brazil - Mobile'),
  ('0055549','Brazil - Mobile','Brazil - Mobile'),
  ('00555589','Brazil - Mobile','Brazil - Mobile'),
  ('0055559','Brazil - Mobile','Brazil - Mobile'),
  ('00556181','Brazil - Mobile','Brazil - Mobile'),
  ('00556189','Brazil - Mobile','Brazil - Mobile'),
  ('0055619','Brazil - Mobile','Brazil - Mobile'),
  ('00556281','Brazil - Mobile','Brazil - Mobile'),
  ('00556289','Brazil - Mobile','Brazil - Mobile'),
  ('0055629','Brazil - Mobile','Brazil - Mobile'),
  ('00556389','Brazil - Mobile','Brazil - Mobile'),
  ('0055639','Brazil - Mobile','Brazil - Mobile'),
  ('00556489','Brazil - Mobile','Brazil - Mobile'),
  ('00556589','Brazil - Mobile','Brazil - Mobile'),
  ('0055659','Brazil - Mobile','Brazil - Mobile'),
  ('00556689','Brazil - Mobile','Brazil - Mobile'),
  ('0055669','Brazil - Mobile','Brazil - Mobile'),
  ('00556789','Brazil - Mobile','Brazil - Mobile'),
  ('0055679','Brazil - Mobile','Brazil - Mobile'),
  ('00556889','Brazil - Mobile','Brazil - Mobile'),
  ('0055689','Brazil - Mobile','Brazil - Mobile'),
  ('00556989','Brazil - Mobile','Brazil - Mobile'),
  ('0055699','Brazil - Mobile','Brazil - Mobile'),
  ('00557188','Brazil - Mobile','Brazil - Mobile'),
  ('0055719','Brazil - Mobile','Brazil - Mobile'),
  ('00557388','Brazil - Mobile','Brazil - Mobile'),
  ('0055739','Brazil - Mobile','Brazil - Mobile'),
  ('00557488','Brazil - Mobile','Brazil - Mobile'),
  ('0055749','Brazil - Mobile','Brazil - Mobile'),
  ('00557588','Brazil - Mobile','Brazil - Mobile'),
  ('0055759','Brazil - Mobile','Brazil - Mobile'),
  ('00557788','Brazil - Mobile','Brazil - Mobile'),
  ('0055779','Brazil - Mobile','Brazil - Mobile'),
  ('00557988','Brazil - Mobile','Brazil - Mobile'),
  ('0055799','Brazil - Mobile','Brazil - Mobile'),
  ('00558188','Brazil - Mobile','Brazil - Mobile'),
  ('0055819','Brazil - Mobile','Brazil - Mobile'),
  ('00558288','Brazil - Mobile','Brazil - Mobile'),
  ('0055829','Brazil - Mobile','Brazil - Mobile'),
  ('00558388','Brazil - Mobile','Brazil - Mobile'),
  ('0055839','Brazil - Mobile','Brazil - Mobile'),
  ('00558488','Brazil - Mobile','Brazil - Mobile'),
  ('0055849','Brazil - Mobile','Brazil - Mobile'),
  ('00558588','Brazil - Mobile','Brazil - Mobile'),
  ('0055859','Brazil - Mobile','Brazil - Mobile'),
  ('00558688','Brazil - Mobile','Brazil - Mobile'),
  ('0055869','Brazil - Mobile','Brazil - Mobile'),
  ('00558788','Brazil - Mobile','Brazil - Mobile'),
  ('0055879','Brazil - Mobile','Brazil - Mobile'),
  ('00558888','Brazil - Mobile','Brazil - Mobile'),
  ('0055889','Brazil - Mobile','Brazil - Mobile'),
  ('00558988','Brazil - Mobile','Brazil - Mobile'),
  ('0055899','Brazil - Mobile','Brazil - Mobile'),
  ('00559188','Brazil - Mobile','Brazil - Mobile'),
  ('00559189','Brazil - Mobile','Brazil - Mobile'),
  ('0055919','Brazil - Mobile','Brazil - Mobile'),
  ('00559288','Brazil - Mobile','Brazil - Mobile'),
  ('00559289','Brazil - Mobile','Brazil - Mobile'),
  ('0055929','Brazil - Mobile','Brazil - Mobile'),
  ('00559388','Brazil - Mobile','Brazil - Mobile'),
  ('00559389','Brazil - Mobile','Brazil - Mobile'),
  ('0055939','Brazil - Mobile','Brazil - Mobile'),
  ('00559488','Brazil - Mobile','Brazil - Mobile'),
  ('00559489','Brazil - Mobile','Brazil - Mobile'),
  ('0055949','Brazil - Mobile','Brazil - Mobile'),
  ('00559588','Brazil - Mobile','Brazil - Mobile'),
  ('00559589','Brazil - Mobile','Brazil - Mobile'),
  ('0055959','Brazil - Mobile','Brazil - Mobile'),
  ('00559688','Brazil - Mobile','Brazil - Mobile'),
  ('00559689','Brazil - Mobile','Brazil - Mobile'),
  ('0055969','Brazil - Mobile','Brazil - Mobile'),
  ('00559788','Brazil - Mobile','Brazil - Mobile'),
  ('0055979','Brazil - Mobile','Brazil - Mobile'),
  ('00559888','Brazil - Mobile','Brazil - Mobile'),
  ('00559889','Brazil - Mobile','Brazil - Mobile'),
  ('0055989','Brazil - Mobile','Brazil - Mobile'),
  ('00559988','Brazil - Mobile','Brazil - Mobile'),
  ('00559989','Brazil - Mobile','Brazil - Mobile'),
  ('0055999','Brazil - Mobile','Brazil - Mobile'),
  ('005521','Brazil - Rio de Janiero','Brazil - Rio de Janiero'),
  ('005511','Brazil - Sao Paulo','Brazil - Sao Paulo'),
  ('001284','British Virgin Islands','British Virgin Islands'),
  ('00673','Brunei','Brunei'),
  ('006732','Brunei - Mobile','Brunei - Mobile'),
  ('0067368','Brunei - Mobile','Brunei - Mobile'),
  ('006738','Brunei - Mobile','Brunei - Mobile'),
  ('00359','Bulgaria','Bulgaria'),
  ('0035948','Bulgaria - Mobile','Bulgaria - Mobile'),
  ('0035979','Bulgaria - Mobile','Bulgaria - Mobile'),
  ('0035987','Bulgaria - Mobile','Bulgaria - Mobile'),
  ('0035988','Bulgaria - Mobile','Bulgaria - Mobile'),
  ('0035998','Bulgaria - Mobile','Bulgaria - Mobile'),
  ('003592','Bulgaria - Sofia','Bulgaria - Sofia'),
  ('00226','Burkina Faso','Burkina Faso'),
  ('00257','Burundi','Burundi'),
  ('0025729','Burundi - Mobile','Burundi - Mobile'),
  ('00855','Cambodia','Cambodia'),
  ('008551','Cambodia - Mobile','Cambodia - Mobile'),
  ('00237','Cameroon','Cameroon'),
  ('002379','Cameroon - Mobile','Cameroon - Mobile'),
  ('001204','Canada','Canada'),
  ('001250','Canada','Canada'),
  ('001306','Canada','Canada'),
  ('001403','Canada','Canada'),
  ('001416','Canada','Canada'),
  ('001418','Canada','Canada'),
  ('001450','Canada','Canada'),
  ('001506','Canada','Canada'),
  ('001514','Canada','Canada'),
  ('001519','Canada','Canada'),
  ('001604','Canada','Canada'),
  ('001613','Canada','Canada'),
  ('001647','Canada','Canada'),
  ('001705','Canada','Canada'),
  ('001709','Canada','Canada'),
  ('001780','Canada','Canada'),
  ('001807','Canada','Canada'),
  ('001819','Canada','Canada'),
  ('001867','Canada','Canada'),
  ('001902','Canada','Canada'),
  ('001905','Canada','Canada'),
  ('00238','Cape Verde Islands','Cape Verde Islands'),
  ('001345','Cayman Islands','Cayman Islands'),
  ('00236','Central African Republic','Central African Republic'),
  ('00235','Chad','Chad'),
  ('0023524','Chad - Mobile','Chad - Mobile'),
  ('0056','Chile','Chile'),
  ('00561','Chile - Mobile','Chile - Mobile'),
  ('005626','Chile - Mobile','Chile - Mobile'),
  ('005627','Chile - Mobile','Chile - Mobile'),
  ('0056300','Chile - Mobile','Chile - Mobile'),
  ('0056568','Chile - Mobile','Chile - Mobile'),
  ('0056569','Chile - Mobile','Chile - Mobile'),
  ('005668','Chile - Mobile','Chile - Mobile'),
  ('005669','Chile - Mobile','Chile - Mobile'),
  ('0056700','Chile - Mobile','Chile - Mobile'),
  ('0056800','Chile - Mobile','Chile - Mobile'),
  ('00569','Chile - Mobile','Chile - Mobile'),
  ('005620','Chile - Santiago','Chile - Santiago'),
  ('005621','Chile - Santiago','Chile - Santiago'),
  ('005622','Chile - Santiago','Chile - Santiago'),
  ('005623','Chile - Santiago','Chile - Santiago'),
  ('005624','Chile - Santiago','Chile - Santiago'),
  ('005625','Chile - Santiago','Chile - Santiago'),
  ('005628','Chile - Santiago','Chile - Santiago'),
  ('005629','Chile - Santiago','Chile - Santiago'),
  ('0086','China','China'),
  ('008610','China - Beijing','China - Beijing'),
  ('008611','China - Beijing','China - Beijing'),
  ('008612','China - Beijing','China - Beijing'),
  ('008614','China - Beijing','China - Beijing'),
  ('008615','China - Beijing','China - Beijing'),
  ('008616','China - Beijing','China - Beijing'),
  ('008617','China - Beijing','China - Beijing'),
  ('008618','China - Beijing','China - Beijing'),
  ('008619','China - Beijing','China - Beijing'),
  ('008620','China - Canton','China - Canton'),
  ('0086591','China - Fuzhou','China - Fuzhou'),
  ('008613','China - Mobile','China - Mobile'),
  ('0086886','China - Mobile','China - Mobile'),
  ('008621','China - Shanghai','China - Shanghai'),
  ('008622','China - Tianjin','China - Tianjin'),
  ('006722','Christmas & Cocos Islands','Christmas & Cocos Islands'),
  ('006724','Christmas & Cocos Islands','Christmas & Cocos Islands'),
  ('0057','Colombia','Colombia'),
  ('005753','Colombia - Baranquilla','Colombia - Baranquilla'),
  ('00571','Colombia - Bogota','Colombia - Bogota'),
  ('00572','Colombia - Cali','Colombia - Cali'),
  ('00574','Colombia - Medellin','Colombia - Medellin'),
  ('00573','Colombia - Mobile','Colombia - Mobile'),
  ('002690','Comoros','Comoros'),
  ('002691','Comoros','Comoros'),
  ('002692','Comoros','Comoros'),
  ('002693','Comoros','Comoros'),
  ('002694','Comoros','Comoros'),
  ('002695','Comoros','Comoros'),
  ('002698','Comoros','Comoros'),
  ('002699','Comoros','Comoros'),
  ('002697','Comoros Mayotte Island - Mobile','Comoros Mayotte Island - Mobile'),
  ('00242','Congo. Republic of','Congo. Republic of'),
  ('00682','Cook Islands','Cook Islands'),
  ('0068260','Cook Islands - Mobile','Cook Islands - Mobile'),
  ('0068261','Cook Islands - Mobile','Cook Islands - Mobile'),
  ('0068264','Cook Islands - Mobile','Cook Islands - Mobile'),
  ('0068265','Cook Islands - Mobile','Cook Islands - Mobile'),
  ('00506','Costa Rica','Costa Rica'),
  ('00506283','Costa Rica - Mobile','Costa Rica - Mobile'),
  ('00506284','Costa Rica - Mobile','Costa Rica - Mobile'),
  ('005063','Costa Rica - Mobile','Costa Rica - Mobile'),
  ('00506712','Costa Rica - Mobile','Costa Rica - Mobile'),
  ('00385','Croatia','Croatia'),
  ('003859','Croatia - Mobile','Croatia - Mobile'),
  ('0053','Cuba','Cuba'),
  ('00539','Cuba - Guantanamo Bay','Cuba - Guantanamo Bay'),
  ('00532','Cuba - Mobil','Cuba - Mobil'),
  ('00357','Cyprus','Cyprus'),
  ('003579','Cyprus - Mobile','Cyprus - Mobile'),
  ('00420','Czech Republic','Czech Republic'),
  ('00420601','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420602','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420603','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420604','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420605','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420606','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420609','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('0042072','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('0042073','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('0042077','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('0042093','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420961','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420962','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420963','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420964','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420965','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('00420966','Czech Republic - Mobile Special/Services','Czech Republic - Mobile Special/Services'),
  ('004202','Czech Republic - Prague','Czech Republic - Prague'),
  ('0045','Denmark','Denmark'),
  ('00452','Denmark - Mobile','Denmark - Mobile'),
  ('004530','Denmark - Mobile','Denmark - Mobile'),
  ('004531','Denmark - Mobile','Denmark - Mobile'),
  ('004540','Denmark - Mobile','Denmark - Mobile'),
  ('004541','Denmark - Mobile','Denmark - Mobile'),
  ('004550','Denmark - Mobile','Denmark - Mobile'),
  ('004551','Denmark - Mobile','Denmark - Mobile'),
  ('004560','Denmark - Mobile','Denmark - Mobile'),
  ('004561','Denmark - Mobile','Denmark - Mobile'),
  ('004570','Denmark - Mobile','Denmark - Mobile'),
  ('004577','Denmark - Mobile','Denmark - Mobile'),
  ('004588','Denmark - Mobile','Denmark - Mobile'),
  ('004590','Denmark - Mobile','Denmark - Mobile'),
  ('0045922','Denmark - Mobile','Denmark - Mobile'),
  ('00246','Diego Garcia','Diego Garcia'),
  ('00253','Djibouti','Djibouti'),
  ('0025380','Djibouti - Mobile','Djibouti - Mobile'),
  ('001767','Dominica','Dominica'),
  ('001809','Dominican Republic','Dominican Republic'),
  ('0018092','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('00180932','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809470','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809474','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809537','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809540','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809563','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809628','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809629','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809630','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809631','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809632','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809633','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809634','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809635','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809683','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('001809695','Dominican Republic - Mobile','Dominican Republic - Mobile'),
  ('00593','Ecuador','Ecuador'),
  ('005934','Ecuador - Guayaquill','Ecuador - Guayaquill'),
  ('005939','Ecuador - Mobile','Ecuador - Mobile'),
  ('005932','Ecuador - Quito','Ecuador - Quito'),
  ('0020','Egypt','Egypt'),
  ('00202','Egypt - Cairo','Egypt - Cairo'),
  ('002010','Egypt - Mobile Special/Services','Egypt - Mobile Special/Services'),
  ('002012','Egypt - Mobile Special/Services','Egypt - Mobile Special/Services'),
  ('00503','El Salvador','El Salvador'),
  ('0050338','El Salvador - Mobile','El Salvador - Mobile'),
  ('0050339','El Salvador - Mobile','El Salvador - Mobile'),
  ('005037','El Salvador - Mobile','El Salvador - Mobile'),
  ('005038','El Salvador - Mobile','El Salvador - Mobile'),
  ('005039','El Salvador - Mobile','El Salvador - Mobile'),
  ('00240','Equatorial Guinea','Equatorial Guinea'),
  ('00291','Eritrea','Eritrea'),
  ('00372','Estonia','Estonia'),
  ('003725','Estonia - Mobile','Estonia - Mobile'),
  ('00251','Ethiopia','Ethiopia'),
  ('0025192','Ethiopia - Mobile','Ethiopia - Mobile'),
  ('00298','Faeroe Islands','Faeroe Islands'),
  ('00500','Falkland Islands  Islas Malvinas)','Falkland Islands  Islas Malvinas)'),
  ('00679','Fiji Islands','Fiji Islands'),
  ('0067913','Fiji Islands - Mobile','Fiji Islands - Mobile'),
  ('00358','Finland','Finland'),
  ('003584','Finland - Mobile Special/Services','Finland - Mobile Special/Services'),
  ('003585','Finland - Mobile Special/Services','Finland - Mobile Special/Services'),
  ('003586','Finland - Mobile Special/Services','Finland - Mobile Special/Services'),
  ('003587','Finland - Mobile Special/Services','Finland - Mobile Special/Services'),
  ('003588','Finland - Mobile Special/Services','Finland - Mobile Special/Services'),
  ('003589600','Finland - Mobile Special/Services','Finland - Mobile Special/Services'),
  ('003589700','Finland - Mobile Special/Services','Finland - Mobile Special/Services'),
  ('003589800','Finland - Mobile Special/Services','Finland - Mobile Special/Services'),
  ('0033','France','France'),
  ('00336','France - Mobile','France - Mobile'),
  ('00338366','France - Mobile','France - Mobile'),
  ('00338367','France - Mobile','France - Mobile'),
  ('0033890','France - Mobile','France - Mobile'),
  ('0033891','France - Mobile','France - Mobile'),
  ('0033892','France - Mobile','France - Mobile'),
  ('0033893','France - Mobile','France - Mobile'),
  ('0033897','France - Mobile','France - Mobile'),
  ('0033898','France - Mobile','France - Mobile'),
  ('0033899','France - Mobile','France - Mobile'),
  ('00331','France - Paris','France - Paris'),
  ('00596','French Antilles  incl. Martinique)','French Antilles  incl. Martinique)'),
  ('00594','French Guiana','French Guiana'),
  ('00689','French Polynesia','French Polynesia'),
  ('00241','Gabon Republic','Gabon Republic'),
  ('0024123','Gabon Republic - Mobile','Gabon Republic - Mobile'),
  ('0024124','Gabon Republic - Mobile','Gabon Republic - Mobile'),
  ('0024125','Gabon Republic - Mobile','Gabon Republic - Mobile'),
  ('0024126','Gabon Republic - Mobile','Gabon Republic - Mobile'),
  ('00220','Gambia','Gambia'),
  ('00995','Georgia','Georgia'),
  ('00995321','Georgia - Mobile','Georgia - Mobile'),
  ('00995322','Georgia - Mobile','Georgia - Mobile'),
  ('00995325','Georgia - Mobile','Georgia - Mobile'),
  ('00995328','Georgia - Mobile','Georgia - Mobile'),
  ('0049','Germany','Germany'),
  ('0049335','Germany - Frankfurt','Germany - Frankfurt'),
  ('004969','Germany - Frankfurt','Germany - Frankfurt'),
  ('00491','Germany - Mobile','Germany - Mobile'),
  ('0049800','Germany - Mobile','Germany - Mobile'),
  ('0049900','Germany - Mobile','Germany - Mobile'),
  ('00233','Ghana','Ghana'),
  ('0023321','Ghana - Accra','Ghana - Accra'),
  ('0023320','Ghana - Mobile','Ghana - Mobile'),
  ('0023324','Ghana - Mobile','Ghana - Mobile'),
  ('0023327','Ghana - Mobile','Ghana - Mobile'),
  ('0023328','Ghana - Mobile','Ghana - Mobile'),
  ('00350','Gibraltar','Gibraltar'),
  ('0035054','Gibraltar - Mobile','Gibraltar - Mobile'),
  ('0035056','Gibraltar - Mobile','Gibraltar - Mobile'),
  ('0035057','Gibraltar - Mobile','Gibraltar - Mobile'),
  ('0035058','Gibraltar - Mobile','Gibraltar - Mobile'),
  ('0030','Greece','Greece'),
  ('00301','Greece - Athens','Greece - Athens'),
  ('00309','Greece - Mobile Special/Services','Greece - Mobile Special/Services'),
  ('00299','Greenland','Greenland'),
  ('002995','Greenland - Mobile','Greenland - Mobile'),
  ('001473','Grenada','Grenada'),
  ('00590','Guadeloupe','Guadeloupe'),
  ('0059069','Guadeloupe - Mobile','Guadeloupe - Mobile'),
  ('001871','Guam','Guam'),
  ('00502','Guatemala','Guatemala'),
  ('0050220','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050221','Guatemala - Mobile','Guatemala - Mobile'),
  ('00502228','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050230','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050231','Guatemala - Mobile','Guatemala - Mobile'),
  ('00502328','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050240','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050241','Guatemala - Mobile','Guatemala - Mobile'),
  ('00502428','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050250','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050251','Guatemala - Mobile','Guatemala - Mobile'),
  ('00502528','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050260','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050261','Guatemala - Mobile','Guatemala - Mobile'),
  ('00502628','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050270','Guatemala - Mobile','Guatemala - Mobile');

COMMIT;

INSERT INTO `voip_routes` (`prefix`, `name`, `descr`) VALUES
  ('0050271','Guatemala - Mobile','Guatemala - Mobile'),
  ('00502728','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050281','Guatemala - Mobile','Guatemala - Mobile'),
  ('00502828','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050290','Guatemala - Mobile','Guatemala - Mobile'),
  ('0050291','Guatemala - Mobile','Guatemala - Mobile'),
  ('00502928','Guatemala - Mobile','Guatemala - Mobile'),
  ('00224','Guinea','Guinea'),
  ('00245','Guinea-Bissau','Guinea-Bissau'),
  ('0024529','Guinea-Bissau - Mobile','Guinea-Bissau - Mobile'),
  ('00592','Guyana','Guyana'),
  ('005921','Guyana - Mobile','Guyana - Mobile'),
  ('005922','Guyana - Mobile','Guyana - Mobile'),
  ('005922888','Guyana - Mobile','Guyana - Mobile'),
  ('0059248','Guyana - Mobile','Guyana - Mobile'),
  ('005925','Guyana - Mobile','Guyana - Mobile'),
  ('005926','Guyana - Mobile','Guyana - Mobile'),
  ('00509','Haiti','Haiti'),
  ('00509251','Haiti - Mobile','Haiti - Mobile'),
  ('005093','Haiti - Mobile','Haiti - Mobile'),
  ('005094','Haiti - Mobile','Haiti - Mobile'),
  ('0050990','Haiti - Mobile','Haiti - Mobile'),
  ('0050992','Haiti - Mobile','Haiti - Mobile'),
  ('005095','Haiti - Special Services','Haiti - Special Services'),
  ('00504','Honduras','Honduras'),
  ('005041','Honduras - Mobile','Honduras - Mobile'),
  ('00852','Hong Kong','Hong Kong'),
  ('0085217','Hong Kong - Mobile','Hong Kong - Mobile'),
  ('0085248','Hong Kong - Mobile','Hong Kong - Mobile'),
  ('0085249','Hong Kong - Mobile','Hong Kong - Mobile'),
  ('008526','Hong Kong - Mobile','Hong Kong - Mobile'),
  ('008528','Hong Kong - Mobile','Hong Kong - Mobile'),
  ('008529','Hong Kong - Mobile','Hong Kong - Mobile'),
  ('0036','Hungary','Hungary'),
  ('00361','Hungary - Budapest','Hungary - Budapest'),
  ('00362','Hungary - Mobile','Hungary - Mobile'),
  ('00363','Hungary - Mobile','Hungary - Mobile'),
  ('003640','Hungary - Mobile','Hungary - Mobile'),
  ('00366','Hungary - Mobile','Hungary - Mobile'),
  ('003670','Hungary - Mobile','Hungary - Mobile'),
  ('003690','Hungary - Mobile','Hungary - Mobile'),
  ('00354','Iceland','Iceland'),
  ('00354388','Iceland - Mobile','Iceland - Mobile'),
  ('0035439','Iceland - Mobile','Iceland - Mobile'),
  ('0035462','Iceland - Mobile','Iceland - Mobile'),
  ('0035463','Iceland - Mobile','Iceland - Mobile'),
  ('0035464','Iceland - Mobile','Iceland - Mobile'),
  ('0035465','Iceland - Mobile','Iceland - Mobile'),
  ('0035466','Iceland - Mobile','Iceland - Mobile'),
  ('0035467','Iceland - Mobile','Iceland - Mobile'),
  ('0035468','Iceland - Mobile','Iceland - Mobile'),
  ('0035469','Iceland - Mobile','Iceland - Mobile'),
  ('0035482','Iceland - Mobile','Iceland - Mobile'),
  ('0035484','Iceland - Mobile','Iceland - Mobile'),
  ('0035485','Iceland - Mobile','Iceland - Mobile'),
  ('0035486','Iceland - Mobile','Iceland - Mobile'),
  ('0035487','Iceland - Mobile','Iceland - Mobile'),
  ('0035489','Iceland - Mobile','Iceland - Mobile'),
  ('003549','Iceland - Mobile','Iceland - Mobile'),
  ('0091','India','India'),
  ('009179','India - Ahmedabad','India - Ahmedabad'),
  ('009180','India - Bangalore','India - Bangalore'),
  ('009122','India - Bombay','India - Bombay'),
  ('009133','India - Calcutta','India - Calcutta'),
  ('009140','India - Hyderbad','India - Hyderbad'),
  ('009144','India - Madras','India - Madras'),
  ('009198','India - Mobile','India - Mobile'),
  ('009111','India - New Delhi','India - New Delhi'),
  ('009120','India - Pune  Poona)','India - Pune  Poona)'),
  ('009116','India - Punjab','India - Punjab'),
  ('009117','India - Punjab','India - Punjab'),
  ('009118','India - Punjab','India - Punjab'),
  ('00919814','India - Punjab','India - Punjab'),
  ('0062','Indonesia','Indonesia'),
  ('006221','Indonesia - Jakarta','Indonesia - Jakarta'),
  ('00628','Indonesia - Mobile','Indonesia - Mobile'),
  ('00871','INMARSAT - Atlantic East','INMARSAT - Atlantic East'),
  ('00874','INMARSAT - Atlantic West','INMARSAT - Atlantic West'),
  ('00873','INMARSAT - Indian','INMARSAT - Indian'),
  ('00872','INMARSAT - Pacific','INMARSAT - Pacific'),
  ('0098','Iran','Iran'),
  ('009811','Iran - Mobile','Iran - Mobile'),
  ('00964','Iraq','Iraq'),
  ('00353','Ireland','Ireland'),
  ('003531','Ireland - Dublin','Ireland - Dublin'),
  ('0035315','Ireland - Mobile','Ireland - Mobile'),
  ('00353386','Ireland - Mobile','Ireland - Mobile'),
  ('00353387','Ireland - Mobile','Ireland - Mobile'),
  ('00353388','Ireland - Mobile','Ireland - Mobile'),
  ('003538','Ireland - Mobile','Ireland - Mobile'),
  ('00881','Iridium','Iridium'),
  ('00972','Israel','Israel'),
  ('009725','Israel - Mobile','Israel - Mobile'),
  ('0097267','Israel - Mobile','Israel - Mobile'),
  ('009723','Israel - Tel Aviv','Israel - Tel Aviv'),
  ('0039','Italy','Italy'),
  ('003902','Italy - Milan','Italy - Milan'),
  ('00392','Italy - Milan','Italy - Milan'),
  ('00393','Italy - Mobile','Italy - Mobile'),
  ('003906','Italy - Rome','Italy - Rome'),
  ('00396','Italy - Rome','Italy - Rome'),
  ('003966','Italy - Vatican City','Italy - Vatican City'),
  ('00225','Ivory Coast','Ivory Coast'),
  ('002250','Ivory Coast - Mobile','Ivory Coast - Mobile'),
  ('002258','Ivory Coast - Mobile','Ivory Coast - Mobile'),
  ('002259','Ivory Coast - Mobile','Ivory Coast - Mobile'),
  ('001876','Jamaica','Jamaica'),
  ('001876301','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876302','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876303','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876304','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187636','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187637','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187638','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187642','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876490','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876491','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876492','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876493','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876494','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876700','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876707','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187677','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187678','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187679','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876804','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876805','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876806','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876807','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876808','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876809','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876812','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876813','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876814','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876815','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876816','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876817','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876818','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876819','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187682','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187683','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187684','Jamaica - Mobile','Jamaica - Mobile'),
  ('00187685','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876909','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876919','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876990','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876995','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876997','Jamaica - Mobile','Jamaica - Mobile'),
  ('001876999','Jamaica - Mobile','Jamaica - Mobile'),
  ('0081','Japan','Japan'),
  ('00813117','Japan - Military','Japan - Military'),
  ('00816117','Japan - Military','Japan - Military'),
  ('008110','Japan - Mobile','Japan - Mobile'),
  ('008120','Japan - Mobile','Japan - Mobile'),
  ('008130','Japan - Mobile','Japan - Mobile'),
  ('008131','Japan - Mobile','Japan - Mobile'),
  ('008140','Japan - Mobile','Japan - Mobile'),
  ('008150','Japan - Mobile','Japan - Mobile'),
  ('008160','Japan - Mobile','Japan - Mobile'),
  ('008161','Japan - Mobile','Japan - Mobile'),
  ('008170','Japan - Mobile','Japan - Mobile'),
  ('008180','Japan - Mobile','Japan - Mobile'),
  ('008190','Japan - Mobile','Japan - Mobile'),
  ('008162','Japan - Osaka','Japan - Osaka'),
  ('008163','Japan - Osaka','Japan - Osaka'),
  ('008164','Japan - Osaka','Japan - Osaka'),
  ('008165','Japan - Osaka','Japan - Osaka'),
  ('008166','Japan - Osaka','Japan - Osaka'),
  ('008167','Japan - Osaka','Japan - Osaka'),
  ('008168','Japan - Osaka','Japan - Osaka'),
  ('008169','Japan - Osaka','Japan - Osaka'),
  ('008111','Japan - Sapporo','Japan - Sapporo'),
  ('00813','Japan - Tokyo','Japan - Tokyo'),
  ('00962','Jordan','Jordan'),
  ('009626','Jordan - Amman','Jordan - Amman'),
  ('0096277','Jordan - Mobile','Jordan - Mobile'),
  ('0096279','Jordan - Mobile','Jordan - Mobile'),
  ('007102','Kazakhstan','Kazakhstan'),
  ('007142','Kazakhstan','Kazakhstan'),
  ('007252','Kazakhstan','Kazakhstan'),
  ('00731','Kazakhstan','Kazakhstan'),
  ('00732','Kazakhstan','Kazakhstan'),
  ('007330','Kazakhstan','Kazakhstan'),
  ('007331','Kazakhstan','Kazakhstan'),
  ('007332','Kazakhstan','Kazakhstan'),
  ('007334','Kazakhstan','Kazakhstan'),
  ('007335','Kazakhstan','Kazakhstan'),
  ('007336','Kazakhstan','Kazakhstan'),
  ('007300','Kazakhstan - Mobile','Kazakhstan - Mobile'),
  ('007333','Kazakhstan - Mobile','Kazakhstan - Mobile'),
  ('007570','Kazakhstan - Mobile','Kazakhstan - Mobile'),
  ('007571','Kazakhstan - Mobile','Kazakhstan - Mobile'),
  ('00254','Kenya','Kenya'),
  ('0025471','Kenya - Mobile','Kenya - Mobile'),
  ('0025472','Kenya - Mobile','Kenya - Mobile'),
  ('0025473','Kenya - Mobile','Kenya - Mobile'),
  ('002542','Kenya - Nairobi','Kenya - Nairobi'),
  ('00686','Kiribati','Kiribati'),
  ('006860','Kiribati - Mobile','Kiribati - Mobile'),
  ('00850','Korea. North','Korea. North'),
  ('0082','Korea. South','Korea. South'),
  ('008211','Korea. South - Mobile','Korea. South - Mobile'),
  ('008212','Korea. South - Mobile','Korea. South - Mobile'),
  ('008216','Korea. South - Mobile','Korea. South - Mobile'),
  ('008217','Korea. South - Mobile','Korea. South - Mobile'),
  ('008218','Korea. South - Mobile','Korea. South - Mobile'),
  ('008219','Korea. South - Mobile','Korea. South - Mobile'),
  ('008227','Korea. South - Mobile','Korea. South - Mobile'),
  ('008267','Korea. South - Mobile','Korea. South - Mobile'),
  ('00822','Korea. South - Seoul','Korea. South - Seoul'),
  ('00965','Kuwait','Kuwait'),
  ('009652','Kuwait - Mobile','Kuwait - Mobile'),
  ('009653','Kuwait - Mobile','Kuwait - Mobile'),
  ('009654','Kuwait - Mobile','Kuwait - Mobile'),
  ('009655','Kuwait - Mobile','Kuwait - Mobile'),
  ('009656','Kuwait - Mobile','Kuwait - Mobile'),
  ('009657','Kuwait - Mobile','Kuwait - Mobile'),
  ('009658','Kuwait - Mobile','Kuwait - Mobile'),
  ('009659','Kuwait - Mobile','Kuwait - Mobile'),
  ('00996','Kyrgyzstan','Kyrgyzstan'),
  ('009963','Kyrgyzstan - Mobile','Kyrgyzstan - Mobile'),
  ('00856','Laos','Laos'),
  ('00371','Latvia','Latvia'),
  ('0037160','Latvia - Mobile','Latvia - Mobile'),
  ('0037161','Latvia - Mobile','Latvia - Mobile'),
  ('0037162','Latvia - Mobile','Latvia - Mobile'),
  ('0037163','Latvia - Mobile','Latvia - Mobile'),
  ('0037164','Latvia - Mobile','Latvia - Mobile'),
  ('0037165','Latvia - Mobile','Latvia - Mobile'),
  ('0037166','Latvia - Mobile','Latvia - Mobile'),
  ('0037167','Latvia - Mobile','Latvia - Mobile'),
  ('0037168','Latvia - Mobile','Latvia - Mobile'),
  ('0037188','Latvia - Mobile','Latvia - Mobile'),
  ('003719','Latvia - Mobile','Latvia - Mobile'),
  ('00961','Lebanon','Lebanon'),
  ('009613','Lebanon - Mobile','Lebanon - Mobile'),
  ('00266','Lesotho','Lesotho'),
  ('00231','Liberia','Liberia'),
  ('00218','Libya','Libya'),
  ('00423','Liechtenstein','Liechtenstein'),
  ('00370','Lithuania','Lithuania'),
  ('0037061','Lithuania Mobile','Lithuania Mobile'),
  ('0037065','Lithuania Mobile','Lithuania Mobile'),
  ('0037067','Lithuania Mobile','Lithuania Mobile'),
  ('0037068','Lithuania Mobile','Lithuania Mobile'),
  ('0037069','Lithuania Mobile','Lithuania Mobile'),
  ('003708','Lithuania Mobile','Lithuania Mobile'),
  ('003709','Lithuania Mobile','Lithuania Mobile'),
  ('00352','Luxembourg','Luxembourg'),
  ('0035221','Luxembourg - Mobile','Luxembourg - Mobile'),
  ('0035228','Luxembourg - Mobile','Luxembourg - Mobile'),
  ('0035291','Luxembourg - Mobile','Luxembourg - Mobile'),
  ('0035298','Luxembourg - Mobile','Luxembourg - Mobile'),
  ('00853','Macau','Macau'),
  ('00389','Macedonia','Macedonia'),
  ('0038970','Macedonia Mobile','Macedonia Mobile'),
  ('00261','Madagascar','Madagascar'),
  ('002613','Madagascar - Mobile','Madagascar - Mobile'),
  ('002617','Madagascar - Mobile','Madagascar - Mobile'),
  ('00265','Malawi','Malawi'),
  ('002659','Malawi - Mobile','Malawi - Mobile'),
  ('0060','Malaysia','Malaysia'),
  ('00603','Malaysia - Kuala Lumpur','Malaysia - Kuala Lumpur'),
  ('00601','Malaysia - Mobile','Malaysia - Mobile'),
  ('00960','Maldives','Maldives'),
  ('0096095','Maldives - Special Services','Maldives - Special Services'),
  ('00223','Mali Republic','Mali Republic'),
  ('00356','Malta','Malta'),
  ('00692','Marshall Island','Marshall Island'),
  ('00222','Mauritania','Mauritania'),
  ('00230','Mauritius','Mauritius'),
  ('002696','Mayotte Island','Mayotte Island'),
  ('0052','Mexico','Mexico'),
  ('0052744','Mexico - Acapulco','Mexico - Acapulco'),
  ('0052449','Mexico - Aguascalientes','Mexico - Aguascalientes'),
  ('0052461','Mexico - Celaya','Mexico - Celaya'),
  ('0052614','Mexico - Chihuahua','Mexico - Chihuahua'),
  ('0052656','Mexico - Ciudad Juarez','Mexico - Ciudad Juarez'),
  ('0052777','Mexico - Cuernavaca','Mexico - Cuernavaca'),
  ('005233','Mexico - Guadalajara','Mexico - Guadalajara'),
  ('0052462','Mexico - Irapuato','Mexico - Irapuato'),
  ('0052477','Mexico - Leon','Mexico - Leon'),
  ('0052550','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525510','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525511','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525512','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525513','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525515','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525516','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525517','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525518','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525520','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525523','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525524','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525527','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525528','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525529','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525532','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525533','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525534','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525535','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525536','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525537','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525538','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525539','Mexico - Mexico City','Mexico - Mexico City'),
  ('0052554','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525556','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525557','Mexico - Mexico City','Mexico - Mexico City'),
  ('0052556','Mexico - Mexico City','Mexico - Mexico City'),
  ('0052557','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525580','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525581','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525582','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525583','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525584','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525586','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525587','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525588','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525589','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525590','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525592','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525593','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525594','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525595','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525596','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525597','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525598','Mexico - Mexico City','Mexico - Mexico City'),
  ('00525514','Mexico','Mexico'),
  ('00525519','Mexico','Mexico'),
  ('00525521','Mexico','Mexico'),
  ('00525522','Mexico','Mexico'),
  ('00525525','Mexico','Mexico'),
  ('00525526','Mexico','Mexico'),
  ('00525530','Mexico','Mexico'),
  ('00525531','Mexico','Mexico'),
  ('00525550','Mexico','Mexico'),
  ('00525551','Mexico','Mexico'),
  ('00525552','Mexico','Mexico'),
  ('00525553','Mexico','Mexico'),
  ('00525554','Mexico','Mexico'),
  ('00525555','Mexico','Mexico'),
  ('00525558','Mexico','Mexico'),
  ('00525559','Mexico','Mexico'),
  ('00525585','Mexico','Mexico'),
  ('00525591','Mexico','Mexico'),
  ('0052810','Mexico - Monterey','Mexico - Monterey'),
  ('0052811','Mexico - Monterey','Mexico - Monterey'),
  ('0052812','Mexico - Monterey','Mexico - Monterey'),
  ('0052813','Mexico - Monterey','Mexico - Monterey'),
  ('0052814','Mexico - Monterey','Mexico - Monterey'),
  ('0052815','Mexico - Monterey','Mexico - Monterey'),
  ('0052816','Mexico - Monterey','Mexico - Monterey'),
  ('0052817','Mexico - Monterey','Mexico - Monterey'),
  ('00528180','Mexico - Monterey','Mexico - Monterey'),
  ('00528185','Mexico - Monterey','Mexico - Monterey'),
  ('00528188','Mexico - Monterey','Mexico - Monterey'),
  ('00528189','Mexico - Monterey','Mexico - Monterey'),
  ('0052819','Mexico - Monterey','Mexico - Monterey'),
  ('0052271','Mexico','Mexico'),
  ('0052272','Mexico','Mexico'),
  ('0052311','Mexico','Mexico'),
  ('0052312','Mexico','Mexico'),
  ('0052351','Mexico','Mexico'),
  ('0052352','Mexico','Mexico'),
  ('0052392','Mexico','Mexico'),
  ('0052452','Mexico','Mexico'),
  ('0052473','Mexico','Mexico'),
  ('0052493','Mexico','Mexico'),
  ('0052595','Mexico','Mexico'),
  ('0052618','Mexico','Mexico'),
  ('0052622','Mexico','Mexico'),
  ('0052644','Mexico','Mexico'),
  ('0052668','Mexico','Mexico'),
  ('0052669','Mexico','Mexico'),
  ('0052722','Mexico','Mexico'),
  ('0052735','Mexico','Mexico'),
  ('0052775','Mexico','Mexico'),
  ('0052834','Mexico','Mexico'),
  ('00528440','Mexico','Mexico'),
  ('0052866','Mexico','Mexico'),
  ('0052867','Mexico','Mexico'),
  ('0052868','Mexico','Mexico'),
  ('0052899','Mexico','Mexico'),
  ('0052921','Mexico','Mexico'),
  ('0052951','Mexico','Mexico'),
  ('0052961','Mexico','Mexico'),
  ('0052228','Mexico','Mexico'),
  ('0052229','Mexico','Mexico'),
  ('0052231','Mexico','Mexico'),
  ('0052232','Mexico','Mexico'),
  ('0052238','Mexico','Mexico'),
  ('0052241','Mexico','Mexico'),
  ('00522840','Mexico','Mexico'),
  ('00522841','Mexico','Mexico'),
  ('00522842','Mexico','Mexico'),
  ('00522848','Mexico','Mexico'),
  ('00522849','Mexico','Mexico'),
  ('0052287','Mexico','Mexico'),
  ('0052288','Mexico','Mexico'),
  ('00522941','Mexico','Mexico'),
  ('00522942','Mexico','Mexico'),
  ('00522943','Mexico','Mexico'),
  ('00522944','Mexico','Mexico'),
  ('00522945','Mexico','Mexico'),
  ('00522946','Mexico','Mexico'),
  ('00522947','Mexico','Mexico'),
  ('00522948','Mexico','Mexico'),
  ('00522949','Mexico','Mexico'),
  ('0052313','Mexico','Mexico'),
  ('0052314','Mexico','Mexico'),
  ('0052317','Mexico','Mexico'),
  ('0052322','Mexico','Mexico'),
  ('0052323','Mexico','Mexico'),
  ('0052324','Mexico','Mexico'),
  ('0052325','Mexico','Mexico'),
  ('0052341','Mexico','Mexico'),
  ('0052354','Mexico','Mexico'),
  ('0052355','Mexico','Mexico'),
  ('0052356','Mexico','Mexico'),
  ('0052374','Mexico','Mexico'),
  ('0052381','Mexico','Mexico'),
  ('0052384','Mexico','Mexico'),
  ('0052389','Mexico','Mexico'),
  ('0052393','Mexico','Mexico'),
  ('0052415','Mexico','Mexico'),
  ('0052427','Mexico','Mexico'),
  ('0052434','Mexico','Mexico'),
  ('0052435','Mexico','Mexico'),
  ('0052436','Mexico','Mexico'),
  ('0052438','Mexico','Mexico'),
  ('0052443','Mexico','Mexico'),
  ('0052445','Mexico','Mexico'),
  ('0052451','Mexico','Mexico'),
  ('0052453','Mexico','Mexico'),
  ('0052463','Mexico','Mexico'),
  ('0052464','Mexico','Mexico'),
  ('0052466','Mexico','Mexico'),
  ('0052469','Mexico','Mexico'),
  ('0052472','Mexico','Mexico'),
  ('0052474','Mexico','Mexico'),
  ('0052475','Mexico','Mexico'),
  ('0052481','Mexico','Mexico'),
  ('0052488','Mexico','Mexico'),
  ('0052492','Mexico','Mexico'),
  ('0052494','Mexico','Mexico'),
  ('0052498','Mexico','Mexico'),
  ('0052591','Mexico','Mexico'),
  ('0052612','Mexico','Mexico'),
  ('0052613','Mexico','Mexico'),
  ('0052615','Mexico','Mexico'),
  ('0052616','Mexico','Mexico'),
  ('0052624','Mexico','Mexico'),
  ('0052625','Mexico','Mexico'),
  ('0052626','Mexico','Mexico'),
  ('0052627','Mexico','Mexico'),
  ('0052631','Mexico','Mexico'),
  ('0052632','Mexico','Mexico'),
  ('0052633','Mexico','Mexico'),
  ('0052634','Mexico','Mexico'),
  ('0052636','Mexico','Mexico'),
  ('0052637','Mexico','Mexico'),
  ('0052639','Mexico','Mexico'),
  ('0052641','Mexico','Mexico'),
  ('0052642','Mexico','Mexico'),
  ('0052645','Mexico','Mexico'),
  ('0052646','Mexico','Mexico'),
  ('0052647','Mexico','Mexico'),
  ('0052648','Mexico','Mexico'),
  ('0052653','Mexico','Mexico'),
  ('0052661','Mexico','Mexico'),
  ('0052662','Mexico','Mexico'),
  ('0052665','Mexico','Mexico'),
  ('0052673','Mexico','Mexico'),
  ('0052674','Mexico','Mexico'),
  ('0052676','Mexico','Mexico'),
  ('0052687','Mexico','Mexico'),
  ('0052712','Mexico','Mexico'),
  ('0052713','Mexico','Mexico'),
  ('0052714','Mexico','Mexico'),
  ('0052715','Mexico','Mexico'),
  ('0052721','Mexico','Mexico'),
  ('0052726','Mexico','Mexico'),
  ('0052727','Mexico','Mexico'),
  ('0052728','Mexico','Mexico'),
  ('0052732','Mexico','Mexico'),
  ('0052733','Mexico','Mexico'),
  ('0052736','Mexico','Mexico'),
  ('0052741','Mexico','Mexico'),
  ('0052742','Mexico','Mexico'),
  ('0052747','Mexico','Mexico'),
  ('0052753','Mexico','Mexico'),
  ('0052754','Mexico','Mexico'),
  ('0052755','Mexico','Mexico'),
  ('0052756','Mexico','Mexico'),
  ('0052757','Mexico','Mexico'),
  ('0052758','Mexico','Mexico'),
  ('0052759','Mexico','Mexico'),
  ('0052762','Mexico','Mexico'),
  ('0052771','Mexico','Mexico'),
  ('0052772','Mexico','Mexico');

COMMIT;

INSERT INTO `voip_routes` (`prefix`, `name`, `descr`) VALUES
  ('0052773','Mexico','Mexico'),
  ('0052774','Mexico','Mexico'),
  ('0052779','Mexico','Mexico'),
  ('0052782','Mexico','Mexico'),
  ('0052783','Mexico','Mexico'),
  ('0052786','Mexico','Mexico'),
  ('0052791','Mexico','Mexico'),
  ('0052821','Mexico','Mexico'),
  ('0052823','Mexico','Mexico'),
  ('0052826','Mexico','Mexico'),
  ('0052828','Mexico','Mexico'),
  ('0052829','Mexico','Mexico'),
  ('0052831','Mexico','Mexico'),
  ('0052833','Mexico','Mexico'),
  ('0052836','Mexico','Mexico'),
  ('0052841','Mexico','Mexico'),
  ('0052842','Mexico','Mexico'),
  ('0052861','Mexico','Mexico'),
  ('0052862','Mexico','Mexico'),
  ('0052877','Mexico','Mexico'),
  ('0052878','Mexico','Mexico'),
  ('0052891','Mexico','Mexico'),
  ('0052892','Mexico','Mexico'),
  ('0052916','Mexico','Mexico'),
  ('0052917','Mexico','Mexico'),
  ('0052922','Mexico','Mexico'),
  ('0052938','Mexico','Mexico'),
  ('0052958','Mexico','Mexico'),
  ('0052962','Mexico','Mexico'),
  ('0052965','Mexico','Mexico'),
  ('0052967','Mexico','Mexico'),
  ('0052968','Mexico','Mexico'),
  ('0052971','Mexico','Mexico'),
  ('0052981','Mexico','Mexico'),
  ('0052983','Mexico','Mexico'),
  ('0052986','Mexico','Mexico'),
  ('0052987','Mexico','Mexico'),
  ('0052993','Mexico','Mexico'),
  ('0052998','Mexico','Mexico'),
  ('0052999','Mexico','Mexico'),
  ('0052222','Mexico - Puebla','Mexico - Puebla'),
  ('0052442','Mexico - Queretaro','Mexico - Queretaro'),
  ('0052444','Mexico - San luis Potisi','Mexico - San luis Potisi'),
  ('0052378','Mexico - Tepatitlan','Mexico - Tepatitlan'),
  ('0052664','Mexico - Tijuana','Mexico - Tijuana'),
  ('00521117','Mexico - Torreon','Mexico - Torreon'),
  ('00521194','Mexico - Torreon','Mexico - Torreon'),
  ('0052871','Mexico - Torreon','Mexico - Torreon'),
  ('00691','Micronesia','Micronesia'),
  ('00373','Moldova','Moldova'),
  ('003738','Moldova - Mobile','Moldova - Mobile'),
  ('003739','Moldova - Mobile','Moldova - Mobile'),
  ('00377','Monaco','Monaco'),
  ('003773','Monaco - Mobile','Monaco - Mobile'),
  ('003774','Monaco - Mobile','Monaco - Mobile'),
  ('003776','Monaco - Mobile','Monaco - Mobile'),
  ('003777','Monaco - Mobile','Monaco - Mobile'),
  ('00976','Mongolia','Mongolia'),
  ('001664','Montserrat','Montserrat'),
  ('001664492','Montserrat','Montserrat'),
  ('00212','Morocco','Morocco'),
  ('002121','Morocco Mobile','Morocco Mobile'),
  ('002126','Morocco Mobile','Morocco Mobile'),
  ('00258','Mozambique','Mozambique'),
  ('0025882','Mozambique - Mobile','Mozambique - Mobile'),
  ('0095','Myanmar  Formerly Burma)','Myanmar  Formerly Burma)'),
  ('00264','Namibia','Namibia'),
  ('00674','Nauru','Nauru'),
  ('006748','Nauru - Mobile','Nauru - Mobile'),
  ('00977','Nepal','Nepal'),
  ('0031','Netherlands','Netherlands'),
  ('003120','Netherlands - Amsterdam','Netherlands - Amsterdam'),
  ('00316','Netherlands - Mobile','Netherlands - Mobile'),
  ('00318','Netherlands - Mobile','Netherlands - Mobile'),
  ('00319','Netherlands - Mobile','Netherlands - Mobile'),
  ('00599','Netherlands Antilles','Netherlands Antilles'),
  ('005999','Netherlands Antilles - Curacao','Netherlands Antilles - Curacao'),
  ('005992','Netherlands Antilles - Mobile','Netherlands Antilles - Mobile'),
  ('0059941','Netherlands Antilles - Mobile','Netherlands Antilles - Mobile'),
  ('005995','Netherlands Antilles - Mobile','Netherlands Antilles - Mobile'),
  ('005996','Netherlands Antilles - Mobile','Netherlands Antilles - Mobile'),
  ('005997','Netherlands Antilles - Mobile','Netherlands Antilles - Mobile'),
  ('0059995','Netherlands Antilles - Mobile','Netherlands Antilles - Mobile'),
  ('0059996','Netherlands Antilles - Mobile','Netherlands Antilles - Mobile'),
  ('00687','New Caledonia','New Caledonia'),
  ('0064','New Zealand','New Zealand'),
  ('006421','New Zealand - Mobile','New Zealand - Mobile'),
  ('006422','New Zealand - Mobile','New Zealand - Mobile'),
  ('006423','New Zealand - Mobile','New Zealand - Mobile'),
  ('006424','New Zealand - Mobile','New Zealand - Mobile'),
  ('006425','New Zealand - Mobile','New Zealand - Mobile'),
  ('006426','New Zealand - Mobile','New Zealand - Mobile'),
  ('006427','New Zealand - Mobile','New Zealand - Mobile'),
  ('006428','New Zealand - Mobile','New Zealand - Mobile'),
  ('006429','New Zealand - Mobile','New Zealand - Mobile'),
  ('00648','New Zealand - Mobile','New Zealand - Mobile'),
  ('0064900','New Zealand - Mobile','New Zealand - Mobile'),
  ('00505','Nicaragua','Nicaragua'),
  ('005053','Nicaragua - Mobile','Nicaragua - Mobile'),
  ('0050550','Nicaragua - Mobile','Nicaragua - Mobile'),
  ('00505532','Nicaragua - Mobile','Nicaragua - Mobile'),
  ('0050555','Nicaragua - Mobile','Nicaragua - Mobile'),
  ('005056','Nicaragua - Mobile','Nicaragua - Mobile'),
  ('005057','Nicaragua - Mobile','Nicaragua - Mobile'),
  ('005058','Nicaragua - Mobile','Nicaragua - Mobile'),
  ('005059','Nicaragua - Mobile','Nicaragua - Mobile'),
  ('00227','Niger Republic','Niger Republic'),
  ('0022790','Niger Republic - Mobile','Niger Republic - Mobile'),
  ('00234','Nigeria','Nigeria'),
  ('002341','Nigeria - Lagos','Nigeria - Lagos'),
  ('00234470','Nigeria - Mobile','Nigeria - Mobile'),
  ('00234774','Nigeria - Mobile','Nigeria - Mobile'),
  ('0023490','Nigeria - Mobile','Nigeria - Mobile'),
  ('00683','Niue','Niue'),
  ('006832','Niue - Mobile','Niue - Mobile'),
  ('006835','Niue - Mobile','Niue - Mobile'),
  ('006837','Niue - Mobile','Niue - Mobile'),
  ('006838','Niue - Mobile','Niue - Mobile'),
  ('006723','Norfolk Island','Norfolk Island'),
  ('0047','Norway','Norway'),
  ('00474','Norway - Mobile','Norway - Mobile'),
  ('00478','Norway - Mobile','Norway - Mobile'),
  ('00479','Norway - Mobile','Norway - Mobile'),
  ('00968','Oman','Oman'),
  ('0096893','Oman - Mobile','Oman - Mobile'),
  ('0092','Pakistan','Pakistan'),
  ('009221','Pakistan - Karachi','Pakistan - Karachi'),
  ('009242','Pakistan - Lahore','Pakistan - Lahore'),
  ('00923','Pakistan - Mobile','Pakistan - Mobile'),
  ('00680','Palau. Republic of','Palau. Republic of'),
  ('00970','Palestine','Palestine'),
  ('0097059','Palestine Mobile','Palestine Mobile'),
  ('00507','Panama','Panama'),
  ('00507208','Panama - Mobile','Panama - Mobile'),
  ('00507209','Panama - Mobile','Panama - Mobile'),
  ('00507218','Panama - Mobile','Panama - Mobile'),
  ('00507219','Panama - Mobile','Panama - Mobile'),
  ('00507408','Panama - Mobile','Panama - Mobile'),
  ('00507418','Panama - Mobile','Panama - Mobile'),
  ('005076','Panama - Mobile','Panama - Mobile'),
  ('00507708','Panama - Mobile','Panama - Mobile'),
  ('00507718','Panama - Mobile','Panama - Mobile'),
  ('005078','Panama - Mobile','Panama - Mobile'),
  ('00675','Papua New Guinea','Papua New Guinea'),
  ('0067520','Papua New Guinea - Mobile','Papua New Guinea - Mobile'),
  ('00595','Paraguay','Paraguay'),
  ('0059521','Paraguay - Asuncion','Paraguay - Asuncion'),
  ('005959','Paraguay - Mobile','Paraguay - Mobile'),
  ('0051','Peru','Peru'),
  ('00511','Peru - Lima','Peru - Lima'),
  ('005115','Peru - Mobile','Peru - Mobile'),
  ('005116','Peru - Mobile','Peru - Mobile'),
  ('005117','Peru - Mobile','Peru - Mobile'),
  ('005118','Peru - Mobile','Peru - Mobile'),
  ('005119','Peru - Mobile','Peru - Mobile'),
  ('0051246','Peru - Mobile','Peru - Mobile'),
  ('0051346','Peru - Mobile','Peru - Mobile'),
  ('0051347','Peru - Mobile','Peru - Mobile'),
  ('0051349','Peru - Mobile','Peru - Mobile'),
  ('0051446','Peru - Mobile','Peru - Mobile'),
  ('0051449','Peru - Mobile','Peru - Mobile'),
  ('0051546','Peru - Mobile','Peru - Mobile'),
  ('0051547','Peru - Mobile','Peru - Mobile'),
  ('0051549','Peru - Mobile','Peru - Mobile'),
  ('0051643','Peru - Mobile','Peru - Mobile'),
  ('0051646','Peru - Mobile','Peru - Mobile'),
  ('0051649','Peru - Mobile','Peru - Mobile'),
  ('0051746','Peru - Mobile','Peru - Mobile'),
  ('0051747','Peru - Mobile','Peru - Mobile'),
  ('0051749','Peru - Mobile','Peru - Mobile'),
  ('0051846','Peru - Mobile','Peru - Mobile'),
  ('0051847','Peru - Mobile','Peru - Mobile'),
  ('0051849','Peru - Mobile','Peru - Mobile'),
  ('0051946','Peru - Mobile','Peru - Mobile'),
  ('0051947','Peru - Mobile','Peru - Mobile'),
  ('0051949','Peru - Mobile','Peru - Mobile'),
  ('0063','Philippines','Philippines'),
  ('00632','Philippines - Manila','Philippines - Manila'),
  ('0063241','Philippines - Mobile','Philippines - Mobile'),
  ('0063242','Philippines - Mobile','Philippines - Mobile'),
  ('006327','Philippines - Mobile','Philippines - Mobile'),
  ('0063291','Philippines - Mobile','Philippines - Mobile'),
  ('006330','Philippines - Mobile','Philippines - Mobile'),
  ('006332','Philippines - Mobile','Philippines - Mobile'),
  ('006335','Philippines - Mobile','Philippines - Mobile'),
  ('006336','Philippines - Mobile','Philippines - Mobile'),
  ('006340','Philippines - Mobile','Philippines - Mobile'),
  ('006342','Philippines - Mobile','Philippines - Mobile'),
  ('006343','Philippines - Mobile','Philippines - Mobile'),
  ('006344','Philippines - Mobile','Philippines - Mobile'),
  ('006345','Philippines - Mobile','Philippines - Mobile'),
  ('006346','Philippines - Mobile','Philippines - Mobile'),
  ('006347','Philippines - Mobile','Philippines - Mobile'),
  ('00635','Philippines - Mobile','Philippines - Mobile'),
  ('006360','Philippines - Mobile','Philippines - Mobile'),
  ('006362','Philippines - Mobile','Philippines - Mobile'),
  ('006364','Philippines - Mobile','Philippines - Mobile'),
  ('006365','Philippines - Mobile','Philippines - Mobile'),
  ('006370','Philippines - Mobile','Philippines - Mobile'),
  ('006372','Philippines - Mobile','Philippines - Mobile'),
  ('006380','Philippines - Mobile','Philippines - Mobile'),
  ('006385','Philippines - Mobile','Philippines - Mobile'),
  ('00639','Philippines - Mobile','Philippines - Mobile'),
  ('0048','Poland','Poland'),
  ('004812','Poland - Krakow','Poland - Krakow'),
  ('004850','Poland - Mobile Special/Services','Poland - Mobile Special/Services'),
  ('004860','Poland - Mobile Special/Services','Poland - Mobile Special/Services'),
  ('0048701','Poland - Mobile Special/Services','Poland - Mobile Special/Services'),
  ('004890','Poland - Mobile Special/Services','Poland - Mobile Special/Services'),
  ('004822','Poland - Warsaw','Poland - Warsaw'),
  ('0048800','Poland - freephone','Poland - freephone'),
  ('00351','Portugal','Portugal'),
  ('003511','Portugal - Lisbon','Portugal - Lisbon'),
  ('0035160','Portugal - Mobile','Portugal - Mobile'),
  ('0035164','Portugal - Mobile','Portugal - Mobile'),
  ('00351676','Portugal - Mobile','Portugal - Mobile'),
  ('003519','Portugal - Mobile','Portugal - Mobile'),
  ('001787','Puerto Rico','Puerto Rico'),
  ('00974','Qatar','Qatar'),
  ('0097422','Qatar - Mobile','Qatar - Mobile'),
  ('0097453','Qatar - Mobile','Qatar - Mobile'),
  ('0097455','Qatar - Mobile','Qatar - Mobile'),
  ('0097458','Qatar - Mobile','Qatar - Mobile'),
  ('0097459','Qatar - Mobile','Qatar - Mobile'),
  ('00262','Reunion Island','Reunion Island'),
  ('0040','Romania','Romania'),
  ('00401','Romania - Bucharest','Romania - Bucharest'),
  ('00407','Romania - Mobile','Romania - Mobile'),
  ('00409','Romania - Mobile','Romania - Mobile'),
  ('007','Russia','Russia'),
  ('007901','Russia - Mobile','Russia - Mobile'),
  ('007902','Russia - Mobile','Russia - Mobile'),
  ('007903','Russia - Mobile','Russia - Mobile'),
  ('007095','Russia - Moscow','Russia - Moscow'),
  ('00750','Russia - Overlay','Russia - Overlay'),
  ('00751','Russia - Overlay','Russia - Overlay'),
  ('00752','Russia - Overlay','Russia - Overlay'),
  ('00753','Russia - Overlay','Russia - Overlay'),
  ('00754','Russia - Overlay','Russia - Overlay'),
  ('00755','Russia - Overlay','Russia - Overlay'),
  ('00756','Russia - Overlay','Russia - Overlay'),
  ('007572','Russia - Overlay','Russia - Overlay'),
  ('007573','Russia - Overlay','Russia - Overlay'),
  ('007574','Russia - Overlay','Russia - Overlay'),
  ('007575','Russia - Overlay','Russia - Overlay'),
  ('007576','Russia - Overlay','Russia - Overlay'),
  ('007577','Russia - Overlay','Russia - Overlay'),
  ('007578','Russia - Overlay','Russia - Overlay'),
  ('007579','Russia - Overlay','Russia - Overlay'),
  ('00758','Russia - Overlay','Russia - Overlay'),
  ('00759','Russia - Overlay','Russia - Overlay'),
  ('007812','Russia - St. Petersburg','Russia - St. Petersburg'),
  ('00250','Rwanda','Rwanda'),
  ('00378','San Marino','San Marino'),
  ('003786','San Marino - Mobile','San Marino - Mobile'),
  ('00239','Sao Tome','Sao Tome'),
  ('00966','Saudi Arabia','Saudi Arabia'),
  ('0096654','Saudi Arabia - Mobile','Saudi Arabia - Mobile'),
  ('0096655','Saudi Arabia - Mobile','Saudi Arabia - Mobile'),
  ('0096694','Saudi Arabia - Mobile','Saudi Arabia - Mobile'),
  ('0096695','Saudi Arabia - Mobile','Saudi Arabia - Mobile'),
  ('00221','Senegal Republic','Senegal Republic'),
  ('002216','Senegal Republic - Mobile','Senegal Republic - Mobile'),
  ('00248','Seychelles Islands','Seychelles Islands'),
  ('002485','Seychelles Islands - Mobile','Seychelles Islands - Mobile'),
  ('002487','Seychelles Islands - Mobile','Seychelles Islands - Mobile'),
  ('00232','Sierra Leone','Sierra Leone'),
  ('0023222','Sierra Leone - Freetown','Sierra Leone - Freetown'),
  ('0023190','Sierra Leone - Mobile','Sierra Leone - Mobile'),
  ('0065','Singapore','Singapore'),
  ('00659','Singapore - Mobile','Singapore - Mobile'),
  ('00421','Slovak Republic','Slovak Republic'),
  ('004219','Slovak Republic - Mobile','Slovak Republic - Mobile'),
  ('00386','Slovenia','Slovenia'),
  ('0038631','Slovenia - Mobile','Slovenia - Mobile'),
  ('003864','Slovenia - Mobile','Slovenia - Mobile'),
  ('0038651','Slovenia - Mobile','Slovenia - Mobile'),
  ('00386609','Slovenia - Mobile','Slovenia - Mobile'),
  ('00677','Solomon Islands','Solomon Islands'),
  ('006771','Solomon Islands - Mobile','Solomon Islands - Mobile'),
  ('006778','Solomon Islands - Mobile','Solomon Islands - Mobile'),
  ('006779','Solomon Islands - Mobile','Solomon Islands - Mobile'),
  ('00252','Somalia','Somalia'),
  ('0027','South Africa','South Africa'),
  ('002721','South Africa - Capetown','South Africa - Capetown'),
  ('002711','South Africa - Johannesburg','South Africa - Johannesburg'),
  ('002772','South Africa - Mobile','South Africa - Mobile'),
  ('002773','South Africa - Mobile','South Africa - Mobile'),
  ('002781','South Africa - Mobile','South Africa - Mobile'),
  ('002782','South Africa - Mobile','South Africa - Mobile'),
  ('002783','South Africa - Mobile','South Africa - Mobile'),
  ('002784','South Africa - Mobile','South Africa - Mobile'),
  ('0034','Spain','Spain'),
  ('003493','Spain - Barcelona','Spain - Barcelona'),
  ('003491','Spain - Madrid','Spain - Madrid'),
  ('00346','Spain - Mobile','Spain - Mobile'),
  ('0094','Sri Lanka','Sri Lanka'),
  ('00947','Sri Lanka - Mobile','Sri Lanka - Mobile'),
  ('00290','St. Helena','St. Helena'),
  ('001869','St. Kitts/Nevis','St. Kitts/Nevis'),
  ('001758','St. Lucia','St. Lucia'),
  ('00508','St. Pierre/Miquelon','St. Pierre/Miquelon'),
  ('001784','St. Vincent/Grenadines','St. Vincent/Grenadines'),
  ('00249','Sudan','Sudan'),
  ('00597','Suriname','Suriname'),
  ('005971','Suriname - Mobile','Suriname - Mobile'),
  ('005977','Suriname - Mobile','Suriname - Mobile'),
  ('005978','Suriname - Mobile','Suriname - Mobile'),
  ('00268','Swaziland','Swaziland'),
  ('0046','Sweden','Sweden'),
  ('004610','Sweden - Mobile','Sweden - Mobile'),
  ('004620','Sweden - Mobile','Sweden - Mobile'),
  ('004670','Sweden - Mobile','Sweden - Mobile'),
  ('004671','Sweden - Mobile','Sweden - Mobile'),
  ('004672','Sweden - Mobile','Sweden - Mobile'),
  ('004673','Sweden - Mobile','Sweden - Mobile'),
  ('004677','Sweden - Mobile','Sweden - Mobile'),
  ('0046900','Sweden - Mobile','Sweden - Mobile'),
  ('0046939','Sweden - Mobile','Sweden - Mobile'),
  ('0046944','Sweden - Mobile','Sweden - Mobile'),
  ('00468','Sweden - Stockholm','Sweden - Stockholm'),
  ('0041','Switzerland','Switzerland'),
  ('004120','Switzerland - Mobile','Switzerland - Mobile'),
  ('004140','Switzerland - Mobile','Switzerland - Mobile'),
  ('004150','Switzerland - Mobile','Switzerland - Mobile'),
  ('004170','Switzerland - Mobile','Switzerland - Mobile'),
  ('004171','Switzerland - Mobile','Switzerland - Mobile'),
  ('004174','Switzerland - Mobile','Switzerland - Mobile'),
  ('004176','Switzerland - Mobile','Switzerland - Mobile'),
  ('004177','Switzerland - Mobile','Switzerland - Mobile'),
  ('004178','Switzerland - Mobile','Switzerland - Mobile'),
  ('004179','Switzerland - Mobile','Switzerland - Mobile'),
  ('004180','Switzerland - Mobile','Switzerland - Mobile'),
  ('004184','Switzerland - Mobile','Switzerland - Mobile'),
  ('004186','Switzerland - Mobile','Switzerland - Mobile'),
  ('004189','Switzerland - Mobile','Switzerland - Mobile'),
  ('004190','Switzerland - Mobile','Switzerland - Mobile'),
  ('004198','Switzerland - Mobile','Switzerland - Mobile'),
  ('004199','Switzerland - Mobile','Switzerland - Mobile'),
  ('00963','Syrian Arab Republic','Syrian Arab Republic'),
  ('00886','Taiwan','Taiwan'),
  ('0088660','Taiwan - Mobile','Taiwan - Mobile'),
  ('008869','Taiwan - Mobile','Taiwan - Mobile'),
  ('008866','Taiwan - Tainan','Taiwan - Tainan'),
  ('008862','Taiwan - Taipei','Taiwan - Taipei'),
  ('00992','Tajikistan','Tajikistan'),
  ('0099291','Tajikistan - Mobile','Tajikistan - Mobile'),
  ('00255','Tanzania','Tanzania'),
  ('0066','Thailand','Thailand'),
  ('00662','Thailand - Bangkok','Thailand - Bangkok'),
  ('00661','Thailand - Mobile','Thailand - Mobile'),
  ('00669','Thailand - Mobile','Thailand - Mobile'),
  ('00228','Togo','Togo'),
  ('00690','Tokelau','Tokelau'),
  ('006905','Tokelau - Mobile','Tokelau - Mobile'),
  ('006906','Tokelau - Mobile','Tokelau - Mobile'),
  ('006907','Tokelau - Mobile','Tokelau - Mobile'),
  ('006908','Tokelau - Mobile','Tokelau - Mobile'),
  ('00676','Tonga Islands','Tonga Islands'),
  ('0067656','Tonga Islands - Mobile','Tonga Islands - Mobile'),
  ('001868','Trinidad & Tobago','Trinidad & Tobago'),
  ('001868678','Trinidad & Tobago - Mobile','Trinidad & Tobago - Mobile'),
  ('00186868','Trinidad & Tobago - Mobile','Trinidad & Tobago - Mobile'),
  ('00216','Tunisia','Tunisia'),
  ('0021652','Tunisia - Mobile','Tunisia - Mobile'),
  ('0021672','Tunisia - Mobile','Tunisia - Mobile'),
  ('0090','Turkey','Turkey'),
  ('0090212','Turkey - Istanbul','Turkey - Istanbul'),
  ('0090216','Turkey - Istanbul','Turkey - Istanbul'),
  ('00905','Turkey - Mobile','Turkey - Mobile'),
  ('0090900','Turkey - Mobile','Turkey - Mobile'),
  ('00993','Turkmenistan','Turkmenistan'),
  ('0099331','Turkmenistan - Mobile','Turkmenistan - Mobile'),
  ('0099332','Turkmenistan - Mobile','Turkmenistan - Mobile'),
  ('0099333','Turkmenistan - Mobile','Turkmenistan - Mobile'),
  ('0099334','Turkmenistan - Mobile','Turkmenistan - Mobile'),
  ('001649','Turks & Caicos','Turks & Caicos'),
  ('00688','Tuvalu','Tuvalu'),
  ('006886','Tuvalu- Mobile','Tuvalu- Mobile'),
  ('006887','Tuvalu- Mobile','Tuvalu- Mobile'),
  ('006888','Tuvalu- Mobile','Tuvalu- Mobile'),
  ('00256','Uganda','Uganda'),
  ('0025675','Uganda - Mobile','Uganda - Mobile'),
  ('0025677','Uganda - Mobile','Uganda - Mobile'),
  ('0025678','Uganda - Mobile','Uganda - Mobile'),
  ('00380','Ukraine','Ukraine'),
  ('0038044','Ukraine - Kiev','Ukraine - Kiev'),
  ('0038050','Ukraine Mobile','Ukraine Mobile'),
  ('003806','Ukraine Mobile','Ukraine Mobile'),
  ('00971','United Arab Emirates','United Arab Emirates'),
  ('0097150','United Arab Emirates - Mobile','United Arab Emirates - Mobile'),
  ('0044','United Kingdom','United Kingdom'),
  ('0044700','United Kingdom - Audiotext','United Kingdom - Audiotext'),
  ('0044707','United Kingdom - Audiotext','United Kingdom - Audiotext'),
  ('0044207','United Kingdom - London','United Kingdom - London'),
  ('0044208','United Kingdom - London','United Kingdom - London'),
  ('00440','United Kingdom - Mobile','United Kingdom - Mobile'),
  ('00443','United Kingdom - Mobile','United Kingdom - Mobile'),
  ('00444','United Kingdom - Mobile','United Kingdom - Mobile'),
  ('00445','United Kingdom - Mobile','United Kingdom - Mobile'),
  ('00446','United Kingdom - Mobile','United Kingdom - Mobile'),
  ('00447','United Kingdom - Mobile','United Kingdom - Mobile'),
  ('00448','United Kingdom - Mobile','United Kingdom - Mobile'),
  ('00449','United Kingdom - Mobile','United Kingdom - Mobile'),
  ('00598','Uruguay','Uruguay'),
  ('005982','Uruguay - Mobile','Uruguay - Mobile'),
  ('005989','Uruguay - Mobile','Uruguay - Mobile'),
  ('001907','US - Alaska','US - Alaska'),
  ('001','US - Continental','US - Continental'),
  ('001808','US - Hawaii','US - Hawaii'),
  ('001670','US - Midway and Wake Island','US - Midway and Wake Island'),
  ('001340','US Virgin Islands','US Virgin Islands'),
  ('00998','Uzbekistan','Uzbekistan'),
  ('00678','Vanuatu. Republic of','Vanuatu. Republic of'),
  ('006785','Vanuatu. Republic of - Mobile','Vanuatu. Republic of - Mobile'),
  ('006786','Vanuatu. Republic of - Mobile','Vanuatu. Republic of - Mobile'),
  ('006787','Vanuatu. Republic of - Mobile','Vanuatu. Republic of - Mobile'),
  ('0058','Venezuela','Venezuela'),
  ('0058212','Venezuela - Caracas','Venezuela - Caracas'),
  ('005812','Venezuela - Mobile','Venezuela - Mobile'),
  ('005814','Venezuela - Mobile','Venezuela - Mobile'),
  ('005815','Venezuela - Mobile','Venezuela - Mobile'),
  ('005816','Venezuela - Mobile','Venezuela - Mobile'),
  ('005817','Venezuela - Mobile','Venezuela - Mobile'),
  ('005818','Venezuela - Mobile','Venezuela - Mobile'),
  ('005823','Venezuela - Mobile','Venezuela - Mobile'),
  ('0058412','Venezuela - Mobile','Venezuela - Mobile'),
  ('0058414','Venezuela - Mobile','Venezuela - Mobile'),
  ('0058415','Venezuela - Mobile','Venezuela - Mobile'),
  ('0058416','Venezuela - Mobile','Venezuela - Mobile'),
  ('0058417','Venezuela - Mobile','Venezuela - Mobile'),
  ('0058418','Venezuela - Mobile','Venezuela - Mobile'),
  ('0084','Vietnam','Vietnam'),
  ('00848','Vietnam - Ho Chi Min City','Vietnam - Ho Chi Min City'),
  ('008480','Vietnam - Mobile','Vietnam - Mobile'),
  ('008481','Vietnam - Mobile','Vietnam - Mobile'),
  ('008485','Vietnam - Mobile','Vietnam - Mobile'),
  ('008488','Vietnam - Mobile','Vietnam - Mobile'),
  ('008489','Vietnam - Mobile','Vietnam - Mobile'),
  ('00849','Vietnam - Mobile','Vietnam - Mobile'),
  ('00681','Wallis & Futuna Islands','Wallis & Futuna Islands'),
  ('00685','Western Samoa','Western Samoa'),
  ('00967','Yemen Arab Republic','Yemen Arab Republic'),
  ('00381','Yugoslavia  incl. Serbia)','Yugoslavia  incl. Serbia)'),
  ('0038116','Yugoslavia Mobile','Yugoslavia Mobile'),
  ('003816','Yugoslavia Mobile','Yugoslavia Mobile'),
  ('00243','Zaire. Republic of','Zaire. Republic of'),
  ('0024322','Zaire. Republic of - Mobile','Zaire. Republic of - Mobile'),
  ('0024378','Zaire. Republic of - Mobile','Zaire. Republic of - Mobile'),
  ('0024381','Zaire. Republic of - Mobile','Zaire. Republic of - Mobile'),
  ('0024384','Zaire. Republic of - Mobile','Zaire. Republic of - Mobile'),
  ('0024388','Zaire. Republic of - Mobile','Zaire. Republic of - Mobile'),
  ('0024397','Zaire. Republic of - Mobile','Zaire. Republic of - Mobile'),
  ('0024398','Zaire. Republic of - Mobile','Zaire. Republic of - Mobile'),
  ('0024399','Zaire. Republic of - Mobile','Zaire. Republic of - Mobile'),
  ('00260','Zambia','Zambia'),
  ('00263','Zimbabwe','Zimbabwe'),
  ('0026311','Zimbabwe - Mobile','Zimbabwe - Mobile'),
  ('0026323','Zimbabwe - Mobile','Zimbabwe - Mobile'),
  ('0026391','Zimbabwe - Mobile','Zimbabwe - Mobile'),
  ('009821','Iran - Teheran','Iran - Teheran'),
  ('00551177','Brazil - Mobile','Brazil - Mobile'),
  ('00551178','Brazil - Mobile','Brazil - Mobile'),
  ('00551278','Brazil - Mobile','Brazil - Mobile'),
  ('00551378','Brazil - Mobile','Brazil - Mobile'),
  ('00551979','Brazil - Mobile','Brazil - Mobile'),
  ('0055216','Brazil - Mobile','Brazil - Mobile'),
  ('00552178','Brazil - Mobile','Brazil - Mobile'),
  ('0055369','Brazil - Mobile','Brazil - Mobile'),
  ('00554178','Brazil - Mobile','Brazil - Mobile'),
  ('00555178','Brazil - Mobile','Brazil - Mobile'),
  ('0055569','Brazil - Mobile','Brazil - Mobile'),
  ('0055579','Brazil - Mobile','Brazil - Mobile'),
  ('0055589','Brazil - Mobile','Brazil - Mobile'),
  ('0055599','Brazil - Mobile','Brazil - Mobile'),
  ('00556178','Brazil - Mobile','Brazil - Mobile'),
  ('0055729','Brazil - Mobile','Brazil - Mobile'),
  ('0055789','Brazil - Mobile','Brazil - Mobile'),
  ('0088670','Taiwan - Mobile','Taiwan - Mobile'),
  ('003296','Belgium - Mobile','Belgium - Mobile'),
  ('8','Inzone H323','Inzone H323'),
  ('7','Inzone','Inzone'),
  ('99','Free World Dialup','Free World Dialup'),
  ('1','Groups','Groups'),
  ('002236','Mali Mobile','Mali Mobile'),
  ('002241','Guinea Mobile','Guinea Mobile'),
  ('002360','Central African Republic Mobile','Central African Republic Mobile'),
  ('002557','Tanzania Mobile','Tanzania Mobile'),
  ('0022263','Mauritania Mobile','Mauritania Mobile'),
  ('0022264','Mauritania Mobile','Mauritania Mobile'),
  ('002314','Liberia Mobile','Liberia Mobile'),
  ('002316','Liberia Mobile','Liberia Mobile'),
  ('002422','Congo Mobile','Congo Mobile'),
  ('002423','Congo Mobile','Congo Mobile'),
  ('002424','Congo Mobile','Congo Mobile'),
  ('002425','Congo Mobile','Congo Mobile'),
  ('002426','Congo Mobile','Congo Mobile');

COMMIT;

INSERT INTO `voip_routes` (`prefix`, `name`, `descr`) VALUES
  ('9','Services','Services');
