/*!40101 SET NAMES binary*/;
/*!40014 SET FOREIGN_KEY_CHECKS=0*/;

/*!40103 SET TIME_ZONE='+00:00' */;
CREATE TABLE `exchange_holidays` (
  `tradeDate` date NOT NULL,
  `exchangeCode` char(3) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `calendarName` varchar(50) DEFAULT NULL,
  `holidayName` varchar(100) DEFAULT NULL,
  `settlement` varchar(10) NOT NULL,
  `trading` varchar(10) NOT NULL,
  `holidayType` varchar(10) DEFAULT NULL,
  `quoteCountry` char(2) NOT NULL,
  `countryName` varchar(20) DEFAULT NULL,
  `region` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`tradeDate`,`exchangeCode`),
  KEY `settlement` (`settlement`),
  KEY `trading` (`trading`),
  KEY `quoteCountry` (`quoteCountry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;