INSERT INTO `event_images` VALUES
(12,29,'[BLOB]','','2023-08-07 05:11:42','2023-08-07 05:11:42'),
(15,60,'[BLOB]','','2023-08-09 04:28:29',NULL);

--
-- Table structure for table `event_users`
--

CREATE TABLE `event_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `approved_status` int(11) DEFAULT NULL,
  `read_status` int(11) NOT NULL DEFAULT 1,
  `event_updated_status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=292 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `event_users`
--

INSERT INTO `event_users` VALUES
(5,2,2,0,1,0),
(6,2,1,1,1,0),
(7,3,1,1,1,0),
(10,5,3,1,1,0),
(13,7,3,1,1,0),
(14,8,1,1,1,0),
(15,8,6,0,1,0),
(16,8,5,0,1,0),
(17,8,4,0,1,0),
(18,8,2,0,1,0),
(24,10,1,1,1,0),
(25,10,2,0,1,0),
(26,10,4,0,1,0),
(27,10,5,0,1,0),
(28,10,6,0,1,0),
(29,11,1,1,1,0),
(30,11,6,0,1,0),
(31,11,5,0,1,0),
(32,11,4,0,1,0),
(33,11,4,0,1,0),
(34,11,5,0,1,0),
(35,11,6,0,1,0),
(36,11,2,0,1,0),
(37,6,1,1,1,0),
(38,6,2,0,1,0),
(39,12,1,1,1,0),
(40,13,1,1,1,0),
(41,13,6,0,1,0),
(42,13,4,0,1,0),
(43,14,4,0,1,0),
(44,14,1,1,1,0),
(45,14,4,0,1,0),
(46,14,6,0,1,0),
(47,15,1,1,1,0),
(48,15,6,0,1,0),
(49,15,5,0,1,0),
(50,15,4,0,1,0),
(51,15,2,0,1,0),
(52,16,1,1,1,0),
(53,16,6,0,1,0),
(54,16,4,0,1,0),
(55,17,1,1,1,0),
(56,17,6,0,1,0),
(57,17,4,0,1,0),
(58,17,2,0,1,0),
(74,19,1,1,1,0),
(75,19,6,1,1,0),
(76,19,4,1,1,0),
(84,1,1,1,1,0),
(85,1,2,0,1,0),
(86,18,1,1,1,0),
(87,18,9,0,1,0),
(88,18,7,0,1,0),
(89,18,6,0,1,0),
(90,18,8,0,1,0),
(91,4,1,1,1,0),
(92,4,2,0,1,0),
(107,22,1,1,1,0),
(108,22,8,0,1,0),
(109,22,9,0,1,0),
(110,22,7,0,1,0),
(121,24,4,1,1,0),
(122,24,7,0,1,0),
(123,24,8,0,1,0),
(124,25,7,1,1,1),
(125,25,9,0,1,0),
(126,25,8,0,1,0),
(127,26,7,1,1,0),
(128,26,7,0,1,0),
(129,26,9,0,1,0),
(130,27,7,1,1,1),
(131,27,4,0,1,0),
(132,27,6,0,1,0),
(133,27,9,0,1,0),
(134,28,7,1,1,1),
(135,28,9,0,1,0),
(136,28,8,0,1,0),
(137,29,1,1,1,1),
(138,29,9,0,1,0),
(139,29,8,0,1,0),
(140,29,7,0,1,0),
(141,29,4,0,1,0),
(142,29,6,0,1,0),
(143,29,9,0,1,0),
(144,29,8,0,1,0),
(145,29,7,0,1,0),
(146,29,6,0,1,0),
(147,29,4,0,1,0),
(148,29,2,0,1,0),
(149,29,1,1,1,1),
(152,31,30,1,1,0),
(153,31,29,0,1,0),
(154,31,28,0,1,0),
(155,31,27,0,1,0),
(156,31,26,0,1,0),
(157,31,25,0,1,0),
(158,31,24,0,1,0),
(159,31,23,0,1,0),
(160,31,22,1,1,0),
(161,31,21,1,1,0),
(162,32,30,1,1,0),
(163,32,21,1,1,0),
(164,32,22,0,1,0),
(165,33,1,1,1,0),
(166,33,9,0,1,0),
(167,33,8,0,1,0),
(168,33,7,0,1,0),
(169,34,1,1,1,1),
(170,34,7,0,1,0),
(171,34,9,0,1,0),
(172,34,8,1,1,0),
(173,35,1,1,1,0),
(174,35,9,0,1,0),
(175,35,8,1,1,0),
(176,35,7,0,1,0),
(177,35,4,0,1,0),
(178,35,6,0,1,0),
(179,35,1,0,1,0),
(180,35,9,0,1,0),
(181,35,8,0,1,0),
(182,35,7,0,1,0),
(183,35,6,0,1,0),
(184,35,4,0,1,0),
(185,35,2,0,1,0),
(186,36,1,1,1,0),
(187,36,9,0,1,0),
(188,36,8,1,1,0),
(189,37,8,1,1,1),
(190,37,4,0,1,0),
(191,37,7,0,1,0),
(192,37,9,0,1,0),
(193,38,1,1,1,0),
(203,41,1,1,1,0),
(204,41,9,0,1,0),
(205,41,8,0,1,0),
(206,42,1,1,1,0),
(207,42,9,0,1,0),
(208,42,8,0,1,0),
(209,42,7,0,1,0),
(210,42,6,0,1,0),
(211,42,4,0,1,0),
(212,42,2,0,1,0),
(213,43,1,1,1,1),
(214,43,9,0,1,0),
(215,43,8,0,1,0),
(216,43,7,0,1,0),
(217,43,6,0,1,0),
(218,43,4,0,1,0),
(219,43,2,0,1,0),
(220,44,8,1,1,1),
(221,44,9,1,1,1),
(222,44,7,0,1,0),
(223,45,9,1,1,1),
(224,45,8,0,1,0),
(225,45,7,0,1,0),
(226,45,6,0,1,0),
(227,46,8,1,1,0),
(228,46,1,1,1,0),
(229,47,32,1,1,0),
(230,47,31,1,1,0),
(231,47,20,0,1,0),
(232,47,19,0,1,0),
(233,48,32,1,1,1),
(234,48,31,0,1,0),
(235,48,20,0,1,0),
(236,48,19,0,1,0),
(237,49,1,1,1,0),
(242,51,1,1,1,0),
(243,51,9,0,1,0),
(244,51,8,0,1,0),
(245,52,1,1,1,0),
(246,52,9,0,1,0),
(247,52,8,0,1,0),
(248,52,7,0,1,0),
(249,52,6,0,1,0),
(250,52,5,0,1,0),
(251,52,4,0,1,0),
(252,52,2,0,1,0),
(253,53,34,1,1,1),
(254,53,33,1,1,1),
(255,54,34,0,1,0),
(256,54,33,1,1,0),
(257,55,8,1,1,1),
(258,55,9,0,1,0),
(259,55,7,0,1,0),
(260,55,6,0,1,0),
(261,55,5,0,1,0),
(262,55,4,0,1,0),
(263,55,2,0,1,0),
(264,55,1,1,1,1),
(265,56,44,1,1,0),
(266,56,43,1,1,0),
(267,56,31,0,1,0),
(291,60,32,1,1,0);

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `team_id` int(11) DEFAULT NULL,
  `schedule` varchar(45) DEFAULT NULL,
  `official_club_date` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `name` varchar(155) DEFAULT NULL,
  `picture_video` varchar(500) DEFAULT NULL,
  `place` varchar(45) DEFAULT NULL,
  `room` varchar(45) DEFAULT NULL,
  `visibility` varchar(45) DEFAULT NULL,
  `limitation_of_participants` varchar(45) DEFAULT NULL,
  `participants` varchar(45) DEFAULT NULL,
  `waiting_list` varchar(45) DEFAULT NULL,
  `max_on_waiting_list` varchar(45) DEFAULT NULL,
  `attachments` varchar(45) DEFAULT NULL,
  `link_to_ticket_store` varchar(45) DEFAULT NULL,
  `tags` varchar(45) DEFAULT NULL,
  `author` varchar(45) 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_approved_status` tinyint(4) DEFAULT NULL,
  `deny_reason` text DEFAULT NULL,
  `deny_by_id` int(11) DEFAULT NULL,
  `audience` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `date_from` datetime DEFAULT NULL,
  `date_to` datetime DEFAULT NULL,
  `coorganizer` text DEFAULT NULL,
  `invite_friends` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `show_guest_list` text DEFAULT NULL,
  `chargeable` text DEFAULT NULL,
  `price_per_participant` float(45,2) DEFAULT NULL,
  `create_invoice` varchar(45) DEFAULT NULL,
  `start_time` varchar(45) DEFAULT NULL,
  `end_time` varchar(45) DEFAULT NULL,
  `date_repeat` datetime DEFAULT NULL,
  `recurrence` varchar(600) DEFAULT NULL,
  `recurring_dates` text DEFAULT NULL,
  `allowed_persons` varchar(32) DEFAULT NULL,
  `update_image_url` 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=61 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `events`
--

INSERT INTO `events` VALUES
(27,141,NULL,NULL,'3','Platinum Events','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/January/Images/download.jpeg\"]','Indore',NULL,'1',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'7',1,NULL,0,NULL,0,NULL,NULL,1,NULL,'2023-04-01 19:25:00','2023-04-09 23:25:00',NULL,NULL,'<hr><div><div><div></div></div><div><div></div></div><div class=\"boxed\"><div><p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus viverra est eget malesuada bibendum. Vivamus malesuada odio et mi blandit, eu sodales felis pellentesque. Donec consequat enim ipsum, eu congue magna lacinia eu. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Aenean ac bibendum diam.&#160;</p></div></div></div>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-04-09 23:25:00',NULL,'[{\"date_from\":\"2023-04-01\",\"start_time\":\"19:25\",\"end_time\":\"23:25\"},{\"date_from\":\"2023-04-03\",\"start_time\":\"19:25\",\"end_time\":\"20:25\"},{\"date_from\":\"2023-04-05\",\"start_time\":\"17:25\",\"end_time\":\"18:25\"},{\"date_from\":\"2023-04-07\",\"start_time\":\"19:25\",\"end_time\":\"20:25\"},{\"date_from\":\"2023-04-09\",\"start_time\":\"19:26\",\"end_time\":\"21:26\"}]',NULL,NULL,0,'2023-01-23 10:01:27','2023-01-23 10:01:27'),
(28,141,NULL,NULL,'3','Platinum Planning','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/January/Images/pexels-alena-darmel-7862655-1674468481212.jpg\"]','Indore',NULL,'1',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'7',1,NULL,0,NULL,0,NULL,NULL,1,NULL,'2023-04-10 18:33:00','2023-04-22 19:33:00',NULL,NULL,'<hr><div><div><div></div></div><div><div></div></div><div class=\"boxed\"><div><p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus viverra est eget malesuada bibendum. Vivamus malesuada odio et mi blandit, eu sodales felis pellentesque. Donec consequat enim ipsum, eu congue magna lacinia eu. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Aenean ac bibendum diam.&#160;</p></div></div></div>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-04-22 19:33:00',NULL,'[{\"date_from\":\"2023-04-10\",\"start_time\":\"18:33\",\"end_time\":\"19:33\"},{\"date_from\":\"2023-04-12\",\"start_time\":\"17:33\",\"end_time\":\"19:33\"},{\"date_from\":\"2023-04-14\",\"start_time\":\"17:34\",\"end_time\":\"19:34\"},{\"date_from\":\"2023-04-16\",\"start_time\":\"19:34\",\"end_time\":\"20:34\"},{\"date_from\":\"2023-04-18\",\"start_time\":\"19:34\",\"end_time\":\"21:34\"},{\"date_from\":\"2023-04-20\",\"start_time\":\"20:34\",\"end_time\":\"01:34\"},{\"date_from\":\"2023-04-22\",\"start_time\":\"17:35\",\"end_time\":\"19:35\"}]',NULL,NULL,0,'2023-01-23 10:06:18','2023-01-23 10:06:18'),
(29,141,NULL,NULL,'3','Test event 23jan','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/pexels-lucas-rodrigues-vimieiro-5199044.jpg\"]','Indore','null','4',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'1',1,NULL,0,NULL,0,NULL,NULL,1,NULL,'2023-01-27 14:00:00','2023-01-27 15:30:00',NULL,NULL,'Trail <font size=\"2\"><font face=\"Arial\">test event</font></font><br>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-27 15:30:00',NULL,'[{\"date_from\":\"2023-01-27\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-02-24\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-03-24\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-04-21\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-05-19\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-06-16\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-07-21\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-08-25\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-09-22\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-10-20\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-11-17\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-12-15\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"}]','null',NULL,1,'2023-01-23 13:45:44','2023-08-07 05:11:42'),
(31,2810,NULL,NULL,'3','Aktionärsmeeting','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/January/Images/meeting-tipps.jpg\"]',' MICROSOFT TEAMS',NULL,'1',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'30',1,NULL,0,NULL,0,NULL,NULL,1,NULL,'2023-01-27 14:00:00','2023-12-15 15:30:00',NULL,NULL,'<span>Digitaler Reminder &#252;ber di</span><span>e Aktion&#228;rsmeetings in verein.cloud</span>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-15 15:30:00',NULL,'[{\"date_from\":\"2023-01-27\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-02-24\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-03-24\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-04-21\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-05-19\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-06-16\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-07-21\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-08-25\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-09-22\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-10-20\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-11-17\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"},{\"date_from\":\"2023-12-15\",\"start_time\":\"14:00\",\"end_time\":\"15:30\"}]',NULL,NULL,1,'2023-01-24 05:03:42','2023-08-07 05:11:41'),
(38,141,NULL,NULL,'2','Test event from admin updated','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/January/Images/images%20%2810%29.jpeg\"]','mango',NULL,'2',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'1',1,NULL,0,NULL,0,NULL,NULL,1,NULL,'2023-01-27 19:12:00','2023-01-27 20:12:00',NULL,NULL,'desc<font face=\"Arial\" size=\"2\">ription</font>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-27 20:12:00',NULL,'[{\"date_from\":\"2023-01-27\",\"start_time\":\"19:12\",\"end_time\":\"20:12\"}]',NULL,NULL,1,'2023-01-27 12:42:42','2023-08-07 05:11:41'),
(41,141,NULL,NULL,'1','Event Each week for Year','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/February/Images/brandon-paul-2P9MMBx-6JY-unsplash.jpg\"]','Indore','','1',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'1',1,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-18 15:00:00','2024-02-18 18:00:00',NULL,NULL,'<p>Lorem ipsum dolor sit amet. Sed commodi sint nam quia unde et maiores illo et dolore deserunt rem aliquam minus. Quo dicta architecto ea consequatur distinctio cum laboriosam impedit et accusamus incidunt sit voluptatem animi 33 ullam magnam. Ut veritatis nemo aut maiores omnis et modi nemo aut officiis officia quo rerum architecto.</p><p>Ut vero rerum nam nulla veniam ad consequatur ducimus ut sapiente deserunt! Est unde maxime sit neque voluptate et corporis architecto ea voluptatem temporibus. Et recusandae omnis eos inventore distinctio aut dolore nesciunt qui nisi enim.</p><p>Et internos voluptatum ut dignissimos molestiae ut quam provident. Vel deleniti soluta in quae officiis ut voluptas internos. Sit fuga perspiciatis ea minima aspernatur ut veritatis mollitia ex rerum sint nam praesentium quis.</p>','',NULL,NULL,NULL,NULL,NULL,'2024-02-18 18:00:00','RRULE:FREQ=WEEKLY;UNTIL=20240218T000000Z;DTSTART=20230218T000000Z\r\n','[{\"date_from\":\"2023-02-18\",\"start_time\":\"15:00\",\"end_time\":\"18:00\"}]',NULL,NULL,1,'2023-02-16 13:00:17','2023-08-07 05:11:41'),
(42,141,NULL,NULL,'1','International Conference On Communication System and Network Technologies Edit','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/February/Images/pexels-brett-sayles-4339335.jpg\"]','Bhopal',NULL,'4',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'1',1,NULL,0,NULL,0,NULL,NULL,1,NULL,'2023-02-22 15:15:00','2023-08-31 19:00:00',NULL,NULL,'<span>27 people interested. Check out who is attending &#10029; exhibiting &#10029; speaking &#10029; schedule &amp; agenda &#10029; reviews &#10029; timing &#10029; entry ticket fees. 2023 edition of International Conference on Communication...</span><p><span><font face=\"Arial\" size=\"2\">Edited</font></span></p>','true','250',250.00,NULL,NULL,NULL,'2023-08-31 19:00:00','RRULE:FREQ=WEEKLY;UNTIL=20230831T000000Z;DTSTART=20230222T000000Z\r\n','[{\"date_from\":\"2023-02-22\",\"start_time\":\"15:15\",\"end_time\":\"19:00\"}]',NULL,NULL,1,'2023-02-22 09:46:36','2023-08-07 05:09:32'),
(43,141,NULL,NULL,'5','AUAP-JLU INTERNATIONAL MOOT COURT COMPETITION, 2023','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm_foto%202023-03-18%20um%2009.38.13.png\"]','Indoreinstitudeofscienceandtechnology','null','4',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'1',1,NULL,0,NULL,0,NULL,NULL,1,NULL,'2023-02-23 17:00:00','2023-08-23 22:00:00',NULL,NULL,'<span>The 2nd Edition of the prestigious AUAP-JLU International Moot Court Competition, 2023, which is the VII Edition of the JLU Moot Court Competition is set to be organized by the Faculty of Law...</span>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-08-23 22:00:00','RRULE:FREQ=WEEKLY;UNTIL=20230823T000000Z;DTSTART=20230223T000000Z\r\n','[{\"date_from\":\"2023-02-23\",\"start_time\":\"17:00\",\"end_time\":\"22:00\"}]','null',NULL,1,'2023-02-22 09:57:40','2023-08-07 05:07:08'),
(45,141,NULL,NULL,'1','The Royal Day Events updated','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/images%20%2810%29.jpeg\"]','indore',NULL,'1',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'9',1,1,0,'{\"name\":\"The Royal Day Events updated\",\"place\":\"indore\",\"type\":\"1\",\"date_from\":\"2023-03-21 14:12\",\"date_to\":\"2023-03-24 17:15\",\"date_repeat\":\"2023-03-24 17:15\",\"start_time\":\"14:12\",\"end_time\":\"17:15\",\"room\":\"null\",\"visibility\":\"1\",\"participant\":[\"9\",\"8\",\"7\",\"6\"],\"show_guest_list\":\"\",\"description\":\"<ul><li>The Royal Day Events u<font face=\\\"Arial\\\" size=\\\"2\\\">pdated</font></li></ul>\",\"users\":\"[{\\\"user_id\\\":9,\\\"approved_status\\\":1},{\\\"user_id\\\":8,\\\"approved_status\\\":0},{\\\"user_id\\\":7,\\\"approved_status\\\":0},{\\\"user_id\\\":6,\\\"approved_status\\\":0}]\",\"author\":\"9\",\"approved_status\":\"1\",\"participants\":\"participants\",\"group\":\"\",\"audience\":\"1\",\"price_per_participant\":\"null\",\"isTask\":\"true\",\"eventDate\":\"[{\\\"date_from\\\":\\\"2023-03-21\\\",\\\"start_time\\\":\\\"14:12\\\",\\\"end_time\\\":\\\"17:15\\\"}]\",\"task\":\"[{\\\"title\\\":\\\"The Royal Day Events task updated\\\",\\\"description\\\":\\\"<font face=\\\\\\\"Arial\\\\\\\" size=\\\\\\\"2\\\\\\\">The Royal Day Events</font>\\\",\\\"organizer_id\\\":9,\\\"status\\\":0,\\\"group_id\\\":0,\\\"groups\\\":\\\"\\\",\\\"date\\\":\\\"2023-03-19\\\",\\\"type_dropdown\\\":[{\\\"id\\\":0,\\\"name\\\":\\\"Individual\\\"}],\\\"user_select\\\":[{\\\"id\\\":9,\\\"user_email\\\":\\\"jinnukikajoi-7835@yopmail.com\\\",\\\"user_name\\\":\\\"MangoIT Editor (jinnukikajoi-7835@yopmail.com )\\\"},{\\\"id\\\":4,\\\"user_email\\\":\\\"aditya.bhawsar@mangoitsolutions.in\\\",\\\"user_name\\\":\\\"Aditya Bhawsar (aditya.bhawsar@mangoitsolutions.in )\\\"},{\\\"id\\\":6,\\\"user_email\\\":\\\"tarun@mangoitsolutions.in\\\",\\\"user_name\\\":\\\"Tarun Pasangya (tarun@mangoitsolutions.in )\\\"},{\\\"id\\\":7,\\\"user_email\\\":\\\"heleuprotizo-3262@yopmail.com\\\",\\\"user_name\\\":\\\"MangoIT Functionary (heleuprotizo-3262@yopmail.com )\\\"}],\\\"taskCollaborators\\\":[{\\\"user_id\\\":9,\\\"approved_status\\\":1},{\\\"user_id\\\":4,\\\"approved_status\\\":1},{\\\"user_id\\\":6,\\\"approved_status\\\":1},{\\\"user_id\\\":7,\\\"approved_status\\\":1}]}]\",\"image\":\"[\\\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/download%20%281%29.jpeg\\\"]\",\"status\":2}',0,NULL,NULL,1,NULL,'2023-03-18 11:09:00','2023-03-23 13:11:00',NULL,NULL,'<ul><li>The Royal Day Events</li></ul>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-23 13:11:00',NULL,'[{\"date_from\":\"2023-03-18\",\"start_time\":\"11:09\",\"end_time\":\"13:11\"}]',NULL,NULL,1,'2023-03-17 05:40:10','2023-08-07 05:07:08'),
(47,2830,NULL,NULL,'1','Spieltag 1. Mannschaft HEIMSPIEL','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009.40.01.png\"]','Fußballplatz ',NULL,'1',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'32',1,NULL,0,NULL,0,NULL,NULL,1,NULL,'2023-03-25 13:00:00','2024-03-25 15:00:00',NULL,NULL,'<p class=\"MsoNormal\">Heimspiel unserer 1. Mannschaft</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2024-03-25 15:00:00','RRULE:FREQ=WEEKLY;UNTIL=20240325T000000Z;INTERVAL=2;DTSTART=20230325T000000Z\r\n','[{\"date_from\":\"2023-03-25\",\"start_time\":\"13:00\",\"end_time\":\"15:00\"}]',NULL,NULL,1,'2023-03-20 07:46:19','2023-08-07 05:07:08'),
(48,2830,NULL,NULL,'1','Spieltag der 1. Mannschaft AUSWÄRTS','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009.40.01.png\"]','Bitte Aushang beachten',NULL,'4',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'32',1,NULL,0,NULL,0,NULL,NULL,1,NULL,'2023-04-01 13:00:00','2024-04-01 15:00:00',NULL,NULL,'<font face=\"Arial\" size=\"2\">Ausw&#228;rtsspiel der 1. Manschaft</font>',NULL,NULL,NULL,NULL,NULL,NULL,'2024-04-01 15:00:00','RRULE:FREQ=WEEKLY;UNTIL=20240401T000000Z;INTERVAL=2;DTSTART=20230401T000000Z\r\n','[{\"date_from\":\"2023-04-01\",\"start_time\":\"13:00\",\"end_time\":\"15:00\"}]',NULL,NULL,1,'2023-03-20 07:56:06','2023-08-07 05:07:07'),
(51,141,NULL,NULL,'1','Test Event 1 April 2023','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/brazuca_2014_world_cup_95821_1024x768.jpg\"]','Test address','null','1',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'1',1,NULL,0,NULL,0,NULL,NULL,1,NULL,'2023-04-01 15:00:00','2023-04-01 18:00:00',NULL,NULL,'<span>Lorem ipsum dolor sit amet. Et odit repudiandae sit inventore dolorum sed enim sequi eos corrupti minima ex esse saepe id consectetur assumenda ea nemo voluptatibus. Nam libero voluptatem sit deserunt atque et odio ipsam ut itaque iure est labore numquam.</span>','true',NULL,NULL,NULL,NULL,NULL,'2023-04-01 18:00:00',NULL,'[{\"date_from\":\"2023-04-01\",\"start_time\":\"15:00\",\"end_time\":\"18:00\"}]',NULL,NULL,1,'2023-03-31 13:20:58','2023-08-07 05:07:07'),
(53,2684,NULL,NULL,'2','Webinar dBAV dWERK Erstinformation Makler','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/April/Documents/Bildschirmfoto%202023-04-24%20um%2018.51.51.png\"]','Online ','null','3',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'33',1,NULL,0,NULL,0,NULL,NULL,1,16,'2023-04-25 16:00:00','2023-04-25 18:00:00',NULL,NULL,'<font face=\"Arial\" size=\"2\">Erstinformation AXA Makler</font>','true','199',199.00,NULL,NULL,NULL,'2023-04-25 18:00:00',NULL,'[{\"date_from\":\"2023-04-25\",\"start_time\":\"16:00\",\"end_time\":\"18:00\"}]',NULL,NULL,1,'2023-04-24 16:52:45','2023-08-07 05:07:07'),
(55,141,NULL,NULL,'5','NAIAS (North American International Autogggg Show)','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/pexels-muhammad-muzamil-14666464.jpg\"]','Huntington Place','20','4',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'8',1,1,1,NULL,0,NULL,NULL,1,NULL,'2023-06-21 13:30:00','2023-11-03 19:30:00',NULL,NULL,'<span>The North American International Auto Show, also known as the &#10;Detroit Auto Show as of 2022 and prior to NAIAS, is an annual auto show &#10;held in Detroit, Michigan, U.S., at Huntington Place. The show was held &#10;in January from 1989 to 2019.</span><span><span></span></span>',NULL,'150',150.00,NULL,NULL,NULL,'2023-11-03 19:30:00','RRULE:FREQ=WEEKLY;UNTIL=20231103T000000Z;INTERVAL=2;BYDAY=SU,SA,SA,SA;DTSTART=20230621T000000Z\r\n','[{\"date_from\":\"2023-06-21\",\"start_time\":\"13:30\",\"end_time\":\"19:30\"}]','999',NULL,1,'2023-06-12 05:29:07','2023-08-07 05:07:07'),
(60,2830,NULL,NULL,'1','Grillfest','[\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/2308_VC_Event_Grillfest.jpg\"]','Meersburg','null','3',NULL,'participants',NULL,NULL,NULL,NULL,NULL,'32',1,NULL,0,NULL,NULL,NULL,NULL,NULL,13,'2023-08-09 18:30:00','2023-08-09 21:00:00',NULL,NULL,'Wir laden zum Saisonabschluss zum Grillen ein. F&#252;r Speisen und Getr&#228;nke ist dank unseres Sponsors &#34;Metzgerei Mustermann&#34; gesorgt.','true',NULL,NULL,NULL,NULL,NULL,'2023-08-09 21:00:00','','[{\"date_from\":\"2023-08-09\",\"start_time\":\"18:30\",\"end_time\":\"21:00\"}]',NULL,NULL,0,'2023-08-09 04:28:29','2023-08-09 04:28:29');

--
-- Table structure for table `family_group`
--

CREATE TABLE `family_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `organizer_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `family_group`
--


--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `team_id` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `author` varchar(155) 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,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modifiedAt` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` VALUES
(13,141,'Club Events',11,1,NULL,'<span>With the&#160;</span><span>online text generator</span><span>&#160;you can process your personal&#160;</span><span>Lorem Ipsum</span><span>&#160;enriching it with html elements that define its structure, with the possibility to insert external links, but not only.</span>','1',1,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2022-12-23 13:05:09','2022-12-23 13:05:09'),
(14,141,'Why An FAQ Resource??',12,2,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/pexels-pixabay-221164.jpg','<p>Firstly, FAQ pages can bring new visitors to your website via&#160;<a href=\"https://www.searchenginejournal.com/multiple-page-1-google-rankings/301063/\">organic search</a>&#160;and drive them quickly to related pages &#8211; most typically deeper blog pages and service pages closely related to the questions being resolved.</p><p>Next, one of the most significant opportunities for impactful brand visibility within the search engine result pages (in-SERP) is targeting audience questions, wants, needs, and pain points.</p><p>The FAQ page is one of the best ways to help people visit your site and&#160;<a href=\"https://www.searchenginejournal.com/featured-snippets-optimization/410622/\">get snippets</a>&#160;of answers in front of users before they click any results within the search pages.</p><p>A helpful FAQ page (more likely an FAQ hub of core pages and topical intent) shortens the time it takes for people to solve their search requirements.</p>','8',1,1,NULL,NULL,0,NULL,NULL,1,1,'2023-03-17 05:59:50','2023-08-04 17:48:45'),
(15,2830,'Wo finde ich ein Antragsformular?',13,1,NULL,'<font face=\"Arial\" size=\"2\">In den Dokumenten</font>','32',1,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2023-03-20 09:26:25','2023-03-20 09:26:25'),
(16,2830,'Wann findet die Abrechnung statt?',13,2,NULL,'<font face=\"Arial\" size=\"2\">Immer am 01. Januar</font>','32',1,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2023-03-20 09:26:53','2023-03-20 09:26:53'),
(17,2830,'Wo steht der Rasenmäher?',14,1,NULL,'<font color=\"#414141\" face=\"Arial\" size=\"2\"><span>Im Ger&#228;teschuppen</span></font>','32',1,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2023-03-20 09:29:18','2023-03-20 09:29:18'),
(18,2830,'Wo sind die Ballnetze?',14,2,NULL,'<span>Ballnetze sind in der Garage.</span>','32',1,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2023-03-20 09:30:32','2023-03-20 09:30:32'),
(19,141,'Sport pertains to any form of physical activity or game',15,1,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/pexels-patrick-case-3800517.jpg','<b>Sport</b><span>&#160;pertains to any form of&#160;</span><a href=\"https://en.wikipedia.org/wiki/Physical_activity\" title=\"Physical activity\">physical activity</a><span>&#160;or&#160;</span><a href=\"https://en.wikipedia.org/wiki/Game\" title=\"Game\">game</a><span>,</span><sup class=\"reference\"><a href=\"https://en.wikipedia.org/wiki/Sport#cite_note-sportaccord-1\">[1]</a></sup><span>&#160;often&#160;</span><a href=\"https://en.wikipedia.org/wiki/Competition\" title=\"Competition\">competitive</a><span>&#160;and&#160;</span><a href=\"https://en.wikipedia.org/wiki/Organization\" title=\"Organization\">organized</a><span>, that aims to use, maintain, or improve physical ability and&#160;</span><a href=\"https://en.wikipedia.org/wiki/Skill\" title=\"Skill\">skills</a><span>&#160;while providing enjoyment to participants and, in some cases,&#160;</span><a href=\"https://en.wikipedia.org/wiki/Entertainment\" title=\"Entertainment\">entertainment</a><span>&#160;to spectators.</span><sup class=\"reference\"><a href=\"https://en.wikipedia.org/wiki/Sport#cite_note-council-2\">[2]</a></sup><span>&#160;Sports can, through casual or organized participation, improve participants\' physical health. Hundreds of sports exist, from those between single contestants, through to those with hundreds of simultaneous participants, either in&#160;</span><a href=\"https://en.wikipedia.org/wiki/Team\" title=\"Team\">teams</a><span>&#160;or competing as individuals. In certain sports such as&#160;</span><a href=\"https://en.wikipedia.org/wiki/Racing\" title=\"Racing\">racing</a><span>, many contestants may compete, simultaneously or consecutively, with one winner; in others, the contest (a&#160;</span><i>match</i><span>) is between two sides, each attempting to exceed the other. Some sports allow a &#34;tie&#34; or &#34;draw&#34;, in which there is no single winner; others provide&#160;</span><a href=\"https://en.wikipedia.org/wiki/Tie-breaking_methods\" class=\"mw-redirect\" title=\"Tie-breaking methods\">tie-breaking methods</a><span>&#160;to ensure one winner and one loser. A number of contests may be arranged in a&#160;</span><a href=\"https://en.wikipedia.org/wiki/Tournament\" title=\"Tournament\">tournament</a><span>&#160;producing a&#160;</span><a href=\"https://en.wikipedia.org/wiki/Champion\" title=\"Champion\">champion</a><span>. Many&#160;</span><a href=\"https://en.wikipedia.org/wiki/Sports_league\" title=\"Sports league\">sports leagues</a><span>&#160;make an annual champion by arranging games in a regular&#160;</span><a href=\"https://en.wikipedia.org/wiki/Sports_season\" class=\"mw-redirect\" title=\"Sports season\">sports season</a><span>, followed in some cases by&#160;</span><a href=\"https://en.wikipedia.org/wiki/Playoffs\" title=\"Playoffs\">playoffs</a><span>.</span>','1',1,NULL,NULL,NULL,NULL,NULL,NULL,0,1,'2023-06-12 07:02:49','2023-08-04 17:48:45'),
(20,141,'IST FE admin FAQ',12,4,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/pexels-pixabay-416831.jpg','<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>','1',1,NULL,NULL,NULL,NULL,NULL,NULL,0,0,'2023-08-08 12:13:13','2023-08-08 12:13:13');

--
-- Table structure for table `faq_category`
--

CREATE TABLE `faq_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `team_id` int(11) DEFAULT NULL,
  `category_title` varchar(255) DEFAULT NULL,
  `category_description` text DEFAULT NULL,
  `category_position` 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_approved_status` tinyint(4) DEFAULT NULL,
  `deny_reason` text DEFAULT NULL,
  `deny_by_id` int(11) DEFAULT NULL,
  `createdAt` timestamp NOT NULL DEFAULT current_timestamp(),
  `modifiedAt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `faq_category`
--

INSERT INTO `faq_category` VALUES
(11,141,'Club Events',NULL,2,'1',1,NULL,0,NULL,NULL,NULL,NULL,'2022-12-23 13:03:18','2022-12-23 13:03:18'),
(12,141,'Ask Me Anything',NULL,1,'1',1,NULL,0,NULL,NULL,NULL,NULL,'2023-03-17 05:55:11','2023-03-17 05:55:11'),
(13,2830,'Mitgliedschaft',NULL,1,'32',1,NULL,0,NULL,NULL,NULL,NULL,'2023-03-20 09:25:33','2023-03-20 09:25:33'),
(14,2830,'Wartung und Pflege',NULL,2,'32',1,NULL,0,NULL,NULL,NULL,NULL,'2023-03-20 09:25:45','2023-03-20 09:25:45'),
(15,141,'Sports',NULL,3,'1',1,NULL,0,NULL,NULL,NULL,NULL,'2023-06-12 07:00:49','2023-06-12 07:00:49');

--
-- Table structure for table `faq_image`
--

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

--
-- Dumping data for table `faq_image`
--

INSERT INTO `faq_image` VALUES
(1,19,'[BLOB]','','2023-08-04 17:48:45',NULL),
(2,14,'[BLOB]','','2023-08-04 17:48:45','2023-08-04 17:48:45'),
(3,20,'[BLOB]','','2023-08-08 12:13:13',NULL);

--
-- Table structure for table `group_image`
--

CREATE TABLE `group_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `group_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=15 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `group_image`
--

INSERT INTO `group_image` VALUES
(1,17,'[BLOB]','2023-08-07 05:41:53',NULL),
(2,16,'[BLOB]','2023-08-07 05:41:53',NULL),
(3,15,'[BLOB]','2023-08-07 05:41:53',NULL),
(4,14,'[BLOB]','2023-08-07 05:41:53',NULL),
(5,13,'[BLOB]','2023-08-07 05:41:54',NULL),
(6,12,'[BLOB]','2023-08-07 05:41:54',NULL),
(7,11,'[BLOB]','2023-08-07 05:42:27',NULL),
(8,8,'[BLOB]','2023-08-07 05:42:27',NULL),
(9,7,'[BLOB]