flowable清理数据
阅读数:63 评论数:0
跳转到新版页面分类
应用软件
正文
DELETE FROM ACT_RU_IDENTITYLINK WHERE PROC_INST_ID_ IN (SELECT ID_ FROM ACT_RU_EXECUTION);
DELETE FROM ACT_RU_TIMER_JOB WHERE EXECUTION_ID_ IN (SELECT ID_ FROM ACT_RU_EXECUTION;
DELETE FROM ACT_RU_DEADLETTER_JOB WHERE PROCESS_INSTANCE_ID_ IN (SELECT ID_ FROM ACT_RU_EXECUTION);
DELETE FROM ACT_HI_PROCINST;
DELETE FROM ACT_HI_TASKINST;
DELETE FROM ACT_HI_ACTINST;
DELETE FROM ACT_HI_VARINST;
DELETE FROM ACT_RU_EXECUTION;
DELETE FROM ACT_RU_TASK;
DELETE FROM ACT_RU_VARIABLE;