CREATE TABLE `filestat` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`completelogfile` TEXT NOT NULL ,
`logfile` VARCHAR( 50 ) NOT NULL ,
`logfiletimestamp` DATE NOT NULL ,
`completefile` TEXT NOT NULL ,
`pathtofile` TEXT NOT NULL ,
`filename` TEXT NOT NULL ,
`isdir` BOOL NOT NULL ,
`changed` BOOL NOT NULL ,
`sourcesize` INT( 10 ) NOT NULL ,
`incrementsize` INT( 10 ) NULL ,
`completestring` TEXT NOT NULL ,
`created` DATETIME NOT NULL ,
`modified` DATETIME NOT NULL ,
`restored` DATETIME NOT NULL ,
INDEX ( `filename` )
) ENGINE = MYISAM
MySQL said: Documentation
#1170 - BLOB/TEXT column 'filename' used in key specification without a key length