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 = MYISAMMySQL said: Documentation#1170 - BLOB/TEXT column 'filename' used in key specification without a key length