text: CREATE TABLE `file_transfers` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `file_id` bigint(20) unsigned NOT NULL,
    `source_id` int(10) unsigned NOT NULL,
    `destination_id` int(10) unsigned NOT NULL,
    `exitcode` smallint(5) NOT NULL,
    `message` varchar(512) COLLATE latin1_general_cs DEFAULT NULL,
    `batch_id` bigint(20) unsigned NOT NULL,
    `created` datetime NOT NULL,
    `started` datetime DEFAULT NULL,
    `finished` datetime DEFAULT NULL,
    `completed` datetime NOT NULL,
    PRIMARY KEY (`id`),
    KEY `transfer` (`file_id`,`source_id`,`destination_id`),
    KEY `batch` (`batch_id`),
    KEY `created` (`created`),
    KEY `started` (`started`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs;
  