XS Add project_id to ci_deleted_objects and set up sharding key config
What we need to do
Add a project_id
column to the ci_deleted_objects
table so we can designate it as the sharding key for records inserted to that table.
How to do it
- Add a project_id column to
ci_deleted_objects
via a normal migration - Add
project_id
to the attributes copied over during bulk import - Make sure that the
desired_sharding_key:backfill_via
automation will work with a partially-populated nullable column. - Add `desired_sharding_key YAML configuration