删除一个工作流

来源：互联网发布：java 网店系统轻量编辑：程序博客网时间：2024/06/05 07:20

--删除一个工作流
delete from wfprocess t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfsubprocess  t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfaction  t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfassignment  t where t.assigncode is null and t.wfid=0 and t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfcondition t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfinput t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfinteraction t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfnode t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfnotification t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfrevision t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfstart t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfstop t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wftask t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from wfwaitlist t where t.processname=\'WOTRACKING\' and t.processrev=\'18\';
delete from maxrole t where t.maxrole in(select t1.roleid from wfassignment t1 where t1.assigncode is null and t1.wfid=0 and t1.processname=\'WOTRACKING\' and t1.processrev=\'18\');
delete from action where action in(select t.action from wfaction t where t.processname=\'WOTRACKING\' and t.processrev=\'18\');