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

START TRANSACTION;



--
-- Database: `pushpaprinte_Nabialam`
--

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

--
-- Table structure for table `lms_apply_history`
--

CREATE TABLE `lms_apply_history` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `application_id` int(11) NOT NULL,
  `service_type` varchar(50) NOT NULL,
  `service_name` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `mobile` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `aadhar_number` varchar(12) NOT NULL,
  `district` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `service_price` decimal(10,2) NOT NULL,
  `status` varchar(20) DEFAULT 'Pending',
  `date` varchar(50) NOT NULL,
  `lms_id_user` varchar(255) DEFAULT NULL,
  `lms_password_user` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lms_apply_history`
--

INSERT INTO `lms_apply_history` (`id`, `username`, `application_id`, `service_type`, `service_name`, `name`, `mobile`, `email`, `aadhar_number`, `district`, `state`, `service_price`, `status`, `date`, `lms_id_user`, `lms_password_user`) VALUES
(1, '7631394549', 18, 'LMS', 'Learning Management System', 'smpat', '9880291726', 'admin@admin.in', '999999999999', 'DISTRICT', 'Punjab', 600.00, 'completed', '06/11/2025 2:13:08', '99198900066@gmail.com', 'Uidai#2024'),
(2, '7631394549', 19, 'LMS', 'Learning Management System', 'work', '9812362262', 'hxbsolution@gmail.com', '999999999999', 'DISTRICT', 'Punjab', 600.00, 'completed', '06/11/2025 2:43:36', 'tinkur454@gmail.com', 'Uidai#2024'),
(3, '7631394549', 20, 'LMS', 'Learning Management System', 'smpat', '9812362262', 'admin@admin.in', '999999999999', 'DISTRICT', 'West Bengal', 600.00, 'completed', '06/11/2025 5:26:41', 'sdbdfbfb@gmail.com', 'weigbj');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `lms_apply_history`
--
ALTER TABLE `lms_apply_history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`),
  ADD KEY `application_id` (`application_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

