[TYPO3] Dam and database error

[Tapio Markula]

Hi

Installing dam failed partially.
following
SQL-statemend didn't wor:


CREATE TABLE tx_dam(
uid int( 11 ) NOT NULL AUTO_INCREMENT ,
pid int( 11 ) NOT NULL default '0',
tstamp int( 11 ) unsigned NOT NULL default '0',
crdate int( 11 ) unsigned NOT NULL default '0',
cruser_id int( 11 ) unsigned NOT NULL default '0',
parent_id int( 11 ) NOT NULL default '0',
deleted tinyint( 4 ) unsigned NOT NULL default '0',
active tinyint( 4 ) unsigned NOT NULL default '0',
sorting int( 10 ) unsigned NOT NULL default '0',
hidden tinyint( 4 ) unsigned NOT NULL default '0',
starttime int( 11 ) unsigned NOT NULL default '0',
endtime int( 11 ) unsigned NOT NULL default '0',
fe_group int( 11 ) NOT NULL default '0',
sys_language_uid int( 11 ) NOT NULL default '0',
l18n_parent int( 11 ) NOT NULL default '0',
l18n_diffsource mediumblob NOT NULL ,
t3ver_oid int( 11 ) NOT NULL default '0',
t3ver_id int( 11 ) NOT NULL default '0',
t3ver_label varchar( 60 ) NOT NULL default '',
media_type tinyint( 4 ) unsigned NOT NULL default '0',
title text NOT NULL ,
category int( 11 ) NOT NULL default '0',
index_type varchar( 8 ) NOT NULL default '',
file_mime_type varchar( 90 ) NOT NULL default '',
file_mime_subtype varchar( 90 ) NOT NULL default '',
file_type varchar( 8 ) NOT NULL default '',
file_type_version varchar( 18 ) NOT NULL default '',
file_name varchar( 200 ) NOT NULL default '',
file_path text NOT NULL ,
file_size int( 11 ) unsigned NOT NULL default '0',
file_mtime int( 11 ) unsigned NOT NULL default '0',
file_inode int( 11 ) NOT NULL default '0',
file_ctime int( 11 ) unsigned NOT NULL default '0',
file_hash varchar( 64 ) NOT NULL default '',
file_status tinyint( 4 ) unsigned NOT NULL default '0',
file_orig_location text NOT NULL ,
file_orig_loc_desc varchar( 90 ) NOT NULL default '',
file_creator varchar( 90 ) NOT NULL default '',
file_dl_name varchar( 200 ) NOT NULL default '',
file_usage int( 11 ) unsigned NOT NULL default '0',
meta text NOT NULL ,
ident varchar( 90 ) NOT NULL default '',
creator varchar( 90 ) NOT NULL default '',
keywords text NOT NULL ,
description text NOT NULL ,
alt_text text NOT NULL ,
caption text NOT NULL ,
abstract text NOT NULL ,
search_content text NOT NULL ,
language char( 6 ) NOT NULL default '',
pages int( 4 ) unsigned NOT NULL default '0',
publisher varchar( 90 ) NOT NULL default '',
copyright text NOT NULL ,
instructions text NOT NULL ,
date_cr int( 11 ) unsigned NOT NULL default '0',
date_mod int( 11 ) unsigned NOT NULL default '0',
loc_desc varchar( 90 ) NOT NULL default '',
loc_country char( 6 ) NOT NULL default '',
loc_city varchar( 90 ) NOT NULL default '',
hres int( 11 ) unsigned NOT NULL default '0',
vres int( 11 ) unsigned NOT NULL default '0',
hpixels int( 11 ) unsigned NOT NULL default '0',
vpixels int( 11 ) unsigned NOT NULL default '0',
color_space varchar( 8 ) NOT NULL default '',
width float unsigned NOT NULL default '0',
height float unsigned NOT NULL default '0',
height_unit char( 6 ) NOT NULL default '',
PRIMARY KEY ( uid ) ,
KEY parent( pid ) ,
KEY media_type( media_type ) ,
KEY t3ver_oid( t3ver_oid ) ,
KEY file_type( file_type ) ,
KEY file_hash( file_hash ) ,
KEY file_name( file_name ) ,
KEY file_path( file_path )
)

MySQL
#1170 - BLOB/TEXT column 'file_path' used in key specification without a 
key length

How to fix