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),
(21, 558, 1400, 'ZAR', 'KAB063952', 4, 'pending', '2024-11-25 10:52:04', '2024-11-25 10:52:04', 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),
(27, 599, 1050, 'ZAR', '1733165292_NTL287535', 3, 'pending', '2024-12-02 18:48:13', '2024-12-02 18:48:13', NULL),
(28, 600, 350, 'ZAR', '1733203832_PM-M-P-726068-0', 1, 'pending', '2024-12-03 05:30:33', '2024-12-03 05:30:33', NULL),
(29, 601, 350, 'ZAR', '1733212916_RUT535981', 1, 'pending', '2024-12-03 08:01:56', '2024-12-03 08:01:56', NULL),
(30, 602, 350, 'ZAR', '1733214488_PM-M-P-321813-10', 1, 'pending', '2024-12-03 08:28:14', '2024-12-03 08:28:14', NULL),
(31, 603, 350, 'ZAR', '1733238323_PM-M-P-758410-4', 1, 'pending', '2024-12-03 15:05:23', '2024-12-03 15:05:23', NULL),
(32, 604, 350, 'ZAR', '1733308264_PM-M-P-186527-6', 1, 'pending', '2024-12-04 10:31:04', '2024-12-04 10:31:04', NULL),
(33, 605, 700, 'ZAR', '1733389144_BRY077700', 2, 'pending', '2024-12-05 08:59:04', '2024-12-05 08:59:04', NULL),
(34, 606, 700, 'ZAR', '1733413139_PM-M-P-808010-1', 2, 'pending', '2024-12-05 15:38:59', '2024-12-05 15:38:59', NULL);