CREATE TABLE `ftp_xferlog` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(30) NOT NULL DEFAULT '',
  `filename` text,
  `size` BIGINT(20) DEFAULT NULL,
  `host` tinytext,
  `ip` tinytext,
  `action` tinytext,
  `duration` tinytext,
  `localtime` TIMESTAMP NULL DEFAULT NULL,
  `success` BOOL NOT NULL DEFAULT '0',
  `supplier` VARCHAR(30) NOT NULL DEFAULT '',
  `isnew` BOOL NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`),
  KEY `idx_usersucc` (`username`, `success`)
);
