/*
SQLyog Enterprise - MySQL GUI v5.17
Host - 5.0.24-community-max-log : Database - geography
*********************************************************************
Server version : 5.0.24-community-max-log
*/


SET NAMES utf8;

SET SQL_MODE='';

create database if not exists `geography`;

USE `geography`;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';

/*Table structure for table `Country` */

DROP TABLE IF EXISTS `Country`;

CREATE TABLE `Country` (
  `Code` char(3) NOT NULL default '',
  `Name` char(52) NOT NULL default '',
  `Continent` enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') NOT NULL default 'Asia',
  `Region` char(26) NOT NULL default '',
  `SurfaceArea` float(10,2) NOT NULL default '0.00',
  `IndepYear` smallint(6) default NULL,
  `Population` int(11) NOT NULL default '0',
  `LifeExpectancy` float(3,1) default NULL,
  `GNP` float(10,2) default NULL,
  `GNPOld` float(10,2) default NULL,
  `LocalName` char(45) NOT NULL default '',
  `GovernmentForm` char(45) NOT NULL default '',
  `HeadOfState` char(60) default NULL,
  `Capital` int(11) default NULL,
  `Code2` char(2) NOT NULL default '',
  PRIMARY KEY  (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;

/*Data for the table `Country` */

insert into `Country` (`Code`,`Name`,`Continent`,`Region`,`SurfaceArea`,`IndepYear`,`Population`,`LifeExpectancy`,`GNP`,`GNPOld`,`LocalName`,`GovernmentForm`,`HeadOfState`,`Capital`,`Code2`) values ('ABW','Aruba','North America','Caribbean',193.00,NULL,103000,78.4,828.00,793.00,'Aruba','Nonmetropolitan Territory of The Netherlands','Beatrix',129,'AW'),('AFG','Afghanistan','Asia','Southern and Central Asia',652090.00,1919,22720000,45.9,5976.00,NULL,'Afganistan/Afqanestan','Islamic Emirate','Mohammad Omar',1,'AF'),('AGO','Angola','Africa','Central Africa',1246700.00,1975,12878000,38.3,6648.00,7984.00,'Angola','Republic','José Eduardo dos Santos',56,'AO'),('AIA','Anguilla','North America','Caribbean',96.00,NULL,8000,76.1,63.20,NULL,'Anguilla','Dependent Territory of the UK','Elisabeth II',62,'AI'),('ALB','Albania','Europe','Southern Europe',28748.00,1912,3401200,71.6,3205.00,2500.00,'Shqipëria','Republic','Rexhep Mejdani',34,'AL'),('AND','Andorra','Europe','Southern Europe',468.00,1278,78000,83.5,1630.00,NULL,'Andorra','Parliamentary Coprincipality','',55,'AD'),('ANT','Netherlands Antilles','North America','Caribbean',800.00,NULL,217000,74.7,1941.00,NULL,'Nederlandse Antillen','Nonmetropolitan Territory of The Netherlands','Beatrix',33,'AN'),('ARE','United Arab Emirates','Asia','Middle East',83600.00,1971,2441000,74.1,37966.00,36846.00,'Al-Imarat al-´Arabiya al-Muttahida','Emirate Federation','Zayid bin Sultan al-Nahayan',65,'AE'),('ARG','Argentina','South America','South America',2780400.00,1816,37032000,75.1,340238.00,323310.00,'Argentina','Federal Republic','Fernando de la Rúa',69,'AR'),('ARM','Armenia','Asia','Middle East',29800.00,1991,3520000,66.4,1813.00,1627.00,'Hajastan','Republic','Robert Kotšarjan',126,'AM'),('ASM','American Samoa','Oceania','Polynesia',199.00,NULL,68000,75.1,334.00,NULL,'Amerika Samoa','US Territory','George W. Bush',54,'AS'),('ATA','Antarctica','Antarctica','Antarctica',13120000.00,NULL,0,NULL,0.00,NULL,'–','Co-administrated','',NULL,'AQ'),('ATF','French Southern territories','Antarctica','Antarctica',7780.00,NULL,0,NULL,0.00,NULL,'Terres australes françaises','Nonmetropolitan Territory of France','Jacques Chirac',NULL,'TF'),('ATG','Antigua and Barbuda','North America','Caribbean',442.00,1981,68000,70.5,612.00,584.00,'Antigua and Barbuda','Constitutional Monarchy','Elisabeth II',63,'AG'),('AUS','Australia','Oceania','Australia and New Zealand',7741220.00,1901,18886000,79.8,351182.00,392911.00,'Australia','Constitutional Monarchy, Federation','Elisabeth II',135,'AU'),('AUT','Austria','Europe','Western Europe',83859.00,1918,8091800,77.7,211860.00,206025.00,'Österreich','Federal Republic','Thomas Klestil',1523,'AT'),('AZE','Azerbaijan','Asia','Middle East',86600.00,1991,7734000,62.9,4127.00,4100.00,'Azärbaycan','Federal Republic','Heydär Äliyev',144,'AZ'),('BDI','Burundi','Africa','Eastern Africa',27834.00,1962,6695000,46.2,903.00,982.00,'Burundi/Uburundi','Republic','Pierre Buyoya',552,'BI'),('BEL','Belgium','Europe','Western Europe',30518.00,1830,10239000,77.8,249704.00,243948.00,'België/Belgique','Constitutional Monarchy, Federation','Albert II',179,'BE'),('BEN','Benin','Africa','Western Africa',112622.00,1960,6097000,50.2,2357.00,2141.00,'Bénin','Republic','Mathieu Kérékou',187,'BJ'),('BFA','Burkina Faso','Africa','Western Africa',274000.00,1960,11937000,46.7,2425.00,2201.00,'Burkina Faso','Republic','Blaise Compaoré',549,'BF'),('BGD','Bangladesh','Asia','Southern and Central Asia',143998.00,1971,129155000,60.2,32852.00,31966.00,'Bangladesh','Republic','Shahabuddin Ahmad',150,'BD'),('BGR','Bulgaria','Europe','Eastern Europe',110994.00,1908,8190900,70.9,12178.00,10169.00,'Balgarija','Republic','Petar Stojanov',539,'BG'),('BHR','Bahrain','Asia','Middle East',694.00,1971,617000,73.0,6366.00,6097.00,'Al-Bahrayn','Monarchy (Emirate)','Hamad ibn Isa al-Khalifa',149,'BH'),('BHS','Bahamas','North America','Caribbean',13878.00,1973,307000,71.1,3527.00,3347.00,'The Bahamas','Constitutional Monarchy','Elisabeth II',148,'BS'),('BIH','Bosnia and Herzegovina','Europe','Southern Europe',51197.00,1992,3972000,71.5,2841.00,NULL,'Bosna i Hercegovina','Federal Republic','Ante Jelavic',201,'BA'),('BLR','Belarus','Europe','Eastern Europe',207600.00,1991,10236000,68.0,13714.00,NULL,'Belarus','Republic','Aljaksandr Lukašenka',3520,'BY'),('BLZ','Belize','North America','Central America',22696.00,1981,241000,70.9,630.00,616.00,'Belize','Constitutional Monarchy','Elisabeth II',185,'BZ'),('BMU','Bermuda','North America','North America',53.00,NULL,65000,76.9,2328.00,2190.00,'Bermuda','Dependent Territory of the UK','Elisabeth II',191,'BM'),('BOL','Bolivia','South America','South America',1098581.00,1825,8329000,63.7,8571.00,7967.00,'Bolivia','Republic','Hugo Bánzer Suárez',194,'BO'),('BRA','Brazil','South America','South America',8547403.00,1822,170115000,62.9,776739.00,804108.00,'Brasil','Federal Republic','Fernando Henrique Cardoso',211,'BR'),('BRB','Barbados','North America','Caribbean',430.00,1966,270000,73.0,2223.00,2186.00,'Barbados','Constitutional Monarchy','Elisabeth II',174,'BB'),('BRN','Brunei','Asia','Southeast Asia',5765.00,1984,328000,73.6,11705.00,12460.00,'Brunei Darussalam','Monarchy (Sultanate)','Haji Hassan al-Bolkiah',538,'BN'),('BTN','Bhutan','Asia','Southern and Central Asia',47000.00,1910,2124000,52.4,372.00,383.00,'Druk-Yul','Monarchy','Jigme Singye Wangchuk',192,'BT'),('BVT','Bouvet Island','Antarctica','Antarctica',59.00,NULL,0,NULL,0.00,NULL,'Bouvetøya','Dependent Territory of Norway','Harald V',NULL,'BV'),('BWA','Botswana','Africa','Southern Africa',581730.00,1966,1622000,39.3,4834.00,4935.00,'Botswana','Republic','Festus G. Mogae',204,'BW'),('CAF','Central African Republic','Africa','Central Africa',622984.00,1960,3615000,44.0,1054.00,993.00,'Centrafrique/Bê-Afrîka','Republic','Ange-Félix Patassé',1889,'CF'),('CAN','Canada','North America','North America',9970610.00,1867,31147000,79.4,598862.00,625626.00,'Canada','Constitutional Monarchy, Federation','Elisabeth II',1822,'CA'),('CCK','Cocos (Keeling) Islands','Oceania','Australia and New Zealand',14.00,NULL,600,NULL,0.00,NULL,'Cocos (Keeling) Islands','Territory of Australia','Elisabeth II',2317,'CC'),('CHE','Switzerland','Europe','Western Europe',41284.00,1499,7160400,79.6,264478.00,256092.00,'Schweiz/Suisse/Svizzera/Svizra','Federation','Adolf Ogi',3248,'CH'),('CHL','Chile','South America','South America',756626.00,1810,15211000,75.7,72949.00,75780.00,'Chile','Republic','Ricardo Lagos Escobar',554,'CL'),('CHN','China','Asia','Eastern Asia',9572900.00,-1523,1277558000,71.4,982268.00,917719.00,'Zhongquo','People\'sRepublic','Jiang Zemin',1891,'CN'),('CIV','Côte d’Ivoire','Africa','Western Africa',322463.00,1960,14786000,45.2,11345.00,10285.00,'Côte d’Ivoire','Republic','Laurent Gbagbo',2814,'CI'),('CMR','Cameroon','Africa','Central Africa',475442.00,1960,15085000,54.8,9174.00,8596.00,'Cameroun/Cameroon','Republic','Paul Biya',1804,'CM'),('COD','Congo, The Democratic Republic of the','Africa','Central Africa',2344858.00,1960,51654000,48.8,6964.00,2474.00,'République Démocratique du Congo','Republic','Joseph Kabila',2298,'CD'),('COG','Congo','Africa','Central Africa',342000.00,1960,2943000,47.4,2108.00,2287.00,'Congo','Republic','Denis Sassou-Nguesso',2296,'CG'),('COK','Cook Islands','Oceania','Polynesia',236.00,NULL,20000,71.1,100.00,NULL,'The Cook Islands','Nonmetropolitan Territory of New Zealand','Elisabeth II',583,'CK'),('COL','Colombia','South America','South America',1138914.00,1810,42321000,70.3,102896.00,105116.00,'Colombia','Republic','Andrés Pastrana Arango',2257,'CO'),('COM','Comoros','Africa','Eastern Africa',1862.00,1975,578000,60.0,4401.00,4361.00,'Komori/Comores','Republic','Azali Assoumani',2295,'KM'),('CPV','Cape Verde','Africa','Western Africa',4033.00,1975,428000,68.9,435.00,420.00,'Cabo Verde','Republic','António Mascarenhas Monteiro',1859,'CV'),('CRI','Costa Rica','North America','Central America',51100.00,1821,4023000,75.8,10226.00,9757.00,'Costa Rica','Republic','Miguel Ángel Rodríguez Echeverría',584,'CR'),('CUB','Cuba','North America','Caribbean',110861.00,1902,11201000,76.2,17843.00,18862.00,'Cuba','Socialistic Republic','Fidel Castro Ruz',2413,'CU'),('CXR','Christmas Island','Oceania','Australia and New Zealand',135.00,NULL,2500,NULL,0.00,NULL,'Christmas Island','Territory of Australia','Elisabeth II',1791,'CX'),('CYM','Cayman Islands','North America','Caribbean',264.00,NULL,38000,78.9,1263.00,1186.00,'Cayman Islands','Dependent Territory of the UK','Elisabeth II',553,'KY'),('CYP','Cyprus','Asia','Middle East',9251.00,1960,754700,76.7,9333.00,8246.00,'Kýpros/Kibris','Republic','Glafkos Klerides',2430,'CY'),('CZE','Czech Republic','Europe','Eastern Europe',78866.00,1993,10278100,74.5,55017.00,52037.00,'¸esko','Republic','Václav Havel',3339,'CZ'),('DEU','Germany','Europe','Western Europe',357022.00,1955,82164700,77.4,2133367.00,2102826.00,'Deutschland','Federal Republic','Johannes Rau',3068,'DE'),('DJI','Djibouti','Africa','Eastern Africa',23200.00,1977,638000,50.8,382.00,373.00,'Djibouti/Jibuti','Republic','Ismail Omar Guelleh',585,'DJ'),('DMA','Dominica','North America','Caribbean',751.00,1978,71000,73.4,256.00,243.00,'Dominica','Republic','Vernon Shaw',586,'DM'),('DNK','Denmark','Europe','Nordic Countries',43094.00,800,5330000,76.5,174099.00,169264.00,'Danmark','Constitutional Monarchy','Margrethe II',3315,'DK'),('DOM','Dominican Republic','North America','Caribbean',48511.00,1844,8495000,73.2,15846.00,15076.00,'República Dominicana','Republic','Hipólito Mejía Domínguez',587,'DO'),('DZA','Algeria','Africa','Northern Africa',2381741.00,1962,31471000,69.7,49982.00,46966.00,'Al-Jaza’ir/Algérie','Republic','Abdelaziz Bouteflika',35,'DZ'),('ECU','Ecuador','South America','South America',283561.00,1822,12646000,71.1,19770.00,19769.00,'Ecuador','Republic','Gustavo Noboa Bejarano',594,'EC'),('EGY','Egypt','Africa','Northern Africa',1001449.00,1922,68470000,63.3,82710.00,75617.00,'Misr','Republic','Hosni Mubarak',608,'EG'),('ERI','Eritrea','Africa','Eastern Africa',117600.00,1993,3850000,55.8,650.00,755.00,'Ertra','Republic','Isayas Afewerki [Isaias Afwerki]',652,'ER'),('ESH','Western Sahara','Africa','Northern Africa',266000.00,NULL,293000,49.8,60.00,NULL,'As-Sahrawiya','Occupied by Marocco','Mohammed Abdel Aziz',2453,'EH'),('ESP','Spain','Europe','Southern Europe',505992.00,1492,39441700,78.8,553233.00,532031.00,'España','Constitutional Monarchy','Juan Carlos I',653,'ES'),('EST','Estonia','Europe','Baltic Countries',45227.00,1991,1439200,69.5,5328.00,3371.00,'Eesti','Republic','Lennart Meri',3791,'EE'),('ETH','Ethiopia','Africa','Eastern Africa',1104300.00,-1000,62565000,45.2,6353.00,6180.00,'YeItyop´iya','Republic','Negasso Gidada',756,'ET'),('FIN','Finland','Europe','Nordic Countries',338145.00,1917,5171300,77.4,121914.00,119833.00,'Suomi','Republic','Tarja Halonen',3236,'FI'),('FJI','Fiji Islands','Oceania','Melanesia',18274.00,1970,817000,67.9,1536.00,2149.00,'Fiji Islands','Republic','Josefa Iloilo',764,'FJ'),('FLK','Falkland Islands','South America','South America',12173.00,NULL,2000,NULL,0.00,NULL,'Falkland Islands','Dependent Territory of the UK','Elisabeth II',763,'FK'),('FRA','France','Europe','Western Europe',551500.00,843,59225700,78.8,1424285.00,1392448.00,'France','Republic','Jacques Chirac',2974,'FR'),('FRO','Faroe Islands','Europe','Nordic Countries',1399.00,NULL,43000,78.4,0.00,NULL,'Føroyar','Part of Denmark','Margrethe II',901,'FO'),('FSM','Micronesia, Federated States of','Oceania','Micronesia',702.00,1990,119000,68.6,212.00,NULL,'Micronesia','Federal Republic','Leo A. Falcam',2689,'FM'),('GAB','Gabon','Africa','Central Africa',267668.00,1960,1226000,50.1,5493.00,5279.00,'Le Gabon','Republic','Omar Bongo',902,'GA'),('GBR','United Kingdom','Europe','British Islands',242900.00,1066,59623400,77.7,1378330.00,1296830.00,'United Kingdom','Constitutional Monarchy','Elisabeth II',456,'GB'),('GEO','Georgia','Asia','Middle East',69700.00,1991,4968000,64.5,6064.00,5924.00,'Sakartvelo','Republic','Eduard Ševardnadze',905,'GE'),('GHA','Ghana','Africa','Western Africa',238533.00,1957,20212000,57.4,7137.00,6884.00,'Ghana','Republic','John Kufuor',910,'GH'),('GIB','Gibraltar','Europe','Southern Europe',6.00,NULL,25000,79.0,258.00,NULL,'Gibraltar','Dependent Territory of the UK','Elisabeth II',915,'GI'),('GIN','Guinea','Africa','Western Africa',245857.00,1958,7430000,45.6,2352.00,2383.00,'Guinée','Republic','Lansana Conté',926,'GN'),('GLP','Guadeloupe','North America','Caribbean',1705.00,NULL,456000,77.0,3501.00,NULL,'Guadeloupe','Overseas Department of France','Jacques Chirac',919,'GP'),('GMB','Gambia','Africa','Western Africa',11295.00,1965,1305000,53.2,320.00,325.00,'The Gambia','Republic','Yahya Jammeh',904,'GM'),('GNB','Guinea-Bissau','Africa','Western Africa',36125.00,1974,1213000,49.0,293.00,272.00,'Guiné-Bissau','Republic','Kumba Ialá',927,'GW'),('GNQ','Equatorial Guinea','Africa','Central Africa',28051.00,1968,453000,53.6,283.00,542.00,'Guinea Ecuatorial','Republic','Teodoro Obiang Nguema Mbasogo',2972,'GQ'),('GRC','Greece','Europe','Southern Europe',131626.00,1830,10545700,78.4,120724.00,119946.00,'Elláda','Republic','Kostis Stefanopoulos',2401,'GR'),('GRD','Grenada','North America','Caribbean',344.00,1974,94000,64.5,318.00,NULL,'Grenada','Constitutional Monarchy','Elisabeth II',916,'GD'),('GRL','Greenland','North America','North America',2166090.00,NULL,56000,68.1,0.00,NULL,'Kalaallit Nunaat/Grønland','Part of Denmark','Margrethe II',917,'GL'),('GTM','Guatemala','North America','Central America',108889.00,1821,11385000,66.2,19008.00,17797.00,'Guatemala','Republic','Alfonso Portillo Cabrera',922,'GT'),('GUF','French Guiana','South America','South America',90000.00,NULL,181000,76.1,681.00,NULL,'Guyane française','Overseas Department of France','Jacques Chirac',3014,'GF'),('GUM','Guam','Oceania','Micronesia',549.00,NULL,168000,77.8,1197.00,1136.00,'Guam','US Territory','George W. Bush',921,'GU'),('GUY','Guyana','South America','South America',214969.00,1966,861000,64.0,722.00,743.00,'Guyana','Republic','Bharrat Jagdeo',928,'GY'),('HKG','Hong Kong','Asia','Eastern Asia',1075.00,NULL,6782000,79.5,166448.00,173610.00,'Xianggang/Hong Kong','Special Administrative Region of China','Jiang Zemin',937,'HK'),('HMD','Heard Island and McDonald Islands','Antarctica','Antarctica',359.00,NULL,0,NULL,0.00,NULL,'Heard and McDonald Islands','Territory of Australia','Elisabeth II',NULL,'HM'),('HND','Honduras','North America','Central America',112088.00,1838,6485000,69.9,5333.00,4697.00,'Honduras','Republic','Carlos Roberto Flores Facussé',933,'HN'),('HRV','Croatia','Europe','Southern Europe',56538.00,1991,4473000,73.7,20208.00,19300.00,'Hrvatska','Republic','Štipe Mesic',2409,'HR'),('HTI','Haiti','North America','Caribbean',27750.00,1804,8222000,49.2,3459.00,3107.00,'Haïti/Dayti','Republic','Jean-Bertrand Aristide',929,'HT'),('HUN','Hungary','Europe','Eastern Europe',93030.00,1918,10043200,71.4,48267.00,45914.00,'Magyarország','Republic','Ferenc Mádl',3483,'HU'),('IDN','Indonesia','Asia','Southeast Asia',1904569.00,1945,212107000,68.0,84982.00,215002.00,'Indonesia','Republic','Abdurrahman Wahid',939,'ID'),('IND','India','Asia','Southern and Central Asia',3287263.00,1947,1013662000,62.5,447114.00,430572.00,'Bharat/India','Federal Republic','Kocheril Raman Narayanan',1109,'IN'),('IOT','British Indian Ocean Territory','Africa','Eastern Africa',78.00,NULL,0,NULL,0.00,NULL,'British Indian Ocean Territory','Dependent Territory of the UK','Elisabeth II',NULL,'IO'),('IRL','Ireland','Europe','British Islands',70273.00,1921,3775100,76.8,75921.00,73132.00,'Ireland/Éire','Republic','Mary McAleese',1447,'IE'),('IRN','Iran','Asia','Southern and Central Asia',1648195.00,1906,67702000,69.7,195746.00,160151.00,'Iran','Islamic Republic','Ali Mohammad Khatami-Ardakani',1380,'IR'),('IRQ','Iraq','Asia','Middle East',438317.00,1932,23115000,66.5,11500.00,NULL,'Al-´Iraq','Republic','Saddam Hussein al-Takriti',1365,'IQ'),('ISL','Iceland','Europe','Nordic Countries',103000.00,1944,279000,79.4,8255.00,7474.00,'Ísland','Republic','Ólafur Ragnar Grímsson',1449,'IS'),('ISR','Israel','Asia','Middle East',21056.00,1948,6217000,78.6,97477.00,98577.00,'Yisra’el/Isra’il','Republic','Moshe Katzav',1450,'IL'),('ITA','Italy','Europe','Southern Europe',301316.00,1861,57680000,79.0,1161755.00,1145372.00,'Italia','Republic','Carlo Azeglio Ciampi',1464,'IT'),('JAM','Jamaica','North America','Caribbean',10990.00,1962,2583000,75.2,6871.00,6722.00,'Jamaica','Constitutional Monarchy','Elisabeth II',1530,'JM'),('JOR','Jordan','Asia','Middle East',88946.00,1946,5083000,77.4,7526.00,7051.00,'Al-Urdunn','Constitutional Monarchy','Abdullah II',1786,'JO'),('JPN','Japan','Asia','Eastern Asia',377829.00,-660,126714000,80.7,3787042.00,4192638.00,'Nihon/Nippon','Constitutional Monarchy','Akihito',1532,'JP'),('KAZ','Kazakstan','Asia','Southern and Central Asia',2724900.00,1991,16223000,63.2,24375.00,23383.00,'Qazaqstan','Republic','Nursultan Nazarbajev',1864,'KZ'),('KEN','Kenya','Africa','Eastern Africa',580367.00,1963,30080000,48.0,9217.00,10241.00,'Kenya','Republic','Daniel arap Moi',1881,'KE'),('KGZ','Kyrgyzstan','Asia','Southern and Central Asia',199900.00,1991,4699000,63.4,1626.00,1767.00,'Kyrgyzstan','Republic','Askar Akajev',2253,'KG'),('KHM','Cambodia','Asia','Southeast Asia',181035.00,1953,11168000,56.5,5121.00,5670.00,'Kâmpuchéa','Constitutional Monarchy','Norodom Sihanouk',1800,'KH'),('KIR','Kiribati','Oceania','Micronesia',726.00,1979,83000,59.8,40.70,NULL,'Kiribati','Republic','Teburoro Tito',2256,'KI'),('KNA','Saint Kitts and Nevis','North America','Caribbean',261.00,1983,38000,70.7,299.00,NULL,'Saint Kitts and Nevis','Constitutional Monarchy','Elisabeth II',3064,'KN'),('KOR','South Korea','Asia','Eastern Asia',99434.00,1948,46844000,74.4,320749.00,442544.00,'Taehan Min’guk (Namhan)','Republic','Kim Dae-jung',2331,'KR'),('KWT','Kuwait','Asia','Middle East',17818.00,1961,1972000,76.1,27037.00,30373.00,'Al-Kuwayt','Constitutional Monarchy (Emirate)','Jabir al-Ahmad al-Jabir al-Sabah',2429,'KW'),('LAO','Laos','Asia','Southeast Asia',236800.00,1953,5433000,53.1,1292.00,1746.00,'Lao','Republic','Khamtay Siphandone',2432,'LA'),('LBN','Lebanon','Asia','Middle East',10400.00,1941,3282000,71.3,17121.00,15129.00,'Lubnan','Republic','Émile Lahoud',2438,'LB'),('LBR','Liberia','Africa','Western Africa',111369.00,1847,3154000,51.0,2012.00,NULL,'Liberia','Republic','Charles Taylor',2440,'LR'),('LBY','Libyan Arab Jamahiriya','Africa','Northern Africa',1759540.00,1951,5605000,75.5,44806.00,40562.00,'Libiya','Socialistic State','Muammar al-Qadhafi',2441,'LY'),('LCA','Saint Lucia','North America','Caribbean',622.00,1979,154000,72.3,571.00,NULL,'Saint Lucia','Constitutional Monarchy','Elisabeth II',3065,'LC'),('LIE','Liechtenstein','Europe','Western Europe',160.00,1806,32300,78.8,1119.00,1084.00,'Liechtenstein','Constitutional Monarchy','Hans-Adam II',2446,'LI'),('LKA','Sri Lanka','Asia','Southern and Central Asia',65610.00,1948,18827000,71.8,15706.00,15091.00,'Sri Lanka/Ilankai','Republic','Chandrika Kumaratunga',3217,'LK'),('LSO','Lesotho','Africa','Southern Africa',30355.00,1966,2153000,50.8,1061.00,1161.00,'Lesotho','Constitutional Monarchy','Letsie III',2437,'LS'),('LTU','Lithuania','Europe','Baltic Countries',65301.00,1991,3698500,69.1,10692.00,9585.00,'Lietuva','Republic','Valdas Adamkus',2447,'LT'),('LUX','Luxembourg','Europe','Western Europe',2586.00,1867,435700,77.1,16321.00,15519.00,'Luxembourg/Lëtzebuerg','Constitutional Monarchy','Henri',2452,'LU'),('LVA','Latvia','Europe','Baltic Countries',64589.00,1991,2424200,68.4,6398.00,5639.00,'Latvija','Republic','Vaira Vike-Freiberga',2434,'LV'),('MAC','Macao','Asia','Eastern Asia',18.00,NULL,473000,81.6,5749.00,5940.00,'Macau/Aomen','Special Administrative Region of China','Jiang Zemin',2454,'MO'),('MAR','Morocco','Africa','Northern Africa',446550.00,1956,28351000,69.1,36124.00,33514.00,'Al-Maghrib','Constitutional Monarchy','Mohammed VI',2486,'MA'),('MCO','Monaco','Europe','Western Europe',1.50,1861,34000,78.8,776.00,NULL,'Monaco','Constitutional Monarchy','Rainier III',2695,'MC'),('MDA','Moldova','Europe','Eastern Europe',33851.00,1991,4380000,64.5,1579.00,1872.00,'Moldova','Republic','Vladimir Voronin',2690,'MD'),('MDG','Madagascar','Africa','Eastern Africa',587041.00,1960,15942000,55.0,3750.00,3545.00,'Madagasikara/Madagascar','Federal Republic','Didier Ratsiraka',2455,'MG'),('MDV','Maldives','Asia','Southern and Central Asia',298.00,1965,286000,62.2,199.00,NULL,'Dhivehi Raajje/Maldives','Republic','Maumoon Abdul Gayoom',2463,'MV'),('MEX','Mexico','North America','Central America',1958201.00,1810,98881000,71.5,414972.00,401461.00,'México','Federal Republic','Vicente Fox Quesada',2515,'MX'),('MHL','Marshall Islands','Oceania','Micronesia',181.00,1990,64000,65.5,97.00,NULL,'Marshall Islands/Majol','Republic','Kessai Note',2507,'MH'),('MKD','Macedonia','Europe','Southern Europe',25713.00,1991,2024000,73.8,1694.00,1915.00,'Makedonija','Republic','Boris Trajkovski',2460,'MK'),('MLI','Mali','Africa','Western Africa',1240192.00,1960,11234000,46.7,2642.00,2453.00,'Mali','Republic','Alpha Oumar Konaré',2482,'ML'),('MLT','Malta','Europe','Southern Europe',316.00,1964,380200,77.9,3512.00,3338.00,'Malta','Republic','Guido de Marco',2484,'MT'),('MMR','Myanmar','Asia','Southeast Asia',676578.00,1948,45611000,54.9,180375.00,171028.00,'Myanma Pye','Republic','kenraali Than Shwe',2710,'MM'),('MNG','Mongolia','Asia','Eastern Asia',1566500.00,1921,2662000,67.3,1043.00,933.00,'Mongol Uls','Republic','Natsagiin Bagabandi',2696,'MN'),('MNP','Northern Mariana Islands','Oceania','Micronesia',464.00,NULL,78000,75.5,0.00,NULL,'Northern Mariana Islands','Commonwealth of the US','George W. Bush',2913,'MP'),('MOZ','Mozambique','Africa','Eastern Africa',801590.00,1975,19680000,37.5,2891.00,2711.00,'Moçambique','Republic','Joaquím A. Chissano',2698,'MZ'),('MRT','Mauritania','Africa','Western Africa',1025520.00,1960,2670000,50.8,998.00,1081.00,'Muritaniya/Mauritanie','Republic','Maaouiya Ould Sid´Ahmad Taya',2509,'MR'),('MSR','Montserrat','North America','Caribbean',102.00,NULL,11000,78.0,109.00,NULL,'Montserrat','Dependent Territory of the UK','Elisabeth II',2697,'MS'),('MTQ','Martinique','North America','Caribbean',1102.00,NULL,395000,78.3,2731.00,2559.00,'Martinique','Overseas Department of France','Jacques Chirac',2508,'MQ'),('MUS','Mauritius','Africa','Eastern Africa',2040.00,1968,1158000,71.0,4251.00,4186.00,'Mauritius','Republic','Cassam Uteem',2511,'MU'),('MWI','Malawi','Africa','Eastern Africa',118484.00,1964,10925000,37.6,1687.00,2527.00,'Malawi','Republic','Bakili Muluzi',2462,'MW'),('MYS','Malaysia','Asia','Southeast Asia',329758.00,1957,22244000,70.8,69213.00,97884.00,'Malaysia','Constitutional Monarchy, Federation','Salahuddin Abdul Aziz Shah Alhaj',2464,'MY'),('MYT','Mayotte','Africa','Eastern Africa',373.00,NULL,149000,59.5,0.00,NULL,'Mayotte','Territorial Collectivity of France','Jacques Chirac',2514,'YT'),('NAM','Namibia','Africa','Southern Africa',824292.00,1990,1726000,42.5,3101.00,3384.00,'Namibia','Republic','Sam Nujoma',2726,'NA'),('NCL','New Caledonia','Oceania','Melanesia',18575.00,NULL,214000,72.8,3563.00,NULL,'Nouvelle-Calédonie','Nonmetropolitan Territory of France','Jacques Chirac',3493,'NC'),('NER','Niger','Africa','Western Africa',1267000.00,1960,10730000,41.3,1706.00,1580.00,'Niger','Republic','Mamadou Tandja',2738,'NE'),('NFK','Norfolk Island','Oceania','Australia and New Zealand',36.00,NULL,2000,NULL,0.00,NULL,'Norfolk Island','Territory of Australia','Elisabeth II',2806,'NF'),('NGA','Nigeria','Africa','Western Africa',923768.00,1960,111506000,51.6,65707.00,58623.00,'Nigeria','Federal Republic','Olusegun Obasanjo',2754,'NG'),('NIC','Nicaragua','North America','Central America',130000.00,1838,5074000,68.7,1988.00,2023.00,'Nicaragua','Republic','Arnoldo Alemán Lacayo',2734,'NI'),('NIU','Niue','Oceania','Polynesia',260.00,NULL,2000,NULL,0.00,NULL,'Niue','Nonmetropolitan Territory of New Zealand','Elisabeth II',2805,'NU'),('NLD','Netherlands','Europe','Western Europe',41526.00,1581,15864000,78.3,371362.00,360478.00,'Nederland','Constitutional Monarchy','Beatrix',5,'NL'),('NOR','Norway','Europe','Nordic Countries',323877.00,1905,4478500,78.7,145895.00,153370.00,'Norge','Constitutional Monarchy','Harald V',2807,'NO'),('NPL','Nepal','Asia','Southern and Central Asia',147181.00,1769,23930000,57.8,4768.00,4837.00,'Nepal','Constitutional Monarchy','Gyanendra Bir Bikram',2729,'NP'),('NRU','Nauru','Oceania','Micronesia',21.00,1968,12000,60.8,197.00,NULL,'Naoero/Nauru','Republic','Bernard Dowiyogo',2728,'NR'),('NZL','New Zealand','Oceania','Australia and New Zealand',270534.00,1907,3862000,77.8,54669.00,64960.00,'New Zealand/Aotearoa','Constitutional Monarchy','Elisabeth II',3499,'NZ'),('OMN','Oman','Asia','Middle East',309500.00,1951,2542000,71.8,16904.00,16153.00,'´Uman','Monarchy (Sultanate)','Qabus ibn Sa´id',2821,'OM'),('PAK','Pakistan','Asia','Southern and Central Asia',796095.00,1947,156483000,61.1,61289.00,58549.00,'Pakistan','Republic','Mohammad Rafiq Tarar',2831,'PK'),('PAN','Panama','North America','Central America',75517.00,1903,2856000,75.5,9131.00,8700.00,'Panamá','Republic','Mireya Elisa Moscoso Rodríguez',2882,'PA'),('PCN','Pitcairn','Oceania','Polynesia',49.00,NULL,50,NULL,0.00,NULL,'Pitcairn','Dependent Territory of the UK','Elisabeth II',2912,'PN'),('PER','Peru','South America','South America',1285216.00,1821,25662000,70.0,64140.00,65186.00,'Perú/Piruw','Republic','Valentin Paniagua Corazao',2890,'PE'),('PHL','Philippines','Asia','Southeast Asia',300000.00,1946,75967000,67.5,65107.00,82239.00,'Pilipinas','Republic','Gloria Macapagal-Arroyo',766,'PH'),('PLW','Palau','Oceania','Micronesia',459.00,1994,19000,68.6,105.00,NULL,'Belau/Palau','Republic','Kuniwo Nakamura',2881,'PW'),('PNG','Papua New Guinea','Oceania','Melanesia',462840.00,1975,4807000,63.1,4988.00,6328.00,'Papua New Guinea/Papua Niugini','Constitutional Monarchy','Elisabeth II',2884,'PG'),('POL','Poland','Europe','Eastern Europe',323250.00,1918,38653600,73.2,151697.00,135636.00,'Polska','Republic','Aleksander Kwasniewski',2928,'PL'),('PRI','Puerto Rico','North America','Caribbean',8875.00,NULL,3869000,75.6,34100.00,32100.00,'Puerto Rico','Commonwealth of the US','George W. Bush',2919,'PR'),('PRK','North Korea','Asia','Eastern Asia',120538.00,1948,24039000,70.7,5332.00,NULL,'Choson Minjujuui In´min Konghwaguk (Bukhan)','Socialistic Republic','Kim Jong-il',2318,'KP'),('PRT','Portugal','Europe','Southern Europe',91982.00,1143,9997600,75.8,105954.00,102133.00,'Portugal','Republic','Jorge Sampãio',2914,'PT'),('PRY','Paraguay','South America','South America',406752.00,1811,5496000,73.7,8444.00,9555.00,'Paraguay','Republic','Luis Ángel González Macchi',2885,'PY'),('PSE','Palestine','Asia','Middle East',6257.00,NULL,3101000,71.4,4173.00,NULL,'Filastin','Autonomous Area','Yasser (Yasir) Arafat',4074,'PS'),('PYF','French Polynesia','Oceania','Polynesia',4000.00,NULL,235000,74.8,818.00,781.00,'Polynésie française','Nonmetropolitan Territory of France','Jacques Chirac',3016,'PF'),('QAT','Qatar','Asia','Middle East',11000.00,1971,599000,72.4,9472.00,8920.00,'Qatar','Monarchy','Hamad ibn Khalifa al-Thani',2973,'QA'),('REU','Réunion','Africa','Eastern Africa',2510.00,NULL,699000,72.7,8287.00,7988.00,'Réunion','Overseas Department of France','Jacques Chirac',3017,'RE'),('ROM','Romania','Europe','Eastern Europe',238391.00,1878,22455500,69.9,38158.00,34843.00,'România','Republic','Ion Iliescu',3018,'RO'),('RUS','Russian Federation','Europe','Eastern Europe',17075400.00,1991,146934000,67.2,276608.00,442989.00,'Rossija','Federal Republic','Vladimir Putin',3580,'RU'),('RWA','Rwanda','Africa','Eastern Africa',26338.00,1962,7733000,39.3,2036.00,1863.00,'Rwanda/Urwanda','Republic','Paul Kagame',3047,'RW'),('SAU','Saudi Arabia','Asia','Middle East',2149690.00,1932,21607000,67.8,137635.00,146171.00,'Al-´Arabiya as-Sa´udiya','Monarchy','Fahd ibn Abdul-Aziz al-Sa´ud',3173,'SA'),('SDN','Sudan','Africa','Northern Africa',2505813.00,1956,29490000,56.6,10162.00,NULL,'As-Sudan','Islamic Republic','Omar Hassan Ahmad al-Bashir',3225,'SD'),('SEN','Senegal','Africa','Western Africa',196722.00,1960,9481000,62.2,4787.00,4542.00,'Sénégal/Sounougal','Republic','Abdoulaye Wade',3198,'SN'),('SGP','Singapore','Asia','Southeast Asia',618.00,1965,3567000,80.1,86503.00,96318.00,'Singapore/Singapura/Xinjiapo/Singapur','Republic','Sellapan Rama Nathan',3208,'SG'),('SGS','South Georgia and the South Sandwich Islands','Antarctica','Antarctica',3903.00,NULL,0,NULL,0.00,NULL,'South Georgia and the South Sandwich Islands','Dependent Territory of the UK','Elisabeth II',NULL,'GS'),('SHN','Saint Helena','Africa','Western Africa',314.00,NULL,6000,76.8,0.00,NULL,'Saint Helena','Dependent Territory of the UK','Elisabeth II',3063,'SH'),('SJM','Svalbard and Jan Mayen','Europe','Nordic Countries',62422.00,NULL,3200,NULL,0.00,NULL,'Svalbard og Jan Mayen','Dependent Territory of Norway','Harald V',938,'SJ'),('SLB','Solomon Islands','Oceania','Melanesia',28896.00,1978,444000,71.3,182.00,220.00,'Solomon Islands','Constitutional Monarchy','Elisabeth II',3161,'SB'),('SLE','Sierra Leone','Africa','Western Africa',71740.00,1961,4854000,45.3,746.00,858.00,'Sierra Leone','Republic','Ahmed Tejan Kabbah',3207,'SL'),('SLV','El Salvador','North America','Central America',21041.00,1841,6276000,69.7,11863.00,11203.00,'El Salvador','Republic','Francisco Guillermo Flores Pérez',645,'SV'),('SMR','San Marino','Europe','Southern Europe',61.00,885,27000,81.1,510.00,NULL,'San Marino','Republic',NULL,3171,'SM'),('SOM','Somalia','Africa','Eastern Africa',637657.00,1960,10097000,46.2,935.00,NULL,'Soomaaliya','Republic','Abdiqassim Salad Hassan',3214,'SO'),('SPM','Saint Pierre and Miquelon','North America','North America',242.00,NULL,7000,77.6,0.00,NULL,'Saint-Pierre-et-Miquelon','Territorial Collectivity of France','Jacques Chirac',3067,'PM'),('STP','Sao Tome and Principe','Africa','Central Africa',964.00,1975,147000,65.3,6.00,NULL,'São Tomé e Príncipe','Republic','Miguel Trovoada',3172,'ST'),('SUR','Suriname','South America','South America',163265.00,1975,417000,71.4,870.00,706.00,'Suriname','Republic','Ronald Venetiaan',3243,'SR'),('SVK','Slovakia','Europe','Eastern Europe',49012.00,1993,5398700,73.7,20594.00,19452.00,'Slovensko','Republic','Rudolf Schuster',3209,'SK'),('SVN','Slovenia','Europe','Southern Europe',20256.00,1991,1987800,74.9,19756.00,18202.00,'Slovenija','Republic','Milan Kucan',3212,'SI'),('SWE','Sweden','Europe','Nordic Countries',449964.00,836,8861400,79.6,226492.00,227757.00,'Sverige','Constitutional Monarchy','Carl XVI Gustaf',3048,'SE'),('SWZ','Swaziland','Africa','Southern Africa',17364.00,1968,1008000,40.4,1206.00,1312.00,'kaNgwane','Monarchy','Mswati III',3244,'SZ'),('SYC','Seychelles','Africa','Eastern Africa',455.00,1976,77000,70.4,536.00,539.00,'Sesel/Seychelles','Republic','France-Albert René',3206,'SC'),('SYR','Syria','Asia','Middle East',185180.00,1941,16125000,68.5,65984.00,64926.00,'Suriya','Republic','Bashar al-Assad',3250,'SY'),('TCA','Turks and Caicos Islands','North America','Caribbean',430.00,NULL,17000,73.3,96.00,NULL,'The Turks and Caicos Islands','Dependent Territory of the UK','Elisabeth II',3423,'TC'),('TCD','Chad','Africa','Central Africa',1284000.00,1960,7651000,50.5,1208.00,1102.00,'Tchad/Tshad','Republic','Idriss Déby',3337,'TD'),('TGO','Togo','Africa','Western Africa',56785.00,1960,4629000,54.7,1449.00,1400.00,'Togo','Republic','Gnassingbé Eyadéma',3332,'TG'),('THA','Thailand','Asia','Southeast Asia',513115.00,1350,61399000,68.6,116416.00,153907.00,'Prathet Thai','Constitutional Monarchy','Bhumibol Adulyadej',3320,'TH'),('TJK','Tajikistan','Asia','Southern and Central Asia',143100.00,1991,6188000,64.1,1990.00,1056.00,'Toçikiston','Republic','Emomali Rahmonov',3261,'TJ'),('TKL','Tokelau','Oceania','Polynesia',12.00,NULL,2000,NULL,0.00,NULL,'Tokelau','Nonmetropolitan Territory of New Zealand','Elisabeth II',3333,'TK'),('TKM','Turkmenistan','Asia','Southern and Central Asia',488100.00,1991,4459000,60.9,4397.00,2000.00,'Türkmenostan','Republic','Saparmurad Nijazov',3419,'TM'),('TMP','East Timor','Asia','Southeast Asia',14874.00,NULL,885000,46.0,0.00,NULL,'Timor Timur','Administrated by the UN','José Alexandre Gusmão',1522,'TP'),('TON','Tonga','Oceania','Polynesia',650.00,1970,99000,67.9,146.00,170.00,'Tonga','Monarchy','Taufa\'ahau Tupou IV',3334,'TO'),('TTO','Trinidad and Tobago','North America','Caribbean',5130.00,1962,1295000,68.0,6232.00,5867.00,'Trinidad and Tobago','Republic','Arthur N. R. Robinson',3336,'TT'),('TUN','Tunisia','Africa','Northern Africa',163610.00,1956,9586000,73.7,20026.00,18898.00,'Tunis/Tunisie','Republic','Zine al-Abidine Ben Ali',3349,'TN'),('TUR','Turkey','Asia','Middle East',774815.00,1923,66591000,71.0,210721.00,189122.00,'Türkiye','Republic','Ahmet Necdet Sezer',3358,'TR'),('TUV','Tuvalu','Oceania','Polynesia',26.00,1978,12000,66.3,6.00,NULL,'Tuvalu','Constitutional Monarchy','Elisabeth II',3424,'TV'),('TWN','Taiwan','Asia','Eastern Asia',36188.00,1945,22256000,76.4,256254.00,263451.00,'T’ai-wan','Republic','Chen Shui-bian',3263,'TW'),('TZA','Tanzania','Africa','Eastern Africa',883749.00,1961,33517000,52.3,8005.00,7388.00,'Tanzania','Republic','Benjamin William Mkapa',3306,'TZ'),('UGA','Uganda','Africa','Eastern Africa',241038.00,1962,21778000,42.9,6313.00,6887.00,'Uganda','Republic','Yoweri Museveni',3425,'UG'),('UKR','Ukraine','Europe','Eastern Europe',603700.00,1991,50456000,66.0,42168.00,49677.00,'Ukrajina','Republic','Leonid Kutšma',3426,'UA'),('UMI','United States Minor Outlying Islands','Oceania','Micronesia/Caribbean',16.00,NULL,0,NULL,0.00,NULL,'United States Minor Outlying Islands','Dependent Territory of the US','George W. Bush',NULL,'UM'),('URY','Uruguay','South America','South America',175016.00,1828,3337000,75.2,20831.00,19967.00,'Uruguay','Republic','Jorge Batlle Ibáñez',3492,'UY'),('USA','United States','North America','North America',9363520.00,1776,278357000,77.1,8510700.00,8110900.00,'United States','Federal Republic','George W. Bush',3813,'US'),('UZB','Uzbekistan','Asia','Southern and Central Asia',447400.00,1991,24318000,63.7,14194.00,21300.00,'Uzbekiston','Republic','Islam Karimov',3503,'UZ'),('VAT','Holy See (Vatican City State)','Europe','Southern Europe',0.40,1929,1000,NULL,9.00,NULL,'Santa Sede/Città del Vaticano','Independent Church State','Johannes Paavali II',3538,'VA'),('VCT','Saint Vincent and the Grenadines','North America','Caribbean',388.00,1979,114000,72.3,285.00,NULL,'Saint Vincent and the Grenadines','Constitutional Monarchy','Elisabeth II',3066,'VC'),('VEN','Venezuela','South America','South America',912050.00,1811,24170000,73.1,95023.00,88434.00,'Venezuela','Federal Republic','Hugo Chávez Frías',3539,'VE'),('VGB','Virgin Islands, British','North America','Caribbean',151.00,NULL,21000,75.4,612.00,573.00,'British Virgin Islands','Dependent Territory of the UK','Elisabeth II',537,'VG'),('VIR','Virgin Islands, U.S.','North America','Caribbean',347.00,NULL,93000,78.1,0.00,NULL,'Virgin Islands of the United States','US Territory','George W. Bush',4067,'VI'),('VNM','Vietnam','Asia','Southeast Asia',331689.00,1945,79832000,69.3,21929.00,22834.00,'Viêt Nam','Socialistic Republic','Trân Duc Luong',3770,'VN'),('VUT','Vanuatu','Oceania','Melanesia',12189.00,1980,190000,60.6,261.00,246.00,'Vanuatu','Republic','John Bani',3537,'VU'),('WLF','Wallis and Futuna','Oceania','Polynesia',200.00,NULL,15000,NULL,0.00,NULL,'Wallis-et-Futuna','Nonmetropolitan Territory of France','Jacques Chirac',3536,'WF'),('WSM','Samoa','Oceania','Polynesia',2831.00,1962,180000,69.2,141.00,157.00,'Samoa','Parlementary Monarchy','Malietoa Tanumafili II',3169,'WS'),('YEM','Yemen','Asia','Middle East',527968.00,1918,18112000,59.8,6041.00,5729.00,'Al-Yaman','Republic','Ali Abdallah Salih',1780,'YE'),('YUG','Yugoslavia','Europe','Southern Europe',102173.00,1918,10640000,72.4,17000.00,NULL,'Jugoslavija','Federal Republic','Vojislav Koštunica',1792,'YU'),('ZAF','South Africa','Africa','Southern Africa',1221037.00,1910,40377000,51.1,116729.00,129092.00,'South Africa','Republic','Thabo Mbeki',716,'ZA'),('ZMB','Zambia','Africa','Eastern Africa',752618.00,1964,9169000,37.2,3377.00,3922.00,'Zambia','Republic','Frederick Chiluba',3162,'ZM'),('ZWE','Zimbabwe','Africa','Eastern Africa',390757.00,1980,11669000,37.8,5951.00,8670.00,'Zimbabwe','Republic','Robert G. Mugabe',4068,'ZW');

/*Table structure for table `CountryLang` */

DROP TABLE IF EXISTS `CountryLang`;

CREATE TABLE `CountryLang` (
  `CountryCode` char(3) NOT NULL default '',
  `Language` char(30) NOT NULL default '',
  `IsOfficial` enum('T','F') NOT NULL default 'F',
  `Percentage` float(4,1) NOT NULL default '0.0',
  PRIMARY KEY  (`CountryCode`,`Language`),
  CONSTRAINT `countrylang_ibfk_1` FOREIGN KEY (`CountryCode`) REFERENCES `country` (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;

/*Data for the table `CountryLang` */

insert into `CountryLang` (`CountryCode`,`Language`,`IsOfficial`,`Percentage`) values ('ABW','Dutch','T',5.3),('ABW','English','F',9.5),('ABW','Papiamento','F',76.7),('ABW','Spanish','F',7.4),('AFG','Balochi','F',0.9),('AFG','Dari','T',32.1),('AFG','Pashto','T',52.4),('AFG','Turkmenian','F',1.9),('AFG','Uzbek','F',8.8),('AGO','Ambo','F',2.4),('AGO','Chokwe','F',4.2),('AGO','Kongo','F',13.2),('AGO','Luchazi','F',2.4),('AGO','Luimbe-nganguela','F',5.4),('AGO','Luvale','F',3.6),('AGO','Mbundu','F',21.6),('AGO','Nyaneka-nkhumbi','F',5.4),('AGO','Ovimbundu','F',37.2),('AIA','English','T',0.0),('ALB','Albaniana','T',97.9),('ALB','Greek','F',1.8),('ALB','Macedonian','F',0.1),('AND','Catalan','T',32.3),('AND','French','F',6.2),('AND','Portuguese','F',10.8),('AND','Spanish','F',44.6),('ANT','Dutch','T',0.0),('ANT','English','F',7.8),('ANT','Papiamento','T',86.2),('ARE','Arabic','T',42.0),('ARE','Hindi','F',0.0),('ARG','Indian Languages','F',0.3),('ARG','Italian','F',1.7),('ARG','Spanish','T',96.8),('ARM','Armenian','T',93.4),('ARM','Azerbaijani','F',2.6),('ASM','English','T',3.1),('ASM','Samoan','T',90.6),('ASM','Tongan','F',3.1),('ATG','Creole English','F',95.7),('ATG','English','T',0.0),('AUS','Arabic','F',1.0),('AUS','Canton Chinese','F',1.1),('AUS','English','T',81.2),('AUS','German','F',0.6),('AUS','Greek','F',1.6),('AUS','Italian','F',2.2),('AUS','Serbo-Croatian','F',0.6),('AUS','Vietnamese','F',0.8),('AUT','Czech','F',0.2),('AUT','German','T',92.0),('AUT','Hungarian','F',0.4),('AUT','Polish','F',0.2),('AUT','Romanian','F',0.2),('AUT','Serbo-Croatian','F',2.2),('AUT','Slovene','F',0.4),('AUT','Turkish','F',1.5),('AZE','Armenian','F',2.0),('AZE','Azerbaijani','T',89.0),('AZE','Lezgian','F',2.3),('AZE','Russian','F',3.0),('BDI','French','T',0.0),('BDI','Kirundi','T',98.1),('BDI','Swahili','F',0.0),('BEL','Arabic','F',1.6),('BEL','Dutch','T',59.2),('BEL','French','T',32.6),('BEL','German','T',1.0),('BEL','Italian','F',2.4),('BEL','Turkish','F',0.9),('BEN','Adja','F',11.1),('BEN','Aizo','F',8.7),('BEN','Bariba','F',8.7),('BEN','Fon','F',39.8),('BEN','Ful','F',5.6),('BEN','Joruba','F',12.2),('BEN','Somba','F',6.7),('BFA','Busansi','F',3.5),('BFA','Dagara','F',3.1),('BFA','Dyula','F',2.6),('BFA','Ful','F',9.7),('BFA','Gurma','F',5.7),('BFA','Mossi','F',50.2),('BGD','Bengali','T',97.7),('BGD','Chakma','F',0.4),('BGD','Garo','F',0.1),('BGD','Khasi','F',0.1),('BGD','Marma','F',0.2),('BGD','Santhali','F',0.1),('BGD','Tripuri','F',0.1),('BGR','Bulgariana','T',83.2),('BGR','Macedonian','F',2.6),('BGR','Romani','F',3.7),('BGR','Turkish','F',9.4),('BHR','Arabic','T',67.7),('BHR','English','F',0.0),('BHS','Creole English','F',89.7),('BHS','Creole French','F',10.3),('BIH','Serbo-Croatian','T',99.2),('BLR','Belorussian','T',65.6),('BLR','Polish','F',0.6),('BLR','Russian','T',32.0),('BLR','Ukrainian','F',1.3),('BLZ','English','T',50.8),('BLZ','Garifuna','F',6.8),('BLZ','Maya Languages','F',9.6),('BLZ','Spanish','F',31.6),('BMU','English','T',100.0),('BOL','Aimará','T',3.2),('BOL','Guaraní','F',0.1),('BOL','Ketšua','T',8.1),('BOL','Spanish','T',87.7),('BRA','German','F',0.5),('BRA','Indian Languages','F',0.2),('BRA','Italian','F',0.4),('BRA','Japanese','F',0.4),('BRA','Portuguese','T',97.5),('BRB','Bajan','F',95.1),('BRB','English','T',0.0),('BRN','Chinese','F',9.3),('BRN','English','F',3.1),('BRN','Malay','T',45.5),('BRN','Malay-English','F',28.8),('BTN','Asami','F',15.2),('BTN','Dzongkha','T',50.0),('BTN','Nepali','F',34.8),('BWA','Khoekhoe','F',2.5),('BWA','Ndebele','F',1.3),('BWA','San','F',3.5),('BWA','Shona','F',12.3),('BWA','Tswana','F',75.5),('CAF','Banda','F',23.5),('CAF','Gbaya','F',23.8),('CAF','Mandjia','F',14.8),('CAF','Mbum','F',6.4),('CAF','Ngbaka','F',7.5),('CAF','Sara','F',6.4),('CAN','Chinese','F',2.5),('CAN','Dutch','F',0.5),('CAN','English','T',60.4),('CAN','Eskimo Languages','F',0.1),('CAN','French','T',23.4),('CAN','German','F',1.6),('CAN','Italian','F',1.7),('CAN','Polish','F',0.7),('CAN','Portuguese','F',0.7),('CAN','Punjabi','F',0.7),('CAN','Spanish','F',0.7),('CAN','Ukrainian','F',0.6),('CCK','English','T',0.0),('CCK','Malay','F',0.0),('CHE','French','T',19.2),('CHE','German','T',63.6),('CHE','Italian','T',7.7),('CHE','Romansh','T',0.6),('CHL','Aimará','F',0.5),('CHL','Araucan','F',9.6),('CHL','Rapa nui','F',0.2),('CHL','Spanish','T',89.7),('CHN','Chinese','T',92.0),('CHN','Dong','F',0.2),('CHN','Hui','F',0.8),('CHN','Mantšu','F',0.9),('CHN','Miao','F',0.7),('CHN','Mongolian','F',0.4),('CHN','Puyi','F',0.2),('CHN','Tibetan','F',0.4),('CHN','Tujia','F',0.5),('CHN','Uighur','F',0.6),('CHN','Yi','F',0.6),('CHN','Zhuang','F',1.4),('CIV','Akan','F',30.0),('CIV','Gur','F',11.7),('CIV','Kru','F',10.5),('CIV','Malinke','F',11.4),('CIV','[South]Mande','F',7.7),('CMR','Bamileke-bamum','F',18.6),('CMR','Duala','F',10.9),('CMR','Fang','F',19.7),('CMR','Ful','F',9.6),('CMR','Maka','F',4.9),('CMR','Mandara','F',5.7),('CMR','Masana','F',3.9),('CMR','Tikar','F',7.4),('COD','Boa','F',2.3),('COD','Chokwe','F',1.8),('COD','Kongo','F',16.0),('COD','Luba','F',18.0),('COD','Mongo','F',13.5),('COD','Ngala and Bangi','F',5.8),('COD','Rundi','F',3.8),('COD','Rwanda','F',10.3),('COD','Teke','F',2.7),('COD','Zande','F',6.1),('COG','Kongo','F',51.5),('COG','Mbete','F',4.8),('COG','Mboshi','F',11.4),('COG','Punu','F',2.9),('COG','Sango','F',2.6),('COG','Teke','F',17.3),('COK','English','F',0.0),('COK','Maori','T',0.0),('COL','Arawakan','F',0.1),('COL','Caribbean','F',0.1),('COL','Chibcha','F',0.4),('COL','Creole English','F',0.1),('COL','Spanish','T',99.0),('COM','Comorian','T',75.0),('COM','Comorian-Arabic','F',1.6),('COM','Comorian-French','F',12.9),('COM','Comorian-madagassi','F',5.5),('COM','Comorian-Swahili','F',0.5),('CPV','Crioulo','F',100.0),('CPV','Portuguese','T',0.0),('CRI','Chibcha','F',0.3),('CRI','Chinese','F',0.2),('CRI','Creole English','F',2.0),('CRI','Spanish','T',97.5),('CUB','Spanish','T',100.0),('CXR','Chinese','F',0.0),('CXR','English','T',0.0),('CYM','English','T',0.0),('CYP','Greek','T',74.1),('CYP','Turkish','T',22.4),('CZE','Czech','T',81.2),('CZE','German','F',0.5),('CZE','Hungarian','F',0.2),('CZE','Moravian','F',12.9),('CZE','Polish','F',0.6),('CZE','Romani','F',0.3),('CZE','Silesiana','F',0.4),('CZE','Slovak','F',3.1),('DEU','German','T',91.3),('DEU','Greek','F',0.4),('DEU','Italian','F',0.7),('DEU','Polish','F',0.3),('DEU','Southern Slavic Languages','F',1.4),('DEU','Turkish','F',2.6),('DJI','Afar','F',34.8),('DJI','Arabic','T',10.6),('DJI','Somali','F',43.9),('DMA','Creole English','F',100.0),('DMA','Creole French','F',0.0),('DNK','Arabic','F',0.7),('DNK','Danish','T',93.5),('DNK','English','F',0.3),('DNK','German','F',0.5),('DNK','Norwegian','F',0.3),('DNK','Swedish','F',0.3),('DNK','Turkish','F',0.8),('DOM','Creole French','F',2.0),('DOM','Spanish','T',98.0),('DZA','Arabic','T',86.0),('DZA','Berberi','F',14.0),('ECU','Ketšua','F',7.0),('ECU','Spanish','T',93.0),('EGY','Arabic','T',98.8),('EGY','Sinaberberi','F',0.0),('ERI','Afar','F',4.3),('ERI','Bilin','F',3.0),('ERI','Hadareb','F',3.8),('ERI','Saho','F',3.0),('ERI','Tigre','F',31.7),('ERI','Tigrinja','T',49.1),('ESH','Arabic','T',100.0),('ESP','Basque','F',1.6),('ESP','Catalan','F',16.9),('ESP','Galecian','F',6.4),('ESP','Spanish','T',74.4),('EST','Belorussian','F',1.4),('EST','Estonian','T',65.3),('EST','Finnish','F',0.7),('EST','Russian','F',27.8),('EST','Ukrainian','F',2.8),('ETH','Amhara','F',30.0),('ETH','Gurage','F',4.7),('ETH','Oromo','F',31.0),('ETH','Sidamo','F',3.2),('ETH','Somali','F',4.1),('ETH','Tigrinja','F',7.2),('ETH','Walaita','F',2.8),('FIN','Estonian','F',0.2),('FIN','Finnish','T',92.7),('FIN','Russian','F',0.4),('FIN','Saame','F',0.0),('FIN','Swedish','T',5.7),('FJI','Fijian','T',50.8),('FJI','Hindi','F',43.7),('FLK','English','T',0.0),('FRA','Arabic','F',2.5),('FRA','French','T',93.6),('FRA','Italian','F',0.4),('FRA','Portuguese','F',1.2),('FRA','Spanish','F',0.4),('FRA','Turkish','F',0.4),('FRO','Danish','T',0.0),('FRO','Faroese','T',100.0),('FSM','Kosrean','F',7.3),('FSM','Mortlock','F',7.6),('FSM','Pohnpei','F',23.8),('FSM','Trukese','F',41.6),('FSM','Wolea','F',3.7),('FSM','Yap','F',5.8),('GAB','Fang','F',35.8),('GAB','Mbete','F',13.8),('GAB','Mpongwe','F',14.6),('GAB','Punu-sira-nzebi','F',17.1),('GBR','English','T',97.3),('GBR','Gaeli','F',0.1),('GBR','Kymri','F',0.9),('GEO','Abhyasi','F',1.7),('GEO','Armenian','F',6.8),('GEO','Azerbaijani','F',5.5),('GEO','Georgiana','T',71.7),('GEO','Osseetti','F',2.4),('GEO','Russian','F',8.8),('GHA','Akan','F',52.4),('GHA','Ewe','F',11.9),('GHA','Ga-adangme','F',7.8),('GHA','Gurma','F',3.3),('GHA','Joruba','F',1.3),('GHA','Mossi','F',15.8),('GIB','Arabic','F',7.4),('GIB','English','T',88.9),('GIN','Ful','F',38.6),('GIN','Kissi','F',6.0),('GIN','Kpelle','F',4.6),('GIN','Loma','F',2.3),('GIN','Malinke','F',23.2),('GIN','Susu','F',11.0),('GIN','Yalunka','F',2.9),('GLP','Creole French','F',95.0),('GLP','French','T',0.0),('GMB','Diola','F',9.2),('GMB','Ful','F',16.2),('GMB','Malinke','F',34.1),('GMB','Soninke','F',7.6),('GMB','Wolof','F',12.6),('GNB','Balante','F',14.6),('GNB','Crioulo','F',36.4),('GNB','Ful','F',16.6),('GNB','Malinke','F',6.9),('GNB','Mandyako','F',4.9),('GNB','Portuguese','T',8.1),('GNQ','Bubi','F',8.7),('GNQ','Fang','F',84.8),('GRC','Greek','T',98.5),('GRC','Turkish','F',0.9),('GRD','Creole English','F',100.0),('GRL','Danish','T',12.5),('GRL','Greenlandic','T',87.5),('GTM','Cakchiquel','F',8.9),('GTM','Kekchí','F',4.9),('GTM','Mam','F',2.7),('GTM','Quiché','F',10.1),('GTM','Spanish','T',64.7),('GUF','Creole French','F',94.3),('GUF','Indian Languages','F',1.9),('GUM','Chamorro','T',29.6),('GUM','English','T',37.5),('GUM','Japanese','F',2.0),('GUM','Korean','F',3.3),('GUM','Philippene Languages','F',19.7),('GUY','Arawakan','F',1.4),('GUY','Caribbean','F',2.2),('GUY','Creole English','F',96.4),('HKG','Canton Chinese','F',88.7),('HKG','Chiu chau','F',1.4),('HKG','English','T',2.2),('HKG','Fukien','F',1.9),('HKG','Hakka','F',1.6),('HND','Creole English','F',0.2),('HND','Garifuna','F',1.3),('HND','Miskito','F',0.2),('HND','Spanish','T',97.2),('HRV','Serbo-Croatian','T',95.9),('HRV','Slovene','F',0.0),('HTI','French','T',0.0),('HTI','Haiti Creole','F',100.0),('HUN','German','F',0.4),('HUN','Hungarian','T',98.5),('HUN','Romani','F',0.5),('HUN','Romanian','F',0.1),('HUN','Serbo-Croatian','F',0.2),('HUN','Slovak','F',0.1),('IDN','Bali','F',1.7),('IDN','Banja','F',1.8),('IDN','Batakki','F',2.2),('IDN','Bugi','F',2.2),('IDN','Javanese','F',39.4),('IDN','Madura','F',4.3),('IDN','Malay','T',12.1),('IDN','Minangkabau','F',2.4),('IDN','Sunda','F',15.8),('IND','Asami','F',1.5),('IND','Bengali','F',8.2),('IND','Gujarati','F',4.8),('IND','Hindi','T',39.9),('IND','Kannada','F',3.9),('IND','Malajalam','F',3.6),('IND','Marathi','F',7.4),('IND','Orija','F',3.3),('IND','Punjabi','F',2.8),('IND','Tamil','F',6.3),('IND','Telugu','F',7.8),('IND','Urdu','F',5.1),('IRL','English','T',98.4),('IRL','Irish','T',1.6),('IRN','Arabic','F',2.2),('IRN','Azerbaijani','F',16.8),('IRN','Bakhtyari','F',1.7),('IRN','Balochi','F',2.3),('IRN','Gilaki','F',5.3),('IRN','Kurdish','F',9.1),('IRN','Luri','F',4.3),('IRN','Mazandarani','F',3.6),('IRN','Persian','T',45.7),('IRN','Turkmenian','F',1.6),('IRQ','Arabic','T',77.2),('IRQ','Assyrian','F',0.8),('IRQ','Azerbaijani','F',1.7),('IRQ','Kurdish','F',19.0),('IRQ','Persian','F',0.8),('ISL','English','F',0.0),('ISL','Icelandic','T',95.7),('ISR','Arabic','T',18.0),('ISR','Hebrew','T',63.1),('ISR','Russian','F',8.9),('ITA','Albaniana','F',0.2),('ITA','French','F',0.5),('ITA','Friuli','F',1.2),('ITA','German','F',0.5),('ITA','Italian','T',94.1),('ITA','Romani','F',0.2),('ITA','Sardinian','F',2.7),('ITA','Slovene','F',0.2),('JAM','Creole English','F',94.2),('JAM','Hindi','F',1.9),('JOR','Arabic','T',97.9),('JOR','Armenian','F',1.0),('JOR','Circassian','F',1.0),('JPN','Ainu','F',0.0),('JPN','Chinese','F',0.2),('JPN','English','F',0.1),('JPN','Japanese','T',99.1),('JPN','Korean','F',0.5),('JPN','Philippene Languages','F',0.1),('KAZ','German','F',3.1),('KAZ','Kazakh','T',46.0),('KAZ','Russian','F',34.7),('KAZ','Tatar','F',2.0),('KAZ','Ukrainian','F',5.0),('KAZ','Uzbek','F',2.3),('KEN','Gusii','F',6.1),('KEN','Kalenjin','F',10.8),('KEN','Kamba','F',11.2),('KEN','Kikuyu','F',20.9),('KEN','Luhya','F',13.8),('KEN','Luo','F',12.8),('KEN','Masai','F',1.6),('KEN','Meru','F',5.5),('KEN','Nyika','F',4.8),('KEN','Turkana','F',1.4),('KGZ','Kazakh','F',0.8),('KGZ','Kirgiz','T',59.7),('KGZ','Russian','T',16.2),('KGZ','Tadzhik','F',0.8),('KGZ','Tatar','F',1.3),('KGZ','Ukrainian','F',1.7),('KGZ','Uzbek','F',14.1),('KHM','Chinese','F',3.1),('KHM','Khmer','T',88.6),('KHM','Tšam','F',2.4),('KHM','Vietnamese','F',5.5),('KIR','Kiribati','T',98.9),('KIR','Tuvalu','F',0.5),('KNA','Creole English','F',100.0),('KNA','English','T',0.0),('KOR','Chinese','F',0.1),('KOR','Korean','T',99.9),('KWT','Arabic','T',78.1),('KWT','English','F',0.0),('LAO','Lao','T',67.2),('LAO','Lao-Soung','F',5.2),('LAO','Mon-khmer','F',16.5),('LAO','Thai','F',7.8),('LBN','Arabic','T',93.0),('LBN','Armenian','F',5.9),('LBN','French','F',0.0),('LBR','Bassa','F',13.7),('LBR','Gio','F',7.9),('LBR','Grebo','F',8.9),('LBR','Kpelle','F',19.5),('LBR','Kru','F',7.2),('LBR','Loma','F',5.8),('LBR','Malinke','F',5.1),('LBR','Mano','F',7.2),('LBY','Arabic','T',96.0),('LBY','Berberi','F',1.0),('LCA','Creole French','F',80.0),('LCA','English','T',20.0),('LIE','German','T',89.0),('LIE','Italian','F',2.5),('LIE','Turkish','F',2.5),('LKA','Mixed Languages','F',19.6),('LKA','Singali','T',60.3),('LKA','Tamil','T',19.6),('LSO','English','T',0.0),('LSO','Sotho','T',85.0),('LSO','Zulu','F',15.0),('LTU','Belorussian','F',1.4),('LTU','Lithuanian','T',81.6),('LTU','Polish','F',7.0),('LTU','Russian','F',8.1),('LTU','Ukrainian','F',1.1),('LUX','French','T',4.2),('LUX','German','T',2.3),('LUX','Italian','F',4.6),('LUX','Luxembourgish','T',64.4),('LUX','Portuguese','F',13.0),('LVA','Belorussian','F',4.1),('LVA','Latvian','T',55.1),('LVA','Lithuanian','F',1.2),('LVA','Polish','F',2.1),('LVA','Russian','F',32.5),('LVA','Ukrainian','F',2.9),('MAC','Canton Chinese','F',85.6),('MAC','English','F',0.5),('MAC','Mandarin Chinese','F',1.2),('MAC','Portuguese','T',2.3),('MAR','Arabic','T',65.0),('MAR','Berberi','F',33.0),('MCO','English','F',6.5),('MCO','French','T',41.9),('MCO','Italian','F',16.1),('MCO','Monegasque','F',16.1),('MDA','Bulgariana','F',1.6),('MDA','Gagauzi','F',3.2),('MDA','Romanian','T',61.9),('MDA','Russian','F',23.2),('MDA','Ukrainian','F',8.6),('MDG','French','T',0.0),('MDG','Malagasy','T',98.9),('MDV','Dhivehi','T',100.0),('MDV','English','F',0.0),('MEX','Mixtec','F',0.6),('MEX','Náhuatl','F',1.8),('MEX','Otomí','F',0.4),('MEX','Spanish','T',92.1),('MEX','Yucatec','F',1.1),('MEX','Zapotec','F',0.6),('MHL','English','T',0.0),('MHL','Marshallese','T',96.8),('MKD','Albaniana','F',22.9),('MKD','Macedonian','T',66.5),('MKD','Romani','F',2.3),('MKD','Serbo-Croatian','F',2.0),('MKD','Turkish','F',4.0),('MLI','Bambara','F',31.8),('MLI','Ful','F',13.9),('MLI','Senufo and Minianka','F',12.0),('MLI','Songhai','F',6.9),('MLI','Soninke','F',8.7),('MLI','Tamashek','F',7.3),('MLT','English','T',2.1),('MLT','Maltese','T',95.8),('MMR','Burmese','T',69.0),('MMR','Chin','F',2.2),('MMR','Kachin','F',1.4),('MMR','Karen','F',6.2),('MMR','Kayah','F',0.4),('MMR','Mon','F',2.4),('MMR','Rakhine','F',4.5),('MMR','Shan','F',8.5),('MNG','Bajad','F',1.9),('MNG','Buryat','F',1.7),('MNG','Dariganga','F',1.4),('MNG','Dorbet','F',2.7),('MNG','Kazakh','F',5.9),('MNG','Mongolian','T',78.8),('MNP','Carolinian','F',4.8),('MNP','Chamorro','F',30.0),('MNP','Chinese','F',7.1),('MNP','English','T',4.8),('MNP','Korean','F',6.5),('MNP','Philippene Languages','F',34.1),('MOZ','Chuabo','F',5.7),('MOZ','Lomwe','F',7.8),('MOZ','Makua','F',27.8),('MOZ','Marendje','F',3.5),('MOZ','Nyanja','F',3.3),('MOZ','Ronga','F',3.7),('MOZ','Sena','F',9.4),('MOZ','Shona','F',6.5),('MOZ','Tsonga','F',12.4),('MOZ','Tswa','F',6.0),('MRT','Ful','F',1.2),('MRT','Hassaniya','F',81.7),('MRT','Soninke','F',2.7),('MRT','Tukulor','F',5.4),('MRT','Wolof','F',6.6),('MRT','Zenaga','F',1.2),('MSR','English','T',0.0),('MTQ','Creole French','F',96.6),('MTQ','French','T',0.0),('MUS','Bhojpuri','F',21.1),('MUS','Creole French','F',70.6),('MUS','French','F',3.4),('MUS','Hindi','F',1.2),('MUS','Marathi','F',0.7),('MUS','Tamil','F',0.8),('MWI','Chichewa','T',58.3),('MWI','Lomwe','F',18.4),('MWI','Ngoni','F',6.7),('MWI','Yao','F',13.2),('MYS','Chinese','F',9.0),('MYS','Dusun','F',1.1),('MYS','English','F',1.6),('MYS','Iban','F',2.8),('MYS','Malay','T',58.4),('MYS','Tamil','F',3.9),('MYT','French','T',20.3),('MYT','Mahoré','F',41.9),('MYT','Malagasy','F',16.1),('NAM','Afrikaans','F',9.5),('NAM','Caprivi','F',4.7),('NAM','German','F',0.9),('NAM','Herero','F',8.0),('NAM','Kavango','F',9.7),('NAM','Nama','F',12.4),('NAM','Ovambo','F',50.7),('NAM','San','F',1.9),('NCL','French','T',34.3),('NCL','Malenasian Languages','F',45.4),('NCL','Polynesian Languages','F',11.6),('NER','Ful','F',9.7),('NER','Hausa','F',53.1),('NER','Kanuri','F',4.4),('NER','Songhai-zerma','F',21.2),('NER','Tamashek','F',10.4),('NFK','English','T',0.0),('NGA','Bura','F',1.6),('NGA','Edo','F',3.3),('NGA','Ful','F',11.3),('NGA','Hausa','F',21.1),('NGA','Ibibio','F',5.6),('NGA','Ibo','F',18.1),('NGA','Ijo','F',1.8),('NGA','Joruba','F',21.4),('NGA','Kanuri','F',4.1),('NGA','Tiv','F',2.3),('NIC','Creole English','F',0.5),('NIC','Miskito','F',1.6),('NIC','Spanish','T',97.6),('NIC','Sumo','F',0.2),('NIU','English','T',0.0),('NIU','Niue','F',0.0),('NLD','Arabic','F',0.9),('NLD','Dutch','T',95.6),('NLD','Fries','F',3.7),('NLD','Turkish','F',0.8),('NOR','Danish','F',0.4),('NOR','English','F',0.5),('NOR','Norwegian','T',96.6),('NOR','Saame','F',0.0),('NOR','Swedish','F',0.3),('NPL','Bhojpuri','F',7.5),('NPL','Hindi','F',3.0),('NPL','Maithili','F',11.9),('NPL','Nepali','T',50.4),('NPL','Newari','F',3.7),('NPL','Tamang','F',4.9),('NPL','Tharu','F',5.4),('NRU','Chinese','F',8.5),('NRU','English','T',7.5),('NRU','Kiribati','F',17.9),('NRU','Nauru','T',57.5),('NRU','Tuvalu','F',8.5),('NZL','English','T',87.0),('NZL','Maori','F',4.3),('OMN','Arabic','T',76.7),('OMN','Balochi','F',0.0),('PAK','Balochi','F',3.0),('PAK','Brahui','F',1.2),('PAK','Hindko','F',2.4),('PAK','Pashto','F',13.1),('PAK','Punjabi','F',48.2),('PAK','Saraiki','F',9.8),('PAK','Sindhi','F',11.8),('PAK','Urdu','T',7.6),('PAN','Arabic','F',0.6),('PAN','Creole English','F',14.0),('PAN','Cuna','F',2.0),('PAN','Embera','F',0.6),('PAN','Guaymí','F',5.3),('PAN','Spanish','T',76.8),('PCN','Pitcairnese','F',0.0),('PER','Aimará','T',2.3),('PER','Ketšua','T',16.4),('PER','Spanish','T',79.8),('PHL','Bicol','F',5.7),('PHL','Cebuano','F',23.3),('PHL','Hiligaynon','F',9.1),('PHL','Ilocano','F',9.3),('PHL','Maguindanao','F',1.4),('PHL','Maranao','F',1.3),('PHL','Pampango','F',3.0),('PHL','Pangasinan','F',1.8),('PHL','Pilipino','T',29.3),('PHL','Waray-waray','F',3.8),('PLW','Chinese','F',1.6),('PLW','English','T',3.2),('PLW','Palau','T',82.2),('PLW','Philippene Languages','F',9.2),('PNG','Malenasian Languages','F',20.0),('PNG','Papuan Languages','F',78.1),('POL','Belorussian','F',0.5),('POL','German','F',1.3),('POL','Polish','T',97.6),('POL','Ukrainian','F',0.6),('PRI','English','F',47.4),('PRI','Spanish','T',51.3),('PRK','Chinese','F',0.1),('PRK','Korean','T',99.9),('PRT','Portuguese','T',99.0),('PRY','German','F',0.9),('PRY','Guaraní','T',40.1),('PRY','Portuguese','F',3.2),('PRY','Spanish','T',55.1),('PSE','Arabic','F',95.9),('PSE','Hebrew','F',4.1),('PYF','Chinese','F',2.9),('PYF','French','T',40.8),('PYF','Tahitian','F',46.4),('QAT','Arabic','T',40.7),('QAT','Urdu','F',0.0),('REU','Chinese','F',2.8),('REU','Comorian','F',2.8),('REU','Creole French','F',91.5),('REU','Malagasy','F',1.4),('REU','Tamil','F',0.0),('ROM','German','F',0.4),('ROM','Hungarian','F',7.2),('ROM','Romani','T',0.7),('ROM','Romanian','T',90.7),('ROM','Serbo-Croatian','F',0.1),('ROM','Ukrainian','F',0.3),('RUS','Avarian','F',0.4),('RUS','Bashkir','F',0.7),('RUS','Belorussian','F',0.3),('RUS','Chechen','F',0.6),('RUS','Chuvash','F',0.9),('RUS','Kazakh','F',0.4),('RUS','Mari','F',0.4),('RUS','Mordva','F',0.5),('RUS','Russian','T',86.6),('RUS','Tatar','F',3.2),('RUS','Udmur','F',0.3),('RUS','Ukrainian','F',1.3),('RWA','French','T',0.0),('RWA','Rwanda','T',100.0),('SAU','Arabic','T',95.0),('SDN','Arabic','T',49.4),('SDN','Bari','F',2.5),('SDN','Beja','F',6.4),('SDN','Chilluk','F',1.7),('SDN','Dinka','F',11.5),('SDN','Fur','F',2.1),('SDN','Lotuko','F',1.5),('SDN','Nubian Languages','F',8.1),('SDN','Nuer','F',4.9),('SDN','Zande','F',2.7),('SEN','Diola','F',5.0),('SEN','Ful','F',21.7),('SEN','Malinke','F',3.8),('SEN','Serer','F',12.5),('SEN','Soninke','F',1.3),('SEN','Wolof','T',48.1),('SGP','Chinese','T',77.1),('SGP','Malay','T',14.1),('SGP','Tamil','T',7.4),('SHN','English','T',0.0),('SJM','Norwegian','T',0.0),('SJM','Russian','F',0.0),('SLB','Malenasian Languages','F',85.6),('SLB','Papuan Languages','F',8.6),('SLB','Polynesian Languages','F',3.8),('SLE','Bullom-sherbro','F',3.8),('SLE','Ful','F',3.8),('SLE','Kono-vai','F',5.1),('SLE','Kuranko','F',3.4),('SLE','Limba','F',8.3),('SLE','Mende','F',34.8),('SLE','Temne','F',31.8),('SLE','Yalunka','F',3.4),('SLV','Nahua','F',0.0),('SLV','Spanish','T',100.0),('SMR','Italian','T',100.0),('SOM','Arabic','T',0.0),('SOM','Somali','T',98.3),('SPM','French','T',0.0),('STP','Crioulo','F',86.3),('STP','French','F',0.7),('SUR','Hindi','F',0.0),('SUR','Sranantonga','F',81.0),('SVK','Czech and Moravian','F',1.1),('SVK','Hungarian','F',10.5),('SVK','Romani','F',1.7),('SVK','Slovak','T',85.6),('SVK','Ukrainian and Russian','F',0.6),('SVN','Hungarian','F',0.5),('SVN','Serbo-Croatian','F',7.9),('SVN','Slovene','T',87.9),('SWE','Arabic','F',0.8),('SWE','Finnish','F',2.4),('SWE','Norwegian','F',0.5),('SWE','Southern Slavic Languages','F',1.3),('SWE','Spanish','F',0.6),('SWE','Swedish','T',89.5),('SWZ','Swazi','T',89.9),('SWZ','Zulu','F',2.0),('SYC','English','T',3.8),('SYC','French','T',1.3),('SYC','Seselwa','F',91.3),('SYR','Arabic','T',90.0),('SYR','Kurdish','F',9.0),('TCA','English','T',0.0),('TCD','Arabic','T',12.3),('TCD','Gorane','F',6.2),('TCD','Hadjarai','F',6.7),('TCD','Kanem-bornu','F',9.0),('TCD','Mayo-kebbi','F',11.5),('TCD','Ouaddai','F',8.7),('TCD','Sara','F',27.7),('TCD','Tandjile','F',6.5),('TGO','Ane','F',5.7),('TGO','Ewe','T',23.2),('TGO','Gurma','F',3.4),('TGO','Kabyé','T',13.8),('TGO','Kotokoli','F',5.7),('TGO','Moba','F',5.4),('TGO','Naudemba','F',4.1),('TGO','Watyi','F',10.3),('THA','Chinese','F',12.1),('THA','Khmer','F',1.3),('THA','Kuy','F',1.1),('THA','Lao','F',26.9),('THA','Malay','F',3.6),('THA','Thai','T',52.6),('TJK','Russian','F',9.7),('TJK','Tadzhik','T',62.2),('TJK','Uzbek','F',23.2),('TKL','English','T',0.0),('TKL','Tokelau','F',0.0),('TKM','Kazakh','F',2.0),('TKM','Russian','F',6.7),('TKM','Turkmenian','T',76.7),('TKM','Uzbek','F',9.2),('TMP','Portuguese','T',0.0),('TMP','Sunda','F',0.0),('TON','English','T',0.0),('TON','Tongan','T',98.3),('TTO','Creole English','F',2.9),('TTO','English','F',93.5),('TTO','Hindi','F',3.4),('TUN','Arabic','T',69.9),('TUN','Arabic-French','F',26.3),('TUN','Arabic-French-English','F',3.2),('TUR','Arabic','F',1.4),('TUR','Kurdish','F',10.6),('TUR','Turkish','T',87.6),('TUV','English','T',0.0),('TUV','Kiribati','F',7.5),('TUV','Tuvalu','T',92.5),('TWN','Ami','F',0.6),('TWN','Atayal','F',0.4),('TWN','Hakka','F',11.0),('TWN','Mandarin Chinese','T',20.1),('TWN','Min','F',66.7),('TWN','Paiwan','F',0.3),('TZA','Chaga and Pare','F',4.9),('TZA','Gogo','F',3.9),('TZA','Ha','F',3.5),('TZA','Haya','F',5.9),('TZA','Hehet','F',6.9),('TZA','Luguru','F',4.9),('TZA','Makonde','F',5.9),('TZA','Nyakusa','F',5.4),('TZA','Nyamwesi','F',21.1),('TZA','Shambala','F',4.3),('TZA','Swahili','T',8.8),('UGA','Acholi','F',4.4),('UGA','Ganda','F',18.1),('UGA','Gisu','F',4.5),('UGA','Kiga','F',8.3),('UGA','Lango','F',5.9),('UGA','Lugbara','F',4.7),('UGA','Nkole','F',10.7),('UGA','Rwanda','F',3.2),('UGA','Soga','F',8.2),('UGA','Teso','F',6.0),('UKR','Belorussian','F',0.3),('UKR','Bulgariana','F',0.3),('UKR','Hungarian','F',0.3),('UKR','Polish','F',0.1),('UKR','Romanian','F',0.7),('UKR','Russian','F',32.9),('UKR','Ukrainian','T',64.7),('UMI','English','T',0.0),('URY','Spanish','T',95.7),('USA','Chinese','F',0.6),('USA','English','T',86.2),('USA','French','F',0.7),('USA','German','F',0.7),('USA','Italian','F',0.6),('USA','Japanese','F',0.2),('USA','Korean','F',0.3),('USA','Polish','F',0.3),('USA','Portuguese','F',0.2),('USA','Spanish','F',7.5),('USA','Tagalog','F',0.4),('USA','Vietnamese','F',0.2),('UZB','Karakalpak','F',2.0),('UZB','Kazakh','F',3.8),('UZB','Russian','F',10.9),('UZB','Tadzhik','F',4.4),('UZB','Tatar','F',1.8),('UZB','Uzbek','T',72.6),('VAT','Italian','T',0.0),('VCT','Creole English','F',99.1),('VCT','English','T',0.0),('VEN','Goajiro','F',0.4),('VEN','Spanish','T',96.9),('VEN','Warrau','F',0.1),('VGB','English','T',0.0),('VIR','English','T',81.7),('VIR','French','F',2.5),('VIR','Spanish','F',13.3),('VNM','Chinese','F',1.4),('VNM','Khmer','F',1.4),('VNM','Man','F',0.7),('VNM','Miao','F',0.9),('VNM','Muong','F',1.5),('VNM','Nung','F',1.1),('VNM','Thai','F',1.6),('VNM','Tho','F',1.8),('VNM','Vietnamese','T',86.8),('VUT','Bislama','T',56.6),('VUT','English','T',28.3),('VUT','French','T',14.2),('WLF','Futuna','F',0.0),('WLF','Wallis','F',0.0),('WSM','English','T',0.6),('WSM','Samoan','T',47.5),('WSM','Samoan-English','F',52.0),('YEM','Arabic','T',99.6),('YEM','Soqutri','F',0.0),('YUG','Albaniana','F',16.5),('YUG','Hungarian','F',3.4),('YUG','Macedonian','F',0.5),('YUG','Romani','F',1.4),('YUG','Serbo-Croatian','T',75.2),('YUG','Slovak','F',0.7),('ZAF','Afrikaans','T',14.3),('ZAF','English','T',8.5),('ZAF','Ndebele','F',1.5),('ZAF','Northsotho','F',9.1),('ZAF','Southsotho','F',7.6),('ZAF','Swazi','F',2.5),('ZAF','Tsonga','F',4.3),('ZAF','Tswana','F',8.1),('ZAF','Venda','F',2.2),('ZAF','Xhosa','T',17.7),('ZAF','Zulu','T',22.7),('ZMB','Bemba','F',29.7),('ZMB','Chewa','F',5.7),('ZMB','Lozi','F',6.4),('ZMB','Nsenga','F',4.3),('ZMB','Nyanja','F',7.8),('ZMB','Tongan','F',11.0),('ZWE','English','T',2.2),('ZWE','Ndebele','F',16.2),('ZWE','Nyanja','F',2.2),('ZWE','Shona','F',72.1);

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;