activiti.h2.drop.history.sql 1.2 KB

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