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