dudas dudas y mas dudas

[freskury]

consulta SQL:

¿Que me quiere decir que tengo mal?

CREATE TABLE `guestbook` (

`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`name` TEXT CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`email` TEXT CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`comments` TEXT CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL ,
`time` DATE NOT NULL ,
FULLTEXT (
`name` ,
`email` ,
`comments`
)
) ENGINE = MYISAM

MySQL ha dicho:

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key