ALTER TABLE applicants
ADD column suffix varchar(255),
ADD column degree varchar(255),
ADD column id_card varchar(255);

ALTER TABLE orders
ADD column is_disabled_app_email char(1),
ADD column is_disabled_sms char(1),
ADD column is_hard_copies_required char(1),
ADD column is_do_not_contact_applicant char(1),
ADD column release_form varchar(200),
ADD column privileges varchar(200),
ADD column other_client_id int(10);