add cached `accepted` column to ratifications
add hooks for updating cached accepted column
translation bug caught by test