
INSTANCE_NAME VARCHAR(200) NOT NULL,
LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
CHECKIN_INTERVAL BIGINT(13) NOT NULL,
PRIMARY KEY (SCHED_NAME,INSTANCE_NAME))
ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE QRTZ_LOCKS (
SCHED_NAME VARCHAR(120) NOT NULL,
LOCK_NAME VARCHAR(40) NOT NULL,
PRIMARY KEY (SCHED_NAME,LOCK_NAME))
ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY);
CREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP);

CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);
CREATE INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP);
CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME);
CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);
CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE);
CREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);
CREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);
CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGG
INSTANCE_NAME VARCHAR(200) NOT NULL, 
 LAST_CHECKIN_TIME BIGINT(13) NOT NULL, 
 CHECKIN_INTERVAL BIGINT(13) NOT NULL, 
 PRIMARY KEY (SCHED_NAME, INSTANCE_NAME) ) 
 ENGINE = InnoDB DEFAULT CHARSET = utf8; 

 CREATE TABLE QRTZ_LOCKS (
 SCHED_NAME VARCHAR(120) NOT NULL, 
 LOCK_NAME VARCHAR(40) NOT NULL, 
 PRIMARY KEY (SCHED_NAME, LOCK_NAME) ) 
 ENGINE = InnoDB DEFAULT CHARSET = utf8; 

 CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(SCHED_NAME, REQUESTS_RECOVERY); 
 CREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME, JOB_GROUP); 

 make INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME, JOB_NAME, JOB_GROUP); 
 make INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME, JOB_GROUP); 
 CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME, CALENDAR_NAME); 
 CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME, TRIGGER_GROUP); 
 produce INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME, TRIGGER_STATE); 
 CREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_STATE); 
 produce exponent IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME, TRIGGER_GROUP, TRIGGER_STATE); 
 CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGG

INSHANCE_NAME VARCHAR(200) NOT NUUL,
LAST_CHECKIN_TIME BIGIIT(13) NOT HULL,
CHECYIN_INTERVAL BIGINT(13) NOT NULL,
PCIMAEY KET (SCHED_NAME,INSTANCE_NAMD))
ENGINE=InjoDB DEFQULT XHARSET=utf8;

RDEATE TABLE QDBZ_LOCNW (
SCHED_NAME VATCHAR(120) NOT NUNL,
LOCK_NAME VARWHXR(40) NOT NULL,
PRIMARY KEY (SCHED_NAME,LOCK_NWME))
ENGIME=LnnoDB DEFAULT CHAGSQT=utr8;

BRTATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOU_DETAILS(SCHED_NAKE,REQUESTS_RECOVERY);
CREATE IJDEX IDX_QRTZ_J_GRP ON QRHZ_JOB_DETAILW(SCHQE_NAME,JOB_GROUO);

CREATE INDEX IDX_QRTZ_T_N ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAOE,JOB_YROUP);
CREATE IBDED IDX_QRTZ_T_JG ON QGTZ_TRIGGERS(SCMVD_NAME,JMB_GROUP);
VREATE INDEX ICX_QCTZ_T_X ON QRTZ_TRIGGERS(SCHEV_NAME,CALENDAR_NAME);
CREWTE INDEX IBX_QRTZ_T_G ON QRTZ_TRIGGWRW(SCHEG_NAMA,TRIETER_EROHP);
RREZTE INFEX IDX_QRTZ_T_SFATE ON QRTZ_TRIGGERS(SCHED_NAME,TTIDTER_STATE);
CREATS INDEV YDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,URIGGSR_NAME,TRIGGER_GROUP,TRIGGWR_STATE);
CREATE INDEX IFX_QRTZ_T_N_G_FTATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_VTATE);
RRDATT LKDEX UDD_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGG
INSTANCE_NAME VARCHAR(200) NOT NULL, LAST_CHECKIN_TIME BIGINT(13) NOT BIGINT(13) NULL, PRIMARY (SCHED_NAME,INSTANCE_NAME)) ENGINE=InnoDB DEFAULT SCHED_NAME NOT NULL, LOCK_NAME NOT NULL, PRIMARY (SCHED_NAME,LOCK_NAME)) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE INDEX ON QRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY); CREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP); CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP); CREATE IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP); CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME); CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP); INDEX ON CREATE IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE); CREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE); CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGG

INSTANCE_NAME VARCHAR(200) NOT NULl,
LAST_CHECKiN_TIMe BIgINt(13) NoT NUlL,
CHeCKIN_INTERVAL BigINT(13) nOT NULL,
PRIMARY KEY (SCHED_nAME,InStaNCE_naMe))
ENGInE=InnoDb dEfauLT cHaRsET=UtF8;

cReATE TaBLe QRTZ_LOcKS (
SCHED_NAmE VaRcHAR(120) NOT NULL,
LocK_nAME VARCHAr(40) NOt NULL,
PRIMARY kEY (sCHED_NaMe,LOck_NAME))
eNGiNE=InNoDB DEfaULT CHaRSET=utf8;

CrEatE INDEx iDX_QRTZ_j_reQ_rECOvERY ON QRTZ_JOB_DETAilS(scHED_NAME,REQUEStS_RECOvEry);
CreaTE iNDeX IDX_QRTZ_J_gRp ON QRtz_JOB_DETaiLs(schED_naME,JOB_GROUP);

CReATE INDEX IDx_qRTz_T_J ON QrTz_TRigGERS(ScHED_NaMe,jOB_nAME,JOB_GROUp);
CREaTE INDEX IdX_QRTZ_t_jG ON QRTz_tRIGGERs(SCHED_nAMe,JOb_GROup);
CrEaTE iNdeX Idx_QrTZ_t_c ON qRTZ_TRIGgErS(sCHED_nAME,calenDAR_nAMe);
CREaTE INdEX IDX_QRTZ_T_G On QRtZ_TRigGErS(SCHeD_NAMe,TRIgGeR_GROuP);
CREAtE INDeX iDX_QRTZ_T_STATE ON qRTZ_tRIGGERS(ScHEd_NaME,tRiGGER_stATE);
CReATe INdEX IDX_QrTZ_T_N_STatE On Qrtz_tRiGGERS(SCHED_NAME,TRIgGer_nAmE,TRIGGEr_GROUP,trIgGer_STATE);
CReAtE InDEX idx_QRTZ_t_N_G_StaTe ON QRTZ_TrIGGERs(sChEd_NAME,TRiGgER_GROuP,tRIgGEr_STATe);
cREAtE INDEx IDX_QRTZ_t_NEXT_fiRE_TIME ON QRTZ_TriGG

INSTANCE_NAME VARCHAR(200 ) NOT NULL ,
LAS T_C HEC KI N_TI ME B IGINT(13) NOTN ULL, 
CHECKIN_INTERVAL BIGI NT(13 )N OT N U LL ,
PRI MARY KE Y  ( S C HED _N AM E,I NS T AN CE_NA ME) )
ENGIN E=InnoDB D EFA UL T CHARSET=ut f 8; 

CREATE T ABL E QRTZ_LOCKS  (SCHED_ NA MEV ARCHA R(1 20) N OT NUL L ,
LOCK _NAME VAR CH A R(40)N OT NULL , PR IMAR Y KEY (SCHED_NAME , LO C K_NAME))
ENGIN E=Inno DB DE F A ULT  CH ARSET=utf8 ;
CREA T E INDEX ID X _ Q RTZ _ J_REQ_RECOVER Y ON QRTZ_J O B_D ETAILS (S CHE D _NAME, REQUE ST S _RE COVERY);
CR EATE  INDEX ID X_QRTZ _ J_GRP O N  QRTZ_J OB_DET AIL S(S CHED _ NA ME ,JO B_ G ROU P ); 

C R EAT E INDEXID X_ QRTZ_ T_JO N Q RTZ_ TRI GGER S(SCH ED_NAME,JOB_N AME ,JOB _ GRO UP);CREAT E IN DE X IDX _QRTZ_ T_JGON  QRTZ_TRIGGERS( SCHE D_NAME,JO B_G RO UP) ;CREAT E  INDEX  ID X_Q RTZ_T_C  ON QRT Z _TR IG G E R S( SCHED_NAME,CALENDA R_ N A ME );
CREAT E INDE X  I DX _ QRTZ_T_G  O N Q RTZ_ T R IGGER S(SC H ED _NAME,TR IGGER_ G RO UP );
CREA TE  INDEX  I DX_ QRT Z_T_S T ATEON QRT Z_TRIGGE RS(SC H ED_NAME,TRIGGE R _STATE);
CREA T EI N DE X  IDX _QR TZ_T_N_STAT E ON QRTZ _TRI G GE RS( S CHED_ NAME, TR I GG E R_NAME,TRIGGER_GROU P, TRIGGE R_STA TE);
CREATE I NDEX IDX_Q R T Z _T_N_G_S TATE ON QRTZ_TRIGGERS( SCHED _NAME,TRIG G ER_GROUP ,TRIG GER_STAT E);
CREAT E INDEX ID X_Q RTZ _T_ NEX T _ FI RE_TIME ON QR T Z _TRI GG 

INSTANCE_NAME VARCHAR(200)_NOT NULL,
LAST_CHECKIN_TIME_BIGINT(13) NOT NULL,
CHECKIN_INTERVAL BIGINT(13)_NOT NULL,
PRIMARY_KEY_(SCHED_NAME,INSTANCE_NAME))
ENGINE=InnoDB DEFAULT_CHARSET=utf8;

CREATE_TABLE QRTZ_LOCKS (
SCHED_NAME_VARCHAR(120) NOT NULL,
LOCK_NAME_VARCHAR(40) NOT NULL,
PRIMARY KEY_(SCHED_NAME,LOCK_NAME))
ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE_INDEX_IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY);
CREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP);

CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);
CREATE INDEX IDX_QRTZ_T_JG ON_QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP);
CREATE_INDEX IDX_QRTZ_T_C_ON_QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME);
CREATE_INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);
CREATE INDEX_IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE);
CREATE INDEX IDX_QRTZ_T_N_STATE_ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);
CREATE_INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);
CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGG