simple design choice

[Alex K]

Hello,

I have a table of a 1 million users. I want to add a flag called
delete if a user wants to delete his account. Note that this situation
does not happen a lot.

1) Should I alter my users table and add a delete flag to the users table.
>> it's easy to update however it uses a lot of unnecessary space.

2) Should I create a new table user_id, flag already prefilled with
all user_ids.

3) Should I create a new table called deleted_users that has a user_id
if this user wants to be deleted.
>> it's hassle to update but takes into consideration the spareness of the data.

Thank you,

Alex