-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 20, 2026 at 10:52 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `lms`
--

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

--
-- Table structure for table `lms_instructor_courses`
--

CREATE TABLE `lms_instructor_courses` (
  `id` int(11) NOT NULL,
  `category_id` varchar(200) DEFAULT NULL,
  `category_title` varchar(200) DEFAULT NULL,
  `course_id` varchar(200) DEFAULT NULL,
  `course_title` varchar(200) DEFAULT NULL,
  `course_type` varchar(200) DEFAULT NULL,
  `course_img` varchar(200) DEFAULT NULL,
  `course_video` varchar(200) DEFAULT NULL,
  `course_price` varchar(200) DEFAULT NULL,
  `course_discount` varchar(200) DEFAULT NULL,
  `course_level` varchar(200) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `language` varchar(200) DEFAULT NULL,
  `no_of_class` varchar(200) DEFAULT NULL,
  `duration` varchar(200) DEFAULT NULL,
  `course_overview` text DEFAULT NULL,
  `details` text DEFAULT NULL,
  `cv` text DEFAULT NULL,
  `additional_info` text DEFAULT NULL,
  `grade` varchar(200) DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `modified_on` datetime DEFAULT NULL,
  `modified_by` varchar(200) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lms_instructor_courses`
--

INSERT INTO `lms_instructor_courses` (`id`, `category_id`, `category_title`, `course_id`, `course_title`, `course_type`, `course_img`, `course_video`, `course_price`, `course_discount`, `course_level`, `start_date`, `language`, `no_of_class`, `duration`, `course_overview`, `details`, `cv`, `additional_info`, `grade`, `created_on`, `created_by`, `modified_on`, `modified_by`, `status`) VALUES
(5, '2', 'Brahma', '7', 'Brahma', 'certificate_course', 'Frntnend_1773733767.jpg', '', '544', NULL, 'Intermediate', '2026-03-24', 'English ', NULL, NULL, '<p>Explore the fundamental concepts and principles of Robotics and Artificial Intelligence, their interrelationship, and their significance in various industries.</p>', '<h3 class=\"fs-14-16-fw-600-lh-20-24 color-Typography-High-Emphasis \">Introduction to Robotics and AI</h3>', '<h2 class=\"section-title \">About this course</h2>\r\n<div class=\"show_bulletin_pts\">\r\n<p><strong id=\"docs-internal-guid-c9da34af-7fff-d98f-1087-22757ef3ecea\"></strong></p>\r\n<p dir=\"ltr\"><strong id=\"docs-internal-guid-c9da34af-7fff-d98f-1087-22757ef3ecea\">This online AI Robotics course equips you with the foundational knowledge to understand the integration of robotics and artificial intelligence in real-world applications. You&rsquo;ll learn the key components of robotics, including control systems, programming languages, and algorithms, alongside the fundamentals of AI and machine learning. The course highlights the symbiotic relationship between robotics and AI, demonstrating how AI enhances robotic capabilities and robotics advances AI. You\'ll gain hands-on experience programming robots, implementing AI algorithms such as neural networks, and applying AI to robotics for tasks such as computer vision and autonomous navigation.</strong></p>\r\n<strong><br></strong>\r\n<p dir=\"ltr\">With exposure to real-world applications across industries such as healthcare, manufacturing, and transportation, this artificial intelligence for robotics course will equip you with the tools to contribute to innovative AI-driven robotics solutions. To keep you current with the latest trends, the course also includes an overview of Recent Updates in Robotics and AI. Whether you\'re aiming for roles in research, development, or engineering, this course will provide a solid foundation for your career in the growing field of robotics and AI. By the end of this course, you&rsquo;ll be equipped to pursue a career in robotics and AI. You will understand the essential skills needed, including programming, problem-solving, and collaboration, and be ready to tackle ethical considerations related to AI and robotics deployment.</p>\r\n<strong id=\"docs-internal-guid-c9da34af-7fff-d98f-1087-22757ef3ecea\"></strong></div>', '<h2 class=\"section-title\">Course outline</h2>', '12', '2026-03-17 13:19:27', '5', NULL, NULL, 1),
(6, '2', 'Brahma', '7', 'Brahma', 'certificate_course', 'Frntnend_1773733837.jpg', '', '54290', NULL, 'Intermediate', '2026-03-12', 'English ', NULL, NULL, '<p>Examine the symbiotic connection between Robotics and AI, understanding how AI enhances robotic capabilities and how robotics drives advancements in AI technologies.</p>', '<h3 class=\"fs-14-16-fw-600-lh-20-24 color-Typography-High-Emphasis \">Relationship between Robotics and AI</h3>', '<h3 class=\"fs-14-16-fw-600-lh-20-24 color-Typography-High-Emphasis \">Relationship between Robotics and AI</h3>', '<h3 class=\"fs-14-16-fw-600-lh-20-24 color-Typography-High-Emphasis \">Relationship between Robotics and AI</h3>', '11', '2026-03-17 13:20:37', '5', NULL, NULL, 1),
(7, '2', 'Brahma', '7', 'Brahma', 'certificate_course', 'Frntnend_1773733885.jpg', '', '90000', NULL, 'Beginner', '2026-03-14', 'English ', NULL, NULL, '<p>Learn the foundational components and principles of robotics, providing a comprehensive understanding of the field.</p>', '<h3 class=\"fs-14-16-fw-600-lh-20-24 color-Typography-High-Emphasis \">Basics of Robotics</h3>', '<p>Learn the foundational components and principles of robotics, providing a comprehensive understanding of the field.</p>', '<p>Learn the foundational components and principles of robotics, providing a comprehensive understanding of the field.</p>', '11', '2026-03-17 13:21:25', '5', NULL, NULL, 1),
(8, '2', 'Brahma', '7', 'Brahma', 'certificate_course', 'Frntnend_1773733936.jpg', '', '6700', NULL, 'Intermediate', '2026-03-14', 'English ', NULL, NULL, '<p>Dive into control systems theory, algorithms, and programming languages used in robotics, enabling you to command and control robots effectively.</p>', '<h3 class=\"fs-14-16-fw-600-lh-20-24 color-Typography-High-Emphasis \">Control Systems, Algorithms, and Robot Programming Languages</h3>', '<p>Dive into control systems theory, algorithms, and programming languages used in robotics, enabling you to command and control robots effectively.</p>', '<p>Dive into control systems theory, algorithms, and programming languages used in robotics, enabling you to command and control robots effectively.</p>', '12', '2026-03-17 13:22:16', '5', NULL, NULL, 1),
(9, '2', 'Brahma', '7', '', 'certificate_course', '', '', '5440', NULL, 'Beginner', '2026-03-04', 'English ', '12', '5 hours', '<p>Gain an understanding of Artificial Intelligence (AI) and Machine Learning (ML) fundamentals, exploring algorithms, data analysis, and decision-making processes.</p>', '<h3 class=\"fs-14-16-fw-600-lh-20-24 color-Typography-High-Emphasis \">Basics of AI and ML</h3>', '<p>Gain an understanding of Artificial Intelligence (AI) and Machine Learning (ML) fundamentals, exploring algorithms, data analysis, and decision-making processes.</p>', '<p>Gain an understanding of Artificial Intelligence (AI) and Machine Learning (ML) fundamentals, exploring algorithms, data analysis, and decision-making processes.</p>', '12', '2026-03-17 13:22:58', '5', '2026-03-17 16:54:27', '5', 1);

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

--
-- Table structure for table `lms_instructor_documents`
--

CREATE TABLE `lms_instructor_documents` (
  `id` int(11) NOT NULL,
  `instructor_id` varchar(200) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `id_proof` varchar(200) DEFAULT NULL,
  `grad_proof` varchar(200) DEFAULT NULL,
  `exp_cert` varchar(200) DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `modified_on` datetime DEFAULT NULL,
  `modified_by` varchar(200) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lms_instructor_documents`
--

INSERT INTO `lms_instructor_documents` (`id`, `instructor_id`, `image`, `id_proof`, `grad_proof`, `exp_cert`, `created_on`, `created_by`, `modified_on`, `modified_by`, `status`) VALUES
(3, '5', 'Frntnend_1773749658.jpg', 'murali10thmarklist_1773749658.jpg', '211FD01064Certificate_1773749658.jpg', 'newplot_1773749658.png', '2026-03-17 17:44:18', '5', NULL, NULL, 1);

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

--
-- Table structure for table `lms_instructor_lessons`
--

CREATE TABLE `lms_instructor_lessons` (
  `id` int(11) NOT NULL,
  `course_id` varchar(200) DEFAULT NULL,
  `course_title` varchar(200) DEFAULT NULL,
  `module_id` varchar(200) DEFAULT NULL,
  `module_title` varchar(200) DEFAULT NULL,
  `lesson_title` varchar(200) DEFAULT NULL,
  `lesson_type` varchar(200) DEFAULT NULL,
  `video_url` varchar(200) DEFAULT NULL,
  `video_upload` varchar(200) DEFAULT NULL,
  `material_url` varchar(200) DEFAULT NULL,
  `material_upload` varchar(200) DEFAULT NULL,
  `assignment_upload` varchar(200) DEFAULT NULL,
  `lesson_url` varchar(200) DEFAULT NULL,
  `lesson_content` text DEFAULT NULL,
  `assign_instruction` text DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `modified_on` datetime DEFAULT NULL,
  `modified_by` varchar(200) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lms_instructor_lessons`
--

INSERT INTO `lms_instructor_lessons` (`id`, `course_id`, `course_title`, `module_id`, `module_title`, `lesson_title`, `lesson_type`, `video_url`, `video_upload`, `material_url`, `material_upload`, `assignment_upload`, `lesson_url`, `lesson_content`, `assign_instruction`, `created_on`, `created_by`, `modified_on`, `modified_by`, `status`) VALUES
(37, '5', NULL, '11', 'Syllabus ', 'Marketing ', 'Video', '', 'Frntnend_1773988217.jpg', '', '', '', '', '<p>vvvvvvvvvvvvvvvvvvv</p>', '', '2026-03-20 12:00:17', '5', NULL, NULL, 1),
(38, '5', NULL, '10', 'Overview', 'Digital Marketing ', 'Text Materials', '', '', 'http://localhost/lms/instructor/add_lesson.php?module_id=11&course_id=5', 'Frntnend_1773988954.jpg', '', 'http://localhost/lms/instructor/add_lesson.php?module_id=11&course_id=5', '<h1 class=\"css-ylpfmv\">Digital Marketing Specialist</h1>\r\n<div class=\"css-13uzvl2\">\r\n<div class=\"css-ngd472\">\r\n<p class=\"css-6ecy9b\">If you like&nbsp;creating online marketing campaigns, analyzing digital data, and driving customer engagement&nbsp;this role is for you.</p>\r\n<p class=\"css-kimdhf\">A Digital Marketing Specialist creates and manages online campaigns to drive engagement and conversions. They optimize SEO, SEM, and social media strategies using analytics tools like Google Analytics.</p>\r\n<p class=\"css-kimdhf\"><strong>Skills you&rsquo;ll need</strong>: Digital Marketing, Search Engine Optimization, Social Media Marketing, Google Analytics, Content Marketing, Email Marketing, Search Engine Marketing, Data Analysis</p>\r\n</div>\r\n</div>', '', '2026-03-20 12:12:34', '5', NULL, NULL, 1),
(39, '5', NULL, '10', 'Overview', 'Marketing 2', 'Assignments', '', '', '', '', 'Frntnend_1773989607.jpg', '', '<h1 class=\"css-ylpfmv\">Digital Marketing Specialist</h1>\r\n<div class=\"css-13uzvl2\">\r\n<div class=\"css-ngd472\">\r\n<p class=\"css-6ecy9b\">If you like&nbsp;creating online marketing campaigns, analyzing digital data, and driving customer engagement&nbsp;this role is for you.</p>\r\n<p class=\"css-kimdhf\">A Digital Marketing Specialist creates and manages online campaigns to drive engagement and conversions. They optimize SEO, SEM, and social media strategies using analytics tools like Google Analytics.</p>\r\n<p class=\"css-kimdhf\"><strong>Skills you&rsquo;ll need</strong>: Digital Marketing, Search Engine Optimization, Social Media Marketing, Google Analytics, Content Marketing, Email Marketing, Search Engine Marketing, Data Analysis</p>\r\n</div>\r\n</div>', '<h1 class=\"css-ylpfmv\">Digital Marketing Specialist</h1>\r\n<div class=\"css-13uzvl2\">\r\n<div class=\"css-ngd472\">\r\n<p class=\"css-6ecy9b\">If you like&nbsp;creating online marketing campaigns, analyzing digital data, and driving customer engagement&nbsp;this role is for you.</p>\r\n<p class=\"css-kimdhf\">A Digital Marketing Specialist creates and manages online campaigns to drive engagement and conversions. They optimize SEO, SEM, and social media strategies using analytics tools like Google Analytics.</p>\r\n<p class=\"css-kimdhf\"><strong>Skills you&rsquo;ll need</strong>: Digital Marketing, Search Engine Optimization, Social Media Marketing, Google Analytics, Content Marketing, Email Marketing, Search Engine Marketing, Data Analysis</p>\r\n</div>\r\n</div>', '2026-03-20 12:23:27', '5', NULL, NULL, 1),
(41, '5', NULL, '12', 'Overview1', 'Marketing ', 'Text Materials', '', '', 'http://localhost/lms/instructor/add_lesson.php?module_id=11&course_id=5', 'Frntnend_1773993157.jpg', '', '', '<h1 class=\"css-ylpfmv\">Digital Marketing Specialist</h1>\r\n<div class=\"css-13uzvl2\">\r\n<div class=\"css-ngd472\">\r\n<p class=\"css-6ecy9b\">If you like&nbsp;creating online marketing campaigns, analyzing digital data, and driving customer engagement&nbsp;this role is for you.</p>\r\n<p class=\"css-kimdhf\">A Digital Marketing Specialist creates and manages online campaigns to drive engagement and conversions. They optimize SEO, SEM, and social media strategies using analytics tools like Google Analytics.</p>\r\n<p class=\"css-kimdhf\"><strong>Skills you&rsquo;ll need</strong>: Digital Marketing, Search Engine Optimization, Social Media Marketing, Google Analytics, Content Marketing, Email Marketing, Search Engine Marketing, Data Analysis</p>\r\n</div>\r\n</div>', '', '2026-03-20 13:22:37', '5', NULL, NULL, 1),
(42, '', NULL, '', 'Syllabus', 'Marketing 4', 'Video', 'https://www.coursera.org/career-academy/roles/digital-marketing-specialist', 'newplot_1773994860.png', '', '', '', 'https://www.coursera.org/career-academy/roles/digital-marketing-specialist', '<p>https://www.coursera.org/career-academy/roles/digital-marketing-specialist</p>', '', '2026-03-20 13:37:29', '5', '2026-03-20 13:51:00', '5', 1),
(43, '5', 'Brahma', '12', 'Overview1', 'Digital Marketing ', 'Assignments', '', '', '', '', 'Frntnend_1773996176.jpg', 'https://www.coursera.org/career-academy/roles/digital-marketing-specialist', '<h1 class=\"css-ylpfmv\">Digital Marketing Specialist</h1>\r\n<div class=\"css-13uzvl2\">\r\n<div class=\"css-ngd472\">\r\n<p class=\"css-6ecy9b\">If you like&nbsp;creating online marketing campaigns, analyzing digital data, and driving customer engagement&nbsp;this role is for you.</p>\r\n<p class=\"css-kimdhf\">A Digital Marketing Specialist creates and manages online campaigns to drive engagement and conversions. They optimize SEO, SEM, and social media strategies using analytics tools like Google Analytics.</p>\r\n<p class=\"css-kimdhf\"><strong>Skills you&rsquo;ll need</strong>: Digital Marketing, Search Engine Optimization, Social Media Marketing, Google Analytics, Content Marketing, Email Marketing, Search Engine Marketing, Data Analysis</p>\r\n</div>\r\n</div>', '<h1 class=\"css-ylpfmv\">Digital Marketing Specialist</h1>\r\n<div class=\"css-13uzvl2\">\r\n<div class=\"css-ngd472\">\r\n<p class=\"css-6ecy9b\">If you like&nbsp;creating online marketing campaigns, analyzing digital data, and driving customer engagement&nbsp;this role is for you.</p>\r\n<p class=\"css-kimdhf\">A Digital Marketing Specialist creates and manages online campaigns to drive engagement and conversions. They optimize SEO, SEM, and social media strategies using analytics tools like Google Analytics.</p>\r\n<p class=\"css-kimdhf\"><strong>Skills you&rsquo;ll need</strong>: Digital Marketing, Search Engine Optimization, Social Media Marketing, Google Analytics, Content Marketing, Email Marketing, Search Engine Marketing, Data Analysis</p>\r\n</div>\r\n</div>', '2026-03-20 14:12:56', '5', NULL, NULL, 1);

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

--
-- Table structure for table `lms_instructor_modules`
--

CREATE TABLE `lms_instructor_modules` (
  `id` int(11) NOT NULL,
  `course_id` varchar(200) DEFAULT NULL,
  `course_title` varchar(200) DEFAULT NULL,
  `module_title` varchar(200) DEFAULT NULL,
  `no_of_lessons` varchar(200) DEFAULT NULL,
  `created_by` varchar(200) DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `modified_by` varchar(200) DEFAULT NULL,
  `modified_on` datetime DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lms_instructor_modules`
--

INSERT INTO `lms_instructor_modules` (`id`, `course_id`, `course_title`, `module_title`, `no_of_lessons`, `created_by`, `created_on`, `modified_by`, `modified_on`, `status`) VALUES
(11, '5', 'Brahma', 'Syllabus', NULL, '5', '2026-03-20 11:01:01', '5', '2026-03-20 13:12:25', 1),
(12, '5', 'Brahma', 'Overview1', NULL, '5', '2026-03-20 13:12:43', '5', '2026-03-20 13:17:01', 1),
(13, '7', 'Brahma', 'Overview', NULL, '5', '2026-03-20 14:27:52', NULL, NULL, 1);

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `lms_instructor_courses`
--
ALTER TABLE `lms_instructor_courses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

--
-- AUTO_INCREMENT for table `lms_instructor_lessons`
--
ALTER TABLE `lms_instructor_lessons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
