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

START TRANSACTION;



--
-- Database: `phpiiinf_unique`
--

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

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

CREATE TABLE `aadharauto` (
  `aadharautoid` int(11) 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) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `sexinlocal` varchar(150) DEFAULT NULL,
  `fulladdress` varchar(250) DEFAULT NULL,
  `locallanguage` varchar(50) DEFAULT NULL,
  `localname` varchar(250) DEFAULT NULL,
  `localaddress` varchar(250) DEFAULT NULL,
  `imagepathoriginal` longtext DEFAULT NULL,
  `imagename` varchar(250) DEFAULT NULL,
  `pata` varchar(50) 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(11) DEFAULT NULL,
  `createdatetime` datetime DEFAULT NULL,
  `userid` varchar(99) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_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
(1, '411729294381', '4117 2929 4381', 'Nagma', 'Istkar', '02/05/2005', 'जन्म तिथि', 'FEMALE', 'महिला', 'W/O : Istkar, Tataheri, Gangoh, Saharanpur , Uttar Pradesh , 247341', 'HI', 'नगमा', 'W/O: इस्तकार, ताताहेडी, गंगोह, सहारनपुर, उत्तर प्रदेश, 247341', 'data:image/jpeg;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 1, '2025-10-26 18:12:44', '7500042610'),
(2, '853697513682', '8536 9751 3682', 'Md Shamshad', 'Mukhtar Hussain', '03/02/1993', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O : Mukhtar Hussain, 09, Satmeri, Maria, Kishanganj, Bihar, 855117', 'HI', 'मो0 शमशाद', 'पिता : मुख्तार हुसैन, 09, सतमेरी, मरिया, किशनगंज, बिहार, 855117', 'data:image/jpeg;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 2, '2025-10-28 13:24:05', '6206990138'),
(3, '947640210407', '9476 4021 0407', 'Md Sabir', 'Hajrat', '06/04/1990', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O : Hajrat, 01, Talbari, Chhattergachh, Kishanganj, Bihar, 855117', 'HI', 'मो0 साबिर', 'पुत्र: हजरत, 01, तालबाड़ी, छत्तरगाछ, किशनगंज, बिहार, 855117', 'data:image/jpeg;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 3, '2025-10-28 13:44:58', '6206990138');
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
(4, '442053335562', '4420 5333 5562', 'Suleman', 'Abdul Hak', '26/07/1990', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O : Abdul Hak, 10, Dighli, Maria, Kishanganj, Bihar, 855117', 'HI', 'सुलेमान', 'पुत्र: अब्दुल हक, 10, दिघली, मरिया, किशनगंज, बिहार, 855117', 'data:image/jpeg;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 4, '2025-10-29 12:35:10', '6206990138'),
(5, '982915707738', '9829 1570 7738', 'Kavya Ishwarappa Talavar', 'Ishwarappa Talavar', '01/01/2006', 'ಜನ್ಮ ದಿನಾಂಕ', 'FEMALE', 'ಹೆಣ್ಣು', 'D/O : Ishwarappa Talavar, \r\nNear Hanuman Temple, Kokatnur\r\n Bijapur, \r\nKarnataka, 586115', 'KN', 'ಕಾವ್ಯಾ ಈಶ್ವರಪ್ಪ ತಳವಾರ', 'D/O: ಈಶ್ವರಪ್ಪ ತಳವಾರ, \r\nಹನುಮಾನ ದೇವಸ್ಥಾನದ ಹತ್ತಿರ, ಕೊಕಟನೂರ\r\n ಬಿಜಾಪುರ, \r\nಕರ್ನಾಟಕ, 586115', 'data:image/jpeg;base64,[BLOB]', NULL, 'ವಿಳಾಸ', '', '', NULL, '', '', NULL, '', '', 5, '2025-10-31 05:19:23', '9008600902');
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
(6, '438580246285', '4385 8024 6285', 'Mahanand Chidanand Hubbali', 'Chidanand', '01/01/1975', 'ಜನ್ಮ ದಿನಾಂಕ', 'FEMALE', 'ಹೆಣ್ಣು', 'W/O : Chidanand, ., Masali B K, Masali B K, Bijapur, Karnataka, 586215', 'KN', 'ಮಹಾನಂದ ಚಿದಾನಂದ ಹುಬ್ಬಳ್ಳಿ', 'W/O : ಚಿದಾನಂದ  ಮಸಳಿ ಬಿ.ಕೆ\r\n ಬಿಜಾಪುರ, \r\nಕರ್ನಾಟಕ, 586215', 'data:image/jpeg;base64,[BLOB]', NULL, 'ವಿಳಾಸ', '', '', NULL, '', '', NULL, '', '', 6, '2025-11-01 15:17:37', '9008600902');
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
(7, '345263055117', '3452 6305 5117', 'PALA RAM', 'KUDA RAM', '01/01/1978', 'जन्म तिथि', 'MALE', 'पुरुष', 'S/O : KUDA RAM, PABNAWA, PO PABNAWA, DISTRICT KAITHAL, HARYANA, 136020', 'HI', 'पाला राम', 'पुत्र: कूड़ा राम, पबनावा, डाकघर पबनावा, जिला कैथल, हरियाणा, 136020', 'data:image/jpeg;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', '', NULL, '', '', 7, '2025-11-02 13:45:04', '7056717410');
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
(8, '921561841063', '9215 6184 1063', 'SALIM', '', '01/01/1994', 'जन्म तिथि', 'MALE', 'पुरुष', 'Saba Pur Delhi, Sabhapur, North East, Delhi - 110094', 'HI', 'सलीम', 'सबा पुर दिल्ली, सभापुर, उत्तर पूर्व, दिल्ली - 110094', 'data:image/jpeg;base64,[BLOB]', NULL, 'पता', '', '', NULL, '', 'North East', NULL, 'Delhi', '110094', 8, '2025-11-04 16:50:56', '9560469522');
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
(9, '901102647014', '9011 0264 7014', 'Abada Khatoon', 'Md Rajik', '01/01/1981', 'जन्म तिथि', 'FEMALE', 'महिला', 'S/O : Md Rajik, Ward No 05, Kathalbari, Maria, Kishanganj, Bihar, 855117', 'HI', 'आबदा खातून', 'पति : मो० राजिक, वार्ड नं 05, कटहलबाड़ी, मरिया, किशनगंज, बिहार, 855117', 'data:image/png;base64,[BLOB]