Prepare indexes for bigint ci_pipeline_chat_data.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_pipeline_chat_data.pipeline_id_convert_to_bigint
:
index_ci_pipeline_chat_data_on_pipeline_id
Follow the instruction, and choose to add indexes concurrently or asynchronously based on the table size and the migration time.
Edited by Tianwen Chen