-- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle 'admin1_codes' -- CREATE TABLE admin1_codes ( `code` varchar(16) default NULL, `name` varchar(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle 'admin1_codes_ascii' -- CREATE TABLE admin1_codes_ascii ( `code` varchar(16) default NULL, `name` varchar(64) default NULL, name_ascii varchar(80) default NULL, geoname_id mediumint(8) unsigned default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle 'admin2_codes' -- CREATE TABLE admin2_codes ( `code` varchar(64) default NULL, name_local varchar(64) default NULL, `name` varchar(64) default NULL, geoname_id mediumint(8) unsigned default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle 'alternate_names' -- CREATE TABLE alternate_names ( alternate_name_id mediumint(8) unsigned NOT NULL, geoname_id mediumint(8) unsigned default NULL, iso_language varchar(7) default NULL, alternate_name varchar(255) default NULL, is_preferred_name tinyint(3) unsigned default NULL, is_short_name tinyint(3) unsigned default NULL, PRIMARY KEY (alternate_name_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle 'continent_codes' -- CREATE TABLE continent_codes ( `code` char(2) default NULL, `name` varchar(16) default NULL, geoname_id mediumint(8) unsigned default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle 'country_info' -- CREATE TABLE country_info ( iso char(2) default NULL, iso3 char(3) default NULL, iso_numeric smallint(5) unsigned default NULL, fips char(2) default NULL, country varchar(64) default NULL, capital varchar(32) default NULL, area_in_sq_km double default NULL, population int(10) unsigned default NULL, continent char(2) default NULL, tld char(3) default NULL, currency_code char(3) default NULL, currency_name varchar(16) default NULL, phone varchar(32) default NULL, postal_code_format varchar(64) default NULL, postal_code_regex varchar(160) default NULL, languages varchar(64) default NULL, geoname_id mediumint(8) unsigned default NULL, neighbours varchar(64) default NULL, equivalent_fips_code varchar(4) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle 'feature_codes' -- CREATE TABLE feature_codes ( `code` varchar(8) default NULL, `name` varchar(64) default NULL, description varchar(255) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle 'geonames' -- CREATE TABLE geonames ( geoname_id mediumint(8) unsigned NOT NULL, `name` varchar(160) default NULL, ascii_name varchar(160) default NULL, alternate_names text, latitude decimal(8,6) default NULL, longitude decimal(9,6) default NULL, feature_class char(1) default NULL, feature_code varchar(8) default NULL, country_code char(2) default NULL, cc2 varchar(40) default NULL, admin1_code varchar(8) default NULL, admin2_code varchar(64) default NULL, admin3_code varchar(16) default NULL, admin4_code varchar(16) default NULL, population int(10) unsigned default NULL, elevation smallint(6) default NULL, gtopo30 smallint(6) default NULL, time_zone varchar(32) default NULL, modification_date date default NULL, PRIMARY KEY (geoname_id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle 'iso_language_codes' -- CREATE TABLE iso_language_codes ( iso_639_3 char(4) default NULL, iso_639_2 varchar(16) default NULL, iso_639_1 varchar(4) default NULL, language_name varchar(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle 'time_zones' -- CREATE TABLE time_zones ( time_zone_id varchar(32) default NULL, gmt_offset decimal(4,2) default NULL, dst_offset decimal(4,2) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;