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
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