mz-cloud/sql/activiti7delete.sql

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

DELETE  FROM  `zwyw_djpd_sq`;

DELETE  FROM  `zwyw_djpd_gs`;

DELETE  FROM  `zwyw_xzpd_jg`;

DELETE  FROM  `zwyw_pdzj_cq`;

DELETE  FROM  `zwyw_gsjg_fk`;

DELETE  FROM  `zwyw_djzs_pb`;

DELETE  FROM  `zwyw_bgdjpd_sq`;

DELETE  FROM  `zwyw_pdzj`;

DELETE  FROM  `zwyw_pdzj_cyjl`;

DELETE  FROM  `zwyw_djpd_jbpd`;

DELETE  FROM  `zwyw_xzpd_jg`;

DELETE  FROM  `zwyw_yljg_sxxx`;

DELETE  FROM  `zwyw_cyry_sxxx`;

DELETE  FROM  `zwyw_yljg_zdgz`;

DELETE  FROM  `zwyw_cyry_zdgz`;

DELETE  FROM  `zwyw_lhcj_nrrd`;

DELETE  FROM  `zwyw_lhcj_gzs`;

DELETE  FROM  `zwyw_lhcj_sxgs`;

DELETE  FROM  `zwyw_lhcj_sb`;

DELETE  FROM  `zwyw_yljg_lhcjmd`;

DELETE  FROM  `zwyw_cyry_lhcjmd`;

DELETE  FROM  `zwyw_lhcj_yc`;

DELETE  FROM  `zwyw_lhcj_ycyt`;