-- =====================================================
-- Activate Virtual Account Payment Methods
-- This script prioritizes automated virtual accounts
-- =====================================================

-- Set Moniepoint as primary (display order 1)
UPDATE payment_methods
SET is_active = TRUE,
    display_order = 1,
    description = 'INSTANT: Get unique account number for instant payment (99.9% success rate, ₦10 fee)'
WHERE code = 'moniepoint';

-- Set Kuda as secondary (display order 2)
UPDATE payment_methods
SET is_active = TRUE,
    display_order = 2,
    description = 'FREE: Get unique Kuda account number with zero fees'
WHERE code = 'kuda';

-- Keep bank_transfer as manual fallback (display order 6)
UPDATE payment_methods
SET is_active = TRUE,
    display_order = 6,
    description = 'Manual bank transfer with proof upload - verified within 5-10 minutes'
WHERE code = 'bank_transfer';

-- Verify changes
SELECT
    id,
    name,
    code,
    is_active,
    is_automated,
    display_order,
    description
FROM payment_methods
WHERE is_active = TRUE
ORDER BY display_order;
