-- Seed: Nigerian banks
-- Base data from ditco_banks (MySQL). bcode → code, bank_name → name, status → is_active.
-- Cronfly Wallet (internal) excluded.
-- Additional entries appended from platform seed (Kuda, TAJ, Titan Trust, VFD).
-- Note: TAJ Bank (302) will be silently skipped if Lotus Bank already occupies that code.

-- UP

INSERT INTO grb_core.banks (name, code, country_code, is_active) VALUES
    ('Access Bank Plc',                       '044',   'NG', TRUE),
    ('Citibank Nigeria Limited',              '023',   'NG', TRUE),
    ('Diamond (Access) Bank Plc',             '063',   'NG', TRUE),
    ('Ecobank Nigeria Plc',                   '050',   'NG', TRUE),
    ('Enterprise Bank',                       '084',   'NG', TRUE),
    ('Fidelity Bank Plc',                     '070',   'NG', TRUE),
    ('First Bank Nigeria Limited',            '011',   'NG', TRUE),
    ('First City Monument Bank Plc',          '214',   'NG', TRUE),
    ('Globus Bank',                           '00103', 'NG', TRUE),
    ('Guaranty Trust Bank Plc',               '058',   'NG', TRUE),
    ('Heritage Banking Company Ltd.',         '030',   'NG', TRUE),
    ('Jaiz Bank',                             '301',   'NG', TRUE),
    ('Keystone Bank',                         '082',   'NG', TRUE),
    ('Lotus Bank',                            '302',   'NG', TRUE),
    ('MainStreet Bank',                       '014',   'NG', TRUE),
    ('Moniepoint Microfinance Bank',          '796',   'NG', TRUE),
    ('OPay (Paycom)',                          '305',   'NG', TRUE),
    ('Optimus Bank',                          '107',   'NG', TRUE),
    ('Palmpay',                               '855',   'NG', TRUE),
    ('Parallex Bank',                         '526',   'NG', TRUE),
    ('Premium Trust Bank',                    '105',   'NG', TRUE),
    ('Providus Bank',                         '101',   'NG', TRUE),
    ('Signature Bank',                        '106',   'NG', TRUE),
    ('Skye Bank Plc',                         '076',   'NG', TRUE),
    ('Stanbic IBTC Bank Ltd.',                '221',   'NG', TRUE),
    ('Standard Chartered Bank Nigeria Ltd.',  '068',   'NG', TRUE),
    ('Sterling Bank Plc',                     '232',   'NG', TRUE),
    ('SunTrust Bank Nigeria Limited',         '0',     'NG', TRUE),
    ('Union Bank of Nigeria Plc',             '032',   'NG', TRUE),
    ('United Bank For Africa Plc',            '033',   'NG', TRUE),
    ('Unity Bank Plc',                        '215',   'NG', TRUE),
    ('Wema Bank Plc',                         '035',   'NG', TRUE),
    ('Zenith Bank Plc',                       '057',   'NG', TRUE),
    -- Additional entries not in MySQL source
    ('Kuda Microfinance Bank',                '50211', 'NG', TRUE),
    ('TAJ Bank',                              '302',   'NG', TRUE),
    ('Titan Trust Bank',                      '102',   'NG', TRUE),
    ('VFD Microfinance Bank',                 '566',   'NG', TRUE)
ON CONFLICT (code, country_code) DO NOTHING;

-- DOWN

DELETE FROM grb_core.banks WHERE country_code = 'NG';
