Add a column with a default and foreign key constraint

Every so often you may be presented with the requirement to ...