-- 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=14676 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.',0,'2025-10-02 15:29:34','2025-10-02 15:29:34'),(14602,21,NULL,'Mikrotik Router Up','✅ Hi Ernest Cheyo, your mikrotik router - Kitonga is back online.',0,'2025-10-02 15:36:33','2025-10-02 15:36:33'),(14603,22,NULL,'Mikrotik Router Down','⚠️ Hi Manyala Agalla, your mikrotik router - Mshua Net is offline. Please check it out.',0,'2025-10-02 15:45:34','2025-10-02 15:45:34'),(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.',0,'2025-10-03 08:18:13','2025-10-03 08:18:13'),(14632,21,NULL,'Mikrotik Router Up','✅ Hi Ernest Cheyo, your mikrotik router - Kitonga is back online.',0,'2025-10-03 09:00:10','2025-10-03 09:00:10'),(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.',0,'2025-10-03 10:11:11','2025-10-03 10:11:11'),(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.',0,'2025-10-03 17:02:13','2025-10-03 17:02:13'),(14660,21,NULL,'Mikrotik Router Down','⚠️ Hi Ernest Cheyo, your mikrotik router - Kitonga is offline. Please check it out.',0,'2025-10-03 17:07:15','2025-10-03 17:07:15'),(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');

--
-- 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=947 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 ('19Hm0cOG58jlVna74uMh1VJ7oL4Bsd5jAZLfaCgs',NULL,'129.211.215.233','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYzR0bjR0OGJMMHloY29meGkxNk9IS1l1MXFqak5rSG90cGxydkFkeiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759517097),('cKGFRDuPfD9x9myAXAXa57Y9pN4tEIAEIAyECR3j',NULL,'128.199.120.164','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWGdSUDRkNmxPMjZ4MWJXcGN5UENpU3VGVTY2MURSUlRjb0lrMk5vMyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759521345),('daulZeVJe89L2Aur24mJ5vnVYn1d9YaHhQiEVK8g',NULL,'147.185.132.72','Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV2V4dTVodkl1UlplcTQwWWdSMnZYUUJSTVR1bVhMNjJEVXl5eU5QTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759516541),('fLDvpliXlQRsHrTGXZaJOdBNrEXTwKgDPtBietCR',NULL,'156.228.189.37','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMjl6MmFUN3NoREZrNEtrTmNBSlYzaGxTUE5tZ1JwdlFBYVVXS2lSYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759525580),('jeNInBy3C0H0Kw7WaXPtiRs7DAYxJOEUE0mgMnWa',NULL,'149.154.161.221','TelegramBot (like TwitterBot)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRURteGdOTFRUaEYzeTY3VlZObDlValBlS2ZveXcwSFoxY3JDYmNucyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1OToiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL2RlbGV0ZS1jb21wYW55LXNlcnZpY2UtcGxhbi8xMDgiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozMzoiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1759523022),('Jp9aHrsg9rg5rTqPiJcyGR7jsXWwH3o81Y0uwdMI',NULL,'156.228.189.37','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVnlHbG1zeUFZSmlQUTFYWDJUWTJ6SHlOZExSd1htNXdUY1RZcHBwZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759525582),('KSaYxKCHoBgjSqmxWyU1OMOU500byhjSPm2tpZui',NULL,'156.228.189.37','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVWhxVmprSXRVelNJaTBSWUlxZHBNcUNRc0R3RlNuY25Sa1BSSkdnciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759525586),('MV5Pm8DEbUgNIoutkrmkMBULZPFAiVkd0k3g1nwf',NULL,'43.166.224.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','YTozOntzOjY6Il90b2tlbiI7czo0MDoidEtZU2JGWDhHdUJkM1c4UXNLdW5pR1hHRXhYYW5pNXhncG5XcVZrcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xNjEuOTcuMTc0LjIwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759524151),('nEGmvTeVfFJUPhhq8iRxGeunhziXU2M9rNG1JUFc',15,'197.250.98.243','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.5','[encoded data, 279360 characters]',1759524748),('Pa94x9P4vSOMaHqoNS1w0w1Ph2EBotZ5bCjUvmZg',30,'154.74.192.118','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Mobile Safari/537.36','[encoded data, 23028 characters]',1759520415),('pYKEw5rJ1cyxlhL3Sh360FIe230VunUCEp1bWVEw',NULL,'156.228.189.37','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoid3FxdEFsRGxjYVBld0toQWdnREUxYUdQSGQwYmFPWUlzajREQjZIZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS8/YXV0aG9yPTEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1759525580),('qiaN3yoAozTYlMZHAmpujhrHxULBjEi30k0ZayI9',NULL,'156.228.189.37','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOU1JZU9US3ZaM2NSNWZpN0lCMndnY3lkNkdDekhhZGtWU0NVT0tDYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759525585),('r0kh9ePCaEgRHaxDyW8qz43xG7JXtUH5Pb1gTKVz',NULL,'61.219.11.155','python-requests/2.32.3','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ2hqUnVpSm9LVnA0Z1FuVjZQYmxmWDZHSFBNRGZZQ29VSTA3VFpRQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xNjEuOTcuMTc0LjIwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759516922),('vCT0zBAdQ0YDBjBTlqty3KZSQGkRqY8j7wZKt5gh',31,'197.186.3.69','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, 53468 characters]',1759523665),('y6Abmacbon4g5C7FaSOKvFOK329qPIRACBm5tHG3',NULL,'156.228.189.37','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaTNDRnd0Y2JHWnhlMjFOZ3ZaZFpjeHpXaWpObjY3R2NFRlJPOUFKNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1759525583);

--
