INSERT INTO `users` (`uid`, `auther_id`, `name`, `pass`, `mail`, `theme`, `signature`, `signature_format`, `created`, `access`, `login`, `status`, `reset_password_token`, `timezone`, `language`, `picture`, `init`, `data`, `contact_number`, `telephone`, `fax`, `process_status`, `support_access`, `licence_block_status`, `additional_key`, `bank_code`, `partnerId`, `SFPSalesPartner`, `invoice_email`, `web`, `function`, `purpose_of_use`, `sales_partner_since`, `is_converted`, `Shortkey`, `DatabaseId`, `syncSalesPartner`, `vcloud_isCourse`, `vcloud_isShiftPlanning`, `accept_terms`) VALUES
(41713, NULL, '', '$2a$10$O7fN3IYrk8JadXLMOjWDYOmJ9Z/KeL/uosF0pvfJzaO0St.n1GA.u', 'budynax@mailinator.com', '', '', 'plain_text', '1728461348766', '0', '0', 1, NULL, NULL, '', '', 'budynax@mailinator.com', NULL, '4521455227', '7458412541', '7895874585', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, 0, 1),
(41714, NULL, '', '$2a$10$hlMD1WH9QCBSOXw0yBKYZuMYxCqH4HBz4gCAVd1N9HjbaQ7MpGA8i', 'test0902@yopmail.com', '', '', 'plain_text', '1728461688690', '1728461756913', '1728461756913', 1, NULL, NULL, '', '', 'test0902@yopmail.com', NULL, '2323455677', '9856541254', '7895654451', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, 0, 1),
(41715, NULL, '', '$2a$10$d6OOnyjAuDkDItngfxIsUOvZ1VnK.T33ujWc5WNXIJE1FuYuOVlCO', 'test090202@yopmail.com', '', '', 'plain_text', '1728462033743', '1728462082336', '1728462082336', 1, NULL, NULL, '', '', 'test090202@yopmail.com', NULL, '08596458562', '01234567845', '4234234', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, 0, 1),
(41716, NULL, '', '$2a$10$qhI4zLcspJygTlUJv0NtGuQ/rL1IgLdGfk6blpsFEoSQl0EnRV/ku', 'xazuzo@mailinator.com', '', '', 'plain_text', '1728466063516', '0', '0', 0, NULL, NULL, '', '', 'xazuzo@mailinator.com', NULL, '3889856321', '6985471254', '9856325412', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, 0, 1),
(41717, NULL, 'crm.oct1401@yopmail.com', '$S$D8Y50CKl7ABGGwzjSf7kuzyx8sbEYLAEcjs2/mP3sbqQzL6T2Irm', 'crm.oct1401@yopmail.com', '', '', 'plain_text', '1728886977000', '1728886977000', '1728886977000', 1, NULL, NULL, 'de', '', 'crm.oct1401@yopmail.com', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, 0, 1),
(41718, NULL, 'crm.pa16oct@yopmail.com', '$S$D8Y50CKl7ABGGwzjSf7kuzyx8sbEYLAEcjs2/mP3sbqQzL6T2Irm', 'crm.pa16oct@yopmail.com', '', '', 'plain_text', '1729080282000', '1729080282000', '1729080282000', 1, NULL, NULL, 'de', '', 'crm.pa16oct@yopmail.com', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, 0, 1),
(41724, NULL, 'crm.oct2201@yopmail.com', '$2a$10$R/ZW/xixFROvkDv9nUoTDeE0Q.lYWsFtTaCncv8ckpdkNezBGLkFC', 'crm.oct2201@yopmail.com', '', '', 'plain_text', '1729579430212', '1729682661510', '1729682661510', 1, NULL, NULL, '', '', 'crm.oct2201@yopmail.com', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, 0, 1),
(41726, NULL, 'crm.oct2330@yopmail.com', '$S$D8Y50CKl7ABGGwzjSf7kuzyx8sbEYLAEcjs2/mP3sbqQzL6T2Irm', 'crm.oct2330@yopmail.com', '', '', 'plain_text', '1729687784000', '1729687784000', '1729687784000', 1, NULL, NULL, '', '', 'crm.oct2330@yopmail.com', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, 0, 1);

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

--
-- Table structure for table `users_club_data`
--

CREATE TABLE `users_club_data` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `databse_id` int(11) DEFAULT NULL,
  `club_id` int(11) DEFAULT NULL,
  `club_name` text NOT NULL,
  `shortKey` varchar(500) DEFAULT NULL,
  `customerId` varchar(500) DEFAULT NULL,
  `contractId` text DEFAULT NULL,
  `access` varchar(32) NOT NULL DEFAULT '0' COMMENT 'Timestamp for previous time user accessed the site.',
  `login` varchar(32) NOT NULL DEFAULT '0' COMMENT 'Timestamp for user’s last login.',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Whether the user is active(1) or blocked(0).',
  `reset_password_token` 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 `users_club_data`
--

INSERT INTO `users_club_data` (`id`, `user_id`, `databse_id`, `club_id`, `club_name`, `shortKey`, `customerId`, `contractId`, `access`, `login`, `status`, `reset_password_token`, `created_at`, `updated_at`) VALUES
(4, 41724, NULL, NULL, 'ACME, Inc.', NULL, NULL, NULL, '0', '0', 0, NULL, '2024-10-22 12:13:50', NULL),
(8, 41724, NULL, NULL, 'mangoitClub1', NULL, NULL, NULL, '1729601058506', '1729601058506', 1, NULL, '2024-10-22 14:01:27', '2024-10-22 18:14:18'),
(9, 41724, NULL, NULL, 'mangoClubTest', NULL, NULL, NULL, '1729602035198', '1729602035198', 1, NULL, '2024-10-22 18:30:10', '2024-10-22 18:30:35'),
(10, 41724, NULL, NULL, 'mangoitClub2', NULL, NULL, NULL, '1729674631126', '1729674631126', 1, NULL, '2024-10-23 14:39:28', '2024-10-23 14:40:31'),
(11, 41724, NULL, NULL, 'mangoitClub3', NULL, NULL, NULL, '1729675128148', '1729675128148', 1, NULL, '2024-10-23 14:48:19', '2024-10-23 14:48:48'),
(12, 41724, NULL, NULL, 'mangoitClubTest2', NULL, NULL, NULL, '0', '0', 0, NULL, '2024-10-23 14:49:49', NULL),
(13, 41724, NULL, NULL, 'mangoitClubTest2', NULL, NULL, NULL, '1729675267015', '1729675267015', 1, NULL, '2024-10-23 14:50:41', '2024-10-23 14:51:07'),
(14, 41724, NULL, NULL, 'mangoitClub6', NULL, NULL, NULL, '1729675439525', '1729675439525', 1, NULL, '2024-10-23 14:53:36', '2024-10-23 14:53:59'),
(15, 41724, NULL, NULL, 'mangoitClub4', NULL, NULL, NULL, '1729675601543', '1729675601543', 1, NULL, '2024-10-23 14:56:18', '2024-10-23 14:56:41'),
(16, 41724, NULL, NULL, 'mango', NULL, NULL, NULL, '1729675727936', '1729675727936', 1, NULL, '2024-10-23 14:58:17', '2024-10-23 14:58:47'),
(17, 41724, NULL, NULL, 'test', NULL, '6718ca66f9420fdd6950b235', '6718ca66f9420fdd6950b236', '1729677911500', '1729677911500', 1, NULL, '2024-10-23 15:34:45', '2024-10-23 15:38:28'),
(18, 41724, NULL, NULL, 'test2', NULL, '6718d6a5f9420fdd6950ed7e', '6718d6a5f9420fdd6950ed7f', '1729681051719', '1729681051719', 1, NULL, '2024-10-23 16:27:03', '2024-10-23 16:27:43'),
(19, 41724, NULL, NULL, 'Mangoit1', NULL, '6718dadc9c2edbb87628bead', '6718dadc9c2edbb87628beae', '1729682135740', '1729682135740', 1, NULL, '2024-10-23 16:42:28', '2024-10-23 16:45:42'),
(20, 41724, NULL, NULL, 'mangoit23', NULL, '6718dc069c2edbb87628c191', '6718dc069c2edbb87628c192', '1729682433759', '1729682433759', 1, NULL, '2024-10-23 16:49:26', '2024-10-23 16:50:40'),
(21, 41724, 21, 11477, 'test2301', 'ai194', '6718dcebf9420fdd69510177', '6718dcebf9420fdd69510178', '1729682661507', '1729682661507', 1, NULL, '2024-10-23 16:53:49', '2024-10-23 16:54:46');

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

--
-- 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, 516290 characters]