Simplify tests code with a little black magic

Also, force utf8 on globally.
Fix clear fixtures script
Add missing fields for job

There are still some thinking that needs to be done regarding the
fields, though. Should we add more columns? Which? etc...
Update Job resultset with new fields
Refactor job verifier and template

Now we can use the same verifier and the same template for both updating
and creating a new record.
Fix identation
Remove redundant pragmas
Make job update and create work