MySQL Version: 5.5.27
// Specified key was too long; max key length is 767 bytes
CREATE TABLE QRTZ_JOB_DETAILS
(
SCHED_NAME VARCHAR(120) NOT NULL,
JOB_NAME VARCHAR(200) NOT NULL,
JOB_GROUP VARCHAR(200) NOT NULL,
DESCRIPTION VARCHAR(250) NULL,
JOB_CLASS_NAME VARCHAR(250) NOT NULL,
IS_DURABLE VARCHAR(1) NOT NULL,
IS_NONCONCURRENT VARCHAR(1) NOT NULL,
IS_UPDATE_DATA VARCHAR(1) NOT NULL,
REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
JOB_DATA BLOB NULL,
PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
)
# 错误是因为utf8字节的计算方式，每个字符占3字节。 120 * 200 * 200 * 3。所以报错
# 解决方式
# 首先要保证数据库引擎是使用 innodb.
show global variables like "innodb_large_prefix";
show global variables like "innodb_file_per_table";
show variables like 'innodb_file_format';
SET GLOBAL innodb_large_prefix = on;
SET GLOBAL innodb_file_per_table = on;
SET GLOBAL innodb_file_format = BARRACUDA;
# 在创建语句后加 row_format = dynamic
