Prepare foreign key constraints for bigint p_ci_builds
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 swap the columns, We will need to replicate the following foreign key constraints for the new bigint columns:
p_ci_builds.auto_canceled_by_id_convert_to_bigint
p_ci_builds.commit_id_convert_to_bigint
p_ci_builds.erased_by_id_convert_to_bigint
p_ci_builds.project_id_convert_to_bigint
p_ci_builds.runner_id_convert_to_bigint
p_ci_builds.trigger_request_id_convert_to_bigint
p_ci_builds.upstream_pipeline_id_convert_to_bigint
p_ci_builds.user_id_convert_to_bigint
Foreign keys:
fk_87f4cefcda
fk_a2141b1522
fk_d3130c9a7f
Follow the instruction, and choose a strategy to add the foreign key constraints based on the table size and the migration time.
Edited by Tianwen Chen