

-- Real bank virtual account details (NUBAN), separate from our internal
-- display-only account_number already on the wallets table
ALTER TABLE wallets
    ADD COLUMN virtual_account_number VARCHAR(20)  DEFAULT NULL AFTER account_number,
    ADD COLUMN virtual_account_bank   VARCHAR(60)  DEFAULT NULL AFTER virtual_account_number,
    ADD COLUMN virtual_account_name  VARCHAR(150) DEFAULT NULL AFTER virtual_account_bank,
    ADD COLUMN virtual_account_ref    VARCHAR(64)  DEFAULT NULL AFTER virtual_account_name,
    ADD COLUMN wallet_provider        VARCHAR(30)  DEFAULT NULL AFTER virtual_account_ref,
    ADD UNIQUE KEY uniq_virtual_account (virtual_account_number);
