--
-- Host: localhost    Database: jobaajgroup_jobaaj_fit
-- ------------------------------------------------------


--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` VALUES
(1,'Tushar Sharma','tushar@gmail.com','9870663306','sdasfsghj','2025-06-25 09:48:07'),
(2,'akash','akash@gmail.com','9870663301','nkjhcxasd','2025-06-25 10:16:05');

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `short_description` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `outcomes` longtext DEFAULT NULL,
  `requirements` longtext DEFAULT NULL,
  `price` varchar(10) NOT NULL,
  `discounted_price` varchar(10) NOT NULL,
  `level` varchar(50) DEFAULT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `video_url` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `slug` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `meta_keywords` longtext DEFAULT NULL,
  `meta_description` longtext DEFAULT NULL,
  `is_free_course` int(11) DEFAULT 0,
  `course_duration` varchar(100) DEFAULT NULL,
  `trainer_id` varchar(255) DEFAULT NULL,
  `tags` varchar(255) DEFAULT NULL,
  `certificate_status` int(11) DEFAULT NULL,
  `course_overview_provider` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `course`
--

INSERT INTO `course` VALUES
(1,'Testing Course By Dhruv singh','Explore the dynamic world of Equity Research & Investment Banking in our workshop.','<p>Delve into the realm of Equity Research &amp; Investment Banking with our comprehensive workshop. Gain insights into the pivotal role of investment bankers, their strategic importance in the financial sector, and the pathways to enter this competitive field.</p>\r\n\r\n<p>Explore the diverse job opportunities available, ranging from advisory roles to financial analysis. Learn about the top companies actively seeking investment bankers and the factors that drive their hiring decisions.</p>\r\n','[\"n/a\",\"No Outcomes\"]','[\"n/a \",\"No Prerequisites\"]','11000','9999','intermediate','1752920412.jpg','https://youtu.be/tDMuhR3CgGM?si=Hh3XJGIqoFUAKEoB','2025-07-19 07:57:43','2025-12-22 10:25:51','testing-course-by-dhruv-singh','pending','Meta keywords dhruv','Meta Keywords dhruv',0,NULL,'2',NULL,NULL,'youtube'),
(2,'Dummy Course','he standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero','<h2>Where can I get some?</h2>\r\n\r\n<p>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don&#39;t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn&#39;t anything embarrassing hidden in the middle of text.&nbsp;</p>\r\n','[\"No Outcomes\"]','[\"No Prerequisites\"]','','','advanced','1753356806.jpg','','2025-07-23 10:14:32','2025-07-25 05:00:58','dummy-course','active','Meta keywordsadfsd','Meta Descriptionfdrawser',1,NULL,'1',NULL,NULL,'gumlet');

--
-- Table structure for table `enrol`
--

CREATE TABLE `enrol` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `course_lock` varchar(255) DEFAULT NULL,
  `discord_status` int(11) DEFAULT 0,
  `discordid` varchar(100) DEFAULT NULL,
  `manual` int(11) DEFAULT 0,
  `userTracking` longtext DEFAULT NULL,
  `given_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `enrol`
--

INSERT INTO `enrol` VALUES
(1,1,1,NULL,0,NULL,1,NULL,NULL,'2025-07-24 06:35:42','2025-07-24 06:35:42'),
(3,4,1,NULL,0,NULL,1,NULL,NULL,'2025-07-24 06:57:38','2025-07-24 07:31:01'),
(5,4,2,NULL,0,NULL,1,NULL,NULL,'2025-07-25 05:01:15','2025-07-25 05:01:15'),
(6,1,2,NULL,0,NULL,1,NULL,NULL,'2025-07-25 05:01:27','2025-07-25 05:01:27');

--
-- Table structure for table `lesson`
--

CREATE TABLE `lesson` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `duration` varchar(255) DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `video_type` varchar(255) DEFAULT NULL,
  `video_url` varchar(255) DEFAULT NULL,
  `gumlet_asset_id` varchar(200) DEFAULT NULL,
  `summary` longtext DEFAULT NULL,
  `is_free` int(11) DEFAULT -1,
  `l_order` int(11) DEFAULT 0,
  `lesson_documents` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `lesson`
--

INSERT INTO `lesson` VALUES
(2,'Lesson 0','5:00',1,1,'youtube','https://www.youtube.com/watch?v=BNc72CtXbwk',NULL,'<h3><strong>The standard Lorem Ipsum passage, used since the 1500s</strong></h3>\r\n\r\n<p>&quot;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.&quot;</p>\r\n',-1,2,'[\"687f3a76e18fa.png\",\"687f3a76e1c91.jpg\"]','2025-07-22 07:15:02','2025-12-22 10:22:56'),
(4,'Lesson 2','45:00',1,1,'youtube','https://www.youtube.com/watch?v=BNc72CtXbwk',NULL,'<p>Testing purpose only</p>\r\n',-1,0,'[\"687f63e75013d.jpg\"]','2025-07-22 10:11:51','2025-07-22 10:12:07'),
(5,'Lesson 3','10:00',1,1,'youtube','https://www.youtube.com/watch?v=FudfVyYWNxQ',NULL,'<h3>1914 translation by H. Rackham</h3>\r\n\r\n<p>&quot;But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?&quot;</p>\r\n',-1,1,'[\"687f6ba7902a6.webp\",\"687f6ba790398.png\",\"687f6ba79047c.png\"]','2025-07-22 10:44:55','2025-07-22 10:52:11'),
(8,'Testing','7:45',1,1,'gumlet','gumlet url',NULL,'<p>Testing purpose only</p>\r\n',-1,3,'[\"688083736ee44.jpg\",\"68808390d37ae.webp\"]','2025-07-23 06:32:42','2025-12-22 10:22:56'),
(9,'Test Lesson','14:00',2,5,'youtube','https://www.youtube.com/watch?v=BNc72CtXbwk',NULL,'',-1,1,'[]','2025-07-24 11:16:08','2025-07-24 11:31:07'),
(10,'sdfsdfdsf','',2,5,'','',NULL,'',-1,0,'[]','2025-07-24 11:30:27','2025-07-24 11:31:07');

--
-- Table structure for table `section`
--

CREATE TABLE `section` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `s_order` int(11) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `section`
--

INSERT INTO `section` VALUES
(1,'SECTION 1',1,0,'2025-07-21 06:25:36','2025-07-23 06:43:23'),
(4,'SECTION 2',1,1,'2025-07-23 06:41:41','2025-07-23 06:43:39'),
(5,'Test Section',2,0,'2025-07-23 11:34:44','2025-07-24 11:29:58');

--
-- Table structure for table `trainers`
--

CREATE TABLE `trainers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `profile_img` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT '0',
  `title` varchar(100) NOT NULL,
  `bio` text DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `trainers`
--

INSERT INTO `trainers` VALUES
(1,'Jhon Doe','https://cdn.nishtyainfotech.com/learnings/assets/auth/sakasham-sir.jpg','Yoga Expert','Professional Yoga Teacher','test test',NULL,'2025-07-23 11:50:30','2025-07-23 11:50:30'),
(2,'Shiva Vashishtha','https://cdn.nishtyainfotech.com/learnings/assets/auth/shiva-sir.jpg','Trainer','Professional Trainer',NULL,NULL,'2025-07-23 11:50:30','2025-07-23 11:50:30'),
(3,'Ramdev Baba','https://yt3.googleusercontent.com/D-T9ZQ7XjXm7DDz-oeGedfINCZrM2zThFpUzShQOC2EGYBL3DPnA2gWRAT-pTcNpEplM9xO5CIM=s900-c-k-c0x00ffffff-no-rj','Trainer','Professional Trainer',NULL,NULL,'2025-07-23 11:50:30','2025-07-23 11:50:30');


