-- 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,[encoded data, 14260 characters]', 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,[encoded data, 13104 characters]', 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,[encoded data, 20528 characters]', 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,[encoded data, 27464 characters]', 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,/9j/4AAQSkZJRgABAQEAeAB4AAD/4QBaRXhpZgAATU0AKgAAAAgABQMBAAUAAAABAAAASgMDAAEAAAABAAAAAFEQAAEAAAABAQAAAFERAAQAAAABAAASdFESAAQAAAABAAASdAAAAAAAAYagAACxj//bAEMAAgEBAgEBAgICAgICAgIDBQMDAwMDBgQEAwUHBgcHBwYHBwgJCwkICAoIBwcKDQoKCwwMDAwHCQ4PDQwOCwwMDP/bAEMBAgICAwMDBgMDBgwIBwgMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDP/AABEIAEQANQMBIgACEQEDEQH/xAAfAAABBQEBAQEBAQAAAAAAAAAAAQIDBAUGBwgJCgv/xAC1EAACAQMDAgQDBQUEBAAAAX0BAgMABBEFEiExQQYTUWEHInEUMoGRoQgjQrHBFVLR8CQzYnKCCQoWFxgZGiUmJygpKjQ1Njc4OTpDREVGR0hJSlNUVVZXWFlaY2RlZmdoaWpzdHV2d3h5eoOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4eLj5OXm5+jp6vHy8/T19vf4+fr/xAAfAQADAQEBAQEBAQEBAAAAAAAAAQIDBAUGBwgJCgv/xAC1EQACAQIEBAMEBwUEBAABAncAAQIDEQQFITEGEkFRB2FxEyIygQgUQpGhscEJIzNS8BVictEKFiQ04SXxFxgZGiYnKCkqNTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqCg4SFhoeIiYqSk5SVlpeYmZqio6Slpqeoqaqys7S1tre4ubrCw8TFxsfIycrS09TV1tfY2dri4+Tl5ufo6ery8/T19vf4+fr/2gAMAwEAAhEDEQA/AP0LtYQHx155rbs1S0t/MkZUQDJZjgVUsYM5GB83tzXw5/wW+/bY1T9nv4c6f4V8PX7WOo66jNcyrw6xDspB4yapyKTsj0X9o3/gs18J/wBnvxTdaIZL3XtSsiUmWzUeUjj+HeTgn6V5X8Ov+DiHwTrHiYQaz4W1DT7NnI86CdZWAPTKmvxrkW++IerveXd1guxZixJJotdMjtLseS8k5Q9QGwK5JYuMZcjZapSa5ktD+oD9nr9pPwV+0t4Ti1bwlrNtqMLIDJEGAlgP9116g16EYEx0zX86f/BPD9uHUf2UvjrpmoR3EiadPMsF7bhvlmjJwcj+tf0L+CvF1r448M2Gq2biW21CBZ42U5BDDNdUal9UQ3fQvS2Y3fKQB9KKsFd3pRVc5lys4C3vPspy/CjqR2r8Qf8Ag4B8UXWq/tW2yedLNZx6cscC577ua/adLlLq1KOcgjkDuK/Gv/gsX8OdO0b9pvQNOsp5byOeGW7keYZkV2bO0n0HauTEzUYXOijTc5KKPkf4C+BZZ9QW41B4o4pB8sbt8xFfVXw4+F3hOysnluYrY7hksSOPrXzf4e+Bl9fa3I9wt4kYRmR4sD5v4efSvevgt8NL7xL8L9QtpJWe/SQRKzHtivj8bWfMpxkfSYeg1B03HY4j4t/s66FqOoXeqeGNWtZby3zIbRJAScc8e9fuB/wS3vNV1D9ivwU2sqI7tbMKq99g4Ga/IP4I/s5ax4f1e4fUnbd5xbBZT8mMbcY/Wv2N/wCCe0S2v7MXhqBrpro2sbpudsuoDHC/TFe1leJ5p+z5rnkY2go+8la57ssJI/GipIrrauAeKK927PP5T5F8S/H+z0P4Rahryuo+y2zS7VOWGBX4Z/tNftcJ8X/j7qWvai8xAl8m3LMf3eG9PSvrD9pT423kPwv1XQdG1KZr68j8tkjbcqqfXHSvzj8ffDS/0fVrhLqVfNGHcE5OT3zXjTxdOsvZyep7VbLMRhpKrFaeZ9Y+AvirHHozxyywlGjO12bgZHHNd9+zx8TY9Jtru1uX08iZ8rMLrn8q+P8AwZr8mkafb20p85FjCtnkV718DNS0lYt6tKQTll+zIw/MivmMVQhTbbZ9FGo50+x9ZaFrsXibU4Ybe4WXz5FQyJ820f1r9Lv2ZPh3H8L/AIZWNut//aDTxq4lACqq9cAD696/GjT/AIk3Oh+ONHu9MZYks5TN9nIwtxjrnHTiv09/ZD/bH8H/ABH8HWdhLqy6NqaLhrS5YKm7/ZY8EV6OVKFNc7er2PGx2DxNdc1KDcY721PqVNQYDhh+dFYVpeLLCGjvkkRhlXUhlYexFFfQxxGh89dLSW5+Cn7Nkw1/xXqFtJFFdtdQMcyAyY968+/ax+Ctvpd/HfwFkju4lUoFICuDg1V/Zj+IL6F4rhknk8qNZmgkckj5Sete8fHDwlYeOfBn2aC6SU3Klo7lCNrSdeB1AHSvjK0nSrqXc/Z+J4Jy5ktJL5Kx8aaj4F1Pw5Mp8rzEPQ12PgTxVqGiwi2W1O9h24rotb+0+FXhtNSRsooG5lyrY9DWTeeL4o5y8CLleMqves6mIlP3ZLQ+PhT5Y7nW6Xqt4dYsnl+Ro43kIJP0/rXqGkeJjockU6XGxLXChgCAxI6fWvF9K07V7zU7PVNQ32toxWOCOQbTJzkn6Vva/wCJZ200EYRJrh3ReQCM8Y/KtaUrJOJ9xwhR5eafdn3t+zv/AMFJ9Y+H/gVNL1GCDVI7cgW7zD5415yCe/aiviLT/FclnapEgZ2CguzdyaK74152PfxPC+WVqsqsqerPBPAV7IzXGSP9c1e7/CHXrqXR2jeQyR2xCRKwyEB60UVli0jhzVJ5Ym+5115odrrE8kF5Cl0iOAvmKCUHoMdKLL4XaBpE8Jt9Mtke6LeY+3LHA4xnp+FFFeXdnyLijm/jnMYtHskUKArhQcc9OufWvOJdQlu9Kt/Mbf5RUJn+Hk0UV0UdkfUcPpezNv4dh9St7ySWWUsJdowegooortPoW9T/2Q==', 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,[encoded data, 86464 characters]', 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,[encoded data, 46968 characters]', 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,[encoded data, 7600 characters]', 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,[encoded data, 297275 characters]