Add project_id columns and foreign keys to x509 tables
What does this MR do and why?
Contributes to:
This migration adds project_id columns to both x509_issuers and
x509_certificates tables along with their foreign key constraints and index
to the projects table.
These changes enable proper sharding configuration for the x509 tables as part of the protocells initiative, allowing them to be classified as org-level tables with project_id as the sharding key.
References
- Sharding Key Investigation for `x509_issuers` t... (#553481)
- Sharding Key Investigation for `x509_certificat... (#553480)
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.
Related to #553481
Edited  by Vasilii Iakliushin