-- Table structure for table `survey_result`
--

CREATE TABLE `survey_result` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `surveyId` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `team_id` int(11) NOT NULL,
  `surveyAnswerId` varchar(50) NOT NULL,
  `surveyType` varchar(20) NOT NULL,
  `surveyTypeId` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `survey_result`
--

INSERT INTO `survey_result` VALUES
(1,3,1,141,'1','all_club','null'),
(3,6,6,141,'11','all_club','null'),
(4,10,4,141,'18','all_club','null'),
(6,9,1,141,'17','all_club','null'),
(7,10,1,141,'18','all_club','null'),
(8,12,8,141,'22','all_club','null'),
(9,12,9,141,'25','all_club','null'),
(10,12,1,141,'22','all_club','null'),
(11,12,5,141,'22','all_club','null'),
(12,15,8,141,'35','all_club','null'),
(13,15,1,141,'36','all_club','null'),
(15,19,1,141,'48','all_club','null'),
(16,22,32,2830,'54','all_club','null');

--
-- Table structure for table `survey_type`
--

CREATE TABLE `survey_type` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `surveyId` int(11) NOT NULL,
  `surveyTypeId` int(11) NOT NULL,
  `surveyType` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `survey_type`
--

INSERT INTO `survey_type` VALUES
(4,14,8,'group'),
(5,17,13,'group');

--
-- Table structure for table `survey_users`
--

CREATE TABLE `survey_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `surveyId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `surveyTypeId` int(11) DEFAULT NULL,
  `approvedStatus` int(11) DEFAULT 0,
  `read_status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `survey_users`
--

INSERT INTO `survey_users` VALUES
(1,3,1,NULL,0,0),
(2,3,2,NULL,0,0),
(5,5,3,NULL,0,0),
(16,8,1,NULL,0,0),
(17,8,2,NULL,0,0),
(18,8,4,NULL,0,0),
(19,8,5,NULL,0,0),
(20,8,6,NULL,0,0),
(21,8,7,NULL,0,0),
(22,8,8,NULL,0,0),
(23,8,9,NULL,0,0),
(24,9,1,NULL,0,1),
(25,9,2,NULL,0,0),
(26,9,4,NULL,0,0),
(27,9,5,NULL,0,0),
(28,9,6,NULL,0,0),
(29,9,7,NULL,0,0),
(30,9,8,NULL,0,0),
(31,9,9,NULL,0,0),
(32,10,1,NULL,0,1),
(33,10,2,NULL,0,0),
(34,10,4,NULL,0,0),
(35,10,5,NULL,0,0),
(36,10,6,NULL,0,0),
(37,10,7,NULL,0,0),
(38,10,8,NULL,0,0),
(39,10,9,NULL,0,0),
(40,11,1,NULL,0,1),
(41,11,2,NULL,0,0),
(42,11,4,NULL,0,0),
(43,11,5,NULL,0,0),
(44,11,6,NULL,0,0),
(45,11,7,NULL,0,0),
(46,11,8,NULL,0,0),
(47,11,9,NULL,0,0),
(48,11,1,NULL,0,1),
(49,11,6,NULL,0,0),
(50,11,5,NULL,0,0),
(51,11,4,NULL,0,0),
(52,11,7,NULL,0,0),
(53,11,8,NULL,0,0),
(54,11,9,NULL,0,0),
(55,11,17,NULL,0,0),
(56,11,18,NULL,0,0),
(57,12,1,NULL,0,1),
(58,12,2,NULL,0,0),
(59,12,4,NULL,0,0),
(60,12,5,NULL,0,0),
(61,12,6,NULL,0,0),
(62,12,7,NULL,0,0),
(63,12,8,NULL,0,0),
(64,12,9,NULL,0,0),
(65,12,17,NULL,0,0),
(66,12,18,NULL,0,0),
(76,14,6,8,0,0),
(77,14,7,8,0,0),
(78,14,8,8,0,0),
(79,14,9,8,0,0),
(80,14,1,8,0,1),
(81,15,1,NULL,0,1),
(82,15,2,NULL,0,0),
(83,15,4,NULL,0,0),
(84,15,5,NULL,0,0),
(85,15,6,NULL,0,0),
(86,15,7,NULL,0,0),
(87,15,8,NULL,0,0),
(88,15,9,NULL,0,0),
(89,15,17,NULL,0,0),
(90,15,18,NULL,0,0),
(91,16,1,NULL,0,1),
(92,16,2,NULL,0,0),
(93,16,4,NULL,0,0),
(94,16,5,NULL,0,0),
(95,16,6,NULL,0,0),
(96,16,7,NULL,0,0),
(97,16,8,NULL,0,0),
(98,16,9,NULL,0,0),
(99,16,17,NULL,0,0),
(100,16,18,NULL,0,0),
(101,17,31,13,0,1),
(102,17,32,13,0,1),
(103,18,1,NULL,0,0),
(104,18,2,NULL,0,0),
(105,18,4,NULL,0,0),
(106,18,5,NULL,0,0),
(107,18,6,NULL,0,0),
(108,18,7,NULL,0,0),
(109,18,8,NULL,0,0),
(110,18,9,NULL,0,0),
(111,18,17,NULL,0,0),
(112,18,18,NULL,0,0),
(113,19,1,NULL,0,0),
(114,19,2,NULL,0,0),
(115,19,4,NULL,0,0),
(116,19,5,NULL,0,0),
(117,19,6,NULL,0,0),
(118,19,7,NULL,0,0),
(119,19,8,NULL,0,0),
(120,19,9,NULL,0,0),
(121,19,17,NULL,0,0),
(122,19,18,NULL,0,0),
(123,20,1,NULL,0,1),
(124,20,2,NULL,0,0),
(125,20,4,NULL,0,0),
(126,20,5,NULL,0,0),
(127,20,6,NULL,0,0),
(128,20,7,NULL,0,0),
(129,20,8,NULL,0,0),
(130,20,9,NULL,0,0),
(131,20,17,NULL,0,0),
(132,20,18,NULL,0,0),
(133,21,1,NULL,0,0),
(134,21,2,NULL,0,0),
(135,21,4,NULL,0,0),
(136,21,5,NULL,0,0),
(137,21,6,NULL,0,0),
(138,21,7,NULL,0,0),
(139,21,8,NULL,0,0),
(140,21,9,NULL,0,0),
(141,21,17,NULL,0,0),
(142,21,18,NULL,0,0),
(143,22,19,NULL,0,0),
(144,22,20,NULL,0,0),
(145,22,31,NULL,0,0),
(146,22,32,NULL,0,0);

--
-- Table structure for table `task_collaborators`
--

CREATE TABLE `task_collaborators` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `approved_status` int(11) DEFAULT NULL,
  `read_status` int(11) NOT NULL DEFAULT 0,
  `task_updated_status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `task_collaborators`
--

INSERT INTO `task_collaborators` VALUES
(1,1,2,0,0,0),
(2,1,1,1,1,0),
(5,2,2,0,0,0),
(6,2,1,1,1,0),
(7,3,2,0,0,0),
(8,3,1,1,1,0),
(9,4,2,0,0,0),
(10,4,1,1,1,0),
(11,5,6,0,0,0),
(12,5,1,1,1,0),
(13,6,1,0,0,0),
(14,6,6,0,0,0),
(15,6,7,0,0,0),
(16,6,8,0,0,0),
(17,6,9,1,0,0),
(18,7,6,0,0,0),
(19,7,7,0,0,0),
(20,7,8,0,0,0),
(21,7,1,1,1,0),
(22,8,9,0,0,0),
(23,8,8,0,0,0),
(24,8,7,0,0,0),
(25,8,1,1,1,0),
(26,9,9,0,0,0),
(27,9,8,0,0,0),
(28,9,1,1,1,0),
(29,10,6,0,0,0),
(30,10,7,0,0,0),
(31,10,8,0,0,0),
(32,10,9,0,0,0),
(33,10,1,1,1,0),
(40,14,8,1,0,1),
(41,14,1,1,1,1),
(42,15,8,1,1,1),
(43,15,1,1,1,0),
(47,17,8,1,1,1),
(48,17,7,1,1,1),
(49,17,9,1,1,1),
(52,19,9,1,0,0),
(53,19,8,1,0,0),
(54,19,6,1,1,0),
(57,21,7,1,0,0),
(58,21,6,1,0,0),
(59,21,4,1,0,0),
(60,21,9,1,0,0),
(61,22,32,1,1,0),
(62,23,7,1,0,0),
(63,23,8,1,0,0),
(64,23,1,1,1,0),
(65,24,9,1,0,1),
(66,24,8,1,1,1),
(67,24,7,1,0,1),
(68,25,34,1,1,1),
(69,25,33,1,1,1),
(70,26,34,1,0,0),
(71,26,33,1,0,0),
(72,27,9,1,1,1),
(73,27,8,1,1,1),
(74,27,7,1,1,1),
(75,27,1,1,1,1);

--
-- Table structure for table `task_group`
--

CREATE TABLE `task_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `team_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `organizer_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  `updated_record` longtext DEFAULT NULL,
  `update_image_url` varchar(500) DEFAULT NULL,
  `is_image_converted` int(11) NOT NULL DEFAULT 0,
  `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,
  `complete_read_status` tinyint(4) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `approved_status` int(11) DEFAULT NULL,
  `event_id` int(11) DEFAULT NULL,
  `course_id` int(11) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `task_group`
--

INSERT INTO `task_group` VALUES
(1,NULL,'Putzen des Vereinsraumes','Der Vereinsraum muss f&#252;r die Versammlung gereinigt werden.<br>',1,0,NULL,2,'2022-09-30',NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,'2022-09-27 09:06:19',NULL,NULL,NULL,'2022-10-03 13:48:16'),
(2,NULL,'tech event task','<font face=\"Arial\" size=\"2\">testing</font>',1,0,NULL,NULL,'2022-09-29',NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,'2022-09-29 09:33:56',NULL,NULL,NULL,'2022-10-03 13:48:16'),
(3,NULL,'event task 22','<font face=\"Arial\" size=\"2\">testing</font>',1,0,NULL,3,'2022-09-30',NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,'2022-09-29 09:34:41',NULL,NULL,NULL,'2022-10-03 13:48:16'),
(4,NULL,'bum bum','<font size=\"2\"><font face=\"Arial\">ksd cks dvkjsdnckjsd ksjd c<br></font></font>',1,1,NULL,0,'2022-10-19',NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,'2022-11-28 11:11:58',NULL,NULL,NULL,'2022-10-14 11:24:10'),
(5,NULL,'Biertische','<font face=\"Arial\" size=\"2\">test</font>',1,1,NULL,0,'2022-11-01',NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,'2022-11-17 16:22:24',NULL,NULL,NULL,'2022-10-31 12:52:23'),
(6,NULL,'Test121','<span>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec nec quam vel arcu&#160;</span>',9,0,NULL,0,'2022-11-21',NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,'2022-11-22 05:42:57',NULL,NULL,NULL,'2022-11-21 12:03:41'),
(7,NULL,'test task 22 nov','testing',1,0,NULL,0,'2022-11-26',NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,'2022-11-22 06:11:47',NULL,NULL,NULL,'2022-11-22 06:11:47'),
(8,NULL,'Test Task123','<span>Lorem ipsum dolor</span>',1,0,NULL,0,'2022-11-24',NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,'2022-11-22 09:01:20',NULL,NULL,NULL,'2022-11-22 09:01:20'),
(9,NULL,'task23','<font face=\"Arial\" size=\"2\">test</font>',1,1,NULL,0,'2022-11-23',NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,'2022-11-22 13:49:20',NULL,NULL,NULL,'2022-11-22 09:29:29'),
(10,NULL,'test task todo','<font face=\"Arial\" size=\"2\">testing</font>',1,0,NULL,8,'2022-12-11',NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,'2022-11-22 10:59:53',NULL,NULL,NULL,'2022-11-22 10:59:53'),
(14,141,' Faculty of Law...','<span>The Faculty of Law, University of Delhi is the law department of the University of Delhi. It has the unique distinction of producing the largest number of sitting judges of the Supreme Court of India</span>',1,0,NULL,0,'2023-03-31','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm_foto%202023-03-18%20um%2009.38.13.png',NULL,NULL,1,0,NULL,NULL,0,0,'2023-03-22 07:23:55',NULL,43,NULL,'2023-08-07 05:44:22'),
(15,141,'Apply statistics and mathematical techniques ','<span>Statistics may be used to study the vast amounts of data we have about these systems and look for patterns. Mathematical and Statistical models can be used&#160;</span><b>to understand and make predictions about such diverse things as glacial movement, seismic events, and tsunamis</b><span>.</span>',1,1,NULL,0,'2023-03-01','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm_foto%202023-03-18%20um%2009.38.48.png',NULL,NULL,1,0,NULL,NULL,0,0,'2023-03-22 08:03:59',NULL,NULL,16,'2023-08-07 05:44:22'),
(17,141,'Aviation Courses task updated','<ul><li><span>Aviation Courses</span></li></ul>',9,0,1,0,'2023-03-18','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/damir-bosnjak.jpg',NULL,NULL,1,0,NULL,NULL,1,0,'2023-03-17 04:46:33',NULL,NULL,20,'2023-08-07 05:44:22'),
(19,141,'Write a gratitude in early morning','<div class=\"co8aDb\" aria-level=\"3\" role=\"heading\"><b>With an intonation that\'s thoughtful and deliberate, you can say:</b></div><div class=\"RqBzHd\"><ol class=\"X5LH0c\"><li class=\"TrT0Xe\">I cannot thank you enough.</li><li class=\"TrT0Xe\">Words cannot express how much you mean to me.</li><li class=\"TrT0Xe\">I am more grateful to you than you\'ll ever know.</li><li class=\"TrT0Xe\">I\'m eternally grateful.</li><li class=\"TrT0Xe\">You have my deepest thanks.</li><li class=\"TrT0Xe\">I\'ll never forget your support and kindness.</li></ol></div>',8,1,1,0,'2023-03-30','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/pexels-pixabay-372748.jpg',NULL,NULL,1,0,NULL,NULL,1,0,'2023-03-17 04:51:55',NULL,NULL,NULL,'2023-08-07 05:44:21'),
(21,141,'The Royal Day Events task','<font face=\"Arial\" size=\"2\">The Royal Day Events</font>',9,1,NULL,0,'2023-03-19','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm_foto%202023-03-18%20um%2009.39.09.png',NULL,NULL,1,0,NULL,NULL,0,0,'2023-04-04 06:00:16',NULL,45,NULL,'2023-08-07 05:44:20'),
(22,2830,'Getränke für das Sportheim einkaufen','<font face=\"Arial\" size=\"2\">2x Cola</font><p><font face=\"Arial\" size=\"2\">2x Bier</font></p>',32,0,NULL,0,'2023-08-02','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009.38.48.png',NULL,NULL,1,NULL,NULL,NULL,0,0,'2023-03-20 11:01:30',NULL,NULL,NULL,'2023-08-07 05:44:20'),
(23,141,'wefrwer','<font face=\"Arial\" size=\"2\">wer</font>',1,1,NULL,11,'2023-03-30','https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/47e7f427-84d9-bfa7-f56b-5bd863fbabd1.jpg',NULL,NULL,1,0,NULL,NULL,0,0,'2023-03-20 16:20:12',NULL,49,NULL,'2023-08-07 05:44:20'),
(24,141,'Test task with sub task edit','<font face=\"Arial\" size=\"2\">testing updating</font>',8,0,1,0,'2023-04-10','https://minio.staging.verein.cloud/tineon/Leipzig/2023/April/Images/pexels-cottonbro-studio-4709285.jpg',NULL,NULL,1,NULL,NULL,NULL,0,0,'2023-04-05 06:02:24',NULL,NULL,NULL,'2023-08-07 05:44:19'),
(25,2684,'Registrierung partner.dwerk.de','<font face=\"Arial\" size=\"2\">Lieber Makler, bitte registriere Dich auf unserer Partner Webseite</font>',33,1,NULL,16,'2023-04-25','https://minio.staging.verein.cloud/tineon/Leipzig/2023/April/Documents/Bildschirmfoto%202023-04-24%20um%2018.51.51.png',NULL,NULL,1,0,NULL,NULL,0,0,'2023-05-07 16:57:31',NULL,53,NULL,'2023-08-07 05:43:49'),
(26,2684,'Registrierung Partner.dWERK. de','<font face=\"Arial\" size=\"2\">Der Zugang zu Ihrem individualisierten, interaktiven Video zur Arbeitgeberansprache</font>',33,0,NULL,16,'2023-04-25','https://minio.staging.verein.cloud/tineon/Leipzig/2023/April/Documents/Bildschirmfoto%202023-04-25%20um%2008.23.02.png',NULL,NULL,1,NULL,NULL,NULL,0,0,'2023-04-25 06:34:29',NULL,54,NULL,'2023-08-07 05:43:49'),
(27,141,'Sell any car more than 200%','<p>This is a <b>list of the most expensive cars sold in public <a href=\"https://en.wikipedia.org/wiki/Auto_auctions\" class=\"mw-redirect\" title=\"Auto auctions\">auto auctions</a></b> through the traditional <a href=\"https://en.wikipedia.org/wiki/Bidding\" title=\"Bidding\">bidding</a> process, that of those that attracted headline grabbing publicity, mainly for the high price their new owners have paid.&#10;</p>On May 5, 2022, in a secret auction at the brand\'s museum in &#10;Germany, Mercedes-Benz sold one of just two 1955 300 SLR Uhlenhaut &#10;coupes from its extensive collection of historical automobiles&#8212;which &#10;dates back to the earliest days of the car in the late 19th century. The&#10; sale, to a private buyer, was for 135 million euros ($142,769,250). It &#10;handily outstripped the previous record-setting $48.4-million sale of a &#10;1962 Ferrari 250 GTO at a 2018 auction to become the most expensive car &#10;ever sold at auction. Both of these high-dollar sales were brokered by &#10;RM Sotheby\'s.<a href=\"https://en.wikipedia.org/wiki/List_of_most_expensive_cars_sold_at_auction#cite_note-1\"></a>',8,0,1,15,'2024-02-29','https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/pexels-sora-shimazaki-5668473.jpg',NULL,NULL,1,0,NULL,NULL,1,0,'2023-06-12 05:46:41',NULL,NULL,29,'2023-08-07 05:43:49');

--
-- Table structure for table `task_image`
--

CREATE TABLE `task_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL,
  `task_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=16 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `task_image`
--

INSERT INTO `task_image` VALUES
(1,27,'[BLOB]','2023-08-07 05:43:48',NULL),
(2,26,'[BLOB]','2023-08-07 05:43:49',NULL),
(3,25,'[BLOB]','2023-08-07 05:43:49',NULL),
(4,24,'[BLOB]','2023-08-07 05:44:19',NULL),
(5,23,'[BLOB]','2023-08-07 05:44:20',NULL),
(6,22,'[BLOB]','2023-08-07 05:44:20',NULL),
(7,21,'[BLOB]','2023-08-07 05:44:20',NULL),
(8,19,'[BLOB]','2023-08-07 05:44:21',NULL),
(9,17,'[BLOB]