remove facility type

alter table facilities DROP CONSTRAINT fac_u;
alter table facilities add CONSTRAINT fac_name_u UNIQUE (name);
alter table facilities drop column type;