Return to Snippet

Revision: 26607
at May 4, 2010 04:14 by yisreldov


Initial Code
update flyspray_tasks, flyspray_assigned  set flyspray_tasks.due_date = UNIX_TIMESTAMP(NOW())  where flyspray_tasks.task_id = flyspray_assigned.task_id and flyspray_assigned.user_id = 2 and due_date < UNIX_TIMESTAMP(NOW()) and is_closed=0

Initial URL

                                

Initial Description

                                

Initial Title
Set old tasks to due today ...

Initial Tags

                                

Initial Language
PHP