/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.16-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: jobaajgroup_jobaaj_fit
-- ------------------------------------------------------
-- Server version	10.11.16-MariaDB-ubu2204

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `admin_logins`
--

DROP TABLE IF EXISTS `admin_logins`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin_logins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `password` varchar(100) NOT 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_logins`
--

LOCK TABLES `admin_logins` WRITE;
/*!40000 ALTER TABLE `admin_logins` DISABLE KEYS */;
INSERT INTO `admin_logins` VALUES
(1,'Admin','admin@jobaaj.fit',NULL,'$2a$12$fyki4NOen.x3jjjdm1T4oe8e3L1Eob05Xcoy10ZEIxVtgTIrSI76W','2025-07-24 10:21:26','2025-07-24 10:34:28');
/*!40000 ALTER TABLE `admin_logins` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `contact_us`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `contact_us` WRITE;
/*!40000 ALTER TABLE `contact_us` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `contact_us` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `course`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `course` WRITE;
/*!40000 ALTER TABLE `course` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `course` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `enrol`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `enrol` WRITE;
/*!40000 ALTER TABLE `enrol` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `enrol` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `lesson`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `lesson` WRITE;
/*!40000 ALTER TABLE `lesson` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `lesson` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `section`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `section` WRITE;
/*!40000 ALTER TABLE `section` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `section` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `trainers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `trainers` WRITE;
/*!40000 ALTER TABLE `trainers` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `trainers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `bio` text DEFAULT NULL,
  `user_status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `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=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'Dhruv Singh','dhruvjobaaj@gmail.com','8520741087','$2y$10$YcgAuobXXB9.6U482ydPEeAWUgqXKfG4TOgM0XF52aPe6HtJ43KfW','This is just a testing purpose bio.\r\n\r\nI am exciting to build jobaaj fit.','active','2025-07-15 10:45:00','2025-07-25 06:29:21'),
(2,'Naina Baker','naina@gmail.com',NULL,'$2y$10$kpOxYjI.FzRwp/m.hG65kucx/AOQGruk3c9fDxzNHI4B7Agj2I2TW',NULL,'active','2025-07-24 06:06:03','2025-07-24 06:06:03'),
(3,'Gauri Calhoun','Gauri@gmail.com',NULL,'$2y$10$7oqkTCIjFA2UCkxqSZngb.cg1jfMqZBp5iS5YW/mffE5cFaHpcgzq',NULL,'active','2025-07-24 06:07:25','2025-07-24 06:07:25'),
(4,'Shivam Singhal','shivam@gmail.com',NULL,'$2y$10$sALIAKUWuBhfj09N3G6b4.5MA7NYu4qcw3fWBZOiy..KrKJvAx.zy',NULL,'active','2025-07-24 06:08:19','2025-07-24 06:08:19'),
(5,'Prateek','prateekguptajii4@gmail.com',NULL,'$2y$10$BMvgYLnbCiNA9dReAjsfN.IQlLBgA86eFpaDh8ebG1TvDjM.8oP8e',NULL,'active','2025-07-25 06:54:36','2025-07-25 06:54:36'),
(6,'Rimjhim','rimjhimjain2308@gmail.com',NULL,'$2y$10$ioWd6YTh6D7NzLca8LroluiIzdPBXgXRtORwTV.O0I/4bb8z.KQce',NULL,'active','2026-01-01 19:10:08','2026-01-01 19:10:08');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-05-03 15:33:01
