-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--

INSERT INTO `model_has_permissions` VALUES (1,'App\\Models\\User',2),(1,'App\\Models\\User',3),(1,'App\\Models\\User',4),(1,'App\\Models\\User',5),(1,'App\\Models\\User',6),(1,'App\\Models\\User',7),(1,'App\\Models\\User',8),(1,'App\\Models\\User',9),(1,'App\\Models\\User',10),(1,'App\\Models\\User',11),(1,'App\\Models\\User',12),(1,'App\\Models\\User',13),(1,'App\\Models\\User',14),(1,'App\\Models\\User',15),(1,'App\\Models\\User',16),(1,'App\\Models\\User',17),(1,'App\\Models\\User',18),(1,'App\\Models\\User',19);

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(2,'App\\Models\\User',3),(2,'App\\Models\\User',4),(2,'App\\Models\\User',5),(2,'App\\Models\\User',6),(2,'App\\Models\\User',7),(2,'App\\Models\\User',8),(2,'App\\Models\\User',9),(2,'App\\Models\\User',10),(2,'App\\Models\\User',11),(2,'App\\Models\\User',12),(2,'App\\Models\\User',13),(2,'App\\Models\\User',14),(2,'App\\Models\\User',15),(2,'App\\Models\\User',16),(1,'App\\Models\\User',17),(1,'App\\Models\\User',18),(1,'App\\Models\\User',19);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '0' COMMENT '0=pending, 1=read',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1066 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` VALUES (1058,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-08-22 14:53:07','2025-08-23 19:00:36'),(1059,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-08-22 14:54:07','2025-08-23 19:00:36'),(1060,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-08-22 16:57:07','2025-08-23 19:00:36'),(1061,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-08-23 12:05:07','2025-08-23 19:00:36'),(1062,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-08-23 12:06:07','2025-08-23 19:00:36'),(1063,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-08-23 12:07:07','2025-08-23 19:00:36'),(1064,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-08-23 14:50:07','2025-08-23 19:00:36'),(1065,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-08-23 14:51:07','2025-08-23 19:00:36');

--
-- Table structure for table `out_messages`
--

CREATE TABLE `out_messages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `message_mode_id` bigint unsigned NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `filename` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `out_messages_message_mode_id_foreign` (`message_mode_id`),
  CONSTRAINT `out_messages_message_mode_id_foreign` FOREIGN KEY (`message_mode_id`) REFERENCES `message_modes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `out_messages`
--


--
-- Table structure for table `outgoing_transaction_entities`
--

CREATE TABLE `outgoing_transaction_entities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `outgoing_transaction_id` int NOT NULL,
  `company_grouped_transaction_id` int NOT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `outgoing_transaction_entities`
--

INSERT INTO `outgoing_transaction_entities` VALUES (1,1,3,210.00,'2025-08-05 19:03:36','2025-08-05 19:03:36',NULL),(2,2,4,210.00,'2025-08-06 20:02:48','2025-08-06 20:02:48',NULL),(3,3,5,1000.00,'2025-08-07 18:53:54','2025-08-07 18:53:54',NULL),(4,4,6,500.00,'2025-08-08 15:56:03','2025-08-08 15:56:03',NULL),(5,5,7,1000.00,'2025-08-09 11:05:18','2025-08-09 11:05:18',NULL),(6,6,8,500.00,'2025-08-09 13:37:14','2025-08-09 13:37:14',NULL),(7,7,9,1000.00,'2025-08-09 15:21:56','2025-08-09 15:21:56',NULL),(8,8,10,1000.00,'2025-08-10 19:09:47','2025-08-10 19:09:47',NULL),(9,9,11,1000.00,'2025-08-11 18:56:22','2025-08-11 18:56:22',NULL),(10,10,12,1000.00,'2025-08-11 19:33:37','2025-08-11 19:33:37',NULL),(11,11,13,210.00,'2025-08-14 20:20:46','2025-08-14 20:20:46',NULL),(12,12,14,1000.00,'2025-08-16 06:35:15','2025-08-16 06:35:15',NULL);

--
-- Table structure for table `outgoing_transactions`
--

CREATE TABLE `outgoing_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_router_id` int DEFAULT NULL,
  `director_share_id` int DEFAULT NULL,
  `company_customer_invocie_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `transaction_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `recipient` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `checkout_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `outgoing_transactions`
--

INSERT INTO `outgoing_transactions` VALUES (1,'GA8S5U',2,NULL,NULL,NULL,'0964383972',210.00,'123456','Money sent to 123456 on account number 123456 ','514066','2025-08-05 19:03:36','2025-08-05 19:03:36',NULL),(2,'7YL9KT',2,NULL,NULL,NULL,'0964774233',210.00,'123456','Money sent to 123456 on account number 123456 ','151783','2025-08-06 20:02:48','2025-08-06 20:02:48',NULL),(3,'K9BH8E',2,NULL,NULL,NULL,'1307377571',1000.00,'123456','Money sent to 123456 on account number 123456 ','788624','2025-08-07 18:53:54','2025-08-07 18:53:54',NULL),(4,'8EPQ27',2,NULL,NULL,NULL,'1308639764',500.00,'123456','Money sent to 123456 on account number 123456 ','762516','2025-08-08 15:56:03','2025-08-08 15:56:03',NULL),(5,'OZP260',2,NULL,NULL,NULL,'1309788641',1000.00,'123456','Money sent to 123456 on account number 123456 ','465166','2025-08-09 11:05:18','2025-08-09 11:05:18',NULL),(6,'0ME2JD',2,NULL,NULL,NULL,'1309940132',500.00,'123456','Money sent to 123456 on account number 123456 ','320618','2025-08-09 13:37:14','2025-08-09 13:37:14',NULL),(7,'JU3FQ6',2,NULL,NULL,NULL,'1310045490',1000.00,'123456','Money sent to 123456 on account number 123456 ','184295','2025-08-09 15:21:56','2025-08-09 15:21:56',NULL),(8,'R0PHAV',2,NULL,NULL,NULL,'1311713416',1000.00,'123456','Money sent to 123456 on account number 123456 ','792168','2025-08-10 19:09:47','2025-08-10 19:09:47',NULL),(9,'Y4CP6J',2,NULL,NULL,NULL,'1313139026',1000.00,'123456','Money sent to 123456 on account number 123456 ','431003','2025-08-11 18:56:22','2025-08-11 18:56:22',NULL),(10,'58RHPU',2,NULL,NULL,NULL,'1313175196',1000.00,'123456','Money sent to 123456 on account number 123456 ','021868','2025-08-11 19:33:37','2025-08-11 19:33:37',NULL),(11,'E4FVO2',2,NULL,NULL,NULL,'0967592079',210.00,'123456','Money sent to 123456 on account number 123456 ','118106','2025-08-14 20:20:46','2025-08-14 20:20:46',NULL),(12,'1CKLJO',2,NULL,NULL,NULL,'1319598138',1000.00,'123456','Money sent to 123456 on account number 123456 ','580259','2025-08-16 06:35:15','2025-08-16 06:35:15',NULL);

--
-- Table structure for table `paid_users`
--

CREATE TABLE `paid_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_router_id` bigint unsigned DEFAULT NULL,
  `company_grouped_transaction_id` int DEFAULT NULL,
  `mac_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `paid_users_company_router_id_foreign` (`company_router_id`),
  CONSTRAINT `paid_users_company_router_id_foreign` FOREIGN KEY (`company_router_id`) REFERENCES `company_routers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `paid_users`
--


--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_reset_tokens`
--


--
-- Table structure for table `paybill_transactions`
--

CREATE TABLE `paybill_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_mode_id` bigint unsigned NOT NULL,
  `phone_used` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `checkout_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `paybill_transactions_payment_mode_id_foreign` (`payment_mode_id`),
  CONSTRAINT `paybill_transactions_payment_mode_id_foreign` FOREIGN KEY (`payment_mode_id`) REFERENCES `payment_modes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `paybill_transactions`
--


--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0=inactive, 1=active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` VALUES (1,'0001','Selcom',1,'2025-08-03 19:10:06','2025-08-03 19:10:06',NULL);

--
-- Table structure for table `payment_modes`
--

CREATE TABLE `payment_modes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0=inactive, 1=active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_modes`
--

INSERT INTO `payment_modes` VALUES (1,'0001','M-PESA',1,'2025-08-03 19:10:05','2025-08-03 19:10:05',NULL),(2,'0002','M-PESA (Manually)',1,'2025-08-03 19:10:05','2025-08-03 19:10:05',NULL),(3,'0003','Cash',1,'2025-08-03 19:10:05','2025-08-03 19:10:05',NULL);

--
-- Table structure for table `payment_types`
--

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

--
-- Dumping data for table `payment_types`
--

INSERT INTO `payment_types` VALUES (1,'Fixed Amount','2025-08-03 19:10:01','2025-08-03 19:10:01',NULL),(2,'Commission Based','2025-08-03 19:10:01','2025-08-03 19:10:01',NULL);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'Administer Company',NULL,'web','2025-08-03 19:10:01','2025-08-03 19:10:01'),(2,'Staff',NULL,'web','2025-08-03 19:10:01','2025-08-03 19:10:01');

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `plan_validity_types`
--

CREATE TABLE `plan_validity_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plan_validity_types`
--

INSERT INTO `plan_validity_types` VALUES (1,'0001','Minutes','m','2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(2,'0002','Hours','h','2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(3,'0003','Days','d','2025-08-03 19:10:02','2025-08-03 19:10:02',NULL);

--
-- Table structure for table `potential_customers`
--

CREATE TABLE `potential_customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int DEFAULT NULL,
  `names` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `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 `potential_customers`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Administrator','web','2025-08-03 19:10:01','2025-08-03 19:10:01'),(2,'Client','web','2025-08-03 19:10:01','2025-08-03 19:10:01'),(3,'Referrer','web','2025-08-03 19:10:01','2025-08-03 19:10:01');

--
-- Table structure for table `service_plans`
--

CREATE TABLE `service_plans` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0=inactive, 1=active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service_plans`
--

INSERT INTO `service_plans` VALUES (1,'0001','Hotspot Plans',1,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(2,'0002','PPPoE Plans',1,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(3,'0003','Static Plans',1,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL);

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

CREATE TABLE `sessions` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext 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 ('0Y8lS2SrjQCR76RECPZkS0NtRX6TBcf51VFNjofR',NULL,'185.177.72.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoibGdLWUtFQjhUQ0RoNDN6aWxJQzNXcVlLV3lvVmdtQkptVko3YnpyUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZS8/cGhwaW5mbz0xIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1755969745),('1FINOZ4FagttOXNLdiEdGDbR28tgjWKJPUhLXaOB',15,'41.59.21.139','Mozilla/5.0 (Linux; U; Android 13; en-us; Infinix X6528 Build/TP1A.220624.014) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.6367.123 Mobile Safari/537.36 PHX/19.2','[encoded data, 68344 characters]',1756016591),('1hw8UY4WU1pS0UyFaESwarafMtlu2qywBIxnLJkN',NULL,'185.177.72.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTFBFem9QeFNGaWt3QmR1VElid1FLajhPRndXSUlFdGV0TTNsenQ3VSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDM6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZS8/eGRlYnVnaW5mbz0iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1755969746),('1YK54DOt8RYDnzTivpYypjQ8TQIZcD3XEBJq4WVo',NULL,'188.132.197.75','libredtail-http','YTozOntzOjY6Il90b2tlbiI7czo0MDoidExuUzRuQUtqejNTb2dGRFI3alN0cHVsZ0U3dFg5ZkFFdTlSVHAybCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTUzOiJodHRwOi8vMTYxLjk3LjE3NC4yMC9wdWJsaWMvaW5kZXgucGhwP2Z1bmN0aW9uPWNhbGxfdXNlcl9mdW5jX2FycmF5JnM9JTJGaW5kZXglMkYlNUN0aGluayU1Q2FwcCUyRmludm9rZWZ1bmN0aW9uJnZhcnMlNUIwJTVEPW1kNSZ2YXJzJTVCMSU1RCU1QjAlNUQ9SGVsbG8iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1756007619),('23gIbC7PhJril5oMRpe5JySh6HsinSeNlEXOkmkc',NULL,'20.171.207.219','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNFlCWW1PYkh0Y0YwZEJHOUF5WUtqTzV0bWlDMlNMd2VjdXRuZHFiRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDg6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS90ZXJtcy1hbmQtY29uZGl0aW9ucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1755981696),('3MTevm16ziQZbKatCQQSNtSIap8sOSiyEMVD62F6',NULL,'54.36.148.250','Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUW0zV2JES3VLaEFHREM3aUtiNkFjczREdFFGMlp4cWpXT1hHdUNreSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1756020674),('5bjp8kMU1fSC02rgzciKtP1z7nzqQv5qTW5RAYLI',NULL,'41.59.21.139','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 OPR/120.0.0.0 (Edition Campaign 34)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRHZOU3FhTnc3MExFZThMY3VkZVNpV3JGRFEwZkcyczdoSnZCV000TCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756027522),('5WidckkUBb7xOnUmff1Konr1capAFfwwTyDGyNP7',NULL,'43.154.140.188','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoicXB6U3pXZ21yaFhrVVp5UVQxS05iTHFVR1pGYWV0U1FUWVRsQXdpaiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly9vcGlmZXgub3BpZmV4dGVjaG5vbG9neS5jb20vcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1756024187),('AWlAT8cjLFb25xWMoRvgmE1nNGkdY1HNzfbamVds',NULL,'185.177.72.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoibW9uSk9Ic2R2aXRFalBXdlcxT0lVWExPaVhweEZUbmNkSEg2Sk9lbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZS9pbmRleC5waHAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1755969742),('bv6vzoJ3kKVe7KSoqTwcZ6JEgSndlQRZy1P1vAM1',15,'41.59.21.139','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0','[encoded data, 68300 characters]',1755972084),('CA619SvUMxcafIZAiDTWNUODRmyCozzC5KpammOF',NULL,'185.177.72.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaDhhOVJlalExSmplQ1hlRTdPNDBTYlRya0M5RHkwMGQwN1poamNqcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZS8/cHA9ZW52Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1755969772),('dz8c3Yp77cfV8rLzUrrSqnVqfpOfJ7trOjAV0gVj',NULL,'206.168.34.34','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZENZVlZGajFOc2Y0Q0hHc1VHZWRsdnhsNXlIcHExazZPcXNOcjJLSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xNjEuOTcuMTc0LjIwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1755988748),('fE2dY7nM9KL5vbp0Un2YwP4j7HCMhRRn9YxcAGS8',NULL,'41.59.21.139','Mozilla/5.0 (Linux; Android 10; itel L5007 Build/QP1A.190711.020; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/136.0.7103.61 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiY0gyQ245dG5MbmZSMVlCSjgxcGpUempBbkd2V3M2cE5qYkIxdklNRyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1755977853),('g6SYxyfuyWEaUrPf9X0gxsYqsmWAm0ZbosH1Cozf',NULL,'105.160.12.114','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaEF0aWdCU0NFMWhmSDlVQUNkU0lDT1lIUHl6SHVCbWpaT0YwNENBUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1755965156),('HhjHUbnAZQYxF1VITguz83qK9h25OYPbiZL5SEV5',NULL,'185.177.72.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTXpYV3BlZnhRUFg1V3pVQzFvbndOTzc0M1ZuaWRpakNGUEEydzJsUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDM6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbj9wcD1lbnYiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1755969772),('IGS0QiBNGvBhRB6m0b3cYdJkD37hHEMmyYC1cbGH',NULL,'185.177.72.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWUJhQ1d5T25wdmh6TlhnUncwN2RXMVptTFNSR1hnUVp5ek56dks4VyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZS8/cT1pbmZvIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1755969746),('Iv9pcGWpNCmCJwz72vDmK2YIaJG9tFc28ZtLOQb6',NULL,'93.123.109.225','Mozilla/5.0 (Linux; Android 9; SM-G975F) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.89 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZEFMN3RUclJXeG0wdXBta3VIbjdEM1JYbExiS3FlbjhnS2lxSklYayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756023817),('J2lXyYrFMsKae5u3I65RpXlxTv1Bryh2vhLCfcor',NULL,'43.133.187.11','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSnAzMExBUjBNQk1BTHkxUmE2czBmRldDaFlkdGM1eEs0VGZXOENkdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1756009884),('jePBOmQu8DL92KCLGmZSeXn3zf2rtYYBdSGKPdLt',NULL,'43.153.76.247','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoibGpEQ2I3TUJTd2pUNzJNdjFOZmdJcktBYjRKNWU2emg2Znp5Wm5RRCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1755969340),('kXYXndqLQGV0EQQWXO0koKkGiDTN6MNgbuCck55J',NULL,'52.16.60.102','Java/17.0.3','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOGpocVNxOGp6TjFpa2t2OFlWZ0pqcDNuR253cXdSbVlkWEJPZGhmZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xNjEuOTcuMTc0LjIwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1755977601),('m59HlOHz0VktQcNfuDdxzflBKV6vH0WCQrjzj8Qm',NULL,'31.13.103.4','facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZlF4cmFkcFVvUk0yNVhVRkdQYkhpS29abDBJWFNPMlhYWVF1eTNUaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756009931),('mxOVBvKkbuYbg1gcas6vhh7aNNPAAptGmS0SwHne',NULL,'17.241.219.217','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNUNsSWN2S0NxQkJTajJuWVEzQmNuTG9DazFWa0NqUG5tS0pqZzBhaiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL2Fib3V0LXVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1755996916),('noupw5AG6kpOXaouVHwLEgxSMw39IBWAvsmdf3Bn',NULL,'57.129.136.58','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:115.0) Gecko/20100101 Chrome/115.0.0.0 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoieVFMRkpIWUdOd1JFTzBSWVd3WXpFS3hIanFHaTFjMUlrQkNGUTU1MSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1755980525),('nPRf0gnW0NBIyGZOtgRp31OjAQE0YKM8y7QNegPw',NULL,'43.155.27.244','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOGRRWHdoblB3aVpMNlVjMmNHQTNjcWpCRTNDcUFCZXA5MGtKZGRpNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xNjEuOTcuMTc0LjIwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1755988703),('pcraNIhrPHbvJ5WE37tbsHJblpJdxgfdPzDHK6AD',NULL,'185.177.72.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoid0xXM3ZNWHdnMFE1enRWcDEzUDVtcDg1Z3AzRGNTMmpZQTF6YjB1eSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZS8/cHA9ZW52Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1755969772),('PgsG4JVZ77gQmWxX509DHrbdvFZJ98mqs48eklQ9',NULL,'185.177.72.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTnZuOUVhZXlpT3VRd1l4ekwxYW5IOXh2OXVFNlpOSjZXUEtrbnlBaiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1755969774),('QGh2AsFzOGwmP6Q4rI9f5QiiAW0hNryydAEt53LJ',NULL,'57.129.136.58','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:115.0) Gecko/20100101 Chrome/115.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWGFZcXpCTEY5OUdpODVGblVReVlPeTJJNVhBMk1JUXpNRnNCazV6biI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1755980767),('R8l1uOIT83MYRYbkiJgJsw04CxGhSZo9nMEFpgNT',NULL,'54.36.148.88','Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoib0dvZVhSdHoxSWNpRURzQlV3Q0UxSUd1NTREZDRrcGJYRUNmcE5XWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL2NvbnRhY3QtdXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1755972952),('RNSvauT7kAthWVJlqpc6Ty8LSwBziuBNHdpS2Bhu',NULL,'43.157.180.116','Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSEwyWXBEaVZ2dFZpa200TXpUV1JxRHRPTkVPZkhoVk1FWEhld1hUMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xNjEuOTcuMTc0LjIwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1755991120),('SpJuXV839FPLfIci0XvazgopfzogQpkByL3gkcXE',NULL,'54.209.165.177','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUGRMdTZRb0laMEswcXR5WEdOWDZmdW1mcHQyY280bXRrdHVzQUY5ciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756012714),('sRknkr9WSOXndp26xfsun6Q4ffz5G7MQYAZYHNoD',NULL,'54.36.148.170','Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUGJtUVBVcDFNVzZLZDA2TVh5dXd5TjgwZ1h4V2IxRmtNeVczQjZ3eiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756014256),('TST26wliepI0WtXQAk9EhQzzkRJjUStXk75STou8',NULL,'41.139.220.91','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36 ABB/3.7.3','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZGNhQ3JKMjVxd1h1OTJyQklRSmVXWGJYVGFkYnRERURHOWlMbmlsNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzg6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9jb250YWN0LXVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1756010014),('U3jbnogh51xIIAoRPjpGEdoH9hlDJL6IOjQgUsLB',NULL,'103.136.220.231','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.5938.60 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoianFNenI5OW04UzdnVE91WXM4SWNwNktZalg4NDRVNjZ2VkVRaXpvOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1755998297),('Uu0HGTJVM2tMDV1LxK3xYqExQjDi9brt355obYX6',NULL,'54.36.148.47','Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOUlyYzFXOHVjbGVHRWxyNDBUejFWWWdzcjFleEx6T3ROcUxTaG95TyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL2Fib3V0LXVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1755994955),('x2RFYMSKa1F93fJkHLEJ6DeTHkGBv5UZzhHalDGq',NULL,'20.171.207.222','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)','YTozOntzOjY6Il90b2tlbiI7czo0MDoieENvUW5heUJjVU5nMGNaTWYwWUFYRVBRcWhSYkk1ZW9LZGFCY283ZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTI6Imh0dHBzOi8vd3d3Lmhlcml0YWdlZ3JvdXAuY28ua2UvdGVybXMtYW5kLWNvbmRpdGlvbnMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1755999904),('zHjsDywvVTK9cioDhH1CkxKZE5iDY2J29bOOgu6s',15,'41.59.21.139','Mozilla/5.0 (Linux; U; Android 13; en-us; Infinix X6528 Build/TP1A.220624.014) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.6367.123 Mobile Safari/537.36 PHX/19.2','[encoded data, 68320 characters]',1755977382);

--
-- Table structure for table `sms_provider_requirements`
--

CREATE TABLE `sms_provider_requirements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sms_provider_id` bigint unsigned NOT NULL,
  `sms_requirement_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sms_provider_requirements_sms_provider_id_foreign` (`sms_provider_id`),
  KEY `sms_provider_requirements_sms_requirement_id_foreign` (`sms_requirement_id`),
  CONSTRAINT `sms_provider_requirements_sms_provider_id_foreign` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sms_provider_requirements_sms_requirement_id_foreign` FOREIGN KEY (`sms_requirement_id`) REFERENCES `sms_requirements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_provider_requirements`
--

INSERT INTO `sms_provider_requirements` VALUES (1,1,1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(2,1,3,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(3,1,4,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(4,2,1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(5,2,5,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(6,2,2,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(7,4,1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(8,4,2,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL);

--
-- Table structure for table `sms_providers`
--

CREATE TABLE `sms_providers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0=inactive, 1=active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_providers`
--

INSERT INTO `sms_providers` VALUES (1,'1','Hostpinnacle',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(2,'2','Ujumbe SMS',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(3,'3','Africas Talking',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(4,'4','Talk Sasa',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL);

--
-- Table structure for table `sms_requirements`
--

CREATE TABLE `sms_requirements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `input_field_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_requirements`
--

INSERT INTO `sms_requirements` VALUES (1,'Sender ID','sender_id','2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(2,'API Key','api_key','2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(3,'Sms User ID','sms_user_id','2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(4,'Password','password','2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(5,'Email','email','2025-08-03 19:10:04','2025-08-03 19:10:04',NULL);

--
-- Table structure for table `sms_template_types`
--

CREATE TABLE `sms_template_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_template_types`
--

INSERT INTO `sms_template_types` VALUES (1,'Upcoming plan/package expiry','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(2,'Invoice notification','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(3,'Payment confirmation','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(4,'Payment reminder','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(5,'Overdue payment warning','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(6,'Service disconnection notice','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(7,'Service restoration notification','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(8,'New subscription confirmation','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(9,'Plan upgrade or downgrade confirmation','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(10,'Service maintenance notification','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(11,'Service outage alert','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(12,'Hotspot Plan Purchase','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL);

--
-- Table structure for table `temporary_grouped_transactions`
--

CREATE TABLE `temporary_grouped_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `originator_conversation_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `grouped_transaction_id` int 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 `temporary_grouped_transactions`
--


--
-- Table structure for table `temporary_transaction_checks`
--

CREATE TABLE `temporary_transaction_checks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_service_plan_id` int DEFAULT NULL,
  `company_id` int DEFAULT NULL,
  `company_router_id` int DEFAULT NULL,
  `company_router_invoice_id` int DEFAULT NULL,
  `company_customer_id` int DEFAULT NULL,
  `mac_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checkout_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `temporary_transaction_checks`
--

INSERT INTO `temporary_transaction_checks` VALUES (1,6,NULL,NULL,NULL,NULL,'F6:2F:D5:3F:00:CE','046507',210.00,'2025-08-06 04:40:29','2025-08-06 04:40:29'),(2,6,NULL,NULL,NULL,NULL,'E8:B1:FC:9B:E3:7B','998553',210.00,'2025-08-06 18:32:33','2025-08-06 18:32:33'),(3,6,NULL,NULL,NULL,NULL,'16:54:CC:BC:13:7C','070146',210.00,'2025-08-06 19:59:25','2025-08-06 19:59:25'),(5,8,NULL,NULL,NULL,NULL,'C2:BC:EF:F6:65:29','918352',500.00,'2025-08-07 14:29:21','2025-08-07 14:29:21'),(6,9,NULL,NULL,NULL,NULL,'D4:67:D3:E3:17:BD','608888',1000.00,'2025-08-07 17:08:13','2025-08-07 17:08:13'),(7,9,NULL,NULL,NULL,NULL,'D4:67:D3:E3:17:BD','163593',1000.00,'2025-08-07 18:00:59','2025-08-07 18:00:59'),(9,8,NULL,NULL,NULL,NULL,'5E:32:CC:C1:11:35','995680',500.00,'2025-08-08 08:09:49','2025-08-08 08:09:49'),(11,9,NULL,NULL,NULL,NULL,'86:65:3C:6B:E1:84','586454',1000.00,'2025-08-08 21:53:41','2025-08-08 21:53:41'),(15,6,NULL,NULL,NULL,NULL,'72:4C:D3:24:6F:37','684402',210.00,'2025-08-10 11:52:17','2025-08-10 11:52:17'),(18,9,NULL,NULL,NULL,NULL,'86:65:3C:6B:E1:84','880636',1000.00,'2025-08-11 19:00:03','2025-08-11 19:00:03'),(20,9,NULL,NULL,NULL,NULL,'BE:9E:B9:04:25:17','410059',1000.00,'2025-08-13 19:39:06','2025-08-13 19:39:06'),(21,9,NULL,NULL,NULL,NULL,'BE:9E:B9:04:25:17','013420',1000.00,'2025-08-13 19:40:12','2025-08-13 19:40:12'),(23,7,NULL,NULL,NULL,NULL,'3A:C9:5E:87:3C:AA','964274',300.00,'2025-08-15 12:27:45','2025-08-15 12:27:45'),(25,8,NULL,NULL,NULL,NULL,'72:82:9F:D3:BA:72','228543',500.00,'2025-08-17 06:30:45','2025-08-17 06:30:45'),(26,9,NULL,NULL,NULL,NULL,'72:82:9F:D3:BA:72','040733',1000.00,'2025-08-17 06:32:48','2025-08-17 06:32:48'),(27,9,NULL,NULL,NULL,NULL,'72:82:9F:D3:BA:72','373924',1000.00,'2025-08-17 06:41:33','2025-08-17 06:41:33'),(28,9,NULL,NULL,NULL,NULL,'EA:58:A4:7A:3F:40','505401',1000.00,'2025-08-17 15:42:00','2025-08-17 15:42:00'),(29,6,NULL,NULL,NULL,NULL,'22:7F:8F:03:CE:EB','740885',210.00,'2025-08-17 15:42:42','2025-08-17 15:42:42'),(30,9,NULL,NULL,NULL,NULL,'EA:58:A4:7A:3F:40','713354',1000.00,'2025-08-17 15:43:07','2025-08-17 15:43:07'),(31,9,NULL,NULL,NULL,NULL,'86:65:3C:6B:E1:84','706706',1000.00,'2025-08-17 21:15:14','2025-08-17 21:15:14'),(32,9,NULL,NULL,NULL,NULL,'86:65:3C:6B:E1:84','933255',1000.00,'2025-08-17 21:16:49','2025-08-17 21:16:49'),(33,9,NULL,NULL,NULL,NULL,'BA:71:D2:D8:D2:D0','092509',1000.00,'2025-08-18 21:56:30','2025-08-18 21:56:30'),(34,8,NULL,NULL,NULL,NULL,'30:FC:EB:7A:0C:90','201884',500.00,'2025-08-19 09:08:32','2025-08-19 09:08:32'),(35,8,NULL,NULL,NULL,NULL,'20:2B:20:82:46:81','186315',500.00,'2025-08-19 09:33:30','2025-08-19 09:33:30'),(36,9,NULL,NULL,NULL,NULL,'EA:58:A4:7A:3F:40','416356',1000.00,'2025-08-19 12:57:38','2025-08-19 12:57:38'),(37,6,NULL,NULL,NULL,NULL,'CE:27:A9:53:A7:97','978587',210.00,'2025-08-19 15:40:10','2025-08-19 15:40:10'),(38,9,NULL,NULL,NULL,NULL,'72:82:9F:D3:BA:72','422101',1000.00,'2025-08-19 17:08:18','2025-08-19 17:08:18'),(39,24,NULL,NULL,NULL,NULL,'5A:90:84:47:BA:75','406449',2500.00,'2025-08-19 17:36:19','2025-08-19 17:36:19'),(40,24,NULL,NULL,NULL,NULL,'62:06:D0:8C:47:36','631740',2500.00,'2025-08-19 17:44:11','2025-08-19 17:44:11'),(41,24,NULL,NULL,NULL,NULL,'62:06:D0:8C:47:36','151565',2500.00,'2025-08-19 17:47:47','2025-08-19 17:47:47'),(42,7,NULL,NULL,NULL,NULL,'FE:96:EF:57:F0:70','545418',300.00,'2025-08-19 17:53:30','2025-08-19 17:53:30'),(43,6,NULL,NULL,NULL,NULL,'CE:74:22:E0:34:EE','641494',210.00,'2025-08-19 17:57:06','2025-08-19 17:57:06'),(44,9,NULL,NULL,NULL,NULL,'F6:15:EE:D6:C1:32','400618',1000.00,'2025-08-19 18:41:59','2025-08-19 18:41:59'),(45,7,NULL,NULL,NULL,NULL,'FE:96:EF:57:F0:70','571353',300.00,'2025-08-19 18:46:25','2025-08-19 18:46:25'),(46,23,NULL,NULL,NULL,NULL,'BE:1F:0E:C7:2C:2E','566876',15000.00,'2025-08-19 19:33:28','2025-08-19 19:33:28'),(47,23,NULL,NULL,NULL,NULL,'BE:1F:0E:C7:2C:2E','135696',15000.00,'2025-08-19 19:35:14','2025-08-19 19:35:14'),(48,23,NULL,NULL,NULL,NULL,'BE:1F:0E:C7:2C:2E','580077',15000.00,'2025-08-19 19:37:53','2025-08-19 19:37:53'),(49,9,NULL,NULL,NULL,NULL,'E6:12:A3:41:F4:AD','583196',1000.00,'2025-08-19 20:09:08','2025-08-19 20:09:08'),(50,9,NULL,NULL,NULL,NULL,'E6:12:A3:41:F4:AD','665552',1000.00,'2025-08-19 20:15:22','2025-08-19 20:15:22'),(51,6,NULL,NULL,NULL,NULL,'5A:18:AE:46:F0:9A','606383',210.00,'2025-08-19 20:31:12','2025-08-19 20:31:12'),(52,9,NULL,NULL,NULL,NULL,'E6:12:A3:41:F4:AD','951620',1000.00,'2025-08-19 20:40:37','2025-08-19 20:40:37'),(53,6,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','666402',210.00,'2025-08-20 05:38:33','2025-08-20 05:38:33'),(54,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','798382',500.00,'2025-08-20 10:00:48','2025-08-20 10:00:48'),(55,9,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','340967',1000.00,'2025-08-20 12:57:26','2025-08-20 12:57:26'),(56,9,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','802864',1000.00,'2025-08-20 12:58:38','2025-08-20 12:58:38'),(57,8,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','092136',500.00,'2025-08-20 12:59:40','2025-08-20 12:59:40'),(58,9,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','000439',1000.00,'2025-08-20 13:00:47','2025-08-20 13:00:47'),(59,9,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','796661',1000.00,'2025-08-20 13:02:24','2025-08-20 13:02:24'),(60,8,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','817977',500.00,'2025-08-20 13:09:17','2025-08-20 13:09:17'),(61,8,NULL,NULL,NULL,NULL,'F2:50:95:0B:4B:27','172820',500.00,'2025-08-20 13:09:33','2025-08-20 13:09:33'),(62,8,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','346349',500.00,'2025-08-20 13:11:22','2025-08-20 13:11:22'),(63,8,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','174631',500.00,'2025-08-20 13:27:28','2025-08-20 13:27:28'),(64,9,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','758317',1000.00,'2025-08-20 13:30:07','2025-08-20 13:30:07'),(65,9,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','995988',1000.00,'2025-08-20 18:05:52','2025-08-20 18:05:52'),(66,9,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','658164',1000.00,'2025-08-20 18:10:03','2025-08-20 18:10:03'),(67,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','072790',500.00,'2025-08-20 18:25:35','2025-08-20 18:25:35'),(68,7,NULL,NULL,NULL,NULL,'CC:C0:79:8D:5E:35','198983',300.00,'2025-08-20 18:59:07','2025-08-20 18:59:07'),(69,9,NULL,NULL,NULL,NULL,'30:FC:EB:7A:0C:90','693194',1000.00,'2025-08-20 19:15:34','2025-08-20 19:15:34'),(70,9,NULL,NULL,NULL,NULL,'12:9B:F6:38:BA:E8','633183',1000.00,'2025-08-20 19:42:05','2025-08-20 19:42:05'),(71,9,NULL,NULL,NULL,NULL,'52:F8:FB:F8:E8:C6','478091',1000.00,'2025-08-20 19:46:17','2025-08-20 19:46:17'),(72,9,NULL,NULL,NULL,NULL,'12:9B:F6:38:BA:E8','801707',1000.00,'2025-08-20 19:51:26','2025-08-20 19:51:26'),(73,8,NULL,NULL,NULL,NULL,'CC:C0:79:8D:5E:35','516750',500.00,'2025-08-20 19:57:34','2025-08-20 19:57:34'),(74,7,NULL,NULL,NULL,NULL,'CC:C0:79:8D:5E:35','267320',300.00,'2025-08-20 20:00:12','2025-08-20 20:00:12'),(75,6,NULL,NULL,NULL,NULL,'1A:A9:97:24:0B:BF','994514',210.00,'2025-08-20 20:37:40','2025-08-20 20:37:40'),(76,6,NULL,NULL,NULL,NULL,'CA:CD:25:B3:8E:2B','069648',210.00,'2025-08-20 20:38:38','2025-08-20 20:38:38'),(77,9,NULL,NULL,NULL,NULL,'BE:FD:23:A1:58:ED','202311',1000.00,'2025-08-21 06:29:51','2025-08-21 06:29:51'),(78,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','030361',500.00,'2025-08-21 08:21:59','2025-08-21 08:21:59'),(79,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','243147',500.00,'2025-08-21 08:23:42','2025-08-21 08:23:42'),(80,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','163183',500.00,'2025-08-21 08:28:42','2025-08-21 08:28:42'),(81,7,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','932383',300.00,'2025-08-21 08:29:47','2025-08-21 08:29:47'),(82,8,NULL,NULL,NULL,NULL,'F2:14:5F:EE:3E:9B','472785',500.00,'2025-08-21 08:49:16','2025-08-21 08:49:16'),(83,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','098143',500.00,'2025-08-21 14:46:55','2025-08-21 14:46:55'),(84,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','551030',500.00,'2025-08-21 14:55:58','2025-08-21 14:55:58'),(85,8,NULL,NULL,NULL,NULL,'D4:67:D3:E3:17:BD','837890',500.00,'2025-08-21 16:13:23','2025-08-21 16:13:23'),(86,9,NULL,NULL,NULL,NULL,'D4:67:D3:E3:17:BD','866912',1000.00,'2025-08-21 16:16:11','2025-08-21 16:16:11'),(87,6,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','219563',210.00,'2025-08-21 16:46:49','2025-08-21 16:46:49'),(88,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','758165',500.00,'2025-08-21 16:48:13','2025-08-21 16:48:13'),(89,8,NULL,NULL,NULL,NULL,'B2:24:D4:B2:3D:2D','359336',500.00,'2025-08-21 16:57:02','2025-08-21 16:57:02'),(90,8,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','378712',500.00,'2025-08-21 16:58:13','2025-08-21 16:58:13'),(91,8,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','410917',500.00,'2025-08-21 16:59:08','2025-08-21 16:59:08'),(92,8,NULL,NULL,NULL,NULL,'B2:24:D4:B2:3D:2D','187762',500.00,'2025-08-21 16:59:53','2025-08-21 16:59:53'),(93,26,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','653469',7000.00,'2025-08-21 17:01:26','2025-08-21 17:01:26'),(94,8,NULL,NULL,NULL,NULL,'B2:24:D4:B2:3D:2D','982679',500.00,'2025-08-21 17:01:31','2025-08-21 17:01:31'),(95,8,NULL,NULL,NULL,NULL,'B2:24:D4:B2:3D:2D','513114',500.00,'2025-08-21 17:04:43','2025-08-21 17:04:43'),(96,8,NULL,NULL,NULL,NULL,'62:98:4F:47:C4:C9','015445',500.00,'2025-08-21 17:24:37','2025-08-21 17:24:37'),(97,8,NULL,NULL,NULL,NULL,'62:98:4F:47:C4:C9','434649',500.00,'2025-08-21 17:28:05','2025-08-21 17:28:05'),(98,8,NULL,NULL,NULL,NULL,'62:98:4F:47:C4:C9','465660',500.00,'2025-08-21 17:30:46','2025-08-21 17:30:46'),(99,8,NULL,NULL,NULL,NULL,'62:98:4F:47:C4:C9','429603',500.00,'2025-08-21 17:34:31','2025-08-21 17:34:31'),(100,8,NULL,NULL,NULL,NULL,'BE:B0:28:C2:D3:11','124047',500.00,'2025-08-21 17:40:48','2025-08-21 17:40:48'),(101,6,NULL,NULL,NULL,NULL,'06:9C:BA:9D:B1:E8','237769',210.00,'2025-08-21 18:03:42','2025-08-21 18:03:42'),(102,8,NULL,NULL,NULL,NULL,'CC:C0:79:8D:5E:35','949862',500.00,'2025-08-21 18:54:25','2025-08-21 18:54:25'),(103,26,NULL,NULL,NULL,NULL,'30:FC:EB:7A:0C:90','162886',7000.00,'2025-08-21 19:27:52','2025-08-21 19:27:52'),(104,8,NULL,NULL,NULL,NULL,'D6:12:9E:9D:91:0E','746427',500.00,'2025-08-21 19:37:38','2025-08-21 19:37:38'),(105,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','128942',500.00,'2025-08-21 19:49:23','2025-08-21 19:49:23'),(106,9,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','230315',1000.00,'2025-08-21 20:22:01','2025-08-21 20:22:01'),(107,8,NULL,NULL,NULL,NULL,'A2:E1:BA:8D:59:00','363486',500.00,'2025-08-22 06:45:38','2025-08-22 06:45:38'),(108,7,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','500624',300.00,'2025-08-22 07:24:39','2025-08-22 07:24:39'),(109,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','414063',500.00,'2025-08-22 10:13:26','2025-08-22 10:13:26'),(110,6,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','973417',210.00,'2025-08-22 17:18:26','2025-08-22 17:18:26'),(111,9,NULL,NULL,NULL,NULL,'FE:96:EF:57:F0:70','564350',1000.00,'2025-08-22 17:26:11','2025-08-22 17:26:11'),(112,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','091414',500.00,'2025-08-22 18:59:54','2025-08-22 18:59:54'),(113,8,NULL,NULL,NULL,NULL,'F2:65:ED:BF:19:CD','246425',500.00,'2025-08-22 20:55:57','2025-08-22 20:55:57'),(114,8,NULL,NULL,NULL,NULL,'CC:C0:79:8D:5E:35','369937',500.00,'2025-08-22 21:30:02','2025-08-22 21:30:02'),(115,9,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','327234',1000.00,'2025-08-22 22:41:17','2025-08-22 22:41:17'),(116,7,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','836406',300.00,'2025-08-22 22:46:31','2025-08-22 22:46:31'),(117,6,NULL,NULL,NULL,NULL,'60:70:72:60:6A:C2','388319',210.00,'2025-08-22 23:20:13','2025-08-22 23:20:13'),(118,9,NULL,NULL,NULL,NULL,'4E:ED:DD:40:F3:A1','996468',1000.00,'2025-08-23 09:25:46','2025-08-23 09:25:46'),(119,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','540841',2500.00,'2025-08-23 12:30:39','2025-08-23 12:30:39'),(120,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','885814',2500.00,'2025-08-23 12:31:33','2025-08-23 12:31:33'),(121,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','282302',2500.00,'2025-08-23 12:31:36','2025-08-23 12:31:36'),(122,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','259503',2500.00,'2025-08-23 12:31:43','2025-08-23 12:31:43'),(123,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','522009',2500.00,'2025-08-23 12:32:26','2025-08-23 12:32:26'),(124,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','767316',2500.00,'2025-08-23 12:32:29','2025-08-23 12:32:29'),(125,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','556775',2500.00,'2025-08-23 12:32:33','2025-08-23 12:32:33'),(126,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','500414',2500.00,'2025-08-23 12:34:33','2025-08-23 12:34:33'),(127,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','109184',2500.00,'2025-08-23 12:34:36','2025-08-23 12:34:36'),(128,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','526822',2500.00,'2025-08-23 12:34:39','2025-08-23 12:34:39'),(129,9,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','842173',1000.00,'2025-08-23 12:35:16','2025-08-23 12:35:16'),(130,6,NULL,NULL,NULL,NULL,'D0:2A:AA:90:40:ED','280551',210.00,'2025-08-23 14:26:13','2025-08-23 14:26:13'),(131,6,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','718557',210.00,'2025-08-23 16:39:08','2025-08-23 16:39:08'),(132,8,NULL,NULL,NULL,NULL,'F2:65:ED:BF:19:CD','924733',500.00,'2025-08-23 20:59:29','2025-08-23 20:59:29'),(133,7,NULL,NULL,NULL,NULL,'1E:1B:E0:50:5B:19','224566',300.00,'2025-08-24 04:03:34','2025-08-24 04:03:34'),(134,6,NULL,NULL,NULL,NULL,'1E:1B:E0:50:5B:19','594460',210.00,'2025-08-24 04:04:34','2025-08-24 04:04:34'),(135,6,NULL,NULL,NULL,NULL,'90:56:FC:DF:4A:E3','596434',210.00,'2025-08-24 07:15:26','2025-08-24 07:15:26'),(136,8,NULL,NULL,NULL,NULL,'5E:AB:0F:45:E5:21','577406',500.00,'2025-08-24 07:53:21','2025-08-24 07:53:21'),(137,8,NULL,NULL,NULL,NULL,'3E:A5:2D:34:21:C5','680604',500.00,'2025-08-24 08:24:03','2025-08-24 08:24:03'),(138,9,NULL,NULL,NULL,NULL,'16:E1:96:3C:2C:14','793156',1000.00,'2025-08-24 09:04:02','2025-08-24 09:04:02'),(139,7,NULL,NULL,NULL,NULL,'A6:85:AC:A3:94:CF','492517',300.00,'2025-08-24 09:27:55','2025-08-24 09:27:55'),(140,6,NULL,NULL,NULL,NULL,'A6:85:AC:A3:94:CF','402396',210.00,'2025-08-24 09:29:38','2025-08-24 09:29:38');

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` bigint unsigned NOT NULL,
  `company_router_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `issue_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `reminder` datetime NOT NULL,
  `stage` enum('Open','In Progress','Resolved','Closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Open',
  `status` int NOT NULL DEFAULT '1' COMMENT '0=Inactive, 1=Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tickets_company_id_foreign` (`company_id`),
  KEY `tickets_company_router_id_foreign` (`company_router_id`),
  KEY `tickets_user_id_foreign` (`user_id`),
  CONSTRAINT `tickets_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tickets_company_router_id_foreign` FOREIGN KEY (`company_router_id`) REFERENCES `company_routers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tickets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tickets`
--


--
-- Table structure for table `transaction_frequencies`
--

CREATE TABLE `transaction_frequencies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number_of_days` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transaction_frequencies`
--

INSERT INTO `transaction_frequencies` VALUES (1,'Instantly',0,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(2,'Daily',1,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(3,'Three Days',3,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(4,'Weekly',7,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(5,'Monthly',30,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL);

--
-- Table structure for table `user_verification_codes`
--

CREATE TABLE `user_verification_codes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `phone_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_verification_codes_user_id_foreign` (`user_id`),
  CONSTRAINT `user_verification_codes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_verification_codes`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `referrer_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `phone_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0=inactive, 1=active',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_phone_unique` (`phone`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'HF4Y6D','Super Admin','0712345678',NULL,'superadmin@gmail.com','2025-07-30 21:26:20','2025-07-30 21:26:20','$2y$12$sL9rLDiCAscrNQ.NY2RztOzzU0.cSCW6B5rNjnvO4i8ICYnXXnIbG',1,NULL,'2025-07-30 21:26:20','2025-08-13 09:20:47',NULL),(14,'H0ERF2','Ben','0745678',NULL,NULL,'2025-08-05 15:16:00','2025-08-05 15:16:00','$2y$12$mgPvt.LZISWEj4nKuYXv6urRN3LvIt1dML13T/snulGiRoOuGWkUq',1,NULL,'2025-08-05 15:16:00','2025-08-05 15:16:00',NULL),(15,'9E8FYP','Erick','0763752350',NULL,'sirnjovu86@gmail.com','2025-08-05 16:56:56','2025-08-05 16:56:56','$2y$12$t28h8a0Wo1XrJk0XZHrmS.zJKIvU002din28wiRKlPKVeRdv.Z10e',1,NULL,'2025-08-05 16:56:56','2025-08-09 11:59:27',NULL),(16,'5NGAQV','Admin','0712345679',NULL,NULL,'2025-08-12 12:25:52','2025-08-12 12:25:52','$2y$12$kuyPB0V6yohwp/aAz4epeO5VQrnpwnW7jJk9KLPTpKxBIfis8CiR2',1,NULL,'2025-08-12 12:25:52','2025-08-12 12:25:52',NULL),(17,'SGC5QD','Te','0694214936',NULL,'test@hmail.com','2025-08-13 07:21:07','2025-08-13 07:21:07','$2y$12$oIxyMmt3CSWOD/v2CEIzH..mKvXm0N61/x7IIMZ0x9Godd0pkXMYK',0,NULL,'2025-08-13 07:21:07','2025-08-13 20:48:18',NULL),(18,'W19D5P','Test','0693058471',NULL,'test@gmail.com','2025-08-13 07:21:55','2025-08-13 07:21:55','$2y$12$LE8vKzwYDwZHpw.hRN7oyuY4XhagL0O4oPpffvuNDZC70Vmt3lkkC',0,NULL,'2025-08-13 07:21:55','2025-08-13 20:48:00',NULL),(19,'2SZ35Y','Admin','0787109988',NULL,NULL,'2025-08-13 19:46:16','2025-08-13 19:46:16','$2y$12$tyfHnsegYuJzDVVrUGjj.eseTN4v2R2TCUmHZ/B09O6XeMd8Vc3bO',0,NULL,'2025-08-13 19:46:16','2025-08-13 20:47:46',NULL);


