**Corrupt file** - "create_tables.sql" in download zip

[berberama]

Install instructions here: http://www.letodms.com/doc/doku.php?id=install:install

But... When going to step #6 "Execute “create_tables.sql” to preload database"

MySQL displays error for database as:

Code:

Error

SQL query:

-- --------------------------------------------------------
--
-- Table structure for table `tblCategory`
--
CREATE TABLE `tblCategory` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` text NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE (
`name`
)
) ENGINE = MYISAM DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1170 - BLOB/TEXT column 'name' used in key specification without a key length

How do we fix that. I can see table created, but they do not work (because of above error) - check.php displays:

Code:

settings->_rootDir : Ok
settings->_httpRoot : Ok
settings->_contentDir : Ok
settings->_ADOdbPath : Ok
database - table 'tblAcls' : Error

table 'tblAcls' Table not found
database - table 'tblDirPath' : Error

table 'tblDirPath' Table not found
database - table 'tblEvents' : Error

table 'tblEvents' Table not found
database - table 'tblMandatoryApprovers' : Error

table 'tblMandatoryApprovers' Table not found
database - table 'tblMandatoryReviewers' : Error

table 'tblMandatoryReviewers' Table not found
database - table 'tblNotify' : Error

table 'tblNotify' Table not found
database - table 'tblPathList' : Error

table 'tblPathList' Table not found
database - table 'tblSessions' : Error

table 'tblSessions' Table not found
database - table 'tblUsers' : Error

table 'tblUsers' 'isAdmin' not found ;
database : Error

Again, I can see all tables, but because of error (in the .sql file) they do not work.

What can I do to fix this?

Thank you.