xxljob

create table mm.dj_qrtz_job_details
  (
    sched_name character varying(128) not null,
    job_name  character varying(256) not null,
    job_group character varying(256) not null,
    description character varying(256) null,
    job_class_name   character varying(256) not null,
    is_durable character varying(1) not null,
    is_nonconcurrent character varying(1) not null,
    is_update_data character varying(1) not null,
    requests_recovery character varying(1) not null,
    job_data bytea null,
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,job_name,job_group)
);


create table mm.dj_qrtz_triggers
  (
    sched_name character varying(128) not null,
    trigger_name character varying(256) not null,
    trigger_group character varying(256) not null,
    job_name  character varying(256) not null,
    job_group character varying(256) not null,
    description character varying(256) null,
    next_fire_time bigint null,
    prev_fire_time bigint null,
    priority integer null,
    trigger_state character varying(16) not null,
    trigger_type character varying(8) not null,
    start_time bigint not null,
    end_time bigint null,
    calendar_name character varying(256) null,
    misfire_instr smallint null,
    job_data bytea null,
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,trigger_name,trigger_group),
    foreign key (sched_name,job_name,job_group)
        references mm.dj_qrtz_job_details(sched_name,job_name,job_group)
);


create table mm.dj_qrtz_simple_triggers
  (
    sched_name character varying(128) not null,
    trigger_name character varying(256) not null,
    trigger_group character varying(256) not null,
    repeat_count bigint not null,
    repeat_interval bigint not null,
    times_triggered bigint not null,
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,trigger_name,trigger_group),
    foreign key (sched_name,trigger_name,trigger_group)
        references mm.dj_qrtz_triggers(sched_name,trigger_name,trigger_group)
);


create table mm.dj_qrtz_cron_triggers
  (
    sched_name character varying(128) not null,
    trigger_name character varying(256) not null,
    trigger_group character varying(256) not null,
    cron_expression character varying(256) not null,
    time_zone_id character varying(80),
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,trigger_name,trigger_group),
    foreign key (sched_name,trigger_name,trigger_group)
        references mm.dj_qrtz_triggers(sched_name,trigger_name,trigger_group)
);


create table mm.dj_qrtz_simprop_triggers
  (          
    sched_name character varying(128) not null,
    trigger_name character varying(256) not null,
    trigger_group character varying(256) not null,
    str_prop_1 character varying(512) null,
    str_prop_2 character varying(512) null,
    str_prop_3 character varying(512) null,
    int_prop_1 int null,
    int_prop_2 int null,
    long_prop_1 bigint null,
    long_prop_2 bigint null,
    dec_prop_1 numeric(13,4) null,
    dec_prop_2 numeric(13,4) null,
    bool_prop_1 character varying(1) null,
    bool_prop_2 character varying(1) null,
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,trigger_name,trigger_group),
    foreign key (sched_name,trigger_name,trigger_group) 
    references mm.dj_qrtz_triggers(sched_name,trigger_name,trigger_group)
);


create table mm.dj_qrtz_bytea_triggers
  (
    sched_name character varying(128) not null,
    trigger_name character varying(256) not null,
    trigger_group character varying(256) not null,
    bytea_data bytea null,
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,trigger_name,trigger_group),
    foreign key (sched_name,trigger_name,trigger_group)
        references mm.dj_qrtz_triggers(sched_name,trigger_name,trigger_group)
);


create table mm.dj_qrtz_calendars
  (
    sched_name character varying(128) not null,
    calendar_name  character varying(256) not null,
    calendar bytea not null,
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,calendar_name)
);


create table mm.dj_qrtz_paused_trigger_grps
  (
    sched_name character varying(128) not null,
    trigger_group  character varying(256) not null, 
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,trigger_group)
);


create table mm.dj_qrtz_fired_triggers
  (
    sched_name character varying(128) not null,
    entry_id character varying(96) not null,
    trigger_name character varying(256) not null,
    trigger_group character varying(256) not null,
    instance_name character varying(256) not null,
    fired_time bigint not null,
    sched_time bigint not null,
    priority integer not null,
    state character varying(16) not null,
    job_name character varying(256) null,
    job_group character varying(256) null,
    is_nonconcurrent character varying(1) null,
    requests_recovery character varying(1) null,
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,entry_id)
);


create table mm.dj_qrtz_scheduler_state
  (
    sched_name character varying(128) not null,
    instance_name character varying(256) not null,
    last_checkin_time bigint not null,
    checkin_interval bigint not null,
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,instance_name)
);


create table mm.dj_qrtz_locks
  (
    sched_name character varying(128) not null,
    lock_name  character varying(48) not null, 
delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
    primary key (sched_name,lock_name)
);




CREATE SEQUENCE mm.seq_qrtz_trigger_info
    INCREMENT 1
    START 19
    MINVALUE 1
    MAXVALUE 9223372036854775807
    CACHE 1;
create table mm.dj_qrtz_trigger_info (
  id integer not null DEFAULT nextval('mm.seq_qrtz_trigger_info'::regclass),
  job_group integer not null ,
  job_cron character varying(128) not null,
  job_desc character varying(256) not null,
  add_time timestamp default null,
  author character varying(64) default null ,
  alarm_email character varying(256) default null ,
  executor_route_strategy character varying(64) default null,
  executor_handler character varying(256) default null ,
  executor_param character varying(512) default null ,
  executor_block_strategy character varying(64) default null ,
  executor_fail_strategy character varying(64) default null ,
  glue_type character varying(64) not null ,
  glue_source text ,
  glue_remark character varying(128) default null,
  glue_updatetime timestamp default null,
  child_jobid character varying(256) default null ,
  delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
  primary key (id)
) ;


CREATE SEQUENCE mm.seq_qrtz_trigger_log
    INCREMENT 1
    START 19
    MINVALUE 1
    MAXVALUE 9223372036854775807
    CACHE 1;
create table mm.dj_qrtz_trigger_log (
  id integer not null DEFAULT nextval('mm.seq_qrtz_trigger_log'::regclass),
  job_group integer not null ,
  job_id integer not null ,
  glue_type character varying(64) default null ,
  executor_address character varying(256) default null ,
  executor_handler character varying(256) default null ,
  executor_param character varying(512) default null,
  trigger_time timestamp default null ,
  trigger_code character varying(256) not null default '0',
  trigger_msg character varying(2048) default null ,
  handle_time timestamp default null ,
  handle_code character varying(256) not null default '0' ,
  handle_msg character varying(2048) default null,
  delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
  primary key (id)
) ;


CREATE SEQUENCE mm.seq_qrtz_trigger_logglue
    INCREMENT 1
    START 19
    MINVALUE 1
    MAXVALUE 9223372036854775807
    CACHE 1;
create table mm.dj_qrtz_trigger_logglue (
  id integer not null DEFAULT nextval('mm.seq_qrtz_trigger_logglue'::regclass),
  job_id integer not null ,
  glue_type character varying(64) default null ,
  glue_source text ,
  glue_remark character varying(128) not null ,
  add_time timestamp null default null,
  
  delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
  primary key (id)
) ;


CREATE SEQUENCE mm.seq_qrtz_trigger_registry
    INCREMENT 1
    START 19
    MINVALUE 1
    MAXVALUE 9223372036854775807
    CACHE 1;
create table mm.dj_qrtz_trigger_registry (
  id integer not null  DEFAULT nextval('mm.seq_qrtz_trigger_registry'::regclass),
  registry_group character varying(256) not null,
  registry_key character varying(256) not null,
  registry_value character varying(256) not null,
  
  delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
  primary key (id)
) ;


CREATE SEQUENCE mm.seq_qrtz_trigger_group
    INCREMENT 1
    START 19
    MINVALUE 1
    MAXVALUE 9223372036854775807
    CACHE 1;
create table mm.dj_qrtz_trigger_group (
  id integer not null  DEFAULT nextval('mm.seq_qrtz_trigger_group'::regclass),
  app_name character varying(64) not null ,
  title character varying(12) not null,
  group_order smallint not null default '0',
  address_type smallint not null default '0' ,
  address_list character varying(512) default null,
  delete_flag smallint NOT NULL DEFAULT 0,
    create_time timestamp without time zone NOT NULL,
    update_time timestamp without time zone NOT NULL,
    create_user character varying(32) COLLATE pg_catalog."default",
    update_user character varying(32) COLLATE pg_catalog."default",
  primary key (id)
) ;


insert into mm.dj_qrtz_trigger_group ( app_name, title, group_order, address_type, address_list) values ( 'xxl-job-executor-sample', '示例执行器', '1', '0', null);


commit;