[Err] 1071 - Specified key was too long; max key length is 1000 bytes
[Err] CREATE TABLE IF NOT EXISTS `character_variables` (
`obj_id` INT NOT NULL DEFAULT '0',
`type` VARCHAR(86) NOT NULL DEFAULT '0',
`name` VARCHAR(86) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
`value` VARCHAR(4000) CHARACTER SET UTF8 NOT NULL DEFAULT '0',
`expire_time` bigint(20) NOT NULL DEFAULT '0',
UNIQUE KEY `prim` (`obj_id`,`type`,`name`),
KEY `obj_id` (`obj_id`),
KEY `type` (`type`),
KEY `name` (`name`),
KEY `value` (`value`),
KEY `expire_time` (`expire_time`)
) ENGINE=MyISAM;
[Msg] Finished - Unsuccessfully >>>>>How to fix .bat error