Prepare foreign keys for bigint conversion on merge_requests Stage Two

What does this MR do and why?

In this MR, we add FKs for targeted bigint columns for merge_requests table. And also add normal indexes created in previous MR.

References

Issue - Prepare bigint indexes for merge_requests stage... (!204153 - merged)

Screenshots or screen recordings

NA

How to set up and validate locally

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.