alter table company add column dep_as_pickupgroup varchar(3);
alter table company alter column dep_as_pickupgroup set default 'yes';
update company set dep_as_pickupgroup = 'yes' where dep_as_pickupgroup is null;
alter table company alter column dep_as_pickupgroup set not null;
