(13,2,'[BLOB]','2023-08-07 05:42:28',NULL);

--
-- Table structure for table `group_tasks`
--

CREATE TABLE `group_tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `group_tasks`
--


--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `team_id` int(11) DEFAULT NULL,
  `approved_status` tinyint(4) DEFAULT 1,
  `approved_by` int(11) DEFAULT NULL,
  `is_read` tinyint(4) NOT NULL DEFAULT 0,
  `updated_record` longtext DEFAULT NULL,
  `update_image_url` varchar(500) DEFAULT NULL,
  `update_approved_status` tinyint(4) DEFAULT NULL,
  `deny_reason` text DEFAULT NULL,
  `deny_by_id` int(11) DEFAULT NULL,
  `is_image_converted` int(11) NOT NULL 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=19 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` VALUES
(2,'Vorstandschaft','<font size=\"2\"><font face=\"Arial\">Abstimmungen, News und Termine rund um die Vorstandschaft.<br></font></font>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/September/Images/Vorstandschaft.jpg',1,141,1,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-09-27 08:35:56','2023-08-07 05:42:28'),
(3,'weekend wibess','<font face=\"Arial\" size=\"2\">testing</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/September/Images/jan-sendereks.jpg',1,141,1,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-09-29 09:32:15','2023-08-07 05:42:28'),
(4,'LiveScore','<span>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque vehicula, lectus sed sollicitudin facilisis, mauris urna rutrum nisl, vel finibus urna sem consequat ipsum. Interdum et malesuada fames ac ante ipsum primis in faucibus. Nullam et ipsum nulla. Sed enim enim, tempor ac mauris sit amet, vulputate venenatis tellus. Suspendisse est mi, tincidunt non convallis et, rutrum at mi. Vestibulum ac ipsum sit amet dui pretium tristique. Phasellus sed interdum erat. In commodo lacus arcu, ut porta eros ultricies id. Ut elementum ipsum eget enim sollicitudin varius. Suspendisse gravida tortor elementum arcu dapibus condimentum.</span><br>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/November/Images/Image%20%286%29-1669098639117.png',1,141,1,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-10-11 06:40:10','2023-08-07 05:42:27'),
(6,'Walkie Talkies','<p><br></p><div><div><div></div></div></div><div class=\"boxed\"><div><p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Morbi quis elementum velit. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Phasellus sagittis justo id nisl mattis, vel auctor purus venenatis. Maecenas non aliquam augue. Donec sit amet risus iaculis, efficitur elit sed, congue nisi. Phasellus sem dui, consequat sit amet suscipit sed, porta vel mi. Aliquam dictum lacinia diam, eu laoreet justo congue eu. Phasellus venenatis tempor nulla. Proin volutpat dictum orci, id eleifend felis ornare eget. Vivamus porttitor scelerisque viverra. Phasellus aliquet justo quis imperdiet consectetur. Mauris vitae consectetur nulla, venenatis accumsan justo. Etiam lectus purus, fringilla imperdiet neque commodo, imperdiet auctor est. Cras pretium ligula ligula, eu posuere urna porttitor ut.</p><p><br></p></div></div>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/November/Images/626317.jpg',4,141,1,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-11-21 08:17:07','2023-08-07 05:42:27'),
(7,'Not Fast, Just Furious','<hr><div><div><div><div></div></div></div><div><div><div></div></div></div><div class=\"boxed\"><div><p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec nec quam vel arcu pellentesque faucibus vitae vel orci. Ut dictum elementum bibendum. Vivamus sed mollis metus, eget ornare ex. Phasellus vel quam eget orci pellentesque interdum. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Phasellus viverra sem nisl. Donec ultricies neque non ex suscipit cursus. Suspendisse pharetra vitae ligula eu consectetur. Curabitur metus tellus, molestie eget bibendum nec, tincidunt sit amet magna. Etiam vel est in libero dignissim porta. Nullam quis tellus malesuada, blandit magna sed, facilisis arcu. Nullam molestie interdum lacinia. Praesent eleifend eros vel risus commodo, vel dignissim elit fermentum. Curabitur eget rhoncus sem, eleifend posuere mauris.</p></div></div></div>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/November/Images/Rectangle%2017293.jpg',4,141,1,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-11-21 10:11:52','2023-08-07 05:42:27'),
(8,'FC Bayern München Fan Club Bavaria','<span>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque vehicula, lectus sed sollicitudin facilisis, mauris urna rutrum nisl, vel finibus urna sem consequat ipsum. Interdum et malesuada fames ac ante ipsum primis in faucibus. Nullam et ipsum nulla. Sed enim enim, tempor ac mauris sit amet, vulputate venenatis tellus. Suspendisse est mi, tincidunt non convallis et, rutrum at mi. Vestibulum ac ipsum sit amet dui pretium tristique. Phasellus sed interdum erat. In commodo lacus arcu, ut porta eros ultricies id. Ut elementum ipsum eget enim sollicitudin varius. Suspendisse gravida tortor elementum arcu dapibus condimentum.</span>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm_foto%202023-03-18%20um%2009.39.25.png',1,141,1,NULL,0,NULL,NULL,0,NULL,NULL,1,'2022-11-22 06:25:23','2023-08-07 05:42:27'),
(11,'Master Minds','<span>A mastermind is&#160;</span><b>a brilliant thinker with original ideas</b><span>. You might be a chess mastermind or a criminal mastermind: either way, people will not want to oppose you. Inventors, intellectuals, and famous geniuses call all be called masterminds, from Albert Einstein to theoretical physicist Dr. Shirley Jackson.</span>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/pexels-anete-lusina-4792503.jpg',8,141,1,1,1,NULL,NULL,0,NULL,NULL,1,'2023-03-17 06:52:31','2023-08-07 05:42:27'),
(12,'Desk Champions updated2 trdt','<ol><li>Desk Champions<font face=\"Arial\" size=\"2\">&#160;updated</font></li></ol>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/testtttttttttt.png',9,141,1,1,1,NULL,NULL,0,NULL,NULL,1,'2023-03-17 11:03:25','2023-08-07 05:41:54'),
(13,'Fußball 1. Mannschaft','<font face=\"Arial\" size=\"2\">Fu&#223;ball, Training Donnerstags ab 18 Uhr</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/S-Verein_01.jpeg',32,2830,1,NULL,0,NULL,NULL,0,NULL,NULL,1,'2023-03-20 09:23:55','2023-08-09 04:41:38'),
(14,'Tennis Damen','<font face=\"Arial\" size=\"2\">Tennis</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/tennis-damen.jpeg',32,2830,1,NULL,0,NULL,NULL,0,NULL,NULL,1,'2023-03-20 11:37:13','2023-08-07 05:41:53'),
(15,'The Nerd Herd','<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p><p><br></p>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/April/Images/pexels-cottonbro-studio-4709285.jpg',1,141,1,NULL,0,NULL,NULL,0,NULL,NULL,1,'2023-04-03 06:02:51','2023-08-07 05:41:53'),
(16,'AXA Makler - dWERK','<font face=\"Arial\" size=\"2\">Informationen f&#252;r AXA Makler &#252;ber dWERK</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/April/Documents/Bildschirmfoto%202023-04-24%20um%2018.46.38.png',33,2684,1,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2023-04-24 16:46:49','2023-08-07 05:41:53'),
(17,'AXA Makler','<font face=\"Arial\" size=\"2\">Launch der dWERK - Akademie f&#252;r Makler&#160;</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/May/Documents/Bildschirmfoto%202023-05-07%20um%2018.49.04.png',33,2684,1,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2023-05-07 16:54:09','2023-08-07 05:41:53');

--
-- Table structure for table `images_news`
--

CREATE TABLE `images_news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `images_news`
--


--
-- Table structure for table `instructor`
--

CREATE TABLE `instructor` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `team_id` int(11) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `emaill` varchar(255) DEFAULT NULL,
  `phone_no` varchar(20) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `courses_type` varchar(255) DEFAULT NULL,
  `add_img` text DEFAULT NULL,
  `author` varchar(155) DEFAULT NULL,
  `active_from` varchar(255) DEFAULT NULL,
  `active_to` varchar(255) DEFAULT NULL,
  `approved_status` tinyint(4) DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `updated_record` longtext DEFAULT NULL,
  `update_image_url` varchar(500) DEFAULT NULL,
  `update_approved_status` tinyint(4) DEFAULT NULL,
  `deny_reason` text DEFAULT NULL,
  `deny_by_id` int(11) DEFAULT NULL,
  `is_read` tinyint(4) DEFAULT 0,
  `is_image_converted` int(11) NOT NULL 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=29 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `instructor`
--

INSERT INTO `instructor` VALUES
(1,141,'Max','Maier','max@maier.de','0152413251','Musterstraße 45a, 73577 Musterdorf',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/September/Images/TrainerFussball-1664268484634.jpg',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-09-27 08:48:04','2023-06-21 10:09:13'),
(2,141,'Peter','Müller','peter@mueller.de','0151845873','Musterweg 66a, 34774 Musterstadt',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/September/Images/Fotograf-1664268710864.jpg',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-09-27 08:51:50','2023-06-21 10:09:13'),
(5,141,'pasangya1','tarun','tarun@mangoitsolutions.in','4565544563','indore',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/September/Images/ayo-ogunseinde-2-1664448999831.jpg',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-09-29 10:56:39','2023-06-21 10:09:13'),
(6,141,'jonthan','byerss','jonthanbyres@gmail.com','8976789871','indore',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/kaci-baum-2-1664873620340.jpg',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-10-04 08:53:40','2023-06-21 10:09:13'),
(7,141,'john','steves','john@gmail.com','8909876789','indore',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/joe-gardner-2-1664886447258.jpg',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-10-04 12:27:27','2023-06-21 10:09:13'),
(8,1690,'Aditya','Bhawsar','bhawsaraditya77@gmail.com','7987494050','test',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/download-1664950131560.jpg',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-10-05 06:08:51','2023-06-21 10:09:13'),
(9,1690,'Aditya','Bhawsar','bhawsaraditya88@gmail.com','7987494055','Test',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/download-1664950309805.jpg',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-10-05 06:11:49','2023-06-21 10:09:13'),
(10,141,'Johan','Clarek','clarek@mailinator.com','9876543100','test',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/clem-onojeghuo-2-1664953250360.jpg',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-10-05 07:00:50','2023-06-21 10:09:13'),
(11,141,'dustin','Henderson','dustin12@mailinator.com','8765678987','indore',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/clem-onojeghuo-4-1665045442132.jpg',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-10-06 08:37:22','2023-06-21 10:09:13'),
(12,1690,'jim','hopper','jim@mailinator.com','4543233232','indore',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/kaci-baum-2-1665047425667.jpg',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-10-06 09:10:25','2023-06-21 10:09:13'),
(13,141,'Smith','John','smith@mailinator.com','9988665544','Indore',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/logo-1666329793275.png',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-10-21 05:23:13','2023-06-21 10:09:13'),
(14,141,'willam','john','willam@mailinator.com','8899665321','test',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/logo-1666330077521.png',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-10-21 05:27:57','2023-06-21 10:09:13'),
(15,141,'sandy','sandy','sandy@yopmail.com','9966553245','indore',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/logo-1666339122513.png',NULL,'2023-06-21','2024-06-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-10-21 07:58:42','2023-06-21 10:09:13'),
(16,141,'Sam','Karun','sam@mailinator.com','5458451526','berlin',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/November/Images/mike-1669027667114.jpg','1','2023-06-21','2024-06-21',1,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-11-21 10:47:47','2023-06-21 10:09:13'),
(17,141,'Christinea','Dunnn','christine@mailinator.com','8545251220','724 Logan Lane Westminster',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/January/Images/joe-gardner-2-1674823505193.jpg','8','2023-06-21','2024-06-21',1,1,NULL,NULL,1,NULL,NULL,1,0,'2023-01-27 12:45:05','2023-06-21 10:09:13'),
(19,141,'Frederick','Douglass','Douglass@mailinator.com','8965784526','A B street',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/February/Images/clem-onojeghuo-2-1677066977253.jpg','1','2023-06-21','2024-06-21',1,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2023-02-22 11:56:17','2023-06-21 10:09:13'),
(20,141,'Friedrich','Froebel','Froebel@mailinator.com','9865452365','A B road',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm_foto%202023-03-18%20um%2009-1679473387245.39.46.png','9','2023-06-21','2024-06-21',1,1,NULL,NULL,0,NULL,NULL,1,0,'2023-02-22 11:59:58','2023-06-21 10:09:13'),
(22,141,'Conny','Schaich','conny@mailinator.com','9856324170','India',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/pexels-rodnae-productions-5778264-1679030090321.jpg','8','2023-06-21','2024-06-21',1,1,NULL,NULL,0,NULL,NULL,0,0,'2023-03-17 05:14:52','2023-06-21 10:09:13'),
(23,2830,'Externer','Trainer','externer.trainer@yopmail.com','0157777777','Musterstraße 3, Musterhausen',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009-1679304261591.39.46.png','32','2023-06-21','2024-06-21',1,NULL,NULL,NULL,0,NULL,NULL,0,1,'2023-03-20 08:07:50','2023-08-04 17:49:34'),
(25,141,'Christan','McAuliffe','McAuliffe@mailinator.com','9988653623','M.G road',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/April/Images/ayo-ogunseinde-2-1681819384186.jpg','1','2023-06-09','2024-06-09',1,NULL,NULL,NULL,0,NULL,NULL,0,1,'2023-04-18 12:03:08','2023-08-04 17:49:33'),
(26,141,'Carlo','Gambino','carlo.gambina@mailinator.com','9753124680','001, New York, USA',NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/pexels-beyzaa-yurtkuran-15976700-1686546525645.jpg','1','2023-06-12','2024-12-30',1,NULL,NULL,NULL,NULL,NULL,NULL,0,1,'2023-06-12 05:08:45','2023-08-04 17:49:33');

--
-- Table structure for table `instructor_availablity`
--

CREATE TABLE `instructor_availablity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `instructor_id` int(11) NOT NULL,
  `weekday` varchar(255) DEFAULT NULL,
  `time_from` time DEFAULT NULL,
  `time_to` time DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `instructor_availablity`
--

INSERT INTO `instructor_availablity` VALUES
(1,1,'Donnerstag','15:00:00','22:00:00','2022-09-27 08:48:04','2022-09-27 08:48:04'),
(2,2,'D','17:00:00','22:00:00','2022-09-27 08:51:50','2022-09-27 08:51:50'),
(3,2,'D','17:00:00','22:00:00','2022-09-27 08:51:50','2022-09-27 08:51:50'),
(7,5,'Friday','19:24:00','20:24:00','2022-09-29 10:56:39','2022-09-29 10:56:39'),
(9,6,'Tuesday','16:22:00','18:22:00','2022-10-04 09:29:31','2022-10-04 09:29:31'),
(11,8,'Monday','12:00:00','14:00:00','2022-10-05 06:08:51','2022-10-05 06:08:51'),
(12,9,'T','12:00:00','16:00:00','2022-10-05 06:11:49','2022-10-05 06:11:49'),
(13,7,'Donnerstag','18:57:00','20:57:00','2022-10-05 06:59:06','2022-10-05 06:59:06'),
(14,10,'Monday','12:30:00','15:30:00','2022-10-05 07:00:50','2022-10-05 07:00:50'),
(15,11,'Monday','15:06:00','17:06:00','2022-10-06 08:37:22','2022-10-06 08:37:22'),
(16,12,'Monday','15:39:00','18:40:00','2022-10-06 09:10:25','2022-10-06 09:10:25'),
(20,13,'Tuesday','11:53:00','13:55:00','2022-10-21 05:26:33','2022-10-21 05:26:33'),
(21,13,'Wednesday','00:55:00','14:57:00','2022-10-21 05:26:33','2022-10-21 05:26:33'),
(22,14,'Monday','11:00:00','16:00:00','2022-10-21 05:27:57','2022-10-21 05:27:57'),
(23,15,'Tuesday','13:28:00','15:28:00','2022-10-21 07:58:42','2022-10-21 07:58:42'),
(24,16,'Monday','16:15:00','22:21:00','2022-11-21 10:47:47','2022-11-21 10:47:47'),
(28,19,'Monday','17:26:00','18:26:00','2023-02-22 11:56:17','2023-02-22 11:56:17'),
(31,17,'Wednesday','19:00:00','20:00:00','2023-02-28 08:37:11','2023-02-28 08:37:11'),
(35,22,'Monday','12:00:00','19:20:00','2023-03-17 05:14:52','2023-03-17 05:14:52'),
(37,23,'Donnerstag','18:00:00','21:00:00','2023-03-20 09:24:21','2023-03-20 09:24:21'),
(39,20,'Monday','17:29:00','19:29:00','2023-03-22 08:23:09','2023-03-22 08:23:09'),
(46,26,'Saturday','11:00:00','21:45:00','2023-06-12 05:08:45','2023-06-12 05:08:45'),
(47,26,'Sunday','12:00:00','22:15:00','2023-06-12 05:08:45','2023-06-12 05:08:45'),
(48,25,'Monday','10:00:00','15:00:00','2023-07-06 05:36:15','2023-07-06 05:36:15');

--
-- Table structure for table `instructor_booking`
--

CREATE TABLE `instructor_booking` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ex_instructor_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `date_from` varchar(255) NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `instructor_booking`
--

INSERT INTO `instructor_booking` VALUES
(1,26,29,'2024-01-06','14:00:00','18:30:00'),
(2,26,29,'2024-01-13','14:00:00','18:30:00'),
(3,26,29,'2024-01-20','14:00:00','18:30:00'),
(4,26,29,'2024-01-27','14:00:00','18:30:00'),
(5,26,29,'2024-02-03','14:00:00','18:30:00'),
(6,26,29,'2024-02-10','14:00:00','18:30:00'),
(7,26,29,'2024-02-17','14:00:00','18:30:00'),
(8,26,29,'2024-02-24','14:00:00','18:30:00'),
(9,26,29,'2024-03-02','14:00:00','18:30:00'),
(10,26,29,'2024-03-09','14:00:00','18:30:00'),
(11,26,29,'2024-03-16','14:00:00','18:30:00'),
(12,26,29,'2024-03-23','14:00:00','18:30:00');

--
-- Table structure for table `instructor_email`
--

CREATE TABLE `instructor_email` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `send_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `receiver_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `sender_email` varchar(255) DEFAULT NULL,
  `receiver_email` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `instructor_email`
--


--
-- Table structure for table `instructor_image`
--

CREATE TABLE `instructor_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `instructor_id` int(11) NOT NULL,
  `instructor_image` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `instructor_image`
--

INSERT INTO `instructor_image` VALUES
(1,26,'[BLOB]','2023-08-04 17:49:33',NULL),
(2,25,'[BLOB]','2023-08-04 17:49:33',NULL),
(3,23,'[BLOB]','2023-08-04 17:49:34',NULL);

--
