DROP TABLE IF EXISTS tng_reports;
CREATE TABLE `tng_reports` (
  `reportID` int NOT NULL AUTO_INCREMENT,
  `reportname` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reportdesc` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ranking` int NOT NULL,
  `display` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `criteria` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `orderby` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `sqlselect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` tinyint NOT NULL,
  PRIMARY KEY (`reportID`),
  KEY `reportname` (`reportname`),
  KEY `ranking` (`ranking`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;