-- Table structure for table `customer_departments`
--

CREATE TABLE `customer_departments` (
  `id` int(10) UNSIGNED NOT NULL,
  `customer_id` int(11) NOT NULL,
  `department_name` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `customer_departments`
--

INSERT INTO `customer_departments` (`id`, `customer_id`, `department_name`, `created_at`) VALUES
(13, 11871, 'Accounts and Admin', '2023-08-10 05:30:29'),
(14, 11871, 'Back-office', '2023-08-10 05:37:40'),
(15, 11873, 'Tennis Ball', '2023-08-14 08:18:21'),
(16, 11873, 'MBA', '2023-08-14 08:20:50'),
(17, 1, 'software engineers', '2023-09-20 10:29:28'),
(18, 1, 'Fussball', '2023-10-16 11:54:38'),
(19, 41573, 'Food', '2024-03-19 07:43:40'),
(20, 41573, 'Sport', '2024-03-19 07:43:52'),
(21, 41573, 'Home', '2024-03-19 07:44:03'),
(22, 41573, 'Life style', '2024-03-19 07:44:12'),
(23, 41597, 'Marketing Department', '2024-05-07 05:18:21'),
(24, 41597, 'sports', '2024-05-07 05:18:29'),
(25, 41597, 'production', '2024-05-07 05:18:38'),
(26, 41598, 'computer', '2024-05-07 09:14:17'),
(27, 41598, 'MCA', '2024-05-07 09:14:46'),
(28, 41599, 'MCA', '2024-05-07 10:30:29'),
(29, 41599, 'BCA', '2024-05-07 10:30:35'),
(30, 41600, 'BCAA', '2024-05-07 10:43:15'),
(31, 41600, 'design', '2024-05-07 10:43:29'),
(32, 41602, 'BCAA', '2024-05-07 12:06:30'),
(33, 41602, 'Marketing Department', '2024-05-07 12:06:40'),
(34, 41603, 'Computer', '2024-05-07 12:30:09'),
(35, 41585, 'BCA\r\n', '2024-05-27 12:53:43'),
(39, 41591, 'test', '2024-06-27 12:30:00'),
(40, 41591, 'Marketing Department', '2024-06-27 12:30:05'),
(41, 41591, 'Computer', '2024-06-27 12:30:11'),
(42, 41585, 'computer', '2024-07-02 05:18:38'),
(43, 41585, 'Marketing', '2024-07-02 05:25:49');

-- --------------------------------------------------------

--
-- Table structure for table `customer_members`
--

CREATE TABLE `customer_members` (
  `id` int(10) UNSIGNED NOT NULL,
  `salutation` varchar(32) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `firstname` varchar(255) DEFAULT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `responsible_person` varchar(255) DEFAULT NULL,
  `gender` varchar(32) NOT NULL,
  `birth_date` varchar(32) DEFAULT NULL,
  `established_date` varchar(32) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `email` varchar(254) NOT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `city` varchar(64) DEFAULT NULL,
  `zipcode` varchar(255) DEFAULT NULL,
  `street` text DEFAULT NULL,
  `image` varchar(500) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `type` longtext DEFAULT NULL,
  `functionClub` varchar(64) DEFAULT NULL,
  `department` longtext DEFAULT NULL,
  `department_entry_date` varchar(64) DEFAULT NULL,
  `club_entry_date` varchar(64) DEFAULT NULL,
  `club_exit_date` varchar(64) DEFAULT NULL,
  `reason_for_exit` longtext DEFAULT NULL,
  `notes` longtext DEFAULT NULL,
  `app_in_use` varchar(20) NOT NULL,
  `payment_type` varchar(255) DEFAULT NULL,
  `tags` varchar(500) DEFAULT NULL,
  `is_converted` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `customer_members`
--

INSERT INTO `customer_members` (`id`, `salutation`, `customer_id`, `firstname`, `lastname`, `company_name`, `responsible_person`, `gender`, `birth_date`, `established_date`, `age`, `email`, `mobile`, `phone`, `city`, `zipcode`, `street`, `image`, `status`, `type`, `functionClub`, `department`, `department_entry_date`, `club_entry_date`, `club_exit_date`, `reason_for_exit`, `notes`, `app_in_use`, `payment_type`, `tags`, `is_converted`, `created_at`) VALUES
(9, 'Company', 11871, '', '', 'Armstrong and Collins Traders', 'teswt', 'diver', '', NULL, NULL, 'test@mail.com', '', '45244254245', 'asas', '123456', 'asas', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/logo1.jpeg', 1, '[1]', '[9]', '[14,13]', '2023-08-26', '2023-08-12', '', '', '', 'yes', 'Bar', '[]', 1, '2023-08-10 10:16:28'),
(10, 'Company', 11871, '', '', 'MangoIt', 'Test', 'diver', '', NULL, NULL, 'test@mail.com', '', '85296374444', 'INdore', '44569', 'xyz street', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/dummy-logo.jpeg', 1, '[1]', '[9]', '[14,13]', '2023-08-26', '2023-08-11', '', '', '', 'yes', 'Keine', '[]', 1, '2023-08-10 10:27:38'),
(11, 'Mr', 11871, 'Savannah', 'Elliott', '', '', 'male', '1989-02-02', NULL, 34, 'test11@gmail.com', '', '96321555124', 'Indore', '123456', 'xyz sttrer', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/profile2.png', 1, '[0]', '[9]', '[14]', '2023-08-31', '2023-08-11', '', '', '', '', 'Keine', '[]', 1, '2023-08-10 10:33:55'),
(12, 'Mr', 11871, 'Zoe', 'Stokes', '', '', 'male', '1992-02-10', NULL, 31, 'vfdv@gmail.com', '', '532587573758', 'Ottawa', '44569', 'xyuz street', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/logo3.png', 1, '[0]', '[9]', '[14,13]', '2023-08-31', '2023-08-25', '', '', '', 'yes', 'Keine', '[]', 1, '2023-08-10 11:16:19'),
(14, 'Mr', 11873, 'Tarun', 'Kumar', '', '', 'male', '0986-03-29', NULL, 1038, 'emile001@yopmail.com', '', '9876543210', 'Indore', '452002', 'Old Palasia', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/hd-png.png', 1, '[0]', '[10]', '[16]', '2023-08-15', '2023-08-10', '', 'test', 'test', '', 'Keine', '[]', 0, '2023-08-14 08:46:17'),
(15, 'Mrs', 1, 'meave', 'milbern', '', '', 'female', '2000-04-07', NULL, 23, 'meave121@mailinator.com', '5425458745', '82558250252', 'indore', '452003', 'chandralok', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/September/Images/ball_smile_happy_123773_1024x768.jpg', 1, '[0]', '[12]', '[17]', '2023-09-20', '2023-09-20', '2023-09-30', '<strong>Lorem Ipsum</strong><span>&#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 containi</span>', '<strong>Lorem Ipsum</strong><span>&#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 containi</span>', 'yes', 'Keine', '[8,7,9]', 0, '2023-09-20 10:33:31'),
(16, 'Mr', 1, 'Chaster', 'Benington', '', '', 'male', '2023-11-03', NULL, 0, 'chaster@mailinator.com', '', '4545424242', 'Munich', '452296', '12/3 street', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/November/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009.38.40.png', 1, '[0]', '[13,12]', '[18,17]', '2023-11-12', '2023-11-08', '', '', '', 'yes', 'Keine', '[5,10]', 0, '2023-11-03 10:32:53'),
(17, 'Company', 1, '', '', 'mangoit', 'manish', 'male', '', NULL, NULL, 'manish.mangoit@gmail.com', '', '82558250252', 'indore', '452003', 'Indore', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/November/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009.38.40.png', 1, '[0,2,1]', '[13,12]', '[18,17]', '2023-11-30', '2023-11-04', '', '', '', '', 'Keine', '[10,9,8,7]', 0, '2023-11-04 11:21:49'),
(18, 'Company', 1, '', '', 'mangoit', 'Manish', 'male', '', NULL, NULL, 'manish.mangoit@gmail.com', '', '82558250252', 'indore', '452003', 'Indore', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/November/Images/honda_cbr_fireblade_99463_1024x768.jpg', 1, '[0,1,2]', '[13,12]', '[18,17]', '2023-11-05', '2023-11-04', '', '', '', '', 'Keine', '[10,10,10,10,9,7,12]', 0, '2023-11-04 11:44:52'),
(19, 'Company', 1, '', '', 'mangoit', 'Manish', 'male', '', NULL, NULL, 'manish.mangoit@gmail.com', '5425458745', '82558250252', 'indore', '452003', 'Indore', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/November/Images/camera_retro_old_419273_1024x768.jpg', 1, '[0,1,2]', '[13,12]', '[18,17]', '2023-11-05', '2023-11-04', '2023-11-04', '', '', '', 'Keine', '[10,10,9,8,7,13,14,15]', 0, '2023-11-04 12:09:21'),
(20, 'Mr', 41573, 'dev', 'mind', '', '', 'male', '2010-01-01', NULL, 14, 'devmind@yopmail.com', '4234234', '423423423423', 'dhaka', '4234', '423', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/March/Images/DevMind.png', 1, '[0]', '[17,16]', '[21,20]', '2024-03-25', '2024-03-01', '', '', '', 'no', 'Lastschrift', '[16]', 0, '2024-03-27 19:53:34');

-- --------------------------------------------------------

--
-- Table structure for table `customer_members_image`
--

CREATE TABLE `customer_members_image` (
  `id` int(11) NOT NULL,
  `customer_members_id` int(11) NOT NULL,
  `customer_members_image` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `customer_members_image`
--

INSERT INTO `customer_members_image` (`id`, `customer_members_id`, `customer_members_image`, `created_at`, `updated_at`) VALUES
(1, 12, '[encoded data, 5512 characters]', '2023-08-10 11:16:19', '2023-08-10 13:29:35'),
(3, 11, '[encoded data, 16940 characters]', '2023-08-10 12:33:14', NULL),
(4, 10, 'KTYyeBnu6zsRKADIuGeY/9j/2wBDAAYEBQYFBAYGBQYHBwYIChAKCgkJChQODwwQFxQYGBcUFhYaHSUfGhsjHBYWICwgIyYnKSopGR8tMC0oMCUoKSj/2wBDAQcHBwoIChMKChMoGhYaKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCj/wAARCADOAPUDASIAAhEBAxEB/8QAHAABAAEFAQEAAAAAAAAAAAAAAAcCBAUGCAED/8QAQhAAAQMCAgUHCAcIAwEAAAAAAAECAwQFBhIRIjFBUQcTFCEyYXEVIyQzUmKBkRY0QkOxweEXJVaUodLw8VNjc5L/xAAaAQEAAwEBAQAAAAAAAAAAAAAAAgQFAwEG/8QAJREBAAICAgICAgIDAAAAAAAAAAECAxIEERMxISIFQTJCFFFh/9oADAMBAAIRAxEAPwDpwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAt6+thoKKepq35IIm5nP/wA3lwWF/trLvZ6q3yPyc+3K1/BUXS1fmiBG/es9e2lVXKdCj/RLbM+P2pZkYvyRF/E8g5ToVd6Rapmf+UyO/oqIRvV001HVT01S3JNG5WOb3ofE6dQwJ52fb2nC0Yzs91ljhjqOanf2Yp25VXuRdir3aTYzmwknk+xY+VWWm5PzvX6tK/avuqu9eC/DgeTRd4vP3nTIkhr9LioxjKjzpkmLnaQaj0Ai3EPK/SWu81dFSW19eyB+TpDKhGI5U7WhMq9SLpTTv0E6Y5v/ABeTeK+0pAhz9t0X8PP/AJxP7B+26L+Hn/zif2HT/Hyf6Q81Exgim0csVNW18ENTZ300csmTnekI/L1aXO0ZU6kTb4pxJWRdLeo42pNJ6l7TJS/oAB4mGrYlx5h7D0j4a6s56qZ2qenbnenjuaviqGp8s+NprTHHZrPNkrp256mVnahjXYiLuc7jtRPFFIILeDjbx3Lhkza/EJtq+W6javolkqXx/wDbUNYvyRHfiX1l5ZrPV1DIbpQVNBm+9zJMxvjo0KnwRTn6R+gv7Bbam+XaltlAzPPO7I3gnFy9yJpVfAsW42PVy8l3YMb2PZG9j87HazXN60VNylRbWuiZbrXSUUL88dNCyBrnbVRrUan4FyZi4AAAAAAAAAAAAAAAAj3lSw/z8HlmlZ5yJuWp95m53w/DwIuOkZGMlZIx7M7Harmu60VOBBmM7E+w3iSFn1SXXgf3cPFNnyXedKSxfyHG1nyV/ftgT1j3sfnZqPbrNfvRdx4CbLSdYb75RoI5n+vbqy+PHwU3O01XPMIMtVc+gqs6erdquZ7SEh2fEFNQUk9bWTZKSBudz9vV3cVOc1+X0PC5Hkx/b3D6cr2LPo5Yei0b8l1rmqyLJtjZ9p/juTvXTuOcdhlsV32pxJfaq51epzrssbdqRxp2Wp4J/VVXeYk0+Pj8dHmS+8hXGznH5E/+9zU3qvdoKCurZzdHzKduXWd7rNqJ8dvyJZL6R243vrC8wr6bdautb6iKPmIO5FXSq+K6NK/oT9yX4h6VSeSap/noG6YOvtx8PFv4eBC2GaXotsj952YztBVzUFbBU0r8k8Tszf17t3xM232UacmceXZ0WYbF1/psNWGquVTr83qxxb5JF7Lf82IiruLmw3SG82qCtp+xK3WbvYqbUXwU595W8W/STEHRqR+e1ULlZFwkfsc/8k7k07xhxb36btskabR+2nXKuqblcJ6yufnqp3K+R/FV/BN2juLR7tDSotq6TIw1f4qi2lk1zozkNwh5Hs3lmvZ+8a5vmmP2xQbUTuV3Uq92ginkWwh9K8R9KrWfuqhcj5+Ej/ss/Ne5O86oKPJzf0qsYqfPYACksAAAAAAAAAAAAAAAABg8YWNl+s0lN9+3Xhfwfw8F2f6M4eOUIXpF41lzhLG+GR7JGZHtcrXMftRU6lRSgkLlRsXNTeWaVnm3aGVPursa747F+HEj07Vnt81nwzhvNJDA44qqxlqgZG/0Fsnn2b/c092nT8VQzxRUQsqKeSGdmdkrVa5nFFJ1nWezDknFbto7FzszoVHxqaSpsckkNUx76H7qoY3Smjg7RsU+9uTyi/JRee99mxvipoRlia9tXeOu/wBM3g+xPvt4ZC31DdeV/sofW+2aagvE9LVa8mbNn9tF2KTbgPCrMO2KOGT63Przv36dzfgfDHeG2XSg6TSs9OptZvF7N7fzT9TPzZt7/wDDNx5tj3/aLqdnNwsY0rAIsVdJe7lbbDdaO2vydMjyu4p7St4KrdKf6Qjw3k1y9W18cr5oGZ2O1nMb1q34cCzx7xX4XuLn/pZiSz6HU3m90tptzM9XO5GNZw0717g+t5x/M0TH1M/sRNVfnw+JOXIJgd9pgff7sxj7lVakW9I2b9Hjs0/odM+aIj6r9I2npJOCsOU2FMO0tppPum5pH75JF7TlM6eNPTLX6xrHQAA9AAAAAAAAAAAAAAAADxyHoAs6ynZVQSQzszwStVjmcUUgvEdpmsl1nopNePtRP9ti7F/LxQn5zdJrGPMPeWbRnp2enQaXxd/Fvx/FCVZUudx/LTaPcIVAB1fPBnsKwsSs6bUerg7LOL9y/AwPiVvunNsyR+raQvZocDj+W29vUJOdiD3wy/63bIoW7Pzdsrjurzm3mbxLSsjrulU/qJ9bwfvT8zDl4yv6RDkk+0Wrk0KdKywOdx/FfavqVIB6xj3vYxjM73arWM61VdyE1GGZwpZn327MptfmG687/ZZw8V2f6Jxp4WRxRsjZkY1qNaxmxqJsQw2DLAyxWeOGT61Lrzv79yeCbPnxNhOVp2fQcLj+Gn29y8RD0AiugAAAAAAAAAAAAAAAAAAAAAF7IAEO8oVk6LcpK2nZkjldmlZwXeqdymlukYidb2HSNRTw1DMk8LHx++3SYd2ErCr86W2FknuN0E92dl/HUvfaJ6QA5Jqp3mWPyFzDYqyb7DyfI8OWqPsUzC7ittHH2IWEF7FjjFGkIBbhapX7Dyl+G6ln2DobosP/AAsPnLQU0m2FgTc6y26pg2sLfpPNu88dC1GHaCbtwmOnwPZ5/WQhzyY4y00lCTHsemo/OSDyb2DNWsuFYz1XqGcF9pfyNlpuTzDcE3PdDzyN9txtNJSw0keSnhYyMnN1PDwKYr9zPb7AAg0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAH/9k=', '2023-08-10 12:33:14', NULL),
(5, 9, '[encoded data, 4372 characters]', '2023-08-10 12:33:15', NULL);
INSERT INTO `customer_members_image` (`id`, `customer_members_id`, `customer_members_image`, `created_at`, `updated_at`) VALUES
(6, 14, '[encoded data, 484071 characters]