CREATE TABLE `geoip_cc` (
  `ci` tinyint(3) unsigned NOT NULL auto_increment,
  `cc` char(2) NOT NULL,
  `cn` varchar(50) NOT NULL,
  PRIMARY KEY  (`ci`)
) ;


INSERT INTO `geoip_cc` VALUES (1,'GB','United Kingdom'),(2,'US','United States'),(3,'CA','Canada'),(4,'MX','Mexico'),(5,'BM','Bermuda'),(6,'SE','Sweden'),(7,'IT','Italy'),(8,'A2','Satellite Provider'),(9,'CH','Switzerland'),(10,'PR','Puerto Rico'),(11,'IN','India'),(12,'VI','Virgin Islands, U.S.'),(13,'DE','Germany'),(14,'IR','Iran, Islamic Republic of'),(15,'BO','Bolivia'),(16,'NG','Nigeria'),(17,'NL','Netherlands'),(18,'FR','France'),(19,'IL','Israel'),(20,'ES','Spain'),(21,'PA','Panama'),(22,'CL','Chile'),(23,'BS','Bahamas'),(24,'AR','Argentina'),(25,'DM','Dominica'),(26,'BE','Belgium'),(27,'IE','Ireland'),(28,'BZ','Belize'),(29,'BR','Brazil'),(30,'ZA','South Africa'),(31,'SC','Seychelles'),(32,'TZ','Tanzania, United Republic of'),(33,'EG','Egypt'),(34,'RW','Rwanda'),(35,'DZ','Algeria'),(36,'SZ','Swaziland'),(37,'GH','Ghana'),(38,'CM','Cameroon'),(39,'MG','Madagascar'),(40,'KE','Kenya'),(41,'AO','Angola'),(42,'NA','Namibia'),(43,'MA','Morocco'),(44,'SL','Sierra Leone'),(45,'CI','Cote D\'Ivoire'),(46,'GA','Gabon'),(47,'MU','Mauritius'),(48,'TG','Togo'),(49,'LY','Libyan Arab Jamahiriya'),(50,'SN','Senegal'),(51,'SD','Sudan'),(52,'UG','Uganda'),(53,'ZW','Zimbabwe'),(54,'MZ','Mozambique'),(55,'ZM','Zambia'),(56,'BW','Botswana'),(57,'LR','Liberia'),(58,'CD','Congo, The Democratic Republic of the'),(59,'BJ','Benin'),(60,'TN','Tunisia'),(61,'JP','Japan'),(62,'EU','Europe'),(63,'AU','Australia'),(64,'TH','Thailand'),(65,'CN','China'),(66,'MY','Malaysia'),(67,'PK','Pakistan'),(68,'NZ','New Zealand'),(69,'KR','Korea, Republic of'),(70,'HK','Hong Kong'),(71,'SG','Singapore'),(72,'BD','Bangladesh'),(73,'ID','Indonesia'),(74,'PH','Philippines'),(75,'TW','Taiwan'),(76,'AF','Afghanistan'),(77,'VN','Vietnam'),(78,'VU','Vanuatu'),(79,'NC','New Caledonia'),(80,'BN','Brunei Darussalam'),(81,'AP','Asia/Pacific Region'),(82,'GR','Greece'),(83,'SA','Saudi Arabia'),(84,'PL','Poland'),(85,'CZ','Czech Republic'),(86,'RU','Russian Federation'),(87,'CY','Cyprus'),(88,'NO','Norway'),(89,'AT','Austria'),(90,'UA','Ukraine'),(91,'TJ','Tajikistan'),(92,'DK','Denmark'),(93,'PT','Portugal'),(94,'TR','Turkey'),(95,'GE','Georgia'),(96,'BY','Belarus'),(97,'IQ','Iraq'),(98,'AM','Armenia'),(99,'LB','Lebanon'),(100,'MD','Moldova, Republic of'),(101,'BG','Bulgaria'),(102,'FI','Finland'),(103,'OM','Oman'),(104,'LV','Latvia'),(105,'KZ','Kazakstan'),(106,'EE','Estonia'),(107,'SK','Slovakia'),(108,'JO','Jordan'),(109,'HU','Hungary'),(110,'KW','Kuwait'),(111,'AL','Albania'),(112,'LT','Lithuania'),(113,'SM','San Marino'),(114,'BT','Bhutan'),(115,'RO','Romania'),(116,'RS','Serbia'),(117,'HR','Croatia'),(118,'LU','Luxembourg'),(119,'IS','Iceland'),(120,'LI','Liechtenstein'),(121,'CR','Costa Rica'),(122,'MK','Macedonia'),(123,'MT','Malta'),(124,'GM','Gambia'),(125,'MW','Malawi'),(126,'SI','Slovenia'),(127,'FK','Falkland Islands (Malvinas)'),(128,'AZ','Azerbaijan'),(129,'MC','Monaco'),(130,'HT','Haiti'),(131,'GU','Guam'),(132,'JM','Jamaica'),(133,'FM','Micronesia, Federated States of'),(134,'EC','Ecuador'),(135,'CO','Colombia'),(136,'PE','Peru'),(137,'KY','Cayman Islands'),(138,'GP','Guadeloupe'),(139,'HN','Honduras'),(140,'YE','Yemen'),(141,'VG','Virgin Islands, British'),(142,'LC','Saint Lucia'),(143,'SY','Syrian Arab Republic'),(144,'NI','Nicaragua'),(145,'DO','Dominican Republic'),(146,'AN','Netherlands Antilles'),(147,'GT','Guatemala'),(148,'VE','Venezuela'),(149,'BA','Bosnia and Herzegovina'),(150,'HM','Heard Island and McDonald Islands'),(151,'UY','Uruguay'),(152,'SV','El Salvador'),(153,'AE','United Arab Emirates'),(154,'TT','Trinidad and Tobago'),(155,'LK','Sri Lanka'),(156,'BV','Bouvet Island'),(157,'MH','Marshall Islands'),(158,'BH','Bahrain'),(159,'CK','Cook Islands'),(160,'GI','Gibraltar'),(161,'PY','Paraguay'),(162,'AG','Antigua and Barbuda'),(163,'LS','Lesotho'),(164,'KN','Saint Kitts and Nevis'),(165,'WS','Samoa'),(166,'PW','Palau'),(167,'QA','Qatar'),(168,'KH','Cambodia'),(169,'AI','Anguilla'),(170,'AS','American Samoa'),(171,'TC','Turks and Caicos Islands'),(172,'MP','Northern Mariana Islands'),(173,'UZ','Uzbekistan'),(174,'MO','Macau'),(175,'UM','United States Minor Outlying Islands'),(176,'RE','Reunion'),(177,'GY','Guyana'),(178,'CU','Cuba'),(179,'CG','Congo'),(180,'A1','Anonymous Proxy'),(181,'BB','Barbados'),(182,'SR','Suriname'),(183,'AW','Aruba'),(184,'FJ','Fiji'),(185,'MS','Montserrat'),(186,'GD','Grenada'),(187,'VC','Saint Vincent and the Grenadines'),(188,'NP','Nepal'),(189,'ME','Montenegro'),(190,'KG','Kyrgyzstan'),(191,'TD','Chad'),(192,'FO','Faroe Islands'),(193,'SO','Somalia'),(194,'ML','Mali'),(195,'PS','Palestinian Territory, Occupied'),(196,'BI','Burundi'),(197,'GN','Guinea'),(198,'ET','Ethiopia'),(199,'KM','Comoros'),(200,'LA','Lao People\'s Democratic Republic'),(201,'MR','Mauritania'),(202,'MQ','Martinique'),(203,'NE','Niger'),(204,'VA','Holy See (Vatican City State)'),(205,'TM','Turkmenistan'),(206,'YT','Mayotte'),(207,'BF','Burkina Faso'),(208,'AD','Andorra'),(209,'AQ','Antarctica'),(210,'GL','Greenland'),(211,'MN','Mongolia'),(212,'PF','French Polynesia'),(213,'MV','Maldives'),(214,'PG','Papua New Guinea'),(215,'CF','Central African Republic'),(216,'ER','Eritrea'),(217,'GW','Guinea-Bissau'),(218,'DJ','Djibouti'),(219,'GQ','Equatorial Guinea'),(220,'CV','Cape Verde'),(221,'ST','Sao Tome and Principe'),(222,'GF','French Guiana'),(223,'SB','Solomon Islands'),(224,'TV','Tuvalu'),(225,'KI','Kiribati'),(226,'TO','Tonga'),(227,'IO','British Indian Ocean Territory'),(228,'NU','Niue'),(229,'TK','Tokelau'),(230,'NR','Nauru'),(231,'NF','Norfolk Island'),(232,'MM','Myanmar'),(233,'KP','Korea, Democratic People\'s Republic of');