acticity删除没有用流程sql

delete ACT_HI_TASKINST;
delete ACT_HI_ATTACHMENT ;
delete ACT_HI_COMMENT;
delete ACT_HI_DETAIL;
delete ACT_HI_IDENTITYLINK;
delete ACT_HI_PROCINST;
delete ACT_HI_TASKINST;
delete ACT_HI_VARINST ;
delete ACT_HI_ACTINST;

-- delete ACT_RU_TASK;
delete  ACT_RU_IDENTITYLINK;
delete ACT_RU_VARIABLE;
-- delete ACT_RU_EXECUTION;
commit;

delete ACT_HI_TASKINST where proc_inst_id_=11 ;
delete ACT_HI_ATTACHMENT where proc_inst_id_=11 ;
delete ACT_HI_COMMENT where proc_inst_id_=11 ;
delete ACT_HI_DETAIL where proc_inst_id_=11 ;
delete ACT_HI_IDENTITYLINK  where proc_inst_id_=11 ;
delete ACT_HI_PROCINST  where proc_inst_id_=11 ;
delete ACT_HI_TASKINST   where proc_inst_id_=11 ;
delete ACT_HI_VARINST   where proc_inst_id_=11 ;

-- delete ACT_RU_TASK  where proc_inst_id_=11 ;
delete  ACT_RU_IDENTITYLINK  where proc_inst_id_=11 ;
delete ACT_RU_VARIABLE  where proc_inst_id_=11 ;
-- delete ACT_RU_EXECUTION   where proc_inst_id_=11 ;
commit;