CREATE TABLE `country_list` (
  `IP_FROM` double NOT NULL default '0',
  `IP_TO` double NOT NULL default '0',
  `country_code` char(2) NOT NULL default '',
  `country_code2` char(3) NOT NULL default '',
  `country_name` varchar(50) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `country_blocks` (
  `id` int(5) NOT NULL auto_increment,
  `country_code` char(2) NOT NULL default '',
  KEY `id` (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;