DROP TABLE IF EXISTS tng_mediatypes;
CREATE TABLE `tng_mediatypes` (
  `mediatypeID` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  `liketype` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumb` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exportas` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disabled` tinyint NOT NULL,
  `ordernum` tinyint NOT NULL,
  `localpath` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `whatsnew` smallint NOT NULL,
  `statistics` smallint NOT NULL,
  `menus` smallint NOT NULL,
  PRIMARY KEY (`mediatypeID`),
  KEY `ordernum` (`ordernum`,`display`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
INSERT INTO tng_mediatypes (mediatypeID,display,path,liketype,icon,thumb,exportas,disabled,ordernum,localpath,whatsnew,statistics,menus) VALUES
("documents","","","","","","","0","0","","1","1","1"),
("headstones","","","","","","","0","0","","1","1","1"),
("histories","","","","","","","0","0","","1","1","1"),
("photos","","","","","","","0","0","","1","1","1"),
("recordings","","","","","","","0","0","","1","1","1"),
("videos","","","","","","","0","0","","1","1","1");