删除工作流测试数据

最新推荐文章于 2024-07-30 13:01:41 发布

李氏程序员

最新推荐文章于 2024-07-30 13:01:41 发布

阅读量1.1k

点赞数 1

分类专栏： activiti 文章标签： activiti清楚测试数据

本文链接：https://blog.csdn.net/weixin_38441551/article/details/84797800

版权

activiti 专栏收录该内容

39 篇文章 0 订阅

订阅专栏

SET FOREIGN_KEY_CHECKS = 0;
DELETE FROM act_hi_taskinst; 		
DELETE FROM act_hi_identitylink;
DELETE FROM act_hi_procinst;
DELETE FROM act_hi_varinst;
DELETE FROM act_ru_identitylink;
DELETE FROM act_ru_variable;
DELETE FROM act_ru_task; 
DELETE from act_hi_actinst;
DELETE FROM act_ru_execution;
SET FOREIGN_KEY_CHECKS = 1;



DELETE FROM act_re_procdef

清空部署流程
DELETE FROM act_re_procdef
DELETE FROM act_re_deployment


清空流程在途数据 				
DELETE FROM act_ru_task 
DELETE FROM act_ru_execution
DELETE FROM act_ru_identitylink
DELETE FROM act_ru_variable

清空流程历史数据 
DELETE FROM act_hi_identitylink
DELETE FROM act_hi_taskinst
DELETE FROM act_hi_procinst
DELETE FROM act_hi_varinst
DELETE FROM act_hi_comment
DELETE FROM act_hi_actinst

清空流程模型
DELETE FROM act_re_model
DELETE FROM act_ge_bytearray

清空全部挂接流程
DELETE FROM pex_wf_setting

清空单位级挂接流程
DELETE FROM pex_wf_setting WHERE agy_code !='*'