1 UPDATE {$NAMESPACE}_herald.herald_action a
2 JOIN {$NAMESPACE}_herald.herald_rule r
4 SET a.action = 'projects.add'
5 WHERE a.action = 'addprojects';
7 UPDATE {$NAMESPACE}_herald.herald_action a
8 JOIN {$NAMESPACE}_herald.herald_rule r
10 SET a.action = 'projects.remove'
11 WHERE a.action = 'removeprojects';