-- SQL Server version of SQL dump

-- Create Database
IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = N'countries')
BEGIN
    CREATE DATABASE [countries];
END
GO

USE [countries];
GO

-- Table structure for table 'capitals'
IF OBJECT_ID('[capitals]', 'U') IS NOT NULL
    DROP TABLE [capitals];
GO

CREATE TABLE [capitals] (
  [alpha_2_code] varchar(2) NOT NULL,
  [country_capital] varchar(255) NOT NULL,
  PRIMARY KEY ([alpha_2_code])
);
GO

-- Dumping data for table 'capitals'
INSERT INTO [capitals] ([alpha_2_code], [country_capital]) VALUES
('AD','Andorra la Vella'),('AE','Abu Dhabi'),('AF','Kabul'),('AG','St. John''s'),('AL','Tiranë (Tirana)'),('AM','Yerevan'),('AO','Luanda'),('AR','Buenos Aires'),('AT','Wien (Vienna)'),('AU','Canberra'),('AZ','Baku'),('BA','Sarajevo'),('BB','Bridgetown'),('BD','Dhaka'),('BE','Bruxelles-Brussel'),('BF','Ouagadougou'),('BG','Sofia'),('BH','Al-Manamah (Manama)'),('BI','Bujumbura'),('BJ','Porto-Novo'),('BN','Bandar Seri Begawan'),('BO','La Paz (Administrative), Sucre (Constitutional)'),('BR','Brasília'),('BS','Nassau'),('BT','Thimphu'),('BW','Gaborone'),('BY','Minsk'),('BZ','Belmopan'),('CA','Ottawa'),('CD','Kinshasa'),('CF','Bangui'),('CG','Brazzaville'),('CH','Bern'),('CL','Santiago'),('CM','Yaoundé'),('CN','Beijing'),('CO','Bogotá'),('CR','San José'),('CU','La Habana (Havana)'),('CV','Praia'),('CY','Lefkosia (Nicosia)'),('CZ','Praha (Prague)'),('DE','Berlin'),('DJ','Djibouti'),('DK','København (Copenhagen)'),('DM','Roseau'),('DO','Santo Domingo'),('DZ','El Djazaïr (Algiers)'),('EC','Quito'),('EE','Tallinn'),('EG','Al-Qahirah (Cairo)'),('ER','Asmara'),('ES','Madrid'),('ET','Addis Ababa'),('FI','Helsinki'),('FJ','Suva'),('FM','Palikir'),('FR','Paris'),('GA','Libreville'),('GB','London'),('GD','St. George''s'),('GE','Tbilisi'),('GH','Accra'),('GM','Banjul'),('GN','Conakry'),('GQ','Malabo'),('GR','Athina (Athens)'),('GT','Guatemala City'),('GW','Bissau'),('GY','Georgetown'),('HN','Tegucigalpa'),('HR','Zagreb'),('HT','Port-au-Prince'),('HU','Budapest'),('ID','Jakarta'),('IE','Dublin'),('IL','Jerusalem'),('IN','NEW Delhi'),('IQ','Baghdad'),('IR','Tehran'),('IS','Reykjavík'),('IT','Roma (Rome)'),('JM','Kingston'),('JO','Amman'),('JP','Tokyo'),('KE','Nairobi'),('KG','Bishkek'),('KH','Phnum Pénh (Phnom Penh)'),('KI','Tarawa'),('KM','Moroni'),('KN','Basseterre'),('KP','P''yongyang'),('KR','Seoul'),('KW','Al-Kuwait (Kuwait City)'),('KZ','Nur-Sultan'),('LA','Viangchan (Vientiane)'),('LB','Beirut'),('LC','Castries'),('LI','Vaduz'),('LK','Sri Jayewardenepura Kotte'),('LR','Monrovia'),('LS','Maseru'),('LT','Vilnius'),('LU','Luxembourg'),('LV','Riga'),('LY','Tripoli'),('MA','Rabat'),('MC','Monaco'),('MD','Chişinău'),('ME','Podgorica'),('MG','Antananarivo'),('ML','Bamako'),('MM','Nay Pyi Taw'),('MN','Ulaanbaatar'),('MR','Nouakchott'),('MT','Valletta'),('MU','Port Louis'),('MV','Malé'),('MW','Lilongwe'),('MX','Ciudad de México (Mexico City)'),('MY','Kuala Lumpur'),('MZ','Maputo'),('NA','Windhoek'),('NE','Niamey'),('NG','Abuja'),('NI','Managua'),('NL','Amsterdam'),('NO','Oslo'),('NP','Kathmandu'),('NR','Yaren'),('NZ','Wellington'),('OM','Masqat (Muscat)'),('PA','Panamá (Panama City)'),('PE','Lima'),('PG','Port Moresby'),('PH','Manila'),('PK','Islamabad'),('PL','Warszawa (Warsaw)'),('PT','Lisboa (Lisbon)'),('PY','Asunción'),('QA','Ad-Dawhah (Doha)'),('RO','Bucureşti (Bucharest)'),('RS','Beograd (Belgrade)'),('RU','Moskva (Moscow)'),('RW','Kigali'),('SA','Ar-Riyad (Riyadh)'),('SB','Honiara'),('SC','Victoria'),('SD','Khartoum'),('SE','Stockholm'),('SG','Singapore'),('SI','Ljubljana'),('SK','Bratislava'),('SL','Freetown'),('SM','San Marino'),('SN','Dakar'),('SO','Muqdisho (Mogadishu)'),('SR','Paramaribo'),('SS','Juba'),('ST','São Tomé'),('SV','San Salvador'),('SY','Dimashq (Damascus)'),('TD','N''Djaména'),('TG','Lomé'),('TH','Bangkok'),('TJ','Dushanbe'),('TL','Dili'),('TM','Ashgabat'),('TN','Tunis'),('TO','Nuku‘alofa'),('TR','Ankara'),('TT','Port of Spain'),('TV','Funafuti'),('TZ','Dodoma'),('UA','Kyiv'),('UG','Kampala'),('US','Washington, D.C.'),('UY','Montevideo'),('UZ','Tashkent'),('VA','Vatican City'),('VC','Kingstown'),('VE','Caracas'),('VN','Hà Nội (Hanoi)'),('VU','Port-Vila'),('WS','Apia'),('YE','Şan‘a’ (Sana''a)'),('ZA','Pretoria (Administrative)'),('ZM','Lusaka'),('ZW','Harare');
GO

-- Table structure for table 'country_codes'
IF OBJECT_ID('[country_codes]', 'U') IS NOT NULL
    DROP TABLE [country_codes];
GO

CREATE TABLE [country_codes] (
  [country_name] varchar(255) NULL,
  [alpha_2_code] varchar(2) NULL,
  [alpha_3_code] varchar(3) NULL
);
GO

-- Dumping data for table 'country_codes'
INSERT INTO [country_codes] ([country_name], [alpha_2_code], [alpha_3_code]) VALUES
('Afghanistan','AF','AFG'),('Albania','AL','ALB'),('Algeria','DZ','DZA'),('American Samoa','AS','ASM'),('Andorra','AD','AND'),('Angola','AO','AGO'),('Anguilla','AI','AIA'),('Antarctica','AQ','ATA'),('Antigua and Barbuda','AG','ATG'),('Argentina','AR','ARG'),('Armenia','AM','ARM'),('Aruba','AW','ABW'),('Australia','AU','AUS'),('Austria','AT','AUT'),('Azerbaijan','AZ','AZE'),('Bahamas (the)','BS','BHS'),('Bahrain','BH','BHR'),('Bangladesh','BD','BGD'),('Barbados','BB','BRB'),('Belarus','BY','BLR'),('Belgium','BE','BEL'),('Belize','BZ','BLZ'),('Benin','BJ','BEN'),('Bermuda','BM','BMU'),('Bhutan','BT','BTN'),('Bolivia (Plurinational State of)','BO','BOL'),('Bonaire, Sint Eustatius and Saba','BQ','BES'),('Bosnia and Herzegovina','BA','BIH'),('Botswana','BW','BWA'),('Bouvet Island','BV','BVT'),('Brazil','BR','BRA'),('British Indian Ocean Territory (the)','IO','IOT'),('Brunei Darussalam','BN','BRN'),('Bulgaria','BG','BGR'),('Burkina Faso','BF','BFA'),('Burundi','BI','BDI'),('Cabo Verde','CV','CPV'),('Cambodia','KH','KHM'),('Cameroon','CM','CMR'),('Canada','CA','CAN'),('Cayman Islands (the)','KY','CYM'),('Central African Republic (the)','CF','CAF'),('Chad','TD','TCD'),('Chile','CL','CHL'),('China','CN','CHN'),('Christmas Island','CX','CXR'),('Cocos (Keeling) Islands (the)','CC','CCK'),('Colombia','CO','COL'),('Comoros (the)','KM','COM'),('Congo (the Democratic Republic of the)','CD','COD'),('Congo (the)','CG','COG'),('Cook Islands (the)','CK','COK'),('Costa Rica','CR','CRI'),('Croatia','HR','HRV'),('Cuba','CU','CUB'),('Curaçao','CW','CUW'),('Cyprus','CY','CYP'),('Czechia','CZ','CZE'),('Côte d''Ivoire','CI','CIV'),('Denmark','DK','DNK'),('Djibouti','DJ','DJI'),('Dominica','DM','DMA'),('Dominican Republic (the)','DO','DOM'),('Ecuador','EC','ECU'),('Egypt','EG','EGY'),('El Salvador','SV','SLV'),('Equatorial Guinea','GQ','GNQ'),('Eritrea','ER','ERI'),('Estonia','EE','EST'),('Eswatini','SZ','SWZ'),('Ethiopia','ET','ETH'),('Falkland Islands (the) [Malvinas]','FK','FLK'),('Faroe Islands (the)','FO','FRO'),('Fiji','FJ','FJI'),('Finland','FI','FIN'),('France','FR','FRA'),('French Guiana','GF','GUF'),('French Polynesia','PF','PYF'),('French Southern Territories (the)','TF','ATF'),('Gabon','GA','GAB'),('Gambia (the)','GM','GMB'),('Georgia','GE','GEO'),('Germany','DE','DEU'),('Ghana','GH','GHA'),('Gibraltar','GI','GIB'),('Greece','GR','GRC'),('Greenland','GL','GRL'),('Grenada','GD','GRD'),('Guadeloupe','GP','GLP'),('Guam','GU','GUM'),('Guatemala','GT','GTM'),('Guernsey','GG','GGY'),('Guinea','GN','GIN'),('Guinea-Bissau','GW','GNB'),('Guyana','GY','GUY'),('Haiti','HT','HTI'),('Heard Island and McDonald Islands','HM','HMD'),('Holy See (the)','VA','VAT'),('Honduras','HN','HND'),('Hong Kong','HK','HKG'),('Hungary','HU','HUN'),('Iceland','IS','ISL'),('India','IN','IND'),('Indonesia','ID','IDN'),('Iran (Islamic Republic of)','IR','IRN'),('Iraq','IQ','IRQ'),('Ireland','IE','IRL'),('Isle of Man','IM','IMN'),('Israel','IL','ISR'),('Italy','IT','ITA'),('Jamaica','JM','JAM'),('Japan','JP','JPN'),('Jersey','JE','JEY'),('Jordan','JO','JOR'),('Kazakhstan','KZ','KAZ'),('Kenya','KE','KEN'),('Kiribati','KI','KIR'),('Korea (the Democratic People''s Republic of)','KP','PRK'),('Korea (the Republic of)','KR','KOR'),('Kuwait','KW','KWT'),('Kyrgyzstan','KG','KGZ'),('Lao People''s Democratic Republic (the)','LA','LAO'),('Latvia','LV','LVA'),('Lebanon','LB','LBN'),('Lesotho','LS','LSO'),('Liberia','LR','LBR'),('Libya','LY','LBY'),('Liechtenstein','LI','LIE'),('Lithuania','LT','LTU'),('Luxembourg','LU','LUX'),('Macao','MO','MAC'),('Madagascar','MG','MDG'),('Malawi','MW','MWI'),('Malaysia','MY','MYS'),('Maldives','MV','MDV'),('Mali','ML','MLI'),('Malta','MT','MLT'),('Marshall Islands (the)','MH','MHL'),('Martinique','MQ','MTQ'),('Mauritania','MR','MRT'),('Mauritius','MU','MUS'),('Mayotte','YT','MYT'),('Mexico','MX','MEX'),('Micronesia (Federated States of)','FM','FSM'),('Moldova (the Republic of)','MD','MDA'),('Monaco','MC','MCO'),('Mongolia','MN','MNG'),('Montenegro','ME','MNE'),('Montserrat','MS','MSR'),('Morocco','MA','MAR'),('Mozambique','MZ','MOZ'),('Myanmar','MM','MMR'),('Namibia','NA','NAM'),('Nauru','NR','NRU'),('Nepal','NP','NPL'),('Netherlands (the)','NL','NLD'),('New Caledonia','NC','NCL'),('New Zealand','NZ','NZL'),('Nicaragua','NI','NIC'),('Niger (the)','NE','NER'),('Nigeria','NG','NGA'),('Niue','NU','NIU'),('Norfolk Island','NF','NFK'),('Northern Mariana Islands (the)','MP','MNP'),('Norway','NO','NOR'),('Oman','OM','OMN'),('Pakistan','PK','PAK'),('Palau','PW','PLW'),('Palestine, State of','PS','PSE'),('Panama','PA','PAN'),('Papua New Guinea','PG','PNG'),('Paraguay','PY','PRY'),('Peru','PE','PER'),('Philippines (the)','PH','PHL'),('Pitcairn','PN','PCN'),('Poland','PL','POL'),('Portugal','PT','PRT'),('Puerto Rico','PR','PRI'),('Qatar','QA','QAT'),('Republic of North Macedonia','MK','MKD'),('Romania','RO','ROU'),('Russian Federation (the)','RU','RUS'),('Rwanda','RW','RWA'),('Réunion','RE','REU'),('Saint Barthélemy','BL','BLM'),('Saint Helena, Ascension and Tristan da Cunha','SH','SHN'),('Saint Kitts and Nevis','KN','KNA'),('Saint Lucia','LC','LCA'),('Saint Martin (French part)','MF','MAF'),('Saint Pierre and Miquelon','PM','SPM'),('Saint Vincent and the Grenadines','VC','VCT'),('Samoa','WS','WSM'),('San Marino','SM','SMR'),('Sao Tome and Principe','ST','STP'),('Saudi Arabia','SA','SAU'),('Senegal','SN','SEN'),('Serbia','RS','SRB'),('Seychelles','SC','SYC'),('Sierra Leone','SL','SLE'),('Singapore','SG','SGP'),('Sint Maarten (Dutch part)','SX','SXM'),('Slovakia','SK','SVK'),('Slovenia','SI','SVN'),('Solomon Islands','SB','SLB'),('Somalia','SO','SOM'),('South Africa','ZA','ZAF'),('South Georgia and the South Sandwich Islands','GS','SGS'),('South Sudan','SS','SSD'),('Spain','ES','ESP'),('Sri Lanka','LK','LKA'),('Sudan (the)','SD','SDN'),('Suriname','SR','SUR'),('Svalbard and Jan Mayen','SJ','SJM'),('Sweden','SE','SWE'),('Switzerland','CH','CHE'),('Syrian Arab Republic','SY','SYR'),('Taiwan (Province of China)','TW','TWN'),('Tajikistan','TJ','TJK'),('Tanzania, United Republic of','TZ','TZA'),('Thailand','TH','THA'),('Timor-Leste','TL','TLS'),('Togo','TG','TGO'),('Tokelau','TK','TKL'),('Tonga','TO','TON'),('Trinidad and Tobago','TT','TTO'),('Tunisia','TN','TUN'),('Turkey','TR','TUR'),('Turkmenistan','TM','TKM'),('Turks and Caicos Islands (the)','TC','TCA'),('Tuvalu','TV','TUV'),('Uganda','UG','UGA'),('Ukraine','UA','UKR'),('United Arab Emirates (the)','AE','ARE'),('United Kingdom of Great Britain and Northern Irela','GB','GBR'),('United States Minor Outlying Islands (the)','UM','UMI'),('United States of America (the)','US','USA'),('Uruguay','UY','URY'),('Uzbekistan','UZ','UZB'),('Vanuatu','VU','VUT'),('Venezuela (Bolivarian Republic of)','VE','VEN'),('Viet Nam','VN','VNM'),('Virgin Islands (British)','VG','VGB'),('Virgin Islands (U.S.)','VI','VIR'),('Wallis and Futuna','WF','WLF'),('Western Sahara','EH','ESH'),('Yemen','YE','YEM'),('Zambia','ZM','ZMB'),('Zimbabwe','ZW','ZWE'),('Åland Islands','AX','ALA');
GO