-- ==========================================
-- Add Staff Details List columns (DoB, Assumption date, Union)
-- Run on existing database to align with FUDMA Staff Details List Excel.
-- ==========================================

USE university_payroll;

ALTER TABLE staff
    ADD COLUMN date_of_birth DATE NULL AFTER last_name,
    ADD COLUMN assumption_date DATE NULL AFTER date_of_birth,
    ADD COLUMN staff_union VARCHAR(100) NULL AFTER payroll_category;
