BEGIN;

ALTER TABLE hr_payroll.contract_renewals
    ADD COLUMN IF NOT EXISTS proposed_pay_band VARCHAR(100);

CREATE INDEX IF NOT EXISTS idx_contract_renewals_tenant_pay_band
    ON hr_payroll.contract_renewals (tenant_id, proposed_pay_band)
    WHERE is_deleted = FALSE;

COMMIT;