Add `findings_data` column to `security_findings` table
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.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Mehmet Emin INAC