DROP TABLE IF EXISTS tng_mostwanted;
CREATE TABLE `tng_mostwanted` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `ordernum` float NOT NULL,
  `gedcom` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mwtype` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `personID` varchar(22) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mediaID` int NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `mwtype` (`mwtype`,`ordernum`,`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;