DROP TRIGGER IF EXISTS beneficiaries_set_updated_at ON beneficiaries;

DROP INDEX IF EXISTS transfers_beneficiary_iban_idx;
DROP INDEX IF EXISTS transfers_beneficiary_id_idx;

ALTER TABLE transfers
    DROP CONSTRAINT IF EXISTS transfers_destination_check,
    DROP COLUMN IF EXISTS transfer_type,
    DROP COLUMN IF EXISTS payment_reference,
    DROP COLUMN IF EXISTS beneficiary_bic,
    DROP COLUMN IF EXISTS beneficiary_iban,
    DROP COLUMN IF EXISTS beneficiary_name,
    DROP COLUMN IF EXISTS beneficiary_id;

DELETE FROM transfers WHERE to_account_id IS NULL;

ALTER TABLE transfers ALTER COLUMN to_account_id SET NOT NULL;

DROP TABLE IF EXISTS beneficiaries;