Granted... UPDATE /*_*/code_rev SET cr_status = 'old' WHERE cr_status = 'new' AND cr_timestamp < NOW() - Some Period AND cr_repo_id = blah would do the job

But might aswell do it semi-properly, eh?

I'm presuming we don't need the status change audit trail?

Version: unspecified
Severity: enhancement