activity使用总结

activity的表带有很多外键，删起来很麻烦，这里整理按顺序删除。

1.activity清表语句

删除历史记录表（历史记录表删除没有限制）

delete from ACT_HI_PROCINST;

delete from ACT_HI_DETAIL;

delete from ACT_HI_TASKINST;

delete from ACT_HI_ACTINST;

delete from ACT_HI_ATTACHMENT;

delete from ACT_HI_COMMENT;

删除正在流转中的表

delete from ACT_RU_TASK;

delete from ACT_RU_IDENTITYLINK;

delete from ACT_RU_VARIABLE;

delete from ACT_RU_EXCUTION where parent_id_ is not null;--这里parent_id_ 作为自己表的外键

delete from ACT_RU_EXCUTION;

delete from ACT_RU_IDENTITY;

delete from ACT_RU_JOB;

删除资源表。

delete from ACT_RE_PROCDEF;

delete from ACT_RE_MODEL;

delete from ACT_GE_BYTEARRAY;

delete from ACT_RE_DEPLOYMENT;

插入一个流程只需三张表的数据，根据DEPLOYMENT_ID_找到对应资源。

1、ACT_RE_DEPLOYMENT表中一条数据。

2、ACT_GE_BYTEARRY;中对应两条记录。

3、ACT_RE_PROCDEF;中一条记录