--清空业务数据，不含配置数据
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;