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 |
Download
|
Filesize |
5 Kbytes
|
Downloaded: |
2720 time(s) |
|