Add issues.correct_work_item_type_id column

What does this MR do and why?

New column will be backfilled with the correct value in a background migration. Part of a larger effort to make work_item_types.id values sequential 1 through 9 [Cells 1.0] Default Work Item Types: Ensure wor... (&15272 - closed)

Migration output

UP

main: == [advisory_lock_connection] object_id: 128960, pg_backend_pid: 18871
main: == 20240924213521 AddCorrectWorkItemTypeIdToIssues: migrating =================
main: -- add_column(:issues, :correct_work_item_type_id, :bigint, {:null=>false, :default=>0})
main:    -> 0.0086s
main: == 20240924213521 AddCorrectWorkItemTypeIdToIssues: migrated (0.0119s) ========

main: == [advisory_lock_connection] object_id: 128960, pg_backend_pid: 18871
ci: == [advisory_lock_connection] object_id: 129280, pg_backend_pid: 18873
ci: == 20240924213521 AddCorrectWorkItemTypeIdToIssues: migrating =================
ci: -- add_column(:issues, :correct_work_item_type_id, :bigint, {:null=>false, :default=>0})
ci:    -> 0.0107s
ci: == 20240924213521 AddCorrectWorkItemTypeIdToIssues: migrated (0.0181s) ========

ci: == [advisory_lock_connection] object_id: 129280, pg_backend_pid: 18873

DOWN

main: == [advisory_lock_connection] object_id: 128520, pg_backend_pid: 22577
main: == 20240924213521 AddCorrectWorkItemTypeIdToIssues: reverting =================
main: -- remove_column(:issues, :correct_work_item_type_id, :bigint, {:null=>false, :default=>0})
main:    -> 0.0021s
main: == 20240924213521 AddCorrectWorkItemTypeIdToIssues: reverted (0.0070s) ========

main: == [advisory_lock_connection] object_id: 128520, pg_backend_pid: 22577
ci: == [advisory_lock_connection] object_id: 129340, pg_backend_pid: 22843
ci: == 20240924213521 AddCorrectWorkItemTypeIdToIssues: reverting =================
ci: -- remove_column(:issues, :correct_work_item_type_id, :bigint, {:null=>false, :default=>0})
ci:    -> 0.0013s
ci: == 20240924213521 AddCorrectWorkItemTypeIdToIssues: reverted (0.0088s) ========

ci: == [advisory_lock_connection] object_id: 129340, pg_backend_pid: 22843

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #493973 (closed)