alter table XXL_JOB_GROUP add UPDATE_TIME timestamp;

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 column START_TIME;
alter table XXL_JOB_INFO drop column END_TIME;
alter table XXL_JOB_INFO drop column JOBCALENDAR;

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

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

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

CREATE SEQUENCE XXL_JOB_INFO_SEQ_ID
    START WITH 2
    INCREMENT BY 1
    NOMAXVALUE;

alter table xxl_job_info modify  id int default XXL_JOB_INFO_SEQ_ID.NEXTVAL ;
