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

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

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

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

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

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

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

INSERT INTO `notifications` VALUES (15686,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-20 22:01:01','2025-10-20 22:01:01'),(15687,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-20 22:02:44','2025-10-20 22:02:44'),(15688,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-20 22:04:59','2025-10-20 22:04:59'),(15689,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-21 01:24:46','2025-10-21 01:24:46'),(15690,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-21 01:27:45','2025-10-21 01:27:45'),(15691,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-21 03:58:46','2025-10-21 03:58:46'),(15692,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-21 04:02:45','2025-10-21 04:02:45'),(15693,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-21 05:17:57','2025-10-21 05:17:57'),(15694,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-21 05:31:55','2025-10-21 05:31:55'),(15695,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',1,'2025-10-21 07:00:38','2025-10-21 08:35:33'),(15696,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-21 07:00:48','2025-10-21 07:00:48'),(15697,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-21 07:03:48','2025-10-21 07:03:48'),(15698,28,NULL,'Mikrotik Router Up','✅ Hi Kelvin Yolam, your mikrotik router - Wakizungu is back online.',0,'2025-10-21 07:22:52','2025-10-21 07:22:52'),(15699,18,NULL,'Mikrotik Router Up','✅ Hi Gilbert mushi, your mikrotik router - G NJARO is back online.',0,'2025-10-21 08:06:40','2025-10-21 08:06:40'),(15700,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-21 08:12:40','2025-10-21 08:12:40'),(15701,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-21 08:15:38','2025-10-21 08:15:38'),(15702,22,NULL,'Mikrotik Router Down','⚠️ Hi Manyala Agalla, your mikrotik router - Mshua Net is offline. Please check it out.',0,'2025-10-21 09:45:48','2025-10-21 09:45:48'),(15703,22,NULL,'Mikrotik Router Up','✅ Hi Manyala Agalla, your mikrotik router - Mshua Net is back online.',0,'2025-10-21 09:49:49','2025-10-21 09:49:49'),(15704,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-21 09:58:48','2025-10-21 09:58:48'),(15705,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-21 10:03:46','2025-10-21 10:03:46'),(15706,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',1,'2025-10-21 10:38:26','2025-10-21 11:00:29'),(15707,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',1,'2025-10-21 12:39:29','2025-10-21 13:49:27'),(15708,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',1,'2025-10-21 12:42:26','2025-10-21 13:49:35'),(15709,22,NULL,'Mikrotik Router Down','⚠️ Hi Manyala Agalla, your mikrotik router - Mshua Net is offline. Please check it out.',0,'2025-10-21 13:57:37','2025-10-21 13:57:37'),(15710,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-21 13:59:40','2025-10-21 13:59:40'),(15711,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-21 14:03:33','2025-10-21 14:03:33'),(15712,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-21 14:05:45','2025-10-21 14:05:45'),(15713,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-21 14:08:49','2025-10-21 14:08:49'),(15714,22,NULL,'Mikrotik Router Up','✅ Hi Manyala Agalla, your mikrotik router - Mshua Net is back online.',0,'2025-10-21 15:39:35','2025-10-21 15:39:35'),(15715,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-21 16:00:34','2025-10-21 16:00:34'),(15716,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-21 16:03:32','2025-10-21 16:03:32'),(15717,22,NULL,'Mikrotik Router Down','⚠️ Hi Manyala Agalla, your mikrotik router - Mshua Net is offline. Please check it out.',0,'2025-10-21 16:55:36','2025-10-21 16:55:36'),(15718,22,NULL,'Mikrotik Router Up','✅ Hi Manyala Agalla, your mikrotik router - Mshua Net is back online.',0,'2025-10-21 16:59:39','2025-10-21 16:59:39'),(15719,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-21 17:49:49','2025-10-21 17:49:49'),(15720,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-21 17:52:46','2025-10-21 17:52:46'),(15721,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-21 18:09:48','2025-10-21 18:09:48'),(15722,28,NULL,'Mikrotik Router Down','⚠️ Hi Kelvin Yolam, your mikrotik router - Wakizungu is offline. Please check it out.',0,'2025-10-21 18:13:44','2025-10-21 18:13:44'),(15723,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-21 18:14:47','2025-10-21 18:14:47'),(15724,28,NULL,'Mikrotik Router Up','✅ Hi Kelvin Yolam, your mikrotik router - Wakizungu is back online.',0,'2025-10-21 18:16:41','2025-10-21 18:16:41'),(15725,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-21 18:20:48','2025-10-21 18:20:48'),(15726,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-21 18:25:47','2025-10-21 18:25:47'),(15727,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-21 18:29:48','2025-10-21 18:29:48'),(15728,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-21 18:32:47','2025-10-21 18:32:47'),(15729,22,NULL,'Mikrotik Router Down','⚠️ Hi Manyala Agalla, your mikrotik router - Mshua Net is offline. Please check it out.',0,'2025-10-21 18:42:37','2025-10-21 18:42:37'),(15730,22,NULL,'Mikrotik Router Up','✅ Hi Manyala Agalla, your mikrotik router - Mshua Net is back online.',0,'2025-10-21 18:46:36','2025-10-21 18:46:36'),(15731,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-21 18:50:47','2025-10-21 18:50:47'),(15732,28,NULL,'Mikrotik Router Down','⚠️ Hi Kelvin Yolam, your mikrotik router - Wakizungu is offline. Please check it out.',0,'2025-10-21 18:52:44','2025-10-21 18:52:44'),(15733,28,NULL,'Mikrotik Router Up','✅ Hi Kelvin Yolam, your mikrotik router - Wakizungu is back online.',0,'2025-10-21 18:55:42','2025-10-21 18:55:42'),(15734,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-21 19:00:46','2025-10-21 19:00:46'),(15735,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-21 19:04:48','2025-10-21 19:04:48'),(15736,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-21 19:08:47','2025-10-21 19:08:47'),(15737,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',1,'2025-10-21 19:21:28','2025-10-22 17:18:32'),(15738,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-21 19:26:50','2025-10-21 19:26:50'),(15739,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-21 19:29:48','2025-10-21 19:29:48'),(15740,28,NULL,'Mikrotik Router Down','⚠️ Hi Kelvin Yolam, your mikrotik router - Wakizungu is offline. Please check it out.',0,'2025-10-21 19:41:45','2025-10-21 19:41:45'),(15741,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-21 19:57:51','2025-10-21 19:57:51'),(15742,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-21 19:59:36','2025-10-21 19:59:36'),(15743,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-21 20:03:35','2025-10-21 20:03:35'),(15744,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-21 20:06:51','2025-10-21 20:06:51'),(15745,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-21 20:55:53','2025-10-21 20:55:53'),(15746,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-21 20:58:51','2025-10-21 20:58:51'),(15747,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-21 21:21:51','2025-10-21 21:21:51'),(15748,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-21 21:31:49','2025-10-21 21:31:49'),(15749,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-21 22:00:40','2025-10-21 22:00:40'),(15750,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',1,'2025-10-21 22:02:31','2025-10-22 17:18:24'),(15751,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-21 22:03:37','2025-10-21 22:03:37'),(15752,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-21 23:03:33','2025-10-21 23:03:33'),(15753,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',1,'2025-10-21 23:07:30','2025-10-22 17:18:41'),(15754,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-22 01:59:41','2025-10-22 01:59:41'),(15755,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-22 02:02:40','2025-10-22 02:02:40'),(15756,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-22 05:11:43','2025-10-22 05:11:43'),(15757,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-22 05:18:41','2025-10-22 05:18:41'),(15758,28,NULL,'Mikrotik Router Up','✅ Hi Kelvin Yolam, your mikrotik router - Wakizungu is back online.',0,'2025-10-22 07:00:45','2025-10-22 07:00:45'),(15759,32,NULL,'Mikrotik Router Down','⚠️ Hi Moses Mousa, your mikrotik router - Moxetech is offline. Please check it out.',0,'2025-10-22 07:25:48','2025-10-22 07:25:48'),(15760,32,NULL,'Mikrotik Router Up','✅ Hi Moses Mousa, your mikrotik router - Moxetech is back online.',0,'2025-10-22 07:28:47','2025-10-22 07:28:47'),(15761,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',0,'2025-10-22 09:56:30','2025-10-22 09:56:30'),(15762,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',0,'2025-10-22 09:59:26','2025-10-22 09:59:26'),(15763,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-22 10:00:35','2025-10-22 10:00:35'),(15764,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-22 10:03:32','2025-10-22 10:03:32'),(15765,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-22 10:41:44','2025-10-22 10:41:44'),(15766,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',0,'2025-10-22 11:02:30','2025-10-22 11:02:30'),(15767,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',0,'2025-10-22 11:05:25','2025-10-22 11:05:25'),(15768,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-22 12:11:42','2025-10-22 12:11:42'),(15769,28,NULL,'Mikrotik Router Down','⚠️ Hi Kelvin Yolam, your mikrotik router - Wakizungu is offline. Please check it out.',0,'2025-10-22 13:55:42','2025-10-22 13:55:42'),(15770,28,NULL,'Mikrotik Router Up','✅ Hi Kelvin Yolam, your mikrotik router - Wakizungu is back online.',0,'2025-10-22 13:58:41','2025-10-22 13:58:41'),(15771,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-22 13:59:34','2025-10-22 13:59:34'),(15772,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-22 14:02:33','2025-10-22 14:02:33'),(15773,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-22 15:39:34','2025-10-22 15:39:34'),(15774,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-22 16:04:45','2025-10-22 16:04:45'),(15775,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-22 16:10:32','2025-10-22 16:10:32'),(15776,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-22 16:37:41','2025-10-22 16:37:41'),(15777,29,NULL,'Mikrotik Router Down','⚠️ Hi Trekker, your mikrotik router - Trekker is offline. Please check it out.',0,'2025-10-22 17:25:48','2025-10-22 17:25:48'),(15778,28,NULL,'Mikrotik Router Down','⚠️ Hi Kelvin Yolam, your mikrotik router - Wakizungu is offline. Please check it out.',0,'2025-10-22 18:22:43','2025-10-22 18:22:43'),(15779,29,NULL,'Mikrotik Router Up','✅ Hi Trekker, your mikrotik router - Trekker is back online.',0,'2025-10-22 18:22:44','2025-10-22 18:22:44'),(15780,28,NULL,'Mikrotik Router Up','✅ Hi Kelvin Yolam, your mikrotik router - Wakizungu is back online.',0,'2025-10-22 18:25:46','2025-10-22 18:25:46'),(15781,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-22 18:36:35','2025-10-22 18:36:35'),(15782,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-22 18:40:36','2025-10-22 18:40:36'),(15783,28,NULL,'Mikrotik Router Down','⚠️ Hi Kelvin Yolam, your mikrotik router - Wakizungu is offline. Please check it out.',0,'2025-10-22 19:22:43','2025-10-22 19:22:43'),(15784,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Machinga Complex is offline. Please check it out.',0,'2025-10-22 19:59:28','2025-10-22 19:59:28'),(15785,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Machinga Complex is back online.',0,'2025-10-22 20:02:26','2025-10-22 20:02:26'),(15786,8,NULL,'Mikrotik Router Down','⚠️ Hi Erick, your mikrotik router - Ngoni Net 1 is offline. Please check it out.',0,'2025-10-22 20:23:29','2025-10-22 20:23:29'),(15787,8,NULL,'Mikrotik Router Up','✅ Hi Erick, your mikrotik router - Ngoni Net 1 is back online.',0,'2025-10-22 20:27:26','2025-10-22 20:27:26'),(15788,20,NULL,'Mikrotik Router Down','⚠️ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is offline. Please check it out.',0,'2025-10-22 21:59:42','2025-10-22 21:59:42'),(15789,20,NULL,'Mikrotik Router Up','✅ Hi FiberNet HotSpot, your mikrotik router - Mkiwa is back online.',0,'2025-10-22 22:02:40','2025-10-22 22:02:40');

--
-- 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=1496 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'),(1484,2,1501,'EE:F7:43:4A:79:AC','063820','4183','255785686231','Greetings, thank you for purchasing [plan] plan worthy 500.00. Please use [username] as the username and 4183 as your password to reconnect yourself. Your subscription expires at [expiry_date].','2025-10-22 13:28:10','2025-10-22 13:28:10');

--
-- 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 ('CmiEFVPzuqYGXd6U6kz1PgNZpS3N413taDDmRBEB',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)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiUHpVekRYdk5vQkxXRHpQUEtVSllFQUozUUlCMU5NcEVUNlpiYlRGNyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1MjoiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL3NlcnZpY2UtcGxhbi1jdXN0b21lcnMvMSI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjUyOiJodHRwczovL2hlcml0YWdlZ3JvdXAuY28ua2Uvc2VydmljZS1wbGFuLWN1c3RvbWVycy8xIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761158621),('DZfQYwE1eZFI4I69IAsAuLosP5XRGxbMkQTPjWVv',NULL,'104.248.75.7','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:59.0) Gecko/20100101 Firefox/59.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWVYxTk5EQUxvaXFyVDNOYTVQNEY3WnR6NTdjSlh4N2VhQW9SR1NZQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vd3d3Lmhlcml0YWdlZ3JvdXAuY28ua2UiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1761160383),('e2Mlcvx9UdsOZxps105OiTt7ix9uZTbpUvlRMw1A',NULL,'197.239.12.121','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Mobile Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNUI0bkxSNGhDanc4NGE4eFVndU1PQXU3WEp2M3VnYUdnNDFNU2JiYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NDoiYXV0aCI7YToxOntzOjIxOiJwYXNzd29yZF9jb25maXJtZWRfYXQiO2k6MTc2MTE1ODY5Mzt9fQ==',1761159375),('Legpvq3xN9Dytr9sn8ToAOzrog3t2eZqYxXg51Bg',NULL,'154.159.252.60','Mozilla/5.0 (Linux; Android 11; TECNO KF8 Build/RP1A.200720.011; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/141.0.7390.97 Mobile Safari/537.36 musical_ly_2024202030 AppName/musical_ly ByteLocale/en','YTozOntzOjY6Il90b2tlbiI7czo0MDoiekpWQVFVMGpPeWlUdFc3SVBUcldkcExMbUF1enc2NWp6M0FHYzlZSiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761164170),('LQWiehzokhEJlAnOl2nayrP9rgTsCNl2UTzVvYnn',44,'197.239.7.197','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Mobile Safari/537.36','[encoded data, 9504 characters]',1761160087),('nXc9k9YxbFRgZTZ5EnvPSkZaqBOBGAdlPjEb8vO2',30,'197.186.2.154','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Mobile Safari/537.36','[encoded data, 49924 characters]',1761158622),('oJN7G0liqlsrgT8JTeLmPkYwe8zdODscLdZb5P5l',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)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSVB6VDNyeFJFYmFYWnFyN2xxdFEzOXBLVHhtRVBkdndxQVRQNWFVaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761158621),('ouU4iS2WMJM7XxBk6CgBBf0cJl69WOFIT0rUhGek',30,'41.59.25.125','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36','[encoded data, 46024 characters]',1761167418),('qerNglDoBsTSo4Dqz0V5OEGs2ald0efZGVloZ70F',NULL,'43.130.53.252','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOWF4dW0xUkxsbkpJbGw1VUEzdUIxaU5CSU9ZM0gybFJHaVNFd2xSSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHA6Ly9vcGlmZXgub3BpZmV4dGVjaG5vbG9neS5jb20vcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761154973),('r7HhiHYGRCRZTy0ybkJx5LQd3GzADmMb270q9kQl',NULL,'129.222.147.74','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiS3cwclVkT2UyWDhMOUladlBLU0w5aTZjWTNoalVNNmV3VzdZdkRNWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vd3d3Lmhlcml0YWdlZ3JvdXAuY28ua2UvcmVnaXN0ZXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1761157390),('rn3crY8OPDK0S47ck5FXhMztXHVzW7IiBFCYGG2O',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)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNTdEMktzZDRsb2lLcEE4TnlvWmR2M0tRRW5LRDJNMEZDOFZocDBDZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1761160087),('T1YEULR0hrP6NuCHhWR4W0hFHje0heBYBMM7XazY',NULL,'103.146.23.178','libredtail-http','YTozOntzOjY6Il90b2tlbiI7czo0MDoiakI1OFpEOEFEWERvZWxWMWM3VnRUSHBZVDZpYjZsOGhNRmQ4WTZxYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTUzOiJodHRwOi8vMTYxLjk3LjE3NC4yMC9wdWJsaWMvaW5kZXgucGhwP2Z1bmN0aW9uPWNhbGxfdXNlcl9mdW5jX2FycmF5JnM9JTJGaW5kZXglMkYlNUN0aGluayU1Q2FwcCUyRmludm9rZWZ1bmN0aW9uJnZhcnMlNUIwJTVEPW1kNSZ2YXJzJTVCMSU1RCU1QjAlNUQ9SGVsbG8iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1761156681),('TlLWde1PDHhDUxsmKXoMiLVWrHaYvk3UQgo5ruln',NULL,'43.132.214.228','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTGdSTmZ0RmRuNmhXRUkzYWZ0MHI5NEpMalJUTE1uNEh0amVqMHljRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1761161561),('u4yJYfaY3pIpIPp5GQnKqZ9yCjHGScdHg0hXtwx7',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)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQ2ZMRjZwbkd2NDZzbktCcFdLTnByMFQyVmJuS0RXZ21tNkVycHpPRCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozMjoiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL2hvbWUiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozMjoiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlL2hvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1761158533),('VCxxqaUx5i5KG2kywp7NRGioielqmOdr6g4vj2eU',15,'41.59.110.160','Mozilla/5.0 (Linux; U; Android 13; en-us; Infinix X6528 Build/TP1A.220624.014) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.6367.123 Mobile Safari/537.36 PHX/19.7','[encoded data, 334760 characters]