BEGIN;
alter table company add column dir_search varchar(5);
update company set dir_search = 'last' where dir_search is NULL;
alter table company alter column dir_search set default 'last';
alter table company alter column dir_search set NOT NULL;
alter table company add constraint company_dir_search_check CHECK (dir_search IN ('last', 'first', 'both'));
COMMIT;

