Update referenced FK to include partition_id for ci_job_artifacts
Problem
Each referenced FK must include the partitioning key in order to partition ci_job_artifacts
.
Solution
Rewrite the following FKs to include partition_id
.
Referenced by:
TABLE "ci_build_trace_metadata" CONSTRAINT "fk_21d25cac1a" FOREIGN KEY (trace_artifact_id) REFERENCES ci_job_artifacts(id) ON DELETE CASCADE
TABLE "ci_job_artifact_states" CONSTRAINT "fk_rails_80a9cba3b2" FOREIGN KEY (job_artifact_id) REFERENCES ci_job_artifacts(id) ON DELETE CASCADE
Edited by Max Orefice