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

START TRANSACTION;



--
-- Database: `trultwik_testdb`
--

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

--
-- Table structure for table `admin_users`
--

CREATE TABLE `admin_users` (
  `id` int NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `role` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` varchar(19) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `updated_at` varchar(19) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin_users`
--

INSERT INTO `admin_users` (`id`, `email`, `password`, `role`, `created_at`, `updated_at`) VALUES
(1, 'admin@gmail.com', '$2y$10$o1f.cDn69gB/vLWZnAoriuqZ45O6GFbLIzRjvasjt7Uv5NDQVUNJu', 'Super_Admi', NULL, NULL),
(2, 'sakthicodedev@gmail.com', '$2y$10$xwQ8VxS7DAudnwKFhqkp7u6jSIik7.Mxi7cUaddbggIZ67MunpJl2', 'admin', '2024-07-26 12:01:15', '2024-07-26 12:01:15'),
(3, 'infintechstudio@gmail.com', '$2y$10$itvzKtu40M.YAPEXiasH5ebjQLa4CdiRflLi5NhtEIWPNwWclEaUG', 'admin', '2024-07-26 12:02:05', '2024-07-26 12:02:05');

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

--
-- Table structure for table `chapters`
--

CREATE TABLE `chapters` (
  `id` varchar(10) DEFAULT NULL,
  `title` varchar(10) DEFAULT NULL,
  `content` varchar(10) DEFAULT NULL,
  `trainingId` varchar(10) DEFAULT NULL,
  `videoPath` varchar(10) DEFAULT NULL,
  `createdAt` varchar(10) DEFAULT NULL,
  `updatedAt` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `feedback`
--

CREATE TABLE `feedback` (
  `id` int NOT NULL,
  `rating` varchar(200) NOT NULL,
  `description` varchar(500) NOT NULL,
  `userId` int NOT NULL,
  `createdAt` timestamp NOT NULL,
  `updatedAt` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `feedback`
--

INSERT INTO `feedback` (`id`, `rating`, `description`, `userId`, `createdAt`, `updatedAt`) VALUES
(1, '3', 'hi', 27, '2024-08-31 11:32:23', '2024-08-31 11:32:23'),
(2, '2', 'hi', 27, '2024-08-31 11:42:45', '2024-08-31 11:42:45'),
(3, '4', 'hi', 27, '2024-08-31 11:44:03', '2024-08-31 11:44:03'),
(4, '4', 'sample', 18, '2024-08-31 12:24:37', '2024-08-31 12:24:37'),
(5, '5', 'sak', 16, '2024-09-01 14:49:05', '2024-09-01 14:49:05');

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

--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `id` int NOT NULL,
  `name` varchar(25) DEFAULT NULL,
  `content` varchar(43) DEFAULT NULL,
  `type` varchar(8) DEFAULT NULL,
  `path` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `createdAt` varchar(19) DEFAULT NULL,
  `updatedAt` varchar(19) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `resources`
--

INSERT INTO `resources` (`id`, `name`, `content`, `type`, `path`, `createdAt`, `updatedAt`) VALUES
(6, 'EDII_TN Research Studies ', 'MSME Enterprises in Tamil Nadu Report - 201', 'Ebooks', 'ebooks/ebooka.pdf', '2024-09-02 00:15:07', NULL),
(7, 'EDII_TN Research Studies ', 'MSME Enterprises in Tamil Nadu Report - 201', 'Ebooks', 'ebooks/ebookb.pdf', '2024-09-02 00:16:13', NULL);

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

--
-- Table structure for table `trainings`
--

CREATE TABLE `trainings` (
  `id` int NOT NULL,
  `title` varchar(28) DEFAULT NULL,
  `description` varchar(240) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `code` varchar(7) DEFAULT NULL,
  `isCourse` int DEFAULT NULL,
  `mode` varchar(6) DEFAULT NULL,
  `rating` varchar(10) DEFAULT NULL,
  `start_date` varchar(19) DEFAULT NULL,
  `end_date` varchar(19) DEFAULT NULL,
  `fee_amount` int DEFAULT NULL,
  `is_fullTime` int DEFAULT NULL,
  `location` varchar(10) DEFAULT NULL,
  `mentorId` varchar(10) DEFAULT NULL,
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `trainings`
--

INSERT INTO `trainings` (`id`, `title`, `description`, `code`, `isCourse`, `mode`, `rating`, `start_date`, `end_date`, `fee_amount`, `is_fullTime`, `location`, `mentorId`, `createdAt`, `updatedAt`) VALUES
(1, 'Gold Appraiser Training', 'Resitor is the process of promoting, selling, and distributing a product or service.', 'RT-102', 1, 'online', '', '', '', 700, 0, 'Coimbatore', '1', '2024-09-01 19:40:35', '2024-09-01 19:40:35'),
(3, 'Basic Photography', 'Marketing is the process of promoting, selling, and distributing a product or service.', 'PT-0091', 1, 'online', '', '2024-07-01', '2024-07-31', 0, 0, 'Chennai', '1', '2024-09-01 19:44:23', '2024-09-01 19:44:23'),
(4, 'Herbal Cosmetics Products', 'Gold Training is the process of promoting, selling, and distributing a product or service.', 'GT-103', 1, 'online', '', '', '', 0, 0, 'Chennai', '3', '2024-09-01 19:42:33', '2024-09-01 19:42:33'),
(5, 'Industrial Chemical Products', 'Digital Marketing is the process of promoting, selling, and distributing a product or service.', 'MT-110', 1, 'online', '', '', '', 400, 0, 'Chennai', '3', '2024-09-01 19:41:09', '2024-09-01 19:41:09'),
(6, 'One Year Certificate Program', 'Entrepreneurship Development and Innovation Institute (EDII-TN) and Entrepreneurship Development Institute of India (EDII) are jointly dedicated in providing a transformative One Year Certificate Programme on Entrepreneurship and Innovation', 'PG09-01', 1, 'offlin', '', '', '', 80000, 1, 'Chennai', '1', '2024-09-01 22:29:04', '2024-09-01 22:29:04'),
(8, 'Youtube Channel Training', 'The YouTube Masterclass is a fast and effective course that takes you from zero skills to a complete YouTube channel with high quality videos, views, and subscribers.\r\n\r\nWhile there are plenty of YouTube courses that focus on specific aspec', 'YT101', 1, 'online', NULL, '2024-07-28', '2024-07-30', 1500, 1, 'Chennai', '1', '2024-09-01 19:39:28', '2024-09-01 19:39:28');

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

--
-- Table structure for table `userCourses`
--

CREATE TABLE `userCourses` (
  `id` int NOT NULL,
  `userId` int DEFAULT NULL,
  `trainingId` int DEFAULT NULL,
  `is_course_completed` int DEFAULT NULL,
  `is_certificate_generated` int DEFAULT NULL,
  `certificate_path` varchar(10) DEFAULT NULL,
  `is_payment_done` int DEFAULT NULL,
  `payment_id` varchar(10) DEFAULT NULL,
  `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `userCourses`
--

INSERT INTO `userCourses` (`id`, `userId`, `trainingId`, `is_course_completed`, `is_certificate_generated`, `certificate_path`, `is_payment_done`, `payment_id`, `createdAt`, `updatedAt`) VALUES
(1, 16, 4, 0, 0, '', 0, '', '2024-08-02 04:06:40', '2024-08-02 04:06:40'),
(2, 16, 4, 0, 0, '', 0, '', '2024-08-02 04:06:49', '2024-08-02 04:06:49'),
(3, 5, 6, 0, 0, '', 0, '', '2024-07-01 12:53:28', '2024-07-01 12:53:28'),
(4, 16, 6, 0, 0, '', 0, '', '2024-08-02 04:06:53', '2024-08-02 04:06:53'),
(5, 16, 6, 0, 0, '', 0, '', '2024-08-02 04:06:57', '2024-08-02 04:06:57');

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

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

CREATE TABLE `users` (
  `id` int NOT NULL,
  `name` varchar(12) DEFAULT NULL,
  `role` varchar(9) DEFAULT NULL,
  `email` varchar(32) DEFAULT NULL,
  `phonenumber` varchar(11) DEFAULT NULL,
  `password` varchar(60) DEFAULT NULL,
  `is_mentor` int DEFAULT NULL,
  `is_investor` int DEFAULT NULL,
  `is_entrepreneur` int DEFAULT NULL,
  `level` varchar(8) DEFAULT NULL,
  `location` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `contact_details` varchar(12) DEFAULT NULL,
  `qualification` varchar(17) DEFAULT NULL,
  `date_of_birth` varchar(10) DEFAULT NULL,
  `age` varchar(2) DEFAULT NULL,
  `gender` varchar(4) DEFAULT NULL,
  `permanent_address` varchar(5) DEFAULT NULL,
  `community` varchar(2) DEFAULT NULL,
  `religion` varchar(5) DEFAULT NULL,
  `differently_abled` int DEFAULT NULL,
  `name_of_university` varchar(35) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `name_of_degree` varchar(5) DEFAULT NULL,
  `year_of_completion` varchar(4) DEFAULT NULL,
  `percentage_of_marks` varchar(2) DEFAULT NULL,
  `father_name` varchar(7) DEFAULT NULL,
  `mother_name` varchar(5) DEFAULT NULL,
  `guardian_number` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `address_of_communication` varchar(7) DEFAULT NULL,
  `pincode` varchar(10) DEFAULT NULL,
  `one_time_password` varchar(4) DEFAULT NULL,
  `is_forgot_password` int DEFAULT NULL,
  `forgot_one_time_password` varchar(10) DEFAULT NULL,
  `is_otp_verified` int DEFAULT NULL,
  `profile_picture` varchar(10) DEFAULT NULL,
  `createdAt` varchar(19) DEFAULT NULL,
  `updatedAt` varchar(19) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `users` (`id`, `name`, `role`, `email`, `phonenumber`, `password`, `is_mentor`, `is_investor`, `is_entrepreneur`, `level`, `location`, `contact_details`, `qualification`, `date_of_birth`, `age`, `gender`, `permanent_address`, `community`, `religion`, `differently_abled`, `name_of_university`, `name_of_degree`, `year_of_completion`, `percentage_of_marks`, `father_name`, `mother_name`, `guardian_number`, `address_of_communication`, `pincode`, `one_time_password`, `is_forgot_password`, `forgot_one_time_password`, `is_otp_verified`, `profile_picture`, `createdAt`, `updatedAt`) VALUES
(1, 'John Doe', 'mentor', 'johndoe@example.com', '1234567890', 'hashed_password', 0, 0, 0, 'beginner', 'Nilgiris', '123-456-7890', 'B.A', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', 0, '', 0, '', '2024-06-06 15:05:25', '2024-06-06 15:05:25'),
(3, 'kavinesh', 'mentor', 'kavinesh@example.com', '1234567891', 'hashed_password', 0, 0, 0, 'beginner', 'Pudukkottai', '123-456-7890', 'B.Sc', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', 0, '', 0, '', '2024-06-06 19:58:15', '2024-06-06 19:58:15'),
(4, 'kavinesh', 'candidate', 'kavinesh301@gmail.com', '2222222223', '$2b$10$6klQMhhOvFLAfQAKYqWtnu/eBbHFfUvJYBAgTxlKqj2Fyz66rLFiy', 0, 0, 0, 'beginner', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '6070', 0, '', 0, '', '2024-06-07 01:27:03', '2024-06-07 01:27:03'),
(6, 'Ashwin', 'expert', 'aswin@gmail.com', '9867583048', 'praveen', 0, 0, 0, 'intermed', 'Madurai', 'email', 'B.Sc', '16/10/1999', '29', 'male', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 'Vinoth', 'investor', 'vinoth@gmail.com', '9485727595', 'vinoth', 0, 1, 0, 'intermed', 'Perambalur', 'email', 'B.Com', '08/07/1999', '26', 'male', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 'Vinoth', 'candidate', 'vinhello@gmail.com', '9952048535', '$2b$10$/xN8WKRXY28kGL2IqK3pTeOg47Es2jOhHp0syeUvQjTmC6C17X.8.', 0, 0, 0, 'beginner', 'Chennai', NULL, 'UG', '14/12/1998', '24', 'male', 'Thanj', 'SC', 'hindu', 0, 'Anna', 'B E', '2017', '87', 'Dummy', 'Dummy', '8.77e9', 'Chennai', NULL, '5343', 0, NULL, 0, NULL, '2024-07-28 15:33:37', '2024-07-29 15:29:30'),
(18, 'Santhosh', 'candidate', 'santhosh.azotos@gmail.com', '8610006836', '$2b$10$SYw/PoaCjhCVkCfr5sCkne43eYvaRCYzKdkJjGPJTqIjtk/AXbGGK', 0, 0, 0, 'beginner', 'Tiruchirapalli ', NULL, 'UG', '2003/07/06', '67', 'male', 'Snmsm', 'BC', 'hindu', 0, 'Udc', 'Bsc', '68', '57', 'Samoke', 'Smap', '67', 'Jjssjja', NULL, '1659', 0, NULL, 0, NULL, '2024-07-30 05:18:01', '2024-08-01 07:58:16'),
(19, 'ARUN', 'candidate', 'arun@gmail.com', '9585585108', '$2b$10$FKMLEOm8MdiZKOVk3ZXPceNKo5i.OeVGxshnXhdeFj.3SP2c5watm', 0, 0, 0, 'beginner', 'Trichy ', NULL, 'UG', '24112000', '24', 'male', 'Thiru', 'MB', 'hindu', 0, 'BDU', 'Udc', NULL, NULL, 'Ram', 'Para', NULL, 'Thiruve', NULL, '8713', 0, NULL, 0, NULL, '2024-07-30 06:41:13', '2024-07-30 06:45:33'),
(20, 'Ram', 'candidate', 'arunram@gmail.com', '9585585107', '$2b$10$oUmwzrrJ2mBjo66iX1fBpuF1ESHer6yNUdhs3XoEl1RvLN5xtqJie', 0, 0, 0, 'beginner', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9397', 0, NULL, 0, NULL, '2024-07-30 06:42:01', '2024-07-30 06:42:01'),
(21, 'Aanrhk', 'candidate', 'Snsnm@gmaol.xl', '0123456789', '$2b$10$mJFnIPcgHDlxH1U98x2Huu/cLqiwzEs3bgu2RZYgSEAJYkz81r7UO', 0, 0, 0, 'beginner', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8571', 0, NULL, 0, NULL, '2024-07-31 08:01:02', '2024-07-31 08:01:02'),
(22, 'venkatesh', 'candidate', 'venkatesh.azotos@gmail.com', '9876543210', '$2b$10$5PTKYAj0Kkf/ghRMaTOdbOG97.tPQt2Z2yjuVM9anXEqjPmlSLkoi', 0, 0, 0, 'beginner', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2849', 0, NULL, 0, NULL, '2024-07-31 08:20:56', '2024-07-31 08:20:56'),
(23, 'darwin', 'candidate', 'darwin.azotos@gmail.com', '9942952654', '$2b$10$1hyibqieowLExZZ.7bPIeuv6XUhg9EbfWDkTS1Mv9XSIhk0O43Ude', 0, 0, 0, 'beginner', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2822', 0, NULL, 0, NULL, '2024-07-31 15:30:19', '2024-07-31 15:30:19'),
(25, 'jerome', 'candidate', 'jerome.azotos@gmail.com', '9092586016', '$2b$10$xS0.aCp3x643569fi7kELurzSVYotk.QPHbXRj7Sy1tyMmcsi9QKK', 0, 0, 0, 'beginner', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2278', 0, NULL, 0, NULL, '2024-08-01 04:45:49', '2024-08-01 04:45:49'),
(26, 'Karthik ', 'candidate', 'mkvspace@gmail.com', '9841316211', '$2b$10$3Nfp/yf97JHBH13e43NqkO2.DynAT52TlHMfpeRKrPVPXA5La.PiS', 0, 0, 0, 'beginner', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2926', 0, NULL, 0, NULL, '2024-08-01 17:07:24', '2024-08-01 17:07:24'),
(27, 'jerome aushl', 'candidate', 'jerome.azotoz@gmail.com', '7010258874', '$2b$10$gMTwNYMYchmmxdxSuVppk.Idji7sNDnvUFAByC4nkm4UeBDTbT54W', 0, 0, 0, 'beginner', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '9750', 0, NULL, 0, NULL, '2024-08-29 09:42:06', '2024-08-29 09:42:06');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_users`
--
ALTER TABLE `admin_users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `feedback`
--
ALTER TABLE `feedback`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `resources`
--
ALTER TABLE `resources`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `trainings`
--
ALTER TABLE `trainings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `userCourses`
--
ALTER TABLE `userCourses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
COMMIT;

