To be able to effectively answer the "first occurrence" query in the provenance db, we need to add an *indexed* column with the date of the revision in the content_in_revision (that is, turn it into (content_id, revision_date, revision_id, location_id)).

We should consider whether we need to do that for directory_in_revision as well.