CREATE TABLE `scanner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message_id` text,
  `real_id` text,
  `virusfree_id` text CHARACTER SET utf8mb4,
  `sender` varchar(255) DEFAULT NULL,
  `sender_domain` varchar(255) DEFAULT NULL,
  `recipient` varchar(255) DEFAULT NULL,
  `recipient_domain` varchar(255) DEFAULT NULL,
  `unixdate` int(11) DEFAULT NULL,
  `host` varchar(255) DEFAULT NULL,
  `subject` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `scanner` char(25) DEFAULT NULL,
  `result` char(25) DEFAULT NULL,
  `relay` int(1) DEFAULT NULL,
  `size` int(11) DEFAULT NULL,
  `duration` double DEFAULT NULL,
  `score` char(20) DEFAULT NULL,
  `crc` char(32) DEFAULT NULL,
  `user_feedback` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`, `unixdate`),
  KEY `scanner_message_id` (`message_id`(255)),
  KEY `scanner_crc` (`crc`),
  KEY `scanner_date` (`unixdate`),
  KEY `scanner_real` (`real_id`(255)),
  KEY `scanner_recipient_date` (`recipient`,`unixdate`),
  KEY `scanner_sender_date` (`sender`,`unixdate`),
  KEY `scanner_sdomain_date` (`sender_domain`,`unixdate`),
  KEY `scanner_rdomain_date` (`recipient_domain`,`unixdate`),
  KEY `scanner_result_date` (`result`,`unixdate`),
  KEY `scanner_feedback` (`user_feedback`)
) ENGINE=TokuDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 `compression`='tokudb_zlib';
