[BLOB]','2023-08-07 05:43:32',NULL);

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `room_type` varchar(255) NOT NULL,
  `no_of_persons` int(11) DEFAULT NULL,
  `price` varchar(255) DEFAULT NULL,
  `active_from` varchar(255) DEFAULT NULL,
  `active_to` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  `team_id` int(11) DEFAULT NULL,
  `author` varchar(155) DEFAULT NULL,
  `approved_status` tinyint(4) DEFAULT NULL,
  `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=23 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` VALUES
(1,'Vereinsraum 01','Tagungsraum',50,NULL,'2023-06-21','2024-06-21','Vereinsraum f&#252;r jegliche Vereinsveranstaltungen.<br>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/September/Images/Meeting.jpg',141,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-09-27 08:46:26','2023-08-07 05:43:32'),
(2,'hotel room mashal','delux',10,NULL,'2023-06-21','2024-06-21','<font face=\"Arial\" size=\"2\">testing</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/September/Images/clem-onojeghuo-4.jpg',141,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-09-29 09:38:54','2023-08-07 05:43:31'),
(3,'badroom','master',2,NULL,'2023-06-21','2024-06-21','<font face=\"Arial\" size=\"2\">testing</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/jan-sendereks.jpg',141,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-10-04 09:37:40','2023-08-07 05:43:31'),
(4,'Room 1','Test',1,NULL,'2023-06-21','2024-06-21','<font face=\"Arial\" size=\"2\">AXS</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/download.jpg',1690,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-10-05 06:15:42','2023-08-07 05:43:31'),
(5,'meyar ','hall',15,NULL,'2023-06-21','2024-06-21','<font face=\"Arial\" size=\"2\">tesitng</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/ayo-ogunseinde-2.jpg',1690,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-10-06 09:11:37','2023-08-07 05:43:31'),
(6,'Delux Room','Delux',2,NULL,'2023-06-21','2024-06-21','<font face=\"Arial\" size=\"2\">test</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/Social.jpg.webp',141,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2022-10-21 05:25:31','2023-08-07 05:43:31'),
(7,'Meeting room','meet',50,NULL,'2023-06-09','2024-07-12','<span>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed efficitur sem id efficitur aliquam. Morbi suscipit sapien eu diam feugiat ullamcorper. Sed molestie diam quis dui venenatis, eget scelerisque est rhoncus. Maecenas placerat diam ligula, at luctus mauris dapibus eget. Nulla facilisi. Curabitur fermentum vel odio ac condimentum. Praesent ullamcorper feugiat nisl, at tincidunt risus aliquam ut. Maecenas vel velit placerat justo placerat pellentesque. Donec a sodales urna, ac interdum sapien. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis in fermentum nunc, non ullamcorper diam. Praesent posuere dui facilisis purus tempus lacinia.</span>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/November/Images/Rectangle%2017293.jpg',141,'1',1,NULL,0,NULL,NULL,1,NULL,NULL,1,'2022-11-21 11:20:36','2023-08-07 05:43:31'),
(8,'Test Room','Test',5,NULL,'2023-06-09','2024-06-09','<span>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed efficitur sem id efficitur aliquam. Morbi suscipit sapien eu diam feugiat ullamcorper. Sed molestie diam quis dui venenatis, eget scelerisque est rhoncus. Maecenas placerat diam ligula, at luctus mauris dapibus eget. Nulla facilisi. Curabitur fermentum vel odio ac condimentum. Praesent ullamcorper feugiat nisl, at tincidunt risus aliquam ut. Maecenas vel velit placerat justo placerat pellentesque. Donec a sodales urna, ac interdum sapien. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis in fermentum nunc, non ullamcorper diam. Praesent posuere dui facilisis purus tempus lacinia.</span>','https://minio.staging.verein.cloud/tineon/Leipzig/2022/November/Images/index1.jpeg',141,'1',1,NULL,0,NULL,NULL,1,NULL,NULL,1,'2022-11-21 11:23:49','2023-08-07 05:43:31'),
(10,'Mango IT Room','Simple  Metting Room',10,NULL,'2023-06-09','2024-07-09','<p>Lorem ipsum dolor sit amet. A omnis natus vel pariatur cumque et vero reprehenderit. Vel similique enim non harum fugit et fuga magnam. Eum quaerat eveniet aut eveniet tenetur ut blanditiis nulla hic voluptatem aliquid est incidunt ullam est neque voluptatum.</p><p>Cum pariatur quod et iure tempore qui minus deserunt sed sint tempora rem natus enim et omnis accusantium. Et voluptatibus magni ut dolorem molestiae ut placeat porro rem dolore impedit! Aut voluptatem omnis a ullam labore id dolores iure 33 omnis alias!</p>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/February/Images/christopher-gower-m_HRfLhgABo-unsplash.jpg',141,'1',1,NULL,0,NULL,NULL,1,NULL,NULL,1,'2023-02-16 12:49:38','2023-08-07 05:43:31'),
(11,'Aviation Simulation ','Aviation Room',3,NULL,'2023-06-09','2024-06-09','<span>The cockpit is&#160;</span><b>the part of the aircraft that offers visibility to the front and sides, and houses the pilot(s) and other crew members</b><span>, for example in older passenger airliners with a flight crew of three, or in military aircraft performing missions that require different tasks to be carried out in the cockpit.</span>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/pexels-captsopon-3469825.jpg',141,'8',1,1,0,NULL,NULL,1,NULL,NULL,1,'2023-03-17 05:04:19','2023-08-07 05:43:30'),
(13,'Red flag','Football',12,NULL,'2023-06-09','2024-06-05','Music Room','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm_foto%202023-03-18%20um%2009.37.56.png',141,'9',1,1,0,NULL,NULL,1,NULL,NULL,1,'2023-03-17 06:28:38','2023-08-07 05:42:43'),
(14,'Rasenplatz','Fußballplatz',50,NULL,'2023-06-21','2024-06-21','<font face=\"Arial\" size=\"2\">Hybridrasen</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009.38.06.png',2830,'32',1,NULL,0,NULL,NULL,1,NULL,NULL,1,'2023-03-20 08:08:53','2023-08-07 05:42:43'),
(15,'Tennisplatz','Tennis',10,NULL,'2023-06-21','2024-06-21','<font face=\"Arial\" size=\"2\">Tennisplatz</font>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/Tennis.jpeg',2830,'32',1,NULL,0,NULL,NULL,1,NULL,NULL,1,'2023-03-20 08:18:29','2023-08-07 05:42:43'),
(16,'MangoIt Meeting Room','Ac Room',20,NULL,'2023-06-21','2024-06-21','<span>Qui dicta illum qui mollitia molestiae aut quam incidunt ut dolore sunt qui veritatis aliquid? Et soluta explicabo aut dignissimos dolor qui obcaecati earum aut laboriosam cumque et voluptatem commodi.</span>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/news-sm-3.png',2810,'30',1,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2023-03-23 04:19:26','2023-08-07 05:42:42'),
(17,'OTT','Surgery Room',9,NULL,'2023-06-09','2024-01-31','<span>An operating theater (also known as an operating room (OR), operating suite, or operation suite) is&#160;</span><b>a facility within a hospital where surgical operations are carried out in an aseptic environment</b>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/April/Images/pexels-anna-shvets-6291070.jpg',141,'1',1,NULL,0,NULL,NULL,1,NULL,NULL,1,'2023-04-03 05:22:31','2023-08-07 05:42:42'),
(18,'OT@2','Hospital room',50,NULL,'2023-06-09','2023-06-30','<p>It is a long established fact that a reader will be distracted by the&#10; readable content of a page when looking at its layout. The point of &#10;using Lorem Ipsum is that it has a more-or-less normal distribution of &#10;letters, as opposed to using \'Content here, content here\', making it &#10;look like readable English. Many desktop publishing packages and web &#10;page editors now use Lorem Ipsum as their default model text, and a &#10;search for \'lorem ipsum\' will uncover many web sites still in their &#10;infancy. Various versions have evolved over the years, sometimes by &#10;accident, sometimes on purpose (injected humour and the like).</p>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/pexels-anna-shvets-6291070.jpg',141,'1',1,NULL,0,NULL,NULL,1,NULL,NULL,1,'2023-06-09 05:29:23','2023-08-07 05:42:42'),
(20,'Car show','Open ground',1000,NULL,'2023-06-15','2024-12-31','<p>An&#160;<b>auto show</b>, also known as a&#160;<b>motor show</b>&#160;or&#160;<b>car show</b>, is a public exhibition of current&#160;<a href=\"https://en.wikipedia.org/wiki/Automobile\" class=\"mw-redirect\" title=\"Automobile\">automobile</a>&#160;models, debuts,&#160;<a href=\"https://en.wikipedia.org/wiki/Concept_car\" title=\"Concept car\">concept cars</a>, or out-of-production classics. It is attended by&#160;<a href=\"https://en.wikipedia.org/wiki/Automotive_industry\" title=\"Automotive industry\">automotive industry</a>&#160;representatives, dealers, auto journalists and car enthusiasts. Most auto shows occur once or twice a year. They are important to car manufacturers and local dealers as a public relations exercise, as they advertise new products and promote auto brands. The five most prestigious auto shows, sometimes called the &#34;<b>Big Five</b>&#34;, are generally considered to be held in&#160;<a href=\"https://en.wikipedia.org/wiki/International_Motor_Show_Germany\" title=\"International Motor Show Germany\">Frankfurt</a>,&#160;<a href=\"https://en.wikipedia.org/wiki/Geneva_Motor_Show\" class=\"mw-redirect\" title=\"Geneva Motor Show\">Geneva</a>,&#160;<a href=\"https://en.wikipedia.org/wiki/North_American_International_Auto_Show\" title=\"North American International Auto Show\">Detroit</a>,&#160;<a href=\"https://en.wikipedia.org/wiki/Paris_Motor_Show\" title=\"Paris Motor Show\">Paris</a>&#160;and&#160;<a href=\"https://en.wikipedia.org/wiki/Tokyo_Motor_Show\" title=\"Tokyo Motor Show\">Tokyo</a>.<sup class=\"reference\"><a href=\"https://en.wikipedia.org/wiki/Auto_show#cite_note-1\">[1]</a></sup>&#160;Car enthusiast communities along the historic&#160;<a href=\"https://en.wikipedia.org/wiki/U.S._Route_66\" title=\"U.S. Route 66\">U.S. Route 66</a>&#160;are credited with general popularization of car meets, including ethnic groups such as the&#160;<a href=\"https://en.wikipedia.org/wiki/Hispanos_of_New_Mexico\" title=\"Hispanos of New Mexico\">Hispanos of New Mexico</a>,<sup class=\"reference\"><a href=\"https://en.wikipedia.org/wiki/Auto_show#cite_note-Usner_2016_p.-2\">[2]</a></sup>&#160;<a href=\"https://en.wikipedia.org/wiki/Chicano\" title=\"Chicano\">Chicanos</a>,<sup class=\"reference\"><a href=\"https://en.wikipedia.org/wiki/Auto_show#cite_note-Tatum_2011_p.-3\">[3]</a></sup>&#160;and&#160;<a href=\"https://en.wikipedia.org/wiki/Mexican-Americans\" class=\"mw-redirect\" title=\"Mexican-Americans\">Mexican-Americans</a>&#160;of the&#160;<a href=\"https://en.wikipedia.org/wiki/Southwestern_United_States\" title=\"Southwestern United States\">Southwestern United States</a>;<sup class=\"reference\"><a href=\"https://en.wikipedia.org/wiki/Auto_show#cite_note-Carpio_2019_p._1-4\">[4]</a></sup>&#160;<a href=\"https://en.wikipedia.org/wiki/Lowrider\" title=\"Lowrider\">lowrider</a>,&#160;<a href=\"https://en.wikipedia.org/wiki/High_technology\" class=\"mw-redirect\" title=\"High technology\">high technology</a>,<sup class=\"reference\"><a href=\"https://en.wikipedia.org/wiki/Auto_show#cite_note-GeekWire_2020-5\">[5]</a></sup>&#160;<a href=\"https://en.wikipedia.org/wiki/Electric_vehicle\" title=\"Electric vehicle\">electric vehicle</a>,<sup class=\"reference\"><a href=\"https://en.wikipedia.org/wiki/Auto_show#cite_note-San_Francisco_Auto_Show_2019-6\">[6]</a></sup>&#160;and other enthusiast show, are popular in&#160;<a href=\"https://en.wikipedia.org/wiki/Los_Angeles\" title=\"Los Angeles\">Los Angeles</a>,&#160;<a href=\"https://en.wikipedia.org/wiki/Las_Vegas\" title=\"Las Vegas\">Las Vegas</a>,&#160;<a href=\"https://en.wikipedia.org/wiki/Albuquerque\" class=\"mw-redirect\" title=\"Albuquerque\">Albuquerque</a>,&#160;<a href=\"https://en.wikipedia.org/wiki/San_Francisco\" title=\"San Francisco\">San Francisco</a>, and&#160;<a href=\"https://en.wikipedia.org/wiki/Chicago\" title=\"Chicago\">Chicago</a>&#160;for this reason.<sup class=\"reference\"><a href=\"https://en.wikipedia.org/wiki/Auto_show#cite_note-Low_Rider_1999_p.-7\">[7]</a></sup><sup class=\"reference\"><a href=\"https://en.wikipedia.org/wiki/Auto_show#cite_note-Chappell_2012_p.-8\">[8]</a></sup></p><p>Some auto shows show besides cars all sorts of other vehicles. The types of vehicles can include&#160;<a href=\"https://en.wikipedia.org/wiki/Bus\" title=\"Bus\">buses</a>,&#160;<a href=\"https://en.wikipedia.org/wiki/Truck\" title=\"Truck\">trucks</a>&#160;and all other types of vehicles such as&#160;<a href=\"https://en.wikipedia.org/wiki/Auto_Expo\" title=\"Auto Expo\">Auto Expo</a>&#160;in Delhi brings a variety of vehicles ranging from private to commercial.</p>','https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/pexels-jose-mueses-1280560.jpg',141,'1',1,NULL,0,NULL,NULL,NULL,NULL,NULL,1,'2023-06-12 05:00:52','2023-08-07 05:42:42');

--
-- Table structure for table `rooms_availablity`
--

CREATE TABLE `rooms_availablity` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL,
  `weekday` varchar(255) NOT 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=80 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `rooms_availablity`
--

INSERT INTO `rooms_availablity` VALUES
(1,3,'T','16:06:00','19:07:00','2022-10-04 09:37:40','2022-10-04 09:37:40'),
(2,4,'M','12:00:00','12:59:00','2022-10-05 06:15:42','2022-10-05 06:15:42'),
(3,5,'Thursday','15:41:00','17:41:00','2022-10-06 09:11:37','2022-10-06 09:11:37'),
(7,6,'Tuesday','00:57:00','15:00:00','2022-10-21 05:31:50','2022-10-21 05:31:50'),
(8,6,'Wednesday','15:00:00','22:18:00','2022-10-21 05:31:50','2022-10-21 05:31:50'),
(35,16,'Monday','13:00:00','15:00:00','2023-03-23 04:19:26','2023-03-23 04:19:26'),
(45,11,'Monday','21:00:00','23:30:00','2023-06-09 04:43:17','2023-06-09 04:43:17'),
(46,13,'Monday','11:57:00','13:59:00','2023-06-09 04:44:47','2023-06-09 04:44:47'),
(47,10,'Monday','15:00:00','18:00:00','2023-06-09 04:45:30','2023-06-09 04:45:30'),
(48,10,'Wednesday','15:00:00','19:00:00','2023-06-09 04:45:30','2023-06-09 04:45:30'),
(49,10,'Friday','15:00:00','19:00:00','2023-06-09 04:45:30','2023-06-09 04:45:30'),
(55,7,'Monday','16:50:00','18:50:00','2023-06-09 04:47:11','2023-06-09 04:47:11'),
(56,17,'Monday','15:00:00','19:00:00','2023-06-09 04:53:28','2023-06-09 04:53:28'),
(57,17,'Wednesday','14:00:00','19:00:00','2023-06-09 04:53:28','2023-06-09 04:53:28'),
(58,17,'Friday','13:00:00','18:00:00','2023-06-09 04:53:28','2023-06-09 04:53:28'),
(60,18,'Montag','12:00:00','21:00:00','2023-06-09 05:30:20','2023-06-09 05:30:20'),
(62,8,'Tuesday','18:53:00','21:53:00','2023-06-09 08:47:11','2023-06-09 08:47:11'),
(63,8,'Monday','16:53:00','16:56:00','2023-06-09 08:47:11','2023-06-09 08:47:11'),
(64,20,'Saturday','11:00:00','21:45:00','2023-06-12 05:00:52','2023-06-12 05:00:52'),
(65,20,'Sunday','12:00:00','22:00:00','2023-06-12 05:00:52','2023-06-12 05:00:52'),
(66,14,'Donnerstag','18:00:00','21:00:00','2023-06-21 09:52:39','2023-06-21 09:52:39'),
(67,15,'Dienstag','17:00:00','19:00:00','2023-06-21 09:53:46','2023-06-21 09:53:46');

--
-- Table structure for table `subtask_group`
--

CREATE TABLE `subtask_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `assigned_to` longtext DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `subtask_group`
--

INSERT INTO `subtask_group` VALUES
(1,7,'test task 22 nov 01','<font face=\"Arial\" size=\"2\">test task 22 nov</font>','7',1,'2022-11-25'),
(2,7,'test task 22 nov 03','<font face=\"Arial\" size=\"2\">Vtest task 22 nov</font>','6',0,'2022-11-24'),
(3,8,'Test Task123 1','<font face=\"Arial\" size=\"2\">Test Task123</font>','7',1,'2022-11-30'),
(4,8,'Test Task123 2','<font face=\"Arial\" size=\"2\">Test Task123</font>','7',0,'2022-12-03'),
(5,10,'test task todo1','<font face=\"Arial\" size=\"2\">testing</font>','9',1,'2022-12-08'),
(7,19,'Write in detail','<span>Gratitude is one of many positive emotions. It\'s about&#160;</span><b>focusing on what\'s good in our lives and being thankful for the things we have</b><span>. Gratitude is pausing to notice and appreciate the things that we often take for granted, like having a place to live, food, clean water, friends, family, even computer access.</span>','[{\"user_id\":6,\"approved_status\":1}]',1,'2023-03-26'),
(9,24,'sub task 01','<font face=\"Arial\" size=\"2\">Just testing</font>','[{\"user_id\":9,\"approved_status\":1},{\"user_id\":8,\"approved_status\":1},{\"user_id\":7,\"approved_status\":1}]',1,'2023-04-05'),
(10,14,'Testaufgabe','<font face=\"Arial\" size=\"2\">Neue Unteraufgabe hinzuf&#252;gen</font>','[{\"user_id\":9,\"approved_status\":1}]',0,'2023-03-27');

--
-- Table structure for table `subtask_group_user`
--

CREATE TABLE `subtask_group_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `subtask_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `approved_status` int(11) DEFAULT NULL,
  `read_status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `subtask_group_user`
--

INSERT INTO `subtask_group_user` VALUES
(1,7,6,1,1),
(5,9,9,1,0),
(6,9,8,1,0),
(7,9,7,1,0),
(8,10,9,1,0);

--
-- Table structure for table `survey`
--

CREATE TABLE `survey` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `surveyOption` enum('0','1') DEFAULT NULL,
  `surveyType` varchar(20) DEFAULT NULL,
  `surveyStartDate` datetime DEFAULT NULL,
  `surveyEndDate` datetime DEFAULT NULL,
  `surveyViewOption` enum('0','1','2','') DEFAULT NULL,
  `additional_anonymous_voting` varchar(10) DEFAULT NULL,
  `additional_cast_vote` varchar(10) DEFAULT NULL,
  `surveyNotificationOption` varchar(45) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `team_id` int(11) DEFAULT NULL,
  `survey_status` int(11) DEFAULT 0,
  `approved_status` tinyint(4) DEFAULT NULL,
  `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,
  `image` varchar(500) 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=23 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `survey`
--

INSERT INTO `survey` VALUES
(1,'Austragungsort des Vereinsfest','<p><font size=\"2\"><font face=\"Arial\">Wo soll unser diesj&#228;hriges Vereinsfest statt finden?</font></font></p><p><font size=\"2\"><font face=\"Arial\"><br></font></font></p>','0','all_club','2022-09-27 00:00:00','2022-09-30 00:00:00','0','false','false','[\"2\",\"1\"]',1,141,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-09-27 09:03:24','2022-09-27 09:03:24'),
(2,'football survey 22','<font face=\"Arial\" size=\"2\">testing</font>','1','all_club','2022-10-13 00:00:00','2022-11-30 00:00:00','0','false','true','[\"2\"]',1,141,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-09-29 10:03:28','2022-09-29 10:03:28'),
(3,'TT survey 22','<font face=\"Arial\" size=\"2\">testing</font>','1','all_club','2022-10-14 00:00:00','2022-10-31 00:00:00','0','false','true','[\"2\"]',1,141,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-10-04 09:01:16','2022-10-04 09:01:16'),
(5,'test feedback survey','<font face=\"Arial\" size=\"2\">testing</font>','1','all_club','2022-10-15 00:00:00','2022-10-30 00:00:00','0','false','true','[\"2\",\"1\"]',3,1690,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-10-06 10:22:15','2022-10-06 10:22:15'),
(8,'Test Survey123','<font face=\"Arial\" size=\"2\">Test Survey123</font>','0','all_club','2022-11-16 00:00:00','2022-11-30 00:00:00','0','false','true','[\"1\"]',1,141,0,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-11-16 13:38:44','2022-11-16 13:38:44'),
(9,'Customer satisfaction survey','<span>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed efficitur sem id efficitur aliquam. Morbi suscipit sapien eu diam feugiat ullamcorper. Sed molestie diam quis dui venenatis, eget scelerisque est rhoncus. Maecenas placerat diam ligula, at luctus mauris dapibus eget. Nulla facilisi. Curabitur fermentum vel odio ac condimentum. Praesent ullamcorper feugiat nisl, at tincidunt risus aliquam ut. Maecenas vel velit placerat justo placerat pellentesque. Donec a sodales urna, ac interdum sapien. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis in fermentum nunc, non ullamcorper diam. Praesent posuere dui facilisis purus tempus lacinia.</span>','0','all_club','2022-11-21 00:00:00','2022-12-31 00:00:00','0','true','true','[\"1\"]',1,141,0,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-11-21 11:28:02','2022-11-21 11:28:02'),
(10,'test1234','<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>','0','all_club','2022-11-21 00:00:00','2023-03-17 00:00:00','0','true','true','[\"1\"]',4,141,0,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'2022-11-21 13:17:37','2022-11-21 13:17:37'),
(11,'Test','<font size=\"2\"><font face=\"Arial\">Test</font></font>','0','all_club','2023-01-27 00:00:00','2023-01-28 00:00:00','0','false','false','[\"2\"]',1,141,0,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'2023-01-27 12:56:07','2023-01-27 12:56:07'),
(12,'Best Olympic swimmer','<span>This article is within the scope of&#160;</span><b><a href=\"https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Swimming\" title=\"Wikipedia:WikiProject Swimming\">WikiProject Swimming</a></b><span>, a collaborative effort to improve the coverage of&#160;</span><a href=\"https://en.wikipedia.org/wiki/Swimming_(sport)\" title=\"Swimming (sport)\">Swimming</a><span>&#160;on Wikipedia. If you would like to participate, please visit the project page, where you can join&#160;</span><a href=\"https://en.wikipedia.org/wiki/Wikipedia_talk:WikiProject_Swimming\" title=\"Wikipedia talk:WikiProject Swimming\">the discussion</a><span>&#160;and see a list of open tasks.</span>','0','all_club','2023-02-10 00:00:00','2023-02-12 00:00:00','0','false','false','[]',1,141,0,1,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/February/Images/pexels-pixabay-236937.jpg',1,'2023-02-10 07:19:49','2023-08-07 05:02:27'),
(13,'Testumfrage ','<font face=\"Arial\" size=\"7\">sjfhakdshfjadhsfkjhaskdjfhkjas<br><br>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et </font><font face=\"Arial\"><font size=\"5\">justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.&#160;</font><br></font>','1','group','2023-03-16 00:00:00','2023-03-28 00:00:00','1','true','false','[\"1\"]',1,141,0,1,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/colin-carter-w1g2o4J_4Dg-unsplash.jpg',1,'2023-03-15 08:27:45','2023-08-07 05:02:26'),
(14,' Employee satisfaction survey updated','<span>This type of survey method is used to gauge whether employees are happy and satisfied with their work environment. Positive results in employee satisfaction surveys can indicate a higher level of employee motivation and a strong team spirit.</span>','0','group','2023-03-18 00:00:00','2023-03-24 00:00:00','0','false','false','[\"1\"]',9,141,0,1,1,1,'{\"title\":\" Employee satisfaction survey updated\",\"description\":\"<span>This type of survey method is used to gauge whether employees are happy and satisfied with their work environment. Positive results in employee satisfaction surveys can indicate a higher level of employee motivation and a strong team spirit.</span>\",\"surveyOption\":\"0\",\"surveyType\":\"group\",\"groupType\":\"[8]\",\"surveyStartDate\":\"2023-03-19\",\"surveyEndDate\":\"2023-03-21\",\"surveyViewOption\":\"0\",\"additional_anonymous_voting\":\"false\",\"additional_cast_vote\":\"false\",\"surveyNotificationOption\":\"[\\\"1\\\"]\",\"survey_Answers\":\"[\\\"Satisfied\\\",\\\"Not Satisfied\\\"]\",\"image\":\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/images%20%2810%29.jpeg\",\"team_id\":\"141\",\"user_id\":\"9\",\"approved_status\":\"1\"}',NULL,0,NULL,NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/images%20%2810%29.jpeg',1,'2023-03-17 05:29:21','2023-08-07 05:01:27'),
(15,'What is your age range?','<b>a range indicating the upper and lower ages considered suitable for a specified thing</b>.','0','all_club','2023-03-17 00:00:00','2023-03-20 00:00:00','0','false','false','[\"1\",\"2\"]',8,141,0,1,1,1,NULL,NULL,0,NULL,NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/pexels-pixabay-219570.jpg',1,'2023-03-17 06:12:12','2023-08-07 05:01:26'),
(16,'Participants ready for Marathon','<span>The marathon is a long-distance foot race with a distance of 42.195 km, usually run as a road race, but the distance can be covered on trail routes. The marathon can be completed by running or with a run/walk strategy.</span>','0','all_club','2023-03-21 00:00:00','2023-03-25 00:00:00','1','false','false','[\"1\",\"2\"]',8,141,0,1,1,0,NULL,NULL,1,NULL,NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/pexels-run-ffwpu-2654902.jpg',1,'2023-03-20 05:01:21','2023-08-07 05:01:26'),
(17,'Neue Trikotfarbe  ','<font face=\"Arial\" size=\"2\">Welche Farbe soll das Trickot in der Saison 2023/24 erhalten?</font>','0','group','2023-03-01 00:00:00','2023-06-01 00:00:00','0','false','false','[\"1\"]',32,2830,0,1,NULL,0,NULL,NULL,NULL,NULL,NULL,'',0,'2023-03-20 12:34:23','2023-03-20 12:34:23'),
(18,'Which course do you prefer?','<span>In higher education a course is a unit of teaching that typically lasts one academic term, is led by one or more instructors, and has a fixed roster of students. A course usually covers an individual subject. Courses generally have a fixed program of sessions every week during the term, called lessons or classes.</span>','0','all_club','2023-06-14 00:00:00','2023-06-30 00:00:00','0','false','false','[]',1,141,0,1,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/pexels-karolina-grabowska-4218864.jpg',1,'2023-06-12 06:29:31','2023-08-07 05:01:24'),
(19,'Which is your birthday range?','<span>A&#160;</span><span>birthday</span><span>&#160;is the anniversary of the birth of a person, or figuratively of an institution.&#160;</span><span>Birthdays</span><span>&#160;of people are celebrated in numerous cultures,&#160;...</span>','0','all_club','2023-06-12 00:00:00','2023-06-17 00:00:00','1','false','true','[]',1,141,0,1,NULL,0,NULL,NULL,NULL,NULL,NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/pexels-karolina-grabowska-4389637.jpg',1,'2023-06-12 06:42:37','2023-08-04 17:49:11'),
(20,'IST FEU admin survey','<div><p><strong>Lorem Ipsum</strong>&#160;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p><p><br></p></div><div></div>','0','all_club','2023-08-10 00:00:00','2023-08-12 00:00:00','0','false','false','\"[\\\"2\\\"]\"',1,141,0,1,NULL,0,NULL,NULL,0,NULL,NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/pexels-pixabay-276566.jpg',0,'2023-08-08 11:29:02','2023-08-08 11:48:13'),
(21,'IST FEU secretary survey','<div><p><strong>Lorem Ipsum</strong><span>&#160;</span>is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p></div><div><br class=\"Apple-interchange-newline\"><br></div>','0','all_club','2023-08-10 00:00:00','2023-08-12 00:00:00','0','false','false','[\"2\"]',8,141,0,1,1,0,NULL,NULL,1,NULL,NULL,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/pexels-freemockupsorg-775219.jpg',0,'2023-08-08 11:57:19','2023-08-08 12:10:37'),
(22,'test','<font face=\"Arial\" size=\"2\">test</font>','1','all_club','2023-08-14 00:00:00','2023-08-28 00:00:00','0','false','false','[]',32,2830,0,1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,'2023-08-14 06:34:59','2023-08-14 06:34:59');

--
-- Table structure for table `survey_answer`
--

CREATE TABLE `survey_answer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `surveyId` int(11) NOT NULL,
  `surveyAnswer` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `survey_answer`
--

INSERT INTO `survey_answer` VALUES
(1,3,'good '),
(2,3,'better'),
(3,3,'best'),
(7,5,'good'),
(8,5,'best'),
(9,5,'bad'),
(14,8,'good'),
(15,8,'bad'),
(16,9,'bad'),
(17,9,'good'),
(18,10,'good'),
(19,10,'bad'),
(20,11,'Antwort A'),
(21,11,'Antwort B'),
(22,12,'Michael phelps'),
(23,12,'Mark Spitz'),
(24,12,'Matt Biondoi'),
(25,12,'Caeleb Dressel'),
(26,12,'Ryan Lochte'),
(27,13,'Ja'),
(28,13,'Vielleicht'),
(29,13,'Nein'),
(30,13,'Oder'),
(31,14,'Satisfied'),
(32,14,'Not Satisfied'),
(33,15,'Baby Boomers (0-10)'),
(34,15,'Gen X (11 - 18)'),
(35,15,'Gen Y / Millennials (19 - 35)'),
(36,15,'Gen Z / iGen / Centennials (36-60)'),
(37,16,'Yes !!'),
(38,16,'Noo'),
(39,16,'May be'),
(40,16,'Let\'s see'),
(41,17,'Rot'),
(42,17,'Weiß'),
(43,17,'Grün'),
(44,18,'Mechanical Engineering'),
(45,18,'Computer Science Engineering'),
(46,18,'Digital Marketing Course'),
(47,19,'0-3'),
(48,19,'4-6'),
(49,19,'7-9'),
(50,20,'Yes'),
(51,20,'No'),
(52,21,'YES'),
(53,21,'NOO'),
(54,22,'ja'),
(55,22,'nein'),
(56,22,'vielleicht');

--
-- Table structure for table `survey_cron_mail`
--

CREATE TABLE `survey_cron_mail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `surveyId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `sendDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `survey_cron_mail`
--


--
-- Table structure for table `survey_image`
--

CREATE TABLE `survey_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `survey_id` int(11) NOT NULL,
  `survey_image` longtext NOT NULL,
  `surevy_document` 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=10 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `survey_image`
--

INSERT INTO `survey_image` VALUES
(1,19,'[BLOB]','','2023-08-04 17:49:11',NULL),
(2,18,'[BLOB]','','2023-08-07 05:01:24',NULL),
(3,16,'[BLOB]