BEGIN;

DO $$
BEGIN
    IF EXISTS (SELECT 1 FROM pg_roles WHERE rolname = 'cutehorse_app') THEN
        IF to_regclass('hr_payroll.payroll_run_items') IS NOT NULL THEN
            GRANT SELECT, INSERT, UPDATE, DELETE
                ON TABLE hr_payroll.payroll_run_items
                TO cutehorse_app;
        END IF;

        IF to_regclass('hr_payroll.statutory_contribution_records') IS NOT NULL THEN
            GRANT SELECT, INSERT, UPDATE, DELETE
                ON TABLE hr_payroll.statutory_contribution_records
                TO cutehorse_app;
        END IF;

        GRANT USAGE, SELECT, UPDATE
            ON ALL SEQUENCES IN SCHEMA hr_payroll
            TO cutehorse_app;
    END IF;
END $$;

COMMIT;