关于导入mysql数据库问题

错误

SQL 查询:

CREATE TABLE zen_configuration(
configuration_id int( 11 ) NOT NULL AUTO_INCREMENT ,
configuration_title text NOT NULL ,
configuration_key varchar( 255 ) NOT NULL ,
configuration_value text NOT NULL ,
configuration_description text NOT NULL ,
configuration_group_id int( 11 ) NOT NULL ,
sort_order int( 5 ) ,
last_modified datetime,
date_added datetime DEFAULT '0001-01-01 00:00:00' NOT NULL ,
use_function text,
set_function text,
PRIMARY KEY ( configuration_id ) ,
KEY unq_config_key_zen( configuration_key ) ,
KEY idx_key_value_zen( configuration_key, configuration_value ) ,
KEY idx_cfg_grp_id_zen( configuration_group_id )
);

MySQL 返回：文档
#1170 - BLOB/TEXT column 'configuration_value' used in key specification without a key length 


我重另外一台服务器 备份下来 utf8编码这些都没错 但是为什么我导入新的服务器里面就出现这样的情况 在线求解

mysql> CREATE TABLE zen_configuration(
  -> configuration_id int( 11 ) NOT NULL AUTO_INCREMENT ,
  -> configuration_title text NOT NULL ,
  -> configuration_key varchar( 255 ) NOT NULL ,
  -> configuration_value text NOT NULL ,
  -> configuration_description text NOT NULL ,
  -> configuration_group_id int( 11 ) NOT NULL ,
  -> sort_order int( 5 ) ,
  -> last_modified datetime,
  -> date_added datetime DEFAULT '0001-01-01 00:00:00' NOT NULL ,
  -> use_function text,
  -> set_function text,
  -> PRIMARY KEY ( configuration_id ) ,
  -> KEY unq_config_key_zen( configuration_key ) ,
  -> KEY idx_key_value_zen( configuration_key, configuration_value(100) ) ,
  -> KEY idx_cfg_grp_id_zen( configuration_group_id )
  -> );
Query OK, 0 rows affected (0.30 sec)

请问我怎么修改 我菜鸟