Swap some Geo verification table FKs for LFKs

Michael Kozonorequested to merge
mk/use-loose-foreign-keys-on-geo-verification-tables into master

What does this MR do and why?

Swap FKs for LFKs:

  • ci_secure_file_states.ci_secure_file_id
  • dependency_proxy_blob_states.dependency_proxy_blob_id
  • dependency_proxy_blob_states.group_id

These tables are cell-local and cannot have a normal foreign key to a non-cell-local table.

References

Resolves #579753

Resolves #579754

How to set up and validate locally

No behavior change expected. Geo verification should not break.

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

Merge request reports