DROP TABLE IF EXISTS `attendees`;
CREATE TABLE `attendees` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `name` varchar(255),
    `surname` varchar(255),
    `email` varchar(255),
    `phone` varchar(255),
    `menuselections` varchar(255),
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `is_converted` varchar(255),
    `event` varchar(255)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `attendees` (`id`, `name`, `surname`, `email`, `phone`, `menuselections`, `created_at`, `updated_at`, `is_converted`, `event`) VALUES
(504, 'Thandeka', 'Malatji', 'teemalatji01@gmail.com', '0714049044', 2, '2024-11-22 16:01:12', '2024-11-22 16:01:12', '0', 9),
(505, 'Rudy', 'Kams', 'rkamst@gmail.com', '0678167809', 1, '2024-11-22 16:01:24', '2024-11-22 16:01:24', 1, 12),
(508, 'Shaquille', 'Sedibe', 'shaquis@gmail.com', '0658562659', 6, '2024-11-22 17:07:40', '2024-11-22 17:07:40', '0', 9),
(509, 'Kagiso', 'Molete', 'kagiemolete@gmail.com', '062 832 2721', 2, '2024-11-22 17:25:31', '2024-11-22 17:25:31', '0', 9),
(510, 'Zanokuhle', 'Noguba', 'Zanokuhlenoguba@gmail.com', '0651366084', 3, '2024-11-22 17:42:36', '2024-11-22 17:42:36', '0', 9),
(511, 'Zanokuhle', 'Noguba', 'Zanokuhlenoguba@gmail.com', '0651366084', 3, '2024-11-22 17:43:25', '2024-11-22 17:43:25', '0', 9),
(512, 'Junior', 'Adusei', 'adusei.junior@gmail.com', '0639335698', 3, '2024-11-21 18:14:56', '2024-11-21 18:14:56', '0', 9),
(513, 'Malik', 'Kams', 'rkamst@gmail.com', '0678167809', 1, '2024-11-21 18:41:26', '2024-11-21 18:41:26', 1, 9),
(514, 'Kamogelo', 'Moriri', 'kamogelomoriri5@live.com', '0659968968', 3, '2024-11-21 20:07:09', '2024-11-21 20:07:09', '0', 9),
(515, 'Nkosana', 'Mahlangu', 'nkosana0019@gmail.com', '0737811389', 4, '2024-11-21 20:52:03', '2024-11-21 20:52:03', '0', 9),
(516, 'Lesedi', 'Masitha', 'lesedimokonemasitha@gmail.com', '0640704426', 2, '2024-11-21 21:58:18', '2024-11-21 21:58:18', '0', 9),
(517, 'Thapelo', 'Mvubu', 'thapelo.mvubu35@gmail.com', '0763084123', 4, '2024-11-22 04:13:13', '2024-11-22 04:13:13', '0', 9),
(518, 'Siyabonga', 'Zwane', 'guccivaslap@gmail.com', '0721796235', 2, '2024-11-22 07:07:47', '2024-11-22 07:07:47', '0', 9),
(520, 'Tshiamo', 'Gwele', 'tshialungile@gmail.com', '0766991044', 1, '2024-11-22 07:21:16', '2024-11-22 07:21:16', '0', 9),
(521, 'Mandisa', 'Pompi', 'mandisapompi9@gmail.com', '0812769885', 2, '2024-11-22 13:10:18', '2024-11-22 13:10:18', '0', 9),
(524, 'Lerato', 'Legotse', 'legotselerato@gmail.com', '0614584568', 2, '2024-11-22 08:31:03', '2024-11-22 08:31:03', '0', 9),
(525, 'Mpho', 'Bogacwi', 'mpho.bogacwi@gmail.com', '0659686782', 2, '2024-11-22 07:36:05', '2024-11-22 07:36:05', '0', 9),
(526, 'Sifiso', 'Mota', 'sifisomota9@gmail.com', '0645077218', 6, '2024-11-22 13:58:43', '2024-11-22 13:58:43', '0', 9),
(527, 'Phumudzo ', 'Mphidi ', 'phathumphidi@gmail.com', '0608397833', 2, '2024-11-22 19:35:32', '2024-11-22 19:35:32', '0', 9),
(529, 'Cebile', 'Shezi', 'shezicebile00@gmail.com', '0682539249', 2, '2024-11-22 20:42:38', '2024-11-22 20:42:38', '0', 9),
(530, 'Zan', 'Kunene', 'ntombizanelezankunene@gmail.com', '068 080 9157', 2, '2024-11-23 02:13:46', '2024-11-23 02:13:46', '0', 9),
(531, 'Zan', 'Kunene', 'ntombizanelezankunene@gmail.com', '068 080 9157', 2, '2024-11-23 02:14:01', '2024-11-23 02:14:01', '0', 9),
(532, 'Zan', 'Kunene', 'ntombizanelezankunene@gmail.com', '068 080 9157', 2, '2024-11-23 02:14:26', '2024-11-23 02:14:26', '0', 9),
(533, 'Zan', 'Kunene', 'ntombizanelezankunene@gmail.com', '068 080 9157', 2, '2024-11-23 02:14:55', '2024-11-23 02:14:55', '0', 9),
(535, 'Abigail ', 'Morake', 'abigailmorake@gmail.com', '0605185344', 4, '2024-11-23 11:14:56', '2024-11-23 11:14:56', '0', 9),
(536, 'Jada', 'Ngcamphalala', 'jadamatho1108@gmail.com', '0635387568', 4, '2024-11-23 13:01:16', '2024-11-23 13:01:16', '0', 9),
(537, 'Katlego ', 'Ditsele', 'missditsele@gmail.com', '0676858375', 2, '2024-11-24 09:51:26', '2024-11-24 09:51:26', '0', 9),
(539, 'Precious Katlego ', 'Ditsele', 'missditsele@gmail.com', '0676858375', 2, '2024-11-24 09:59:52', '2024-11-24 09:59:52', '0', 9),
(540, 'Zan', 'Kunene', 'thebrownzan94@gmail.com', '068 080 9157', 2, '2024-11-24 17:16:08', '2024-11-24 17:16:08', '0', 9),
(541, 'Zan', 'Kunene', 'thebrownzan94@gmail.com', '068 080 9157', 2, '2024-11-24 17:16:15', '2024-11-24 17:16:15', '0', 9),
(542, 'Veliswa', 'Mehana ', 'vnmehana@gmail.com', '0787312200', 4, '2024-11-24 19:27:45', '2024-11-24 19:27:45', '0', 9),
(543, 'Sihle', 'Twaise', 'twaisesihle1@gmail.com', '0817291444', 2, '2024-11-25 00:57:16', '2024-11-25 00:57:16', '0', 9),
(545, 'Asekho', 'Gaxela', 'asekhogaxela0@gmail.com', '0796558786', 2, '2024-11-25 02:51:11', '2024-11-25 02:51:11', '0', 9),
(548, 'Amy', 'Morgan', 'amyjaynemorgan@gmail.com', '083 218 6527', 1, '2024-11-25 06:54:51', '2024-11-25 06:54:51', 1, 12),
(549, 'Brandon', 'Song', 'brandonlsong@gmail.com', '0846310023', 2, '2024-11-25 07:00:24', '2024-11-25 07:00:24', '0', 12),
(550, 'Amy', 'Norris', 'amyjaynemorgan@gmail.com', '0832186527', 2, '2024-11-25 07:36:24', '2024-11-25 07:36:24', 1, 12),
(557, 'Multimedia', 'Bsc.', 'kabamba.m@gmail.com', '0672721488', 4, '2024-11-25 10:14:43', '2024-11-25 10:14:43', 1, 12),
(558, 'Kabelo', 'Philiso', 'kabelo@sunfiregroup.co.za', +27823063952, 4, '2024-11-25 10:52:04', '2024-11-25 10:52:04', '0', 12),
(564, 'Kabelo', 'Philiso', 'kabelo@sunfiregroup.co.za', +27823063952, 4, '2024-11-25 11:56:24', '2024-11-25 11:56:24', '0', 13),
(565, 'Casey', 'Amber', 'caseyaprinsloo98@gmail.com', 627381274, 2, '2024-11-25 13:29:09', '2024-11-25 13:29:09', '0', 13),
(567, 'Lesego', 'Siane', 'lsgsiane12@gmail.com', '0613434239', 2, '2024-11-25 21:43:04', '2024-11-25 21:43:04', '0', 9),
(568, 'Athandwa', 'Makhathini', 'athandwa.makhathini@gmail.com', '0682544694', 16, '2024-11-26 05:12:50', '2024-11-26 05:12:50', '0', 9),
(569, 'Multimedia', 'Bsc.', 'kabamba.m@gmail.com', '0672721488', 1, '2024-11-27 12:36:28', '2024-11-27 12:36:28', 1, 12),
(584, 'Multimedia', 'Bsc.', 'kabamba.m@gmail.com', '0672721488', 2, '2024-11-27 16:12:00', '2024-11-27 16:12:00', 1, 18),
(585, 'Jaie', 'Norris', 'jaienorris.jn@gmail.com', '0658514707', 1, '2024-11-27 17:49:33', '2024-11-27 17:49:33', 1, 12),
(586, 'Jaie', 'Norris', 'jaienorris.jn@gmail.com', '0658514707', 1, '2024-11-27 17:57:57', '2024-11-27 17:57:57', 1, 12),
(587, 'Kgosi', 'Masithe', 'kgosimasithe17@gmail.com', '+27 81 728 7608', 3, '2024-11-27 21:20:44', '2024-11-27 21:20:44', '0', 9),
(588, 'Sindi', 'Khumalo', 'khumalosindi94@gmail.com', '0724970884', 5, '2024-11-27 22:24:16', '2024-11-27 22:24:16', '0', 13),
(589, 'Shone', 'Abrahams', 'shoneabrahams11@gmail.com', '(069) 536-7735', 2, '2024-11-28 06:52:01', '2024-11-28 06:52:01', '0', 13),
(590, 'Nicole', 'Roux', 'niniroux88@gmail.com', '0711200544', 2, '2024-11-28 09:16:34', '2024-11-28 09:16:34', '0', 13),
(591, 'Chanelle ', 'Moreira ', 'chanelle.moreira@gmail.com', '0836666043', 2, '2024-11-28 09:35:19', '2024-11-28 09:35:19', '0', 13),
(592, 'Lihleli', 'Mroleli', 'lmroleli@gmail.com', '0662223438', 2, '2024-11-28 09:56:21', '2024-11-28 09:56:21', '0', 9),
(593, 'Q', 'M', 'snekwes@outlook.com', '0814888627', 3, '2024-11-28 11:32:43', '2024-11-28 11:32:43', '0', 13),
(594, 'Sibo Dan Mrubata', 'Mrubata ', 'sibodan28@gmail.com', '074578602', 2, '2024-11-28 11:51:58', '2024-11-28 11:51:58', '0', 13),
(595, 'Zan', 'Kunene', 'ntombizanelezankunene@gmail.com', '068 080 9157', 2, '2024-11-28 16:43:12', '2024-11-28 16:43:12', '0', 9),
(596, 'Adam', 'Kuhl', 'adamkuhl@icloud.com', '0744880591', 3, '2024-11-29 14:52:41', '2024-11-29 14:52:41', '0', 13),
(597, 'Ty', 'Alakaÿ', 'lasovskytyron@gmail.com', '0736001190', 4, '2024-11-29 20:08:51', '2024-11-29 20:08:51', '0', 9),
(598, 'Zanokuhle', 'Noguba', 'Zanokuhlenoguba@gmail.com', '0651366084', NULL, '2024-11-30 18:13:19', '2024-11-30 18:13:19', '0', 2),
(599, 'Ntlahla ', 'Bonani', 'bonanintlahla@gmail.com', '0724287535', 3, '2024-12-02 18:48:12', '2024-12-02 18:48:12', '0', 12),
(600, 'Judi', 'Norris', 'judinorris.jn@gmail.com', '0692726068', 1, '2024-12-03 05:30:32', '2024-12-03 05:30:32', 1, 12),
(601, 'Ruth', 'Chambers', 'ruth@ruthchambers.co.za', '0832535981', 1, '2024-12-03 08:01:56', '2024-12-03 08:01:56', '0', 12),
(602, 'Lani', 'du Plessis', 'lani.duplessis1@gmail.com', '0768321813', 1, '2024-12-03 08:28:08', '2024-12-03 08:28:08', 1, 12),
(603, 'Shaun', 'Dhlamini', 'shaundlamini428@gmail.com', '072 075 8410 ', 1, '2024-12-03 15:05:23', '2024-12-03 15:05:23', 1, 12),
(604, 'Elaine', 'O''Connel', 'amyjaynemorgan@gmail.com', '0832186527', 1, '2024-12-04 10:31:04', '2024-12-04 10:31:04', 1, 12),
(605, 'Bryce', 'Nel', 'nel.bryce@gmail.com', '0729077700', 2, '2024-12-05 08:59:04', '2024-12-05 08:59:04', '0', 12),
(606, 'Carol', 'Magoane', 'magoanec@gmail.com', '0767808010', 2, '2024-12-05 15:38:59', '2024-12-05 15:38:59', 1, 12),
(607, 'Khetha', 'Mkhize', 'lindo1010@live.com', '0739751162', 2, '2024-12-05 15:46:50', '2024-12-05 15:46:50', '0', 15);