Yes, seems like I messed up, the second solution works. Thanks all.

Hello this is the message I get.

ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is...