Merge branch '493768--add-not-null-constraint-sharding-key-vulnerability_state_transitions' into 'master' 

Add NOT NULL on sharding key for vulnerability_state_transitions

See merge request https://gitlab.com/gitlab-org/gitlab/-/merge_requests/182698



Merged-by: Leonardo da Rosa <ldarosa@gitlab.com>
Approved-by: Shubham Kumar <shukumar@gitlab.com>
Approved-by: Leonardo da Rosa <ldarosa@gitlab.com>
Reviewed-by: Leonardo da Rosa <ldarosa@gitlab.com>
Co-authored-by: Shane Maglangit <smaglangit@gitlab.com>