I've a table `item` that has some columns that are `nullable`.
To one of them `type`, I'd like to automatically insert a `default` value (instead of a `NULL`) whenever a new record in inserted in the table and do not specify a value for that column.

Can it be done without affecting the existing data?
The `type` column is a `varchar`.

I can update the current `nulls`.