# MySQL dump 8.16
#
# Host: localhost    Database: papp
#--------------------------------------------------------
# Server version	3.23.47

#
# Table structure for table 'iso3166'
#

CREATE TABLE iso3166 (
  alpha3 char(3) NOT NULL default '',
  alpha2 char(2) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  fullname varchar(255) NOT NULL default '',
  code smallint(3) unsigned zerofill NOT NULL default '000',
  KEY alpha2 (alpha2),
  KEY alpha3 (alpha3),
  KEY code (code)
) TYPE=MyISAM COMMENT='ISO3166-1, ISO3166-2 and UNSD numeric codes';