-- phpMyAdmin SQL Dump
-- version 4.7.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 25, 2019 at 10:29 AM
-- Server version: 5.6.36-82.1-log
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `hgapps94_emc`
--

-- --------------------------------------------------------

--
-- Table structure for table `emc_countries`
--

CREATE TABLE `emc_countries` (
  `code` char(2) NOT NULL DEFAULT '',
  `prefixe` varchar(10) NOT NULL DEFAULT '',
  `pays` varchar(128) NOT NULL DEFAULT '',
  `pays_min` varchar(128) NOT NULL,
  `capitale` varchar(128) NOT NULL DEFAULT '',
  `code_continent` char(3) NOT NULL DEFAULT '',
  `translate` tinyint(1) NOT NULL DEFAULT '0',
  `id_language` char(2) NOT NULL,
  `language` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `emc_countries`
--

INSERT INTO `emc_countries` (`code`, `prefixe`, `pays`, `pays_min`, `capitale`, `code_continent`, `translate`, `id_language`, `language`) VALUES
('AD', '376', 'ANDORRA', 'Andorra', 'Andorra la Vella', 'EU', 0, '', 'CATALAN'),
('AE', '971', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'Abu Dhabi', 'ME', 0, '', 'ENGLISH/ARABIC'),
('AF', '93', 'AFGHANISTAN', 'Afghanistan', 'Kabul', 'ME', 0, '', 'PERSIAN/PASHTO'),
('AG', '1268', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'St. John\'s', 'SA', 0, '', 'ENGLISH'),
('AI', '1264', 'ANGUILLA', 'Anguilla', 'The Valley', 'SA', 0, '', 'ENGLISH'),
('AL', '355', 'ALBANIA', 'Albania', 'Tiranë', 'EU', 0, '', 'ALBANIAN'),
('AM', '374', 'ARMENIA', 'Armenia', 'Yerevan', 'CIS', 0, '', 'RUSSIAN'),
('AN', '599', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'Willemstad', 'SA', 0, '', 'ENGLISH/DUTCH'),
('AO', '244', 'ANGOLA', 'Angola', 'Luanda', 'AF', 0, '', 'PORTUGUESE'),
('AQ', '672', 'ANTARCTICA', 'Antarctica', '', 'AN', 0, '', 'ENGLISH/FRENCH/RUSSIAN/SPANISH/PORTUGUESE'),
('AR', '54', 'ARGENTINA', 'Argentina', 'Buenos Aires', 'SA', 0, '', 'SPANISH'),
('AS', '684', 'AMERICAN SAMOA', 'American Samoa', 'Pago Pago', 'OC', 0, '', 'ENGLISH/SAMOAN'),
('AT', '43', 'AUSTRIA', 'Austria', 'Vienna', 'EU', 0, '', 'GERMAN'),
('AU', '61', 'AUSTRALIA', 'Australia', 'Canberra', 'OC', 0, '', 'ENGLISH'),
('AW', '297', 'ARUBA', 'Aruba', 'Oranjestad', 'SA', 0, '', 'DUTCH/PAPIAMENTO'),
('AX', '35818', 'ALAND ISLANDS', 'Aland Islands', 'Mariehamn', 'EU', 0, '', 'SWEDISH'),
('AZ', '994', 'AZERBAIJAN', 'Azerbaijan', 'Baku', 'CIS', 0, '', 'RUSSIAN'),
('BA', '387', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'Sarajevo', 'EU', 0, '', 'BOSNIAN/CROATIAN/SERBIAN'),
('BB', '1246', 'BARBADOS', 'Barbados', 'Bridgetown', 'SA', 0, '', 'ENGLISH'),
('BD', '880', 'BANGLADESH', 'Bangladesh', 'Dhaka', 'AS', 0, '', 'BANGLA'),
('BE', '32', 'BELGIUM', 'Belgium', 'Brussels', 'EU', 0, '', 'FRENCH/DUTCH/GERMAN'),
('BF', '226', 'BURKINA FASO', 'Burkina Faso', 'Ouagadougou', 'AF', 0, '', 'FRENCH'),
('BG', '359', 'BULGARIA', 'Bulgaria', 'Sofia', 'EU', 0, '', 'BULGARIAN'),
('BH', '973', 'BAHRAIN', 'Bahrain', 'Al-Manámah', 'ME', 0, '', 'ARABIC'),
('BI', '257', 'BURUNDI', 'Burundi', 'Bujumbura', 'AF', 0, '', 'FRENCH/KIRUNDI'),
('BJ', '229', 'BENIN', 'Benin', 'Porto-Novo', 'AF', 0, '', 'FRENCH'),
('BM', '1441', 'BERMUDA', 'Bermuda', 'Hamilton', 'SA', 0, '', 'ENGLISH/PORTUGUESE'),
('BN', '673', 'BRUNEI', 'Brunei', 'Bandar Seri Begawan', 'AS', 0, '', 'MALAY'),
('BO', '591', 'BOLIVIA', 'Bolivia', 'La Paz', 'SA', 0, '', 'SPANISH/QUECHUA/AIMARA/GUARANI'),
('BR', '55', 'BRAZIL', 'Brazil', 'Brasília', 'SA', 0, '', 'PORTUGUESE'),
('BS', '1242', 'BAHAMAS', 'Bahamas', 'Nassau', 'SA', 0, '', 'ENGLISH'),
('BT', '975', 'BHUTAN', 'Bhutan', 'Thimphu', 'AS', 0, '', 'DZONGKHA/THIMPHOU'),
('BV', '47', 'BOUVET ISLAND', 'Bouvet Island', '', 'AN', 0, '', 'NORWEGIAN'),
('BW', '267', 'BOTSWANA', 'Botswana', 'Gaborone', 'AF', 0, '', 'ENGLISH'),
('BY', '375', 'BELARUS', 'Belarus', 'Mensk (Minsk)', 'CIS', 0, '', 'RUSSIAN/BELARUSIAN'),
('BZ', '501', 'BELIZE', 'Belize', 'Belmopan', 'SA', 0, '', 'ENGLISH'),
('CA', '1', 'CANADA', 'Canada', 'Ottawa', 'NA', 0, '', 'ENGLISH/FRENCH'),
('CC', '61', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', 'West Island', 'OC', 0, '', 'ENGLISH'),
('CD', '243', 'CONGO (KINSHASA)', 'Congo (Kinshasa)', 'Kinshasa', 'AF', 0, '', 'FRENCH'),
('CF', '236', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'Bangui', 'AF', 0, '', 'FRENCH/SANGO'),
('CG', '242', 'CONGO (BRAZZAVILLE)', 'Congo (Brazzaville)', 'Brazzaville', 'AF', 0, '', 'FRENCH'),
('CH', '41', 'SWITZERLAND', 'Switzerland', 'Bern', 'EU', 0, '', 'FRENCH/ITALIAN/GERMAN'),
('CI', '225', 'IVORY COAST', 'Ivory Coast', 'Yamoussoukro', 'AF', 0, '', 'FRENCH'),
('CK', '682', 'COOK ISLANDS', 'Cook Islands', 'Avarua', 'OC', 0, '', 'ENGLISH'),
('CL', '56', 'CHILE', 'Chile', 'Santiago', 'SA', 0, '', 'SPANISH'),
('CM', '237', 'CAMEROON', 'Cameroon', 'Yaoundé', 'AF', 0, '', 'FRENCH'),
('CN', '86', 'CHINA', 'China', 'Beijing', 'AS', 0, '', 'CHINESE'),
('CO', '57', 'COLOMBIA', 'Colombia', 'Bogatá', 'SA', 0, '', 'SPANISH'),
('CR', '506', 'COSTA RICA', 'Costa Rica', 'San José', 'SA', 0, '', 'SPANISH'),
('CU', '53', 'CUBA', 'Cuba', 'Havana', 'SA', 0, '', 'SPANISH'),
('CV', '238', 'CAPE VERDE', 'Cape Verde', 'Praia', 'AF', 0, '', 'PORTUGUESE'),
('CX', '61', 'CHRISTMAS ISLAND', 'Christmas Island', 'The Settlement', 'AS', 0, '', 'ENGLISH'),
('CY', '357', 'CYPRUS', 'Cyprus', 'Nicosia', 'EU', 0, '', 'GREEK/TURKISH'),
('CZ', '420', 'CZECH REPUBLIC', 'Czech Republic', 'Prague', 'EU', 0, '', 'CZECH'),
('DE', '49', 'GERMANY', 'Germany', 'Berlin', 'EU', 1, 'de', 'GERMAN'),
('DJ', '253', 'DJIBOUTI', 'Djibouti', 'Djibouti', 'AF', 0, '', 'FRENCH/ARABIC'),
('DK', '45', 'DENMARK', 'Denmark', 'Copenhagen', 'EU', 0, '', 'DANISH'),
('DM', '1767', 'DOMINICA', 'Dominica', 'Roseau', 'NA', 0, '', 'ENGLISH'),
('DO', '1809', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'Santo Domingo', 'SA', 0, '', 'SPANISH'),
('DZ', '213', 'ALGERIA', 'Algeria', 'Algiers', 'MH', 0, '', 'FRENCH/ARABIC/BERBER'),
('EC', '593', 'ECUADOR', 'Ecuador', 'Quito', 'SA', 0, '', 'SPANISH'),
('EE', '372', 'ESTONIA', 'Estonia', 'Tallinn', 'EU', 0, '', 'RUSSIAN'),
('EG', '20', 'EGYPT', 'Egypt', 'Cairo', 'MH', 0, '', 'ARABIC'),
('EH', '685', 'WESTERN SAHARA', 'Western Sahara', 'El-Aaiun', 'AF', 0, '', 'ARABIC'),
('ER', '291', 'ERITREA', 'Eritrea', 'Asmara', 'AF', 0, '', 'ENGLISH'),
('ES', '34', 'SPAIN', 'Spain', 'Madrid', 'EU', 1, 'es', 'SPANISH'),
('ET', '251', 'ETHIOPIA', 'Ethiopia', 'Addis Ababa', 'AF', 0, '', 'AMHARIC'),
('FI', '358', 'FINLAND', 'Finland', 'Helsinki', 'EU', 0, '', 'FINNISH/SWEDISH'),
('FJ', '679', 'FIJI', 'Fiji', 'Suva', 'OC', 0, '', 'FIDJIAN'),
('FK', '500', 'FALKLAND ISLANDS', 'Falkland Islands', 'Stanley', 'SA', 0, '', 'ENGLISH'),
('FM', '691', 'MICRONESIA', 'Micronesia', 'Palikir', 'OC', 0, '', 'ENGLISH'),
('FO', '298', 'FAROE ISLANDS', 'Faroe Islands', 'Tórshavn', 'EU', 0, '', 'DANISH/FAROESE'),
('FR', '33', 'FRANCE', 'France', 'Paris', 'EU', 1, 'fr', 'FRENCH'),
('GA', '241', 'GABON', 'Gabon', 'Libreville', 'AF', 0, '', 'FRENCH'),
('GB', '44', 'UNITED KINGDOM', 'United Kingdom', 'London', 'EU', 1, 'en', 'ENGLISH'),
('GD', '1473', 'GRENADA', 'Grenada', 'St. George\'s', 'SA', 0, '', 'ENGLISH'),
('GE', '995', 'GEORGIA', 'Georgia', 'Tbilisi', 'EU', 0, '', 'GEORGIAN'),
('GF', '594', 'FRENCH GUIANA', 'French Guiana', 'Cayenne', 'SA', 0, '', 'FRENCH'),
('GG', '441481', 'GUERNSEY', 'Guernsey', 'St Peter Port', 'EU', 0, '', 'ENGLISH/FRENCH'),
('GH', '233', 'GHANA', 'Ghana', 'Accra', 'AF', 0, '', 'ENGLISH'),
('GI', '350', 'GIBRALTAR', 'Gibraltar', 'Gibraltar', 'EU', 0, '', 'ENGLISH'),
('GL', '299', 'GREENLAND', 'Greenland', 'Nuuk (Godthåb)', 'EU', 0, '', 'GREENLANDIC'),
('GM', '220', 'GAMBIA', 'Gambia', 'Banjul', 'AF', 0, '', 'ENGLISH'),
('GN', '224', 'GUINEA', 'Guinea', 'Conakry', 'AF', 0, '', 'FRENCH'),
('GP', '590', 'GUADELOUPE', 'Guadeloupe', 'Basse-Terre', 'SA', 0, '', 'FRENCH'),
('GQ', '240', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'Malabo', 'AF', 0, '', 'SPANISH'),
('GR', '30', 'GREECE', 'Greece', 'Athens', 'EU', 0, '', 'GREEK'),
('GS', '1382', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', 'Grytviken', 'AN', 0, '', 'ENGLISH'),
('GT', '502', 'GUATEMALA', 'Guatemala', 'Guatemala City', 'SA', 0, '', 'SPANISH'),
('GU', '1671', 'GUAM', 'Guam', 'Hagåtña', 'OC', 0, '', 'ENGLISH'),
('GW', '245', 'GUINEA-BISSAU', 'Guinea-Bissau', 'Bissau', 'AF', 0, '', 'ENGLISH'),
('GY', '592', 'GUYANA', 'Guyana', 'Georgetown', 'SA', 0, '', 'ENGLISH'),
('HK', '852', 'HONG KONG', 'Hong Kong', 'Hong Kong', 'AS', 0, '', 'ENGLISH/CANTONESE'),
('HM', '672', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and McDonald Islands', '', 'AN', 0, '', 'ENGLISH'),
('HN', '504', 'HONDURAS', 'Honduras', 'Tegucigalpa', 'SA', 0, '', 'SPANISH'),
('HR', '385', 'CROATIA', 'Croatia', 'Zagreb', 'EU', 0, '', 'CROATIAN'),
('HT', '509', 'HAITI', 'Haiti', 'Port-au-Prince', 'SA', 0, '', 'FRENCH'),
('HU', '36', 'HUNGARY', 'Hungary', 'Budapest', 'EU', 0, '', 'HUNGARIAN'),
('ID', '62', 'INDONESIA', 'Indonesia', 'Jakarta', 'AS', 0, '', 'INDONESIAN'),
('IE', '353', 'IRELAND', 'Ireland', 'Dublin', 'EU', 0, '', 'ENGLISH/IRISH'),
('IL', '972', 'ISRAEL', 'Israel', 'Jerusalem', 'ME', 0, '', 'ARABIC/HEBREW'),
('IM', '44', 'ISLE OF MAN', 'Isle of Man', 'Douglas', 'EU', 0, '', 'ENGLISH'),
('IN', '91', 'INDIA', 'India', 'New Delhi', 'AS', 0, '', 'ENGLISH/HINDI'),
('IO', '1284', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', 'Diego Garcia', 'AS', 0, '', 'ENGLISH'),
('IQ', '964', 'IRAQ', 'Iraq', 'Baghdad', 'ME', 0, '', 'ARABIC/KURDISH'),
('IR', '98', 'IRAN', 'Iran', 'Tehran', 'ME', 0, '', 'PERSIAN'),
('IS', '354', 'ICELAND', 'Iceland', 'Reykjavik', 'EU', 0, '', 'ICELANDIC'),
('IT', '39', 'ITALY', 'Italy', 'Rome', 'EU', 0, '', 'ITALIAN'),
('JE', '44', 'JERSEY', 'Jersey', 'Saint Helier', 'EU', 0, '', 'ENGLISH/FRENCH/NORMAN'),
('JM', '1876', 'JAMAICA', 'Jamaica', 'Kingston', 'SA', 0, '', 'ENGLISH'),
('JO', '962', 'JORDAN', 'Jordan', 'Amman', 'ME', 0, '', 'ARABIC'),
('JP', '81', 'JAPAN', 'Japan', 'Tokyo', 'AS', 0, '', 'JAPANESE'),
('KE', '254', 'KENYA', 'Kenya', 'Nairobi', 'AF', 0, '', 'ENGLISH/SWAHILI'),
('KG', '996', 'KYRGYZSTAN', 'Kyrgyzstan', 'Bishkek', 'CIS', 0, '', 'RUSSIAN/KYRGYZ'),
('KH', '855', 'CAMBODIA', 'Cambodia', 'Phnom Penh', 'AS', 0, '', 'KHMER'),
('KI', '686', 'KIRIBATI', 'Kiribati', 'Tarawa', 'OC', 0, '', 'ENGLISH'),
('KM', '269', 'COMOROS', 'Comoros', 'Moroni', 'AF', 0, '', 'FRENCH/COMOROS/ARABIC'),
('KN', '869', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'Basseterre', 'NA', 0, '', 'ENGLISH'),
('KP', '850', 'NORTH KOREA', 'North Korea', 'Pyongyang', 'AS', 0, '', 'KOREAN'),
('KR', '82', 'SOUTH KOREA', 'South Korea', 'Seoul', 'AS', 0, '', 'KOREAN'),
('KW', '965', 'KUWAIT', 'Kuwait', 'Kuwait City', 'ME', 0, '', 'ARABIC'),
('KY', '1345', 'CAYMAN ISLANDS', 'Cayman Islands', 'George Town', 'SA', 0, '', 'ENGLISH'),
('KZ', '7', 'KAZAKHSTAN', 'Kazakhstan', 'Almaty', 'CIS', 0, '', 'RUSSIAN/KAZAKH'),
('LA', '856', 'LAOS', 'Laos', 'Vientiane', 'AS', 0, '', 'LAOTIAN'),
('LB', '961', 'LEBANON', 'Lebanon', 'Beirut', 'ME', 0, '', 'ARABIC'),
('LC', '758', 'SAINT LUCIA', 'Saint Lucia', 'Castries', 'NA', 0, '', 'ENGLISH'),
('LI', '423', 'LIECHTENSTEIN', 'Liechtenstein', 'Vaduz', 'EU', 0, '', 'GERMAN'),
('LK', '94', 'SRI LANKA', 'Sri Lanka', 'Colombo', 'AS', 0, '', 'ENGLISH/CINGALAIS/TAMOUL'),
('LR', '231', 'LIBERIA', 'Liberia', 'Monrovia', 'AF', 0, '', 'ENGLISH'),
('LS', '266', 'LESOTHO', 'Lesotho', 'Maseru', 'AF', 0, '', 'ENGLISH/SESOTHO'),
('LT', '370', 'LITHUANIA', 'Lithuania', 'Vilnius', 'EU', 0, '', 'LITHUANIAN'),
('LU', '352', 'LUXEMBOURG', 'Luxembourg', 'Luxembourg', 'EU', 0, '', 'GERMAN/LUXEMBOURG'),
('LV', '371', 'LATVIA', 'Latvia', 'Riga', 'EU', 0, '', 'LATVIAN'),
('LY', '218', 'LIBYA', 'Libya', 'Tripoli', 'MH', 0, '', 'ARABIC'),
('MA', '212', 'MOROCCO', 'Morocco', 'Rabat', 'MH', 0, '', 'FRENCH/ARABIC/BERBER'),
('MC', '377', 'MONACO', 'Monaco', 'Monaco', 'EU', 0, '', 'FRENCH'),
('MD', '373', 'MOLDOVA', 'Moldova', 'Chisinau', 'CIS', 0, '', 'ROMANIAN'),
('ME', '382', 'MONTENEGRO', 'Montenegro', 'Podgorica', 'EU', 0, '', 'BOSNIAN/SERBIAN/CROATIAN/ALBANIAN/MONTENEGRIN'),
('MG', '261', 'MADAGASCAR', 'Madagascar', 'Antananarivo', 'AF', 0, '', 'FRENCH/MALAGASY'),
('MH', '692', 'MARSHALL ISLANDS', 'Marshall Islands', 'Majuro', 'OC', 0, '', 'ENGLISH'),
('MK', '389', 'MACEDONIA', 'Macedonia', 'Skopje', 'EU', 0, '', 'MACEDONIAN'),
('ML', '223', 'MALI', 'Mali', 'Bamako', 'AF', 0, '', 'FRENCH'),
('MM', '95', 'MYANMAR', 'Myanmar', 'Rangoon', 'AS', 0, '', 'BURMESE'),
('MN', '976', 'MONGOLIA', 'Mongolia', 'Ulan Bator', 'CIS', 0, '', 'MONGOL'),
('MO', '853', 'MACAO S.A.R., CHINA', 'Macao S.A.R., China', 'Macao', 'AS', 0, '', 'CANTONES/PORTUGUESE'),
('MP', '1670', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'Saipan', 'OC', 0, '', 'ENGLISH'),
('MQ', '596', 'MARTINIQUE', 'Martinique', 'Fort-de-France', 'SA', 0, '', 'FRENCH'),
('MR', '222', 'MAURITANIA', 'Mauritania', 'Nouakchott', 'AF', 0, '', 'ARABIC'),
('MS', '1664', 'MONTSERRAT', 'Montserrat', 'Plymouth', 'NA', 0, '', 'ENGLISH'),
('MT', '356', 'MALTA', 'Malta', 'Valletta', 'EU', 0, '', 'ENGLISH/MALTAIS'),
('MU', '230', 'MAURITIUS', 'Mauritius', 'Port Louis', 'AF', 0, '', 'ENGLISH/FRENCH/MAURITIUS'),
('MV', '960', 'MALDIVES', 'Maldives', 'Malé', 'AS', 0, '', 'DIVEHI'),
('MW', '265', 'MALAWI', 'Malawi', 'Lilongwe', 'AF', 0, '', 'ENGLISH/CHICHEWA'),
('MX', '52', 'MEXICO', 'Mexico', 'Mexico City', 'SA', 0, '', 'SPANISH'),
('MY', '60', 'MALAYSIA', 'Malaysia', 'Kuala Lumpur', 'AS', 0, '', 'MALAY'),
('MZ', '258', 'MOZAMBIQUE', 'Mozambique', 'Maputo', 'AF', 0, '', 'PORTUGUESE/MAPUTO'),
('NA', '264', 'NAMIBIA', 'Namibia', 'Windhoek', 'AF', 0, '', 'ENGLISH'),
('NC', '687', 'NEW CALEDONIA', 'New Caledonia', 'Noumea', 'OC', 0, '', 'FRENCH'),
('NE', '227', 'NIGER', 'Niger', 'Niamey', 'AF', 0, '', 'FRENCH'),
('NF', '672', 'NORFOLK ISLAND', 'Norfolk Island', 'Kingston', 'OC', 0, '', 'ENGLISH'),
('NG', '234', 'NIGERIA', 'Nigeria', 'Abuja', 'AF', 0, '', 'ENGLISH'),
('NI', '505', 'NICARAGUA', 'Nicaragua', 'Managua', 'SA', 0, '', 'SPANISH'),
('NL', '31', 'NETHERLANDS', 'Netherlands', 'Amsterdam', 'EU', 0, '', 'DUTCH'),
('NO', '47', 'NORWAY', 'Norway', 'Oslo', 'EU', 0, '', 'NORWEGIAN'),
('NP', '977', 'NEPAL', 'Nepal', 'Kathmandu', 'AS', 0, '', 'NEPALAIS'),
('NR', '674', 'NAURU', 'Nauru', 'Yaren', 'OC', 0, '', 'ENGLISH'),
('NU', '683', 'NIUE', 'Niue', 'Alofi', 'OC', 0, '', 'ENGLISH/NIUEAN'),
('NZ', '64', 'NEW ZEALAND', 'New Zealand', 'Wellington', 'OC', 0, '', 'ENGLISH'),
('OM', '968', 'OMAN', 'Oman', 'Muscat', 'ME', 0, '', 'ARABIC'),
('PA', '507', 'PANAMA', 'Panama', 'Panama City', 'SA', 0, '', 'SPANISH'),
('PE', '51', 'PERU', 'Peru', 'Lima', 'SA', 0, '', 'SPANISH/QUECHUA/AIMARA'),
('PF', '689', 'FRENCH POLYNESIA', 'French Polynesia', 'Papeete', 'OC', 0, '', 'FRENCH'),
('PG', '675', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'Port Moresby', 'OC', 0, '', 'ENGLISH/TOK PISIN/HIRI MOTU'),
('PH', '63', 'PHILIPPINES', 'Philippines', 'Manila', 'AS', 0, '', 'ENGLISH/FILIPINO'),
('PK', '92', 'PAKISTAN', 'Pakistan', 'Islamabad', 'ME', 0, '', 'ENGLISH/OURDOU'),
('PL', '48', 'POLAND', 'Poland', 'Warsaw', 'EU', 0, '', 'POLISH'),
('PM', '508', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'Saint-Pierre', 'EU', 0, '', 'ENGLISH'),
('PN', '672', 'PITCAIRN', 'Pitcairn', 'Adamstown', 'OC', 0, '', 'ENGLISH'),
('PR', '1787', 'PUERTO RICO', 'Puerto Rico', 'San Juan', 'SA', 0, '', 'ENGLISH/SPANISH'),
('PS', '970', 'PALESTINIAN TERRITORY', 'Palestinian Territory', 'East Jerusalem', 'ME', 0, '', 'ARABIC'),
('PT', '351', 'PORTUGAL', 'Portugal', 'Lisbon', 'EU', 1, 'pt', 'PORTUGUESE'),
('PW', '680', 'PALAU', 'Palau', 'Koror', 'OC', 0, '', 'ENGLISH'),
('PY', '595', 'PARAGUAY', 'Paraguay', 'Asunción', 'SA', 0, '', 'SPANISH/GUARANI'),
('QA', '974', 'QATAR', 'Qatar', 'Doha', 'ME', 0, '', 'ARABIC'),
('RE', '262', 'REUNION', 'Reunion', 'Saint-Denis', 'AS', 0, '', 'FRENCH'),
('RO', '40', 'ROMANIA', 'Romania', 'Bucharest', 'EU', 0, '', 'ROMANIAN'),
('RS', '381', 'SERBIA', 'Serbia', 'Belgrade', 'EU', 0, '', 'SERBIAN'),
('RU', '7', 'RUSSIA', 'Russia', 'Moscow', 'CIS', 1, 'ru', 'RUSSIAN'),
('RW', '250', 'RWANDA', 'Rwanda', 'Kigali', 'AF', 0, '', 'ENGLISH/FRENCH/KINYARWANDA'),
('SA', '966', 'SAUDI ARABIA', 'Saudi Arabia', 'Riyadh', 'ME', 0, '', 'ARABIC'),
('SB', '677', 'SOLOMON ISLANDS', 'Solomon Islands', 'Honiara', 'OC', 0, '', 'ENGLISH'),
('SC', '248', 'SEYCHELLES', 'Seychelles', 'Victoria', 'SA', 0, '', 'ENGLISH/FRENCH'),
('SD', '249', 'SUDAN', 'Sudan', 'Khartoum', 'AF', 0, '', 'ENGLISH/ARABIC'),
('SE', '46', 'SWEDEN', 'Sweden', 'Stockholm', 'EU', 0, '', 'SWEDISH'),
('SG', '65', 'SINGAPORE', 'Singapore', 'Singapore', 'AS', 0, '', 'ENGLISH/MANDARIN/MALAY/TAMOUL'),
('SH', '290', 'SAINT HELENA', 'Saint Helena', 'Jamestown', 'AF', 0, '', 'ENGLISH'),
('SI', '386', 'SLOVENIA', 'Slovenia', 'Ljubljana', 'EU', 0, '', 'ITALIAN/SLOVENIAN/HUNGARIAN'),
('SJ', '47', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'Longyearbyen', 'EU', 0, '', 'ENGLISH'),
('SK', '421', 'SLOVAKIA', 'Slovakia', 'Bratislava', 'EU', 0, '', 'SLOVAQUE'),
('SL', '232', 'SIERRA LEONE', 'Sierra Leone', 'Freetown', 'EU', 0, '', 'ENGLISH'),
('SM', '378', 'SAN MARINO', 'San Marino', 'San Marino', 'EU', 0, '', 'ITALIAN'),
('SN', '221', 'SENEGAL', 'Senegal', 'Dakar', 'AF', 0, '', 'FRENCH'),
('SO', '252', 'SOMALIA', 'Somalia', 'Mogadishu', 'AF', 0, '', 'ARABIC/SOMALI'),
('SR', '597', 'SURINAME', 'Suriname', 'Paramaribo', 'SA', 0, '', 'DUTCH/PARAMARIBO'),
('ST', '239', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'São Tomé', 'AF', 0, '', 'PORTUGUESE'),
('SV', '503', 'EL SALVADOR', 'El Salvador', 'San Salvador', 'NA', 0, '', 'ENGLISH'),
('SY', '963', 'SYRIA', 'Syria', 'Damascus', 'ME', 0, '', 'ARABIC'),
('SZ', '268', 'SWAZILAND', 'Swaziland', 'Mbabane', 'AF', 0, '', 'ENGLISH/SWATI'),
('TC', '1649', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'Grand Turk (Cockburn Town)', 'SA', 0, '', 'ENGLISH'),
('TD', '235', 'CHAD', 'Chad', 'N\'Djamena', 'AF', 0, '', 'ENGLISH'),
('TG', '228', 'TOGO', 'Togo', 'Lomé', 'AF', 0, '', 'FRENCH'),
('TH', '66', 'THAILAND', 'Thailand', 'Bangkok', 'AS', 0, '', 'THAI'),
('TJ', '992', 'TAJIKISTAN', 'Tajikistan', 'Dushanbe', 'CIS', 0, '', 'RUSSIAN/TADJIK'),
('TK', '690', 'TOKELAU', 'Tokelau', '', 'OC', 0, '', 'ENGLISH'),
('TL', '670', 'EAST TIMOR', 'East Timor', 'Dili', 'AS', 0, '', 'PORTUGUESE'),
('TM', '993', 'TURKMENISTAN', 'Turkmenistan', 'Ashgabat', 'CIS', 0, '', 'RUSSIAN/TURKMEN'),
('TN', '216', 'TUNISIA', 'Tunisia', 'Tunis', 'MH', 0, '', 'FRENCH/ARABIC/CHELHA'),
('TO', '676', 'TONGA', 'Tonga', 'Nuku\'alofa', 'SA', 0, '', 'ENGLISH/TONGIEN'),
('TR', '90', 'TURKEY', 'Turkey', 'Ankara', 'ME', 0, '', 'TURKISH'),
('TT', '1868', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'Port-of-Spain', 'SA', 0, '', 'ENGLISH'),
('TV', '688', 'TUVALU', 'Tuvalu', 'Funafuti', 'OC', 0, '', 'TUVALUAN'),
('TW', '886', 'TAIWAN', 'Taiwan', 'Taipei', 'AS', 0, '', 'CHINESE/MANDARIN'),
('TZ', '255', 'TANZANIA', 'Tanzania', 'Dar es Salaam', 'AF', 0, '', 'ENGLISH/SWAHILI'),
('UA', '380', 'UKRAINE', 'Ukraine', 'Kyiv (Kiev)', 'EU', 0, '', 'RUSSIAN/UKRAINIAN/HUNGARIAN/ROMANIAN'),
('UG', '256', 'UGANDA', 'Uganda', 'Kampala', 'AF', 0, '', 'ENGLISH/SWAHILI'),
('UM', '1', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', '', 'NA', 0, '', 'ENGLISH'),
('US', '1', 'UNITED STATES', 'United States', 'Washington, D.C.', 'NA', 0, '', 'ENGLISH'),
('UY', '598', 'URUGUAY', 'Uruguay', 'Montevideo', 'SA', 0, '', 'SPANISH'),
('UZ', '998', 'UZBEKISTAN', 'Uzbekistan', 'Tashkent', 'CIS', 0, '', 'RUSSIAN/UZBEK'),
('VC', '784', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'Kingstown', 'NA', 0, '', 'ENGLISH'),
('VE', '58', 'VENEZUELA', 'Venezuela', 'Caracas', 'SA', 0, '', 'SPANISH'),
('VG', '180949', 'BRITISH VIRGIN ISLANDS', 'British Virgin Islands', 'Road Town', 'NA', 0, '', 'ENGLISH'),
('VI', '1809', 'U.S. VIRGIN ISLANDS', 'U.S. Virgin Islands', 'Charlotte Amalie', 'SA', 0, '', 'ENGLISH'),
('VN', '84', 'VIETNAM', 'Vietnam', 'Hanoi', 'AS', 0, '', 'VIETNAMESE'),
('VU', '678', 'VANUATU', 'Vanuatu', 'Vila', 'OC', 0, '', 'ENGLISH/FRENCH/BISLAMA'),
('WF', '681', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'Matâ\'Utu', 'EU', 0, '', 'FRENCH'),
('WS', '685', 'SAMOA', 'Samoa', 'Apia', 'OC', 0, '', 'ENGLISH/SAMOAN'),
('YE', '967', 'YEMEN', 'Yemen', 'Sanaá', 'ME', 0, '', 'ARABIC'),
('YT', '269', 'MAYOTTE', 'Mayotte', 'Mamoutzou', 'AF', 0, '', 'SWAHILI/MALAGASY'),
('ZA', '27', 'SOUTH AFRICA', 'South Africa', 'Pretoria', 'AF', 0, '', 'ENGLISH/AFRIKAAN'),
('ZM', '260', 'ZAMBIA', 'Zambia', 'Lusaka', 'AF', 0, '', 'ENGLISH'),
('ZW', '263', 'ZIMBABWE', 'Zimbabwe', 'Harare', 'AF', 0, '', 'ENGLISH'),
('XK', '383', 'KOSOVO', 'Kosovo', 'Pristina', 'EU', 0, '', 'ALBANIAN/SERBIAN'),
('VA', '379', 'VATICAN CITY STATE', 'Vatican City State', 'Vatican', 'EU', 0, '', 'ITALIAN'),
('', '', 'OTHER', '', '', '', 0, '', '');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
