-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `aryapri1_panprint`
--

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

--
-- Table structure for table `aadhaarpdf`
--

CREATE TABLE `aadhaarpdf` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `pan_no` varchar(255) DEFAULT NULL,
  `eid` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `pdf_link` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) NOT NULL,
  `ret_wp_no` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `aadhaarpdf`
--

INSERT INTO `aadhaarpdf` (`id`, `application_no`, `appliedby`, `name`, `pan_no`, `eid`, `date`, `time`, `pdf_link`, `status`, `fee`, `ret_wp_no`, `aadhaar_no`, `apply_date`) VALUES
(683, 'AHK24544230', '8360453367', 'SEEMA KUMARI', NULL, '23091333029716', '26/01/2014', '10:20:30', 'https://mbajallive.xyz/admin/uploads/56196930.PNG', 'success', '400', '8360453367', '926500899272', '2024-02-08 14:03:44'),
(687, 'AHK99377848', 'ADMIN', 'Arya', NULL, '85828523698521', '05/03/2020', '10:00:00', NULL, 'pending', '500', 'ADMIN', NULL, '2024-04-14 13:39:47');

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

--
-- Table structure for table `aadhaar_no`
--

CREATE TABLE `aadhaar_no` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) DEFAULT NULL,
  `appliedby` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `eid` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `time` varchar(255) DEFAULT NULL,
  `pdf_link` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `fee` varchar(255) DEFAULT NULL,
  `ret_wp_no` varchar(255) DEFAULT NULL,
  `aadhaar_no` varchar(255) DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `aadhaar_no`
--

INSERT INTO `aadhaar_no` (`id`, `application_no`, `appliedby`, `name`, `eid`, `date`, `time`, `pdf_link`, `status`, `fee`, `ret_wp_no`, `aadhaar_no`, `apply_date`) VALUES
(163, 'AHK35141528', 'ADMIN', 'RK', '78945', NULL, NULL, '', 'pending', '500', 'ADMIN', NULL, '2024-04-14 13:04:24'),
(164, 'AHK46423093', 'ADMIN', 'Name', '8877992549', NULL, NULL, 'https://aryaprint.xyz/admin/uploads/323089123NITESH (1).pdf', 'success', '500', 'ADMIN', '834346884603', '2024-04-14 13:06:08'),
(165, 'AHK21859270', 'ADMIN', 'Aryam', '8686868685', NULL, NULL, '', 'pending', '500', 'ADMIN', NULL, '2024-04-14 16:46:39');

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

--
-- Table structure for table `aadhaar_no_2`
--

CREATE TABLE `aadhaar_no_2` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `aadhaar_pdf`
--

CREATE TABLE `aadhaar_pdf` (
  `id` int(11) NOT NULL,
  `application_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appliedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `aadhaar_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dob` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ret_wp_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pdf_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apply_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `aadhaar_pdf`
--

INSERT INTO `aadhaar_pdf` (`id`, `application_no`, `appliedby`, `name`, `aadhaar_no`, `dob`, `ret_wp_no`, `pan_no`, `pdf_link`, `status`, `fee`, `apply_date`) VALUES
(42, 'AHK69642192', '9034232343', 'pritam lal grover', '657591298174', '', '9034232343', 'VLKYU5880H', 'https://aryaprint.xyz/admin/uploads/922880IMG_20240530_175428_257.jpg', 'success', '500', '2024-04-23 09:24:52');

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

--
-- Table structure for table `aadharauto`
--

CREATE TABLE `aadharauto` (
  `aadharautoid` int(99) NOT NULL,
  `aadharno` varchar(50) DEFAULT NULL,
  `originalaadharno` varchar(50) DEFAULT NULL,
  `aadharname` varchar(250) DEFAULT NULL,
  `fathername` varchar(250) DEFAULT NULL,
  `dob` varchar(50) DEFAULT NULL,
  `dobinlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `sexinlocal` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `localname` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `localaddress` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `imagepathoriginal` longtext DEFAULT NULL,
  `imagename` varchar(250) DEFAULT NULL,
  `pata` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `houseno` varchar(50) DEFAULT NULL,
  `street` varchar(250) DEFAULT NULL,
  `panchayat` varchar(250) DEFAULT NULL,
  `vtcandpost` varchar(150) DEFAULT NULL,
  `dist` varchar(150) DEFAULT NULL,
  `subdist` varchar(150) DEFAULT NULL,
  `statename` varchar(150) DEFAULT NULL,
  `pincode` varchar(50) DEFAULT NULL,
  `srno` int(99) DEFAULT NULL,
  `createdatetime` datetime DEFAULT NULL,
  `userid` varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `aadharauto`
--

INSERT INTO `aadharauto` (`aadharautoid`, `aadharno`, `originalaadharno`, `aadharname`, `fathername`, `dob`, `dobinlocal`, `gender`, `sexinlocal`, `fulladdress`, `locallanguage`, `localname`, `localaddress`, `imagepathoriginal`, `imagename`, `pata`, `houseno`, `street`, `panchayat`, `vtcandpost`, `dist`, `subdist`, `statename`, `pincode`, `srno`, `createdatetime`, `userid`) VALUES
(510, '410146697068', '4101 4669 7068', 'Nikki Kumari', '', '01/01/2006', 'जन्म तिथि', 'FEMALE', 'महिला', 'D/O: Radha Krishna Singh, Chanpura, Rohtas, Bihar, 821312', 'HI', 'निक्की कुमारी', 'डी/ओ: राधा कृष्ण सिंह, चानपुरा, रोहतास, बिहार, 821312', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 1, '2024-04-19 13:08:02', '6299991996'),
(511, '970214105570', '9702 1410 5570', 'Raja Kumar', '', '05/03/2001', 'जन्म तिथि', 'MALE', 'पुरुष', 'C/O Shambhu Vishwakarma, Jago Dih, Gram Jagodih post Ramdihra, Rohtas, Bihar, 821312', 'HI', 'राजा कुमार', 'सी/ओ शंभू विश्वकर्मा, जागो डीह, ग्राम जागोडीह पोस्ट रामडीहरा, रोहतास, बिहार, 821312', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 2, '2024-04-21 18:34:25', '6299991996'),
(512, '541523507106', '5415 2350 7106', 'Bishal Kumar', '', '26/04/2008', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O: Ram Udit Noniya, Khaira, sihuli khaira, Aurangabad, Bihar, 824125', 'HI', 'बिशाल कुमार', 'पुत्र: राम उदित नोनिया, खैरा, सिहुली खैरा, औरंगाबाद, बिहार, 824125', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 3, '2024-04-27 10:23:17', '7033665817'),
(513, '287523181346', '2875 2318 1346', 'MRIDUL KANT', '', '11/09/1992', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O Achchhe Lal, Chutmalpur, Halwana Road, Saharanpur, Uttar Pradesh, 247662', 'HI', 'मृदुल कांत', 'पुत्र अच्छे लाल, छुटमलपुर, हलवाना रोड, सहारनपुर, उत्तर प्रदेश, 247662', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 4, '2024-04-27 16:41:01', '9719118134'),
(514, '594718975827', '5947 1897 5827', 'Judi Mehto', '', '01/01/1973', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O Vijender Mehto, SAMAY PUR, n-44/395, gali n0-9, sanjay colony, North West Delhi, Delhi, 110042', 'HI', 'जूडी मेहतो', 'S/O  विजेंदर महतो, समय पुर, एन-44/395, गली नंबर-9, संजय कॉलोनी, उत्तर पश्चिम दिल्ली, दिल्ली, 110042', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 5, '2024-04-29 14:05:56', '7870380381'),
(515, '210408546425', '2104 0854 6425', 'GITA MOHANTA', '', '01/01/1973', 'জন্ম তিথি', 'FEMALE', 'মহিলা', 'KELABARI, Kelabari, Darjiling, West Bengal, 734427', 'BN', 'গীতা মোহন্ত', 'কেলাবাড়ি, কেলাবাড়ি, দার্জিলিং, পশ্চিমবঙ্গ, 734427', 'data:image/png;base64,[BLOB]', NULL, 'ঠিকানা', '', '', NULL, '', '', NULL, '', '', 6, '2024-04-29 17:58:24', '7478568488');
INSERT INTO `aadharauto` (`aadharautoid`, `aadharno`, `originalaadharno`, `aadharname`, `fathername`, `dob`, `dobinlocal`, `gender`, `sexinlocal`, `fulladdress`, `locallanguage`, `localname`, `localaddress`, `imagepathoriginal`, `imagename`, `pata`, `houseno`, `street`, `panchayat`, `vtcandpost`, `dist`, `subdist`, `statename`, `pincode`, `srno`, `createdatetime`, `userid`) VALUES
(518, '962957612048', '9629 5761 2048', 'Bimlesh', '', '01/01/1986', 'जन्म तिथि', 'FEMALE', 'महिला', 'S/O: Bobi, Kaluwala Jahanpur, Satpura, Saharanpur, Uttar Pradesh, 247129', 'HI', 'बिमलेश', 'एस/ओ: बोबी, कालूवाला जहांपुर, सतपुड़ा, सहारनपुर, उत्तर प्रदेश, 247129', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 8, '2024-04-30 16:20:02', '9719118134'),
(519, '913297102714', '9132 9710 2714', 'Shamas Alam', '', '05/05/1995', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O: Ashique Hussain, Sasaram, Rohtas, Bihar, 821115', 'HI', 'शमास आलम', 'पुत्र: आशिक हुसैन, सासाराम, रोहतास, बिहार, 821115', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 9, '2024-04-30 19:44:29', '6299991996'),
(520, '616046229099', '6160 4622 9099', 'Sujeet Kumar', '', '03/10/1989', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O ASHOK GUPTA, WARD NO 5, VILL-MAHARAJGANJ, Tilauthu, PO-MAHARAJGANJ, Rohtas, Bihar, 821312', 'HI', 'सुजीत कुमार', 'पुत्र अशोक गुप्ता, वार्ड नंबर 5, ग्राम-महाराजगंज, तिलौथू, पोस्ट-महाराजगंज, रोहतास, बिहार, 821312', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 10, '2024-05-02 12:50:12', '6299991996'),
(521, '776168790854', '7761 6879 0854', 'Manjit Kumar', '', '06/06/2004', '', 'MALE', 'पुरुष', 'S/O: Vijay Prasad, Panchanpur, Post panchanpur, Gaya, Bihar, 824236', 'HI', 'मंजीत कुमार', 'पुत्र: विजय प्रसाद, पंचानपुर, पोस्ट पंचानपुर, गया, बिहार, 824236', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 11, '2024-05-02 18:13:04', '7033665817'),
(524, '936747641080', '9367 4764 1080', 'Sunita Devi', '', '01/01/1985', 'जन्म तिथि', 'FEMALE', 'महिला', 'W/O: Anil Yadav, Narawat, narawat, Gaya, Bihar, 823311', 'HI', 'सुनीता देवी', 'W/O: अनिल यादव, नरावत, नरावत, गया, बिहार, 823311', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 12, '2024-05-08 15:56:40', '9263919531');
INSERT INTO `aadharauto` (`aadharautoid`, `aadharno`, `originalaadharno`, `aadharname`, `fathername`, `dob`, `dobinlocal`, `gender`, `sexinlocal`, `fulladdress`, `locallanguage`, `localname`, `localaddress`, `imagepathoriginal`, `imagename`, `pata`, `houseno`, `street`, `panchayat`, `vtcandpost`, `dist`, `subdist`, `statename`, `pincode`, `srno`, `createdatetime`, `userid`) VALUES
(525, '534940066159', '5349 4006 6159', 'Vikash Kumar', '', '17/09/2010', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O: Kishori Yadav, Narawat, graam-narawat post-piyar thana-atari, Gaya, Bihar, 823311', 'HI', 'विकाश कुमार', 'पुत्र: किशोरी यादव, नरावत, ग्राम-नरावत पोस्ट-पियार थाना-अटारी, गया, बिहार, 823311', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 13, '2024-05-08 16:01:10', '9263919531'),
(526, '782644159005', '7826 4415 9005', 'Nimai Kumar Mandal', '', '01/01/1989', 'জন্ম তিথি', 'MALE', 'পুরুষ', 'S/O Phani Mandal, KELABARI, Vill - Kelabari, Kharibari, Darjeeling, West Bengal, 734427', 'BN', 'নিমাই কুমার মন্ডল', 'S/O ফণী মণ্ডল, কেলাবাড়ি, ভিল - কেলাবাড়ি, খড়িবাড়ি, দার্জিলিং, পশ্চিমবঙ্গ, 734427', 'data:image/png;base64,[BLOB]', NULL, 'ঠিকানা', '', '', NULL, '', '', NULL, '', '', 14, '2024-05-09 10:56:31', '7478568488'),
(527, '216748911183', '2167 4891 1183', 'Mohit Chauhan', '', '18/05/1997', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O: Satish Chauhan, Muradnagar, MURAD gram pur pursi, Ghaziabad, Uttar Pradesh, 201206', 'HI', 'मोहित चौहान', 'पुत्र: सतीश चौहान, मुरादनगर, मुराद ग्राम पुर पुरसी, गाजियाबाद, उत्तर प्रदेश, 201206', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 15, '2024-05-09 17:41:20', '9259585759'),
(528, '987964432740', '9879 6443 2740', 'Rinki Kumari', '', '15/01/1996', 'जन्म तिथि', 'FEMALE', 'महिला', 'D/O: Ram Avadhesh Singh, Tilauthu, Vill padriya post tilaulhu, Rohtas, Bihar, 821312', 'HI', 'रिंकी कुमारी', 'डी/ओ: राम अवधेश सिंह, तिलौथू, ग्राम पड़रिया पोस्ट तिलौथू, रोहतास, बिहार, 821312', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 16, '2024-05-10 13:11:37', '6299991996'),
(529, '978344215353', '9783 4421 5353', 'Mitrwa Devi', '', '01/01/1977', 'जन्म तिथि', 'FEMALE', 'महिला', 'C/O Jamuna Manjhi, GRAM-FATEHPUR POST-FATEHPUR, THANA-FATEHPUR, Fatehpur, Gaya, Bihar, 824232', 'HI', 'मितरवा देवी', 'अर्धांगिनी जमुना मांझी, ग्राम-फतेहपुर पोस्ट-फतेहपुर, थाना-फतेहपुर, फतेहपुर, गया, बिहार, 824232', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 17, '2024-05-10 16:44:02', '7033665817'),
(530, '342329151221', '3423 2915 1221', 'Anjan Devi', '', '01/01/1995', 'जन्म तिथि', 'FEMALE', 'महिला', 'W/O: Mithlesh Yadav, Maharajganj, jhauwari, Purnia, Bihar, 854202', 'HI', 'अंजन देवी', 'W/O: मिथलेश यादव, महाराजगंज, झौवारी, पूर्णिया, बिहार, 854202', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 18, '2024-05-12 13:25:48', '8521940488');
INSERT INTO `aadharauto` (`aadharautoid`, `aadharno`, `originalaadharno`, `aadharname`, `fathername`, `dob`, `dobinlocal`, `gender`, `sexinlocal`, `fulladdress`, `locallanguage`, `localname`, `localaddress`, `imagepathoriginal`, `imagename`, `pata`, `houseno`, `street`, `panchayat`, `vtcandpost`, `dist`, `subdist`, `statename`, `pincode`, `srno`, `createdatetime`, `userid`) VALUES
(531, '360802867934', '3608 0286 7934', 'Dharmendra Kumar', '', '01/01/1995', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O Late Ramnath Ram, ward 05, vill mahuliya, Mahulia, thana garhwa, Garhwa, Jharkhand, 822114', 'HI', 'धर्मेन्द्र कुमार', 'पुत्र स्वर्गीय रामनाथ राम, वार्ड 05, ग्राम महुलिया, महुलिया, थाना गढ़वा, गढ़वा, झारखंड, 822114', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 19, '2024-05-12 17:28:27', '6299991996'),
(533, '320109175095', '3201 0917 5095', 'ANNU AZAD', '', '05/10/1994', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O: Wazid Ali, HOME NO-158 BLOCK 80, ADARSH COLONY, Muradnagar, Ghaziabad, Uttar Pradesh, 201206', 'HI', 'अन्नू आज़ाद', 'पुत्र: वाजिद अली, घर नंबर-158 ब्लॉक 80, आदर्श कॉलोनी, मुरादनगर, गाजियाबाद, उत्तर प्रदेश, 201206', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 20, '2024-05-14 11:03:05', '9259585759'),
(535, '288440708150', '2884 4070 8150', 'SAKALMANI DEVI', '', '01/01/1941', 'जन्म तिथि', 'FEMALE', 'महिला', 'MOHARPUR, WARD NO 14 BORIYA ,SAMASTIPUR , BIHAR-848211', 'HI', 'सकलमणि देवी', 'मोहरपुर, वार्ड नंबर 14 बोरिया,समस्तीपुर, बिहार-848211', '', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 21, '2024-05-26 17:09:11', '9519127799'),
(536, '864914043756', '8649 1404 3756', 'Gudiya Devi', '', '01-01-1996', 'जन्म तिथि', 'FEMALE', 'महिला', 'W/O: AJAY MAHALDAR,  Prem nagar Sabour, BHAGALPUR, Sabour, BIHAR, 813210', 'HI', 'गुड़िया देवी', 'W/O : अजय महलदार, प्रेम नगर , सबौर, भागलपुर, सबौर, बिहार, 813210', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 22, '2024-05-27 18:42:11', '9801939381'),
(537, '958669406931', '9586 6940 6931', 'Vaishali Pal', '', '12-08-2000', 'जन्म तिथि', 'FEMALE', 'महिला', 'C/O: Brijpal,Gandewda, 37, , SAHARANPUR, Saharanpur, UTTAR PRADESH, 247662', 'HI', 'वैशाली पाल', 'सी/ओ: बृजपाल, गंदेवड़ा, 37,, सहारनपुर, सहारनपुर, उत्तर प्रदेश, 247662', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 23, '2024-05-29 16:19:07', '9719118134'),
(538, '394492595005', '3944 9259 5005', 'Mithlesh Singh', '', '01/01/1947', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/o: Keshwar Singh     Atri Piar  Atri Gaya Bihar-823311', 'HI', 'मिथलेश सिंह', 'पुत्र: केश्वर सिंह अत्रि पियार अत्रि गया बिहार-823311', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 24, '2024-06-05 17:51:42', '9263919531');
INSERT INTO `aadharauto` (`aadharautoid`, `aadharno`, `originalaadharno`, `aadharname`, `fathername`, `dob`, `dobinlocal`, `gender`, `sexinlocal`, `fulladdress`, `locallanguage`, `localname`, `localaddress`, `imagepathoriginal`, `imagename`, `pata`, `houseno`, `street`, `panchayat`, `vtcandpost`, `dist`, `subdist`, `statename`, `pincode`, `srno`, `createdatetime`, `userid`) VALUES
(539, '238187396253', '2381 8739 6253', 'Roushan Kumar', '', '10/02/2008', 'जन्म तिथि', 'MALE', 'पुरुष', 'C/o: Satendra Yadav    Brki Delha Paraiya Road Gaya R.s Gaya  Gaya Gaya Bihar-823002', 'HI', 'रौशन कुमार', 'C/o: सतेंद्र यादव ब्रकी डेल्हा परैया रोड गया R.s गया गया गया बिहार-823002', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 25, '2024-06-06 10:16:58', '7033665817'),
(540, '321571430180', '3215 7143 0180', 'Sandeep Kumar', '', '02/03/2005', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/o: Bhagwan Ram    Vill Dudhami Dihri Post Hurka Tilouthu Hurka  Dehri Rohtas Bihar-821312', 'HI', 'संदीप कुमार', 'पुत्र: भगवान राम ग्राम दुधमी डिहरी पोस्ट हुरका तिलौथू हुरका डेहरी रोहतास बिहार-821312', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 26, '2024-06-06 13:30:44', '6299991996'),
(541, '321870265058', '3218 7026 5058', 'Anshu Kumari', '', '06/11/2010', 'जन्म तिथि', 'FEMALE', 'महिला', 'D/o: Vijay Das   Gram-taraka Post-maksudpur Khizersarai Patak Bigha  Khizirsarai Gaya Bihar-824233', 'HI', 'अंशू कुमारी', 'डी/ओ: विजय दास ग्राम-तारका पोस्ट-मकसूदपुर खिजरसराय पटक बिगहा खिजिरसराय गया बिहार-824233', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 27, '2024-06-07 15:55:19', '9934473670'),
(542, '386359209382', '3863 5920 9382', 'Safik Bakho', '', '01/01/1998', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/o: Parwej Bakho Gram-bahera    Bahera Mohan Bahera  Benipur Darbhanga Bihar-847201', 'HI', 'सफीक बखो', 'S/o: परवेज बखो ग्राम-बहेड़ा बहेरा मोहन बहेरा बेनीपुर दरभंगा बिहार-847201', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 28, '2024-06-07 16:31:49', '7870380381'),
(543, '730906366916', '7309 0636 6916', 'Anshu Kumari', '', '04/11/2008', 'जन्म तिथि', 'FEMALE', 'महिला', 'D/o: Kamlesh Singh Bauliya    Ramdihra Jago Dih  Tilouthu Rohtas Bihar-821312', 'HI', 'अंशू कुमारी', 'D/o:कमलेश सिंह बौलिया रामडीहरा जागो डीह तिलौथू रोहतास बिहार-821312', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 29, '2024-06-07 17:32:48', '6299991996'),
(544, '369284880774', '3692 8488 0774', 'Jajji Murmu', '', '01/01/1982', 'जन्म तिथि', 'FEMALE', 'महिला', 'W/o: Matal Hasda    Kaitha Dom Ward No 6 Purnea Chowk Rangpura  Dhamdaha Purnia Bihar-854304', 'HI', 'जज्जी मुर्मू', 'W/o: मतल हसदा कैथा डोम वार्ड नंबर 6 पूर्णिया चौक रंगपुरा धमदाहा पूर्णिया बिहार-854304', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 30, '2024-06-08 10:03:00', '8521940488');
INSERT INTO `aadharauto` (`aadharautoid`, `aadharno`, `originalaadharno`, `aadharname`, `fathername`, `dob`, `dobinlocal`, `gender`, `sexinlocal`, `fulladdress`, `locallanguage`, `localname`, `localaddress`, `imagepathoriginal`, `imagename`, `pata`, `houseno`, `street`, `panchayat`, `vtcandpost`, `dist`, `subdist`, `statename`, `pincode`, `srno`, `createdatetime`, `userid`) VALUES
(545, '432848841336', '4328 4884 1336', 'Kamlesh Devi', '', '20/05/1980', 'जन्म तिथि', 'FEMALE', 'महिला', 'W/O: Rishipal Singh 306    Bhavigarh Bhavigarh  Atrauli Aligarh Uttar Pradesh-202125', 'HI', 'कमलेश देवी', 'W/O: ऋषिपाल सिंह 306 भवीगढ़ भवीगढ़ अतरौली अलीगढ उत्तर प्रदेश-202125', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 31, '2024-06-08 18:10:21', '9084692942'),
(546, '568260597890', '5682 6059 7890', 'Neha Kumari Mahato', '', '03/02/1999', 'জন্ম তিথি', 'FEMALE', 'মহিলা', 'Aluabari Station  Islampur Islampur   Uttar Dinajpur West Bengal-733202', 'BN', 'নেহা কুমারী মাহাতো', 'আলুয়াবাড়ী স্টেশন ইসলামপুর ইসলামপুর উত্তর দিনাজপুর পশ্চিমবঙ্গ-733202', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'ঠিকানা', '', '', NULL, '', '', NULL, '', '', 32, '2024-06-08 18:39:36', '7478568488'),
(547, '873056097233', '8730 5609 7233', 'LALITA BARMAN', '', '28/08/2002', 'জন্ম তিথি', 'FEMALE', 'মহিলা', 'Adhikari   Kelabari   Darjiling West Bengal-734427', 'BN', 'ললিতা বর্মন', 'অধিকারী কেলাবাড়ি দার্জিলিং পশ্চিমবঙ্গ-734427', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'ঠিকানা', '', '', NULL, '', '', NULL, '', '', 33, '2024-06-08 18:51:31', '7478568488'),
(548, '331736177867', '3317 3617 7867', 'Dhiraj Kumar', '', '01/01/2011', 'जन्म तिथि', 'MALE', 'पुरुष', 'C/o: Bare Babu Gram-narawat P O-piyar   Atri Narawat  Atri Gaya Bihar-823311', 'HI', 'धीरज कुमार', 'C/o: बड़े बाबू ग्राम-नरावत पी ओ-पियार अत्रि नरावत अत्रि गया बिहार-823311', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 34, '2024-06-08 19:23:14', '9263919531'),
(549, '305755540271', '3057 5554 0271', 'Himaraj Kumar', '', '09/11/2008', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/o: Tunni Sapera    Naravat Post Piyar Atri Atri  Atri Gaya Bihar-823311', 'HI', 'हिमराज कुमार', 'पुत्र: टुन्नी सपेरा नरावत पोस्ट पियार अत्रि अत्रि अत्रि गया बिहार-823311', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 35, '2024-06-09 19:56:43', '9263919531'),
(550, '944738391483', '9447 3839 1483', 'Nirmal Tuddu', '', '01/01/2004', 'जन्म तिथि', 'MALE', 'पुरुष', 'C/o: Patwari Tuddu    Bhatta Chakla Champabati Champawati  Dhamdaha Purnia Bihar-854206', 'HI', 'निर्मल टुड्डू', 'सी/ओ: पटवारी टुड्डू भट्टा चकला चंपाबती चंपावती धमदाहा पूर्णिया बिहार-854206', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 36, '2024-06-10 09:46:08', '8521940488');
INSERT INTO `aadharauto` (`aadharautoid`, `aadharno`, `originalaadharno`, `aadharname`, `fathername`, `dob`, `dobinlocal`, `gender`, `sexinlocal`, `fulladdress`, `locallanguage`, `localname`, `localaddress`, `imagepathoriginal`, `imagename`, `pata`, `houseno`, `street`, `panchayat`, `vtcandpost`, `dist`, `subdist`, `statename`, `pincode`, `srno`, `createdatetime`, `userid`) VALUES
(551, '570846206324', '5708 4620 6324', 'Kalpana Devi', '', '01/01/1983', 'जन्म तिथि', 'FEMALE', 'महिला', 'W/o: Paltu Modak    Kusmatand Pargha Pargha  Baliapur Dhanbad Jharkhand-828201', 'HI', 'कल्पना देवी', 'W/o: पलटू मोदक कुसमाटांड़  परघा परघा बलियापुर धनबाद झारखंड-828201', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 37, '2024-06-10 17:12:17', '7870111334'),
(552, '433854676652', '4338 5467 6652', 'Himanshu Kumar', '', '08/09/2008', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/o: Visnu Paswan  Thatheri Tola Sabour  Post- Sabour Sabour Sabour  Sabour Bhagalpur Bihar-813210', 'HI', '-हिमांशु कुमार', 'पुत्र: विष्णु पासवान ठठेरी टोला सबौर पोस्ट- सबौर सबौर सबौर सबौर भागलपुर बिहार-813210', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 38, '2024-06-10 18:38:36', '9801939381'),
(553, '629040786418', '6290 4078 6418', 'Rukiya Devi', '', '01/01/1942', 'जन्म तिथि', 'FEMALE', 'महिला', 'W/o Panchu Pandit H. No 95 Block -c Gali No 5 M C D School Nangli Vihar Baprola Bapraula  Punjabi Bagh West Delhi Delhi-110043', 'HI', 'रुकिया देवी', 'पंचू पंडित मकान नंबर 95 ब्लॉक-सी गली नंबर 5 एम सी डी स्कूल नंगली विहार बापरोला बापरौला पंजाबी बाग पश्चिमी दिल्ली दिल्ली-110043', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 39, '2024-06-11 09:00:49', '8406977440'),
(554, '561397171976', '5613 9717 1976', 'Manji Murmu', '', '01/01/1992', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/o: Late Jata Murmu   Panchayat-kolajora,word Number-09 Gram-kolajora,thana-pakur Pakur Kalajora  Pakur Pakur Jharkhand-816107', 'HI', 'मांजी मुर्मू', 'S/O: स्वर्गीय जटा मुर्मू पंचायत-कोलाजोरा, शब्द संख्या-09 ग्राम-कोलाजोरा, थाना-पाकुड़ पाकुड़ कालाजोरा पाकुड़ पाकुड़ झारखंड-816107', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 40, '2024-06-11 09:20:27', '9835073773'),
(555, '732867804096', '7328 6780 4096', 'Rakesh', '', '01/01/1990', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/o: Palla   Amwala  Muzaffrabad Jayantipur Aht.  Behat Saharanpur Uttar Pradesh-247129', 'HI', 'राकेश', 'पुत्र: पल्ला आमवाला मुजफ्फराबाद जयंतीपुर एहट।  बेहट सहारनपुर उत्तर प्रदेश-247129', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 41, '2024-06-11 15:57:00', '9719118134'),
(556, '355234374224', '3552 3437 4224', 'Saroj', '', '02/10/1989', 'जन्म तिथि', 'FEMALE', 'महिला', 'W/O: Ratan Singh    Aichhar Kasna Kasana  Gautam Buddha Nagar Gautam Buddha Nagar Uttar Pradesh-201310', 'HI', 'सरोज', 'सम्बोधित: रतन सिंह ऐच्छर कसाना कसाना गौतम बुद्ध नगर गौतम बुद्ध नगर उत्तर प्रदेश-201310', 'data:image/jpg;charset=utf-8;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 42, '2024-06-11 18:35:49', '9084692942');
INSERT INTO `aadharauto` (`aadharautoid`, `aadharno`, `originalaadharno`, `aadharname`, `fathername`, `dob`, `dobinlocal`, `gender`, `sexinlocal`, `fulladdress`, `locallanguage`, `localname`, `localaddress`, `imagepathoriginal`, `imagename`, `pata`, `houseno`, `street`, `panchayat`, `vtcandpost`, `dist`, `subdist`, `statename`, `pincode`, `srno`, `createdatetime`, `userid`) VALUES
(557, '278957329555', '2789 5732 9555', 'OM PRAKASH', '', '20-08-1978', 'जन्म तिथि', 'MALE', 'पुरुष', 'C/O: Ram Samujh,Binohni Kalan, 40, , BALRAMPUR, Balrampur, UTTAR PRADESH, 271207', 'HI', 'ओम प्रकाश', 'सी/ओ: राम समुझ, बिनोहनी कलां, 40, , बलरामपुर, बलरामपुर, उत्तर प्रदेश, 271207', 'data:image/png;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 43, '2024-06-13 12:34:02', '9918267707');

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

--
