Prepare indexes for bigint ci_sources_pipelines

Problem

This column references the ci_pipelines table and its column type is not bigint.

Process

This is part of the process to convert the column to bigint.

To be able to replicate the foreign key constraints, We will need to replicate the following indexes for the new bigint column:

  • ci_sources_pipelines.pipeline_id_convert_to_bigint
  • ci_sources_pipelines.source_pipeline_id_convert_to_bigint

Indexes:

  • index_ci_sources_pipelines_on_pipeline_id
  • index_ci_sources_pipelines_on_source_pipeline_id

Follow the instruction, and choose to add indexes concurrently or asynchronously based on the table size and the migration time.