Mysql Table for HnR

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 ;