alter table SYS_BATCHTASK_DEF_FILTER
drop primary key (FILTER_ID, DEF_ID);
drop table if exists SYS_BATCHTASK_DEF_FILTER;
create table SYS_BATCHTASK_DEF_FILTER
(
DEF_ID varchar(60) not null,
FILTER_ID varchar(60) not null,
FILTER_NAME varchar(255),
RUN_ORDER varchar(2) default '50',
RUN_TYPE varchar(2), /*執(zhí)行類型:runCreated,runCorrect,runResume,runPause*/
RUN_STEP varchar(2), /*執(zhí)行階段:main_block,part_exec,main_finish*/
BEFORE_AFTER varchar(2) default '1', /*執(zhí)行時機:前1,后2*/
UPDATE_FLAG varchar(2) default '1', /*完成更新:更新1,不更新0*/
NOTE varchar(512)
);
alter table SYS_BATCHTASK_DEF_FILTER
add primary key (DEF_ID, FILTER_ID);