activiti.mysql.drop.history.sql 1.2 KB

12345678910111213141516171819202122232425
  1. drop index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST;
  2. drop index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST;
  3. drop index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST;
  4. drop index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST;
  5. drop index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL;
  6. drop index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL;
  7. drop index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL;
  8. drop index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL;
  9. drop index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL;
  10. drop index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST;
  11. drop index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST;
  12. drop index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST;
  13. drop index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK;
  14. drop index ACT_IDX_HI_IDENT_LNK_TASK on ACT_HI_IDENTITYLINK;
  15. drop index ACT_IDX_HI_IDENT_LNK_PROCINST on ACT_HI_IDENTITYLINK;
  16. drop index ACT_IDX_HI_TASK_INST_PROCINST on ACT_HI_TASKINST;
  17. drop table if exists ACT_HI_PROCINST;
  18. drop table if exists ACT_HI_ACTINST;
  19. drop table if exists ACT_HI_VARINST;
  20. drop table if exists ACT_HI_TASKINST;
  21. drop table if exists ACT_HI_DETAIL;
  22. drop table if exists ACT_HI_COMMENT;
  23. drop table if exists ACT_HI_ATTACHMENT;
  24. drop table if exists ACT_HI_IDENTITYLINK;