-- Dumping data for table `jobs`
--


--
-- Table structure for table `message_modes`
--

CREATE TABLE `message_modes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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 `message_modes`
--

INSERT INTO `message_modes` VALUES (1,'SMS',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(2,'Email',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(3,'WhatsApp',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL);

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

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

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

INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2024_12_31_100452_create_permission_tables',1),(5,'2024_12_31_100952_create_companies_table',1),(6,'2024_12_31_100953_create_payment_types_table',1),(7,'2024_12_31_100954_create_transaction_frequencies_table',1),(8,'2024_12_31_101150_create_company_users_table',1),(9,'2024_12_31_101616_create_service_plans_table',1),(10,'2024_12_31_101618_create_plan_validity_types_table',1),(11,'2024_12_31_101619_create_company_routers_table',1),(12,'2024_12_31_101857_create_company_ip_pools_table',1),(13,'2024_12_31_101858_create_company_service_plans_table',1),(14,'2024_12_31_174557_create_user_verification_codes_table',1),(15,'2024_12_31_181637_create_notifications_table',1),(16,'2024_12_31_213650_create_message_modes_table',1),(17,'2024_12_31_221743_create_sms_providers_table',1),(18,'2024_12_31_221919_create_sms_requirements_table',1),(19,'2024_12_31_221940_create_sms_provider_requirements_table',1),(20,'2024_12_31_221957_create_company_sms_providers_table',1),(21,'2024_12_31_222005_create_company_sms_provider_entities_table',1),(22,'2025_01_01_122817_create_company_email_configurations_table',1),(23,'2025_01_01_173315_create_company_customers_table',1),(24,'2025_01_02_125417_create_company_prepaid_vouchers_table',1),(25,'2025_01_03_162401_create_company_prepaid_users_table',1),(26,'2025_01_03_162402_create_payment_modes_table',1),(27,'2025_01_03_163433_create_company_grouped_transactions_table',1),(28,'2025_01_08_121255_create_company_bulk_messages_table',1),(29,'2025_01_08_213530_create_banks_table',1),(30,'2025_01_08_213531_create_payment_methods_table',1),(32,'2025_01_21_025009_create_company_static_pages_table',1),(33,'2025_01_22_020910_create_personal_access_tokens_table',1),(34,'2025_01_22_021305_create_failed_transactions_table',1),(35,'2025_01_22_022710_create_company_customer_service_plans_table',1),(36,'2025_01_22_151114_create_company_customer_invoices_table',1),(37,'2025_01_22_151543_create_company_customer_invoice_payments_table',1),(38,'2025_01_22_230339_create_grouped_transactions_table',1),(39,'2025_01_22_233047_create_company_router_invoices_table',1),(40,'2025_01_22_233054_create_company_router_invoice_payments_table',1),(41,'2025_01_24_174649_create_company_customer_service_plan_previous_debt_payments_table',1),(42,'2025_01_27_232712_create_company_referrals_table',1),(43,'2025_01_28_001754_create_company_referral_payments_table',1),(44,'2025_02_04_180817_create_company_escrow_transactions_table',1),(45,'2025_02_12_105715_create_paid_users_table',1),(46,'2025_02_16_144236_create_company_sms_table',1),(47,'2025_02_16_144254_create_company_sms_usages_table',1),(48,'2025_02_16_144918_create_expenses_table',1),(49,'2025_02_23_220746_create_customers_table',1),(50,'2025_02_24_231040_create_out_messages_table',1),(51,'2025_03_04_160220_create_company_router_interfaces_table',1),(52,'2025_03_08_213801_create_escrow_transactions_table',1),(53,'2025_03_08_213802_create_director_shares_table',1),(54,'2025_03_11_190100_create_outgoing_transactions_table',1),(55,'2025_03_13_115203_create_sms_template_types_table',1),(56,'2025_03_13_115729_create_company_sms_templates_table',1),(57,'2025_03_18_003524_create_company_customer_invoice_notify_rates_table',1),(58,'2025_03_20_010357_create_company_inventories_table',1),(59,'2025_03_20_124540_create_company_whatsapp_scans_table',1),(60,'2025_03_30_212850_create_potential_customers_table',1),(61,'2025_04_02_002642_create_paybill_transactions_table',1),(62,'2025_04_04_041618_create_director_share_incomes_table',1),(63,'2025_05_04_131513_create_b2b_outgoing_transaction_charges_table',1),(64,'2025_05_04_210449_create_outgoing_transaction_entities_table',1),(65,'2025_05_05_120828_create_temporary_grouped_transactions_table',1),(66,'2025_05_06_214708_create_b2c_outgoing_transaction_charges_table',1),(67,'2025_05_22_121943_create_tickets_table',1),(68,'2025_05_23_090344_create_ip_prefix_lengths_table',1),(69,'2025_05_25_122209_add_group_to_permissions_table',1),(70,'2025_06_02_232726_create_director_share_payment_accounts_table',1),(71,'2025_06_08_143800_create_company_router_customers_table',1),(72,'2025_07_04_013141_create_company_customer_service_plan_installation_items_table',1),(73,'2025_07_04_013148_create_company_customer_service_plan_installation_item_payments_table',1),(74,'2025_07_09_032524_create_client_to_be_disconnecteds_table',1),(77,'2025_08_01_223540_create_temporary_transaction_checks_table',2),(78,'2025_01_08_213816_create_company_payment_accounts_table',3);

--
-- 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),(1,'App\\Models\\User',20),(1,'App\\Models\\User',21),(1,'App\\Models\\User',22),(1,'App\\Models\\User',23),(1,'App\\Models\\User',24),(1,'App\\Models\\User',25),(1,'App\\Models\\User',26),(1,'App\\Models\\User',27),(1,'App\\Models\\User',28),(1,'App\\Models\\User',29),(1,'App\\Models\\User',30),(1,'App\\Models\\User',31),(1,'App\\Models\\User',32),(1,'App\\Models\\User',33),(2,'App\\Models\\User',34),(1,'App\\Models\\User',35),(1,'App\\Models\\User',36),(1,'App\\Models\\User',37),(1,'App\\Models\\User',38);

--
-- 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),(2,'App\\Models\\User',20),(2,'App\\Models\\User',21),(2,'App\\Models\\User',22),(2,'App\\Models\\User',23),(2,'App\\Models\\User',24),(2,'App\\Models\\User',25),(2,'App\\Models\\User',26),(2,'App\\Models\\User',27),(2,'App\\Models\\User',28),(2,'App\\Models\\User',29),(2,'App\\Models\\User',30),(2,'App\\Models\\User',31),(2,'App\\Models\\User',32),(2,'App\\Models\\User',33),(2,'App\\Models\\User',34),(2,'App\\Models\\User',35),(2,'App\\Models\\User',36),(2,'App\\Models\\User',37),(2,'App\\Models\\User',38);

--
-- 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=14695 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `notifications` VALUES (14583,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-01 22:02:37','2025-10-01 22:02:37'),(14584,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',0,'2025-10-01 22:13:27','2025-10-01 22:13:27'),(14585,26,NULL,'Mikrotik Router Down','⚠️ Hi Ivan Rauya, your mikrotik router - WiFi Net is offline. Please check it out.',0,'2025-10-01 22:35:40','2025-10-01 22:35:40'),(14586,26,NULL,'Mikrotik Router Up','✅ Hi Ivan Rauya, your mikrotik router - WiFi Net is back online.',0,'2025-10-01 22:44:41','2025-10-01 22:44:41'),(14587,16,NULL,'Mikrotik Router Down','⚠️ Hi Emmanuel, your mikrotik router - Street Mesh is offline. Please check it out.',0,'2025-10-01 22:49:31','2025-10-01 22:49:31'),(14588,23,NULL,'Mikrotik Router Down','⚠️ Hi DENIS AMINI, your mikrotik router - ITeam is offline. Please check it out.',0,'2025-10-02 01:13:37','2025-10-02 01:13:37'),(14589,23,NULL,'Mikrotik Router Up','✅ Hi DENIS AMINI, your mikrotik router - ITeam is back online.',0,'2025-10-02 01:16:35','2025-10-02 01:16:35'),(14590,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-02 01:59:34','2025-10-02 01:59:34'),(14591,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-02 02:02:33','2025-10-02 02:02:33'),(14592,26,NULL,'Mikrotik Router Down','⚠️ Hi Ivan Rauya, your mikrotik router - WiFi Net is offline. Please check it out.',0,'2025-10-02 03:11:42','2025-10-02 03:11:42'),(14593,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-02 04:41:26','2025-10-02 04:41:26'),(14594,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-02 04:46:24','2025-10-02 04:46:24'),(14595,26,NULL,'Mikrotik Router Up','✅ Hi Ivan Rauya, your mikrotik router - WiFi Net is back online.',0,'2025-10-02 05:10:41','2025-10-02 05:10:41'),(14596,26,NULL,'Mikrotik Router Down','⚠️ Hi Ivan Rauya, your mikrotik router - WiFi Net is offline. Please check it out.',0,'2025-10-02 15:06:47','2025-10-02 15:06:47'),(14597,26,NULL,'Mikrotik Router Down','⚠️ Hi Ivan Rauya, your mikrotik router - WiFi Net is offline. Please check it out.',0,'2025-10-02 15:06:54','2025-10-02 15:06:54'),(14598,22,NULL,'Mikrotik Router Up','✅ Hi Manyala Agalla, your mikrotik router - Mshua Net is back online.',0,'2025-10-02 15:06:57','2025-10-02 15:06:57'),(14599,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-02 15:07:34','2025-10-02 15:07:34'),(14600,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-02 15:11:32','2025-10-02 15:11:32'),(14601,21,NULL,'Mikrotik Router Down','⚠️ Hi Ernest Cheyo, your mikrotik router - Kitonga is offline. Please check it out.',1,'2025-10-02 15:29:34','2025-10-03 23:27:46'),(14602,21,NULL,'Mikrotik Router Up','✅ Hi Ernest Cheyo, your mikrotik router - Kitonga is back online.',1,'2025-10-02 15:36:33','2025-10-03 23:27:46'),(14603,22,NULL,'Mikrotik Router Down','⚠️ Hi Manyala Agalla, your mikrotik router - Mshua Net is offline. Please check it out.',1,'2025-10-02 15:45:34','2025-10-04 09:19:36'),(14604,23,NULL,'Mikrotik Router Down','⚠️ Hi DENIS AMINI, your mikrotik router - ITeam is offline. Please check it out.',0,'2025-10-02 16:10:38','2025-10-02 16:10:38'),(14605,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-02 17:59:51','2025-10-02 17:59:51'),(14606,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-02 18:02:49','2025-10-02 18:02:49'),(14607,26,NULL,'Mikrotik Router Up','✅ Hi Ivan Rauya, your mikrotik router - WiFi Net is back online.',0,'2025-10-02 18:29:56','2025-10-02 18:29:56'),(14608,18,NULL,'Mikrotik Router Down','⚠️ Hi Gilbert mushi, your mikrotik router - G NJARO is offline. Please check it out.',0,'2025-10-02 20:11:52','2025-10-02 20:11:52'),(14609,22,NULL,'Mikrotik Router Up','✅ Hi Manyala Agalla, your mikrotik router - Mshua Net is back online.',0,'2025-10-02 20:27:54','2025-10-02 20:27:54'),(14610,18,NULL,'Mikrotik Router Up','✅ Hi Gilbert mushi, your mikrotik router - G NJARO is back online.',0,'2025-10-02 20:40:51','2025-10-02 20:40:51'),(14611,18,NULL,'Mikrotik Router Down','⚠️ Hi Gilbert mushi, your mikrotik router - G NJARO is offline. Please check it out.',0,'2025-10-02 20:47:52','2025-10-02 20:47:52'),(14612,18,NULL,'Mikrotik Router Up','✅ Hi Gilbert mushi, your mikrotik router - G NJARO is back online.',0,'2025-10-02 20:54:52','2025-10-02 20:54:52'),(14613,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-02 20:57:51','2025-10-02 20:57:51'),(14614,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-02 21:00:50','2025-10-02 21:00:50'),(14615,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-02 22:00:07','2025-10-02 22:00:07'),(14616,22,NULL,'Mikrotik Router Down','⚠️ Hi Manyala Agalla, your mikrotik router - Mshua Net is offline. Please check it out.',0,'2025-10-02 22:06:10','2025-10-02 22:06:10'),(14617,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-02 22:38:06','2025-10-02 22:38:06'),(14618,13,NULL,'Mikrotik Router Down','⚠️ Hi Kazungu, your mikrotik router - La Zungu is offline. Please check it out.',0,'2025-10-02 23:07:03','2025-10-02 23:07:03'),(14619,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-10-02 23:10:02','2025-10-02 23:10:02'),(14620,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 00:01:08','2025-10-03 00:01:08'),(14621,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-03 00:04:06','2025-10-03 00:04:06'),(14622,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 02:01:09','2025-10-03 02:01:09'),(14623,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-03 02:04:07','2025-10-03 02:04:07'),(14624,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 03:56:09','2025-10-03 03:56:09'),(14625,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-03 04:03:07','2025-10-03 04:03:07'),(14626,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-03 04:46:05','2025-10-03 04:46:05'),(14627,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-03 04:49:02','2025-10-03 04:49:02'),(14628,13,NULL,'Mikrotik Router Down','⚠️ Hi Kazungu, your mikrotik router - La Zungu is offline. Please check it out.',0,'2025-10-03 07:25:07','2025-10-03 07:25:07'),(14629,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-10-03 07:30:05','2025-10-03 07:30:05'),(14630,26,NULL,'Mikrotik Router Down','⚠️ Hi Ivan Rauya, your mikrotik router - WiFi Net is offline. Please check it out.',0,'2025-10-03 07:32:18','2025-10-03 07:32:18'),(14631,21,NULL,'Mikrotik Router Down','⚠️ Hi Ernest Cheyo, your mikrotik router - Kitonga is offline. Please check it out.',1,'2025-10-03 08:18:13','2025-10-03 23:27:46'),(14632,21,NULL,'Mikrotik Router Up','✅ Hi Ernest Cheyo, your mikrotik router - Kitonga is back online.',1,'2025-10-03 09:00:10','2025-10-03 23:27:46'),(14633,27,NULL,'Mikrotik Router Down','⚠️ Hi Garcia, your mikrotik router - Router20 is offline. Please check it out.',1,'2025-10-03 09:07:24','2025-10-03 11:08:42'),(14634,27,NULL,'Mikrotik Router Up','✅ Hi Garcia, your mikrotik router - Router20 is back online.',1,'2025-10-03 09:27:18','2025-10-03 11:59:14'),(14635,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 09:59:11','2025-10-03 09:59:11'),(14636,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-03 10:04:09','2025-10-03 10:04:09'),(14637,21,NULL,'Mikrotik Router Down','⚠️ Hi Ernest Cheyo, your mikrotik router - Kitonga is offline. Please check it out.',1,'2025-10-03 10:11:11','2025-10-03 23:27:46'),(14638,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-03 10:52:06','2025-10-03 10:52:06'),(14639,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-03 10:57:05','2025-10-03 10:57:05'),(14640,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',0,'2025-10-03 11:01:08','2025-10-03 11:01:08'),(14641,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',0,'2025-10-03 11:05:05','2025-10-03 11:05:05'),(14642,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 12:01:11','2025-10-03 12:01:11'),(14643,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-03 12:04:09','2025-10-03 12:04:09'),(14644,13,NULL,'Mikrotik Router Down','⚠️ Hi Kazungu, your mikrotik router - La Zungu is offline. Please check it out.',0,'2025-10-03 12:49:06','2025-10-03 12:49:06'),(14645,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-10-03 12:52:07','2025-10-03 12:52:07'),(14646,27,NULL,'Mikrotik Router Down','⚠️ Hi Garcia, your mikrotik router - Twistechs is offline. Please check it out.',0,'2025-10-03 13:55:22','2025-10-03 13:55:22'),(14647,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 14:01:11','2025-10-03 14:01:11'),(14648,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-03 14:04:10','2025-10-03 14:04:10'),(14649,18,NULL,'Mikrotik Router Down','⚠️ Hi Gilbert mushi, your mikrotik router - G NJARO is offline. Please check it out.',0,'2025-10-03 14:25:09','2025-10-03 14:25:09'),(14650,18,NULL,'Mikrotik Router Up','✅ Hi Gilbert mushi, your mikrotik router - G NJARO is back online.',0,'2025-10-03 15:05:07','2025-10-03 15:05:07'),(14651,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-03 15:35:11','2025-10-03 15:35:11'),(14652,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-03 15:41:09','2025-10-03 15:41:09'),(14653,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 16:01:20','2025-10-03 16:01:20'),(14654,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-03 16:04:13','2025-10-03 16:04:13'),(14655,26,NULL,'Mikrotik Router Up','✅ Hi Ivan Rauya, your mikrotik router - WiFi Net is back online.',0,'2025-10-03 16:33:21','2025-10-03 16:33:21'),(14656,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-03 16:38:10','2025-10-03 16:38:10'),(14657,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-03 16:46:08','2025-10-03 16:46:08'),(14658,26,NULL,'Mikrotik Router Down','⚠️ Hi Ivan Rauya, your mikrotik router - WiFi Net is offline. Please check it out.',0,'2025-10-03 16:47:23','2025-10-03 16:47:23'),(14659,21,NULL,'Mikrotik Router Up','✅ Hi Ernest Cheyo, your mikrotik router - Kitonga is back online.',1,'2025-10-03 17:02:13','2025-10-03 23:27:46'),(14660,21,NULL,'Mikrotik Router Down','⚠️ Hi Ernest Cheyo, your mikrotik router - Kitonga is offline. Please check it out.',1,'2025-10-03 17:07:15','2025-10-03 23:27:46'),(14661,26,NULL,'Mikrotik Router Up','✅ Hi Ivan Rauya, your mikrotik router - WiFi Net is back online.',0,'2025-10-03 17:32:24','2025-10-03 17:32:24'),(14662,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 18:01:23','2025-10-03 18:01:23'),(14663,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-03 18:04:15','2025-10-03 18:04:15'),(14664,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-03 18:32:12','2025-10-03 18:32:12'),(14665,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-03 18:37:10','2025-10-03 18:37:10'),(14666,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 20:01:16','2025-10-03 20:01:16'),(14667,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-03 20:04:15','2025-10-03 20:04:15'),(14668,26,NULL,'Mikrotik Router Down','⚠️ Hi Ivan Rauya, your mikrotik router - WiFi Net is offline. Please check it out.',0,'2025-10-03 20:16:25','2025-10-03 20:16:25'),(14669,26,NULL,'Mikrotik Router Up','✅ Hi Ivan Rauya, your mikrotik router - WiFi Net is back online.',0,'2025-10-03 20:20:23','2025-10-03 20:20:23'),(14670,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 20:24:16','2025-10-03 20:24:16'),(14671,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-03 20:34:12','2025-10-03 20:34:12'),(14672,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-03 20:45:10','2025-10-03 20:45:10'),(14673,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-03 20:50:15','2025-10-03 20:50:15'),(14674,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-03 22:01:12','2025-10-03 22:01:12'),(14675,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-03 22:07:10','2025-10-03 22:07:10'),(14676,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-03 23:57:23','2025-10-03 23:57:23'),(14677,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-03 23:59:30','2025-10-03 23:59:30'),(14678,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-04 00:02:28','2025-10-04 00:02:28'),(14679,27,NULL,'Mikrotik Router Up','✅ Hi Garcia, your mikrotik router - Twistechs is back online.',0,'2025-10-04 00:12:37','2025-10-04 00:12:37'),(14680,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-04 00:20:21','2025-10-04 00:20:21'),(14681,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-04 01:16:24','2025-10-04 01:16:24'),(14682,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-04 01:19:22','2025-10-04 01:19:22'),(14683,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',0,'2025-10-04 01:39:26','2025-10-04 01:39:26'),(14684,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-04 03:09:29','2025-10-04 03:09:29'),(14685,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-04 03:12:25','2025-10-04 03:12:25'),(14686,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-04 04:00:32','2025-10-04 04:00:32'),(14687,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-04 04:03:31','2025-10-04 04:03:31'),(14688,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-04 04:11:30','2025-10-04 04:11:30'),(14689,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-04 04:14:26','2025-10-04 04:14:26'),(14690,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',0,'2025-10-04 04:48:22','2025-10-04 04:48:22'),(14691,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-04 06:59:29','2025-10-04 06:59:29'),(14692,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-04 07:03:31','2025-10-04 07:03:31'),(14693,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-04 09:05:30','2025-10-04 09:05:30'),(14694,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-04 09:13:28','2025-10-04 09:13:28');

--
-- 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 AUTO_INCREMENT=18 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=953 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `paid_users` VALUES (129,7,140,'DE:FE:99:B9:7F:F5','749353','4130','255785581266','Greetings, thank you for purchasing [plan] plan worthy 200.00. Please use [username] as the username and 4130 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-09-01 10:47:58','2025-09-01 10:47:58'),(174,2,185,'FE:02:BF:6C:60:89','702460','7336','255611299495','Greetings, thank you for purchasing [plan] plan worthy 210.00. Please use [username] as the username and 7336 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-09-02 23:31:28','2025-09-02 23:31:28'),(773,2,789,'02:C0:AF:A7:33:40','423957','3052','255761933535','Greetings, thank you for purchasing [plan] plan worthy 500.00. Please use [username] as the username and 3052 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-09-28 21:03:05','2025-09-28 21:03:05'),(908,2,925,'F6:1D:E3:77:F2:61','958013','6479','255781692464','Greetings, thank you for purchasing [plan] plan worthy 300.00. Please use [username] as the username and 6479 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-02 18:53:15','2025-10-02 18:53:15');

--
-- 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`
--

INSERT INTO `password_reset_tokens` VALUES ('info@twistechs.bj','$2y$12$MwwKbNXSntZDfXC2N9sHMeBGO.LHpSsIRaesQ.ghJbf3gY/cV44qi','2025-10-03 10:02:54'),('ivonirauya@gmail.com','$2y$12$gG7lXzsC9QzP2Oa569DyZeLwOWDm9zjuHdu3C01G67emcJ8XckFIq','2025-10-01 22:12:55'),('sales@iteam.co.tz','$2y$12$95fJp6sBR9iT/ns4Vx6dlOePkzrQu.v9gW/Yp14MOcnjiYSdEbfLy','2025-09-30 08:09:30');

--
-- 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 ('2mXeBedUX8Cs7eHpjLLNctfiA70SisVZr9aEaVez',NULL,'52.34.76.65','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiU3hpdzNRekVBTzh5QWFpY09CQkNxTzg2bEJ0Y05Vc0l1ODM4TDBxeSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759558354),('30PReIh9ybH0c6PY72zTKTiLZl1VaaHp14fjN0Pz',NULL,'34.125.230.24','Mozilla/5.0 (Macintosh; Intel Mac OS X 13_3_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoicTJuM2N1N21YOVlTdXh5eVczRVA1T0ljTlZrTjk3UWlYMEZIemcwdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759558384),('40uMKrlmI7UC0E6cDAanYb9XJbr0zQqngFL2fFFy',NULL,'102.86.4.43','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoickJWWkR5RlJTY2NGVjZXOW9vSEtTa3draHNFQkM5S0czNjYyZ0dZNCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozNjoiaHR0cHM6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZS9ob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759567106),('97PsPN81CSFpM60VxeVwFySBUNZoDI9qMlFIkLES',NULL,'142.250.32.41','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoicWVDTnp6MGU1dVI1eXo1c2w3V2VKS1pLOXV2S3pNY1JDb1NxZzFocyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759566024),('98hRupQMKeCrl0bK0mT2mLqIgVqTmLkIL3uow6iZ',NULL,'161.97.174.20','GuzzleHttp/7','YTozOntzOjY6Il90b2tlbiI7czo0MDoid1ZLN2lBRTk2aXFWNHgzdWxmU1NWZGd3cGxjM25vR1d0UGtod2JRWiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9ob3RzcG90LXN0YXRpYy1wYWdlcy80M09SQ0oiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1759555439),('BrHccHKQhCeS4iFYmi7KA5KbrVA4SBs6ONfCgv5y',NULL,'3.144.107.199','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.51','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYklyYUJnRE52eVNvOUtWN0ZhR3lDZjdKV01YQlVOVWhDMG5JZEx2MiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759558352),('Cp8tVePpE18lk5Sycc7BmZgwcgJApeKzbBQUDMmb',NULL,'107.178.194.14','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 AppEngine-Google; (+http://code.google.com/appengine; appid: s~virustotalcloud)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiREluWk45MGdDOGxhZjBnOXZaSnR5QWVXR0pKWnB2dDRWTmZGcWdJbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759558362),('EU0MlbhfBor7bJcMfR0VIsRAeE56iqost76OZE3y',NULL,'54.158.34.52','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.51','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRHNGQkJranpCRnBmbHBZWmUyTkx1dHVoU3NBcDJZdFJOSTBDVFhnQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759558352),('gcMXs21sslJqr4vIk5DuDIfbhIMwcXtW83h6OdvD',NULL,'191.101.31.60','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.89 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiblFSWU5LZnZaSUowUUxmRHJVMG1SZHVMU2lsSzc0Y1FPY3A1a1lDRCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759562392),('gf5jEtOBk5c6MItLebtpbFiF8Gl6N21oSlbJMUKh',NULL,'91.250.249.150','Mozilla/5.0 (iPhone; CPU iPhone OS 17_0_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0.1 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQlhab1l3Nk1ETlowUDhWN2tvNVVDTWE4YlJ0c2U4RThob1RONnNtUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759559801),('HFmYrTvRyS96cPSHlkIofjPPl5KDGJXFNSnTPB2L',NULL,'205.169.39.37','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.5938.132 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYXpWTTJoQmtFcDBNYWlCd2U4WVh4TjFDaE12dDh0VzdZYkRNdGNHSiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759562016),('hoAsNy876yk7yamrRptHvrxPKzvn07PHSagDwGWs',28,'197.186.0.91','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36','[encoded data, 9324 characters]',1759555462),('ImfwgTGrTP2zgvLhcKE5NWjngnROxqGHx3nwfizT',NULL,'107.178.194.13','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 AppEngine-Google; (+http://code.google.com/appengine; appid: s~virustotalcloud)','YToyOntzOjY6Il90b2tlbiI7czo0MDoiR3B6eWgxTjBjc1RxM0NvYlBtZVF1dzdLQVJjMlVkeUVXMXo3blY1biI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759558362),('Iq5P5i5TMobALJwO6o4Pjs8EOdCXjNeAN9bIRHj0',15,'41.59.21.222','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36','[encoded data, 279340 characters]',1759557273),('junOm31EV2bfNj0hd1tvnRMFfIKmBWdEwF6qOP4A',NULL,'198.235.24.161','Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity','YTozOntzOjY6Il90b2tlbiI7czo0MDoieGFqdU5MS2R1b0JORXM0bWlKd1FyNW5PTnF0Qm9vdktwS0hvdDR1MCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759560707),('KLRg33UahvvppofBa7qD1KwqTXSVhpH6rUYClAgg',NULL,'142.250.32.40','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiUXQ0aGJJbmFWdHhsb3Z5d0hEWER1akZyNGs1NFhWMEpLcmRRbURSQyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NDoiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL3BheW1lbnQtYWNjb3VudHMiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NDoiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL3BheW1lbnQtYWNjb3VudHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1759566023),('l5528lfZFYPT9rRtiymGH7f5xUIWQfAjbRI8fcCX',NULL,'132.232.144.200','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVDFIR0RyS3YwMEJsTTNsZkVHY0Y4WUxVTkVVZVFoTmhHU1gwNlIyMyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759558573),('lbEZxFiX3fnunCYS12kLwWBYKrdxACmRVoORFbpy',NULL,'17.241.75.136','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)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVTZzS2VGMzZoSTllZHIxY1V2T0s3T1Z4ZDJrRG1oQmZmaGl1a29PUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759561076),('LfaojDDh2Pt3yqGCULEpLXuePXWiuDOpADsHlHh2',32,'196.249.105.119','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36','[encoded data, 17172 characters]',1759566181),('mOb2uwrEiedB6X0tn5pzrMyo6tzXe9RqpgZEv0P1',NULL,'107.178.194.12','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 AppEngine-Google; (+http://code.google.com/appengine; appid: s~virustotalcloud)','YToyOntzOjY6Il90b2tlbiI7czo0MDoieExpb2puVEF6TER6eHdweURKeWdiTFdISmFzbklUd3hlZ05NRE9yVCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759558352),('NwKH7Ns1U6rmlhmN1ZfBBDoMShcrUTjCjP8tD2x8',NULL,'45.87.212.92','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiU01OSXd0UFhHTXZJQkdnVVZFUmoxdHhNNTJZSTNheVRSRzgzYTRpMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759559800),('nYtuL7RY9VZZIMqX0NZIUn8jXav4WQ91MjnL0u5I',NULL,'43.166.129.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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVE02eXh1ell6RWFmOWdGZ2d5RFVYampTWmswMFBWNXVzMmpESFhlVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759564305),('OnKR1aFCyFep5Y7yPDgi1xYRLEUqRJB928bLSsas',NULL,'104.253.247.14','Mozilla/5.0 (iPhone; CPU iPhone OS 18_5 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/138.0.7204.156 Mobile/15E148 Safari/604.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoidVpCOU9aRmhtaVJkczR0ZTJCQTlCQkZhMnNQeDlGdERmaUZLMEdBUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759566018),('POw4l1ipM5QESLy64UxA3nnYGBzWQOmUyCq1sZwp',NULL,'107.178.194.13','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36 AppEngine-Google; (+http://code.google.com/appengine; appid: s~virustotalcloud)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYmpRY2dUcmRPZ1dGTUd1YkREU0FKYmo4T05DSGdnTnpkcnNxZXNXMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759558352),('qkdxx2o69qFi2kBiHkkDWxZ1yOBNhoNX4tFCXWac',NULL,'41.59.111.188','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOWVyaG1CeXlFakhRM0kwNXRiTUtqSFU2WW0weExSeG83eTZnZUVNUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759566534),('u6w8heNiy5YMXFPmcqheRs6irYg2b7x4TWEoeg6D',NULL,'3.140.193.193','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.51','YTozOntzOjY6Il90b2tlbiI7czo0MDoidkRJT2RSeDJyRlY0clk4WWVLaXRRT3dXaVZGSEFleHJLdlJ6UG9NbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759558352),('UvLjIV1fVoQFeIhBgG2tHIFTf7AD1ywcwCoW95uc',NULL,'205.169.39.52','Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMU1rWFNqbjJqV3lxeWJrOXhGWnhpanViczBXU1N5M1hLWVdWR2RrayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759561999),('v3hQCcYWlszhnxKrE79n0CgTZZKrbCN7zcgzC52E',NULL,'195.47.238.176','Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; Trident/6.0)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaVpEMXZKZ0lpYXMxcUdSNGRZSlhaSTA0NWZYVnM2THMwWjR3bm5rVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759558386),('Vl44Bb0mNAdpnwOIagHvzYFKPLOaKRQGeauZsNJi',NULL,'64.225.100.118','Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZkU4VUlrOWE4RndSMUliOTdxYkJSVHZaQVBhR3hFalg0b3Y0c0VZZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759561963),('XwtUPgLU5WxxPz8ESS5MbXKCHzB0cf95taMXOnkV',NULL,'66.249.69.140','GoogleOther','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZktocXJDa3JVVHNOeXFKSHFjNXVmN214N2FGdkFNWGkwbDlKQWpNZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759558352),('YOi4wbEn03nGJ27yOjjcpuxAsqXSmxPpKudumX07',NULL,'104.197.69.115','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/125.0.6422.60 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiemFqaUh2SDc1VGFpN3FmNlpmOTF4VVhiMVV2WmhaTWVFbEcwcnJuSCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759561973);

--
