alter table XXL_JOB_GROUP add UPDATE_TIME datetime;

alter table XXL_JOB_INFO rename column JOB_CRON to SCHEDULE_CONF ;
comment on column XXL_JOB_INFO.SCHEDULE_CONF is '调度配置，值含义取决于调度类型';

alter table XXL_JOB_INFO drop  START_TIME;
alter table XXL_JOB_INFO drop  END_TIME;
alter table XXL_JOB_INFO drop  JOBCALENDAR;

alter table XXL_JOB_INFO add SCHEDULE_TYPE varchar(50) not null default 'NONE' ;
comment on column XXL_JOB_INFO.SCHEDULE_TYPE is '调度类型';
alter table XXL_JOB_INFO add MISFIRE_STRATEGY varchar(50) not null default 'DO_NOTHING' ;
comment on column XXL_JOB_INFO.MISFIRE_STRATEGY is '调度过期策略';

alter table XXL_JOB_LOG drop HANDLE_END_TIME;
alter table XXL_JOB_LOG drop HANDLE_DURATION;

alter table XXL_JOB_LOG_report add UPDATE_TIME datetime  ;
comment on column XXL_JOB_LOG_report.UPDATE_TIME is '调度-时间';

CREATE SEQUENCE XXL_JOB_INFO_SEQ_ID
    INCREMENT BY 1		--每次+1
    START WITH 10		--从1开始
    nomaxvalue			--不限最大值
    nominvalue			--不限最小值
    cache 20;			--设置取值缓存数为20

alter table xxl_job_info modify  id int default XXL_JOB_INFO_SEQ_ID.NEXTVAL ;
