INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Palestinian Settlements','970','164');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Panama','507','165');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Papua New Guinea','675','166');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Paraguay','595','167');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Peru','51','168');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Philippines','63','169');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Poland','48','171');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Portugal','351','172');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Puerto Rico','1787','173');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Qatar','974','174');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Réunion Island','262','175');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Romania','40','176');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Russia','7','177');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Rwandese Republic','250','178');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('St. Helena','290','179');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('St. Kitts/Nevis','1869','180');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('St. Lucia','1758','181');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('St. Pierre & Miquelon','508','182');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('St. Vincent & Grenadines','1784','183');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('San Marino','378','185');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('S?o Tomé and Principe','239','186');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Saudi Arabia','966','187');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Senegal','221','188');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Serbia and Montenegro','381',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Seychelles Republic','248','189');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Sierra Leone','232','190');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Singapore','65','191');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Slovak Republic','421','192');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Slovenia','386','193');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Solomon Islands','677','194');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Somali Democratic Republic','252','195');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('South Africa','27','196');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Spain','34','198');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Sri Lanka','94','199');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Sudan','249','200');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Suriname','597','201');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Swaziland','268','203');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Sweden','46','204');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Switzerland','41','205');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Syria','963','206');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Taiwan','886','207');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Tajikistan','992','208');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Tanzania','255','209');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Thailand','66','210');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Thuraya (Mobile Satellite service)','88216',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Togolese Republic','228','212');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Tokelau','690','213');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Tonga Islands','676','214');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Trinidad & Tobago','1868','215');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Tunisia','216','216');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Turkey','90','217');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Turkmenistan','993','218');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Turks and Caicos Islands','1649','219');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Tuvalu','688','220');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Uganda','256','221');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Ukraine','380','222');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('United Arab Emirates','971','223');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('United Kingdom','44','224');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('United States of America','1','225');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('US Virgin Islands','1340','225');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Universal Personal Telecommunications (UPT)','878',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Uruguay','598','227');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Uzbekistan','998','228');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Vanuatu','678','229');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Vatican City','39',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela','58','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela Etelix','58102','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela http://www.multiphone.net.ve','58107','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela CANTV','58110','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela Convergence Comunications','58111','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela Telcel, C.A.','58114','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela Totalcom Venezuela','58119','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela Orbitel de Venezuela, C.A. ENTEL Venezuela','58123','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela LD Telecomunicaciones, C.A.','58150','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela Telecomunicaciones NGTV','58133','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Venezuela Veninfotel Comunicaciones','58199','230');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Vietnam','84','231');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Wake Island','808',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Wallis and Futuna Islands','681',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Western Samoa','685','184');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Yemen','967','236');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Zambia','260','238');INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Zanzibar','255',NULL);INSERT INTO cc_prefix (destination,prefixe,id_cc_country) VALUES ('Zimbabwe','263','239');ALTER TABLE cc_country ADD COLUMN countryprefix VARCHAR(10) NOT NULL DEFAULT 0;UPDATE cc_country SET countryprefix = '93' WHERE id = '1';UPDATE cc_country SET countryprefix = '355' WHERE id = '2';UPDATE cc_country SET countryprefix = '213' WHERE id = '3';UPDATE cc_country SET countryprefix = '684' WHERE id = '4';UPDATE cc_country SET countryprefix = '376' WHERE id = '5';UPDATE cc_country SET countryprefix = '244' WHERE id = '6';UPDATE cc_country SET countryprefix = '1264' WHERE id = '7';UPDATE cc_country SET countryprefix = '672' WHERE id = '8';UPDATE cc_country SET countryprefix = '54' WHERE id = '10';UPDATE cc_country SET countryprefix = '374' WHERE id = '11';UPDATE cc_country SET countryprefix = '297' WHERE id = '12';UPDATE cc_country SET countryprefix = '61' WHERE id = '13';UPDATE cc_country SET countryprefix = '43' WHERE id = '14';UPDATE cc_country SET countryprefix = '994' WHERE id = '15';UPDATE cc_country SET countryprefix = '1242' WHERE id = '16';UPDATE cc_country SET countryprefix = '973' WHERE id = '17';UPDATE cc_country SET countryprefix = '880' WHERE id = '18';UPDATE cc_country SET countryprefix = '1246' WHERE id = '19';UPDATE cc_country SET countryprefix = '375' WHERE id = '20';UPDATE cc_country SET countryprefix = '32' WHERE id = '21';UPDATE cc_country SET countryprefix = '501' WHERE id = '22';UPDATE cc_country SET countryprefix = '229' WHERE id = '23';UPDATE cc_country SET countryprefix = '1441' WHERE id = '24';UPDATE cc_country SET countryprefix = '975' WHERE id = '25';UPDATE cc_country SET countryprefix = '591' WHERE id = '26';UPDATE cc_country SET countryprefix = '387' WHERE id = '27';UPDATE cc_country SET countryprefix = '267' WHERE id = '28';UPDATE cc_country SET countryprefix = '55' WHERE id = '30';UPDATE cc_country SET countryprefix = '1284' WHERE id = '31';UPDATE cc_country SET countryprefix = '673' WHERE id = '32';UPDATE cc_country SET countryprefix = '359' WHERE id = '33';UPDATE cc_country SET countryprefix = '226' WHERE id = '34';UPDATE cc_country SET countryprefix = '257' WHERE id = '35';UPDATE cc_country SET countryprefix = '855' WHERE id = '36';UPDATE cc_country SET countryprefix = '237' WHERE id = '37';UPDATE cc_country SET countryprefix = '1' WHERE id = '38';UPDATE cc_country SET countryprefix = '238' WHERE id = '39';UPDATE cc_country SET countryprefix = '1345' WHERE id = '40';UPDATE cc_country SET countryprefix = '236' WHERE id = '41';UPDATE cc_country SET countryprefix = '235' WHERE id = '42';UPDATE cc_country SET countryprefix = '56' WHERE id = '43';UPDATE cc_country SET countryprefix = '86' WHERE id = '44';UPDATE cc_country SET countryprefix = '618' WHERE id = '45';UPDATE cc_country SET countryprefix = '61' WHERE id = '46';UPDATE cc_country SET countryprefix = '57' WHERE id = '47';UPDATE cc_country SET countryprefix = '269' WHERE id = '48';UPDATE cc_country SET countryprefix = '242' WHERE id = '49';UPDATE cc_country SET countryprefix = '243' WHERE id = '50';UPDATE cc_country SET countryprefix = '682' WHERE id = '51';UPDATE cc_country SET countryprefix = '506' WHERE id = '52';UPDATE cc_country SET countryprefix = '225' WHERE id = '53';UPDATE cc_country SET countryprefix = '385' WHERE id = '54';UPDATE cc_country SET countryprefix = '53' WHERE id = '55';UPDATE cc_country SET countryprefix = '357' WHERE id = '56';UPDATE cc_country SET countryprefix = '420' WHERE id = '57';UPDATE cc_country SET countryprefix = '45' WHERE id = '58';UPDATE cc_country SET countryprefix = '246' WHERE id = '241';UPDATE cc_country SET countryprefix = '253' WHERE id = '59';UPDATE cc_country SET countryprefix = '1767' WHERE id = '60';UPDATE cc_country SET countryprefix = '1809' WHERE id = '61';UPDATE cc_country SET countryprefix = '593' WHERE id = '62';UPDATE cc_country SET countryprefix = '20' WHERE id = '63';UPDATE cc_country SET countryprefix = '503' WHERE id = '64';UPDATE cc_country SET countryprefix = '240' WHERE id = '65';UPDATE cc_country SET countryprefix = '291' WHERE id = '66';UPDATE cc_country SET countryprefix = '372' WHERE id = '67';UPDATE cc_country SET countryprefix = '251' WHERE id = '68';UPDATE cc_country SET countryprefix = '500' WHERE id = '69';UPDATE cc_country SET countryprefix = '298' WHERE id = '70';UPDATE cc_country SET countryprefix = '679' WHERE id = '71';UPDATE cc_country SET countryprefix = '358' WHERE id = '72';UPDATE cc_country SET countryprefix = '33' WHERE id = '73';UPDATE cc_country SET countryprefix = '596' WHERE id = '74';UPDATE cc_country SET countryprefix = '594' WHERE id = '75';UPDATE cc_country SET countryprefix = '689' WHERE id = '76';UPDATE cc_country SET countryprefix = '241' WHERE id = '77';UPDATE cc_country SET countryprefix = '220' WHERE id = '78';UPDATE cc_country SET countryprefix = '995' WHERE id = '79';UPDATE cc_country SET countryprefix = '49' WHERE id = '80';UPDATE cc_country SET countryprefix = '233' WHERE id = '81';UPDATE cc_country SET countryprefix = '350' WHERE id = '82';UPDATE cc_country SET countryprefix = '30' WHERE id = '83';UPDATE cc_country SET countryprefix = '299' WHERE id = '84';UPDATE cc_country SET countryprefix = '1473' WHERE id = '85';UPDATE cc_country SET countryprefix = '590' WHERE id = '86';UPDATE cc_country SET countryprefix = '1671' WHERE id = '87';UPDATE cc_country SET countryprefix = '502' WHERE id = '88';UPDATE cc_country SET countryprefix = '245' WHERE id = '90';UPDATE cc_country SET countryprefix = '224' WHERE id = '89';UPDATE cc_country SET countryprefix = '592' WHERE id = '91';UPDATE cc_country SET countryprefix = '509' WHERE id = '92';UPDATE cc_country SET countryprefix = '504' WHERE id = '95';UPDATE cc_country SET countryprefix = '852' WHERE id = '96';UPDATE cc_country SET countryprefix = '36' WHERE id = '97';UPDATE cc_country SET countryprefix = '354' WHERE id = '98';UPDATE cc_country SET countryprefix = '91' WHERE id = '99';UPDATE cc_country SET countryprefix = '62' WHERE id = '100';UPDATE cc_country SET countryprefix = '98' WHERE id = '101';UPDATE cc_country SET countryprefix = '964' WHERE id = '102';UPDATE cc_country SET countryprefix = '353' WHERE id = '103';UPDATE cc_country SET countryprefix = '972' WHERE id = '104';UPDATE cc_country SET countryprefix = '39' WHERE id = '105';UPDATE cc_country SET countryprefix = '1876' WHERE id = '106';UPDATE cc_country SET countryprefix = '81' WHERE id = '107';UPDATE cc_country SET countryprefix = '962' WHERE id = '108';UPDATE cc_country SET countryprefix = '7' WHERE id = '109';UPDATE cc_country SET countryprefix = '254' WHERE id = '110';UPDATE cc_country SET countryprefix = '686' WHERE id = '111';UPDATE cc_country SET countryprefix = '850' WHERE id = '112';UPDATE cc_country SET countryprefix = '82' WHERE id = '113';UPDATE cc_country SET countryprefix = '965' WHERE id = '114';UPDATE cc_country SET countryprefix = '996' WHERE id = '115';UPDATE cc_country SET countryprefix = '856' WHERE id = '116';UPDATE cc_country SET countryprefix = '371' WHERE id = '117';UPDATE cc_country SET countryprefix = '961' WHERE id = '118';UPDATE cc_country SET countryprefix = '266' WHERE id = '119';UPDATE cc_country SET countryprefix = '231' WHERE id = '120';UPDATE cc_country SET countryprefix = '218' WHERE id = '121';UPDATE cc_country SET countryprefix = '423' WHERE id = '122';UPDATE cc_country SET countryprefix = '370' WHERE id = '123';UPDATE cc_country SET countryprefix = '352' WHERE id = '124';UPDATE cc_country SET countryprefix = '853' WHERE id = '125';UPDATE cc_country SET countryprefix = '389' WHERE id = '126';UPDATE cc_country SET countryprefix = '261' WHERE id = '127';UPDATE cc_country SET countryprefix = '265' WHERE id = '128';UPDATE cc_country SET countryprefix = '60' WHERE id = '129';UPDATE cc_country SET countryprefix = '960' WHERE id = '130';UPDATE cc_country SET countryprefix = '223' WHERE id = '131';UPDATE cc_country SET countryprefix = '356' WHERE id = '132';UPDATE cc_country SET countryprefix = '692' WHERE id = '133';UPDATE cc_country SET countryprefix = '596' WHERE id = '134';UPDATE cc_country SET countryprefix = '222' WHERE id = '135';UPDATE cc_country SET countryprefix = '230' WHERE id = '136';UPDATE cc_country SET countryprefix = '269' WHERE id = '137';UPDATE cc_country SET countryprefix = '52' WHERE id = '138';UPDATE cc_country SET countryprefix = '691' WHERE id = '139';UPDATE cc_country SET countryprefix = '1808' WHERE id = '140';UPDATE cc_country SET countryprefix = '377' WHERE id = '141';UPDATE cc_country SET countryprefix = '976' WHERE id = '142';UPDATE cc_country SET countryprefix = '1664' WHERE id = '143';UPDATE cc_country SET countryprefix = '212' WHERE id = '144';UPDATE cc_country SET countryprefix = '258' WHERE id = '145';UPDATE cc_country SET countryprefix = '95' WHERE id = '146';UPDATE cc_country SET countryprefix = '264' WHERE id = '147';UPDATE cc_country SET countryprefix = '674' WHERE id = '148';UPDATE cc_country SET countryprefix = '977' WHERE id = '149';