DROP TABLE IF EXISTS tng_eventtypes;
CREATE TABLE `tng_eventtypes` (
  `eventtypeID` int NOT NULL AUTO_INCREMENT,
  `tag` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(90) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `keep` tinyint NOT NULL,
  `collapse` tinyint NOT NULL,
  `ordernum` smallint NOT NULL,
  `ldsevent` tinyint NOT NULL,
  `type` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`eventtypeID`),
  UNIQUE KEY `typetagdesc` (`type`,`tag`,`description`),
  KEY `ordernum` (`ordernum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;