Add namespace_id column to redirect_routes

What does this MR do and why?

Adds a namespace_id column to the redirect_routes table as the first step towards adding the sharding key for the table, as outlined in #514146 (closed)

Additionally, the index and foreign key constraint is added concurrently to the column.

References

• Related to #514146 (closed)

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