GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Can we have a currencies table included ?  XML
Forum Index -> General
Author Message
devmorfo



Joined: 28/06/2010 14:18:33
Messages: 2
Offline

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.

 Description The actual currencies file [Disk] Download
 Filesize 5 Kbytes
 Downloaded:  2013 time(s)


Who is General Error and what is he doing in my drive A:
marc



Joined: 08/12/2005 07:39:47
Messages: 3926
Offline

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

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

[WWW]
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team