CREATE TABLE `postcode_city` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
`country_code` varchar(5) NOT NULL COMMENT 'Country Code',
`postcode` varchar(20) NOT NULL COMMENT 'Postcode',
`city` text NOT NULL COMMENT 'City',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52142 DEFAULT CHARSET=utf8 COMMENT='Postcode -> City';