activiti7delete.sql 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273
  1. DELETE FROM `act_hi_attachment`;
  2. DELETE FROM `act_hi_comment`;
  3. DELETE FROM `act_hi_detail`;
  4. DELETE FROM `act_hi_actinst`;
  5. DELETE FROM `act_hi_identitylink`;
  6. DELETE FROM `act_hi_procinst`;
  7. DELETE FROM `act_hi_taskinst`;
  8. DELETE FROM `act_hi_varinst`;
  9. DELETE FROM `act_ru_identitylink`;
  10. DELETE FROM `act_ru_task`;
  11. DELETE FROM `act_ru_variable`;
  12. DELETE FROM `act_ru_execution` WHERE `PARENT_ID_` IS NOT NULL AND `IS_SCOPE_`=0;
  13. DELETE FROM `act_ru_execution` WHERE `PARENT_ID_` IS NOT NULL AND `IS_SCOPE_`=1;
  14. DELETE FROM `act_ru_execution`;
  15. DELETE FROM `zwyw_djpd_sq`;
  16. DELETE FROM `zwyw_djpd_gs`;
  17. DELETE FROM `zwyw_xzpd_jg`;
  18. DELETE FROM `zwyw_pdzj_cq`;
  19. DELETE FROM `zwyw_gsjg_fk`;
  20. DELETE FROM `zwyw_djzs_pb`;
  21. DELETE FROM `zwyw_bgdjpd_sq`;
  22. DELETE FROM `zwyw_pdzj`;
  23. DELETE FROM `zwyw_pdzj_cyjl`;
  24. DELETE FROM `zwyw_djpd_jbpd`;
  25. DELETE FROM `zwyw_xq_pz`;
  26. DELETE FROM `zwyw_yljg_sxxx`;
  27. DELETE FROM `zwyw_cyry_sxxx`;
  28. DELETE FROM `zwyw_yljg_zdgz`;
  29. DELETE FROM `zwyw_cyry_zdgz`;
  30. DELETE FROM `zwyw_lhcj_nrrd`;
  31. DELETE FROM `zwyw_lhcj_gzs`;
  32. DELETE FROM `zwyw_lhcj_sxgs`;
  33. DELETE FROM `zwyw_lhcj_sb`;
  34. DELETE FROM `zwyw_yljg_lhcjmd`;
  35. DELETE FROM `zwyw_cyry_lhcjmd`;
  36. DELETE FROM `zwyw_lhcj_yc`;
  37. DELETE FROM `zwyw_lhcj_ycyt`;