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;
I got a Error whit this if itry to put install database?
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table '11.character_variables' doesn't exist
if try to instal the missing character_variables i got this eror:
[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
somewone got a good character_variables Execule Batch File for me.
Somewone to help to fix this please