[encoded data, 214786 characters]', '13/06/2024 7:03:14');

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

--
-- 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;

--
-- Dumping data for table `referal`
--

INSERT INTO `referal` (`id`, `phone`, `referred_by`, `txn_no`, `referral_balance`, `total_ref_bal`, `refer_date`, `status`) VALUES
(31, '8780203649', '7870814228', 'REF32776', '5', NULL, '2023-02-13 20:24:52', '1'),
(32, '9903428725', '6290007518', 'REF70282', '5', NULL, '2023-02-14 12:45:16', '1'),
(33, '8755367449', '9068182749', 'REF51959', '5', NULL, '2023-02-15 11:02:55', '1'),
(34, '9118785053', '8881983196', 'REF90271', '5', NULL, '2023-02-18 14:33:46', '1'),
(35, '7004603746', '7870814228', 'REF69029', '5', NULL, '2023-02-18 18:51:35', '1'),
(36, '9571395974', '7891500811', 'REF42827', '5', NULL, '2023-02-21 15:34:39', '1'),
(37, '7980603437', '6290007518', 'REF1397', '5', NULL, '2023-03-02 07:33:23', '1'),
(38, '8429222714', '6302195751', 'REF1221', '5', NULL, '2023-03-03 08:29:13', '1'),
(39, 'DHAKA', '8830017643', 'REF17066', '5', NULL, '2023-03-16 17:58:25', '1'),
(40, '6284064831', '9914734010', 'REF54002', '5', NULL, '2023-03-23 12:16:24', '1'),
(41, 'Yadav', '9936741231', 'REF84654', '5', NULL, '2023-03-25 16:20:24', '1'),
(42, '9142499134', '7773811452', 'REF62279', '5', NULL, '2023-03-26 08:01:33', '1'),
(43, '9310749227', '8882191393', 'REF91924', '5', NULL, '2023-04-16 12:36:16', '1'),
(44, '9876963088', '9897521386', 'REF22782', '5', NULL, '2023-04-16 20:54:48', '1'),
(45, '9044744456', '9897521386', 'REF19415', '5', NULL, '2023-04-16 21:45:16', '1'),
(46, '9548368757', '7037779592', 'REF72764', '5', NULL, '2023-04-17 09:58:53', '1'),
(47, '4682937518', '7037779592', 'REF93395', '5', NULL, '2023-04-17 10:04:55', '1'),
(48, '22588966', '7037779592', 'REF7481', '5', NULL, '2023-04-17 10:11:48', '1'),
(49, '2556363636', '7037779592', 'REF39052', '5', NULL, '2023-04-17 10:30:47', '1'),
(50, '1521521521', '7037779592', 'REF56724', '5', NULL, '2023-04-17 10:32:35', '1'),
(51, '2525252525', '7037779592', 'REF9326', '5', NULL, '2023-04-17 10:37:16', '1'),
(52, '5757875758', '7037779592', 'REF59259', '5', NULL, '2023-04-17 10:37:55', '1'),
(53, '9336939632', '7037779592', 'REF26777', '5', NULL, '2023-04-17 10:38:56', '1'),
(54, '5225255886', '7037779592', 'REF33512', '5', NULL, '2023-04-17 10:40:08', '1'),
(55, '9878007072', '9897521386', 'REF6541', '5', NULL, '2023-04-17 20:35:56', '1'),
(56, '9000322802', '8074172236', 'REF64652', '5', NULL, '2023-04-18 06:54:55', '1'),
(57, '7033230967', '9570298908', 'REF5547', '5', NULL, '2023-04-18 14:23:09', '1'),
(58, '9578463485', '9570298908', 'REF96315', '5', NULL, '2023-04-18 14:37:59', '1');

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

--
-- Table structure for table `samb`
--

CREATE TABLE `samb` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `samb` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `pdf_link` varchar(500) NOT NULL,
  `date` varchar(255) DEFAULT NULL,
  `ret_wp_no` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `samb`
--

INSERT INTO `samb` (`id`, `appliedby`, `application_no`, `samb`, `status`, `fee`, `remark`, `aadhaar_no`, `pdf_link`, `date`, `ret_wp_no`, `state`) VALUES
(992, '1234567890', 'KAFILA7907372', '989898365421', 'pending', '20', NULL, NULL, '', '6th of September 2023 04:30:19 PM', NULL, NULL),
(993, '1234567890', 'KAFILA12131091', '12588899', 'success', '20', NULL, 'NO RECORD', 'https://kafilaworld.xyz/admin/uploads/828417Screenshot 2023-07-06 185526.png', '6th of September 2023 04:46:46 PM', '975588112233', 'MADHYA PRADESH'),
(994, '7089755335', 'KAFILA88787825', '21793713', 'success', '20', NULL, '21793713', 'https://kafilaworld.xyz/admin/uploads/626358pdf (16).pdf', '7th of September 2023 05:45:19 PM', '7089755335', 'MADHYA PRADESH'),
(995, '7089755335', 'KAFILA86643591', '44092013', 'success', '20', NULL, '44092013', 'https://kafilaworld.xyz/admin/uploads/475982pdf (54).pdf', '15th of September 2023 03:09:37 PM', '7089755335', 'MADHYA PRADESH');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `webname` varchar(255) DEFAULT NULL,
  `weburl` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `HomeTemplatename` varchar(255) DEFAULT NULL,
  `ref_bal` varchar(255) DEFAULT NULL,
  `logo` longtext DEFAULT NULL,
  `pgtype` varchar(255) DEFAULT NULL,
  `mid` varchar(255) DEFAULT NULL,
  `mkey` varchar(255) DEFAULT NULL,
  `callback_url` varchar(255) DEFAULT NULL,
  `reg_callback_url` varchar(255) DEFAULT NULL,
  `nsdl_api_key` varchar(255) DEFAULT NULL,
  `nsdl_callback_url` varchar(255) DEFAULT NULL,
  `paytm` int(11) DEFAULT NULL,
  `payu` int(11) DEFAULT NULL,
  `upi` int(11) DEFAULT NULL,
  `qr` varchar(255) NOT NULL DEFAULT '1',
  `upi_id` varchar(255) DEFAULT NULL,
  `payu_mkey` varchar(255) DEFAULT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `upi_key` varchar(2000) DEFAULT NULL,
  `ret_reg_fee` varchar(255) DEFAULT NULL,
  `dist_reg_fee` varchar(255) DEFAULT NULL,
  `rc_flat_com` varchar(255) DEFAULT NULL,
  `airtel_com` varchar(255) DEFAULT NULL,
  `jio_com` varchar(255) DEFAULT NULL,
  `bsnl_com` varchar(255) DEFAULT NULL,
  `vi_com` varchar(255) DEFAULT NULL,
  `dist_com` varchar(255) DEFAULT '20',
  `status` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `webname`, `weburl`, `phone`, `email`, `address`, `HomeTemplatename`, `ref_bal`, `logo`, `pgtype`, `mid`, `mkey`, `callback_url`, `reg_callback_url`, `nsdl_api_key`, `nsdl_callback_url`, `paytm`, `payu`, `upi`, `qr`, `upi_id`, `payu_mkey`, `salt`, `upi_key`, `ret_reg_fee`, `dist_reg_fee`, `rc_flat_com`, `airtel_com`, `jio_com`, `bsnl_com`, `vi_com`, `dist_com`, `status`) VALUES
(1, 'All In One Find Portal', 'aryaprint.xyz', '1234567890', 'MBAJALLIVE.XYZ', 'Address 12345', 'default', '5', 'https://mbajallive.xyz/admin/uploads/15362WhatsApp Image 2023-08-30 at 14.07.34.jpeg', 'MBA', '1234567890', '1234567890', '1234567890', 'http://allinonefind.xyz/paytm/regResponse.php', 'N2FiN2I2YmMteWxibi0yNzUyLWRoMGMtYmY4ZGU4YTc5NmRm', 'http://localhost/ProjectList/AllinOne/admin/nsdl_ekyc_callback.php', 0, 0, 0, '1', '7483a2-fefa5f-ae7ffa-6a6c54-fe494b', '7483a2-fefa5f-ae7ffa-6a6c54-fe494b', '7483a2-fefa5f-ae7ffa-6a6c54-fe494b', '7483a2-fefa5f-ae7ffa-6a6c54-fe494b', '49', '99', '3', '3.0', '3.0', '3.0', '2.5', '30', '1');

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

--
-- Table structure for table `upfind`
--

CREATE TABLE `upfind` (
  `id` int(11) NOT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `upfind` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `pdf_link` varchar(500) NOT NULL,
  `date` varchar(255) DEFAULT NULL,
  `ret_wp_no` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `upfind`
--

INSERT INTO `upfind` (`id`, `appliedby`, `application_no`, `upfind`, `status`, `fee`, `remark`, `aadhaar_no`, `pdf_link`, `date`, `ret_wp_no`, `state`) VALUES
(997, '6395660281', 'KAFILA64917480', '6395660281', 'success', '22', NULL, 'NO RECORD', 'https://kafilaworld.xyz/admin/uploads/654955Screenshot 2023-07-06 185526.png', '9th of September 2023 12:19:00 PM', 'UTTAR PRADESH', '09175497028268'),
(998, '7459852255', 'KAFILA61866009', '7459852255', 'success', '22', NULL, 'NO RECORD', 'https://kafilaworld.xyz/admin/uploads/236230Screenshot 2023-07-06 185526.png', '16th of September 2023 10:53:46 PM', 'UTTAR PRADESH', '269615730943'),
(999, '8979760730', 'KAFILA63662321', '8979760730', 'success', '22', NULL, '926500899272', 'https://mbajallive.xyz/admin/uploads/40844NO RECORD.png', '17th of September 2023 09:52:44 PM', 'UTTAR PRADESH', '09145697274192');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `parent` varchar(255) NOT NULL DEFAULT 'admin',
  `referred_by` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `type` text DEFAULT NULL,
  `balance` varchar(255) NOT NULL DEFAULT '0',
  `address` varchar(255) DEFAULT NULL,
  `reg_date` datetime NOT NULL DEFAULT current_timestamp(),
  `order_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `panfind_fee` int(50) NOT NULL DEFAULT 80
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `parent`, `referred_by`, `name`, `phone`, `email`, `password`, `type`, `balance`, `address`, `reg_date`, `order_id`, `status`, `date`, `panfind_fee`) VALUES
(1, 'admin', NULL, 'Arya Infotech', 'ADMIN', 'demo@gmail.com', '$2y$10$gmssLL4EcE9aY.iDQp8rMe3U4.yylZK/M7OwehJOTRShAw9cbwN46', 'admin', '6100', 'xyz', '2022-11-16 18:01:27', NULL, '1', NULL, 50),
(3490, 'admin', '', 'Aryan', '7870992497', 'aryan354@gmail.com', '$2y$10$/twL8rlUDLaOj2FrVFvNL.Jkg4/5Hb1mtgbQ14hbAUZPENf1rxScy', 'retailer', '250', NULL, '2024-04-15 13:32:24', 'HKB_474254', '1', '15-04-2024', 80),
(3491, 'admin', '', 'Aryan', '8877992549', 'aryan345@gmail.com', '$2y$10$MXHUaBjw68ImdbbP1AqVxe5x8u/ECi0ezsqqNEzLQzEn7WKfOd9SS', 'distributor', '500', NULL, '2024-04-15 13:33:59', 'HKB_117495', '1', '15-04-2024', 80),
(3492, 'admin', '', 'RAJA KUMAR', '6299991996', 'NEWRAJAKUMAR@GMAIL.COM', '$2y$10$kmYyS1x5qmRkdCIvRyrGi.hpB32MbyX/tC5uMEBPDxhASoZUxqmWK', 'retailer', '50', NULL, '2024-04-15 13:58:13', 'HKB_716417', '1', '15-04-2024', 80),
(3498, '7320972673', NULL, 'ranjit kumar', '7763910705', 'allindiatechnicalwork@gmail.com', '$2y$10$yCWUlpmxe5z2ckcKFnzlaeBViHQktpteSHMaTin4jrRS.FpYSQxcy', 'retailer', '20', NULL, '2024-04-15 16:16:54', NULL, '1', NULL, 80),
(3500, '7320972673', NULL, 'dinesh kumar', '9934473670', 'dineshkumar121580@gmail.com', '$2y$10$VRgIA0.fsPCeSBstpCUudeSqXUmWfR63ObEdyntbwuTHCY7GeXuRe', 'retailer', '40', 'vill telbigha ps khijarsaray distt gaya', '2024-04-15 16:55:45', NULL, '1', NULL, 80),
(3501, 'ADMIN', NULL, 'Sandeep Kumar', '7320972673', 'srgpay123@gmail.com', '$2y$10$iRY.e6bZCtvf0AHQhmEW9unUkwAtneuirj7.UfbXv68c0Puk.lwfm', 'distributor', '60', NULL, '2024-04-15 17:10:42', NULL, '1', NULL, 80),
(3502, 'admin', '', 'Ishu', '9255479432', 'rinkupanchal669@yahoo.in', '$2y$10$RzOQWwjEZfZQFQ8TQG63eemJkfCq5ZmwS9ndAv4tBBq2plIhgGdcq', 'retailer', '10', NULL, '2024-04-15 17:24:20', 'HKB_100462', '1', '15-04-2024', 80),
(3511, 'ADMIN', NULL, 'Dileep Tiwari', '9651631407', 'tiwari965@gmail.com', '$2y$10$ocYOd0uxtolSv5y8z1flnetUVBn8XQ4aI9vHw81O9EcQgOq7UJ/Gi', 'retailer', '200', NULL, '2024-04-16 13:01:15', NULL, '1', NULL, 80),
(3523, 'admin', '', 'Royal Rajput ', '8175098216', 'swagatraj6392@gmail.com', '$2y$10$xKR5A.Cez57doaGiHL7G5ORZKDFCPLnhv8nB1nkZubJKj3zRfQAg2', 'retailer', '80', NULL, '2024-04-17 09:09:36', 'HKB_696537', '1', '17-04-2024', 80),
(3539, 'admin', '', 'Jasim', '8617858750', 'jasimuddinansary714@gmail.com', '$2y$10$H9IWy0d3gnb8hgKFbt.UOOWqDBN0cM0aXlEET8Oplkc9wc1a2Xcq.', 'retailer', '70', NULL, '2024-04-18 16:06:42', 'HKB_992685', '1', '18-04-2024', 80),
(3545, 'admin', '', 'Danendra kushwaha ', '8770427621', 'danendrakushwaha1996@gmail.com', '$2y$10$hQD/5fccuvt4EmkUZXKnVeeXdylIiPQp1P1ZZsEXd/iAnC49nAsoW', 'distributor', '30', NULL, '2024-04-18 20:00:17', 'HKB_349263', '1', '18-04-2024', 80),
(3549, 'admin', '', 'Kataru Venkateswarlu', '7981121611', 'kataruvenkatesh@gmail.com', '$2y$10$9RxUl3J494NXgNJp6MCn2.bSmYhpLn.015m7ZeW6jYZ.ZZDQ2Q6XW', 'retailer', '60', NULL, '2024-04-18 21:02:07', 'HKB_652073', '1', '18-04-2024', 80),
(3556, 'admin', '', 'jaya', '8394937329', 'jayakumari8630@gmail.com', '$2y$10$L/Q0ucDVGaCSz5sq3AwlNOxvNhRb5cO2SXsjbjk7GueRhH2djXY2S', 'retailer', '40', NULL, '2024-04-18 21:43:02', 'HKB_943078', '1', '18-04-2024', 80),
(3561, 'admin', '', 'MANOJ KUMAR', '8178824292', 'medant07@gmail.com', '$2y$10$IIRUos1ECG.11gY/Sg5HCeQbWLgyyzoVVohYn6ARZTQ/N6J8at2Ri', 'retailer', '60', NULL, '2024-04-19 10:50:20', 'HKB_72258', '1', '19-04-2024', 80),
(3572, 'admin', '', 'Pankaj Singh', '8668849461', 'shailesh.bagdi@gmail.com', '$2y$10$IeP7oE/pZyjODuFw3./2VeeiImXD/X7U.jequY8BLnEADd/yoLgM2', 'retailer', '100', NULL, '2024-04-19 21:55:39', 'HKB_304649', '1', '19-04-2024', 80),
(3581, 'admin', '', 'CHHOTE LAL MODAK', '7870111334', 'chhotelal9835@gmail.com', '$2y$10$id9l.38e0x5CppQdfCKiROZP2PncPID0UgWzsIrDO6oPkkoZgXhJy', 'retailer', '20', NULL, '2024-04-20 16:12:51', 'HKB_795863', '1', '20-04-2024', 80),
(3605, 'admin', '', 'BIPIN KUMAR', '8406977440', 'bipinkumar11045@gmail.com', '$2y$10$RgsFv0ch8GLkjGQdeqqHs.P95t2qLsAB2s4cKiXLSxEmfIuykOEJy', 'retailer', '90', NULL, '2024-04-21 10:08:05', 'HKB_202112', '1', '21-04-2024', 80),
(3606, 'admin', '', 'S NAGASUDEER KUMAR', '9885753032', 'onlinesftwr@gmail.com', '$2y$10$M4e7oE9KDm./Hge79.YcRufyI.VGNF06ZS4vem6U9ecwlN.BAF7Yi', 'retailer', '90', NULL, '2024-04-21 10:37:27', 'HKB_155451', '1', '21-04-2024', 80),
(3617, 'admin', '', 'DEVENDRA BHADORIYA ', '9617237769', 'guddubhai454@gmail.com', '$2y$10$M5gSMrPKHntL6bWDJlR8YekgBxSefvpmdH2tQF0UvJwCzsURInEsG', 'retailer', '100', NULL, '2024-04-21 18:56:51', 'HKB_961445', '1', '21-04-2024', 80),
(3622, 'admin', '', 'sonu', '9034232343', 'cscmusepur@gmail.com', '$2y$10$K6YYEX/P9b4aKB50C8boPuMgHx8JR0FxMVhYscXucGKvWWyMxiDnG', 'retailer', '40', NULL, '2024-04-22 11:41:28', 'HKB_648505', '1', '22-04-2024', 80),
(3625, 'admin', '', 'Manu Kumar', '9988194455', 'mannukumar.08.05@gmail.com', '$2y$10$vcDqkZKayF9UwvcVS8e9GOX0iHXHEIZeU438LapK03.JYnjIH5D9i', 'retailer', '20', NULL, '2024-04-22 14:27:01', 'HKB_926578', '1', '22-04-2024', 80),
(3636, 'admin', '', 'ankit jha', '7870380381', 'ajha184@gmail.com', '$2y$10$.AgUNs8RhDe8fcIi4KFjE.9TzA3HI9RODc9kcXQFoaYyQBCFJjHSq', 'retailer', '10', NULL, '2024-04-23 10:15:56', 'HKB_109147', '1', '23-04-2024', 80),
(3639, 'admin', '', 'Digital Web Cafe', '9259585759', 'csc201206@gmail.com', '$2y$10$s6o4rAG9lBEkZCDxIJgwneJS99usr6gQQ9B3HDeQoWGfRPtW.cQgm', 'retailer', '60', NULL, '2024-04-23 15:49:57', 'HKB_430189', '1', '23-04-2024', 80),
(3648, 'admin', '', 'Himanshu kumar', '9719118134', 'hk4611482@gmail.com', '$2y$10$/CuLGuqR6bb49w.H0GIfQOdzXQTiSCGIgXlp2hGYXfb1SAbUPSeGe', 'retailer', '60', NULL, '2024-04-24 11:48:07', 'HKB_817741', '1', '24-04-2024', 80),
(3652, 'admin', '', 'Pavan Kumar', '9084692942', 'pavan.k136@gmail.com', '$2y$10$V.V9aE3.mp8AYRLYCJ5LqOkVzHC5EkcvZGCkNWjIS7utBRxaZM7HG', 'retailer', '60', NULL, '2024-04-24 14:48:33', 'HKB_813253', '1', '24-04-2024', 80),
(3653, 'admin', '', 'prakash saraswat', '9644601338', 'prakashsaraswat1994@gmail.com', '$2y$10$dpChmZld42bOfuACNlRNt.Vfxuxsi//Vwtfpcs9tRlnDeEMzVF2HS', 'retailer', '70', NULL, '2024-04-24 15:58:56', 'HKB_58751', '1', '24-04-2024', 80),
(3675, '7320972673', NULL, 'MAKSUD ', '7033665817', 'makasud86@gmail.com', '$2y$10$Jdm60y0SdX.UuNXJNXhoC.FaSOis5bij6nRz1JNTzR23EkQtLgqnO', 'retailer', '10', NULL, '2024-04-27 10:11:34', NULL, '1', NULL, 80),
(3687, 'admin', '', 'shiv kumar', '9801939381', 'ashokbgp5@gmail.com', '$2y$10$7MtLlVgLRQEAUs/tJsiBV.GHcQe6vy5iYM/p2f7EHNC.dLrTDAu7K', 'retailer', '120', NULL, '2024-04-29 14:38:17', 'HKB_251552', '1', '29-04-2024', 80),
(3688, 'admin', '', 'KUNDAN KUMAR DAS', '7478568488', 'DASKUNDAN371@GMAIL.COM', '$2y$10$RqAO5az4ee4SfEM5TsAYf.2ioWyXIRasYPjHAaVaKiPeFPNXYmVbG', 'retailer', '70', NULL, '2024-04-29 17:54:50', 'HKB_360693', '1', '29-04-2024', 80),
(3705, '7320972673', NULL, 'SANJIT KUMAR', '9263919531', 'sunjitkugaya8863@gmail.com', '$2y$10$2RWREiFbNzy2wLMyZFbjnukad2QgBREk2DrEXQNBZheuBvyoH77nC', 'retailer', '20', NULL, '2024-05-08 10:59:22', NULL, '1', NULL, 80),
(3726, 'admin', '', 'SHYAM KUMAR YADAV', '8521940488', 'sk504948@gmail.com', '$2y$10$foA26t/delAuL5URSwlISeMXc5rBOCVKTrXtQxz/AUQM4c2zd8U1W', 'retailer', '90', NULL, '2024-05-12 12:21:01', 'HKB_271593', '1', '12-05-2024', 80),
(3730, 'admin', '', 'Omkar Kode', '8905993904', 'omkarashramhyd@gmail.com', '$2y$10$m5/nLa8DnL5GOdnZsgb.xeLlytmA8oZuOOgUzZtSbMvR8f.Evf80S', 'distributor', '120', NULL, '2024-05-12 17:04:21', 'HKB_202582', '1', '12-05-2024', 80),
(3757, 'admin', '', 'purvanchal ', '8800285266', 'onlinesewa10@gmail.com', '$2y$10$7bXpgh.K0wnZ7edmzqn.zudtzE7XaGbdVJMU5xezeiiKNVasfmKW.', 'retailer', '60', NULL, '2024-05-13 16:10:05', 'HKB_997469', '1', '13-05-2024', 80),
(3765, 'admin', '', 'Mangesh Mohanlal Gupta ', '9930919743', 'guptamangesh1002@gmail.com', '$2y$10$QiR2S4aIRAg4Ju02H42ueOcRLGfuDxmjx8Sv/GiV2OwEDV8Uxd.mu', 'retailer', '100', NULL, '2024-05-13 18:14:00', 'HKB_883172', '1', '13-05-2024', 80),
(3781, 'admin', '', 'Angad kumar', '7052989911', 'angadraj110@gmail.com', '$2y$10$.bXEJCMfnWGLfSD/wKOFJ.qdie.m88/05WTEmAwaUq.JNpZZwi1Sa', 'retailer', '20', NULL, '2024-05-14 12:16:19', 'HKB_257818', '1', '14-05-2024', 80),
(3790, 'admin', '', 'Punjabi Karansingh gurudayalsingh', '9033423606', 'karansinghpunjabi0343@gmail.com', '$2y$10$arDuTZbMG8Jef/F/qwv.ReVN6/NtqYOxnE7ALcD2lXlMEAG59dvFm', 'retailer', '90', '85/2 Gujarat housing board Last bus stop', '2024-05-15 13:36:47', 'HKB_769681', '1', '15-05-2024', 80),
(3801, 'admin', '', 'SHUBHAM GUPTA', '7004190013', 'psinfo828203@gmail.com', '$2y$10$0q.zh5zTnc143wUCLVuSYu6ralf1RS5f4U4wmJwPiGpkG3Iz3H5/e', 'distributor', '140', NULL, '2024-05-17 12:35:08', 'HKB_827897', '1', '17-05-2024', 80),
(3811, 'admin', '', 'Bk verma', '8700095096', 'banarasiv4796@gmail.com', '$2y$10$oXh3n/Biz0tZsTY.0qQ6JOEmDurQgb7kLm9t2Rr3D3vhkO6knQnQi', 'retailer', '40', NULL, '2024-05-19 05:08:55', 'HKB_305386', '1', '19-05-2024', 80),
(3824, 'admin', '', 'SUNIL KUMAR', '8969056208', 'sonamdto1620@gmail.com', '$2y$10$Or.DWg/DGgSOANguHdl6Wux3.LlMHRdjcmdY/YAwLZPi9fRyEkAVS', 'retailer', '80', NULL, '2024-05-23 10:36:37', 'HKB_23546', '1', '23-05-2024', 80),
(3825, 'admin', '', 'rangaswamy nk', '7022182629', 'rangaswamy78958@gmail.com', '$2y$10$pskaXKw.Hd8Cyrs8zZueFOYcysXnz1/jqnyLt6BPYODee9Q.S0Bqi', 'retailer', '90', NULL, '2024-05-23 11:22:40', 'HKB_411311', '1', '23-05-2024', 80),
(3835, 'admin', '', 'Bablu kumar', '9519127799', 'Bablu83189@gmail.com', '$2y$10$ChBM9jQz667cKEfwZbFcEuPLwWKZuR3ydWeB14Pl3BOTrS4g2K3v2', 'retailer', '60', NULL, '2024-05-26 16:38:18', 'HKB_209360', '1', '26-05-2024', 80),
(3852, 'admin', '', 'RAHUL', '9350349633', 'rahulchechi420@gmail.com', '$2y$10$hjpr.z/.2kl00bWnKQYo.OztcLvYu.zwH1/SsVxzBLFaMxuBubE8u', 'retailer', '40', NULL, '2024-05-30 17:56:04', 'HKB_53748', '1', '30-05-2024', 80),
(3860, 'admin', '', 'Om Prakash ', '9918267707', 'pradeeptreders777@mail.com', '$2y$10$7FNAccNWGfh00bIatrLFfuN2Mha1BARXowF.1XkQpO.34HJ5Js7Mm', 'retailer', '170', NULL, '2024-06-01 14:58:43', 'HKB_254051', '1', '01-06-2024', 80),
(3871, 'admin', '', 'Suraj Kumar ', '9565654013', 'suraj9565654013@gmail.com', '$2y$10$WEBpOSlVE2Tl4t6kUgA5v.uLKZP.GI9eAMbTOwge8I/Y1kEyc76X6', 'retailer', '30', NULL, '2024-06-03 13:05:03', 'HKB_474924', '1', '03-06-2024', 80),
(3873, 'admin', '', 'Bihar ', '9507522536', 'gangarajhd635@gmail.com', '$2y$10$aF7kvLNpXK7RG1zv5AAOgex8mGrFPN72qxzSJPu5oFXYewKD8dKtO', 'retailer', '0', NULL, '2024-06-03 13:24:07', 'HKB_585586', '0', '03-06-2024', 80),
(3874, 'admin', '', 'PAVANKUMAR', '8866688676', 'KMPKADI1@GMAIL.COM', '$2y$10$n4Y3AeRngj6o6hMXqxWlHuwUb8lT5V9LNr4NL8J4JkR2o1dwcqP.a', 'retailer', '100', NULL, '2024-06-03 14:26:13', 'HKB_39598', '1', '03-06-2024', 80),
(3875, 'admin', '', 'Gulmohammad', '7217492764', 'Toshifkhan87@gmail.com', '$2y$10$sIeaPquXOa5httE4hvfqL.tuLKM4gXNXDxksZg8nhKNWzW8eHhavO', 'retailer', '0', NULL, '2024-06-03 14:37:27', 'HKB_875491', '0', '03-06-2024', 80),
(3876, 'admin', '', 'Dndxn', '1234567890', 'bxxbbd@gmail.com', '$2y$10$P6wUl3WbBlNKEz9/PcUJC.TyLu/vORe8jMBYdD9Rn7VmGDhgPQM3m', 'retailer', '0', NULL, '2024-06-03 14:44:54', 'HKB_159726', '0', '03-06-2024', 80),
(3877, 'admin', '', 'Saurabh jain', '9340753581', 'sourabhjaincomputers@gmail.com', '$2y$10$6mUTt1aP/9utXJJ.27TiS.qAIxAuR7nTA7bABbnfqLKlKNkKrkUya', 'retailer', '0', NULL, '2024-06-03 17:08:02', 'HKB_338408', '0', '03-06-2024', 80),
(3878, 'admin', '', 'Sanju kumar', '9904848557', 'padharsunita57@gmail.com', '$2y$10$swiEc.36bb6ZTD95ZeznVe0NaPMJJnFl86QcuswpY9f8YiSalc1LS', 'retailer', '0', NULL, '2024-06-03 21:32:53', 'HKB_98064', '0', '03-06-2024', 80),
(3879, 'admin', '', 'Akhilesh Kumar ', '8539078645', 'akhileshkumar80010@gmail.com', '$2y$10$0/Og0OCbBYIEWVaG96x2.eQkDaaW5mxJzgI120q9jJ80inhR/XsYG', 'distributor', '0', NULL, '2024-06-04 12:29:10', 'HKB_146843', '0', '04-06-2024', 80),
(3880, 'admin', '', 'UMER UDDIN', '9319552565', 'STARJANSEVAKENDRA1@GMAIL.COM', '$2y$10$PuNphjVXeD5Gvlur9oLev.Jla/poMWZ0sBhqw3Bw7X3rbbpBu2QIa', 'retailer', '0', NULL, '2024-06-04 13:29:35', 'HKB_223396', '0', '04-06-2024', 80),
(3881, 'admin', '', 'Rakesh Kumar ', '8092638859', 'msahpkr21@gmail.com', '$2y$10$FdczNuLQ0iZ8Bvy6Cb5tU.D7KUFyG3ms3PkQ8/9K6QF2r6PzTZgGS', 'retailer', '0', NULL, '2024-06-04 15:06:54', 'HKB_22610', '0', '04-06-2024', 80),
(3882, 'admin', '', 'Rakesh Kumar', '9835073773', 'msahpkr15@gmail.com', '$2y$10$P2H9vq4yGGYLG/qkz6p.B.FYpv9TkudL3EkmiEro53a0LLlEF7wu6', 'retailer', '50', NULL, '2024-06-04 15:10:57', 'HKB_140267', '1', '04-06-2024', 80),
(3883, 'admin', '', 'raju', '7000882340', 'rajeshrajoriya69@gmail.com', '$2y$10$UKugyyM86nkOVlIJnJ6POuXuN.rxI95bDG5NS8VMzVom74oY5go2e', 'retailer', '0', NULL, '2024-06-05 10:19:55', 'HKB_863088', '0', '05-06-2024', 80),
(3884, 'admin', '', 'rajesh', '9617697929', 'rajeshrajoriya68@gmail.com', '$2y$10$cHugZI9yHPebvVihRPzvPO6zrUiCjXCdgxqqc4IYhG/railUgoh9i', 'retailer', '50', NULL, '2024-06-05 10:22:27', 'HKB_961114', '1', '05-06-2024', 80),
(3885, 'admin', '', 'Jitendra Prajapati', '9617177395', 'jitendracwsib262@gmail.com', '$2y$10$eByOgBcg6xZqCVz3ti8Xm.ew.1nfmuFZreh1AQhyTz9Fc1ryLtYKm', 'retailer', '-40', NULL, '2024-06-05 13:28:58', 'HKB_463451', '0', '05-06-2024', 80),
(3886, 'admin', '', 'RAKESH KUMAR SINGH', '7000875597', 'unemployedcandidate@gmail.com', '$2y$10$Lk5wZCzmNCCB94hUivzhzuFg9OivYmIz4KVvBoKOH4S7NlOLxaX/2', 'retailer', '0', NULL, '2024-06-05 13:48:49', 'HKB_760867', '1', '05-06-2024', 80),
(3887, 'admin', '', 'SYED NAWAZ', '9642656460', 'snawazuddin87@gmail.com', '$2y$10$rUG/oQvM6FaAhO70HCLn6uo48YmnPHuhbIWf0tWXUg4rjsr45SS3S', 'retailer', '70', NULL, '2024-06-05 13:55:29', 'HKB_298027', '1', '05-06-2024', 80),
(3888, 'admin', '', 'Raj kishor yadav', '7070070600', 'rajkishoey256@gmail.com', '$2y$10$.QdibYIzQA6LRGY61zvD6uo4cxMF8iMw86MiUjE3lYVfKWD920Pca', 'retailer', '0', NULL, '2024-06-05 20:36:50', 'HKB_88979', '0', '05-06-2024', 80),
(3889, 'admin', '', 'niraj kumar', '9264237452', 'sanidev91069@gmail.com', '$2y$10$1CdIrmLBGF8iAE2fuRz9veHe/KurdkRnrt692pPu8cfslmanTHNPi', 'retailer', '0', NULL, '2024-06-06 18:17:21', 'HKB_853261', '0', '06-06-2024', 80),
(3890, 'admin', '', 'Devil', '6261165979', 'rk6264803109@gmail.com', '$2y$10$fv10l.2k7t29h853KQyunua0KQejGyrbIEafieQH1kII9qKawK3oy', 'retailer', '0', NULL, '2024-06-07 02:11:23', 'HKB_905189', '0', '07-06-2024', 80),
(3891, 'admin', '', 'Bidyut Choudhury', '9647254008', 'bidyutpurulia22@gmail.com', '$2y$10$tmdFVwmJ7hqZXMj9.owewu/UVQK0E2C7.YHX9vFCIB2KHsk/4p97S', 'retailer', '0', NULL, '2024-06-08 13:52:07', 'HKB_36066', '0', '08-06-2024', 80),
(3892, 'admin', '', 'omprakash ', '9406871324', 'omsagarom007@gmail.com', '$2y$10$n8OtKCD3Ucc0Bsx5pE0e.uiy260hqfx3UT9gVu/9VsyZDVKtWQoXi', 'distributor', '0', NULL, '2024-06-08 16:43:37', 'HKB_136072', '0', '08-06-2024', 80),
(3893, 'admin', '', 'Yashpal Singh', '9720593210', 'yashpalcsc18@gmail.com', '$2y$10$JtJkSVyOvgHxRhzKkv/hVOMy9H3NrEw6GbpZVPsC2l6hns2gN607.', 'retailer', '100', NULL, '2024-06-08 18:13:46', 'HKB_770108', '1', '08-06-2024', 80),
(3894, 'admin', '', 'Rajababu Kumar Yadav', '8651673044', 'rajababucsccenter@gmail.com', '$2y$10$rjkYMkhsKTzmpKjT1HWRfOnx6GNe7YbzDREyStB7ILG/F9uVoTJVi', 'retailer', '0', NULL, '2024-06-08 20:58:24', 'HKB_320120', '0', '08-06-2024', 80),
(3895, 'admin', '', 'manoj', '7015120387', 'cscsamain1@gmail.com', '$2y$10$1f7cG8DaqxT.9DHB0UHc9.lvfb1wS/xLcL40IV3zOIs3pSAraCUpK', 'retailer', '0', NULL, '2024-06-09 11:10:33', 'HKB_448256', '0', '09-06-2024', 80),
(3896, 'admin', '', 'SANTOSH KUMAR', '8827288309', 'santoshlovewanshi3@gmail.com', '$2y$10$qlLKRdfdvtVJbR0zr1eR3OF/n2yjrfCijatLxAOPxPXP2Hqh.sZMm', 'retailer', '0', NULL, '2024-06-10 14:27:37', 'HKB_1348', '0', '10-06-2024', 80),
(3898, 'admin', '', 'sandeep kumar', '8709845048', 'ramsaran952500@gmail.com', '$2y$10$iRY.e6bZCtvf0AHQhmEW9unUkwAtneuirj7.UfbXv68c0Puk.lwfm', 'distributor', '0', NULL, '2024-06-10 20:01:23', 'HKB_153912', '0', '10-06-2024', 80),
(3899, 'admin', '', 'akib', '9651920437', 'fs3287682@gmail.com', '$2y$10$7e6pXTuhdYi.nMSAx.9egOKMbt4kxNNbHpL7NrKpVf/hFjpqJwxxK', 'distributor', '0', NULL, '2024-06-11 08:32:22', 'HKB_539168', '0', '11-06-2024', 80),
(3900, 'admin', '', 'Digambar Bhinge', '8793870788', 'bhinge.dd@gmail.com', '$2y$10$xeuyHW0vfSJZ29WcH4OZFuCJO96tD36iObw2atnTXY0EYxGGF4ZHm', 'distributor', '0', NULL, '2024-06-11 10:39:56', 'HKB_234468', '0', '11-06-2024', 80),
(3901, 'admin', '', 'SHIVA', '9934016473', 'csc01muz@gmail.com', '$2y$10$xrCNx.ISKPK/ALwGllQ06OA0AwW4pVyucK0dzvgysDlJJdXKAX4de', 'retailer', '0', NULL, '2024-06-11 19:51:03', 'HKB_681747', '0', '11-06-2024', 80),
(3902, 'admin', '', 'suresh', '9106009817', 'sureshjain3846@gmail.com', '$2y$10$spp2X/.T5i7zjfghC..coeuLSygFKLFg5zKnVFZOOZ/eZELQC/MrG', 'retailer', '0', NULL, '2024-06-12 11:01:15', 'HKB_123285', '0', '12-06-2024', 80),
(3903, 'admin', '', 'Raviraj Singh ', '6261542652', 'rdodiya216@gmail.com', '$2y$10$PYXpHGISdHzT4GrMIR5JWOIFbdvcySr7E3Ybk/YskNfvTjgj08J8S', 'retailer', '-10', NULL, '2024-06-12 12:05:59', 'HKB_477594', '1', '12-06-2024', 80),
(3904, 'admin', '', 'Arvind Kumar ', '7903541148', 'arvindsuman91@gmail.com', '$2y$10$RwT1Sua.ZHpRpQvd5JGwZeQutWRoPVFhrtaLu/Jko/hEe5cVyiUhK', 'retailer', '0', NULL, '2024-06-12 17:08:36', 'HKB_991453', '0', '12-06-2024', 80),
(3905, '7320972673', NULL, 'SUBHASH', '9923232323', 'DDDDD@FFFF', '$2y$10$yYbkMp5gN5wch50J5Gwoy.x./9AXDhcYPhjolJg4MgCaTNsxrSK/O', 'retailer', '0', NULL, '2024-06-13 12:22:57', NULL, '1', NULL, 80),
(3906, '7320972673', NULL, 'subhash', '9708003162', 'singhhent.aircel@gmail.com', '$2y$10$CNlTOv6Z/5uzg/mp9zjQnurbd4vNKrSd9VvYu3zx0hJQ/mLo/5SIK', 'retailer', '90', NULL, '2024-06-13 12:34:06', NULL, '1', NULL, 80),
(3907, 'admin', '', 'ak_2580', '7869776427', 'rehankhan25@gmail.com', '$2y$10$8UNZped389KDBg8FJlpGAeXKQHJKMOUeaWFc0a/K8xgJ.kGljBAlO', 'retailer', '0', NULL, '2024-06-13 17:55:24', 'HKB_742662', '0', '13-06-2024', 80),
(3908, 'admin', '', 'Ramkripal patel ', '7507454487', 'ramkripalpatel82@gmail.com', '$2y$10$Ac3QlrtdkAvkw407lCfgXuUgVcK474GuDMx1dqM9QTXI/vdVDNeau', 'retailer', '0', NULL, '2024-06-13 18:18:34', 'HKB_874556', '0', '13-06-2024', 80);

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

--
-- Table structure for table `voterauto`
--

CREATE TABLE `voterauto` (
  `id` int(11) NOT NULL,
  `votername` varchar(250) DEFAULT NULL,
  `votarname2` varchar(100) NOT NULL,
  `aadharname` varchar(250) DEFAULT NULL,
  `namelocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `dob` varchar(50) DEFAULT NULL,
  `dobinlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `genderlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `sexlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `spousename` varchar(50) DEFAULT NULL,
  `spousenamelocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `fathername` varchar(150) DEFAULT NULL,
  `fatheraadharname` varchar(250) DEFAULT NULL,
  `fathernamelocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `epicno` varchar(50) DEFAULT NULL,
  `policestation` varchar(150) DEFAULT NULL,
  `tahshil` varchar(150) DEFAULT NULL,
  `assconnonm` varchar(150) DEFAULT NULL,
  `assconnonmlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `partno` varchar(50) DEFAULT NULL,
  `partname` varchar(250) DEFAULT NULL,
  `partnamelocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `localaddress` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `pata` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `kaname` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `sign` varchar(250) DEFAULT NULL,
  `signlocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `assconnameno` varchar(250) DEFAULT NULL,
  `assconnamenolocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `partnoandname` varchar(250) DEFAULT NULL,
  `partnoandnamelocal` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `imagepathoriginal` longtext DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `updatestatusdatetime` datetime DEFAULT NULL,
  `updateuserid` int(11) DEFAULT NULL,
  `srno` int(11) DEFAULT NULL,
  `createdatetime` datetime DEFAULT NULL,
  `userid` varchar(200) DEFAULT NULL,
  `payment_status` int(11) NOT NULL DEFAULT 0,
  `mobile` varchar(10) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `voterauto`
--

INSERT INTO `voterauto` (`id`, `votername`, `votarname2`, `aadharname`, `namelocal`, `dob`, `dobinlocal`, `gender`, `genderlocal`, `sexlocal`, `spousename`, `spousenamelocal`, `fathername`, `fatheraadharname`, `fathernamelocal`, `epicno`, `policestation`, `tahshil`, `assconnonm`, `assconnonmlocal`, `partno`, `partname`, `partnamelocal`, `locallanguage`, `fulladdress`, `localaddress`, `pata`, `kaname`, `sign`, `signlocal`, `assconnameno`, `assconnamenolocal`, `partnoandname`, `partnoandnamelocal`, `imagepathoriginal`, `status`, `updatestatusdatetime`, `updateuserid`, `srno`, `createdatetime`, `userid`, `payment_status`, `mobile`, `email`) VALUES
(1, 'HFDGHF', '', '', 'ghfg', '2023-09-04', 'ਜਨਮ ਤਿਥੀ/ਉਮਰ', 'hf', '', 'ਸੈਕਸ', 'Father', 'ਪਿਤਾ', 'DFHF', '', 'ghfdg', 'dfghfdg', 'ytutyu', 'fdghfdg', '- hfg', '-dfgh', 'dfgh', 'dfh', 'fgh', 'PA', 'Police Station-ytutyu, Tahshil-fdghfdg, District-dfghdfgh, Pin Code-546456', 'ਪੁਲਿਸ ਸਟੇਸ਼ਨ-ਯਤੂਯੂ, ਤਹਿਸ਼ੀਲ-fdghfdg, ਜ਼ਿਲ੍ਹਾ-dfghdfgh, ਪਿੰਨ ਕੋਡ-546456', 'ਪਤਾ', 'ਕਾ ਨਾਮ', '', 'ਚੋਣਕਾਰ ਰਜਿਸਟ੍ਰੇਸ਼ਨ ਅਫਸਰ', 'Assembly Constituency No. & Name', 'ਵਿਧਾਨ ਸਭਾ ਚੋਣ ਖੇਤਰ ਦਾ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'Part No and Name', 'ਭਾਗ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'data:image/jpeg;base64,[encoded data, 103144 characters]', 'PENDING', NULL, NULL, 1, '2023-09-13 23:25:01', '0', 0, NULL, NULL);
INSERT INTO `voterauto` (`id`, `votername`, `votarname2`, `aadharname`, `namelocal`, `dob`, `dobinlocal`, `gender`, `genderlocal`, `sexlocal`, `spousename`, `spousenamelocal`, `fathername`, `fatheraadharname`, `fathernamelocal`, `epicno`, `policestation`, `tahshil`, `assconnonm`, `assconnonmlocal`, `partno`, `partname`, `partnamelocal`, `locallanguage`, `fulladdress`, `localaddress`, `pata`, `kaname`, `sign`, `signlocal`, `assconnameno`, `assconnamenolocal`, `partnoandname`, `partnoandnamelocal`, `imagepathoriginal`, `status`, `updatestatusdatetime`, `updateuserid`, `srno`, `createdatetime`, `userid`, `payment_status`, `mobile`, `email`) VALUES
(2, 'KARAMVEER SINGH', '', '', 'ਕਰਮਵੀਰ ਸਿੰਘ', '1992-05-17', 'ਜਨਮ ਤਿਥੀ/ਉਮਰ', 'MALE', '', 'ਸੈਕਸ', 'Father', 'ਪਿਤਾ', 'GURMAIL SINGH', '', 'ਗੁਰਮੇਲ ਸਿੰਘ', 'SLH2004869', 'H. NO.673/3 Jattan Mohalla', 'Adampur', '-', '-', '.', '.', '', 'PA', 'H.NO.673/3 Jattan Mohalla,Adampur, District-Jalandhar, Pin Code-144102', 'H NO 673/3 ਜੱਟਾਂ ਮੁਹੱਲਾ ਆਦਮਪੁਰ ਜ਼ਿਲ੍ਹਾ- ਜਲੰਧਰ ਪਿੰਨ ਕੋਡ 144102', 'ਪਤਾ', 'ਕਾ ਨਾਮ', '', 'ਚੋਣਕਾਰ ਰਜਿਸਟ੍ਰੇਸ਼ਨ ਅਫਸਰ', 'Assembly Constituency No. & Name', 'ਵਿਧਾਨ ਸਭਾ ਚੋਣ ਖੇਤਰ ਦਾ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'Part No and Name', 'ਭਾਗ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'data:image/jpeg;base64,[encoded data, 23940 characters]', 'PENDING', NULL, NULL, 2, '2023-09-28 19:15:04', '8699591290', 0, NULL, NULL);
INSERT INTO `voterauto` (`id`, `votername`, `votarname2`, `aadharname`, `namelocal`, `dob`, `dobinlocal`, `gender`, `genderlocal`, `sexlocal`, `spousename`, `spousenamelocal`, `fathername`, `fatheraadharname`, `fathernamelocal`, `epicno`, `policestation`, `tahshil`, `assconnonm`, `assconnonmlocal`, `partno`, `partname`, `partnamelocal`, `locallanguage`, `fulladdress`, `localaddress`, `pata`, `kaname`, `sign`, `signlocal`, `assconnameno`, `assconnamenolocal`, `partnoandname`, `partnoandnamelocal`, `imagepathoriginal`, `status`, `updatestatusdatetime`, `updateuserid`, `srno`, `createdatetime`, `userid`, `payment_status`, `mobile`, `email`) VALUES
(3, 'CHANDA DEVI', '', '', 'ਚੰਦਾ ਦੇਵੀ', '10-08-2003', 'ਜਨਮ ਤਿਥੀ/ਉਮਰ', 'FEMALE', '', 'ਸੈਕਸ', 'Husband', 'ਪਤੀ', 'ANUJ', '', 'ਅਨੁਜ', 'IGZ8503891', 'SAHNEWAL', 'LUDHIANA', 'DHANDARI-25', 'ਢੰਡਾਰੀ-25', '125', 'DHANDARI KALAN', 'ਢੰਡਾਰੀ ਕਲਾਂ', 'PA', 'Police Station-SANEWAL, Tahshil-LUDHIANA, District-LUDHIANA, Pin Code-141014', 'ਪੁਲਿਸ ਸਟੇਸ਼ਨ-ਸਾਨੇਵਾਲ, ਤਹਿਸ਼ੀਲ-ਲੁਧਿਆਣਾ, ਜਿਲ੍ਹਾ-ਲੁਧਿਆਣਾ, ਪਿੰਨ ਕੋਡ-141014', 'ਪਤਾ', 'ਕਾ ਨਾਮ', '', 'ਚੋਣਕਾਰ ਰਜਿਸਟ੍ਰੇਸ਼ਨ ਅਫਸਰ', 'Assembly Constituency No. & Name', 'ਵਿਧਾਨ ਸਭਾ ਚੋਣ ਖੇਤਰ ਦਾ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'Part No and Name', 'ਭਾਗ ਨੰਬਰ ਅਤੇ ਨਾਮ', 'data:image/png;base64,[encoded data, 147981 characters]