DROP TABLE IF EXISTS tng_reports;
CREATE TABLE `tng_reports` (
  `reportID` int(11) NOT NULL AUTO_INCREMENT,
  `reportname` varchar(80) NOT NULL,
  `reportdesc` text NOT NULL,
  `ranking` int(11) NOT NULL,
  `display` text NOT NULL,
  `criteria` text NOT NULL,
  `orderby` text NOT NULL,
  `sqlselect` text NOT NULL,
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (`reportID`),
  KEY `reportname` (`reportname`),
  KEY `ranking` (`ranking`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
