Added unique index to Jobs.jHandle for uniqueness constraint and query where clause
Added unique index to Jobs.jHandle for uniqueness constraint and query where clause

Added index to Jobs.pkgID for potential join to packages table

Added index to Jobs.isSchedule (isScheduled, jDateLastRun, jID) for query where + order by

Added index to Jobs.jDateLastRun (jDateLastRun, jID) for full table scan order by


Former-commit-id: a809ea2861bd06502fec638f0062126e2264f17b
biplobice/concrete5,KorvinSzanto/concrete5,rikzuiderlicht/concrete5,biplobice/concrete5,mainio/concrete5,haeflimi/concrete5,triplei/concrete5-8,haeflimi/concrete5,hissy/concrete5,mainio/concrete5,mlocati/concrete5,hissy/concrete5,deek87/concrete5,a3020/concrete5,jaromirdalecky/concrete5,olsgreen/concrete5,concrete5/concrete5,acliss19xx/concrete5,hissy/concrete5,jaromirdalecky/concrete5,haeflimi/concrete5,concrete5/concrete5,jaromirdalecky/concrete5,KorvinSzanto/concrete5,rikzuiderlicht/concrete5,biplobice/concrete5,concrete5/concrete5,jaromirdalecky/concrete5,olsgreen/concrete5,acliss19xx/concrete5,concrete5/concrete5,hissy/concrete5,mlocati/concrete5,MrKarlDilkington/concrete5,deek87/concrete5,biplobice/concrete5,triplei/concrete5-8,triplei/concrete5-8,mlocati/concrete5,mlocati/concrete5,deek87/concrete5,mainio/concrete5,KorvinSzanto/concrete5,deek87/concrete5,acliss19xx/concrete5,rikzuiderlicht/concrete5,a3020/concrete5,haeflimi/concrete5,olsgreen/concrete5,MrKarlDilkington/concrete5,MrKarlDilkington/concrete5