Add missing index on code monitor worker tables

Created by: eseliger

All worker tables should have an index on state. Spotted in query insights on our demo instance, where these queries were among the dominating ones.

Test plan

Just a new index, test suite covers migrations.