怎样安全地删除与工作流有关的角色与操作

xiangzhao

其sql语句示例如下：
删除角色
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='JXCK'  and t1.processrev=1)
  and not exists(select 1 from wfassignment t2 where t2.assigncode is null and t2.wfid=0 and t2.processname<>'JXCK' and t2.roleid=t.maxrole) ;

删除操作
delete  from action where action in (select t.action from wfaction t where t.processname='JXCK' and t.processrev=1) AND
  NOT exists(select 1 from wfaction t1 where t1.processname<>'JXCK' and t1.action=action.action)

jskhfw

。。。。。。。。。。。。。。。。。。。。