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) NOT NULL DEFAULT '0',
  `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=2263671 DEFAULT CHARSET=utf8 `compression`='tokudb_zlib'
/*!50100 PARTITION BY RANGE (unixdate)
(PARTITION p1458255600 VALUES LESS THAN (1460930400) ENGINE = TokuDB,
 PARTITION p1460930400 VALUES LESS THAN (1463522400) ENGINE = TokuDB,
 PARTITION p1463522400 VALUES LESS THAN (1466200800) ENGINE = TokuDB,
 PARTITION p1466200800 VALUES LESS THAN (1468792800) ENGINE = TokuDB,
 PARTITION p1468792800 VALUES LESS THAN (1471471200) ENGINE = TokuDB,
 PARTITION p1471471200 VALUES LESS THAN (1474149600) ENGINE = TokuDB,
 PARTITION p1474149600 VALUES LESS THAN (1474472437) ENGINE = TokuDB,
 PARTITION p1477060837 VALUES LESS THAN (1477060837) ENGINE = TokuDB,
 PARTITION p1479686401 VALUES LESS THAN (1479686401) ENGINE = TokuDB,
 PARTITION p1482800401 VALUES LESS THAN (1482800401) ENGINE = TokuDB,
 PARTITION p1485738001 VALUES LESS THAN (1485738001) ENGINE = TokuDB,
 PARTITION p1488848402 VALUES LESS THAN (1488848402) ENGINE = TokuDB,
 PARTITION p1491613201 VALUES LESS THAN (1491613201) ENGINE = TokuDB,
 PARTITION pMAX VALUES LESS THAN MAXVALUE ENGINE = TokuDB)
