[BLOB]', '2025-10-31 11:19:25');
INSERT INTO `ration_pdf` (`id`, `name`, `username`, `aadhar`, `pdf`, `date`) VALUES
(6, '', '8147974386', '', 'data:application/pdf;base64,[BLOB]', '2025-10-31 11:20:02');

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

--
-- Table structure for table `ration_to_aadhar_requests`
--

CREATE TABLE `ration_to_aadhar_requests` (
  `id` int(11) NOT NULL,
  `userid` varchar(20) NOT NULL,
  `ration_no` varchar(30) NOT NULL,
  `order_id` varchar(50) NOT NULL,
  `status` enum('Pending','Success','Failed') NOT NULL DEFAULT 'Pending',
  `request_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ration_to_aadhar_requests`
--

INSERT INTO `ration_to_aadhar_requests` (`id`, `userid`, `ration_no`, `order_id`, `status`, `request_time`) VALUES
(1, '7970715727', '009994900040', 'TNG-377182C420', 'Success', '2025-10-31 16:18:16');

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

--
-- Table structure for table `recharge_history`
--

CREATE TABLE `recharge_history` (
  `id` int(11) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `operator` varchar(50) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` varchar(20) NOT NULL,
  `agentid` varchar(50) DEFAULT NULL,
  `opid` varchar(50) DEFAULT NULL,
  `rbid` varchar(50) DEFAULT NULL,
  `msg` varchar(255) DEFAULT NULL,
  `commission` decimal(10,2) DEFAULT 0.00,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `recharge_history`
--

INSERT INTO `recharge_history` (`id`, `userid`, `mobile`, `operator`, `amount`, `status`, `agentid`, `opid`, `rbid`, `msg`, `commission`, `date`) VALUES
(1, '9964517756', '9900203360', 'AIRTEL', 199.00, 'SUCCESS', '17599048012228', '1158580046', '115641100825', 'Recharge Success', 2.99, '2025-10-08 06:26:45'),
(2, '7986173392', '8872645865', 'JIO', 299.00, 'SUCCESS', '17599348749169', 'BR3595355764', '081755100825', 'Recharge Success', 3.59, '2025-10-08 14:48:01'),
(3, '7986173392', '7895722706', 'VODAFONE , VI', 155.00, 'SUCCESS', '17599814415172', 'ASR2510090914460014', '091401100925', 'Recharge Success', 4.65, '2025-10-09 03:44:03'),
(4, '9964517756', '8660711632', 'JIO', 299.00, 'PENDING', '17602472406461', '', '110400101225', 'Recharge Under Process', 3.59, '2025-10-12 05:34:20'),
(5, '7986173392', '9478787634', 'BSNL TOPUP', 10.00, 'SUCCESS', '17604186131737', '7400752110', '104013101425', 'Recharge Success', 0.35, '2025-10-14 05:10:19'),
(6, '8953558905', '8953558905', 'VODAFONE , VI', 365.00, 'SUCCESS', '17605365259662', 'UEH2510151925470129', '072525101525', 'Recharge Success', 10.95, '2025-10-15 13:55:28'),
(7, '8953558905', '8953558905', 'VODAFONE , VI', 22.00, 'SUCCESS', '17605463593145', 'RJR2510152209450016', '100919101525', 'Recharge Success', 0.66, '2025-10-15 16:39:22'),
(8, '7986173392', '7814519943', 'VODAFONE , VI', 10.00, 'SUCCESS', '17612238859265', 'RBR2510231821430088', '062126102325', 'Recharge Success', 0.30, '2025-10-23 12:51:29'),
(9, '9938893600', '8658013726', 'AIRTEL', 22.00, 'SUCCESS', '17615376281619', '1784683138', '093028102725', 'Recharge Success', 0.33, '2025-10-27 04:00:32'),
(10, '9938893600', '8658013726', 'AIRTEL', 26.00, 'SUCCESS', '17616436099262', '934033248', '025649102825', 'Recharge Success', 0.39, '2025-10-28 09:26:53'),
(11, '7986173392', '7535996472', 'JIO', 198.00, 'SUCCESS', '17617147903191', 'LJ912002642', '104310102925', 'Recharge Success', 2.38, '2025-10-29 05:13:19'),
(12, '7986173392', '7717463870', 'VODAFONE , VI', 10.00, 'SUCCESS', '17619159532766', 'PBH2510311835460285', '063554103125', 'Recharge Success', 0.30, '2025-10-31 13:05:56'),
(13, '9938893600', '8895178869', 'BSNL SPECIAL', 16.00, 'SUCCESS', '17619176348268', '7417989071', '070354103125', 'Recharge Success', 0.56, '2025-10-31 13:34:15'),
(14, '7986173392', '8449250450', 'VODAFONE , VI', 10.00, 'SUCCESS', '17619951938836', 'RJR2511011636410117', '043633110125', 'Recharge Success', 0.30, '2025-11-01 11:06:35'),
(15, '9938893600', '8895178869', 'BSNL SPECIAL', 16.00, 'SUCCESS', '17621778497223', '7421132894', '072049110325', 'Recharge Success', 0.56, '2025-11-03 13:50:59'),
(16, '7986173392', '9708304788', 'VODAFONE , VI', 299.00, 'SUCCESS', '17622262582842', 'BRH2511040847440083', '084739110425', 'Recharge Success', 8.97, '2025-11-04 03:17:42'),
(17, '7986173392', '8979602076', 'VODAFONE , VI', 299.00, 'SUCCESS', '17622398867074', 'ASR2511041234470213', '123446110425', 'Recharge Success', 8.97, '2025-11-04 07:04:48'),
(18, '9938893600', '8895178869', 'BSNL SPECIAL', 16.00, 'SUCCESS', '17622555164699', '7421959916', '045516110425', 'Recharge Success', 0.56, '2025-11-04 11:25:26'),
(19, '9938893600', '8895178869', 'BSNL SPECIAL', 16.00, 'SUCCESS', '17623305811122', '7422764943', '014621110525', 'Recharge Success', 0.56, '2025-11-05 08:16:32'),
(20, '7986173392', '8872645865', 'JIO', 299.00, 'SUCCESS', '17623564842324', 'BR0000SWQE61', '085805110525', 'Recharge Success', 3.59, '2025-11-05 15:28:12'),
(21, '7986173392', '8288914492', 'AIRTEL', 199.00, 'SUCCESS', '17624283692286', '1038747765', '045610110625', 'Recharge Success', 2.99, '2025-11-06 11:26:14'),
(22, '6202421380', '6202421380', 'JIO', 198.00, 'SUCCESS', '17624675624139', 'LJ925359182', '034922110725', 'Recharge Success', 2.38, '2025-11-06 22:19:33'),
(23, '9938893600', '9938893600', 'JIO', 29.00, 'SUCCESS', '17625405776192', 'RJ1286027499', '120617110825', 'Recharge Success', 0.35, '2025-11-07 18:36:27'),
(24, '7986173392', '7668708187', 'AIRTEL', 10.00, 'SUCCESS', '17625736741199', '1988633283', '091755110825', 'Recharge Success', 0.15, '2025-11-08 03:47:59'),
(25, '7986173392', '6284206545', 'AIRTEL', 299.00, 'SUCCESS', '17625900553534', '1994202874', '015056110825', 'Recharge Success', 4.49, '2025-11-08 08:21:01');

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

--
-- Table structure for table `referal`
--

CREATE TABLE `referal` (
  `id` int(11) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `referred_by` varchar(255) DEFAULT NULL,
  `txn_no` varchar(255) DEFAULT NULL,
  `referral_balance` varchar(255) DEFAULT NULL,
  `total_ref_bal` varchar(255) DEFAULT NULL,
  `refer_date` datetime NOT NULL DEFAULT current_timestamp(),
  `status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `rtps_pdf`
--

CREATE TABLE `rtps_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `samgra_pdf`
--

CREATE TABLE `samgra_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `vehicle_pdf`
--

CREATE TABLE `vehicle_pdf` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vehicle_pdf`
--

INSERT INTO `vehicle_pdf` (`id`, `name`, `username`, `aadhar`, `pdf`, `date`) VALUES
(1, 'HASEM ALI', '7970715727', 'AS27E7392', 'data:application/pdf;base64,[BLOB]