Joined: 28/06/2010 14:18:33
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 (
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.
||The actual currencies file
|| 2002 time(s)