ALTER TABLE admissions
    ADD COLUMN employment_function VARCHAR(150) NULL AFTER uniform_size,
    ADD COLUMN admission_date DATE NULL AFTER employment_function,
    ADD COLUMN dismissal_date DATE NULL AFTER admission_date,
    ADD COLUMN workload_hours VARCHAR(30) NULL AFTER dismissal_date,
    ADD COLUMN salary_amount DECIMAL(10,2) NULL AFTER workload_hours,
    ADD COLUMN salary_type VARCHAR(20) NULL AFTER salary_amount;

ALTER TABLE admissions
    MODIFY COLUMN bank_agency VARCHAR(30) NULL,
    MODIFY COLUMN bank_account VARCHAR(40) NULL;
