— remove doc task
\nupdate DocChangeSetting set autoSend=0,autoReceive =0;
\n–remove all webservices
\ntruncate table wsregiste;
\n–remove all tasks or update SCHEDULESETTING set cronexpr =’0 0 0 1 1 ?’;
\ndelete from SCHEDULESETTING;
\n–change pwd
\nupdate hrmresource set password=’C4CA4238A0B923820DCC509A6F75849B’; –1
\nupdate HrmResourceManager set password=’C4CA4238A0B923820DCC509A6F75849B’ where loginid=’sysadmin’;<\/p>\n
–1
\n–change page temp
\nupdate SystemLoginTemplate set isCurrent =0;
\nupdate SystemLoginTemplate set isCurrent =1 where loginTemplateId=2;
\n–del test workflow
\nupdate workflow_requestbase set deleted =0 where requestid in(
\nselect requestid from workflow_requestbase t1,workflow_base t2
\nwhere t1.workflowid=t2.id and (t1.deleted=1 and (t2.isvalid=’2′ or t2.isvalid=’0′)));
\n–remove ofs
\ntruncate table ofs_todo_data;
\ntruncate table ofs_log;
\n–set test work flow,0:invalid,1:valide,2:test
\nupdate workflow_base set isvalid = ‘0’;
\n–\u6253\u5f00\u67d0\u4e2a\u6d41\u7a0b
\nupdate workflow_base set isvalid = ‘1’ where workflowname like ‘%EEE%’;
\n–delete workflow auto create
\ntruncate table outerdatawfset;
\n–\u6e05\u9664\u6d41\u7a0b\u6570\u636e
\n–remove all pending workflow
\ntruncate table workflow_currentoperator;
\n–remove all workflow instances
\ntruncate table workflow_requestbase;<\/p>\n
–\u6b63\u5e38\u7ef4\u62a4SQL
\n–\u5220\u9664\u65e0\u6548\u7684\u6d41\u7a0b\u4eba\u5458\u914d\u7f6e<\/p>\n
–\u5220\u9664\u5df2\u7ecf\u5931\u6548\u7684\u4ee3\u7406
\nupdate Workflow_Agent set enddate =’2019-06-01′ where enddate >=’2019-06-01′; –\u4e34\u65f6\u4f7f\u7528
\ndelete from Workflow_Agent where beagenterid not in(select id from hrmresource where status =1);
\ndelete from Workflow_Agent where enddate < convert(char(10),getdate(),120);
\n–delete from Workflow_Agent where begindate =’1900-01-01′ and enddate =’2099-12-31′;
\ndelete from workflow_agentConditionSet where agentid not in (select agentid from Workflow_Agent);<\/p>\n
–\u53bb\u6389\u9a8c\u8bc1\u7801\uff0c\u9700\u91cd\u542f
\nupdate HrmSettings set needvalidate = 0;<\/p>\n
–delete pending flow
\nupdate workflow_requestbase set deleted =1 where requestid in(
\nselect DISTINCT a.requestid from workflow_requestbase a,workflow_currentoperator b,workflow_base c,workflow_type d
\nwhere a.requestid = b.requestid and a.workflowid = c.id and c.workflowtype = d.id
\nand b.userid = 1 and a.deleted =0 and d.id = 1 –workflowtype
\n);<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
— remove doc task update DocChangeSetting set autoSend=0,autoReceive =0; –remove all webservices truncate table wsregiste; –remove all tasks or update SCHEDULESETTING set cronexpr =’0 0 0 1 1 ?’; delete from SCHEDULESETTING; –change pwd update hrmresource set password=’C4CA4238A0B923820DCC509A6F75849B’; –1 update HrmResourceManager set password=’C4CA4238A0B923820DCC509A6F75849B’ where loginid=’sysadmin’; –1 –change page temp update SystemLoginTemplate set isCurrent =0; update […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-252","post","type-post","status-publish","format-standard","hentry","category-ecology"],"_links":{"self":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=252"}],"version-history":[{"count":0,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/252\/revisions"}],"wp:attachment":[{"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=252"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}