--清空业务数据，不含配置数据
|
delete from mdm_nc_node;
|
delete from mdm_dnc_back_file;
|
delete from mdm_program_seq;
|
delete from mdm_flow_program_file;
|
delete from mdm_task_dispatch;
|
delete from mdm_approve_record;
|
delete from mdm_approve_record;
|
delete from mdm_nc_program_approved;
|
|
--清空flowable流程实例数据
|
|
-- 清空运行时数据
|
DELETE FROM ACT_RU_TASK;
|
DELETE FROM ACT_RU_IDENTITYLINK;
|
DELETE FROM ACT_RU_VARIABLE;
|
DELETE FROM ACT_RU_EXECUTION;
|
DELETE FROM ACT_RU_EVENT_SUBSCR;
|
DELETE FROM ACT_RU_JOB;
|
DELETE FROM ACT_RU_DEADLETTER_JOB;
|
DELETE FROM ACT_RU_SUSPENDED_JOB;
|
DELETE FROM ACT_RU_TIMER_JOB;
|
DELETE FROM ACT_RU_HISTORY_JOB;
|
|
-- 清空历史数据
|
DELETE FROM ACT_HI_TASKINST;
|
DELETE FROM ACT_HI_TSK_LOG;
|
DELETE FROM ACT_HI_PROCINST;
|
DELETE FROM ACT_HI_IDENTITYLINK;
|
DELETE FROM ACT_HI_DETAIL;
|
DELETE FROM ACT_HI_VARINST;
|
DELETE FROM ACT_HI_ACTINST;
|
DELETE FROM ACT_HI_COMMENT;
|
DELETE FROM ACT_HI_ATTACHMENT;
|
DELETE FROM ACT_HI_INCIDENT;
|
DELETE FROM ACT_HI_JOB_LOG;
|
DELETE FROM ACT_HI_BATCH;
|
|
-- 清空身份数据
|
DELETE FROM ACT_ID_USER;
|
DELETE FROM ACT_ID_INFO;
|
DELETE FROM ACT_ID_GROUP;
|
DELETE FROM ACT_ID_MEMBERSHIP;
|
DELETE FROM ACT_ID_PRIV;
|
DELETE FROM ACT_ID_PRIV_MAPPING;
|
|
-- 清空部署数据
|
-- DELETE FROM ACT_RE_DEPLOYMENT;
|
-- DELETE FROM ACT_RE_PROCDEF;
|
-- DELETE FROM ACT_RE_MODEL;
|
-- DELETE FROM ACT_RE_DECISION_DEF;
|
-- DELETE FROM ACT_RE_CASE_DEF;
|
-- DELETE FROM ACT_RE_DECISION_REQ_DEF;
|
|
-- 清空其他表
|
DELETE FROM ACT_EVT_LOG;
|
DELETE FROM ACT_PROCDEF_INFO;
|
DELETE FROM ACT_CMMN_DATABASECHANGELOG;
|
DELETE FROM ACT_DMN_DATABASECHANGELOG;
|
