-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `joqo64qe_crownscope`
--

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

--
-- Table structure for table `accident_coverages`
--

CREATE TABLE `accident_coverages` (
  `id` int(11) NOT NULL,
  `package` varchar(50) DEFAULT NULL,
  `death` int(11) DEFAULT NULL,
  `permanent_total_disability` int(11) DEFAULT NULL,
  `temporary_total_disability` int(11) DEFAULT NULL,
  `medical_expenses` int(11) DEFAULT NULL,
  `last_expense` int(11) DEFAULT NULL,
  `artificial_limbs` int(11) DEFAULT NULL,
  `dental` int(11) DEFAULT NULL,
  `optical` int(11) DEFAULT NULL,
  `wheelchair` int(11) DEFAULT NULL,
  `hearing_aid` int(11) DEFAULT NULL,
  `local_evacuation` int(11) DEFAULT NULL,
  `ambulance_expenses` int(11) DEFAULT NULL,
  `rehabilitation` int(11) DEFAULT NULL,
  `premium_payable` int(11) DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `accident_coverages`
--

INSERT INTO `accident_coverages` (`id`, `package`, `death`, `permanent_total_disability`, `temporary_total_disability`, `medical_expenses`, `last_expense`, `artificial_limbs`, `dental`, `optical`, `wheelchair`, `hearing_aid`, `local_evacuation`, `ambulance_expenses`, `rehabilitation`, `premium_payable`, `file_path`) VALUES
(1, 'Gold', 5000000, 5000000, 20000, 200000, 100000, 65000, 7500, 8500, 30000, 7500, 40000, 40000, 40000, 10000, 'golfers/what_s covered/Golfer_s damage to golf equipment.png'),
(2, 'Silver', 2500000, 2500000, 12500, 100000, 50000, 50000, 5000, 5000, 10000, 5000, 25000, 25000, 25000, 6000, 'golfers/what_s covered/Golfer_s damage to golf equipment.png'),
(3, 'Bronze', 750000, 750000, 5000, 50000, 25000, 10000, 3000, 3000, 5000, NULL, NULL, NULL, NULL, 2000, 'golfers/what_s covered/Golfer_s damage to golf equipment.png');

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

--
-- Table structure for table `accident_details`
--

CREATE TABLE `accident_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `activity` int(11) NOT NULL DEFAULT '1',
  `cover_type` varchar(255) NOT NULL DEFAULT 'Accident',
  `status` varchar(255) DEFAULT 'pending',
  `expiry_date` date NOT NULL,
  `autorenew` tinyint(1) NOT NULL DEFAULT '0',
  `package` varchar(255) NOT NULL,
  `premium` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `payment` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `accident_details`
--

INSERT INTO `accident_details` (`id`, `user_id`, `activity`, `cover_type`, `status`, `expiry_date`, `autorenew`, `package`, `premium`, `amount`, `filename`, `payment`, `created_at`, `updated_at`) VALUES
(2, 41, 1, 'Accident', 'pending', '2024-10-05', 1, 'Gold', 2000, 2000, NULL, 'paid', '2024-09-05 06:56:51', '2024-09-11 07:05:02');

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

--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `log_name` varchar(255) DEFAULT NULL,
  `description` text,
  `subject_type` varchar(255) DEFAULT NULL,
  `subject_id` bigint(20) UNSIGNED DEFAULT NULL,
  `causer_type` varchar(255) DEFAULT NULL,
  `causer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `batch_uuid` char(36) DEFAULT NULL,
  `event` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `activity_log`
--

INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `subject_id`, `causer_type`, `causer_id`, `properties`, `batch_uuid`, `event`, `created_at`, `updated_at`) VALUES
(1, 'default', 'created', 'App\\Models\\User', 48, NULL, NULL, '{\"attributes\":{\"first_name\":\"uuu\",\"middle_name\":null,\"last_name\":\"nnpnjp\",\"email\":\"admin@admin.com15\",\"phone\":\"+254726756349\",\"is_verified\":0,\"type\":\"user\"}}', NULL, 'created', '2024-09-06 08:38:00', '2024-09-06 08:38:00'),
(2, 'default', 'created', 'App\\Models\\User', 49, NULL, NULL, '{\"attributes\":{\"first_name\":\"osano34\",\"middle_name\":null,\"last_name\":\"alvin6\",\"email\":\"toxicking2659@gmail.com\",\"phone\":\"+254728756234\",\"is_verified\":0,\"type\":\"user\"}}', NULL, 'created', '2024-09-06 08:40:44', '2024-09-06 08:40:44'),
(3, 'default', 'updated', 'App\\Models\\User', 49, 'App\\Models\\User', 49, '{\"attributes\":{\"is_verified\":1},\"old\":{\"is_verified\":0}}', NULL, 'updated', '2024-09-06 09:18:12', '2024-09-06 09:18:12'),
(4, 'default', 'created', 'App\\Models\\UserDetail', 18, 'App\\Models\\User', 49, '{\"attributes\":{\"user_id\":49,\"kra_pin\":null,\"selfie_path\":\"\\/storage\\/selfies\\/70IPTHCusJ6oc55oYKSXfO088WxCqwSZPXXHDjJ1.jpg\",\"national_id_front_path\":null,\"national_id_back_path\":null,\"home_address\":\"Latitude: -1.523712, Longitude: 37.260493\",\"date_of_birth\":\"2024-09-11\",\"pre_existing_conditions\":\"none\"}}', NULL, 'created', '2024-09-06 09:22:20', '2024-09-06 09:22:20'),
(5, 'default', 'created', 'App\\Models\\MpesaSTK', 210, NULL, NULL, '{\"attributes\":{\"MerchantRequestID\":null,\"CheckoutRequestID\":null,\"ResultCode\":null,\"ResultDesc\":null,\"Amount\":null,\"MpesaReceiptNumber\":null,\"Balance\":null,\"TransactionDate\":null,\"PhoneNumber\":null,\"user_id\":null}}', NULL, 'created', '2024-09-06 12:09:13', '2024-09-06 12:09:13'),
(6, 'default', 'updated', 'App\\Models\\GolfersDetail', 17, 'App\\Models\\User', 41, '{\"attributes\":{\"filename\":\"receipt_17.pdf\"},\"old\":{\"filename\":null}}', NULL, 'updated', '2024-09-07 07:58:17', '2024-09-07 07:58:17'),
(7, 'default', 'created', 'App\\Models\\Paystack', 3, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"cover_type\":\"Golfers\",\"amount\":\"4000.00\",\"payment_method\":\"paystack\",\"transaction_id\":\"534501199\",\"status\":\"completed\"}}', NULL, 'created', '2024-09-07 08:42:05', '2024-09-07 08:42:05'),
(8, 'default', 'updated', 'App\\Models\\Paystack', 3, 'App\\Models\\User', 41, '{\"attributes\":{\"amount\":\"0.00\"},\"old\":{\"amount\":\"4000.00\"}}', NULL, 'updated', '2024-09-07 08:42:19', '2024-09-07 08:42:19'),
(9, 'default', 'created', 'App\\Models\\Paystack', 4, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"cover_type\":\"Golfers\",\"amount\":\"4033.00\",\"payment_method\":\"paystack\",\"transaction_id\":\"947855529\",\"status\":\"completed\"}}', NULL, 'created', '2024-09-07 08:57:39', '2024-09-07 08:57:39'),
(10, 'default', 'updated', 'App\\Models\\GolfersDetail', 17, 'App\\Models\\User', 41, '{\"attributes\":{\"filename\":\"receipt_17.pdf\"},\"old\":{\"filename\":\"\"}}', NULL, 'updated', '2024-09-07 08:57:50', '2024-09-07 08:57:50'),
(11, 'default', 'updated', 'App\\Models\\Paystack', 4, 'App\\Models\\User', 41, '{\"attributes\":{\"amount\":\"0.00\"},\"old\":{\"amount\":\"4033.00\"}}', NULL, 'updated', '2024-09-07 08:58:00', '2024-09-07 08:58:00'),
(12, 'default', 'updated', 'App\\Models\\Notification', 13, 'App\\Models\\User', 41, '{\"attributes\":{\"notification_count\":3},\"old\":{\"notification_count\":2}}', NULL, 'updated', '2024-09-08 06:02:44', '2024-09-08 06:02:44'),
(13, 'default', 'created', 'App\\Models\\Paystack', 5, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"cover_type\":\"Golfers\",\"amount\":\"4033.00\",\"payment_method\":\"paystack\",\"transaction_id\":\"647395408\",\"status\":\"completed\"}}', NULL, 'created', '2024-09-08 15:51:17', '2024-09-08 15:51:17'),
(14, 'default', 'updated', 'App\\Models\\Paystack', 5, 'App\\Models\\User', 41, '{\"attributes\":{\"amount\":\"0.00\"},\"old\":{\"amount\":\"4033.00\"}}', NULL, 'updated', '2024-09-08 15:51:27', '2024-09-08 15:51:27'),
(15, 'default', 'created', 'App\\Models\\Paystack', 6, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"cover_type\":\"Golfers\",\"amount\":\"4033.00\",\"payment_method\":\"paystack\",\"transaction_id\":\"448742766\",\"status\":\"completed\"}}', NULL, 'created', '2024-09-08 15:56:09', '2024-09-08 15:56:09'),
(16, 'default', 'updated', 'App\\Models\\Paystack', 6, 'App\\Models\\User', 41, '{\"attributes\":{\"amount\":\"0.00\"},\"old\":{\"amount\":\"4033.00\"}}', NULL, 'updated', '2024-09-08 15:56:19', '2024-09-08 15:56:19'),
(17, 'default', 'created', 'App\\Models\\Paystack', 7, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"cover_type\":\"Golfers\",\"amount\":\"4033.00\",\"payment_method\":\"paystack\",\"transaction_id\":\"783938255\",\"status\":\"completed\"}}', NULL, 'created', '2024-09-08 16:01:33', '2024-09-08 16:01:33'),
(18, 'default', 'updated', 'App\\Models\\Paystack', 7, 'App\\Models\\User', 41, '{\"attributes\":{\"amount\":\"0.00\"},\"old\":{\"amount\":\"4033.00\"}}', NULL, 'updated', '2024-09-08 16:01:57', '2024-09-08 16:01:57'),
(19, 'default', 'updated', 'App\\Models\\Notification', 11, 'App\\Models\\User', 41, '{\"attributes\":{\"notification_count\":3},\"old\":{\"notification_count\":2}}', NULL, 'updated', '2024-09-09 13:27:26', '2024-09-09 13:27:26'),
(20, 'default', 'updated', 'App\\Models\\Notification', 11, 'App\\Models\\User', 41, '{\"attributes\":{\"kra_pin\":\"1\",\"home_address\":\"1\",\"dob\":\"1\"},\"old\":{\"kra_pin\":\"0\",\"home_address\":\"0\",\"dob\":\"0\"}}', NULL, 'updated', '2024-09-09 17:27:45', '2024-09-09 17:27:45'),
(21, 'default', 'updated', 'App\\Models\\Notification', 12, 'App\\Models\\User', 41, '{\"attributes\":{\"notification_count\":3},\"old\":{\"notification_count\":0}}', NULL, 'updated', '2024-09-09 17:37:12', '2024-09-09 17:37:12'),
(22, 'default', 'updated', 'App\\Models\\Notification', 12, 'App\\Models\\User', 41, '{\"attributes\":{\"kra_pin\":\"1\",\"selfie\":\"1\",\"home_address\":\"1\",\"dob\":\"1\"},\"old\":{\"kra_pin\":\"0\",\"selfie\":\"0\",\"home_address\":\"0\",\"dob\":\"0\"}}', NULL, 'updated', '2024-09-09 17:38:59', '2024-09-09 17:38:59'),
(23, 'default', 'created', 'App\\Models\\Notification', 1, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"kra_pin\":1,\"selfie\":1,\"id_card\":null,\"home_address\":1,\"dob\":1,\"notification_count\":0}}', NULL, 'created', '2024-09-09 18:42:58', '2024-09-09 18:42:58'),
(24, 'default', 'updated', 'App\\Models\\Notification', 1, 'App\\Models\\User', 41, '{\"attributes\":{\"notification_count\":3},\"old\":{\"notification_count\":0}}', NULL, 'updated', '2024-09-09 18:43:14', '2024-09-09 18:43:14'),
(25, 'default', 'created', 'App\\Models\\Notification', 2, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"kra_pin\":1,\"selfie\":1,\"id_card\":null,\"home_address\":1,\"dob\":1,\"notification_count\":0}}', NULL, 'created', '2024-09-09 19:03:57', '2024-09-09 19:03:57'),
(26, 'default', 'updated', 'App\\Models\\Notification', 2, 'App\\Models\\User', 41, '{\"attributes\":{\"notification_count\":3},\"old\":{\"notification_count\":0}}', NULL, 'updated', '2024-09-09 19:07:09', '2024-09-09 19:07:09'),
(27, 'default', 'updated', 'App\\Models\\Notification', 2, 'App\\Models\\User', 41, '{\"attributes\":{\"notification_count\":3},\"old\":{\"notification_count\":1}}', NULL, 'updated', '2024-09-09 19:23:22', '2024-09-09 19:23:22'),
(28, 'default', 'created', 'App\\Models\\Notification', 3, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"kra_pin\":1,\"selfie\":1,\"id_card\":null,\"home_address\":1,\"dob\":1,\"notification_count\":1}}', NULL, 'created', '2024-09-09 19:28:03', '2024-09-09 19:28:03'),
(29, 'default', 'updated', 'App\\Models\\Notification', 3, 'App\\Models\\User', 41, '{\"attributes\":{\"notification_count\":3},\"old\":{\"notification_count\":1}}', NULL, 'updated', '2024-09-09 19:28:45', '2024-09-09 19:28:45'),
(30, 'default', 'created', 'App\\Models\\GolfersDetail', 18, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"activity\":1,\"cover_type\":\"Golfers\",\"status\":\"Active\",\"expiry_date\":\"2024-10-09T00:00:00.000000Z\",\"autorenew\":false,\"package\":\"Bronze\",\"premium\":\"2750\",\"filename\":null}}', NULL, 'created', '2024-09-09 19:50:47', '2024-09-09 19:50:47'),
(31, 'default', 'created', 'App\\Models\\Paystack', 8, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"cover_type\":\"Golfers\",\"amount\":\"2750.00\",\"payment_method\":\"paystack\",\"transaction_id\":\"163879459\",\"status\":\"completed\"}}', NULL, 'created', '2024-09-09 19:51:51', '2024-09-09 19:51:51'),
(32, 'default', 'updated', 'App\\Models\\GolfersDetail', 18, 'App\\Models\\User', 41, '{\"attributes\":{\"filename\":\"receipt_18.pdf\"},\"old\":{\"filename\":null}}', NULL, 'updated', '2024-09-09 19:52:41', '2024-09-09 19:52:41'),
(33, 'default', 'updated', 'App\\Models\\Paystack', 8, 'App\\Models\\User', 41, '{\"attributes\":{\"amount\":\"0.00\"},\"old\":{\"amount\":\"2750.00\"}}', NULL, 'updated', '2024-09-09 19:52:53', '2024-09-09 19:52:53'),
(34, 'default', 'created', 'App\\Models\\GolfersDetail', 19, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"activity\":1,\"cover_type\":\"Golfers\",\"status\":\"Active\",\"expiry_date\":\"2024-10-10T00:00:00.000000Z\",\"autorenew\":false,\"package\":\"Silver\",\"premium\":\"4000\",\"filename\":null}}', NULL, 'created', '2024-09-10 02:55:15', '2024-09-10 02:55:15'),
(35, 'default', 'created', 'App\\Models\\Paystack', 9, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"cover_type\":\"Golfers\",\"amount\":\"4000.00\",\"payment_method\":\"paystack\",\"transaction_id\":\"782534616\",\"status\":\"completed\"}}', NULL, 'created', '2024-09-10 02:55:31', '2024-09-10 02:55:31'),
(36, 'default', 'updated', 'App\\Models\\GolfersDetail', 19, 'App\\Models\\User', 41, '{\"attributes\":{\"filename\":\"receipt_19.pdf\"},\"old\":{\"filename\":null}}', NULL, 'updated', '2024-09-10 02:55:45', '2024-09-10 02:55:45'),
(37, 'default', 'updated', 'App\\Models\\Paystack', 9, 'App\\Models\\User', 41, '{\"attributes\":{\"amount\":\"0.00\"},\"old\":{\"amount\":\"4000.00\"}}', NULL, 'updated', '2024-09-10 02:55:55', '2024-09-10 02:55:55'),
(38, 'default', 'updated', 'App\\Models\\RentersDetail', 4, 'App\\Models\\User', 41, '{\"attributes\":{\"autorenew\":true},\"old\":{\"autorenew\":false}}', NULL, 'updated', '2024-09-10 03:32:03', '2024-09-10 03:32:03'),
(39, 'default', 'created', 'App\\Models\\Notification', 4, 'App\\Models\\User', 40, '{\"attributes\":{\"user_id\":40,\"kra_pin\":0,\"selfie\":0,\"id_card\":null,\"home_address\":0,\"dob\":0,\"notification_count\":1}}', NULL, 'created', '2024-09-10 05:03:44', '2024-09-10 05:03:44'),
(40, 'default', 'updated', 'App\\Models\\RentersDetail', 4, 'App\\Models\\User', 41, '{\"attributes\":{\"autorenew\":false},\"old\":{\"autorenew\":true}}', NULL, 'updated', '2024-09-10 17:05:16', '2024-09-10 17:05:16'),
(41, 'default', 'created', 'App\\Models\\GolfersDetail', 20, 'App\\Models\\User', 41, '{\"attributes\":{\"user_id\":41,\"activity\":1,\"cover_type\":\"Golfers\",\"status\":\"Active\",\"expiry_date\":\"2024-10-12T00:00:00.000000Z\",\"autorenew\":false,\"package\":\"Bronze\",\"premium\":\"2750\",\"filename\":null}}', NULL, 'created', '2024-09-12 00:01:09', '2024-09-12 00:01:09'),
(42, 'default', 'created', 'App\\Models\\User', 50, NULL, NULL, '{\"attributes\":{\"first_name\":\"KIPKEMBOI\",\"middle_name\":null,\"last_name\":\"BRIAN\",\"email\":\"kipkemboibrian864@gmail.com\",\"phone\":\"+254728756236\",\"is_verified\":0,\"type\":\"user\"}}', NULL, 'created', '2024-09-12 10:57:22', '2024-09-12 10:57:22'),
(43, 'default', 'updated', 'App\\Models\\User', 50, 'App\\Models\\User', 50, '{\"attributes\":{\"is_verified\":1},\"old\":{\"is_verified\":0}}', NULL, 'updated', '2024-09-12 10:58:56', '2024-09-12 10:58:56'),
(44, 'default', 'created', 'App\\Models\\Notification', 5, 'App\\Models\\User', 50, '{\"attributes\":{\"user_id\":50,\"kra_pin\":0,\"selfie\":0,\"id_card\":null,\"home_address\":0,\"dob\":0,\"notification_count\":1}}', NULL, 'created', '2024-09-12 11:03:04', '2024-09-12 11:03:04'),
(45, 'default', 'created', 'App\\Models\\Notification', 6, 'App\\Models\\User', 49, '{\"attributes\":{\"user_id\":49,\"kra_pin\":0,\"selfie\":0,\"id_card\":null,\"home_address\":0,\"dob\":0,\"notification_count\":1}}', NULL, 'created', '2024-09-12 11:49:20', '2024-09-12 11:49:20'),
(46, 'default', 'updated', 'App\\Models\\Notification', 6, 'App\\Models\\User', 49, '{\"attributes\":{\"notification_count\":2},\"old\":{\"notification_count\":1}}', NULL, 'updated', '2024-09-12 11:49:40', '2024-09-12 11:49:40'),
(47, 'default', 'created', 'App\\Models\\Notification', 7, 'App\\Models\\User', 36, '{\"attributes\":{\"user_id\":36,\"kra_pin\":0,\"selfie\":0,\"id_card\":null,\"home_address\":0,\"dob\":0,\"notification_count\":1}}', NULL, 'created', '2024-09-12 13:13:03', '2024-09-12 13:13:03'),
(48, 'default', 'created', 'App\\Models\\User', 51, NULL, NULL, '{\"attributes\":{\"first_name\":\"Brian\",\"middle_name\":null,\"last_name\":\"Osoro\",\"email\":\"nyambsb@gmail.com\",\"phone\":\"+254708593463\",\"is_verified\":0,\"type\":\"user\"}}', NULL, 'created', '2024-09-12 14:42:59', '2024-09-12 14:42:59'),
(49, 'default', 'created', 'App\\Models\\User', 52, NULL, NULL, '{\"attributes\":{\"first_name\":\"Brian\",\"middle_name\":null,\"last_name\":\"Osoro\",\"email\":\"nyambsb@gmail.com\",\"phone\":\"+254708593463\",\"is_verified\":0,\"type\":\"user\"}}', NULL, 'created', '2024-09-12 14:48:58', '2024-09-12 14:48:58'),
(50, 'default', 'updated', 'App\\Models\\User', 52, 'App\\Models\\User', 52, '{\"attributes\":{\"is_verified\":1},\"old\":{\"is_verified\":0}}', NULL, 'updated', '2024-09-12 14:49:29', '2024-09-12 14:49:29'),
(51, 'default', 'created', 'App\\Models\\Notification', 8, 'App\\Models\\User', 52, '{\"attributes\":{\"user_id\":52,\"kra_pin\":0,\"selfie\":0,\"id_card\":null,\"home_address\":0,\"dob\":0,\"notification_count\":1}}', NULL, 'created', '2024-09-12 14:56:30', '2024-09-12 14:56:30'),
(52, 'default', 'updated', 'App\\Models\\Notification', 8, 'App\\Models\\User', 52, '{\"attributes\":{\"notification_count\":2},\"old\":{\"notification_count\":1}}', NULL, 'updated', '2024-09-12 14:56:59', '2024-09-12 14:56:59'),
(53, 'default', 'created', 'App\\Models\\GolfersDetail', 21, 'App\\Models\\User', 52, '{\"attributes\":{\"user_id\":52,\"activity\":1,\"cover_type\":\"Golfers\",\"status\":\"Active\",\"expiry_date\":\"2024-10-12T00:00:00.000000Z\",\"autorenew\":false,\"package\":\"Bronze\",\"premium\":\"2750\",\"filename\":null}}', NULL, 'created', '2024-09-12 15:06:43', '2024-09-12 15:06:43'),
(54, 'default', 'created', 'App\\Models\\MpesaSTK', 211, NULL, NULL, '{\"attributes\":{\"MerchantRequestID\":\"9566-48c7-8be0-71e5ae4748f078308925\",\"CheckoutRequestID\":\"ws_CO_12092024121536029708593463\",\"ResultCode\":1032,\"ResultDesc\":\"Request cancelled by user\",\"Amount\":null,\"MpesaReceiptNumber\":null,\"Balance\":null,\"TransactionDate\":null,\"PhoneNumber\":null,\"user_id\":null}}', NULL, 'created', '2024-09-12 15:15:42', '2024-09-12 15:15:42'),
(55, 'default', 'created', 'App\\Models\\Paystack', 10, 'App\\Models\\User', 52, '{\"attributes\":{\"user_id\":52,\"cover_type\":\"Golfers\",\"amount\":\"2750.00\",\"payment_method\":\"paystack\",\"transaction_id\":\"424670018\",\"status\":\"completed\"}}', NULL, 'created', '2024-09-12 15:16:02', '2024-09-12 15:16:02'),
(56, 'default', 'updated', 'App\\Models\\GolfersDetail', 21, 'App\\Models\\User', 52, '{\"attributes\":{\"filename\":\"receipt_21.pdf\"},\"old\":{\"filename\":null}}', NULL, 'updated', '2024-09-12 15:16:09', '2024-09-12 15:16:09'),
(57, 'default', 'updated', 'App\\Models\\Paystack', 10, 'App\\Models\\User', 52, '{\"attributes\":{\"amount\":\"0.00\"},\"old\":{\"amount\":\"2750.00\"}}', NULL, 'updated', '2024-09-12 15:16:15', '2024-09-12 15:16:15');

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

--
-- Table structure for table `claims`
--

CREATE TABLE `claims` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `policy` varchar(255) NOT NULL,
  `claim_number` varchar(255) NOT NULL,
  `date_filed` datetime NOT NULL,
  `last_updated` datetime NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'open',
  `customer` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT '1000.00',
  `conversation_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `claims`
--

INSERT INTO `claims` (`id`, `policy`, `claim_number`, `date_filed`, `last_updated`, `status`, `customer`, `user_id`, `amount`, `conversation_id`, `created_at`, `updated_at`) VALUES
(3, 'Medical', 'MED/20240908/yJYTu2', '2024-09-08 08:36:18', '2024-09-08 08:36:18', 'open', 'osano', 41, 1000.00, 12, '2024-09-08 05:36:18', '2024-09-08 05:36:18'),
(5, 'Personal Accident', 'PER/20240908/MzPuGW', '2024-09-08 15:08:10', '2024-09-08 15:08:10', 'open', 'osano', 41, 1000.00, 20, '2024-09-08 12:08:10', '2024-09-08 12:08:10'),
(8, 'Golfers', 'GOL/20240912/csSQIa', '2024-09-12 03:16:29', '2024-09-12 03:16:29', 'closed', 'osano', 41, 1000.00, 23, '2024-09-12 00:16:29', '2024-09-12 00:16:29'),
(9, 'Golfers', 'GOL/20240912/kmoByi', '2024-09-12 03:19:14', '2024-09-12 03:19:14', 'open', 'osano', 41, 1000.00, 24, '2024-09-12 00:19:14', '2024-09-12 00:19:14'),
(10, 'Travel', 'TRA/20240912/d6a6HV', '2024-09-12 03:22:27', '2024-09-12 03:22:27', 'open', 'osano', 41, 1000.00, 25, '2024-09-12 00:22:27', '2024-09-12 00:22:27'),
(11, 'Domestic Package', 'DOM/20240912/M3HIeT', '2024-09-12 03:24:03', '2024-09-12 03:24:03', 'open', 'osano', 41, 1000.00, 26, '2024-09-12 00:24:03', '2024-09-12 00:24:03');

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

--
-- Table structure for table `conversations`
--

CREATE TABLE `conversations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `conversation` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `claim_type` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `conversations`
--

INSERT INTO `conversations` (`id`, `user_id`, `conversation`, `claim_type`, `created_at`, `updated_at`) VALUES
(12, 41, '[{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Hi,osano! I understand you\\u2019d like to report a claim. I\\u2019ll be happy to help with that.!\\n                \",\"timestamp\":\"2024-09-08T08:36:17.968Z\"},{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                First, can you confirm which policy you\\u2019re claiming under?                \",\"timestamp\":\"2024-09-08T08:36:17.968Z\"},{\"index\":1.5,\"sender\":\"user\",\"message\":\"I want to claim Medical\",\"timestamp\":\"2024-09-08T08:36:17.968Z\"},{\"index\":1,\"sender\":\"bot\",\"message\":\"Let\'s get started with your medical claim at Crownscope Insurance Brokers. I\'m here to help. To process your claim efficiently, could you please tell me the story of what happened?\",\"timestamp\":\"2024-09-08T08:36:17.968Z\"},{\"index\":2.5,\"sender\":\"user\",\"message\":\"yyyu\",\"timestamp\":\"2024-09-08T08:36:17.968Z\"},{\"index\":2,\"sender\":\"bot\",\"message\":\"It seems like there might be some technical issue with your response. Please disregard the \'yyyu\' as it\'s unclear. Let\'s try again. Could you please tell me the story of what happened?\",\"timestamp\":\"2024-09-08T08:36:17.968Z\"}]', 'Medical', '2024-09-08 05:36:18', '2024-09-08 05:36:18'),
(13, 41, '[{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Hi,osano! I understand you\\u2019d like to report a claim. I\\u2019ll be happy to help with that.!\\n                \",\"timestamp\":\"2024-09-08T14:17:03.495Z\"},{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                First, can you confirm which policy you\\u2019re claiming under?                \",\"timestamp\":\"2024-09-08T14:17:03.495Z\"}]', 'Travel', '2024-09-08 11:17:04', '2024-09-08 11:17:04'),
(20, 41, '[{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Hi,osano! I understand you\\u2019d like to report a claim. I\\u2019ll be happy to help with that.!\\n                \",\"timestamp\":\"2024-09-08T15:08:09.904Z\"},{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                First, can you confirm which policy you\\u2019re claiming under?                \",\"timestamp\":\"2024-09-08T15:08:09.904Z\"},{\"index\":1.5,\"sender\":\"user\",\"message\":\"I want to claim Personal Accident\",\"timestamp\":\"2024-09-08T15:08:09.904Z\"},{\"index\":1,\"sender\":\"bot\",\"message\":\"Are you okay? Can you share what happened?\",\"timestamp\":\"2024-09-08T15:08:09.904Z\"}]', 'Personal Accident', '2024-09-08 12:08:10', '2024-09-08 12:08:10'),
(23, 41, '[{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Hi,osano! I understand you\\u2019d like to report a claim. I\\u2019ll be happy to help with that.!\\n                \",\"timestamp\":\"2024-09-12T03:16:29.040Z\"},{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Make sure to finish your conversation before clicking \'Done.\' Clicking \'Done\' will finalize and submit your claim.\\n                \",\"timestamp\":\"2024-09-12T03:16:29.040Z\"},{\"index\":1,\"sender\":\"bot\",\"message\":\"\\n                First, can you confirm which policy you\\u2019re claiming under?                \",\"timestamp\":\"2024-09-12T03:16:29.040Z\"},{\"index\":2.5,\"sender\":\"user\",\"message\":\"I want to claim Golfers\",\"timestamp\":\"2024-09-12T03:16:29.040Z\"},{\"index\":2,\"sender\":\"bot\",\"message\":\"You mean you want to make a claim for `Loss\\/Damage to Golf Equipment`. That\'s our first type of claim. Here\'s what we need from you:\\n\\nWhat finally happened to your Golfers? & Please Try to Give the Full Story\\n\\n(If you\'re having trouble describing what happened, don\'t worry, we\'ll get through this together!)\",\"timestamp\":\"2024-09-12T03:16:29.040Z\"}]', 'Golfers', '2024-09-12 00:16:29', '2024-09-12 00:16:29'),
(24, 41, '[{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Hi,osano! I understand you\\u2019d like to report a claim. I\\u2019ll be happy to help with that.!\\n                \",\"timestamp\":\"2024-09-12T03:19:13.649Z\"},{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Make sure to finish your conversation before clicking \'Done.\' Clicking \'Done\' will finalize and submit your claim.\\n                \",\"timestamp\":\"2024-09-12T03:19:13.650Z\"},{\"index\":1,\"sender\":\"bot\",\"message\":\"\\n                First, can you confirm which policy you\\u2019re claiming under?                \",\"timestamp\":\"2024-09-12T03:19:13.650Z\"},{\"index\":2.5,\"sender\":\"user\",\"message\":\"I want to claim Golfers\",\"timestamp\":\"2024-09-12T03:19:13.650Z\"},{\"index\":2,\"sender\":\"bot\",\"message\":\"One last time... What happened specifically to your golf clubs, and can you provide us with as much detail as possible?\",\"timestamp\":\"2024-09-12T03:19:13.651Z\"}]', 'Golfers', '2024-09-12 00:19:14', '2024-09-12 00:19:14'),
(25, 41, '[{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Hi,osano! I understand you\\u2019d like to report a claim. I\\u2019ll be happy to help with that.!\\n                \",\"timestamp\":\"2024-09-12T03:22:26.841Z\"},{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Make sure to finish your conversation before clicking \'Done.\' Clicking \'Done\' will finalize and submit your claim.\\n                \",\"timestamp\":\"2024-09-12T03:22:26.841Z\"},{\"index\":1,\"sender\":\"bot\",\"message\":\"\\n                First, can you confirm which policy you\\u2019re claiming under?                \",\"timestamp\":\"2024-09-12T03:22:26.841Z\"},{\"index\":2.5,\"sender\":\"user\",\"message\":\"I want to claim Travel\",\"timestamp\":\"2024-09-12T03:22:26.841Z\"},{\"index\":2,\"sender\":\"bot\",\"message\":\"Where did you go?\",\"timestamp\":\"2024-09-12T03:22:26.841Z\"}]', 'Travel', '2024-09-12 00:22:27', '2024-09-12 00:22:27'),
(26, 41, '[{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Hi,osano! I understand you\\u2019d like to report a claim. I\\u2019ll be happy to help with that.!\\n                \",\"timestamp\":\"2024-09-12T03:24:02.691Z\"},{\"index\":0,\"sender\":\"bot\",\"message\":\"\\n                    Make sure to finish your conversation before clicking \'Done.\' Clicking \'Done\' will finalize and submit your claim.\\n                \",\"timestamp\":\"2024-09-12T03:24:02.691Z\"},{\"index\":1,\"sender\":\"bot\",\"message\":\"\\n                First, can you confirm which policy you\\u2019re claiming under?                \",\"timestamp\":\"2024-09-12T03:24:02.691Z\"},{\"index\":2.5,\"sender\":\"user\",\"message\":\"I want to claim Domestic Package\",\"timestamp\":\"2024-09-12T03:24:02.691Z\"},{\"index\":2,\"sender\":\"bot\",\"message\":\"I\'d be happy to assist you with that.\\n\\nWhere did you go on your domestic trip?\",\"timestamp\":\"2024-09-12T03:24:02.691Z\"}]', 'Domestic Package', '2024-09-12 00:24:03', '2024-09-12 00:24:03');

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

--
-- Table structure for table `domestics_details`
--

CREATE TABLE `domestics_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `activity` tinyint(1) DEFAULT '0',
  `cover_type` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `autorenew` tinyint(1) DEFAULT '1',
  `payment` varchar(255) DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `domestics_details`
--

INSERT INTO `domestics_details` (`id`, `user_id`, `activity`, `cover_type`, `status`, `created_at`, `updated_at`, `expiry_date`, `autorenew`, `payment`) VALUES
(1, 41, 1, 'domestics', 'active', '2024-08-05 20:24:12', '2024-09-10 17:05:09', '2024-08-18', 1, 'pending');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `golfers_detailofcover`
--

CREATE TABLE `golfers_detailofcover` (
  `id` int(11) NOT NULL,
  `plan_name` varchar(50) NOT NULL,
  `premium` decimal(10,2) NOT NULL,
  `coverage_name` varchar(255) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `description` text NOT NULL,
  `exclusion_type` varchar(255) NOT NULL,
  `exclusion_description` text NOT NULL,
  `file_path` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `golfers_detailofcover`
--

INSERT INTO `golfers_detailofcover` (`id`, `plan_name`, `premium`, `coverage_name`, `amount`, `created_at`, `updated_at`, `description`, `exclusion_type`, `exclusion_description`, `file_path`) VALUES
(1, 'Bronze', 2750.00, 'Loss or damage to golf equipment', 'Ksh 150,000', '2024-08-06 10:06:50', '2024-08-12 13:32:49', 'For when your kit or clubs gets damaged or stolen', 'Cash', 'Loose cash or change isn\'t covered if it gets lost or stolen on the course', 'golfers/what_s covered/Golfer_s damage to golf equipment.png'),
(2, 'Bronze', 2750.00, 'Loss or damage to personal effects', 'Ksh 50,000', '2024-08-06 10:06:50', '2024-08-10 16:45:26', 'For when your stuff gets lost or stolen', 'Natural wear and tear', 'Things may deteriorate over time. Which is why you can\'t claim back for new items when this happens', '/golfers/what_s covered/Damage or loss to personal effects.png'),
(3, 'Bronze', 2750.00, 'Third-party liability', 'Ksh 500,000', '2024-08-06 10:06:50', '2024-08-10 16:47:04', '', '', '', '/golfers/what_s covered/Third party liability.png'),
(4, 'Bronze', 2750.00, 'Personal accident', 'Ksh 250,000', '2024-08-06 10:06:50', '2024-08-12 13:33:02', 'In case you get hurt on the course', '', '', 'golfers/what_s covered/Personal accident.png'),
(5, 'Bronze', 2750.00, 'Hole-in-one', 'Ksh 30,000', '2024-08-06 10:06:50', '2024-08-10 16:31:32', '', '', '', '/golfers/what_scovered/hole in one.png'),
(6, 'Silver', 4000.00, 'Loss or damage to golf equipment', 'Ksh 200,000', '2024-08-06 10:06:50', '2024-08-12 13:39:41', 'For when your kit or clubs gets damaged or stolen', '', '', 'golfers/what_s covered/Golfer_s damage to golf equipment.png'),
(7, 'Silver', 4000.00, 'Loss or damage to personal effects', 'Ksh 75,000', '2024-08-06 10:06:50', '2024-08-10 16:45:14', 'For when your stuff gets lost or stolen', '', '', '/golfers/what_s covered/Damage or loss to personal effects.png'),
(8, 'Silver', 4000.00, 'Third-party liability', 'Ksh 750,000', '2024-08-06 10:06:50', '2024-08-10 16:48:15', '', '', '', '/golfers/what_s covered/Third party liability.png'),
(9, 'Silver', 4000.00, 'Personal accident', 'Ksh 500,000', '2024-08-06 10:06:50', '2024-08-10 16:50:23', 'In case you get hurt on the course', '', '', 'golfers/What_s covered/Personal accident.png'),
(10, 'Silver', 4000.00, 'Hole-in-one', 'Ksh 50,000', '2024-08-06 10:06:50', '2024-08-12 13:38:14', '', '', '', 'golfers/what_s covered/hole in one.png'),
(11, 'Gold', 6000.00, 'Loss or damage to golf equipment', 'Ksh 250,000', '2024-08-06 10:06:50', '2024-08-12 13:39:07', 'For when your kit or clubs gets damaged or stolen', '', '', 'golfers/what_s covered/Golfer_s damage to golf equipment.png'),
(12, 'Gold', 6000.00, 'Loss or damage to personal effects', 'Ksh 100,000', '2024-08-06 10:06:50', '2024-08-10 16:44:27', 'For when your stuff gets lost or stolen', '', '', '/golfers/what_s covered/Damage or loss to personal effects.png'),
(13, 'Gold', 6000.00, 'Third-party liability', 'Ksh 1,000,000', '2024-08-06 10:06:50', '2024-08-10 16:48:22', '', '', '', '/golfers/what_s covered/Third party liability.png'),
(14, 'Gold', 6000.00, 'Personal accident', 'Ksh 1,000,000', '2024-08-06 10:06:50', '2024-08-12 13:37:22', 'In case you get hurt on the course', '', '', 'golfers/what_s covered/Personal accident.png'),
(15, 'Gold', 6000.00, 'Hole-in-one', 'Ksh 75,000', '2024-08-06 10:06:50', '2024-08-12 13:37:11', '', '', '', 'golfers/what_s covered/hole in one.png');

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

--
-- Table structure for table `golfers_details`
--

CREATE TABLE `golfers_details` (
  `id` int(11) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `activity` tinyint(1) DEFAULT '0',
  `cover_type` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `autorenew` tinyint(1) DEFAULT '1',
  `package` varchar(255) NOT NULL,
  `premium` varchar(255) NOT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `payment` varchar(255) DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `golfers_details`
--

INSERT INTO `golfers_details` (`id`, `user_id`, `activity`, `cover_type`, `status`, `created_at`, `updated_at`, `expiry_date`, `autorenew`, `package`, `premium`, `filename`, `payment`) VALUES
(9, 38, 1, 'Golfers', 'Active', '2024-08-12 08:54:05', '2024-08-12 09:05:18', '2024-09-11', 0, 'Gold', '6000', 'receipt_9.pdf', 'pending'),
(10, 36, 1, 'Golfers', 'Active', '2024-08-12 10:22:47', '2024-08-12 10:22:47', '2024-09-11', 1, 'Gold', '6000', NULL, 'pending'),
(11, 40, 1, 'Golfers', 'Active', '2024-08-12 11:57:06', '2024-08-12 11:57:13', '2024-09-11', 1, 'Silver', '40', 'receipt_11.pdf', 'pending'),
(14, 42, 1, 'Golfers', 'Active', '2024-08-29 11:48:22', '2024-08-29 11:48:22', '2024-09-28', 0, 'Silver', '4000', NULL, 'pending'),
(21, 52, 1, 'Golfers', 'Active', '2024-09-12 15:06:43', '2024-09-12 15:16:15', '2024-10-12', 0, 'Bronze', '2750', 'receipt_21.pdf', 'paid');

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

--
-- Table structure for table `medical_details`
--

CREATE TABLE `medical_details` (
  `id` int(11) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `activity` tinyint(1) DEFAULT '0',
  `cover_type` varchar(255) NOT NULL,
  `additional_adults` int(11) DEFAULT NULL,
  `additional_children` int(11) DEFAULT NULL,
  `additional_adult_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `status` varchar(255) DEFAULT NULL,
  `cover_limit` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `autorenew` tinyint(1) DEFAULT '1',
  `amount` decimal(10,2) DEFAULT NULL,
  `national_id_image` varchar(255) DEFAULT NULL,
  `payment` varchar(255) DEFAULT 'pending',
  `premium` int(11) GENERATED ALWAYS AS (floor(`amount`)) STORED
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `medical_details`
--

INSERT INTO `medical_details` (`id`, `user_id`, `activity`, `cover_type`, `additional_adults`, `additional_children`, `additional_adult_details`, `status`, `cover_limit`, `created_at`, `updated_at`, `expiry_date`, `autorenew`, `amount`, `national_id_image`, `payment`) VALUES
(12, 1, 1, 'medical', 2, 0, '[{\"name\":\"erdf\",\"birthdate\":\"0004-03-23\"},{\"name\":\"3wers\",\"birthdate\":\"2024-08-20\"}]', 'Active', '500K', '2024-08-09 18:29:48', '2024-08-09 18:29:48', '2024-09-08', 0, 10000.00, NULL, 'pending'),
(13, 1, 1, 'medical', 2, 0, '[{\"name\":\"lph\",\"birthdate\":\"2222-01-31\"},{\"name\":\"jj\",\"birthdate\":\"0056-12-31\"}]', 'Active', '500K', '2024-08-09 18:42:32', '2024-08-09 18:42:32', '2024-09-08', 0, 10000.00, NULL, 'pending'),
(18, 1, 1, 'medical', 1, 1, '[{\"name\":\"ff\",\"birthdate\":\"2024-08-21\"}]', 'Active', '500K', '2024-08-09 19:24:34', '2024-08-09 19:24:34', '2024-09-08', 0, 10000.00, '[\"national_ids\\/1723242274_laravel.PNG\"]', 'pending'),
(19, 70, 1, 'medical', 2, 0, '[{\"name\":\"hh\",\"birthdate\":\"2024-08-19\"},{\"name\":\"hh\",\"birthdate\":\"2024-08-27\"}]', 'Active', '500K', '2024-08-09 19:28:47', '2024-08-09 19:28:47', '2024-09-08', 0, 10000.00, '[\"national_ids\\/1723242527_avatar.PNG\",\"national_ids\\/1723242527_php core.PNG\"]', 'pending');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1);

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

--
-- Table structure for table `mpesa_transactions`
--

CREATE TABLE `mpesa_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `MerchantRequestID` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CheckoutRequestID` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ResultCode` int(11) DEFAULT NULL,
  `ResultDesc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Amount` int(11) DEFAULT NULL,
  `MpesaReceiptNumber` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Balance` int(11) DEFAULT NULL,
  `TransactionDate` bigint(20) DEFAULT NULL,
  `PhoneNumber` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `response` text COLLATE utf8mb4_unicode_ci,
  `user_id` int(11) DEFAULT NULL,
  `account_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mpesa_transactions`
--

INSERT INTO `mpesa_transactions` (`id`, `MerchantRequestID`, `CheckoutRequestID`, `ResultCode`, `ResultDesc`, `Amount`, `MpesaReceiptNumber`, `Balance`, `TransactionDate`, `PhoneNumber`, `created_at`, `updated_at`, `response`, `user_id`, `account_no`) VALUES
(131, '2654-4b64-97ff-b827b542881d153855', 'ws_CO_17072024202021030728756236', NULL, NULL, NULL, NULL, NULL, NULL, '0728756236', '2024-07-17 14:16:50', '2024-07-17 14:16:50', NULL, NULL, NULL),
(132, '6e86-45dd-91ac-fd5d4178ab523758819', 'ws_CO_17072024210256016728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 14:59:26', '2024-07-17 14:59:26', NULL, NULL, NULL),
(133, '2654-4b64-97ff-b827b542881d154204', 'ws_CO_17072024210004677728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 15:00:07', '2024-07-17 15:00:07', NULL, NULL, NULL),
(134, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:24:46', '2024-07-17 19:24:46', NULL, NULL, NULL),
(135, '7071-4170-a0e4-8345632bad441608161', 'ws_CO_18072024012615272728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:26:16', '2024-07-17 19:26:16', NULL, NULL, NULL),
(136, '6e86-45dd-91ac-fd5d4178ab523761142', 'ws_CO_18072024013154320728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:28:23', '2024-07-17 19:28:23', NULL, NULL, NULL),
(137, '3b82-4048-94fd-4503f39b858f140257', 'ws_CO_18072024013711958728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:33:41', '2024-07-17 19:33:41', NULL, NULL, NULL),
(138, '1c5b-4ba8-815c-ac45c57a3db01611092', 'ws_CO_18072024013735445728756236', NULL, '+254728756236', 0, NULL, NULL, NULL, '+254728756236', '2024-07-17 19:34:04', '2024-09-12 11:49:07', NULL, NULL, NULL),
(139, '2654-4b64-97ff-b827b542881d156560', 'ws_CO_18072024013421151728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:34:21', '2024-07-17 19:34:21', NULL, NULL, NULL),
(140, '6e86-45dd-91ac-fd5d4178ab523761223', 'ws_CO_18072024014036080728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:37:05', '2024-07-17 19:37:05', NULL, NULL, NULL),
(141, '1c5b-4ba8-815c-ac45c57a3db01611108', 'ws_CO_18072024013731464728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:37:32', '2024-07-17 19:37:32', NULL, NULL, NULL),
(142, '6e86-45dd-91ac-fd5d4178ab523761245', 'ws_CO_18072024013800196728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:38:00', '2024-07-17 19:38:00', NULL, NULL, NULL),
(143, '7071-4170-a0e4-8345632bad441608229', 'ws_CO_18072024013823109728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:38:23', '2024-07-17 19:38:23', NULL, NULL, NULL),
(144, '6e86-45dd-91ac-fd5d4178ab523761251', 'ws_CO_18072024013853964728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:38:54', '2024-07-17 19:38:54', NULL, NULL, NULL),
(145, '7071-4170-a0e4-8345632bad441608241', 'ws_CO_18072024013909914728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:39:10', '2024-07-17 19:39:10', NULL, NULL, NULL),
(146, '2654-4b64-97ff-b827b542881d156625', 'ws_CO_18072024013919209728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:39:19', '2024-07-17 19:39:19', NULL, NULL, NULL),
(147, '3b82-4048-94fd-4503f39b858f140319', 'ws_CO_18072024014327401728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:39:56', '2024-07-17 19:39:56', NULL, NULL, NULL),
(148, '2654-4b64-97ff-b827b542881d156635', 'ws_CO_18072024014035596728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-17 19:40:36', '2024-07-17 19:40:36', NULL, NULL, NULL),
(149, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-18 03:29:10', '2024-07-18 03:29:10', NULL, NULL, NULL),
(150, '2654-4b64-97ff-b827b542881d161266', 'ws_CO_18072024112129621728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-18 05:17:58', '2024-07-18 05:17:58', NULL, NULL, NULL),
(151, '7071-4170-a0e4-8345632bad441613161', 'ws_CO_18072024113518849728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-18 05:35:20', '2024-07-18 05:35:20', NULL, NULL, NULL),
(152, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-21 12:49:11', '2024-07-21 12:49:11', NULL, NULL, NULL),
(153, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-21 12:51:51', '2024-07-21 12:51:51', NULL, NULL, NULL),
(154, '7071-4170-a0e4-8345632bad441655455', 'ws_CO_21072024190038833728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-21 12:57:07', '2024-07-21 12:57:07', NULL, NULL, NULL),
(155, '2654-4b64-97ff-b827b542881d204396', 'ws_CO_21072024194201626728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-21 13:38:30', '2024-07-21 13:38:30', NULL, NULL, NULL),
(156, '2654-4b64-97ff-b827b542881d216967', 'ws_CO_22072024200742003728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-22 14:04:10', '2024-07-22 14:04:10', NULL, NULL, NULL),
(157, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-26 12:45:47', '2024-07-26 12:45:47', NULL, NULL, NULL),
(158, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-26 12:49:20', '2024-07-26 12:49:20', NULL, NULL, NULL),
(159, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-26 12:52:10', '2024-07-26 12:52:10', NULL, NULL, NULL),
(160, '7071-4170-a0e4-8345632bad441719608', 'ws_CO_26072024185241451728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-26 12:52:43', '2024-07-26 12:52:43', NULL, NULL, NULL),
(161, '1c5b-4ba8-815c-ac45c57a3db01723857', 'ws_CO_26072024185950663728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-26 12:59:52', '2024-07-26 12:59:52', NULL, NULL, NULL),
(162, '1c5b-4ba8-815c-ac45c57a3db01723881', 'ws_CO_26072024190814708728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-26 13:04:42', '2024-07-26 13:04:42', NULL, NULL, NULL),
(163, '6e86-45dd-91ac-fd5d4178ab523882640', 'ws_CO_26072024190833553728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-26 13:05:00', '2024-07-26 13:05:00', NULL, NULL, NULL),
(164, '2654-4b64-97ff-b827b542881d278120', 'ws_CO_26072024191007346728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-26 13:06:34', '2024-07-26 13:06:34', NULL, NULL, NULL),
(165, '6e86-45dd-91ac-fd5d4178ab523896438', 'ws_CO_27072024112712803728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 05:23:39', '2024-07-27 05:23:39', NULL, NULL, NULL),
(166, '6e86-45dd-91ac-fd5d4178ab523897421', 'ws_CO_27072024123146999728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 06:31:47', '2024-07-27 06:31:47', NULL, NULL, NULL),
(167, '1c5b-4ba8-815c-ac45c57a3db01732739', 'ws_CO_27072024123943618728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 06:36:10', '2024-07-27 06:36:10', NULL, NULL, NULL),
(168, '7071-4170-a0e4-8345632bad441728546', 'ws_CO_27072024124054276728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 06:37:20', '2024-07-27 06:37:20', NULL, NULL, NULL),
(169, '2654-4b64-97ff-b827b542881d292594', 'ws_CO_27072024124254390728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 06:39:20', '2024-07-27 06:39:20', NULL, NULL, NULL),
(170, 'f1e2-4b95-a71d-b30d3cdbb7a71018955', 'ws_CO_27072024123955639728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 06:39:58', '2024-07-27 06:39:58', NULL, NULL, NULL),
(171, 'f1e2-4b95-a71d-b30d3cdbb7a71018964', 'ws_CO_27072024124058664728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 06:40:59', '2024-07-27 06:40:59', NULL, NULL, NULL),
(172, '6e86-45dd-91ac-fd5d4178ab523897570', 'ws_CO_27072024124514638728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 06:41:41', '2024-07-27 06:41:41', NULL, NULL, NULL),
(173, '6e86-45dd-91ac-fd5d4178ab523897580', 'ws_CO_27072024124312802728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 06:43:13', '2024-07-27 06:43:13', NULL, NULL, NULL),
(174, '3b82-4048-94fd-4503f39b858f277185', 'ws_CO_27072024124910230728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 06:45:38', '2024-07-27 06:45:38', NULL, NULL, NULL),
(175, 'f1e2-4b95-a71d-b30d3cdbb7a71019017', 'ws_CO_27072024124728897728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 06:47:29', '2024-07-27 06:47:29', NULL, NULL, NULL),
(176, '6e86-45dd-91ac-fd5d4178ab523897853', 'ws_CO_27072024130132464728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 07:01:34', '2024-07-27 07:01:34', NULL, NULL, NULL),
(177, '6e86-45dd-91ac-fd5d4178ab523900944', 'ws_CO_27072024164418859728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 10:40:45', '2024-07-27 10:40:45', NULL, NULL, NULL),
(178, '1c5b-4ba8-815c-ac45c57a3db01734955', 'ws_CO_27072024164208830728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-07-27 10:42:09', '2024-07-27 10:42:09', NULL, NULL, NULL),
(179, '1c5b-4ba8-815c-ac45c57a3db01880168', 'ws_CO_07082024225543529728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-07 16:55:42', '2024-08-07 16:55:42', NULL, NULL, NULL),
(180, '3b82-4048-94fd-4503f39b858f519730', 'ws_CO_07082024230400928728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-07 17:04:00', '2024-08-07 17:04:00', NULL, NULL, NULL),
(181, '2654-4b64-97ff-b827b542881d558215', 'ws_CO_09082024021747766728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-08 20:17:46', '2024-08-08 20:17:46', NULL, NULL, NULL),
(182, '2654-4b64-97ff-b827b542881d567456', 'ws_CO_09082024124412380728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-09 06:44:14', '2024-08-09 06:44:14', NULL, NULL, NULL),
(183, '6e86-45dd-91ac-fd5d4178ab524172835', 'ws_CO_09082024130217568728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-09 07:02:23', '2024-08-09 07:02:23', NULL, NULL, NULL),
(184, '7071-4170-a0e4-8345632bad441895939', 'ws_CO_09082024130551664728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-09 07:05:53', '2024-08-09 07:05:53', NULL, NULL, NULL),
(185, '6e86-45dd-91ac-fd5d4178ab524175280', 'ws_CO_09082024153311411728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-09 09:33:13', '2024-08-09 09:33:13', NULL, NULL, NULL),
(186, '7071-4170-a0e4-8345632bad441936395', 'ws_CO_12082024145352897708593463', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 08:53:50', '2024-08-12 08:53:50', NULL, NULL, NULL),
(187, '3b82-4048-94fd-4503f39b858f627426', 'ws_CO_12082024150741882708593463', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 09:07:43', '2024-08-12 09:07:43', NULL, NULL, NULL),
(188, '2654-4b64-97ff-b827b542881d642200', 'ws_CO_12082024151116347728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 09:11:17', '2024-08-12 09:11:17', NULL, NULL, NULL),
(189, '1c5b-4ba8-815c-ac45c57a3db01941262', 'ws_CO_12082024152333532708593463', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 09:23:38', '2024-08-12 09:23:38', NULL, NULL, NULL),
(190, '6e86-45dd-91ac-fd5d4178ab524248591', 'ws_CO_12082024162156145716564001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 10:21:58', '2024-08-12 10:21:58', NULL, NULL, NULL),
(191, '3b82-4048-94fd-4503f39b858f629577', 'ws_CO_12082024171932754716564001', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 11:19:35', '2024-08-12 11:19:35', NULL, NULL, NULL),
(192, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 11:56:54', '2024-08-12 11:56:54', NULL, NULL, NULL),
(193, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 12:01:48', '2024-08-12 12:01:48', NULL, NULL, NULL),
(194, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 12:49:44', '2024-08-12 12:49:44', NULL, NULL, NULL),
(195, '3b82-4048-94fd-4503f39b858f631362', 'ws_CO_12082024185916483728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 12:59:14', '2024-08-12 12:59:14', NULL, NULL, NULL),
(196, '6e86-45dd-91ac-fd5d4178ab524251521', 'ws_CO_12082024190151256728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 13:01:53', '2024-08-12 13:01:53', NULL, NULL, NULL),
(197, '3b82-4048-94fd-4503f39b858f631550', 'ws_CO_12082024191029650728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 13:10:27', '2024-08-12 13:10:27', NULL, NULL, NULL),
(198, '3b82-4048-94fd-4503f39b858f637282', 'ws_CO_13082024003126574728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-12 18:31:27', '2024-08-12 18:31:27', NULL, NULL, NULL),
(199, '2654-4b64-97ff-b827b542881d719730', 'ws_CO_16082024011735048726543456', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-15 19:17:28', '2024-08-15 19:17:28', NULL, NULL, NULL),
(200, 'f1e2-4b95-a71d-b30d3cdbb7a71438488', 'ws_CO_29082024173248471728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-29 11:32:51', '2024-08-29 11:32:51', NULL, NULL, NULL),
(201, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-29 12:41:00', '2024-08-29 12:41:00', NULL, NULL, NULL),
(202, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-29 12:43:13', '2024-08-29 12:43:13', NULL, NULL, NULL),
(203, '7071-4170-a0e4-8345632bad442149331', 'ws_CO_29082024184341599728756236', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-29 12:43:44', '2024-08-29 12:43:44', NULL, NULL, NULL),
(204, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-29 15:29:55', '2024-08-29 15:29:55', NULL, NULL, NULL),
(205, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-29 15:31:08', '2024-08-29 15:31:08', NULL, NULL, NULL),
(206, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-29 15:31:43', '2024-08-29 15:31:43', NULL, NULL, NULL),
(207, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-29 15:51:42', '2024-08-29 15:51:42', NULL, NULL, NULL),
(208, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-29 16:03:36', '2024-08-29 16:03:36', NULL, NULL, NULL),
(209, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-29 16:06:17', '2024-08-29 16:06:17', NULL, NULL, NULL),
(210, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-09-06 12:09:13', '2024-09-06 12:09:13', NULL, NULL, NULL),
(211, '9566-48c7-8be0-71e5ae4748f078308925', 'ws_CO_12092024121536029708593463', 1032, 'Request cancelled by user', NULL, NULL, NULL, NULL, NULL, '2024-09-12 15:15:42', '2024-09-12 15:15:42', NULL, NULL, NULL);

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

--
-- Table structure for table `paystack`
--

CREATE TABLE `paystack` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `cover_type` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` enum('mpesa','paystack') NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `status` enum('pending','completed','failed') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `premium` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `paystack`
--

INSERT INTO `paystack` (`id`, `user_id`, `cover_type`, `amount`, `payment_method`, `transaction_id`, `status`, `created_at`, `updated_at`, `premium`) VALUES
(1, 41, 'Medical Cover', 0.00, 'paystack', '697734119', 'pending', '2024-09-05 03:53:42', '2024-09-12 00:30:11', NULL),
(2, 41, 'Medical Cover', 0.00, 'paystack', '182049598', 'completed', '2024-09-05 04:34:40', '2024-09-12 00:30:11', NULL),
(3, 41, 'Golfers', 0.00, 'paystack', '534501199', 'completed', '2024-09-07 08:42:05', '2024-09-12 00:30:11', NULL),
(4, 41, 'Golfers', 0.00, 'paystack', '947855529', 'completed', '2024-09-07 08:57:39', '2024-09-12 00:30:11', NULL),
(5, 41, 'Golfers', 0.00, 'paystack', '647395408', 'completed', '2024-09-08 15:51:17', '2024-09-12 00:30:11', NULL),
(6, 41, 'Golfers', 0.00, 'paystack', '448742766', 'completed', '2024-09-08 15:56:09', '2024-09-12 00:30:11', NULL),
(7, 41, 'Golfers', 0.00, 'paystack', '783938255', 'completed', '2024-09-08 16:01:33', '2024-09-12 00:30:11', NULL),
(8, 41, 'Golfers', 0.00, 'paystack', '163879459', 'completed', '2024-09-09 19:51:51', '2024-09-12 00:30:11', NULL),
(9, 41, 'Golfers', 0.00, 'paystack', '782534616', 'completed', '2024-09-10 02:55:31', '2024-09-12 00:30:11', NULL),
(10, 52, 'Golfers', 0.00, 'paystack', '424670018', 'completed', '2024-09-12 15:16:02', '2024-09-12 15:24:00', NULL);

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

--
-- Table structure for table `pets_details`
--

CREATE TABLE `pets_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `activity` tinyint(1) DEFAULT '0',
  `cover_type` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `autorenew` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `pets_details`
--

INSERT INTO `pets_details` (`id`, `user_id`, `activity`, `cover_type`, `status`, `created_at`, `updated_at`, `expiry_date`, `autorenew`) VALUES
(1, 1, 0, 'pets', 'active', '2024-08-05 20:15:41', '2024-08-05 20:15:41', '2024-08-22', 1);

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

--
-- Table structure for table `renters_details`
--

CREATE TABLE `renters_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `ownership_status` varchar(255) NOT NULL,
  `cohabitants` varchar(255) DEFAULT NULL,
  `family_details` text,
  `valuables` varchar(255) DEFAULT NULL,
  `building_type` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` varchar(255) DEFAULT 'pending',
  `cover_type` varchar(255) DEFAULT NULL,
  `expiry_date` datetime DEFAULT NULL,
  `activity` tinyint(4) DEFAULT '1',
  `autorenew` tinyint(1) NOT NULL DEFAULT '1',
  `payment` varchar(255) DEFAULT 'pending',
  `premium` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `renters_details`
--

INSERT INTO `renters_details` (`id`, `user_id`, `ownership_status`, `cohabitants`, `family_details`, `valuables`, `building_type`, `created_at`, `updated_at`, `status`, `cover_type`, `expiry_date`, `activity`, `autorenew`, `payment`, `premium`) VALUES
(2, 34, 'Owning', 'Kids', NULL, 'Expensive jewelry', NULL, '2024-08-07 17:03:49', '2024-08-08 08:42:07', 'pending', NULL, '2024-08-28 23:20:01', 1, 1, 'pending', 1000),
(3, 35, 'Owning', 'Roommate', NULL, 'Expensive jewelry', NULL, '2024-08-09 07:13:02', '2024-08-11 03:44:57', 'Active', 'Renters', '2024-09-08 00:00:00', 1, 1, 'pending', 1000),
(4, 41, 'Owning', 'Partner, Kids, Pets', '\"\\\"{\\\\\\\"partner\\\\\\\":{\\\\\\\"name\\\\\\\":\\\\\\\"Susan Osoro\\\\\\\",\\\\\\\"birthdate\\\\\\\":\\\\\\\"2018-08-15\\\\\\\"},\\\\\\\"kid0\\\\\\\":{\\\\\\\"name\\\\\\\":\\\\\\\"Ssss\\\\\\\",\\\\\\\"birthdate\\\\\\\":\\\\\\\"2024-08-08\\\\\\\"},\\\\\\\"kid1\\\\\\\":{\\\\\\\"name\\\\\\\":\\\\\\\"Sssgs\\\\\\\",\\\\\\\"birthdate\\\\\\\":\\\\\\\"2024-08-06\\\\\\\"},\\\\\\\"kid2\\\\\\\":{\\\\\\\"name\\\\\\\":\\\\\\\"Gggd\\\\\\\",\\\\\\\"birthdate\\\\\\\":\\\\\\\"2024-07-09\\\\\\\"},\\\\\\\"kid3\\\\\\\":{\\\\\\\"name\\\\\\\":\\\\\\\"Yyy\\\\\\\",\\\\\\\"birthdate\\\\\\\":\\\\\\\"2024-07-10\\\\\\\"}}\\\"\"', NULL, NULL, '2024-08-12 09:23:04', '2024-09-10 17:05:15', 'Active', 'Renters', '2024-09-11 00:00:00', 1, 0, 'paid', 1000);

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

--
-- Table structure for table `residential_properties`
--

CREATE TABLE `residential_properties` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ownership_status` varchar(255) NOT NULL,
  `occupancy_status` varchar(255) NOT NULL,
  `property_value` decimal(15,2) NOT NULL,
  `rent_amount` varchar(255) DEFAULT NULL,
  `furniture_value` varchar(255) DEFAULT NULL,
  `electrical_appliances_value` varchar(255) DEFAULT NULL,
  `paintings_value` varchar(255) DEFAULT NULL,
  `kitchenware_value` varchar(255) DEFAULT NULL,
  `household_linen_value` varchar(255) DEFAULT NULL,
  `photography_equipment_value` varchar(255) DEFAULT NULL,
  `jewellery_value` varchar(255) DEFAULT NULL,
  `phones_quantity` int(11) DEFAULT NULL,
  `laptops_quantity` int(11) DEFAULT NULL,
  `tablets_quantity` int(11) DEFAULT NULL,
  `music_players_quantity` int(11) DEFAULT NULL,
  `cameras_quantity` int(11) DEFAULT NULL,
  `phone_1_model` varchar(255) DEFAULT NULL,
  `phone_1_value` varchar(255) DEFAULT NULL,
  `phone_2_model` varchar(255) DEFAULT NULL,
  `phone_2_value` varchar(255) DEFAULT NULL,
  `phone_3_model` varchar(255) DEFAULT NULL,
  `phone_3_value` varchar(255) DEFAULT NULL,
  `laptop_1_model` varchar(255) DEFAULT NULL,
  `laptop_1_value` varchar(255) DEFAULT NULL,
  `laptop_2_model` varchar(255) DEFAULT NULL,
  `laptop_2_value` varchar(255) DEFAULT NULL,
  `gardeners_count` int(11) DEFAULT NULL,
  `indoor_workers_count` int(11) DEFAULT NULL,
  `watchmen_count` int(11) DEFAULT NULL,
  `gardener_salary` varchar(255) DEFAULT NULL,
  `indoor_workers_salary` varchar(255) DEFAULT NULL,
  `watchman_salary` varchar(255) DEFAULT NULL,
  `liability_increase_choice` varchar(255) DEFAULT NULL,
  `owners_liability_amount` varchar(255) DEFAULT NULL,
  `occupiers_liability_amount` varchar(255) DEFAULT NULL,
  `additional_cover` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `cover_type` varchar(255) DEFAULT 'ResidentialProperty',
  `premium` int(11) DEFAULT '1000',
  `payment` varchar(255) DEFAULT 'pending',
  `activity` tinyint(1) DEFAULT '1',
  `amount` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `residential_properties`
--

INSERT INTO `residential_properties` (`id`, `user_id`, `ownership_status`, `occupancy_status`, `property_value`, `rent_amount`, `furniture_value`, `electrical_appliances_value`, `paintings_value`, `kitchenware_value`, `household_linen_value`, `photography_equipment_value`, `jewellery_value`, `phones_quantity`, `laptops_quantity`, `tablets_quantity`, `music_players_quantity`, `cameras_quantity`, `phone_1_model`, `phone_1_value`, `phone_2_model`, `phone_2_value`, `phone_3_model`, `phone_3_value`, `laptop_1_model`, `laptop_1_value`, `laptop_2_model`, `laptop_2_value`, `gardeners_count`, `indoor_workers_count`, `watchmen_count`, `gardener_salary`, `indoor_workers_salary`, `watchman_salary`, `liability_increase_choice`, `owners_liability_amount`, `occupiers_liability_amount`, `additional_cover`, `created_at`, `updated_at`, `cover_type`, `premium`, `payment`, `activity`, `amount`) VALUES
(1, 41, 'Owning', 'Occupying', 66.00, 'undefined', '1', '1', '1', '1', '1', '1', '1', 1, 1, 1, 1, 1, 'weewe', '1', NULL, NULL, NULL, NULL, 'ew', '11', NULL, NULL, 1, 1, 1, '22', '33', '333', 'Neither', 'undefined', 'undefined', '[\"Debris removal\"]', '2024-08-27 12:06:13', '2024-09-11 15:33:57', 'ResidentialProperty', 9, 'paid', 1, 9);

--
-- Triggers `residential_properties`
--
DELIMITER $$
CREATE TRIGGER `set_amount_based_on_premium` BEFORE INSERT ON `residential_properties` FOR EACH ROW BEGIN
    -- Use FLOOR function to set amount
    SET NEW.amount = FLOOR(NEW.premium);
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `set_amount_on_insert` BEFORE INSERT ON `residential_properties` FOR EACH ROW BEGIN
    SET NEW.amount = NEW.premium;
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `set_amount_on_update` BEFORE UPDATE ON `residential_properties` FOR EACH ROW BEGIN
    SET NEW.amount = NEW.premium;
END
$$
DELIMITER ;

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

--
-- Table structure for table `stripe_payments`
--

CREATE TABLE `stripe_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `charge_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `currency` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stripe_payments`
--

INSERT INTO `stripe_payments` (`id`, `user_id`, `charge_id`, `amount`, `currency`, `status`, `description`, `created_at`, `updated_at`) VALUES
(1, 41, 'ch_3Ptd3PCvhZjEf8LI0tjBtNPX', 0, 'usd', 'succeeded', 'Test payment dogotech', '2024-08-30 19:12:28', '2024-09-03 13:54:58');

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

--
-- Table structure for table `travel_details`
--

CREATE TABLE `travel_details` (
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `activity` tinyint(1) DEFAULT '0',
  `cover_type` varchar(255) NOT NULL,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `autorenew` tinyint(1) DEFAULT '1',
  `amount` decimal(10,2) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `adults` int(11) NOT NULL,
  `children` int(11) NOT NULL,
  `traveller_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `departure_date` date DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  `id` int(11) NOT NULL,
  `payment` varchar(255) DEFAULT 'pending',
  `premium` int(11) DEFAULT '1000'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `travel_details`
--

INSERT INTO `travel_details` (`user_id`, `activity`, `cover_type`, `status`, `created_at`, `updated_at`, `expiry_date`, `autorenew`, `amount`, `destination`, `adults`, `children`, `traveller_details`, `departure_date`, `return_date`, `id`, `payment`, `premium`) VALUES
(7, 1, 'travel', 'Active', '2024-08-09 14:35:25', '2024-08-09 14:35:25', '2024-08-13', 0, 7000.00, 'ghgg', 1, 0, '\"[{\\\"name\\\":\\\"fvghj\\\",\\\"birthdate\\\":\\\"2024-08-21\\\",\\\"passport\\\":\\\"vvl;\\\"}]\"', '0444-05-05', '2024-08-13', 1, 'pending', 1000),
(40, 1, 'travel', 'Active', '2024-08-12 13:10:28', '2024-08-12 13:10:28', '2024-09-06', 0, 7000.00, 'trfjhnk', 1, 0, '\"[{\\\"name\\\":\\\"45678\\\",\\\"birthdate\\\":\\\"4444-03-24\\\",\\\"passport\\\":\\\"3trffjhkkl\\\"}]\"', '0454-04-05', '0666-06-06', 71, 'pending', 1000);

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

--
-- Table structure for table `user_activities`
--

CREATE TABLE `user_activities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `event` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `table` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `old_data` text COLLATE utf8mb4_unicode_ci,
  `new_data` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_activities`
--

INSERT INTO `user_activities` (`id`, `event`, `table`, `user_id`, `old_data`, `new_data`, `ip_address`, `user_agent`, `created_at`) VALUES
(1, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 07:43:08'),
(2, 'update', 'mpesa_transactions', 41, '\"{\\n    \\\"id\\\": 138,\\n    \\\"MerchantRequestID\\\": \\\"1c5b-4ba8-815c-ac45c57a3db01611092\\\",\\n    \\\"CheckoutRequestID\\\": \\\"ws_CO_18072024013735445728756236\\\",\\n    \\\"ResultCode\\\": null,\\n    \\\"ResultDesc\\\": \\\"+254728756236\\\",\\n    \\\"Amount\\\": 0,\\n    \\\"MpesaReceiptNumber\\\": null,\\n    \\\"Balance\\\": null,\\n    \\\"TransactionDate\\\": null,\\n    \\\"PhoneNumber\\\": \\\"+254728756236\\\",\\n    \\\"created_at\\\": \\\"2024-07-17T22:34:04.000000Z\\\",\\n    \\\"updated_at\\\": \\\"2024-09-06T00:34:09.000000Z\\\",\\n    \\\"response\\\": null,\\n    \\\"user_id\\\": null,\\n    \\\"account_no\\\": null\\n}\"', '\"{\\n    \\\"id\\\": 138,\\n    \\\"MerchantRequestID\\\": \\\"1c5b-4ba8-815c-ac45c57a3db01611092\\\",\\n    \\\"CheckoutRequestID\\\": \\\"ws_CO_18072024013735445728756236\\\",\\n    \\\"ResultCode\\\": null,\\n    \\\"ResultDesc\\\": \\\"+254728756236\\\",\\n    \\\"Amount\\\": 0,\\n    \\\"MpesaReceiptNumber\\\": null,\\n    \\\"Balance\\\": null,\\n    \\\"TransactionDate\\\": null,\\n    \\\"PhoneNumber\\\": \\\"+254728756236\\\",\\n    \\\"created_at\\\": \\\"2024-07-17T22:34:04.000000Z\\\",\\n    \\\"updated_at\\\": \\\"2024-09-06T10:43:08.000000Z\\\",\\n    \\\"response\\\": null,\\n    \\\"user_id\\\": null,\\n    \\\"account_no\\\": null,\\n    \\\"amount\\\": 0\\n}\"', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 07:43:08'),
(3, 'Logout', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 08:11:32'),
(4, 'Login', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 08:12:06'),
(5, 'Logout', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 08:15:44'),
(6, 'Login', 'users', 48, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 08:38:01'),
(7, 'Login', 'users', 49, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 08:40:46'),
(8, 'Logout', 'users', 49, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 09:26:09'),
(9, 'Login', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 09:26:27'),
(10, 'Logout', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 10:06:29'),
(11, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-06 10:08:25'),
(12, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-07 07:57:40'),
(13, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-07 08:31:56'),
(14, 'Login', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-07 15:10:30'),
(15, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-07 16:30:21'),
(16, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-07 19:06:54'),
(17, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1 Edg/128.0.0.0', '2024-09-08 03:12:10'),
(18, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1 Edg/128.0.0.0', '2024-09-08 08:39:56'),
(19, 'Logout', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1 Edg/128.0.0.0', '2024-09-08 08:40:43'),
(20, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1 Edg/128.0.0.0', '2024-09-08 08:43:29'),
(21, 'Logout', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1 Edg/128.0.0.0', '2024-09-08 08:43:45'),
(22, 'Login', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 08:44:43'),
(23, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-08 11:06:29'),
(24, 'Logout', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 11:07:05'),
(25, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 11:07:25'),
(26, 'Logout', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1 Edg/128.0.0.0', '2024-09-08 11:46:11'),
(27, 'Login', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1 Edg/128.0.0.0', '2024-09-08 11:46:48'),
(28, 'Logout', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 12:06:17'),
(29, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 12:06:29'),
(30, 'Logout', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 12:08:48'),
(31, 'Login', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 12:09:26'),
(32, 'Logout', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 13:31:42'),
(33, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 13:32:12'),
(34, 'Logout', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 13:40:23'),
(35, 'Login', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 13:40:38'),
(36, 'Logout', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 13:41:02'),
(37, 'Login', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 13:42:06'),
(38, 'Logout', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 14:01:11'),
(39, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-08 14:39:59'),
(40, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-08 15:50:38'),
(41, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-09 03:44:24'),
(42, 'Logout', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1 Edg/128.0.0.0', '2024-09-09 05:37:23'),
(43, 'Login', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_6 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.6 Mobile/15E148 Safari/604.1 Edg/128.0.0.0', '2024-09-09 05:38:28'),
(44, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-09 10:06:30'),
(45, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-09 10:17:04'),
(46, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-09 11:42:13'),
(47, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-09 17:27:43'),
(48, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-10 02:48:10'),
(49, 'Logout', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-10 05:02:06'),
(50, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-10 05:02:45'),
(51, 'Logout', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-10 05:02:58'),
(52, 'Login', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-10 05:03:42'),
(53, 'Logout', 'users', 40, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-10 05:19:23'),
(54, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-10 05:20:02'),
(55, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-10 15:05:56'),
(56, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:129.0) Gecko/20100101 Firefox/129.0', '2024-09-10 19:10:54'),
(57, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-11 01:42:27'),
(58, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-11 07:25:45'),
(59, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0', '2024-09-11 23:59:20'),
(60, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0', '2024-09-12 00:02:19'),
(61, 'Login', 'users', 41, 'null', 'null', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-12 00:03:00'),
(62, 'Login', 'users', 50, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 10:57:23'),
(63, 'Login', 'users', 50, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0', '2024-09-12 11:02:54'),
(64, 'Login', 'users', 50, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0', '2024-09-12 11:05:36'),
(65, 'Logout', 'users', 50, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 11:49:11'),
(66, 'Login', 'users', 49, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 11:49:19'),
(67, 'Logout', 'users', 49, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 12:52:11'),
(68, 'Login', 'users', 49, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 12:52:28'),
(69, 'Login', 'users', 36, 'null', 'null', '104.28.160.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0', '2024-09-12 13:12:57'),
(70, 'Logout', 'users', 49, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 13:13:54'),
(71, 'Login', 'users', 49, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 13:26:58'),
(72, 'Logout', 'users', 49, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 13:29:57'),
(73, 'Login', 'users', 49, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 13:30:05'),
(74, 'Logout', 'users', 49, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 13:48:05'),
(75, 'Login', 'users', 51, 'null', 'null', '41.90.172.100', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0', '2024-09-12 14:43:00'),
(76, 'Login', 'users', 49, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 14:47:07'),
(77, 'Logout', 'users', 49, 'null', 'null', '102.0.13.126', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 14:47:18'),
(78, 'Login', 'users', 52, 'null', 'null', '41.90.5.93', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 14:48:58'),
(79, 'Login', 'users', 40, 'null', 'null', '104.28.160.212', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36', '2024-09-12 16:05:30'),
(80, 'Login', 'users', 40, 'null', 'null', '104.28.160.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36', '2024-09-13 00:04:06');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accident_coverages`
--
ALTER TABLE `accident_coverages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `accident_details`
--
ALTER TABLE `accident_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_subject` (`subject_type`,`subject_id`),
  ADD KEY `idx_causer` (`causer_type`,`causer_id`);

--
-- Indexes for table `claims`
--
ALTER TABLE `claims`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `claim_number` (`claim_number`),
  ADD KEY `conversation_id` (`conversation_id`);

--
-- Indexes for table `conversations`
--
ALTER TABLE `conversations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `domestics_details`
--
ALTER TABLE `domestics_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `golfers_detailofcover`
--
ALTER TABLE `golfers_detailofcover`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `golfers_details`
--
ALTER TABLE `golfers_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `medical_details`
--
ALTER TABLE `medical_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mpesa_transactions`
--
ALTER TABLE `mpesa_transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `account_no` (`account_no`);

--
-- Indexes for table `paystack`
--
ALTER TABLE `paystack`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pets_details`
--
ALTER TABLE `pets_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `renters_details`
--
ALTER TABLE `renters_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `residential_properties`
--
ALTER TABLE `residential_properties`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `stripe_payments`
--
ALTER TABLE `stripe_payments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `travel_details`
--
ALTER TABLE `travel_details`
  ADD UNIQUE KEY `id` (`id`);

--
-- Indexes for table `user_activities`
--
ALTER TABLE `user_activities`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accident_coverages`
--
ALTER TABLE `accident_coverages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `accident_details`
--
ALTER TABLE `accident_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `activity_log`
--
ALTER TABLE `activity_log`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `claims`
--
ALTER TABLE `claims`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `conversations`
--
ALTER TABLE `conversations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `golfers_detailofcover`
--
ALTER TABLE `golfers_detailofcover`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `golfers_details`
--
ALTER TABLE `golfers_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `medical_details`
--
ALTER TABLE `medical_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `mpesa_transactions`
--
ALTER TABLE `mpesa_transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=212;

--
-- AUTO_INCREMENT for table `paystack`
--
ALTER TABLE `paystack`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `renters_details`
--
ALTER TABLE `renters_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `residential_properties`
--
ALTER TABLE `residential_properties`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `stripe_payments`
--
ALTER TABLE `stripe_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `travel_details`
--
ALTER TABLE `travel_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `user_activities`
--
ALTER TABLE `user_activities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `claims`
--
ALTER TABLE `claims`
  ADD CONSTRAINT `claims_ibfk_1` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE;
COMMIT;

