You either need to specify a default value and not null at the same time, or you need to add the column nullable, put a value in every row and then make it not null. If you add a column and have no default value then the default value will be null.