CREATE TABLE IF NOT EXISTS `zipcode` (
  `zipcode` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `zipcode` (`zipcode`,`city`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
