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`;