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

--
-- Table structure for table `wallet`
--

CREATE TABLE `wallet` (
  `id` int(11) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `txn_id` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `txn_date` datetime DEFAULT current_timestamp(),
  `email` varchar(255) DEFAULT NULL,
  `PAYMENTMODE` varchar(255) DEFAULT NULL,
  `RESPMSG` varchar(255) DEFAULT NULL,
  `BANKTXNID` varchar(255) DEFAULT NULL,
  `status` enum('pending','success') DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wallet`
--

INSERT INTO `wallet` (`id`, `phone`, `amount`, `txn_id`, `date`, `txn_date`, `email`, `PAYMENTMODE`, `RESPMSG`, `BANKTXNID`, `status`) VALUES
(1, '9519778486', '101', NULL, NULL, '2025-10-05 17:17:47', NULL, 'UPI', 'Txn Success', '399311951438', 'success'),
(2, '7549202021', '1', NULL, NULL, '2025-10-05 20:44:24', NULL, 'UPI', 'Txn Success', '527820030042', 'success'),
(3, '8839494234', '200', NULL, NULL, '2025-10-06 12:14:29', NULL, 'UPI', 'Txn Success', '602267112498', 'success'),
(4, '7276569373', '200', NULL, NULL, '2025-10-06 14:02:44', NULL, 'UPI', 'Txn Success', '527924600791', 'success'),
(5, '9889149562', '200', NULL, NULL, '2025-10-06 17:40:37', NULL, 'UPI', 'Txn Success', '527920616683', 'success'),
(6, '7518020202', '200', NULL, NULL, '2025-10-06 20:42:08', NULL, 'UPI', 'Txn Success', '527970756004', 'success'),
(7, '9964517756', '200', NULL, NULL, '2025-10-07 12:03:34', NULL, 'UPI', 'Txn Success', '075448602352', 'success'),
(8, '6351764460', '200', NULL, NULL, '2025-10-08 09:49:41', NULL, 'UPI', 'Txn Success', '961317805044', 'success'),
(9, '7719602042', '200', NULL, NULL, '2025-10-08 13:08:08', NULL, 'UPI', 'Txn Success', '060596517763', 'success'),
(10, '7986173392', '300', NULL, NULL, '2025-10-08 20:16:33', NULL, 'UPI', 'Txn Success', '564741255150', 'success'),
(11, '7986173392', '200', NULL, NULL, '2025-10-09 09:13:33', NULL, 'UPI', 'Txn Success', '564831687009', 'success'),
(12, '9404944848', '200', NULL, NULL, '2025-10-09 11:39:44', NULL, 'UPI', 'Txn Success', '257607185601', 'success'),
(13, '8409785591', '49.00', NULL, NULL, '2025-10-10 18:37:46', NULL, 'UPI', 'Txn Success', '138038070708', 'success'),
(14, '8080446166', '200', NULL, NULL, '2025-10-10 22:32:41', NULL, 'UPI', 'Txn Success', '487437570859', 'success'),
(15, '8249622067', '200', NULL, NULL, '2025-10-11 13:01:50', NULL, 'UPI', 'Txn Success', '214164877714', 'success'),
(16, '9305042586', '99.00', NULL, NULL, '2025-10-11 15:30:51', NULL, 'UPI', 'Txn Success', '259515330288', 'success'),
(17, '7017915077', '49.00', NULL, NULL, '2025-10-11 16:45:54', NULL, 'UPI', 'Txn Success', '528482792773', 'success'),
(18, '9027862577', '49.00', NULL, NULL, '2025-10-11 23:06:38', NULL, 'UPI', 'Txn Success', '565029565571', 'success'),
(19, '9964517756', '300', NULL, NULL, '2025-10-12 10:57:46', NULL, 'UPI', 'Txn Success', '253680814363', 'success'),
(20, '9122222304', '49.00', NULL, NULL, '2025-10-12 16:38:31', NULL, 'UPI', 'Txn Success', '565140212458', 'success'),
(21, '9008600902', '49.00', NULL, NULL, '2025-10-13 07:58:36', NULL, 'UPI', 'Txn Success', '035627403030', 'success'),
(22, '9008600902', '250', NULL, NULL, '2025-10-13 09:18:44', NULL, 'UPI', 'Txn Success', '468376643419', 'success'),
(23, '8954848632', '49.00', NULL, NULL, '2025-10-13 09:40:44', NULL, 'UPI', 'Txn Success', '565260605251', 'success'),
(24, '9145131300', '200', NULL, NULL, '2025-10-13 10:23:48', NULL, 'UPI', 'Txn Success', '565283020849', 'success'),
(25, '8341941402', '99.00', NULL, NULL, '2025-10-13 11:46:59', NULL, 'UPI', 'Txn Success', '916484201931', 'success'),
(26, '8341941402', '200', NULL, NULL, '2025-10-13 11:58:21', NULL, 'UPI', 'Txn Success', '383149658436', 'success'),
(27, '8528877048', '49.00', NULL, NULL, '2025-10-13 14:54:45', NULL, 'UPI', 'Txn Success', '528608951822', 'success'),
(28, '9971122119', '49.00', NULL, NULL, '2025-10-14 05:57:12', NULL, 'UPI', 'Txn Success', '528769382467', 'success'),
(29, '9953290213', '200', NULL, NULL, '2025-10-14 11:49:01', NULL, 'UPI', 'Txn Success', '528742617394', 'success'),
(30, '7017915077', '200', NULL, NULL, '2025-10-14 12:26:26', NULL, 'UPI', 'Txn Success', '528715987014', 'success'),
(31, '9330699696', '49.00', NULL, NULL, '2025-10-14 14:49:27', NULL, 'UPI', 'Txn Success', '528738537989', 'success'),
(32, '9330699696', '200', NULL, NULL, '2025-10-14 15:26:04', NULL, 'UPI', 'Txn Success', '528720636251', 'success'),
(33, '8953558905', '99.00', NULL, NULL, '2025-10-14 23:42:24', NULL, 'UPI', 'Txn Success', '763155069242', 'success'),
(34, '8953558905', '200', NULL, NULL, '2025-10-15 10:54:27', NULL, 'UPI', 'Txn Success', '221678028389', 'success'),
(35, '8953558905', '200', NULL, NULL, '2025-10-15 11:42:06', NULL, 'UPI', 'Txn Success', '807696725086', 'success'),
(36, '7986173392', '200', NULL, NULL, '2025-10-15 12:06:44', NULL, 'UPI', 'Txn Success', '083743262577', 'success'),
(37, '9614501414', '49.00', NULL, NULL, '2025-10-15 19:24:32', NULL, 'UPI', 'Txn Success', '528880405305', 'success'),
(38, '7500042610', '49.00', NULL, NULL, '2025-10-15 20:38:55', NULL, 'UPI', 'Txn Success', '844577052071', 'success'),
(39, '7500042610', '200', NULL, NULL, '2025-10-15 21:05:56', NULL, 'UPI', 'Txn Success', '476746349002', 'success'),
(40, '9765008676', '49.00', NULL, NULL, '2025-10-16 12:54:22', NULL, 'UPI', 'Txn Success', '109555846212', 'success'),
(41, '8889633486', '49.00', NULL, NULL, '2025-10-16 13:05:45', NULL, 'UPI', 'Txn Success', '997216383229', 'success'),
(42, '9614501414', '200', NULL, NULL, '2025-10-17 14:24:46', NULL, 'UPI', 'Txn Success', '142438313846', 'success'),
(43, '9404944848', '200', NULL, NULL, '2025-10-23 16:24:13', NULL, 'UPI', 'Txn Success', '027328661293', 'success'),
(44, '8868825500', '49.00', NULL, NULL, '2025-10-24 07:33:30', NULL, 'UPI', 'Txn Success', '489427927247', 'success'),
(45, '7463944135', '49.00', NULL, NULL, '2025-10-24 19:48:00', NULL, 'UPI', 'Txn Success', '293886241016', 'success'),
(46, '7463944135', '200', NULL, NULL, '2025-10-24 19:49:52', NULL, 'UPI', 'Txn Success', '293886369694', 'success'),
(47, '9560469522', '49.00', NULL, NULL, '2025-10-24 20:52:38', NULL, 'UPI', 'Txn Success', '529720925618', 'success'),
(48, '8928467490', '99.00', NULL, NULL, '2025-10-25 16:44:47', NULL, 'UPI', 'Txn Success', '164430941447', 'success'),
(49, '6206990138', '49.00', NULL, NULL, '2025-10-25 18:03:17', NULL, 'UPI', 'Txn Success', '780091193738', 'success'),
(50, '7500042610', '200', NULL, NULL, '2025-10-25 23:59:59', NULL, 'UPI', 'Txn Success', '809532621281', 'success'),
(51, '9627562376', '99.00', NULL, NULL, '2025-10-26 09:48:32', NULL, 'UPI', 'Txn Success', '529973091112', 'success'),
(52, '9627562376', '200', NULL, NULL, '2025-10-26 09:53:28', NULL, 'UPI', 'Txn Success', '529973179829', 'success'),
(53, '8930403472', '99.00', NULL, NULL, '2025-10-26 11:55:17', NULL, 'UPI', 'Txn Success', '848278281454', 'success'),
(54, '7396073040', '49.00', NULL, NULL, '2025-10-26 22:46:24', NULL, 'UPI', 'Txn Success', '566511622088', 'success'),
(55, '8707021185', '200', NULL, NULL, '2025-10-27 10:52:49', NULL, 'UPI', 'Txn Success', '699176324655', 'success'),
(56, '8953268129', '49.00', NULL, NULL, '2025-10-27 11:37:14', NULL, 'UPI', 'Txn Success', '113247968506', 'success'),
(57, '9826427511', '49.00', NULL, NULL, '2025-10-27 19:57:13', NULL, 'UPI', 'Txn Success', '582440414524', 'success'),
(58, '9826427511', '200', NULL, NULL, '2025-10-27 20:34:23', NULL, 'UPI', 'Txn Success', '172927700429', 'success'),
(59, '9699258311', '99.00', NULL, NULL, '2025-10-28 12:18:56', NULL, 'UPI', 'Txn Success', '863821642989', 'success'),
(60, '6206990138', '200', NULL, NULL, '2025-10-28 12:43:44', NULL, 'UPI', 'Txn Success', '655889398530', 'success'),
(61, '9560469522', '200', NULL, NULL, '2025-10-28 16:38:30', NULL, 'UPI', 'Txn Success', '530116638855', 'success'),
(62, '9889004620', '49.00', NULL, NULL, '2025-10-28 17:48:46', NULL, 'UPI', 'Txn Success', '530153795147', 'success'),
(63, '9770235186', '49.00', NULL, NULL, '2025-10-29 10:31:44', NULL, 'UPI', 'Txn Success', '294104333183', 'success'),
(64, '9560852317', '99.00', NULL, NULL, '2025-10-29 15:58:42', NULL, 'UPI', 'Txn Success', '741662369637', 'success'),
(65, '9098225107', '49.00', NULL, NULL, '2025-10-30 19:19:37', NULL, 'UPI', 'Txn Success', '797834300295', 'success'),
(66, '7979725898', '49.00', NULL, NULL, '2025-10-30 20:41:14', NULL, 'UPI', 'Txn Success', '113408563455', 'success'),
(67, '6386583063', '49.00', NULL, NULL, '2025-10-31 09:34:09', NULL, 'UPI', 'Txn Success', '830706291093', 'success'),
(68, '9729553579', '99.00', NULL, NULL, '2025-10-31 10:39:41', NULL, 'UPI', 'Txn Success', '113423020141', 'success'),
(69, '9729553579', '200', NULL, NULL, '2025-10-31 10:41:54', NULL, 'UPI', 'Txn Success', '113423109973', 'success'),
(70, '9893929126', '49.00', NULL, NULL, '2025-10-31 10:57:24', NULL, 'UPI', 'Txn Success', '306905198959', 'success'),
(71, '9523558593', '49.00', NULL, NULL, '2025-10-31 11:05:18', NULL, 'UPI', 'Txn Success', '033986028702', 'success'),
(72, '8147974386', '49.00', NULL, NULL, '2025-10-31 11:12:47', NULL, 'UPI', 'Txn Success', '189195552785', 'success'),
(73, '8147974386', '200', NULL, NULL, '2025-10-31 11:18:26', NULL, 'UPI', 'Txn Success', '744300016869', 'success'),
(74, '6303623875', '49.00', NULL, NULL, '2025-11-01 00:30:51', NULL, 'UPI', 'Txn Success', '530524669279', 'success'),
(75, '9760305088', '49.00', NULL, NULL, '2025-11-01 17:15:26', NULL, 'UPI', 'Txn Success', '530502968449', 'success'),
(76, '9760305088', '200', NULL, NULL, '2025-11-01 17:16:27', NULL, 'UPI', 'Txn Success', '530594874918', 'success'),
(77, '9008600902', '200', NULL, NULL, '2025-11-01 20:04:27', NULL, 'UPI', 'Txn Success', '522821092521', 'success'),
(78, '8292547028', '49.00', NULL, NULL, '2025-11-02 07:01:23', NULL, 'UPI', 'Txn Success', '769392152215', 'success'),
(79, '7056717410', '49.00', NULL, NULL, '2025-11-02 15:05:20', NULL, 'UPI', 'Txn Success', '530636216741', 'success'),
(80, '7056717410', '200', NULL, NULL, '2025-11-02 18:10:38', NULL, 'UPI', 'Txn Success', '173947910916', 'success'),
(81, '8114051785', '49.00', NULL, NULL, '2025-11-03 19:22:21', NULL, 'UPI', 'Txn Success', '530752073214', 'success'),
(82, '8114051785', '200', NULL, NULL, '2025-11-03 19:26:41', NULL, 'UPI', 'Txn Success', '294404370329', 'success'),
(83, '7986173392', '300', NULL, NULL, '2025-11-04 08:47:00', NULL, 'UPI', 'Txn Success', '567445524388', 'success'),
(84, '7986173392', '250', NULL, NULL, '2025-11-04 12:29:31', NULL, 'UPI', 'Txn Success', '321685390309', 'success'),
(85, '7986173392', '200', NULL, NULL, '2025-11-04 12:34:16', NULL, 'UPI', 'Txn Success', '001022897709', 'success'),
(86, '6360446360', '99.00', NULL, NULL, '2025-11-05 12:34:49', NULL, 'UPI', 'Txn Success', '288044924110', 'success'),
(87, '6360446360', '200', NULL, NULL, '2025-11-05 12:39:38', NULL, 'UPI', 'Txn Success', '646961227244', 'success'),
(88, '7986173392', '200', NULL, NULL, '2025-11-05 20:57:16', NULL, 'UPI', 'Txn Success', '245658934486', 'success'),
(89, '7799772349', '49.00', NULL, NULL, '2025-11-06 10:56:12', NULL, 'UPI', 'Txn Success', '761674132996', 'success'),
(90, '7799772349', '200', NULL, NULL, '2025-11-06 10:56:57', NULL, 'UPI', 'Txn Success', '686005973468', 'success'),
(91, '6202421380', '200', NULL, NULL, '2025-11-06 14:13:39', NULL, 'UPI', 'Txn Success', '531090087594', 'success'),
(92, '9977874993', '49.00', NULL, NULL, '2025-11-06 14:40:56', NULL, 'UPI', 'Txn Success', '121642778213', 'success'),
(93, '9977874993', '200', NULL, NULL, '2025-11-06 14:43:57', NULL, 'UPI', 'Txn Success', '357225955505', 'success'),
(94, '7986173392', '200', NULL, NULL, '2025-11-06 16:55:31', NULL, 'UPI', 'Txn Success', '531029727963', 'success'),
(95, '7428306344', '49.00', NULL, NULL, '2025-11-06 20:18:27', NULL, 'UPI', 'Txn Success', '531089617364', 'success'),
(96, '7738319028', '49.00', NULL, NULL, '2025-11-06 20:20:39', NULL, 'UPI', 'Txn Success', '531094486755', 'success'),
(97, '7428306344', '200', NULL, NULL, '2025-11-06 20:22:01', NULL, 'UPI', 'Txn Success', '531089682250', 'success'),
(98, '7738319028', '200', NULL, NULL, '2025-11-06 20:27:56', NULL, 'UPI', 'Txn Success', '531056099413', 'success'),
(99, '9765008676', '200', NULL, NULL, '2025-11-06 20:46:37', NULL, 'UPI', 'Txn Success', '410147632763', 'success'),
(100, '8360626185', '49.00', NULL, NULL, '2025-11-06 23:27:49', NULL, 'UPI', 'Txn Success', '294583063042', 'success'),
(101, '9348296279', '49.00', NULL, NULL, '2025-11-07 18:42:55', NULL, 'UPI', 'Txn Success', '531173435641', 'success'),
(102, '6200471448', '99.00', NULL, NULL, '2025-11-08 09:52:28', NULL, 'UPI', 'Txn Success', '531201905115', 'success'),
(103, '6200471448', '250', NULL, NULL, '2025-11-08 09:54:02', NULL, 'UPI', 'Txn Success', '531201906971', 'success'),
(104, '9660934479', '49.00', NULL, NULL, '2025-11-08 11:03:20', NULL, 'UPI', 'Txn Success', '058567289085', 'success'),
(105, '7986173392', '250', NULL, NULL, '2025-11-08 13:50:20', NULL, 'UPI', 'Txn Success', '531282277514', 'success'),
(106, '8839494234', '200', NULL, NULL, '2025-11-08 17:21:07', NULL, 'UPI', 'Txn Success', '795776316881', 'success');

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

--
-- Table structure for table `wallethistory`
--

CREATE TABLE `wallethistory` (
  `id` int(11) NOT NULL,
  `userid` varchar(255) DEFAULT NULL,
  `amount` varchar(255) DEFAULT NULL,
  `oldbalance` varchar(100) DEFAULT NULL,
  `balance` varchar(255) DEFAULT NULL,
  `purpose` longtext DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wallethistory`
--

INSERT INTO `wallethistory` (`id`, `userid`, `amount`, `oldbalance`, `balance`, `purpose`, `status`, `type`, `date`) VALUES
(1, '7276569373', '2', NULL, '198', 'Mobile Look Up Find', '1', 'Debit', '2025-10-06 10:35:43'),
(2, '9889149562', '20', NULL, '180', 'DL PDF Verification', '1', 'Debit', '2025-10-06 14:19:44'),
(3, '7275747773', '100', NULL, '100', 'Admin Credit (other)', '1', 'credit', '2025-10-07 19:10:50'),
(4, '7275747773', '100', NULL, '200', 'Admin Credit (other)', '1', 'credit', '2025-10-07 19:11:14'),
(5, '9519778486', '50', NULL, '10051', 'Mobile to PAN Verification', '1', 'Debit', '2025-10-07 19:31:24'),
(6, '7970715727', '5000', NULL, '5000', 'Admin Credit (other)', '1', 'credit', '2025-10-08 06:19:59'),
(7, '6351764460', '10', NULL, '190', 'Pan Manual Print', '1', 'Debit', '2025-10-08 08:02:03'),
(8, '7970715727', '30', NULL, '4970', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-08 08:24:26'),
(9, '9964517756', '199', NULL, '200', 'Recharge Payment', '1', 'Debit', '2025-10-08 08:26:45'),
(10, '9964517756', '2.99', NULL, '3.99', 'Recharge Commission', '1', 'Credit', '2025-10-08 08:26:45'),
(11, '7719602042', '30', NULL, '170', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-08 09:42:52'),
(12, '9145131300', '50', NULL, '50', 'Admin Credit (other)', '1', 'credit', '2025-10-08 10:40:50'),
(13, '9145131300', '2', NULL, '48', 'Uid To Mask  Pan', '1', 'Debit', '2025-10-08 11:20:13'),
(14, '7275747773', '50', NULL, '150', 'Chassis to RC Verification', '1', 'Debit', '2025-10-08 15:58:29'),
(15, '7986173392', '299', NULL, '300', 'Recharge Payment', '1', 'Debit', '2025-10-08 16:48:01'),
(16, '7986173392', '3.59', NULL, '4.59', 'Recharge Commission', '1', 'Credit', '2025-10-08 16:48:01'),
(17, '8839494234', '30', NULL, '170', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-09 03:51:57'),
(18, '7986173392', '155', NULL, '204.59', 'Recharge Payment', '1', 'Debit', '2025-10-09 05:44:03'),
(19, '7986173392', '4.65', NULL, '54.24', 'Recharge Commission', '1', 'Credit', '2025-10-09 05:44:03'),
(20, '8839494234', '30', NULL, '140', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-09 06:42:11'),
(21, '7970715727', '20', NULL, '4950', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-09 07:30:07'),
(22, '7970715727', '20', NULL, '4930', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-09 08:50:02'),
(23, '9404944848', '30', NULL, '170', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-09 09:04:39'),
(24, '8839494234', '30', NULL, '110', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-09 11:37:14'),
(25, '9404944848', '20', NULL, '150', '4161988925 Learning Licence PDF Verification', '1', 'Debit', '2025-10-09 15:13:14'),
(26, '9519778486', '20', NULL, '10031', '4148043625 Learning Licence PDF Verification', '1', 'Debit', '2025-10-09 17:19:31'),
(27, '8839494234', '30', NULL, '80', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-10 09:11:46'),
(28, '9404944848', '30', NULL, '120', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-10 12:00:45'),
(29, '9404944848', '30', NULL, '90', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-10 13:51:26'),
(30, '9404944848', '30', NULL, '60', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-10 14:35:40'),
(31, '9938893600', '200', NULL, '200', 'Admin Credit (other)', '1', 'credit', '2025-10-10 16:23:47'),
(32, '8080446166', '30', NULL, '170', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-10 19:03:27'),
(33, '8080446166', '30', NULL, '140', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-10 19:04:20'),
(34, '8080446166', '30', NULL, '110', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-10 19:04:52'),
(35, '9938893600', '10', NULL, '190', 'Upi Id To Bank Details Verification', '1', 'Debit', '2025-10-11 03:24:30'),
(36, '9938893600', '2', NULL, '188', 'Mobile Look Up Find', '1', 'Debit', '2025-10-11 03:27:28'),
(37, '9519778486', '20', NULL, '10011', 'NSDL Activation', '1', 'Debit', '2025-10-11 06:47:59'),
(38, '9938893600', '10', NULL, '178', 'Pan Manual Print', '1', 'Debit', '2025-10-11 09:31:25'),
(39, '8249622067', '20', NULL, '180', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-11 10:37:37'),
(40, '8249622067', '20', NULL, '160', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-11 15:16:39'),
(41, '9964517756', '299', NULL, '303.99', 'Recharge Payment', '1', 'Debit', '2025-10-12 07:34:20'),
(42, '9964517756', '3.59', NULL, '8.58', 'Recharge Commission', '1', 'Credit', '2025-10-12 07:34:20'),
(43, '8839494234', '30', NULL, '50', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-12 13:05:13'),
(44, '9964517756', '2', NULL, '6.58', 'Mobile Look Up Find', '1', 'Debit', '2025-10-12 14:37:49'),
(45, '9720460020', '10', NULL, '15', 'Upi Id To Bank Details Verification', '1', 'Debit', '2025-10-12 22:41:53'),
(46, '9720460020', '10', NULL, '5', 'Upi Id To Bank Details Verification', '1', 'Debit', '2025-10-12 22:44:57'),
(47, '9008600902', '20', NULL, '230', 'Voter Advance Print', '1', 'Debit', '2025-10-13 05:50:08'),
(48, '9145131300', '147', NULL, '101', 'Pan to Aadhar Find', '1', 'Debit', '2025-10-13 06:54:59'),
(49, '9519778486', '0', NULL, '9991', 'This data was fetched from system records. No wallet balance was deducted.', '1', 'Debit', '2025-10-14 06:29:35'),
(50, '7986173392', '10', NULL, '54.24', 'Recharge Payment', '1', 'Debit', '2025-10-14 07:10:19'),
(51, '7986173392', '0.35', NULL, '44.59', 'Recharge Commission', '1', 'Credit', '2025-10-14 07:10:19'),
(52, '9953290213', '20', NULL, '180', 'Aadhar PVC  pDF', '1', 'Debit', '2025-10-14 08:21:38'),
(53, '9330699696', '49', NULL, '151', 'Vehicle 2 Mobile Find Verification', '1', 'Debit', '2025-10-14 12:38:35'),
(54, '9330699696', '10', NULL, '141', 'Pan Manual Print', '1', 'Debit', '2025-10-14 12:52:36'),
(55, '9330699696', '10', NULL, '131', 'Pan  To Pan Verification', '1', 'Debit', '2025-10-14 13:55:32'),
(56, '9330699696', '10', NULL, '121', 'Pan  To Pan Verification', '1', 'Debit', '2025-10-14 13:56:31'),
(57, '9330699696', '100', NULL, '21', 'Mobile Number To  Details Verification', '1', 'Debit', '2025-10-14 14:03:26'),
(58, '9330699696', '10', NULL, '11', 'Upi Id To Bank Details Verification', '1', 'Debit', '2025-10-14 14:48:01'),
(59, '9330699696', '2', NULL, '9', 'IFSC Lookup', '1', 'Debit', '2025-10-14 14:50:38'),
(60, '8953558905', '20', NULL, '180', 'NSDL Activation', '1', 'Debit', '2025-10-15 07:25:27'),
(61, '7970715727', '30', NULL, '4900', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-15 09:02:36'),
(62, '7970715727', '30', NULL, '4870', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-15 09:08:06'),
(63, '9008600902', '20', NULL, '210', 'Voter Advance Print', '1', 'Debit', '2025-10-15 11:45:51'),
(64, '9008600902', '20', NULL, '190', 'Voter Advance Print', '1', 'Debit', '2025-10-15 12:07:24'),
(65, '7719602042', '20', NULL, '150', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-15 14:45:32'),
(66, '8953558905', '365', NULL, '380', 'Recharge Payment', '1', 'Debit', '2025-10-15 15:55:28'),
(67, '8953558905', '10.95', NULL, '25.95', 'Recharge Commission', '1', 'Credit', '2025-10-15 15:55:28'),
(68, '7007332130', '20', NULL, '160', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-15 16:21:41'),
(69, '7500042610', '100', NULL, '100', 'Mobile Number To  Details Verification', '1', 'Debit', '2025-10-15 17:37:05'),
(70, '7500042610', '2', NULL, '98', 'Mobile Look Up Find', '1', 'Debit', '2025-10-15 17:51:28'),
(71, '7500042610', '20', NULL, '78', 'NSDL Activation', '1', 'Debit', '2025-10-15 17:55:04'),
(72, '8953558905', '22', NULL, '25.95', 'Recharge Payment', '1', 'Debit', '2025-10-15 18:39:22'),
(73, '8953558905', '0.66', NULL, '4.61', 'Recharge Commission', '1', 'Credit', '2025-10-15 18:39:22'),
(74, '9008600902', '20', NULL, '170', 'Voter Advance Print', '1', 'Debit', '2025-10-16 06:33:06'),
(75, '8341941402', '10', NULL, '190', 'Pan Manual Print', '1', 'Debit', '2025-10-16 07:06:00'),
(76, '9953290213', '99', NULL, '81', 'Upgrade to Distributor | Fee: ₹99 | Old: 180 | New: 81', '1', 'Debit', '2025-10-16 10:41:36'),
(77, '9953290213', '20', NULL, '61', 'NSDL Activation', '1', 'Debit', '2025-10-16 10:43:03'),
(78, '7970715727', '30', NULL, '4840', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-16 10:49:16'),
(79, '9330699696', '200', NULL, '209', 'Admin Credit (other)', '1', 'credit', '2025-10-16 17:42:10'),
(80, '9330699696', '30', NULL, '179', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-16 17:48:28'),
(81, '9330699696', '30', NULL, '149', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-16 17:50:13'),
(82, '9145131300', '25', NULL, '81', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-17 10:09:00'),
(83, '9145131300', '10', NULL, '66', 'Pan Manual Print', '1', 'Debit', '2025-10-17 10:23:18'),
(84, '9404944848', '20', NULL, '40', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-17 11:33:04'),
(85, '9404944848', '0', NULL, '20', 'This data was fetched from system records. No wallet balance was deducted.', '1', 'Debit', '2025-10-17 11:33:36'),
(86, '7500042610', '2', NULL, '76', 'IFSC Lookup', '1', 'Debit', '2025-10-20 07:19:06'),
(87, '7500042610', '2', NULL, '74', 'IFSC Lookup', '1', 'Debit', '2025-10-20 07:21:18'),
(88, '7500042610', '25', NULL, '54', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-20 09:14:38'),
(89, '7500042610', '2', NULL, '47', 'Uid To Mask  Pan', '1', 'Debit', '2025-10-20 09:16:46'),
(90, '7500042610', '15', NULL, '32', 'Pan  To Pan Verification', '1', 'Debit', '2025-10-20 09:18:48'),
(91, '9404944848', '30', NULL, '10', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-21 12:59:20'),
(92, '9519778486', '20', NULL, '9991', 'Driving Licence To Mobile Finder', '1', 'Debit', '2025-10-21 22:10:09'),
(93, '9008600902', '20', NULL, '150', 'Voter Advance Print', '1', 'Debit', '2025-10-22 08:07:37'),
(94, '9008600902', '20', NULL, '130', 'Voter Advance Print', '1', 'Debit', '2025-10-22 08:08:22'),
(95, '9404944848', '30', NULL, '180', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-23 12:54:51'),
(96, '9404944848', '30', NULL, '150', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-23 12:55:27'),
(97, '9404944848', '30', NULL, '120', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-23 13:02:44'),
(98, '7986173392', '10', NULL, '244.59', 'Recharge Payment', '1', 'Debit', '2025-10-23 14:51:29'),
(99, '7986173392', '0.3', NULL, '234.89', 'Recharge Commission', '1', 'Credit', '2025-10-23 14:51:29'),
(100, '9008600902', '20', NULL, '110', 'Voter Advance Print', '1', 'Debit', '2025-10-24 07:51:55'),
(101, '9008600902', '20', NULL, '90', 'Voter Advance Print', '1', 'Debit', '2025-10-24 13:49:16'),
(102, '7463944135', '20', NULL, '180', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-24 16:21:29'),
(103, '7500042610', '20', NULL, '12', 'Voter Advance Print', '1', 'Debit', '2025-10-24 18:56:13'),
(104, '9330699696', '2', NULL, '147', 'Uid To Mask  Pan', '1', 'Debit', '2025-10-25 11:30:53'),
(105, '9330699696', '20', NULL, '127', 'Aadhar To Ration Pdf ', '1', 'Debit', '2025-10-25 11:33:50'),
(106, '9330699696', '50', NULL, '77', 'GSTIN to Contact Verification', '1', 'Debit', '2025-10-25 11:49:13'),
(107, '9330699696', '30', NULL, '47', 'GST to PAN With Gst Details Find', '1', 'Debit', '2025-10-25 11:52:56'),
(108, '9330699696', '30', NULL, '17', 'GST to PAN With Gst Details Find', '1', 'Debit', '2025-10-25 11:54:31'),
(109, '9627562376', '20', NULL, '180', 'Ayushman Print PMJAY', '1', 'Debit', '2025-10-26 05:57:34'),
(110, '7500042610', '20', NULL, '192', 'Aadhar Manual  print', '1', 'Debit', '2025-10-26 18:12:44'),
(111, '9938893600', '22', NULL, '178', 'Recharge Payment', '1', 'Debit', '2025-10-27 05:00:32'),
(112, '9938893600', '0.33', NULL, '156.33', 'Recharge Commission', '1', 'Credit', '2025-10-27 05:00:32'),
(113, '8707021185', '30', NULL, '170', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-27 06:26:20'),
(114, '8707021185', '30', NULL, '140', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-27 06:29:13'),
(115, '8249622067', '20', NULL, '140', 'DL PDF Verification', '1', 'Debit', '2025-10-27 07:44:07'),
(116, '6351764460', '10', NULL, '180', 'Pan Manual Print', '1', 'Debit', '2025-10-27 13:16:19'),
(117, '9953290213', '10', NULL, '51', 'Voter Original PDF Download', '1', 'Debit', '2025-10-27 14:10:51'),
(118, '8341941402', '10', NULL, '180', 'Pan  To Pan Verification', '1', 'Debit', '2025-10-27 15:19:09'),
(119, '9826427511', '20', NULL, '180', ' Ration Pdf ', '1', 'Debit', '2025-10-28 04:52:55'),
(120, '9826427511', '20', NULL, '160', ' Ration Pdf ', '1', 'Debit', '2025-10-28 04:54:26'),
(121, '6206990138', '20', NULL, '180', 'Voter Advance Print', '1', 'Debit', '2025-10-28 08:17:53'),
(122, '6351764460', '10', NULL, '170', 'Pan Manual Print', '1', 'Debit', '2025-10-28 08:17:57'),
(123, '9938893600', '26', NULL, '156.33', 'Recharge Payment', '1', 'Debit', '2025-10-28 10:26:53'),
(124, '9938893600', '0.39', NULL, '130.72', 'Recharge Commission', '1', 'Credit', '2025-10-28 10:26:53'),
(125, '6206990138', '20', NULL, '160', 'Aadhar Manual  print', '1', 'Debit', '2025-10-28 13:24:05'),
(126, '6206990138', '20', NULL, '140', 'Aadhar Manual  print', '1', 'Debit', '2025-10-28 13:44:58'),
(127, '7986173392', '198', NULL, '234.89000000000001', 'Recharge Payment', '1', 'Debit', '2025-10-29 06:13:19'),
(128, '7986173392', '2.38', NULL, '39.27', 'Recharge Commission', '1', 'Credit', '2025-10-29 06:13:19'),
(129, '7017915077', '10', NULL, '190', 'Pan  To Pan Verification', '1', 'Debit', '2025-10-29 07:30:45'),
(130, '8707021185', '20', NULL, '120', ' Ration Pdf ', '1', 'Debit', '2025-10-29 07:32:16'),
(131, '7275747773', '30', NULL, '120', 'Vehicle PDF Verification', '1', 'Debit', '2025-10-29 11:04:47'),
(132, '6206990138', '20', NULL, '120', 'Aadhar Manual  print', '1', 'Debit', '2025-10-29 12:35:10'),
(133, '9008600902', '20', NULL, '70', 'Voter Advance Print', '1', 'Debit', '2025-10-30 06:25:54'),
(134, '9008600902', '20', NULL, '50', 'Voter Advance Print', '1', 'Debit', '2025-10-30 06:27:03'),
(135, '7500042610', '20', NULL, '172', 'Voter Advance Print', '1', 'Debit', '2025-10-30 08:33:12'),
(136, '7500042610', '20', NULL, '152', 'Voter Advance Print', '1', 'Debit', '2025-10-30 08:34:57'),
(137, '7500042610', '20', NULL, '132', 'Voter Advance Print', '1', 'Debit', '2025-10-30 09:05:12'),
(138, '7500042610', '20', NULL, '112', 'Voter Advance Print', '1', 'Debit', '2025-10-30 09:10:08'),
(139, '9008600902', '20', NULL, '30', 'Aadhar Manual  print', '1', 'Debit', '2025-10-31 05:19:23'),
(140, '8147974386', '20', NULL, '180', 'Aadhar To Ration Pdf ', '1', 'Debit', '2025-10-31 06:49:25'),
(141, '8147974386', '20', NULL, '160', 'Aadhar To Ration Pdf ', '1', 'Debit', '2025-10-31 06:50:02'),
(142, '9627562376', '30', NULL, '150', 'Agri Farmer Card  PDF', '1', 'Debit', '2025-10-31 07:01:21'),
(143, '9729553579', '20', NULL, '180', 'Aadhar To Pan Verification', '1', 'Debit', '2025-10-31 07:44:08'),
(144, '7970715727', '200', NULL, '4640', 'Ration to UID All State Verification', '1', 'Debit', '2025-10-31 11:48:16'),
(145, '7986173392', '10', NULL, '39.27000000000002', 'Recharge Payment', '1', 'Debit', '2025-10-31 14:05:56'),
(146, '7986173392', '0.3', NULL, '29.57', 'Recharge Commission', '1', 'Credit', '2025-10-31 14:05:56'),
(147, '9938893600', '16', NULL, '130.72', 'Recharge Payment', '1', 'Debit', '2025-10-31 14:34:15'),
(148, '9938893600', '0.56', NULL, '115.28', 'Recharge Commission', '1', 'Credit', '2025-10-31 14:34:15'),
(149, '7500042610', '20', NULL, '92', 'Voter Advance Print', '1', 'Debit', '2025-10-31 18:33:03'),
(150, '7500042610', '20', NULL, '72', 'Voter Advance Print', '1', 'Debit', '2025-10-31 18:34:31'),
(151, '7500042610', '20', NULL, '52', 'Voter Advance Print', '1', 'Debit', '2025-11-01 08:28:50'),
(152, '7007332130', '20', NULL, '140', 'Aadhar To Pan Verification', '1', 'Debit', '2025-11-01 08:57:56'),
(153, '7986173392', '10', NULL, '29.570000000000018', 'Recharge Payment', '1', 'Debit', '2025-11-01 12:06:35'),
(154, '7986173392', '0.3', NULL, '19.87', 'Recharge Commission', '1', 'Credit', '2025-11-01 12:06:35'),
(155, '9826427511', '30', NULL, '130', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-01 13:17:24'),
(156, '9008600902', '20', NULL, '10', 'Aadhar Manual  print', '1', 'Debit', '2025-11-01 15:17:37'),
(157, '9519778486', '20', NULL, '9971', 'DL PDF Verification', '1', 'Debit', '2025-11-01 16:34:54'),
(158, '9519778486', '49', NULL, '9922', 'Vehicle 2 Mobile Find Verification', '1', 'Debit', '2025-11-01 16:36:52'),
(159, '9519778486', '30', NULL, '9892', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-01 16:37:48'),
(160, '8707021185', '20', NULL, '100', 'Aadhar To Pan Verification', '1', 'Debit', '2025-11-02 05:05:03'),
(161, '7500042610', '20', NULL, '32', 'Voter Advance Print', '1', 'Debit', '2025-11-02 11:07:32'),
(162, '9760305088', '20', NULL, '180', 'Aadhar To Pan Verification', '1', 'Debit', '2025-11-02 11:09:36'),
(163, '7056717410', '20', NULL, '180', 'Aadhar Manual  print', '1', 'Debit', '2025-11-02 13:45:04'),
(164, '9953290213', '20', NULL, '31', 'Aadhar To Pan Verification', '1', 'Debit', '2025-11-02 14:41:16'),
(165, '9953290213', '10', NULL, '21', 'Pan Manual Print', '1', 'Debit', '2025-11-02 14:54:50'),
(166, '9008600902', '20', NULL, '190', 'Voter Advance Print', '1', 'Debit', '2025-11-02 16:27:40'),
(167, '7500042610', '20', NULL, '12', 'Voter Advance Print', '1', 'Debit', '2025-11-03 08:03:45'),
(168, '9826427511', '20', NULL, '110', 'Voter Advance Print', '1', 'Debit', '2025-11-03 09:08:20'),
(169, '9826427511', '20', NULL, '90', 'Voter Advance Print', '1', 'Debit', '2025-11-03 09:13:08'),
(170, '9826427511', '20', NULL, '70', 'Voter Advance Print', '1', 'Debit', '2025-11-03 09:15:22'),
(171, '9519778486', '30', NULL, '9862', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-03 10:06:55'),
(172, '9519778486', '10', NULL, '9852', 'Upi Id To Bank Details Verification', '1', 'Debit', '2025-11-03 14:10:45'),
(173, '9938893600', '16', NULL, '115.28', 'Recharge Payment', '1', 'Debit', '2025-11-03 14:50:59'),
(174, '9938893600', '0.56', NULL, '99.84', 'Recharge Commission', '1', 'Credit', '2025-11-03 14:50:59'),
(175, '8114051785', '30', NULL, '170', 'Agri Farmer Card  PDF', '1', 'Debit', '2025-11-03 15:05:59'),
(176, '7986173392', '299', NULL, '319.87', 'Recharge Payment', '1', 'Debit', '2025-11-04 04:17:42'),
(177, '7986173392', '8.97', NULL, '29.84', 'Recharge Commission', '1', 'Credit', '2025-11-04 04:17:42'),
(178, '7986173392', '299', NULL, '479.84000000000003', 'Recharge Payment', '1', 'Debit', '2025-11-04 08:04:48'),
(179, '7986173392', '8.97', NULL, '189.81', 'Recharge Commission', '1', 'Credit', '2025-11-04 08:04:48'),
(180, '9560469522', '30', NULL, '170', 'Aadhar Advance ', '1', 'Debit', '2025-11-04 12:10:51'),
(181, '9560469522', '30', NULL, '140', 'Aadhar Advance ', '1', 'Debit', '2025-11-04 12:20:40'),
(182, '9938893600', '16', NULL, '99.84', 'Recharge Payment', '1', 'Debit', '2025-11-04 12:25:26'),
(183, '9938893600', '0.56', NULL, '84.4', 'Recharge Commission', '1', 'Credit', '2025-11-04 12:25:26'),
(184, '6360446360', '2', NULL, '198', 'Mobile Look Up Find', '1', 'Debit', '2025-11-05 09:06:04'),
(185, '9938893600', '16', NULL, '84.4', 'Recharge Payment', '1', 'Debit', '2025-11-05 09:16:32'),
(186, '9938893600', '0.56', NULL, '68.96', 'Recharge Commission', '1', 'Credit', '2025-11-05 09:16:32'),
(187, '7986173392', '299', NULL, '389.81000000000006', 'Recharge Payment', '1', 'Debit', '2025-11-05 16:28:12'),
(188, '7986173392', '3.59', NULL, '94.4', 'Recharge Commission', '1', 'Credit', '2025-11-05 16:28:12'),
(189, '9953290213', '2', NULL, '19', 'Mobile Look Up Find', '1', 'Debit', '2025-11-05 19:36:04'),
(190, '8249622067', '20', NULL, '120', 'Aadhar To Pan Verification', '1', 'Debit', '2025-11-06 05:33:41'),
(191, '8839494234', '30', NULL, '20', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-06 10:07:26'),
(192, '7986173392', '199', NULL, '294.4000000000001', 'Recharge Payment', '1', 'Debit', '2025-11-06 12:26:14'),
(193, '7986173392', '2.99', NULL, '98.39', 'Recharge Commission', '1', 'Credit', '2025-11-06 12:26:14'),
(194, '6351764460', '10', NULL, '160', 'Pan Manual Print', '1', 'Debit', '2025-11-06 13:05:13'),
(195, '6351764460', '10', NULL, '150', 'Pan Manual Print', '1', 'Debit', '2025-11-06 13:07:27'),
(196, '6351764460', '10', NULL, '140', 'Pan  To Pan Verification', '1', 'Debit', '2025-11-06 13:10:35'),
(197, '6351764460', '10', NULL, '130', 'Pan Manual Print', '1', 'Debit', '2025-11-06 13:11:18'),
(198, '6351764460', '10', NULL, '120', 'Pan  To Pan Verification', '1', 'Debit', '2025-11-06 13:22:58'),
(199, '6351764460', '10', NULL, '110', 'Pan Manual Print', '1', 'Debit', '2025-11-06 13:25:41'),
(200, '9330699696', '10', NULL, '7', 'Upi Id To Bank Details Verification', '1', 'Debit', '2025-11-06 14:23:49'),
(201, '7428306344', '2', NULL, '198', 'Pan To Mask  Aadhar', '1', 'Debit', '2025-11-06 16:01:38'),
(202, '9519778486', '100', NULL, '9752', 'Ration 2 uid Find', '1', 'Debit', '2025-11-06 16:03:07'),
(203, '7428306344', '100', NULL, '298', 'Admin Credit (other)', '1', 'credit', '2025-11-06 16:04:31'),
(204, '7428306344', '200', NULL, '98', 'Debit from 7428306344 (other)', '1', 'debit', '2025-11-06 16:04:48'),
(205, '9519778486', '200', NULL, '9952', 'Received from 7428306344 (other)', '1', 'credit', '2025-11-06 16:04:48'),
(206, '7738319028', '20', NULL, '180', 'Debit from 7738319028 (other)', '1', 'debit', '2025-11-06 16:15:14'),
(207, '9519778486', '20', NULL, '9972', 'Received from 7738319028 (other)', '1', 'credit', '2025-11-06 16:15:14'),
(208, '9765008676', '30', NULL, '170', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-06 16:19:01'),
(209, '9765008676', '30', NULL, '140', 'Agri Farmer Card  PDF', '1', 'Debit', '2025-11-06 16:49:54'),
(210, '7799772349', '30', NULL, '170', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-06 17:17:56'),
(211, '6202421380', '198', NULL, '200', 'Recharge Payment', '1', 'Debit', '2025-11-06 23:19:33'),
(212, '6202421380', '2.38', NULL, '4.38', 'Recharge Commission', '1', 'Credit', '2025-11-06 23:19:33'),
(213, '9938893600', '29', NULL, '68.96000000000001', 'Recharge Payment', '1', 'Debit', '2025-11-07 19:36:27'),
(214, '9938893600', '0.35', NULL, '40.31', 'Recharge Commission', '1', 'Credit', '2025-11-07 19:36:27'),
(215, '7986173392', '10', NULL, '98.39000000000009', 'Recharge Payment', '1', 'Debit', '2025-11-08 04:47:59'),
(216, '7986173392', '0.15', NULL, '88.54', 'Recharge Commission', '1', 'Credit', '2025-11-08 04:47:59'),
(217, '8249622067', '30', NULL, '90', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-08 07:01:03'),
(218, '8249622067', '20', NULL, '70', 'DL PDF Verification', '1', 'Debit', '2025-11-08 07:05:06'),
(219, '8249622067', '30', NULL, '40', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-08 07:08:12'),
(220, '7986173392', '299', NULL, '338.5400000000001', 'Recharge Payment', '1', 'Debit', '2025-11-08 09:21:01'),
(221, '7986173392', '4.49', NULL, '44.03', 'Recharge Commission', '1', 'Credit', '2025-11-08 09:21:01'),
(222, '6206990138', '20', NULL, '100', 'Aadhar Manual  print', '1', 'Debit', '2025-11-08 12:03:26'),
(223, '7799772349', '30', NULL, '140', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-08 12:39:28'),
(224, '8839494234', '30', NULL, '190', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-08 12:52:00'),
(225, '8839494234', '30', NULL, '160', 'Vehicle PDF Verification', '1', 'Debit', '2025-11-08 12:52:57');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `aadharauto`
--
ALTER TABLE `aadharauto`
  ADD PRIMARY KEY (`aadharautoid`);

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

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

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

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

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

--
-- Indexes for table `contact_replies`
--
ALTER TABLE `contact_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contact_id` (`contact_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `voterauto1`
--
ALTER TABLE `voterauto1`
  ADD PRIMARY KEY (`voterautoid`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `aadharauto`
--
ALTER TABLE `aadharauto`
  MODIFY `aadharautoid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `importantlink`
--
ALTER TABLE `importantlink`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `voterauto1`
--
ALTER TABLE `voterauto1`
  MODIFY `voterautoid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `contact_replies`
--
ALTER TABLE `contact_replies`
  ADD CONSTRAINT `contact_replies_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `contact_queries` (`id`) ON DELETE CASCADE;
COMMIT;

