CREATE TABLE IF NOT EXISTS countrynames (
  cid int(8) unsigned NOT NULL auto_increment,
  tld char(2) NOT NULL default '',
  cnameen char(128) default NULL,
  cnamede char(128) default NULL,
  PRIMARY KEY (cid)
) TYPE=MyISAM;



INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('yu','Yougoslavia','Jugoslawien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('uk','United Kingdom','Gross Britannien');  
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('ua','Ukraine','Ukraine');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('tr','Turkey','Turkei');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('sm','San Marino','San Marino');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('sk','Slovakia','Slowakei');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('si','Slovenia','Slowenien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('se','Sweden','Schweden');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('ru','Russian Federation','Russische Föderation');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('ro','Romania','Rumänien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('pt','Portugal','Portugal');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('pl','Poland','Polen');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('no','Norway','Norwegen');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('nl','Netherlands','Niederlande');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('mt','Malta','Malta');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('mk','Macedonia','Mazedinien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('md','Moldavia','Moldawien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('mc','Monaco','Monaco');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('ma','Morocco','Marokko');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('lv','Latvia','Lettland');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('lu','Luxemburg','Luxemburg');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('lt','Lithuania','Litauen');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('li','Liechtenstein','Liechtenstein');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('it','Italy','Italien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('ie','Ireland','Irland');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('ic','Iceland','Island');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('hu','Hungary','Ungarn');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('hr','Croatia','Kroatien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('gr','Greece','Griechenland');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('ge','Georgia','Georgien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('fi','Finland','Finnland');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('fr','France','Frankreich');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('es','Spain','Spanien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('ee','Estonia','Estland');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('dk','Denmark','Dänemark');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('de','Germany','Deutschland');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('cz','Czech Republik','Tschechische Republik');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('cy','Cyprus','Zypern');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('ch','Switzerland','Schweiz');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('by','Belarus','Weissrussland');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('bh','Bosnia and Herzegovina','Bosnien und Herzegowina');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('bg','Bulgaria','Bulgarien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('be','Belgium','Belgien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('at','Austria','Österreich');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('am','Armenia','Armenien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('al','Albania','Albanien');
INSERT INTO countrynames (tld,cnameen,cnamede) VALUES ('ad','Andorra','Andorra');