quartz mysql 建表_quartz创建表语句

quartz创建表语句

目录 :

该建表语句适用2.xx版本,每个表的用途可以问度娘.(oracle)

该建表语句适用2.xx版本,每个表的用途可以问度娘.(mysql)

-- 存储每一个已配置的 Job 的详细信息

CREATE TABLE qrtz_job_details

(

SCHED_NAME VARCHAR2(120) NOT NULL,

JOB_NAME VARCHAR2(200) NOT NULL,

JOB_GROUP VARCHAR2(200) NOT NULL,

DESCRIPTION VARCHAR2(250) NULL,

JOB_CLASS_NAME VARCHAR2(250) NOT NULL,

IS_DURABLE VARCHAR2(1) NOT NULL,

IS_NONCONCURRENT VARCHAR2(1) NOT NULL,

IS_UPDATE_DATA VARCHAR2(1) NOT NULL,

REQUESTS_RECOVERY VARCHAR2(1) NOT NULL,

JOB_DATA BLOB NULL,

CONSTRAINT QRTZ_JOB_DETAILS_PK PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)

);

-- 存储已配置的 Trigger 的信息

CREATE TABLE qrtz_triggers

(

SCHED_NAME VARCHAR2(120) NOT NULL,

TRIGGER_NAME VARCHAR2(200) NOT NULL,

TRIGGER_GROUP VARCHAR2(200) NOT NULL,

JOB_NAME VARCHAR2(200) NOT NULL,

JOB_GROUP VARCHAR2(200) NOT NULL,

DESCRIPTION VARCHAR2(250) NULL,

NEXT_FIRE_TIME NUMBER(13) NULL,

PREV_FIRE_TIME NUMBER(13) NULL,

PRIORITY NUMBER(13) NULL,

TRIGGER_STATE VARCHAR2(16) NOT NULL,

TRIGGER_TYPE VARCHAR2(8) NOT NULL,

START_TIME NUMBER(13) NOT NULL,

END_TIME NUMBER(13) NULL,

CALENDAR_NAME VARCHAR2(200) NULL,

MISFIRE_INSTR NUMBER(2) NULL,

JOB_DATA BLOB NULL,

CONSTRAINT QRTZ_TRIGGERS_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),

CONSTRAINT QRTZ_TRIGGER_TO_JOBS_FK FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)

REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP)

);

-- 存储简单的 Trigger，包括重复次数，间隔，以及已触的次数

CREATE TABLE qrtz_simple_triggers

(

SCHED_NAME VARCHAR2(120) NOT NULL,

TRIGGER_NAME VARCHAR2(200) NOT NULL,

TRIGGER_GROUP VARCHAR2(200) NOT NULL,

REPEAT_COUNT NUMBER(7) NOT NULL,

REPEAT_INTERVAL NUMBER(12) NOT NULL,

TIMES_TRIGGERED NUMBER(10) NOT NULL,

CONSTRAINT QRTZ_SIMPLE_TRIG_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),

CONSTRAINT QRTZ_SIMPLE_TRIG_TO_TRIG_FK FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)

REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)

);

-- 存储 Cron Trigger，包括 Cron 表达式和时区信息

CREATE TABLE qrtz_cron_triggers

(

SCHED_NAME VARCHAR2(120) NOT NULL,

TRIGGER_NAME VARCHAR2(200) NOT NULL,

TRIGGER_GROUP VARCHAR2(200) NOT NULL,

CRON_EXPRESSION VARCHAR2(120) NOT NULL,

TIME_ZONE_ID VARCHAR2(80),

CONSTRAINT QRTZ_CRON_TRIG_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),

CONSTRAINT QRTZ_CRON_TRIG_TO_TRIG_FK FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)

REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)

);

CREATE TABLE qrtz_simprop_triggers

(

SCHED_NAME VARCHAR2(120) NOT NULL,

TRIGGER_NAME VARCHAR2(200) NOT NULL,

TRIGGER_GROUP VARCHAR2(200) NOT NULL,

STR_PROP_1 VARCHAR2(512) NULL,

STR_P