--  取消外键约束
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` ;  -- 提交备注