INSERT INTO `smspva_service_cache` (`id`, `service_code`, `service_name`, `country_code`, `operator`, `usd_price`, `ngn_price`, `count_available`, `conversion_rate`, `synced_at`) VALUES
(108167, 'opt9', 'Tinder', 'VN', 'HTMobile_VN', 0.1500, 450.00, 999, 0.00, '2026-05-25 01:52:16'),
(108168, 'opt9', 'Tinder', 'VN', 'ViettelMobile_VN', 0.1500, 450.00, 999, 0.00, '2026-05-25 01:52:16'),
(108169, 'opt9', 'Tinder', 'VN', 'Intel_VN', 0.1500, 450.00, 999, 0.00, '2026-05-25 01:52:16'),
(108170, 'opt9', 'Tinder', 'VN', 'Total_VN', 0.1500, 450.00, 999, 0.00, '2026-05-25 01:52:16'),
(108171, 'opt90', 'Snapchat', 'VN', 'ViettelMobile_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108172, 'opt90', 'Snapchat', 'VN', 'Intel_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108173, 'opt90', 'Snapchat', 'VN', 'VietnamMobile2_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108174, 'opt90', 'Snapchat', 'VN', 'Vina_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108175, 'opt90', 'Snapchat', 'VN', 'HTMobile_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108176, 'opt90', 'Snapchat', 'VN', 'Total_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108177, 'opt9001', 'OPT9001', 'VN', 'Vina_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108178, 'opt9001', 'OPT9001', 'VN', 'HTMobile_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108179, 'opt9001', 'OPT9001', 'VN', 'ViettelMobile_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108180, 'opt9001', 'OPT9001', 'VN', 'Intel_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108181, 'opt9001', 'OPT9001', 'VN', 'VietnamMobile2_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108182, 'opt9001', 'OPT9001', 'VN', 'Total_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108183, 'opt91', 'Wise', 'VN', 'VietnamMobile2_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108184, 'opt91', 'Wise', 'VN', 'Vina_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108185, 'opt91', 'Wise', 'VN', 'HTMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108186, 'opt91', 'Wise', 'VN', 'ViettelMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108187, 'opt91', 'Wise', 'VN', 'Intel_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108188, 'opt91', 'Wise', 'VN', 'Total_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108189, 'opt92', 'DiDi', 'VN', 'ViettelMobile_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108190, 'opt92', 'DiDi', 'VN', 'Intel_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108191, 'opt92', 'DiDi', 'VN', 'VietnamMobile2_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108192, 'opt92', 'DiDi', 'VN', 'Vina_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108193, 'opt92', 'DiDi', 'VN', 'HTMobile_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108194, 'opt92', 'DiDi', 'VN', 'Total_VN', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:16'),
(108195, 'opt93', 'Zoho', 'VN', 'Intel_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108196, 'opt93', 'Zoho', 'VN', 'VietnamMobile2_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108197, 'opt93', 'Zoho', 'VN', 'Vina_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108198, 'opt93', 'Zoho', 'VN', 'HTMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108199, 'opt93', 'Zoho', 'VN', 'ViettelMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108200, 'opt93', 'Zoho', 'VN', 'Total_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108201, 'opt94', 'JD.com', 'VN', 'Vina_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108202, 'opt94', 'JD.com', 'VN', 'HTMobile_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108203, 'opt94', 'JD.com', 'VN', 'ViettelMobile_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108204, 'opt94', 'JD.com', 'VN', 'Intel_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108205, 'opt94', 'JD.com', 'VN', 'VietnamMobile2_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108206, 'opt94', 'JD.com', 'VN', 'Total_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108207, 'opt95', 'NetBet', 'VN', 'Intel_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108208, 'opt95', 'NetBet', 'VN', 'VietnamMobile2_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108209, 'opt95', 'NetBet', 'VN', 'Vina_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108210, 'opt95', 'NetBet', 'VN', 'HTMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108211, 'opt95', 'NetBet', 'VN', 'ViettelMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108212, 'opt95', 'NetBet', 'VN', 'Total_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108213, 'opt96', 'MiChat', 'VN', 'Vina_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108214, 'opt96', 'MiChat', 'VN', 'HTMobile_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108215, 'opt96', 'MiChat', 'VN', 'ViettelMobile_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108216, 'opt96', 'MiChat', 'VN', 'Intel_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108217, 'opt96', 'MiChat', 'VN', 'VietnamMobile2_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108218, 'opt96', 'MiChat', 'VN', 'Total_VN', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:16'),
(108219, 'opt97', 'Kuper (SberMarket)', 'VN', 'Vina_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108220, 'opt97', 'Kuper (SberMarket)', 'VN', 'HTMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108221, 'opt97', 'Kuper (SberMarket)', 'VN', 'ViettelMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108222, 'opt97', 'Kuper (SberMarket)', 'VN', 'Intel_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108223, 'opt97', 'Kuper (SberMarket)', 'VN', 'VietnamMobile2_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108224, 'opt97', 'Kuper (SberMarket)', 'VN', 'Total_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108225, 'opt98', 'Clubhouse', 'VN', 'ViettelMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108226, 'opt98', 'Clubhouse', 'VN', 'Intel_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108227, 'opt98', 'Clubhouse', 'VN', 'VietnamMobile2_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108228, 'opt98', 'Clubhouse', 'VN', 'Vina_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108229, 'opt98', 'Clubhouse', 'VN', 'HTMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108230, 'opt98', 'Clubhouse', 'VN', 'Total_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108231, 'opt99', 'KoronaPay', 'VN', 'VietnamMobile2_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108232, 'opt99', 'KoronaPay', 'VN', 'Vina_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108233, 'opt99', 'KoronaPay', 'VN', 'HTMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108234, 'opt99', 'KoronaPay', 'VN', 'ViettelMobile_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108235, 'opt99', 'KoronaPay', 'VN', 'Intel_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108236, 'opt99', 'KoronaPay', 'VN', 'Total_VN', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:16'),
(108237, 'opt0', 'myopinions & erewards', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108238, 'opt0', 'myopinions & erewards', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108239, 'opt1', 'Google (YouTube, Gmail)', 'XK', 'Kosovo_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108240, 'opt1', 'Google (YouTube, Gmail)', 'XK', 'Total_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108241, 'opt10', 'AOL', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108242, 'opt10', 'AOL', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108243, 'opt100', 'Mamba', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:18'),
(108244, 'opt100', 'Mamba', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:18'),
(108245, 'opt101', 'Netflix', 'XK', 'Kosovo_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108246, 'opt101', 'Netflix', 'XK', 'Total_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108247, 'opt103', 'ICard', 'XK', 'Kosovo_XK', 0.4000, 1200.00, 999, 0.00, '2026-05-25 01:52:18'),
(108248, 'opt103', 'ICard', 'XK', 'Total_XK', 0.4000, 1200.00, 999, 0.00, '2026-05-25 01:52:18'),
(108249, 'opt104', 'TikTok', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108250, 'opt104', 'TikTok', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108251, 'opt105', 'LocalBitcoins', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108252, 'opt105', 'LocalBitcoins', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108253, 'opt106', 'Wing Money', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108254, 'opt106', 'Wing Money', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108255, 'opt107', 'Prom.UA', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:18'),
(108256, 'opt107', 'Prom.UA', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:18'),
(108257, 'opt108', 'Glovo & Raketa', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108258, 'opt108', 'Glovo & Raketa', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108259, 'opt109', 'Paddy Power', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108260, 'opt109', 'Paddy Power', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108261, 'opt11', 'Viber', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108262, 'opt11', 'Viber', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108263, 'opt110', 'Grindr', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108264, 'opt110', 'Grindr', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108265, 'opt111', 'IMO', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108266, 'opt111', 'IMO', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108267, 'opt112', 'CoinBase', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108268, 'opt112', 'CoinBase', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108269, 'opt113', 'OfferUp', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108270, 'opt113', 'OfferUp', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108271, 'opt114', 'Locanto.com', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108272, 'opt114', 'Locanto.com', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108273, 'opt115', 'foodpanda', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108274, 'opt115', 'foodpanda', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108275, 'opt116', 'Neteller', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108276, 'opt116', 'Neteller', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108277, 'opt117', 'Skrill', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108278, 'opt117', 'Skrill', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108279, 'opt118', 'Inboxdollars', 'XK', 'Kosovo_XK', 0.3500, 1050.00, 999, 0.00, '2026-05-25 01:52:18'),
(108280, 'opt118', 'Inboxdollars', 'XK', 'Total_XK', 0.3500, 1050.00, 999, 0.00, '2026-05-25 01:52:18'),
(108281, 'opt119', 'Nico', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108282, 'opt119', 'Nico', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108283, 'opt120', 'Hinge', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108284, 'opt120', 'Hinge', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108285, 'opt121', 'Monese', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108286, 'opt121', 'Monese', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108287, 'opt122', 'Paysafecard', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108288, 'opt122', 'Paysafecard', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108289, 'opt123', 'Whoosh', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108290, 'opt123', 'Whoosh', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108291, 'opt124', 'Credit Karma', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108292, 'opt124', 'Credit Karma', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108293, 'opt125', 'Swagbucks', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108294, 'opt125', 'Swagbucks', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108295, 'opt126', 'Magnit', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108296, 'opt126', 'Magnit', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108297, 'opt127', 'Signal', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108298, 'opt127', 'Signal', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108299, 'opt129', 'kwiff.com', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108300, 'opt129', 'kwiff.com', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108301, 'opt13', 'Fotostrana', 'XK', 'Kosovo_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:18'),
(108302, 'opt13', 'Fotostrana', 'XK', 'Total_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:18'),
(108303, 'opt130', 'Vinted', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108304, 'opt130', 'Vinted', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108305, 'opt131', 'Apple', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108306, 'opt131', 'Apple', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108307, 'opt132', '1 OpenAI API (chatGPT, DALL-e 2)', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108308, 'opt132', '1 OpenAI API (chatGPT, DALL-e 2)', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108309, 'opt133', 'Revolut', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108310, 'opt133', 'Revolut', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108311, 'opt134', 'Schibsted-konto', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108312, 'opt134', 'Schibsted-konto', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108313, 'opt135', 'blsspain-russia.com', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108314, 'opt135', 'blsspain-russia.com', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108315, 'opt136', 'dundle', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108316, 'opt136', 'dundle', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108317, 'opt137', 'bwin', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108318, 'opt137', 'bwin', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108319, 'opt138', 'Bazos.sk', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108320, 'opt138', 'Bazos.sk', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108321, 'opt139', 'fontbet', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108322, 'opt139', 'fontbet', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108323, 'opt140', 'Google Voice', 'XK', 'Kosovo_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108324, 'opt140', 'Google Voice', 'XK', 'Total_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108325, 'opt141', 'EUROBET', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108326, 'opt141', 'EUROBET', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108327, 'opt142', 'funpay', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108328, 'opt142', 'funpay', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108329, 'opt143', 'autocosmos.com', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108330, 'opt143', 'autocosmos.com', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108331, 'opt144', 'hopper', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108332, 'opt144', 'hopper', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108333, 'opt145', 'bumble', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108334, 'opt145', 'bumble', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108335, 'opt146', 'subito.it', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108336, 'opt146', 'subito.it', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108337, 'opt147', 'VooV Meeting', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108338, 'opt147', 'VooV Meeting', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108339, 'opt148', 'casa.it', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108340, 'opt148', 'casa.it', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108341, 'opt149', 'pm.by', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108342, 'opt149', 'pm.by', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108343, 'opt15', 'Microsoft (Azure, Bing, Skype, etc)', 'XK', 'Kosovo_XK', 2.5000, 7500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108344, 'opt15', 'Microsoft (Azure, Bing, Skype, etc)', 'XK', 'Total_XK', 2.5000, 7500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108345, 'opt150', 'Czech email services', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108346, 'opt150', 'Czech email services', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108347, 'opt151', 'novibet.com', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108348, 'opt151', 'novibet.com', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108349, 'opt152', 'kleinanzeigen.de', 'XK', 'Kosovo_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108350, 'opt152', 'kleinanzeigen.de', 'XK', 'Total_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108351, 'opt153', 'ROOMSTER', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108352, 'opt153', 'ROOMSTER', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108353, 'opt154', 'Rambler.ru', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108354, 'opt154', 'Rambler.ru', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108355, 'opt155', 'Happn', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108356, 'opt155', 'Happn', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108357, 'opt156', 'mobileDE', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108358, 'opt156', 'mobileDE', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108359, 'opt157', 'CupidMedia', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108360, 'opt157', 'CupidMedia', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108361, 'opt158', 'Zalo', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108362, 'opt158', 'Zalo', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108363, 'opt159', 'Feeld', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108364, 'opt159', 'Feeld', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108365, 'opt16', 'Instagram (+Threads)', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108366, 'opt16', 'Instagram (+Threads)', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108367, 'opt160', 'U By Prodia', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108368, 'opt160', 'U By Prodia', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108369, 'opt161', 'TANK.RU', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108370, 'opt161', 'TANK.RU', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108371, 'opt162', 'Payoneer', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108372, 'opt162', 'Payoneer', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108373, 'opt163', 'Wolt', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108374, 'opt163', 'Wolt', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108375, 'opt164', 'Leboncoin', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108376, 'opt164', 'Leboncoin', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108377, 'opt165', 'idealista.com', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108378, 'opt165', 'idealista.com', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108379, 'opt166', 'HUAWEI', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108380, 'opt166', 'HUAWEI', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108381, 'opt167', 'inbox.lv', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108382, 'opt167', 'inbox.lv', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108383, 'opt169', 'Pari.ru', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108384, 'opt169', 'Pari.ru', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108385, 'opt17', 'bet365', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108386, 'opt17', 'bet365', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108387, 'opt170', 'Royal Canin', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108388, 'opt170', 'Royal Canin', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108389, 'opt171', 'Marktplaats', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108390, 'opt171', 'Marktplaats', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108391, 'opt172', 'WEB.DE', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108392, 'opt172', 'WEB.DE', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108393, 'opt173', 'X World Wallet', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108394, 'opt173', 'X World Wallet', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108395, 'opt174', 'Samsung', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108396, 'opt174', 'Samsung', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108397, 'opt175', 'Klarna', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108398, 'opt175', 'Klarna', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108399, 'opt176', 'ChoTot', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108400, 'opt176', 'ChoTot', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108401, 'opt177', 'NHNcorp (강남언니)', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108402, 'opt177', 'NHNcorp (강남언니)', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108403, 'opt178', 'VonageVF', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108404, 'opt178', 'VonageVF', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108405, 'opt179', 'GetsBet.ro', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108406, 'opt179', 'GetsBet.ro', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108407, 'opt18', 'Qiwi', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108408, 'opt18', 'Qiwi', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:18'),
(108409, 'opt180', 'Lalamove', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108410, 'opt180', 'Lalamove', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108411, 'opt181', 'OZON.ru', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108412, 'opt181', 'OZON.ru', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108413, 'opt182', 'LAPOSTE', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108414, 'opt182', 'LAPOSTE', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108415, 'opt183', 'PAYSEND', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108416, 'opt183', 'PAYSEND', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108417, 'opt184', 'MOMO', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108418, 'opt184', 'MOMO', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108419, 'opt185', 'Samokat', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108420, 'opt185', 'Samokat', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108421, 'opt186', 'RusDate', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108422, 'opt186', 'RusDate', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108423, 'opt187', 'Beget.com', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108424, 'opt187', 'Beget.com', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108425, 'opt188', 'GGbet', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108426, 'opt188', 'GGbet', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108427, 'opt189', 'foodora', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108428, 'opt189', 'foodora', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108429, 'opt19', 'OTHER (no guarantee)', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108430, 'opt19', 'OTHER (no guarantee)', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108431, 'opt190', 'SNKRDUNK', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108432, 'opt190', 'SNKRDUNK', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108433, 'opt191', 'TopCashback', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108434, 'opt191', 'TopCashback', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108435, 'opt192', 'Betano (+BETANO.ro)', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108436, 'opt192', 'Betano (+BETANO.ro)', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108437, 'opt193', 'Ipsos', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108438, 'opt193', 'Ipsos', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108439, 'opt194', 'ZoomInfo', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108440, 'opt194', 'ZoomInfo', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108441, 'opt195', 'Lajumate.ro', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108442, 'opt195', 'Lajumate.ro', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108443, 'opt196', 'Claude (Anthropic)', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108444, 'opt196', 'Claude (Anthropic)', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108445, 'opt197', 'MPSellers', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108446, 'opt197', 'MPSellers', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108447, 'opt198', 'Nectar', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108448, 'opt198', 'Nectar', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108449, 'opt199', 'bunq', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108450, 'opt199', 'bunq', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108451, 'opt2', 'Facebook', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108452, 'opt2', 'Facebook', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108453, 'opt20', 'WhatsAPP', 'XK', 'Kosovo_XK', 12.0000, 36000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108454, 'opt20', 'WhatsAPP', 'XK', 'Total_XK', 12.0000, 36000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108455, 'opt200', 'ENEBA', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108456, 'opt200', 'ENEBA', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108457, 'opt201', 'Casino Plus', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108458, 'opt201', 'Casino Plus', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108459, 'opt202', 'NHNCloud', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108460, 'opt202', 'NHNCloud', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108461, 'opt203', 'HelloTalk', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108462, 'opt203', 'HelloTalk', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108463, 'opt204', 'DenimApp', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108464, 'opt204', 'DenimApp', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108465, 'opt205', 'Twitch', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108466, 'opt205', 'Twitch', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108467, 'opt206', 'WalletHub', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108468, 'opt206', 'WalletHub', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108469, 'opt207', 'Publi24', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108470, 'opt207', 'Publi24', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108471, 'opt208', 'WooPlus', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108472, 'opt208', 'WooPlus', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108473, 'opt209', 'BANDUS', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108474, 'opt209', 'BANDUS', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108475, 'opt21', 'EasyPay', 'XK', 'Kosovo_XK', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:18'),
(108476, 'opt21', 'EasyPay', 'XK', 'Total_XK', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:18'),
(108477, 'opt211', 'MrGreen', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108478, 'opt211', 'MrGreen', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108479, 'opt212', 'OurTime', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108480, 'opt212', 'OurTime', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108481, 'opt213', 'Waitomo', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108482, 'opt213', 'Waitomo', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108483, 'opt214', 'Cashrewards', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108484, 'opt214', 'Cashrewards', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108485, 'opt215', 'Fbet', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108486, 'opt215', 'Fbet', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108487, 'opt216', 'Hey', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108488, 'opt216', 'Hey', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108489, 'opt217', 'Brevo', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108490, 'opt217', 'Brevo', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108491, 'opt218', 'TransferGo', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108492, 'opt218', 'TransferGo', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108493, 'opt219', 'maxline.by', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108494, 'opt219', 'maxline.by', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108495, 'opt22', '888casino', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108496, 'opt22', '888casino', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108497, 'opt220', 'TOTOGAMING', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108498, 'opt220', 'TOTOGAMING', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108499, 'opt221', 'Fortuna', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108500, 'opt221', 'Fortuna', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108501, 'opt222', 'LASVEGAS.RO', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108502, 'opt222', 'LASVEGAS.RO', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108503, 'opt223', 'Betmgm', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108504, 'opt223', 'Betmgm', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108505, 'opt224', '22bet', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108506, 'opt224', '22bet', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108507, 'opt225', 'Zasilkovna', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108508, 'opt225', 'Zasilkovna', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108509, 'opt226', 'Cash App', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108510, 'opt226', 'Cash App', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108511, 'opt227', 'Walmart', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108512, 'opt227', 'Walmart', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108513, 'opt228', 'OKX', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108514, 'opt228', 'OKX', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108515, 'opt229', 'GGPokerUK', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108516, 'opt229', 'GGPokerUK', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108517, 'opt23', 'Yandex&YooMoney', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:18'),
(108518, 'opt23', 'Yandex&YooMoney', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:18'),
(108519, 'opt230', 'OkCupid', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108520, 'opt230', 'OkCupid', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108521, 'opt231', 'Whatnot', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108522, 'opt231', 'Whatnot', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108523, 'opt232', 'DistroKid', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108524, 'opt232', 'DistroKid', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108525, 'opt233', 'TrueCaller', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108526, 'opt233', 'TrueCaller', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108527, 'opt234', 'Solitaire Cash', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108528, 'opt234', 'Solitaire Cash', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108529, 'opt235', 'TLScontact', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108530, 'opt235', 'TLScontact', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108531, 'opt236', 'Year13', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108532, 'opt236', 'Year13', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108533, 'opt237', 'Bitpanda', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108534, 'opt237', 'Bitpanda', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108535, 'opt238', 'hepsiburada', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108536, 'opt238', 'hepsiburada', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108537, 'opt239', 'Taptap', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108538, 'opt239', 'Taptap', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108539, 'opt24', 'WebMoney&ENUM', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108540, 'opt24', 'WebMoney&ENUM', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108541, 'opt240', 'goldbet.it', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108542, 'opt240', 'goldbet.it', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108543, 'opt241', 'onet.pl (Onet Konto)', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108544, 'opt241', 'onet.pl (Onet Konto)', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108545, 'opt242', 'Abbott', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108546, 'opt242', 'Abbott', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108547, 'opt243', 'IQOS', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108548, 'opt243', 'IQOS', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108549, 'opt244', 'Truth Social', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108550, 'opt244', 'Truth Social', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108551, 'opt245', 'Linode', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108552, 'opt245', 'Linode', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108553, 'opt246', 'Outlier', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108554, 'opt246', 'Outlier', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108555, 'opt247', 'RadQuest', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108556, 'opt247', 'RadQuest', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108557, 'opt248', 'ESX (abonamentesali.ro)', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108558, 'opt248', 'ESX (abonamentesali.ro)', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108559, 'opt249', 'Superbet', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108560, 'opt249', 'Superbet', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108561, 'opt25', 'BetFair', 'XK', 'Kosovo_XK', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:18'),
(108562, 'opt25', 'BetFair', 'XK', 'Total_XK', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:18'),
(108563, 'opt250', 'Match', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108564, 'opt250', 'Match', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108565, 'opt251', '1cupis.ru', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108566, 'opt251', '1cupis.ru', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:18'),
(108567, 'opt252', 'Best Buy', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108568, 'opt252', 'Best Buy', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108569, 'opt253', 'Zoosk', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108570, 'opt253', 'Zoosk', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108571, 'opt254', 'Monster Energy', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108572, 'opt254', 'Monster Energy', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108573, 'opt255', 'Casa Pariurilor', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108574, 'opt255', 'Casa Pariurilor', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108575, 'opt256', 'Astropay', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108576, 'opt256', 'Astropay', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108577, 'opt257', 'Remitly', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108578, 'opt257', 'Remitly', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108579, 'opt258', 'SumUp', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108580, 'opt258', 'SumUp', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108581, 'opt259', 'Google Messenger', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108582, 'opt259', 'Google Messenger', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108583, 'opt26', 'Craigslist', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108584, 'opt26', 'Craigslist', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108585, 'opt260', 'Parions Sport', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108586, 'opt260', 'Parions Sport', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108587, 'opt261', 'Welo Data', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108588, 'opt261', 'Welo Data', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108589, 'opt262', 'BC GAME', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108590, 'opt262', 'BC GAME', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108591, 'opt263', 'Profee.com', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108592, 'opt263', 'Profee.com', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108593, 'opt264', 'Toloka.ai', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108594, 'opt264', 'Toloka.ai', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108595, 'opt265', 'Reddit', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108596, 'opt265', 'Reddit', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108597, 'opt266', 'Capital One Shopping', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108598, 'opt266', 'Capital One Shopping', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108599, 'opt267', 'Caliente', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108600, 'opt267', 'Caliente', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108601, 'opt268', 'Pokémon(ポケモンセンターオンライン)', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108602, 'opt268', 'Pokémon(ポケモンセンターオンライン)', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108603, 'opt269', 'Neosurf', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108604, 'opt269', 'Neosurf', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108605, 'opt27', 'Dodopizza + PapaJohns', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108606, 'opt27', 'Dodopizza + PapaJohns', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108607, 'opt270', 'Skelbiu', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108608, 'opt270', 'Skelbiu', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108609, 'opt271', 'Google Chat', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108610, 'opt271', 'Google Chat', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108611, 'opt272', 'American Airlines', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108612, 'opt272', 'American Airlines', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108613, 'opt28', 'Gamers set (offgamers.com, G2A.com, seagm.com)', 'XK', 'Kosovo_XK', 4.0000, 12000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108614, 'opt28', 'Gamers set (offgamers.com, G2A.com, seagm.com)', 'XK', 'Total_XK', 4.0000, 12000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108615, 'opt29', 'Telegram', 'XK', 'Kosovo_XK', 7.0000, 21000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108616, 'opt29', 'Telegram', 'XK', 'Total_XK', 7.0000, 21000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108617, 'opt3', 'Parimatch', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108618, 'opt3', 'Parimatch', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108619, 'opt30', 'GrabTaxi', 'XK', 'Kosovo_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108620, 'opt30', 'GrabTaxi', 'XK', 'Total_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108621, 'opt31', 'Drug Vokrug', 'XK', 'Kosovo_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:19'),
(108622, 'opt31', 'Drug Vokrug', 'XK', 'Total_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:19'),
(108623, 'opt32', 'Drom.RU', 'XK', 'Kosovo_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:19'),
(108624, 'opt32', 'Drom.RU', 'XK', 'Total_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:19'),
(108625, 'opt33', 'Mail.RU', 'XK', 'Kosovo_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:19'),
(108626, 'opt33', 'Mail.RU', 'XK', 'Total_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:19'),
(108627, 'opt34', 'Tencent QQ', 'XK', 'Kosovo_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108628, 'opt34', 'Tencent QQ', 'XK', 'Total_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108629, 'opt35', 'GetTaxi', 'XK', 'Kosovo_XK', 0.4000, 1200.00, 999, 0.00, '2026-05-25 01:52:19'),
(108630, 'opt35', 'GetTaxi', 'XK', 'Total_XK', 0.4000, 1200.00, 999, 0.00, '2026-05-25 01:52:19'),
(108631, 'opt37', 'Line Messenger', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108632, 'opt37', 'Line Messenger', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108633, 'opt38', 'Sisal', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108634, 'opt38', 'Sisal', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108635, 'opt39', 'Verse', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108636, 'opt39', 'Verse', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108637, 'opt4', 'Mail.ru Group', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108638, 'opt4', 'Mail.ru Group', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108639, 'opt40', 'Doordash', 'XK', 'Kosovo_XK', 2.0000, 6000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108640, 'opt40', 'Doordash', 'XK', 'Total_XK', 2.0000, 6000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108641, 'opt41', 'X (Twitter)', 'XK', 'Kosovo_XK', 0.7000, 2100.00, 999, 0.00, '2026-05-25 01:52:19'),
(108642, 'opt41', 'X (Twitter)', 'XK', 'Total_XK', 0.7000, 2100.00, 999, 0.00, '2026-05-25 01:52:19'),
(108643, 'opt42', 'LiveScore', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108644, 'opt42', 'LiveScore', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108645, 'opt420', 'Grailed', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108646, 'opt420', 'Grailed', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108647, 'opt43', 'FastMail', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108648, 'opt43', 'FastMail', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108649, 'opt44', 'Amazon', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108650, 'opt44', 'Amazon', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108651, 'opt45', 'Discord', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108652, 'opt45', 'Discord', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108653, 'opt46', 'Airbnb', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108654, 'opt46', 'Airbnb', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108655, 'opt47', 'MoneyLion', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108656, 'opt47', 'MoneyLion', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108657, 'opt48', 'Shopee', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108658, 'opt48', 'Shopee', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108659, 'opt49', 'Skout', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19');
INSERT INTO `smspva_service_cache` (`id`, `service_code`, `service_name`, `country_code`, `operator`, `usd_price`, `ngn_price`, `count_available`, `conversion_rate`, `synced_at`) VALUES
(108660, 'opt49', 'Skout', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108661, 'opt5', 'OD', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108662, 'opt5', 'OD', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108663, 'opt51', 'CONTACT', 'XK', 'Kosovo_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:19'),
(108664, 'opt51', 'CONTACT', 'XK', 'Total_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:19'),
(108665, 'opt52', 'Ticketmaster', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108666, 'opt52', 'Ticketmaster', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108667, 'opt53', 'Deliveroo', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108668, 'opt53', 'Deliveroo', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108669, 'opt54', 'Weebly', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108670, 'opt54', 'Weebly', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108671, 'opt55', 'ifood', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108672, 'opt55', 'ifood', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108673, 'opt56', 'Badoo', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108674, 'opt56', 'Badoo', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108675, 'opt57', 'Proton Mail', 'XK', 'Kosovo_XK', 1.3000, 3900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108676, 'opt57', 'Proton Mail', 'XK', 'Total_XK', 1.3000, 3900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108677, 'opt58', 'Steam', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108678, 'opt58', 'Steam', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108679, 'opt59', 'Avito', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108680, 'opt59', 'Avito', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108681, 'opt6', 'Fiverr', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108682, 'opt6', 'Fiverr', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108683, 'opt60', 'Lazada', 'XK', 'Kosovo_XK', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:19'),
(108684, 'opt60', 'Lazada', 'XK', 'Total_XK', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:19'),
(108685, 'opt61', 'Alibaba (Taobao, 1688.com)', 'XK', 'Kosovo_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108686, 'opt61', 'Alibaba (Taobao, 1688.com)', 'XK', 'Total_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108687, 'opt64', 'OPT64', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108688, 'opt64', 'OPT64', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108689, 'opt65', 'Yahoo', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108690, 'opt65', 'Yahoo', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108691, 'opt66', 'Twilio', 'XK', 'Kosovo_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:19'),
(108692, 'opt66', 'Twilio', 'XK', 'Total_XK', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:19'),
(108693, 'opt67', 'WeChat', 'XK', 'Kosovo_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108694, 'opt67', 'WeChat', 'XK', 'Total_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108695, 'opt68', 'G2A.COM', 'XK', 'Kosovo_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108696, 'opt68', 'G2A.COM', 'XK', 'Total_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108697, 'opt69', 'VK (no guarantee)', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108698, 'opt69', 'VK (no guarantee)', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108699, 'opt7', 'MS Office 365', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108700, 'opt7', 'MS Office 365', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108701, 'opt70', 'OLX + goods.ru', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108702, 'opt70', 'OLX + goods.ru', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108703, 'opt71', 'KakaoTalk', 'XK', 'Kosovo_XK', 2.0000, 6000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108704, 'opt71', 'KakaoTalk', 'XK', 'Total_XK', 2.0000, 6000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108705, 'opt72', 'Uber', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108706, 'opt72', 'Uber', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108707, 'opt73', 'Naver', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108708, 'opt73', 'Naver', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108709, 'opt74', 'Taxi Maksim', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108710, 'opt74', 'Taxi Maksim', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108711, 'opt75', 'Lyft', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108712, 'opt75', 'Lyft', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108713, 'opt76', 'CityMobil', 'XK', 'Kosovo_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108714, 'opt76', 'CityMobil', 'XK', 'Total_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108715, 'opt77', 'Gameflip', 'XK', 'Kosovo_XK', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:19'),
(108716, 'opt77', 'Gameflip', 'XK', 'Total_XK', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:19'),
(108717, 'opt78', 'Blizzard', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108718, 'opt78', 'Blizzard', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108719, 'opt8', 'LinkedIn', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108720, 'opt8', 'LinkedIn', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108721, 'opt80', 'WESTSTEIN', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108722, 'opt80', 'WESTSTEIN', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108723, 'opt81', 'Bolt', 'XK', 'Kosovo_XK', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:19'),
(108724, 'opt81', 'Bolt', 'XK', 'Total_XK', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:19'),
(108725, 'opt82', 'Tango', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108726, 'opt82', 'Tango', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108727, 'opt83', 'PayPal + Ebay', 'XK', 'Kosovo_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108728, 'opt83', 'PayPal + Ebay', 'XK', 'Total_XK', 3.0000, 9000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108729, 'opt84', 'POF.com', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108730, 'opt84', 'POF.com', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108731, 'opt85', 'giocodigitale.it', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108732, 'opt85', 'giocodigitale.it', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108733, 'opt86', 'Adidas & Nike', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108734, 'opt86', 'Adidas & Nike', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108735, 'opt88', 'Yalla.live', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108736, 'opt88', 'Yalla.live', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108737, 'opt89', 'Careem', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108738, 'opt89', 'Careem', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108739, 'opt9', 'Tinder', 'XK', 'Kosovo_XK', 6.0000, 18000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108740, 'opt9', 'Tinder', 'XK', 'Total_XK', 6.0000, 18000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108741, 'opt90', 'Snapchat', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108742, 'opt90', 'Snapchat', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108743, 'opt9001', 'OPT9001', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108744, 'opt9001', 'OPT9001', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108745, 'opt91', 'Wise', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108746, 'opt91', 'Wise', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108747, 'opt92', 'DiDi', 'XK', 'Kosovo_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108748, 'opt92', 'DiDi', 'XK', 'Total_XK', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108749, 'opt93', 'Zoho', 'XK', 'Kosovo_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108750, 'opt93', 'Zoho', 'XK', 'Total_XK', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108751, 'opt94', 'JD.com', 'XK', 'Kosovo_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108752, 'opt94', 'JD.com', 'XK', 'Total_XK', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:19'),
(108753, 'opt95', 'NetBet', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108754, 'opt95', 'NetBet', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108755, 'opt96', 'MiChat', 'XK', 'Kosovo_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108756, 'opt96', 'MiChat', 'XK', 'Total_XK', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:19'),
(108757, 'opt97', 'Kuper (SberMarket)', 'XK', 'Kosovo_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108758, 'opt97', 'Kuper (SberMarket)', 'XK', 'Total_XK', 5.0000, 15000.00, 999, 0.00, '2026-05-25 01:52:19'),
(108759, 'opt98', 'Clubhouse', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108760, 'opt98', 'Clubhouse', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108761, 'opt99', 'KoronaPay', 'XK', 'Kosovo_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108762, 'opt99', 'KoronaPay', 'XK', 'Total_XK', 1.5000, 4500.00, 999, 0.00, '2026-05-25 01:52:19'),
(108763, 'opt0', 'myopinions & erewards', 'YE', 'Total_YE', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:20'),
(108764, 'opt1', 'Google (YouTube, Gmail)', 'YE', 'Total_YE', 0.5500, 1650.00, 999, 0.00, '2026-05-25 01:52:20'),
(108765, 'opt10', 'AOL', 'YE', 'Total_YE', 0.3500, 1050.00, 999, 0.00, '2026-05-25 01:52:20'),
(108766, 'opt100', 'Mamba', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108767, 'opt101', 'Netflix', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108768, 'opt103', 'ICard', 'YE', 'Total_YE', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:20'),
(108769, 'opt104', 'TikTok', 'YE', 'Total_YE', 0.1000, 300.00, 999, 0.00, '2026-05-25 01:52:20'),
(108770, 'opt105', 'LocalBitcoins', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108771, 'opt106', 'Wing Money', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108772, 'opt107', 'Prom.UA', 'YE', 'Total_YE', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:20'),
(108773, 'opt108', 'Glovo & Raketa', 'YE', 'Total_YE', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:20'),
(108774, 'opt109', 'Paddy Power', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108775, 'opt11', 'Viber', 'YE', 'Total_YE', 0.4000, 1200.00, 999, 0.00, '2026-05-25 01:52:20'),
(108776, 'opt110', 'Grindr', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108777, 'opt111', 'IMO', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108778, 'opt112', 'CoinBase', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108779, 'opt113', 'OfferUp', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108780, 'opt114', 'Locanto.com', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108781, 'opt115', 'foodpanda', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108782, 'opt116', 'Neteller', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108783, 'opt117', 'Skrill', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108784, 'opt118', 'Inboxdollars', 'YE', 'Total_YE', 0.2500, 750.00, 999, 0.00, '2026-05-25 01:52:20'),
(108785, 'opt119', 'Nico', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108786, 'opt12', 'OPT12', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108787, 'opt120', 'Hinge', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108788, 'opt121', 'Monese', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108789, 'opt122', 'Paysafecard', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108790, 'opt123', 'Whoosh', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108791, 'opt124', 'Credit Karma', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108792, 'opt125', 'Swagbucks', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108793, 'opt126', 'Magnit', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108794, 'opt127', 'Signal', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108795, 'opt129', 'kwiff.com', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108796, 'opt13', 'Fotostrana', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108797, 'opt130', 'Vinted', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108798, 'opt131', 'Apple', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108799, 'opt132', '1 OpenAI API (chatGPT, DALL-e 2)', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108800, 'opt133', 'Revolut', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108801, 'opt134', 'Schibsted-konto', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108802, 'opt135', 'blsspain-russia.com', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:20'),
(108803, 'opt136', 'dundle', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108804, 'opt137', 'bwin', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108805, 'opt138', 'Bazos.sk', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108806, 'opt139', 'fontbet', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108807, 'opt140', 'Google Voice', 'YE', 'Total_YE', 0.5500, 1650.00, 999, 0.00, '2026-05-25 01:52:21'),
(108808, 'opt141', 'EUROBET', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108809, 'opt142', 'funpay', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108810, 'opt143', 'autocosmos.com', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108811, 'opt144', 'hopper', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108812, 'opt145', 'bumble', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108813, 'opt146', 'subito.it', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108814, 'opt147', 'VooV Meeting', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108815, 'opt148', 'casa.it', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108816, 'opt149', 'pm.by', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108817, 'opt15', 'Microsoft (Azure, Bing, Skype, etc)', 'YE', 'Total_YE', 0.5500, 1650.00, 999, 0.00, '2026-05-25 01:52:21'),
(108818, 'opt150', 'Czech email services', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108819, 'opt151', 'novibet.com', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108820, 'opt152', 'kleinanzeigen.de', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108821, 'opt153', 'ROOMSTER', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108822, 'opt154', 'Rambler.ru', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108823, 'opt155', 'Happn', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108824, 'opt156', 'mobileDE', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108825, 'opt157', 'CupidMedia', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108826, 'opt158', 'Zalo', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108827, 'opt159', 'Feeld', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108828, 'opt16', 'Instagram (+Threads)', 'YE', 'Total_YE', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:21'),
(108829, 'opt160', 'U By Prodia', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108830, 'opt161', 'TANK.RU', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108831, 'opt162', 'Payoneer', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108832, 'opt163', 'Wolt', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108833, 'opt164', 'Leboncoin', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108834, 'opt165', 'idealista.com', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108835, 'opt166', 'HUAWEI', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108836, 'opt167', 'inbox.lv', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108837, 'opt169', 'Pari.ru', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108838, 'opt17', 'bet365', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108839, 'opt170', 'Royal Canin', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108840, 'opt171', 'Marktplaats', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108841, 'opt172', 'WEB.DE', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108842, 'opt173', 'X World Wallet', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108843, 'opt174', 'Samsung', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108844, 'opt175', 'Klarna', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108845, 'opt176', 'ChoTot', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108846, 'opt177', 'NHNcorp (강남언니)', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108847, 'opt178', 'VonageVF', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108848, 'opt179', 'GetsBet.ro', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108849, 'opt18', 'Qiwi', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108850, 'opt180', 'Lalamove', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108851, 'opt181', 'OZON.ru', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108852, 'opt182', 'LAPOSTE', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108853, 'opt183', 'PAYSEND', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108854, 'opt184', 'MOMO', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108855, 'opt185', 'Samokat', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108856, 'opt186', 'RusDate', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108857, 'opt187', 'Beget.com', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108858, 'opt188', 'GGbet', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108859, 'opt189', 'foodora', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108860, 'opt19', 'OTHER (no guarantee)', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108861, 'opt190', 'SNKRDUNK', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108862, 'opt191', 'TopCashback', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108863, 'opt192', 'Betano (+BETANO.ro)', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108864, 'opt193', 'Ipsos', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108865, 'opt194', 'ZoomInfo', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108866, 'opt195', 'Lajumate.ro', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108867, 'opt196', 'Claude (Anthropic)', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108868, 'opt197', 'MPSellers', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108869, 'opt198', 'Nectar', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108870, 'opt199', 'bunq', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108871, 'opt2', 'Facebook', 'YE', 'Total_YE', 0.4000, 1200.00, 999, 0.00, '2026-05-25 01:52:21'),
(108872, 'opt20', 'WhatsAPP', 'YE', 'Total_YE', 0.7500, 2250.00, 999, 0.00, '2026-05-25 01:52:21'),
(108873, 'opt200', 'ENEBA', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108874, 'opt201', 'Casino Plus', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108875, 'opt202', 'NHNCloud', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108876, 'opt203', 'HelloTalk', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108877, 'opt204', 'DenimApp', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108878, 'opt205', 'Twitch', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108879, 'opt206', 'WalletHub', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108880, 'opt207', 'Publi24', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108881, 'opt208', 'WooPlus', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108882, 'opt209', 'BANDUS', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108883, 'opt21', 'EasyPay', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108884, 'opt211', 'MrGreen', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108885, 'opt212', 'OurTime', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108886, 'opt213', 'Waitomo', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108887, 'opt214', 'Cashrewards', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108888, 'opt215', 'Fbet', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108889, 'opt216', 'Hey', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108890, 'opt217', 'Brevo', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108891, 'opt218', 'TransferGo', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108892, 'opt219', 'maxline.by', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108893, 'opt22', '888casino', 'YE', 'Total_YE', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:21'),
(108894, 'opt220', 'TOTOGAMING', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108895, 'opt221', 'Fortuna', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108896, 'opt222', 'LASVEGAS.RO', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108897, 'opt223', 'Betmgm', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108898, 'opt224', '22bet', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108899, 'opt225', 'Zasilkovna', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108900, 'opt226', 'Cash App', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108901, 'opt227', 'Walmart', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108902, 'opt228', 'OKX', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108903, 'opt229', 'GGPokerUK', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108904, 'opt23', 'Yandex&YooMoney', 'YE', 'Total_YE', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:21'),
(108905, 'opt230', 'OkCupid', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108906, 'opt231', 'Whatnot', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108907, 'opt232', 'DistroKid', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108908, 'opt233', 'TrueCaller', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108909, 'opt234', 'Solitaire Cash', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108910, 'opt235', 'TLScontact', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108911, 'opt236', 'Year13', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108912, 'opt237', 'Bitpanda', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108913, 'opt238', 'hepsiburada', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108914, 'opt239', 'Taptap', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108915, 'opt24', 'WebMoney&ENUM', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108916, 'opt240', 'goldbet.it', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108917, 'opt241', 'onet.pl (Onet Konto)', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108918, 'opt242', 'Abbott', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108919, 'opt243', 'IQOS', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108920, 'opt244', 'Truth Social', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108921, 'opt245', 'Linode', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108922, 'opt246', 'Outlier', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108923, 'opt247', 'RadQuest', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108924, 'opt248', 'ESX (abonamentesali.ro)', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108925, 'opt249', 'Superbet', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108926, 'opt25', 'BetFair', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108927, 'opt250', 'Match', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108928, 'opt251', '1cupis.ru', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108929, 'opt252', 'Best Buy', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108930, 'opt253', 'Zoosk', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108931, 'opt254', 'Monster Energy', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108932, 'opt255', 'Casa Pariurilor', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108933, 'opt256', 'Astropay', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108934, 'opt257', 'Remitly', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108935, 'opt258', 'SumUp', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108936, 'opt259', 'Google Messenger', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108937, 'opt26', 'Craigslist', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108938, 'opt260', 'Parions Sport', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108939, 'opt261', 'Welo Data', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108940, 'opt262', 'BC GAME', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108941, 'opt263', 'Profee.com', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108942, 'opt264', 'Toloka.ai', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108943, 'opt265', 'Reddit', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108944, 'opt266', 'Capital One Shopping', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108945, 'opt267', 'Caliente', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108946, 'opt268', 'Pokémon(ポケモンセンターオンライン)', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108947, 'opt269', 'Neosurf', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108948, 'opt27', 'Dodopizza + PapaJohns', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108949, 'opt270', 'Skelbiu', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108950, 'opt271', 'Google Chat', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108951, 'opt272', 'American Airlines', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108952, 'opt28', 'Gamers set (offgamers.com, G2A.com, seagm.com)', 'YE', 'Total_YE', 0.8000, 2400.00, 999, 0.00, '2026-05-25 01:52:21'),
(108953, 'opt29', 'Telegram', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108954, 'opt3', 'Parimatch', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108955, 'opt30', 'GrabTaxi', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108956, 'opt31', 'Drug Vokrug', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108957, 'opt32', 'Drom.RU', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108958, 'opt33', 'Mail.RU', 'YE', 'Total_YE', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:21'),
(108959, 'opt34', 'Tencent QQ', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108960, 'opt35', 'GetTaxi', 'YE', 'Total_YE', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:21'),
(108961, 'opt36', 'OPT36', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108962, 'opt37', 'Line Messenger', 'YE', 'Total_YE', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:21'),
(108963, 'opt38', 'Sisal', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108964, 'opt39', 'Verse', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108965, 'opt4', 'Mail.ru Group', 'YE', 'Total_YE', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:21'),
(108966, 'opt40', 'Doordash', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108967, 'opt41', 'X (Twitter)', 'YE', 'Total_YE', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:21'),
(108968, 'opt42', 'LiveScore', 'YE', 'Total_YE', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:21'),
(108969, 'opt420', 'Grailed', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108970, 'opt43', 'FastMail', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108971, 'opt44', 'Amazon', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108972, 'opt45', 'Discord', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108973, 'opt46', 'Airbnb', 'YE', 'Total_YE', 0.3500, 1050.00, 999, 0.00, '2026-05-25 01:52:21'),
(108974, 'opt47', 'MoneyLion', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108975, 'opt48', 'Shopee', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108976, 'opt49', 'Skout', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108977, 'opt5', 'OD', 'YE', 'Total_YE', 0.4000, 1200.00, 999, 0.00, '2026-05-25 01:52:21'),
(108978, 'opt50', 'OPT50', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108979, 'opt51', 'CONTACT', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108980, 'opt52', 'Ticketmaster', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108981, 'opt53', 'Deliveroo', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108982, 'opt54', 'Weebly', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108983, 'opt55', 'ifood', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108984, 'opt56', 'Badoo', 'YE', 'Total_YE', 0.4000, 1200.00, 999, 0.00, '2026-05-25 01:52:21'),
(108985, 'opt57', 'Proton Mail', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108986, 'opt58', 'Steam', 'YE', 'Total_YE', 0.3000, 900.00, 999, 0.00, '2026-05-25 01:52:21'),
(108987, 'opt59', 'Avito', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108988, 'opt6', 'Fiverr', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108989, 'opt60', 'Lazada', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108990, 'opt61', 'Alibaba (Taobao, 1688.com)', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108991, 'opt62', 'OPT62', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108992, 'opt63', 'OPT63', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108993, 'opt64', 'OPT64', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108994, 'opt65', 'Yahoo', 'YE', 'Total_YE', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:21'),
(108995, 'opt66', 'Twilio', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108996, 'opt67', 'WeChat', 'YE', 'Total_YE', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:21'),
(108997, 'opt68', 'G2A.COM', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(108998, 'opt69', 'VK (no guarantee)', 'YE', 'Total_YE', 0.5000, 1500.00, 999, 0.00, '2026-05-25 01:52:21'),
(108999, 'opt7', 'MS Office 365', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109000, 'opt70', 'OLX + goods.ru', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109001, 'opt71', 'KakaoTalk', 'YE', 'Total_YE', 1.1000, 3300.00, 999, 0.00, '2026-05-25 01:52:21'),
(109002, 'opt72', 'Uber', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109003, 'opt73', 'Naver', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109004, 'opt74', 'Taxi Maksim', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109005, 'opt75', 'Lyft', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109006, 'opt76', 'CityMobil', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109007, 'opt77', 'Gameflip', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109008, 'opt78', 'Blizzard', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109009, 'opt79', 'OPT79', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109010, 'opt8', 'LinkedIn', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109011, 'opt80', 'WESTSTEIN', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109012, 'opt81', 'Bolt', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109013, 'opt82', 'Tango', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:21'),
(109014, 'opt83', 'PayPal + Ebay', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109015, 'opt84', 'POF.com', 'YE', 'Total_YE', 0.2000, 600.00, 999, 0.00, '2026-05-25 01:52:22'),
(109016, 'opt85', 'giocodigitale.it', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109017, 'opt86', 'Adidas & Nike', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109018, 'opt87', 'OPT87', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109019, 'opt88', 'Yalla.live', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109020, 'opt89', 'Careem', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109021, 'opt9', 'Tinder', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109022, 'opt90', 'Snapchat', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109023, 'opt9001', 'OPT9001', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109024, 'opt91', 'Wise', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109025, 'opt92', 'DiDi', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109026, 'opt93', 'Zoho', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109027, 'opt94', 'JD.com', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109028, 'opt95', 'NetBet', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109029, 'opt96', 'MiChat', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109030, 'opt97', 'Kuper (SberMarket)', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109031, 'opt98', 'Clubhouse', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22'),
(109032, 'opt99', 'KoronaPay', 'YE', 'Total_YE', 1.0000, 3000.00, 999, 0.00, '2026-05-25 01:52:22');

-- --------------------------------------------------------

--
-- Table structure for table `sm_categories`
--

CREATE TABLE `sm_categories` (
  `id` int(11) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_image` varchar(500) DEFAULT NULL,
  `status` enum('1','0') DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sm_categories`
--

INSERT INTO `sm_categories` (`id`, `category_name`, `category_image`, `status`, `created_at`) VALUES
(1, 'Facebook', 'https://cdn-icons-png.flaticon.com/512/124/124010.png', '1', '2025-11-18 00:44:47'),
(2, 'Instagram', 'https://cdn-icons-png.flaticon.com/512/174/174855.png', '1', '2025-11-18 00:45:27'),
(3, 'Twitter/X', 'https://cdn-icons-png.flaticon.com/512/733/733579.png', '1', '2025-11-18 00:45:58'),
(4, 'TikTok', 'https://cdn-icons-png.flaticon.com/512/3046/3046121.png', '1', '2025-11-18 00:46:31'),
(5, 'LinkedIn', 'https://cdn-icons-png.flaticon.com/512/174/174857.png', '1', '2025-11-18 00:47:02');

-- --------------------------------------------------------

--
-- Table structure for table `sm_purchases`
--

CREATE TABLE `sm_purchases` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `service_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `purchase_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` enum('completed','cancelled','refund_pending','refunded') DEFAULT 'completed',
  `refund_reason` text DEFAULT NULL,
  `refund_date` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'User who made the transaction',
  `transaction_ref` varchar(255) NOT NULL COMMENT 'Unique transaction reference',
  `payment_gateway` varchar(50) NOT NULL COMMENT 'Payment gateway used (paystack, etc)',
  `transaction_type` enum('deposit','number_purchase','social_boost','logs_purchase','refund') NOT NULL DEFAULT 'deposit' COMMENT 'Type of transaction: deposit | number_purchase | social_boost | logs_purchase | refund',
  `amount` decimal(10,2) NOT NULL COMMENT 'Transaction amount',
  `currency` varchar(10) DEFAULT 'NGN' COMMENT 'Currency code',
  `status` enum('pending','successful','failed','cancelled') DEFAULT 'pending' COMMENT 'Transaction status',
  `payment_method` varchar(50) DEFAULT NULL COMMENT 'Payment method (card, bank_transfer, ussd)',
  `gateway_reference` varchar(255) DEFAULT NULL COMMENT 'Gateway transaction reference',
  `gateway_response` text DEFAULT NULL COMMENT 'Full gateway response JSON',
  `metadata` text DEFAULT NULL COMMENT 'Additional transaction metadata',
  `ip_address` varchar(45) DEFAULT NULL COMMENT 'User IP address',
  `is_first_deposit` tinyint(1) DEFAULT 0 COMMENT 'Is this the first deposit for the user',
  `referral_awarded` tinyint(1) DEFAULT 0 COMMENT 'Has referral bonus been awarded',
  `created_at` timestamp NULL DEFAULT current_timestamp() COMMENT 'Transaction creation time',
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Last update time'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `user_id`, `transaction_ref`, `payment_gateway`, `transaction_type`, `amount`, `currency`, `status`, `payment_method`, `gateway_reference`, `gateway_response`, `metadata`, `ip_address`, `is_first_deposit`, `referral_awarded`, `created_at`, `updated_at`) VALUES
(9, 340, 'TXN_6A11840F097D6_1779532815', 'paystack', 'deposit', 150000.00, 'NGN', 'successful', 'card', 'TXN_6A11840F097D6_1779532815', '{\"status\":true,\"message\":\"Verification successful\",\"data\":{\"id\":6177171996,\"domain\":\"test\",\"status\":\"success\",\"reference\":\"TXN_6A11840F097D6_1779532815\",\"receipt_number\":null,\"amount\":15000000,\"message\":null,\"gateway_response\":\"Successful\",\"response_code\":\"00\",\"paid_at\":\"2026-05-23T10:40:28.000Z\",\"created_at\":\"2026-05-23T10:40:22.000Z\",\"channel\":\"card\",\"currency\":\"NGN\",\"ip_address\":\"105.113.112.43\",\"metadata\":{\"custom_fields\":[{\"display_name\":\"User ID\",\"variable_name\":\"user_id\",\"value\":\"340\"}],\"referrer\":\"http://localhost/llcpro/jediprime/jediprime/faq/user/fund-wallet\"},\"log\":{\"start_time\":1779532823,\"time_spent\":6,\"attempts\":1,\"errors\":0,\"success\":true,\"mobile\":false,\"input\":[],\"history\":[{\"type\":\"action\",\"message\":\"Attempted to pay with card\",\"time\":4},{\"type\":\"success\",\"message\":\"Successfully paid with card\",\"time\":6}]},\"fees\":200000,\"fees_split\":null,\"authorization\":{\"authorization_code\":\"AUTH_5eswjl8xmz\",\"bin\":\"408408\",\"last4\":\"4081\",\"exp_month\":\"12\",\"exp_year\":\"2030\",\"channel\":\"card\",\"card_type\":\"visa \",\"bank\":\"TEST BANK\",\"country_code\":\"NG\",\"brand\":\"visa\",\"reusable\":true,\"signature\":\"SIG_DFi0QSofNbEQEVo6NJHB\",\"account_name\":null,\"receiver_bank_account_number\":null,\"receiver_bank\":null},\"customer\":{\"id\":365485655,\"first_name\":\"\",\"last_name\":\"\",\"email\":\"elitefxt3@gmail.com\",\"customer_code\":\"CUS_pwqd0b7bafxxp0v\",\"phone\":\"\",\"metadata\":null,\"risk_action\":\"default\",\"international_format_phone\":null},\"plan\":null,\"split\":{},\"order_id\":null,\"paidAt\":\"2026-05-23T10:40:28.000Z\",\"createdAt\":\"2026-05-23T10:40:22.000Z\",\"requested_amount\":15000000,\"pos_transaction_data\":null,\"source\":null,\"fees_breakdown\":null,\"connect\":null,\"transaction_date\":\"2026-05-23T10:40:22.000Z\",\"plan_object\":{},\"subaccount\":{}}}', NULL, '::1', 1, 0, '2026-05-23 10:40:15', '2026-05-23 10:40:37'),
(10, 340, 'FS_C6858476C205', '5sim', 'number_purchase', 1995.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"1kkirana\",\"country\":\"Austria\",\"phone\":\"+4367870320054\",\"order_id5\":1014712241}', NULL, 0, 0, '2026-05-23 12:04:07', '2026-05-23 12:04:07'),
(11, 340, 'FS_905429474776', '5sim', 'number_purchase', 1155.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"amazon\",\"country\":\"Bangladesh\",\"phone\":\"+8801356012096\",\"order_id5\":1014731253}', NULL, 0, 0, '2026-05-23 12:37:50', '2026-05-23 12:37:50'),
(12, 340, 'FSREF_83CE07E008', '5sim', 'refund', 1155.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"5SIM number cancelled\",\"order_id5\":1014731253}', NULL, 0, 0, '2026-05-23 12:38:04', '2026-05-23 12:38:04'),
(13, 340, 'SB_9CC84C69FB9A', 'smsbus', 'number_purchase', 3240.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Indonesia\",\"phone\":\"6287741823938\",\"request_id\":9223372036854775807}', NULL, 0, 0, '2026-05-24 04:22:21', '2026-05-24 04:22:21'),
(14, 340, 'SBAUTO_3898E5EF', 'smsbus', 'refund', 3240.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"SMS-Bus auto-refund: expired\",\"request_id\":2147483647}', NULL, 0, 0, '2026-05-24 04:42:26', '2026-05-24 04:42:26'),
(15, 340, 'SB_6A3D4B9DF9D5', 'smsbus', 'number_purchase', 6120.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Canada\",\"phone\":\"13434742750\",\"request_id\":\"260524130430955777536\"}', NULL, 0, 0, '2026-05-24 05:04:30', '2026-05-24 05:04:30'),
(16, 340, 'SBREF_C9FD4F647E', 'smsbus', 'refund', 6120.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"SMS-Bus number cancelled\",\"request_id\":\"260524130430955777536\"}', NULL, 0, 0, '2026-05-24 05:07:43', '2026-05-24 05:07:43'),
(17, 340, 'FS_767F8AE15AE8', '5sim', 'number_purchase', 3135.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"1kkirana\",\"country\":\"Austria\",\"phone\":\"+4367858108709\",\"order_id5\":1015123130}', NULL, 0, 0, '2026-05-24 05:39:53', '2026-05-24 05:39:53'),
(18, 340, 'FSREF_62C053DAE6', '5sim', 'refund', 3135.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"5SIM number cancelled\",\"order_id5\":1015123130}', NULL, 0, 0, '2026-05-24 05:40:23', '2026-05-24 05:40:23'),
(19, 340, 'FS_B4FB1DF3DEB5', 'virtual_number', 'number_purchase', 2145.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"activision\",\"country\":\"Canada\",\"phone\":\"+13655304823\",\"order_id5\":1015126156}', NULL, 0, 0, '2026-05-24 05:50:23', '2026-05-24 05:50:23'),
(20, 340, 'FSREF_93F29129D5', 'virtual_number', 'refund', 2145.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"order_id5\":1015126156}', NULL, 0, 0, '2026-05-24 05:50:27', '2026-05-24 05:50:27'),
(21, 340, 'TXN_6A1295636BFA1_1779602787', 'paystack', 'deposit', 500.00, 'NGN', 'pending', NULL, NULL, NULL, NULL, '::1', 0, 0, '2026-05-24 06:06:27', '2026-05-24 06:06:27'),
(22, 340, 'SB_2851ADA2A44D', 'virtual_number', 'number_purchase', 6120.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Canada\",\"phone\":\"13434742608\",\"request_id\":\"260524145945958222336\"}', NULL, 0, 0, '2026-05-24 06:59:45', '2026-05-24 06:59:45'),
(23, 341, 'TXN_6A12ED0C45235_1779625228', 'paystack', 'deposit', 10000.00, 'NGN', 'pending', NULL, NULL, NULL, NULL, '105.127.14.101', 1, 0, '2026-05-24 12:20:28', '2026-05-24 12:20:28'),
(24, 340, 'TXN_6A130200C0D5E_1779630592', 'paystack', 'deposit', 1000.00, 'NGN', 'pending', NULL, NULL, NULL, NULL, '102.90.116.233', 0, 0, '2026-05-24 13:49:52', '2026-05-24 13:49:52'),
(25, 340, 'SB_29A0F2D919E0', 'virtual_number', 'number_purchase', 4320.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Cambodia\",\"phone\":\"855974624279\",\"request_id\":\"260524215124950751872\"}', NULL, 0, 0, '2026-05-24 13:51:24', '2026-05-24 13:51:24'),
(26, 340, 'SBREF_FBC117D55F', 'virtual_number', 'refund', 4320.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260524215124950751872\"}', NULL, 0, 0, '2026-05-24 14:22:33', '2026-05-24 14:22:33'),
(27, 340, 'SB_5637292C9E60', 'virtual_number', 'number_purchase', 6120.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Canada\",\"phone\":\"17788502346\",\"request_id\":\"260524225705952179712\"}', NULL, 0, 0, '2026-05-24 14:57:05', '2026-05-24 14:57:05'),
(28, 340, 'FS_379A78EF81CD', 'virtual_number', 'number_purchase', 4290.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"alipay\",\"country\":\"Australia\",\"phone\":\"+61489935443\",\"order_id5\":1015430236}', NULL, 0, 0, '2026-05-24 16:05:27', '2026-05-24 16:05:27'),
(29, 340, 'FSAUTO_3DAABFB7', 'virtual_number', 'refund', 4290.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"order_id5\":1015430236}', NULL, 0, 0, '2026-05-24 16:17:47', '2026-05-24 16:17:47'),
(30, 340, 'FS_106C4E76B8B7', 'virtual_number', 'number_purchase', 2640.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"algida\",\"country\":\"Australia\",\"phone\":\"+61468113295\",\"order_id5\":1015438279}', NULL, 0, 0, '2026-05-24 16:18:09', '2026-05-24 16:18:09'),
(31, 340, 'FSAUTO_9FD43816', 'virtual_number', 'refund', 2640.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"order_id5\":1015438279}', NULL, 0, 0, '2026-05-24 16:23:14', '2026-05-24 16:23:14'),
(32, 340, 'FS_907C16764C6A', 'virtual_number', 'number_purchase', 3465.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"1688\",\"country\":\"Austria\",\"phone\":\"+4367858106102\",\"order_id5\":1015449638}', NULL, 0, 0, '2026-05-24 16:35:22', '2026-05-24 16:35:22'),
(33, 340, 'FS_1C8C398EF284', 'virtual_number', 'number_purchase', 3135.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"1kkirana\",\"country\":\"Austria\",\"phone\":\"+4367858108709\",\"order_id5\":1015463344}', NULL, 0, 0, '2026-05-24 16:58:07', '2026-05-24 16:58:07'),
(34, 340, 'FS_E6E647539E2A', 'virtual_number', 'number_purchase', 3465.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"1688\",\"country\":\"Austria\",\"phone\":\"+4369020080535\",\"order_id5\":1015466098}', NULL, 0, 0, '2026-05-24 17:03:05', '2026-05-24 17:03:05'),
(35, 340, 'FSAUTO_0736255C', 'virtual_number', 'refund', 3135.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"order_id5\":1015463344}', NULL, 0, 0, '2026-05-24 17:03:09', '2026-05-24 17:03:09'),
(36, 340, 'FS_3249F63BD7BA', 'virtual_number', 'number_purchase', 3135.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"1kkirana\",\"country\":\"Austria\",\"phone\":\"+4369020080535\",\"order_id5\":1015481882}', NULL, 0, 0, '2026-05-24 17:37:04', '2026-05-24 17:37:04'),
(37, 340, 'FSAUTO_917B9F41', 'virtual_number', 'refund', 3135.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"order_id5\":1015481882}', NULL, 0, 0, '2026-05-24 17:42:07', '2026-05-24 17:42:07'),
(38, 340, 'FS_E8F971CA5C34', 'virtual_number', 'number_purchase', 3465.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"1688\",\"country\":\"Austria\",\"phone\":\"+4367870348926\",\"order_id5\":1015484574}', NULL, 0, 0, '2026-05-24 17:42:25', '2026-05-24 17:42:25'),
(39, 340, 'FS_5CA09D64546C', 'virtual_number', 'number_purchase', 3465.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"1688\",\"country\":\"Austria\",\"phone\":\"+4367870353839\",\"order_id5\":1015490621}', NULL, 0, 0, '2026-05-24 17:55:32', '2026-05-24 17:55:32'),
(40, 340, 'FS_EA77E1ABA120', 'virtual_number', 'number_purchase', 3465.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"1688\",\"country\":\"Austria\",\"phone\":\"+4367870379215\",\"order_id5\":1015492601}', NULL, 0, 0, '2026-05-24 17:59:54', '2026-05-24 17:59:54'),
(41, 345, 'TXN_6A133D4EAD161_1779645774', 'paystack', 'deposit', 3500.00, 'NGN', 'successful', 'bank_transfer', 'TXN_6A133D4EAD161_1779645774', '{\"status\":true,\"message\":\"Verification successful\",\"data\":{\"id\":6182169369,\"domain\":\"live\",\"status\":\"success\",\"reference\":\"TXN_6A133D4EAD161_1779645774\",\"receipt_number\":null,\"amount\":350000,\"message\":null,\"gateway_response\":\"Approved\",\"response_code\":null,\"paid_at\":\"2026-05-24T18:04:04.000Z\",\"created_at\":\"2026-05-24T18:02:57.000Z\",\"channel\":\"bank_transfer\",\"currency\":\"NGN\",\"ip_address\":\"102.90.79.170\",\"metadata\":{\"custom_fields\":[{\"display_name\":\"User ID\",\"variable_name\":\"user_id\",\"value\":\"345\"}],\"referrer\":\"https://smspride.cfd/user/fund-wallet\"},\"log\":{\"start_time\":1779645777,\"time_spent\":67,\"attempts\":0,\"errors\":0,\"success\":true,\"mobile\":true,\"input\":[],\"history\":[{\"type\":\"action\",\"message\":\"Set payment method to: bank_transfer\",\"time\":2},{\"type\":\"success\",\"message\":\"Successfully paid with bank_transfer\",\"time\":67}]},\"fees\":15250,\"fees_split\":null,\"authorization\":{\"authorization_code\":\"AUTH_ol5mnymdw3\",\"bin\":\"004XXX\",\"last4\":\"X557\",\"exp_month\":\"05\",\"exp_year\":\"2026\",\"channel\":\"bank_transfer\",\"card_type\":\"transfer\",\"bank\":\"Stanbic IBTC Bank\",\"country_code\":\"NG\",\"brand\":\"Managed Account\",\"reusable\":false,\"signature\":null,\"account_name\":null,\"sender_bank\":\"Stanbic IBTC Bank\",\"sender_country\":\"NG\",\"sender_bank_account_number\":\"XXXXXXX557\",\"sender_name\":\"THANKGOD AZIBAGIRI STEPHEN\",\"narration\":\"good\",\"receiver_bank_account_number\":null,\"receiver_bank\":null},\"customer\":{\"id\":367554742,\"first_name\":\"\",\"last_name\":\"\",\"email\":\"beckyjennifer07@gmail.com\",\"customer_code\":\"CUS_2qvxi4qnenck9lw\",\"phone\":\"\",\"metadata\":null,\"risk_action\":\"default\",\"international_format_phone\":null},\"plan\":null,\"split\":{},\"order_id\":null,\"paidAt\":\"2026-05-24T18:04:04.000Z\",\"createdAt\":\"2026-05-24T18:02:57.000Z\",\"requested_amount\":350000,\"pos_transaction_data\":null,\"source\":null,\"fees_breakdown\":[{\"amount\":15250,\"formula\":null,\"type\":\"paystack\"}],\"connect\":null,\"transaction_date\":\"2026-05-24T18:02:57.000Z\",\"plan_object\":{},\"subaccount\":{}}}', NULL, '102.90.79.170', 1, 0, '2026-05-24 18:02:54', '2026-05-24 18:04:07'),
(42, 340, 'SB_8E4E3AAB5626', 'virtual_number', 'number_purchase', 8100.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447529433745\",\"request_id\":\"260525020944957921408\"}', NULL, 0, 0, '2026-05-24 18:09:44', '2026-05-24 18:09:44'),
(43, 340, 'FSAUTO_9B9440DD', 'virtual_number', 'refund', 3465.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"order_id5\":1015490621}', NULL, 0, 0, '2026-05-24 18:10:32', '2026-05-24 18:10:32'),
(44, 340, 'SBREF_A8E1D1BADA', 'virtual_number', 'refund', 8100.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260525020944957921408\"}', NULL, 0, 0, '2026-05-24 18:10:39', '2026-05-24 18:10:39'),
(45, 340, 'FSAUTO_6494B265', 'virtual_number', 'refund', 3465.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"order_id5\":1015492601}', NULL, 0, 0, '2026-05-24 18:14:54', '2026-05-24 18:14:54'),
(46, 340, 'SB_47FD622A7B45', 'virtual_number', 'number_purchase', 8100.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447529518320\",\"request_id\":\"260525021912953061888\"}', NULL, 0, 0, '2026-05-24 18:19:12', '2026-05-24 18:19:12'),
(47, 340, 'SB_18BD6BB33F9C', 'virtual_number', 'number_purchase', 4320.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United States (Virtual)\",\"phone\":\"19207688298\",\"request_id\":\"260525093901952722176\"}', NULL, 0, 0, '2026-05-25 01:39:01', '2026-05-25 01:39:01'),
(48, 340, 'SBAUTO_A7F704C7', 'virtual_number', 'refund', 4320.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"request_id\":\"260525093901952722176\"}', NULL, 0, 0, '2026-05-25 01:49:22', '2026-05-25 01:49:22'),
(49, 340, 'WDR_6A15D8AFE5BB1_1779816623', 'paystack_transfer', '', 150.00, 'NGN', 'pending', 'bank_transfer', 'TRF_dz6kl13klj2ui94q', NULL, '{\"bank\":\"999991\",\"account\":\"7039416531\",\"name\":\"JULIUS ECHELEBOR EBIEH\",\"fee\":209}', NULL, 0, 0, '2026-05-26 17:30:25', '2026-05-26 17:30:25'),
(50, 340, 'WDR_6A15D9EDB12FB_1779816941', 'paystack_transfer', '', 150.00, 'NGN', 'pending', 'bank_transfer', 'TRF_7oolv04jhwv1eqaf', NULL, '{\"bank\":\"999991\",\"account\":\"7039416531\",\"name\":\"JULIUS ECHELEBOR EBIEH\",\"fee\":209}', NULL, 0, 0, '2026-05-26 17:35:42', '2026-05-26 17:35:42'),
(51, 340, 'FS_8D1CC54A5044', 'virtual_number', 'number_purchase', 4290.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"alipay\",\"country\":\"Australia\",\"phone\":\"+61489939613\",\"order_id5\":1024055505}', NULL, 0, 0, '2026-06-05 10:41:22', '2026-06-05 10:41:22'),
(52, 340, 'FSREF_F1D236763D', 'virtual_number', 'refund', 4290.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"order_id5\":1024055505}', NULL, 0, 0, '2026-06-05 10:41:27', '2026-06-05 10:41:27'),
(53, 340, 'FS_615CF8907AE1', 'virtual_number', 'number_purchase', 1155.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"product\":\"whatnot\",\"country\":\"USA\",\"phone\":\"+16293234622\",\"order_id5\":1024058536}', NULL, 0, 0, '2026-06-05 10:44:01', '2026-06-05 10:44:01'),
(54, 340, 'FSREF_332CB650F2', 'virtual_number', 'refund', 1155.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"order_id5\":1024058536}', NULL, 0, 0, '2026-06-05 10:44:12', '2026-06-05 10:44:12'),
(55, 340, 'SB_0FAEF817101E', 'virtual_number', 'number_purchase', 3255.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Nigeria\",\"phone\":\"2348038347584\",\"request_id\":\"260605184431958432768\"}', NULL, 0, 0, '2026-06-05 10:44:32', '2026-06-05 10:44:32'),
(56, 340, 'SBREF_FFC2FE1A28', 'virtual_number', 'refund', 3255.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260605184431958432768\"}', NULL, 0, 0, '2026-06-05 10:44:42', '2026-06-05 10:44:42'),
(57, 340, 'SB_7A7DAC5417BE', 'virtual_number', 'number_purchase', 3255.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Nigeria\",\"phone\":\"2348036903767\",\"request_id\":\"260605184455955755392\"}', NULL, 0, 0, '2026-06-05 10:44:56', '2026-06-05 10:44:56'),
(58, 340, 'SBREF_9079F17AF7', 'virtual_number', 'refund', 3255.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260605184455955755392\"}', NULL, 0, 0, '2026-06-05 10:45:04', '2026-06-05 10:45:04'),
(59, 340, 'SB_FCA4BE2C53A4', 'virtual_number', 'number_purchase', 5460.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"1xbet\",\"country\":\"Austria\",\"phone\":\"436767207405\",\"request_id\":\"260605212033956269440\"}', NULL, 0, 0, '2026-06-05 13:20:33', '2026-06-05 13:20:33'),
(60, 340, 'SBREF_0BA6C9CDAC', 'virtual_number', 'refund', 5460.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260605212033956269440\"}', NULL, 0, 0, '2026-06-05 13:20:39', '2026-06-05 13:20:39'),
(61, 513, 'PDVA_6A22D492EED72_1780667538', 'paystack_dva', 'deposit', 200.00, 'NGN', 'successful', 'bank_transfer', '100033260605135210839676041869', '{\"event\":\"charge.success\",\"data\":{\"id\":6226019922,\"domain\":\"live\",\"status\":\"success\",\"reference\":\"100033260605135210839676041869\",\"amount\":20000,\"message\":null,\"gateway_response\":\"Approved\",\"paid_at\":\"2026-06-05T13:52:18.000Z\",\"created_at\":\"2026-06-05T13:52:18.000Z\",\"channel\":\"dedicated_nuban\",\"currency\":\"NGN\",\"ip_address\":null,\"metadata\":{\"receiver_account_number\":\"9813639135\",\"receiver_bank\":\"Wema Bank\",\"receiver_account_type\":null,\"custom_fields\":[{\"display_name\":\"Receiver Account\",\"variable_name\":\"receiver_account_number\",\"value\":\"9813639135\"},{\"display_name\":\"Receiver Bank\",\"variable_name\":\"receiver_bank\",\"value\":\"Wema Bank\"}]},\"fees_breakdown\":{\"amount\":200,\"formula\":null,\"type\":\"paystack\"},\"log\":null,\"fees\":200,\"fees_split\":null,\"authorization\":{\"authorization_code\":\"AUTH_setaya1b49\",\"bin\":\"703XXX\",\"last4\":\"X531\",\"exp_month\":\"05\",\"exp_year\":\"2026\",\"channel\":\"dedicated_nuban\",\"card_type\":\"transfer\",\"bank\":\"PalmPay\",\"country_code\":\"NG\",\"brand\":\"Managed Account\",\"reusable\":false,\"signature\":null,\"account_name\":null,\"sender_country\":\"NG\",\"sender_bank\":\"PalmPay\",\"sender_bank_account_number\":\"XXXXXX6531\",\"sender_name\":\"JULIUS ECHELEBOR EBIEH\",\"narration\":\"7039416531/9813639135/JEDITECHNOLOG/J\",\"receiver_bank_account_number\":\"9813639135\",\"receiver_bank\":\"Wema Bank\"},\"customer\":{\"id\":372586860,\"first_name\":\"Ebieh\",\"last_name\":\"Julius\",\"email\":\"ebiehngozibevy@gmail.com\",\"customer_code\":\"CUS_6ecjqvm0t7ltvi4\",\"phone\":\"+2347039416531\",\"metadata\":{},\"risk_action\":\"default\",\"international_format_phone\":\"+2347039416531\"},\"plan\":{},\"subaccount\":{},\"split\":{},\"order_id\":null,\"paidAt\":\"2026-06-05T13:52:18.000Z\",\"requested_amount\":20000,\"pos_transaction_data\":null,\"source\":null}}', NULL, '52.214.14.220', 1, 0, '2026-06-05 13:52:18', '2026-06-05 13:52:18'),
(62, 340, 'SB_8EAA722187B5', 'virtual_number', 'number_purchase', 1470.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"1xbet\",\"country\":\"Canada\",\"phone\":\"18192473967\",\"request_id\":\"260606023609956512640\"}', NULL, 0, 0, '2026-06-05 18:36:09', '2026-06-05 18:36:09'),
(63, 340, 'SBREF_B9811C6E0E', 'virtual_number', 'refund', 1470.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260606023609956512640\"}', NULL, 0, 0, '2026-06-05 18:36:13', '2026-06-05 18:36:13'),
(64, 513, 'VACT_6A2321CCBC4A5_1780687308', 'virtual_account', 'deposit', 198.20, 'NGN', 'successful', 'bank_transfer', 'PFI|2606052588271', '{\"order\":{\"amount\":200,\"settlement_amount\":198.2,\"fee\":1.8000000000000003,\"description\":\"7001063245 received 200 from JULIUS ECHELEBOR EBIEH (7001063245, N\\/A) \"},\"transaction\":{\"reference\":\"PFI|2606052588271\"},\"account_number\":\"7001063245\",\"customer\":{\"id\":195985,\"first_name\":\"Ebieh\",\"last_name\":\"Julius\",\"phone\":\"07039416531\",\"email\":\"ebiehngozibevy@gmail.com\",\"nin\":null,\"bvn\":null,\"businessId\":\"29808\",\"created_at\":\"2026-06-05T13:29:12.000000Z\",\"updated_at\":\"2026-06-05T13:29:12.000000Z\"}}', NULL, '162.213.251.112', 0, 0, '2026-06-05 19:21:48', '2026-06-05 19:21:48'),
(65, 355, 'PDVA_6A24495933B83_1780762969', 'paystack_dva', 'deposit', 100.00, 'NGN', 'successful', 'bank_transfer', '100004260606162231161909931037', '{\"event\":\"charge.success\",\"data\":{\"id\":6230127555,\"domain\":\"live\",\"status\":\"success\",\"reference\":\"100004260606162231161909931037\",\"amount\":10000,\"message\":null,\"gateway_response\":\"Approved\",\"paid_at\":\"2026-06-06T16:22:48.000Z\",\"created_at\":\"2026-06-06T16:22:48.000Z\",\"channel\":\"dedicated_nuban\",\"currency\":\"NGN\",\"ip_address\":null,\"metadata\":{\"receiver_account_number\":\"9813348820\",\"receiver_bank\":\"Wema Bank\",\"receiver_account_type\":null,\"custom_fields\":[{\"display_name\":\"Receiver Account\",\"variable_name\":\"receiver_account_number\",\"value\":\"9813348820\"},{\"display_name\":\"Receiver Bank\",\"variable_name\":\"receiver_bank\",\"value\":\"Wema Bank\"}]},\"fees_breakdown\":{\"amount\":100,\"formula\":null,\"type\":\"paystack\"},\"log\":null,\"fees\":100,\"fees_split\":null,\"authorization\":{\"authorization_code\":\"AUTH_8g8a15eb3l\",\"bin\":\"903XXX\",\"last4\":\"X181\",\"exp_month\":\"05\",\"exp_year\":\"2026\",\"channel\":\"dedicated_nuban\",\"card_type\":\"transfer\",\"bank\":\"OPay Digital Services Limited (OPay)\",\"country_code\":\"NG\",\"brand\":\"Managed Account\",\"reusable\":false,\"signature\":null,\"account_name\":null,\"sender_country\":\"NG\",\"sender_bank\":\"OPay Digital Services Limited (OPay)\",\"sender_bank_account_number\":\"XXXXXX2181\",\"sender_name\":\"LUCKY OKE\",\"narration\":\"9038152181/9813348820/JEDITECHNOLOG/L\",\"receiver_bank_account_number\":\"9813348820\",\"receiver_bank\":\"Wema Bank\"},\"customer\":{\"id\":365013593,\"first_name\":\"Oke\",\"last_name\":\"Lucky\",\"email\":\"okeluckyroland@gmail.com\",\"customer_code\":\"CUS_xri2cwdgiggdrem\",\"phone\":\"+2349157636221\",\"metadata\":null,\"risk_action\":\"default\",\"international_format_phone\":\"+2349157636221\"},\"plan\":{},\"subaccount\":{},\"split\":{},\"order_id\":null,\"paidAt\":\"2026-06-06T16:22:48.000Z\",\"requested_amount\":10000,\"pos_transaction_data\":null,\"source\":null}}', NULL, '52.49.173.169', 1, 0, '2026-06-06 16:22:49', '2026-06-06 16:22:49'),
(66, 398, 'PDVA_6A24D5BCA853E_1780798908', 'paystack_dva', 'deposit', 4000.00, 'NGN', 'successful', 'bank_transfer', '100004260607022117161944332359', '{\"event\":\"charge.success\",\"data\":{\"id\":6231330038,\"domain\":\"live\",\"status\":\"success\",\"reference\":\"100004260607022117161944332359\",\"amount\":400000,\"message\":null,\"gateway_response\":\"Approved\",\"paid_at\":\"2026-06-07T02:21:48.000Z\",\"created_at\":\"2026-06-07T02:21:48.000Z\",\"channel\":\"dedicated_nuban\",\"currency\":\"NGN\",\"ip_address\":null,\"metadata\":{\"receiver_account_number\":\"9813428991\",\"receiver_bank\":\"Wema Bank\",\"receiver_account_type\":null,\"custom_fields\":[{\"display_name\":\"Receiver Account\",\"variable_name\":\"receiver_account_number\",\"value\":\"9813428991\"},{\"display_name\":\"Receiver Bank\",\"variable_name\":\"receiver_bank\",\"value\":\"Wema Bank\"}]},\"fees_breakdown\":{\"amount\":4000,\"formula\":null,\"type\":\"paystack\"},\"log\":null,\"fees\":4000,\"fees_split\":null,\"authorization\":{\"authorization_code\":\"AUTH_3un7vfv1kp\",\"bin\":\"703XXX\",\"last4\":\"X204\",\"exp_month\":\"05\",\"exp_year\":\"2026\",\"channel\":\"dedicated_nuban\",\"card_type\":\"transfer\",\"bank\":\"OPay Digital Services Limited (OPay)\",\"country_code\":\"NG\",\"brand\":\"Managed Account\",\"reusable\":false,\"signature\":null,\"account_name\":null,\"sender_country\":\"NG\",\"sender_bank\":\"OPay Digital Services Limited (OPay)\",\"sender_bank_account_number\":\"XXXXXX3204\",\"sender_name\":\"FUHAAD AREMU ETIKO\",\"narration\":\"7037023204/9813428991/JEDITECHNOLOG/A\",\"receiver_bank_account_number\":\"9813428991\",\"receiver_bank\":\"Wema Bank\"},\"customer\":{\"id\":369398914,\"first_name\":\"Ruth\",\"last_name\":\"Avila\",\"email\":\"sruth3732@gmail.com\",\"customer_code\":\"CUS_h8dktofncigm7si\",\"phone\":\"+2348142484125\",\"metadata\":{},\"risk_action\":\"default\",\"international_format_phone\":\"+2348142484125\"},\"plan\":{},\"subaccount\":{},\"split\":{},\"order_id\":null,\"paidAt\":\"2026-06-07T02:21:48.000Z\",\"requested_amount\":400000,\"pos_transaction_data\":null,\"source\":null}}', NULL, '52.49.173.169', 1, 0, '2026-06-07 02:21:48', '2026-06-07 02:21:48'),
(67, 340, 'SB_29995113F0E5', 'virtual_number', 'number_purchase', 420.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"Nike\",\"country\":\"United Arab Emirates\",\"phone\":\"971553145632\",\"request_id\":\"260607220244957580672\"}', NULL, 0, 0, '2026-06-07 14:02:44', '2026-06-07 14:02:44'),
(68, 340, 'SBREF_EC3C992142', 'virtual_number', 'refund', 420.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260607220244957580672\"}', NULL, 0, 0, '2026-06-07 14:02:49', '2026-06-07 14:02:49'),
(69, 340, 'SB_BB5D13499ECA', 'virtual_number', 'number_purchase', 1050.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"AARP\",\"country\":\"Argentina\",\"phone\":\"5491165853911\",\"request_id\":\"260612190557954258432\"}', NULL, 0, 0, '2026-06-12 11:05:57', '2026-06-12 11:05:57'),
(70, 340, 'SBREF_B43C036854', 'virtual_number', 'refund', 1050.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260612190557954258432\"}', NULL, 0, 0, '2026-06-12 11:06:04', '2026-06-12 11:06:04'),
(71, 354, 'TXN_6A2C20A87B80B_1781276840', 'paystack', 'deposit', 500.00, 'NGN', 'pending', NULL, NULL, NULL, NULL, '102.90.103.240', 1, 0, '2026-06-12 15:07:20', '2026-06-12 15:07:20'),
(72, 355, 'PDVA_6A32998FC7DD5_1781701007', 'paystack_dva', 'deposit', 10.00, 'NGN', 'successful', 'bank_transfer', '100033260617125628723798985294', '{\"event\":\"charge.success\",\"data\":{\"id\":6269676222,\"domain\":\"live\",\"status\":\"success\",\"reference\":\"100033260617125628723798985294\",\"amount\":1000,\"message\":null,\"gateway_response\":\"Approved\",\"paid_at\":\"2026-06-17T12:56:47.000Z\",\"created_at\":\"2026-06-17T12:56:47.000Z\",\"channel\":\"dedicated_nuban\",\"currency\":\"NGN\",\"ip_address\":null,\"metadata\":{\"receiver_account_number\":\"9813348820\",\"receiver_bank\":\"Wema Bank\",\"receiver_account_type\":null,\"custom_fields\":[{\"display_name\":\"Receiver Account\",\"variable_name\":\"receiver_account_number\",\"value\":\"9813348820\"},{\"display_name\":\"Receiver Bank\",\"variable_name\":\"receiver_bank\",\"value\":\"Wema Bank\"}]},\"fees_breakdown\":{\"amount\":10,\"formula\":null,\"type\":\"paystack\"},\"log\":null,\"fees\":10,\"fees_split\":null,\"authorization\":{\"authorization_code\":\"AUTH_uf4v42n41v\",\"bin\":\"292XXX\",\"last4\":\"X962\",\"exp_month\":\"05\",\"exp_year\":\"2026\",\"channel\":\"dedicated_nuban\",\"card_type\":\"transfer\",\"bank\":\"PalmPay\",\"country_code\":\"NG\",\"brand\":\"Managed Account\",\"reusable\":false,\"signature\":null,\"account_name\":null,\"sender_country\":\"NG\",\"sender_bank\":\"PalmPay\",\"sender_bank_account_number\":\"XXXXXX2962\",\"sender_name\":\"LUCKY OKE\",\"narration\":\"2920752962/9813348820/JEDITECHNOLOG/L\",\"receiver_bank_account_number\":\"9813348820\",\"receiver_bank\":\"Wema Bank\"},\"customer\":{\"id\":365013593,\"first_name\":\"Oke\",\"last_name\":\"Lucky\",\"email\":\"okeluckyroland@gmail.com\",\"customer_code\":\"CUS_xri2cwdgiggdrem\",\"phone\":\"+2349157636221\",\"metadata\":null,\"risk_action\":\"default\",\"international_format_phone\":\"+2349157636221\"},\"plan\":{},\"subaccount\":{},\"split\":{},\"order_id\":null,\"paidAt\":\"2026-06-17T12:56:47.000Z\",\"requested_amount\":1000,\"pos_transaction_data\":null,\"source\":null}}', NULL, '52.31.139.75', 0, 0, '2026-06-17 12:56:47', '2026-06-17 12:56:47'),
(73, 355, 'TXN_6A3299C45CF5C_1781701060', 'paystack', 'deposit', 1000.00, 'NGN', 'pending', NULL, NULL, NULL, NULL, '102.90.103.128', 0, 0, '2026-06-17 12:57:40', '2026-06-17 12:57:40'),
(74, 355, 'TXN_6A353E32958A3_1781874226', 'paystack', 'deposit', 1000.00, 'NGN', 'pending', NULL, NULL, NULL, NULL, '102.90.96.89', 0, 0, '2026-06-19 13:03:46', '2026-06-19 13:03:46'),
(75, 340, 'SB_813812B72A9A', 'virtual_number', 'number_purchase', 14542.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Germany\",\"phone\":\"4915216064966\",\"request_id\":\"260620045950954456832\"}', NULL, 0, 0, '2026-06-19 20:59:50', '2026-06-19 20:59:50'),
(76, 340, 'SBREF_D34754574C', 'virtual_number', 'refund', 14542.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260620045950954456832\"}', NULL, 0, 0, '2026-06-19 20:59:54', '2026-06-19 20:59:54'),
(77, 538, 'TXN_6A4962011BE59_1783194113', 'paystack', 'deposit', 2000.00, 'NGN', 'pending', NULL, NULL, NULL, NULL, '197.210.226.159', 1, 0, '2026-07-04 19:41:53', '2026-07-04 19:41:53'),
(78, 538, 'VACT_6A4962B9E0866_1783194297', 'virtual_account', 'deposit', 2477.50, 'NGN', 'successful', 'bank_transfer', 'PFI|2607042679079', '{\"order\":{\"amount\":2500,\"settlement_amount\":2477.5,\"fee\":22.500000000000004,\"description\":\"7001622365 received 2500 from OTEGA UNITY OYEFIA (9153277130, N\\/A) \"},\"transaction\":{\"reference\":\"PFI|2607042679079\"},\"account_number\":\"7001622365\",\"customer\":{\"id\":292604,\"first_name\":\"Oyefia\",\"last_name\":\"Otega\",\"phone\":\"09153277130\",\"email\":\"oyefiaotega150@gmail.com\",\"nin\":null,\"bvn\":null,\"businessId\":\"29808\",\"created_at\":\"2026-07-04T19:36:52.000000Z\",\"updated_at\":\"2026-07-04T19:36:52.000000Z\"}}', NULL, '162.213.251.112', 1, 0, '2026-07-04 19:44:57', '2026-07-04 19:44:57'),
(79, 538, 'VACT_6A4966DD8E314_1783195357', 'virtual_account', 'deposit', 1982.00, 'NGN', 'successful', 'bank_transfer', 'PFI|2607042729898', '{\"order\":{\"amount\":2000,\"settlement_amount\":1982,\"fee\":18.000000000000004,\"description\":\"7001622365 received 2000 from OTEGA UNITY OYEFIA (9153277130, N\\/A) \"},\"transaction\":{\"reference\":\"PFI|2607042729898\"},\"account_number\":\"7001622365\",\"customer\":{\"id\":292604,\"first_name\":\"Oyefia\",\"last_name\":\"Otega\",\"phone\":\"09153277130\",\"email\":\"oyefiaotega150@gmail.com\",\"nin\":null,\"bvn\":null,\"businessId\":\"29808\",\"created_at\":\"2026-07-04T19:36:52.000000Z\",\"updated_at\":\"2026-07-04T19:36:52.000000Z\"}}', NULL, '162.213.251.112', 0, 0, '2026-07-04 20:02:37', '2026-07-04 20:02:37'),
(80, 538, 'VACT_6A4967CA1E3B3_1783195594', 'virtual_account', 'deposit', 495.50, 'NGN', 'successful', 'bank_transfer', 'PFI|2607042742491', '{\"order\":{\"amount\":500,\"settlement_amount\":495.5,\"fee\":4.500000000000001,\"description\":\"7001622365 received 500 from OTEGA UNITY OYEFIA (9153277130, N\\/A) \"},\"transaction\":{\"reference\":\"PFI|2607042742491\"},\"account_number\":\"7001622365\",\"customer\":{\"id\":292604,\"first_name\":\"Oyefia\",\"last_name\":\"Otega\",\"phone\":\"09153277130\",\"email\":\"oyefiaotega150@gmail.com\",\"nin\":null,\"bvn\":null,\"businessId\":\"29808\",\"created_at\":\"2026-07-04T19:36:52.000000Z\",\"updated_at\":\"2026-07-04T19:36:52.000000Z\"}}', NULL, '162.213.251.112', 0, 0, '2026-07-04 20:06:34', '2026-07-04 20:06:34'),
(81, 538, 'SB_C7B47DEAD955', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447999166141\",\"request_id\":\"260705040706955699712\"}', NULL, 0, 0, '2026-07-04 20:07:06', '2026-07-04 20:07:06'),
(82, 538, 'SBAUTO_E5D258D5', 'virtual_number', 'refund', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"request_id\":\"260705040706955699712\"}', NULL, 0, 0, '2026-07-04 20:33:12', '2026-07-04 20:33:12'),
(83, 538, 'SB_C70FB1280097', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447724554202\",\"request_id\":\"260705043357956345472\"}', NULL, 0, 0, '2026-07-04 20:33:57', '2026-07-04 20:33:57'),
(84, 538, 'SB_351D0BB5E461', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447354947594\",\"request_id\":\"260705043426958910208\"}', NULL, 0, 0, '2026-07-04 20:34:26', '2026-07-04 20:34:26'),
(85, 538, 'SBAUTO_D26DAF7A', 'virtual_number', 'refund', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"request_id\":\"260705043426958910208\"}', NULL, 0, 0, '2026-07-04 20:42:01', '2026-07-04 20:42:01'),
(86, 538, 'SB_C457DDACB9A6', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447514621373\",\"request_id\":\"260705044321953559808\"}', NULL, 0, 0, '2026-07-04 20:43:21', '2026-07-04 20:43:21'),
(87, 538, 'SBAUTO_004C0A49', 'virtual_number', 'refund', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"request_id\":\"260705044321953559808\"}', NULL, 0, 0, '2026-07-04 21:38:13', '2026-07-04 21:38:13'),
(88, 538, 'SB_54CAAD9936BC', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447756666827\",\"request_id\":\"260705054048952690304\"}', NULL, 0, 0, '2026-07-04 21:40:49', '2026-07-04 21:40:49'),
(89, 538, 'SBAUTO_A63C18C4', 'virtual_number', 'refund', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"request_id\":\"260705054048952690304\"}', NULL, 0, 0, '2026-07-04 21:45:52', '2026-07-04 21:45:52'),
(90, 538, 'SB_27E199E5B4E0', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447446309001\",\"request_id\":\"260705062205957541248\"}', NULL, 0, 0, '2026-07-04 22:22:05', '2026-07-04 22:22:05'),
(91, 538, 'SBREF_9EE4BB4C41', 'virtual_number', 'refund', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260705062205957541248\"}', NULL, 0, 0, '2026-07-04 22:22:10', '2026-07-04 22:22:10'),
(92, 538, 'SB_90CDF338E738', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447429374316\",\"request_id\":\"260705173951955265280\"}', NULL, 0, 0, '2026-07-05 09:39:51', '2026-07-05 09:39:51'),
(93, 538, 'SBAUTO_D9C9DE1C', 'virtual_number', 'refund', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"request_id\":\"260705173951955265280\"}', NULL, 0, 0, '2026-07-05 09:45:46', '2026-07-05 09:45:46'),
(94, 538, 'SB_7741D5AD9348', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447907309861\",\"request_id\":\"260705175941955339904\"}', NULL, 0, 0, '2026-07-05 09:59:41', '2026-07-05 09:59:41'),
(95, 538, 'SBAUTO_F2299614', 'virtual_number', 'refund', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"request_id\":\"260705175941955339904\"}', NULL, 0, 0, '2026-07-05 10:04:45', '2026-07-05 10:04:45'),
(96, 538, 'SB_0B64695AAC1E', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447529506369\",\"request_id\":\"260706055327958393344\"}', NULL, 0, 0, '2026-07-05 21:53:27', '2026-07-05 21:53:27'),
(97, 538, 'SBREF_5CB1C06566', 'virtual_number', 'refund', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260706055327958393344\"}', NULL, 0, 0, '2026-07-05 21:54:12', '2026-07-05 21:54:12'),
(98, 538, 'SB_73785B640C28', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447529512919\",\"request_id\":\"260706055421957090944\"}', NULL, 0, 0, '2026-07-05 21:54:21', '2026-07-05 21:54:21'),
(99, 538, 'VACT_6A5642F5A4BCE_1784038133', 'virtual_account', 'deposit', 3171.20, 'NGN', 'successful', 'bank_transfer', 'PFI|2607141447121', '{\"order\":{\"amount\":3200,\"settlement_amount\":3171.2,\"fee\":28.800000000000004,\"description\":\"7001622365 received 3200 from OTEGA UNITY OYEFIA (9153277130, N\\/A) \"},\"transaction\":{\"reference\":\"PFI|2607141447121\"},\"account_number\":\"7001622365\",\"customer\":{\"id\":292604,\"first_name\":\"Oyefia\",\"last_name\":\"Otega\",\"phone\":\"09153277130\",\"email\":\"oyefiaotega150@gmail.com\",\"nin\":null,\"bvn\":null,\"businessId\":\"29808\",\"created_at\":\"2026-07-04T19:36:52.000000Z\",\"updated_at\":\"2026-07-04T19:36:52.000000Z\"}}', NULL, '162.213.251.112', 0, 0, '2026-07-14 14:08:53', '2026-07-14 14:08:53'),
(100, 538, 'SB_C04EC50F8821', 'virtual_number', 'number_purchase', 3570.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Canada\",\"phone\":\"16394308061\",\"request_id\":\"260714221023953926784\"}', NULL, 0, 0, '2026-07-14 14:10:23', '2026-07-14 14:10:23'),
(101, 538, 'SBAUTO_40E904F3', 'virtual_number', 'refund', 3570.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"request_id\":\"260714221023953926784\"}', NULL, 0, 0, '2026-07-14 14:15:26', '2026-07-14 14:15:26'),
(102, 538, 'SB_61A1AE610CB2', 'virtual_number', 'number_purchase', 3570.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Canada\",\"phone\":\"12366064804\",\"request_id\":\"260714222006951168896\"}', NULL, 0, 0, '2026-07-14 14:20:06', '2026-07-14 14:20:06'),
(103, 538, 'SBAUTO_57A10684', 'virtual_number', 'refund', 3570.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number expired\",\"request_id\":\"260714222006951168896\"}', NULL, 0, 0, '2026-07-14 14:25:08', '2026-07-14 14:25:08'),
(104, 538, 'SB_FD7937B53E3D', 'virtual_number', 'number_purchase', 3570.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Canada\",\"phone\":\"12366063841\",\"request_id\":\"260714222535952210176\"}', NULL, 0, 0, '2026-07-14 14:25:35', '2026-07-14 14:25:35'),
(105, 538, 'SBAUTO_0981B45B', 'virtual_number', 'refund', 3570.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Auto-refund: number timeout\",\"request_id\":\"260714222535952210176\"}', NULL, 0, 0, '2026-07-14 14:30:36', '2026-07-14 14:30:36'),
(106, 538, 'SB_A3D399E15F22', 'virtual_number', 'number_purchase', 3570.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"Canada\",\"phone\":\"17534380572\",\"request_id\":\"260714223057953404544\"}', NULL, 0, 0, '2026-07-14 14:30:57', '2026-07-14 14:30:57'),
(107, 538, 'SBREF_7B1762A0DE', 'virtual_number', 'refund', 3570.00, 'NGN', 'successful', NULL, NULL, NULL, '{\"reason\":\"Number cancelled\",\"request_id\":\"260714223057953404544\"}', NULL, 0, 0, '2026-07-14 14:31:55', '2026-07-14 14:31:55'),
(108, 538, 'VACT_6A57BBC0456F1_1784134592', 'virtual_account', 'deposit', 1189.20, 'NGN', 'successful', 'bank_transfer', 'PFI|2607151928883', '{\"order\":{\"amount\":1200,\"settlement_amount\":1189.2,\"fee\":10.8,\"description\":\"7001622365 received 1200 from OTEGA UNITY OYEFIA (9153277130, N\\/A) \"},\"transaction\":{\"reference\":\"PFI|2607151928883\"},\"account_number\":\"7001622365\",\"customer\":{\"id\":292604,\"first_name\":\"Oyefia\",\"last_name\":\"Otega\",\"phone\":\"09153277130\",\"email\":\"oyefiaotega150@gmail.com\",\"nin\":null,\"bvn\":null,\"businessId\":\"29808\",\"created_at\":\"2026-07-04T19:36:52.000000Z\",\"updated_at\":\"2026-07-04T19:36:52.000000Z\"}}', NULL, '162.213.251.112', 0, 0, '2026-07-15 16:56:32', '2026-07-15 16:56:32'),
(109, 538, 'SB_D1B0AFDC3E62', 'virtual_number', 'number_purchase', 4567.50, 'NGN', 'successful', NULL, NULL, NULL, '{\"project\":\"WhatsApp\",\"country\":\"United Kingdom\",\"phone\":\"447513417533\",\"request_id\":\"260716005708959415680\"}', NULL, 0, 0, '2026-07-15 16:57:08', '2026-07-15 16:57:08'),
(110, 544, 'TXN_6A59B2A976A2B_1784263337', 'flutterwave', 'deposit', 33000000.00, 'USD', 'pending', NULL, NULL, NULL, '{\"original_amount\":30000,\"original_currency\":\"USD\",\"converted_ngn\":33000000,\"fx_rate\":null}', '::1', 1, 0, '2026-07-17 04:42:17', '2026-07-17 04:42:17'),
(111, 544, 'TXN_6A59B2CB28E54_1784263371', 'flutterwave', 'deposit', 550000.00, 'USD', 'pending', NULL, NULL, NULL, '{\"original_amount\":500,\"original_currency\":\"USD\",\"converted_ngn\":550000,\"fx_rate\":null}', '::1', 1, 0, '2026-07-17 04:42:51', '2026-07-17 04:42:51'),
(112, 544, 'TXN_6A59B3F943222_1784263673', 'flutterwave', 'deposit', 550000.00, 'USD', 'failed', NULL, NULL, NULL, '{\"original_amount\":500,\"original_currency\":\"USD\",\"converted_ngn\":550000,\"fx_rate\":null}', '::1', 1, 0, '2026-07-17 04:47:53', '2026-07-17 04:47:54'),
(113, 544, 'TXN_6A59B408AE37A_1784263688', 'paystack', 'deposit', 500.00, 'NGN', 'pending', NULL, NULL, NULL, '{\"original_amount\":500,\"original_currency\":\"NGN\",\"converted_ngn\":500,\"fx_rate\":1}', '::1', 1, 0, '2026-07-17 04:48:08', '2026-07-17 04:48:08'),
(114, 544, 'TXN_6A59B42E915F7_1784263726', 'flutterwave', 'deposit', 215000.00, 'AED', 'failed', NULL, NULL, NULL, '{\"original_amount\":500,\"original_currency\":\"AED\",\"converted_ngn\":215000,\"fx_rate\":null}', '::1', 1, 0, '2026-07-17 04:48:46', '2026-07-17 04:48:47'),
(115, 544, 'TXN_6A59B42FAFC0D_1784263727', 'flutterwave', 'deposit', 215000.00, 'AED', 'failed', NULL, NULL, NULL, '{\"original_amount\":500,\"original_currency\":\"AED\",\"converted_ngn\":215000,\"fx_rate\":null}', '::1', 1, 0, '2026-07-17 04:48:47', '2026-07-17 04:48:48'),
(116, 544, 'TXN_6A59B4488D9DE_1784263752', 'flutterwave', 'deposit', 1100000.00, 'USD', 'failed', NULL, NULL, NULL, '{\"original_amount\":1000,\"original_currency\":\"USD\",\"converted_ngn\":1100000,\"fx_rate\":null}', '::1', 1, 0, '2026-07-17 04:49:12', '2026-07-17 04:49:13');

-- --------------------------------------------------------

--
-- Table structure for table `virtual_card_customers`
--

CREATE TABLE `virtual_card_customers` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `customer_id` varchar(100) NOT NULL COMMENT 'StroWallet customerEmail used as ID',
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `id_type` varchar(50) DEFAULT NULL,
  `id_number` varchar(100) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='StroWallet customer records per user';

-- --------------------------------------------------------

--
-- Table structure for table `virtual_card_transactions`
--

CREATE TABLE `virtual_card_transactions` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `card_id` varchar(100) NOT NULL COMMENT 'StroWallet card ID (FK → virtual_cards.card_id)',
  `type` enum('fund','spend','withdraw','refund','fee','reversal') NOT NULL,
  `amount_usd` decimal(12,4) NOT NULL COMMENT 'USD amount (positive)',
  `amount_ngn` decimal(14,2) NOT NULL DEFAULT 0.00 COMMENT 'NGN equivalent deducted/credited to wallet',
  `rate_used` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'Exchange rate applied',
  `description` varchar(300) DEFAULT NULL,
  `merchant` varchar(150) DEFAULT NULL COMMENT 'Merchant name for spend txns',
  `reference` varchar(100) DEFAULT NULL COMMENT 'Internal reference',
  `external_ref` varchar(150) DEFAULT NULL COMMENT 'StroWallet transaction ID',
  `status` enum('pending','completed','failed','reversed') NOT NULL DEFAULT 'completed',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Per-card funding, spending and withdrawal history';

--
-- Dumping data for table `virtual_card_transactions`
--

INSERT INTO `virtual_card_transactions` (`id`, `user_id`, `card_id`, `type`, `amount_usd`, `amount_ngn`, `rate_used`, `description`, `merchant`, `reference`, `external_ref`, `status`, `created_at`) VALUES
(1, 340, 'd28e8082-68cc-4c92-a4d1-b36a22d5a4ea', 'fund', 5.0000, 7145.75, 1429.15, 'Initial card funding', NULL, 'CARD_CREATE_1', NULL, 'completed', '2026-05-25 02:43:21'),
(2, 340, 'd28e8082-68cc-4c92-a4d1-b36a22d5a4ea', 'fee', 0.0000, 7000.00, 0.00, 'Card creation fee', NULL, 'FEE_CREATE_1', NULL, 'completed', '2026-05-25 02:43:21'),
(3, 340, 'd28e8082-68cc-4c92-a4d1-b36a22d5a4ea', 'withdraw', 4.0000, 5396.60, 1349.15, 'Withdrawal to wallet', NULL, 'card_withdraw_ELUT88TKLY', NULL, 'completed', '2026-05-25 02:47:40');

-- --------------------------------------------------------

--
-- Table structure for table `vtu_cable_plans`
--

CREATE TABLE `vtu_cable_plans` (
  `id` int(11) NOT NULL,
  `provider` varchar(30) NOT NULL COMMENT 'DSTV | GOTV | STARTIMES',
  `plan_name` varchar(100) NOT NULL,
  `plan_code` varchar(50) NOT NULL COMMENT 'Provider bouquet code',
  `sell_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vtu_cable_plans`
--

INSERT INTO `vtu_cable_plans` (`id`, `provider`, `plan_name`, `plan_code`, `sell_price`, `status`, `created_at`) VALUES
(1, 'DSTV', 'DStv Padi', '3', 4400.00, 1, '2026-03-30 10:14:38'),
(2, 'GOTV', 'GOtv Smallie-monthly', '4', 1900.00, 1, '2026-03-30 10:15:26'),
(3, 'STARTIMES', 'Nova (antenna) -1 week', '5', 700.00, 1, '2026-03-30 10:15:53'),
(4, 'DSTV', 'DStv Yanga', '6', 6000.00, 1, '2026-03-30 10:16:13'),
(5, 'DSTV', 'DStv Confam', '7', 11000.00, 1, '2026-03-30 10:17:25'),
(6, 'DSTV', 'DStv Compact', '8', 19000.00, 1, '2026-03-30 10:22:35'),
(7, 'DSTV', 'DStv Compact Plus', '9', 30000.00, 1, '2026-03-30 10:22:54'),
(8, 'DSTV', 'DStv Premium', '10', 44500.00, 1, '2026-03-30 10:23:24'),
(9, 'GOTV', 'GOtv Jinja', '11', 3900.00, 1, '2026-03-30 10:23:42'),
(10, 'GOTV', 'Gotv Jolli', '12', 5800.00, 1, '2026-03-30 10:24:51'),
(11, 'GOTV', 'GOtv Max', '13', 8500.00, 1, '2026-03-30 10:25:18'),
(12, 'GOTV', 'GOtv Supa', '14', 11400.00, 1, '2026-03-30 10:25:49'),
(13, 'GOTV', 'GOtv Supa Plus', '15', 16800.00, 1, '2026-03-30 10:26:15'),
(14, 'STARTIMES', 'Nova (Dish) - 1 Week', '16', 700.00, 1, '2026-03-30 10:27:36'),
(15, 'STARTIMES', 'Nova (Antenna) - 1 Month', '17', 2100.00, 1, '2026-03-30 10:28:01'),
(16, 'STARTIMES', 'Basic (Antenna) -1 Week', '18', 1400.00, 1, '2026-03-30 10:28:36'),
(17, 'STARTIMES', 'Basic (Dish) - 1 week', '19', 1700.00, 1, '2026-03-30 10:29:16'),
(18, 'STARTIMES', 'Basic (Antenna)- 1 month', '20', 4000.00, 1, '2026-03-30 10:29:40'),
(19, 'STARTIMES', 'Basic (dish) - 1Month', '21', 5100.00, 1, '2026-03-30 10:30:03'),
(20, 'STARTIMES', 'Classic (Dish) - 1 Week', '22', 2500.00, 1, '2026-03-30 10:30:35'),
(21, 'STARTIMES', 'Classic (Dish) -1 Month', '23', 7400.00, 1, '2026-03-30 10:30:55'),
(22, 'STARTIMES', 'Super (Dish) - 1 Week', '24', 3300.00, 1, '2026-03-30 10:31:21'),
(23, 'STARTIMES', 'Super (Antenna) - 1 week', '25', 3200.00, 1, '2026-03-30 10:31:52'),
(24, 'STARTIMES', 'Super (Antenna) -1 Month', '26', 9500.00, 1, '2026-03-30 10:32:14');

-- --------------------------------------------------------

--
-- Table structure for table `vtu_data_plans`
--

CREATE TABLE `vtu_data_plans` (
  `id` int(11) NOT NULL,
  `network` varchar(20) NOT NULL COMMENT 'MTN | GLO | AIRTEL | 9MOBILE',
  `plan_name` varchar(100) NOT NULL COMMENT 'e.g. 1GB Daily',
  `data_size` varchar(30) NOT NULL COMMENT 'e.g. 1GB',
  `validity` varchar(30) NOT NULL COMMENT 'e.g. 1 Day',
  `plan_id` varchar(50) NOT NULL COMMENT 'CheapDataHub plan ID / code',
  `plan_type` varchar(20) NOT NULL DEFAULT 'DAILY' COMMENT 'DAILY | WEEKLY | MONTHLY',
  `cost_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'Our cost from provider (NGN)',
  `sell_price` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'Price charged to user (NGN)',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=Active, 0=Disabled',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Admin-managed data plans fetched/synced from CheapDataHub';

--
-- Dumping data for table `vtu_data_plans`
--

INSERT INTO `vtu_data_plans` (`id`, `network`, `plan_name`, `data_size`, `validity`, `plan_id`, `plan_type`, `cost_price`, `sell_price`, `status`, `created_at`, `updated_at`) VALUES
(1, 'MTN', '110MB', '110MB', '1 Day', '43', 'DAILY', 99.00, 100.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:36:29'),
(2, 'MTN', '230MB', '230MB', '1 Day', '74', 'DAILY', 200.00, 250.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:36:13'),
(3, 'MTN', '500MB', '500MB', '30 Days', '44', 'MONTHLY', 350.00, 400.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:36:52'),
(4, 'MTN', '1GB', '1GB', '7 Days', '45', 'WEEKLY', 850.00, 450.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:37:16'),
(5, 'MTN', '1GB', '1GB', '30 Days', '46', 'MONTHLY', 570.00, 600.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:37:33'),
(6, 'GLO', '200 MB', '200MB', '1 Day', '42', 'DAILY', 89.00, 100.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:35:30'),
(7, 'GLO', '500MB', '500MB', '30 Day', '35', 'MONTHLY', 225.00, 250.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:33:43'),
(8, 'GLO', '1GB', '1GB', '14 Days', '41', 'WEEKLY', 485.00, 500.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:35:12'),
(9, 'AIRTEL', '500MB', '500MB', '7 Days', '13', 'WEEKLY', 490.00, 500.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:32:46'),
(10, 'AIRTEL', '1.5GB', '1.5GB', '1 Day', '69', 'DAILY', 500.00, 530.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:58:10'),
(11, 'AIRTEL', '6GB', '6GB', '7 Days', '22', 'WEEKLY', 2455.00, 2599.00, 1, '2026-03-30 06:19:36', '2026-04-01 22:32:16'),
(14, 'AIRTEL', '1GB', '1GB', '3 Days', '70', 'DAILY', 295.00, 300.00, 1, '2026-04-01 16:13:40', '2026-04-01 21:37:18'),
(15, 'AIRTEL', '1.5GB', '1.5GB', '2 Days', '66', 'DAILY', 599.00, 650.00, 1, '2026-04-01 16:23:58', '2026-04-01 21:37:18'),
(16, 'AIRTEL', '1GB', '1GB', '7 Days', '15', 'WEEKLY', 785.00, 800.00, 1, '2026-04-01 16:50:28', '2026-04-01 21:37:18'),
(17, 'AIRTEL', '2GB', '2GB', '30 Days', '17', 'MONTHLY', 1470.00, 1500.00, 1, '2026-04-01 16:51:34', '2026-04-01 21:37:18'),
(18, 'AIRTEL', '5GB', '5GB', '7 Days', '52', 'WEEKLY', 1570.00, 1599.00, 1, '2026-04-01 16:53:26', '2026-04-01 21:37:18'),
(19, 'AIRTEL', '4GB', '4GB', '30 Days', '19', 'MONTHLY', 2570.00, 2650.00, 1, '2026-04-01 22:27:58', '2026-04-01 22:27:58'),
(20, 'AIRTEL', '8GB', '8GB', '30 Days', '20', 'MONTHLY', 2999.00, 3200.00, 1, '2026-04-01 22:29:41', '2026-04-01 22:34:34'),
(21, 'AIRTEL', '10GB', '10GB', '30 Days', '21', 'MONTHLY', 4070.00, 4200.00, 1, '2026-04-01 22:40:39', '2026-04-01 22:41:05'),
(22, 'GLO', '1GB', '1GB', '3 Days', '68', 'DAILY', 280.00, 330.00, 1, '2026-04-01 22:44:05', '2026-04-01 22:44:05'),
(23, 'GLO', '1GB', '1GB', '30 Days', '36', 'MONTHLY', 425.00, 450.00, 1, '2026-04-01 22:45:09', '2026-04-01 22:45:09'),
(24, 'GLO', '2GB', '2GB', '30 Days', '40', 'MONTHLY', 840.00, 900.00, 1, '2026-04-01 22:46:26', '2026-04-01 22:46:26'),
(25, 'GLO', '3GB', '3GB', '30 Days', '37', 'MONTHLY', 1290.00, 1400.00, 1, '2026-04-01 22:47:20', '2026-04-01 22:47:20'),
(26, 'GLO', '5GB', '5GB', '7 Days', '54', 'WEEKLY', 1690.00, 1800.00, 1, '2026-04-01 22:48:11', '2026-04-01 22:48:11'),
(27, 'GLO', '5GB', '5GB', '30 Days', '38', 'MONTHLY', 2190.00, 2250.00, 1, '2026-04-01 22:49:19', '2026-04-01 22:49:19'),
(28, 'GLO', '10GB', '10GB', '30 Days', '39', 'MONTHLY', 4390.00, 4400.00, 1, '2026-04-01 22:50:16', '2026-04-01 22:50:16'),
(29, 'GLO', '20.5GB', '20.5GB', '30 Days', '59', 'MONTHLY', 5300.00, 6000.00, 1, '2026-04-01 22:51:18', '2026-04-01 22:51:18'),
(30, 'GLO', '107GB', '107GB', '30 Days', '58', 'MONTHLY', 19300.00, 20000.00, 1, '2026-04-01 22:52:42', '2026-04-01 22:52:42'),
(31, 'MTN', '2GB', '2GB', '7 Days', '47', 'WEEKLY', 930.00, 950.00, 1, '2026-04-01 22:54:56', '2026-04-01 22:54:56'),
(32, 'MTN', '3.5GB', '3.5GB', '1 Day', '60', 'DAILY', 980.00, 1000.00, 1, '2026-04-01 22:55:35', '2026-04-01 22:55:35'),
(33, 'MTN', '2.5GB', '2.5GB', '2 Days', '27', 'DAILY', 900.00, 1000.00, 1, '2026-04-01 22:56:31', '2026-04-01 22:56:31'),
(34, 'MTN', '2GB', '2GB', '7 Days', '71', 'WEEKLY', 900.00, 1000.00, 1, '2026-04-01 22:57:46', '2026-04-01 22:57:46'),
(35, 'MTN', '2GB', '2GB', '30 Days', '48', 'MONTHLY', 1150.00, 1250.00, 1, '2026-04-01 23:01:28', '2026-04-01 23:01:28'),
(36, 'MTN', '4GB', '4GB', '2 Days', '62', 'DAILY', 1175.00, 1300.00, 1, '2026-04-01 23:02:30', '2026-04-01 23:02:30'),
(37, 'MTN', '3GB', '3GB', '30 Days', '49', 'MONTHLY', 1370.00, 1500.00, 1, '2026-04-01 23:03:31', '2026-04-01 23:03:31'),
(38, 'MTN', '5GB', '5GB', '30 Days', '50', 'MONTHLY', 2050.00, 2300.00, 1, '2026-04-01 23:04:17', '2026-04-01 23:04:17'),
(39, 'MTN', '6GB', '6GB', '7 Days', '53', 'WEEKLY', 2495.00, 2600.00, 1, '2026-04-01 23:05:05', '2026-04-01 23:05:28'),
(40, 'MTN', '11GB', '11GB', '7 Days', '55', 'WEEKLY', 3430.00, 3450.00, 1, '2026-04-01 23:06:26', '2026-04-01 23:06:26'),
(41, 'MTN', '7GB', '7GB', '30 Days', '33', 'MONTHLY', 3499.00, 3599.00, 1, '2026-04-01 23:07:51', '2026-04-01 23:07:51'),
(42, 'MTN', '10GB', '10GB', '30 Days', '67', 'MONTHLY', 4470.00, 5000.00, 1, '2026-04-01 23:08:31', '2026-04-01 23:08:31'),
(43, 'MTN', '36GB', '36GB', '30 Days', '57', 'MONTHLY', 10800.00, 11000.00, 1, '2026-04-01 23:09:20', '2026-04-01 23:09:20'),
(44, 'MTN', '75GB', '75GB', '30 Days', '51', 'DAILY', 17990.00, 18500.00, 1, '2026-04-01 23:10:03', '2026-04-01 23:10:03'),
(45, 'MTN', '1GB', '1GB', '1 Day', '78', 'DAILY', 280.00, 300.00, 1, '2026-04-21 10:15:06', '2026-04-21 10:15:06'),
(46, 'MTN', '500MB', '500MB', '2 Days', '76', 'DAILY', 250.00, 270.00, 1, '2026-04-21 10:18:09', '2026-04-21 10:18:09'),
(47, 'MTN', '1GB', '1GB', '2 Days', '77', 'DAILY', 399.00, 420.00, 1, '2026-04-21 10:21:13', '2026-04-21 10:21:13'),
(48, 'MTN', '1GB', '1GB', '7 Days', '45', 'WEEKLY', 450.00, 470.00, 1, '2026-04-21 10:22:06', '2026-04-21 10:22:06'),
(49, 'MTN', '2.5GB', '2.5GB', '1 Day', '79', 'DAILY', 600.00, 650.00, 1, '2026-05-15 12:32:49', '2026-05-15 12:32:49');

-- --------------------------------------------------------

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'User who requested withdrawal',
  `username` varchar(50) NOT NULL COMMENT 'Username (snapshot)',
  `withdrawal_method_id` int(11) NOT NULL COMMENT 'Withdrawal method used',
  `method_name` varchar(100) NOT NULL COMMENT 'Method name (snapshot)',
  `amount` decimal(10,2) NOT NULL COMMENT 'Withdrawal amount requested',
  `fee_percentage` decimal(5,2) NOT NULL COMMENT 'Fee percentage (snapshot)',
  `fee_amount` decimal(10,2) NOT NULL COMMENT 'Fee amount calculated',
  `final_amount` decimal(10,2) NOT NULL COMMENT 'Amount user will receive',
  `wallet_or_account` text NOT NULL COMMENT 'Wallet address or bank details',
  `status` enum('pending','processing','completed','rejected','cancelled') DEFAULT 'pending' COMMENT 'Withdrawal status',
  `admin_note` text DEFAULT NULL COMMENT 'Admin notes or rejection reason',
  `processed_by` int(11) DEFAULT NULL COMMENT 'Admin who processed',
  `processed_at` datetime DEFAULT NULL COMMENT 'When withdrawal was processed',
  `transaction_reference` varchar(100) DEFAULT NULL COMMENT 'Transaction reference/hash',
  `ip_address` varchar(50) DEFAULT NULL COMMENT 'User IP address',
  `user_agent` text DEFAULT NULL COMMENT 'Browser info',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `withdrawal_methods`
--

CREATE TABLE `withdrawal_methods` (
  `id` int(11) NOT NULL,
  `method_name` varchar(100) NOT NULL COMMENT 'Method name (e.g., Bank Transfer)',
  `method_type` enum('bank','crypto','mobile_money','paypal','other') NOT NULL DEFAULT 'bank' COMMENT 'Method type',
  `fee_percentage` decimal(5,2) NOT NULL DEFAULT 0.00 COMMENT 'Fee percentage',
  `minimum_amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT 'Minimum withdrawal amount',
  `maximum_amount` decimal(10,2) DEFAULT NULL COMMENT 'Maximum withdrawal amount (NULL = unlimited)',
  `processing_time` varchar(100) DEFAULT 'Within 24 hours' COMMENT 'Expected processing time',
  `status` enum('active','inactive') DEFAULT 'active' COMMENT 'Method status',
  `instructions` text DEFAULT NULL COMMENT 'Instructions for users',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `withdrawal_methods`
--

INSERT INTO `withdrawal_methods` (`id`, `method_name`, `method_type`, `fee_percentage`, `minimum_amount`, `maximum_amount`, `processing_time`, `status`, `instructions`, `created_at`, `updated_at`) VALUES
(1, 'Bank Transfer', 'bank', 2.00, 10000.00, NULL, 'Within 12 hours', 'active', 'Provide your bank account details including account number, account name, and bank name.', '2026-01-09 12:53:05', '2026-04-06 21:21:20'),
(2, 'USDT (TRC20)', 'crypto', 10.00, 10000.00, NULL, 'Within 12 hours', 'active', 'Provide your USDT TRC20 wallet address. Make sure it is correct as transactions are irreversible.', '2026-01-09 12:53:05', '2026-04-06 21:21:28');

-- --------------------------------------------------------

--
-- Table structure for table `xtralog_orders`
--

CREATE TABLE `xtralog_orders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` varchar(100) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `server` tinyint(1) NOT NULL DEFAULT 1,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `unit_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total_charge` decimal(10,2) NOT NULL DEFAULT 0.00,
  `order_ref` varchar(100) NOT NULL,
  `api_response` text DEFAULT NULL,
  `logs_data` longtext DEFAULT NULL,
  `status` enum('pending','completed','failed') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `xtralog_products`
--

CREATE TABLE `xtralog_products` (
  `id` int(11) NOT NULL,
  `product_id` varchar(100) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `server` tinyint(1) NOT NULL DEFAULT 1,
  `api_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `our_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `category` varchar(100) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `synced_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `active_number`
--
ALTER TABLE `active_number`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `api_logs`
--
ALTER TABLE `api_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `idx_endpoint` (`endpoint`);

--
-- Indexes for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `slug` (`slug`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_category` (`category`),
  ADD KEY `idx_created` (`created_at`);

--
-- Indexes for table `cron_log`
--
ALTER TABLE `cron_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_run_time` (`run_time`);

--
-- Indexes for table `fivesim_countries`
--
ALTER TABLE `fivesim_countries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `country_key` (`country_key`);

--
-- Indexes for table `fivesim_orders`
--
ALTER TABLE `fivesim_orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_id5` (`order_id5`);

--
-- Indexes for table `fivesim_products`
--
ALTER TABLE `fivesim_products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_country_product` (`country_key`,`product`);

--
-- Indexes for table `gift_card_products`
--
ALTER TABLE `gift_card_products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_product_id` (`product_id`),
  ADD KEY `idx_country` (`country_code`),
  ADD KEY `idx_brand` (`brand_id`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `kyc_verifications`
--
ALTER TABLE `kyc_verifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `otp_server`
--
ALTER TABLE `otp_server`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `price_settings`
--
ALTER TABLE `price_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

--
-- Indexes for table `referrals`
--
ALTER TABLE `referrals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `referrer_id` (`referrer_id`),
  ADD KEY `referred_user_id` (`referred_user_id`),
  ADD KEY `referral_code` (`referral_code`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `referral_earnings`
--
ALTER TABLE `referral_earnings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `referral_id` (`referral_id`),
  ADD KEY `referrer_id` (`referrer_id`),
  ADD KEY `referred_user_id` (`referred_user_id`),
  ADD KEY `transaction_id` (`transaction_id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `seller_applications`
--
ALTER TABLE `seller_applications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `seller_withdrawals`
--
ALTER TABLE `seller_withdrawals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `sell_giftcard_types`
--
ALTER TABLE `sell_giftcard_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `service`
--
ALTER TABLE `service`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `service_icon`
--
ALTER TABLE `service_icon`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `service_logo`
--
ALTER TABLE `service_logo`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_service_id` (`service_id`);

--
-- Indexes for table `smm_orders`
--
ALTER TABLE `smm_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `jap_order_id` (`jap_order_id`),
  ADD KEY `status` (`status`),
  ADD KEY `smm_service_id` (`smm_service_id`);

--
-- Indexes for table `smm_services`
--
ALTER TABLE `smm_services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `jap_service_id` (`jap_service_id`),
  ADD KEY `category` (`category`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `smsbus_countries`
--
ALTER TABLE `smsbus_countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smsbus_orders`
--
ALTER TABLE `smsbus_orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `request_id` (`request_id`);

--
-- Indexes for table `smsbus_prices`
--
ALTER TABLE `smsbus_prices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_cp` (`country_id`,`project_id`);

--
-- Indexes for table `smsbus_projects`
--
ALTER TABLE `smsbus_projects`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smspva_cron_log`
--
ALTER TABLE `smspva_cron_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_run_time` (`run_time`);

--
-- Indexes for table `smspva_service_cache`
--
ALTER TABLE `smspva_service_cache`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_smspva_service` (`service_code`,`country_code`,`operator`),
  ADD KEY `idx_country` (`country_code`),
  ADD KEY `idx_service` (`service_code`);

--
-- Indexes for table `sm_categories`
--
ALTER TABLE `sm_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sm_purchases`
--
ALTER TABLE `sm_purchases`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `service_id` (`service_id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transaction_ref` (`transaction_ref`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `status` (`status`),
  ADD KEY `payment_gateway` (`payment_gateway`),
  ADD KEY `created_at` (`created_at`),
  ADD KEY `idx_transaction_type` (`transaction_type`);

--
-- Indexes for table `virtual_card_customers`
--
ALTER TABLE `virtual_card_customers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`),
  ADD KEY `idx_user` (`user_id`);

--
-- Indexes for table `virtual_card_transactions`
--
ALTER TABLE `virtual_card_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user` (`user_id`),
  ADD KEY `idx_card` (`card_id`),
  ADD KEY `idx_type` (`type`),
  ADD KEY `idx_created` (`created_at`);

--
-- Indexes for table `vtu_cable_plans`
--
ALTER TABLE `vtu_cable_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_provider` (`provider`);

--
-- Indexes for table `vtu_data_plans`
--
ALTER TABLE `vtu_data_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_network` (`network`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `withdrawal_method_id` (`withdrawal_method_id`),
  ADD KEY `status` (`status`),
  ADD KEY `created_at` (`created_at`),
  ADD KEY `processed_by` (`processed_by`),
  ADD KEY `idx_user_status` (`user_id`,`status`);

--
-- Indexes for table `withdrawal_methods`
--
ALTER TABLE `withdrawal_methods`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status` (`status`);

--
-- Indexes for table `xtralog_orders`
--
ALTER TABLE `xtralog_orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `order_ref` (`order_ref`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_product` (`product_id`);

--
-- Indexes for table `xtralog_products`
--
ALTER TABLE `xtralog_products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `product_id` (`product_id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_category` (`category`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `active_number`
--
ALTER TABLE `active_number`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `api_logs`
--
ALTER TABLE `api_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_posts`
--
ALTER TABLE `blog_posts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `cron_log`
--
ALTER TABLE `cron_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `fivesim_countries`
--
ALTER TABLE `fivesim_countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1072;

--
-- AUTO_INCREMENT for table `fivesim_orders`
--
ALTER TABLE `fivesim_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `fivesim_products`
--
ALTER TABLE `fivesim_products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83991;

--
-- AUTO_INCREMENT for table `gift_card_products`
--
ALTER TABLE `gift_card_products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13568;

--
-- AUTO_INCREMENT for table `kyc_verifications`
--
ALTER TABLE `kyc_verifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `otp_server`
--
ALTER TABLE `otp_server`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=280;

--
-- AUTO_INCREMENT for table `price_settings`
--
ALTER TABLE `price_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=213038;

--
-- AUTO_INCREMENT for table `referrals`
--
ALTER TABLE `referrals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `referral_earnings`
--
ALTER TABLE `referral_earnings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `seller_applications`
--
ALTER TABLE `seller_applications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `seller_withdrawals`
--
ALTER TABLE `seller_withdrawals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `sell_giftcard_types`
--
ALTER TABLE `sell_giftcard_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `service`
--
ALTER TABLE `service`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42395;

--
-- AUTO_INCREMENT for table `service_icon`
--
ALTER TABLE `service_icon`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- AUTO_INCREMENT for table `service_logo`
--
ALTER TABLE `service_logo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smm_orders`
--
ALTER TABLE `smm_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smm_services`
--
ALTER TABLE `smm_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4697;

--
-- AUTO_INCREMENT for table `smsbus_orders`
--
ALTER TABLE `smsbus_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `smsbus_prices`
--
ALTER TABLE `smsbus_prices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33843;

--
-- AUTO_INCREMENT for table `smspva_cron_log`
--
ALTER TABLE `smspva_cron_log`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smspva_service_cache`
--
ALTER TABLE `smspva_service_cache`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=218065;

--
-- AUTO_INCREMENT for table `sm_categories`
--
ALTER TABLE `sm_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `sm_purchases`
--
ALTER TABLE `sm_purchases`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117;

--
-- AUTO_INCREMENT for table `virtual_card_customers`
--
ALTER TABLE `virtual_card_customers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `virtual_card_transactions`
--
ALTER TABLE `virtual_card_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `vtu_cable_plans`
--
ALTER TABLE `vtu_cable_plans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `vtu_data_plans`
--
ALTER TABLE `vtu_data_plans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `withdrawal_methods`
--
ALTER TABLE `withdrawal_methods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `xtralog_orders`
--
ALTER TABLE `xtralog_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `xtralog_products`
--
ALTER TABLE `xtralog_products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26737;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `referrals`
--
ALTER TABLE `referrals`
  ADD CONSTRAINT `referrals_ibfk_1` FOREIGN KEY (`referrer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `referrals_ibfk_2` FOREIGN KEY (`referred_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sm_purchases`
--
ALTER TABLE `sm_purchases`
  ADD CONSTRAINT `sm_purchases_ibfk_1` FOREIGN KEY (`service_id`) REFERENCES `sm_services` (`id`) ON DELETE CASCADE;
COMMIT;

