--
-- Host: localhost    Database: crowd-funding
-- ------------------------------------------------------


--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `balance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `organization_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` VALUES (1,'9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','NMB Account','7223429071066688','NMB Account','475','9c7fe719-f571-45dd-b3df-077a8a95604c','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,NULL,'2024-08-03 22:04:40','2024-08-26 04:08:31'),(2,'9cb64e6d-0d11-4425-8c71-db57333a1e5f','Account 1','2322772755015090','Account 1','1224','9c7fe719-f571-45dd-b3df-077a8a95604c','9cb6339a-97fb-4c1e-8f65-b49d5301daa5',NULL,NULL,'2024-08-07 20:02:17','2024-11-11 11:17:07'),(3,'9cdd68ec-93c7-4d5b-88b1-2995201dce9b','My Account','4898743054724951','My Account','215','9c7fe719-f571-45dd-b3df-077a8a95604c','9cdb356a-d2df-4890-9c52-d86d9ef85c40',NULL,NULL,'2024-08-27 06:33:40','2024-08-28 08:36:43'),(4,'9cf80eb5-5f3f-4892-80c6-e18ec85832f1','Test Account','2646436549139777','Test Account','17593','9c7fe719-f571-45dd-b3df-077a8a95604c','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,NULL,'2024-09-09 12:28:45','2024-11-11 11:17:07'),(5,'9d76b2c2-646a-4fc2-a0b9-927e049a19c4','An Account','4697416981138193','An Account','3028','9c7fe719-f571-45dd-b3df-077a8a95604c','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9',NULL,NULL,'2024-11-11 11:21:47','2024-11-11 12:22:03');

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `bank_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` VALUES (1,'c5f7109a-1843-4d75-8fb4-b833d5500d04','My Bank','9c7fe719-f571-45dd-b3df-077a8a95604c',NULL,'2024-08-03 23:38:06','2024-08-03 23:38:06');

--
-- Table structure for table `campaign_emails`
--

CREATE TABLE `campaign_emails` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `campaign_email_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `campaign_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'queued',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `campaign_emails`
--

INSERT INTO `campaign_emails` VALUES (1,'9d1a531e-3f93-45a5-becb-27a6bfc510bd','9d1a531c-036b-4b2c-9f9d-b6e18ded1f0a','Takudzwa','thetakudzwagozo@gmail.com','sent',NULL,'2024-09-26 13:18:12','2024-09-26 13:18:18'),(2,'9d1acddf-e599-4089-adba-18d5cd0799c7','9d1acdbb-ea70-48fb-a7a1-4881478fed58','Takudzwa','thetakudzwagozo@gmail.com','queued',NULL,'2024-09-26 19:01:27','2024-09-26 19:01:27'),(3,'9d1ace30-67ee-4622-ab47-99e238010ef7','9d1ace2e-91a4-4c53-a41f-9e25219f013b','Takudzwa','thetakudzwagozo@gmail.com','queued',NULL,'2024-09-26 19:02:19','2024-09-26 19:02:19'),(4,'9d1acf1c-69c6-4d1c-bb6c-bfd450abecda','9d1acf19-f1e6-47ab-8ecf-d6ffb710c7da','Takudzwa','thetakudzwagozo@gmail.com','queued',NULL,'2024-09-26 19:04:54','2024-09-26 19:04:54'),(5,'9d1acfb4-2069-4450-aa92-284ff937e45c','9d1acfaf-a074-43e4-a604-fdfd2d54b3c7','Takudzwa','thetakudzwagozo@gmail.com','queued',NULL,'2024-09-26 19:06:33','2024-09-26 19:06:33'),(6,'9d1acff6-a970-4bea-8ba8-a17426c041ba','9d1acff4-0a2d-4857-acfd-cedddbafe1c6','Takudzwa','thetakudzwagozo@gmail.com','sent',NULL,'2024-09-26 19:07:17','2024-09-26 19:07:37'),(7,'9d1ad0bf-c706-42af-afca-8273f78bb426','9d1ad0bd-04d4-40fc-9b97-5bdd0731b5b6','Takudzwa','thetakudzwagozo@gmail.com','sent',NULL,'2024-09-26 19:09:29','2024-09-26 19:09:34'),(8,'9d1ad1db-0dc5-4c5b-8974-0b0dfbe4d94b','9d1ad1d8-4c9d-47cf-99f6-e8cb4db99b9a','Takudzwa','thetakudzwagozo@gmail.com','sent',NULL,'2024-09-26 19:12:35','2024-09-26 19:12:41'),(9,'9d1ad2ec-9980-4b7a-b1bf-65de4a2fa3c6','9d1ad2eb-5a84-4e4d-b3f1-b97a3f744a72','Takudzwa','thetakudzwagozo@gmail.com','sent',NULL,'2024-09-26 19:15:34','2024-09-26 19:15:45'),(10,'9d1adbf5-c458-4783-ad0b-267e4e1394d9','9d1adbde-fab3-459e-8168-9c9d0b22373d','Takudzwa','thetakudzwagozo@gmail.com','sent',NULL,'2024-09-26 19:40:50','2024-09-26 19:40:54'),(11,'9d76b30b-2f12-4ad4-bf39-15c11cfebfec','9d76b306-8b9b-451a-9129-6c42159fd11c','Gozo Takudzwa','thetakudzwagozo@gmail.com','sent',NULL,'2024-11-11 11:22:35','2024-11-11 11:22:39'),(12,'9d76b30b-3385-498f-b0a1-1c7b2f82d62a','9d76b306-8b9b-451a-9129-6c42159fd11c','Takudzwa Gozo','takudzwagozo19@gmail.com','sent',NULL,'2024-11-11 11:22:35','2024-11-11 11:22:41'),(13,'9d76c2e5-ede8-4c79-89cb-7e97c12efa5a','9d76c2e2-b6c5-472c-aa31-29887c1f830c','Gozo Takudzwa','thetakudzwagozo@gmail.com','queued',NULL,'2024-11-11 12:06:55','2024-11-11 12:06:55'),(14,'9d76c2e5-efed-4e22-9650-14570e2a6121','9d76c2e2-b6c5-472c-aa31-29887c1f830c','Takudzwa Gozo','takudzwagozo19@gmail.com','queued',NULL,'2024-11-11 12:06:55','2024-11-11 12:06:55'),(15,'9d76c2e5-f058-4663-84e8-7dc10e3190a5','9d76c2e2-b6c5-472c-aa31-29887c1f830c','Martha','martha@getprismm.com','queued',NULL,'2024-11-11 12:06:55','2024-11-11 12:06:55'),(16,'9d76c2e5-f0c0-4029-a2c0-6cfa92988806','9d76c2e2-b6c5-472c-aa31-29887c1f830c','Bright','brightbhamubbt@gmail.com','queued',NULL,'2024-11-11 12:06:55','2024-11-11 12:06:55'),(17,'9d76c3e2-993b-4194-b368-934ec2ce7f72','9d76c3de-9019-4331-9d81-4f3edcfcfb11','Gozo Takudzwa','thetakudzwagozo@gmail.com','queued',NULL,'2024-11-11 12:09:41','2024-11-11 12:09:41'),(18,'9d76c3e2-9b46-463c-b072-5e1704f1f418','9d76c3de-9019-4331-9d81-4f3edcfcfb11','Takudzwa Gozo','takudzwagozo19@gmail.com','queued',NULL,'2024-11-11 12:09:41','2024-11-11 12:09:41'),(19,'9d76c3e2-9bbb-467a-83c8-a4f36776fb0e','9d76c3de-9019-4331-9d81-4f3edcfcfb11','Martha','martha@getprismm.com','queued',NULL,'2024-11-11 12:09:41','2024-11-11 12:09:41'),(20,'9d76c3e2-9c3a-4667-9102-ecaf956add74','9d76c3de-9019-4331-9d81-4f3edcfcfb11','Bright','brightbhamubbt@gmail.com','queued',NULL,'2024-11-11 12:09:41','2024-11-11 12:09:41'),(21,'9d76c462-4211-4a2d-9a6f-11b527c7f007','9d76c45f-a1e8-4d75-80dc-1fe2fada8345','Gozo Takudzwa','thetakudzwagozo@gmail.com','queued',NULL,'2024-11-11 12:11:04','2024-11-11 12:11:04'),(22,'9d76c462-4369-4ec1-8349-6fc8dcf40723','9d76c45f-a1e8-4d75-80dc-1fe2fada8345','Takudzwa Gozo','takudzwagozo19@gmail.com','queued',NULL,'2024-11-11 12:11:04','2024-11-11 12:11:04'),(23,'9d76c462-4620-441b-8be1-7436e452d107','9d76c45f-a1e8-4d75-80dc-1fe2fada8345','Martha','martha@getprismm.com','queued',NULL,'2024-11-11 12:11:04','2024-11-11 12:11:04'),(24,'9d76c462-47df-42e7-addc-707b8605aedf','9d76c45f-a1e8-4d75-80dc-1fe2fada8345','Bright','brightbhamubbt@gmail.com','queued',NULL,'2024-11-11 12:11:04','2024-11-11 12:11:04'),(25,'9d76c632-2b3a-4fdd-b760-fe028f801f50','9d76c630-c18a-4b99-877e-8e912281a489','Gozo Takudzwa','thetakudzwagozo@gmail.com','queued',NULL,'2024-11-11 12:16:08','2024-11-11 12:16:08'),(26,'9d76c632-2c42-41d1-9b4c-2567d350b25a','9d76c630-c18a-4b99-877e-8e912281a489','Takudzwa Gozo','takudzwagozo19@gmail.com','queued',NULL,'2024-11-11 12:16:08','2024-11-11 12:16:08'),(27,'9d76c632-2cc0-4c84-8d40-3b95a4aab0ac','9d76c630-c18a-4b99-877e-8e912281a489','Martha','martha@getprismm.com','queued',NULL,'2024-11-11 12:16:08','2024-11-11 12:16:08'),(28,'9d76c632-2d28-454e-9dfe-0129dd17bc3b','9d76c630-c18a-4b99-877e-8e912281a489','Bright','brightbhamubbt@gmail.com','queued',NULL,'2024-11-11 12:16:08','2024-11-11 12:16:08'),(29,'9d76c713-d3ff-4e12-b206-5976785c953c','9d76c70d-1e42-461d-b135-716bc45cff36','Gozo Takudzwa','thetakudzwagozo@gmail.com','sent',NULL,'2024-11-11 12:18:36','2024-11-11 12:18:40'),(30,'9d76c713-d60d-422c-8431-b0dd4c868e96','9d76c70d-1e42-461d-b135-716bc45cff36','Takudzwa Gozo','takudzwagozo19@gmail.com','sent',NULL,'2024-11-11 12:18:36','2024-11-11 12:18:41'),(31,'9d76c713-d66d-44d8-adf8-096c2bc1ae2f','9d76c70d-1e42-461d-b135-716bc45cff36','Martha','martha@getprismm.com','sent',NULL,'2024-11-11 12:18:36','2024-11-11 12:18:44'),(32,'9d76c713-d6e7-4ad7-ae00-5a546b62b8da','9d76c70d-1e42-461d-b135-716bc45cff36','Bright','brightbhamubbt@gmail.com','sent',NULL,'2024-11-11 12:18:36','2024-11-11 12:18:45');

--
-- Table structure for table `campaign_recipients`
--

CREATE TABLE `campaign_recipients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `campaign_recipient_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `campaign_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mailing_list_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `campaign_recipients`
--

INSERT INTO `campaign_recipients` VALUES (1,'9d1a3b9e-4936-4ccd-8e11-b036960cf7ec','9d1a3b9e-4508-41b5-81a2-04cab3169ae2','9d1a3b2b-359f-422d-bedc-cdcbbcfc11ea',NULL,'2024-09-26 12:12:29','2024-09-26 12:12:29'),(2,'9d1a531c-058b-4da7-8868-063663d9cc6d','9d1a531c-036b-4b2c-9f9d-b6e18ded1f0a','9d1a513a-aa02-45a7-ae1b-b454663628dd',NULL,'2024-09-26 13:18:10','2024-09-26 13:18:10'),(3,'9d1acdbb-f5f8-4300-9eb9-01f01187c71e','9d1acdbb-ea70-48fb-a7a1-4881478fed58','9d1a513a-aa02-45a7-ae1b-b454663628dd',NULL,'2024-09-26 19:01:03','2024-09-26 19:01:03'),(4,'9d1ace2e-96d6-4aa7-b17a-41b896a4c879','9d1ace2e-91a4-4c53-a41f-9e25219f013b','9d1a513a-aa02-45a7-ae1b-b454663628dd',NULL,'2024-09-26 19:02:18','2024-09-26 19:02:18'),(5,'9d1acf19-f516-44bf-a9d8-577bfd8bcf85','9d1acf19-f1e6-47ab-8ecf-d6ffb710c7da','9d1a513a-aa02-45a7-ae1b-b454663628dd',NULL,'2024-09-26 19:04:52','2024-09-26 19:04:52'),(6,'9d1acfaf-a363-4135-affc-f40c5527facd','9d1acfaf-a074-43e4-a604-fdfd2d54b3c7','9d1a513a-aa02-45a7-ae1b-b454663628dd',NULL,'2024-09-26 19:06:31','2024-09-26 19:06:31'),(7,'9d1acff4-0d26-44b4-a9d7-9845dfddef3a','9d1acff4-0a2d-4857-acfd-cedddbafe1c6','9d1a513a-aa02-45a7-ae1b-b454663628dd',NULL,'2024-09-26 19:07:15','2024-09-26 19:07:15'),(8,'9d1ad0bd-07be-4fbf-91b7-8706013a3bfe','9d1ad0bd-04d4-40fc-9b97-5bdd0731b5b6','9d1a513a-aa02-45a7-ae1b-b454663628dd',NULL,'2024-09-26 19:09:27','2024-09-26 19:09:27'),(9,'9d1ad1d8-4f30-45ff-863f-15b96e683e14','9d1ad1d8-4c9d-47cf-99f6-e8cb4db99b9a','9d1a513a-aa02-45a7-ae1b-b454663628dd',NULL,'2024-09-26 19:12:33','2024-09-26 19:12:33'),(10,'9d1ad2eb-5d78-4394-9f05-73834860700d','9d1ad2eb-5a84-4e4d-b3f1-b97a3f744a72','9d1a513a-aa02-45a7-ae1b-b454663628dd',NULL,'2024-09-26 19:15:33','2024-09-26 19:15:33'),(11,'9d1adbde-fe44-4b62-8df3-2af92e745142','9d1adbde-fab3-459e-8168-9c9d0b22373d','9d1a513a-aa02-45a7-ae1b-b454663628dd',NULL,'2024-09-26 19:40:35','2024-09-26 19:40:35'),(12,'9d76b306-8d34-4b14-b0bb-97d8cfa2a9db','9d76b306-8b9b-451a-9129-6c42159fd11c','9d76b10b-0773-4b6b-a40b-ca6da36c6788',NULL,'2024-11-11 11:22:32','2024-11-11 11:22:32'),(13,'9d76c2e2-b827-4f0b-a475-7c88f3fb48f4','9d76c2e2-b6c5-472c-aa31-29887c1f830c','9d76c2a8-803d-47dd-8438-6bf7bf437c82',NULL,'2024-11-11 12:06:53','2024-11-11 12:06:53'),(14,'9d76c3de-9962-4b45-802e-9e8482f5c5d6','9d76c3de-9019-4331-9d81-4f3edcfcfb11','9d76c2a8-803d-47dd-8438-6bf7bf437c82',NULL,'2024-11-11 12:09:38','2024-11-11 12:09:38'),(15,'9d76c45f-a319-4240-9845-1ac913938314','9d76c45f-a1e8-4d75-80dc-1fe2fada8345','9d76c2a8-803d-47dd-8438-6bf7bf437c82',NULL,'2024-11-11 12:11:03','2024-11-11 12:11:03'),(16,'9d76c630-c917-46e0-8a9c-21c411587214','9d76c630-c18a-4b99-877e-8e912281a489','9d76c2a8-803d-47dd-8438-6bf7bf437c82',NULL,'2024-11-11 12:16:07','2024-11-11 12:16:07'),(17,'9d76c70d-26a5-4398-b1be-f71adc1987f9','9d76c70d-1e42-461d-b135-716bc45cff36','9d76c2a8-803d-47dd-8438-6bf7bf437c82',NULL,'2024-11-11 12:18:32','2024-11-11 12:18:32');

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'9cae61f3-ac70-4886-b2cb-2945cda29f8c','Category 1','event',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16'),(2,'9cae61f3-add3-43cf-9641-90ebcbcf203a','Category 2','event',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16'),(3,'9cae61f3-af75-45ac-851a-ebd0b1a5c5b7','Category 3','event',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16'),(4,'9cae61f3-b0f0-4e06-a377-5623c677668f','Category 4','event',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16'),(5,'9cae61f3-b2d0-493d-be9e-94daa36db9b9','Category 5','event',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16'),(6,'9cae61f3-b417-4468-9d93-bb6accade837','Category 6','event',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16');

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `city_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` VALUES (1,'57d48593-e49d-459c-954b-c01f9ccced52','New York',NULL,'2024-08-03 23:56:13','2024-08-03 23:56:13');

--
-- Table structure for table `configurations`
--

CREATE TABLE `configurations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `configuration_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `configurations`
--

INSERT INTO `configurations` VALUES (5,'9d76bad1-1dfe-424d-b5ad-b89303c66627','withdrawal_charge','15',NULL,NULL,'2024-11-11 11:44:19','2024-11-11 11:44:19');

--
-- Table structure for table `contribution_forms`
--

CREATE TABLE `contribution_forms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `contribution_form_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contribution_forms`
--

INSERT INTO `contribution_forms` VALUES (1,'9cae6e5c-4fc6-46b8-b050-6c9f61315763','New Form','New Form','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-03 22:04:57','2024-08-03 22:04:57'),(2,'9cafb47c-1edf-4239-bd0e-0210f5bcbb80','Something Form','Something Form','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-04 13:16:52','2024-08-04 13:16:52');

--
-- Table structure for table `contributions`
--

CREATE TABLE `contributions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `contribution_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contributions`
--

INSERT INTO `contributions` VALUES (2,'9caf6386-1445-4576-83eb-34348193c6be','9caf6386-0e6e-43a0-b2a2-5fd6aa99be65',NULL,'2024-08-04 09:30:29','2024-08-04 09:30:29'),(3,'9cafd131-0524-4e91-ba12-bcf51018aa19','9cafd131-0067-4559-bab1-9b1a77687aac',NULL,'2024-08-04 14:37:08','2024-08-04 14:37:08'),(4,'9cafdb33-9d9f-4b01-8338-fda43c409204','9cafdb33-9768-4816-a8d7-ccbfabdfe80a',NULL,'2024-08-04 15:05:08','2024-08-04 15:05:08'),(6,'9cafe2cb-253c-46cd-8846-8bf31acb9e1f','9cafe2cb-2169-45f4-b78e-4db77a512954',NULL,'2024-08-04 15:26:21','2024-08-04 15:26:21'),(7,'9cb191d2-58a3-4036-972e-543dd9418a7d','9cb191d2-54f3-43f3-9efe-dc001fa0b5e0',NULL,'2024-08-05 11:31:36','2024-08-05 11:31:36'),(8,'9cb19ce7-586d-4e9e-b318-37d953f89a43','9cb19ce7-5639-4129-b9ca-afee2cc087f8',NULL,'2024-08-05 12:02:35','2024-08-05 12:02:35'),(9,'9cb19f69-dbe6-4d40-966a-497a88a841c7','9cb19f69-d6bf-43bc-b900-e537c7cabc77',NULL,'2024-08-05 12:09:36','2024-08-05 12:09:36');

--
-- Table structure for table `contributor_details`
--

CREATE TABLE `contributor_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `contributor_detail_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mailing_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_employed` tinyint(1) NOT NULL,
  `employer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `occupation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_birth` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contributor_details`
--

INSERT INTO `contributor_details` VALUES (1,'9caf9e51-2b0d-4f8a-9ae6-3a77978b1b1e','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',1,'ysugd','dhjd','2024-08-11','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 12:15:26','2024-08-04 13:02:33'),(2,'9cafb2df-c0f1-493e-872f-d87463c1607b','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-29','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 13:13:06','2024-08-04 13:13:35'),(3,'9cafb480-c58f-401e-9ba7-a9eac3e00c06','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','student','2024-08-23','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 13:17:05','2024-08-04 13:17:05'),(4,'9cafb52c-bb4f-46a2-ba98-d9e3fac4f1d9','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','student','2024-08-28','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 13:18:59','2024-08-04 13:18:59'),(5,'9cafb58b-fea8-4d16-94c0-4a8c5a938652','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-13','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 13:19:59','2024-08-04 13:19:59'),(6,'9cafb784-9fa6-4957-b342-5b38f953e07f','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','1981-02-24','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 13:25:34','2024-08-04 13:25:55'),(7,'9cafb81f-c151-4fa4-89c1-d66f2f6d80ac','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-08','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 13:27:14','2024-08-04 13:30:12'),(8,'9cafba87-e787-4aa2-88c1-7df70ccba3a4','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','student','2024-08-07','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 13:35:07','2024-08-04 13:35:07'),(9,'9cafd946-5a01-47a7-8684-0e5b527fa925','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2004-06-18','female','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 15:00:12','2024-08-04 15:00:12'),(10,'9cafdae9-a9bd-403c-aaea-99866ecdef40','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',1,'Proident minim volu','Aut praesentium adip','1986-09-03','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 15:04:46','2024-08-04 15:04:46'),(11,'9cafe27f-5649-44eb-9fa1-013963c4de33','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-20','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-04 15:25:46','2024-08-04 15:25:46'),(12,'9cb19165-aa6c-4e63-9eed-f3e6ef98240f','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-13','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-05 11:31:03','2024-08-05 11:31:03'),(13,'9cb19c5c-8efa-4d50-871d-f011d25d4f0d','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-07-31','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-05 12:01:31','2024-08-05 12:01:31'),(14,'9cb19f3a-bb61-47a9-819b-6c12fc5775f0','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-14','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-05 12:09:26','2024-08-05 12:09:26'),(15,'9ccc64f3-f9ba-4ce8-85ea-fe820712c6d5','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-18','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-18 19:33:48','2024-08-18 19:33:58'),(16,'9cdd81f4-50ec-4314-a869-034920292196','Takudzwa','Gozo','takudzwagozo19@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-27','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-27 07:48:14','2024-08-27 07:51:26'),(17,'9cdd945c-a1f1-4ec7-8d22-02e9d6cd2e6d','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-27','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-27 08:35:34','2024-08-27 08:35:34'),(18,'9cdd94eb-ab20-45ae-a7f9-5d6497f8c34b','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-27','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-27 08:36:53','2024-08-27 08:36:53'),(19,'9cdd95c7-910e-43d1-b92f-5f827621a524','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',1,'wu6yd','sydstds','2024-08-27','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-27 08:39:18','2024-08-27 08:39:18'),(20,'9cddb023-68d5-40fe-a497-18a3cc2a407a','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-27','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-27 09:53:01','2024-08-27 09:53:01'),(21,'9cddb0d6-558e-4d90-a8f3-32f9574f6f96','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-08-27','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-27 09:54:56','2024-08-27 09:54:56'),(22,'9d01a305-7de2-4ae6-916c-25aab9664afb','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','thetakudzwagozo@gmail.com',0,'','student','2024-09-25','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-14 06:46:19','2024-09-14 06:48:56'),(23,'9d01b13b-7e74-4f73-a8a8-697519cac9ef','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','Uve 2517, Vengere, Rusape',0,'','unemployed','2024-09-24','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-14 07:25:57','2024-09-14 07:25:57'),(24,'9d01b190-3726-4b1e-9424-71d7cb82a7c2','Lads','Africa','thetakudzwagozo@gmail.com','0785991512','Innovation Hub, HIT Campus',0,'','unemployed','2024-09-25','female','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-14 07:26:52','2024-09-14 07:27:49'),(25,'9d01b3c3-4a92-42b1-8c08-98c0526a3ece','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'Tenetur perspiciatis','unemployed','1985-10-23','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-14 07:32:57','2024-09-14 07:32:57'),(26,'9d01ed66-fe38-4df6-920e-eb625b8daccf','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-09-14','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-14 10:14:11','2024-09-14 10:14:11'),(27,'9d01f277-9b17-4c54-b699-b52d09084184','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','Uve 2517, Vengere, Rusape',0,'','unemployed','2024-09-14','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-14 10:28:26','2024-09-14 10:28:26'),(28,'9d19eae5-018c-4fbd-9f3b-692858cb1dd4','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-09-26','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-26 08:27:54','2024-09-26 08:27:54'),(29,'9d19f3e9-81c4-463c-92d3-a35b378bc2ae','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','student','2024-09-26','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-26 08:52:22','2024-09-26 08:52:22'),(30,'9d1a389d-4331-4433-880c-f286c11e4ea2','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-09-26','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-26 12:04:45','2024-09-26 12:04:45'),(31,'9d1ac454-9cad-4ede-879e-232932b265cb','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-09-26','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-26 18:34:59','2024-09-26 18:34:59'),(32,'9d1aca6f-f4ac-47a3-8d02-2ebff03f1f92','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-09-26','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-26 18:52:27','2024-09-26 18:52:40'),(33,'9d1adc10-fa3a-451e-8d67-1be83c082154','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-09-26','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-26 19:41:31','2024-09-26 19:41:31'),(34,'9d1adcca-d67a-4aa7-b9f6-75a3431eaf8b','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-09-26','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-26 19:43:30','2024-09-26 19:43:30'),(35,'9d76ae1a-3208-40ce-ac92-c5dcbd3f8d30','Takuzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park, Harare',0,'','student','2024-11-11','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-11-11 11:09:04','2024-11-11 11:09:04'),(36,'9d76af52-497f-436f-b768-d2f2ddd87037','Takuzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park, Harare',0,'','unemployed','2024-11-11','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-11-11 11:12:29','2024-11-11 11:12:29'),(37,'9d76b325-f9bf-487a-a811-2b8785a7141e','Takudzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park',0,'','unemployed','2024-11-11','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-11-11 11:23:20','2024-11-11 11:23:20'),(38,'9d76b4cd-5d52-4fbe-90ce-ee8d20509e35','Takudzwa','Gozo','takudzwagozo19@gmail.com','0785991512','1432 Granary Estate Park',0,'','student','2024-11-11','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-11-11 11:28:02','2024-11-11 11:28:02'),(39,'9d76c1be-e1f5-4dc3-bc1a-fd0e97840d07','Takuzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park, Harare',0,'','unemployed','2024-11-11','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-11-11 12:03:53','2024-11-11 12:03:53'),(40,'9d76c7a5-b595-43f3-bdea-181f4a31476d','Takuzwa','Gozo','thetakudzwagozo@gmail.com','0785991512','1432 Granary Estate Park, Harare',0,'','unemployed','2024-11-11','male','57d48593-e49d-459c-954b-c01f9ccced52','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-11-11 12:21:08','2024-11-11 12:21:08');

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `country_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'5f76bf9c-329f-439e-885c-c1760ca82a60','United States of America',NULL,'2024-08-03 23:56:36','2024-08-03 23:56:36');

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `currency_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` VALUES (1,'9c7fe719-f571-45dd-b3df-077a8a95604c','USD','USD','1',NULL,'2024-08-03 23:38:47','2024-08-03 23:38:47');

--
-- Table structure for table `currency_event`
--

CREATE TABLE `currency_event` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `currency_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currency_event`
--


--
-- Table structure for table `emails`
--

CREATE TABLE `emails` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `email_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `to` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emails`
--

INSERT INTO `emails` VALUES (3,'9cdfcc5c-9937-4902-b9a5-fd763d394714','takudzwagozo19@gmail.com','user_registered','2024-08-28 11:04:33','2024-08-28 11:03:22','2024-08-28 11:04:33'),(4,'9cdfcd26-ea8d-446d-80ec-e8d0cebad302','takudzwagozo19@gmail.com','user_updated','2024-08-28 11:05:55','2024-08-28 11:05:35','2024-08-28 11:05:55'),(5,'9cdfcd26-fd38-4b90-ab6a-42c208bab83f','takudzwagozo19@gmail.com','user_updated','2024-08-28 11:05:58','2024-08-28 11:05:35','2024-08-28 11:05:58'),(6,'9cec44fa-fa58-444a-8cc8-6baf4086ba30','thetakudzwagozo@gmail.com','user_registered','2024-09-03 15:50:51','2024-09-03 15:50:35','2024-09-03 15:50:51'),(7,'9d76ab8f-aa46-4e3f-99e0-fd77a3678451','thetakudzwagozo@gmail.com','user_registered','2024-11-11 11:03:07','2024-11-11 11:01:40','2024-11-11 11:03:07');

--
-- Table structure for table `event_attendances`
--

CREATE TABLE `event_attendances` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_attendance_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_attendances`
--


--
-- Table structure for table `event_image`
--

CREATE TABLE `event_image` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_image`
--

INSERT INTO `event_image` VALUES (1,'1','4',NULL,NULL),(2,'2','6',NULL,NULL),(3,'3','7',NULL,NULL),(4,'3','8',NULL,NULL),(5,'4','9',NULL,NULL),(6,'4','10',NULL,NULL),(7,'5','11',NULL,NULL),(8,'6','12',NULL,NULL),(9,'7','13',NULL,NULL),(10,'8','17',NULL,NULL),(11,'9','25',NULL,NULL),(12,'9','26',NULL,NULL),(13,'9','27',NULL,NULL),(14,'9','28',NULL,NULL),(15,'10','29',NULL,NULL);

--
-- Table structure for table `event_types`
--

CREATE TABLE `event_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_types`
--

INSERT INTO `event_types` VALUES (1,'9cae61f3-a72e-421a-8c63-73462113331f','Physical',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16'),(2,'9cae61f3-aa83-4c87-b667-7c070072186d','Online',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16');

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `event_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tagline` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` VALUES (1,'9cafe4b7-dde0-4fe5-b7bb-7462b62fae02','9cae61f3-ac70-4886-b2cb-2945cda29f8c','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','Event Name','<p>hdufhjf</p>','9cae61f3-aa83-4c87-b667-7c070072186d','2024-08-10T19:31','2024-08-17T19:31','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-04 15:31:44','2024-08-04 15:31:44','Event Name'),(2,'9cbf6c7f-c2a5-40a5-b8a7-72f218946a92','9cae61f3-b417-4468-9d93-bb6accade837','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','Sequi quibusdam vita','<p>dhjyudgdhd</p>','9cae61f3-a72e-421a-8c63-73462113331f','2024-01-25T19:24','2005-04-21T04:07','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-12 08:48:49','2024-08-12 08:48:49','Irure reprehenderit '),(3,'9cbfb1d0-c797-47e0-9750-4de78d224e62','9cae61f3-add3-43cf-9641-90ebcbcf203a','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','New Event','<p>This is my event</p>','9cae61f3-aa83-4c87-b667-7c070072186d','2024-08-12T16:02','2024-08-13T16:02','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-12 12:02:39','2024-08-12 12:02:39','New Event'),(4,'9cbfbf3c-e37e-4ac1-ba3c-d20780643a3e','9cae61f3-b0f0-4e06-a377-5623c677668f','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','Big Event','<p>&lt;h1&gt;Annual Tech Innovation Conference 2024&lt;/h1&gt;</p><p>&lt;img src=\"https://via.placeholder.com/1200x400.png?text=Tech+Innovation+Conference+2024\" alt=\"Tech Conference Banner\" style=\"width:100%;\"&gt;</p><p>&lt;p&gt;Welcome to the &lt;strong&gt;Annual Tech Innovation Conference 2024&lt;/strong&gt;! This premier event brings together industry leaders, innovative minds, and tech enthusiasts from around the globe to discuss the latest trends, breakthroughs, and future directions in technology. Join us for an exciting two-day journey into the world of tech innovation.&lt;/p&gt;</p><p>&lt;h2&gt;Event Details&lt;/h2&gt;<br>&lt;ul&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Date:&lt;/strong&gt; November 5-6, 2024&lt;/li&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Location:&lt;/strong&gt; Silicon Valley, California&lt;/li&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Venue:&lt;/strong&gt; The Grand Tech Arena, 123 Innovation Drive, Palo Alto, CA&lt;/li&gt;<br>&lt;/ul&gt;</p><p>&lt;h2&gt;Event Highlights&lt;/h2&gt;</p><p>&lt;h3&gt;1. Keynote Sessions&lt;/h3&gt;<br>&lt;img src=\"https://via.placeholder.com/800x400.png?text=Keynote+Speaker\" alt=\"Keynote Speaker\" style=\"width:100%;\"&gt;</p><p>&lt;p&gt;Our conference will feature keynote speeches from some of the most influential voices in the tech industry. Topics will cover everything from the impact of AI on society to the future of blockchain technology. Don’t miss out on insights from:&lt;/p&gt;<br>&lt;ul&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Elon Musk&lt;/strong&gt; – Visionary entrepreneur and CEO of SpaceX and Tesla.&lt;/li&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Sundar Pichai&lt;/strong&gt; – CEO of Alphabet Inc., discussing the future of AI.&lt;/li&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Ginni Rometty&lt;/strong&gt; – Former CEO of IBM, sharing her journey in technology leadership.&lt;/li&gt;<br>&lt;/ul&gt;</p><p>&lt;h3&gt;2. Interactive Workshops&lt;/h3&gt;<br>&lt;img src=\"https://via.placeholder.com/800x400.png?text=Interactive+Workshop\" alt=\"Workshop\" style=\"width:100%;\"&gt;</p><p>&lt;p&gt;Our hands-on workshops are designed to equip you with practical skills in the latest technologies. Whether you\'re interested in machine learning, cybersecurity, or blockchain, our experts will guide you through real-world applications. Workshops include:&lt;/p&gt;<br>&lt;ul&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;AI in Action:&lt;/strong&gt; Learn how to build and deploy AI models with Python.&lt;/li&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Blockchain Basics:&lt;/strong&gt; A step-by-step guide to understanding and using blockchain.&lt;/li&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Cybersecurity Essentials:&lt;/strong&gt; Protecting your digital assets in an interconnected world.&lt;/li&gt;<br>&lt;/ul&gt;</p><p>&lt;h3&gt;3. Tech Expo&lt;/h3&gt;<br>&lt;img src=\"https://via.placeholder.com/800x400.png?text=Tech+Expo\" alt=\"Tech Expo\" style=\"width:100%;\"&gt;</p><p>&lt;p&gt;The Tech Expo is a showcase of the latest innovations from top tech companies, startups, and research institutions. Discover groundbreaking products, cutting-edge prototypes, and futuristic concepts that will shape tomorrow’s world. Featured exhibitors include:&lt;/p&gt;<br>&lt;ul&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Google:&lt;/strong&gt; Showcasing the latest advancements in quantum computing.&lt;/li&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Apple:&lt;/strong&gt; A sneak peek into their new augmented reality (AR) projects.&lt;/li&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Microsoft:&lt;/strong&gt; Presenting innovations in cloud computing and AI integration.&lt;/li&gt;<br>&lt;/ul&gt;</p><p>&lt;h3&gt;4. Networking Opportunities&lt;/h3&gt;<br>&lt;img src=\"https://via.placeholder.com/800x400.png?text=Networking+Opportunities\" alt=\"Networking\" style=\"width:100%;\"&gt;</p><p>&lt;p&gt;Connect with like-minded professionals, potential collaborators, and industry experts during our dedicated networking sessions. Whether you’re looking to share ideas, find partners, or explore new career opportunities, our event offers ample time for meaningful interactions. Networking highlights:&lt;/p&gt;<br>&lt;ul&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Speed Networking:&lt;/strong&gt; Meet new contacts quickly in a series of short, timed interactions.&lt;/li&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Industry Roundtables:&lt;/strong&gt; Join discussions with peers from your sector.&lt;/li&gt;<br>&nbsp; &nbsp;&lt;li&gt;&lt;strong&gt;Evening Gala:&lt;/strong&gt; Enjoy a night of entertainment, fine dining, and conversation with fellow attendees.&lt;/li&gt;<br>&lt;/ul&gt;</p><p>&lt;h2&gt;Speakers&lt;/h2&gt;</p><p>&lt;h3&gt;Elon Musk&lt;/h3&gt;<br>&lt;img src=\"https://via.placeholder.com/400x400.png?text=Elon+Musk\" alt=\"Elon Musk\" style=\"width:100%;\"&gt;</p><p>&lt;p&gt;&lt;strong&gt;Topic:&lt;/strong&gt; &lt;em&gt;The Future of Space Exploration and Sustainable Energy&lt;/em&gt;&lt;/p&gt;<br>&lt;p&gt;Elon Musk is a visionary entrepreneur known for his work with SpaceX, Tesla, and Neuralink. In this keynote, he will share his insights into the future of space travel and the critical role of sustainable energy in preserving our planet.&lt;/p&gt;</p><p>&lt;h3&gt;Sundar Pichai&lt;/h3&gt;<br>&lt;img src=\"https://via.placeholder.com/400x400.png?text=Sundar+Pichai\" alt=\"Sundar Pichai\" style=\"width:100%;\"&gt;</p><p>&lt;p&gt;&lt;strong&gt;Topic:&lt;/strong&gt; &lt;em&gt;AI and Its Impact on the Future of Work&lt;/em&gt;&lt;/p&gt;<br>&lt;p&gt;Sundar Pichai, CEO of Alphabet Inc., will discuss how AI is transforming industries and reshaping the future of work. His talk will cover Google’s latest AI advancements and their implications for global employment.&lt;/p&gt;</p><p>&lt;h3&gt;Ginni Rometty&lt;/h3&gt;<br>&lt;img src=\"https://via.placeholder.com/400x400.png?text=Ginni+Rometty\" alt=\"Ginni Rometty\" style=\"width:100%;\"&gt;</p><p>&lt;p&gt;&lt;strong&gt;Topic:&lt;/strong&gt; &lt;em&gt;Leadership in a Digital World&lt;/em&gt;&lt;/p&gt;<br>&lt;p&gt;Ginni Rometty, former CEO of IBM, will share her journey of leading one of the world’s largest tech companies through a time of significant transformation. She will discuss the challenges and opportunities of leadership in a digital age.&lt;/p&gt;</p><p>&lt;h2&gt;Schedule&lt;/h2&gt;</p><p>&lt;img src=\"https://via.placeholder.com/1200x800.png?text=Event+Schedule\" alt=\"Event Schedule\" style=\"width:100%;\"&gt;</p><p>&lt;table style=\"width:100%; border-collapse: collapse;\"&gt;<br>&nbsp; &nbsp;&lt;tr&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;th style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Time&lt;/th&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;th style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Session&lt;/th&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;th style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Location&lt;/th&gt;<br>&nbsp; &nbsp;&lt;/tr&gt;<br>&nbsp; &nbsp;&lt;tr&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;8:00 AM&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Registration and Breakfast&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Lobby&lt;/td&gt;<br>&nbsp; &nbsp;&lt;/tr&gt;<br>&nbsp; &nbsp;&lt;tr&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;9:00 AM&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Opening Remarks&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Main Hall&lt;/td&gt;<br>&nbsp; &nbsp;&lt;/tr&gt;<br>&nbsp; &nbsp;&lt;tr&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;9:30 AM&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Keynote: Elon Musk&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Main Hall&lt;/td&gt;<br>&nbsp; &nbsp;&lt;/tr&gt;<br>&nbsp; &nbsp;&lt;tr&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;11:00 AM&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Workshop: AI in Action&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Workshop Room 1&lt;/td&gt;<br>&nbsp; &nbsp;&lt;/tr&gt;<br>&nbsp; &nbsp;&lt;tr&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;12:30 PM&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Lunch Break&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Dining Hall&lt;/td&gt;<br>&nbsp; &nbsp;&lt;/tr&gt;<br>&nbsp; &nbsp;&lt;tr&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;2:00 PM&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Panel Discussion: The Future of Tech&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Panel Room&lt;/td&gt;<br>&nbsp; &nbsp;&lt;/tr&gt;<br>&nbsp; &nbsp;&lt;tr&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;3:30 PM&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Networking Session&lt;/td&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Networking Lounge&lt;/td&gt;<br>&nbsp; &nbsp;&lt;/tr&gt;<br>&nbsp; &nbsp;&lt;tr&gt;<br>&nbsp; &nbsp; &nbsp; &nbsp;&lt;td style=\"border: 1px solid #ddd; padding:<br>8px;\"&gt;5:00 PM&lt;/td&gt; &lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Evening Gala&lt;/td&gt; &lt;td style=\"border: 1px solid #ddd; padding: 8px;\"&gt;Grand Ballroom&lt;/td&gt; &lt;/tr&gt;</p><p>&lt;/table&gt;</p>','9cae61f3-aa83-4c87-b667-7c070072186d','2024-08-12T16:39','2024-08-15T16:39','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-12 12:40:11','2024-08-12 12:40:11','Big Event'),(5,'9cbfc56d-f7ab-4e90-8917-e2331f3c7159','9cae61f3-add3-43cf-9641-90ebcbcf203a','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','Iure nesciunt quae ','<p>cv</p>','9cae61f3-a72e-421a-8c63-73462113331f','2023-08-15T00:58','2001-10-06T18:49','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-12 12:57:30','2024-08-12 12:57:30','Qui suscipit dolorem'),(6,'9cc04645-c40c-4f9f-a8e4-67ab7706ad9e','9cae61f3-b417-4468-9d93-bb6accade837','9cb64e6d-0d11-4425-8c71-db57333a1e5f','Dolores obcaecati ut','<p>3867484</p>','9cae61f3-aa83-4c87-b667-7c070072186d','1971-11-05T06:19','2018-05-04T20:08','9cb6339a-97fb-4c1e-8f65-b49d5301daa5',NULL,'2024-08-12 18:57:46','2024-08-12 18:57:46','Enim molestiae neces'),(7,'9cc04681-0777-4e6d-a700-a543e88c50a9','9cae61f3-b2d0-493d-be9e-94daa36db9b9','9cb64e6d-0d11-4425-8c71-db57333a1e5f','Dolore quae elit sa','<p>455</p>','9cae61f3-a72e-421a-8c63-73462113331f','1994-01-23T00:07','1975-08-05T07:08','9cb6339a-97fb-4c1e-8f65-b49d5301daa5',NULL,'2024-08-12 18:58:25','2024-08-12 18:58:25','Eu quia illo explica'),(8,'9cdd6961-a1a9-4d97-b876-21bbf0511173','9cae61f3-af75-45ac-851a-ebd0b1a5c5b7','9cdd68ec-93c7-4d5b-88b1-2995201dce9b','Latest Event','<p>Here is the first Event</p>','9cae61f3-a72e-421a-8c63-73462113331f','2024-08-27T10:34','2024-08-31T10:34','9cdb356a-d2df-4890-9c52-d86d9ef85c40',NULL,'2024-08-27 06:34:57','2024-08-27 06:34:57','Latest Event'),(9,'9d19f306-f5bd-45d5-95c5-bbc36112f758','9cae61f3-add3-43cf-9641-90ebcbcf203a','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','My Event','<p>hello there</p>','9cae61f3-aa83-4c87-b667-7c070072186d','2024-09-26T12:48','2024-10-01T12:48','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 08:49:30','2024-09-26 08:49:30','My Event'),(10,'9d19f97f-ba35-41a1-9204-c9a6db2cc753','9cae61f3-af75-45ac-851a-ebd0b1a5c5b7','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','hsytdhgd','<p>shgfd</p>','9cae61f3-a72e-421a-8c63-73462113331f','2024-09-26T13:07','2024-09-26T13:07','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 09:07:36','2024-09-26 09:07:36','hddghd');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--

INSERT INTO `failed_jobs` VALUES (1,'6c2a2fef-b0b8-4163-86b4-1713c33a436f','database','default','{\"uuid\":\"6c2a2fef-b0b8-4163-86b4-1713c33a436f\",\"displayName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\SendCampaignEmails\\\":1:{s:38:\\\"\\u0000App\\\\Jobs\\\\SendCampaignEmails\\u0000fundraise\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Fundraise\\\";s:2:\\\"id\\\";i:7;s:9:\\\"relations\\\";a:2:{i:0;s:9:\\\"recipient\\\";i:1;s:21:\\\"recipient.mailingList\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}','Illuminate\\Queue\\ManuallyFailedException in /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:216\nStack trace:\n#0 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/InteractsWithQueue.php(61): Illuminate\\Queue\\Jobs\\Job->fail()\n#1 /home/takudzwa/pers/web/afriblocks/crowd-funding/app/Jobs/SendCampaignEmails.php(61): App\\Jobs\\SendCampaignEmails->fail()\n#2 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\SendCampaignEmails->handle()\n#3 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#5 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#6 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#7 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()\n#8 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()\n#9 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#10 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()\n#11 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()\n#12 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()\n#13 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#14 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Pipeline\\Pipeline->then()\n#15 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()\n#16 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call()\n#17 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()\n#18 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process()\n#19 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob()\n#20 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\\Queue\\Worker->daemon()\n#21 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\\Queue\\Console\\WorkCommand->runWorker()\n#22 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#23 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#25 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#26 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#27 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()\n#28 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()\n#29 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#30 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()\n#31 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()\n#32 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()\n#33 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()\n#34 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()\n#35 /home/takudzwa/pers/web/afriblocks/crowd-funding/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#36 {main}','2024-09-26 19:01:27'),(2,'823b23e9-4325-46ad-b377-5adb7a00225e','database','default','{\"uuid\":\"823b23e9-4325-46ad-b377-5adb7a00225e\",\"displayName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\SendCampaignEmails\\\":1:{s:38:\\\"\\u0000App\\\\Jobs\\\\SendCampaignEmails\\u0000fundraise\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Fundraise\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:2:{i:0;s:9:\\\"recipient\\\";i:1;s:21:\\\"recipient.mailingList\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}','Illuminate\\Queue\\ManuallyFailedException in /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:216\nStack trace:\n#0 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/InteractsWithQueue.php(61): Illuminate\\Queue\\Jobs\\Job->fail()\n#1 /home/takudzwa/pers/web/afriblocks/crowd-funding/app/Jobs/SendCampaignEmails.php(61): App\\Jobs\\SendCampaignEmails->fail()\n#2 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\SendCampaignEmails->handle()\n#3 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#5 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#6 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#7 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()\n#8 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()\n#9 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#10 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()\n#11 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()\n#12 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()\n#13 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#14 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Pipeline\\Pipeline->then()\n#15 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()\n#16 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call()\n#17 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()\n#18 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process()\n#19 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob()\n#20 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\\Queue\\Worker->daemon()\n#21 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\\Queue\\Console\\WorkCommand->runWorker()\n#22 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#23 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#25 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#26 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#27 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()\n#28 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()\n#29 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#30 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()\n#31 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()\n#32 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()\n#33 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()\n#34 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()\n#35 /home/takudzwa/pers/web/afriblocks/crowd-funding/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#36 {main}','2024-09-26 19:02:20'),(3,'807f7628-4424-4e7a-9c95-593270b25d46','database','default','{\"uuid\":\"807f7628-4424-4e7a-9c95-593270b25d46\",\"displayName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\SendCampaignEmails\\\":1:{s:38:\\\"\\u0000App\\\\Jobs\\\\SendCampaignEmails\\u0000fundraise\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Fundraise\\\";s:2:\\\"id\\\";i:9;s:9:\\\"relations\\\";a:2:{i:0;s:9:\\\"recipient\\\";i:1;s:21:\\\"recipient.mailingList\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}','Illuminate\\Queue\\ManuallyFailedException in /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:216\nStack trace:\n#0 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/InteractsWithQueue.php(61): Illuminate\\Queue\\Jobs\\Job->fail()\n#1 /home/takudzwa/pers/web/afriblocks/crowd-funding/app/Jobs/SendCampaignEmails.php(62): App\\Jobs\\SendCampaignEmails->fail()\n#2 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\SendCampaignEmails->handle()\n#3 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#5 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#6 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#7 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()\n#8 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()\n#9 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#10 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()\n#11 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()\n#12 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()\n#13 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#14 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Pipeline\\Pipeline->then()\n#15 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()\n#16 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call()\n#17 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()\n#18 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process()\n#19 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob()\n#20 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\\Queue\\Worker->daemon()\n#21 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\\Queue\\Console\\WorkCommand->runWorker()\n#22 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#23 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#25 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#26 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#27 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()\n#28 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()\n#29 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#30 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()\n#31 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()\n#32 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()\n#33 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()\n#34 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()\n#35 /home/takudzwa/pers/web/afriblocks/crowd-funding/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#36 {main}','2024-09-26 19:04:54'),(4,'a0f057cc-32db-46d6-8c47-03cbb3733506','database','default','{\"uuid\":\"a0f057cc-32db-46d6-8c47-03cbb3733506\",\"displayName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\SendCampaignEmails\\\":1:{s:38:\\\"\\u0000App\\\\Jobs\\\\SendCampaignEmails\\u0000fundraise\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Fundraise\\\";s:2:\\\"id\\\";i:10;s:9:\\\"relations\\\";a:2:{i:0;s:9:\\\"recipient\\\";i:1;s:21:\\\"recipient.mailingList\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}','Illuminate\\Queue\\ManuallyFailedException in /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:216\nStack trace:\n#0 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/InteractsWithQueue.php(61): Illuminate\\Queue\\Jobs\\Job->fail()\n#1 /home/takudzwa/pers/web/afriblocks/crowd-funding/app/Jobs/SendCampaignEmails.php(62): App\\Jobs\\SendCampaignEmails->fail()\n#2 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\SendCampaignEmails->handle()\n#3 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#5 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#6 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#7 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()\n#8 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()\n#9 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#10 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()\n#11 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()\n#12 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()\n#13 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#14 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Pipeline\\Pipeline->then()\n#15 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()\n#16 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call()\n#17 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()\n#18 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process()\n#19 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob()\n#20 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\\Queue\\Worker->daemon()\n#21 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\\Queue\\Console\\WorkCommand->runWorker()\n#22 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#23 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#25 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#26 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#27 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()\n#28 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()\n#29 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#30 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()\n#31 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()\n#32 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()\n#33 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()\n#34 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()\n#35 /home/takudzwa/pers/web/afriblocks/crowd-funding/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#36 {main}','2024-09-26 19:06:34'),(5,'14082ee7-b952-46c6-a920-884361be6798','database','default','{\"uuid\":\"14082ee7-b952-46c6-a920-884361be6798\",\"displayName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\SendCampaignEmails\\\":1:{s:38:\\\"\\u0000App\\\\Jobs\\\\SendCampaignEmails\\u0000fundraise\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Fundraise\\\";s:2:\\\"id\\\";i:17;s:9:\\\"relations\\\";a:2:{i:0;s:9:\\\"recipient\\\";i:1;s:21:\\\"recipient.mailingList\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}','Illuminate\\Queue\\ManuallyFailedException in /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:216\nStack trace:\n#0 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/InteractsWithQueue.php(61): Illuminate\\Queue\\Jobs\\Job->fail()\n#1 /home/takudzwa/pers/web/afriblocks/crowd-funding/app/Jobs/SendCampaignEmails.php(62): App\\Jobs\\SendCampaignEmails->fail()\n#2 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\SendCampaignEmails->handle()\n#3 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#5 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#6 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#7 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()\n#8 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()\n#9 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#10 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()\n#11 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()\n#12 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()\n#13 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#14 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Pipeline\\Pipeline->then()\n#15 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()\n#16 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call()\n#17 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()\n#18 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process()\n#19 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob()\n#20 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\\Queue\\Worker->daemon()\n#21 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\\Queue\\Console\\WorkCommand->runWorker()\n#22 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#23 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#25 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#26 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#27 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()\n#28 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()\n#29 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#30 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()\n#31 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()\n#32 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()\n#33 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()\n#34 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()\n#35 /home/takudzwa/pers/web/afriblocks/crowd-funding/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#36 {main}','2024-11-11 12:06:59'),(6,'1e0539bc-5324-4f04-804a-e958c7eedb10','database','default','{\"uuid\":\"1e0539bc-5324-4f04-804a-e958c7eedb10\",\"displayName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\SendCampaignEmails\\\":1:{s:38:\\\"\\u0000App\\\\Jobs\\\\SendCampaignEmails\\u0000fundraise\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Fundraise\\\";s:2:\\\"id\\\";i:18;s:9:\\\"relations\\\";a:2:{i:0;s:9:\\\"recipient\\\";i:1;s:21:\\\"recipient.mailingList\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}','Illuminate\\Queue\\ManuallyFailedException in /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:216\nStack trace:\n#0 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/InteractsWithQueue.php(61): Illuminate\\Queue\\Jobs\\Job->fail()\n#1 /home/takudzwa/pers/web/afriblocks/crowd-funding/app/Jobs/SendCampaignEmails.php(62): App\\Jobs\\SendCampaignEmails->fail()\n#2 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\SendCampaignEmails->handle()\n#3 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#5 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#6 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#7 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()\n#8 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()\n#9 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#10 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()\n#11 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()\n#12 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()\n#13 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#14 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Pipeline\\Pipeline->then()\n#15 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()\n#16 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call()\n#17 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()\n#18 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process()\n#19 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob()\n#20 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\\Queue\\Worker->daemon()\n#21 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\\Queue\\Console\\WorkCommand->runWorker()\n#22 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#23 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#25 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#26 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#27 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()\n#28 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()\n#29 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#30 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()\n#31 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()\n#32 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()\n#33 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()\n#34 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()\n#35 /home/takudzwa/pers/web/afriblocks/crowd-funding/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#36 {main}','2024-11-11 12:09:44'),(7,'e5ed7249-0eb1-4972-a300-fab4fe4c6343','database','default','{\"uuid\":\"e5ed7249-0eb1-4972-a300-fab4fe4c6343\",\"displayName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\SendCampaignEmails\\\":1:{s:38:\\\"\\u0000App\\\\Jobs\\\\SendCampaignEmails\\u0000fundraise\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Fundraise\\\";s:2:\\\"id\\\";i:19;s:9:\\\"relations\\\";a:2:{i:0;s:9:\\\"recipient\\\";i:1;s:21:\\\"recipient.mailingList\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}','Illuminate\\Queue\\ManuallyFailedException in /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:216\nStack trace:\n#0 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/InteractsWithQueue.php(61): Illuminate\\Queue\\Jobs\\Job->fail()\n#1 /home/takudzwa/pers/web/afriblocks/crowd-funding/app/Jobs/SendCampaignEmails.php(62): App\\Jobs\\SendCampaignEmails->fail()\n#2 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\SendCampaignEmails->handle()\n#3 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#5 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#6 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#7 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()\n#8 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()\n#9 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#10 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()\n#11 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()\n#12 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()\n#13 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#14 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Pipeline\\Pipeline->then()\n#15 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()\n#16 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call()\n#17 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()\n#18 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process()\n#19 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob()\n#20 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\\Queue\\Worker->daemon()\n#21 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\\Queue\\Console\\WorkCommand->runWorker()\n#22 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#23 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#25 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#26 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#27 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()\n#28 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()\n#29 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#30 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()\n#31 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()\n#32 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()\n#33 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()\n#34 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()\n#35 /home/takudzwa/pers/web/afriblocks/crowd-funding/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#36 {main}','2024-11-11 12:11:08'),(8,'9e5a4e41-4417-4664-a844-0c5506c5cbb9','database','default','{\"uuid\":\"9e5a4e41-4417-4664-a844-0c5506c5cbb9\",\"displayName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendCampaignEmails\",\"command\":\"O:27:\\\"App\\\\Jobs\\\\SendCampaignEmails\\\":1:{s:38:\\\"\\u0000App\\\\Jobs\\\\SendCampaignEmails\\u0000fundraise\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:20:\\\"App\\\\Models\\\\Fundraise\\\";s:2:\\\"id\\\";i:20;s:9:\\\"relations\\\";a:2:{i:0;s:9:\\\"recipient\\\";i:1;s:21:\\\"recipient.mailingList\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}\"}}','Illuminate\\Queue\\ManuallyFailedException in /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php:216\nStack trace:\n#0 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/InteractsWithQueue.php(61): Illuminate\\Queue\\Jobs\\Job->fail()\n#1 /home/takudzwa/pers/web/afriblocks/crowd-funding/app/Jobs/SendCampaignEmails.php(62): App\\Jobs\\SendCampaignEmails->fail()\n#2 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\SendCampaignEmails->handle()\n#3 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#4 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#5 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#6 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#7 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call()\n#8 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}()\n#9 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#10 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then()\n#11 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(124): Illuminate\\Bus\\Dispatcher->dispatchNow()\n#12 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}()\n#13 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()\n#14 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Pipeline\\Pipeline->then()\n#15 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(71): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware()\n#16 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call()\n#17 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()\n#18 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process()\n#19 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob()\n#20 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(139): Illuminate\\Queue\\Worker->daemon()\n#21 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(122): Illuminate\\Queue\\Console\\WorkCommand->runWorker()\n#22 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#23 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#24 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()\n#25 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()\n#26 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Container/Container.php(690): Illuminate\\Container\\BoundMethod::call()\n#27 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()\n#28 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()\n#29 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()\n#30 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(1047): Illuminate\\Console\\Command->run()\n#31 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(316): Symfony\\Component\\Console\\Application->doRunCommand()\n#32 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/symfony/console/Application.php(167): Symfony\\Component\\Console\\Application->doRun()\n#33 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\\Component\\Console\\Application->run()\n#34 /home/takudzwa/pers/web/afriblocks/crowd-funding/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1203): Illuminate\\Foundation\\Console\\Kernel->handle()\n#35 /home/takudzwa/pers/web/afriblocks/crowd-funding/artisan(13): Illuminate\\Foundation\\Application->handleCommand()\n#36 {main}','2024-11-11 12:16:12');

--
-- Table structure for table `fundraise_image`
--

CREATE TABLE `fundraise_image` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fundraise_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fundraise_image`
--

INSERT INTO `fundraise_image` VALUES (1,'1','18',NULL,NULL),(2,'1','19',NULL,NULL),(3,'1','20',NULL,NULL),(4,'1','21',NULL,NULL),(5,'1','22',NULL,NULL),(6,'1','23',NULL,NULL),(7,'1','24',NULL,NULL),(8,'2','30',NULL,NULL),(9,'2','31',NULL,NULL),(10,'2','32',NULL,NULL),(11,'2','33',NULL,NULL),(12,'2','34',NULL,NULL),(13,'2','35',NULL,NULL),(14,'2','36',NULL,NULL);

--
-- Table structure for table `fundraiser_types`
--

CREATE TABLE `fundraiser_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fundraiser_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fundraiser_types`
--

INSERT INTO `fundraiser_types` VALUES (1,'9cae61f3-b5dd-47c7-a888-eb561f02ca0a','Political',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16'),(2,'9cae61f3-bfe1-40fd-865d-f849f48d6438','Fund Me',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16'),(3,'9cae61f3-c269-4cc4-9dc2-7b9f57efad96','General',NULL,'2024-08-03 21:30:16','2024-08-03 21:30:16');

--
-- Table structure for table `fundraises`
--

CREATE TABLE `fundraises` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `fundraise_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tagline` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_anonymous` tinyint(1) NOT NULL DEFAULT '0',
  `category_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_sender_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fundraises`
--

INSERT INTO `fundraises` VALUES (1,'9cf80fd8-8b28-4652-b9a0-a16b8973682c','fundraise','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','General Campaign Contribution','1','<p>This is a campaign to raise funds for Elementary Kids</p>','2024-09-27T16:30','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-09 12:31:56','2024-09-09 12:31:56',0,'9cae61f3-c269-4cc4-9dc2-7b9f57efad96','','pending'),(2,'9d1a384a-b5f9-41c7-889a-b4534dfe92e1','fundraise','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','Testing Fundraise','1','<p>This is a testing campaign</p>','2024-09-27T16:02','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 12:03:11','2024-09-26 12:03:11',0,'9cae61f3-c269-4cc4-9dc2-7b9f57efad96','','pending'),(3,'9d1a3b9e-4508-41b5-81a2-04cab3169ae2','email','','Testing Campaign','Testing Campaign','<p>This is a testing email Campaign</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 12:12:29','2024-09-26 12:13:39',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(4,'9d1a515a-5116-409c-8c8e-b070944e7755','email','','mmm','mmm','<p>Hello</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 13:13:15','2024-09-26 13:13:15',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','pending'),(5,'9d1a52c6-d518-4183-b95f-ebdf77d8dc7a','email','','Hey','Hey','<p>Hey</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 13:17:14','2024-09-26 13:17:14',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','pending'),(6,'9d1a531c-036b-4b2c-9f9d-b6e18ded1f0a','email','','Hey','Hey','<p>Hey</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 13:18:10','2024-09-26 13:18:12',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(7,'9d1acdbb-ea70-48fb-a7a1-4881478fed58','email','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','hdh','dhhd','<p>Test Final</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 19:01:03','2024-09-26 19:01:27',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(8,'9d1ace2e-91a4-4c53-a41f-9e25219f013b','email','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','A Test','A Test','<p>A Test</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 19:02:18','2024-09-26 19:02:19',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(9,'9d1acf19-f1e6-47ab-8ecf-d6ffb710c7da','email','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','The Test','The Test','<p>The Test</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 19:04:52','2024-09-26 19:04:54',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(10,'9d1acfaf-a074-43e4-a604-fdfd2d54b3c7','email','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','Working','Working','<p>Working</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 19:06:31','2024-09-26 19:06:33',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(11,'9d1acff4-0a2d-4857-acfd-cedddbafe1c6','email','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','Aaah','Aaah','<p>Aaah</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 19:07:15','2024-09-26 19:07:17',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(12,'9d1ad0bd-04d4-40fc-9b97-5bdd0731b5b6','email','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','Again','Again','<p>Again</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 19:09:27','2024-09-26 19:09:29',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(13,'9d1ad1d8-4c9d-47cf-99f6-e8cb4db99b9a','email','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','Next','Next','<p>Next</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 19:12:33','2024-09-26 19:12:35',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(14,'9d1ad2eb-5a84-4e4d-b3f1-b97a3f744a72','email','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','Justify','Justify','<p>Justify</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 19:15:33','2024-09-26 19:15:34',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(15,'9d1adbde-fab3-459e-8168-9c9d0b22373d','email','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','Demonstation Campaign','Demonstation Campaign','<p>This is a Demonstation Campaign</p>','','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 19:40:35','2024-09-26 19:40:50',1,'','9d1a3a54-57e5-4ae0-b9d4-3daadd03d641','queued'),(16,'9d76b306-8b9b-451a-9129-6c42159fd11c','email','9d76b2c2-646a-4fc2-a0b9-927e049a19c4','A Campaign','thetakudzwagozo@gmail.com','<p>This is a campaign</p>','','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9',NULL,'2024-11-11 11:22:32','2024-11-11 11:22:35',1,'','1abb102e-aa05-4a25-986a-abba098347a6','queued'),(17,'9d76c2e2-b6c5-472c-aa31-29887c1f830c','email','9d76b2c2-646a-4fc2-a0b9-927e049a19c4','Testing Campaign','Testing Campaign','<p>This is a Testing Campaign</p>','','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9',NULL,'2024-11-11 12:06:53','2024-11-11 12:06:55',1,'','1abb102e-aa05-4a25-986a-abba098347a6','queued'),(18,'9d76c3de-9019-4331-9d81-4f3edcfcfb11','email','9d76b2c2-646a-4fc2-a0b9-927e049a19c4','Testing Campaign','Testing Campaign','<p>This is a Testing Campaign&nbsp;</p>','','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9',NULL,'2024-11-11 12:09:38','2024-11-11 12:09:41',1,'','1abb102e-aa05-4a25-986a-abba098347a6','queued'),(19,'9d76c45f-a1e8-4d75-80dc-1fe2fada8345','email','9d76b2c2-646a-4fc2-a0b9-927e049a19c4','Testing Campaign','Testing Campaign','<p>This is a Testing Campaign</p>','','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9',NULL,'2024-11-11 12:11:03','2024-11-11 12:11:04',1,'','1abb102e-aa05-4a25-986a-abba098347a6','queued'),(20,'9d76c630-c18a-4b99-877e-8e912281a489','email','9d76b2c2-646a-4fc2-a0b9-927e049a19c4','Testing Campaign','Testing Campaign','<p>This is a Testing Campaign</p>','','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9',NULL,'2024-11-11 12:16:07','2024-11-11 12:16:08',1,'','1abb102e-aa05-4a25-986a-abba098347a6','queued'),(21,'9d76c70d-1e42-461d-b135-716bc45cff36','email','9d76b2c2-646a-4fc2-a0b9-927e049a19c4','A Campaign','A Campaign','<p>This&nbsp;</p>','','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9',NULL,'2024-11-11 12:18:32','2024-11-11 12:18:36',1,'','1abb102e-aa05-4a25-986a-abba098347a6','queued');

--
-- Table structure for table `histories`
--

CREATE TABLE `histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `history_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'initiated',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `histories`
--

INSERT INTO `histories` VALUES (1,'9d76bb08-16eb-4329-8938-baeeebc94bde','jUcDyQ','Initiated Withdrawal Request',NULL,'9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9','withdrawal','9d76bb08-154e-4361-8d18-1b78f15dbc54','initiated',NULL,'2024-11-11 11:44:55','2024-11-11 11:44:55'),(4,'9d76bba9-37ea-4959-aad2-dd2613c31f06','qtcHXy','Paid Withdrawal: EOlQ3W',NULL,'9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9','withdrawal','9d76bb08-154e-4361-8d18-1b78f15dbc54','paid',NULL,'2024-11-11 11:46:41','2024-11-11 11:46:41');

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `images`
--

INSERT INTO `images` VALUES (3,'9cae6aad-a61e-44ba-9739-c4a5d523fb03','photos/92t8S4SbW0W0ejzvV1hA0uTJgBkaDJH6NDifETDG.png','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-03 21:54:40','2024-08-03 21:54:40'),(4,'9cafe4b7-dc30-42ec-9c24-1c6e2a615b0e','photos/VPRloAKdPYdKpQPKIvKl2SE1IPlg58ARh035FduW.png','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-04 15:31:44','2024-08-04 15:31:44'),(5,'9cb6339b-01f6-431f-8055-af72516e53e2','photos/exPp5dyej8AutAGEYGEs01JueB16Z53a7Pd0eWQi.jpg','9cb6339a-97fb-4c1e-8f65-b49d5301daa5',NULL,'2024-08-07 18:47:17','2024-08-07 18:47:17'),(6,'9cbf6c7f-be04-4ba6-b09c-3ceee3dddae9','photos/9V5juwfxQyYbl12uHywiPThlgx8K2zv9tQ8tqZZn.png','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-12 08:48:49','2024-08-12 08:48:49'),(7,'9cbfb1d0-c0e7-4cd5-95d8-6f4b2c82fcf3','photos/hM6MbRZu13jx8XQAKJRm0C0pCJy151Lvuuwlxh28.png','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-12 12:02:39','2024-08-12 12:02:39'),(8,'9cbfb1d0-c635-4684-b8a6-47f8a56cc1ad','photos/Ke32vsE99ZnoouMrSASgnZhaISdXPCLQKA7H398a.png','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-12 12:02:39','2024-08-12 12:02:39'),(9,'9cbfbf3c-dccf-4c77-8c3d-f1d5456563f6','photos/u5OPZTCcfLVWi1pMq5NPaEngbf5LR7AqO8mcVO3l.png','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-12 12:40:11','2024-08-12 12:40:11'),(10,'9cbfbf3c-e149-4397-9551-d7a555b4ff69','photos/ID7rfSaaljWOoXWflDKzJsO8ByGLN4rcwwaRRNGD.png','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-12 12:40:11','2024-08-12 12:40:11'),(11,'9cbfc56d-f493-4b43-b7fe-0d0d2a8e55e2','photos/7xChSfTRoo5ZBVsEgQ4EES57JfH9G9IgXTYYftIU.png','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL,'2024-08-12 12:57:30','2024-08-12 12:57:30'),(12,'9cc04645-c1bb-4df2-b6b6-3f8ca9edd4a7','photos/9CVHBT8z1ZMWnGoVwYLrQsGS5NOgLYWAAkCu1yuq.png','9cb6339a-97fb-4c1e-8f65-b49d5301daa5',NULL,'2024-08-12 18:57:46','2024-08-12 18:57:46'),(13,'9cc04681-04d4-49c3-944c-8eb822d580c9','photos/wPYnxUNXKVMorZmHuWpTa3DoT54ESTUfbJSsJIaY.png','9cb6339a-97fb-4c1e-8f65-b49d5301daa5',NULL,'2024-08-12 18:58:25','2024-08-12 18:58:25'),(14,'9cdb3278-7c2d-4477-acce-b971c9eb20c0','photos/SVRJL1a82ytyomcB4BXGIOUyOAuDmW0nNH12W22Y.png','9cdb3277-752c-4630-95da-9e4a77b6ce1f',NULL,'2024-08-26 04:09:45','2024-08-26 04:09:45'),(15,'9cdb3303-9cc7-4e72-95da-201ea23a32a8','photos/pi5e5UjONKnlXI7Ex0JRnMp7HJwG6qd6XQiaF9ZU.png','9cdb3302-76f3-4a19-a461-e8871d46ee51',NULL,'2024-08-26 04:11:16','2024-08-26 04:11:16'),(16,'9cdb356b-f9ed-48ac-abeb-47ce96706d18','photos/VBRbKepXm4S68zQqVXD91QP15OAQncvYrMgd37QC.png','9cdb356a-d2df-4890-9c52-d86d9ef85c40',NULL,'2024-08-26 04:18:00','2024-08-26 04:18:00'),(17,'9cdd6961-a00a-4b6f-9f1c-82f6b70169f5','photos/JCNutQM9Uh4dBAQTzYFXteVpQMrbxUabKLcxQpbR.png','9cdb356a-d2df-4890-9c52-d86d9ef85c40',NULL,'2024-08-27 06:34:57','2024-08-27 06:34:57'),(18,'9cf80fd8-8424-40f2-ac29-54484f24f9f1','photos/RDpBiGWXhISz0eTZiNWiJfl32XKFLCuC3OhN7c2b.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-09 12:31:56','2024-09-09 12:31:56'),(19,'9cf80fd8-85a1-414a-b90f-08047ecdfd67','photos/krE5dj0wJNFtJMIcwX1zJ22Zff2wSKVfMayT2m2H.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-09 12:31:56','2024-09-09 12:31:56'),(20,'9cf80fd8-86b2-4a1d-b91c-17b49ad3791e','photos/maelm9db1fjiUDnkXknGZLY8tmVssKGFkT7xW8et.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-09 12:31:56','2024-09-09 12:31:56'),(21,'9cf80fd8-87d9-4b0d-b6a0-db4840f2f778','photos/75kYmNgCZn7a6uMW0VdUngBbplE07Kefs97gvtGH.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-09 12:31:56','2024-09-09 12:31:56'),(22,'9cf80fd8-88b8-4e01-9d3e-84444515bc64','photos/hikMYXApOtNxcHj6JN4yWCoAjquo4DMhFnTcF2nx.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-09 12:31:56','2024-09-09 12:31:56'),(23,'9cf80fd8-8998-4492-9137-a43ed3ec7834','photos/HPEqlmcAkzGcda9d0A43cHluIzbXrPOtmE5RsDZv.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-09 12:31:56','2024-09-09 12:31:56'),(24,'9cf80fd8-8a75-46f7-9cb6-496c42b8d870','photos/wveeIaHDAJXkQl3yvseBa2fhwr4xeFoTtOdkGFjT.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-09 12:31:56','2024-09-09 12:31:56'),(25,'9d19f306-ecf9-4f3c-a844-709fb1530bb0','photos/9QESviM6Gr5L3CBWtUCVTL8mBNtUEbG5qYb8FpOx.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 08:49:30','2024-09-26 08:49:30'),(26,'9d19f306-efda-4bbe-a39c-f66014026b7c','photos/ezMABjB4H0XRhHt4IDeAdZvKdoll1ueARn50hw5e.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 08:49:30','2024-09-26 08:49:30'),(27,'9d19f306-f21d-4b29-803f-0f63e4425f55','photos/8pwpPKTa3szgAruqFW9eOsc6KiNvjJ4aDXIeWIQc.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 08:49:30','2024-09-26 08:49:30'),(28,'9d19f306-f485-4ae3-86ac-16bad62128f5','photos/kFI1klfaT0CFuntoszjMqNurn9jRijOHEufXoBEc.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 08:49:30','2024-09-26 08:49:30'),(29,'9d19f97f-b8a2-483e-9036-af8fede2cb5a','photos/qKKiggTV71Wap8O1ZDV9aOOZMSpSf4dPEMlrC1Jy.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 09:07:36','2024-09-26 09:07:36'),(30,'9d1a384a-9ddf-4277-9f0a-efb4b8369360','photos/fOWIUpudcUVPwTqPQpfwIdO7FVQLNuBWkT21wC9Y.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 12:03:11','2024-09-26 12:03:11'),(31,'9d1a384a-a447-4de5-8fbd-da9b41d590d7','photos/7o1O0Sm6OnaUHHbeNvL4xxtIIFDzFgskIB4zy5gH.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 12:03:11','2024-09-26 12:03:11'),(32,'9d1a384a-a794-4706-820f-e5ef65009afc','photos/ZrklQ9zE7uzBVrPG9KdzVBCHbmNPhoh0BfUvoMvT.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 12:03:11','2024-09-26 12:03:11'),(33,'9d1a384a-ab00-425c-8e8e-a301a9c10d54','photos/HnLtjy4SgnD9LqEdS1JovqMwZFTLEDvYPj2ZDZRr.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 12:03:11','2024-09-26 12:03:11'),(34,'9d1a384a-adac-4a16-af78-6b0278a971dd','photos/vwGwj75NDSrcj2rP8vf53pwUN6BHvPe7i4EcxJjj.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 12:03:11','2024-09-26 12:03:11'),(35,'9d1a384a-b099-4a93-afed-288462eadcec','photos/wGov7EK82SLhyT9OU2vrhh5qHM8DtRHlYcoz557k.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 12:03:11','2024-09-26 12:03:11'),(36,'9d1a384a-b34a-4a8e-af60-28f8ef75ed47','photos/qjwuDVbppsUO4oPcBrE3yMJ11dX9KxlI2FKWhvaa.png','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 12:03:11','2024-09-26 12:03:11'),(37,'9d76ab7d-ff4a-4fe9-bd7c-450a89d06275','photos/RNFD2eLrXKA4h0UHJlrEjfwtWniRpfUgiK1M01uB.png','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9',NULL,'2024-11-11 11:01:28','2024-11-11 11:01:28');

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `mailing_lists`
--

CREATE TABLE `mailing_lists` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `mailing_list_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `recipients_count` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mailing_lists`
--

INSERT INTO `mailing_lists` VALUES (1,'9d1a3b2b-359f-422d-bedc-cdcbbcfc11ea','My Testing List','My Testing List','csv/4msgADLSU7NcaWHCAsxvrYZ4bmSJj3OG5cN7TSqP.csv','3','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 12:11:13','2024-09-26 12:11:30'),(2,'9d1a513a-aa02-45a7-ae1b-b454663628dd','sec','sec','csv/1wNFkF9d10Xgnx1c2r0ZPjZ2Ym4A83fgNpQTZf17.csv','1','9cec447c-bc9a-4784-a581-4b0051ff6880',NULL,'2024-09-26 13:12:55','2024-09-26 13:12:56'),(3,'9d76b10b-0773-4b6b-a40b-ca6da36c6788','My List','My List','csv/VOcWIR9k3vHpff4E3eWWNhZknGIkxr5H8EnzTHah.csv','2','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9',NULL,'2024-11-11 11:16:59','2024-11-11 11:17:08'),(4,'9d76c2a8-803d-47dd-8438-6bf7bf437c82','2nd list','2nd list','csv/8HzISCDH3OFcC4puUqGfRd0sNewu10QbcXYuwpc5.csv','4','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9',NULL,'2024-11-11 12:06:15','2024-11-11 12:06:16');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=238 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (173,'0001_01_01_000000_create_users_table',1),(174,'0001_01_01_000001_create_cache_table',1),(175,'0001_01_01_000002_create_jobs_table',1),(176,'2024_05_30_150340_add_two_factor_columns_to_users_table',1),(177,'2024_05_30_150436_create_personal_access_tokens_table',1),(178,'2024_06_18_221307_add_verify_token_to_users_table',1),(179,'2024_06_19_010833_add_forgot_password_token_to_users_table',1),(180,'2024_06_19_204748_create_states_table',1),(181,'2024_06_19_204921_create_countries_table',1),(182,'2024_06_19_205039_create_banks_table',1),(183,'2024_06_19_210016_create_cities_table',1),(184,'2024_06_19_215321_create_user_banks_table',1),(185,'2024_06_19_215426_create_user_residents_table',1),(186,'2024_06_19_220039_add_on_boarding_to_users_table',1),(187,'2024_06_19_221953_create_user_types_table',1),(188,'2024_06_20_203753_create_accounts_table',1),(189,'2024_06_20_225208_create_currencies_table',1),(190,'2024_06_21_144824_create_events_table',1),(191,'2024_06_21_145615_create_event_image_table',1),(192,'2024_06_21_145649_create_images_table',1),(193,'2024_06_21_160940_create_currency_event_table',1),(194,'2024_06_21_162323_create_event_types_table',1),(195,'2024_06_21_163618_create_categories_table',1),(196,'2024_06_21_223348_create_prices_table',1),(197,'2024_06_22_000041_create_orders_table',1),(198,'2024_06_22_000512_create_order_items_table',1),(199,'2024_06_23_093340_create_event_attendances_table',1),(200,'2024_06_23_093734_create_transactions_table',1),(201,'2024_06_23_100424_add_resource_to_orders_table',1),(202,'2024_06_23_101454_add_currency_to_orders_table',1),(203,'2024_06_23_104852_add_account_id_to_transactions_table',1),(204,'2024_06_23_113647_add_tagline_to_events_table',1),(205,'2024_06_23_130117_create_fundraises_table',1),(206,'2024_06_23_145413_create_fundraiser_types_table',1),(207,'2024_06_23_151055_create_fundraise_image_table',1),(208,'2024_06_26_181843_add_column_is_anonymous_to_fundraises_table',1),(209,'2024_06_27_162657_add_columns_category_id-email_sender_id_to_fundraises_table',1),(210,'2024_06_27_163351_create_campaign_recipients_table',1),(211,'2024_06_27_190605_create_mail_senders_table',1),(212,'2024_06_27_203119_create_mailing_lists_table',1),(213,'2024_06_27_221357_create_campaign_emails_table',1),(214,'2024_06_27_222553_add_column_status_to_fundraises_table',1),(215,'2024_06_30_131034_add_column_order_id_to_transactions_table',1),(216,'2024_06_30_184711_create_configurations_table',1),(217,'2024_07_01_222104_create_withdrawals_table',1),(218,'2024_07_07_123921_create_histories_table',1),(219,'2024_07_15_133009_create_contribution_forms_table',1),(220,'2024_07_16_015230_create_contribution_form_properties_table',1),(221,'2024_07_16_015440_create_contribution_form_sections_table',1),(222,'2024_07_16_032716_create_contribution_sections_table',1),(223,'2024_07_16_033540_create_contribution_section_answers_table',1),(224,'2024_07_16_035840_create_contributions_table',1),(225,'2024_07_20_230159_add_column_rate_to_transactions_table',1),(226,'2024_07_21_022535_create_site_emails_table',1),(227,'2024_07_23_195810_add_column_user_id_to_transactions_table',1),(228,'2024_08_04_122404_create_contributor_details_table',2),(230,'2024_08_04_150030_add_column_contributor_id_to_orders_table',3),(231,'2024_08_04_163559_add_column_contributor_id_to_transactions_table',4),(234,'2024_08_07_210611_add_columns_date_of_birth-employer-occupation-gender_to_users_table',5),(235,'2024_08_10_190255_add_column_is_admin_to_users_table',6),(236,'2024_08_28_103133_alter_users_table_make_ssn_and_image_nullable',7),(237,'2024_08_28_124743_create_emails_table',8);

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_item_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` VALUES (1,'9caf6386-1623-4c63-8851-140706987f6d','9caf6386-0e6e-43a0-b2a2-5fd6aa99be65','Contribution to New Form','Contribution to New Form','1','30',NULL,'2024-08-04 09:30:29','2024-08-04 09:30:29'),(2,'9cafd131-10d8-460f-a788-6819d7b0d2e8','9cafd131-0067-4559-bab1-9b1a77687aac','Contribution to Something Form','Contribution to Something Form','1','80',NULL,'2024-08-04 14:37:08','2024-08-04 14:37:08'),(3,'9cafdb33-b1ec-4967-81b4-a85fce02c07a','9cafdb33-9768-4816-a8d7-ccbfabdfe80a','Contribution to New Form','Contribution to New Form','1','78',NULL,'2024-08-04 15:05:08','2024-08-04 15:05:08'),(5,'9cafe2cb-3045-45d4-aaf1-50784193730d','9cafe2cb-2169-45f4-b78e-4db77a512954','Contribution to Something Form','Contribution to Something Form','1','12',NULL,'2024-08-04 15:26:21','2024-08-04 15:26:21'),(6,'9cb191d2-626a-47eb-b83b-5843134d49d2','9cb191d2-54f3-43f3-9efe-dc001fa0b5e0','Contribution to New Form','Contribution to New Form','1','45',NULL,'2024-08-05 11:31:36','2024-08-05 11:31:36'),(7,'9cb19ce7-60ae-4e3b-a5f0-c7eed1f58da2','9cb19ce7-5639-4129-b9ca-afee2cc087f8','Contribution to New Form','Contribution to New Form','1','50',NULL,'2024-08-05 12:02:35','2024-08-05 12:02:35'),(8,'9cb19f69-e595-4eee-a669-7cf68e29c3ab','9cb19f69-d6bf-43bc-b900-e537c7cabc77','Contribution to New Form','Contribution to New Form','1','90',NULL,'2024-08-05 12:09:36','2024-08-05 12:09:36'),(11,'9cbfc58f-b95c-449a-9145-b3e5f3daf212','9cbfc58f-b2cb-46ec-945d-d83d4efcdf24','1','1','100','1',NULL,'2024-08-12 12:57:52','2024-08-12 12:57:52'),(12,'9cbfc58f-b95c-449a-9145-b3e5f3daf212','9cbfc58f-b2cb-46ec-945d-d83d4efcdf24','1','1','14','1',NULL,'2024-08-12 12:57:52','2024-08-12 12:57:52'),(13,'9cbfe4d5-522f-4b42-a574-0845ce9d0862','9cbfe4d5-4b74-4917-8440-c1edc7c458c6','1','1','20','1',NULL,'2024-08-12 14:25:18','2024-08-12 14:25:18'),(14,'9cc046f8-c493-4862-a11b-d998a4f5b168','9cc046f8-bfc5-4f3e-ae09-c65beea8c67b','10','1','100','12',NULL,'2024-08-12 18:59:43','2024-08-12 18:59:43'),(16,'9cdd8649-44e6-4278-8c13-daddfc3b6e31','9cdd8649-423c-40fe-90d1-f8b26b1ff196','Second Ticket','Second Ticket','4','15',NULL,'2024-08-27 07:55:46','2024-08-27 07:55:46'),(17,'9cdd9501-e1e6-4e09-9776-6b2588c78ce6','9cdd9501-dee3-49ec-a0b5-5febbd251468','First Ticket','First Ticket','2','10',NULL,'2024-08-27 08:36:56','2024-08-27 08:36:56'),(18,'9cdd95e2-60ef-4106-b88e-10431cb26e17','9cdd95e2-5efb-408f-8be8-6678f36f6365','Second Ticket','Second Ticket','1','15',NULL,'2024-08-27 08:39:23','2024-08-27 08:39:23'),(19,'9cdd95e2-621c-4fa7-9b9f-93d92d3e2b99','9cdd95e2-5efb-408f-8be8-6678f36f6365','First Ticket','First Ticket','1','10',NULL,'2024-08-27 08:39:23','2024-08-27 08:39:23'),(20,'9cddb03d-115a-4701-9065-9525fe411b14','9cddb03d-0ee6-476c-a5af-a25f72db2d31','Second Ticket','Second Ticket','1','15',NULL,'2024-08-27 09:53:04','2024-08-27 09:53:04'),(21,'9cddb0f1-df35-45af-84d2-ce4cda0ef5d9','9cddb0f1-dc8c-4e1f-be06-ed1e036ba0b9','First Ticket','First Ticket','2','10',NULL,'2024-08-27 09:55:03','2024-08-27 09:55:03'),(22,'9cddb0f1-e09f-4a10-b127-4d432aef1bb5','9cddb0f1-dc8c-4e1f-be06-ed1e036ba0b9','Second Ticket','Second Ticket','5','15',NULL,'2024-08-27 09:55:03','2024-08-27 09:55:03'),(28,'9d01ed85-dafb-4c14-97a7-4d28abc8098a','9d01ed85-d951-404c-aaa9-3ce2cb1671b7','Contribution to General Campaign Contribution','Contribution to General Campaign Contribution','1','20',NULL,'2024-09-14 10:14:15','2024-09-14 10:14:15'),(30,'9d01f2c6-07a8-45f9-899b-81937e0c2193','9d01f2c6-041d-4a9e-9445-52435661c547','Contribution to General Campaign Contribution','Contribution to General Campaign Contribution','1','1333',NULL,'2024-09-14 10:28:55','2024-09-14 10:28:55'),(31,'9d19eb5a-a0dd-4386-9aeb-42e1e6b6a605','9d19eb5a-92c8-44ba-8d8f-55a684f9253c','Contribution to General Campaign Contribution','Contribution to General Campaign Contribution','1','90',NULL,'2024-09-26 08:28:03','2024-09-26 08:28:03'),(32,'9d19f420-0531-4e1e-bb17-4bddbf6a612c','9d19f41f-f94f-4d9c-9275-805eb788e8ec','First','First','5','10',NULL,'2024-09-26 08:52:34','2024-09-26 08:52:34'),(33,'9d1a38ea-90a7-4a0f-9a24-2c3155288e68','9d1a38ea-816b-4c35-bdf3-07ae7db2c6c4','Contribution to Testing Fundraise','Contribution to Testing Fundraise','1','10000',NULL,'2024-09-26 12:04:56','2024-09-26 12:04:56'),(36,'9d1acb50-0afb-4336-86f2-0979fb65409a','9d1acb50-052e-414b-98a6-77087c184b11','Contribution to Hey','Contribution to Hey','1','3000',NULL,'2024-09-26 18:54:17','2024-09-26 18:54:17'),(37,'9d1adc51-eb29-4861-9e57-4f37c31439ae','9d1adc51-e6c2-432d-8544-f04fd681923a','Contribution to Demonstation Campaign','Contribution to Demonstation Campaign','1','3000',NULL,'2024-09-26 19:41:50','2024-09-26 19:41:50'),(38,'9d1adcfa-7090-464e-8570-75533eea45e9','9d1adcfa-696f-43f2-b9ca-c39c1e9e075d','Contribution to Testing Fundraise','Contribution to Testing Fundraise','1','3000',NULL,'2024-09-26 19:43:41','2024-09-26 19:43:41'),(39,'9d76ae41-18a6-4627-bd28-98ec0aad4ea7','9d76ae41-1624-425a-bce4-946b62fc2387','Contribution to General Campaign Contribution','Contribution to General Campaign Contribution','1','100',NULL,'2024-11-11 11:09:12','2024-11-11 11:09:12'),(40,'9d76af7d-f525-47ff-8806-a9f0e8519a44','9d76af7d-ecc2-4e4d-a0dd-d5375dea1368','10','1','2','12',NULL,'2024-11-11 11:12:39','2024-11-11 11:12:39'),(41,'9d76b356-a369-448b-bf79-ba2b26a0d5cb','9d76b356-a1a2-4b49-ac0c-b919ea2a2e6b','Contribution to A Campaign','Contribution to A Campaign','1','20',NULL,'2024-11-11 11:23:25','2024-11-11 11:23:25'),(42,'9d76b502-843c-4d9d-914a-563e74cb5f8f','9d76b502-82b1-4efa-bf08-6ca5dfe663f9','Contribution to A Campaign','Contribution to A Campaign','1','19',NULL,'2024-11-11 11:28:05','2024-11-11 11:28:05'),(43,'9d76c811-55d1-44a8-812a-deb3207bece2','9d76c811-523c-46bf-b93a-5510696ae1a6','Contribution to A Campaign','Contribution to A Campaign','1','2999',NULL,'2024-11-11 12:21:22','2024-11-11 12:21:22');

--
-- Table structure for table `prices`
--

CREATE TABLE `prices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `price_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prices`
--

INSERT INTO `prices` VALUES (1,'9cbfc56d-f8cd-49a6-9ac5-ce8d6025fcf4','9c7fe719-f571-45dd-b3df-077a8a95604c','1','1','1','event','9cbfc56d-f7ab-4e90-8917-e2331f3c7159',NULL,'2024-08-12 12:57:30','2024-08-12 12:57:30'),(2,'9cc04681-098f-47e5-824b-04961576043f','9c7fe719-f571-45dd-b3df-077a8a95604c','10','12','1','event','9cc04681-0777-4e6d-a700-a543e88c50a9',NULL,'2024-08-12 18:58:25','2024-08-12 18:58:25'),(3,'9cdd6961-a32c-41ea-b6fa-d3beeec36a5a','9c7fe719-f571-45dd-b3df-077a8a95604c','First Ticket','10','First Ticket','event','9cdd6961-a1a9-4d97-b876-21bbf0511173',NULL,'2024-08-27 06:34:57','2024-08-27 06:34:57'),(4,'9cdd6961-a645-480c-9ca8-3f768cf95fe3','9c7fe719-f571-45dd-b3df-077a8a95604c','Second Ticket','15','Second Ticket','event','9cdd6961-a1a9-4d97-b876-21bbf0511173',NULL,'2024-08-27 06:34:57','2024-08-27 06:34:57'),(5,'9d19f306-f75a-4084-b546-2be63f0c9014','9c7fe719-f571-45dd-b3df-077a8a95604c','First','10','First','event','9d19f306-f5bd-45d5-95c5-bbc36112f758',NULL,'2024-09-26 08:49:30','2024-09-26 08:49:30');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('6TaxFR5z2sI1CfZcxCRH8pofsH065b8xSUbF41g4',15,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQXBPYmswcXVSSEw0ZlJFUHIyb1k3WDBCODB3VDRyclhWMGZtTEpXbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9teS1hY2NvdW50cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE1O30=',1731335003),('BSSzsoyUnOPvaw2tLpgRRyg3UEJF2hB0JjEp7EMQ',15,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiQlMxRUNnNmQ0T2NhNU9remNYSTVHRmRBdmxib3dRd2lNWU9DeTdNOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9teS1vcmRlcnMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjM6InVybCI7YToxOntzOjg6ImludGVuZGVkIjtzOjcwOiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvdi1mdW5kcmFpc2UvOWQxYTM4NGEtYjVmOS00MWM3LTg4OWEtYjQ1MzRkZmU5MmUxIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTU7fQ==',1731331968),('qQw2jGPVbL2LZM8mdTjXkXAdMLzj7hSY2mlyTLvj',15,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVXVKNUc3akxySWhpTldUeXhZUVZHWm1IdWVLVnlEbXdnU202Z053ciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjg6ODAwMC9teS1mdW5kcmFpc2VycyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE1O30=',1731334712);

--
-- Table structure for table `site_emails`
--

CREATE TABLE `site_emails` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sent` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_emails`
--


--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `state_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` VALUES (1,'a4f6573b-b15c-477f-9f14-a96b1db4e0bf','Florida',NULL,'2024-08-03 23:58:56','2024-08-03 23:58:56');

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `resource_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `account_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contributor_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` VALUES (1,'9cafd164-4c14-4eda-8f6e-5acfb740078c','contribution','9cafb47c-1edf-4239-bd0e-0210f5bcbb80','payment','Contribution to Something Form','9c7fe719-f571-45dd-b3df-077a8a95604c','1','80',NULL,'2024-08-04 14:37:42','2024-08-04 14:37:42','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','9cafd131-0067-4559-bab1-9b1a77687aac','9cae6aad-368a-4f5b-85fc-a1e142862863','9cafba87-e787-4aa2-88c1-7df70ccba3a4'),(2,'9cafdb6c-5d99-465b-be00-6900ffbdc86d','contribution','9cae6e5c-4fc6-46b8-b050-6c9f61315763','payment','Contribution to New Form','9c7fe719-f571-45dd-b3df-077a8a95604c','1','78',NULL,'2024-08-04 15:05:45','2024-08-04 15:05:45','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','9cafdb33-9768-4816-a8d7-ccbfabdfe80a',NULL,'9cafdae9-a9bd-403c-aaea-99866ecdef40'),(3,'9cafe30d-4a6a-41a5-b5c7-7bd42745f201','contribution','9cafb47c-1edf-4239-bd0e-0210f5bcbb80','payment','Contribution to Something Form','9c7fe719-f571-45dd-b3df-077a8a95604c','1','12',NULL,'2024-08-04 15:27:05','2024-08-04 15:27:05','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','9cafe2cb-2169-45f4-b78e-4db77a512954','9cae6aad-368a-4f5b-85fc-a1e142862863','9cafe27f-5649-44eb-9fa1-013963c4de33'),(4,'9cb19215-10da-4924-a5e6-4fdc2ac8d906','contribution','9cae6e5c-4fc6-46b8-b050-6c9f61315763','payment','Contribution to New Form','9c7fe719-f571-45dd-b3df-077a8a95604c','1','45',NULL,'2024-08-05 11:32:19','2024-08-05 11:32:19','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','9cb191d2-54f3-43f3-9efe-dc001fa0b5e0','9cae6aad-368a-4f5b-85fc-a1e142862863','9cb19165-aa6c-4e63-9eed-f3e6ef98240f'),(5,'9cb19d16-dc89-431b-93a8-5049e41765d0','contribution','9cae6e5c-4fc6-46b8-b050-6c9f61315763','payment','Contribution to New Form','9c7fe719-f571-45dd-b3df-077a8a95604c','1','50',NULL,'2024-08-05 12:03:06','2024-08-05 12:03:06','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','9cb19ce7-5639-4129-b9ca-afee2cc087f8',NULL,'9cb19c5c-8efa-4d50-871d-f011d25d4f0d'),(6,'9cb19f96-8f97-49c8-82f2-5d8cc7dcba85','contribution','9cae6e5c-4fc6-46b8-b050-6c9f61315763','payment','Contribution to New Form','9c7fe719-f571-45dd-b3df-077a8a95604c','1','90',NULL,'2024-08-05 12:10:05','2024-08-05 12:10:05','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','9cb19f69-d6bf-43bc-b900-e537c7cabc77','9cae6aad-368a-4f5b-85fc-a1e142862863','9cb19f3a-bb61-47a9-819b-6c12fc5775f0'),(7,'9cbfc5c3-37f7-49d0-a07d-f4580df08225','event','9cbfc56d-f7ab-4e90-8917-e2331f3c7159','payment','Ticket for Iure nesciunt quae ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','100',NULL,'2024-08-12 12:58:25','2024-08-12 12:58:25','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','9cbfc58f-b2cb-46ec-945d-d83d4efcdf24','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL),(9,'9cbfe4fa-fec4-4591-a8fd-d14bac1c2693','event','9cbfc56d-f7ab-4e90-8917-e2331f3c7159','payment','Ticket for Iure nesciunt quae ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','20',NULL,'2024-08-12 14:25:43','2024-08-12 14:25:43','9cae6e41-7a2e-4d30-ab39-ab0a71738a1e','9cbfe4d5-4b74-4917-8440-c1edc7c458c6','9cae6aad-368a-4f5b-85fc-a1e142862863',NULL),(10,'9cc04725-f9e1-4e7d-bcf7-b88d6bd31dcc','event','9cc04681-0777-4e6d-a700-a543e88c50a9','payment','Ticket for Dolore quae elit sa','9c7fe719-f571-45dd-b3df-077a8a95604c','1','1200',NULL,'2024-08-12 19:00:13','2024-08-12 19:00:13','9cb64e6d-0d11-4425-8c71-db57333a1e5f','9cc046f8-bfc5-4f3e-ae09-c65beea8c67b','9cb6339a-97fb-4c1e-8f65-b49d5301daa5',NULL),(11,'9cdd8676-58e8-4d45-881a-b361d89a4765','event','9cdd6961-a1a9-4d97-b876-21bbf0511173','payment','Ticket for Latest Event','9c7fe719-f571-45dd-b3df-077a8a95604c','1','60',NULL,'2024-08-27 07:56:16','2024-08-27 07:56:16','9cdd68ec-93c7-4d5b-88b1-2995201dce9b','9cdd8649-423c-40fe-90d1-f8b26b1ff196','9cdb356a-d2df-4890-9c52-d86d9ef85c40',NULL),(12,'9cdd9525-29f6-432e-8f76-d10c84299de4','event','9cdd6961-a1a9-4d97-b876-21bbf0511173','payment','Ticket for Latest Event','9c7fe719-f571-45dd-b3df-077a8a95604c','1','20',NULL,'2024-08-27 08:37:19','2024-08-27 08:37:19','9cdd68ec-93c7-4d5b-88b1-2995201dce9b','9cdd9501-dee3-49ec-a0b5-5febbd251468',NULL,NULL),(13,'9cdd9645-87b6-4f04-add6-0e6ac5a5bbc8','event','9cdd6961-a1a9-4d97-b876-21bbf0511173','payment','Ticket for Latest Event','9c7fe719-f571-45dd-b3df-077a8a95604c','1','25',NULL,'2024-08-27 08:40:28','2024-08-27 08:40:28','9cdd68ec-93c7-4d5b-88b1-2995201dce9b','9cdd95e2-5efb-408f-8be8-6678f36f6365',NULL,NULL),(14,'9cddb061-003e-4a66-92f3-58da7b2c2dbb','event','9cdd6961-a1a9-4d97-b876-21bbf0511173','payment','Ticket for Latest Event','9c7fe719-f571-45dd-b3df-077a8a95604c','1','15',NULL,'2024-08-27 09:53:28','2024-08-27 09:53:28','9cdd68ec-93c7-4d5b-88b1-2995201dce9b','9cddb03d-0ee6-476c-a5af-a25f72db2d31',NULL,NULL),(15,'9cddb112-eb71-446f-a59b-9d4a0bd08a7b','event','9cdd6961-a1a9-4d97-b876-21bbf0511173','payment','Ticket for Latest Event','9c7fe719-f571-45dd-b3df-077a8a95604c','1','95',NULL,'2024-08-27 09:55:25','2024-08-27 09:55:25','9cdd68ec-93c7-4d5b-88b1-2995201dce9b','9cddb0f1-dc8c-4e1f-be06-ed1e036ba0b9',NULL,'9cddb0d6-558e-4d90-a8f3-32f9574f6f96'),(16,'9d01edb2-a6eb-468b-bf32-1331dfc27455','fundraise','9cf80fd8-8b28-4652-b9a0-a16b8973682c','payment','Contribution to ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','20',NULL,'2024-09-14 10:14:44','2024-09-14 10:14:44','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','9d01ed85-d951-404c-aaa9-3ce2cb1671b7',NULL,'9d01ed66-fe38-4df6-920e-eb625b8daccf'),(17,'9d01f2e5-a39f-48b5-badb-a787e7f8ccfe','fundraise','9cf80fd8-8b28-4652-b9a0-a16b8973682c','payment','Contribution to ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','1333',NULL,'2024-09-14 10:29:16','2024-09-14 10:29:16','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','9d01f2c6-041d-4a9e-9445-52435661c547','9cec447c-bc9a-4784-a581-4b0051ff6880','9d01f277-9b17-4c54-b699-b52d09084184'),(18,'9d19ecc7-9e36-407d-b428-a26717c63d8e','fundraise','9cf80fd8-8b28-4652-b9a0-a16b8973682c','payment','Contribution to ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','90',NULL,'2024-09-26 08:32:02','2024-09-26 08:32:02','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','9d19eb5a-92c8-44ba-8d8f-55a684f9253c',NULL,'9d19eae5-018c-4fbd-9f3b-692858cb1dd4'),(19,'9d19f494-1d48-4733-b592-1d32046e2948','event','9d19f306-f5bd-45d5-95c5-bbc36112f758','payment','Ticket for My Event','9c7fe719-f571-45dd-b3df-077a8a95604c','1','50',NULL,'2024-09-26 08:53:50','2024-09-26 08:53:50','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','9d19f41f-f94f-4d9c-9275-805eb788e8ec','9cec447c-bc9a-4784-a581-4b0051ff6880','9d19f3e9-81c4-463c-92d3-a35b378bc2ae'),(20,'9d1a3925-0550-4609-9914-074ecdcd0083','fundraise','9d1a384a-b5f9-41c7-889a-b4534dfe92e1','payment','Contribution to ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','10000',NULL,'2024-09-26 12:05:34','2024-09-26 12:05:34','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','9d1a38ea-816b-4c35-bdf3-07ae7db2c6c4','9cec447c-bc9a-4784-a581-4b0051ff6880','9d1a389d-4331-4433-880c-f286c11e4ea2'),(22,'9d1adc88-6d36-4f9f-976b-b743ed2e88ff','fundraise','9d1adbde-fab3-459e-8168-9c9d0b22373d','payment','Contribution to ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','3000',NULL,'2024-09-26 19:42:26','2024-09-26 19:42:26','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','9d1adc51-e6c2-432d-8544-f04fd681923a',NULL,'9d1adc10-fa3a-451e-8d67-1be83c082154'),(23,'9d1add2e-438d-4e4c-bf67-8527a7bb3727','fundraise','9d1a384a-b5f9-41c7-889a-b4534dfe92e1','payment','Contribution to ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','3000',NULL,'2024-09-26 19:44:15','2024-09-26 19:44:15','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','9d1adcfa-696f-43f2-b9ca-c39c1e9e075d','9cec447c-bc9a-4784-a581-4b0051ff6880','9d1adcca-d67a-4aa7-b9f6-75a3431eaf8b'),(24,'9d76ae73-343a-4fd9-9139-6bc1997b23be','fundraise','9cf80fd8-8b28-4652-b9a0-a16b8973682c','payment','Contribution to ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','100',NULL,'2024-11-11 11:09:44','2024-11-11 11:09:44','9cf80eb5-5f3f-4892-80c6-e18ec85832f1','9d76ae41-1624-425a-bce4-946b62fc2387','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9','9d76ae1a-3208-40ce-ac92-c5dcbd3f8d30'),(25,'9d76afae-32b2-45f9-b577-7eedeb3ddb9d','event','9cc04681-0777-4e6d-a700-a543e88c50a9','payment','Ticket for Dolore quae elit sa','9c7fe719-f571-45dd-b3df-077a8a95604c','1','24',NULL,'2024-11-11 11:13:11','2024-11-11 11:13:11','9cb64e6d-0d11-4425-8c71-db57333a1e5f','9d76af7d-ecc2-4e4d-a0dd-d5375dea1368','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9','9d76af52-497f-436f-b768-d2f2ddd87037'),(26,'9d76b380-20eb-4594-aed4-16ed1b404c9a','fundraise','9d76b306-8b9b-451a-9129-6c42159fd11c','payment','Contribution to ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','20',NULL,'2024-11-11 11:23:52','2024-11-11 11:23:52','9d76b2c2-646a-4fc2-a0b9-927e049a19c4','9d76b356-a1a2-4b49-ac0c-b919ea2a2e6b',NULL,'9d76b325-f9bf-487a-a811-2b8785a7141e'),(27,'9d76b53c-d9ea-40a5-ad5b-51ac6b3aee73','fundraise','9d76b306-8b9b-451a-9129-6c42159fd11c','payment','Contribution to ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','19',NULL,'2024-11-11 11:28:43','2024-11-11 11:28:43','9d76b2c2-646a-4fc2-a0b9-927e049a19c4','9d76b502-82b1-4efa-bf08-6ca5dfe663f9',NULL,'9d76b4cd-5d52-4fbe-90ce-ee8d20509e35'),(28,'9d76bba9-3927-4570-881d-8cb22a7185b4','withdrawal','9d76bb08-154e-4361-8d18-1b78f15dbc54','withdrawal','Paid Withdrawal: EOlQ3W','9c7fe719-f571-45dd-b3df-077a8a95604c','1','8.50',NULL,'2024-11-11 11:46:41','2024-11-11 11:46:41','9d76b2c2-646a-4fc2-a0b9-927e049a19c4',NULL,NULL,NULL),(29,'9d76bba9-3b64-4373-8f3b-f1044aad0292','withdrawal','9d76bb08-154e-4361-8d18-1b78f15dbc54','withdrawal_fee','Withdrawal Fee for Withdrawal: EOlQ3W','9c7fe719-f571-45dd-b3df-077a8a95604c','1','1.5',NULL,'2024-11-11 11:46:41','2024-11-11 11:46:41','9d76b2c2-646a-4fc2-a0b9-927e049a19c4',NULL,NULL,NULL),(30,'9d76c84c-adf0-4bea-bb35-f2ca56ae5a4c','fundraise','9d76c70d-1e42-461d-b135-716bc45cff36','payment','Contribution to ','9c7fe719-f571-45dd-b3df-077a8a95604c','1','2999',NULL,'2024-11-11 12:22:01','2024-11-11 12:22:01','9d76b2c2-646a-4fc2-a0b9-927e049a19c4','9d76c811-523c-46bf-b93a-5510696ae1a6','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9','9d76c7a5-b595-43f3-bdea-181f4a31476d');

--
-- Table structure for table `user_banks`
--

CREATE TABLE `user_banks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_bank_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_holder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_banks`
--

INSERT INTO `user_banks` VALUES (1,'9cae6c82-00ef-4fd7-be76-7157c48cab23','9cae6aad-368a-4f5b-85fc-a1e142862863','c5f7109a-1843-4d75-8fb4-b833d5500d04','232098422','Gozo Takudzwa',NULL,'2024-08-03 21:59:47','2024-08-03 21:59:47');

--
-- Table structure for table `user_residents`
--

CREATE TABLE `user_residents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_resident_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `physical_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `city_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `zip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_residents`
--

INSERT INTO `user_residents` VALUES (1,'9cae6c81-fd55-4e6a-9d1d-29557d1cbba7','9cae6aad-368a-4f5b-85fc-a1e142862863','1432 Granary Estate Park','57d48593-e49d-459c-954b-c01f9ccced52','a4f6573b-b15c-477f-9f14-a96b1db4e0bf','00000000','0785991512','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-03 21:59:47','2024-08-03 21:59:47'),(2,'9cb64dfa-e8de-4fd3-8cb9-0db5a6fc1371','9cb6339a-97fb-4c1e-8f65-b49d5301daa5','1432 Granary Estate Park','57d48593-e49d-459c-954b-c01f9ccced52','a4f6573b-b15c-477f-9f14-a96b1db4e0bf','00000000','0785991512','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-07 20:01:02','2024-08-07 20:01:02'),(3,'9cdb35e0-2879-46db-b095-d77dc5a7839e','9cdb356a-d2df-4890-9c52-d86d9ef85c40','1432 Granary Estate Park','57d48593-e49d-459c-954b-c01f9ccced52','a4f6573b-b15c-477f-9f14-a96b1db4e0bf','00000000','0785991512','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-26 04:19:16','2024-08-26 04:19:16'),(4,'9cdf98ce-e3a4-462c-a5b1-da2c19c5d370','9cdf9890-4048-43d4-b379-cb78585dd4a8','1432 Granary Estate Park','57d48593-e49d-459c-954b-c01f9ccced52','a4f6573b-b15c-477f-9f14-a96b1db4e0bf','00000000','0785991512','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-08-28 08:39:13','2024-08-28 08:39:13'),(5,'9cec47f9-5c93-41da-bfdf-a257d02f5b62','9cec447c-bc9a-4784-a581-4b0051ff6880','','','','','0785991512','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-09-03 15:58:57','2024-09-03 15:58:57'),(6,'9d76ac68-03e5-40bc-82a8-478d8f8feab0','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9','1432 Granary Estate Park, Harare','57d48593-e49d-459c-954b-c01f9ccced52','a4f6573b-b15c-477f-9f14-a96b1db4e0bf','00000000','0785991512','5f76bf9c-329f-439e-885c-c1760ca82a60',NULL,'2024-11-11 11:04:01','2024-11-11 11:04:01');

--
-- Table structure for table `user_types`
--

CREATE TABLE `user_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_type_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_types`
--

INSERT INTO `user_types` VALUES (1,'62770c92-b5cb-42c2-b7e2-a5ebd109ce70','Developer',NULL,'2024-08-03 23:36:40','2024-08-03 23:36:40');

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `withdrawal_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount_paid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_charge` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdrawals`
--

INSERT INTO `withdrawals` VALUES (1,'9d76bb08-154e-4361-8d18-1b78f15dbc54','EOlQ3W','10','8.50','9d76b2c2-646a-4fc2-a0b9-927e049a19c4','9c7fe719-f571-45dd-b3df-077a8a95604c','9d76ab7d-8643-4eba-88d0-1cde1dd2b7e9','15','m','paid',NULL,'2024-11-11 11:44:55','2024-11-11 11:46:43');


