Add index for the new primary key on system_note_metadata
What does this MR do and why?
Related to #424114 (closed)
system_note_metadata
table's primary key column id
needs to be converted to use bigint
type.
id_convert_to_bigint
is the new column that's been backfilled and uses bigint
. We need to create a new index on the column. The index will be used to support the new primary key (this step is a part of https://docs.gitlab.com/ee/development/database/avoiding_downtime_in_migrations.html#swap-the-columns-release-n--1).
The index has been added (prepared) asynchronously for .com in !141330 (merged)
This MR synchronously adds the same index following https://docs.gitlab.com/ee/development/database/adding_database_indexes.html#add-a-migration-to-create-the-index-synchronously.
Edited by euko