Comment 4 for bug 1672824

Something along the lines of this?

update action_trigger.event set complete_time = update_time where state = 'complete' and complete_time is null;

Agreed it would be good to have and should be a separate script.