-- Table structure for table `club_info_setting_data`
--

CREATE TABLE `club_info_setting_data` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `clubName` varchar(500) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `postCode` varchar(255) DEFAULT NULL,
  `pobox` text DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `poboxPostcode` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `phone` varchar(500) DEFAULT NULL,
  `poBoxLocation` varchar(500) DEFAULT NULL,
  `fedralState` varchar(500) DEFAULT NULL,
  `fax` varchar(500) DEFAULT NULL,
  `mobile` varchar(500) DEFAULT NULL,
  `web` varchar(500) DEFAULT NULL,
  `contact_person` varchar(500) DEFAULT NULL,
  `date_of_foundation` varchar(500) DEFAULT NULL,
  `club_type` varchar(255) DEFAULT NULL,
  `lsb_club` varchar(255) DEFAULT NULL,
  `club_logo` varchar(500) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `club_info_setting_data`
--

INSERT INTO `club_info_setting_data` (`id`, `user_id`, `clubName`, `description`, `street`, `postCode`, `pobox`, `location`, `poboxPostcode`, `state`, `email`, `country`, `phone`, `poBoxLocation`, `fedralState`, `fax`, `mobile`, `web`, `contact_person`, `date_of_foundation`, `club_type`, `lsb_club`, `club_logo`, `created_at`, `updated_at`) VALUES
(12, 1, 'TEST club', NULL, 'test', '52634', '65231', 'test', '585632', NULL, 'test@yopmail.com', 'Germany', '855642359898', '55656', 'Berlin', NULL, '8574545125', 'https://www.ksk-ostalb.de', 'dsdsdfds', '2024-06-12', 'Sportverein', '55536', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/June/Images/Bogenschie%C3%9Fen.jpeg', '2024-06-11 18:56:10', '2024-06-14 15:19:18'),
(15, 41585, 'Tineon Direktvertrieb', 'Tineon Direktvertrieb', '138/8 street', '526312', '', 'german', '', NULL, 'crm.16April01@yopmail.com', 'Germany', '5245152636', '', 'Hamburg', '4234234', '1245698578', 'https://www.ksk-ostalb.de', 'test', '2024-06-21', 'Sachsen-Anhalt', '', NULL, '2024-06-21 16:55:27', '2024-08-14 09:00:19'),
(16, 41591, 'TInoen Club ', 'TEST club ', 'dfdff', '45862332', '21233', 'sddsd', '45862332', NULL, 'testUser27@mailinator.com', 'Germany', '8578451245', 'sddsd', 'Bremen', '9658745896', '8978457845', 'www.ksk-gelnhausen.de', 'customer cust', '2024-06-21', 'Kulturverein', '', NULL, '2024-06-27 18:01:02', NULL);

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

--
-- Table structure for table `contact_admin`
--

CREATE TABLE `contact_admin` (
  `cid` int(10) UNSIGNED NOT NULL,
  `uid` int(11) NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  `mail` varchar(255) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `contact_admin`
--

INSERT INTO `contact_admin` (`cid`, `uid`, `name`, `mail`, `subject`, `message`, `status`) VALUES
(1, 1, NULL, 'admin@gmail.com', 'testing', 'hello this message is for testing purpose', 1),
(2, 4465, NULL, 'hans-joerg.zimmermann@vewetec.de', 'Test', 'Hallo Test aus neuem CRM<br>', 1),
(3, 4478, NULL, 'tineon26011@yopmail.com', 'Test', 'Hallo Test&#160;', 1),
(4, 4476, NULL, 'anurag1@yopmail.com', 'Coming soon', '<p class=\"MsoListParagraph\">New HTML Text for auto response at contact&#10;field (coming soon)</p>', 0),
(5, 10928, NULL, 'bob2@mailinator.com', 'Want to connect', 'Want to connect to discuss the problem.', 0),
(6, 1, NULL, 'admin@gmail.com', 'Test description', 'This is test message!<div><br></div>', 1),
(7, 11638, NULL, 'test123@mailinator.com', 'testing', 'testing', 1),
(8, 11638, NULL, 'test123@mailinator.com', 'Testing', 'test', 1),
(9, 11638, NULL, 'test123@mailinator.com', 'test', 'test', 0),
(10, 1, NULL, 'test.104@mailinator.com', 'Want to connect', 'Hiii', 0),
(11, 40487, NULL, 'admin@gmail.com', 'Want to connect', 'hii', 0),
(12, 40413, NULL, 'jack@mailinator.com', 'Test Text', '<span>Hello.<br>Lorem ipsum dolor sit amet.</span>', 1),
(13, 40428, NULL, 'test.101@mailinator.com', 'test', 'test message', 1);

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

--
-- Table structure for table `crm_product`
--

CREATE TABLE `crm_product` (
  `id` int(10) UNSIGNED NOT NULL,
  `product_name` text NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `price` int(11) NOT NULL,
  `component_type` varchar(255) DEFAULT NULL,
  `tax_policy` varchar(255) DEFAULT NULL,
  `non_visible_role_category` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `is_converted` int(11) NOT NULL DEFAULT 0,
  `upload_document_required` int(11) NOT NULL DEFAULT 0 COMMENT '0 -> Not required, 1-> required',
  `created_at` varchar(32) DEFAULT NULL,
  `modified_at` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `crm_product`
--

INSERT INTO `crm_product` (`id`, `product_name`, `image`, `description`, `price`, `component_type`, `tax_policy`, `non_visible_role_category`, `status`, `is_converted`, `upload_document_required`, `created_at`, `modified_at`) VALUES
(1, 'new product', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/July/Images/v-logo.png', 'testing', 5000, '', '', '[]', 1, 1, 0, '2022-09-30T00:0.000Z;', '2023-09-20T00:0.000Z;'),
(2, 'Oct17 product', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/July/Images/v-logo.png', 'test', 676, 'test', '', '[1,2,3,4,5]', 1, 1, 0, '2023-07-03T00:0.000Z;', '2023-07-05T00:0.000Z;'),
(4, 'Jul04 product', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/July/Images/v-logo.png', 'Jul04 product', 499, '', '', '[1,2,3,4,5]', 1, 1, 1, '2023-07-04T00:0.000Z;', '2023-10-11T00:0.000Z;'),
(7, 'Orbital Keys update', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/kitten_lying_striped_102741_1280x720.jpg', ' test', 676, NULL, NULL, '[]', 1, 1, 0, '2023-08-07T00:0.000Z;', '2023-08-08T00:0.000Z;'),
(8, 'InstaPress', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009.38.30.png', '<span>Lorem ipsum dolor sit amet.&#160;</span>', 500, 'test', '2121', '[]', 1, 1, 0, '2023-08-08T00:0.000Z;', '2023-08-08T00:0.000Z;'),
(9, ' Swish Wallet', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/pexels-ali-ramazan-%C3%A7ift%C3%A7i-13771186%20%281%29.jpg', '<span>Lorem ipsum dolor sit amet.</span>', 569, '', '', '[]', 1, 1, 0, '2023-08-08T00:0.000Z;', '2023-08-08T00:0.000Z;'),
(10, 'IST Product', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/pexels-anand-dandekar-1532771.jpg', '<div><p><strong>Lorem Ipsum</strong>&#160;</p></div><div></div>', 123, '', '', '[]', 1, 1, 0, '2023-08-09T00:0.000Z;', '2023-08-09T00:0.000Z;'),
(12, ' Uno Wear', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009.39.01.png', '<span>Lorem ipsum dolor sit amet. Ut rerum corrupti eum minima velit et obcaecati cumque ad officia nihil!&#160;</span>', 356, '', '', '[1,2,3,4,5]', 1, 0, 0, '2023-08-10T00:0.000Z;', NULL),
(13, 'Soylent Corp', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Documents/Bildschirm%C2%ADfoto%202023-03-18%20um%2009.40.01.png', '<span>Lorem ipsum dolor sit amet. Est voluptatem consequuntur et eaque accusamus nam aspernatur sunt et tenetur debitis est nulla iure qui repellat iure.&#160;</span>', 360, '', '', '[1,2,3,4,5]', 1, 0, 0, '2023-08-14T00:0.000Z;', '2023-08-14T00:0.000Z;'),
(15, 'Product to check', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/September/Images/new-logo.png', 'Product to check', 130, '', '', '[]', 1, 0, 1, '2023-09-04T00:0.000Z;', '2023-09-14T00:0.000Z;'),
(16, 'Stickem update', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/July/Images/Hockeydamen.jpeg', 'Stickem update', 100, 'test', '6985d', '[]', 1, 1, 1, '2023-10-03T00:0.000Z;', '2024-07-04T00:0.000Z;'),
(17, 'test product', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/July/Images/Tennisspieler.jpeg', 'test product', 1, 'test', '1452632', '[1,1,2,3,4,5]', 1, 0, 1, '2024-07-03T00:0.000Z;', NULL),
(18, 'test test', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/July/Images/Tennis-Minis.jpeg', 'test&#160;', 1, 'test', '1452632', '[1,2,3,4,5]', 1, 0, 1, '2024-07-03T00:0.000Z;', NULL),
(19, 'product Name', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/July/Images/Volleyball%20M%C3%A4dels.jpeg', 'Stdescriptionreet', 100, 'test', '6985d', '[\r\n  1,\r\n  2,\r\n  3,\r\n  4,\r\n  5\r\n]', 1, 0, 1, '2024-07-03T00:0.000Z;', NULL),
(20, 'product Name 123', NULL, 'Stdescriptionreet', 100, 'test', '6985d', '[\r\n  1,\r\n  2,\r\n  3,\r\n  4,\r\n  5\r\n]', 1, 0, 1, '2024-07-04T00:0.000Z;', NULL),
(21, 'product Name 123', NULL, 'Stdescriptionreet', 100, 'test', '6985d', '[\r\n  1,\r\n  2,\r\n  3,\r\n  4,\r\n  5\r\n]', 1, 0, 1, '2024-07-04T00:0.000Z;', NULL),
(22, 'product Name 123', NULL, 'Stdescriptionreet', 100, 'test', '6985d', '[\r\n  1,\r\n  2,\r\n  3,\r\n  4,\r\n  5\r\n]', 1, 0, 1, '2024-07-04T00:0.000Z;', NULL),
(23, 'product Name 123', NULL, 'Stdescriptionreet', 100, 'test', '6985d', '[\r\n  1,\r\n  2,\r\n  3,\r\n  4,\r\n  5\r\n]', 1, 0, 1, '2024-07-04T00:0.000Z;', NULL),
(24, 'product Name', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/July/Images/Leichtathetik.jpeg', 'description', 100, 'test', '6985d', '[\r\n  1,\r\n  2,\r\n  3,\r\n  4,\r\n  5\r\n]', 1, 0, 1, '2024-07-04T00:0.000Z;', NULL);

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

--
-- Table structure for table `crm_product_image`
--

CREATE TABLE `crm_product_image` (
  `id` int(11) NOT NULL,
  `crm_product_id` int(11) NOT NULL,
  `product_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 `crm_product_image`
--

INSERT INTO `crm_product_image` (`id`, `crm_product_id`, `product_image`, `created_at`, `updated_at`) VALUES
(1, 7, '[encoded data, 185668 characters]', '2023-08-07 13:49:46', '2023-08-10 05:04:08');
INSERT INTO `crm_product_image` (`id`, `crm_product_id`, `product_image`, `created_at`, `updated_at`) VALUES
(2, 8, '[encoded data, 328121 characters]