-- Table structure for table `tickets_requests`
--

CREATE TABLE `tickets_requests` (
  `id` int(10) UNSIGNED NOT NULL,
  `ticket_number` longtext NOT NULL,
  `user_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(264) NOT NULL,
  `description` longtext NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `attachment_url` varchar(255) DEFAULT NULL,
  `is_converted` int(11) NOT NULL DEFAULT 0,
  `status` varchar(264) NOT NULL,
  `assigned_to` varchar(264) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tickets_requests`
--

INSERT INTO `tickets_requests` (`id`, `ticket_number`, `user_id`, `category_id`, `name`, `description`, `attachment`, `attachment_url`, `is_converted`, `status`, `assigned_to`, `created_at`, `updated_at`) VALUES
(7, 'ed512e76465189e2f48c5a0b907087', 11801, 2, 'Couch', '<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>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/July/Documents/Test.txt', '/tineon/Leipzig/2023/July/Documents/Test.txt', 1, '1', 'support', '2023-07-07 05:28:18', '2023-08-10 07:44:06'),
(8, '9de7faf3a1dddc4e4e36d6d9c89a14', 11857, 2, 'TEst request', '<font face=\"Arial\" size=\"2\">test</font>', NULL, NULL, 0, '1', 'support', '2023-08-08 04:14:48', NULL),
(9, 'e8fe26ab555fc182f3f64bceaa29b8', 11801, 2, 'test request', '<font face=\"Arial\" size=\"2\">test</font>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Documents/samplepptx%20%283%29.pptx', '/tineon/Leipzig/2023/August/Documents/samplepptx%20%283%29.pptx', 1, '1', 'support', '2023-08-08 04:56:16', '2023-08-10 07:44:06'),
(10, 'd7c6de41920292be10fc380236f550', 11857, 2, 'templateaa', '<font face=\"Arial\" size=\"2\">test description</font>', NULL, NULL, 0, 'Inprogress', 'support', '2023-08-08 08:31:28', '2023-08-08 11:46:04'),
(11, 'd96e514f2b0afddc38310d8bdf247e', 11857, 2, 'test', '<font face=\"Arial\" size=\"2\">test descriptuion</font>', NULL, NULL, 0, '1', 'support', '2023-08-08 10:07:26', NULL),
(12, '3ce208414714aed3a989d3f65061fb', 11857, 2, 'Test2', '<font face=\"Arial\" size=\"2\">test</font>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Documents/RTN-003796-NHKFJ-DNLNM%20%281%29.pdf', '/tineon/Leipzig/2023/August/Documents/RTN-003796-NHKFJ-DNLNM%20%281%29.pdf', 1, '1', 'support', '2023-08-08 10:17:50', '2023-08-10 07:44:06'),
(13, '7b1b0710d5774c34e76be336b7f5ee', 11871, 2, 'Lorem ipsum', '<span>Lorem ipsum dolor sit amet. Aut culpa quia aut voluptas recusandae qui impedit impedit aut facilis deserunt quo galisum consectetur. Qui dolorum deserunt ut perferendis praesentium sit numquam</span>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/August/Documents/sample.pdf', '/tineon/Leipzig/2023/August/Documents/sample.pdf', 0, '1', 'support', '2023-08-16 06:33:27', NULL),
(14, '625744354f337894769db2eaf29325', 40414, 2, 'Lorem Test', '<span>Lorem ipsum dolor sit amet. In velit consectetur vel architecto aliquid qui enim quia! Et error totam At autem omnis aut omnis optio ut cupiditate debitis sit aperiam delectus!</span>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/September/Documents/sample.pdf', '/tineon/Leipzig/2023/September/Documents/sample.pdf', 0, '1', 'support', '2023-09-20 09:37:33', NULL),
(15, 'eb675373c8d4eb0f31dd5c850775ec', 40412, 2, 'Test the ticket request', '<strong>orem Ipsum</strong> is simply dummy text of the printing and &#10;typesetting industry. Lorem Ipsum has been the industry\'s standard dummy&#10; text ever since the 1500s, when an unknown printer took a galley of &#10;type and scrambled it to make a type specimen book. It has survived not &#10;only five centuries, but also the leap into electronic typesetting, &#10;remaining essentially unchanged. It was p', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/September/Documents/sample-pdf.pdf', '/tineon/Leipzig/2023/September/Documents/sample-pdf.pdf', 0, '1', 'support', '2023-09-20 09:50:54', NULL),
(16, '317eac116120e26e38c200553461c8', 40414, 2, 'Can You suggest some alternatives', '<font face=\"Arial\" size=\"2\">lorem test</font>', NULL, NULL, 0, '1', 'support', '2023-09-20 11:38:24', NULL),
(17, '0c2dd4d08c56e219da18aea6d45889', 40483, 2, 'Avatar is an American media franchise created by James Cameron, which consists of a planned series ', '<span>Avatar is an American media franchise created by James Cameron, &#10;which consists of a planned series of epic science fiction films &#10;produced by Lightstorm Entertainment and distributed by 20th Century &#10;Studios, as well as associated merchandise, video games and theme park &#10;attractions</span>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/September/Documents/sample-pdf.pdf', '/tineon/Leipzig/2023/September/Documents/sample-pdf.pdf', 0, '1', 'support', '2023-09-21 13:33:56', NULL),
(18, 'ebd38828d3b8e42f834dc924c3665d', 40483, 2, 'Avatar is an American m', '<span>Avatar is an American media franchise created by James Cameron, &#10;which consists of a planned series of epic science fiction films &#10;produced by Lightstorm Entertainment and distributed by 20th Century &#10;Studios, as well as associated merchandise, video games and theme park &#10;attractions</span>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/September/Documents/sample3.txt', '/tineon/Leipzig/2023/September/Documents/sample3.txt', 0, '1', 'support', '2023-09-21 13:34:44', NULL),
(19, '934bf0a605c0a4f2287b800bf0d320', 40481, 2, 'test', '<span>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</span>', NULL, NULL, 0, '1', 'support', '2023-09-21 14:25:47', NULL),
(20, '04ac365310bbf7c38967938daddd11', 40481, 2, 'Where can I get some?', '<span>There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.<br></span><p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of &#34;de Finibus Bonorum et Malorum&#34; (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, &#34;Lorem ipsum dolor sit amet..&#34;, comes from a line in section 1.10.32.</p><p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from &#34;de Finibus Bonorum et Malorum&#34; by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>', NULL, NULL, 0, '1', 'support', '2023-09-21 14:27:02', NULL),
(21, '3ea935a18a2b9f1662611827723269', 40481, 2, 'Where can', '<p><font color=\"#000000\" face=\"Open Sans, Arial, sans-serif\">Hallo Herr Spaeth, \\r\\n\\r\\nIhr Link m&#252;sste nun wieder f&#252;r Sie sichtbar sein.\\r\\n\\r\\nZur Not hier noch der Link: https://verwaltung.s-verein.de/login/fderklev\\r\\n\\r\\nMit freundlichen Gr&#252;&#223;en\\r\\nSchmitz</font><br></p>', NULL, NULL, 0, '1', 'support', '2023-09-21 14:39:05', NULL),
(22, 'fb6d6c06166a2e2e1446fe97390a92', 40487, 2, 'Test`', '<font face=\"Arial\" size=\"2\">Testing</font>', NULL, NULL, 0, '1', 'support', '2023-09-22 08:21:45', NULL),
(23, 'cfa6c28fe8ad1150a76e821e70b447', 40413, 2, 'Can you suggest some alternatives.', '<p>Lorem ipsum dolor sit amet. Vel quia commodi ut accusamus blanditiis ut eius quam ut quas harum et sunt iste eum blanditiis odit. At consequuntur impedit rem quia dolores 33 vitae autem At aliquid obcaecati sed enim fuga qui odio fugit.<span>Ad temporibus corporis ab voluptatum sint et sunt molestiae ex aliquid quae ut esse fugit hic suscipit aperiam! A iusto temporibus quo quibusdam quam quo perferendis aliquid aut accusamus libero.</span><span>Aut sapiente quos aut velit voluptatibus est eaque cupiditate sed cumque saepe. Aut molestiae maxime ea dolorum reprehenderit est obcaecati necessitatibus in sint asperiores est necessitatibus nobis.</span></p>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/September/Documents/sample3.txt', '/tineon/Leipzig/2023/September/Documents/sample3.txt', 0, '1', 'support', '2023-09-22 09:45:23', NULL),
(24, '75a02b4f3250556d537fbdc9fb83ae', 40413, 2, 'Keep it real!', '<p>Lorem ipsum dolor sit amet. Non natus sint aut quia ratione ex assumenda galisum quo provident porro vel delectus cupiditate. Et alias consequuntur sit repellendus nobis ex dolores dicta qui galisum consequatur id perferendis nihil aut numquam cupiditate.</p><p>Cum tempora iusto sit necessitatibus ratione non tenetur eaque aut enim quae non repellat odio. Aut labore blanditiis est eveniet totam nam aliquam molestias. Est vero dolores aut aperiam sunt ut esse explicabo et aliquid assumenda aut omnis dicta qui doloribus quos.</p><p>Sed velit vitae non ducimus voluptates cum dolore assumenda vel inventore vitae vel delectus eveniet non assumenda ducimus et repellat dicta. Non galisum harum et aspernatur adipisci qui neque voluptatem ut nulla odit. Qui quasi odit sed rerum consequatur qui debitis doloremque cum reprehenderit voluptatem! Ad quaerat ullam et earum perspiciatis ut corporis accusamus et alias quia et sunt eligendi.</p>', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/September/Documents/sample3.txt', '/tineon/Leipzig/2023/September/Documents/sample3.txt', 0, '1', 'support', '2023-09-22 09:49:04', NULL),
(25, 'dff5c46a35c2bef2d78b5fac7a6c13', 40488, 2, ' the obligations', 'On the other hand, we denounce with righteous indignation and dislike &#10;men who are so beguiled and demoralized by the charms of pleasure of the&#10; moment, so blinded by desire, that they cannot foresee the pain and &#10;trouble that are bound to ensue; and equal blame belongs to those who &#10;fail in their duty through weakness of will, which is the same as saying&#10; through shrinking from toil and pain. These cases are perfectly simple &#10;and easy to distinguish. In a free hour, when our power of choice is &#10;untrammelled and when nothing prevents our being able to do what we like&#10; best, every pleasure is to be welcomed and every pain avoided. But in &#10;certain circumstances and owing to the claims of duty or the obligations&#10; of business it will frequently occur that pleasures have to be &#10;repudiated and annoyances accepted. The wise man therefore always holds &#10;in these matters to this principle of selection: he rejects pleasures to&#10; secure other greater pleasures, or else he endures pains to avoid worse&#10; pains.&#34;On the other hand, we denounce with righteous indignation and dislike &#10;men who are so beguiled and demoralized by the charms of pleasure of the&#10; moment, so blinded by desire, that they cannot foresee the pain and &#10;trouble that are bound to ensue; and equal blame belongs to those who &#10;fail in their duty through weakness of will, which is the same as saying&#10; through shrinking from toil and pain. These cases are perfectly simple &#10;and easy to distinguish. In a free hour, when our power of choice is &#10;untrammelled and when nothing prevents our being able to do what we like&#10; best, every pleasure is to be welcomed and every pain avoided. But in &#10;certain circumstances and owing to the claims of duty or the obligations&#10; of business it will frequently occur that pleasures have to be &#10;repudiated and annoyances accepted. The wise man therefore always holds &#10;in these matters to this principle of selection: he rejects pleasures to&#10; secure other greater pleasures, or else he endures pains to avoid worse&#10; pains.&#34;', 'https://minio.staging.verein.cloud/tineon/Leipzig/2023/September/Documents/sample-pdf.pdf', '/tineon/Leipzig/2023/September/Documents/sample-pdf.pdf', 0, '1', 'support', '2023-09-22 09:52:48', NULL),
(26, '906efeceeec626a846ab1022bd1ce1', 40413, 2, 'Authenticity matters, choose real brands!', '<p>Lorem ipsum dolor sit amet. Sit ipsum ratione est assumenda ratione in galisum cumque ea officia vero vel assumenda architecto? Quo rerum rerum et internos eius 33 illum blanditiis ad adipisci consectetur rem fugit excepturi. Cum ipsa voluptatum ut praesentium veniam est veritatis internos eum pariatur velit vel molestiae consequatur. Qui neque itaque At veniam voluptatum ut facilis saepe est atque distinctio qui iste impedit et rerum commodi.</p><p>A odit Quis quo error dolorem non perspiciatis neque sed quidem aliquam in voluptatem omnis quo eaque inventore ad quia quia! Est doloribus labore vel sunt aspernatur est dolorum molestias quo soluta corrupti est commodi earum vel porro nisi? Qui eligendi quia sit voluptas fugiat sed dolorem porro sit molestiae impedit et explicabo obcaecati!</p>', NULL, NULL, 0, '1', 'support', '2023-09-22 10:25:34', NULL),
(27, '106cb793f48a4defab6ca689546c92', 40487, 2, 'Test', '<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. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</span><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. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</span><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. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</span><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. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</span><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. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</span><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. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</span>', NULL, NULL, 0, '1', 'support', '2023-09-22 10:39:00', NULL),
(28, '5ef1dd07282a4fd9a77a61bb08eca4', 40437, 2, 'Authenticity matters, choose real brands!', '<p>Lorem ipsum dolor sit amet. Eos voluptates unde in ullam aliquid nam autem quos ut harum deserunt hic accusantium dicta est voluptatum consequatur. Aut sint facilis 33 voluptates quam ut error magnam. 33 odio saepe id facere voluptatem rem repudiandae enim.</p><p>Sed corporis odio est modi sint rem tempore exercitationem 33 enim temporibus eum nobis voluptatem. Et ratione galisum ut provident sint ea internos illo. Est harum velit sit velit mollitia ab obcaecati voluptatum sit nesciunt quae quo internos facilis!</p><p>A voluptas iusto eos vero maiores ea quia vero aut aperiam aliquam. At beatae earum sit dolorum molestiae qui laborum repellat rem tenetur incidunt ea expedita accusamus in eveniet repellat?</p>', NULL, NULL, 0, '1', 'support', '2023-09-22 10:41:44', NULL),
(29, '423470cc1b413b681ca0cd7f7e74ea', 40437, 2, 'Keep it real!', '<p>Lorem ipsum dolor sit amet. Eos voluptates unde in ullam aliquid nam autem quos ut harum deserunt hic accusantium dicta est voluptatum consequatur. Aut sint facilis 33 voluptates quam ut error magnam. 33 odio saepe id facere voluptatem rem repudiandae enim.</p><p>Sed corporis odio est modi sint rem tempore exercitationem 33 enim temporibus eum nobis voluptatem. Et ratione galisum ut provident sint ea internos illo. Est harum velit sit velit mollitia ab obcaecati voluptatum sit nesciunt quae quo internos facilis!</p><p>A voluptas iusto eos vero maiores ea quia vero aut aperiam aliquam. At beatae earum sit dolorum molestiae qui laborum repellat rem tenetur incidunt ea expedita accusamus in eveniet repellat?<span>Lorem ipsum dolor sit amet. Eos voluptates unde in ullam aliquid nam autem quos ut harum deserunt hic accusantium dicta est voluptatum consequatur. Aut sint facilis 33 voluptates quam ut error magnam. 33 odio saepe id facere voluptatem rem repudiandae enim.</span></p><p>Sed corporis odio est modi sint rem tempore exercitationem 33 enim temporibus eum nobis voluptatem. Et ratione galisum ut provident sint ea internos illo. Est harum velit sit velit mollitia ab obcaecati voluptatum sit nesciunt quae quo internos facilis!</p><p>A voluptas iusto eos vero maiores ea quia vero aut aperiam aliquam. At beatae earum sit dolorum molestiae qui laborum repellat rem tenetur incidunt ea expedita accusamus in eveniet repellat?</p><p>Lorem ipsum dolor sit amet. Eos voluptates unde in ullam aliquid nam autem quos ut harum deserunt hic accusantium dicta est voluptatum consequatur. Aut sint facilis 33 voluptates quam ut error magnam. 33 odio saepe id facere voluptatem rem repudiandae enim.</p><p>Sed corporis odio est modi sint rem tempore exercitationem 33 enim temporibus eum nobis voluptatem. Et ratione galisum ut provident sint ea internos illo. Est harum velit sit velit mollitia ab obcaecati voluptatum sit nesciunt quae quo internos facilis!</p><p>A voluptas iusto eos vero maiores ea quia vero aut aperiam aliquam. At beatae earum sit dolorum molestiae qui laborum repellat rem tenetur incidunt ea expedita accusamus in eveniet repellat?</p>', NULL, NULL, 0, '1', 'support', '2023-09-22 10:42:45', NULL),
(30, '19eb17638f99655ba09cf9d73c26fc', 40518, 2, 'Testing purpose', '<font face=\"Arial\" size=\"2\">Description is just for testing.</font>', NULL, NULL, 0, '1', 'support', '2023-09-27 08:53:45', NULL),
(31, 'e88fd3eae199dbc602c97c62af400a', 40984, 2, 'Test`', '<font face=\"Arial\" size=\"2\">Testing purpose</font>', NULL, NULL, 0, '1', 'support', '2023-10-19 06:29:12', NULL),
(32, 'c36e66bf89188f2a9ed0feaf5aef9f', 40984, 2, 'New logo', '<font face=\"Arial\" size=\"2\">Testing new logo</font>', NULL, NULL, 0, '1', 'support', '2023-10-19 06:51:52', NULL),
(33, 'ebd838f855b3ef8fd4efc2ddee71f7', 41585, 2, 'Request Name', 'description', NULL, NULL, 0, '1', 'support', '2024-07-29 08:11:22', NULL);

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

--
-- Table structure for table `ticket_request_assignedTo`
--

CREATE TABLE `ticket_request_assignedTo` (
  `id` int(10) UNSIGNED NOT NULL,
  `request_id` int(11) NOT NULL,
  `assigned_user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ticket_request_assignedTo`
--

INSERT INTO `ticket_request_assignedTo` (`id`, `request_id`, `assigned_user_id`) VALUES
(3, 7, 1),
(4, 9, 1),
(5, 10, 1),
(6, 12, 1),
(7, 12, 11755),
(8, 12, 1),
(9, 12, 11755),
(10, 13, 1),
(11, 13, 11755),
(12, 13, 11870),
(13, 13, 11755),
(14, 13, 1),
(15, 21, 40407),
(16, 22, 11870),
(17, 29, 1),
(18, 29, 11755),
(19, 29, 11870),
(20, 29, 40406),
(21, 30, 40406),
(22, 28, 11755),
(23, 31, 40407),
(24, 32, 40406),
(25, 33, 11755);

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

--
-- Table structure for table `tineon_infos`
--

CREATE TABLE `tineon_infos` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `club_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `association_purpose` varchar(255) DEFAULT NULL,
  `number_of_members` varchar(255) DEFAULT NULL,
  `club_Website` varchar(255) DEFAULT 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 `tineon_infos`
--

INSERT INTO `tineon_infos` (`id`, `name`, `club_name`, `email`, `association_purpose`, `number_of_members`, `club_Website`, `created_at`, `updated_at`) VALUES
(3, 'test', 'Verein', 'test123@mailinator.com', 'orgnize events', '5', 'www.google.com', '2023-11-01 06:55:21', NULL),
(4, 'Ghhshh', 'Ghhhsb', 'Hahjhh@gmail.com', 'Bjajhah', 'Abjhba', 'BjJh', '2024-04-10 05:32:59', NULL),
(5, 'fdf', 'sfs', 'fg@gmail.com', 'fdsfd', 'fdf', 'fdsf', '2024-04-11 10:28:55', NULL),
(6, 'test', 'test', 'test@gmail.com', 'dfsf', '3', 'sdfsfs', '2024-04-11 10:35:22', NULL),
(7, 'gfhf', 'dgfg', 'fgfgf@gmail.com', 'edfr', 'sf', 'sfd', '2024-04-11 10:37:18', NULL),
(8, 'dsfs', 'ghh', 'fghf@gmail.com', 'dsf', 'dfdd', 'sfsdf', '2024-04-11 10:39:48', NULL),
(9, 'dsfs', 'ghh', 'fghf@gmail.com', 'dsf', 'dfdd', 'sfsdf', '2024-04-11 10:40:15', NULL),
(10, 'dsfs', 'ghh', 'fghf@gmail.com', 'dsf', 'dfdd', 'sfsdf', '2024-04-11 10:41:26', NULL),
(11, 'dsfs', 'ghh', 'fghf@gmail.com', 'dsf', 'dfdd', 'sfsdf', '2024-04-11 10:41:58', NULL),
(12, 'fdgd', 'dfgdf', 'dfkg@gmail.com', 'gdfg', 'gfg', 'fggf', '2024-04-11 10:42:34', NULL),
(13, 'ghf', 'ghhh', 'fgf@gmail.com', 'ghjg', 'gh', 'hj', '2024-04-11 10:47:26', NULL),
(14, 'ghf', 'ghhh', 'fgf@gmail.com', 'ghjg', 'gh', 'hj', '2024-04-11 10:48:09', NULL),
(15, 'ghf', 'ghhh', 'fgf@gmail.com', 'ghjg', 'gh', 'hj', '2024-04-11 10:58:53', NULL);

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

--
-- Table structure for table `upcomming_user_order`
--

CREATE TABLE `upcomming_user_order` (
  `id` int(10) UNSIGNED NOT NULL,
  `planVariantId` varchar(255) NOT NULL,
  `holder` varchar(255) NOT NULL,
  `iban` varchar(255) NOT NULL,
  `mandate_text` longtext NOT NULL,
  `chairman_name` varchar(255) NOT NULL,
  `coupon` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `users_domain`
--

CREATE TABLE `users_domain` (
  `uid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Primary Key: users.uid for user.',
  `domain_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Primary Key: domain.domain_id for domain.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `users_image`
--

CREATE TABLE `users_image` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_picture` 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 `users_image`
--

INSERT INTO `users_image` (`id`, `user_id`, `user_picture`, `created_at`, `updated_at`) VALUES
(1, 11868, '[encoded data, 497067 characters]