The following adds a non-null column named author_type, which includes the constant “primary_author” as the default value, and a null column named au_publisher to the authors table:
alter table authors add author_type varchar(20) default "primary_author" not null, au_publisher varchar(40) null
