-- Table structure for table `out_messages`
--

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

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


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

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

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

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

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

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

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

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

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

CREATE TABLE `paid_users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `company_router_id` bigint unsigned DEFAULT NULL,
  `company_grouped_transaction_id` int DEFAULT NULL,
  `mac_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `paid_users_company_router_id_foreign` (`company_router_id`),
  CONSTRAINT `paid_users_company_router_id_foreign` FOREIGN KEY (`company_router_id`) REFERENCES `company_routers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `paid_users`
--


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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `sessions` VALUES ('2IYFF7Y98vbiKrvNLi2SoTiAYV4DSXPmErbnWaay',NULL,'105.161.81.254','Mozilla/5.0 (Linux; Android 8.0.0; SAMSUNG SM-G892A Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/7.0 Chrome/59.0.3071.125 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVlh2dUUybjBRVUZtVXE0V3c3aFdEQjlncFRFN1hHVUdsS1ZzWmhaSiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756446713),('a9wRLk460KXaJhfkqKYXQ4xHTBUbFJceRkSZE3Of',NULL,'197.250.227.78','Dalvik/2.1.0 (Linux; U; Android 13; Infinix X6528 Build/TP1A.220624.014)','YTozOntzOjY6Il90b2tlbiI7czo0MDoidDJuc2N2ZjU0T0h3a1VFMFJiZEhwRjh2MDBaemNtemdKZFlodXNQRSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyNzoiaHR0cHM6Ly9oZXJpdGFnZWdyb3VwLmNvLmtlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1756452406),('gNRPUUzCaYXcjptJ38AUXN4q2YwdKaPPJojoVXjG',NULL,'198.235.24.212','Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYksxaGlYRkY0WHBHTEJSamd0R1ZwcERYNkJEa3Rzb3VmNVFMYnFSUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756448265),('JuBiWYqRtzzpHWEbJ4bk6H6Sl0YcpJw8NQij0Bvr',15,'41.59.137.174','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','[encoded data, 85644 characters]',1756445745),('OGfgaqFvLQKHSRVIKH2bKaVuUZ6OaJcUb2N5xkCZ',NULL,'20.171.207.84','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWGJwOTdWb29NNDNXcWx3bkMzMTk0TVlRNmx4c3FadDRLQ3pLTkQ2ZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTI6Imh0dHBzOi8vd3d3Lmhlcml0YWdlZ3JvdXAuY28ua2UvdGVybXMtYW5kLWNvbmRpdGlvbnMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1756453513),('S7IJLeaeoi7fg9LY7KsBOHWEvNZJNN0zJJzUNqWO',15,'197.250.227.78','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.2','[encoded data, 95912 characters]',1756452410),('Xj6NeF6WkyIaVXu2SbVNoVxG2lcCikCitLRBmE7Z',NULL,'20.171.207.127','Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiVDR2WEhIdEpQZkZ5bWVFYTNnZzgzUmljU2lmYm5Zd2xDWjhDbTNlOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDg6Imh0dHBzOi8vaGVyaXRhZ2Vncm91cC5jby5rZS90ZXJtcy1hbmQtY29uZGl0aW9ucyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1756453426),('zlZSDqgiXvn6dRhkbbCHyt9Ui1YhC7JMvylXQGt0',20,'197.250.101.241','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','[encoded data, 19008 characters]',1756457903);

--
-- 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=234 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'),(163,8,NULL,NULL,NULL,NULL,'42:B6:CB:A6:FE:13','247889',500.00,'2025-08-26 12:03:24','2025-08-26 12:03:24'),(164,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','281061',500.00,'2025-08-26 14:50:55','2025-08-26 14:50:55'),(165,27,NULL,NULL,NULL,NULL,'82:B2:02:1D:E5:B8','212741',500.00,'2025-08-26 17:50:22','2025-08-26 17:50:22'),(166,27,NULL,NULL,NULL,NULL,'82:B2:02:1D:E5:B8','594517',500.00,'2025-08-26 17:51:22','2025-08-26 17:51:22'),(167,27,NULL,NULL,NULL,NULL,'82:B2:02:1D:E5:B8','943673',500.00,'2025-08-26 17:51:29','2025-08-26 17:51:29'),(168,27,NULL,NULL,NULL,NULL,'82:B2:02:1D:E5:B8','718710',500.00,'2025-08-26 17:51:34','2025-08-26 17:51:34'),(169,27,NULL,NULL,NULL,NULL,'82:B2:02:1D:E5:B8','717515',500.00,'2025-08-26 17:52:25','2025-08-26 17:52:25'),(170,36,NULL,NULL,NULL,NULL,'50:9A:4C:26:30:57','450158',8000.00,'2025-08-26 18:59:08','2025-08-26 18:59:08'),(171,8,NULL,NULL,NULL,NULL,'3E:A5:2D:34:21:C5','991841',500.00,'2025-08-26 19:10:11','2025-08-26 19:10:11'),(172,9,NULL,NULL,NULL,NULL,'42:BE:94:8E:99:FF','476738',1000.00,'2025-08-26 19:38:25','2025-08-26 19:38:25'),(173,38,NULL,NULL,NULL,NULL,'22:63:D2:CA:34:F3','398601',500.00,'2025-08-26 19:52:38','2025-08-26 19:52:38'),(174,39,NULL,NULL,NULL,NULL,'22:63:D2:CA:34:F3','630708',1000.00,'2025-08-26 19:54:02','2025-08-26 19:54:02'),(175,40,NULL,NULL,NULL,NULL,'22:63:D2:CA:34:F3','218373',5000.00,'2025-08-26 20:01:25','2025-08-26 20:01:25'),(176,38,NULL,NULL,NULL,NULL,'22:63:D2:CA:34:F3','396310',500.00,'2025-08-26 20:02:43','2025-08-26 20:02:43'),(177,38,NULL,NULL,NULL,NULL,'E2:23:F3:B5:17:BF','785888',500.00,'2025-08-26 20:04:39','2025-08-26 20:04:39'),(178,38,NULL,NULL,NULL,NULL,'82:B2:02:1D:E5:B8','790684',500.00,'2025-08-26 20:15:18','2025-08-26 20:15:18'),(179,40,NULL,NULL,NULL,NULL,'82:B2:02:1D:E5:B8','594457',5000.00,'2025-08-26 20:17:11','2025-08-26 20:17:11'),(180,8,NULL,NULL,NULL,NULL,'02:C0:AF:A7:33:40','191090',500.00,'2025-08-26 20:35:06','2025-08-26 20:35:06'),(181,8,NULL,NULL,NULL,NULL,'02:C0:AF:A7:33:40','484323',500.00,'2025-08-26 20:36:54','2025-08-26 20:36:54'),(182,8,NULL,NULL,NULL,NULL,'F2:65:ED:BF:19:CD','651226',500.00,'2025-08-26 20:44:17','2025-08-26 20:44:17'),(183,39,NULL,NULL,NULL,NULL,'82:B2:02:1D:E5:B8','983728',1000.00,'2025-08-26 20:49:45','2025-08-26 20:49:45'),(184,7,NULL,NULL,NULL,NULL,'F2:94:94:28:61:0A','537486',300.00,'2025-08-26 21:16:51','2025-08-26 21:16:51'),(185,6,NULL,NULL,NULL,NULL,'DE:C9:D5:36:F6:CE','044294',210.00,'2025-08-26 21:32:38','2025-08-26 21:32:38'),(186,26,NULL,NULL,NULL,NULL,'D6:23:01:B5:97:58','934000',7000.00,'2025-08-26 21:32:39','2025-08-26 21:32:39'),(187,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','967878',500.00,'2025-08-27 07:57:16','2025-08-27 07:57:16'),(188,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','258284',500.00,'2025-08-27 08:00:02','2025-08-27 08:00:02'),(189,7,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','996326',300.00,'2025-08-27 08:02:28','2025-08-27 08:02:28'),(190,38,NULL,NULL,NULL,NULL,'82:B2:02:1D:E5:B8','768142',500.00,'2025-08-27 08:55:25','2025-08-27 08:55:25'),(191,39,NULL,NULL,NULL,NULL,'22:63:D2:CA:34:F3','372001',1000.00,'2025-08-27 09:01:28','2025-08-27 09:01:28'),(192,40,NULL,NULL,NULL,NULL,'A2:84:7A:6A:65:C0','438871',5000.00,'2025-08-27 10:41:18','2025-08-27 10:41:18'),(193,39,NULL,NULL,NULL,NULL,'C2:14:39:F6:BE:64','051418',1000.00,'2025-08-27 10:41:41','2025-08-27 10:41:41'),(194,39,NULL,NULL,NULL,NULL,'A2:ED:93:63:1B:07','501012',1000.00,'2025-08-27 10:46:00','2025-08-27 10:46:00'),(195,39,NULL,NULL,NULL,NULL,'C2:14:39:F6:BE:64','068047',1000.00,'2025-08-27 10:47:31','2025-08-27 10:47:31'),(196,38,NULL,NULL,NULL,NULL,'C6:50:3F:D4:A6:76','252716',500.00,'2025-08-27 10:58:28','2025-08-27 10:58:28'),(197,39,NULL,NULL,NULL,NULL,'BA:FE:60:FB:62:6D','609856',1000.00,'2025-08-27 11:08:04','2025-08-27 11:08:04'),(198,38,NULL,NULL,NULL,NULL,'D4:38:9C:39:B2:30','726118',500.00,'2025-08-27 11:08:43','2025-08-27 11:08:43'),(199,38,NULL,NULL,NULL,NULL,'D4:38:9C:39:B2:30','788469',500.00,'2025-08-27 13:04:39','2025-08-27 13:04:39'),(200,38,NULL,NULL,NULL,NULL,'D4:38:9C:39:B2:30','097698',500.00,'2025-08-27 13:06:26','2025-08-27 13:06:26'),(201,38,NULL,NULL,NULL,NULL,'D4:38:9C:39:B2:30','552328',500.00,'2025-08-27 13:08:44','2025-08-27 13:08:44'),(202,38,NULL,NULL,NULL,NULL,'D4:38:9C:39:B2:30','971790',500.00,'2025-08-27 13:10:48','2025-08-27 13:10:48'),(203,38,NULL,NULL,NULL,NULL,'6E:1C:29:B1:62:47','957989',500.00,'2025-08-27 13:48:08','2025-08-27 13:48:08'),(204,6,NULL,NULL,NULL,NULL,'42:B6:CB:A6:FE:13','258068',210.00,'2025-08-27 14:39:12','2025-08-27 14:39:12'),(205,39,NULL,NULL,NULL,NULL,'A2:BA:54:80:E6:F0','523587',1000.00,'2025-08-27 17:07:33','2025-08-27 17:07:33'),(206,8,NULL,NULL,NULL,NULL,'5A:22:D6:25:36:E9','341224',500.00,'2025-08-27 17:34:36','2025-08-27 17:34:36'),(207,38,NULL,NULL,NULL,NULL,'D2:98:B5:52:54:DF','608258',500.00,'2025-08-27 17:46:05','2025-08-27 17:46:05'),(208,38,NULL,NULL,NULL,NULL,'D2:98:B5:52:54:DF','621893',500.00,'2025-08-27 17:53:42','2025-08-27 17:53:42'),(209,8,NULL,NULL,NULL,NULL,'CE:42:78:C4:E6:C9','802912',500.00,'2025-08-27 20:00:50','2025-08-27 20:00:50'),(210,8,NULL,NULL,NULL,NULL,'D6:12:9E:9D:91:0E','329466',500.00,'2025-08-27 20:03:22','2025-08-27 20:03:22'),(211,8,NULL,NULL,NULL,NULL,'D6:12:9E:9D:91:0E','050355',500.00,'2025-08-27 20:04:46','2025-08-27 20:04:46'),(212,8,NULL,NULL,NULL,NULL,'D6:12:9E:9D:91:0E','142624',500.00,'2025-08-27 20:08:09','2025-08-27 20:08:09'),(213,8,NULL,NULL,NULL,NULL,'02:C0:AF:A7:33:40','832478',500.00,'2025-08-27 20:32:32','2025-08-27 20:32:32'),(214,8,NULL,NULL,NULL,NULL,'3E:A5:2D:34:21:C5','988660',500.00,'2025-08-27 20:40:17','2025-08-27 20:40:17'),(215,9,NULL,NULL,NULL,NULL,'86:65:3C:6B:E1:84','800593',1000.00,'2025-08-27 23:25:10','2025-08-27 23:25:10'),(216,39,NULL,NULL,NULL,NULL,'A2:ED:93:63:1B:07','350839',1000.00,'2025-08-28 10:55:46','2025-08-28 10:55:46'),(217,8,NULL,NULL,NULL,NULL,'14:9F:3C:6B:96:77','711204',500.00,'2025-08-28 11:46:45','2025-08-28 11:46:45'),(222,9,NULL,NULL,NULL,NULL,'76:B4:55:80:75:CE','392335',1000.00,'2025-08-28 19:02:30','2025-08-28 19:02:30'),(226,8,NULL,NULL,NULL,NULL,'BE:B3:CB:9E:09:DC','642413',500.00,'2025-08-28 21:02:07','2025-08-28 21:02:07'),(231,9,NULL,NULL,NULL,NULL,'8E:CC:F9:80:BC:C7','799672',1000.00,'2025-08-29 07:09:48','2025-08-29 07:09:48'),(232,9,NULL,NULL,NULL,NULL,'8E:CC:F9:80:BC:C7','748127',1000.00,'2025-08-29 07:11:40','2025-08-29 07:11:40'),(233,39,NULL,NULL,NULL,NULL,'FE:0C:B3:5D:CE:B7','726438',1000.00,'2025-08-29 09:05:12','2025-08-29 09:05:12');

--
-- 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=22 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),(20,'Q3B8YT','Mwamba Cosmetics','0786000803',NULL,NULL,'2025-08-26 13:06:13','2025-08-26 13:06:13','$2y$12$h0Nfh6j2Mx0foH/6aLc6jOQE2C8Bzurd2Mf3XN5/miuSlz/HpYvNm',1,NULL,'2025-08-26 13:06:13','2025-08-27 18:57:35',NULL);


