Use loose foreign keys for pages_deployments
What does this MR do and why?
The foreign key on the ci_build_id column in the pages_deployments table is replaced with a loose foreign key constraint. This is needed as CI builds are stored in a different database compared to the pages_deployments table.
This fixes #336442 (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 Yorick Peterse