-- Add supervisor and work references to time_clocks and timesheets

ALTER TABLE time_clocks
    ADD COLUMN IF NOT EXISTS supervisor_id INTEGER,
    ADD COLUMN IF NOT EXISTS supervisor_type VARCHAR(50),
    ADD COLUMN IF NOT EXISTS work_id INTEGER,
    ADD COLUMN IF NOT EXISTS approval_comment TEXT;

ALTER TABLE timesheets
    ADD COLUMN IF NOT EXISTS supervisor_id INTEGER,
    ADD COLUMN IF NOT EXISTS supervisor_type VARCHAR(50),
    ADD COLUMN IF NOT EXISTS work_id INTEGER,
    ADD COLUMN IF NOT EXISTS approval_comment TEXT;
