Scenario: Migration from INT to BIGINT PK

Interviewer prompt: user_id INT is close to overflow. Design SQL migration plan to BIGINT with minimal downtime.

users(user_id INT PK), orders(user_id FK)