Skip to content

Swap FKs ci_secure_file_states to ci_secure_files for LFK

Summary

Verification state tables are cell-local. None of their rows should be copied to destination cells by Org Data Migration. But many of them still have foreign keys to non-cell-local tables. The table with foreign key references is: ci_secure_files. We are going to replace the foreign key with "loose foreign keys".

Foreign key to swap:

  • ci_secure_file_states.ci_secure_file_idci_secure_files.id

Implementation

Follow the loose foreign keys documentation and use !185323 (merged) as an example.

Edited by 🤖 GitLab Bot 🤖