The last_modified column should be a timestamp defaulted to CURRENT_TIMESTAMP. The CURRENT_TIMESTAMP should also be used ON UPDATE.

This will require 3 migration steps on dev/stage/prod where: step 1 will update the schema defaulting the column to NULL and settings the ON UPDATE CURRENT_TIMESTAMP clause step 2 will set DEFAULT CURRENT_TIMESTAMP step 3 will set all the NULL values to GREATEST(submit_timestamp, start_timestamp, end_timestamp)

This change will enable the ui to perform requests of increments, reducing the load on both the service and the client

Commit pushed to master at https://github.com/mozilla/treeherder-service https://github.com/mozilla/treeherder-service/commit/c1713cab92e353c12a0288be6b16dc2de141bebe Bug 1100983 - Add last_modified column to the job table

I'm going to use attachment 8524765 [details] to migrate dev/stage/prod

I realize we need some support form the dba to apply this change to production. If I do it by hand I think it will result in a huge table lock.

Only prod is missing.