清空测试环境的 activiti 数据的 SQL
· 阅读需 1 分钟
-- 禁用外键检查
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE ACT_EVT_LOG;
TRUNCATE TABLE ACT_GE_BYTEARRAY;
TRUNCATE TABLE ACT_HI_DETAIL;
TRUNCATE TABLE ACT_HI_COMMENT;
TRUNCATE TABLE ACT_HI_IDENTITYLINK;
TRUNCATE TABLE ACT_HI_PROCINST;
TRUNCATE TABLE ACT_HI_VARINST;
TRUNCATE TABLE ACT_HI_TASKINST;
TRUNCATE TABLE ACT_HI_ACTINST;
TRUNCATE TABLE ACT_RU_IDENTITYLINK;
TRUNCATE TABLE ACT_RU_TASK;
TRUNCATE TABLE ACT_RU_VARIABLE;
TRUNCATE TABLE ACT_RU_EXECUTION;
TRUNCATE TABLE ACT_HI_ATTACHMENT;
TRUNCATE TABLE ACT_RU_EVENT_SUBSCR;
TRUNCATE TABLE ACT_RU_JOB;
TRUNCATE TABLE ACT_PROCDEF_INFO;
TRUNCATE TABLE ACT_RE_DEPLOYMENT;
TRUNCATE TABLE ACT_RE_MODEL;
TRUNCATE TABLE ACT_RE_PROCDEF;
SET FOREIGN_KEY_CHECKS = 1;