ADD or modify column in one call (upsert) - avoid DROP calls
If I understand your question correctly, you just want to make the column NOT NULL. This can be done with the ALTER &lt;column_name&gt; sub-command
ALTER TABLE mbk_user ALTER login_attempts SET NOT NULL; 

Obviously this only works if there are no NULL values in that column.