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

START TRANSACTION;



--
-- Database: `pushpaprinte_Nabialam`
--

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

--
-- Table structure for table `ll_pas`
--

CREATE TABLE `ll_pas` (
  `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,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dob` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `appicationNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pan_no` 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,
  `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,
  `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,
  `state` 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 `ll_pas`
--

INSERT INTO `ll_pas` (`id`, `application_no`, `appliedby`, `password`, `dob`, `appicationNo`, `pan_no`, `eid`, `date`, `time`, `pdf_link`, `status`, `fee`, `ret_wp_no`, `aadhaar_no`, `state`, `apply_date`) VALUES
(1, 'Ll_exam11312922', '7669771997', 'N2NR48', '2006-01-01', '3893368025', NULL, NULL, NULL, NULL, NULL, 'pending', '70', '7669771997', NULL, NULL, '2025-09-22 15:39:53'),
(2, '9876543210', '7631394549', 'ASDF7654', '2000-01-01', NULL, NULL, NULL, '2025-11-02', '03:47:23', 'uploads/learning_licenses/learning_942_69068fd29f151.png', 'Success', '80', '7631394549', NULL, 'Haryana', '2025-11-02 03:47:23'),
(3, '98765432100', '7631394549', 'kjhgfd', '2001-01-01', NULL, NULL, NULL, '2025-11-02', '04:35:41', 'uploads/learning_licenses/learning_943_69069411605f1.jpg', 'Success', '80', '7631394549', NULL, 'Goa', '2025-11-02 04:35:41'),
(4, 'LL_17620386659122', '7631394549', 'kdufs', '2003-01-01', NULL, NULL, NULL, '2025-11-02', '04:41:05', NULL, 'pending', '80', '7631394549', NULL, 'Jammu and Kashmir', '2025-11-02 04:41:05');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ll_pas`
--
ALTER TABLE `ll_pas`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ll_pas`
--
ALTER TABLE `ll_pas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

