后台管理系统Java代码

清除oa数据库数据.txt 1.3KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. delete from OA_AFFAIR_DB;
  2. delete from OA_AFFAIR_DB_FK;
  3. delete from OA_AFFAIR_TZGG;
  4. delete from OA_AFFAIR_XF;
  5. delete from OA_COMM_RELATE_FILE;
  6. delete from OA_DOC_ABORT;
  7. delete from OA_DOC_ATTACHMENT;
  8. delete from OA_DOC_FW;
  9. delete from OA_DOC_QB;
  10. delete from OA_DOC_SW;
  11. delete from OA_PROCESS_TRACK;
  12. delete from OA_TRANSAC_YCSQ;
  13. delete from OA_TRANSAC_BX;
  14. delete from OA_TRANSAC_CCXJ;
  15. delete from OA_TRANSAC_DRIVER;
  16. delete from OA_TRANSAC_HY;
  17. delete from OA_TRANSAC_HYTZ;
  18. delete from OA_TRANSAC_HYTZ_USER;
  19. delete from OA_TRANSAC_HY_RELATION;
  20. delete from OA_TRANSAC_HY_ROOM;
  21. delete from OA_TRANSAC_HY_USER;
  22. delete from OA_TRANSAC_VEHICLE;
  23. delete from OA_TRANSAC_ZBPB;
  24. delete from OA_TRANSAC_ZBPB_LOG;
  25. delete from WFH_ACTIVITY;
  26. delete from WFH_PROCESS;
  27. delete from WFH_WORKITEM;
  28. delete from WFMH_APPLICATION;
  29. delete from WFMH_APPLICATIONITEM;
  30. delete from WFMH_APPROVAL;
  31. delete from WFMH_OPERATIONLOG;
  32. delete from WFMH_PROCESSEXTEND;
  33. delete from WFMR_APPLICATION;
  34. delete from WFMR_APPLICATIONITEM;
  35. delete from WFMR_APPROVAL;
  36. delete from WFMR_OPERATIONLOG;
  37. delete from WFMR_PROCESSEXTEND;
  38. delete from WFR_ACTIVITY;
  39. delete from WFR_PROCESS;
  40. delete from WFR_WORKITEM;
  41. delete from wfmh_approval_attachment;
  42. delete from wfmh_document;
  43. delete from wfmr_approval_attachment;
  44. delete from wfmr_document;
  45. delete from WFM_MESSAGE;