CREATE TABLE "QRTZ_BLOB_TRIGGERS"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"TRIGGER_NAME" VARCHAR(200 char) NOT NULL,
|
"TRIGGER_GROUP" VARCHAR(200 char) NOT NULL,
|
"BLOB_DATA" BLOB NULL
|
);
|
CREATE TABLE "QRTZ_CALENDARS"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"CALENDAR_NAME" VARCHAR(200 char) NOT NULL,
|
"CALENDAR" BLOB NOT NULL
|
);
|
CREATE TABLE "QRTZ_CRON_TRIGGERS"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"TRIGGER_NAME" VARCHAR(200 char) NOT NULL,
|
"TRIGGER_GROUP" VARCHAR(200 char) NOT NULL,
|
"CRON_EXPRESSION" VARCHAR(200 char) NOT NULL,
|
"TIME_ZONE_ID" VARCHAR(80 char) NULL
|
);
|
CREATE TABLE "QRTZ_FIRED_TRIGGERS"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"ENTRY_ID" VARCHAR(95 char) NOT NULL,
|
"TRIGGER_NAME" VARCHAR(200 char) NOT NULL,
|
"TRIGGER_GROUP" VARCHAR(200 char) NOT NULL,
|
"INSTANCE_NAME" VARCHAR(200 char) NOT NULL,
|
"FIRED_TIME" BIGINT NOT NULL,
|
"SCHED_TIME" BIGINT NOT NULL,
|
"PRIORITY" INT NOT NULL,
|
"STATE" VARCHAR(16 char) NOT NULL,
|
"JOB_NAME" VARCHAR(200 char) NULL,
|
"JOB_GROUP" VARCHAR(200 char) NULL,
|
"IS_NONCONCURRENT" VARCHAR(1 char) NULL,
|
"REQUESTS_RECOVERY" VARCHAR(1 char) NULL
|
);
|
CREATE TABLE "QRTZ_JOB_DETAILS"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"JOB_NAME" VARCHAR(200 char) NOT NULL,
|
"JOB_GROUP" VARCHAR(200 char) NOT NULL,
|
"DESCRIPTION" VARCHAR(250 char) NULL,
|
"JOB_CLASS_NAME" VARCHAR(250 char) NOT NULL,
|
"IS_DURABLE" VARCHAR(1 char) NOT NULL,
|
"IS_NONCONCURRENT" VARCHAR(1 char) NOT NULL,
|
"IS_UPDATE_DATA" VARCHAR(1 char) NOT NULL,
|
"REQUESTS_RECOVERY" VARCHAR(1 char) NOT NULL,
|
"JOB_DATA" BLOB NULL
|
);
|
CREATE TABLE "QRTZ_LOCKS"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"LOCK_NAME" VARCHAR(40 char) NOT NULL
|
);
|
CREATE TABLE "QRTZ_PAUSED_TRIGGER_GRPS"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"TRIGGER_GROUP" VARCHAR(200 char) NOT NULL
|
);
|
CREATE TABLE "QRTZ_SCHEDULER_STATE"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"INSTANCE_NAME" VARCHAR(200 char) NOT NULL,
|
"LAST_CHECKIN_TIME" BIGINT NOT NULL,
|
"CHECKIN_INTERVAL" BIGINT NOT NULL
|
);
|
CREATE TABLE "QRTZ_SIMPLE_TRIGGERS"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"TRIGGER_NAME" VARCHAR(200 char) NOT NULL,
|
"TRIGGER_GROUP" VARCHAR(200 char) NOT NULL,
|
"REPEAT_COUNT" BIGINT NOT NULL,
|
"REPEAT_INTERVAL" BIGINT NOT NULL,
|
"TIMES_TRIGGERED" BIGINT NOT NULL
|
);
|
CREATE TABLE "QRTZ_SIMPROP_TRIGGERS"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"TRIGGER_NAME" VARCHAR(200 char) NOT NULL,
|
"TRIGGER_GROUP" VARCHAR(200 char) NOT NULL,
|
"STR_PROP_1" VARCHAR(512 char) NULL,
|
"STR_PROP_2" VARCHAR(512 char) NULL,
|
"STR_PROP_3" VARCHAR(512 char) NULL,
|
"INT_PROP_1" INT NULL,
|
"INT_PROP_2" INT NULL,
|
"LONG_PROP_1" BIGINT NULL,
|
"LONG_PROP_2" BIGINT NULL,
|
"DEC_PROP_1" DECIMAL(13,4) NULL,
|
"DEC_PROP_2" DECIMAL(13,4) NULL,
|
"BOOL_PROP_1" VARCHAR(1 char) NULL,
|
"BOOL_PROP_2" VARCHAR(1 char) NULL
|
);
|
CREATE TABLE "QRTZ_TRIGGERS"
|
(
|
"SCHED_NAME" VARCHAR(120 char) NOT NULL,
|
"TRIGGER_NAME" VARCHAR(200 char) NOT NULL,
|
"TRIGGER_GROUP" VARCHAR(200 char) NOT NULL,
|
"JOB_NAME" VARCHAR(200 char) NOT NULL,
|
"JOB_GROUP" VARCHAR(200 char) NOT NULL,
|
"DESCRIPTION" VARCHAR(250 char) NULL,
|
"NEXT_FIRE_TIME" BIGINT NULL,
|
"PREV_FIRE_TIME" BIGINT NULL,
|
"PRIORITY" INT NULL,
|
"TRIGGER_STATE" VARCHAR(16 char) NOT NULL,
|
"TRIGGER_TYPE" VARCHAR(8 char) NOT NULL,
|
"START_TIME" BIGINT NOT NULL,
|
"END_TIME" BIGINT NULL,
|
"CALENDAR_NAME" VARCHAR(200 char) NULL,
|
"MISFIRE_INSTR" SMALLINT NULL,
|
"JOB_DATA" BLOB NULL
|
);
|
ALTER TABLE "QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") ;
|
|
ALTER TABLE "QRTZ_CALENDARS" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","CALENDAR_NAME") ;
|
|
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") ;
|
|
ALTER TABLE "QRTZ_FIRED_TRIGGERS" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","ENTRY_ID") ;
|
|
ALTER TABLE "QRTZ_JOB_DETAILS" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","JOB_NAME","JOB_GROUP") ;
|
|
ALTER TABLE "QRTZ_LOCKS" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","LOCK_NAME") ;
|
|
ALTER TABLE "QRTZ_PAUSED_TRIGGER_GRPS" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","TRIGGER_GROUP") ;
|
|
ALTER TABLE "QRTZ_SCHEDULER_STATE" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","INSTANCE_NAME") ;
|
|
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") ;
|
|
ALTER TABLE "QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") ;
|
|
ALTER TABLE "QRTZ_TRIGGERS" ADD CONSTRAINT NOT CLUSTER PRIMARY KEY("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") ;
|
|
ALTER TABLE "QRTZ_BLOB_TRIGGERS" ADD CONSTRAINT "QRTZ_BLOB_TRIGGERS_IBFK_1" FOREIGN KEY("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") REFERENCES "QRTZ_TRIGGERS"("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") with index ;
|
|
ALTER TABLE "QRTZ_CRON_TRIGGERS" ADD CONSTRAINT "QRTZ_CRON_TRIGGERS_IBFK_1" FOREIGN KEY("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") REFERENCES "QRTZ_TRIGGERS"("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") with index ;
|
|
ALTER TABLE "QRTZ_SIMPLE_TRIGGERS" ADD CONSTRAINT "QRTZ_SIMPLE_TRIGGERS_IBFK_1" FOREIGN KEY("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") REFERENCES "QRTZ_TRIGGERS"("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") with index ;
|
|
ALTER TABLE "QRTZ_SIMPROP_TRIGGERS" ADD CONSTRAINT "QRTZ_SIMPROP_TRIGGERS_IBFK_1" FOREIGN KEY("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") REFERENCES "QRTZ_TRIGGERS"("SCHED_NAME","TRIGGER_NAME","TRIGGER_GROUP") with index ;
|
|
ALTER TABLE "QRTZ_TRIGGERS" ADD CONSTRAINT "QRTZ_TRIGGERS_IBFK_1" FOREIGN KEY("SCHED_NAME","JOB_NAME","JOB_GROUP") REFERENCES "QRTZ_JOB_DETAILS"("SCHED_NAME","JOB_NAME","JOB_GROUP") with index ;
|
|
CREATE INDEX "SCHED_NAME"
|
ON "QRTZ_TRIGGERS"("SCHED_NAME","JOB_NAME","JOB_GROUP");
|
ALTER INDEX "SCHED_NAME" VISIBLE;
|
|
COMMENT ON TABLE "QRTZ_BLOB_TRIGGERS" IS 'Blob类型的触发器表';
|
|
COMMENT ON COLUMN "QRTZ_BLOB_TRIGGERS"."BLOB_DATA" IS '存放持久化Trigger对象';
|
|
COMMENT ON COLUMN "QRTZ_BLOB_TRIGGERS"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON COLUMN "QRTZ_BLOB_TRIGGERS"."TRIGGER_GROUP" IS 'qrtz_triggers表trigger_group的外键';
|
|
COMMENT ON COLUMN "QRTZ_BLOB_TRIGGERS"."TRIGGER_NAME" IS 'qrtz_triggers表trigger_name的外键';
|
|
COMMENT ON TABLE "QRTZ_CALENDARS" IS '日历信息表';
|
|
COMMENT ON COLUMN "QRTZ_CALENDARS"."CALENDAR" IS '存放持久化calendar对象';
|
|
COMMENT ON COLUMN "QRTZ_CALENDARS"."CALENDAR_NAME" IS '日历名称';
|
|
COMMENT ON COLUMN "QRTZ_CALENDARS"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON TABLE "QRTZ_CRON_TRIGGERS" IS 'Cron类型的触发器表';
|
|
COMMENT ON COLUMN "QRTZ_CRON_TRIGGERS"."CRON_EXPRESSION" IS 'cron表达式';
|
|
COMMENT ON COLUMN "QRTZ_CRON_TRIGGERS"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON COLUMN "QRTZ_CRON_TRIGGERS"."TIME_ZONE_ID" IS '时区';
|
|
COMMENT ON COLUMN "QRTZ_CRON_TRIGGERS"."TRIGGER_GROUP" IS 'qrtz_triggers表trigger_group的外键';
|
|
COMMENT ON COLUMN "QRTZ_CRON_TRIGGERS"."TRIGGER_NAME" IS 'qrtz_triggers表trigger_name的外键';
|
|
COMMENT ON TABLE "QRTZ_FIRED_TRIGGERS" IS '已触发的触发器表';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."ENTRY_ID" IS '调度器实例id';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."FIRED_TIME" IS '触发的时间';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."INSTANCE_NAME" IS '调度器实例名';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."IS_NONCONCURRENT" IS '是否并发';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."JOB_GROUP" IS '任务组名';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."JOB_NAME" IS '任务名称';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."PRIORITY" IS '优先级';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."REQUESTS_RECOVERY" IS '是否接受恢复执行';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."SCHED_TIME" IS '定时器制定的时间';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."STATE" IS '状态';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."TRIGGER_GROUP" IS 'qrtz_triggers表trigger_group的外键';
|
|
COMMENT ON COLUMN "QRTZ_FIRED_TRIGGERS"."TRIGGER_NAME" IS 'qrtz_triggers表trigger_name的外键';
|
|
COMMENT ON TABLE "QRTZ_JOB_DETAILS" IS '任务详细信息表';
|
|
COMMENT ON COLUMN "QRTZ_JOB_DETAILS"."DESCRIPTION" IS '相关介绍';
|
|
COMMENT ON COLUMN "QRTZ_JOB_DETAILS"."IS_DURABLE" IS '是否持久化';
|
|
COMMENT ON COLUMN "QRTZ_JOB_DETAILS"."IS_NONCONCURRENT" IS '是否并发';
|
|
COMMENT ON COLUMN "QRTZ_JOB_DETAILS"."IS_UPDATE_DATA" IS '是否更新数据';
|
|
COMMENT ON COLUMN "QRTZ_JOB_DETAILS"."JOB_CLASS_NAME" IS '执行任务类名称';
|
|
COMMENT ON COLUMN "QRTZ_JOB_DETAILS"."JOB_DATA" IS '存放持久化job对象';
|
|
COMMENT ON COLUMN "QRTZ_JOB_DETAILS"."JOB_GROUP" IS '任务组名';
|
|
COMMENT ON COLUMN "QRTZ_JOB_DETAILS"."JOB_NAME" IS '任务名称';
|
|
COMMENT ON COLUMN "QRTZ_JOB_DETAILS"."REQUESTS_RECOVERY" IS '是否接受恢复执行';
|
|
COMMENT ON COLUMN "QRTZ_JOB_DETAILS"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON TABLE "QRTZ_LOCKS" IS '存储的悲观锁信息表';
|
|
COMMENT ON COLUMN "QRTZ_LOCKS"."LOCK_NAME" IS '悲观锁名称';
|
|
COMMENT ON COLUMN "QRTZ_LOCKS"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON TABLE "QRTZ_PAUSED_TRIGGER_GRPS" IS '暂停的触发器表';
|
|
COMMENT ON COLUMN "QRTZ_PAUSED_TRIGGER_GRPS"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON COLUMN "QRTZ_PAUSED_TRIGGER_GRPS"."TRIGGER_GROUP" IS 'qrtz_triggers表trigger_group的外键';
|
|
COMMENT ON TABLE "QRTZ_SCHEDULER_STATE" IS '调度器状态表';
|
|
COMMENT ON COLUMN "QRTZ_SCHEDULER_STATE"."CHECKIN_INTERVAL" IS '检查间隔时间';
|
|
COMMENT ON COLUMN "QRTZ_SCHEDULER_STATE"."INSTANCE_NAME" IS '实例名称';
|
|
COMMENT ON COLUMN "QRTZ_SCHEDULER_STATE"."LAST_CHECKIN_TIME" IS '上次检查时间';
|
|
COMMENT ON COLUMN "QRTZ_SCHEDULER_STATE"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON TABLE "QRTZ_SIMPLE_TRIGGERS" IS '简单触发器的信息表';
|
|
COMMENT ON COLUMN "QRTZ_SIMPLE_TRIGGERS"."REPEAT_COUNT" IS '重复的次数统计';
|
|
COMMENT ON COLUMN "QRTZ_SIMPLE_TRIGGERS"."REPEAT_INTERVAL" IS '重复的间隔时间';
|
|
COMMENT ON COLUMN "QRTZ_SIMPLE_TRIGGERS"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON COLUMN "QRTZ_SIMPLE_TRIGGERS"."TIMES_TRIGGERED" IS '已经触发的次数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPLE_TRIGGERS"."TRIGGER_GROUP" IS 'qrtz_triggers表trigger_group的外键';
|
|
COMMENT ON COLUMN "QRTZ_SIMPLE_TRIGGERS"."TRIGGER_NAME" IS 'qrtz_triggers表trigger_name的外键';
|
|
COMMENT ON TABLE "QRTZ_SIMPROP_TRIGGERS" IS '同步机制的行锁表';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."BOOL_PROP_1" IS 'Boolean类型的trigger的第一个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."BOOL_PROP_2" IS 'Boolean类型的trigger的第二个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."DEC_PROP_1" IS 'decimal类型的trigger的第一个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."DEC_PROP_2" IS 'decimal类型的trigger的第二个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."INT_PROP_1" IS 'int类型的trigger的第一个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."INT_PROP_2" IS 'int类型的trigger的第二个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."LONG_PROP_1" IS 'long类型的trigger的第一个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."LONG_PROP_2" IS 'long类型的trigger的第二个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."STR_PROP_1" IS 'String类型的trigger的第一个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."STR_PROP_2" IS 'String类型的trigger的第二个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."STR_PROP_3" IS 'String类型的trigger的第三个参数';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."TRIGGER_GROUP" IS 'qrtz_triggers表trigger_group的外键';
|
|
COMMENT ON COLUMN "QRTZ_SIMPROP_TRIGGERS"."TRIGGER_NAME" IS 'qrtz_triggers表trigger_name的外键';
|
|
COMMENT ON TABLE "QRTZ_TRIGGERS" IS '触发器详细信息表';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."CALENDAR_NAME" IS '日程表名称';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."DESCRIPTION" IS '相关介绍';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."END_TIME" IS '结束时间';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."JOB_DATA" IS '存放持久化job对象';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."JOB_GROUP" IS 'qrtz_job_details表job_group的外键';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."JOB_NAME" IS 'qrtz_job_details表job_name的外键';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."MISFIRE_INSTR" IS '补偿执行的策略';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."NEXT_FIRE_TIME" IS '上一次触发时间（毫秒）';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."PREV_FIRE_TIME" IS '下一次触发时间（默认为-1表示不触发）';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."PRIORITY" IS '优先级';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."SCHED_NAME" IS '调度名称';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."START_TIME" IS '开始时间';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."TRIGGER_GROUP" IS '触发器所属组的名字';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."TRIGGER_NAME" IS '触发器的名字';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."TRIGGER_STATE" IS '触发器状态';
|
|
COMMENT ON COLUMN "QRTZ_TRIGGERS"."TRIGGER_TYPE" IS '触发器的类型';
|
