DROP TABLE IF EXISTS tng_timelineevents;
CREATE TABLE `tng_timelineevents` (
  `tleventID` int NOT NULL AUTO_INCREMENT,
  `evday` tinyint NOT NULL,
  `evmonth` tinyint NOT NULL,
  `evyear` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `endday` tinyint NOT NULL,
  `endmonth` tinyint NOT NULL,
  `endyear` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `evtitle` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `evdetail` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`tleventID`),
  KEY `evyear` (`evyear`,`evmonth`,`evday`,`evdetail`(100)),
  KEY `evdetail` (`evdetail`(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;