DROP TABLE IF EXISTS `event_payments`;
CREATE TABLE `event_payments` (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `attendee_id` varchar(255),
    `amount` varchar(255),
    `currency` varchar(255),
    `merchant_transaction_id` varchar(255),
    `number_of_tickets` varchar(255),
    `status` varchar(255),
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` varchar(255)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `event_payments` (`id`, `attendee_id`, `amount`, `currency`, `merchant_transaction_id`, `number_of_tickets`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(15, 505, 350, 'ZAR', 'PM-M-P-167809-2', 1, 'successful', '2024-11-22 16:01:24', '2024-11-22 16:03:59', NULL),
(16, 548, 350, 'ZAR', 'PM-M-P-186527-6', 1, 'successful', '2024-11-25 06:54:51', '2024-11-25 10:58:19', NULL),
(17, 549, 700, 'ZAR', 'BRA310023', 2, 'pending', '2024-11-25 07:00:24', '2024-11-25 07:00:24', NULL),
(20, 557, 1400, 'ZAR', '1732529683_PM-M-P-562718-7', 4, 'pending', '2024-11-25 10:14:43', '2024-11-25 10:14:43', NULL),
(21, 558, 1400, 'ZAR', 'KAB063952', 4, 'pending', '2024-11-25 10:52:04', '2024-11-25 10:52:04', NULL),
(24, 569, 350, 'ZAR', 'PM-M-P-562718-7', 1, 'pending', '2024-11-27 12:36:29', '2024-11-27 12:36:29', NULL),
(25, 585, 350, 'ZAR', '1732729773_PM-M-P-514707-1', 1, 'pending', '2024-11-27 17:49:34', '2024-11-27 17:49:34', NULL),
(26, 586, 350, 'ZAR', '1732730277_PM-M-P-514707-1', 1, 'pending', '2024-11-27 17:57:57', '2024-11-27 17:57:57', NULL);