DROP TABLE IF EXISTS sepa_settlement_events;

DROP INDEX IF EXISTS transfers_settlement_reference_idx;
DROP INDEX IF EXISTS transfers_sepa_settlement_due_idx;

ALTER TABLE transfers
    DROP COLUMN IF EXISTS settled_at,
    DROP COLUMN IF EXISTS settlement_next_attempt_at,
    DROP COLUMN IF EXISTS settlement_error,
    DROP COLUMN IF EXISTS settlement_reference,
    DROP COLUMN IF EXISTS settlement_provider,
    DROP COLUMN IF EXISTS settlement_attempts;

ALTER TABLE transfers
    DROP CONSTRAINT IF EXISTS transfers_status_check;

ALTER TABLE transfers
    ADD CONSTRAINT transfers_status_check
    CHECK (status IN ('pending', 'completed', 'failed', 'reversed'));