assarn
for all values that are currently null, insert a default value
add not null constraint to the column