# --------------------------------------------------------
# Table structure for table `pphlogger_domains`
# --------------------------------------------------------
#
# $Id: pphl_domains.sql,v 1.10 2002/05/04 16:40:28 cvs_iezzi Exp $

CREATE TABLE pphl_domains (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT,
  tld varchar(20) NOT NULL default '',
  area varchar(4) NOT NULL default '',
  PRIMARY KEY (id),
  UNIQUE KEY tld_ind (tld)
);

#
# Dumping data for table `pphl_domains`
#

INSERT INTO pphl_domains (tld, area) VALUES ('ac', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('ad', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('ae', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('af', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('ag', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('ai', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('al', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('am', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('an', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('ao', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('aq', 'AN');
INSERT INTO pphl_domains (tld, area) VALUES ('ar', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('as', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('au', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('aw', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('az', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('ba', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('bb', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('bd', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('be', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('bf', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('bg', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('bh', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('bi', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('bj', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('bm', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('bn', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('bo', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('br', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('bs', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('bt', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('bv', 'AN');
INSERT INTO pphl_domains (tld, area) VALUES ('bw', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('by', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('bz', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('ca', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('cc', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('cd', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('cf', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('cg', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('ch', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('ci', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('ck', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('cl', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('cm', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('cn', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('co', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('cr', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('cu', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('cv', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('cx', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('cy', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('cz', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('de', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('dj', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('dk', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('dm', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('do', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('dz', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('ec', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('ee', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('eg', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('eh', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('er', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('es', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('et', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('fi', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('fj', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('fk', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('fm', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('fo', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('fr', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('ga', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('gd', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('ge', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('gf', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('gg', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('gh', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('gi', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('gl', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('gm', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('gn', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('gp', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('gq', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('gr', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('gs', 'AN');
INSERT INTO pphl_domains (tld, area) VALUES ('gt', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('gu', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('gw', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('gy', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('hk', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('hm', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('hn', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('hr', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('ht', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('hu', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('id', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('ie', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('il', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('im', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('in', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('io', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('iq', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('ir', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('is', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('it', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('je', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('jm', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('jo', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('jp', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('ke', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('kg', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('kh', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('ki', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('km', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('kn', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('kp', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('kr', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('kw', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('ky', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('kz', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('la', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('lb', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('lc', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('li', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('lk', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('lr', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('ls', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('lt', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('lu', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('lv', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('ly', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('ma', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('mc', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('md', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('mg', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('mh', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('mk', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('ml', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('mm', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('mn', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('mo', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('mp', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('mq', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('mr', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('ms', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('mt', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('mu', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('mv', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('mw', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('mx', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('my', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('mz', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('na', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('nc', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('ne', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('nf', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('ng', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('ni', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('nl', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('no', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('np', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('nr', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('nu', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('nz', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('om', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('pa', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('pe', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('pf', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('pg', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('ph', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('pk', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('pl', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('pm', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('pn', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('pr', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('pt', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('pw', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('py', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('qa', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('re', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('ro', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('ru', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('rw', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('sa', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('sb', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('sc', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('sd', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('se', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('sg', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('sh', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('si', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('sj', '');
INSERT INTO pphl_domains (tld, area) VALUES ('sk', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('sl', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('sm', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('sn', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('so', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('sr', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('st', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('sv', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('sy', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('sz', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('tc', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('td', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('tf', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('tg', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('th', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('tj', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('tk', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('tm', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('tn', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('to', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('tp', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('tr', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('tt', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('tv', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('tw', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('tz', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('ua', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('ug', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('uk', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('gb', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('um', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('us', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('uy', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('uz', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('va', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('vc', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('ve', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('vg', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('vi', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('vn', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('vu', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('wf', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('ws', 'OZ');
INSERT INTO pphl_domains (tld, area) VALUES ('ye', 'AS');
INSERT INTO pphl_domains (tld, area) VALUES ('yt', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('yu', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('za', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('zm', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('zr', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('zw', 'AF');
INSERT INTO pphl_domains (tld, area) VALUES ('com', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('net', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('org', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('edu', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('int', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('arpa', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('at', 'EU');
INSERT INTO pphl_domains (tld, area) VALUES ('gov', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('mil', 'AM');
INSERT INTO pphl_domains (tld, area) VALUES ('su', 'GUS');
INSERT INTO pphl_domains (tld, area) VALUES ('reverse', '');
INSERT INTO pphl_domains (tld, area) VALUES ('arts', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('firm', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('info', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('nom', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('rec', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('shop', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('web', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('biz', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('pro', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('coop', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('museum', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('aero', 'UN');
INSERT INTO pphl_domains (tld, area) VALUES ('eu', 'EU');