CREATE TABLE `files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `batch` text,
  `filename` text,
  `date` datetime DEFAULT NULL,
  `scan_time` datetime DEFAULT NULL,
  `type` text,
  `pro` varchar(100) DEFAULT NULL,
  `anti` varchar(100) DEFAULT NULL,
  `origFolder` text,
  `file_size` text,
  `file_creation_date` datetime DEFAULT NULL,
  `file_format` text,
  `file_type` text,
  `file_last_accessed_date` datetime DEFAULT NULL,
  `file_last_modified_date` datetime DEFAULT NULL,
  `line_count` text,
  `token_count` text,
  `user_notes` text,
  `username` varchar(100) DEFAULT NULL,
  `timeStamp` varchar(100) DEFAULT NULL,
  `results` text,
  `shortFilename` text,
  `parentFolderId` int(11) DEFAULT NULL,
  `session` text,
  `data` text,
  `userId` int(11) DEFAULT NULL,
  `batch_serial_id` text,
  `batch_id` text,
  `author` varchar(100) DEFAULT NULL,
  `redactedId` int(11) DEFAULT NULL,
  `redactedEndId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `timeStamp_Index` (`timeStamp`),
  KEY `username_Index` (`username`),
  KEY `date_Index` (`date`),
  KEY `parentFolderId_Index` (`parentFolderId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
/*!50100 PARTITION BY KEY (id) */