GeoNames Forum

I have created and succesfully linked with foreign keys a currencies table. Do you think we should include this in GeoNames ?

Here is the code for it.

CREATE TABLE currencies (
isoalpha3 character(3),
symbol character varying(7),
currency_name character varying(120),
fractional_unit character varying(20)
);

ALTER TABLE ONLY currencies ADD CONTRAINT "pk_currencies" PRIMARY KEY (isoalpha3);

Data for this in the attached.

I have added a link to this thread to the countryInfo.txt file

http://download.geonames.org/export/dump/countryInfo.txt