-- Table structure for table `domain`
--

CREATE TABLE `domain` (
  `domain_id` int(10) UNSIGNED NOT NULL,
  `subdomain` varchar(255) NOT NULL,
  `sitename` varchar(255) NOT NULL,
  `machine_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `email_template`
--

CREATE TABLE `email_template` (
  `id` int(10) UNSIGNED NOT NULL,
  `template_type` varchar(100) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `template_body` longtext NOT NULL,
  `header_content` text NOT NULL,
  `footer_content` text NOT NULL,
  `logo` longtext DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  `is_converted` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `modified_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `email_template`
--

INSERT INTO `email_template` (`id`, `template_type`, `subject`, `template_body`, `header_content`, `footer_content`, `logo`, `url`, `is_converted`, `created_at`, `modified_at`) VALUES
(8, 'Customer ticket', 'New Request Generated ', 'New Request Generated By Customer. Below are the request Details:', '<div>Hello,</div><div>Suppport</div><div><br></div>', '<div>Thanks</div><div><br></div>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/dummy-logo.jpeg', 'http://crmangular.mangoitsol.com/', 1, '2022-06-09 13:50:19', '2022-06-09 08:20:19'),
(9, 'Assigned Support User', 'Ticket Asssigned to Support', 'Below Ticket is Assigned to you. Please check, Below are ticket details:', '<div>Hello,</div><div>Suppport</div><div><br></div>', 'Thanks,<div>Support Admin</div>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/October/Documents/WhatsApp%20Image%202023-10-16%20at%2016.55.58.png', 'http://crmangular.mangoitsol.com/', 1, '2022-06-09 13:50:19', '2022-06-09 08:20:19'),
(10, 'Reply from Support User', 'Request acknowledge from Support', '<span>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout.</span>', '<div>Hello&#160; Customer,</div>', '<span>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested.</span>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/v-logo.png', 'http://crmangular.mangoitsol.com/', 1, '2022-06-09 13:50:19', '2022-06-09 08:20:19'),
(11, 'Reply from customer', 'Reply From Customer', 'Customer added reply on this ticket', 'Hello Support,', 'Thanks & Regards', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/October/Images/logoNew.png', 'http://crmangular.mangoitsol.com/', 1, '2022-06-09 13:50:19', '2022-06-09 08:20:19'),
(13, 'Ticket Closed', 'closed the ticket', 'we hope that you are getting your answer and its helpfull to you', 'Hello Customer,', 'Thanks & Regards,Support', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/October/Images/logoNew.png', 'http://crmangular.mangoitsol.com/', 1, '2022-06-09 13:50:19', '2022-06-09 08:20:19'),
(14, 'Password Reset', 'Please reset your password (Please reset your password)', '<h4>Thank you for your interest in our S-Club | Online club management.</h4><h5> Please reset your password via the following link: </h5>', '<h3>Dear association member,</h3>', '<h3>If the forwarding does not work, please copy the link in the address bar of your browser.</h3>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/October/Images/logoNew.png', 'http://crmangular.mangoitsol.com/', 1, '2022-06-09 13:50:19', '2022-06-09 08:20:19'),
(15, 'Contact Admin', 'CRM user wants to contact you.', 'CRM user wants to contact you:- mail:', '<h3>Dear Admin,</h3>', 'Thanks', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/October/Images/logoNew.png', 'http://crmangular.mangoitsol.com/', 1, '2022-06-09 13:50:19', '2022-06-09 08:20:19'),
(17, 'Survey Create', ' Happy with your <survey Name>? | Let us know how you feel', '&#160;Would you like to fill up a short survey to help us improve our services? It will take only 5 mins!&lt;Survey_Link&gt;Thank you in advance for your valuable insights.&#160; Your input will be used to ensure that we continue to meet your needs.&#160;', '<div>Hi &lt;Name&gt;,</div><div>We hope you are enjoying your recent purchase of &lt;Product Name&gt; from &lt;Company Name&gt;..</div>', '<div>We appreciate your trust in us and look forward to serving you in the future. For any questions, please contact our &lt;Customer Support&gt;.</div><div>Thank you</div>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/logo1.jpeg', 'http://crmangular.mangoitsol.com/', 1, '2023-08-09 13:28:51', '2023-08-09 15:28:51'),
(18, 'Trial Registration', 'New Request Generated -update', 'New Request Generated By Customer. Below are the request Details:', '<div>Hello</div><div><br></div>', 'Thanks', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/logo3.png', 'http://crmangular.mangoitsol.com/', 1, '2023-08-09 13:54:52', '2023-08-09 15:54:52'),
(19, 'Payment Escalation', 'Billwerk Zahlungseskalation', '<div><span>Mitteilung aus Billwerk, Kunde hat dem Lastschrifteinzug widersprochen/ Zahlungsdaten haben sich ge&#228;ndert</span><span><br></span></div>', '<span>Dear association member,</span><br>', '<span>Thanks</span>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Images/dummy-logo.jpeg', 'http://crmangular.mangoitsol.com/', 0, '2023-08-16 05:42:24', '2023-08-16 07:42:24');

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

--
-- Table structure for table `email_template_image`
--

CREATE TABLE `email_template_image` (
  `id` int(11) NOT NULL,
  `template_id` int(11) NOT NULL,
  `template_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 `email_template_image`
--

INSERT INTO `email_template_image` (`id`, `template_id`, `template_image`, `created_at`, `updated_at`) VALUES
(1, 18, '[encoded data, 5512 characters]', '2023-08-09 13:54:52', '2023-08-10 05:11:03'),
(2, 8, 'rjWhf1vuO17ABcWvCEOJ/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-09 13:57:20', '2023-08-10 05:11:17'),
(3, 17, '[encoded data, 4372 characters]', '2023-08-09 14:07:21', '2023-08-10 05:11:03');
INSERT INTO `email_template_image` (`id`, `template_id`, `template_image`, `created_at`, `updated_at`) VALUES
(4, 15, '[encoded data, 240940 characters]', '2023-08-10 05:11:03', '2023-10-19 06:49:49');
INSERT INTO `email_template_image` (`id`, `template_id`, `template_image`, `created_at`, `updated_at`) VALUES
(5, 14, '[encoded data, 240940 characters]', '2023-08-10 05:11:03', '2023-10-19 06:50:06');
