审批流 数据表清空

-- 清空运行中测试数据

DELETE FROM `act_ru_variable`

DELETE FROM `act_ru_identitylink`

DELETE FROM `act_ru_task`

-- 这个表清空报错 需要层层查询，删除最外层的记录，一层层往里删除

DELETE FROM `act_ru_execution`

SELECT t1.* FROM act_ru_execution t1-- 子

  LEFT JOIN (

SELECT t1.* FROM act_ru_execution t1-- 子

                LEFT JOIN (

SELECT t1.* FROM act_ru_execution t1-- 子

                              LEFT JOIN (

SELECT t1.* FROM act_ru_execution t1-- 子

                                            LEFT JOIN act_ru_execution t2ON t1.PARENT_ID_=t2.id_ -- 父

                                          WHERE  t2.id_ IS NOT NULL

                                        ) t2ON t1.PARENT_ID_=t2.id_ -- 父

                            WHERE  t2.id_ IS NOT NULL

                          ) t2ON t1.PARENT_ID_=t2.id_ -- 父

              WHERE  t2.id_ IS NOT NULL

            ) t2ON t1.PARENT_ID_=t2.id_ -- 父

WHERE  t2.id_ IS NOT NULL

-- 清空历史流程测试数据

DELETE FROM `act_hi_varinst`

DELETE FROM `act_hi_taskinst`

DELETE FROM `act_hi_identitylink`

DELETE FROM `act_hi_comment`

DELETE FROM `act_hi_procinst`

-- 清空对象型流程变量

DELETE FROM `act_ge_bytearray`WHERE deployment_id_ IS NULL AND name_ NOT IN('source','source-extra')