-- Table structure for table `company_referral_payments`
--

CREATE TABLE `company_referral_payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_referral_id` bigint unsigned NOT NULL,
  `company_router_invoice_payment_id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `payment_mode_id` bigint unsigned NOT NULL,
  `transaction_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 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`),
  KEY `company_referral_payments_company_referral_id_foreign` (`company_referral_id`),
  KEY `company_referral_payments_payment_mode_id_foreign` (`payment_mode_id`),
  CONSTRAINT `company_referral_payments_company_referral_id_foreign` FOREIGN KEY (`company_referral_id`) REFERENCES `company_referrals` (`id`) ON DELETE CASCADE,
  CONSTRAINT `company_referral_payments_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 `company_referral_payments`
--


--
-- Table structure for table `company_referrals`
--

CREATE TABLE `company_referrals` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `referrer_id` int NOT NULL,
  `percentage_commission` 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`),
  KEY `company_referrals_company_id_foreign` (`company_id`),
  CONSTRAINT `company_referrals_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_referrals`
--


--
-- Table structure for table `company_router_customers`
--

CREATE TABLE `company_router_customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_router_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `company_router_customers_company_router_id_foreign` (`company_router_id`),
  CONSTRAINT `company_router_customers_company_router_id_foreign` FOREIGN KEY (`company_router_id`) REFERENCES `company_routers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_router_customers`
--

INSERT INTO `company_router_customers` VALUES (1,2,'7E:A5:C8:0E:3C:6A','255763752350','2025-08-05 18:59:16','2025-08-20 05:38:54',NULL),(2,2,'5A:DD:D5:00:65:24','255693311437','2025-08-05 19:03:34','2025-08-14 20:20:44',NULL),(3,2,'56:4C:02:FD:0F:0B','255672040034','2025-08-07 18:53:51','2025-08-30 18:22:28',NULL),(4,2,'5E:32:CC:C1:11:35','255617595193','2025-08-08 15:56:01','2025-08-08 15:56:01',NULL),(5,2,'D4:67:D3:E3:17:BD','255656056606','2025-08-09 11:05:16','2025-08-09 11:05:16',NULL),(6,2,'76:B4:55:80:75:CE','255618250327','2025-08-11 19:33:35','2025-08-28 19:09:11',NULL),(7,2,'Silas','0796230626','2025-08-17 08:18:10','2025-08-17 08:18:10',NULL),(8,2,'Wankrew','0792222222','2025-08-17 13:16:10','2025-08-17 13:16:10',NULL),(9,2,'Admin','0723232334','2025-08-17 14:00:15','2025-08-17 14:00:15',NULL),(10,2,'Admin','0723232323','2025-08-17 14:05:10','2025-08-17 14:05:10',NULL),(11,2,'njovu','0763752350','2025-08-17 14:08:43','2025-08-17 14:08:43',NULL),(12,2,'EA:58:A4:7A:3F:40','255746278281','2025-08-17 15:44:23','2025-08-17 15:44:23',NULL),(13,2,'30:FC:EB:7A:0C:90','255758728802','2025-08-19 09:09:34','2025-08-20 19:16:07',NULL),(14,2,'62:06:D0:8C:47:36','255673093138','2025-08-19 17:48:08','2025-08-19 17:48:08',NULL),(15,2,'E6:12:A3:41:F4:AD','255746184273','2025-08-19 20:41:06','2025-08-19 20:41:06',NULL),(16,2,'14:9F:3C:6B:96:77','255783709549','2025-08-20 10:01:10','2025-08-20 10:01:10',NULL),(17,2,'F2:50:95:0B:4B:27','255747101974','2025-08-20 13:10:29','2025-08-20 13:10:29',NULL),(18,2,'Faith','0712050835','2025-08-20 14:09:02','2025-08-20 14:09:02',NULL),(19,2,'5A:22:D6:25:36:E9','255616535743','2025-08-20 18:26:13','2025-08-20 18:26:13',NULL),(20,2,'3E:A5:2D:34:21:C5','255617223653','2025-08-20 20:00:36','2025-08-24 08:24:28',NULL),(21,2,'BE:FD:23:A1:58:ED','255654966625','2025-08-21 06:30:08','2025-08-21 06:30:08',NULL),(22,2,'D6:12:9E:9D:91:0E','255625284273','2025-08-21 19:38:06','2025-08-21 19:38:06',NULL),(23,2,'0A:00:F5:20:D1:35','255769211401','2025-08-21 20:22:20','2025-08-21 20:22:20',NULL),(24,2,'FE:96:EF:57:F0:70','255714840147','2025-08-22 17:26:43','2025-08-22 17:26:43',NULL),(25,2,'F2:65:ED:BF:19:CD','255785162610','2025-08-22 20:56:29','2025-08-22 20:56:29',NULL),(26,2,'0A:00:F5:20:D1:35','255629671401','2025-08-22 22:46:53','2025-08-22 22:46:53',NULL),(27,2,'4E:ED:DD:40:F3:A1','255792736886','2025-08-23 09:26:25','2025-08-23 09:26:25',NULL),(28,2,'A6:85:AC:A3:94:CF','255742925839','2025-08-24 09:30:08','2025-08-24 09:30:08',NULL),(29,2,'FC:AA:B6:3B:A0:48','255769039595','2025-08-24 21:25:55','2025-08-31 22:41:14',NULL),(30,2,'0E:32:DD:A2:B3:84','255715060369','2025-08-25 17:22:24','2025-09-02 15:34:31',NULL),(31,2,'42:B6:CB:A6:FE:13','255774422687','2025-08-25 17:32:30','2025-08-25 17:32:30',NULL),(32,2,'0E:06:50:49:08:C6','255775514233','2025-08-25 19:15:59','2025-08-25 19:15:59',NULL),(33,2,'5A:22:D6:25:36:E9','255767631761','2025-08-26 14:51:15','2025-08-26 14:51:15',NULL),(34,6,'Mwamba','123456','2025-08-26 17:28:39','2025-08-26 17:28:39',NULL),(35,2,'02:C0:AF:A7:33:40','255761933535','2025-08-26 20:37:23','2025-08-28 21:38:06',NULL),(36,2,'F2:94:94:28:61:0A','255685827717','2025-08-26 21:17:04','2025-08-26 21:17:04',NULL),(37,5,'maleko','0713277244','2025-08-26 21:46:05','2025-08-26 21:46:05',NULL),(38,5,'magwila','0785949091','2025-08-26 21:53:10','2025-08-26 21:53:10',NULL),(39,5,'luta','0789880287','2025-08-26 21:58:54','2025-08-26 21:58:54',NULL),(40,5,'gilbert','0715807200','2025-08-26 22:02:34','2025-08-26 22:02:34',NULL),(41,6,'A2:ED:93:63:1B:07','255781995838','2025-08-27 10:46:41','2025-08-27 10:46:41',NULL),(42,6,'C2:14:39:F6:BE:64','255767506018','2025-08-27 10:48:07','2025-08-27 10:48:07',NULL),(43,2,'2E:1A:C2:11:77:57','255786509766','2025-08-28 13:09:31','2025-08-28 13:09:31',NULL),(44,2,'FA:EE:D5:8C:58:74','255687691491','2025-08-28 15:53:52','2025-08-28 15:53:52',NULL),(45,2,'daniel','0657745566','2025-08-29 05:36:04','2025-08-29 05:36:04',NULL),(46,2,'munisi','0784354707','2025-08-29 05:38:44','2025-08-29 05:38:44',NULL),(47,2,'ndunguru','0763462201','2025-08-29 05:41:06','2025-08-29 05:41:06',NULL),(48,2,'2E:02:FF:6E:4D:83','255622713224','2025-08-29 12:02:21','2025-08-29 12:02:21',NULL),(49,2,'BE:B3:CB:9E:09:DC','255625387323','2025-08-29 12:46:55','2025-09-01 11:15:44',NULL),(50,2,'52:79:1D:E2:BB:02','255768091773','2025-08-29 13:16:58','2025-08-30 07:18:53',NULL),(51,7,'8E:E0:2B:0F:11:26','255754578434','2025-08-29 20:53:37','2025-08-29 20:53:37',NULL),(52,2,'7E:5E:FC:92:8D:6E','255656397070','2025-08-30 08:01:52','2025-08-30 08:01:52',NULL),(53,2,'26:FF:4F:81:B9:CD','255794449030','2025-08-30 09:12:33','2025-08-30 09:12:33',NULL),(54,2,'62:98:4F:47:C4:C9','255656537308','2025-08-30 11:39:29','2025-08-30 11:39:29',NULL),(55,2,'E2:CA:F4:73:20:C8','255747433974','2025-08-30 16:26:16','2025-08-30 16:26:16',NULL),(56,2,'F2:14:5F:EE:3E:9B','255794474606','2025-08-31 10:25:51','2025-08-31 10:25:51',NULL),(57,6,'7A:39:BF:E7:E7:A8','255784130128','2025-08-31 11:28:50','2025-08-31 11:28:50',NULL),(58,6,'C2:FB:8E:57:E1:CE','255712513119','2025-08-31 11:39:01','2025-08-31 11:39:01',NULL),(59,6,'C8:B2:9B:7C:5F:29','255758219626','2025-08-31 13:13:17','2025-08-31 13:13:17',NULL),(60,2,'90:2B:D2:AA:09:B8','255752565788','2025-08-31 15:02:58','2025-08-31 15:02:58',NULL),(61,2,'10:3F:44:60:C7:32','255783339170','2025-08-31 19:08:51','2025-08-31 19:08:51',NULL),(62,2,'82:75:18:2D:C9:ED','255749709448','2025-08-31 20:49:57','2025-08-31 20:49:57',NULL),(63,2,'C6:C2:9D:CB:45:91','255786334359','2025-08-31 21:27:22','2025-08-31 21:27:22',NULL),(64,2,'FE:54:93:3B:80:42','255764788454','2025-09-01 05:50:29','2025-09-01 05:50:29',NULL),(65,7,'C6:F2:E7:AB:DB:E5','255745071246','2025-09-01 08:25:02','2025-09-01 08:25:02',NULL),(66,6,'BA:C8:C0:76:B0:F5','255679180150','2025-09-01 09:41:32','2025-09-01 09:41:32',NULL),(67,2,'4E:3D:13:06:1F:4B','255616692225','2025-09-01 10:11:33','2025-09-02 20:58:03',NULL),(68,7,'CE:0A:06:DF:1F:AA','255742455774','2025-09-01 10:21:41','2025-09-01 10:21:41',NULL),(69,7,'DE:FE:99:B9:7F:F5','255785581266','2025-09-01 10:47:55','2025-09-01 10:47:55',NULL),(70,2,'4C:63:71:96:C0:61','255760565257','2025-09-01 11:22:40','2025-09-01 11:22:40',NULL),(71,7,'EA:56:D4:D3:43:77','255766383956','2025-09-01 12:38:35','2025-09-02 07:22:06',NULL),(72,7,'F2:8D:73:23:0E:53','255794877187','2025-09-01 13:08:34','2025-09-01 13:08:34',NULL),(73,2,'6E:86:6A:C0:08:FA','255625593547','2025-09-01 14:36:31','2025-09-01 14:36:31',NULL),(74,2,'A6:FE:2D:DE:CA:43','255756686605','2025-09-01 15:25:14','2025-09-01 15:25:14',NULL),(75,7,'DA:A8:28:9C:36:F4','255684128557','2025-09-01 16:03:03','2025-09-01 16:03:03',NULL),(76,7,'5E:93:95:94:AB:32','255760634846','2025-09-01 16:31:16','2025-09-01 16:31:16',NULL),(77,7,'C6:1B:31:E0:18:15','255792840418','2025-09-01 17:21:13','2025-09-01 17:21:13',NULL),(78,7,'56:3C:66:83:95:BB','255745504484','2025-09-01 21:17:35','2025-09-01 21:17:35',NULL),(79,7,'A6:F5:4F:AB:DF:19','255695220884','2025-09-01 21:25:11','2025-09-01 21:25:11',NULL),(80,2,'AA:93:3E:F3:53:52','255784147778','2025-09-01 21:39:52','2025-09-01 21:39:52',NULL),(81,2,'FE:02:BF:6C:60:89','255611299495','2025-09-01 22:34:54','2025-09-02 23:31:26',NULL),(82,7,'9A:1F:40:7C:81:B4','255783748565','2025-09-02 09:24:52','2025-09-02 09:24:52',NULL),(83,2,'F2:65:ED:BF:19:CD','255756172712','2025-09-02 09:36:11','2025-09-02 09:36:11',NULL),(84,2,'4A:87:2C:39:9D:A6','255699798976','2025-09-02 14:51:27','2025-09-02 14:51:27',NULL),(85,2,'7A:84:79:EC:32:66','255754410997','2025-09-02 16:45:57','2025-09-02 16:45:57',NULL),(86,2,'C6:82:84:09:10:28','255761028792','2025-09-02 19:19:24','2025-09-02 19:19:24',NULL),(87,2,'82:75:18:2D:C9:ED','255674057530','2025-09-02 19:35:14','2025-09-02 19:35:14',NULL),(88,2,'86:87:D5:B9:81:15','255654759552','2025-09-03 06:31:13','2025-09-03 06:31:13',NULL),(89,2,'CE:42:78:C4:E6:C9','255627130488','2025-09-03 07:53:49','2025-09-03 07:53:49',NULL),(90,2,'A0:CC:2B:B3:51:BB','255624253578','2025-09-03 08:46:53','2025-09-03 08:46:53',NULL);

--
-- Table structure for table `company_router_interfaces`
--

CREATE TABLE `company_router_interfaces` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_router_id` bigint unsigned 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`),
  KEY `company_router_interfaces_company_router_id_foreign` (`company_router_id`),
  CONSTRAINT `company_router_interfaces_company_router_id_foreign` FOREIGN KEY (`company_router_id`) REFERENCES `company_routers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_router_interfaces`
--

INSERT INTO `company_router_interfaces` VALUES (9,2,'ether1',1,'2025-08-05 17:44:20','2025-08-05 17:44:20',NULL),(10,2,'ether3',1,'2025-08-05 17:44:20','2025-08-05 17:44:20',NULL),(11,2,'ether4',1,'2025-08-05 17:44:20','2025-08-05 17:44:20',NULL),(12,2,'ether5',1,'2025-08-05 17:44:20','2025-08-05 17:44:20',NULL),(13,2,'bridge',1,'2025-08-05 17:44:20','2025-08-05 17:44:20',NULL),(14,2,'lo',1,'2025-08-05 17:44:20','2025-08-05 17:44:20',NULL),(15,2,'ovpn-out1',1,'2025-08-05 17:44:20','2025-08-05 17:44:20',NULL),(25,5,'ether1',1,'2025-08-26 18:11:46','2025-08-26 18:11:46',NULL),(26,5,'ether3',1,'2025-08-26 18:11:46','2025-08-26 18:11:46',NULL),(27,5,'ether4',1,'2025-08-26 18:11:46','2025-08-26 18:11:46',NULL),(28,5,'ether5',1,'2025-08-26 18:11:46','2025-08-26 18:11:46',NULL),(29,5,'bridge',1,'2025-08-26 18:11:46','2025-08-26 18:11:46',NULL),(30,5,'ovpn-out1',1,'2025-08-26 18:11:46','2025-08-26 18:11:46',NULL),(31,7,'ether1',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(32,7,'ether2',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(33,7,'ether3',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(34,7,'ether5',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(35,7,'ether6',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(36,7,'ether7',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(37,7,'ether8',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(38,7,'sfp1',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(39,7,'bridge',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(40,7,'lo',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(41,7,'ovpn-out1',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL),(42,7,'wifi1',1,'2025-08-29 20:13:38','2025-08-29 20:13:38',NULL);

--
-- Table structure for table `company_router_invoice_payments`
--

CREATE TABLE `company_router_invoice_payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `router_invoice_id` int NOT NULL,
  `grouped_transaction_id` bigint unsigned NOT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `commission_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`),
  KEY `company_router_invoice_payments_grouped_transaction_id_foreign` (`grouped_transaction_id`),
  CONSTRAINT `company_router_invoice_payments_grouped_transaction_id_foreign` FOREIGN KEY (`grouped_transaction_id`) REFERENCES `grouped_transactions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_router_invoice_payments`
--

INSERT INTO `company_router_invoice_payments` VALUES (1,6,1,21000.00,0.00,'2025-08-28 06:42:22','2025-08-28 06:42:22',NULL);

--
-- Table structure for table `company_router_invoices`
--

CREATE TABLE `company_router_invoices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_router_id` bigint unsigned NOT NULL,
  `from_date` timestamp NOT NULL,
  `to_date` timestamp NOT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `status` int NOT NULL DEFAULT '0' COMMENT '0=pending, 1=paid',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `company_router_invoices_company_router_id_foreign` (`company_router_id`),
  CONSTRAINT `company_router_invoices_company_router_id_foreign` FOREIGN KEY (`company_router_id`) REFERENCES `company_routers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_router_invoices`
--

INSERT INTO `company_router_invoices` VALUES (2,'1052P9',2,'2025-08-04 22:00:00','2025-09-04 22:00:00',1000.00,0,'2025-08-05 16:56:56','2025-08-28 13:27:33','2025-08-28 13:27:33'),(5,'L3POA9',5,'2025-08-17 22:00:00','2025-09-17 22:00:00',21000.00,0,'2025-08-18 17:15:11','2025-08-28 06:45:33',NULL),(6,'UMORD7',6,'2025-08-25 22:00:00','2025-09-25 22:00:00',21000.00,1,'2025-08-26 13:06:13','2025-08-28 06:42:22',NULL),(7,'LIM5SR',7,'2025-08-28 22:00:00','2025-09-28 22:00:00',21000.00,0,'2025-08-29 19:10:58','2025-08-29 19:10:58',NULL),(8,'UA4N6X',8,'2025-08-29 22:00:00','2025-09-29 22:00:00',21000.00,0,'2025-08-30 06:58:45','2025-08-30 06:58:45',NULL);

--
-- Table structure for table `company_routers`
--

CREATE TABLE `company_routers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `public_ip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `api_port` int NOT NULL DEFAULT '8728',
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscription_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `expiry_date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_care_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `online_status` int NOT NULL DEFAULT '1' COMMENT '0=offline, 1=online',
  `online_status_counter` int NOT NULL DEFAULT '0',
  `file_location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_frequency_id` bigint unsigned DEFAULT NULL,
  `next_transaction_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hotspot_anti_sharing_enabled` int NOT NULL DEFAULT '0' COMMENT '0=no, 1=yes',
  `status` int NOT NULL DEFAULT '1' COMMENT '0=inactive, 1=active, 2=expired',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `company_routers_ip_address_unique` (`ip_address`),
  UNIQUE KEY `company_routers_public_ip_unique` (`public_ip`),
  KEY `company_routers_company_id_foreign` (`company_id`),
  KEY `company_routers_transaction_frequency_id_foreign` (`transaction_frequency_id`),
  CONSTRAINT `company_routers_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `company_routers_transaction_frequency_id_foreign` FOREIGN KEY (`transaction_frequency_id`) REFERENCES `transaction_frequencies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_routers`
--

INSERT INTO `company_routers` VALUES (2,'GI6BYT',8,'Ngoni Net 1','50.50.50.2','161.97.174.20:16758','ngoni',8728,'48DWVF',0.00,'2025-08-05','0716583413',1,0,NULL,1,'2025-08-05',1,1,'2025-08-05 16:56:56','2025-09-03 06:16:16',NULL),(5,'YE6B2O',8,'Machinga Complex','50.50.50.5','161.97.174.20:11566','heritage',8728,'0HAWV2',21000.00,'2025-08-26','0763752350',1,3,NULL,NULL,NULL,1,1,'2025-08-18 17:15:11','2025-09-03 08:34:13',NULL),(6,'83WYM2',11,'Mwamba','50.50.50.6','161.97.174.20:18680','heritage',8728,'5ZISPW',21000.00,'2025-09-28','0786000803',0,0,'flash',NULL,NULL,1,1,'2025-08-26 13:06:13','2025-09-01 11:16:09',NULL),(7,'O37YGC',13,'La Zungu','50.50.50.7','161.97.174.20:18875','heritage',8728,'6ZNHLJ',21000.00,'2025-08-29','0754578434',0,163,NULL,NULL,NULL,1,2,'2025-08-29 19:10:58','2025-09-03 10:30:19',NULL),(8,'9N2EL1',14,'MwendoKasi','50.50.50.8',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-08-30','0696849400',0,3,NULL,NULL,NULL,0,2,'2025-08-30 06:58:45','2025-08-30 08:39:34',NULL);

--
-- Table structure for table `company_service_plans`
--

CREATE TABLE `company_service_plans` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` bigint unsigned NOT NULL,
  `service_plan_id` bigint unsigned NOT NULL,
  `company_router_id` bigint unsigned DEFAULT NULL,
  `company_ip_pool_id` int DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `download_limit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_scale` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_limit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_scale` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `burst_download_limit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `burst_download_scale` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `burst_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shared_users` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `valid_for` decimal(8,2) NOT NULL DEFAULT '1.00',
  `plan_validity_type_id` int DEFAULT NULL,
  `cost` decimal(8,2) NOT NULL DEFAULT '0.00',
  `status` int NOT NULL DEFAULT '1' COMMENT '0=inactive, 1=active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `company_service_plans_company_id_foreign` (`company_id`),
  KEY `company_service_plans_service_plan_id_foreign` (`service_plan_id`),
  KEY `company_service_plans_company_router_id_foreign` (`company_router_id`),
  CONSTRAINT `company_service_plans_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `company_service_plans_company_router_id_foreign` FOREIGN KEY (`company_router_id`) REFERENCES `company_routers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `company_service_plans_service_plan_id_foreign` FOREIGN KEY (`service_plan_id`) REFERENCES `service_plans` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_service_plans`
--

INSERT INTO `company_service_plans` VALUES (6,'F3L651',8,1,2,3,'1 Hour','5','M','5','M',NULL,NULL,NULL,'1',1.00,2,210.00,1,'2025-08-05 17:49:04','2025-08-15 23:19:41',NULL),(7,'YPH8AG',8,1,2,3,'3 Hours','3','M','2','M',NULL,NULL,NULL,'1',3.00,2,300.00,1,'2025-08-05 17:49:42','2025-08-31 19:13:23',NULL),(8,'RN5IOU',8,1,2,3,'12 Hours','3','M','3','M',NULL,NULL,NULL,'1',12.00,2,500.00,1,'2025-08-05 17:50:05','2025-08-28 22:28:21',NULL),(9,'SHZN7L',8,1,2,3,'24 Hours','3','M','3','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-08-05 17:50:21','2025-08-28 22:30:53',NULL),(10,'ICA7K6',8,1,2,3,'7 Day','3','M','3','M',NULL,NULL,NULL,'1',7.00,3,5000.00,1,'2025-08-08 19:52:48','2025-08-18 21:00:20',NULL),(22,'X8D2C0',8,2,2,4,'Kiboko','10','M','10','M',NULL,NULL,NULL,'1',30.00,3,40000.00,1,'2025-08-11 10:11:00','2025-08-11 10:11:00',NULL),(23,'Q3R0VS',8,1,2,3,'Mwezi','3','M','3','M',NULL,NULL,NULL,'1',30.00,3,15000.00,1,'2025-08-14 20:43:56','2025-08-15 18:44:13',NULL),(24,'48IY1U',8,1,2,3,'3 days','03','M','03','M',NULL,NULL,NULL,'1',3.00,3,2500.00,1,'2025-08-14 20:45:13','2025-08-14 20:45:13',NULL),(25,'OP0VN1',8,3,2,NULL,'6mbps/6mbps','3','M','3','M',NULL,NULL,NULL,'1',1.00,3,2000.00,1,'2025-08-19 20:17:59','2025-08-19 20:17:59',NULL),(26,'S3H0WT',8,1,2,3,'2 week','03','M','03','M',NULL,NULL,NULL,'1',14.00,3,7000.00,1,'2025-08-20 11:02:58','2025-08-20 11:02:58',NULL),(27,'0X5KNQ',11,1,6,6,'Ndovu','3','M','3','M',NULL,NULL,NULL,'50',30.00,1,500.00,1,'2025-08-26 17:07:49','2025-08-26 18:55:14','2025-08-26 18:55:14'),(28,'6KXBQV',11,1,6,6,'Chui','5','M','5','M',NULL,NULL,NULL,'1',24.00,2,10000.00,1,'2025-08-26 17:14:36','2025-08-26 18:55:46','2025-08-26 18:55:46'),(29,'X1OSK4',11,1,6,6,'Chui','5','M','5','M',NULL,NULL,NULL,'1',24.00,2,10000.00,1,'2025-08-26 17:14:44','2025-08-26 17:15:12','2025-08-26 17:15:12'),(30,'LTR62D',11,2,6,7,'5 Mbps','5','M','5','M',NULL,NULL,NULL,'1',30.00,3,10000.00,1,'2025-08-26 17:24:27','2025-08-26 21:41:08','2025-08-26 21:41:08'),(31,'R6Z9YE',8,1,5,8,'saa 1','3','M','3','M',NULL,NULL,NULL,'1',1.00,2,210.00,1,'2025-08-26 18:34:22','2025-08-26 18:35:41',NULL),(32,'LHSBZ6',8,1,5,8,'12h','3','M','3','M',NULL,NULL,NULL,'1',12.00,2,500.00,1,'2025-08-26 18:35:06','2025-08-26 18:35:06',NULL),(33,'Z1QWMR',8,1,5,8,'3 days','3','M','3','M',NULL,NULL,NULL,'1',3.00,3,2500.00,1,'2025-08-26 18:36:38','2025-08-26 18:36:38',NULL),(34,'PDSZU1',8,1,5,8,'24hs','3','M','3','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-08-26 18:37:51','2025-08-26 18:37:51',NULL),(35,'Y2XKDT',8,1,5,8,'7days','03','M','05','M',NULL,NULL,NULL,'1',7.00,3,5000.00,1,'2025-08-26 18:38:54','2025-08-26 18:38:54',NULL),(36,'LOYQE0',8,1,5,8,'2 weeks','3','M','3','M',NULL,NULL,NULL,'1',14.00,3,8000.00,1,'2025-08-26 18:40:14','2025-08-26 18:40:14',NULL),(37,'04YOGN',8,1,5,8,'30 days','3','M','5','M',NULL,NULL,NULL,'1',30.00,3,20000.00,1,'2025-08-26 18:41:01','2025-08-26 18:41:01',NULL),(38,'YEW603',11,1,6,6,'Masaa 6','100','M','100','M',NULL,NULL,NULL,'1',6.00,2,500.00,1,'2025-08-26 18:56:38','2025-08-28 12:57:08',NULL),(39,'F21X6R',11,1,6,6,'Masaa 24','150','M','150','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-08-26 18:58:52','2025-08-28 12:57:25',NULL),(40,'2PGTOV',11,1,6,6,'Siku 7','100','M','100','M',NULL,NULL,NULL,'1',7.00,3,5000.00,1,'2025-08-26 19:00:05','2025-08-28 12:57:46',NULL),(41,'BT1SFP',8,2,5,9,'flash','10','M','10','M',NULL,NULL,NULL,'1',30.00,3,40000.00,1,'2025-08-26 19:37:31','2025-08-26 19:37:31',NULL),(42,'C7SJTZ',8,2,5,9,'swala','5','M','5','M',NULL,NULL,NULL,'1',30.00,3,20000.00,1,'2025-08-26 19:38:42','2025-08-26 19:38:42',NULL),(43,'R4CLS6',13,1,7,10,'Pipi','2','M','5','M',NULL,NULL,NULL,'1',30.00,1,200.00,1,'2025-08-29 20:46:28','2025-08-31 07:25:31','2025-08-31 07:25:31'),(44,'4KDB2L',13,1,7,10,'30 | Nusu saa |','5','M','5','M',NULL,NULL,NULL,'1',30.00,1,200.00,1,'2025-08-31 07:28:52','2025-08-31 07:28:52',NULL),(45,'9ZH6DY',13,1,7,10,'1 Hour','5','M','5','M',NULL,NULL,NULL,'1',1.00,2,300.00,1,'2025-08-31 07:30:35','2025-08-31 07:30:35',NULL),(46,'5IR041',13,1,7,10,'2 Hours','5','M','5','M',NULL,NULL,NULL,'1',2.00,2,400.00,1,'2025-08-31 07:31:43','2025-08-31 07:31:43',NULL),(47,'8SOLGK',13,1,7,10,'4 Hours','8','M','8','M',NULL,NULL,NULL,'1',4.00,2,500.00,1,'2025-08-31 07:33:48','2025-08-31 07:33:48',NULL),(48,'8T6PNO',13,1,7,10,'7 Hours','8','M','8','M',NULL,NULL,NULL,'1',7.00,2,600.00,1,'2025-08-31 07:36:47','2025-08-31 07:36:47',NULL),(49,'25GC3H',13,1,7,10,'8 Hours','8','M','8','M',NULL,NULL,NULL,'1',8.00,2,700.00,1,'2025-08-31 07:38:26','2025-08-31 07:38:26',NULL),(50,'QPVI49',13,1,7,10,'9 Hours','8','M','8','M',NULL,NULL,NULL,'1',9.00,2,800.00,1,'2025-08-31 07:39:40','2025-08-31 07:39:40',NULL),(51,'CM5IHB',13,1,7,10,'12 Hours','8','M','8','M',NULL,NULL,NULL,'1',12.00,2,900.00,1,'2025-08-31 07:44:12','2025-08-31 07:44:12',NULL),(52,'3JX0O4',13,1,7,10,'1 Day','10','M','10','M',NULL,NULL,NULL,'1',1.00,3,1000.00,1,'2025-08-31 07:52:54','2025-08-31 07:52:54',NULL),(53,'3PV8ZA',13,1,7,10,'SIKU MOJA NA NUSU','10','M','10','M',NULL,NULL,NULL,'1',30.00,2,1500.00,1,'2025-08-31 08:13:23','2025-08-31 08:13:23',NULL),(54,'Z7RLWI',13,1,7,10,'3 Days','10','M','10','M',NULL,NULL,NULL,'1',3.00,3,2000.00,1,'2025-08-31 08:14:54','2025-08-31 08:14:54',NULL),(55,'M5FICZ',13,1,7,10,'1 Week','15','M','15','M',NULL,NULL,NULL,'1',7.00,3,4000.00,1,'2025-08-31 08:16:26','2025-08-31 08:16:26',NULL),(56,'VZ2NXP',13,1,7,10,'2 Weeks','15','M','15','M',NULL,NULL,NULL,'1',14.00,3,7500.00,1,'2025-08-31 08:19:55','2025-08-31 08:19:55',NULL),(57,'RMXA0W',13,1,7,10,'3 Weeks','15','M','15','M',NULL,NULL,NULL,'1',21.00,3,12000.00,1,'2025-08-31 08:32:43','2025-08-31 08:32:43',NULL),(58,'BE0OKR',13,1,7,10,'1 Month | Mwezi |','18','M','18','M',NULL,NULL,NULL,'1',28.00,3,15000.00,1,'2025-08-31 08:38:11','2025-08-31 08:38:11',NULL);

--
-- Table structure for table `company_sms`
--

CREATE TABLE `company_sms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `sms_units` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `company_sms_company_id_foreign` (`company_id`),
  CONSTRAINT `company_sms_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_sms`
--


--
-- Table structure for table `company_sms_provider_entities`
--

CREATE TABLE `company_sms_provider_entities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_sms_provider_id` bigint unsigned NOT NULL,
  `requirement_id` int NOT NULL,
  `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`),
  KEY `company_sms_provider_entities_company_sms_provider_id_foreign` (`company_sms_provider_id`),
  CONSTRAINT `company_sms_provider_entities_company_sms_provider_id_foreign` FOREIGN KEY (`company_sms_provider_id`) REFERENCES `company_sms_providers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_sms_provider_entities`
--

INSERT INTO `company_sms_provider_entities` VALUES (1,1,7,'La Zungu','2025-09-01 06:07:22','2025-09-01 06:07:22',NULL),(2,1,8,'1152|z0RRuHr8EQLxtqTMo5WPUNrXJIYYbl5Q2BJpWKiN43a0aece','2025-09-01 06:07:22','2025-09-01 06:07:22',NULL),(3,2,7,'La Zungu','2025-09-01 06:15:21','2025-09-01 06:15:21',NULL),(4,2,8,'1152|z0RRuHr8EQLxtqTMo5WPUNrXJIYYbl5Q2BJpWKiN43a0aece','2025-09-01 06:15:21','2025-09-01 06:15:21',NULL),(5,3,7,'La Zungu','2025-09-01 06:16:04','2025-09-01 06:16:04',NULL),(6,3,8,'1152|z0RRuHr8EQLxtqTMo5WPUNrXJIYYbl5Q2BJpWKiN43a0aece','2025-09-01 06:16:04','2025-09-01 06:16:04',NULL);

--
-- Table structure for table `company_sms_providers`
--

CREATE TABLE `company_sms_providers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `sms_provider_id` bigint unsigned 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`),
  KEY `company_sms_providers_company_id_foreign` (`company_id`),
  KEY `company_sms_providers_sms_provider_id_foreign` (`sms_provider_id`),
  CONSTRAINT `company_sms_providers_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `company_sms_providers_sms_provider_id_foreign` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_sms_providers`
--

INSERT INTO `company_sms_providers` VALUES (1,13,4,1,'2025-09-01 06:06:35','2025-09-01 06:14:22','2025-09-01 06:14:22'),(2,13,4,1,'2025-09-01 06:15:21','2025-09-01 06:15:34','2025-09-01 06:15:34'),(3,13,4,1,'2025-09-01 06:16:04','2025-09-01 06:16:04',NULL);

--
-- Table structure for table `company_sms_templates`
--

CREATE TABLE `company_sms_templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int DEFAULT NULL,
  `sms_template_type_id` bigint unsigned NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '0' COMMENT '0=inactive, 1=active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `company_sms_templates_sms_template_type_id_foreign` (`sms_template_type_id`),
  CONSTRAINT `company_sms_templates_sms_template_type_id_foreign` FOREIGN KEY (`sms_template_type_id`) REFERENCES `sms_template_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_sms_templates`
--

INSERT INTO `company_sms_templates` VALUES (1,0,1,'Dear [name], your internet plan is expiring in [expiry_days] day(s). Kindly make the payment at your earliest convenience to avoid service interruptions. Pay via paybill - [paybill] and account number [account_number]',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(2,0,2,'Dear [name], your invoice for [month] amounting to Ksh [balance] has been generated. Please pay via paybill - [paybill] and account number [account_number]',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(3,0,3,'Hello [name], this is to confirm that we have received your payment of Ksh [amount] for [month]. Your current balance as of now is Ksh [balance]',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(4,0,4,'Dear [name], this is a reminder that your payment of Ksh [balance] for [month] is due. Kindly make the payment at your earliest convenience to avoid service interruptions. Pay via paybill - [paybill] and account number [account_number]',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(5,0,5,'Dear [name], your payment of Ksh [balance] for [month] is overdue. Please settle the outstanding amount immediately to avoid service disruption. Pay via paybill - [paybill] and account number [account_number]',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(6,0,6,'Hello [name], due to an overdue balance of [balance], your service has been disconnected. To restore the services, please pay Ksh [balance] to paybill - [paybill] using account number [account_number]',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(7,0,7,'Hello [name], we are excited to have you on board! Your subscription to [internet_plan] is now active. If you have any questions, feel free to contact us. Thank you',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(8,0,8,'Hello [name], we are excited to have you on board! Your subscription to [internet_plan] is now active. If you have any questions, feel free to contact us.',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(9,0,9,'Dear [name], your request to change your plan to [internet_plan] has been processed successfully. Your new plan is now active. Contact us if you need assistance.',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(10,0,10,'Dear [name], we will be performing maintenance on 1st Jan 2025 from 09:30am to 11:30am. Service may be temporarily affected. Thank you for your patience.',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(11,0,11,'Dear [name], we are aware of an ongoing service disruption in your area. Our team is investigating and will restore service as soon as possible.',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(12,0,12,'Greetings, thank you for purchasing [plan] plan worthy [amount]. Please use [username] as the username and [password] as your password to reconnect yourself. Your subscription expires at [expiry_date].',1,'2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(13,8,11,'Dear [name], we are aware of an ongoing service disruption in your area. Our team is investigating and will restore service as soon as possible.',1,'2025-08-22 21:17:08','2025-08-22 21:17:08',NULL),(14,8,12,'Greetings, thank you for purchasing [plan] plan worthy [amount]. Please use [username] as the username and [password] as your password to reconnect yourself. Your subscription expires at [expiry_date].',1,'2025-08-22 21:20:09','2025-08-22 21:20:09',NULL),(15,11,1,'Dear [name], your internet plan is expiring in [expiry_days] day(s). Kindly make the payment at your earliest convenience to avoid service interruptions. Pay via paybill - [paybill] and account number [account_number]',1,'2025-08-26 17:26:06','2025-08-26 17:26:06',NULL),(16,13,12,'Greetings, thank you for purchasing [plan] plan worthy [amount]. Please use [username] as the username and [password] as your password to reconnect yourself. Your subscription expires at [expiry_date].',1,'2025-08-29 22:04:52','2025-08-29 22:04:52',NULL),(17,13,11,'Dear [name], we are aware of an ongoing service disruption in your area. Our team is investigating and will restore service as soon as possible.',1,'2025-08-29 22:05:13','2025-08-29 22:05:13',NULL),(18,13,10,'Dear [name], we will be performing maintenance on 1st Jan 2025 from 09:30am to 11:30am. Service may be temporarily affected. Thank you for your patience.',1,'2025-08-29 22:05:34','2025-08-29 22:05:34',NULL),(19,13,9,'Dear [name], your request to change your plan to [internet_plan] has been processed successfully. Your new plan is now active. Contact us if you need assistance.',1,'2025-08-29 22:06:16','2025-08-29 22:06:16',NULL),(20,13,8,'Hello [name], we are excited to have you on board! Your subscription to [internet_plan] is now active. If you have any questions, feel free to contact us.',1,'2025-08-29 22:06:24','2025-08-29 22:06:24',NULL),(21,13,7,'Hello [name], we are excited to have you on board! Your subscription to [internet_plan] is now active. If you have any questions, feel free to contact us. Thank you',1,'2025-08-29 22:06:29','2025-08-29 22:06:29',NULL),(22,13,6,'Hello [name], due to an overdue balance of [balance], your service has been disconnected. To restore the services, please pay Ksh [balance] to paybill - [paybill] using account number [account_number]',1,'2025-08-29 22:06:35','2025-08-29 22:06:35',NULL),(23,13,5,'Dear [name], your payment of Ksh [balance] for [month] is overdue. Please settle the outstanding amount immediately to avoid service disruption. Pay via paybill - [paybill] and account number [account_number]',1,'2025-08-29 22:06:40','2025-08-29 22:06:40',NULL),(24,13,4,'Dear [name], this is a reminder that your payment of Ksh [balance] for [month] is due. Kindly make the payment at your earliest convenience to avoid service interruptions. Pay via paybill - [paybill] and account number [account_number]',1,'2025-08-29 22:06:46','2025-08-29 22:06:46',NULL),(25,13,3,'Hello [name], this is to confirm that we have received your payment of Ksh [amount] for [month]. Your current balance as of now is Ksh [balance]',1,'2025-08-29 22:06:51','2025-08-29 22:06:51',NULL),(26,13,2,'Dear [name], your invoice for [month] amounting to Ksh [balance] has been generated. Please pay via paybill - [paybill] and account number [account_number]',1,'2025-08-29 22:07:00','2025-08-29 22:07:00',NULL),(27,13,1,'Dear [name], your internet plan is expiring in [expiry_days] day(s). Kindly make the payment at your earliest convenience to avoid service interruptions. Pay via paybill - [paybill] and account number [account_number]',1,'2025-08-29 22:07:07','2025-08-29 22:07:07',NULL);

--
-- Table structure for table `company_sms_usages`
--

CREATE TABLE `company_sms_usages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `sms_units` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `company_sms_usages_company_id_foreign` (`company_id`),
  CONSTRAINT `company_sms_usages_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_sms_usages`
--


--
-- Table structure for table `company_static_pages`
--

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


--
-- Table structure for table `company_users`
--

CREATE TABLE `company_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned 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`),
  KEY `company_users_company_id_foreign` (`company_id`),
  KEY `company_users_user_id_foreign` (`user_id`),
  CONSTRAINT `company_users_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `company_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_users`
--

INSERT INTO `company_users` VALUES (8,8,15,1,'2025-08-05 16:56:56','2025-08-05 16:56:56',NULL),(11,11,20,1,'2025-08-26 13:06:13','2025-08-26 13:06:13',NULL),(14,13,22,1,'2025-08-29 19:10:58','2025-08-29 19:10:58',NULL),(15,14,23,1,'2025-08-30 06:58:45','2025-08-30 06:58:45',NULL),(16,8,24,1,'2025-08-31 22:17:44','2025-08-31 22:17:44',NULL);

--
-- Table structure for table `company_whatsapp_scans`
--

CREATE TABLE `company_whatsapp_scans` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int DEFAULT NULL,
  `phone` 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_whatsapp_scans`
--


--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0' COMMENT '0=pending, 1=sent',
  `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 `customers`
--

INSERT INTO `customers` VALUES (1,'+2547222222222',NULL,NULL,NULL,0,'2025-08-11 23:41:45','2025-08-11 23:41:59','2025-08-11 23:41:59'),(2,NULL,NULL,NULL,NULL,0,'2025-08-11 23:43:58','2025-08-26 13:45:45',NULL);

--
-- Table structure for table `director_share_incomes`
--

CREATE TABLE `director_share_incomes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `director_share_id` bigint unsigned NOT NULL,
  `grouped_transaction_id` bigint unsigned NOT NULL,
  `percentage_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `settled_status` int NOT NULL DEFAULT '0' COMMENT '0=pending, 1=sent',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `director_share_incomes_director_share_id_foreign` (`director_share_id`),
  KEY `director_share_incomes_grouped_transaction_id_foreign` (`grouped_transaction_id`),
  CONSTRAINT `director_share_incomes_director_share_id_foreign` FOREIGN KEY (`director_share_id`) REFERENCES `director_shares` (`id`) ON DELETE CASCADE,
  CONSTRAINT `director_share_incomes_grouped_transaction_id_foreign` FOREIGN KEY (`grouped_transaction_id`) REFERENCES `grouped_transactions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `director_share_incomes`
--

INSERT INTO `director_share_incomes` VALUES (1,1,1,50.00,10500.00,0,'2025-08-28 06:42:22','2025-08-28 06:42:22',NULL);

--
-- Table structure for table `director_share_payment_accounts`
--

CREATE TABLE `director_share_payment_accounts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `director_share_id` bigint unsigned NOT NULL,
  `payment_method_id` bigint unsigned NOT NULL,
  `bank_id` bigint unsigned DEFAULT NULL,
  `phone_account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 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`),
  KEY `director_share_payment_accounts_director_share_id_foreign` (`director_share_id`),
  KEY `director_share_payment_accounts_payment_method_id_foreign` (`payment_method_id`),
  KEY `director_share_payment_accounts_bank_id_foreign` (`bank_id`),
  CONSTRAINT `director_share_payment_accounts_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `director_share_payment_accounts_director_share_id_foreign` FOREIGN KEY (`director_share_id`) REFERENCES `director_shares` (`id`) ON DELETE CASCADE,
  CONSTRAINT `director_share_payment_accounts_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `director_share_payment_accounts`
--


--
-- Table structure for table `director_shares`
--

CREATE TABLE `director_shares` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `names` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `percentage_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `status` int NOT NULL DEFAULT '1',
  `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 `director_shares`
--

INSERT INTO `director_shares` VALUES (1,'DS001','Jared Maera','+254716100572','maerajared12@gmail.com',50.00,1,'2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(2,'DS002','Dennis Bogonko','+254720579706','bogonkomokaya92@gmail.com',30.00,1,'2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(3,'DS003','Jaem Net','0716327828','info@jaemnet.com',20.00,1,'2025-08-03 19:10:08','2025-08-03 19:10:08',NULL);

--
-- Table structure for table `escrow_transactions`
--

CREATE TABLE `escrow_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` int DEFAULT NULL,
  `company_router_id` int DEFAULT 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 `escrow_transactions_payment_mode_id_foreign` (`payment_mode_id`),
  CONSTRAINT `escrow_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 `escrow_transactions`
--


--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expenses`
--


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

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

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


--
-- Table structure for table `failed_transactions`
--

CREATE TABLE `failed_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payment_mode_id` bigint unsigned NOT NULL,
  `checkout_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `failed_transactions_payment_mode_id_foreign` (`payment_mode_id`),
  CONSTRAINT `failed_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 `failed_transactions`
--


--
-- Table structure for table `grouped_transactions`
--

CREATE TABLE `grouped_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_type` int NOT NULL DEFAULT '1' COMMENT '1=invoice, 2=sms',
  `unit_sms_price` decimal(8,2) NOT NULL DEFAULT '0.00',
  `provider_sms_price` decimal(8,2) NOT NULL DEFAULT '0.00',
  `company_id` bigint unsigned NOT NULL,
  `company_router_id` int DEFAULT NULL,
  `user_id` int DEFAULT 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 `grouped_transactions_company_id_foreign` (`company_id`),
  KEY `grouped_transactions_payment_mode_id_foreign` (`payment_mode_id`),
  CONSTRAINT `grouped_transactions_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `grouped_transactions_payment_mode_id_foreign` FOREIGN KEY (`payment_mode_id`) REFERENCES `payment_modes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grouped_transactions`
--

INSERT INTO `grouped_transactions` VALUES (1,'8I42E6',1,0.00,0.00,11,6,1,2,NULL,'THR178AWB',21000.00,NULL,NULL,'2025-08-28 06:42:22','2025-08-28 06:42:22',NULL);

--
-- Table structure for table `ip_prefix_lengths`
--

CREATE TABLE `ip_prefix_lengths` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prefix` 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=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ip_prefix_lengths`
--

INSERT INTO `ip_prefix_lengths` VALUES (1,'8 (16,777,214 IPs)','8','2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(2,'12 (1,048,574 IPs)','12','2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(3,'16 (65,534 IPs)','16','2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(4,'20 (4,094 IPs)','20','2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(5,'24 (254 IPs)','24','2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(6,'28 (14 IPs)','28','2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(7,'30 (2 IPs)','30','2025-08-03 19:10:09','2025-08-03 19:10:09',NULL),(8,'32 (1 IP)','32','2025-08-03 19:10:09','2025-08-03 19:10:09',NULL);

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

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

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


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

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

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

INSERT INTO `jobs` VALUES (1,'default','{\"uuid\":\"864014d8-f513-419a-9600-d560ff7ae7a8\",\"displayName\":\"App\\\\Jobs\\\\SendMessages\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendMessages\",\"command\":\"O:21:\\\"App\\\\Jobs\\\\SendMessages\\\":2:{s:10:\\\"\\u0000*\\u0000payload\\\";a:6:{s:9:\\\"sessionId\\\";i:0;s:15:\\\"message_mode_id\\\";s:1:\\\"1\\\";s:7:\\\"company\\\";i:0;s:7:\\\"message\\\";s:114:\\\"Dear Ben, your invoice for Aug amounting to Ksh  has been generated. Please pay via paybill -  and account number \\\";s:8:\\\"filename\\\";s:0:\\\"\\\";s:5:\\\"phone\\\";s:7:\\\"0745678\\\";}s:5:\\\"delay\\\";O:13:\\\"Carbon\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-08-12 10:53:44.362541\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:14:\\\"Africa\\/Nairobi\\\";}}\"}}',0,NULL,1754985224,1754985204),(2,'default','{\"uuid\":\"c1587e1d-4d6f-4586-a6fc-24955aded68a\",\"displayName\":\"App\\\\Jobs\\\\SendMessages\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendMessages\",\"command\":\"O:21:\\\"App\\\\Jobs\\\\SendMessages\\\":2:{s:10:\\\"\\u0000*\\u0000payload\\\";a:6:{s:9:\\\"sessionId\\\";i:0;s:15:\\\"message_mode_id\\\";s:1:\\\"1\\\";s:7:\\\"company\\\";i:0;s:7:\\\"message\\\";s:116:\\\"Dear Erick, your invoice for Aug amounting to Ksh  has been generated. Please pay via paybill -  and account number \\\";s:8:\\\"filename\\\";s:0:\\\"\\\";s:5:\\\"phone\\\";s:10:\\\"0763752350\\\";}s:5:\\\"delay\\\";O:13:\\\"Carbon\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-08-12 10:53:44.495011\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:14:\\\"Africa\\/Nairobi\\\";}}\"}}',0,NULL,1754985224,1754985204),(3,'default','{\"uuid\":\"64d42b36-cefe-4579-a9d1-6a9025ea9ee1\",\"displayName\":\"App\\\\Jobs\\\\SendMessages\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendMessages\",\"command\":\"O:21:\\\"App\\\\Jobs\\\\SendMessages\\\":2:{s:10:\\\"\\u0000*\\u0000payload\\\";a:6:{s:9:\\\"sessionId\\\";i:0;s:15:\\\"message_mode_id\\\";s:1:\\\"3\\\";s:7:\\\"company\\\";O:18:\\\"App\\\\Models\\\\Company\\\":31:{s:13:\\\"\\u0000*\\u0000connection\\\";s:5:\\\"mysql\\\";s:8:\\\"\\u0000*\\u0000table\\\";s:9:\\\"companies\\\";s:13:\\\"\\u0000*\\u0000primaryKey\\\";s:2:\\\"id\\\";s:10:\\\"\\u0000*\\u0000keyType\\\";s:3:\\\"int\\\";s:12:\\\"incrementing\\\";b:1;s:7:\\\"\\u0000*\\u0000with\\\";a:0:{}s:12:\\\"\\u0000*\\u0000withCount\\\";a:0:{}s:19:\\\"preventsLazyLoading\\\";b:0;s:10:\\\"\\u0000*\\u0000perPage\\\";i:15;s:6:\\\"exists\\\";b:1;s:18:\\\"wasRecentlyCreated\\\";b:0;s:28:\\\"\\u0000*\\u0000escapeWhenCastingToString\\\";b:0;s:13:\\\"\\u0000*\\u0000attributes\\\";a:16:{s:2:\\\"id\\\";i:13;s:6:\\\"ref_no\\\";s:6:\\\"9BYRSA\\\";s:7:\\\"user_id\\\";i:22;s:4:\\\"name\\\";s:18:\\\"La Zungu Creations\\\";s:5:\\\"phone\\\";s:10:\\\"0754578434\\\";s:5:\\\"email\\\";s:21:\\\"karnsinkazy@gmail.com\\\";s:11:\\\"box_address\\\";N;s:8:\\\"location\\\";s:9:\\\"Daresalam\\\";s:8:\\\"latitude\\\";N;s:9:\\\"longitude\\\";N;s:4:\\\"logo\\\";s:45:\\\"kJuzfMRNZoWZd9KwMsXAjfFMIgCv3hHbEVRw9HWq.webp\\\";s:24:\\\"subscription_expiry_date\\\";N;s:6:\\\"status\\\";i:1;s:10:\\\"created_at\\\";s:19:\\\"2025-08-29 21:10:58\\\";s:10:\\\"updated_at\\\";s:19:\\\"2025-08-29 22:20:17\\\";s:10:\\\"deleted_at\\\";N;}s:11:\\\"\\u0000*\\u0000original\\\";a:16:{s:2:\\\"id\\\";i:13;s:6:\\\"ref_no\\\";s:6:\\\"9BYRSA\\\";s:7:\\\"user_id\\\";i:22;s:4:\\\"name\\\";s:18:\\\"La Zungu Creations\\\";s:5:\\\"phone\\\";s:10:\\\"0754578434\\\";s:5:\\\"email\\\";s:21:\\\"karnsinkazy@gmail.com\\\";s:11:\\\"box_address\\\";N;s:8:\\\"location\\\";s:9:\\\"Daresalam\\\";s:8:\\\"latitude\\\";N;s:9:\\\"longitude\\\";N;s:4:\\\"logo\\\";s:45:\\\"kJuzfMRNZoWZd9KwMsXAjfFMIgCv3hHbEVRw9HWq.webp\\\";s:24:\\\"subscription_expiry_date\\\";N;s:6:\\\"status\\\";i:1;s:10:\\\"created_at\\\";s:19:\\\"2025-08-29 21:10:58\\\";s:10:\\\"updated_at\\\";s:19:\\\"2025-08-29 22:20:17\\\";s:10:\\\"deleted_at\\\";N;}s:10:\\\"\\u0000*\\u0000changes\\\";a:0:{}s:8:\\\"\\u0000*\\u0000casts\\\";a:1:{s:10:\\\"deleted_at\\\";s:8:\\\"datetime\\\";}s:17:\\\"\\u0000*\\u0000classCastCache\\\";a:0:{}s:21:\\\"\\u0000*\\u0000attributeCastCache\\\";a:0:{}s:13:\\\"\\u0000*\\u0000dateFormat\\\";N;s:10:\\\"\\u0000*\\u0000appends\\\";a:0:{}s:19:\\\"\\u0000*\\u0000dispatchesEvents\\\";a:0:{}s:14:\\\"\\u0000*\\u0000observables\\\";a:0:{}s:12:\\\"\\u0000*\\u0000relations\\\";a:2:{s:21:\\\"companyPaymentAccount\\\";O:32:\\\"App\\\\Models\\\\CompanyPaymentAccount\\\":31:{s:13:\\\"\\u0000*\\u0000connection\\\";s:5:\\\"mysql\\\";s:8:\\\"\\u0000*\\u0000table\\\";s:24:\\\"company_payment_accounts\\\";s:13:\\\"\\u0000*\\u0000primaryKey\\\";s:2:\\\"id\\\";s:10:\\\"\\u0000*\\u0000keyType\\\";s:3:\\\"int\\\";s:12:\\\"incrementing\\\";b:1;s:7:\\\"\\u0000*\\u0000with\\\";a:0:{}s:12:\\\"\\u0000*\\u0000withCount\\\";a:0:{}s:19:\\\"preventsLazyLoading\\\";b:0;s:10:\\\"\\u0000*\\u0000perPage\\\";i:15;s:6:\\\"exists\\\";b:1;s:18:\\\"wasRecentlyCreated\\\";b:0;s:28:\\\"\\u0000*\\u0000escapeWhenCastingToString\\\";b:0;s:13:\\\"\\u0000*\\u0000attributes\\\";a:9:{s:2:\\\"id\\\";i:5;s:10:\\\"company_id\\\";i:13;s:17:\\\"company_router_id\\\";i:7;s:6:\\\"ref_no\\\";s:6:\\\"HI023B\\\";s:14:\\\"selcom_api_key\\\";s:86:\\\"ivnQEneyuX6VgUKFkbMKyEbtCYzPtM6Xzxdf3jp-sCus-jJtJxMjQUY10awhjrAN3RG1wNlM7OhbT3U55h2P9w\\\";s:6:\\\"status\\\";i:1;s:10:\\\"created_at\\\";s:19:\\\"2025-08-29 22:27:58\\\";s:10:\\\"updated_at\\\";s:19:\\\"2025-08-29 22:27:58\\\";s:10:\\\"deleted_at\\\";N;}s:11:\\\"\\u0000*\\u0000original\\\";a:9:{s:2:\\\"id\\\";i:5;s:10:\\\"company_id\\\";i:13;s:17:\\\"company_router_id\\\";i:7;s:6:\\\"ref_no\\\";s:6:\\\"HI023B\\\";s:14:\\\"selcom_api_key\\\";s:86:\\\"ivnQEneyuX6VgUKFkbMKyEbtCYzPtM6Xzxdf3jp-sCus-jJtJxMjQUY10awhjrAN3RG1wNlM7OhbT3U55h2P9w\\\";s:6:\\\"status\\\";i:1;s:10:\\\"created_at\\\";s:19:\\\"2025-08-29 22:27:58\\\";s:10:\\\"updated_at\\\";s:19:\\\"2025-08-29 22:27:58\\\";s:10:\\\"deleted_at\\\";N;}s:10:\\\"\\u0000*\\u0000changes\\\";a:0:{}s:8:\\\"\\u0000*\\u0000casts\\\";a:1:{s:10:\\\"deleted_at\\\";s:8:\\\"datetime\\\";}s:17:\\\"\\u0000*\\u0000classCastCache\\\";a:0:{}s:21:\\\"\\u0000*\\u0000attributeCastCache\\\";a:0:{}s:13:\\\"\\u0000*\\u0000dateFormat\\\";N;s:10:\\\"\\u0000*\\u0000appends\\\";a:0:{}s:19:\\\"\\u0000*\\u0000dispatchesEvents\\\";a:0:{}s:14:\\\"\\u0000*\\u0000observables\\\";a:0:{}s:12:\\\"\\u0000*\\u0000relations\\\";a:0:{}s:10:\\\"\\u0000*\\u0000touches\\\";a:0:{}s:10:\\\"timestamps\\\";b:1;s:13:\\\"usesUniqueIds\\\";b:0;s:9:\\\"\\u0000*\\u0000hidden\\\";a:0:{}s:10:\\\"\\u0000*\\u0000visible\\\";a:0:{}s:11:\\\"\\u0000*\\u0000fillable\\\";a:5:{i:0;s:10:\\\"company_id\\\";i:1;s:17:\\\"company_router_id\\\";i:2;s:6:\\\"ref_no\\\";i:3;s:14:\\\"selcom_api_key\\\";i:4;s:6:\\\"status\\\";}s:10:\\\"\\u0000*\\u0000guarded\\\";a:1:{i:0;s:1:\\\"*\\\";}s:16:\\\"\\u0000*\\u0000forceDeleting\\\";b:0;}s:18:\\\"companySmsProvider\\\";N;}s:10:\\\"\\u0000*\\u0000touches\\\";a:0:{}s:10:\\\"timestamps\\\";b:1;s:13:\\\"usesUniqueIds\\\";b:0;s:9:\\\"\\u0000*\\u0000hidden\\\";a:0:{}s:10:\\\"\\u0000*\\u0000visible\\\";a:0:{}s:11:\\\"\\u0000*\\u0000fillable\\\";a:12:{i:0;s:6:\\\"ref_no\\\";i:1;s:7:\\\"user_id\\\";i:2;s:4:\\\"name\\\";i:3;s:5:\\\"phone\\\";i:4;s:5:\\\"email\\\";i:5;s:11:\\\"box_address\\\";i:6;s:8:\\\"location\\\";i:7;s:8:\\\"latitude\\\";i:8;s:9:\\\"longitude\\\";i:9;s:4:\\\"logo\\\";i:10;s:24:\\\"subscription_expiry_date\\\";i:11;s:6:\\\"status\\\";}s:10:\\\"\\u0000*\\u0000guarded\\\";a:1:{i:0;s:1:\\\"*\\\";}s:16:\\\"\\u0000*\\u0000forceDeleting\\\";b:0;}s:7:\\\"message\\\";s:222:\\\"Dear 8E:E0:2B:0F:11:26, this is a reminder that your payment of Ksh 0 for Aug is due. Kindly make the payment at your earliest convenience to avoid service interruptions. Pay via paybill - 4157595 and account number W8HE0K\\\";s:8:\\\"filename\\\";s:0:\\\"\\\";s:5:\\\"phone\\\";s:12:\\\"255754578434\\\";}s:5:\\\"delay\\\";O:13:\\\"Carbon\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-08-29 22:59:45.162308\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:14:\\\"Africa\\/Nairobi\\\";}}\"}}',0,NULL,1756497585,1756497565),(4,'default','{\"uuid\":\"23c926f7-33f5-4a4c-a3a8-c2226baf8731\",\"displayName\":\"App\\\\Jobs\\\\SendMessages\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendMessages\",\"command\":\"O:21:\\\"App\\\\Jobs\\\\SendMessages\\\":2:{s:10:\\\"\\u0000*\\u0000payload\\\";a:6:{s:9:\\\"sessionId\\\";i:0;s:15:\\\"message_mode_id\\\";s:1:\\\"3\\\";s:7:\\\"company\\\";O:18:\\\"App\\\\Models\\\\Company\\\":31:{s:13:\\\"\\u0000*\\u0000connection\\\";s:5:\\\"mysql\\\";s:8:\\\"\\u0000*\\u0000table\\\";s:9:\\\"companies\\\";s:13:\\\"\\u0000*\\u0000primaryKey\\\";s:2:\\\"id\\\";s:10:\\\"\\u0000*\\u0000keyType\\\";s:3:\\\"int\\\";s:12:\\\"incrementing\\\";b:1;s:7:\\\"\\u0000*\\u0000with\\\";a:0:{}s:12:\\\"\\u0000*\\u0000withCount\\\";a:0:{}s:19:\\\"preventsLazyLoading\\\";b:0;s:10:\\\"\\u0000*\\u0000perPage\\\";i:15;s:6:\\\"exists\\\";b:1;s:18:\\\"wasRecentlyCreated\\\";b:0;s:28:\\\"\\u0000*\\u0000escapeWhenCastingToString\\\";b:0;s:13:\\\"\\u0000*\\u0000attributes\\\";a:16:{s:2:\\\"id\\\";i:13;s:6:\\\"ref_no\\\";s:6:\\\"9BYRSA\\\";s:7:\\\"user_id\\\";i:22;s:4:\\\"name\\\";s:18:\\\"La Zungu Creations\\\";s:5:\\\"phone\\\";s:10:\\\"0754578434\\\";s:5:\\\"email\\\";s:21:\\\"karnsinkazy@gmail.com\\\";s:11:\\\"box_address\\\";N;s:8:\\\"location\\\";s:9:\\\"Daresalam\\\";s:8:\\\"latitude\\\";N;s:9:\\\"longitude\\\";N;s:4:\\\"logo\\\";s:45:\\\"kJuzfMRNZoWZd9KwMsXAjfFMIgCv3hHbEVRw9HWq.webp\\\";s:24:\\\"subscription_expiry_date\\\";N;s:6:\\\"status\\\";i:1;s:10:\\\"created_at\\\";s:19:\\\"2025-08-29 21:10:58\\\";s:10:\\\"updated_at\\\";s:19:\\\"2025-08-29 22:20:17\\\";s:10:\\\"deleted_at\\\";N;}s:11:\\\"\\u0000*\\u0000original\\\";a:16:{s:2:\\\"id\\\";i:13;s:6:\\\"ref_no\\\";s:6:\\\"9BYRSA\\\";s:7:\\\"user_id\\\";i:22;s:4:\\\"name\\\";s:18:\\\"La Zungu Creations\\\";s:5:\\\"phone\\\";s:10:\\\"0754578434\\\";s:5:\\\"email\\\";s:21:\\\"karnsinkazy@gmail.com\\\";s:11:\\\"box_address\\\";N;s:8:\\\"location\\\";s:9:\\\"Daresalam\\\";s:8:\\\"latitude\\\";N;s:9:\\\"longitude\\\";N;s:4:\\\"logo\\\";s:45:\\\"kJuzfMRNZoWZd9KwMsXAjfFMIgCv3hHbEVRw9HWq.webp\\\";s:24:\\\"subscription_expiry_date\\\";N;s:6:\\\"status\\\";i:1;s:10:\\\"created_at\\\";s:19:\\\"2025-08-29 21:10:58\\\";s:10:\\\"updated_at\\\";s:19:\\\"2025-08-29 22:20:17\\\";s:10:\\\"deleted_at\\\";N;}s:10:\\\"\\u0000*\\u0000changes\\\";a:0:{}s:8:\\\"\\u0000*\\u0000casts\\\";a:1:{s:10:\\\"deleted_at\\\";s:8:\\\"datetime\\\";}s:17:\\\"\\u0000*\\u0000classCastCache\\\";a:0:{}s:21:\\\"\\u0000*\\u0000attributeCastCache\\\";a:0:{}s:13:\\\"\\u0000*\\u0000dateFormat\\\";N;s:10:\\\"\\u0000*\\u0000appends\\\";a:0:{}s:19:\\\"\\u0000*\\u0000dispatchesEvents\\\";a:0:{}s:14:\\\"\\u0000*\\u0000observables\\\";a:0:{}s:12:\\\"\\u0000*\\u0000relations\\\";a:2:{s:21:\\\"companyPaymentAccount\\\";O:32:\\\"App\\\\Models\\\\CompanyPaymentAccount\\\":31:{s:13:\\\"\\u0000*\\u0000connection\\\";s:5:\\\"mysql\\\";s:8:\\\"\\u0000*\\u0000table\\\";s:24:\\\"company_payment_accounts\\\";s:13:\\\"\\u0000*\\u0000primaryKey\\\";s:2:\\\"id\\\";s:10:\\\"\\u0000*\\u0000keyType\\\";s:3:\\\"int\\\";s:12:\\\"incrementing\\\";b:1;s:7:\\\"\\u0000*\\u0000with\\\";a:0:{}s:12:\\\"\\u0000*\\u0000withCount\\\";a:0:{}s:19:\\\"preventsLazyLoading\\\";b:0;s:10:\\\"\\u0000*\\u0000perPage\\\";i:15;s:6:\\\"exists\\\";b:1;s:18:\\\"wasRecentlyCreated\\\";b:0;s:28:\\\"\\u0000*\\u0000escapeWhenCastingToString\\\";b:0;s:13:\\\"\\u0000*\\u0000attributes\\\";a:9:{s:2:\\\"id\\\";i:5;s:10:\\\"company_id\\\";i:13;s:17:\\\"company_router_id\\\";i:7;s:6:\\\"ref_no\\\";s:6:\\\"HI023B\\\";s:14:\\\"selcom_api_key\\\";s:86:\\\"ivnQEneyuX6VgUKFkbMKyEbtCYzPtM6Xzxdf3jp-sCus-jJtJxMjQUY10awhjrAN3RG1wNlM7OhbT3U55h2P9w\\\";s:6:\\\"status\\\";i:1;s:10:\\\"created_at\\\";s:19:\\\"2025-08-29 22:27:58\\\";s:10:\\\"updated_at\\\";s:19:\\\"2025-08-29 22:27:58\\\";s:10:\\\"deleted_at\\\";N;}s:11:\\\"\\u0000*\\u0000original\\\";a:9:{s:2:\\\"id\\\";i:5;s:10:\\\"company_id\\\";i:13;s:17:\\\"company_router_id\\\";i:7;s:6:\\\"ref_no\\\";s:6:\\\"HI023B\\\";s:14:\\\"selcom_api_key\\\";s:86:\\\"ivnQEneyuX6VgUKFkbMKyEbtCYzPtM6Xzxdf3jp-sCus-jJtJxMjQUY10awhjrAN3RG1wNlM7OhbT3U55h2P9w\\\";s:6:\\\"status\\\";i:1;s:10:\\\"created_at\\\";s:19:\\\"2025-08-29 22:27:58\\\";s:10:\\\"updated_at\\\";s:19:\\\"2025-08-29 22:27:58\\\";s:10:\\\"deleted_at\\\";N;}s:10:\\\"\\u0000*\\u0000changes\\\";a:0:{}s:8:\\\"\\u0000*\\u0000casts\\\";a:1:{s:10:\\\"deleted_at\\\";s:8:\\\"datetime\\\";}s:17:\\\"\\u0000*\\u0000classCastCache\\\";a:0:{}s:21:\\\"\\u0000*\\u0000attributeCastCache\\\";a:0:{}s:13:\\\"\\u0000*\\u0000dateFormat\\\";N;s:10:\\\"\\u0000*\\u0000appends\\\";a:0:{}s:19:\\\"\\u0000*\\u0000dispatchesEvents\\\";a:0:{}s:14:\\\"\\u0000*\\u0000observables\\\";a:0:{}s:12:\\\"\\u0000*\\u0000relations\\\";a:0:{}s:10:\\\"\\u0000*\\u0000touches\\\";a:0:{}s:10:\\\"timestamps\\\";b:1;s:13:\\\"usesUniqueIds\\\";b:0;s:9:\\\"\\u0000*\\u0000hidden\\\";a:0:{}s:10:\\\"\\u0000*\\u0000visible\\\";a:0:{}s:11:\\\"\\u0000*\\u0000fillable\\\";a:5:{i:0;s:10:\\\"company_id\\\";i:1;s:17:\\\"company_router_id\\\";i:2;s:6:\\\"ref_no\\\";i:3;s:14:\\\"selcom_api_key\\\";i:4;s:6:\\\"status\\\";}s:10:\\\"\\u0000*\\u0000guarded\\\";a:1:{i:0;s:1:\\\"*\\\";}s:16:\\\"\\u0000*\\u0000forceDeleting\\\";b:0;}s:18:\\\"companySmsProvider\\\";N;}s:10:\\\"\\u0000*\\u0000touches\\\";a:0:{}s:10:\\\"timestamps\\\";b:1;s:13:\\\"usesUniqueIds\\\";b:0;s:9:\\\"\\u0000*\\u0000hidden\\\";a:0:{}s:10:\\\"\\u0000*\\u0000visible\\\";a:0:{}s:11:\\\"\\u0000*\\u0000fillable\\\";a:12:{i:0;s:6:\\\"ref_no\\\";i:1;s:7:\\\"user_id\\\";i:2;s:4:\\\"name\\\";i:3;s:5:\\\"phone\\\";i:4;s:5:\\\"email\\\";i:5;s:11:\\\"box_address\\\";i:6;s:8:\\\"location\\\";i:7;s:8:\\\"latitude\\\";i:8;s:9:\\\"longitude\\\";i:9;s:4:\\\"logo\\\";i:10;s:24:\\\"subscription_expiry_date\\\";i:11;s:6:\\\"status\\\";}s:10:\\\"\\u0000*\\u0000guarded\\\";a:1:{i:0;s:1:\\\"*\\\";}s:16:\\\"\\u0000*\\u0000forceDeleting\\\";b:0;}s:7:\\\"message\\\";s:138:\\\"Dear , we are aware of an ongoing service disruption in your area. Our team is investigating and will restore service as soon as possible.\\\";s:8:\\\"filename\\\";s:0:\\\"\\\";s:5:\\\"phone\\\";s:12:\\\"255754578434\\\";}s:5:\\\"delay\\\";O:13:\\\"Carbon\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-08-30 09:57:04.938817\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:14:\\\"Africa\\/Nairobi\\\";}}\"}}',0,NULL,1756537024,1756537004),(5,'default','{\"uuid\":\"4a6e4c40-2790-4bd4-a207-50999c488e6e\",\"displayName\":\"App\\\\Jobs\\\\SendMessages\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendMessages\",\"command\":\"O:21:\\\"App\\\\Jobs\\\\SendMessages\\\":2:{s:10:\\\"\\u0000*\\u0000payload\\\";a:7:{s:9:\\\"sessionId\\\";i:0;s:15:\\\"message_mode_id\\\";s:1:\\\"2\\\";s:7:\\\"company\\\";O:18:\\\"App\\\\Models\\\\Company\\\":31:{s:13:\\\"\\u0000*\\u0000connection\\\";s:5:\\\"mysql\\\";s:8:\\\"\\u0000*\\u0000table\\\";s:9:\\\"companies\\\";s:13:\\\"\\u0000*\\u0000primaryKey\\\";s:2:\\\"id\\\";s:10:\\\"\\u0000*\\u0000keyType\\\";s:3:\\\"int\\\";s:12:\\\"incrementing\\\";b:1;s:7:\\\"\\u0000*\\u0000with\\\";a:0:{}s:12:\\\"\\u0000*\\u0000withCount\\\";a:0:{}s:19:\\\"preventsLazyLoading\\\";b:0;s:10:\\\"\\u0000*\\u0000perPage\\\";i:15;s:6:\\\"exists\\\";b:1;s:18:\\\"wasRecentlyCreated\\\";b:0;s:28:\\\"\\u0000*\\u0000escapeWhenCastingToString\\\";b:0;s:13:\\\"\\u0000*\\u0000attributes\\\";a:16:{s:2:\\\"id\\\";i:13;s:6:\\\"ref_no\\\";s:6:\\\"9BYRSA\\\";s:7:\\\"user_id\\\";i:22;s:4:\\\"name\\\";s:18:\\\"La Zungu Creations\\\";s:5:\\\"phone\\\";s:10:\\\"0754578434\\\";s:5:\\\"email\\\";s:21:\\\"karnsinkazy@gmail.com\\\";s:11:\\\"box_address\\\";N;s:8:\\\"location\\\";s:9:\\\"Daresalam\\\";s:8:\\\"latitude\\\";N;s:9:\\\"longitude\\\";N;s:4:\\\"logo\\\";s:45:\\\"kJuzfMRNZoWZd9KwMsXAjfFMIgCv3hHbEVRw9HWq.webp\\\";s:24:\\\"subscription_expiry_date\\\";N;s:6:\\\"status\\\";i:1;s:10:\\\"created_at\\\";s:19:\\\"2025-08-29 21:10:58\\\";s:10:\\\"updated_at\\\";s:19:\\\"2025-08-29 22:20:17\\\";s:10:\\\"deleted_at\\\";N;}s:11:\\\"\\u0000*\\u0000original\\\";a:16:{s:2:\\\"id\\\";i:13;s:6:\\\"ref_no\\\";s:6:\\\"9BYRSA\\\";s:7:\\\"user_id\\\";i:22;s:4:\\\"name\\\";s:18:\\\"La Zungu Creations\\\";s:5:\\\"phone\\\";s:10:\\\"0754578434\\\";s:5:\\\"email\\\";s:21:\\\"karnsinkazy@gmail.com\\\";s:11:\\\"box_address\\\";N;s:8:\\\"location\\\";s:9:\\\"Daresalam\\\";s:8:\\\"latitude\\\";N;s:9:\\\"longitude\\\";N;s:4:\\\"logo\\\";s:45:\\\"kJuzfMRNZoWZd9KwMsXAjfFMIgCv3hHbEVRw9HWq.webp\\\";s:24:\\\"subscription_expiry_date\\\";N;s:6:\\\"status\\\";i:1;s:10:\\\"created_at\\\";s:19:\\\"2025-08-29 21:10:58\\\";s:10:\\\"updated_at\\\";s:19:\\\"2025-08-29 22:20:17\\\";s:10:\\\"deleted_at\\\";N;}s:10:\\\"\\u0000*\\u0000changes\\\";a:0:{}s:8:\\\"\\u0000*\\u0000casts\\\";a:1:{s:10:\\\"deleted_at\\\";s:8:\\\"datetime\\\";}s:17:\\\"\\u0000*\\u0000classCastCache\\\";a:0:{}s:21:\\\"\\u0000*\\u0000attributeCastCache\\\";a:0:{}s:13:\\\"\\u0000*\\u0000dateFormat\\\";N;s:10:\\\"\\u0000*\\u0000appends\\\";a:0:{}s:19:\\\"\\u0000*\\u0000dispatchesEvents\\\";a:0:{}s:14:\\\"\\u0000*\\u0000observables\\\";a:0:{}s:12:\\\"\\u0000*\\u0000relations\\\";a:0:{}s:10:\\\"\\u0000*\\u0000touches\\\";a:0:{}s:10:\\\"timestamps\\\";b:1;s:13:\\\"usesUniqueIds\\\";b:0;s:9:\\\"\\u0000*\\u0000hidden\\\";a:0:{}s:10:\\\"\\u0000*\\u0000visible\\\";a:0:{}s:11:\\\"\\u0000*\\u0000fillable\\\";a:12:{i:0;s:6:\\\"ref_no\\\";i:1;s:7:\\\"user_id\\\";i:2;s:4:\\\"name\\\";i:3;s:5:\\\"phone\\\";i:4;s:5:\\\"email\\\";i:5;s:11:\\\"box_address\\\";i:6;s:8:\\\"location\\\";i:7;s:8:\\\"latitude\\\";i:8;s:9:\\\"longitude\\\";i:9;s:4:\\\"logo\\\";i:10;s:24:\\\"subscription_expiry_date\\\";i:11;s:6:\\\"status\\\";}s:10:\\\"\\u0000*\\u0000guarded\\\";a:1:{i:0;s:1:\\\"*\\\";}s:16:\\\"\\u0000*\\u0000forceDeleting\\\";b:0;}s:7:\\\"message\\\";N;s:8:\\\"filename\\\";s:0:\\\"\\\";s:5:\\\"title\\\";N;s:5:\\\"email\\\";N;}s:5:\\\"delay\\\";O:13:\\\"Carbon\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2025-08-31 22:57:23.687941\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:14:\\\"Africa\\/Nairobi\\\";}}\"}}',0,NULL,1756670243,1756670223);

--
-- 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),(2,'App\\Models\\User',24);

--
-- 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);

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

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

INSERT INTO `notifications` VALUES (3897,13,NULL,'Mikrotik Router Down','⚠️ Hi Kazungu, your mikrotik router - La Zungu is offline. Please check it out.',1,'2025-09-01 08:00:23','2025-09-01 14:55:04'),(3898,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',1,'2025-09-01 08:05:20','2025-09-01 11:50:44'),(3899,11,NULL,'Mikrotik Router Up','✅ Hi Mwamba Cosmetics, your mikrotik router - Mwamba is back online.',1,'2025-09-01 08:18:07','2025-09-01 10:28:52'),(3900,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-09-01 11:03:07','2025-09-01 12:07:48'),(3901,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',1,'2025-09-01 11:06:04','2025-09-01 12:07:04'),(3902,11,NULL,'Mikrotik Router Down','⚠️ Hi Mwamba Cosmetics, your mikrotik router - Mwamba is offline. Please check it out.',0,'2025-09-01 11:12:08','2025-09-01 11:12:08'),(3903,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 2 is back online.',1,'2025-09-01 11:24:04','2025-09-01 12:06:51'),(3904,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',1,'2025-09-01 15:52:10','2025-09-02 04:24:43'),(3905,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',1,'2025-09-01 15:55:08','2025-09-01 20:49:00'),(3906,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-09-02 04:25:12','2025-09-02 04:49:27'),(3907,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',1,'2025-09-02 04:30:10','2025-09-02 07:14:06'),(3908,13,NULL,'Mikrotik Router Down','⚠️ Hi Kazungu, your mikrotik router - La Zungu is offline. Please check it out.',0,'2025-09-02 10:05:16','2025-09-02 10:05:16'),(3909,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-02 10:14:14','2025-09-02 10:14:14'),(3910,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-09-02 10:18:16','2025-09-02 14:03:08'),(3911,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',1,'2025-09-02 10:22:12','2025-09-02 20:05:40'),(3912,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-09-02 11:02:15','2025-09-02 20:05:55'),(3913,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',1,'2025-09-02 11:05:12','2025-09-02 18:57:54'),(3914,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',1,'2025-09-02 12:51:14','2025-09-02 14:04:03'),(3915,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',1,'2025-09-02 12:58:12','2025-09-02 14:03:39'),(3916,13,NULL,'Mikrotik Router Down','⚠️ Hi Kazungu, your mikrotik router - La Zungu is offline. Please check it out.',0,'2025-09-02 14:17:18','2025-09-02 14:17:18'),(3917,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-02 14:20:15','2025-09-02 14:20:15'),(3918,13,NULL,'Mikrotik Router Down','⚠️ Hi Kazungu, your mikrotik router - La Zungu is offline. Please check it out.',1,'2025-09-02 16:45:16','2025-09-02 19:17:55'),(3919,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-02 16:48:14','2025-09-02 16:48:14'),(3920,13,NULL,'Mikrotik Router Down','⚠️ Hi Kazungu, your mikrotik router - La Zungu is offline. Please check it out.',0,'2025-09-02 17:00:17','2025-09-02 17:00:17'),(3921,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',0,'2025-09-03 05:26:20','2025-09-03 05:26:20'),(3922,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',0,'2025-09-03 05:30:17','2025-09-03 05:30:17'),(3923,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',0,'2025-09-03 05:45:20','2025-09-03 05:45:20'),(3924,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',1,'2025-09-03 06:16:15','2025-09-03 08:23:30'),(3925,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 07:52:14','2025-09-03 07:52:14'),(3926,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 07:53:14','2025-09-03 07:53:14'),(3927,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 07:54:14','2025-09-03 07:54:14'),(3928,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 07:55:15','2025-09-03 07:55:15'),(3929,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 07:56:14','2025-09-03 07:56:14'),(3930,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 07:57:14','2025-09-03 07:57:14'),(3931,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 07:58:14','2025-09-03 07:58:14'),(3932,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 07:59:14','2025-09-03 07:59:14'),(3933,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:00:15','2025-09-03 08:00:15'),(3934,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:01:14','2025-09-03 08:01:14'),(3935,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:02:14','2025-09-03 08:02:14'),(3936,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:03:15','2025-09-03 08:03:15'),(3937,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:04:14','2025-09-03 08:04:14'),(3938,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:05:14','2025-09-03 08:05:14'),(3939,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:06:14','2025-09-03 08:06:14'),(3940,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:07:14','2025-09-03 08:07:14'),(3941,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:08:14','2025-09-03 08:08:14'),(3942,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:09:14','2025-09-03 08:09:14'),(3943,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:10:15','2025-09-03 08:10:15'),(3944,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:11:14','2025-09-03 08:11:14'),(3945,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:12:14','2025-09-03 08:12:14'),(3946,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:13:15','2025-09-03 08:13:15'),(3947,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:14:14','2025-09-03 08:14:14'),(3948,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:15:14','2025-09-03 08:15:14'),(3949,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:16:14','2025-09-03 08:16:14'),(3950,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:17:16','2025-09-03 08:17:16'),(3951,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:18:14','2025-09-03 08:18:14'),(3952,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:19:14','2025-09-03 08:19:14'),(3953,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:20:14','2025-09-03 08:20:14'),(3954,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:21:14','2025-09-03 08:21:14'),(3955,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:22:14','2025-09-03 08:22:14'),(3956,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:23:18','2025-09-03 08:23:18'),(3957,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:24:14','2025-09-03 08:24:14'),(3958,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:25:14','2025-09-03 08:25:14'),(3959,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:26:14','2025-09-03 08:26:14'),(3960,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:27:14','2025-09-03 08:27:14'),(3961,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:28:14','2025-09-03 08:28:14'),(3962,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:29:14','2025-09-03 08:29:14'),(3963,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:30:15','2025-09-03 08:30:15'),(3964,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:31:14','2025-09-03 08:31:14'),(3965,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:32:14','2025-09-03 08:32:14'),(3966,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:33:15','2025-09-03 08:33:15'),(3967,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-09-03 08:34:13','2025-09-03 08:34:13'),(3968,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:35:14','2025-09-03 08:35:14'),(3969,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:36:22','2025-09-03 08:36:22'),(3970,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:37:14','2025-09-03 08:37:14'),(3971,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:38:14','2025-09-03 08:38:14'),(3972,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:39:14','2025-09-03 08:39:14'),(3973,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:40:15','2025-09-03 08:40:15'),(3974,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:41:14','2025-09-03 08:41:14'),(3975,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:42:14','2025-09-03 08:42:14'),(3976,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:43:14','2025-09-03 08:43:14'),(3977,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:44:14','2025-09-03 08:44:14'),(3978,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:45:14','2025-09-03 08:45:14'),(3979,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:46:14','2025-09-03 08:46:14'),(3980,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:47:14','2025-09-03 08:47:14'),(3981,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:48:14','2025-09-03 08:48:14'),(3982,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:49:14','2025-09-03 08:49:14'),(3983,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:50:14','2025-09-03 08:50:14'),(3984,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:51:14','2025-09-03 08:51:14'),(3985,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:52:14','2025-09-03 08:52:14'),(3986,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:53:14','2025-09-03 08:53:14'),(3987,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:54:14','2025-09-03 08:54:14'),(3988,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:55:14','2025-09-03 08:55:14'),(3989,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:56:14','2025-09-03 08:56:14'),(3990,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:57:14','2025-09-03 08:57:14'),(3991,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:58:14','2025-09-03 08:58:14'),(3992,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 08:59:15','2025-09-03 08:59:15'),(3993,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:00:15','2025-09-03 09:00:15'),(3994,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:01:14','2025-09-03 09:01:14'),(3995,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:02:14','2025-09-03 09:02:14'),(3996,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:03:14','2025-09-03 09:03:14'),(3997,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:04:14','2025-09-03 09:04:14'),(3998,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:05:14','2025-09-03 09:05:14'),(3999,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:06:14','2025-09-03 09:06:14'),(4000,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:07:14','2025-09-03 09:07:14'),(4001,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:08:14','2025-09-03 09:08:14'),(4002,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:09:14','2025-09-03 09:09:14'),(4003,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:10:14','2025-09-03 09:10:14'),(4004,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:11:14','2025-09-03 09:11:14'),(4005,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:12:14','2025-09-03 09:12:14'),(4006,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:13:14','2025-09-03 09:13:14'),(4007,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:14:14','2025-09-03 09:14:14'),(4008,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:15:15','2025-09-03 09:15:15'),(4009,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:16:14','2025-09-03 09:16:14'),(4010,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:17:18','2025-09-03 09:17:18'),(4011,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:18:14','2025-09-03 09:18:14'),(4012,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:19:14','2025-09-03 09:19:14'),(4013,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:20:14','2025-09-03 09:20:14'),(4014,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:21:14','2025-09-03 09:21:14'),(4015,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:22:15','2025-09-03 09:22:15'),(4016,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:23:14','2025-09-03 09:23:14'),(4017,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:24:14','2025-09-03 09:24:14'),(4018,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:25:14','2025-09-03 09:25:14'),(4019,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:26:14','2025-09-03 09:26:14'),(4020,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:27:14','2025-09-03 09:27:14'),(4021,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:28:14','2025-09-03 09:28:14'),(4022,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:29:14','2025-09-03 09:29:14'),(4023,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:30:15','2025-09-03 09:30:15'),(4024,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:31:14','2025-09-03 09:31:14'),(4025,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:32:14','2025-09-03 09:32:14'),(4026,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:33:14','2025-09-03 09:33:14'),(4027,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:34:14','2025-09-03 09:34:14'),(4028,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:35:15','2025-09-03 09:35:15'),(4029,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:36:14','2025-09-03 09:36:14'),(4030,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:37:14','2025-09-03 09:37:14'),(4031,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:38:14','2025-09-03 09:38:14'),(4032,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:39:14','2025-09-03 09:39:14'),(4033,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:40:15','2025-09-03 09:40:15'),(4034,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:41:18','2025-09-03 09:41:18'),(4035,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:42:15','2025-09-03 09:42:15'),(4036,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:43:14','2025-09-03 09:43:14'),(4037,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:44:14','2025-09-03 09:44:14'),(4038,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:45:15','2025-09-03 09:45:15'),(4039,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:46:14','2025-09-03 09:46:14'),(4040,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:47:14','2025-09-03 09:47:14'),(4041,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:48:14','2025-09-03 09:48:14'),(4042,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:49:14','2025-09-03 09:49:14'),(4043,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:50:14','2025-09-03 09:50:14'),(4044,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:51:14','2025-09-03 09:51:14'),(4045,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:52:14','2025-09-03 09:52:14'),(4046,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:53:14','2025-09-03 09:53:14'),(4047,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:54:14','2025-09-03 09:54:14'),(4048,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:55:14','2025-09-03 09:55:14'),(4049,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:56:14','2025-09-03 09:56:14'),(4050,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:57:14','2025-09-03 09:57:14'),(4051,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:58:14','2025-09-03 09:58:14'),(4052,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 09:59:14','2025-09-03 09:59:14'),(4053,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:00:16','2025-09-03 10:00:16'),(4054,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:01:14','2025-09-03 10:01:14'),(4055,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:02:14','2025-09-03 10:02:14'),(4056,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:03:14','2025-09-03 10:03:14'),(4057,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:04:14','2025-09-03 10:04:14'),(4058,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:05:15','2025-09-03 10:05:15'),(4059,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:06:15','2025-09-03 10:06:15'),(4060,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:07:14','2025-09-03 10:07:14'),(4061,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:08:15','2025-09-03 10:08:15'),(4062,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:09:14','2025-09-03 10:09:14'),(4063,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:10:15','2025-09-03 10:10:15'),(4064,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:11:14','2025-09-03 10:11:14'),(4065,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:12:14','2025-09-03 10:12:14'),(4066,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:13:15','2025-09-03 10:13:15'),(4067,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:14:14','2025-09-03 10:14:14'),(4068,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:15:14','2025-09-03 10:15:14'),(4069,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:16:14','2025-09-03 10:16:14'),(4070,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:17:17','2025-09-03 10:17:17'),(4071,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:18:15','2025-09-03 10:18:15'),(4072,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:19:14','2025-09-03 10:19:14'),(4073,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:20:14','2025-09-03 10:20:14'),(4074,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:21:14','2025-09-03 10:21:14'),(4075,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:22:14','2025-09-03 10:22:14'),(4076,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:23:15','2025-09-03 10:23:15'),(4077,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:24:14','2025-09-03 10:24:14'),(4078,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:25:14','2025-09-03 10:25:14'),(4079,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:26:14','2025-09-03 10:26:14'),(4080,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:27:14','2025-09-03 10:27:14'),(4081,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:28:15','2025-09-03 10:28:15'),(4082,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:29:15','2025-09-03 10:29:15'),(4083,13,NULL,'Mikrotik Router Up','✅ Hi Kazungu, your mikrotik router - La Zungu is back online.',0,'2025-09-03 10:30:19','2025-09-03 10:30:19');

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

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

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


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

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

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

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

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

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

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

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

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

CREATE TABLE `paid_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_router_id` bigint unsigned DEFAULT NULL,
  `company_grouped_transaction_id` int DEFAULT NULL,
  `mac_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `paid_users_company_router_id_foreign` (`company_router_id`),
  CONSTRAINT `paid_users_company_router_id_foreign` FOREIGN KEY (`company_router_id`) REFERENCES `company_routers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=182 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');

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

CREATE TABLE `potential_customers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int DEFAULT NULL,
  `names` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `potential_customers`
--


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

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

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


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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `sessions` VALUES ('2gLbf1JHJQbB0Nc3iW6aHOX2beCSRGzsTcrkfV5o',1,'102.208.180.254','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiQ3dWZ09SYk5uaE5EcGJWMHQxcUtvZG5Vc05vdzZyVXlwMkFEMWE3NiI7czozOiJ1cmwiO2E6MDp7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7czo0OiJhdXRoIjthOjE6e3M6MjE6InBhc3N3b3JkX2NvbmZpcm1lZF9hdCI7aToxNzU2ODc4MzkyO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NzoiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL2ZldGNoLXdoYXRzYXBwLXFyLzAiO319',1756881672),('2R9zpWm8S55legCZTKECrFhw2SSflhODt0AjozdX',NULL,'145.239.161.191','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:115.0) Gecko/20100101 Chrome/115.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRUJRbTBqUVl5bWFNcXV5MkhrWWN3bTJlNkNHVlhyTlFFU3FyZlRRUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756882318),('4R0JOH952y5oJ1ISheKaJjwnrDxvddoBfjGWPDmS',NULL,'3.208.116.168','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRmFBODhRakZhS2dwakRLdmZqTExaTTJLdnBIc2RMRVNmOGVBdHN2TCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756875046),('6EcJUmDHYvjTO3o5Tb4dwLnOlmkQtV2r537NEsRT',NULL,'69.171.249.7','facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMFV3WXdzQ0pWbWd3UFIwRkcxb1pkRnlNcjN0YmhpTzJEd0oxQVpIZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756883243),('6ZxJwzpPo6vfZvnhKya8DOwXW21brUHZ5KRFKcRo',22,'197.250.96.199','Mozilla/5.0 (Android 16; Mobile; rv:142.0) Gecko/142.0 Firefox/142.0','[encoded data, 43976 characters]',1756837075),('7N9EHTgehyL7HomfQAT4DJtEkCwYMJLGmIucx0SL',NULL,'43.152.72.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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZWdMVjlBaWF3Vm9ZSHhnUlNUaTZPZFZMQ2ZpQ3NMQnhpTVNWWVdXQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly9vcGlmZXgub3BpZmV4dGVjaG5vbG9neS5jb20vcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1756867587),('8TuL5FbI35VcCfEmA7qKq8hFFvFLTjFYA7A4YVO3',15,'41.59.52.203','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','[encoded data, 139268 characters]',1756842247),('a2TMOSRQpOucXY3L2Gwtr3HDAP1u6Z5e4vbPYyCA',NULL,'54.38.147.227','Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOTFWRHZ3bGlZb2tIZE9remdINzVKbTBRVGMwakxGMnZDdTVQTXIxMSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1756879596),('elTnCs336Afe4tf68ba5aVkDDOoCjTy8YV9ifr26',15,'41.59.52.203','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:142.0) Gecko/20100101 Firefox/142.0','[encoded data, 131612 characters]',1756844700),('EP0DmVuwWsXq6jtZ3VJoGSOgWCAA85AF4Y8pvV0W',NULL,'66.249.77.140','Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.7204.183 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaVlBQjR2Z2dIdFJOd0paSTQzYUNCY3d6YzZuejNIeFdsS05IUFB3biI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9wYXNzd29yZC9yZXNldCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756891196),('Erw9VXCWEDsQVjUFIfOCvx9y9pyguMiXOij8cuyo',NULL,'167.94.146.54','Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZjJLTExxeWFQRGFUSFhOZlVVc2JNUUhYMnlhTXpYUG5UNTE1c3dqZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xNjEuOTcuMTc0LjIwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756882341),('f21TY4kmUyJqhUMhxDq5wfbSQnpdcyXIEFSspsLr',NULL,'43.157.181.189','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoicjdYRlZVbFdBUEtqVHR5T0RQSFFjWGxSb0NUdGpMa2FoWlIzVDkwNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1756867331),('guLLl30si05XnXNvlObJOpEKncIHXY6Bh1upsPA5',NULL,'197.136.9.4','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoic2I5bkNpNTdYeGpCQk5hWUZFaDlzT1hTa0Z2bkx1M1F4dDAzY2lCRCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9yZWdpc3RlciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756855608),('ixm55ghRnttExFiV0Fe2Mhrtgz9hBjKGMx9dZGX4',NULL,'51.68.236.72','Mozilla/5.0 (compatible; MJ12bot/v2.0.4; http://mj12bot.com/)','YTozOntzOjY6Il90b2tlbiI7czo0MDoidGFtTTlsck9pMEl4R0hlUlM1cmM2RFJJMVlwd3ZkM2pBUmpjT2cxViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756841912),('JjXADebHf9smgmrxeGiqh2G8upaovWEBHa8Vb8rD',NULL,'69.171.249.4','facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUG9QNTRVVnl6VlJqa2pCVGJheDZYd1pHVWxkc09jMFcyU3lLRVR2dSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756883243),