CREATE TABLE `Port` (
  `Code` char(5) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `SEQ` char(1) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `CountryCode` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SubCode` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CName` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CountryName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PortName` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Subdivision` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Others` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Sea` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Rail` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `HWay` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Air` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Postal` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Border` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Status` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CDate` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `IATA` char(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  `REQ` char(6) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`Code`,`SEQ`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
