[BLOB]', '2025-11-06 17:55:41');

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

--
-- Table structure for table `pan_details`
--

CREATE TABLE `pan_details` (
  `id` int(11) NOT NULL,
  `application` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `pan` varchar(20) NOT NULL,
  `dob` varchar(255) DEFAULT NULL,
  `gender` varchar(10) NOT NULL,
  `fathername` varchar(100) NOT NULL,
  `aadhar` varchar(20) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pan_details`
--

INSERT INTO `pan_details` (`id`, `application`, `username`, `name`, `pan`, `dob`, `gender`, `fathername`, `aadhar`, `date`) VALUES
(1, 'pan_to_full_details_wbT8xZrqiXW2MVUjkYGK', '9330699696', 'KAKALI SAHA', 'FGUPS3351F', '30/04/1992', 'Female', 'DIPENDRA KUMAR DAS', 'XXXXXXXX6875', '2025-10-14 17:25:32'),
(2, 'pan_to_full_details_pZdTmYbIifnHGcQOz0Ca', '9330699696', 'KAKALI SAHA', 'FGUPS3351F', '30/04/1992', 'Female', 'DIPENDRA KUMAR DAS', 'XXXXXXXX6875', '2025-10-14 17:26:31'),
(3, 'pan_to_details_z76ZKjqtBN8A4VEDgI5Y', '7500042610', 'BHARATBHUSHAN', 'CUBPB4414Q', '01/01/1989', 'Male', '', 'XXXXXXXX2432', '2025-10-20 12:48:48'),
(4, 'pan_to_full_details_B5tP7i8Xh93nO2CjmSTR', '8341941402', 'JANI BASHA SHAIK', 'EGGPS9981A', '18/06/1988', 'Male', 'JANI SHAIK', '', '2025-10-27 19:49:09'),
(5, 'pan_to_full_details_bav6E1VI4JXBnmUWijNr', '7017915077', 'ABRAR', 'BQZPA6228C', '08/11/1989', 'Male', 'ILIYAS', '', '2025-10-29 12:00:45'),
(6, 'pan_to_full_details_E4Nq3gZ6AojnkzealrJS', '6351764460', 'GAYATRI PARMAR', 'FLCPP0665N', '05/07/1996', 'Female', 'VINODBHAI PARMAR', 'XXXXXXXX2189', '2025-11-06 17:40:35'),
(7, 'pan_to_full_details_910qRvDaLIcJigxblNSz', '6351764460', 'PATEL ANCHAL BHIKHARI', 'IUXPB9469P', '12/02/2006', 'Female', '', 'XXXXXXXX9017', '2025-11-06 17:52:58');

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

--
-- Table structure for table `ration_pdf`
--

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

--
-- Dumping data for table `ration_pdf`
--

INSERT INTO `ration_pdf` (`id`, `name`, `username`, `aadhar`, `pdf`, `date`) VALUES
(1, '', '9330699696', '', 'data:application/pdf;base64,[BLOB]', '2025-10-25 15:03:50');
INSERT INTO `ration_pdf` (`id`, `name`, `username`, `aadhar`, `pdf`, `date`) VALUES
(2, '', '9826427511', '43563454', 'data:application/pdf;base64,[BLOB]', '2025-10-28 09:22:55');
INSERT INTO `ration_pdf` (`id`, `name`, `username`, `aadhar`, `pdf`, `date`) VALUES
(3, '', '9826427511', '43563454', 'data:application/pdf;base64,[BLOB]