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
-
todos.note_id
-
system_note_metadata.note_id
-
epic_user_mentions.note_id
-
suggestions.note_id
-
issue_user_mentions.note_id
-
note_diff_files.diff_note_id
-
snippet_user_mentions.note_id
-
design_user_mentions.note_id
-
vulnerability_user_mentions.note_id
-
commit_user_mentions.note_id
-
merge_request_user_mentions.note_id
-
timelogs.note_id
-
award_emoji.awardable_id
-
events.target_id
Edited by Alex Ives