Swap integer and bigint columns for notes and dependent tables for GitLab.com

This is the next step after Initialize the migration of notes.id and depend... (#389306 - closed).

Following the process outlined here, we want to swap the columns for GitLab.com as soon as we can. This migrations will be done for GitLab.com only, so that we enforce a required stop on the upgrade path for self-manages instances. As we are going to have required stop (15.11) anyway, we'll duplicate the migrations in %16.0 for self-managed only.

The columns we need to migrate are

• notes.id
  • Prepare indexes for converting notes.id to bigint (!119913 - merged)
  • Cleanup artefacts from notes.id bigint migration (!120206 - merged)
  • Prepare FKs for converting notes.id to bigint (!120816 - merged)
  • Swap notes.id to bigint for GitLab.com (!119705 - merged)
• todos.note_id
  • Prepare todos for bigint migration (!117963 - merged)
  • Swap todos.note_id to bigint (!118123 - merged)
• system_note_metadata.note_id
  • Prepare system_note_metadata for bigint migration (!117485 - merged)
  • Swap system_note_metadata.note_id to bigint (!117343 - merged)
• epic_user_mentions.note_id
  • Swap epic_user_mentions.note_id to bigint (!116627 - merged)
• suggestions.note_id
  • Swap suggestions.note_id to bigint (!116622 - merged)
• issue_user_mentions.note_id
  • Prepare issue_user_mentions for bigint migration (!116614 - merged)
  • Swap issue_user_mentions.note_id to bigint (!116509 - merged)
  • Change migration order for issue_user_mentions ... (!117476 - merged)
• note_diff_files.diff_note_id
  • Prepare note_diff_files for bigint migration (!115614 - merged)
  • Swap note_diff_files.diff_note_id to bigint (!115460 - merged)
• snippet_user_mentions.note_id
  • Swap snippet_user_mentions.note_id to bigint (!115456 - merged)
• design_user_mentions.note_id
  • Swap design_user_mentions.note_id to bigint (!115285 - merged)
• vulnerability_user_mentions.note_id
  • Swap vulnerability_user_mentions.note_id to bigint (!115280 - merged)
• commit_user_mentions.note_id
  • Swap commit_user_mentions.note_id to bigint (!115277 - merged)
• merge_request_user_mentions.note_id
  • Prepare merge_request_user_mentions for bigint ... (!114043 - merged)
  • Finalize conversion of merge_request_user_menti... (!113928 - merged)
• timelogs.note_id
  • Finalize conversion of timelogs.note_id to bigint (!113052 - merged)
• award_emoji.awardable_id
  • Swap award_emoji.awardable_id to bigint (!118125 - merged)
• events.target_id
  • Prepare index for converting events.target_id t... (!124943 - merged)
  • Swap events.target_id to bigint (!126786 - merged)