[encoded data, 85910 characters]',1756179937),('XXZmlDtRwNaihlP3rGc5botpy2gwQNHhTji02ups',NULL,'43.165.70.220','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','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRUY4Z2RUcnI2TkVRd3pVclVJcVpVR0U3TkhCNEdNSGZ5YXI1NUtzTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1756194048);

--
-- Table structure for table `sms_provider_requirements`
--

CREATE TABLE `sms_provider_requirements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sms_provider_id` bigint unsigned NOT NULL,
  `sms_requirement_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sms_provider_requirements_sms_provider_id_foreign` (`sms_provider_id`),
  KEY `sms_provider_requirements_sms_requirement_id_foreign` (`sms_requirement_id`),
  CONSTRAINT `sms_provider_requirements_sms_provider_id_foreign` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sms_provider_requirements_sms_requirement_id_foreign` FOREIGN KEY (`sms_requirement_id`) REFERENCES `sms_requirements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_provider_requirements`
--

INSERT INTO `sms_provider_requirements` VALUES (1,1,1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(2,1,3,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(3,1,4,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(4,2,1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(5,2,5,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(6,2,2,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(7,4,1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(8,4,2,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL);

--
-- Table structure for table `sms_providers`
--

CREATE TABLE `sms_providers` (
  `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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_providers`
--

INSERT INTO `sms_providers` VALUES (1,'1','Hostpinnacle',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(2,'2','Ujumbe SMS',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(3,'3','Africas Talking',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(4,'4','Talk Sasa',1,'2025-08-03 19:10:04','2025-08-03 19:10:04',NULL);

--
-- Table structure for table `sms_requirements`
--

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

--
-- Dumping data for table `sms_requirements`
--

INSERT INTO `sms_requirements` VALUES (1,'Sender ID','sender_id','2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(2,'API Key','api_key','2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(3,'Sms User ID','sms_user_id','2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(4,'Password','password','2025-08-03 19:10:04','2025-08-03 19:10:04',NULL),(5,'Email','email','2025-08-03 19:10:04','2025-08-03 19:10:04',NULL);

--
-- Table structure for table `sms_template_types`
--

CREATE TABLE `sms_template_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=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_template_types`
--

INSERT INTO `sms_template_types` VALUES (1,'Upcoming plan/package expiry','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(2,'Invoice notification','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(3,'Payment confirmation','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(4,'Payment reminder','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(5,'Overdue payment warning','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(6,'Service disconnection notice','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(7,'Service restoration notification','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(8,'New subscription confirmation','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(9,'Plan upgrade or downgrade confirmation','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(10,'Service maintenance notification','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(11,'Service outage alert','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL),(12,'Hotspot Plan Purchase','2025-08-03 19:10:08','2025-08-03 19:10:08',NULL);

--
-- Table structure for table `temporary_grouped_transactions`
--

CREATE TABLE `temporary_grouped_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `originator_conversation_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `grouped_transaction_id` int NOT NULL,
  `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 `temporary_grouped_transactions`
--


--
-- Table structure for table `temporary_transaction_checks`
--

CREATE TABLE `temporary_transaction_checks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_service_plan_id` int DEFAULT NULL,
  `company_id` int DEFAULT NULL,
  `company_router_id` int DEFAULT NULL,
  `company_router_invoice_id` int DEFAULT NULL,
  `company_customer_id` int DEFAULT NULL,
  `mac_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checkout_id` varchar(191) 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `temporary_transaction_checks`
--

INSERT INTO `temporary_transaction_checks` VALUES (1,6,NULL,NULL,NULL,NULL,'F6:2F:D5:3F:00:CE','046507',210.00,'2025-08-06 04:40:29','2025-08-06 04:40:29'),(2,6,NULL,NULL,NULL,NULL,'E8:B1:FC:9B:E3:7B','998553',210.00,'2025-08-06 18:32:33','2025-08-06 18:32:33'),(3,6,NULL,NULL,NULL,NULL,'16:54:CC:BC:13:7C','070146',210.00,'2025-08-06 19:59:25','2025-08-06 19:59:25'),(5,8,NULL,NULL,NULL,NULL,'C2:BC:EF:F6:65:29','918352',500.00,'2025-08-07 14:29:21','2025-08-07 14:29:21'),(6,9,NULL,NULL,NULL,NULL,'D4:67:D3:E3:17:BD','608888',1000.00,'2025-08-07 17:08:13','2025-08-07 17:08:13'),(7,9,NULL,NULL,NULL,NULL,'D4:67:D3:E3:17:BD','163593',1000.00,'2025-08-07 18:00:59','2025-08-07 18:00:59'),(9,8,NULL,NULL,NULL,NULL,'5E:32:CC:C1:11:35','995680',500.00,'2025-08-08 08:09:49','2025-08-08 08:09:49'),(11,9,NULL,NULL,NULL,NULL,'86:65:3C:6B:E1:84','586454',1000.00,'2025-08-08 21:53:41','2025-08-08 21:53:41'),(15,6,NULL,NULL,NULL,NULL,'72:4C:D3:24:6F:37','684402',210.00,'2025-08-10 11:52:17','2025-08-10 11:52:17'),(18,9,NULL,NULL,NULL,NULL,'86:65:3C:6B:E1:84','880636',1000.00,'2025-08-11 19:00:03','2025-08-11 19:00:03'),(20,9,NULL,NULL,NULL,NULL,'BE:9E:B9:04:25:17','410059',1000.00,'2025-08-13 19:39:06','2025-08-13 19:39:06'),(21,9,NULL,NULL,NULL,NULL,'BE:9E:B9:04:25:17','013420',1000.00,'2025-08-13 19:40:12','2025-08-13 19:40:12'),(23,7,NULL,NULL,NULL,NULL,'3A:C9:5E:87:3C:AA','964274',300.00,'2025-08-15 12:27:45','2025-08-15 12:27:45'),(25,8,NULL,NULL,NULL,NULL,'72:82:9F:D3:BA:72','228543',500.00,'2025-08-17 06:30:45','2025-08-17 06:30:45'),(26,9,NULL,NULL,NULL,NULL,'72:82:9F:D3:BA:72','040733',1000.00,'2025-08-17 06:32:48','2025-08-17 06:32:48'),(27,9,NULL,NULL,NULL,NULL,'72:82:9F:D3:BA:72','373924',1000.00,'2025-08-17 06:41:33','2025-08-17 06:41:33'),(28,9,NULL,NULL,NULL,NULL,'EA:58:A4:7A:3F:40','505401',1000.00,'2025-08-17 15:42:00','2025-08-17 15:42:00'),(29,6,NULL,NULL,NULL,NULL,'22:7F:8F:03:CE:EB','740885',210.00,'2025-08-17 15:42:42','2025-08-17 15:42:42'),(30,9,NULL,NULL,NULL,NULL,'EA:58:A4:7A:3F:40','713354',1000.00,'2025-08-17 15:43:07','2025-08-17 15:43:07'),(31,9,NULL,NULL,NULL,NULL,'86:65:3C:6B:E1:84','706706',1000.00,'2025-08-17 21:15:14','2025-08-17 21:15:14'),(32,9,NULL,NULL,NULL,NULL,'86:65:3C:6B:E1:84','933255',1000.00,'2025-08-17 21:16:49','2025-08-17 21:16:49'),(33,9,NULL,NULL,NULL,NULL,'BA:71:D2:D8:D2:D0','092509',1000.00,'2025-08-18 21:56:30','2025-08-18 21:56:30'),(34,8,NULL,NULL,NULL,NULL,'30:FC:EB:7A:0C:90','201884',500.00,'2025-08-19 09:08:32','2025-08-19 09:08:32'),(35,8,NULL,NULL,NULL,NULL,'20:2B:20:82:46:81','186315',500.00,'2025-08-19 09:33:30','2025-08-19 09:33:30'),(36,9,NULL,NULL,NULL,NULL,'EA:58:A4:7A:3F:40','416356',1000.00,'2025-08-19 12:57:38','2025-08-19 12:57:38'),(37,6,NULL,NULL,NULL,NULL,'CE:27:A9:53:A7:97','978587',210.00,'2025-08-19 15:40:10','2025-08-19 15:40:10'),(38,9,NULL,NULL,NULL,NULL,'72:82:9F:D3:BA:72','422101',1000.00,'2025-08-19 17:08:18','2025-08-19 17:08:18'),(39,24,NULL,NULL,NULL,NULL,'5A:90:84:47:BA:75','406449',2500.00,'2025-08-19 17:36:19','2025-08-19 17:36:19'),(40,24,NULL,NULL,NULL,NULL,'62:06:D0:8C:47:36','631740',2500.00,'2025-08-19 17:44:11','2025-08-19 17:44:11'),(41,24,NULL,NULL,NULL,NULL,'62:06:D0:8C:47:36','151565',2500.00,'2025-08-19 17:47:47','2025-08-19 17:47:47'),(42,7,NULL,NULL,NULL,NULL,'FE:96:EF:57:F0:70','545418',300.00,'2025-08-19 17:53:30','2025-08-19 17:53:30'),(43,6,NULL,NULL,NULL,NULL,'CE:74:22:E0:34:EE','641494',210.00,'2025-08-19 17:57:06','2025-08-19 17:57:06'),(44,9,NULL,NULL,NULL,NULL,'F6:15:EE:D6:C1:32','400618',1000.00,'2025-08-19 18:41:59','2025-08-19 18:41:59'),(45,7,NULL,NULL,NULL,NULL,'FE:96:EF:57:F0:70','571353',300.00,'2025-08-19 18:46:25','2025-08-19 18:46:25'),(46,23,NULL,NULL,NULL,NULL,'BE:1F:0E:C7:2C:2E','566876',15000.00,'2025-08-19 19:33:28','2025-08-19 19:33:28'),(47,23,NULL,NULL,NULL,NULL,'BE:1F:0E:C7:2C:2E','135696',15000.00,'2025-08-19 19:35:14','2025-08-19 19:35:14'),(48,23,NULL,NULL,NULL,NULL,'BE:1F:0E:C7:2C:2E','580077',15000.00,'2025-08-19 19:37:53','2025-08-19 19:37:53'),(49,9,NULL,NULL,NULL,NULL,'E6:12:A3:41:F4:AD','583196',1000.00,'2025-08-19 20:09:08','2025-08-19 20:09:08'),(50,9,NULL,NULL,NULL,NULL,'E6:12:A3:41:F4:AD','665552',1000.00,'2025-08-19 20:15:22','2025-08-19 20:15:22'),(51,6,NULL,NULL,NULL,NULL,'5A:18:AE:46:F0:9A','606383',210.00,'2025-08-19 20:31:12','2025-08-19 20:31:12'),(52,9,NULL,NULL,NULL,NULL,'E6:12:A3:41:F4:AD','951620',1000.00,'2025-08-19 20:40:37','2025-08-19 20:40:37'),(53,6,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','666402',210.00,'2025-08-20 05:38:33','2025-08-20 05:38:33'),(54,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','798382',500.00,'2025-08-20 10:00:48','2025-08-20 10:00:48'),(55,9,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','340967',1000.00,'2025-08-20 12:57:26','2025-08-20 12:57:26'),(56,9,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','802864',1000.00,'2025-08-20 12:58:38','2025-08-20 12:58:38'),(57,8,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','092136',500.00,'2025-08-20 12:59:40','2025-08-20 12:59:40'),(58,9,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','000439',1000.00,'2025-08-20 13:00:47','2025-08-20 13:00:47'),(59,9,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','796661',1000.00,'2025-08-20 13:02:24','2025-08-20 13:02:24'),(60,8,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','817977',500.00,'2025-08-20 13:09:17','2025-08-20 13:09:17'),(61,8,NULL,NULL,NULL,NULL,'F2:50:95:0B:4B:27','172820',500.00,'2025-08-20 13:09:33','2025-08-20 13:09:33'),(62,8,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','346349',500.00,'2025-08-20 13:11:22','2025-08-20 13:11:22'),(63,8,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','174631',500.00,'2025-08-20 13:27:28','2025-08-20 13:27:28'),(64,9,NULL,NULL,NULL,NULL,'86:62:B2:00:7B:AC','758317',1000.00,'2025-08-20 13:30:07','2025-08-20 13:30:07'),(65,9,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','995988',1000.00,'2025-08-20 18:05:52','2025-08-20 18:05:52'),(66,9,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','658164',1000.00,'2025-08-20 18:10:03','2025-08-20 18:10:03'),(67,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','072790',500.00,'2025-08-20 18:25:35','2025-08-20 18:25:35'),(68,7,NULL,NULL,NULL,NULL,'CC:C0:79:8D:5E:35','198983',300.00,'2025-08-20 18:59:07','2025-08-20 18:59:07'),(69,9,NULL,NULL,NULL,NULL,'30:FC:EB:7A:0C:90','693194',1000.00,'2025-08-20 19:15:34','2025-08-20 19:15:34'),(70,9,NULL,NULL,NULL,NULL,'12:9B:F6:38:BA:E8','633183',1000.00,'2025-08-20 19:42:05','2025-08-20 19:42:05'),(71,9,NULL,NULL,NULL,NULL,'52:F8:FB:F8:E8:C6','478091',1000.00,'2025-08-20 19:46:17','2025-08-20 19:46:17'),(72,9,NULL,NULL,NULL,NULL,'12:9B:F6:38:BA:E8','801707',1000.00,'2025-08-20 19:51:26','2025-08-20 19:51:26'),(73,8,NULL,NULL,NULL,NULL,'CC:C0:79:8D:5E:35','516750',500.00,'2025-08-20 19:57:34','2025-08-20 19:57:34'),(74,7,NULL,NULL,NULL,NULL,'CC:C0:79:8D:5E:35','267320',300.00,'2025-08-20 20:00:12','2025-08-20 20:00:12'),(75,6,NULL,NULL,NULL,NULL,'1A:A9:97:24:0B:BF','994514',210.00,'2025-08-20 20:37:40','2025-08-20 20:37:40'),(76,6,NULL,NULL,NULL,NULL,'CA:CD:25:B3:8E:2B','069648',210.00,'2025-08-20 20:38:38','2025-08-20 20:38:38'),(77,9,NULL,NULL,NULL,NULL,'BE:FD:23:A1:58:ED','202311',1000.00,'2025-08-21 06:29:51','2025-08-21 06:29:51'),(78,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','030361',500.00,'2025-08-21 08:21:59','2025-08-21 08:21:59'),(79,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','243147',500.00,'2025-08-21 08:23:42','2025-08-21 08:23:42'),(80,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','163183',500.00,'2025-08-21 08:28:42','2025-08-21 08:28:42'),(81,7,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','932383',300.00,'2025-08-21 08:29:47','2025-08-21 08:29:47'),(82,8,NULL,NULL,NULL,NULL,'F2:14:5F:EE:3E:9B','472785',500.00,'2025-08-21 08:49:16','2025-08-21 08:49:16'),(83,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','098143',500.00,'2025-08-21 14:46:55','2025-08-21 14:46:55'),(84,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','551030',500.00,'2025-08-21 14:55:58','2025-08-21 14:55:58'),(85,8,NULL,NULL,NULL,NULL,'D4:67:D3:E3:17:BD','837890',500.00,'2025-08-21 16:13:23','2025-08-21 16:13:23'),(86,9,NULL,NULL,NULL,NULL,'D4:67:D3:E3:17:BD','866912',1000.00,'2025-08-21 16:16:11','2025-08-21 16:16:11'),(87,6,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','219563',210.00,'2025-08-21 16:46:49','2025-08-21 16:46:49'),(88,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','758165',500.00,'2025-08-21 16:48:13','2025-08-21 16:48:13'),(89,8,NULL,NULL,NULL,NULL,'B2:24:D4:B2:3D:2D','359336',500.00,'2025-08-21 16:57:02','2025-08-21 16:57:02'),(90,8,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','378712',500.00,'2025-08-21 16:58:13','2025-08-21 16:58:13'),(91,8,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','410917',500.00,'2025-08-21 16:59:08','2025-08-21 16:59:08'),(92,8,NULL,NULL,NULL,NULL,'B2:24:D4:B2:3D:2D','187762',500.00,'2025-08-21 16:59:53','2025-08-21 16:59:53'),(93,26,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','653469',7000.00,'2025-08-21 17:01:26','2025-08-21 17:01:26'),(94,8,NULL,NULL,NULL,NULL,'B2:24:D4:B2:3D:2D','982679',500.00,'2025-08-21 17:01:31','2025-08-21 17:01:31'),(95,8,NULL,NULL,NULL,NULL,'B2:24:D4:B2:3D:2D','513114',500.00,'2025-08-21 17:04:43','2025-08-21 17:04:43'),(96,8,NULL,NULL,NULL,NULL,'62:98:4F:47:C4:C9','015445',500.00,'2025-08-21 17:24:37','2025-08-21 17:24:37'),(97,8,NULL,NULL,NULL,NULL,'62:98:4F:47:C4:C9','434649',500.00,'2025-08-21 17:28:05','2025-08-21 17:28:05'),(98,8,NULL,NULL,NULL,NULL,'62:98:4F:47:C4:C9','465660',500.00,'2025-08-21 17:30:46','2025-08-21 17:30:46'),(99,8,NULL,NULL,NULL,NULL,'62:98:4F:47:C4:C9','429603',500.00,'2025-08-21 17:34:31','2025-08-21 17:34:31'),(100,8,NULL,NULL,NULL,NULL,'BE:B0:28:C2:D3:11','124047',500.00,'2025-08-21 17:40:48','2025-08-21 17:40:48'),(101,6,NULL,NULL,NULL,NULL,'06:9C:BA:9D:B1:E8','237769',210.00,'2025-08-21 18:03:42','2025-08-21 18:03:42'),(102,8,NULL,NULL,NULL,NULL,'CC:C0:79:8D:5E:35','949862',500.00,'2025-08-21 18:54:25','2025-08-21 18:54:25'),(103,26,NULL,NULL,NULL,NULL,'30:FC:EB:7A:0C:90','162886',7000.00,'2025-08-21 19:27:52','2025-08-21 19:27:52'),(104,8,NULL,NULL,NULL,NULL,'D6:12:9E:9D:91:0E','746427',500.00,'2025-08-21 19:37:38','2025-08-21 19:37:38'),(105,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','128942',500.00,'2025-08-21 19:49:23','2025-08-21 19:49:23'),(106,9,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','230315',1000.00,'2025-08-21 20:22:01','2025-08-21 20:22:01'),(107,8,NULL,NULL,NULL,NULL,'A2:E1:BA:8D:59:00','363486',500.00,'2025-08-22 06:45:38','2025-08-22 06:45:38'),(108,7,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','500624',300.00,'2025-08-22 07:24:39','2025-08-22 07:24:39'),(109,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','414063',500.00,'2025-08-22 10:13:26','2025-08-22 10:13:26'),(110,6,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','973417',210.00,'2025-08-22 17:18:26','2025-08-22 17:18:26'),(111,9,NULL,NULL,NULL,NULL,'FE:96:EF:57:F0:70','564350',1000.00,'2025-08-22 17:26:11','2025-08-22 17:26:11'),(112,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','091414',500.00,'2025-08-22 18:59:54','2025-08-22 18:59:54'),(113,8,NULL,NULL,NULL,NULL,'F2:65:ED:BF:19:CD','246425',500.00,'2025-08-22 20:55:57','2025-08-22 20:55:57'),(114,8,NULL,NULL,NULL,NULL,'CC:C0:79:8D:5E:35','369937',500.00,'2025-08-22 21:30:02','2025-08-22 21:30:02'),(115,9,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','327234',1000.00,'2025-08-22 22:41:17','2025-08-22 22:41:17'),(116,7,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','836406',300.00,'2025-08-22 22:46:31','2025-08-22 22:46:31'),(117,6,NULL,NULL,NULL,NULL,'60:70:72:60:6A:C2','388319',210.00,'2025-08-22 23:20:13','2025-08-22 23:20:13'),(118,9,NULL,NULL,NULL,NULL,'4E:ED:DD:40:F3:A1','996468',1000.00,'2025-08-23 09:25:46','2025-08-23 09:25:46'),(119,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','540841',2500.00,'2025-08-23 12:30:39','2025-08-23 12:30:39'),(120,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','885814',2500.00,'2025-08-23 12:31:33','2025-08-23 12:31:33'),(121,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','282302',2500.00,'2025-08-23 12:31:36','2025-08-23 12:31:36'),(122,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','259503',2500.00,'2025-08-23 12:31:43','2025-08-23 12:31:43'),(123,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','522009',2500.00,'2025-08-23 12:32:26','2025-08-23 12:32:26'),(124,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','767316',2500.00,'2025-08-23 12:32:29','2025-08-23 12:32:29'),(125,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','556775',2500.00,'2025-08-23 12:32:33','2025-08-23 12:32:33'),(126,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','500414',2500.00,'2025-08-23 12:34:33','2025-08-23 12:34:33'),(127,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','109184',2500.00,'2025-08-23 12:34:36','2025-08-23 12:34:36'),(128,24,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','526822',2500.00,'2025-08-23 12:34:39','2025-08-23 12:34:39'),(129,9,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','842173',1000.00,'2025-08-23 12:35:16','2025-08-23 12:35:16'),(130,6,NULL,NULL,NULL,NULL,'D0:2A:AA:90:40:ED','280551',210.00,'2025-08-23 14:26:13','2025-08-23 14:26:13'),(131,6,NULL,NULL,NULL,NULL,'7E:A5:C8:0E:3C:6A','718557',210.00,'2025-08-23 16:39:08','2025-08-23 16:39:08'),(132,8,NULL,NULL,NULL,NULL,'F2:65:ED:BF:19:CD','924733',500.00,'2025-08-23 20:59:29','2025-08-23 20:59:29'),(133,7,NULL,NULL,NULL,NULL,'1E:1B:E0:50:5B:19','224566',300.00,'2025-08-24 04:03:34','2025-08-24 04:03:34'),(134,6,NULL,NULL,NULL,NULL,'1E:1B:E0:50:5B:19','594460',210.00,'2025-08-24 04:04:34','2025-08-24 04:04:34'),(135,6,NULL,NULL,NULL,NULL,'90:56:FC:DF:4A:E3','596434',210.00,'2025-08-24 07:15:26','2025-08-24 07:15:26'),(136,8,NULL,NULL,NULL,NULL,'5E:AB:0F:45:E5:21','577406',500.00,'2025-08-24 07:53:21','2025-08-24 07:53:21'),(137,8,NULL,NULL,NULL,NULL,'3E:A5:2D:34:21:C5','680604',500.00,'2025-08-24 08:24:03','2025-08-24 08:24:03'),(138,9,NULL,NULL,NULL,NULL,'16:E1:96:3C:2C:14','793156',1000.00,'2025-08-24 09:04:02','2025-08-24 09:04:02'),(139,7,NULL,NULL,NULL,NULL,'A6:85:AC:A3:94:CF','492517',300.00,'2025-08-24 09:27:55','2025-08-24 09:27:55'),(140,6,NULL,NULL,NULL,NULL,'A6:85:AC:A3:94:CF','402396',210.00,'2025-08-24 09:29:38','2025-08-24 09:29:38'),(141,9,NULL,NULL,NULL,NULL,'0E:C6:C3:E7:72:DB','156062',1000.00,'2025-08-24 13:11:18','2025-08-24 13:11:18'),(142,6,NULL,NULL,NULL,NULL,'2A:D7:59:12:C1:90','831234',210.00,'2025-08-24 15:34:15','2025-08-24 15:34:15'),(143,9,NULL,NULL,NULL,NULL,'5A:18:AE:46:F0:9A','580563',1000.00,'2025-08-24 17:57:20','2025-08-24 17:57:20'),(144,7,NULL,NULL,NULL,NULL,'F0:C7:45:88:DC:5D','691296',300.00,'2025-08-24 18:38:57','2025-08-24 18:38:57'),(145,7,NULL,NULL,NULL,NULL,'FC:AA:B6:3B:A0:48','301904',300.00,'2025-08-24 21:25:34','2025-08-24 21:25:34'),(146,7,NULL,NULL,NULL,NULL,'0A:00:F5:20:D1:35','274492',300.00,'2025-08-24 22:33:56','2025-08-24 22:33:56'),(147,8,NULL,NULL,NULL,NULL,'F2:65:ED:BF:19:CD','093513',500.00,'2025-08-24 22:36:13','2025-08-24 22:36:13'),(148,9,NULL,NULL,NULL,NULL,'66:BB:53:AB:22:4E','790430',1000.00,'2025-08-25 17:17:13','2025-08-25 17:17:13'),(149,8,NULL,NULL,NULL,NULL,'66:BB:53:AB:22:4E','639650',500.00,'2025-08-25 17:19:35','2025-08-25 17:19:35'),(150,8,NULL,NULL,NULL,NULL,'0E:06:50:49:08:C6','832104',500.00,'2025-08-25 17:19:43','2025-08-25 17:19:43'),(151,8,NULL,NULL,NULL,NULL,'0E:32:DD:A2:B3:84','629536',500.00,'2025-08-25 17:21:15','2025-08-25 17:21:15'),(152,9,NULL,NULL,NULL,NULL,'0E:32:DD:A2:B3:84','198458',1000.00,'2025-08-25 17:22:06','2025-08-25 17:22:06'),(153,9,NULL,NULL,NULL,NULL,'42:B6:CB:A6:FE:13','232501',1000.00,'2025-08-25 17:32:11','2025-08-25 17:32:11'),(154,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','364169',500.00,'2025-08-25 18:07:50','2025-08-25 18:07:50'),(155,8,NULL,NULL,NULL,NULL,'3E:A5:2D:34:21:C5','164429',500.00,'2025-08-25 18:27:58','2025-08-25 18:27:58'),(156,6,NULL,NULL,NULL,NULL,'0E:06:50:49:08:C6','337251',210.00,'2025-08-25 19:11:22','2025-08-25 19:11:22'),(157,9,NULL,NULL,NULL,NULL,'0E:06:50:49:08:C6','265677',1000.00,'2025-08-25 19:13:42','2025-08-25 19:13:42'),(158,6,NULL,NULL,NULL,NULL,'0E:06:50:49:08:C6','684657',210.00,'2025-08-25 19:14:42','2025-08-25 19:14:42'),(159,9,NULL,NULL,NULL,NULL,'0E:06:50:49:08:C6','950655',1000.00,'2025-08-25 19:15:38','2025-08-25 19:15:38'),(160,8,NULL,NULL,NULL,NULL,'FC:AA:B6:3B:A0:48','063636',500.00,'2025-08-25 20:53:38','2025-08-25 20:53:38'),(161,8,NULL,NULL,NULL,NULL,'F2:65:ED:BF:19:CD','678837',500.00,'2025-08-25 20:55:53','2025-08-25 20:55:53'),(162,8,NULL,NULL,NULL,NULL,'FC:AA:B6:3B:A0:48','485614',500.00,'2025-08-25 20:58:38','2025-08-25 20:58:38');

--
-- Table structure for table `tickets`
--

CREATE TABLE `tickets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_id` bigint unsigned NOT NULL,
  `company_router_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `issue_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `reminder` datetime NOT NULL,
  `stage` enum('Open','In Progress','Resolved','Closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Open',
  `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 `tickets_company_id_foreign` (`company_id`),
  KEY `tickets_company_router_id_foreign` (`company_router_id`),
  KEY `tickets_user_id_foreign` (`user_id`),
  CONSTRAINT `tickets_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tickets_company_router_id_foreign` FOREIGN KEY (`company_router_id`) REFERENCES `company_routers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tickets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tickets`
--


--
-- Table structure for table `transaction_frequencies`
--

CREATE TABLE `transaction_frequencies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number_of_days` int 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 `transaction_frequencies`
--

INSERT INTO `transaction_frequencies` VALUES (1,'Instantly',0,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(2,'Daily',1,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(3,'Three Days',3,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(4,'Weekly',7,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL),(5,'Monthly',30,'2025-08-03 19:10:02','2025-08-03 19:10:02',NULL);

--
-- Table structure for table `user_verification_codes`
--

CREATE TABLE `user_verification_codes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `phone_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_code` 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 `user_verification_codes_user_id_foreign` (`user_id`),
  CONSTRAINT `user_verification_codes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_verification_codes`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `referrer_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `phone_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1' COMMENT '0=inactive, 1=active',
  `remember_token` varchar(100) 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`),
  UNIQUE KEY `users_phone_unique` (`phone`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'HF4Y6D','Super Admin','0712345678',NULL,'superadmin@gmail.com','2025-07-30 21:26:20','2025-07-30 21:26:20','$2y$12$sL9rLDiCAscrNQ.NY2RztOzzU0.cSCW6B5rNjnvO4i8ICYnXXnIbG',1,NULL,'2025-07-30 21:26:20','2025-08-13 09:20:47',NULL),(14,'H0ERF2','Ben','0745678',NULL,NULL,'2025-08-05 15:16:00','2025-08-05 15:16:00','$2y$12$mgPvt.LZISWEj4nKuYXv6urRN3LvIt1dML13T/snulGiRoOuGWkUq',1,NULL,'2025-08-05 15:16:00','2025-08-05 15:16:00',NULL),(15,'9E8FYP','Erick','0763752350',NULL,'sirnjovu86@gmail.com','2025-08-05 16:56:56','2025-08-05 16:56:56','$2y$12$t28h8a0Wo1XrJk0XZHrmS.zJKIvU002din28wiRKlPKVeRdv.Z10e',1,NULL,'2025-08-05 16:56:56','2025-08-09 11:59:27',NULL),(16,'5NGAQV','Admin','0712345679',NULL,NULL,'2025-08-12 12:25:52','2025-08-12 12:25:52','$2y$12$kuyPB0V6yohwp/aAz4epeO5VQrnpwnW7jJk9KLPTpKxBIfis8CiR2',1,NULL,'2025-08-12 12:25:52','2025-08-12 12:25:52',NULL),(17,'SGC5QD','Te','0694214936',NULL,'test@hmail.com','2025-08-13 07:21:07','2025-08-13 07:21:07','$2y$12$oIxyMmt3CSWOD/v2CEIzH..mKvXm0N61/x7IIMZ0x9Godd0pkXMYK',0,NULL,'2025-08-13 07:21:07','2025-08-13 20:48:18',NULL),(18,'W19D5P','Test','0693058471',NULL,'test@gmail.com','2025-08-13 07:21:55','2025-08-13 07:21:55','$2y$12$LE8vKzwYDwZHpw.hRN7oyuY4XhagL0O4oPpffvuNDZC70Vmt3lkkC',0,NULL,'2025-08-13 07:21:55','2025-08-13 20:48:00',NULL),(19,'2SZ35Y','Admin','0787109988',NULL,NULL,'2025-08-13 19:46:16','2025-08-13 19:46:16','$2y$12$tyfHnsegYuJzDVVrUGjj.eseTN4v2R2TCUmHZ/B09O6XeMd8Vc3bO',0,NULL,'2025-08-13 19:46:16','2025-08-13 20:47:46',NULL);


