CREATE TABLE `CCCode` (
  `CCCode` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `StartDate` date NOT NULL,
  `EndDate` date DEFAULT NULL,
  `QUnit` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SQUnit` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SWUnit` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NormalPriceDutyRate` double(16,4) DEFAULT NULL,
  `NormalQTYDutyRate` double(16,4) DEFAULT NULL,
  `SecondPriceDutyRate` double(16,4) DEFAULT NULL,
  `SecondQTYDutyRate` double(16,4) DEFAULT NULL,
  `SpecialPriceDutyRate` double(16,4) DEFAULT NULL,
  `SpecialQTYDutyRate` double(16,4) DEFAULT NULL,
  `FloatNormalPriceDutyRate` double(16,4) DEFAULT NULL,
  `FloatNormalQTYDutyRate` double(16,4) DEFAULT NULL,
  `FloatSecondPriceDutyRate` double(16,4) DEFAULT NULL,
  `FloatSecondQTYDutyRate` double(16,4) DEFAULT NULL,
  `FloatSpecialPriceDutyRate` double(16,4) DEFAULT NULL,
  `FloatSpecialQTYDutyRate` double(16,4) DEFAULT NULL,
  `FloatStartDate` date DEFAULT NULL,
  `FloatEndDate` date DEFAULT NULL,
  `Mode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportControl1` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportArea1` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportControl2` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportArea2` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportControl3` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportArea3` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportControl4` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportArea4` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportControl5` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportArea5` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportControl6` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ImportArea6` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportControl1` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportArea1` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportControl2` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportArea2` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportControl3` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportArea3` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportControl4` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportArea4` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportControl5` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportArea5` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportControl6` char(4) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ExportArea6` char(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`CCCode`,`StartDate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
