activiti 删除某个流程的sql

DELETE FROM ACT_HI_ATTACHMENT WHERE PROC_INST_ID_= '152512';
DELETE FROM ACT_HI_COMMENT WHERE PROC_INST_ID_='152512';
DELETE FROM ACT_HI_ACTINST WHERE PROC_INST_ID_='152512';
DELETE FROM ACT_HI_DETAIL WHERE PROC_INST_ID_='152512';

DELETE FROM ACT_HI_IDENTITYLINK WHERE TASK_ID_ IN(
SELECT ID_ FROM ACT_RU_TASK WHERE PROC_INST_ID_='152512'
UNION ALL
SELECT ID_ FROM ACT_HI_TASKINST WHERE PROC_INST_ID_='152512'
)OR PROC_INST_ID_ ='152512';
DELETE FROM ACT_HI_TASKINST WHERE PROC_INST_ID_='152512';
DELETE FROM ACT_HI_PROCINST WHERE PROC_INST_ID_='152512';
DELETE FROM ACT_HI_VARINST WHERE PROC_INST_ID_='152512';
DELETE FROM ACT_RU_EVENT_SUBSCR WHERE PROC_INST_ID_='152512';
DELETE FROM ACT_RU_IDENTITYLINK WHERE TASK_ID_ IN(SELECT ID_ FROM ACT_RU_TASK WHERE PROC_INST_ID_='152512')OR PROC_INST_ID_='152512';
DELETE FROM ACT_RU_VARIABLE WHERE PROC_INST_ID_='152512';

DELETE FROM ACT_RU_TASK WHERE PROC_INST_ID_='152512';
DELETE FROM ACT_RU_EXECUTION WHERE PROC_INST_ID_='152512';