-- Table structure for table `member_additional_data`
--

CREATE TABLE `member_additional_data` (
  `ad_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `clubEntryOn` date NOT NULL,
  `clubExitDate` date DEFAULT NULL,
  `status` int(11) NOT NULL COMMENT '1 -> Active,\r\n0 -> Passive\r\n',
  `reasonForLeaving` varchar(255) NOT NULL,
  `picture` varchar(255) DEFAULT NULL,
  `assignCommunity` varchar(255) NOT NULL,
  `industry` varchar(255) NOT 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 `member_additional_data`
--

INSERT INTO `member_additional_data` (`ad_id`, `md_id`, `clubEntryOn`, `clubExitDate`, `status`, `reasonForLeaving`, `picture`, `assignCommunity`, `industry`, `created_at`, `updated_at`) VALUES
(1, 12, '2024-03-22', NULL, 1, 'nothing', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/March/Images/images%20%2815%29.jpeg', 'test', 'any', '2024-03-20 08:15:39', '2024-05-28 17:51:01'),
(4, 41, '2022-01-01', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-05-28 19:00:31', NULL),
(5, 42, '2022-01-01', '2022-02-02', 1, 'nothing', NULL, 'test', 'Any', '2024-05-29 10:41:38', '2024-06-25 19:00:05'),
(8, 45, '2024-05-28', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-05-30 14:08:31', NULL),
(10, 47, '2024-05-28', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-06-04 11:59:42', NULL),
(11, 48, '2024-06-20', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-06-20 16:38:26', NULL),
(12, 49, '2024-06-20', NULL, 0, 'nothing', NULL, 'test', 'Any', '2024-06-20 18:30:17', NULL),
(13, 50, '2024-06-21', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-06-21 17:47:01', NULL),
(14, 19, '2021-04-01', '2021-05-01', 1, 'nothibng', NULL, 'test', 'any', '2024-06-25 18:51:16', '2024-06-25 18:59:06'),
(16, 63, '2024-10-18', '2024-10-21', 2, 'unknown', 'null', '2', 'Datenverarbeitung', '2024-06-27 18:18:46', '2024-10-18 09:57:09'),
(17, 64, '2024-06-27', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-06-27 18:21:28', NULL),
(18, 65, '2024-07-19', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-07-05 10:36:53', NULL),
(19, 72, '2024-08-15', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-08-14 13:15:42', NULL),
(20, 125, '2024-10-18', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-10-18 13:30:02', NULL),
(21, 126, '2024-10-18', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-10-18 13:36:25', NULL),
(22, 127, '2024-10-18', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-10-18 15:52:36', NULL),
(23, 128, '2024-10-19', NULL, 1, 'nothing', NULL, 'test', 'Any', '2024-10-18 15:55:39', NULL),
(24, 129, '2024-10-18', '2024-10-23', 1, 'relocation', 'null', '1', 'Chemie', '2024-10-18 15:59:48', '2024-10-18 10:37:19');

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

--
-- Table structure for table `member_additional_data_image`
--

CREATE TABLE `member_additional_data_image` (
  `id` int(11) NOT NULL,
  `ad_id` int(11) NOT NULL,
  `picture_url` longtext NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_additional_data_image`
--

INSERT INTO `member_additional_data_image` (`id`, `ad_id`, `picture_url`, `created_at`) VALUES
(1, 1, '[encoded data, 5916 characters]', '2024-03-20 08:15:39');

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

--
-- Table structure for table `member_age_group_default`
--

CREATE TABLE `member_age_group_default` (
  `age_grp_id` int(11) NOT NULL,
  `age_from` double NOT NULL,
  `age_to` double NOT NULL,
  `user_id` int(11) NOT 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 `member_age_group_default`
--

INSERT INTO `member_age_group_default` (`age_grp_id`, `age_from`, `age_to`, `user_id`, `created_at`, `updated_at`) VALUES
(57, 0, 6, 41711, '2024-10-15 13:39:44', NULL),
(58, 7, 14, 41711, '2024-10-15 13:39:44', NULL),
(59, 15, 18, 41711, '2024-10-15 13:39:44', NULL),
(60, 19, 26, 41711, '2024-10-15 13:39:44', NULL),
(61, 27, 40, 41711, '2024-10-15 13:39:44', NULL),
(62, 41, 60, 41711, '2024-10-15 13:39:44', NULL),
(63, 61, 99, 41711, '2024-10-15 13:39:44', NULL),
(64, 0, 6, 41636, '2024-10-16 11:18:31', NULL),
(65, 7, 14, 41636, '2024-10-16 11:18:31', NULL),
(66, 15, 18, 41636, '2024-10-16 11:18:31', NULL),
(67, 19, 26, 41636, '2024-10-16 11:18:31', NULL),
(68, 27, 40, 41636, '2024-10-16 11:18:31', NULL),
(69, 41, 60, 41636, '2024-10-16 11:18:31', NULL),
(70, 61, 99, 41636, '2024-10-16 11:18:31', NULL),
(71, 0, 6, 41724, '2024-10-22 06:45:14', NULL),
(72, 7, 14, 41724, '2024-10-22 06:45:14', NULL),
(73, 15, 18, 41724, '2024-10-22 06:45:14', NULL),
(74, 19, 26, 41724, '2024-10-22 06:45:14', NULL),
(75, 27, 40, 41724, '2024-10-22 06:45:14', NULL),
(76, 41, 60, 41724, '2024-10-22 06:45:14', NULL),
(77, 61, 99, 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_appCommunity`
--

CREATE TABLE `member_appCommunity` (
  `app_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `status` bigint(20) NOT NULL COMMENT '1. kein Nutzer (preselected)\r\n	2. eingeladen\r\n	3. aktiv\r\n	4. gesperrt',
  `email` varchar(100) NOT NULL,
  `role_id` varchar(500) NOT NULL,
  `role` varchar(255) NOT NULL,
  `role_mapping_data` text NOT NULL,
  `keyclock_id` varchar(500) NOT NULL,
  `keyclock_data` text NOT 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 `member_appCommunity`
--

INSERT INTO `member_appCommunity` (`app_id`, `md_id`, `status`, `email`, `role_id`, `role`, `role_mapping_data`, `keyclock_id`, `keyclock_data`, `created_at`, `updated_at`) VALUES
(3, 16, 1, 'abc@gmail.com', '388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6', 'member_light', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6\",\"name\":\"member_light\",\"description\":\"member_light\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', 'c5b9a7d3-3af7-4d2b-af64-ffd138cb0970', '[{\"id\":\"c5b9a7d3-3af7-4d2b-af64-ffd138cb0970\",\"createdTimestamp\":1713260187311,\"username\":\"johndeuc\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"John\",\"lastName\":\"deuc\",\"email\":\"abc@gmail.com\",\"attributes\":{\"vv_club_id\":[\"9482\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-04-16 11:36:32', NULL),
(4, 19, 3, 'kuno01@yopmail.com', '84974569-6717-4e89-92d3-f32fc35af0ff', 'admin', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"84974569-6717-4e89-92d3-f32fc35af0ff\",\"name\":\"admin\",\"description\":\"The admin\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', '1762f3ba-bc94-45f7-9a26-8616262c2eb5', '[{\"id\":\"1762f3ba-bc94-45f7-9a26-8616262c2eb5\",\"createdTimestamp\":1713330013418,\"username\":\"kuno01@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Herr\",\"lastName\":\"Kuno\",\"email\":\"kuno01@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"9792\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-04-17 07:00:19', '2024-04-18 12:23:53'),
(5, 20, 4, 'exampleupdate@yopmail.com', 'cc68140b-ed54-41a8-9a3e-76d328831ebb', 'user', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"cc68140b-ed54-41a8-9a3e-76d328831ebb\",\"name\":\"user\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', 'b034ae2d-af3d-4475-9ea3-6ae8ce591a77', '[{\"id\":\"b034ae2d-af3d-4475-9ea3-6ae8ce591a77\",\"createdTimestamp\":1713333022665,\"username\":\"naumann01@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Ralf\",\"lastName\":\"naumann@yopmail.com\",\"email\":\"naumann01@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"9812\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-04-17 07:50:28', '2024-04-17 12:26:26'),
(6, 21, 1, 'meier@yopmail.com', '388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6', 'member_light', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6\",\"name\":\"member_light\",\"description\":\"member_light\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', 'ddb02ed4-ecfa-4910-a38b-0d30d7268ffe', '[{\"id\":\"ddb02ed4-ecfa-4910-a38b-0d30d7268ffe\",\"createdTimestamp\":1713434806824,\"username\":\"meier@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"David\",\"lastName\":\"Meier\",\"email\":\"meier@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"9832\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-04-18 15:36:53', '2024-05-06 18:54:37'),
(7, 25, 3, 'kluge.test@yopmail.com', '388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6', 'member_light', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6\",\"name\":\"member_light\",\"description\":\"member_light\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', '2f31e703-1661-4f5b-8070-c7ba6eedc953', '[{\"id\":\"2f31e703-1661-4f5b-8070-c7ba6eedc953\",\"createdTimestamp\":1715062907181,\"username\":\"kluge.test@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Erik\",\"lastName\":\"Kluge\",\"email\":\"kluge.test@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10001\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 11:51:52', '2024-05-07 18:28:15'),
(8, 24, 3, 'schmid.may@yopmail.com', '35afdc9e-ca75-40d6-aa24-7907571375a8', 'editor', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"35afdc9e-ca75-40d6-aa24-7907571375a8\",\"name\":\"editor\",\"description\":\"editor\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', 'cbe5194f-f2c8-4b1e-8de5-f7a918033641', '[{\"id\":\"cbe5194f-f2c8-4b1e-8de5-f7a918033641\",\"createdTimestamp\":1715063009186,\"username\":\"schmid.may@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Martina\",\"lastName\":\"Schmid\",\"email\":\"schmid.may@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10001\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 11:53:35', NULL),
(9, 23, 3, 'bieber@yopmail.com', 'ce12d594-e28f-4fb2-8ffe-681e6db867d5', 'secretary', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"ce12d594-e28f-4fb2-8ffe-681e6db867d5\",\"name\":\"secretary\",\"description\":\"secretary\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', '16fab78a-9b4e-463a-9600-fba62bc45209', '[{\"id\":\"16fab78a-9b4e-463a-9600-fba62bc45209\",\"createdTimestamp\":1715063048531,\"username\":\"bieber@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Nadine\",\"lastName\":\"Bieber\",\"email\":\"bieber@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10001\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 11:54:13', NULL),
(10, 27, 3, 'ruth@yopmail.com', '6a6fedd5-71ac-413c-a498-02d9fa498b1e', 'member', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"6a6fedd5-71ac-413c-a498-02d9fa498b1e\",\"name\":\"member\",\"description\":\"member\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', 'faf88f81-a8ec-4859-92a5-7e68fff2350e', '[{\"id\":\"faf88f81-a8ec-4859-92a5-7e68fff2350e\",\"createdTimestamp\":1715075845501,\"username\":\"ruth@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Ramos\",\"lastName\":\"Ruth\",\"email\":\"ruth@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10006\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 15:27:30', NULL),
(11, 26, 4, 'anja@yopmail.com', '84974569-6717-4e89-92d3-f32fc35af0ff', 'admin', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"84974569-6717-4e89-92d3-f32fc35af0ff\",\"name\":\"admin\",\"description\":\"The admin\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', '3b2e9065-2c51-4c9f-805d-60f6fd577a50', '[{\"id\":\"3b2e9065-2c51-4c9f-805d-60f6fd577a50\",\"createdTimestamp\":1715075888831,\"username\":\"anja@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Anja\",\"lastName\":\"Kimball\",\"email\":\"anja@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10006\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 15:28:13', NULL),
(12, 29, 3, 'goff@yopmail.com', '84974569-6717-4e89-92d3-f32fc35af0ff', 'admin', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"84974569-6717-4e89-92d3-f32fc35af0ff\",\"name\":\"admin\",\"description\":\"The admin\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', 'a56956dd-d1fd-4f2e-93da-30a1c6851ed7', '[{\"id\":\"a56956dd-d1fd-4f2e-93da-30a1c6851ed7\",\"createdTimestamp\":1715078063061,\"username\":\"goff@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Ethel\",\"lastName\":\"Goff\",\"email\":\"goff@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10009\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 16:04:29', NULL),
(13, 28, 3, 'brandes@yopmail.com', 'cc68140b-ed54-41a8-9a3e-76d328831ebb', 'user', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"cc68140b-ed54-41a8-9a3e-76d328831ebb\",\"name\":\"user\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', 'd806a036-b9c9-4b05-a7c8-b2bb15cf978a', '[{\"id\":\"d806a036-b9c9-4b05-a7c8-b2bb15cf978a\",\"createdTimestamp\":1715078099705,\"username\":\"brandes@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Mary\",\"lastName\":\"Brandes\",\"email\":\"brandes@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10009\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 16:05:04', NULL),
(14, 31, 3, 'tiffany@yopmail.com', '6a6fedd5-71ac-413c-a498-02d9fa498b1e', 'member', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"6a6fedd5-71ac-413c-a498-02d9fa498b1e\",\"name\":\"member\",\"description\":\"member\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', '176dbed2-6d5f-4d30-84b3-25e0ec838925', '[{\"id\":\"176dbed2-6d5f-4d30-84b3-25e0ec838925\",\"createdTimestamp\":1715078905437,\"username\":\"tiffany@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Watts\",\"lastName\":\"Tiffany\",\"email\":\"tiffany@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10012\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 16:18:31', NULL),
(15, 30, 3, 'nicole@yopmail.com', 'cc68140b-ed54-41a8-9a3e-76d328831ebb', 'user', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"cc68140b-ed54-41a8-9a3e-76d328831ebb\",\"name\":\"user\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', '9bd9d43a-6a6c-4084-8052-05827e1ae35f', '[{\"id\":\"9bd9d43a-6a6c-4084-8052-05827e1ae35f\",\"createdTimestamp\":1715079049531,\"username\":\"nicole@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Turnage\",\"lastName\":\"Nicole\",\"email\":\"nicole@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10012\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 16:20:55', NULL),
(16, 33, 3, 'wood@yopmail.com', 'f86e92e8-dd09-43f8-81d5-1f62fe907480', 'member_light_admin', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"f86e92e8-dd09-43f8-81d5-1f62fe907480\",\"name\":\"member_light_admin\",\"description\":\"member_light_admin\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', '493ee521-63ef-4cbd-a4cc-b29e293b7c9c', '[{\"id\":\"493ee521-63ef-4cbd-a4cc-b29e293b7c9c\",\"createdTimestamp\":1715083862174,\"username\":\"wood@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Diane\",\"lastName\":\"Wood\",\"email\":\"wood@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10016\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 17:41:09', '2024-05-07 18:28:19'),
(17, 32, 3, 'king@yopmail.com', '6a6fedd5-71ac-413c-a498-02d9fa498b1e', 'member', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"6a6fedd5-71ac-413c-a498-02d9fa498b1e\",\"name\":\"member\",\"description\":\"member\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', 'd3e1ce18-a12f-478a-96ca-b7459e2a418b', '[{\"id\":\"d3e1ce18-a12f-478a-96ca-b7459e2a418b\",\"createdTimestamp\":1715083887925,\"username\":\"king@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Valerie\",\"lastName\":\"King\",\"email\":\"king@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10016\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 17:41:34', NULL),
(18, 34, 3, 'rita@yopmail.com', '6a6fedd5-71ac-413c-a498-02d9fa498b1e', 'member', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"6a6fedd5-71ac-413c-a498-02d9fa498b1e\",\"name\":\"member\",\"description\":\"member\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', 'ff9941fc-cc85-4cc8-a08c-9b2d00d61095', '[{\"id\":\"ff9941fc-cc85-4cc8-a08c-9b2d00d61095\",\"createdTimestamp\":1715085388735,\"username\":\"rita@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Rita\",\"lastName\":\"Flowers\",\"email\":\"rita@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10018\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 18:06:34', '2024-05-07 18:08:37'),
(19, 35, 3, 'hoff@yopmail.com', '388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6', 'member_light', '{\"verein-nodejs\":{\"id\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\",\"client\":\"verein-nodejs\",\"mappings\":[{\"id\":\"388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6\",\"name\":\"member_light\",\"description\":\"member_light\",\"composite\":false,\"clientRole\":true,\"containerId\":\"f71a06e7-3966-453b-a6e0-f3ca4d92cfc4\"}]}}', '87c32509-c8d9-43ea-8ca8-c7e969652e8f', '[{\"id\":\"87c32509-c8d9-43ea-8ca8-c7e969652e8f\",\"createdTimestamp\":1715085422725,\"username\":\"hoff@yopmail.com\",\"enabled\":true,\"totp\":false,\"emailVerified\":false,\"firstName\":\"Amanda\",\"lastName\":\"Hoff\",\"email\":\"hoff@yopmail.com\",\"attributes\":{\"vv_club_id\":[\"10018\"],\"vv_database_id\":[\"21\"]},\"disableableCredentialTypes\":[],\"requiredActions\":[\"terms_and_conditions\"],\"notBefore\":0,\"access\":{\"manageGroupMembership\":true,\"view\":true,\"mapRoles\":true,\"impersonate\":false,\"manage\":true}}]', '2024-05-07 18:07:07', NULL);

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

--
-- Table structure for table `member_appCommunity_downgrade_role`
--

CREATE TABLE `member_appCommunity_downgrade_role` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `app_id` int(11) NOT NULL,
  `old_role_id` varchar(500) NOT NULL,
  `old_role_name` varchar(500) NOT NULL,
  `change_role_id` varchar(500) NOT NULL,
  `change_role_name` varchar(500) NOT NULL,
  `keyclock_id` varchar(500) NOT NULL,
  `downgrade_effective_date` varchar(500) NOT NULL,
  `cronJob_run_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 => cronjob not run,\r\n1 ->cron job successfully run',
  `cronJob_execution_date` varchar(500) DEFAULT NULL,
  `crated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_appCommunity_downgrade_role`
--

INSERT INTO `member_appCommunity_downgrade_role` (`id`, `user_id`, `md_id`, `app_id`, `old_role_id`, `old_role_name`, `change_role_id`, `change_role_name`, `keyclock_id`, `downgrade_effective_date`, `cronJob_run_status`, `cronJob_execution_date`, `crated_at`) VALUES
(4, 41591, 21, 6, 'ce12d594-e28f-4fb2-8ffe-681e6db867d5', 'secretary', '388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6', 'member_light', 'ddb02ed4-ecfa-4910-a38b-0d30d7268ffe', '2024-05-06', 1, '2024-05-06 19:00:20.556', '2024-05-06 18:00:17'),
(5, 41597, 25, 7, '6a6fedd5-71ac-413c-a498-02d9fa498b1e', 'member', '388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6', 'member_light', '2f31e703-1661-4f5b-8070-c7ba6eedc953', '2024-05-07', 1, '2024-05-07 18:28:12.990', '2024-05-07 12:10:27'),
(6, 41602, 33, 16, '84974569-6717-4e89-92d3-f32fc35af0ff', 'admin', 'f86e92e8-dd09-43f8-81d5-1f62fe907480', 'member_light_admin', '493ee521-63ef-4cbd-a4cc-b29e293b7c9c', '2024-05-07', 1, '2024-05-07 18:28:12.990', '2024-05-07 17:43:23'),
(7, 41602, 32, 17, '6a6fedd5-71ac-413c-a498-02d9fa498b1e', 'member', '388f2e2a-0f40-41b4-9a6e-c4bc37ce80e6', 'member_light', 'd3e1ce18-a12f-478a-96ca-b7459e2a418b', '2024-06-06', 0, NULL, '2024-05-07 17:43:23');

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

--
-- Table structure for table `member_assignMember`
--

CREATE TABLE `member_assignMember` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `owner_member_id` int(11) NOT NULL,
  `assign_member_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_assignMember`
--

INSERT INTO `member_assignMember` (`id`, `user_id`, `owner_member_id`, `assign_member_id`, `created_at`, `updated_at`) VALUES
(2, 41585, 18, 19, '2024-04-30 12:10:53', NULL);

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

--
-- Table structure for table `member_change_history`
--

CREATE TABLE `member_change_history` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `field_name` varchar(255) NOT NULL,
  `old_value` text NOT NULL,
  `new_value` text NOT NULL,
  `mode_of_change` text NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_change_history`
--

INSERT INTO `member_change_history` (`id`, `user_id`, `md_id`, `field_name`, `old_value`, `new_value`, `mode_of_change`, `updated_at`) VALUES
(5, 41585, 69, 'letterSalutation', 'SehrGeehrterHerrTitel', 'SehrGeehrteFrauNachname', 'manual', '2024-07-05 10:21:48'),
(6, 41585, 19, 'salutation', 'Mrs.', 'herr', 'manual', '2024-07-05 10:24:50'),
(7, 41585, 19, 'country', 'Hamburg', 'AG', 'manual', '2024-07-05 10:24:50'),
(8, 41585, 19, 'gender', 'Male', 'Keiner', 'manual', '2024-07-05 10:24:50');

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

--
-- Table structure for table `member_communication_data`
--

CREATE TABLE `member_communication_data` (
  `cd_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `typeOfEntry` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `telephone` varchar(20) NOT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `web` varchar(255) DEFAULT NULL,
  `skype` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_communication_data`
--

INSERT INTO `member_communication_data` (`cd_id`, `md_id`, `typeOfEntry`, `description`, `telephone`, `fax`, `mobile`, `email`, `web`, `skype`, `created_at`) VALUES
(1, 1, 'private', 'description', '1245124515', '454545', '1234567898', 'abc@yopmail.com', 'www.abc.com', 'skype', '2024-01-30 13:30:55'),
(2, 2, 'private', 'description', '1245124515', '454545', '1234567898', 'abc@yopmail.com', 'www.abc.com', 'skype', '2024-01-31 04:04:33'),
(4, 6, 'private', 'description', '1245124515', '454545', '1234567898', 'abc@yopmail.com', 'www.abc.com', 'skype', '2024-01-31 06:16:19'),
(8, 16, 'private', '31312', '3123123', '3123123', '2312798798', 'rong@yopmail.com', 'https://www.google.com', 'john.smith123', '2024-04-09 19:25:23'),
(10, 17, 'Private', 'Test', '9098564859', '025-58965', '7845145245', 'crm16aprilMemebr1@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-16 11:27:09'),
(14, 19, 'private', 'Test', '745126352', '025-58965', '8978451526', 'kuno01@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-16 12:47:10'),
(15, 19, 'Private', 'Test', '9098564859', '025-58965', '8978451526', 'kuno.test1@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-16 13:02:39'),
(16, 20, 'Private', 'Test', '9098564859', '025-58965', '8978451526', 'naumannupdate@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-17 05:34:45'),
(17, 20, 'Private', 'Test', '9098564859', '025-58965', '8978451526', 'exampleupdate@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-17 05:35:04'),
(18, 20, 'Private', 'Test', '9098564859', '025-58965', '8978451526', 'example@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-17 08:20:46'),
(19, 20, 'Private', 'Test', '9098564859', '025-58965', '8978451526', 'exampleupdate@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-17 08:21:22'),
(20, 21, 'Private', 'Test', '8596451452', '025-58965', '8978451526', 'meier@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-18 09:42:55'),
(21, 21, 'Buisness', 'Test', '8596451452', '025-58965', '8978451526', 'meier1@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-18 09:43:07'),
(22, 22, 'Private', 'Test', '9098564859', '025-58965', '8978451526', 'pabst@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-18 10:26:55'),
(23, 85, 'Private', 'Test', '9098564859', '025-58965', '8978451526', 'example@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-24 06:15:43'),
(24, 85, 'buisness', 'Test update', '9098564859', '025-58965', '8978451526', 'example@yopmail.com', 'https://www.example.com', 'examle_skype.com', '2024-04-24 06:15:43'),
(25, 25, 'private', 'test', '8596451246', '', '', 'kluge@yopmail.com', '', '', '2024-05-07 06:00:48'),
(26, 25, 'business', 'test', '85964514562', '', '', 'kluge.test@yopmail.com', '', '', '2024-05-07 06:00:48'),
(27, 24, 'business', 'test', '8596458785', '', '', 'schmid@yopmail.com', '', '', '2024-05-07 06:09:15'),
(28, 24, 'business', 'test2', '898965968', '', '', 'schmid.may@yopmail.com', '', '', '2024-05-07 06:09:15'),
(29, 24, 'private', 'test', '745693895', '', '', 'test.schmid@yopmail.com', '', '', '2024-05-07 06:09:15'),
(30, 25, 'private', 'test', '8596451246', '', '', 'kluge@yopmail.com', '', '', '2024-05-07 06:16:09'),
(31, 25, 'business', 'test', '8945124799', '', '', 'kluge07@yopmail.com', '', '', '2024-05-07 06:16:09'),
(32, 23, 'business', '', '8596451245', '', '9865415245', 'bieber@yopmail.com', '', '', '2024-05-07 06:18:19'),
(39, 41, 'Private', 'Personal', '123-456-7890', NULL, '098-765-4321', 'john.doe@example.com', NULL, NULL, '2024-05-28 19:00:31'),
(40, 41, 'Private', 'Work', '222-333-4444', NULL, '555-666-7777', 'john.doe@workexample.com', NULL, NULL, '2024-05-28 19:00:31'),
(46, 45, 'Private', 'description', '4512452136', NULL, '8574859654', 'lena@yopmail.com', NULL, NULL, '2024-05-30 14:08:31'),
(48, 47, 'Private', 'description', '4512452136', NULL, '8574859654', 'abc@yopmail.com', NULL, NULL, '2024-06-04 11:59:42'),
(50, 49, 'Private', 'Willebadessen', '5894561256', NULL, '857845896', 'kaiser@yopmail.com', NULL, NULL, '2024-06-20 18:30:17'),
(53, 63, 'Private', 'test2@yopmail.com', '08596458562', NULL, '8596457845', 'test2@yopmail.com', NULL, NULL, '2024-06-27 18:18:46'),
(58, 72, 'Private', '', '', NULL, '', 'crm.aug1401@yopmail.com', NULL, NULL, '2024-08-14 13:15:42'),
(59, 125, 'Private', 'test', '5263451256', NULL, '9856784512', 'test1@yopmail.com', NULL, NULL, '2024-10-18 13:30:02'),
(60, 126, 'Private', 'test', '5263451256', NULL, '9856784512', 'test1@yopmail.com', NULL, NULL, '2024-10-18 13:36:25'),
(61, 127, 'Private', 'test', '8578457841', NULL, '8578457845', 'check123@yopmail.com', NULL, NULL, '2024-10-18 15:52:36'),
(62, 128, 'Private', 'cte', '7845784514', NULL, '7845154254', 'check18@yopmail.com', NULL, NULL, '2024-10-18 15:55:39'),
(63, 129, 'Private', 'test', '8578451452', NULL, '8578457841', 'tet1801@yopmail.com', NULL, NULL, '2024-10-18 15:59:48');

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

--
-- Table structure for table `member_Contribution_data`
--

CREATE TABLE `member_Contribution_data` (
  `contribution_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `number` bigint(20) DEFAULT NULL,
  `contribution_type` varchar(600) NOT NULL,
  `department_id` bigint(20) NOT NULL,
  `payment_method` varchar(255) NOT NULL,
  `income_account` text NOT NULL,
  `contribution_text` varchar(600) NOT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `basicAmount` decimal(10,2) 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 `member_Contribution_data`
--

INSERT INTO `member_Contribution_data` (`contribution_id`, `md_id`, `number`, `contribution_type`, `department_id`, `payment_method`, `income_account`, `contribution_text`, `designation`, `basicAmount`, `created_at`, `updated_at`) VALUES
(1, 12, 2, 'Normal Post', 2, 'Month', '2120--Real memebrship', 'Contribution collection [last name], [first name] [department]', 'prof', '200.00', '2024-03-21 11:00:04', '2024-03-21 18:02:34'),
(2, 12, 5, 'Family contribution', 2, 'month', '2170-surcharges', 'Contribution collection [last name], [first name] [department]', 'designation', '500.00', '2024-03-21 11:17:10', '2024-03-21 11:55:08');

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

--
-- Table structure for table `member_default_anniversaries`
--

CREATE TABLE `member_default_anniversaries` (
  `anniversary_id` int(11) NOT NULL,
  `anniversary_name` text NOT NULL,
  `years_of_membership` int(11) NOT NULL,
  `user_id` int(11) NOT 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 `member_default_anniversaries`
--

INSERT INTO `member_default_anniversaries` (`anniversary_id`, `anniversary_name`, `years_of_membership`, `user_id`, `created_at`, `updated_at`) VALUES
(3, '10 Jahre Mitgliedschaft bronzene Ehrennadel', 10, 41711, '2024-10-16 07:00:13', NULL),
(4, '25 Jahre Mitgliedschaft silberne Ehrennadel', 25, 41711, '2024-10-16 07:00:13', NULL),
(5, '40 Jahre Mitgliedschaft goldene Ehrennadel', 40, 41711, '2024-10-16 07:00:13', NULL),
(6, '10 Jahre Mitgliedschaft bronzene Ehrennadel', 10, 41636, '2024-10-16 11:18:31', NULL),
(7, '25 Jahre Mitgliedschaft silberne Ehrennadel', 25, 41636, '2024-10-16 11:18:31', NULL),
(8, '40 Jahre Mitgliedschaft goldene Ehrennadel', 40, 41636, '2024-10-16 11:18:31', NULL),
(9, '10 Jahre Mitgliedschaft bronzene Ehrennadel', 10, 41724, '2024-10-22 06:45:14', NULL),
(10, '25 Jahre Mitgliedschaft silberne Ehrennadel', 25, 41724, '2024-10-22 06:45:14', NULL),
(11, '40 Jahre Mitgliedschaft goldene Ehrennadel', 40, 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_club_additional_dependent_fields`
--

CREATE TABLE `member_default_club_additional_dependent_fields` (
  `dependent_field_id` int(11) NOT NULL,
  `club_value_id` int(11) NOT NULL,
  `additional_field_name` text NOT NULL,
  `field_type` int(11) NOT NULL COMMENT '0 - None, 1 - free text , 2 :Selection field, 3 :Checkbox',
  `field_title` text NOT NULL,
  `default_value` text DEFAULT NULL,
  `max_characters` int(11) DEFAULT NULL,
  `is_mandatory` int(11) NOT NULL DEFAULT 0 COMMENT '	0 - Not mandatory, 1 - Mandatory',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_default_club_additional_dependent_fields`
--

INSERT INTO `member_default_club_additional_dependent_fields` (`dependent_field_id`, `club_value_id`, `additional_field_name`, `field_type`, `field_title`, `default_value`, `max_characters`, `is_mandatory`, `created_at`) VALUES
(1, 64, 'additional_field3.1\r\n', 1, 'DFB club number', NULL, 8, 0, '2024-09-26 16:25:03');

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

--
-- Table structure for table `member_default_club_additional_fields`
--

CREATE TABLE `member_default_club_additional_fields` (
  `additionalField_id` int(11) NOT NULL,
  `club_id` int(11) NOT NULL,
  `additional_field` text NOT NULL,
  `field_type` int(11) NOT NULL COMMENT '(Stores the type of field (checkbox, selection, text)\r\n0 - None,\r\n1 - free text ,\r\n2 :Selection field,\r\n3 :Checkbox\r\n',
  `field_title` text DEFAULT NULL COMMENT 'The title of the field (e.g., "Select Options", "Input Text")',
  `default_value` text DEFAULT NULL COMMENT 'Default value for the field (applicable for text fields)',
  `max_characters` int(11) DEFAULT NULL COMMENT 'Maximum character limit (applicable for text fields)',
  `is_mandatory` int(11) NOT NULL DEFAULT 0 COMMENT '0 - Not  mandatory,\r\n1 - Mandatory',
  `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 `member_default_club_additional_fields`
--

INSERT INTO `member_default_club_additional_fields` (`additionalField_id`, `club_id`, `additional_field`, `field_type`, `field_title`, `default_value`, `max_characters`, `is_mandatory`, `created_at`, `updated_at`) VALUES
(32, 13, 'additional_field1', 1, 'free text field title', 'test', 15, 0, '2024-09-26 06:26:38', NULL),
(33, 13, 'additional_field2', 2, 'selection field title', NULL, NULL, 0, '2024-09-26 06:26:38', NULL),
(34, 13, 'additional_field3', 0, NULL, NULL, NULL, 0, '2024-09-26 06:26:38', NULL),
(47, 17, 'additional_field1', 2, 'Auswahlfeld Landesverband', NULL, NULL, 0, '2024-09-26 09:25:14', NULL),
(48, 17, 'additional_field2', 1, 'LSB club number ', NULL, 10, 0, '2024-09-26 09:25:14', NULL),
(49, 17, 'additional_field3', 3, 'Member of the DFB', NULL, NULL, 0, '2024-09-26 09:25:14', NULL),
(55, 21, 'additional_field1', 2, 'Auswahlfeld Landesverband', NULL, NULL, 0, '2024-09-26 11:10:01', NULL);

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

--
-- Table structure for table `member_default_club_field_values`
--

CREATE TABLE `member_default_club_field_values` (
  `club_value_id` int(11) NOT NULL,
  `additionalField_id` int(11) NOT NULL,
  `additionalField_key` text NOT NULL,
  `additional_field_values` text NOT NULL,
  `default_value` int(11) DEFAULT 0 COMMENT '0 -> Not set as default value,\r\n1 -> Set as default value',
  `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 `member_default_club_field_values`
--

INSERT INTO `member_default_club_field_values` (`club_value_id`, `additionalField_id`, `additionalField_key`, `additional_field_values`, `default_value`, `created_at`, `updated_at`) VALUES
(27, 33, 'value1', 'Hamburger Sports Association', 1, '2024-09-26 06:26:38', NULL),
(28, 33, 'value2', 'Landessportbund Berlin', 0, '2024-09-26 06:26:38', NULL),
(56, 47, 'value1', 'Bitte auswählen', 1, '2024-09-26 09:25:14', NULL),
(57, 47, 'value2', 'Bayerischer Landes-Sportverband', 0, '2024-09-26 09:25:14', NULL),
(58, 47, 'value3', 'Hamburger Sportbund', 0, '2024-09-26 09:25:14', NULL),
(59, 47, 'value4', 'Landessportbund Berlin', 0, '2024-09-26 09:25:14', NULL),
(60, 47, 'value5', 'Landessportbund Brandenburg', 0, '2024-09-26 09:25:14', NULL),
(61, 47, 'value6', 'Landessportbund Bremen', 0, '2024-09-26 09:25:14', NULL),
(62, 47, 'value7', 'Landessportbund Hessen', 0, '2024-09-26 09:25:14', NULL),
(63, 49, 'value1', 'No', 1, '2024-09-26 09:25:14', NULL),
(64, 49, 'value2', 'Yes', 0, '2024-09-26 09:25:14', NULL),
(67, 55, 'value1', 'Bitte auswählen', 1, '2024-09-26 11:10:01', NULL);

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

--
-- Table structure for table `member_default_club_types`
--

CREATE TABLE `member_default_club_types` (
  `club_id` int(11) NOT NULL,
  `club_designation` text NOT NULL,
  `user_id` int(11) NOT 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 `member_default_club_types`
--

INSERT INTO `member_default_club_types` (`club_id`, `club_designation`, `user_id`, `created_at`, `updated_at`) VALUES
(13, 'Sports Club update1', 41585, '2024-09-26 04:58:05', '2024-09-26 05:53:50'),
(17, 'Sportverein up', 41585, '2024-09-26 09:23:59', '2024-09-26 09:25:14'),
(21, 'Sportverein update', 41585, '2024-09-26 11:09:14', '2024-09-26 11:10:01');

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

--
-- Table structure for table `member_default_country_list`
--

CREATE TABLE `member_default_country_list` (
  `id` int(11) NOT NULL,
  `country_id` int(11) NOT NULL,
  `country_name` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `updated_by_user` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `member_default_free_fields`
--

CREATE TABLE `member_default_free_fields` (
  `field_id` int(11) NOT NULL,
  `field_designation` text NOT NULL,
  `field_type` int(11) NOT NULL COMMENT '1- Text ,\r\n2 - Number,\r\n3 - Date ,\r\n4 - Selection, \r\n5 - Long Text',
  `field_default_value` text DEFAULT NULL,
  `field_type_max_lines` int(11) DEFAULT NULL,
  `field_type_max_characters` int(11) DEFAULT NULL,
  `user_id` int(11) NOT 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 `member_default_free_fields`
--

INSERT INTO `member_default_free_fields` (`field_id`, `field_designation`, `field_type`, `field_default_value`, `field_type_max_lines`, `field_type_max_characters`, `user_id`, `created_at`, `updated_at`) VALUES
(2, 'test', 1, 'test', NULL, NULL, 41585, '2024-09-19 11:02:18', '2024-09-20 11:21:48'),
(12, 'text', 1, 'text', NULL, NULL, 41585, '2024-09-20 09:20:01', NULL),
(13, 'selection field up', 4, '', NULL, NULL, 41585, '2024-09-20 09:23:42', '2024-09-20 11:01:17'),
(17, 'long text up ', 5, '', 62, 300, 41585, '2024-09-20 10:08:06', '2024-09-20 11:02:25');

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

--
-- Table structure for table `member_default_free_fields_selectionType`
--

CREATE TABLE `member_default_free_fields_selectionType` (
  `selection_id` int(11) NOT NULL,
  `field_id` int(11) NOT NULL,
  `selection_key` text NOT NULL,
  `selection_value` text NOT 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 `member_default_free_fields_selectionType`
--

INSERT INTO `member_default_free_fields_selectionType` (`selection_id`, `field_id`, `selection_key`, `selection_value`, `created_at`, `updated_at`) VALUES
(5, 13, 'value1', 'test2', '2024-09-20 11:01:17', NULL),
(6, 13, 'value2', 'test3', '2024-09-20 11:01:17', NULL);

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

--
-- Table structure for table `member_default_genders`
--

CREATE TABLE `member_default_genders` (
  `gender_id` int(11) NOT NULL,
  `gender_name` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `action_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 - can edit/delete\r\n1- cannot edit/delete',
  `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 `member_default_genders`
--

INSERT INTO `member_default_genders` (`gender_id`, `gender_name`, `user_id`, `action_status`, `created_at`, `updated_at`) VALUES
(12, 'divers', 41711, 1, '2024-10-16 08:15:48', NULL),
(13, 'Gemeinschaft', 41711, 0, '2024-10-16 08:15:48', NULL),
(14, 'Juristische Person', 41711, 0, '2024-10-16 08:15:48', NULL),
(15, 'männlich', 41711, 1, '2024-10-16 08:15:48', NULL),
(16, 'ohne Angabe', 41711, 1, '2024-10-16 08:15:48', NULL),
(17, 'weiblich', 41711, 1, '2024-10-16 08:15:48', NULL),
(19, 'divers', 41636, 1, '2024-10-16 11:18:31', NULL),
(20, 'Gemeinschaft', 41636, 0, '2024-10-16 11:18:31', NULL),
(21, 'Juristische Person', 41636, 0, '2024-10-16 11:18:31', NULL),
(22, 'männlich', 41636, 1, '2024-10-16 11:18:31', NULL),
(23, 'ohne Angabe', 41636, 1, '2024-10-16 11:18:31', NULL),
(24, 'weiblich', 41636, 1, '2024-10-16 11:18:31', NULL),
(25, 'divers', 41724, 1, '2024-10-22 06:45:14', NULL),
(26, 'Gemeinschaft', 41724, 0, '2024-10-22 06:45:14', NULL),
(27, 'Juristische Person', 41724, 0, '2024-10-22 06:45:14', NULL),
(28, 'männlich', 41724, 1, '2024-10-22 06:45:14', NULL),
(29, 'ohne Angabe', 41724, 1, '2024-10-22 06:45:14', NULL),
(30, 'weiblich', 41724, 1, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_honors`
--

CREATE TABLE `member_default_honors` (
  `honor_id` int(11) NOT NULL,
  `honor_name` text NOT NULL,
  `years_of_membership` int(11) DEFAULT NULL,
  `user_id` int(11) NOT 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 `member_default_honors`
--

INSERT INTO `member_default_honors` (`honor_id`, `honor_name`, `years_of_membership`, `user_id`, `created_at`, `updated_at`) VALUES
(8, 'Ehrenmitglied', NULL, 41711, '2024-10-16 06:48:23', NULL),
(9, 'Erfolg', NULL, 41711, '2024-10-16 06:48:23', NULL),
(10, 'Verbandsehrung', NULL, 41711, '2024-10-16 06:48:23', NULL),
(11, 'Verdienstnadel in Bronze', 10, 41711, '2024-10-16 06:48:23', NULL),
(12, 'Verdienstnadel in Gold', 40, 41711, '2024-10-16 06:48:23', NULL),
(13, 'Verdienstnadel in Silber', 25, 41711, '2024-10-16 06:48:23', NULL),
(14, 'Ehrenmitglied', NULL, 41636, '2024-10-16 11:18:31', NULL),
(15, 'Erfolg', NULL, 41636, '2024-10-16 11:18:31', NULL),
(16, 'Verbandsehrung', NULL, 41636, '2024-10-16 11:18:31', NULL),
(17, 'Verdienstnadel in Bronze', 10, 41636, '2024-10-16 11:18:31', NULL),
(18, 'Verdienstnadel in Gold', 40, 41636, '2024-10-16 11:18:31', NULL),
(19, 'Verdienstnadel in Silber', 25, 41636, '2024-10-16 11:18:31', NULL),
(20, 'Ehrenmitglied', NULL, 41724, '2024-10-22 06:45:14', NULL),
(21, 'Erfolg', NULL, 41724, '2024-10-22 06:45:14', NULL),
(22, 'Verbandsehrung', NULL, 41724, '2024-10-22 06:45:14', NULL),
(23, 'Verdienstnadel in Bronze', 10, 41724, '2024-10-22 06:45:14', NULL),
(24, 'Verdienstnadel in Gold', 40, 41724, '2024-10-22 06:45:14', NULL),
(25, 'Verdienstnadel in Silber', 25, 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_industries`
--

CREATE TABLE `member_default_industries` (
  `industries_id` int(11) NOT NULL,
  `industry_name` text NOT NULL,
  `user_id` int(11) NOT 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 `member_default_industries`
--

INSERT INTO `member_default_industries` (`industries_id`, `industry_name`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Architektur', 41711, '2024-10-16 06:28:11', NULL),
(2, 'Baugewerbe & Immobilienwirtschaft', 41711, '2024-10-16 06:28:11', NULL),
(3, 'Branchenunabhängig', 41711, '2024-10-16 06:28:11', NULL),
(4, 'Chemie / Pharmazeut. Industrie', 41711, '2024-10-16 06:28:11', NULL),
(5, 'Chor', 41711, '2024-10-16 06:28:11', NULL),
(6, 'EDV / Datenverarbeitung / Informatik (Software)', 41711, '2024-10-16 06:28:11', NULL),
(7, 'Elektrotechnik / Elektronik / Feinmechanik / Optik', 41711, '2024-10-16 06:28:11', NULL),
(8, 'Energie- / Wasserversorgung', 41711, '2024-10-16 06:28:11', NULL),
(9, 'Forschung / Lehre', 41711, '2024-10-16 06:28:11', NULL),
(10, 'Gesundheits- / Sozialwesen', 41711, '2024-10-16 06:28:11', NULL),
(11, 'Handel', 41711, '2024-10-16 06:28:11', NULL),
(12, 'Handwerk', 41711, '2024-10-16 06:28:11', NULL),
(13, 'Holz- / Möbelindustrie', 41711, '2024-10-16 06:28:11', NULL),
(14, 'Kreativberufe / Veranstaltungen', 41711, '2024-10-16 06:28:11', NULL),
(15, 'Kredit- / Finanzinstitute / Finanzdienstl.', 41711, '2024-10-16 06:28:11', NULL),
(16, 'Kunststoffverarbeitung', 41711, '2024-10-16 06:28:11', NULL),
(17, 'Land- / Forstwirtschaft', 41711, '2024-10-16 06:28:11', NULL),
(18, 'Lehr- / Erziehungsberufe', 41711, '2024-10-16 06:28:11', NULL),
(19, 'Maschinen- u. Anlagenbau', 41711, '2024-10-16 06:28:11', NULL),
(20, 'Medien / Kommunikation', 41711, '2024-10-16 06:28:11', NULL),
(21, 'Metallverarbeitung', 41711, '2024-10-16 06:28:11', NULL),
(22, 'Mode / Kosmetik', 41711, '2024-10-16 06:28:11', NULL),
(23, 'Nahrungsmittelindustrie', 41711, '2024-10-16 06:28:11', NULL),
(24, 'Papier- / Druckindustrie / Verlag', 41711, '2024-10-16 06:28:11', NULL),
(25, 'Sonstige', 41711, '2024-10-16 06:28:11', NULL),
(26, 'Sonstige Dienstleistungen', 41711, '2024-10-16 06:28:11', NULL),
(27, 'Sport', 41711, '2024-10-16 06:28:11', NULL),
(28, 'Technik', 41711, '2024-10-16 06:28:11', NULL),
(29, 'Textil- / Lederindustrie', 41711, '2024-10-16 06:28:11', NULL),
(30, 'Tourismus / Gastronomie', 41711, '2024-10-16 06:28:11', NULL),
(31, 'Transport / Verkehr', 41711, '2024-10-16 06:28:11', NULL),
(32, 'Umwelttechnik / Entsorgung / Recycling', 41711, '2024-10-16 06:28:11', NULL),
(33, 'Versicherungsgewerbe', 41711, '2024-10-16 06:28:11', NULL),
(34, 'Werbung', 41711, '2024-10-16 06:28:11', NULL),
(35, 'Wirtschaftspr. / Steuerb. / Rechtswesen / Öff. Dienst', 41711, '2024-10-16 06:28:11', NULL),
(36, 'Zeitarbeit', 41711, '2024-10-16 06:28:11', NULL),
(37, 'Architektur', 41636, '2024-10-16 11:18:31', NULL),
(38, 'Baugewerbe & Immobilienwirtschaft', 41636, '2024-10-16 11:18:31', NULL),
(39, 'Branchenunabhängig', 41636, '2024-10-16 11:18:31', NULL),
(40, 'Chemie / Pharmazeut. Industrie', 41636, '2024-10-16 11:18:31', NULL),
(41, 'Chor', 41636, '2024-10-16 11:18:31', NULL),
(42, 'EDV / Datenverarbeitung / Informatik (Software)', 41636, '2024-10-16 11:18:31', NULL),
(43, 'Elektrotechnik / Elektronik / Feinmechanik / Optik', 41636, '2024-10-16 11:18:31', NULL),
(44, 'Energie- / Wasserversorgung', 41636, '2024-10-16 11:18:31', NULL),
(45, 'Forschung / Lehre', 41636, '2024-10-16 11:18:31', NULL),
(46, 'Gesundheits- / Sozialwesen', 41636, '2024-10-16 11:18:31', NULL),
(47, 'Handel', 41636, '2024-10-16 11:18:31', NULL),
(48, 'Handwerk', 41636, '2024-10-16 11:18:31', NULL),
(49, 'Holz- / Möbelindustrie', 41636, '2024-10-16 11:18:31', NULL),
(50, 'Kreativberufe / Veranstaltungen', 41636, '2024-10-16 11:18:31', NULL),
(51, 'Kredit- / Finanzinstitute / Finanzdienstl.', 41636, '2024-10-16 11:18:31', NULL),
(52, 'Kunststoffverarbeitung', 41636, '2024-10-16 11:18:31', NULL),
(53, 'Land- / Forstwirtschaft', 41636, '2024-10-16 11:18:31', NULL),
(54, 'Lehr- / Erziehungsberufe', 41636, '2024-10-16 11:18:31', NULL),
(55, 'Maschinen- u. Anlagenbau', 41636, '2024-10-16 11:18:31', NULL),
(56, 'Medien / Kommunikation', 41636, '2024-10-16 11:18:31', NULL),
(57, 'Metallverarbeitung', 41636, '2024-10-16 11:18:31', NULL),
(58, 'Mode / Kosmetik', 41636, '2024-10-16 11:18:31', NULL),
(59, 'Nahrungsmittelindustrie', 41636, '2024-10-16 11:18:31', NULL),
(60, 'Papier- / Druckindustrie / Verlag', 41636, '2024-10-16 11:18:31', NULL),
(61, 'Sonstige', 41636, '2024-10-16 11:18:31', NULL),
(62, 'Sonstige Dienstleistungen', 41636, '2024-10-16 11:18:31', NULL),
(63, 'Sport', 41636, '2024-10-16 11:18:31', NULL),
(64, 'Technik', 41636, '2024-10-16 11:18:31', NULL),
(65, 'Textil- / Lederindustrie', 41636, '2024-10-16 11:18:31', NULL),
(66, 'Tourismus / Gastronomie', 41636, '2024-10-16 11:18:31', NULL),
(67, 'Transport / Verkehr', 41636, '2024-10-16 11:18:31', NULL),
(68, 'Umwelttechnik / Entsorgung / Recycling', 41636, '2024-10-16 11:18:31', NULL),
(69, 'Versicherungsgewerbe', 41636, '2024-10-16 11:18:31', NULL),
(70, 'Werbung', 41636, '2024-10-16 11:18:31', NULL),
(71, 'Wirtschaftspr. / Steuerb. / Rechtswesen / Öff. Dienst', 41636, '2024-10-16 11:18:31', NULL),
(72, 'Zeitarbeit', 41636, '2024-10-16 11:18:31', NULL),
(73, 'Architektur', 41724, '2024-10-22 06:45:14', NULL),
(74, 'Baugewerbe & Immobilienwirtschaft', 41724, '2024-10-22 06:45:14', NULL),
(75, 'Branchenunabhängig', 41724, '2024-10-22 06:45:14', NULL),
(76, 'Chemie / Pharmazeut. Industrie', 41724, '2024-10-22 06:45:14', NULL),
(77, 'Chor', 41724, '2024-10-22 06:45:14', NULL),
(78, 'EDV / Datenverarbeitung / Informatik (Software)', 41724, '2024-10-22 06:45:14', NULL),
(79, 'Elektrotechnik / Elektronik / Feinmechanik / Optik', 41724, '2024-10-22 06:45:14', NULL),
(80, 'Energie- / Wasserversorgung', 41724, '2024-10-22 06:45:14', NULL),
(81, 'Forschung / Lehre', 41724, '2024-10-22 06:45:14', NULL),
(82, 'Gesundheits- / Sozialwesen', 41724, '2024-10-22 06:45:14', NULL),
(83, 'Handel', 41724, '2024-10-22 06:45:14', NULL),
(84, 'Handwerk', 41724, '2024-10-22 06:45:14', NULL),
(85, 'Holz- / Möbelindustrie', 41724, '2024-10-22 06:45:14', NULL),
(86, 'Kreativberufe / Veranstaltungen', 41724, '2024-10-22 06:45:14', NULL),
(87, 'Kredit- / Finanzinstitute / Finanzdienstl.', 41724, '2024-10-22 06:45:14', NULL),
(88, 'Kunststoffverarbeitung', 41724, '2024-10-22 06:45:14', NULL),
(89, 'Land- / Forstwirtschaft', 41724, '2024-10-22 06:45:14', NULL),
(90, 'Lehr- / Erziehungsberufe', 41724, '2024-10-22 06:45:14', NULL),
(91, 'Maschinen- u. Anlagenbau', 41724, '2024-10-22 06:45:14', NULL),
(92, 'Medien / Kommunikation', 41724, '2024-10-22 06:45:14', NULL),
(93, 'Metallverarbeitung', 41724, '2024-10-22 06:45:14', NULL),
(94, 'Mode / Kosmetik', 41724, '2024-10-22 06:45:14', NULL),
(95, 'Nahrungsmittelindustrie', 41724, '2024-10-22 06:45:14', NULL),
(96, 'Papier- / Druckindustrie / Verlag', 41724, '2024-10-22 06:45:14', NULL),
(97, 'Sonstige', 41724, '2024-10-22 06:45:14', NULL),
(98, 'Sonstige Dienstleistungen', 41724, '2024-10-22 06:45:14', NULL),
(99, 'Sport', 41724, '2024-10-22 06:45:14', NULL),
(100, 'Technik', 41724, '2024-10-22 06:45:14', NULL),
(101, 'Textil- / Lederindustrie', 41724, '2024-10-22 06:45:14', NULL),
(102, 'Tourismus / Gastronomie', 41724, '2024-10-22 06:45:14', NULL),
(103, 'Transport / Verkehr', 41724, '2024-10-22 06:45:14', NULL),
(104, 'Umwelttechnik / Entsorgung / Recycling', 41724, '2024-10-22 06:45:14', NULL),
(105, 'Versicherungsgewerbe', 41724, '2024-10-22 06:45:14', NULL),
(106, 'Werbung', 41724, '2024-10-22 06:45:14', NULL),
(107, 'Wirtschaftspr. / Steuerb. / Rechtswesen / Öff. Dienst', 41724, '2024-10-22 06:45:14', NULL),
(108, 'Zeitarbeit', 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_invoice_status`
--

CREATE TABLE `member_default_invoice_status` (
  `id` int(11) NOT NULL,
  `invoice_name` text NOT NULL,
  `days_after_due_date` int(11) DEFAULT NULL,
  `invoice_description` text DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `action_status` int(11) NOT NULL DEFAULT 0 COMMENT '0-can Edit/Delete,\r\n1-cannot Edit/delete',
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_default_invoice_status`
--

INSERT INTO `member_default_invoice_status` (`id`, `invoice_name`, `days_after_due_date`, `invoice_description`, `user_id`, `action_status`, `created_at`, `updated_at`) VALUES
(7, 'Bezahlt', NULL, 'Rechnung vollständig bezahlt', 41711, 1, '2024-10-16 09:19:37', NULL),
(8, 'In Bearbeitung', NULL, 'Rechnung erstellt aber noch nicht versendet', 41711, 1, '2024-10-16 09:19:37', NULL),
(9, 'Mahnstufe 1', 20, 'Mahnstufe 1, 20 Tage nach Fälligkeitsdatum', 41711, 0, '2024-10-16 09:19:37', NULL),
(10, 'Mahnstufe 2', 40, 'Mahnstufe 2, 40 Tage nach Fälligkeitsdatum', 41711, 0, '2024-10-16 09:19:37', NULL),
(11, 'Mahnstufe 3', 60, 'Mahnstufe 3, 60 Tage nach Fälligkeitsdatum', 41711, 0, '2024-10-16 09:19:37', NULL),
(12, 'Storniert', NULL, 'Rechnung storniert', 41711, 1, '2024-10-16 09:19:37', NULL),
(13, 'Teilweise bezahlt', 5, 'Rechnung teilweise bezahlt', 41711, 1, '2024-10-16 09:19:37', NULL),
(14, 'Überfällig', 5, '5 Tage nach Fälligkeitsdatum', 41711, 0, '2024-10-16 09:19:37', NULL),
(15, 'Versendet', NULL, 'Rechnung versendet', 41711, 1, '2024-10-16 09:19:37', NULL),
(16, 'Bezahlt', NULL, 'Rechnung vollständig bezahlt', 41636, 1, '2024-10-16 11:18:31', NULL),
(17, 'In Bearbeitung', NULL, 'Rechnung erstellt aber noch nicht versendet', 41636, 1, '2024-10-16 11:18:31', NULL),
(18, 'Mahnstufe 1', 20, 'Mahnstufe 1, 20 Tage nach Fälligkeitsdatum', 41636, 0, '2024-10-16 11:18:31', NULL),
(19, 'Mahnstufe 2', 40, 'Mahnstufe 2, 40 Tage nach Fälligkeitsdatum', 41636, 0, '2024-10-16 11:18:31', NULL),
(20, 'Mahnstufe 3', 60, 'Mahnstufe 3, 60 Tage nach Fälligkeitsdatum', 41636, 0, '2024-10-16 11:18:31', NULL),
(21, 'Storniert', NULL, 'Rechnung storniert', 41636, 1, '2024-10-16 11:18:31', NULL),
(22, 'Teilweise bezahlt', 5, 'Rechnung teilweise bezahlt', 41636, 1, '2024-10-16 11:18:31', NULL),
(23, 'Überfällig', 5, '5 Tage nach Fälligkeitsdatum', 41636, 0, '2024-10-16 11:18:31', NULL),
(24, 'Versendet', NULL, 'Rechnung versendet', 41636, 1, '2024-10-16 11:18:31', NULL),
(25, 'Bezahlt', NULL, 'Rechnung vollständig bezahlt', 41724, 1, '2024-10-22 06:45:14', NULL),
(26, 'In Bearbeitung', NULL, 'Rechnung erstellt aber noch nicht versendet', 41724, 1, '2024-10-22 06:45:14', NULL),
(27, 'Mahnstufe 1', 20, 'Mahnstufe 1, 20 Tage nach Fälligkeitsdatum', 41724, 0, '2024-10-22 06:45:14', NULL),
(28, 'Mahnstufe 2', 40, 'Mahnstufe 2, 40 Tage nach Fälligkeitsdatum', 41724, 0, '2024-10-22 06:45:14', NULL),
(29, 'Mahnstufe 3', 60, 'Mahnstufe 3, 60 Tage nach Fälligkeitsdatum', 41724, 0, '2024-10-22 06:45:14', NULL),
(30, 'Storniert', NULL, 'Rechnung storniert', 41724, 1, '2024-10-22 06:45:14', NULL),
(31, 'Teilweise bezahlt', 5, 'Rechnung teilweise bezahlt', 41724, 1, '2024-10-22 06:45:14', NULL),
(32, 'Überfällig', 5, '5 Tage nach Fälligkeitsdatum', 41724, 0, '2024-10-22 06:45:14', NULL),
(33, 'Versendet', NULL, 'Rechnung versendet', 41724, 1, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_letter_salutation`
--

CREATE TABLE `member_default_letter_salutation` (
  `letter_salutation_id` int(11) NOT NULL,
  `letter_salutations` text NOT NULL,
  `user_id` int(11) NOT 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 `member_default_letter_salutation`
--

INSERT INTO `member_default_letter_salutation` (`letter_salutation_id`, `letter_salutations`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Hallo [Anrede] [Nachname]', 41711, '2024-10-16 06:31:44', NULL),
(2, 'Hallo [Vorname]', 41711, '2024-10-16 06:31:44', NULL),
(3, 'Sehr geehrte Damen und Herren', 41711, '2024-10-16 06:31:44', NULL),
(4, 'Sehr geehrte Frau [Nachname]', 41711, '2024-10-16 06:31:44', NULL),
(5, 'Sehr geehrte Frau [Titel] [Nachname]', 41711, '2024-10-16 06:31:44', NULL),
(6, 'Sehr geehrter Herr [Nachname]', 41711, '2024-10-16 06:31:44', NULL),
(7, 'Sehr geehrter Herr [Titel] [Nachname]', 41711, '2024-10-16 06:31:44', NULL),
(8, 'Hallo [Anrede] [Nachname]', 41636, '2024-10-16 11:18:31', NULL),
(9, 'Hallo [Vorname]', 41636, '2024-10-16 11:18:31', NULL),
(10, 'Sehr geehrte Damen und Herren', 41636, '2024-10-16 11:18:31', NULL),
(11, 'Sehr geehrte Frau [Nachname]', 41636, '2024-10-16 11:18:31', NULL),
(12, 'Sehr geehrte Frau [Titel] [Nachname]', 41636, '2024-10-16 11:18:31', NULL),
(13, 'Sehr geehrter Herr [Nachname]', 41636, '2024-10-16 11:18:31', NULL),
(14, 'Sehr geehrter Herr [Titel] [Nachname]', 41636, '2024-10-16 11:18:31', NULL),
(15, 'Hallo [Anrede] [Nachname]', 41724, '2024-10-22 06:45:14', NULL),
(16, 'Hallo [Vorname]', 41724, '2024-10-22 06:45:14', NULL),
(17, 'Sehr geehrte Damen und Herren', 41724, '2024-10-22 06:45:14', NULL),
(18, 'Sehr geehrte Frau [Nachname]', 41724, '2024-10-22 06:45:14', NULL),
(19, 'Sehr geehrte Frau [Titel] [Nachname]', 41724, '2024-10-22 06:45:14', NULL),
(20, 'Sehr geehrter Herr [Nachname]', 41724, '2024-10-22 06:45:14', NULL),
(21, 'Sehr geehrter Herr [Titel] [Nachname]', 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_marital_status`
--

CREATE TABLE `member_default_marital_status` (
  `marital_id` int(11) NOT NULL,
  `marital_status_name` text NOT NULL,
  `user_id` int(11) NOT 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 `member_default_marital_status`
--

INSERT INTO `member_default_marital_status` (`marital_id`, `marital_status_name`, `user_id`, `created_at`, `updated_at`) VALUES
(7, 'geschieden', 41711, '2024-10-16 06:52:24', NULL),
(8, 'ledig', 41711, '2024-10-16 06:52:24', NULL),
(9, 'unbekannt', 41711, '2024-10-16 06:52:24', NULL),
(10, 'verheiratet', 41711, '2024-10-16 06:52:24', NULL),
(11, 'verwitwet', 41711, '2024-10-16 06:52:24', NULL),
(12, 'geschieden', 41636, '2024-10-16 11:18:31', NULL),
(13, 'ledig', 41636, '2024-10-16 11:18:31', NULL),
(14, 'unbekannt', 41636, '2024-10-16 11:18:31', NULL),
(15, 'verheiratet', 41636, '2024-10-16 11:18:31', NULL),
(16, 'verwitwet', 41636, '2024-10-16 11:18:31', NULL),
(17, 'geschieden', 41724, '2024-10-22 06:45:14', NULL),
(18, 'ledig', 41724, '2024-10-22 06:45:14', NULL),
(19, 'unbekannt', 41724, '2024-10-22 06:45:14', NULL),
(20, 'verheiratet', 41724, '2024-10-22 06:45:14', NULL),
(21, 'verwitwet', 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_membership_levels`
--

CREATE TABLE `member_default_membership_levels` (
  `level_id` int(11) NOT NULL,
  `level_from` int(11) NOT NULL,
  `level_to` int(11) NOT NULL,
  `user_id` int(11) NOT 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 `member_default_membership_levels`
--

INSERT INTO `member_default_membership_levels` (`level_id`, `level_from`, `level_to`, `user_id`, `created_at`, `updated_at`) VALUES
(3, 0, 5, 41711, '2024-10-16 07:59:06', NULL),
(4, 6, 10, 41711, '2024-10-16 07:59:06', NULL),
(5, 11, 25, 41711, '2024-10-16 07:59:06', NULL),
(6, 26, 50, 41711, '2024-10-16 07:59:06', NULL),
(7, 51, 99, 41711, '2024-10-16 07:59:06', NULL),
(8, 0, 5, 41636, '2024-10-16 11:18:31', NULL),
(9, 6, 10, 41636, '2024-10-16 11:18:31', NULL),
(10, 11, 25, 41636, '2024-10-16 11:18:31', NULL),
(11, 26, 50, 41636, '2024-10-16 11:18:31', NULL),
(12, 51, 99, 41636, '2024-10-16 11:18:31', NULL),
(13, 0, 5, 41724, '2024-10-22 06:45:14', NULL),
(14, 6, 10, 41724, '2024-10-22 06:45:14', NULL),
(15, 11, 25, 41724, '2024-10-22 06:45:14', NULL),
(16, 26, 50, 41724, '2024-10-22 06:45:14', NULL),
(17, 51, 99, 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_note_type`
--

CREATE TABLE `member_default_note_type` (
  `note_id` int(11) NOT NULL,
  `note_type` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `action_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 - can edit/delete\r\n1- cannot edit/delete\r\n',
  `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 `member_default_note_type`
--

INSERT INTO `member_default_note_type` (`note_id`, `note_type`, `user_id`, `action_status`, `created_at`, `updated_at`) VALUES
(11, 'Besprechung', 41585, 1, '2024-10-16 08:15:48', '2024-10-18 14:02:06'),
(12, 'Sitzung', 41585, 0, '2024-10-16 08:15:48', '2024-10-18 14:02:12'),
(13, 'Sonstiges', 41585, 1, '2024-10-16 08:15:48', '2024-10-18 15:53:32'),
(14, 'Telefonat', 41585, 1, '2024-10-16 08:15:48', '2024-10-18 15:53:38'),
(15, 'Training', 41585, 0, '2024-10-16 08:15:48', '2024-10-18 15:53:42'),
(16, 'Besprechung', 41636, 1, '2024-10-16 11:18:31', NULL),
(17, 'Sitzung', 41636, 0, '2024-10-16 11:18:31', NULL),
(18, 'Sonstiges', 41636, 1, '2024-10-16 11:18:31', NULL),
(19, 'Telefonat', 41636, 1, '2024-10-16 11:18:31', NULL),
(20, 'Training', 41636, 0, '2024-10-16 11:18:31', NULL),
(21, 'Besprechung', 41724, 1, '2024-10-22 06:45:14', NULL),
(22, 'Sitzung', 41724, 0, '2024-10-22 06:45:14', NULL),
(23, 'Sonstiges', 41724, 1, '2024-10-22 06:45:14', NULL),
(24, 'Telefonat', 41724, 1, '2024-10-22 06:45:14', NULL),
(25, 'Training', 41724, 0, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_payment_method`
--

CREATE TABLE `member_default_payment_method` (
  `id` int(11) NOT NULL,
  `payment_name` text NOT NULL,
  `payment_description` text DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `action_status` int(11) NOT NULL DEFAULT 0 COMMENT '0-can Edit/Delete\r\n1-cannot Edit/delete\r\n',
  `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 `member_default_payment_method`
--

INSERT INTO `member_default_payment_method` (`id`, `payment_name`, `payment_description`, `user_id`, `action_status`, `created_at`, `updated_at`) VALUES
(19, 'Bar', 'Barzahler', 41711, 1, '2024-10-16 10:01:20', NULL),
(20, 'Keine', '', 41711, 1, '2024-10-16 10:01:20', NULL),
(21, 'Lastschrift', 'Zahlung per SEPA Lastschrift', 41711, 1, '2024-10-16 10:01:20', NULL),
(22, 'Sozialamt', 'Übernahme durch Sozialamt', 41711, 1, '2024-10-16 10:01:20', NULL),
(23, 'Überweisung', 'Überweisungszahler', 41711, 1, '2024-10-16 10:01:20', NULL),
(24, 'Bar', 'Barzahler', 41636, 1, '2024-10-16 11:18:31', NULL),
(25, 'Keine', '', 41636, 1, '2024-10-16 11:18:31', NULL),
(26, 'Lastschrift', 'Zahlung per SEPA Lastschrift', 41636, 1, '2024-10-16 11:18:31', NULL),
(27, 'Sozialamt', 'Übernahme durch Sozialamt', 41636, 1, '2024-10-16 11:18:31', NULL),
(28, 'Überweisung', 'Überweisungszahler', 41636, 1, '2024-10-16 11:18:31', NULL),
(29, 'Bar', 'Barzahler', 41724, 1, '2024-10-22 06:45:14', NULL),
(30, 'Keine', '', 41724, 1, '2024-10-22 06:45:14', NULL),
(31, 'Lastschrift', 'Zahlung per SEPA Lastschrift', 41724, 1, '2024-10-22 06:45:14', NULL),
(32, 'Sozialamt', 'Übernahme durch Sozialamt', 41724, 1, '2024-10-22 06:45:14', NULL),
(33, 'Überweisung', 'Überweisungszahler', 41724, 1, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_reason_for_leaving`
--

CREATE TABLE `member_default_reason_for_leaving` (
  `reason_id` int(11) NOT NULL,
  `reason_name` text NOT NULL,
  `user_id` int(11) NOT 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 `member_default_reason_for_leaving`
--

INSERT INTO `member_default_reason_for_leaving` (`reason_id`, `reason_name`, `user_id`, `created_at`, `updated_at`) VALUES
(4, 'Abteilungswechsel', 41711, '2024-10-16 05:33:28', NULL),
(5, 'Auflösung Abteilung', 41711, '2024-10-16 05:33:28', NULL),
(6, 'Ausschluss vom Verein', 41711, '2024-10-16 05:33:28', NULL),
(7, 'Krankheit/Verletzung', 41711, '2024-10-16 05:33:28', NULL),
(8, 'Umzug', 41711, '2024-10-16 05:33:28', NULL),
(9, 'Unbekannt', 41711, '2024-10-16 05:33:28', NULL),
(10, 'Unzufrieden', 41711, '2024-10-16 05:33:28', NULL),
(11, 'Vereinswechsel', 41711, '2024-10-16 05:33:28', NULL),
(12, 'Verstorben', 41711, '2024-10-16 05:33:28', NULL),
(13, 'Abteilungswechsel', 41636, '2024-10-16 11:18:31', NULL),
(14, 'Auflösung Abteilung', 41636, '2024-10-16 11:18:31', NULL),
(15, 'Ausschluss vom Verein', 41636, '2024-10-16 11:18:31', NULL),
(16, 'Krankheit/Verletzung', 41636, '2024-10-16 11:18:31', NULL),
(17, 'Umzug', 41636, '2024-10-16 11:18:31', NULL),
(18, 'Unbekannt', 41636, '2024-10-16 11:18:31', NULL),
(19, 'Unzufrieden', 41636, '2024-10-16 11:18:31', NULL),
(20, 'Vereinswechsel', 41636, '2024-10-16 11:18:31', NULL),
(21, 'Verstorben', 41636, '2024-10-16 11:18:31', NULL),
(22, 'Abteilungswechsel', 41724, '2024-10-22 06:45:14', NULL),
(23, 'Auflösung Abteilung', 41724, '2024-10-22 06:45:14', NULL),
(24, 'Ausschluss vom Verein', 41724, '2024-10-22 06:45:14', NULL),
(25, 'Krankheit/Verletzung', 41724, '2024-10-22 06:45:14', NULL),
(26, 'Umzug', 41724, '2024-10-22 06:45:14', NULL),
(27, 'Unbekannt', 41724, '2024-10-22 06:45:14', NULL),
(28, 'Unzufrieden', 41724, '2024-10-22 06:45:14', NULL),
(29, 'Vereinswechsel', 41724, '2024-10-22 06:45:14', NULL),
(30, 'Verstorben', 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_round_birthday`
--

CREATE TABLE `member_default_round_birthday` (
  `round_id` int(11) NOT NULL,
  `round_old` int(11) NOT NULL,
  `user_id` int(11) NOT 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 `member_default_round_birthday`
--

INSERT INTO `member_default_round_birthday` (`round_id`, `round_old`, `user_id`, `created_at`, `updated_at`) VALUES
(6, 50, 41711, '2024-10-16 09:30:14', NULL),
(7, 60, 41711, '2024-10-16 09:30:14', NULL),
(8, 70, 41711, '2024-10-16 09:30:14', NULL),
(9, 80, 41711, '2024-10-16 09:30:14', NULL),
(10, 90, 41711, '2024-10-16 09:30:14', NULL),
(11, 50, 41636, '2024-10-16 11:18:31', NULL),
(12, 60, 41636, '2024-10-16 11:18:31', NULL),
(13, 70, 41636, '2024-10-16 11:18:31', NULL),
(14, 80, 41636, '2024-10-16 11:18:31', NULL),
(15, 90, 41636, '2024-10-16 11:18:31', NULL),
(16, 50, 41724, '2024-10-22 06:45:14', NULL),
(17, 60, 41724, '2024-10-22 06:45:14', NULL),
(18, 70, 41724, '2024-10-22 06:45:14', NULL),
(19, 80, 41724, '2024-10-22 06:45:14', NULL),
(20, 90, 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_salutation`
--

CREATE TABLE `member_default_salutation` (
  `salutation_id` int(11) NOT NULL,
  `salutation_title` text NOT NULL,
  `gender_id` int(11) NOT NULL,
  `user_id` int(11) NOT 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 `member_default_salutation`
--

INSERT INTO `member_default_salutation` (`salutation_id`, `salutation_title`, `gender_id`, `user_id`, `created_at`, `updated_at`) VALUES
(5, 'Eheleute', 7, 41711, '2024-10-16 05:58:57', NULL),
(6, 'Firma', 8, 41711, '2024-10-16 05:58:57', NULL),
(7, 'Frau', 11, 41711, '2024-10-16 05:58:57', NULL),
(8, 'Gemeinde', 8, 41711, '2024-10-16 05:58:57', NULL),
(9, 'Herr', 9, 41711, '2024-10-16 05:58:57', NULL),
(10, 'Herrn', 9, 41711, '2024-10-16 05:58:57', NULL),
(11, 'Stadt', 8, 41711, '2024-10-16 05:58:57', NULL),
(12, 'Verein', 8, 41711, '2024-10-16 05:58:57', NULL),
(13, 'Eheleute', 20, 41636, '2024-10-16 11:18:31', NULL),
(14, 'Firma', 21, 41636, '2024-10-16 11:18:31', NULL),
(15, 'Frau', 24, 41636, '2024-10-16 11:18:31', NULL),
(16, 'Gemeinde', 21, 41636, '2024-10-16 11:18:31', NULL),
(17, 'Herr', 22, 41636, '2024-10-16 11:18:31', NULL),
(18, 'Herrn', 22, 41636, '2024-10-16 11:18:31', NULL),
(19, 'Stadt', 21, 41636, '2024-10-16 11:18:31', NULL),
(20, 'Verein', 21, 41636, '2024-10-16 11:18:31', NULL),
(21, 'Eheleute', 26, 41724, '2024-10-22 06:45:14', NULL),
(22, 'Firma', 27, 41724, '2024-10-22 06:45:14', NULL),
(23, 'Frau', 30, 41724, '2024-10-22 06:45:14', NULL),
(24, 'Gemeinde', 27, 41724, '2024-10-22 06:45:14', NULL),
(25, 'Herr', 28, 41724, '2024-10-22 06:45:14', NULL),
(26, 'Herrn', 28, 41724, '2024-10-22 06:45:14', NULL),
(27, 'Stadt', 27, 41724, '2024-10-22 06:45:14', NULL),
(28, 'Verein', 27, 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_title`
--

CREATE TABLE `member_default_title` (
  `title_id` int(11) NOT NULL,
  `title_name` text NOT NULL,
  `user_id` int(11) NOT 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 `member_default_title`
--

INSERT INTO `member_default_title` (`title_id`, `title_name`, `user_id`, `created_at`, `updated_at`) VALUES
(3, 'Bgm.', 41711, '2024-10-16 09:35:04', NULL),
(4, 'Dr.', 41711, '2024-10-16 09:35:04', NULL),
(5, 'Dr. Dr.', 41711, '2024-10-16 09:35:04', NULL),
(6, 'Prof.', 41711, '2024-10-16 09:35:04', NULL),
(7, 'Prof. Dr.', 41711, '2024-10-16 09:35:04', NULL),
(8, 'Bgm.', 41636, '2024-10-16 11:18:31', NULL),
(9, 'Dr.', 41636, '2024-10-16 11:18:31', NULL),
(10, 'Dr. Dr.', 41636, '2024-10-16 11:18:31', NULL),
(11, 'Prof.', 41636, '2024-10-16 11:18:31', NULL),
(12, 'Prof. Dr.', 41636, '2024-10-16 11:18:31', NULL),
(13, 'Bgm.', 41724, '2024-10-22 06:45:14', NULL),
(14, 'Dr.', 41724, '2024-10-22 06:45:14', NULL),
(15, 'Dr. Dr.', 41724, '2024-10-22 06:45:14', NULL),
(16, 'Prof.', 41724, '2024-10-22 06:45:14', NULL),
(17, 'Prof. Dr.', 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_default_VAT_rates`
--

CREATE TABLE `member_default_VAT_rates` (
  `vat_id` int(11) NOT NULL,
  `vat_description` text NOT NULL,
  `tax_rate` varchar(11) NOT NULL,
  `tax_code` int(11) DEFAULT NULL,
  `user_id` int(11) NOT 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 `member_default_VAT_rates`
--

INSERT INTO `member_default_VAT_rates` (`vat_id`, `vat_description`, `tax_rate`, `tax_code`, `user_id`, `created_at`, `updated_at`) VALUES
(3, 'Erlöse 0 % USt.', '0,00', NULL, 41711, '2024-10-16 10:02:35', NULL),
(4, 'Erlöse 7 % USt.', '7,00', 52, 41711, '2024-10-16 10:02:35', NULL),
(5, 'Erlöse 19 % USt.', '19,00', 53, 41711, '2024-10-16 10:02:35', NULL),
(6, 'Erlöse 0 % USt.', '0,00', NULL, 41636, '2024-10-16 11:18:31', NULL),
(7, 'Erlöse 7 % USt.', '7,00', 52, 41636, '2024-10-16 11:18:31', NULL),
(8, 'Erlöse 19 % USt.', '19,00', 53, 41636, '2024-10-16 11:18:31', NULL),
(9, 'Erlöse 0 % USt.', '0,00', NULL, 41724, '2024-10-22 06:45:14', NULL),
(10, 'Erlöse 7 % USt.', '7,00', 52, 41724, '2024-10-22 06:45:14', NULL),
(11, 'Erlöse 19 % USt.', '19,00', 53, 41724, '2024-10-22 06:45:14', NULL);

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

--
-- Table structure for table `member_departments`
--

CREATE TABLE `member_departments` (
  `d_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `department_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_departments`
--

INSERT INTO `member_departments` (`d_id`, `md_id`, `department_id`, `created_at`) VALUES
(1, 1, 1, '2024-03-01 13:14:31'),
(2, 1, 2, '2024-03-01 13:14:31'),
(3, 2, 1, '2024-03-05 09:11:37'),
(4, 2, 2, '2024-03-05 09:11:37'),
(5, 2, 3, '2024-03-05 09:11:37'),
(6, 3, 1, '2024-03-07 04:49:22'),
(7, 3, 2, '2024-03-07 04:49:22'),
(8, 3, 3, '2024-03-07 04:49:22'),
(9, 4, 15, '2024-03-11 05:51:46'),
(10, 5, 1, '2024-03-13 09:01:04'),
(11, 5, 2, '2024-03-13 09:01:04'),
(12, 5, 3, '2024-03-13 09:01:04'),
(13, 6, 1, '2024-03-13 09:05:53'),
(14, 6, 2, '2024-03-13 09:05:53'),
(15, 6, 3, '2024-03-13 09:05:53'),
(16, 7, 15, '2024-03-13 09:10:53'),
(17, 7, 14, '2024-03-13 09:10:53'),
(18, 8, 15, '2024-03-13 09:14:50'),
(19, 8, 14, '2024-03-13 09:14:50'),
(20, 8, 13, '2024-03-13 09:14:50'),
(21, 9, 14, '2024-03-13 09:16:41'),
(22, 10, 15, '2024-03-13 09:18:48'),
(23, 10, 14, '2024-03-13 09:18:48'),
(24, 11, 15, '2024-03-13 10:07:07'),
(25, 11, 14, '2024-03-13 10:07:07'),
(26, 12, 15, '2024-03-13 12:52:26'),
(27, 12, 14, '2024-03-13 12:52:26'),
(28, 12, 13, '2024-03-13 12:52:26'),
(29, 13, 15, '2024-03-13 12:56:42'),
(30, 13, 14, '2024-03-13 12:56:42'),
(34, 15, 22, '2024-03-27 08:47:40'),
(35, 15, 21, '2024-03-27 08:47:40'),
(36, 16, 1, '2024-04-12 09:24:16'),
(37, 16, 2, '2024-04-12 09:24:16'),
(38, 16, 3, '2024-04-12 09:24:16'),
(45, 17, 1, '2024-04-16 11:17:42'),
(46, 17, 2, '2024-04-16 11:17:42'),
(47, 17, 3, '2024-04-16 11:17:42'),
(54, 18, 1, '2024-04-16 12:11:36'),
(55, 18, 2, '2024-04-16 12:11:36'),
(56, 18, 3, '2024-04-16 12:11:36'),
(63, 19, 35, '2024-04-16 12:27:48'),
(66, 20, 1, '2024-04-17 05:22:47'),
(67, 20, 2, '2024-04-17 05:22:47'),
(68, 20, 3, '2024-04-17 05:22:47'),
(69, 21, 1, '2024-04-18 09:34:37'),
(70, 21, 2, '2024-04-18 09:34:37'),
(71, 21, 3, '2024-04-18 09:34:37'),
(72, 22, 1, '2024-04-18 10:21:56'),
(73, 22, 2, '2024-04-18 10:21:56'),
(74, 22, 3, '2024-04-18 10:21:56'),
(75, 23, 24, '2024-05-07 05:25:29'),
(76, 24, 23, '2024-05-07 05:36:28'),
(77, 25, 23, '2024-05-07 05:41:03'),
(78, 26, 26, '2024-05-07 09:17:07'),
(79, 27, 27, '2024-05-07 09:19:22'),
(80, 28, 28, '2024-05-07 10:32:26'),
(81, 29, 28, '2024-05-07 10:33:52'),
(82, 30, 30, '2024-05-07 10:46:03'),
(83, 31, 31, '2024-05-07 10:47:54'),
(84, 31, 30, '2024-05-07 10:47:54'),
(85, 32, 33, '2024-05-07 12:08:12'),
(86, 33, 32, '2024-05-07 12:10:28'),
(87, 34, 34, '2024-05-07 12:31:39'),
(88, 35, 34, '2024-05-07 12:32:50'),
(95, 41, 101, '2024-05-28 19:00:31'),
(96, 41, 102, '2024-05-28 19:00:31'),
(97, 41, 103, '2024-05-28 19:00:31'),
(98, 42, 102, '2024-05-29 10:41:38'),
(99, 42, 101, '2024-05-29 10:41:38'),
(100, 42, 103, '2024-05-29 10:41:38'),
(107, 45, 35, '2024-05-30 14:08:31'),
(108, 45, 36, '2024-05-30 14:08:31'),
(109, 45, 3, '2024-05-30 14:08:31'),
(114, 47, 35, '2024-06-04 11:59:42'),
(115, 47, 36, '2024-06-04 11:59:42'),
(117, 48, 2, '2024-06-20 16:38:26'),
(118, 49, 35, '2024-06-20 18:30:17'),
(119, 50, 35, '2024-06-21 17:47:01'),
(121, 63, 35, '2024-06-27 18:18:46'),
(122, 64, 35, '2024-06-27 18:21:28');

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

--
-- Table structure for table `member_department_main`
--

CREATE TABLE `member_department_main` (
  `dept_id` int(11) NOT NULL,
  `department_name` varchar(255) NOT NULL,
  `cost1` int(11) NOT NULL,
  `cost2` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_department_main`
--

INSERT INTO `member_department_main` (`dept_id`, `department_name`, `cost1`, `cost2`, `created_at`) VALUES
(1, 'department1 ', 12, 233, '2024-02-07 10:12:35'),
(2, 'department ', 123, 123, '2024-03-01 13:10:46');

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

--
-- Table structure for table `member_function`
--

CREATE TABLE `member_function` (
  `f_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `function_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_function`
--

INSERT INTO `member_function` (`f_id`, `md_id`, `function_id`, `created_at`) VALUES
(1, 1, 1, '2024-03-01 13:14:31'),
(2, 1, 2, '2024-03-01 13:14:31'),
(3, 2, 1, '2024-03-05 09:11:37'),
(4, 2, 2, '2024-03-05 09:11:37'),
(5, 2, 3, '2024-03-05 09:11:37'),
(6, 3, 1, '2024-03-07 04:49:22'),
(7, 3, 2, '2024-03-07 04:49:22'),
(8, 3, 3, '2024-03-07 04:49:22'),
(9, 4, 12, '2024-03-11 05:51:46'),
(10, 5, 1, '2024-03-13 09:01:04'),
(11, 5, 2, '2024-03-13 09:01:04'),
(12, 5, 3, '2024-03-13 09:01:04'),
(13, 6, 1, '2024-03-13 09:05:53'),
(14, 6, 2, '2024-03-13 09:05:53'),
(15, 6, 3, '2024-03-13 09:05:53'),
(16, 7, 12, '2024-03-13 09:10:53'),
(17, 7, 11, '2024-03-13 09:10:53'),
(18, 8, 12, '2024-03-13 09:14:50'),
(19, 8, 11, '2024-03-13 09:14:50'),
(20, 9, 12, '2024-03-13 09:16:41'),
(21, 10, 12, '2024-03-13 09:18:48'),
(22, 11, 12, '2024-03-13 10:07:07'),
(23, 11, 10, '2024-03-13 10:07:07'),
(24, 12, 12, '2024-03-13 12:52:26'),
(25, 12, 11, '2024-03-13 12:52:26'),
(26, 13, 12, '2024-03-13 12:56:42'),
(27, 13, 10, '2024-03-13 12:56:42'),
(28, 14, 1, '2024-03-15 12:43:37'),
(29, 14, 2, '2024-03-15 12:43:37'),
(30, 14, 3, '2024-03-15 12:43:37'),
(31, 15, 17, '2024-03-27 08:47:40'),
(32, 15, 16, '2024-03-27 08:47:40'),
(33, 15, 15, '2024-03-27 08:47:40'),
(34, 16, 1, '2024-04-12 09:24:16'),
(35, 16, 2, '2024-04-12 09:24:16'),
(36, 16, 3, '2024-04-12 09:24:16'),
(43, 17, 1, '2024-04-16 11:17:42'),
(44, 17, 2, '2024-04-16 11:17:42'),
(45, 17, 3, '2024-04-16 11:17:42'),
(52, 18, 1, '2024-04-16 12:11:36'),
(53, 18, 2, '2024-04-16 12:11:36'),
(54, 18, 3, '2024-04-16 12:11:36'),
(61, 19, 1, '2024-04-16 12:27:48'),
(62, 19, 2, '2024-04-16 12:27:48'),
(63, 19, 3, '2024-04-16 12:27:48'),
(64, 20, 1, '2024-04-17 05:22:47'),
(65, 20, 2, '2024-04-17 05:22:47'),
(66, 20, 3, '2024-04-17 05:22:47'),
(67, 21, 1, '2024-04-18 09:34:37'),
(68, 21, 2, '2024-04-18 09:34:37'),
(69, 21, 3, '2024-04-18 09:34:37'),
(70, 22, 1, '2024-04-18 10:21:56'),
(71, 22, 2, '2024-04-18 10:21:56'),
(72, 22, 3, '2024-04-18 10:21:56'),
(73, 23, 19, '2024-05-07 05:25:29'),
(74, 24, 20, '2024-05-07 05:36:28'),
(75, 25, 19, '2024-05-07 05:41:03'),
(76, 26, 21, '2024-05-07 09:17:07'),
(77, 27, 22, '2024-05-07 09:19:22'),
(78, 28, 23, '2024-05-07 10:32:26'),
(79, 29, 24, '2024-05-07 10:33:52'),
(80, 30, 25, '2024-05-07 10:46:03'),
(81, 31, 26, '2024-05-07 10:47:54'),
(82, 31, 25, '2024-05-07 10:47:54'),
(83, 32, 28, '2024-05-07 12:08:12'),
(84, 33, 28, '2024-05-07 12:10:28'),
(85, 34, 29, '2024-05-07 12:31:39'),
(86, 35, 29, '2024-05-07 12:32:50'),
(88, 66, 31, '2024-07-05 06:43:07');

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

--
-- Table structure for table `member_function_main`
--

CREATE TABLE `member_function_main` (
  `f_id` int(11) NOT NULL,
  `function_name` varchar(255) NOT 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 `member_function_main`
--

INSERT INTO `member_function_main` (`f_id`, `function_name`, `created_at`, `updated_at`) VALUES
(1, 'function1 ', '2024-03-01 13:12:42', NULL),
(2, 'function 2 ', '2024-03-01 13:12:56', '2024-03-01 13:13:12');

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

--
-- Table structure for table `member_honors`
--

CREATE TABLE `member_honors` (
  `h_id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `honor` varchar(50) NOT NULL,
  `description` varchar(500) NOT NULL,
  `showInTheClubCalendar` varchar(11) NOT 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 `member_honors`
--

INSERT INTO `member_honors` (`h_id`, `md_id`, `date`, `honor`, `description`, `showInTheClubCalendar`, `created_at`, `updated_at`) VALUES
(3, 12, '2024-03-19', 'Honor', 'Description', 'yes', '2024-03-18 13:15:59', '2024-03-18 13:16:24');

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

--
-- Table structure for table `member_main_data`
--

CREATE TABLE `member_main_data` (
  `md_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `membershipNo` varchar(50) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `salutation` varchar(50) DEFAULT NULL,
  `letterSalutation` varchar(255) DEFAULT NULL,
  `firstName` varchar(255) NOT NULL,
  `lastName` varchar(255) NOT NULL,
  `street` varchar(255) DEFAULT NULL,
  `postcode` int(11) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `additionalAddress` varchar(500) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `birthDate` varchar(50) NOT NULL,
  `birthday_relase_app` varchar(50) DEFAULT NULL,
  `gender` varchar(50) DEFAULT NULL,
  `maritalStatus` varchar(50) DEFAULT NULL,
  `emergencyNumber` varchar(20) DEFAULT NULL,
  `emergencyContact` varchar(20) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `role` varchar(255) NOT NULL,
  `entryDate` varchar(255) NOT NULL,
  `image` longtext DEFAULT NULL,
  `self_verified` int(11) NOT NULL DEFAULT 1 COMMENT '1 -> default\r\n0->cretaed from Link\r\n2->self activate',
  `applicant_fname` varchar(250) DEFAULT NULL,
  `applicant_lname` varchar(250) DEFAULT NULL,
  `applicant_email` varchar(250) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_main_data`
--

INSERT INTO `member_main_data` (`md_id`, `user_id`, `membershipNo`, `title`, `salutation`, `letterSalutation`, `firstName`, `lastName`, `street`, `postcode`, `city`, `additionalAddress`, `country`, `birthDate`, `birthday_relase_app`, `gender`, `maritalStatus`, `emergencyNumber`, `emergencyContact`, `email`, `role`, `entryDate`, `image`, `self_verified`, `applicant_fname`, `applicant_lname`, `applicant_email`, `created_at`, `updated_at`) VALUES
(15, 12345, '4145089', 'dr', 'bitte', 'halloVorname', 'StteJjlZQ', 'PASdC69kk', 'mQMYIqKHd', 82120, 'PYXUX7ue9', 'new address', 'DE', '1964-11-02 18:00:00', NULL, 'female', 'ledig', '2232549', '3762339', 'hb@yopmail.com', 'member', '2024-03-25T18:00:00.000Z', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/March/Images/3736.jpg', 1, NULL, NULL, NULL, '2024-03-27 08:47:40', '2024-04-12 08:49:26'),
(16, 41504, '12345', 'Prof.', 'Miss', 'Hello (Firstname)', 'John', 'deuc', 'Test', 526345, 'hessen', 'No address', 'germany', '1996-02-02 00:00:00', NULL, 'Male', 'Single', '7845124526', '4512545632', 'test@yopmail.com', 'Single', 'Single', NULL, 1, NULL, NULL, NULL, '2024-04-12 09:24:16', '2024-04-16 10:14:25'),
(17, 41584, '856', 'Prof.', 'Miss', 'Hello miss', 'Leonie', 'Beike', 'Osterhofen', 895645, 'Kirchenallee', 'No address', 'germany', '1999-02-02 00:00:00', NULL, 'Male', 'Single', '7845124526', '4512545632', 'beike@yopmail.com', 'member', '16-04-2024', NULL, 2, NULL, NULL, NULL, '2024-04-16 11:07:43', '2024-06-14 12:03:50'),
(18, 41585, '859', 'Prof.', 'Miss', 'Hello miss', 'Kathrin', 'Wagner', 'Amsinckstrasse 64', 8481, 'Lengenfeld', 'No address', 'germany', '1999-02-02 00:00:00', NULL, 'Male', 'Single', '7845124526', '4512545632', 'beike@yopmail.com', 'member', '16-04-2024', NULL, 1, NULL, NULL, NULL, '2024-04-16 12:11:10', '2024-04-16 12:16:47'),
(19, 41585, NULL, 'Prof.', 'Mr.', 'Hello Mr.', 'Herr', 'Kuno', 'Kaiserplatz 11', 53113, 'Bonn', 'Kaiserplatz 11', 'germany', '1998-02-02 00:00:00', NULL, 'Male', 'Single', '8956254152', '4512545632', 'kuno@yopmail.com', 'member', '16-04-2024', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/April/Images/Tennisspielerin.jpeg', 1, NULL, NULL, NULL, '2024-04-16 12:13:24', '2024-06-27 10:36:09'),
(20, 41589, '85978', 'Prof.', 'Miss', 'Hello (Miss', 'Ralf', 'naumann@yopmail.com', 'Test', 526345, 'hessen', 'No address', 'germany', '1996-02-02 00:00:00', NULL, 'Male', 'Single', '7845124526', '4512545632', 'naumann@yopmail.com', 'Single', 'Single', 'https://minio.staging.verein.cloud/tineon/Leipzig/2024/May/Images/Tennis-Minis.jpeg', 1, NULL, NULL, NULL, '2024-04-17 05:22:47', '2024-05-17 10:12:00'),
(21, 41591, '41519', 'Prof.', 'Miss', 'Hello mr', 'David', 'Meier', 'Ziegelstr. 37', 84567, 'Erlbach', 'No address', 'germany', '1989-06-02 00:00:00', NULL, 'Male', 'Single', '7845124526', '4512545632', 'meier@yopmail.com', 'Single', 'Single', NULL, 1, NULL, NULL, NULL, '2024-04-18 09:34:37', '2024-04-18 09:53:19'),
(22, 41592, '415866', 'Prof.', 'Miss', 'Hello Mr', 'Doreen', 'Pabst', 'Bleibtreustraße 83', 78234, 'hessen', 'No address', 'germany', '1996-02-02 00:00:00', NULL, 'Male', 'Single', '7845124526', '4512545632', 'pabst@yopmail.com', 'Single', 'Single', NULL, 1, NULL, NULL, NULL, '2024-04-18 10:21:56', '2024-04-18 10:26:24'),
(23, 41597, '891', 'dr', 'frau', 'SehrGeehrterHerrNachname', 'Nadine', 'Bieber', 'Hoheluftchaussee 86', 16857, 'Kyritz', NULL, 'DE', '1990-05-04 13:00:00', NULL, 'female', 'verwitwet', NULL, NULL, 'bieber@yopmail.com', 'company', '2024-05-06T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 05:25:29', '2024-05-07 06:17:33'),
(24, 41597, '890', 'profDr', 'frau', 'SehrGeehrterHerrNachname', 'Martina', 'Schmid', 'Karl-Liebknecht-Strasse 96', 27386, 'Kirchwalsede', NULL, 'DE', '1995-05-05 13:00:00', NULL, 'female', 'verwitwet', NULL, NULL, 'schmid@yopmail.com', 'member', '2024-05-06T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 05:36:28', '2024-05-07 06:06:06'),
(25, 41597, '899', 'prof', 'firma', 'SehrGeehrterHerrNachname', 'Erik', 'Kluge', 'Dunum', 26427, 'Dunum', NULL, 'DE', '2000-04-30 13:00:00', NULL, 'female', 'verheiratet', NULL, NULL, 'kluge@yopmail.com', 'member', '2024-04-30T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 05:41:03', '2024-05-07 05:59:42'),
(26, 41598, NULL, NULL, NULL, NULL, 'Anja', 'Kimball', 'Michaelkirchstr. 8', 31655, 'Stadthagen', NULL, NULL, '1996-08-20 18:30:00', NULL, 'male', NULL, NULL, NULL, 'anja@yopmail.com', 'company', '2024-05-05T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 09:17:07', NULL),
(27, 41598, NULL, NULL, NULL, NULL, 'Ramos', 'Ruth', 'Hermannstrasse 64', 67590, 'Monsheim', NULL, NULL, '1997-05-26 18:30:00', NULL, 'male', NULL, NULL, NULL, 'ruth@yopmail.com', 'company', '2024-05-19T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 09:19:22', NULL),
(28, 41599, NULL, NULL, NULL, NULL, 'Mary', 'Brandes', 'Schoenebergerstrasse 30', 94513, 'Schonberg', NULL, NULL, '2000-12-04 18:30:00', NULL, 'divers', NULL, NULL, NULL, 'brandes@yopmail.com', 'company', '2024-05-06T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 10:32:26', NULL),
(29, 41599, NULL, NULL, NULL, NULL, 'Ethel', 'Goff', 'Buelowstrasse 66', 56459, 'Langenhahn', NULL, NULL, '2016-02-14 18:30:00', NULL, 'female', NULL, NULL, NULL, 'goff@yopmail.com', 'member', '2024-05-30T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 10:33:52', NULL),
(30, 41600, NULL, NULL, NULL, NULL, 'Turnage', 'Nicole', 'Heinrich Heine Platz 99', 99941, 'Bad Langensalza', NULL, NULL, '2000-07-04 18:30:00', NULL, 'female', NULL, NULL, NULL, 'nicole@yopmail.com', 'member', '2024-05-06T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 10:46:03', NULL),
(31, 41600, NULL, NULL, NULL, NULL, 'Watts', 'Tiffany', 'Knesebeckstraße 37', 52249, 'Eschweiler', NULL, NULL, '1999-05-14 18:30:00', NULL, 'male', NULL, NULL, NULL, 'tiffany@yopmail.com', 'member', '2024-05-06T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 10:47:54', NULL),
(32, 41602, NULL, NULL, NULL, NULL, 'Valerie', 'King', 'Feldstrasse 50', 39521, 'Schonhausen', NULL, NULL, '1992-06-14 18:30:00', NULL, 'female', NULL, NULL, NULL, 'king@yopmail.com', 'company', '2024-05-06T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 12:08:12', NULL),
(33, 41602, NULL, NULL, NULL, NULL, 'Diane', 'Wood', 'Paderborner Strasse 96', 86554, 'Pottmes', NULL, NULL, '2003-01-07 18:30:00', NULL, 'jurPerson', NULL, NULL, NULL, 'wood@yopmail.com', 'member', '2024-05-06T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 12:10:28', NULL),
(34, 41603, NULL, NULL, NULL, NULL, 'Rita', 'Flowers', 'Paul-Nevermann-Platz 95', 97792, 'Riedenberg', NULL, NULL, '1993-01-04 18:30:00', NULL, 'female', NULL, NULL, NULL, 'rita@yopmail.com', 'company', '2024-05-06T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 12:31:39', NULL),
(35, 41603, NULL, NULL, NULL, NULL, 'Amanda', 'Hoff', 'Alt Reinickendorf 24', 87527, 'Ofterschwang', NULL, NULL, '1994-03-06 18:30:00', NULL, 'divers', NULL, NULL, NULL, 'hoff@yopmail.com', 'member', '2024-05-06T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-05-07 12:32:50', NULL),
(41, 41585, NULL, NULL, 'Mr.', NULL, 'John', 'Doe', '123 Main St', 12345, 'Anytown', NULL, 'USA', '1990-01-01', NULL, 'Male', NULL, NULL, NULL, 'john@yopmail.com', 'member', '2024-05-28 19:00:31.104', NULL, 1, NULL, NULL, NULL, '2024-05-28 19:00:31', '2024-06-27 10:36:12'),
(45, 41585, NULL, NULL, 'Mr', NULL, 'Lenatr', 'Baier', 'Gubener Str. 43', 83077, 'Oberaudorf', NULL, 'DE', '1990-01-01', NULL, 'female', NULL, NULL, NULL, 'lenatr@yopmail.com', 'member', '2024-05-30 14:08:31.884', NULL, 2, NULL, NULL, NULL, '2024-05-30 14:08:31', '2024-06-14 08:35:30'),
(47, 41585, NULL, NULL, 'Mr', NULL, 'Test1', 'Test2', 'street', 45124, 'city', NULL, 'DE', '1990-01-01', NULL, 'female', NULL, NULL, NULL, 'test123@yopmail.com', 'member', '2024-06-04 11:59:42.307', NULL, 2, NULL, NULL, NULL, '2024-06-04 11:59:42', '2024-06-04 06:30:41'),
(49, 41585, NULL, NULL, 'Ms.', NULL, 'Uwe', 'kaiser', 'Leipziger Straße 37', 34439, 'Willebadessen', NULL, 'Berlin', '2016-06-22', NULL, 'Male', NULL, NULL, NULL, 'kaiser@yopmail.com', 'member', '2024-06-20 18:30:17.568', NULL, 0, NULL, NULL, NULL, '2024-06-20 18:30:17', NULL),
(54, 41591, 'UAXO000002', NULL, NULL, NULL, 'johny', 'fre', 'german', 85965, 'german', NULL, NULL, '2024-06-25 18:30:00', NULL, 'male', NULL, NULL, NULL, 'john@yopmail.com', 'member', '2024-06-25T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-06-27 11:21:30', NULL),
(58, 41591, 'UAXO000003', NULL, NULL, NULL, 'dfsd', 'fd', 'vd', 85784, 'dfd', NULL, NULL, '2024-06-27 18:30:00', NULL, 'female', NULL, NULL, NULL, 'dfz@yopmail.com', 'member', '2024-06-10T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-06-27 12:01:54', NULL),
(59, 41591, 'UAXO000001', NULL, NULL, NULL, 'DSAS', 'ASDD', 'dfd', 12133, 'dff', NULL, NULL, '2024-06-24 18:30:00', NULL, 'jurPerson', NULL, NULL, NULL, 'SDD@yopmail.com', 'member', '2024-06-27T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-06-27 12:09:11', NULL),
(60, 41591, 'UAXO000004', NULL, NULL, NULL, 'fdfsf', 'fdxf', 'sdsd', 78457, 'test', NULL, NULL, '2024-06-25 18:30:00', NULL, 'female', NULL, NULL, NULL, 'fgffdg@yopmail.com', 'member', '2024-06-18T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-06-27 12:10:00', NULL),
(61, 41591, 'u202400001', NULL, NULL, NULL, 'ererte', 'dfdd', 'DFDF', 34563, 'test', NULL, NULL, '2024-06-18 18:30:00', NULL, 'female', NULL, NULL, NULL, 'dfdgf@yopmail.com', 'member', '2024-06-25T18:30:00.000Z', NULL, 1, NULL, NULL, NULL, '2024-06-27 12:11:59', NULL),
(63, 41585, '2024000002', NULL, 'Ms.', NULL, 'test2', 'test2', 'test', 985645, 'german', NULL, 'Hamburg', '2024-06-28', NULL, 'Female', NULL, NULL, NULL, 'test2@yopmail.com', 'member', '2024-06-27 18:18:46.984', NULL, 1, 'test2', 'test2', 'test2@yopmail.com', '2024-06-27 18:18:46', '2024-07-11 09:01:45'),
(72, 41585, '2024000001', NULL, 'Mrs.', NULL, 'crm', 'aug1401', 'test', 52458, 'test', NULL, 'Deutschland', '2024-08-15', NULL, 'Female', NULL, NULL, NULL, 'crm.aug1401@yopmail.com', 'member', '2024-08-14 13:15:42.794', NULL, 0, 'crm', 'aug1401', 'crm.aug1401@yopmail.com', '2024-08-14 13:15:42', NULL),
(75, 41632, '0000000001', NULL, NULL, NULL, 'Pietro', 'Bouldering', 'Eaglestraße', 78583, 'Pitch', NULL, 'Deutschland', '1991-08-11', NULL, 'Männlich', 'Verwitwet', '+49 14 016 4443', '+49 767 822 7305', 'eitel99@jaekel.de', 'member', '2024-10-03T06:32:19.251Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:32:19', NULL),
(76, 41632, '0000000002', NULL, NULL, NULL, 'Ansgar', 'Kickboxing', 'Sharkstraße', 20549, 'Rink', NULL, 'Deutschland', '1968-01-16', NULL, 'Männlich', 'Ledig', '+49 18 020 1437', '+49 809 664 8468', 'ianlachmann@haase.de', 'member', '2024-10-03T06:32:19.271Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:32:19', NULL),
(77, 41632, '0000000003', NULL, NULL, NULL, 'Branko', 'Swimming', 'Pantherstraße', 53239, 'Park', NULL, 'Deutschland', '1990-04-21', NULL, 'Weiblich', 'Verheiratet', '+49 11 372 0301', '+49 628 315 2386', 'oeimer@aol.de', 'member', '2024-10-03T06:58:13.204Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(78, 41632, '0000000004', NULL, NULL, NULL, 'Annaliese', 'IceHockey', 'Tigerstraße', 7816, 'Ground', NULL, 'Deutschland', '1952-10-21', NULL, 'Weiblich', 'Geschieden', '+49 18 565 8756', '+49 121 363 7150', 'ljohann@flantz.org', 'member', '2024-10-03T06:58:13.214Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(79, 41632, '0000000005', NULL, NULL, NULL, 'Hannelore', 'Powerlifting', 'Eaglestraße', 87014, 'Track', NULL, 'Deutschland', '2000-02-16', NULL, 'Weiblich', 'Geschieden', '+49 13 285 8841', '+49 957 027 3137', 'vitoritter@seifert.org', 'member', '2024-10-03T06:58:13.221Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(80, 41632, '0000000006', NULL, NULL, NULL, 'Yasemin', 'Handball', 'Leopardstraße', 95207, 'Gym', NULL, 'Deutschland', '1972-01-10', NULL, 'Weiblich', 'Verwitwet', '+49 12 417 1256', '+49 924 002 0856', 'jacobxaver@gmx.de', 'member', '2024-10-03T06:58:13.226Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(81, 41632, '0000000007', NULL, NULL, NULL, 'Klaus-D.', 'Diving', 'Pantherstraße', 45244, 'Arena', NULL, 'Deutschland', '1987-11-26', NULL, 'Weiblich', 'Ledig', '+49 17 335 1218', '+49 133 533 9054', 'schenkralph@wilmsen.de', 'member', '2024-10-03T06:58:13.233Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(82, 41632, '0000000008', NULL, NULL, NULL, 'Elizabeth', 'Lacrosse', 'Leopardstraße', 42500, 'Arena', NULL, 'Deutschland', '1969-10-11', NULL, 'Männlich', 'Geschieden', '+49 19 037 8237', '+49 749 262 6890', 'christiane91@gmx.de', 'member', '2024-10-03T06:58:13.244Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(83, 41632, '0000000009', NULL, NULL, NULL, 'Cathleen', 'Surfing', 'Leopardstraße', 21222, 'Rink', NULL, 'Deutschland', '1999-01-10', NULL, 'Männlich', 'Ledig', '+49 12 672 8303', '+49 816 754 0993', 'ilosekann@budig.de', 'member', '2024-10-03T06:58:13.254Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(84, 41632, '0000000010', NULL, NULL, NULL, 'Pasquale', 'Volleyball', 'Wolfstraße', 52810, 'Field', NULL, 'Deutschland', '1973-07-15', NULL, 'Männlich', 'Ledig', '+49 18 543 7729', '+49 138 858 4799', 'bschmidt@yahoo.de', 'member', '2024-10-03T06:58:13.259Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(85, 41632, '0000000011', NULL, NULL, NULL, 'Wencke', 'TableTennis', 'Eaglestraße', 53753, 'Gym', NULL, 'Deutschland', '2004-03-21', NULL, 'Männlich', 'Ledig', '+49 13 647 5141', '+49 196 409 9705', 'minnaklotz@bachmann.com', 'member', '2024-10-03T06:58:13.264Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(86, 41632, '0000000012', NULL, NULL, NULL, 'Isabell', 'Netball', 'Wolfstraße', 25546, 'Arena', NULL, 'Deutschland', '1977-10-23', NULL, 'Weiblich', 'Verwitwet', '+49 11 062 9484', '+49 563 362 2420', 'klapphans-herbert@hotmail.de', 'member', '2024-10-03T06:58:13.269Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(87, 41632, '0000000013', NULL, NULL, NULL, 'Harriet', 'Decathlon', 'Bearstraße', 91045, 'Rink', NULL, 'Deutschland', '1947-03-14', NULL, 'Weiblich', 'Geschieden', '+49 18 740 8148', '+49 933 935 3139', 'steyelsbeth@baerer.com', 'member', '2024-10-03T06:58:13.274Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(88, 41632, '0000000014', NULL, NULL, NULL, 'Steffen', 'Tennis', 'Pantherstraße', 47897, 'Court', NULL, 'Deutschland', '1964-12-23', NULL, 'Weiblich', 'Ledig', '+49 13 058 4193', '+49 541 559 4376', 'mariusz75@hotmail.de', 'member', '2024-10-03T06:58:13.281Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(89, 41632, '0000000015', NULL, NULL, NULL, 'Sieglinde', 'Basketball', 'Falconstraße', 18430, 'Rink', NULL, 'Deutschland', '1991-01-19', NULL, 'Männlich', 'Verwitwet', '+49 16 832 8500', '+49 116 692 5853', 'edeltraudholsten@holzapfel.de', 'member', '2024-10-03T06:58:13.286Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(90, 41632, '0000000016', NULL, NULL, NULL, 'Anna-Maria', 'Athletics', 'Bearstraße', 77646, 'Arena', NULL, 'Deutschland', '1989-11-08', NULL, 'Männlich', 'Verwitwet', '+49 19 959 9364', '+49 820 897 2510', 'zaenkermira@hotmail.de', 'member', '2024-10-03T06:58:13.291Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(91, 41632, '0000000017', NULL, NULL, NULL, 'Danielle', 'Weightlifting', 'Elephantstraße', 96424, 'Rink', NULL, 'Deutschland', '1972-11-21', NULL, 'Weiblich', 'Geschieden', '+49 10 518 2444', '+49 806 965 4363', 'uweiss@kroker.org', 'member', '2024-10-03T06:58:13.295Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(92, 41632, '0000000018', NULL, NULL, NULL, 'Ante', 'Cricket', 'Eaglestraße', 39762, 'Park', NULL, 'Deutschland', '1953-06-19', NULL, 'Männlich', 'Verheiratet', '+49 19 535 2072', '+49 956 926 2047', 'friederike81@kuehnert.com', 'member', '2024-10-03T06:58:13.300Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(93, 41632, '0000000019', NULL, NULL, NULL, 'Lisette', 'FieldHockey', 'Leopardstraße', 380, 'Ground', NULL, 'Deutschland', '1996-04-21', NULL, 'Weiblich', 'Ledig', '+49 10 228 4013', '+49 427 076 4001', 'heuseranja@baerer.de', 'member', '2024-10-03T06:58:13.304Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(94, 41632, '0000000020', NULL, NULL, NULL, 'Claudia', 'Badminton', 'Sharkstraße', 20432, 'Track', NULL, 'Deutschland', '2003-07-21', NULL, 'Divers', 'Verwitwet', '+49 19 405 0060', '+49 947 239 7125', 'reisingingmar@gmx.de', 'member', '2024-10-03T06:58:13.309Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(95, 41632, '0000000021', NULL, NULL, NULL, 'Dörte', 'Snowboarding', 'Tigerstraße', 86296, 'Gym', NULL, 'Deutschland', '1953-05-30', NULL, 'Männlich', 'Ledig', '+49 12 859 3674', '+49 308 883 7929', 'hennybaehr@gmx.de', 'member', '2024-10-03T06:58:13.314Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(96, 41632, '0000000022', NULL, NULL, NULL, 'Katerina', 'Fencing', 'Leopardstraße', 16252, 'Field', NULL, 'Deutschland', '1945-06-21', NULL, 'Weiblich', 'Verwitwet', '+49 14 486 6684', '+49 930 279 1482', 'hans-georgadler@ruppert.com', 'member', '2024-10-03T06:58:13.319Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(97, 41632, '0000000023', NULL, NULL, NULL, 'Lilo', 'Squash', 'Eaglestraße', 82664, 'Court', NULL, 'Deutschland', '1960-03-07', NULL, 'Weiblich', 'Geschieden', '+49 19 780 1439', '+49 243 845 0537', 'bienmarie-louise@gmx.de', 'member', '2024-10-03T06:58:13.324Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(98, 41632, '0000000024', NULL, NULL, NULL, 'Mia', 'Karate', 'Eaglestraße', 7065, 'Ground', NULL, 'Deutschland', '1991-01-14', NULL, 'Männlich', 'Geschieden', '+49 10 528 2219', '+49 850 207 9157', 'hans-joerg38@hotmail.de', 'member', '2024-10-03T06:58:13.329Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(99, 41632, '0000000025', NULL, NULL, NULL, 'Berthold', 'Football', 'Falconstraße', 47871, 'Stadium', NULL, 'Deutschland', '1970-01-14', NULL, 'Weiblich', 'Ledig', '+49 19 399 8629', '+49 138 568 2230', 'bwerner@heser.de', 'member', '2024-10-03T06:58:13.334Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(100, 41632, '0000000026', NULL, NULL, NULL, 'Veli', 'Triathlon', 'Lionstraße', 48204, 'Pitch', NULL, 'Deutschland', '1952-11-25', NULL, 'Weiblich', 'Ledig', '+49 18 692 1899', '+49 564 129 9918', 'leopoldine94@trommler.net', 'member', '2024-10-03T06:58:13.339Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(101, 41632, '0000000027', NULL, NULL, NULL, 'Patrick', 'WaterPolo', 'Sharkstraße', 63795, 'Field', NULL, 'Deutschland', '1944-02-01', NULL, 'Weiblich', 'Geschieden', '+49 15 294 6092', '+49 809 833 5048', 'heinz-joachim78@googlemail.com', 'member', '2024-10-03T06:58:13.345Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(102, 41632, '0000000028', NULL, NULL, NULL, 'Robby', 'Golf', 'Tigerstraße', 28433, 'Court', NULL, 'Deutschland', '1989-08-10', NULL, 'Männlich', 'Verheiratet', '+49 11 581 3708', '+49 510 295 5369', 'leigenwillig@eberth.net', 'member', '2024-10-03T06:58:13.350Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(103, 41632, '0000000029', NULL, NULL, NULL, 'Marieluise', 'Climbing', 'Bearstraße', 34687, 'Pitch', NULL, 'Deutschland', '1957-01-15', NULL, 'Männlich', 'Geschieden', '+49 14 881 9369', '+49 261 821 3964', 'rosalie43@plath.de', 'member', '2024-10-03T06:58:13.355Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(104, 41632, '0000000030', NULL, NULL, NULL, 'Burkhardt', 'Skiing', 'Bearstraße', 40161, 'Gym', NULL, 'Deutschland', '1952-09-17', NULL, 'Weiblich', 'Verheiratet', '+49 18 701 2305', '+49 457 646 3185', 'seifertnikolaos@flantz.com', 'member', '2024-10-03T06:58:13.360Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(105, 41632, '0000000031', NULL, NULL, NULL, 'Hans-Jochen', 'Football', 'Sharkstraße', 25939, 'Court', NULL, 'Deutschland', '1954-05-09', NULL, 'Weiblich', 'Verheiratet', '+49 11 638 6027', '+49 864 697 8416', 'anneliese80@scholz.de', 'member', '2024-10-03T06:58:13.365Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(106, 41632, '0000000032', NULL, NULL, NULL, 'Leo', 'Rowing', 'Bearstraße', 81357, 'Arena', NULL, 'Deutschland', '1949-09-22', NULL, 'Männlich', 'Verheiratet', '+49 17 737 5944', '+49 044 660 1949', 'nielsbenthin@yahoo.de', 'member', '2024-10-03T06:58:13.370Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(107, 41632, '0000000033', NULL, NULL, NULL, 'Gunter', 'Judo', 'Eaglestraße', 83172, 'Stadium', NULL, 'Deutschland', '1949-10-06', NULL, 'Weiblich', 'Geschieden', '+49 12 921 2750', '+49 073 103 8592', 'anettmuelichen@aol.de', 'member', '2024-10-03T06:58:13.377Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(108, 41632, '0000000034', NULL, NULL, NULL, 'Ramazan', 'Skating', 'Wolfstraße', 98784, 'Pitch', NULL, 'Deutschland', '1988-05-24', NULL, 'Männlich', 'Verheiratet', '+49 15 928 4382', '+49 502 745 5302', 'schaeferhans-martin@kraushaar.de', 'member', '2024-10-03T06:58:13.382Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(109, 41632, '0000000035', NULL, NULL, NULL, 'Annelise', 'Hockey', 'Lionstraße', 18600, 'Track', NULL, 'Deutschland', '1958-04-30', NULL, 'Weiblich', 'Geschieden', '+49 14 599 1652', '+49 220 714 8533', 'ottoannamaria@trupp.net', 'member', '2024-10-03T06:58:13.387Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(110, 41632, '0000000036', NULL, NULL, NULL, 'Lissi', 'Running', 'Tigerstraße', 92871, 'Stadium', NULL, 'Deutschland', '1957-12-10', NULL, 'Männlich', 'Verheiratet', '+49 10 435 6010', '+49 411 477 3305', 'bbeer@gmail.com', 'member', '2024-10-03T06:58:13.391Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(111, 41632, '0000000037', NULL, NULL, NULL, 'Diethard', 'Cycling', 'Lionstraße', 42441, 'Rink', NULL, 'Deutschland', '1991-09-08', NULL, 'Weiblich', 'Verheiratet', '+49 16 448 1887', '+49 756 045 5970', 'gmoechlichen@oderwald.com', 'member', '2024-10-03T06:58:13.396Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(112, 41632, '0000000038', NULL, NULL, NULL, 'Reginald', 'Boxing', 'Sharkstraße', 77809, 'Gym', NULL, 'Deutschland', '1982-04-18', NULL, 'Männlich', 'Ledig', '+49 16 031 5940', '+49 686 604 9645', 'roskothapostolos@rohleder.de', 'member', '2024-10-03T06:58:13.400Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(113, 41632, '0000000039', NULL, NULL, NULL, 'Siegward', 'Polo', 'Bearstraße', 17859, 'Track', NULL, 'Deutschland', '1939-07-31', NULL, 'Männlich', 'Verheiratet', '+49 11 449 4561', '+49 883 156 3991', 'vstadelmann@wiek.org', 'member', '2024-10-03T06:58:13.407Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(114, 41632, '0000000040', NULL, NULL, NULL, 'Elly', 'Tennis', 'Lionstraße', 30289, 'Stadium', NULL, 'Deutschland', '1966-06-03', NULL, 'Männlich', 'Verwitwet', '+49 17 552 1998', '+49 190 824 9872', 'marisawagenknecht@aol.de', 'member', '2024-10-03T06:58:13.411Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(115, 41632, '0000000041', NULL, NULL, NULL, 'Gundula', 'Archery', 'Tigerstraße', 21228, 'Arena', NULL, 'Deutschland', '1984-11-02', NULL, 'Weiblich', 'Geschieden', '+49 13 348 7049', '+49 008 537 2490', 'jannahuhn@finke.com', 'member', '2024-10-03T06:58:13.416Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(116, 41632, '0000000042', NULL, NULL, NULL, 'Burghard', 'Rugby', 'Leopardstraße', 31864, 'Court', NULL, 'Deutschland', '1989-03-10', NULL, 'Weiblich', 'Ledig', '+49 19 957 1173', '+49 499 876 0018', 'klaus-ulrichlosekann@gmail.com', 'member', '2024-10-03T06:58:13.421Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(117, 41632, '0000000043', NULL, NULL, NULL, 'Randolf', 'Sailing', 'Tigerstraße', 43626, 'Court', NULL, 'Deutschland', '1950-10-15', NULL, 'Männlich', 'Geschieden', '+49 18 472 8182', '+49 009 763 0101', 'nikolai72@nohlmans.org', 'member', '2024-10-03T06:58:13.439Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(118, 41632, '0000000044', NULL, NULL, NULL, 'Alexandros', 'Pentathlon', 'Falconstraße', 63213, 'Pitch', NULL, 'Deutschland', '1957-02-24', NULL, 'Männlich', 'Verheiratet', '+49 17 173 0800', '+49 730 456 5736', 'xreichmann@web.de', 'member', '2024-10-03T06:58:13.451Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(119, 41632, '0000000045', NULL, NULL, NULL, 'Peggy', 'Rodeo', 'Bearstraße', 93328, 'Ground', NULL, 'Deutschland', '1942-10-15', NULL, 'Weiblich', 'Ledig', '+49 15 982 9477', '+49 610 940 7652', 'soelzerharri@gmx.de', 'member', '2024-10-03T06:58:13.461Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(120, 41632, '0000000046', NULL, NULL, NULL, 'Leo', 'Wrestling', 'Wolfstraße', 39258, 'Rink', NULL, 'Deutschland', '1963-06-27', NULL, 'Männlich', 'Verheiratet', '+49 17 247 9565', '+49 473 483 6301', 'ronnyvollbrecht@steckel.com', 'member', '2024-10-03T06:58:13.468Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(121, 41632, '0000000047', NULL, NULL, NULL, 'Hendrik', 'MartialArts', 'Lionstraße', 50591, 'Track', NULL, 'Deutschland', '2002-08-08', NULL, 'Divers', 'Verwitwet', '+49 10 768 2261', '+49 702 629 3081', 'heinz-guentherrogner@radisch.com', 'member', '2024-10-03T06:58:13.474Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(122, 41632, '0000000048', NULL, NULL, NULL, 'Mohamed', 'Gymnastics', 'Lionstraße', 85572, 'Rink', NULL, 'Deutschland', '1980-05-19', NULL, 'Männlich', 'Verwitwet', '+49 19 675 5761', '+49 277 229 9523', 'ikraushaar@bluemel.de', 'member', '2024-10-03T06:58:13.480Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(123, 41632, '0000000049', NULL, NULL, NULL, 'Irmengard', 'Softball', 'Sharkstraße', 56390, 'Rink', NULL, 'Deutschland', '1961-03-06', NULL, 'Divers', 'Verheiratet', '+49 12 173 1950', '+49 098 846 5882', 'tintzmannannemarie@gmail.com', 'member', '2024-10-03T06:58:13.485Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(124, 41632, '0000000050', NULL, NULL, NULL, 'Liliana', 'Baseball', 'Leopardstraße', 76569, 'Arena', NULL, 'Deutschland', '1995-03-19', NULL, 'Männlich', 'Geschieden', '+49 11 168 6935', '+49 304 261 3224', 'giovanni20@aol.de', 'member', '2024-10-03T06:58:13.490Z', NULL, 1, NULL, NULL, NULL, '2024-10-03 06:58:13', NULL),
(125, 41585, '2024000003', NULL, 'Ms.', NULL, 'test1', 'test', 'test', 52634, 'test', NULL, 'Deutschland', '2024-10-08', NULL, 'Other', NULL, NULL, NULL, 'test1@yopmail.com', 'member', '2024-10-18 13:30:02.553', NULL, 0, 'test1', 'test2', 'test1@yopmail.com', '2024-10-18 13:30:02', NULL),
(126, 41585, '2024000004', NULL, 'Ms.', NULL, 'test18', 'test', 'test', 52634, 'test', NULL, 'Deutschland', '2024-10-08', NULL, 'Other', NULL, NULL, NULL, 'test1@yopmail.com', 'member', '2024-10-18 13:36:25.691', NULL, 0, 'test1', 'test2', 'test1@yopmail.com', '2024-10-18 13:36:25', NULL),
(127, 41585, '2024000005', NULL, 'Ms.', NULL, 'check123', 'check', 'test', 85964, 'german', NULL, 'Deutschland', '2024-10-18', NULL, 'Female', NULL, NULL, NULL, 'check123@yopmail.com', 'member', '2024-10-18 15:52:36.809', NULL, 0, 'check123', 'cjeck', 'check123@yopmail.com', '2024-10-18 15:52:36', NULL),
(128, 41585, '2024000006', NULL, 'Mrs.', NULL, 'check18', 'test', 'test', 85784, 'german', NULL, 'Deutschland', '2024-10-19', NULL, 'Male', NULL, NULL, NULL, 'check18@yopmail.com', 'member', '2024-10-18 15:55:39.490', NULL, 0, 'check18', 'test', 'check18@yopmail.com', '2024-10-18 15:55:39', NULL),
(129, 41585, '2024000007', NULL, 'Mrs.', NULL, 'test1801', 'fdf', 'sd', 524556, 'df', NULL, 'Deutschland', '2024-10-18', NULL, 'Female', NULL, NULL, NULL, 'tet1801@yopmail.com', 'member', '2024-10-18 15:59:48.101', NULL, 1, 'tet1801', 'test', 'tet1801@yopmail.com', '2024-10-18 15:59:48', '2024-10-18 10:30:50');

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

--
-- Table structure for table `member_main_data_image`
--

CREATE TABLE `member_main_data_image` (
  `id` int(11) NOT NULL,
  `md_id` int(11) NOT NULL,
  `image_url` longtext NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `member_main_data_image`
--

INSERT INTO `member_main_data_image` (`id`, `md_id`, `image_url`, `created_at`) VALUES
(2, 6, '[encoded data, 163392 characters]', '2024-03-13 09:06:41');
INSERT INTO `member_main_data_image` (`id`, `md_id`, `image_url`, `created_at`) VALUES
(5, 14, '[encoded data, 163392 characters]', '2024-03-27 04:44:30');
