CREATE TABLE `OldCName` (
  `CCCode` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `CName` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`CCCode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
