BEGIN;

DO $$
BEGIN
    IF EXISTS (SELECT 1 FROM pg_roles WHERE rolname = 'cutehorse_app') THEN
        GRANT USAGE ON SCHEMA contacts TO cutehorse_app;
        GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA contacts TO cutehorse_app;
        GRANT USAGE, SELECT, UPDATE ON ALL SEQUENCES IN SCHEMA contacts TO cutehorse_app;

        ALTER DEFAULT PRIVILEGES IN SCHEMA contacts
            GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO cutehorse_app;

        ALTER DEFAULT PRIVILEGES IN SCHEMA contacts
            GRANT USAGE, SELECT, UPDATE ON SEQUENCES TO cutehorse_app;
    END IF;
END $$;

COMMIT;