Skip to content

Add `findings_data` column to `security_findings` table

Mehmet Emin INAC requested to merge 376201_add_finding_data_to_security_findings_table into master

What does this MR do and why?

This MR adds a new column called findings_data to the security_findings table.

Note: We will start setting the data for this column later once I create the required patch for the OJ gem(https://github.com/ohler55/oj/pull/819).

Database Review

db:migrate:up 
main: == 20221028152422 AddFindingDataColumnToSecurityFindings: migrating ===========
main: -- transaction_open?()
main:    -> 0.0000s
main: -- add_column(:security_findings, :finding_data, :jsonb, {:default=>{}, :null=>false})
main:    -> 0.0019s
main: == 20221028152422 AddFindingDataColumnToSecurityFindings: migrated (0.0090s) ==
db:migrate:down 
main: == 20221028152422 AddFindingDataColumnToSecurityFindings: reverting ===========
main: -- transaction_open?()
main:    -> 0.0000s
main: -- remove_column(:security_findings, :finding_data)
main:    -> 0.0014s
main: == 20221028152422 AddFindingDataColumnToSecurityFindings: reverted (0.0086s) ==

Related to Add finding_data column to security_findings table (#376201 - closed).

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Mehmet Emin INAC

Merge request reports