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 '触发器的类型';

