DB ERROR

hi
   
I can not install because it gives me error in the database:


Can't create tables... you can do that manually using phpMyAdmin, see install/db.sql file for tables structure.
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '', `time` int(10 - 1064

CREATE TABLE `pas_ban` ( `ip` varchar(15) collate latin1_general_ci NOT NULL default '', `time` int(10) unsigned NOT NULL default '0', `type` int(1) unsigned NOT NULL default '0', KEY `time` (`time`), KEY `ip` (`ip`) ) TYPE=MyISAM CHARACTER SET `utf8`


please help me

thanks
tiziana facco

maybe you don't have this collation compiled into your mysql server:

collate latin1_general_ci

try removing the collate latin1_general_ci and import the sql again

that's right, tizianafacco and I just forgot to tell here that the problem is already resolved.