Previously the foreign key constraint for `user_id` on the
`personal_access_tokens` table did not have the ON DELETE CASCADE
option enabled, which made deleting users that had generated a
PAT impossible.

This migration adds a new foreign key constraint with this option and
drops the old one.

Closes https://gitlab.com/gitlab-org/gitlab/issues/191262