Add template fields migration for compliance frameworks

What does this MR do and why?

Add template fields migration for compliance frameworks

Extract database changes from !224646 (closed).

Adds columns to compliance_management_frameworks table to support compliance framework templates functionality.

Changelog: other

References

#591059

Screenshots or screen recordings

Before After

Migration Logs

rails db:migrate
main: == [advisory_lock_connection] object_id: 136220, pg_backend_pid: 28115
main: == 20260219140405 AddTemplateFieldsToComplianceManagementFrameworks: migrating
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- add_column(:compliance_management_frameworks, :template_id, :text, {:if_not_exists=>true})
main:    -> 0.0368s
main: -- add_column(:compliance_management_frameworks, :template_version, :integer, {:if_not_exists=>true})
main:    -> 0.0008s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: == 20260219140405 AddTemplateFieldsToComplianceManagementFrameworks: migrated (0.0650s)

main: == [advisory_lock_connection] object_id: 136220, pg_backend_pid: 28115
ci: == [advisory_lock_connection] object_id: 136220, pg_backend_pid: 28116
ci: == 20260219140405 AddTemplateFieldsToComplianceManagementFrameworks: migrating
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: -- add_column(:compliance_management_frameworks, :template_id, :text, {:if_not_exists=>true})
ci:    -> 0.0068s
ci: -- add_column(:compliance_management_frameworks, :template_version, :integer, {:if_not_exists=>true})
ci:    -> 0.0007s
ci: -- transaction_open?(nil)
ci:    -> 0.0000s
ci: == 20260219140405 AddTemplateFieldsToComplianceManagementFrameworks: migrated (0.0212s)

ci: == [advisory_lock_connection] object_id: 136220, pg_backend_pid: 28116
sec: == [advisory_lock_connection] object_id: 136220, pg_backend_pid: 28118
sec: == 20260219140405 AddTemplateFieldsToComplianceManagementFrameworks: migrating
sec: -- transaction_open?(nil)
sec:    -> 0.0000s
sec: -- add_column(:compliance_management_frameworks, :template_id, :text, {:if_not_exists=>true})
sec:    -> 0.0125s
sec: -- add_column(:compliance_management_frameworks, :template_version, :integer, {:if_not_exists=>true})
sec:    -> 0.0006s
sec: -- transaction_open?(nil)
sec:    -> 0.0000s
sec: == 20260219140405 AddTemplateFieldsToComplianceManagementFrameworks: migrated (0.0265s)

sec: == [advisory_lock_connection] object_id: 136220, pg_backend_pid: 28118

MR acceptance checklist

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

Edited by Harsimar Sandhu

Merge request reports

Loading