--
-- Host: localhost    Database: tineon
-- ------------------------------------------------------


--
-- Table structure for table `appointment`
--

CREATE TABLE `appointment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `appointment_type` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp(),
  `organizer_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `appointment`
--


--
-- Table structure for table `appointment_groups`
--

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

--
-- Dumping data for table `appointment_groups`
--


--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bannerName` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `bannerStartDate` datetime NOT NULL,
  `bannerEndDate` datetime NOT NULL,
  `image` varchar(500) DEFAULT NULL,
  `redirectLink` varchar(500) NOT NULL,
  `status` int(11) NOT NULL,
  `invoice` int(11) NOT NULL,
  `category` varchar(255) NOT NULL,
  `placement` varchar(255) NOT NULL,
  `display` varchar(255) NOT NULL,
  `author` int(11) NOT NULL,
  `team_id` int(11) NOT NULL,
  `is_image_converted` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` VALUES
(2,'LOEV YOUR FUTURE','<ul class=\"i8Z77e\"><li class=\"TrT0Xe\">Electric cars can travel less distance. AEVs on average have a shorter range than gas-powered cars. ...</li><li class=\"TrT0Xe\">Electric cars can take a long time to recharge. Fueling an all-electric car can also be an issue. ...</li><li class=\"TrT0Xe\">Electric cars can be expensive</li></ul>','2023-02-28 00:00:00','2023-03-10 00:00:00','\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/WhatsApp%20Image%202023-02-20%20at%2013.46.46.jpeg\"','https://www.google.com/',0,2,'[\"1\"]','[\"1\",\"2\",\"3\",\"4\",\"5\"]','[\"4\"]',1,141,1,'2023-02-28 04:32:51','2023-08-07 05:41:38'),
(3,'Vinyl Banners','<p><a href=\"https://www.signsbytomorrow.com/vinyl-banners\">Vinyl banners</a>&#160;are an old standby, and for good reason. It&#8217;s hard to argue with the durability of their material; they can be used both indoors and outdoors, and they are tear-resistant.</p><p><br></p>','2023-03-17 00:00:00','2023-03-22 00:00:00','\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/HealthInsurance.png\"','https://www.signsbytomorrow.com/blog/what-are-the-different-types-of-banners',0,2,'[\"1\",\"2\",\"3\"]','[\"1\",\"2\",\"3\",\"4\",\"5\"]','[\"4\"]',1,141,1,'2023-03-17 09:35:36','2023-08-07 05:41:38'),
(4,'Chassis on the wheels','<span>The chassis must be strong enough to bear the weight of the car, yet somewhat flexible in order to sustain the shocks and tension caused by turning and road conditions.&#160;</span><span>Attached to the chassis are the wheels and steering assembly, the suspension, the brakes, and the body</span><span>.</span>','2023-03-20 00:00:00','2023-04-02 00:00:00','\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/pexels-cottonbro-studio-7019607.jpg\"','https://www.google.com/',0,1,'[\"1\"]','[\"1\",\"2\",\"3\",\"4\",\"5\"]','[\"2\"]',1,141,1,'2023-03-20 06:27:48','2023-08-07 05:41:38'),
(5,'Zahnzusatz','<h2>Zahnzusatzversicherung von AXA</h2><h1><span class=\"teaser-product-title\">Falls Sie sich mal die F&#252;llung rausziehen.</span></h1>','2023-05-07 00:00:00','2024-03-07 00:00:00','\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/May/Documents/Bildschirmfoto%202023-05-07%20um%2019.02.06.png\"','www.axa-betreuer.de/claus_decker/landingpages/regional/',0,0,'[\"1\"]','[\"1\"]','[\"4\"]',33,2684,1,'2023-05-07 17:04:23','2023-08-07 05:41:38'),
(6,'Continental','<font face=\"Arial\" size=\"2\">DFB-Sponsor Continental</font>','2023-06-21 00:00:00','2023-06-30 00:00:00','\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/Bannertest_1.png\"','https://www.continental-reifen.de/',0,0,'[\"2\"]','[\"1\",\"2\",\"3\",\"4\",\"5\"]','[\"4\"]',43,2661,1,'2023-06-21 10:11:30','2023-08-07 05:41:38'),
(7,'IST FE admin banner','<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>','2023-08-08 00:00:00','2023-08-11 00:00:00','\"https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/pexels-valentin-perret-1209890.jpg\"','https://www.lipsum.com/',0,1,'[\"3\"]','[\"1\",\"3\",\"5\",\"2\",\"4\"]','[\"4\"]',1,141,0,'2023-08-08 12:22:51','2023-08-08 12:22:51');

--
-- Table structure for table `banner_image`
--

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

--
-- Dumping data for table `banner_image`
--

INSERT INTO `banner_image` VALUES
(1,6,'[BLOB]','2023-08-07 05:41:38','2023-08-07 05:41:38'),
(2,5,'[BLOB]','2023-08-07 05:41:38','2023-08-07 05:41:38'),
(3,4,'[BLOB]','2023-08-07 05:41:38','2023-08-07 05:41:38'),
(4,3,'[BLOB]','2023-08-07 05:41:38','2023-08-07 05:41:38'),
(5,2,'[BLOB]','2023-08-07 05:41:38','2023-08-07 05:41:38'),
(6,7,'[BLOB]','2023-08-08 12:22:51','2023-08-08 12:22:51');

--
-- Table structure for table `banner_statistics`
--

CREATE TABLE `banner_statistics` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `banner_id` int(11) NOT NULL,
  `gender` varchar(20) NOT NULL,
  `display_mode` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `banner_statistics`
--

INSERT INTO `banner_statistics` VALUES
(1,1,2,'M',1,1,'2023-02-28 05:20:46','2023-02-28 05:20:46'),
(2,1,2,'M',0,1,'2023-02-28 05:50:14','2023-02-28 05:50:14'),
(3,8,3,'U',0,5,'2023-03-20 06:25:28','2023-03-20 06:37:08'),
(4,1,3,'M',0,1,'2023-03-20 06:28:27','2023-03-20 06:28:27'),
(5,1,4,'M',0,3,'2023-03-20 06:30:23','2023-03-23 04:42:56'),
(6,9,3,'U',0,1,'2023-03-20 08:16:05','2023-03-20 08:16:05'),
(7,8,4,'U',0,2,'2023-03-20 08:32:34','2023-03-20 08:33:45'),
(8,33,5,'U',0,6,'2023-05-07 18:34:39','2023-06-19 13:05:54'),
(9,34,5,'U',0,1,'2023-06-12 13:49:58','2023-06-12 13:49:58'),
(10,43,6,'M',0,2,'2023-06-21 10:11:46','2023-06-21 17:14:34'),
(11,31,6,'U',0,3,'2023-06-21 10:43:20','2023-06-21 11:08:02'),
(12,44,6,'M',1,1,'2023-06-26 08:27:15','2023-06-26 08:27:15');

--
-- Table structure for table `birthdays`
--

CREATE TABLE `birthdays` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `created_by` varchar(255) NOT NULL,
  `updated_by` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `appointment_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `birthdays`
--


--
-- Table structure for table `chat`
--

CREATE TABLE `chat` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `room_id` varchar(600) DEFAULT NULL,
  `message` text DEFAULT NULL,
  `sender_id` varchar(255) DEFAULT NULL,
  `receiver_id` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `chat`
--

INSERT INTO `chat` VALUES
(1,'1,6','{\"message\":\"fdgf\",\"timestamp\":1665117212170,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-07 04:33:32'),
(2,'1,6','{\"message\":\"server\",\"timestamp\":1665117850456,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-07 04:44:10'),
(3,'1,6','{\"message\":\"hel\",\"timestamp\":1665119175892,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-07 05:06:15'),
(4,'1,6','{\"message\":\"hiii Aditya\",\"timestamp\":1665120943867,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-07 05:35:43'),
(5,'1,6','{\"message\":\"ewfasdfasd\",\"timestamp\":1665120989402,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-07 05:36:29'),
(6,'1,6','{\"message\":\"what are you doing\",\"timestamp\":1665121037477,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-07 05:37:17'),
(7,'1,6','{\"message\":\"wow\",\"timestamp\":1665121059450,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-07 05:37:39'),
(8,'1,6','{\"message\":\"superb\",\"timestamp\":1665121067463,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-07 05:37:47'),
(9,'1,6','{\"message\":\"h\",\"timestamp\":1666254099082,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-20 08:21:39'),
(10,'1,6','{\"message\":\"hgfh hh ghg gh efr\",\"timestamp\":1666254117990,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-20 08:21:57'),
(11,'1,6','{\"message\":\"Hallo Tarun, check if chat is working.\",\"timestamp\":1666778039106,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-10-26 09:53:59'),
(12,'1,6','{\"message\":\"Hi\",\"timestamp\":1669094062173,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2022-11-22 05:14:22'),
(13,'8,9','{\"message\":\"test editor\",\"timestamp\":1670998307868,\"senderUid\":\"8\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','8','9','2022-12-14 06:11:47'),
(14,'1,7','{\"message\":\"Hello\",\"timestamp\":1672088831267,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','7','2022-12-26 21:07:11'),
(15,'1,8','{\"message\":\"Hii Good morning ,\\nHow are doing?\",\"timestamp\":1672203081089,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','8','2022-12-28 04:51:21'),
(16,'1,8','{\"message\":\"Heyy\",\"timestamp\":1672203176808,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','8','2022-12-28 04:52:56'),
(17,'21,22','{\"message\":\"Salü\",\"timestamp\":1674811744986,\"senderUid\":\"21\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','21','22','2023-01-27 09:29:04'),
(18,'21,22','{\"message\":\"Hi\",\"timestamp\":1674811772145,\"senderUid\":\"22\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','22','21','2023-01-27 09:29:32'),
(19,'21,22','{\"message\":\"https://firebasestorage.googleapis.com/v0/b/friendlychat-97fd3.appspot.com/o/21%2F22%2F23_01_verein_cloud_produktwelt.png?alt=media&token=123123123123\",\"timestamp\":1674811822356,\"senderUid\":\"21\",\"read\":true,\"readers\":[],\"messageType\":\"image\"}','21','22','2023-01-27 09:30:22'),
(20,'21,22','{\"message\":\"Bild kam an\",\"timestamp\":1674811860171,\"senderUid\":\"22\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','22','21','2023-01-27 09:31:00'),
(21,'21,22','{\"message\":\"des isch ja huralässig\",\"timestamp\":1674812028513,\"senderUid\":\"21\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','21','22','2023-01-27 09:33:48'),
(22,'1,8','{\"message\":\"hello\",\"timestamp\":1674825915750,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-01-27 13:25:15'),
(23,'1,6','{\"message\":\"Hello Helge how are you\\n\",\"timestamp\":1674825944299,\"senderUid\":\"6\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-01-27 13:25:44'),
(24,'1,7','{\"message\":\"Fine\",\"timestamp\":1674825962875,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','7','2023-01-27 13:26:02'),
(25,'1,8','{\"message\":\"yes\",\"timestamp\":1674825969542,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-01-27 13:26:09'),
(26,'1,6','{\"message\":\"Hyyyyy\",\"timestamp\":1674825995036,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-01-27 13:26:35'),
(27,'1,8','{\"message\":\"hey \",\"timestamp\":1674826002074,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-01-27 13:26:42'),
(28,'1,6','{\"message\":\"Hello tarun\",\"timestamp\":1674827331438,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-01-27 13:48:51'),
(29,'1,6','{\"message\":\"hello\",\"timestamp\":1674827592272,\"senderUid\":\"6\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-01-27 13:53:12'),
(30,'1,6','{\"message\":\"hyyy\",\"timestamp\":1674827694344,\"senderUid\":\"6\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-01-27 13:54:54'),
(31,'1,8','{\"message\":\"ji\",\"timestamp\":1675330763653,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-02-02 09:39:23'),
(32,'1,8','{\"message\":\"hii\",\"timestamp\":1675330801045,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','8','2023-02-02 09:40:01'),
(33,'1,8','{\"message\":\"ko\",\"timestamp\":1675330801411,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-02-02 09:40:01'),
(34,'1,8','{\"message\":\"lo\",\"timestamp\":1675330815110,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-02-02 09:40:15'),
(35,'1,8','{\"message\":\"pop\",\"timestamp\":1675330827542,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-02-02 09:40:27'),
(36,'1,8','{\"message\":\"hii\",\"timestamp\":1675330830617,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','8','2023-02-02 09:40:30'),
(37,'1,8','{\"message\":\"lp\",\"timestamp\":1675330837025,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-02-02 09:40:37'),
(38,'1,8','{\"message\":\"hii\",\"timestamp\":1675330890628,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','8','2023-02-02 09:41:30'),
(39,'1,8','{\"message\":\"lpo\",\"timestamp\":1675330893563,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-02-02 09:41:33'),
(40,'1,8','{\"message\":\"\'\'\'\",\"timestamp\":1675330983734,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-02-02 09:43:03'),
(41,'1,8','{\"message\":\"New message\",\"timestamp\":1675331674909,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-02-02 09:54:34'),
(42,'1,8','{\"message\":\"hello world\",\"timestamp\":1675331690663,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-02-02 09:54:50'),
(43,'1,6','{\"message\":\"hello tarun\",\"timestamp\":1675331794987,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-02-02 09:56:34'),
(44,'1,6','{\"message\":\"hi\",\"timestamp\":1675331823762,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 09:57:03'),
(45,'1,6','{\"message\":\"fine\",\"timestamp\":1675331868350,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-02-02 09:57:48'),
(46,'1,6','{\"message\":\"het\",\"timestamp\":1675331901106,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 09:58:21'),
(47,'1,6','{\"message\":\"one\",\"timestamp\":1675331913229,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 09:58:33'),
(48,'1,8','{\"message\":\"hi\",\"timestamp\":1675331946928,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','8','2023-02-02 09:59:06'),
(49,'1,8','{\"message\":\"Hi helge\",\"timestamp\":1675331971712,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','1','2023-02-02 09:59:31'),
(50,'1,6','{\"message\":\"ji\",\"timestamp\":1675333796401,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 10:29:56'),
(51,'1,6','{\"message\":\"ghf\",\"timestamp\":1675333842396,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 10:30:42'),
(52,'1,6','{\"message\":\"new msg\",\"timestamp\":1675334507705,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 10:41:47'),
(53,'1,6','{\"message\":\"once again\",\"timestamp\":1675334543680,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 10:42:23'),
(54,'1,6','{\"message\":\"let me reply\",\"timestamp\":1675334582569,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 10:43:02'),
(55,'1,6','{\"message\":\"once check\",\"timestamp\":1675334631354,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 10:43:51'),
(56,'1,8','{\"message\":\"hy\",\"timestamp\":1675334729924,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','8','2023-02-02 10:45:29'),
(57,'1,6','{\"message\":\"yes\",\"timestamp\":1675334745723,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 10:45:45'),
(58,'1,6','{\"message\":\"five\",\"timestamp\":1675334824346,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 10:47:04'),
(59,'1,6','{\"message\":\"six\",\"timestamp\":1675334836757,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-02 10:47:16'),
(60,'1,6','{\"message\":\"hyy tarun\",\"timestamp\":1675420649262,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-02-03 10:37:29'),
(61,'1,6','{\"message\":\"I am fine how are you\",\"timestamp\":1675420829404,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:40:29'),
(62,'1,6','{\"message\":\"ok\",\"timestamp\":1675420851296,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-02-03 10:40:51'),
(63,'1,6','{\"message\":\"hii\",\"timestamp\":1675420987554,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-02-03 10:43:07'),
(64,'1,6','{\"message\":\"Where is your message\",\"timestamp\":1675421006392,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:43:26'),
(65,'1,6','{\"message\":\"ok got it\",\"timestamp\":1675421013234,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:43:33'),
(66,'1,6','{\"message\":\"Refresh karna padra h\",\"timestamp\":1675421045224,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-02-03 10:44:05'),
(67,'1,6','{\"message\":\"no actually its taking time\",\"timestamp\":1675421079407,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:44:39'),
(68,'1,6','{\"message\":\"Wait for a while\",\"timestamp\":1675421116623,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:45:16'),
(69,'6,8','{\"message\":\"hi\",\"timestamp\":1675421164442,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 10:46:04'),
(70,'6,8','{\"message\":\"Hi Tarun\",\"timestamp\":1675421177631,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 10:46:17'),
(71,'1,6','{\"message\":\"trail 2\",\"timestamp\":1675421190932,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-02-03 10:46:30'),
(72,'6,8','{\"message\":\"Hello\",\"timestamp\":1675421211749,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:46:51'),
(73,'1,6','{\"message\":\"Ya we have refresh the page\",\"timestamp\":1675421232333,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:47:12'),
(74,'6,8','{\"message\":\"gghhh\",\"timestamp\":1675421245703,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 10:47:25'),
(75,'6,8','{\"message\":\"hyyyyy\",\"timestamp\":1675421258777,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:47:38'),
(76,'6,8','{\"message\":\"How are you\",\"timestamp\":1675421279894,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:47:59'),
(77,'1,6','{\"message\":\"seee the magic\",\"timestamp\":1675421293617,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:48:13'),
(78,'6,8','{\"message\":\"hello are you able to see\",\"timestamp\":1675421317080,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:48:37'),
(79,'6,8','{\"message\":\"Helllo\",\"timestamp\":1675421342496,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:49:02'),
(80,'6,8','{\"message\":\"how are you\",\"timestamp\":1675421352269,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:49:12'),
(81,'6,8','{\"message\":\"fgg\",\"timestamp\":1675421355579,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 10:49:15'),
(82,'6,8','{\"message\":\"hyyyy\",\"timestamp\":1675421368123,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:49:28'),
(83,'6,8','{\"message\":\"hello\",\"timestamp\":1675421385429,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 10:49:45'),
(84,'6,8','{\"message\":\"hyyyyyyyyyyyy\",\"timestamp\":1675421406874,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:50:06'),
(85,'6,8','{\"message\":\"hello tarun\",\"timestamp\":1675421458950,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 10:50:58'),
(86,'1,6','{\"message\":\"hyyyy\",\"timestamp\":1675421470830,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:51:10'),
(87,'1,6','{\"message\":\"hyyyyyyy\",\"timestamp\":1675421491329,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:51:31'),
(88,'1,6','{\"message\":\"helloo helge\",\"timestamp\":1675421525443,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:52:05'),
(89,'1,6','{\"message\":\"hi\",\"timestamp\":1675421537240,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-02-03 10:52:17'),
(90,'1,6','{\"message\":\"hhyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy\",\"timestamp\":1675421548800,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','1','2023-02-03 10:52:28'),
(91,'1,6','{\"message\":\"klklk\",\"timestamp\":1675421566291,\"senderUid\":\"1\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-02-03 10:52:46'),
(92,'6,9','{\"message\":\"test\",\"timestamp\":1675421649471,\"senderUid\":\"9\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','9','6','2023-02-03 10:54:09'),
(93,'6,8','{\"message\":\"hii\",\"timestamp\":1675421650610,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 10:54:10'),
(94,'6,9','{\"message\":\"hyyy\",\"timestamp\":1675421666974,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','9','2023-02-03 10:54:26'),
(95,'6,9','{\"message\":\"hello\",\"timestamp\":1675421689932,\"senderUid\":\"9\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','9','6','2023-02-03 10:54:49'),
(96,'6,9','{\"message\":\"See in taruns \",\"timestamp\":1675421694099,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','9','2023-02-03 10:54:54'),
(97,'6,8','{\"message\":\"helllo\",\"timestamp\":1675421703995,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:55:04'),
(98,'6,9','{\"message\":\"hhhyyy\",\"timestamp\":1675421729119,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','9','2023-02-03 10:55:29'),
(99,'6,8','{\"message\":\"hyy\",\"timestamp\":1675421743372,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:55:43'),
(100,'6,9','{\"message\":\"hyyyyyy\",\"timestamp\":1675421762210,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','9','2023-02-03 10:56:02'),
(101,'6,9','{\"message\":\"join the chat\",\"timestamp\":1675421793545,\"senderUid\":\"9\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','9','6','2023-02-03 10:56:33'),
(102,'6,8','{\"message\":\"join chat\",\"timestamp\":1675421817935,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:56:57'),
(103,'6,9','{\"message\":\"got the same\",\"timestamp\":1675421834400,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','9','2023-02-03 10:57:14'),
(104,'6,9','{\"message\":\"hjk\",\"timestamp\":1675421861829,\"senderUid\":\"9\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','9','6','2023-02-03 10:57:41'),
(105,'6,8','{\"message\":\"kya kare\",\"timestamp\":1675421899932,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 10:58:19'),
(106,'6,9','{\"message\":\"hyyy\",\"timestamp\":1675421900534,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','9','2023-02-03 10:58:20'),
(107,'6,8','{\"message\":\"still not confirmed\",\"timestamp\":1675421931729,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:58:51'),
(108,'6,8','{\"message\":\"some time its working \",\"timestamp\":1675421945011,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:59:05'),
(109,'6,9','{\"message\":\"I think its taking timme\",\"timestamp\":1675421969866,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','9','2023-02-03 10:59:29'),
(110,'6,8','{\"message\":\"this two were recived without reload\",\"timestamp\":1675421975641,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 10:59:35'),
(111,'6,8','{\"message\":\"i think so\",\"timestamp\":1675421989203,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 10:59:49'),
(112,'6,8','{\"message\":\"ask aditya sir to have a look in it\",\"timestamp\":1675422006793,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 11:00:06'),
(113,'6,8','{\"message\":\"Hello sir\",\"timestamp\":1675422063942,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 11:01:03'),
(114,'6,8','{\"message\":\"this should not be done\",\"timestamp\":1675422090491,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 11:01:30'),
(115,'6,8','{\"message\":\"ya we are gonna work on it\",\"timestamp\":1675422111084,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 11:01:51'),
(116,'6,8','{\"message\":\"it should not be account baised\",\"timestamp\":1675422116150,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 11:01:56'),
(117,'6,8','{\"message\":\"this are his comment\",\"timestamp\":1675422134299,\"senderUid\":\"8\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','8','6','2023-02-03 11:02:14'),
(118,'6,8','{\"message\":\"i know that but we are gonna check for the same\",\"timestamp\":1675422153789,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 11:02:33'),
(119,'6,8','{\"message\":\"please login with our sever \",\"timestamp\":1675422165146,\"senderUid\":\"6\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','6','8','2023-02-03 11:02:45'),
(120,'1,6','{\"timestamp\":1676013068054,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"image\",\"message\":\"https://firebasestorage.googleapis.com/v0/b/friendlychat-97fd3.appspot.com/o/1%2F6%2Fpexels-pixabay-261060.jpg?alt=media&token=123123123123\"}','1','6','2023-02-10 07:11:08'),
(121,'21,22','{\"message\":\"Find ich auch…\",\"timestamp\":1676014872866,\"senderUid\":\"22\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','22','21','2023-02-10 07:41:12'),
(122,'1,6','{\"message\":\"test\",\"timestamp\":1677571816342,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-02-28 08:10:16'),
(123,'1,6','{\"message\":\"Test\",\"timestamp\":1678809238850,\"senderUid\":\"1\",\"read\":false,\"readers\":[],\"messageType\":\"text\"}','1','6','2023-03-14 15:53:58'),
(124,'31,32','{\"message\":\"Hallo Steffen, hier das neue Bild aus dem Vereinsheim.\\n\\nViele Grüße\\nMax\",\"timestamp\":1680290010735,\"senderUid\":\"32\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','32','31','2023-03-31 19:13:30'),
(125,'31,32','{\"message\":\"https://firebasestorage.googleapis.com/v0/b/friendlychat-97fd3.appspot.com/o/32%2F31%2FBildschirm­foto 2023-03-18 um 09.38.48.png?alt=media&token=123123123123\",\"timestamp\":1680290033203,\"senderUid\":\"32\",\"read\":true,\"readers\":[],\"messageType\":\"image\"}','32','31','2023-03-31 19:13:53'),
(126,'33,34','{\"message\":\"Hallo Torsten, hast Du die Anwendung schon einmal getestet? \\nBitte um Feedback, was aus Deiner Sicht für eine erste Präsentation bei einem potenziellen Investor darstellbar sein sollte. \\n\\nHG \\n\\nJörn \",\"timestamp\":1686301066671,\"senderUid\":\"33\",\"read\":true,\"readers\":[],\"messageType\":\"text\"}','33','34','2023-06-09 08:57:46');

--
-- Table structure for table `chat_delete`
--

CREATE TABLE `chat_delete` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `room_id` varchar(20) DEFAULT NULL,
  `user_id` varchar(20) DEFAULT NULL,
  `delete_date` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `chat_delete`
--

INSERT INTO `chat_delete` VALUES
(1,'1,6','1','2023-02-02 09:57:33'),
(2,'10,11','11','2023-02-02 09:58:06');

--
-- Table structure for table `club_folder`
--

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

--
-- Dumping data for table `club_folder`
--


--
-- Table structure for table `club_theme_images`
--

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

--
-- Dumping data for table `club_theme_images`
--

INSERT INTO `club_theme_images` VALUES
(1,13,'[BLOB]','2023-08-07 05:06:48','2023-08-07 05:06:48'),
(2,12,'[BLOB]','2023-08-07 05:06:48','2023-08-07 05:06:48'),
(3,11,'[BLOB]','2023-08-07 05:06:48','2023-08-07 05:06:48'),
(4,10,'[BLOB]','2023-08-07 05:06:49','2023-08-07 05:06:49'),
(5,9,'[BLOB]','2023-08-07 05:06:49','2023-08-07 05:06:49'),
(6,8,'[BLOB]','2023-08-07 05:06:49','2023-08-07 05:06:49'),
(7,7,'[BLOB]','2023-08-07 05:06:49','2023-08-07 05:06:49'),
(8,6,'[BLOB]','2023-08-07 05:06:49','2023-08-07 05:06:49'),
(9,5,'[BLOB]','2023-08-07 05:06:49','2023-08-07 05:06:49'),
(10,4,'[BLOB]','2023-08-07 05:06:49','2023-08-07 05:06:49'),
(11,3,'[BLOB]','2023-08-07 05:06:51','2023-08-07 05:06:51'),
(12,2,'[BLOB]','2023-08-07 05:06:51','2023-08-07 05:06:51');

--
