CREATE TABLE `QRTZ_TRIGGERS` (
  `TRIGGER_NAME` varchar(255) NOT NULL,
  `TRIGGER_GROUP` varchar(20) NOT NULL,
  `JOB_NAME` varchar(255) NOT NULL,
  `JOB_GROUP` varchar(20) NOT NULL,
  `IS_VOLATILE` varchar(1) NOT NULL,
  `DESCRIPTION` varchar(120) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(80) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` longblob,
  PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `JOB_NAME` (`JOB_NAME`,`JOB_GROUP`),
  KEY `idx_qrtz_t_next_fire_time` (`NEXT_FIRE_TIME`),
  KEY `idx_qrtz_t_state` (`TRIGGER_STATE`),
  KEY `idx_qrtz_t_nft_st` (`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `idx_qrtz_t_volatile` (`IS_VOLATILE`),
  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

  KEY `JOB_NAME` (`JOB_NAME`,`JOB_GROUP`),
  KEY `idx_qrtz_t_next_fire_time` (`NEXT_FIRE_TIME`),
  KEY `idx_qrtz_t_state` (`TRIGGER_STATE`),
  KEY `idx_qrtz_t_nft_st` (`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `idx_qrtz_t_volatile` (`IS_VOLATILE`),