--
-- PostgreSQL database dump
--

\restrict BgOCJYw1kO2uDCIS4hmlhXuMHoEDPeN1sqSFQrMbkJsEY3W5IuGrbeUBCNiBdt1

-- Dumped from database version 17.7
-- Dumped by pg_dump version 17.6

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: countries; Type: SCHEMA; Schema: -; Owner: -
--

CREATE SCHEMA countries;


SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: capitals; Type: TABLE; Schema: countries; Owner: -
--

CREATE TABLE countries.capitals (
    alpha_2_code character varying(2) NOT NULL,
    country_capital character varying(255) NOT NULL
);


--
-- Name: country_codes; Type: TABLE; Schema: countries; Owner: -
--

CREATE TABLE countries.country_codes (
    country_name character varying(255) DEFAULT NULL::character varying,
    alpha_2_code character varying(2) DEFAULT NULL::character varying,
    alpha_3_code character varying(3) DEFAULT NULL::character varying
);


--
-- Name: capitals; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.capitals (
    alpha_2_code character varying(2) NOT NULL,
    country_capital character varying(255) NOT NULL
);


--
-- Name: country_codes; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.country_codes (
    country_name character varying(255) DEFAULT NULL::character varying,
    alpha_2_code character varying(2) DEFAULT NULL::character varying,
    alpha_3_code character varying(3) DEFAULT NULL::character varying
);


--
-- Data for Name: capitals; Type: TABLE DATA; Schema: countries; Owner: -
--

COPY countries.capitals (alpha_2_code, country_capital) FROM stdin;
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
\.


--
-- Data for Name: country_codes; Type: TABLE DATA; Schema: countries; Owner: -
--

COPY countries.country_codes (country_name, alpha_2_code, alpha_3_code) FROM stdin;
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
\.


--
-- Data for Name: capitals; Type: TABLE DATA; Schema: public; Owner: -
--

COPY public.capitals (alpha_2_code, country_capital) FROM stdin;
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
\.


--
-- Data for Name: country_codes; Type: TABLE DATA; Schema: public; Owner: -
--

COPY public.country_codes (country_name, alpha_2_code, alpha_3_code) FROM stdin;
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
\.


--
-- Name: capitals capitals_pkey; Type: CONSTRAINT; Schema: countries; Owner: -
--

ALTER TABLE ONLY countries.capitals
    ADD CONSTRAINT capitals_pkey PRIMARY KEY (alpha_2_code);


--
-- Name: capitals capitals_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.capitals
    ADD CONSTRAINT capitals_pkey PRIMARY KEY (alpha_2_code);


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: -
--

GRANT ALL ON SCHEMA public TO cloudsqlsuperuser;


--
-- PostgreSQL database dump complete
--

\unrestrict BgOCJYw1kO2uDCIS4hmlhXuMHoEDPeN1sqSFQrMbkJsEY3W5IuGrbeUBCNiBdt1