PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "country" (
"Code" CHAR(3),
"Continent" TEXT,
"Region" CHAR(26),
"LocalName" CHAR(45),
"GovernmentForm" CHAR(45),
"HeadOfState" CHAR(60),
PRIMARY KEY ("Code")
);





INSERT INTO "country" VALUES ("AGO", "Africa", "Southern Africa", "Angola", "Republic", "Jose Eduardo dos Santos");
INSERT INTO "country" VALUES ("DZA", "Africa", "Northern Africa", "Algeria", "Republic", "Abdelaziz Bouteflika");
INSERT INTO "country" VALUES ("BEN", "Africa", "Western Africa", "Benin", "Republic", "Mathieu Kerekou");
INSERT INTO "country" VALUES ("BWA", "Africa", "Southern Africa", "Botswana", "Republic", "Festus Mogae");
INSERT INTO "country" VALUES ("BFA", "Africa", "Western Africa", "Burkina Faso", "Republic", "Blaise Compaore");
INSERT INTO "country" VALUES ("BDI", "Africa", "Eastern Africa", "Burundi", "Republic", "Pierre Buyoya");
INSERT INTO "country" VALUES ("CMR", "Africa", "Central Africa", "Cameroon", "Republic", "Paul Biya");
INSERT INTO "country" VALUES ("CPV", "Africa", "Western Africa", "Cape Verde", "Republic", "Pedro Verona Rodrigues Pires");
INSERT INTO "country" VALUES ("CAF", "Africa", "Central Africa", "Central African Republic", "Republic", "Ange-Felix Patasse");
INSERT INTO "country" VALUES ("TCD", "Africa", "Central Africa", "Chad", "Republic", "Idriss Deby");
INSERT INTO "country" VALUES ("COM", "Africa", "Eastern Africa", "Comoros", "Republic", "Azali Assoumani");
INSERT INTO "country" VALUES ("COG", "Africa", "Central Africa", "Congo", "Republic", "Denis Sassou-Nguesso");
INSERT INTO "country" VALUES ("CIV", "Africa", "Western Africa", "Cote dIvoire", "Republic", "Laurent Gbagbo");
INSERT INTO "country" VALUES ("COD", "Africa", "Central Africa", "Congo, The Democratic Republic of the", "Republic", "Joseph Kabila");
INSERT INTO "country" VALUES ("DJI", "Africa", "Eastern Africa", "Djibouti", "Republic", "Ismail Omar Guelleh");
INSERT INTO "country" VALUES ("EGY", "Africa", "Northern Africa", "Egypt", "Republic", "Mohamed Hosni Mubarak");
INSERT INTO "country" VALUES ("GNQ", "Africa", "Central Africa", "Equatorial Guinea", "Republic", "Teodoro Obiang Nguema Mbasogo");
INSERT INTO "country" VALUES ("ERI", "Africa", "Eastern Africa", "Eritrea", "Republic", "Isaias Afewerki");
INSERT INTO "country" VALUES ("ETH", "Africa", "Eastern Africa", "Ethiopia", "Republic", "Girma Wolde-Giorgis");
INSERT INTO "country" VALUES ("GAB", "Africa", "Central Africa", "Gabon", "Republic", "Omar Bongo");
INSERT INTO "country" VALUES ("GMB", "Africa", "Western Africa", "Gambia", "Republic", "Yahya Jammeh");
INSERT INTO "country" VALUES ("GHA", "Africa", "Western Africa", "Ghana", "Republic", "John Kufuor");
INSERT INTO "country" VALUES ("GIN", "Africa", "Western Africa", "Guinea", "Republic", "Lansana Conte");
INSERT INTO "country" VALUES ("GNB", "Africa", "Western Africa", "Guinea-Bissau", "Republic", "Kumba Iala");
INSERT INTO "country" VALUES ("KEN", "Africa", "Eastern Africa", "Kenya", "Republic", "Daniel arap Moi");
INSERT INTO "country" VALUES ("LSO", "Africa", "Southern Africa", "Lesotho", "Constitutional Monarchy", "Letsie III");
INSERT INTO "country" VALUES ("LBR", "Africa", "Western Africa", "Liberia", "Republic", "Moses Z. Blah");
INSERT INTO "country" VALUES ("LBY", "Africa", "Northern Africa", "Libyan Arab Jamahiriya", "Socialist Peoples Libyan Arab Jamahiriya", "Muammar al-Gaddafi");
INSERT INTO "country" VALUES ("MDG", "Africa", "Eastern Africa", "Madagascar", "Republic", "Marc Ravalomanana");
INSERT INTO "country" VALUES ("MWI", "Africa", "Eastern Africa", "Malawi", "Republic", "Bakili Muluzi");
INSERT INTO "country" VALUES ("MLI", "Africa", "Western Africa", "Mali", "Republic", "Amadou Toumani Toure");
INSERT INTO "country" VALUES ("MRT", "Africa", "Western Africa", "Mauritania", "Republic", "Maaouiya Ould Taya");
INSERT INTO "country" VALUES ("MUS", "Africa", "Eastern Africa", "Mauritius", "Republic", "Karl Offmann");
INSERT INTO "country" VALUES ("MAR", "Africa", "Northern Africa", "Morocco", "Constitutional Monarchy", "Mohammed VI");
INSERT INTO "country" VALUES ("MOZ", "Africa", "Eastern Africa", "Mozambique", "Republic", "Joaquim Alberto Chissano");
INSERT INTO "country" VALUES ("NAM", "Africa", "Southern Africa", "Namibia", "Republic", "Sam Nujoma");
INSERT INTO "country" VALUES ("NER", "Africa", "Western Africa", "Niger", "Republic", "Mamadou Tandja");
INSERT INTO "country" VALUES ("NGA", "Africa", "Western Africa", "Nigeria", "Federal Republic", "Olusegun Obasanjo");
INSERT INTO "country" VALUES ("REU", "Africa", "Eastern Africa", "Reunion", "Overseas Department", "Jacques Chirac");
INSERT INTO "country" VALUES ("RWA", "Africa", "Eastern Africa", "Rwanda", "Republic", "Paul Kagame");
INSERT INTO "country" VALUES ("STP", "Africa", "Central Africa", "Sao Tome and Principe", "Republic", "Fradique de Menezes");
INSERT INTO "country" VALUES ("SEN", "Africa", "Western Africa", "Senegal", "Republic", "Abdoulaye Wade");
INSERT INTO "country" VALUES ("SYC", "Africa", "Eastern Africa", "Seychelles", "Republic", "France Albert Rene");
INSERT INTO "country" VALUES ("SLE", "Africa", "Western Africa", "Sierra Leone", "Republic", "Ahmad Tejan Kabbah");
INSERT INTO "country" VALUES ("SOM", "Africa", "Eastern Africa", "Somalia", "Republic transitional", "Abdiqasim Salad Hassan");
INSERT INTO "country" VALUES ("ZAF", "Africa", "Southern Africa", "South Africa", "Republic", "Thabo Mbeki");
INSERT INTO "country" VALUES ("SDN", "Africa", "Northern Africa", "Sudan", "Republic", "Omar Hassan Ahmad al-Bashir");
INSERT INTO "country" VALUES ("SWZ", "Africa", "Southern Africa", "Swaziland", "Absolute Monarchy", "Mswati III");
INSERT INTO "country" VALUES ("TZA", "Africa", "Eastern Africa", "Tanzania", "Republic", "Benjamin William Mkapa");
INSERT INTO "country" VALUES ("TGO", "Africa", "Western Africa", "Togo", "Republic", "Gnassingbe Eyadema");
INSERT INTO "country" VALUES ("TUN", "Africa", "Northern Africa", "Tunisia", "Republic", "Zine al-Abidine Ben Ali");
INSERT INTO "country" VALUES ("UGA", "Africa", "Eastern Africa", "Uganda", "Republic", "Yoweri Museveni");
INSERT INTO "country" VALUES ("ESH", "Africa", "Northern Africa", "Western Sahara", "Occupied Territory", "Mohammed VI");
INSERT INTO "country" VALUES ("ZMB", "Africa", "Eastern Africa", "Zambia", "Republic", "Frederick Chiluba");
INSERT INTO "country" VALUES ("ZWE", "Africa", "Eastern Africa", "Zimbabwe", "Republic", "Robert Gabriel Mugabe");
INSERT INTO "country" VALUES ("GBR", "Europe", "Western Europe", "United Kingdom", "Constitutional Monarchy", "Elisabeth II");
INSERT INTO "country" VALUES ("USA", "North America", "North America", "United States", "Federal Republic", "George W. Bush");
INSERT INTO "country" VALUES ("CAN", "North America", "North America", "Canada", "Constitutional Monarchy", "Elisabeth II");
INSERT INTO "country" VALUES ("AUS", "Oceania", "Australia and New Zealand", "Australia", "Constitutional Monarchy", "Elisabeth II");
INSERT INTO "country" VALUES ("IND", "Asia", "Southern and Central Asia", "India", "Federal Republic", "Kocheril Raman Narayanan");
INSERT INTO "country" VALUES ("CHN", "Asia", "Eastern Asia", "China", "Peoples Republic", "Jiang Zemin");
INSERT INTO "country" VALUES ("JPN", "Asia", "Eastern Asia", "Japan", "Constitutional Monarchy", "Akihito");
INSERT INTO "country" VALUES ("BRA", "South America", "South America", "Brazil", "Federal Republic", "Fernando Henrique Cardoso");
INSERT INTO "country" VALUES ("ARG", "South America", "South America", "Argentina", "Federal Republic", "Eduardo Duhalde");
INSERT INTO "country" VALUES ("DEU", "Europe", "Western Europe", "Germany", "Federal Republic", "Johannes Rau");
INSERT INTO "country" VALUES ("FRA", "Europe", "Western Europe", "France", "Republic", "Jacques Chirac");
INSERT INTO "country" VALUES ("ITA", "Europe", "Southern Europe", "Italy", "Republic", "Carlo Azeglio Ciampi");
INSERT INTO "country" VALUES ("ESP", "Europe", "Southern Europe", "Spain", "Constitutional Monarchy", "Juan Carlos I");
INSERT INTO "country" VALUES ("RUS", "Europe", "Eastern Europe", "Russian Federation", "Federal Republic", "Vladimir Putin");
INSERT INTO "country" VALUES ("MEX", "North America", "Central America", "Mexico", "Federal Republic", "Vicente Fox Quesada");