-- Per-employee yearly leave quotas (admin/manager configurable). Default: 12 sick + 12 casual = 24/year.

ALTER TABLE users
  ADD COLUMN IF NOT EXISTS sick_leave_quota integer NOT NULL DEFAULT 12,
  ADD COLUMN IF NOT EXISTS casual_leave_quota integer NOT NULL DEFAULT 12;

COMMENT ON COLUMN users.sick_leave_quota IS 'Max sick leave days per calendar year for this user.';
COMMENT ON COLUMN users.casual_leave_quota IS 'Max casual leave days per calendar year for this user.';