-- 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=9 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),(2,10,2,21000.00,0.00,'2025-09-10 17:38:47','2025-09-10 17:38:47',NULL),(3,11,3,21000.00,0.00,'2025-09-18 14:40:49','2025-09-18 14:40:49',NULL),(4,13,4,21000.00,0.00,'2025-09-27 15:04:44','2025-09-27 15:04:44',NULL),(5,16,5,21000.00,0.00,'2025-10-01 12:28:16','2025-10-01 12:28:16',NULL),(6,17,6,21000.00,0.00,'2025-10-02 06:41:55','2025-10-02 06:41:55',NULL),(7,21,7,21000.00,0.00,'2025-10-03 12:19:17','2025-10-03 12:19:17',NULL),(8,23,8,21000.00,0.00,'2025-10-23 18:42:27','2025-10-23 18:42:27',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=39 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),(9,'XKAGB1',9,'2025-09-05 22:00:00','2025-10-05 22:00:00',21000.00,0,'2025-09-06 06:09:37','2025-09-25 06:34:59',NULL),(10,'IFBS2J',10,'2025-09-08 22:00:00','2025-10-08 22:00:00',21000.00,1,'2025-09-09 09:33:08','2025-09-10 17:38:47',NULL),(11,'O2YFSQ',11,'2025-09-17 22:00:00','2025-10-17 22:00:00',21000.00,1,'2025-09-18 14:24:23','2025-09-18 14:40:49',NULL),(12,'YXDQ1H',12,'2025-09-24 22:00:00','2025-10-24 22:00:00',21000.00,0,'2025-09-25 11:55:26','2025-09-25 11:55:26',NULL),(13,'2IS8WQ',13,'2025-09-25 22:00:00','2025-10-25 22:00:00',21000.00,1,'2025-09-26 08:35:02','2025-09-27 15:04:44',NULL),(14,'R3WP1U',6,'2025-09-27 22:00:00','2025-10-27 23:00:00',21000.00,0,'2025-09-28 06:00:33','2025-09-28 06:00:33',NULL),(15,'YGTP9N',14,'2025-09-27 22:00:00','2025-10-27 23:00:00',21000.00,0,'2025-09-28 14:43:39','2025-09-28 14:43:39',NULL),(16,'BEO5CU',15,'2025-09-28 22:00:00','2025-10-28 23:00:00',21000.00,1,'2025-09-29 10:07:30','2025-10-01 12:28:16',NULL),(17,'LG0OC1',16,'2025-09-28 22:00:00','2025-10-28 23:00:00',21000.00,1,'2025-09-29 16:41:08','2025-10-02 06:41:55',NULL),(18,'T3BUIG',17,'2025-09-29 22:00:00','2025-10-29 23:00:00',21000.00,0,'2025-09-30 08:49:41','2025-09-30 08:49:41',NULL),(19,'V5CJ14',18,'2025-09-29 22:00:00','2025-10-29 23:00:00',21000.00,0,'2025-09-30 09:13:04','2025-09-30 09:13:04',NULL),(20,'D5PAZM',19,'2025-09-30 22:00:00','2025-10-31 23:00:00',21000.00,0,'2025-10-01 16:23:50','2025-10-01 16:23:50',NULL),(21,'2QUX6H',20,'2025-10-02 22:00:00','2025-11-02 23:00:00',21000.00,1,'2025-10-03 09:04:23','2025-10-03 12:19:17',NULL),(22,'78BA5U',21,'2025-10-03 22:00:00','2025-11-03 23:00:00',21000.00,0,'2025-10-04 13:01:27','2025-10-04 13:01:27',NULL),(23,'M8Z2W9',22,'2025-10-03 22:00:00','2025-11-03 23:00:00',21000.00,1,'2025-10-04 15:30:12','2025-10-23 18:42:27',NULL),(24,'3EQ5WR',23,'2025-10-06 22:00:00','2025-11-06 23:00:00',21000.00,0,'2025-10-07 18:10:55','2025-10-07 18:10:55',NULL),(25,'3SMYQP',24,'2025-10-07 22:00:00','2025-11-07 23:00:00',21000.00,0,'2025-10-08 07:47:36','2025-10-08 07:47:36',NULL),(26,'QYAL7V',25,'2025-10-10 22:00:00','2025-11-10 23:00:00',21000.00,0,'2025-10-11 11:22:25','2025-10-11 11:22:25',NULL),(27,'XH5SWE',26,'2025-10-10 22:00:00','2025-11-10 23:00:00',21000.00,0,'2025-10-11 14:29:17','2025-10-11 14:29:17',NULL),(28,'Q28N53',27,'2025-10-15 22:00:00','2025-11-15 23:00:00',21000.00,0,'2025-10-16 06:14:37','2025-10-16 06:14:37',NULL),(29,'75KW6S',11,'2025-10-17 22:00:00','2025-11-17 23:00:00',21000.00,0,'2025-10-18 06:02:01','2025-10-18 06:02:01',NULL),(30,'P38J9K',28,'2025-10-22 22:00:00','2025-11-22 23:00:00',21000.00,0,'2025-10-23 19:40:10','2025-10-23 19:40:10',NULL),(31,'M9YHZ6',29,'2025-10-25 22:00:00','2025-11-25 23:00:00',21000.00,0,'2025-10-26 15:06:22','2025-10-26 15:06:22',NULL),(32,'4CPU85',30,'2025-10-26 23:00:00','2025-11-26 23:00:00',21000.00,0,'2025-10-27 16:45:13','2025-10-27 16:45:13',NULL),(33,'LR5WE6',31,'2025-10-26 23:00:00','2025-11-26 23:00:00',21000.00,0,'2025-10-27 20:55:59','2025-10-27 20:55:59',NULL),(36,'YRNQH8',41,'2025-10-28 23:00:00','2025-11-28 23:00:00',21000.00,0,'2025-10-29 07:38:55','2025-10-29 07:38:55',NULL),(37,'NQ2XE8',13,'2025-10-29 23:00:00','2025-11-29 23:00:00',21000.00,0,'2025-10-30 07:03:42','2025-10-30 07:03:42',NULL),(38,'5DJA3X',14,'2025-10-29 23:00:00','2025-11-29 23:00:00',21000.00,0,'2025-10-30 07:03:42','2025-10-30 07:03:42',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,
  `wg_private_key` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wg_public_key` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT 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=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `company_routers` VALUES (2,'GI6BYT',8,'Ngoni Net 1',NULL,NULL,'50.50.50.2','161.97.174.20:16758','ngoni',8728,'48DWVF',0.00,'2025-09-30','0716583413',0,3,NULL,1,'2025-08-05',1,1,'2025-08-05 16:56:56','2025-10-30 15:13:36',NULL),(5,'YE6B2O',8,'Machinga Complex',NULL,NULL,'50.50.50.5','161.97.174.20:11566','heritage',8728,'0HAWV2',21000.00,'2025-08-26','0763752350',0,3,NULL,NULL,NULL,1,1,'2025-08-18 17:15:11','2025-10-30 15:14:36',NULL),(6,'83WYM2',11,'Mwamba',NULL,NULL,'50.50.50.6','161.97.174.20:18680','heritage',8728,'5ZISPW',21000.00,'2025-09-28','0786000803',0,0,'flash',NULL,NULL,1,0,'2025-08-26 13:06:13','2025-10-02 06:50:09',NULL),(7,'O37YGC',13,'La Zungu',NULL,NULL,'50.50.50.7','161.97.174.20:18875','heritage',8728,'6ZNHLJ',21000.00,'2025-08-29','0754578434',0,5,NULL,NULL,NULL,1,2,'2025-08-29 19:10:58','2025-10-08 17:01:12',NULL),(8,'9N2EL1',14,'MwendoKasi',NULL,NULL,'50.50.50.8',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-08-30','0696849400',0,3,NULL,NULL,NULL,0,0,'2025-08-30 06:58:45','2025-10-02 18:50:56',NULL),(9,'D2WHM9',16,'Street Mesh',NULL,NULL,'50.50.50.9','161.97.174.20:10194','heritage',8728,'X71WBR',21000.00,'2025-10-25','0747777710',0,3,'flash',NULL,NULL,1,2,'2025-09-06 06:09:37','2025-10-01 22:49:31',NULL),(10,'31DRYJ',17,'Mr Bando Internet Services',NULL,NULL,'50.50.50.10','161.97.174.20:18997','heritage',8728,'L7BDGY',21000.00,'2025-10-10','0780601042',0,0,'flash',NULL,NULL,1,0,'2025-09-09 09:33:08','2025-09-11 06:52:45',NULL),(11,'43ORCJ',18,'G NJARO',NULL,NULL,'50.50.50.11','161.97.174.20:10200','heritage',8728,'3R02DL',21000.00,'2025-10-18','0769932392',0,3,'flash',NULL,NULL,1,2,'2025-09-18 14:24:23','2025-10-30 15:18:42',NULL),(12,'9TGQOX',19,'Router12',NULL,NULL,'50.50.50.12',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-10-28','07577006671',0,3,NULL,NULL,NULL,0,2,'2025-09-25 11:55:26','2025-09-28 08:16:03',NULL),(13,'XH6WF3',20,'Mkiwa',NULL,NULL,'50.50.50.13','161.97.174.20:19708','heritage',8728,'2VCSLF',21000.00,'2025-10-30','0788443614',0,3,NULL,NULL,NULL,0,2,'2025-09-26 08:35:02','2025-10-30 15:12:49',NULL),(14,'BJX2SV',21,'Kitonga',NULL,NULL,'50.50.50.14','161.97.174.20:19796','heritage',8728,'N8MAJS',21000.00,'2025-10-30','0765288577',0,3,NULL,NULL,NULL,0,2,'2025-09-28 14:43:39','2025-10-30 07:03:42',NULL),(15,'F1TDMC',22,'Mshua Net',NULL,NULL,'50.50.50.15','161.97.174.20:19673','heritage',8728,'9721RV',21000.00,'2025-10-31','0679254949',0,3,NULL,NULL,NULL,0,1,'2025-09-29 10:07:30','2025-10-30 15:12:53',NULL),(16,'PJV6KX',23,'ITeam',NULL,NULL,'50.50.50.16','161.97.174.20:13166','heritage',8728,'JEXLR3',21000.00,'2025-10-31','0789431231',0,0,NULL,NULL,NULL,1,1,'2025-09-29 16:41:08','2025-10-11 16:03:09',NULL),(17,'HPW02V',24,'Router17',NULL,NULL,'50.50.50.17',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-09-30','0759920774',0,3,NULL,NULL,NULL,0,2,'2025-09-30 08:49:41','2025-09-30 08:52:32',NULL),(18,'Z03B4N',25,'Ktown',NULL,NULL,'50.50.50.18','161.97.174.20:12008','heritage',8728,'D96KI4',21000.00,'2025-09-30','0783502405',0,3,NULL,NULL,NULL,1,0,'2025-09-30 09:13:04','2025-10-02 17:34:57',NULL),(19,'QEPFU3',26,'WiFi Net',NULL,NULL,'50.50.50.19','161.97.174.20:11861','heritage',8728,'F8KRT3',21000.00,'2025-10-03','0688680386',0,3,NULL,NULL,NULL,0,2,'2025-10-01 16:23:50','2025-10-06 19:18:51',NULL),(20,'FY3HV7',27,'Twistechs',NULL,NULL,'50.50.50.20','161.97.174.20:16370','heritage',8728,'4ERWVN',21000.00,'2025-11-03','22999985858',1,1,NULL,NULL,NULL,1,1,'2025-10-03 09:04:23','2025-10-29 20:47:56',NULL),(21,'37PHMJ',28,'Wakizungu',NULL,NULL,'50.50.50.21',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-10-04','0744002165',0,3,'flash',NULL,NULL,0,2,'2025-10-04 13:01:27','2025-10-29 17:48:35',NULL),(22,'R9UY6D',29,'Trekker',NULL,NULL,'50.50.50.22','161.97.174.20:10154','heritage',8728,'CV4Y75',21000.00,'2025-12-01','256787176354',1,0,NULL,NULL,NULL,0,1,'2025-10-04 15:30:12','2025-10-30 20:40:58',NULL),(23,'FWDKP4',30,'Zurich',NULL,NULL,'50.50.50.23','161.97.174.20:18285','heritage',8728,'ND5S2K',21000.00,'2025-10-07','0787109988',0,0,'flash',NULL,NULL,0,2,'2025-10-07 18:10:55','2025-10-11 16:22:52',NULL),(24,'D69E8Z',31,'JNET',NULL,NULL,'50.50.50.24',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-10-08','07778198889',0,3,'flash',NULL,NULL,0,2,'2025-10-08 07:47:36','2025-10-08 12:30:30',NULL),(25,'XAFKM2',32,'Moxetech',NULL,NULL,'50.50.50.25','161.97.174.20:14243','heritage',8728,'72MSPJ',21000.00,'2025-10-11','0778180076',1,0,NULL,NULL,NULL,1,2,'2025-10-11 11:22:25','2025-10-30 22:18:04',NULL),(26,'4D26LZ',33,'Trial',NULL,NULL,'50.50.50.26',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-10-11','0712345',0,3,NULL,NULL,NULL,0,2,'2025-10-11 14:29:17','2025-10-12 18:38:43',NULL),(27,'EA7G54',34,'Router27',NULL,NULL,'50.50.50.27',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-10-16','0696011778',0,3,NULL,NULL,NULL,0,2,'2025-10-16 06:14:37','2025-10-16 06:17:54',NULL),(28,'9TSVGD',35,'Router28',NULL,NULL,'50.50.50.28','161.97.174.20:18180','heritage',8728,'WM6NRZ',21000.00,'2025-10-23','0764334732',0,0,'flash',NULL,NULL,1,2,'2025-10-23 19:40:10','2025-10-23 21:53:59',NULL),(29,'Z6PN3Q',36,'Router29',NULL,NULL,'50.50.50.29',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-10-26','0716582313',0,3,NULL,NULL,NULL,0,2,'2025-10-26 15:06:22','2025-10-26 15:08:58',NULL),(30,'3JKVF9',37,'Router30',NULL,NULL,'50.50.50.30',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-11-27','0622454056',0,3,'flash',NULL,NULL,0,2,'2025-10-27 16:45:13','2025-10-30 15:13:16',NULL),(31,'GVE96Q',8,'Router31',NULL,NULL,'50.50.50.31',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-10-27','0716583413',0,3,NULL,NULL,NULL,0,1,'2025-10-27 20:55:59','2025-10-27 20:59:03',NULL),(41,'Z3RELG',47,'Router32','mJysVoltwHc3Nl2OcmtBYvhvo7Bw8IC7M9x9IRaAfW8=','BKfqCspScXQLlngn4UaDiEnH5X7Hkktc7AEyrkS1qUo=','50.50.50.32',NULL,'heritage',8728,'heritage@2025',21000.00,'2025-10-29','08754',0,3,NULL,NULL,NULL,0,2,'2025-10-29 07:38:55','2025-10-29 07:42:18',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=153 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-10-17 21:12:52','2025-10-17 21:12:52'),(7,'YPH8AG',8,1,2,3,'3 Hours bila kikomo','3','M','2','M',NULL,NULL,NULL,'1',3.00,2,300.00,1,'2025-08-05 17:49:42','2025-10-24 05:01:29',NULL),(8,'RN5IOU',8,1,2,3,'12 Hours 3GB','3','M','3','M',NULL,NULL,NULL,'1',12.00,2,500.00,1,'2025-08-05 17:50:05','2025-10-24 05:15:51',NULL),(9,'SHZN7L',8,1,2,3,'24 Hours bila kikomo','3','M','3','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-08-05 17:50:21','2025-10-24 05:02:24',NULL),(10,'ICA7K6',8,1,2,3,'7 Day bila kikomo','3','M','3','M',NULL,NULL,NULL,'1',7.00,3,5000.00,1,'2025-08-08 19:52:48','2025-10-24 05:03:05',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 bila kikomo','3','M','3','M',NULL,NULL,NULL,'1',30.00,3,15000.00,1,'2025-08-14 20:43:56','2025-10-24 05:03:32',NULL),(24,'48IY1U',8,1,2,3,'3 days bila kikomo','03','M','03','M',NULL,NULL,NULL,'1',3.00,3,2500.00,1,'2025-08-14 20:45:13','2025-10-24 05:03:54',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 bila kikomo','03','M','03','M',NULL,NULL,NULL,'1',14.00,3,7000.00,1,'2025-08-20 11:02:58','2025-10-24 05:04:18',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','3','M','5','M',NULL,NULL,NULL,'1',7.00,3,5000.00,1,'2025-08-26 18:38:54','2025-10-12 06:07:09',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),(59,'CQHY58',16,1,9,12,'Unlimited 12hrs','3','M','3','M',NULL,NULL,NULL,'1',12.00,2,1000.00,1,'2025-09-06 06:53:48','2025-09-29 18:06:05',NULL),(60,'8ZXKH7',16,2,9,13,'Mwezi','10','M','10','M',NULL,NULL,NULL,'1',30.00,3,15000.00,1,'2025-09-06 06:55:07','2025-09-06 06:55:07',NULL),(61,'85EDC4',16,1,9,12,'Mselekeko Spenko','10','M','10','M',NULL,NULL,NULL,'3',30.00,3,30000.00,1,'2025-09-06 18:36:04','2025-09-29 18:04:18','2025-09-29 18:04:18'),(62,'3HA74Q',17,1,10,14,'SIKU','10','M','10','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-09-09 11:03:43','2025-09-09 11:03:43',NULL),(63,'TQM92W',17,2,10,15,'MWEZI','10','M','10','M',NULL,NULL,NULL,'1',30.00,3,25000.00,1,'2025-09-09 11:05:23','2025-09-09 11:05:23',NULL),(64,'CH17FV',18,1,11,16,'SIKU','10','M','10','M',NULL,NULL,NULL,'1',1.00,3,1000.00,1,'2025-09-18 14:59:05','2025-09-18 14:59:05',NULL),(65,'7JZES1',18,1,11,16,'VOCHA ZA MASAA 500/=','3','M','3','M',NULL,NULL,NULL,'1',5.00,2,500.00,1,'2025-09-18 15:37:39','2025-09-18 15:37:39',NULL),(66,'8V5GCZ',18,1,11,16,'MWEZI','10','M','10','M',NULL,NULL,NULL,'1',30.00,3,26000.00,1,'2025-09-18 18:29:05','2025-09-18 18:29:05',NULL),(67,'B2N8DJ',18,1,11,16,'WIKI','5','M','5','M',NULL,NULL,NULL,'1',7.00,3,6000.00,1,'2025-09-18 18:30:47','2025-09-18 18:30:47',NULL),(68,'BPG4NY',16,1,9,12,'Unlimited 24Hrs','3','M','3','M',NULL,NULL,NULL,'1',24.00,2,1500.00,1,'2025-09-22 21:35:08','2025-09-29 18:06:55',NULL),(69,'W0F76Z',16,1,9,12,'Unlimited 2Days','3','M','3','M',NULL,NULL,NULL,'1',2.00,3,3000.00,1,'2025-09-23 16:23:46','2025-09-29 18:08:06',NULL),(70,'RVJX80',20,1,13,18,'12 Hours 1 Device','3','M','3','M',NULL,NULL,NULL,'1',12.00,2,1000.00,1,'2025-09-26 13:52:52','2025-09-27 10:20:26',NULL),(71,'FUJ5C1',20,1,13,18,'1 Day 1 Device','3','M','3','M',NULL,NULL,NULL,'1',1.00,3,2000.00,1,'2025-09-26 14:49:07','2025-10-19 20:45:07',NULL),(72,'L51RS7',20,1,13,18,'7 Days 1 Device','3','M','3','M',NULL,NULL,NULL,'1',7.00,3,5500.00,1,'2025-09-26 15:01:08','2025-09-27 10:18:17',NULL),(73,'SQU2YH',20,1,13,18,'3 Day  1 Device','3','M','3','M',NULL,NULL,NULL,'1',3.00,3,3500.00,1,'2025-09-26 15:11:27','2025-09-30 10:12:59',NULL),(74,'DC413I',20,1,13,18,'30 Days 1 Device','3','M','3','M',NULL,NULL,NULL,'1',30.00,3,25000.00,1,'2025-09-27 10:03:18','2025-10-19 20:42:29',NULL),(75,'ER1T6A',20,1,13,18,'30 Days 3 Device','5','M','5','M',NULL,NULL,NULL,'1',30.00,3,35000.00,1,'2025-09-27 10:05:18','2025-10-19 20:43:51',NULL),(76,'2G79IP',20,1,13,18,'7 Days 2 Device','3','M','3','M',NULL,NULL,NULL,'2',7.00,3,10000.00,1,'2025-09-27 10:38:17','2025-10-19 20:46:47',NULL),(77,'G624X3',21,1,14,20,'Masaa 15','5','M','5','M',NULL,NULL,NULL,'1',15.00,2,700.00,1,'2025-09-28 15:52:06','2025-09-28 16:04:19',NULL),(78,'AQM4U8',21,1,14,20,'Masaa 24','5','M','5','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-09-28 15:53:09','2025-09-28 16:04:45',NULL),(79,'6GXFQ7',21,1,14,20,'Wiki','5','M','5','M',NULL,NULL,NULL,'1',7.00,3,5000.00,1,'2025-09-28 16:05:07','2025-09-28 16:05:07',NULL),(80,'NUD2OG',21,1,14,20,'Mwezi','5','M','5','M',NULL,NULL,NULL,'1',30.00,3,20000.00,1,'2025-09-28 16:05:31','2025-09-28 16:05:31',NULL),(81,'P4HLM9',22,1,15,22,'2 Hour (BILA KIKOMO)','10','M','10','M',NULL,NULL,NULL,'1',2.00,2,600.00,1,'2025-09-29 12:05:49','2025-10-01 13:58:19',NULL),(82,'WV0O73',22,1,15,22,'3 Hours (BILA KIKOMO)','10','M','10','M',NULL,NULL,NULL,'1',3.00,2,800.00,1,'2025-09-29 12:06:21','2025-10-01 13:59:30',NULL),(83,'J63HKS',23,1,16,24,'JERO 6HRS','5','M','5','M',NULL,NULL,NULL,'1',6.00,2,500.00,1,'2025-09-29 17:08:08','2025-10-01 17:30:07',NULL),(84,'2XJPZY',23,1,16,24,'6 Hours','5','M','5','M',NULL,NULL,NULL,'1',6.00,2,100.00,1,'2025-09-29 17:08:34','2025-09-29 17:10:15','2025-09-29 17:10:15'),(85,'K96LPM',23,1,16,24,'BUKU -24HRS','5','M','5','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-09-29 17:11:10','2025-10-01 17:30:43',NULL),(86,'0AIUGL',16,1,9,12,'Unlimited 7Days','3','M','3','M',NULL,NULL,NULL,'1',7.00,3,5000.00,1,'2025-09-29 18:09:17','2025-09-29 18:09:17',NULL),(87,'E14VAJ',16,1,9,12,'Unlimited 14Days','3','M','3','M',NULL,NULL,NULL,'1',14.00,3,10000.00,1,'2025-09-29 18:10:55','2025-09-29 18:10:55',NULL),(88,'L3R9BX',16,1,9,12,'Unlimited 30Days','3','M','3','M',NULL,NULL,NULL,'1',30.00,3,15000.00,1,'2025-09-29 18:12:07','2025-09-29 18:12:07',NULL),(89,'ZXRV6W',23,2,16,24,'islam','10','M','10','M',NULL,NULL,NULL,'1',120.00,3,1.00,1,'2025-09-29 19:20:03','2025-09-29 19:20:03',NULL),(90,'XZ0EAI',25,1,18,26,'24hrs','20','M','20','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-09-30 09:52:56','2025-09-30 10:05:29',NULL),(91,'0KS3Z2',25,2,18,27,'10000','5','M','5','M',NULL,NULL,NULL,'1',30.00,3,10000.00,1,'2025-09-30 09:55:54','2025-09-30 09:55:54',NULL),(92,'RJGF20',20,1,13,18,'Free','1','M','1','M',NULL,NULL,NULL,'1',2.00,1,0.00,1,'2025-09-30 16:22:41','2025-10-01 14:12:42','2025-10-01 14:12:42'),(93,'EMX8NH',23,1,16,24,'wakala','5','M','5','M',NULL,NULL,NULL,'1',90.00,3,200.00,1,'2025-09-30 20:30:40','2025-10-01 17:25:09','2025-10-01 17:25:09'),(94,'QSL2RM',23,3,16,NULL,'mshua Download-8Mbps/Upload-8Mbps','5','M','5','M',NULL,NULL,NULL,'1',30.00,3,90.00,1,'2025-09-30 20:33:18','2025-09-30 20:33:18',NULL),(95,'7ZX0R6',22,1,15,22,'4 Hours (BILA KIKOMO)','15','M','10','M',NULL,NULL,NULL,'1',4.30,2,1000.00,1,'2025-10-01 12:07:07','2025-10-07 12:43:56',NULL),(96,'ZDP2OV',22,1,15,22,'1 DAYS (BILA KIKOMO)','20','M','20','M',NULL,NULL,NULL,'1',1.00,3,1500.00,1,'2025-10-01 12:12:37','2025-10-07 12:40:04',NULL),(97,'6B9L7R',26,1,19,28,'Unlimited 1Hour','10','M','10','M',NULL,NULL,NULL,'1',1.00,2,500.00,1,'2025-10-01 17:05:42','2025-10-01 17:53:33',NULL),(98,'D7S9T2',26,1,19,28,'Unlimited 24Hours','10','M','10','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-10-01 17:15:39','2025-10-01 17:54:06',NULL),(99,'TJM3WX',26,1,19,28,'Unlimited 7Days','10','M','10','M',NULL,NULL,NULL,'1',7.00,3,5000.00,1,'2025-10-01 17:22:49','2025-10-01 17:54:36',NULL),(100,'KX93Q2',26,1,19,28,'Unlimited 30Days','10','M','10','M',NULL,NULL,NULL,'1',30.00,3,15000.00,1,'2025-10-01 17:25:09','2025-10-01 17:55:03',NULL),(101,'79PSJM',23,1,16,24,'BUKU 2','5','M','5','M',NULL,NULL,NULL,'1',72.00,3,2000.00,1,'2025-10-01 17:27:54','2025-10-01 17:27:54',NULL),(102,'JHZRV7',26,1,19,28,'Ulimited24h Super','20','M','20','M',NULL,NULL,NULL,'1',24.00,1,2000.00,1,'2025-10-01 17:30:28','2025-10-01 17:41:39',NULL),(103,'LC3ZEP',26,1,19,28,'Unlimited 7D Super','20','M','20','M',NULL,NULL,NULL,'1',7.00,3,8500.00,1,'2025-10-01 17:33:18','2025-10-01 17:33:18',NULL),(104,'2KQ5XB',26,1,19,28,'Unlimited 7D Super','20','M','20','M',NULL,NULL,NULL,'1',7.00,3,8500.00,1,'2025-10-01 17:33:42','2025-10-01 17:39:27','2025-10-01 17:39:27'),(105,'BLY69T',26,1,19,28,'Unlimited 7D Super','20','M','20','M',NULL,NULL,NULL,'1',7.00,3,8000.00,1,'2025-10-01 17:34:00','2025-10-01 17:38:51','2025-10-01 17:38:51'),(106,'LCH32G',26,1,19,28,'Unlimited 7D Super','20','M','20','M',NULL,NULL,NULL,'1',7.00,3,8000.00,1,'2025-10-01 17:35:37','2025-10-01 17:38:30','2025-10-01 17:38:30'),(107,'8JPTFL',26,1,19,28,'Unlimited 7D Super','20','M','20','M',NULL,NULL,NULL,'1',7.00,3,8000.00,1,'2025-10-01 17:37:20','2025-10-01 17:38:11','2025-10-01 17:38:11'),(108,'E6LRZG',21,1,14,0,'Masaa','5','M','5','M','','','','1',15.00,2,0.00,1,'2025-10-03 07:02:55','2025-10-07 12:51:07','2025-10-07 12:51:07'),(109,'6KUZT4',21,1,14,0,'Masaa','5','M','5','M','','','','1',1.00,3,0.00,1,'2025-10-03 07:02:55','2025-10-11 16:19:06','2025-10-11 16:19:06'),(110,'TYJG8Z',21,1,14,20,'Wiki2','5','M','5','M',NULL,NULL,NULL,'1',1.00,2,0.00,1,'2025-10-03 07:02:55','2025-10-11 16:18:41','2025-10-11 16:18:41'),(111,'9XKNTP',21,1,14,0,'Mwezi','5','M','5','M','','','','1',4.00,0,0.00,1,'2025-10-03 07:02:55','2025-10-11 16:17:34','2025-10-11 16:17:34'),(112,'R9DPT5',27,1,20,31,'Test','2','M','2','M',NULL,NULL,NULL,'1',30.00,3,200.00,1,'2025-10-03 10:28:49','2025-10-03 12:05:07','2025-10-03 12:05:07'),(113,'Y4T3HE',27,1,20,31,'5h','3','M','2','M',NULL,NULL,NULL,'1',5.00,2,100.00,1,'2025-10-03 11:36:50','2025-10-03 11:36:50',NULL),(114,'J26SQF',27,1,20,31,'24h','5','M','2','M',NULL,NULL,NULL,'1',24.00,2,200.00,1,'2025-10-03 11:39:48','2025-10-03 11:39:48',NULL),(115,'NTPG9D',27,1,20,31,'3jours','6','M','2','M',NULL,NULL,NULL,'1',3.00,3,500.00,1,'2025-10-03 11:42:28','2025-10-03 11:42:28',NULL),(116,'7G3KWB',27,1,20,31,'1 semaine','8','M','2','M',NULL,NULL,NULL,'1',7.00,3,800.00,1,'2025-10-03 11:44:15','2025-10-03 11:44:15',NULL),(117,'SHY789',27,1,20,31,'1 mois','9','M','3','M',NULL,NULL,NULL,'1',30.00,3,3000.00,1,'2025-10-03 11:46:13','2025-10-03 11:46:13',NULL),(118,'CG4HLV',28,1,21,33,'SIKU','10','M','10','M',NULL,NULL,NULL,'1',12.00,2,1000.00,1,'2025-10-04 13:30:54','2025-10-04 13:42:17',NULL),(119,'TSMJ3D',28,1,21,33,'WIKI','10','M','10','M',NULL,NULL,NULL,'1',7.00,3,6000.00,1,'2025-10-04 13:30:54','2025-10-04 14:06:36',NULL),(120,'WY6CZE',28,1,21,0,'MWEZI',NULL,NULL,NULL,NULL,'','','','1',0.00,0,0.00,1,'2025-10-04 13:30:54','2025-10-04 14:09:06','2025-10-04 14:09:06'),(121,'KJ7R3Z',29,1,22,35,'1 Day','5','M','5','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-10-04 16:49:17','2025-10-04 16:49:17',NULL),(122,'3PZL8C',29,1,22,35,'1 week','5','M','5','M',NULL,NULL,NULL,'1',7.00,3,6000.00,1,'2025-10-04 16:51:47','2025-10-04 16:51:47',NULL),(123,'PQVJT6',29,2,22,36,'1 Day','5','M','5','M',NULL,NULL,NULL,'1',24.00,2,1000.00,1,'2025-10-04 18:04:57','2025-10-04 18:04:57',NULL),(124,'Y9XEDM',22,1,15,22,'7 DAYS (BILA KIKOMO)','15','M','10','M',NULL,NULL,NULL,'1',7.00,3,10000.00,1,'2025-10-07 11:07:02','2025-10-07 11:07:02',NULL),(125,'B43CWP',22,1,15,22,'15 DAYS (BILA KIKOMO)','15','M','10','M',NULL,NULL,NULL,'1',15.00,3,15000.00,1,'2025-10-07 11:08:42','2025-10-07 11:16:26',NULL),(126,'XLF98S',22,1,15,22,'30 DAYS (BILA KIKOMO)','20','M','15','M',NULL,NULL,NULL,'1',30.00,3,30000.00,1,'2025-10-07 11:10:28','2025-10-07 11:10:28',NULL),(127,'QPA84U',30,1,23,38,'1HOUR','5','M','5','M',NULL,NULL,NULL,'1',1.00,2,1000.00,1,'2025-10-07 18:24:58','2025-10-08 07:49:23',NULL),(128,'AS9G53',30,1,23,38,'SIKU','5','M','5','M',NULL,NULL,NULL,'1',40.00,1,500.00,1,'2025-10-07 18:24:58','2025-10-08 08:38:12',NULL),(129,'D4KJ3E',30,1,23,0,'WEEK','5','M','5','M','','','','1',0.00,0,0.00,1,'2025-10-07 18:24:58','2025-10-07 18:24:58',NULL),(130,'S98NV5',30,1,23,0,'MWEZI','5','M','5','M','','','','1',0.00,0,0.00,1,'2025-10-07 18:24:59','2025-10-07 18:24:59',NULL),(131,'D8GHCW',33,2,26,4,'5','5','M','5','M','','','','1',1.00,NULL,0.00,1,'2025-10-11 15:24:24','2025-10-11 15:24:24',NULL),(132,'U647VE',33,2,26,4,'10','10','M','10','M','','','','1',1.00,NULL,0.00,1,'2025-10-11 15:24:24','2025-10-11 15:24:24',NULL),(133,'KHUGM9',33,2,26,4,'15','15','M','15','M','','','','1',1.00,NULL,0.00,1,'2025-10-11 15:24:24','2025-10-11 15:24:24',NULL),(134,'JE8D52',33,2,26,4,'20','20','M','20','M','','','','1',1.00,NULL,0.00,1,'2025-10-11 15:24:24','2025-10-11 15:24:24',NULL),(135,'A7ZHRU',33,1,26,44,'1 Hour','10','M','10','M',NULL,NULL,NULL,'1',1.00,2,2.00,1,'2025-10-11 15:24:34','2025-10-11 15:24:34',NULL),(136,'YH3RGK',33,1,26,44,'6 Hours','10','M','10','M',NULL,NULL,NULL,'1',6.00,2,4.00,1,'2025-10-11 15:24:59','2025-10-11 15:24:59',NULL),(137,'9HD748',33,1,26,44,'12 Hours','10','M','10','M',NULL,NULL,NULL,'1',12.00,2,5.00,1,'2025-10-11 15:25:29','2025-10-11 15:25:29',NULL),(138,'D3AVLM',33,1,26,44,'24 Hours','10','M','10','M',NULL,NULL,NULL,'1',24.00,2,7.00,1,'2025-10-11 15:25:56','2025-10-11 15:25:56',NULL),(139,'4K2VYR',32,1,25,42,'1hr','3','M','3','M',NULL,NULL,NULL,'1',1.00,2,500.00,1,'2025-10-11 16:38:56','2025-10-12 06:43:48',NULL),(140,'PF64NC',32,1,25,42,'1d','4','M','4','M',NULL,NULL,NULL,'1',1.00,3,2000.00,1,'2025-10-11 17:24:02','2025-10-11 17:24:02',NULL),(141,'4W5HEK',32,1,25,42,'5hrs','3','M','3','M',NULL,NULL,NULL,'1',5.00,2,1000.00,1,'2025-10-12 06:45:14','2025-10-13 19:34:25',NULL),(142,'A9UXR4',29,1,22,35,'1 month','5','M','5','M',NULL,NULL,NULL,'1',30.00,3,20000.00,1,'2025-10-12 18:34:24','2025-10-12 18:34:24',NULL),(143,'BAK485',20,2,13,19,'Family','10','M','10','M',NULL,NULL,NULL,'1',30.00,3,60000.00,1,'2025-10-19 20:48:44','2025-10-19 20:48:44',NULL),(144,'VY4ELQ',35,1,28,46,'MASAA 10 BILA KIKOMO TSH 1,000','03','M','03','M',NULL,NULL,NULL,'1',10.00,2,1000.00,1,'2025-10-23 20:07:47','2025-10-23 20:19:11',NULL),(145,'JSVDY5',35,1,28,46,'MASAA 24 BILA KIKOMO TSH 2,000','03','M','03','M',NULL,NULL,NULL,'1',24.00,2,2000.00,1,'2025-10-23 20:20:12','2025-10-23 20:21:33',NULL),(146,'YK6DG2',35,1,28,46,'SIKU 7 BILA KIKOMO TSH 7,000','03','M','03','M',NULL,NULL,NULL,'1',7.00,3,7000.00,1,'2025-10-23 20:23:39','2025-10-23 20:23:39',NULL),(147,'ZW68AT',8,1,2,3,'10 MBPS PEED KWA MAA 3','010','M','020','M',NULL,NULL,NULL,'1',3.00,2,500.00,1,'2025-10-24 05:18:55','2025-10-24 05:18:55',NULL),(148,'HW9JGD',29,1,22,35,'4 Hours','5','M','5','M',NULL,NULL,NULL,'1',4.00,2,500.00,1,'2025-10-26 10:57:15','2025-10-26 10:57:15',NULL),(149,'DLAYP9',37,1,30,48,'MASAA 12','15','M','15','M',NULL,NULL,NULL,'1',12.00,2,700.00,1,'2025-10-27 17:35:26','2025-10-27 18:39:07',NULL),(150,'CZ563P',37,1,30,48,'MASAA 24','15','M','15','M',NULL,NULL,NULL,'1',1.00,3,1000.00,1,'2025-10-27 17:53:05','2025-10-28 10:21:52',NULL),(151,'TNZL6G',37,1,30,48,'SIKU 7','15','M','15','M',NULL,NULL,NULL,'1',7.00,3,5000.00,1,'2025-10-27 18:40:45','2025-10-28 10:22:17',NULL),(152,'JEB5QZ',37,1,30,48,'SIKU 30','15','M','15','M',NULL,NULL,NULL,'1',30.00,3,20000.00,1,'2025-10-27 18:41:28','2025-10-28 10:22:40',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=31 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 Tsh [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-09-23 09:01:32',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),(28,16,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.',0,'2025-09-06 06:57:59','2025-09-06 06:58:07',NULL),(29,20,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-09-26 14:33:20','2025-09-26 14:33:20',NULL),(30,37,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-10-27 17:36:35','2025-10-27 17:36:35',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=53 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,0,'2025-08-30 06:58:45','2025-10-02 18:50:56',NULL),(16,8,24,1,'2025-08-31 22:17:44','2025-08-31 22:17:44',NULL),(17,15,15,0,'2025-09-03 20:05:20','2025-10-07 14:15:34',NULL),(18,16,25,1,'2025-09-06 06:09:37','2025-09-06 06:09:37',NULL),(19,16,26,1,'2025-09-06 13:01:40','2025-09-06 13:01:40',NULL),(20,17,27,0,'2025-09-09 09:33:08','2025-09-11 06:52:45',NULL),(21,18,28,1,'2025-09-18 14:24:23','2025-09-18 14:24:23',NULL),(22,19,29,1,'2025-09-25 11:55:26','2025-09-25 11:55:26',NULL),(23,20,30,1,'2025-09-26 08:35:02','2025-09-26 08:35:02',NULL),(24,21,31,1,'2025-09-28 14:43:39','2025-10-02 15:48:56',NULL),(25,22,32,1,'2025-09-29 10:07:30','2025-09-29 10:07:30',NULL),(26,23,33,1,'2025-09-29 16:41:08','2025-09-29 16:41:08',NULL),(27,23,34,1,'2025-09-29 17:59:20','2025-09-29 17:59:20',NULL),(28,24,35,1,'2025-09-30 08:49:41','2025-09-30 08:49:41',NULL),(29,25,36,0,'2025-09-30 09:13:04','2025-10-02 18:50:39',NULL),(30,26,37,1,'2025-10-01 16:23:50','2025-10-01 16:23:50',NULL),(31,27,38,1,'2025-10-03 09:04:23','2025-10-03 09:04:23',NULL),(32,28,39,1,'2025-10-04 13:01:27','2025-10-04 13:01:27',NULL),(33,29,40,1,'2025-10-04 15:30:12','2025-10-04 15:30:12',NULL),(34,30,42,1,'2025-10-07 18:10:55','2025-10-07 18:10:55',NULL),(35,31,43,1,'2025-10-08 07:47:36','2025-10-08 07:47:36',NULL),(36,32,44,1,'2025-10-11 11:22:25','2025-10-11 11:22:25',NULL),(37,33,45,1,'2025-10-11 14:29:16','2025-10-11 14:29:16',NULL),(38,34,46,1,'2025-10-16 06:14:37','2025-10-16 06:14:37',NULL),(39,35,47,1,'2025-10-23 19:40:10','2025-10-23 19:40:10',NULL),(40,36,48,1,'2025-10-26 15:06:22','2025-10-26 15:06:22',NULL),(41,37,49,1,'2025-10-27 16:45:13','2025-10-27 16:45:13',NULL),(51,47,59,1,'2025-10-29 07:38:55','2025-10-29 07:38:55',NULL),(52,37,60,1,'2025-10-29 07:51:37','2025-10-29 07:51:37',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 AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `company_whatsapp_scans` VALUES (1,0,'+254716100572','2025-09-10 08:04:10','2025-09-10 08:04:10',NULL),(2,0,'254716100572','2025-09-10 08:04:22','2025-09-10 08:04:22',NULL),(3,13,'+255754578434','2025-09-10 13:00:13','2025-09-10 13:00:13',NULL),(4,0,'+254796230626','2025-09-23 08:59:43','2025-09-23 08:59:43',NULL),(5,32,'+256778180076','2025-10-12 06:47:12','2025-10-12 06:47:12',NULL);

--
-- 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=9 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),(2,1,2,50.00,10500.00,0,'2025-09-10 17:38:47','2025-09-10 17:38:47',NULL),(3,1,3,50.00,10500.00,0,'2025-09-18 14:40:49','2025-09-18 14:40:49',NULL),(4,1,4,50.00,10500.00,0,'2025-09-27 15:04:44','2025-09-27 15:04:44',NULL),(5,1,5,50.00,10500.00,0,'2025-10-01 12:28:16','2025-10-01 12:28:16',NULL),(6,1,6,50.00,10500.00,0,'2025-10-02 06:41:55','2025-10-02 06:41:55',NULL),(7,1,7,50.00,10500.00,0,'2025-10-03 12:19:17','2025-10-03 12:19:17',NULL),(8,1,8,50.00,10500.00,0,'2025-10-23 18:42:27','2025-10-23 18:42:27',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=9 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),(2,'8RSZVT',1,0.00,0.00,17,10,1,2,NULL,'TI62NA5R2A',21000.00,NULL,NULL,'2025-09-10 17:38:47','2025-09-10 17:38:47',NULL),(3,'8BHOI7',1,0.00,0.00,18,11,1,2,NULL,'',21000.00,NULL,NULL,'2025-09-18 14:40:49','2025-09-18 14:40:49',NULL),(4,'KANE2C',1,0.00,0.00,20,13,1,2,NULL,'TIRKH5U8DQ',21000.00,NULL,NULL,'2025-09-27 15:04:44','2025-09-27 15:04:44',NULL),(5,'4MBU7G',1,0.00,0.00,22,15,1,2,NULL,'',21000.00,NULL,NULL,'2025-10-01 12:28:16','2025-10-01 12:28:16',NULL),(6,'CW7PYX',1,0.00,0.00,23,16,1,2,NULL,'TJ1KH69JKS',21000.00,NULL,NULL,'2025-10-02 06:41:55','2025-10-02 06:41:55',NULL),(7,'THUX2L',1,0.00,0.00,27,20,1,2,NULL,'13V78007B6571820N',21000.00,NULL,NULL,'2025-10-03 12:19:16','2025-10-03 12:19:16',NULL),(8,'4JLVYP',1,0.00,0.00,29,22,1,2,NULL,'ty9r',21000.00,NULL,NULL,'2025-10-23 18:42:27','2025-10-23 18:42:27',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=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

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

--
-- Dumping data for table `message_modes`
--

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

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

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

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

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

--
-- Table structure for table `model_has_permissions`
--

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

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

INSERT INTO `model_has_permissions` VALUES (1,'App\\Models\\User',2),(1,'App\\Models\\User',3),(1,'App\\Models\\User',4),(1,'App\\Models\\User',5),(1,'App\\Models\\User',6),(1,'App\\Models\\User',7),(1,'App\\Models\\User',8),(1,'App\\Models\\User',9),(1,'App\\Models\\User',10),(1,'App\\Models\\User',11),(1,'App\\Models\\User',12),(1,'App\\Models\\User',13),(1,'App\\Models\\User',14),(1,'App\\Models\\User',15),(1,'App\\Models\\User',16),(1,'App\\Models\\User',17),(1,'App\\Models\\User',18),(1,'App\\Models\\User',19),(1,'App\\Models\\User',20),(1,'App\\Models\\User',21),(1,'App\\Models\\User',22),(1,'App\\Models\\User',23),(1,'App\\Models\\User',24),(1,'App\\Models\\User',25),(1,'App\\Models\\User',26),(1,'App\\Models\\User',27),(1,'App\\Models\\User',28),(1,'App\\Models\\User',29),(1,'App\\Models\\User',30),(1,'App\\Models\\User',31),(1,'App\\Models\\User',32),(1,'App\\Models\\User',33),(2,'App\\Models\\User',34),(1,'App\\Models\\User',35),(1,'App\\Models\\User',36),(1,'App\\Models\\User',37),(1,'App\\Models\\User',38),(1,'App\\Models\\User',39),(1,'App\\Models\\User',40),(1,'App\\Models\\User',42),(1,'App\\Models\\User',43),(1,'App\\Models\\User',44),(1,'App\\Models\\User',45),(1,'App\\Models\\User',46),(1,'App\\Models\\User',47),(1,'App\\Models\\User',48),(1,'App\\Models\\User',49),(1,'App\\Models\\User',50),(1,'App\\Models\\User',51),(1,'App\\Models\\User',52),(1,'App\\Models\\User',53),(1,'App\\Models\\User',54),(1,'App\\Models\\User',55),(1,'App\\Models\\User',56),(1,'App\\Models\\User',57),(1,'App\\Models\\User',58),(1,'App\\Models\\User',59),(2,'App\\Models\\User',60);

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

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

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

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(2,'App\\Models\\User',3),(2,'App\\Models\\User',4),(2,'App\\Models\\User',5),(2,'App\\Models\\User',6),(2,'App\\Models\\User',7),(2,'App\\Models\\User',8),(2,'App\\Models\\User',9),(2,'App\\Models\\User',10),(2,'App\\Models\\User',11),(2,'App\\Models\\User',12),(2,'App\\Models\\User',13),(2,'App\\Models\\User',14),(2,'App\\Models\\User',15),(2,'App\\Models\\User',16),(1,'App\\Models\\User',17),(1,'App\\Models\\User',18),(1,'App\\Models\\User',19),(2,'App\\Models\\User',20),(2,'App\\Models\\User',21),(2,'App\\Models\\User',22),(2,'App\\Models\\User',23),(2,'App\\Models\\User',24),(2,'App\\Models\\User',25),(2,'App\\Models\\User',26),(2,'App\\Models\\User',27),(2,'App\\Models\\User',28),(2,'App\\Models\\User',29),(2,'App\\Models\\User',30),(2,'App\\Models\\User',31),(2,'App\\Models\\User',32),(2,'App\\Models\\User',33),(2,'App\\Models\\User',34),(2,'App\\Models\\User',35),(2,'App\\Models\\User',36),(2,'App\\Models\\User',37),(2,'App\\Models\\User',38),(2,'App\\Models\\User',39),(2,'App\\Models\\User',40),(2,'App\\Models\\User',42),(2,'App\\Models\\User',43),(2,'App\\Models\\User',44),(2,'App\\Models\\User',45),(2,'App\\Models\\User',46),(2,'App\\Models\\User',47),(2,'App\\Models\\User',48),(2,'App\\Models\\User',49),(2,'App\\Models\\User',50),(2,'App\\Models\\User',51),(2,'App\\Models\\User',52),(2,'App\\Models\\User',53),(2,'App\\Models\\User',54),(2,'App\\Models\\User',55),(2,'App\\Models\\User',56),(2,'App\\Models\\User',57),(2,'App\\Models\\User',58),(2,'App\\Models\\User',59),(2,'App\\Models\\User',60);

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

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

INSERT INTO `notifications` VALUES (16152,18,NULL,'Mikrotik Router Down','⚠️ Hi Gilbert mushi, your mikrotik router - G NJARO is offline. Please check it out.',0,'2025-10-28 23:41:39','2025-10-28 23:41:39'),(16153,18,NULL,'Mikrotik Router Up','✅ Hi Gilbert mushi, your mikrotik router - G NJARO is back online.',0,'2025-10-28 23:59:37','2025-10-28 23:59:37'),(16154,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-29 02:17:34','2025-10-29 02:17:34'),(16155,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-29 02:20:33','2025-10-29 02:20:33'),(16156,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',0,'2025-10-29 04:01:43','2025-10-29 04:01:43'),(16157,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',0,'2025-10-29 04:05:39','2025-10-29 04:05:39'),(16158,20,NULL,'Invoice Generated','Dear FiberNet HotSpot, this is a notification that your billing system subscription is expiring tomorrow (Oct 30 2025). Please pay upfront amount of Ksh 21,000 using below link; https://heritagegroup.co.ke/renew-company-router-subscription/13',0,'2025-10-29 07:02:17','2025-10-29 07:02:17'),(16159,21,NULL,'Invoice Generated','Dear Ernest Cheyo, this is a notification that your billing system subscription is expiring tomorrow (Oct 30 2025). Please pay upfront amount of Ksh 21,000 using below link; https://heritagegroup.co.ke/renew-company-router-subscription/14',0,'2025-10-29 07:02:17','2025-10-29 07:02:17'),(16160,27,NULL,'Invoice Generated','Dear Garcia, this is a reminder for you to renew your billing system subscription before Nov 03 2025 to avoid any inconveniences. Please pay upfront amount of Ksh 21,000 using below link; https://heritagegroup.co.ke/renew-company-router-subscription/20',0,'2025-10-29 07:02:18','2025-10-29 07:02:18'),(16161,40,NULL,'Mikrotik Router Down','⚠️ Hi TRIAL, your mikrotik router - Router32 is offline. Please check it out.',0,'2025-10-29 07:11:16','2025-10-29 07:11:16'),(16162,41,NULL,'Mikrotik Router Down','⚠️ Hi , your mikrotik router - Router32 is offline. Please check it out.',0,'2025-10-29 07:14:16','2025-10-29 07:14:16'),(16163,43,NULL,'Mikrotik Router Down','⚠️ Hi TRIAL, your mikrotik router - Router32 is offline. Please check it out.',0,'2025-10-29 07:18:19','2025-10-29 07:18:19'),(16164,44,NULL,'Mikrotik Router Down','⚠️ Hi TRIAL!, your mikrotik router - Router38 is offline. Please check it out.',0,'2025-10-29 07:22:21','2025-10-29 07:22:21'),(16165,45,NULL,'Mikrotik Router Down','⚠️ Hi TRIAL 2, your mikrotik router - Router39 is offline. Please check it out.',0,'2025-10-29 07:31:22','2025-10-29 07:31:22'),(16166,46,NULL,'Mikrotik Router Down','⚠️ Hi TRIAL, your mikrotik router - Router32 is offline. Please check it out.',0,'2025-10-29 07:37:19','2025-10-29 07:37:19'),(16167,47,NULL,'Mikrotik Router Down','⚠️ Hi TRIAL, your mikrotik router - Router32 is offline. Please check it out.',0,'2025-10-29 07:42:18','2025-10-29 07:42:18'),(16168,27,NULL,'Mikrotik Router Down','⚠️ Hi Garcia, your mikrotik router - Twistechs is offline. Please check it out.',0,'2025-10-29 08:51:57','2025-10-29 08:51:57'),(16169,27,NULL,'Mikrotik Router Up','✅ Hi Garcia, your mikrotik router - Twistechs is back online.',0,'2025-10-29 08:55:55','2025-10-29 08:55:55'),(16170,27,NULL,'Mikrotik Router Down','⚠️ Hi Garcia, your mikrotik router - Twistechs is offline. Please check it out.',0,'2025-10-29 09:13:58','2025-10-29 09:13:58'),(16171,27,NULL,'Mikrotik Router Up','✅ Hi Garcia, your mikrotik router - Twistechs is back online.',0,'2025-10-29 09:20:55','2025-10-29 09:20:55'),(16172,37,NULL,'Mikrotik Router Up','✅ Hi Carlos Kenyatta, your mikrotik router - Router30 is back online.',0,'2025-10-29 10:32:13','2025-10-29 10:32:13'),(16173,28,NULL,'Mikrotik Router Up','✅ Hi Kelvin Yolam, your mikrotik router - Wakizungu is back online.',0,'2025-10-29 10:57:48','2025-10-29 10:57:48'),(16174,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',0,'2025-10-29 11:43:38','2025-10-29 11:43:38'),(16175,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-29 11:43:49','2025-10-29 11:43:49'),(16176,37,NULL,'Mikrotik Router Down','⚠️ Hi Carlos Kenyatta, your mikrotik router - Router30 is offline. Please check it out.',0,'2025-10-29 11:44:16','2025-10-29 11:44:16'),(16177,18,NULL,'Mikrotik Router Down','⚠️ Hi Gilbert mushi, your mikrotik router - G NJARO is offline. Please check it out.',0,'2025-10-29 11:44:42','2025-10-29 11:44:42'),(16178,22,NULL,'Mikrotik Router Down','⚠️ Hi Manyala Agalla, your mikrotik router - Mshua Net is offline. Please check it out.',0,'2025-10-29 11:45:51','2025-10-29 11:45:51'),(16179,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-29 14:24:53','2025-10-29 14:24:53'),(16180,28,NULL,'Mikrotik Router Down','⚠️ Hi Kelvin Yolam, your mikrotik router - Wakizungu is offline. Please check it out.',0,'2025-10-29 17:48:35','2025-10-29 17:48:35'),(16181,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 18:40:47','2025-10-29 18:40:47'),(16182,27,NULL,'Mikrotik Router Down','⚠️ Hi Garcia, your mikrotik router - Twistechs is offline. Please check it out.',0,'2025-10-29 18:42:39','2025-10-29 18:42:39'),(16183,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 18:43:45','2025-10-29 18:43:45'),(16184,27,NULL,'Mikrotik Router Up','✅ Hi Garcia, your mikrotik router - Twistechs is back online.',0,'2025-10-29 18:45:37','2025-10-29 18:45:37'),(16185,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 18:52:46','2025-10-29 18:52:46'),(16186,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 18:55:45','2025-10-29 18:55:45'),(16187,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 19:28:49','2025-10-29 19:28:49'),(16188,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 19:36:51','2025-10-29 19:36:51'),(16189,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 19:39:53','2025-10-29 19:39:53'),(16190,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 19:47:52','2025-10-29 19:47:52'),(16191,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 19:50:53','2025-10-29 19:50:53'),(16192,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 20:00:53','2025-10-29 20:00:53'),(16193,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 20:08:59','2025-10-29 20:08:59'),(16194,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 20:16:58','2025-10-29 20:16:58'),(16195,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 20:28:03','2025-10-29 20:28:03'),(16196,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 20:36:01','2025-10-29 20:36:01'),(16197,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 20:44:05','2025-10-29 20:44:05'),(16198,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 20:47:03','2025-10-29 20:47:03'),(16199,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 20:57:05','2025-10-29 20:57:05'),(16200,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 21:00:03','2025-10-29 21:00:03'),(16201,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 21:03:07','2025-10-29 21:03:07'),(16202,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 21:08:15','2025-10-29 21:08:15'),(16203,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 21:24:15','2025-10-29 21:24:15'),(16204,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 21:29:13','2025-10-29 21:29:13'),(16205,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-29 21:46:17','2025-10-29 21:46:17'),(16206,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-29 21:49:17','2025-10-29 21:49:17'),(16207,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-30 01:49:23','2025-10-30 01:49:23'),(16208,20,NULL,'Invoice Generated','Dear FiberNet HotSpot, this is a notification that your billing system subscription has expired. Pay Ksh 21,000 using below link; https://heritagegroup.co.ke/renew-company-router-subscription/13 ',0,'2025-10-30 07:03:42','2025-10-30 07:03:42'),(16209,21,NULL,'Invoice Generated','Dear Ernest Cheyo, this is a notification that your billing system subscription has expired. Pay Ksh 42,000 using below link; https://heritagegroup.co.ke/renew-company-router-subscription/14 ',0,'2025-10-30 07:03:42','2025-10-30 07:03:42'),(16210,22,NULL,'Invoice Generated','Dear Manyala Agalla, this is a notification that your billing system subscription is expiring tomorrow (Oct 31 2025). Please pay upfront amount of Ksh 21,000 using below link; https://heritagegroup.co.ke/renew-company-router-subscription/15',0,'2025-10-30 07:03:42','2025-10-30 07:03:42'),(16211,23,NULL,'Invoice Generated','Dear DENIS AMINI, this is a notification that your billing system subscription is expiring tomorrow (Oct 31 2025). Please pay upfront amount of Ksh 21,000 using below link; https://heritagegroup.co.ke/renew-company-router-subscription/16',0,'2025-10-30 07:03:50','2025-10-30 07:03:50'),(16212,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-30 07:33:23','2025-10-30 07:33:23'),(16213,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',1,'2025-10-30 09:12:46','2025-10-30 14:42:04'),(16214,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-30 09:49:23','2025-10-30 09:49:23'),(16215,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-30 09:52:22','2025-10-30 09:52:22'),(16216,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',1,'2025-10-30 12:14:31','2025-10-30 14:42:04'),(16217,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',1,'2025-10-30 12:27:27','2025-10-30 14:42:04'),(16218,18,NULL,'Mikrotik Router Up','✅ Hi Gilbert mushi, your mikrotik router - G NJARO is back online.',0,'2025-10-30 13:45:24','2025-10-30 13:45:24'),(16219,22,NULL,'Mikrotik Router Up','✅ Hi Manyala Agalla, your mikrotik router - Mshua Net is back online.',0,'2025-10-30 13:45:30','2025-10-30 13:45:30'),(16220,37,NULL,'Mikrotik Router Up','✅ Hi Carlos Kenyatta, your mikrotik router - Router30 is back online.',0,'2025-10-30 13:45:51','2025-10-30 13:45:51'),(16221,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',0,'2025-10-30 13:48:51','2025-10-30 13:48:51'),(16222,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-30 13:56:39','2025-10-30 13:56:39'),(16223,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-30 13:59:40','2025-10-30 13:59:40'),(16224,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-30 14:02:39','2025-10-30 14:02:39'),(16225,37,NULL,'Mikrotik Router Down','⚠️ Hi Carlos Kenyatta, your mikrotik router - Router30 is offline. Please check it out.',0,'2025-10-30 14:07:04','2025-10-30 14:07:04'),(16226,37,NULL,'Mikrotik Router Up','✅ Hi Carlos Kenyatta, your mikrotik router - Router30 is back online.',0,'2025-10-30 14:13:02','2025-10-30 14:13:02'),(16227,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-30 14:51:31','2025-10-30 14:51:31'),(16228,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-30 15:12:49','2025-10-30 15:12:49'),(16229,22,NULL,'Mikrotik Router Down','⚠️ Hi Manyala Agalla, your mikrotik router - Mshua Net is offline. Please check it out.',0,'2025-10-30 15:12:53','2025-10-30 15:12:53'),(16230,37,NULL,'Mikrotik Router Down','⚠️ Hi Carlos Kenyatta, your mikrotik router - Router30 is offline. Please check it out.',0,'2025-10-30 15:13:16','2025-10-30 15:13:16'),(16231,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',0,'2025-10-30 15:13:36','2025-10-30 15:13:36'),(16232,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-30 15:14:36','2025-10-30 15:14:36'),(16233,18,NULL,'Mikrotik Router Down','⚠️ Hi Gilbert mushi, your mikrotik router - G NJARO is offline. Please check it out.',0,'2025-10-30 15:18:41','2025-10-30 15:18:41'),(16234,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-30 17:25:00','2025-10-30 17:25:00'),(16235,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-30 17:28:57','2025-10-30 17:28:57'),(16236,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-30 17:52:01','2025-10-30 17:52:01'),(16237,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-30 18:22:59','2025-10-30 18:22:59'),(16238,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-30 19:45:05','2025-10-30 19:45:05'),(16239,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-30 19:49:07','2025-10-30 19:49:07'),(16240,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-30 19:50:02','2025-10-30 19:50:02'),(16241,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-30 19:55:58','2025-10-30 19:55:58'),(16242,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-30 19:56:04','2025-10-30 19:56:04'),(16243,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-30 20:00:04','2025-10-30 20:00:04'),(16244,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-30 20:05:02','2025-10-30 20:05:02'),(16245,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-30 20:05:09','2025-10-30 20:05:09'),(16246,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-30 20:08:05','2025-10-30 20:08:05'),(16247,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-30 20:15:59','2025-10-30 20:15:59'),(16248,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-30 20:28:02','2025-10-30 20:28:02'),(16249,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-30 20:40:58','2025-10-30 20:40:58'),(16250,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-30 20:48:05','2025-10-30 20:48:05'),(16251,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-30 20:51:04','2025-10-30 20:51:04'),(16252,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-30 21:26:05','2025-10-30 21:26:05'),(16253,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-30 21:29:03','2025-10-30 21:29:03'),(16254,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-30 21:39:05','2025-10-30 21:39:05'),(16255,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-30 21:42:03','2025-10-30 21:42:03'),(16256,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-30 22:15:06','2025-10-30 22:15:06'),(16257,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-30 22:18:03','2025-10-30 22:18:03');

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

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

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


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

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

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

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

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

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

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

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

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

CREATE TABLE `paid_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_router_id` bigint unsigned DEFAULT NULL,
  `company_grouped_transaction_id` int DEFAULT NULL,
  `mac_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `paid_users_company_router_id_foreign` (`company_router_id`),
  CONSTRAINT `paid_users_company_router_id_foreign` FOREIGN KEY (`company_router_id`) REFERENCES `company_routers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1696 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'),(773,2,789,'02:C0:AF:A7:33:40','423957','3052','255761933535','Greetings, thank you for purchasing [plan] plan worthy 500.00. Please use [username] as the username and 3052 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-09-28 21:03:05','2025-09-28 21:03:05'),(908,2,925,'F6:1D:E3:77:F2:61','958013','6479','255781692464','Greetings, thank you for purchasing [plan] plan worthy 300.00. Please use [username] as the username and 6479 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-02 18:53:15','2025-10-02 18:53:15'),(954,2,971,'32:FE:B8:B0:34:56','046509','8688','255752578492','Greetings, thank you for purchasing [plan] plan worthy 500.00. Please use [username] as the username and 8688 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-04 10:54:54','2025-10-04 10:54:54'),(1086,15,1103,'CA:07:EA:5F:DB:02','174984','7088','255620695938','','2025-10-08 09:55:42','2025-10-08 09:55:42'),(1524,2,1541,'82:3D:CF:B1:31:9B','447295','4937','255762697291','Greetings, thank you for purchasing [plan] plan worthy 300.00. Please use [username] as the username and 4937 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-23 19:50:16','2025-10-23 19:50:16'),(1576,2,1593,'06:04:75:A8:AE:04','928664','5473','255740770996','Greetings, thank you for purchasing [plan] plan worthy 500.00. Please use [username] as the username and 5473 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-25 19:08:01','2025-10-25 19:08:01'),(1593,2,1610,'B2:41:96:EA:C0:C1','185150','4340','255717109758','Greetings, thank you for purchasing [plan] plan worthy 1000.00. Please use [username] as the username and 4340 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-26 12:27:41','2025-10-26 12:27:41'),(1606,2,1623,'26:C2:3C:DC:C7:89','759814','0605','255628187856','Greetings, thank you for purchasing [plan] plan worthy 1000.00. Please use [username] as the username and 0605 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-26 20:29:36','2025-10-26 20:29:36'),(1628,15,1645,'1E:62:6E:B6:04:B3','555859','7048','255767967942','','2025-10-27 16:20:28','2025-10-27 16:20:28'),(1636,2,1653,'0A:47:1B:5E:1E:BC','612924','2517','255780232928','Greetings, thank you for purchasing [plan] plan worthy 5000.00. Please use [username] as the username and 2517 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-27 20:08:22','2025-10-27 20:08:22'),(1662,2,1679,'3A:98:8E:E4:FF:40','775470','7990','255718522465','Greetings, thank you for purchasing [plan] plan worthy 1000.00. Please use [username] as the username and 7990 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-28 16:33:32','2025-10-28 16:33:32'),(1689,2,1706,'62:79:85:2D:CD:86','307040','2898','255743745093','Greetings, thank you for purchasing [plan] plan worthy 1000.00. Please use [username] as the username and 2898 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-29 10:23:46','2025-10-29 10:23:46');

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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `sessions` VALUES ('11YJg2TBGAO74vHnpmwDG7wrCdy3qvEqMiVEvNhB',NULL,'43.135.134.127','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoibFdPMkpsMXdycVhQOG5XZjZiVE1kVjRZN2hra0hxeHNTRkRxazNFNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9mZWF0dXJlcyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761850833),('1FbymLZWOC122Wp0wpIuH7SzHCUH5Mmzb6q9a3wm',NULL,'170.106.11.141','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWFZPb2pWaExZVHpabHNIOVlITk1VbnNpMnVqSFZxQk81TDNIQVBncSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL3Bhc3N3b3JkL3Jlc2V0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761848022),('2abg3ev3n8vLc8Fz0fW4vODpkKeSzr0m30lVjrwc',NULL,'154.159.237.232','Mozilla/5.0 (Linux; Android 10; V2002A Build/QP1A.190711.020; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/139.0.7258.158 Mobile Safari/537.36 musical_ly_2024109030 AppName/musical_ly ByteLocale/en','YTozOntzOjY6Il90b2tlbiI7czo0MDoicDU0bkJxWm9ZVE1WaHBTMkh3U1R0dWpZUkJTb3VXdUN5dzhCTTd0USI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761838359),('2lRQtpn7pV3k0BtoN73GoSiMrqu8AewZlyCy91mT',NULL,'138.199.35.8','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSXcxZnEyVjlPU2dReXlFYjdiWXFwUTdqVHR0NFo3UTNOZzFlOUhYbyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761832405),('4Cy8tmHbxaprjkr5qJUOdZhnLmnoWQk9xK6rcNR1',NULL,'129.222.187.155','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNDBQcFBURFFocFI0N0F6UHk4RXI1NW55V0luU09BVUhxR3luZEtKdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761843451),('565jv16aYJtPmxOU5ifC2u286F8OQ2iE3oYQdxy8',NULL,'66.249.79.164','Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.7390.122 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSGhzVFdiYVpLYjBEQzVvSHJNQ2VPNFNlQmlDRGxGVTZaSTFCbFpHRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vd3d3Lmhlcml0YWdlZ3JvdXAuY28ua2UiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1761844930),('8w5RpX2srBGUjpjBaa0xyDgl4jYF1OAtQ85F57aP',NULL,'31.13.127.2','facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)','YTozOntzOjY6Il90b2tlbiI7czo0MDoib2t0Zzh0cGN0bTdxcjBuN3JKZVE3VDNOQ09sT0Q2ZEF4Qk5BOENqaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761828876),('9eBhysRrpGW96fTpU6SyCIKLC19RVPvDB4kUlBuh',NULL,'43.135.145.117','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYmdLczB5cXIzRENTcHBWU0tzcm5kSk9yYkVBQ1RsbDRCMXk3MXl2VSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xNjEuOTcuMTc0LjIwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761829531),('9HSzbccE4DH4rtZiBMgV8k15ezWh9gnwaBYM2Ocg',NULL,'43.130.57.46','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiUnJhNzZUOE1OTFBTdTZJaEJhU1hjMHh1a2dmTzJDT3cxOXZ6eXhsZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9yZWdpc3RlciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761849172),('arOrZxM8weQ7rr8MbcVmNvvztM7wCLfQxjVAzTj6',NULL,'69.171.251.7','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoielJaNzV2c1dMaTNJZEZMMnpwZGc5VVNRYW00Q2s3akZHVWVMTUlHcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTQyOiJodHRwOi8vaGVyaXRhZ2Vncm91cC5jby5rZS8/ZmJjbGlkPUl3WlhoMGJnTmhaVzBDTVRFQUFSNENVYlJGa1M0XzE3UVRwWElENE1ncldpSnRoeHlvYUlmSVBUUURaVHRDcEdUTU1PVkNIb0NjTWVVelVBX2FlbV9CMnFITlpLWF96dEdTYnpraFNGTTRBIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761828877),('AucnwEEcGH2YeZwQg4R1lxvbkl1DlFTSCNbYBmAO',NULL,'107.21.63.239','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.3','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ0ZPMHp5MEFNR0hZTkhQb0xlWVR0WEhiRHVxdkJ4dllpbVNveENCSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761828518),('bHnjHXpw7DEsnUEMbNC2t6IHR2HoM2QzFlu1p1NU',NULL,'216.10.250.218','libredtail-http','YTozOntzOjY6Il90b2tlbiI7czo0MDoiemlENURhNmZNVEV6VkdJck53NThQbzlUSkM1SmhyM1hQNlNLWmxOViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTUzOiJodHRwOi8vMTYxLjk3LjE3NC4yMC9wdWJsaWMvaW5kZXgucGhwP2Z1bmN0aW9uPWNhbGxfdXNlcl9mdW5jX2FycmF5JnM9JTJGaW5kZXglMkYlNUN0aGluayU1Q2FwcCUyRmludm9rZWZ1bmN0aW9uJnZhcnMlNUIwJTVEPW1kNSZ2YXJzJTVCMSU1RCU1QjAlNUQ9SGVsbG8iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1761837238),('bIvuBJfkZfiQP9HYCTcEh843H9HBJJuiNeWYtxLG',NULL,'182.43.70.143','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoicnJRd0l5TnJtQ3JEeVVpbFFDWGtqWFRGeVc4SVI1RWRkYVY4bWVxaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761847984),('bSvA4CgIPatHvswiILB17wuCs3oDaV4mhX6iWMfO',NULL,'142.250.32.40','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiS1pVdThjNDRvR2RLWVRPMUJnejQ1WDVQUWlXT2lnVU5SWjV0cU5FTyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0NDoiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL3ByZXBhaWQtdm91Y2hlcnMiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NDoiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL3ByZXBhaWQtdm91Y2hlcnMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1761847112),('CKtyO7M5s3Lvo4QQV5DzWv7pnh113GbgpFQSsTOK',NULL,'142.250.32.39','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiS1I3S3c5SUlJaFdURHN6YTZ0SGdZaEhOSGtlYk83MDNjckg3NlNMZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761847112),('CojpoKkIV3nj93akaNsBKDgkMhlkCdlEo0bBxxpe',NULL,'43.166.247.82','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiamFlQWxIdnJsMTUzcUtGY3BZV3ZoQ21EYmlEQVNTYjZaMDhFM2VJSCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761848475),('DNly0eqFlfVPlmr9lFi5m6XyZGBZUtX7kUQvlzGU',NULL,'43.157.158.178','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiV2E5UXpmQU00cFFaUEhGakYwTUxLTFhWZG5SZ1ZCVlBOZ3U3TXdGNCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL2Fib3V0LXVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761846546),('F1UROfKHHaCrTppXHTgRBqQG0sXCfYNyxjpI91VI',NULL,'43.166.134.114','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRjdjSTJObllyQkw3VXlNMjhQdlpXbWkyWWdlY1djM2lvQ1hjaWZIRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHA6Ly8xNjEtOTctMTc0LTAyMC5jcHJhcGlkLmNvbS9wdWJsaWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1761834841),('gdhB3Cg8o0TCgZ0jtCNiioFSmQDSbtwY8v0zgFgO',NULL,'41.59.136.247','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoiZlVXVUx3aXNjdUdvNVp3d2JPQWN6VkhmS2tRYzNLZnlBUUt6ZUw1TiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761828878),('GLkrwc1IxoabVYccWHhs1mW7biyFpzjS35WOJ28D',NULL,'43.130.16.212','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoieXpnZzRPZXFvRGRjc1FLZ3BVOUFqNUNCcGRnZVFIWTNxVVR6dER6TyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDc6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL3Rlcm1zLWFuZC1jb25kaXRpb25zIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761843634),('hvfpMyHC0SsIacaEBD5OXz9jHsxFwKpcmguhcNzo',NULL,'66.249.79.163','Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.84 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoicTBYdTE5bU9QVG95ME95S1dqQ3B5TmlWQ3NqUE4wSmVzdVNmeEVIQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761840448),('KxDrW7SqEPjAn2DUt5XwldqrmZxBrIHOfc6K6Brw',NULL,'54.242.188.15','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:35.0) Gecko/20100101 Firefox/35.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaHd4VzFrYmsyVUZyUE9iNjRwVDFxaWkwbm84T0ZYaVpHR2l2VnFhOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761831850),('lcX4G3BjnHSUB2EHxuOTmCcQYdngbpV0q7x1dTea',40,'197.239.11.89','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36','[encoded data, 9720 characters]',1761831094),('ljnaGA5CXGuK8hh20H7vnYX5NKNfc0VgjVRNDhg1',NULL,'146.70.11.55','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiakN2N2RvYmFsT0RGNHZCN3I2NUJEdm1OeXpidkN3YWIyQ25xZkVjNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761853165),('LuedryAzRLBFswMhhAdRA1KqDt55wstnoRviJaBO',NULL,'69.171.249.3','facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiODhoMFFDbjJnUHp3ZEFUcHh0MUZZb1NKWVZjb1ROeHMwRHBzWXVWdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761818719),('LywUudPQLVPlucybZHuNYAHxF7dy0Z2Yt2OYxImZ',NULL,'142.250.32.41','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoidnNvUnpQYzJPR0ROMDFCZGVoSjBEeEI3cWhlWjY0U3o3ckFyWm9hWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761843143),('myORzJhFJWHBpII8KGfHYzShcXZ54a8d6jQFnJCC',NULL,'66.249.79.163','Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMm9CU3ByWkxiMXVKQ0xuQ2RVOXlIZVo4elVVblVhY2lCR3ZwcVVzVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cuaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761840448),('N6LGjCIEeaLk9USBsBISzLM0bRzOi2wOmQWn6FFu',15,'41.59.136.247','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:144.0) Gecko/20100101 Firefox/144.0','[encoded data, 368402 characters]