A MySQL schema for the domestic part of the geonames database. If you find any errors, please leave a comment below.

id int(10) NOT NULL,
name varchar(100),
class varchar(50),
state char(2),
statenum int(2),
county varchar(100),
countynum int(3),
latdms varchar(7),
londms varchar(8),
latdec decimal(11,7),
londec decimal(12,7),
sourcestate varchar(2),
sourcelatdms varchar(7),
sourcelondms varchar(8),
sourcelatdec decimal(11,7),
sourcelondec decimal(12,7),
elevation int(5),
mapname varchar(100)

http://geonames.usgs.gov/domestic/states_fileformat.htm

See also table schema for foreign geonames