GeoNames Forum

Hello there,

I just had a look on the countryInfo cvs version called countries.txt and it looks great. I tried to look around if i could find the mysql table for that but i havent found anything. I dont feel myself doing it (adding the new field) since it appears for me to be quite advanced.
I was wondering if anyone will be kind enough to upload the mysql table structure of the cvs version file countries.txt.

Thanks in advance, Regards.
Goose

PS: i am french so plz excuse my english.

for postgresql I use this statement :

Code:

 create table country (
         iso char(2),
         isoalpha char(3),
         isonum int,
         fips varchar(3),
         name varchar(100),
         capital varchar(100),
         area float,
         population int,
         continent varchar(2),
         languages varchar(100),
         currency varchar(3),
         geonameid  int
 );

hope it helps

Marc