1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
SET NAMES 'utf8'; SET CHARACTER SET utf8; set @bp=158907; set @user=6324; set @need_permission = 'read'; set @permission = ''; select s.id into @workflow from b_bp_workflow_state s where s.document_id= @bp; select permission into @permission from b_bp_workflow_permissions p where p.workflow_id=@workflow and p.object_id = concat('user_', cast(@user AS CHAR)); insert into b_bp_workflow_permissions (workflow_id, object_id, permission) select @workflow, concat('user_', cast(@user AS CHAR(4))), @need_permission from dual where @permission != @need_permission; select * from b_bp_workflow_permissions p where p.workflow_id=@workflow and p.object_id = concat('user_', cast(@user AS CHAR)) order by id; |