互联网安全知识分享

DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;DROP TABLE IF EXISTS QRTZ_LOCKS;DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;DROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS;DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;DROP TABLE IF EXISTS QRTZ_TRIGGERS;DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;DROP TABLE IF EXISTS QRTZ_CALENDARS;

CREATE TABLE QRTZ_JOB_DETAILS(SCHED_NAME VARCHAR( 一 二0) NOT NULL,JOB_NAME VARCHAR( 二00) NOT NULL,JOB_GROUP VARCHAR( 二00) NOT NULL,DEION VARCHAR( 二 五0) NULL,JOB_CLASS_NAME VARCHAR( 二 五0) NOT NULL,IS_DURABLE VARCHAR( 一) NOT NULL,IS_NONCONCURRENT VARCHAR( 一) NOT NULL,IS_UPDATE_DATA VARCHAR( 一) NOT NULL,REQUESTS_RECOVERY VARCHAR( 一) NOT NULL,JOB_DATA BLOB NULL,PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP));

CREATE TABLE QRTZ_TRIGGERS(SCHED_NAME VARCHAR( 一 二0) NOT NULL,TRIGGER_NAME VARCHAR( 二00) NOT NULL,TRIGGER_GROUP VARCHAR( 二00) NOT NULL,JOB_NAME VARCHAR( 二00) NOT NULL,JOB_GROUP VARCHAR( 二00) NOT NULL,DEION VARCHAR( 二 五0) NULL,NEXT_FIRE_TIME BIGINT( 一 三) NULL,PREV_FIRE_TIME BIGINT( 一 三) NULL,PRIORITY INTEGER NULL,TRIGGER_STATE VARCHAR( 一 六) NOT NULL,TRIGGER_TYPE VARCHAR( 八) NOT NULL,START_TIME BIGINT( 一 三) NOT NULL,END_TIME BIGINT( 一 三) NULL,CALENDAR_NAME VARCHAR( 二00) NULL,MISFIRE_INSTR 奸淫ALLINT( 二) NULL,JOB_DATA BLOB NULL,PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP));

CREATE TABLE QRTZ_SIMPLE_TRIGGERS(SCHED_NAME VARCHAR( 一 二0) NOT NULL,TRIGGER_NAME VARCHAR( 二00) NOT NULL,TRIGGER_GROUP VARCHAR( 二00) NOT NULL,REPEAT_COUNT BIGINT( 七) NOT NULL,REPEAT_INTERVAL BIGINT( 一 二) NOT NULL,TIMES_TRIGGERED BIGINT( 一0) NOT NULL,PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP));

CREATE TABLE QRTZ_CRON_TRIGGERS(SCHED_NAME VARCHAR( 一 二0) NOT NULL,TRIGGER_NAME VARCHAR( 二00) NOT NULL,TRIGGER_GROUP VARCHAR( 二00) NOT NULL,CRON_EXPRESSION VARCHAR( 二00) NOT NULL,TIME_ZONE_ID VARCHAR( 八0),PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP));

CREATE TABLE QRTZ_SIMPROP_TRIGGERS(SCHED_NAME VARCHAR( 一 二0) NOT NULL,TRIGGER_NAME VARCHAR( 二00) NOT NULL,TRIGGER_GROUP VARCHAR( 二00) NOT NULL,STR_PROP_ 一 VARCHAR( 五 一 二) NULL,STR_PROP_ 二 VARCHAR( 五 一 二) NULL,STR_PROP_ 三 VARCHAR( 五 一 二) NULL,INT_PROP_ 一 INT NULL,INT_PROP_ 二 INT NULL,LONG_PROP_ 一 BIGINT NULL,LONG_PROP_ 二 BIGINT NULL,DEC_PROP_ 一 NUMERIC( 一 三, 四) NULL,DEC_PROP_ 二 NUMERIC( 一 三, 四) NULL,BOOL_PROP_ 一 VARCHAR( 一) NULL,BOOL_PROP_ 二 VARCHAR( 一) NULL,PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP));

CREATE TABLE QRTZ_BLOB_TRIGGERS(SCHED_NAME VARCHAR( 一 二0) NOT NULL,TRIGGER_NAME VARCHAR( 二00) NOT NULL,TRIGGER_GROUP VARCHAR( 二00) NOT NULL,BLOB_DATA BLOB NULL,PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP));

CREATE TABLE QRTZ_CALENDARS(SCHED_NAME VARCHAR( 一 二0) NOT NULL,CALENDAR_NAME VARCHAR( 二00) NOT NULL,CALENDAR BLOB NOT NULL,PRIMARY KEY (SCHED_NAME,CALENDAR_NAME));

CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS(SCHED_NAME VARCHAR( 一 二0) NOT NULL,TRIGGER_GROUP VARCHAR( 二00) NOT NULL,PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP));

CREATE TABLE QRTZ_FIRED_TRIGGERS(SCHED_NAME VARCHAR( 一 二0) NOT NULL,ENTRY_ID VARCHAR( 九 五) NOT NULL,TRIGGER_NAME VARCHAR( 二00) NOT NULL,TRIGGER_GROUP VARCHAR( 二00) NOT NULL,INSTANCE_NAME VARCHAR( 二00) NOT NULL,FIRED_TIME BIGINT( 一 三) NOT NULL,SCHED_TIME BIGINT( 一 三) NOT NULL,PRIORITY INTEGER NOT NULL,STATE VARCHAR( 一 六) NOT NULL,JOB_NAME VARCHAR( 二00) NULL,JOB_GROUP VARCHAR( 二00) NULL,IS_NONCONCURRENT VARCHAR( 一) NULL,REQUESTS_RECOVERY VARCHAR( 一) NULL,PRIMARY KEY (SCHED_NAME,ENTRY_ID));

CREATE TABLE QRTZ_SCHEDULER_STATE(SCHED_NAME VARCHAR( 一 二0) NOT NULL,INSTANCE_NAME VARCHAR( 二00) NOT NULL,LAST_CHECKIN_TIME BIGINT( 一 三) NOT NULL,CHECKIN_INTERVAL BIGINT( 一 三) NOT NULL,PRIMARY KEY (SCHED_NAME,INSTANCE_NAME));

CREATE TABLE QRTZ_LOCKS(SCHED_NAME VARCHAR( 一 二0) NOT NULL,LOCK_NAME VARCHAR( 四0) NOT NULL,PRIMARY KEY (SCHED_NAME,LOCK_NAME));

运用tables-mysql.sql创立 表的语句执止实现后，解释 Quartz的数据库战表创立 胜利 ，咱们审查数据库的ER图，以下图所示。

 三. 设置装备摆设 数据库战Quartz

修正 application.properties设置装备摆设 文献，设置装备摆设 数据库取Quartz。详细 操做以下：