Add license_occurrence_uuids to security_policy_dismissals

What does this MR do and why?

Add license_occurrence_uuids to the security_policy_dismissals table.

This new column will be used to store the occurrence uuids to enable us to filter dependencies dismissed by security policies.

Migration up

main: == [advisory_lock_connection] object_id: 171180, pg_backend_pid: 58537
main: == 20251023141331 AddLicenseOccurrenceUuidsToPolicyDismissal: migrating =======
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- add_column(:security_policy_dismissals, :license_occurrence_uuids, :text, {:array=>true, :default=>[], :null=>false, :if_not_exists=>true})
main:    -> 0.0442s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- transaction_open?(nil)
main:    -> 0.0000s
main: -- execute("ALTER TABLE security_policy_dismissals\nADD CONSTRAINT security_policy_dismissals_license_occurrence_uuids_size\nCHECK ( CARDINALITY(license_occurrence_uuids) <= 1000 )\nNOT VALID;\n")
main:    -> 0.0010s
main: == 20251023141331 AddLicenseOccurrenceUuidsToPolicyDismissal: migrated (0.0861s) 

Migration down

main: == 20251023141331 AddLicenseOccurrenceUuidsToPolicyDismissal: reverting =======
main: -- remove_column(:security_policy_dismissals, :license_occurrence_uuids, :text, {:array=>true, :default=>[], :null=>false})
main:    -> 0.0975s
main: == 20251023141331 AddLicenseOccurrenceUuidsToPolicyDismissal: reverted (0.1438s) 

References

Related to: #570791

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.