`tmp_index_vulnerability_occurrences_uuid_cast` synchronous database index(es) addition

Summary

This issue is to add a migration(s) to create the tmp_index_vulnerability_occurrences_uuid_cast database index(es) synchronously after it has been created/destroyed on GitLab.com.

The asynchronous index(es) was introduced in !131620 (merged).