activiti 清库脚本

activiti 清库脚本

DELETE  FROM  `act_hi_attachment`;

DELETE  FROM  `act_hi_comment`;

DELETE  FROM  `act_hi_detail`;

DELETE  FROM  `act_hi_actinst`;

DELETE  FROM  `act_hi_identitylink`;

DELETE  FROM  `act_hi_procinst`;

DELETE  FROM  `act_hi_taskinst`;

DELETE  FROM  `act_hi_varinst`;

DELETE  FROM  `act_ru_identitylink`;

DELETE  FROM  `act_ru_task`;

DELETE  FROM  `act_ru_variable`;

DELETE  FROM  `act_ru_execution` WHERE `PARENT_ID_` IS NOT NULL AND `IS_SCOPE_`=0;

DELETE  FROM  `act_ru_execution` WHERE `PARENT_ID_` IS NOT NULL AND `IS_SCOPE_`=1;

DELETE  FROM  `act_ru_execution`;