Update db migrations to add jobs indexes and make status non-nullable

Adding indexes to jobs timeout and status columns.
Make status non-nullable with a default of 'QUEUED'.
Fixed / expanded some tests.
How about dropping the index on hard_timeout as well?