Add sharding key to search_namespace_index_assignments.yml

What does this MR do and why?

Related to #442664 (closed)

update gitlab_schema and define sharding key for search_namespace_index_assignments table

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

N/A

How to set up and validate locally

N/A