[DB] Framework source column

What does this MR do and why?

In this MR, we are introducing a new database column, source_id, to compliance management frameworks.

The migration will:

  • Add 'source_id' to compliance management frameworks

We are going to be using this column in subsequent MRs.

Migration Logs

rails db:migrate:down:main VERSION=20250604221239
main: == [advisory_lock_connection] object_id: 136880, pg_backend_pid: 69560
main: == 20250604221239 AddSourceUuidToFrameworks: reverting ========================
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- remove_column(:compliance_management_frameworks, :source_id, {:if_exists=>true})
main:    -> 0.0150s
main: == 20250604221239 AddSourceUuidToFrameworks: reverted (0.0268s) ===============

main: == [advisory_lock_connection] object_id: 136880, pg_backend_pid: 69560

rails db:migrate:up:main VERSION=20250604221239
main: == [advisory_lock_connection] object_id: 136880, pg_backend_pid: 70322
main: == 20250604221239 AddSourceUuidToFrameworks: migrating ========================
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- add_column(:compliance_management_frameworks, :source_id, :uuid)
main:    -> 0.0016s
main: == 20250604221239 AddSourceUuidToFrameworks: migrated (0.0141s) ===============

main: == [advisory_lock_connection] object_id: 136880, pg_backend_pid: 70322

Related to #546243 (closed)

Edited by Jean van der Walt

Merge request reports

Loading