工作流引擎表处理

-- 1处理act_ge_bytearray
SELECT * FROM `act_ge_bytearray`
delete from act_ge_bytearray

-- 2处理act_hi_actinst
SELECT * FROM `act_hi_actinst`
delete from act_hi_actinst

-- 3处理act_hi_identitylink
select * from act_hi_identitylink
delete from act_hi_identitylink

-- 4处理act_hi_procinst
SELECT * FROM `act_hi_procinst`
DELETE from act_hi_procinst

-- 5 处理act_hi_taskinst
SELECT * from act_hi_taskinst
delete from act_hi_taskinst

-- 6处理act_hi_varinst
SELECT * FROM `act_hi_varinst`
delete from  act_hi_varinst

-- 7处理act_re_deployment
select *  from  act_re_deployment
delete from  act_re_deployment


-- 8处理act_re_procdef
SELECT * FROM `act_re_procdef`
delete from act_re_procdef

-- 9处理act_ru_actinst
SELECT * FROM `act_ru_actinst`
delete from act_ru_actinst

-- 10处理act_ru_execution
select * from act_ru_execution
delete from act_ru_execution

-- 11处理act_ru_identitylink
SELECT * FROM `act_ru_identitylink`
delete from act_ru_identitylink


-- 12 处理act_ru_task
select *  from act_ru_task
delete from act_ru_task

-- 13 处理act_ru_variable
SELECT * FROM `act_ru_variable`
delete from  act_ru_variable



SELECT * FROM `wf_flow_entry`
delete from wf_flow_entry

select *  from wf_flow_entry_publish
delete from wf_flow_entry_publish


SELECT * FROM `wf_flow_entry_publish_variable`
delete from wf_flow_entry_publish_variable

SELECT * FROM `wf_flow_entry_variable`
delete from wf_flow_entry_variable

SELECT * FROM `wf_flow_message`
delete from wf_flow_message

SELECT * FROM `wf_flow_message_candicate_identity`
delete from wf_flow_message_candicate_identity

SELECT * FROM `wf_flow_message_identity_operation`
delete from wf_flow_message_identity_operation

SELECT * FROM `wf_flow_task_comment`
delete from wf_flow_task_comment

SELECT * FROM `wf_flow_task_ext`
delete from wf_flow_task_ext

SELECT * FROM `wf_flow_work_order`
delete from wf_flow_work_order

SELECT * FROM `zz_test_flow_contract`
delete  from zz_test_flow_contract

SELECT * FROM `zz_test_flow_leave`
delete from zz_test_flow_leave

SELECT * FROM `zz_test_flow_product`
delete from zz_test_flow_product

SELECT * FROM `zz_test_flow_submit`
delete from zz_test_flow_submit

SELECT * FROM `zz_test_flow_translate`
delete from zz_test_flow_translate

 

posted @ 2023-01-06 12:34  DarJeely  阅读(84)  评论(0编辑  收藏  举报