Prepare indexes for bigint ci_stages.pipeline_id
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_stages.pipeline_id_convert_to_bigint
:
index_ci_stages_on_pipeline_id
index_ci_stages_on_pipeline_id_and_id
index_ci_stages_on_pipeline_id_and_name
index_ci_stages_on_pipeline_id_and_position
Follow the instruction, and choose to add indexes concurrently or asynchronously based on the table size and the migration time.
Edited by Tianwen Chen