activiti 删除表清空表流程

最新推荐文章于 2023-07-14 11:59:48 发布

weixin_34391445

最新推荐文章于 2023-07-14 11:59:48 发布

阅读量4.8k

点赞数 2

文章标签：数据库 java python

原文链接：https://my.oschina.net/u/1760858/blog/847743

版权

2019独角兽企业重金招聘Python工程师标准>>>

-- oracle 清理数据库

DELETE FROM ACT_RU_IDENTITYLINK ; -- 删除运行状态的
DELETE FROM ACT_RU_TASK ; -- 删除任务
DELETE FROM ACT_RU_VARIABLE; -- 删除运行遍历

DELETE FROM ACT_RU_EXECUTION ; -- 删除执行的数据

-- 删除历史数据
DELETE FROM ACT_HI_VARINST ; -- 历史变量
DELETE FROM ACT_HI_TASKINST ; -- 历史任务实例
DELETE FROM ACT_HI_PROCINST ; -- 历史执行流程实例 ;
DELETE FROM ACT_HI_IDENTITYLINK; -- 历史身份链接
DELETE FROM ACT_HI_DETAIL ; -- 详情
DELETE FROM ACT_HI_ACTINST ; -- 流程实例
DELETE FROM ACT_HI_COMMENT ; -- 提交备注

-- 删除表数据表

DELETE FROM FLOW_EVECTION;

mysql 清理数据库

-- 取消外键约束
SET FOREIGN_KEY_CHECKS=0;

DELETE FROM ACT_RU_IDENTITYLINK ; -- 删除运行状态的
DELETE FROM ACT_RU_TASK ; -- 删除任务
DELETE FROM ACT_RU_VARIABLE; -- 删除运行遍历

DELETE FROM ACT_RU_EXECUTION ; -- 删除执行的数据

-- 删除历史数据
DELETE FROM ACT_HI_VARINST ; -- 历史变量
DELETE FROM ACT_HI_TASKINST ; -- 历史任务实例
DELETE FROM ACT_HI_PROCINST ; -- 历史执行流程实例 ;
DELETE FROM ACT_HI_IDENTITYLINK; -- 历史身份链接
DELETE FROM ACT_HI_DETAIL ; -- 详情
DELETE FROM ACT_HI_ACTINST ; -- 流程实例
DELETE FROM ACT_HI_COMMENT ; -- 提交备注
-- 启用外键约束
SET FOREIGN_KEY_CHECKS=1;

-- 删除历史数据
DELETE FROM `act_hi_varinst` ; -- 历史变量
DELETE FROM `act_hi_taskinst` ; -- 历史任务实例
DELETE FROM `act_hi_procinst` ; -- 历史执行流程实例 ;
DELETE FROM `act_hi_identitylink`; -- 历史身份链接
DELETE FROM `act_hi_detail` ; -- 详情
DELETE FROM `act_hi_actinst` ; -- 流程实例
DELETE FROM `act_hi_comment` ; -- 提交备注

----说明2
DELETE FROM `act_re_procdef` ; -- 流程定义,详细信息
DELETE FROM `act_ge_bytearray`; -- 删除二进制表
DELETE FROM `act_re_deployment`; ---流程部署简单说明!

-- 查看任务节点
http://127.0.0.1:8080/jeesite-testActiviti/a/act/task/histoicFlow?procInsId=48567ba18a3749ca82d0f479a2feea44&startAct=&endAct=&t=1486628127483

转载于:https://my.oschina.net/u/1760858/blog/847743