History of Importing geonames data into Firebird

<p>First cut at schema for geonames table</p>

<p>&nbsp; GEONAMEID BIGINT NOT NULL,<br />
&nbsp; NAME VARCHAR(200) NOT NULL,<br />
&nbsp; ASCIINAME VARCHAR(200),<br />
&nbsp; ALTERNATENAMES BLOB SUB_TYPE 1,<br />
&nbsp; LATITUDE DOUBLE PRECISION,<br />
&nbsp; LONGITUDE DOUBLE PRECISION,<br />
&nbsp; FEATURE_CLASS CHAR(1),<br />
&nbsp; FEATURE_CODE VARCHAR(10),<br />
&nbsp; COUNTRY_CODE CHAR(2),<br />
&nbsp; CC2 VARCHAR(60),<br />
&nbsp; ADMIN1_CODE VARCHAR(20),<br />
&nbsp; ADMIN2_CODE VARCHAR(80),<br />
&nbsp; ADMIN3_CODE VARCHAR(20),<br />
&nbsp; ADMIN4_CODE VARCHAR(20),<br />
&nbsp; POPULATION BIGINT,<br />
&nbsp; ELEVATION INTEGER,<br />
&nbsp; DEM INTEGER,<br />
&nbsp; TIMEZONE VARCHAR(40),<br />
&nbsp; MOD_DATE DATE,<br />
&nbsp; CONSTRAINT PK_GEONAMES PRIMARY KEY (GEONAMEID)</p>

<p>Import via XMLWizard works fine, but need to improve speed when applying updates.</p>