 CHECKIN_INTERVAL BIGINT(13) NOT NULL,
 RECOVERER VARCHAR(80) NULL,
 PRIMARY KEY (INSTANCE_NAME))
-TYPE=InnoDB;
+ENGINE=InnoDB;
 
 CREATE TABLE QRTZ_LOCKS (
 LOCK_NAME VARCHAR(40) NOT NULL,
 PRIMARY KEY (LOCK_NAME))
-TYPE=InnoDB;
+ENGINE=InnoDB;
 
 INSERT INTO QRTZ_LOCKS values('TRIGGER_ACCESS');
 INSERT INTO QRTZ_LOCKS values('JOB_ACCESS');

INDEX (TRIGGER_NAME, TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP))
TYPE=InnoDB;

CREATE TABLE QRTZ_CRON_TRIGGERS (
TRIGGER_NAME VARCHAR(80) NOT NULL,

INDEX (TRIGGER_NAME, TRIGGER_GROUP),
FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP))
ENGINE=InnoDB;

CREATE TABLE QRTZ_BLOB_TRIGGERS (
TRIGGER_NAME VARCHAR(80) NOT NULL,
