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_id→ci_secure_files.id
Implementation
Follow the loose foreign keys documentation and use !185323 (merged) as an example.
Edited by 🤖 GitLab Bot 🤖