Convert primary keys to bigint for ci_pipeline_variables

It looks like it's more complex/impossible without downtime to change a primary key after the table is partitioned since we can't use our current workflow on partitioned tables:

PG::FeatureNotSupported: ERROR:  ALTER TABLE / ADD CONSTRAINT USING INDEX is not supported on partitioned tables

The primary key for ci_pipeline_variables is still using integer type and we need to have it converted to bigint before starting to partition that table.

This will take 4 releases(milestones) to be completed.

Process

Following the process outlined here, we must:

Step MR Workflow Status Milestone
Initialize the conversion !118878 (merged) workflowcomplete %16.0
Swap the columns - Async Index !120946 (merged)
- Sync Index !120950 (merged)
- Swap the columns !120823 (merged)
workflowcomplete
workflowcomplete
workflowcomplete
%16.1
Remove the trigger and old integer columns !124026 (merged) workflowcomplete %16.2
Remove ignore rules !125187 (merged) workflowcomplete %16.3
Edited by Tianwen Chen