CREATE TABLE `transfer_history` (
`uid` INT( 11 ) NOT NULL DEFAULT '0',
`fid` INT( 11 ) NOT NULL DEFAULT '0',
`uploaded` INT( 11 ) NOT NULL DEFAULT '0',
`downloaded` INT( 11 ) NOT NULL DEFAULT '0',
`last_action` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`connectable` ENUM( '0', '1' ) NOT NULL DEFAULT '0',
`seeding` ENUM( '0', '1' ) NOT NULL DEFAULT '0',
`seedtime` INT( 30 ) NOT NULL DEFAULT '0',
`hnr` ENUM( '0', '1', '2' ) NOT NULL DEFAULT '0',
`hnrsettime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY ( `uid` , `fid` ) 
) ENGINE = InnoDB ;