--
-- Host: localhost    Database: payldr
-- ------------------------------------------------------


--
-- Table structure for table `account_session`
--

CREATE TABLE `account_session` (
  `transactionID` varchar(50) NOT NULL,
  `account_number` varchar(20) NOT NULL,
  `bank_name` varchar(250) NOT NULL,
  `acc_name` varchar(250) NOT NULL,
  `amount` decimal(11,2) NOT NULL,
  `purchase` varchar(250) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `expired_at` timestamp NOT NULL DEFAULT (current_timestamp() + interval 60 minute),
  `deleted` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `account_session`
--

INSERT INTO `account_session` VALUES ('payldr29','0067100155','Mock Bank','muhammad Sanusi',20000.00,'','2025-10-17 10:16:34','2025-10-17 10:17:34','1'),('payldr29','0067100155','Mock Bank','muhammad Sanusi',20000.00,'','2025-10-17 10:17:44','2025-10-17 10:18:44','1'),('payldr29','0067100155','Mock Bank','muhammad Sanusi',20000.00,'','2025-10-17 10:20:57','2025-10-17 10:21:57','1'),('payldr29','0067100155','Mock Bank','muhammad Sanusi',20000.00,'','2025-10-17 10:32:18','2025-10-17 10:33:18','1'),('payldr29','0067100155','Mock Bank','muhammad Sanusi',20000.00,'','2025-10-17 10:35:07','2025-10-17 10:36:07','1'),('payldr29','0067100155','Mock Bank','muhammad Sanusi',20000.00,'','2025-10-17 10:37:05','2025-10-17 10:38:05','1'),('payldr29','0067100155','Mock Bank','muhammad Sanusi',20000.00,'','2025-10-17 10:39:00','2025-10-17 10:40:00','1'),('payldr29','0067100155','Mock Bank','muhammad Sanusi',20000.00,'2 Gavel  3/4inch','2025-10-17 10:48:15','2025-10-17 10:49:15','1');

--
-- Table structure for table `commsn_table`
--

CREATE TABLE `commsn_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `percentage_value` decimal(4,3) DEFAULT NULL,
  `set_by` varchar(255) DEFAULT NULL,
  `state` enum('current','obsolete') DEFAULT 'current',
  `set_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `commsn_table`
--

INSERT INTO `commsn_table` VALUES (1,0.300,'+2348068124682','','2025-08-15 06:45:05'),(2,0.300,'+2348068124682','','2025-08-15 06:45:26'),(3,0.300,'+2348068124682','','2025-08-15 06:47:37'),(4,0.300,'+2348068124682','obsolete','2025-08-15 06:50:21'),(5,0.300,'+2348068124682','obsolete','2025-08-15 06:52:16'),(6,0.300,'2348068124682','obsolete','2025-08-15 06:54:25'),(7,0.300,'2348068124682','obsolete','2025-08-15 06:54:27'),(8,0.300,'2348068124682','obsolete','2025-08-15 06:55:46'),(9,0.300,'2348068124682','obsolete','2025-08-15 06:56:57'),(10,5.000,'2348068124682','obsolete','2025-08-15 07:06:33'),(11,0.300,'2348068124682','obsolete','2025-08-15 07:06:56'),(12,0.320,'2348068124682','obsolete','2025-08-15 07:07:21'),(13,0.200,'2348068124682','obsolete','2025-08-15 08:30:18'),(14,0.440,'2348068124682','obsolete','2025-08-15 08:30:34'),(15,1.500,'2348068124682','obsolete','2025-08-15 10:47:22'),(16,0.500,'2348068124682','obsolete','2025-08-15 11:05:06'),(17,0.460,'2348068124682','obsolete','2025-08-15 23:20:00'),(18,0.400,'2348068124682','obsolete','2025-08-17 19:06:35'),(19,5.000,'2348068124682','current','2025-08-24 19:36:39');

--
-- Table structure for table `default_dispute`
--

CREATE TABLE `default_dispute` (
  `id` int(11) NOT NULL,
  `reasons` varchar(255) NOT NULL,
  `user_type` enum('driver','client','both') DEFAULT 'both',
  `severity` tinyint(3) unsigned NOT NULL,
  `_created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `is_active` enum('0','1') DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `default_dispute`
--

INSERT INTO `default_dispute` VALUES (1,'Driver stuck on transit','client',1,'2025-10-03 05:27:54','2025-10-03 23:10:09','1'),(2,'Dump away from actual site','client',1,'2025-10-03 05:27:54','2025-10-03 23:10:09','1'),(3,'abuse','both',1,'2025-10-03 05:27:54','2025-10-03 23:10:09','1'),(4,'Client Change site','driver',1,'2025-10-03 05:27:54','2025-10-03 23:10:09','1'),(5,'Driver went out of reach','client',1,'2025-10-03 05:34:41','2025-10-03 23:10:09','1'),(6,'Driver made supply not as requested','client',1,'2025-10-03 05:40:26','2025-10-03 23:10:09','1'),(7,'Unable to reach client or recipient for site confirmation','driver',1,'2025-10-03 05:47:28','2025-10-03 23:10:09','1'),(8,'Driver made Less quality supply','client',1,'2025-10-03 10:24:19','2025-10-03 23:10:09','1');

--
-- Table structure for table `disputes_record`
--

CREATE TABLE `disputes_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dispute_id` varchar(255) DEFAULT NULL,
  `complainant` varchar(50) NOT NULL,
  `defendant` varchar(50) NOT NULL,
  `transactionId` varchar(255) DEFAULT NULL,
  `default_dispute_id` int(11) NOT NULL,
  `who_is` varchar(15) NOT NULL,
  `details` text DEFAULT NULL,
  `status` enum('new','pending','resolved') DEFAULT 'new',
  `resolution_note` text DEFAULT NULL,
  `resolved_by` varchar(50) DEFAULT NULL,
  `resolved_at` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `blockreason_id` (`default_dispute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `disputes_record`
--

INSERT INTO `disputes_record` VALUES (1,'pyldrCmpl001','+2348068124682','+2348064763531','payldr2',1,'',NULL,'pending',NULL,NULL,NULL,'2025-06-21 19:32:27'),(2,'pyldrCmpl002','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','resolved',NULL,NULL,NULL,'2025-06-21 19:33:18'),(3,'pyldrCmpl003','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','resolved',NULL,NULL,NULL,'2025-06-21 19:47:10'),(4,'pyldrCmpl004','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 19:48:43'),(5,'pyldrCmpl005','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','resolved',NULL,NULL,NULL,'2025-06-21 19:49:17'),(6,'pyldrCmpl006','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 19:53:36'),(7,'pyldrCmpl007','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','resolved',NULL,NULL,NULL,'2025-06-21 19:53:52'),(8,'pyldrCmpl008','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','resolved',NULL,NULL,NULL,'2025-06-21 19:54:26'),(9,'pyldrCmpl009','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 19:55:20'),(10,'pyldrCmpl010','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','new',NULL,NULL,NULL,'2025-06-21 20:02:28'),(11,'pyldrCmpl011','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 20:03:35'),(12,'pyldrCmpl012','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 20:03:51'),(13,'pyldrCmpl013','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 20:04:44'),(14,'pyldrCmpl014','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','new',NULL,NULL,NULL,'2025-06-21 22:07:54'),(15,'pyldrCmpl015','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','new',NULL,NULL,NULL,'2025-06-21 22:15:14'),(16,'pyldrCmpl016','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','new',NULL,NULL,NULL,'2025-06-21 22:22:30'),(17,'pyldrCmpl017','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:23:21'),(18,'pyldrCmpl018','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','resolved',NULL,NULL,NULL,'2025-06-21 22:30:24'),(19,'pyldrCmpl019','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:30:54'),(20,'pyldrCmpl020','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:31:29'),(21,'pyldrCmpl021','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:32:34'),(22,'pyldrCmpl022','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:37:20'),(23,'pyldrCmpl023','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:38:57'),(24,'pyldrCmpl024','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','new',NULL,NULL,NULL,'2025-06-21 22:39:38'),(25,'pyldrCmpl025','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:45:46'),(26,'pyldrCmpl026','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:46:19'),(27,'pyldrCmpl027','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','resolved',NULL,NULL,NULL,'2025-06-21 22:57:07'),(28,'pyldrCmpl028','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','new',NULL,NULL,NULL,'2025-06-21 22:57:40'),(29,'pyldrCmpl029','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:57:51'),(30,'pyldrCmpl030','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:58:07'),(31,'pyldrCmpl031','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','resolved',NULL,NULL,NULL,'2025-06-21 22:58:35'),(32,'pyldrCmpl032','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:58:48'),(33,'pyldrCmpl033','+2348068124682','+2348064763531','payldr2',1,'','he refuse to do deliver','pending',NULL,NULL,NULL,'2025-06-21 22:59:15'),(34,'pyldrCmpl034','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','resolved',NULL,NULL,NULL,'2025-06-28 08:14:42'),(35,'pyldrCmpl035','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','new',NULL,NULL,NULL,'2025-06-28 08:20:19'),(36,'pyldrCmpl036','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','resolved',NULL,NULL,NULL,'2025-06-28 08:20:41'),(37,'pyldrCmpl037','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','pending',NULL,NULL,NULL,'2025-06-28 08:22:38'),(38,'pyldrCmpl038','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','resolved',NULL,NULL,NULL,'2025-06-28 08:23:15'),(39,'pyldrCmpl039','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','new',NULL,NULL,NULL,'2025-06-29 07:59:58'),(40,'pyldrCmpl040','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','pending',NULL,NULL,NULL,'2025-06-29 08:01:57'),(41,'pyldrCmpl041','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','resolved',NULL,NULL,NULL,'2025-06-29 08:02:27'),(42,'pyldrCmpl042','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','new',NULL,NULL,NULL,'2025-06-29 08:04:59'),(43,'pyldrCmpl043','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','resolved',NULL,NULL,NULL,'2025-06-29 08:06:30'),(44,'pyldrCmpl044','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','new',NULL,NULL,NULL,'2025-06-29 08:06:32'),(45,'pyldrCmpl045','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','resolved',NULL,NULL,NULL,'2025-06-29 08:07:47'),(46,'pyldrCmpl046','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','new',NULL,NULL,NULL,'2025-06-29 08:08:48'),(47,'pyldrCmpl047','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','pending',NULL,NULL,NULL,'2025-06-29 08:09:43'),(48,'pyldrCmpl048','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','new',NULL,NULL,NULL,'2025-06-29 08:11:17'),(49,'pyldrCmpl049','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','pending',NULL,NULL,NULL,'2025-06-29 08:12:21'),(50,'pyldrCmpl050','+2348068124682','+2348064763531','payldr2',3,'','this is a detail of the complain','resolved',NULL,NULL,NULL,'2025-06-29 08:15:44'),(51,'pyldrCmpl051','08068124682','08064763531','payldr29',4,'driver','i stayed for long waiting for the recipient, only for him to come from another site and say that is where we are going to.','new',NULL,NULL,NULL,'2025-10-04 11:33:05'),(52,'pyldrCmpl052','08068124682','08064763531','payldr29',4,'driver','i stayed for long waiting for the recipient, only for him to come from another site and say that is where we are going to.','new',NULL,NULL,NULL,'2025-10-04 12:37:06');

--
-- Table structure for table `driverstandbytable`
--

CREATE TABLE `driverstandbytable` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `driver` varchar(255) NOT NULL,
  `hauledgeData` longtext NOT NULL,
  `standbyDate` date NOT NULL,
  `standbyTime` time NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `driverstandbytable`
--

INSERT INTO `driverstandbytable` VALUES (9,'+2348064763531','{\"name\":\"yusuf\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234krsh\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-05','16:05:00',1),(10,'+2348064763531','{\"name\":\"yusuf\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234krsh\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-05','16:06:09',0),(11,'+2348064763531','{\"name\":\"yusuf\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234krsh\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-06','06:10:17',0),(12,'+2347037762286','{\"name\":\"OgaNuhu\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234KUJ\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-06','06:24:00',0),(13,'+2348068124682','{\"name\":\"sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-07','18:42:57',0),(14,'+2348068124682','{\"name\":\"sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-09','14:40:52',0),(15,'+2347037762286','{\"name\":\"OgaNuhu\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234KUJ\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-09','14:44:49',0),(16,'+2348064763531','{\"name\":\"yusuf\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234krsh\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-09','18:48:06',1),(17,'+2348064763531','{\"name\":\"yusuf\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234krsh\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-09','20:25:33',0),(18,'+2348064763531','{\"name\":\"yusuf\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234krsh\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-10','07:38:21',0),(19,'+2348068124682','{\"name\":\"sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-10','07:56:37',0),(20,'+2348068124682','{\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 Tyres\"}','2025-04-11','11:23:20',0),(21,'+2348064763531','{\"name\":\"yusuf\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234krsh\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-15','10:10:56',0),(22,'+2348068124682','{\"name\":\"sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-04-17','05:55:56',0),(23,'+2348068124682','{\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\"}','2025-05-06','13:42:53',0),(24,'+2348068124682','{\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-05-09','11:09:22',0),(25,'+2348064763531','{\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-05-09','21:17:42',0),(26,'+2348064763531','{\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-05-10','10:40:48',0),(27,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":7.3805279,\"lat\":8.964733},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-05-11','13:12:39',0),(28,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":7.9564,\"lat\":9.6543},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":50000}','2025-05-15','10:24:47',0),(29,'+2348064763532','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":\"7.482\",\"lat\":\"9.0319\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":50000}','2025-05-15','10:52:34',0),(30,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Gwarinpa\",\"tipperGarageCodnate\":{\"long\":\"7.408\",\"lat\":\"9.099\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":50000}','2025-05-24','09:37:04',0),(31,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Gwarinpa\",\"tipperGarageCodnate\":{\"long\":\"7.408\",\"lat\":\"9.099\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":50000}','2025-05-26','09:20:22',0),(32,'+2348064763532','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-05-26','12:51:06',0),(33,'+2348068124682','{\"name\":\"sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-05-27','06:56:28',0),(34,'+2348064763533','{\"name\":\"Sanusi\",\"tipperGarage\":\"Gwarinpa\",\"tipperGarageCodnate\":{\"long\":\"7.408\",\"lat\":\"9.099\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":50000}','2025-05-27','10:56:47',0),(35,'+2348064763532','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-05-27','11:13:40',0),(36,'+2348064763532','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-05-30','19:36:42',0),(37,'+2348064763533','{\"name\":\"Sanusi\",\"tipperGarage\":\"Gwarinpa\",\"tipperGarageCodnate\":{\"long\":\"7.408\",\"lat\":\"9.099\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":50000}','2025-05-30','19:37:31',0),(38,'+2348068124682','{\"name\":\"sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":20.472,\"lat\":70.874},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\"}','2025-05-30','20:06:53',0),(39,'+2348064763532','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-05-31','14:13:22',0),(40,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Gwarinpa\",\"tipperGarageCodnate\":{\"long\":\"7.408\",\"lat\":\"9.099\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":50000}','2025-06-19','20:18:44',0),(41,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":7.382573286286656,\"lat\":8.963934919112992},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":\"5000\"}','2025-06-20','10:27:23',0),(42,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Gwarinpa\",\"tipperGarageCodnate\":{\"long\":\"7.408\",\"lat\":\"9.099\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"header\":\"search\",\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":50000}','2025-06-25','12:50:30',0),(43,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-06-29','20:06:38',0),(44,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-06-30','01:57:49',0),(46,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-02','11:15:18',0),(47,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-03','05:37:24',0),(48,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-04','05:22:32',0),(49,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-05','07:30:03',0),(54,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-06','14:22:14',0),(55,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-06','14:28:25',0),(56,'+2348064763532','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-06','14:34:07',0),(57,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-07','11:05:17',0),(58,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-07','20:01:16',0),(59,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-23','14:20:02',0),(60,'+2348064763532','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-23','14:21:10',0),(61,'+2348122764475','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-23','14:23:17',0),(62,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-23','16:08:21',0),(63,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-24','19:14:29',0),(64,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-25','10:13:12',0),(65,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-26','20:43:19',0),(66,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-07-27','12:52:43',0),(67,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-08-03','06:18:29',0),(68,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-08-04','13:51:16',0),(69,'+2348122764475','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":2,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Top Soil\",\"product_subCat\":\"fine\",\"truckSize\":\"18 tyres\",\"price\":70000}','2025-08-04','13:52:25',0),(70,'+2347037762286','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":2,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Top Soil\",\"product_subCat\":\"fine\",\"truckSize\":\"18 tyres\",\"price\":70000}','2025-08-04','13:53:52',0),(71,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-08-05','14:15:13',1),(72,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-08-05','15:05:00',1),(73,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-08-07','09:05:14',1),(74,'+2348122764475','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-08-07','09:06:09',1),(75,'+2348122764475','{\"name\":\"Yusuf Habu\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"GWA-254-DA\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Top Soil\",\"product_subCat\":\"fine\",\"truckSize\":\"24 tyres\",\"price\":80000}','2025-08-07','09:42:32',1),(76,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":9.867073311808669,\"lat\":10.345895274360466},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":\"50000\"}','2025-08-07','10:18:06',0),(77,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":9.8671426,\"lat\":10.3464535},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":\"50000\"}','2025-08-07','13:41:01',1),(78,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":9.8671435,\"lat\":10.3464614},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":\"50000\"}','2025-08-08','13:14:25',1),(79,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":9.8671435,\"lat\":10.3464614},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":\"50000\"}','2025-08-08','13:23:29',1),(80,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":9.8671383,\"lat\":10.3464608},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":\"60000\"}','2025-08-10','11:28:11',1),(81,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":9.8671383,\"lat\":10.3464608},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":\"60000\"}','2025-08-10','11:32:50',1),(82,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":9.8671435,\"lat\":10.3464614},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":\"50000\"}','2025-08-11','10:56:07',0),(83,'+2348068124682','{\"name\":\"Sanusi\",\"tipperGarage\":\"Dutse Tipper Garage\",\"tipperGarageCodnate\":{\"long\":9.8671384,\"lat\":10.3464601},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":\"50000\"}','2025-08-16','11:41:46',0),(84,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-08-16','22:11:05',0),(85,'+2348064763531','{\"name\":\"Sanusi\",\"tipperGarage\":\"Garki\",\"tipperGarageCodnate\":{\"long\":\"7.416\",\"lat\":\"9.239\"},\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1,\"product\":\"Shap Sand\",\"product_subCat\":\"fine\",\"truckSize\":\"16 tyres\",\"price\":60000}','2025-08-17','06:06:18',0),(86,'08064763531','{\"name\":\"Sanusi\",\"truck\":{\"id\":1,\"licensePlate\":\"1234Abj\"},\"productId\":1,\"product\":\"Shap Sand fine\",\"truckSize\":\"10 tyres\",\"truckName\":\"HOWO\",\"truckNameCapacity\":\"30-45 ton\",\"currentLoc\":\"katampe\",\"currentCoordinate\":{\"log\":\"7.88087\",\"long\":\"8.90909\"},\"direction\":\"direction\",\"price\":\"200000\"}','2025-08-21','12:01:02',0),(87,'08064763531','{\"name\":\"Driver\",\"truck\":{\"id\":1,\"licensePlate\":\"\"},\"productId\":1,\"product\":\"Shap Sand fine\",\"truckSize\":\"10 tyres\",\"truckName\":\"HOWO\",\"truckNameCapacity\":\"30-35Tons\",\"currentCoordinate\":{\"lat\":\"8.963083382238983\",\"long\":\"7.384403514110098\"},\"direction\":6.765054702758789,\"price\":\"290000\",\"pricing\":\"trip\"}','2025-08-24','13:01:06',0),(88,'08068124682','{\"name\":\"Sanusi\",\"truck\":{\"id\":2,\"licensePlate\":\"RLD-377-BK\"},\"productId\":1,\"product\":\"Shap Sand fine\",\"truckSize\":\"16 tyres\",\"truckName\":\"Tipper Trailer\",\"truckNameCapacity\":\"65-70Tons\",\"currentCoordinate\":{\"lat\":\"8.964855500673856\",\"long\":\"7.3830212430233635\"},\"direction\":5.537698745727539,\"price\":\"350000\",\"pricing\":\"trip\"}','2025-08-24','14:04:10',1),(89,'08068124682','{\"name\":\"Sanusi\",\"truck\":{\"id\":2,\"licensePlate\":\"RLD-377-BK\"},\"productId\":1,\"product\":\"Shap Sand fine\",\"truckSize\":\"16 tyres\",\"truckName\":\"Tipper Trailer\",\"truckNameCapacity\":\"65-70Tons\",\"currentCoordinate\":{\"lat\":\"9.0412583\",\"long\":\"7.4961149\"},\"direction\":-14.006250381469727,\"price\":\"357000\",\"pricing\":\"trip\"}','2025-08-24','18:35:19',1),(90,'08068124682','{\"name\":\"Sanusi\",\"truck\":{\"id\":2,\"licensePlate\":\"RLD-377-BK\"},\"productId\":1,\"product\":\"Shap Sand fine\",\"truckSize\":\"16 tyres\",\"truckName\":\"Tipper Trailer\",\"truckNameCapacity\":\"65-70Tons\",\"currentCoordinate\":{\"lat\":\"8.9710148\",\"long\":\"7.3862683\"},\"direction\":36.22500228881836,\"price\":\"350000\",\"pricing\":\"trip\"}','2025-09-12','05:57:18',1),(91,'08068124682','{\"name\":\"Sanusi\",\"truck\":{\"id\":2,\"licensePlate\":\"RLD-377-BK\"},\"productId\":1,\"product\":\"Shap Sand fine\",\"truckSize\":\"16 tyres\",\"truckName\":\"Tipper Trailer\",\"truckNameCapacity\":\"65-70Tons\",\"currentCoordinate\":{\"lat\":\"8.9710148\",\"long\":\"7.3862683\"},\"direction\":36.1875,\"price\":\"380000\",\"pricing\":\"trip\"}','2025-09-12','06:12:09',1);

--
-- Table structure for table `drvr`
--

CREATE TABLE `drvr` (
  `usrName` varchar(255) NOT NULL,
  `usr` varchar(255) DEFAULT NULL,
  `usrPh` varchar(255) DEFAULT NULL,
  `userResidentAdress` longtext DEFAULT NULL,
  `crdtDtls` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '{"license":"","photo":""}',
  `pswrd` longtext DEFAULT NULL,
  `truck` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '{"id":"", "license":"", "color":"","photo":""}',
  `nxtKin` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '{"address":"","phone_num":"","full_name":"","rel":""}',
  `pswrdRstData` longtext DEFAULT NULL,
  `timeStamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `signUpVrfStatus` int(1) DEFAULT 0,
  `truck_fleet` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `garage` varchar(255) DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `drvr`
--

INSERT INTO `drvr` VALUES ('muhammad Sanusi','sanusimtb@gmail.com','08068124682','Bwari Abuja','{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$YU1HMnhJYU5xWmhaZzFhTA$auUDS7Qs0Se9B4lileZvKkpsLu//PYNp3zXfOFIGufU','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}','$argon2i$v=19$m=65536,t=4,p=1$bUFqVG42blc0RDhhcWxNQw$ZDOqhh4qJhva02P5eKrHsGVfDHG1EY2dpEfr1Qd9/t8','2025-03-27 13:06:31',1,NULL,NULL,1),('yusuf',NULL,'08064763531',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$RTk0RmlVZkNKN1ZiTWI3eg$08v9asRG941fb4U13rdI3r5uxzU+UC1F/6lPf9NzPcY','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}',NULL,'2025-03-27 13:06:31',1,NULL,NULL,2),('OgaNuhu',NULL,'07037762286',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$LnBSMjBCdU5JeVRGUHdGbA$2Xc3t//j/pGfuGyd56Gh4kkxL4lGexqHuyh/nFzP1+I','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}',NULL,'2025-03-27 13:06:31',1,NULL,NULL,3),('Muhammad Sanusi',NULL,'08064763532',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$TnNsVi90QUI2eHlOUFVnLg$1+7WrmU3CWjGdNHzrsuTU1ArIkQ2uDAN78HsH0V8/UE','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}','$argon2i$v=19$m=65536,t=4,p=1$RWxack5QdE52d2tQc1hKUA$uYbaaJaOMih+wEqr1N7oQCxGlXIFr9k2QZZWbOO/Bpw','2025-04-15 12:47:03',1,NULL,NULL,4),('nince count',NULL,'08023456789',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$SlJHYi9uTG9HNWk0M2RjWQ$WRD2xuJgYzhPY+Jm5Kvasu6dUP6ObhkPyKQyJ3ZWMrc','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}','$argon2i$v=19$m=65536,t=4,p=1$cEpiUE5JVENoa2hGMHBoaA$igd+M3vqtrTYn87F0HLm3JIc9rFJV915zxinWpo3Oa4','2025-04-16 19:58:27',1,NULL,NULL,5),('name surname',NULL,'08039616045',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$dnhOSmtFNXl0YjRLTy4vbg$Lcdn0HmKVT2nSz5Pl9M3mz2yZaetJypJ8dwVd8J+ZD8','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}','$argon2i$v=19$m=65536,t=4,p=1$ZmhKemVCdmxpYUxrSU9MSg$bl2vQ3+T1OVJWPU0p9cMix0dyOxsrbStmWAY3eVCiZ0','2025-04-18 10:50:41',0,NULL,NULL,6),('JohnDoe','user@example.com','09029794213',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$b3lPUnZxTHR5ZU56M0ZrVA$Q9R5hp72a04UUaVARydHBHIge9byzJQDoPnJRxrxNvU','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}',NULL,'2025-04-30 21:45:10',0,NULL,NULL,7),('JohnDoe','user@example.com','09029794213',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$OWMudnhrTUZPMVBuYkJDeA$8oRvDN1lydGHVctpmJnMWvbkVSBbEe+2YXnbTQs7T9s','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}',NULL,'2025-04-30 21:45:10',0,NULL,NULL,8),('JohnDoe','user@example.com','09029794213',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$N1QzQ2Y4TmhTaHZPVG1wdA$4gXJxC9aSvb/RVOJfHMXcg2m4SM1/W1WE0ZCRBKYgiU','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}',NULL,'2025-04-30 21:45:11',0,NULL,NULL,9),('JohnDoe','user@example.com','09029794213',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$aHZLUDhablhoZm11VE45dQ$njNIIXX5mC4iQJHph1Gg4iejax1n1p50j6cl+1GG6JI','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}',NULL,'2025-04-30 21:45:11',0,NULL,NULL,10),('JohnDoe','user@example.com','09029794213',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$dkNxVC5tZHlFL1NYcGVIYQ$qvA7/ltf6rvmArFZRsmGonkP2h8olwRoEOTFQUnhSSY','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}',NULL,'2025-04-30 21:45:11',0,NULL,NULL,11),('JohnDoe','aishamsambo94@gmail.com','09029794213',NULL,'{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2i$v=19$m=65536,t=4,p=1$WElxT2lyN3J6eDVMTm8xLg$3tn72nxl6aB42lP88FJbigJ5gCq4X6M5J136/agzT2c','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}',NULL,'2025-04-30 21:45:43',0,NULL,NULL,12),('Test User',NULL,'12345678901','Test user Address','{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2id$v=19$m=131072,t=4,p=2$R3NyYkRxRjdyaDVHNXl1SQ$2ubclGd6Nqm8LJLMJ7TcFAS7CBW2EmsE98+a4ZaO4/c','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}','$argon2id$v=19$m=131072,t=4,p=2$OG14ckxuemc1TkhoYmV5cQ$tvvG/XwecmhGhQzx5j507V38Rn6xto7Rojsj+Fx7ql8','2025-08-21 09:02:18',1,NULL,NULL,31),('Test User',NULL,'12345678902','Test user Address','{\"license\":\"gtj35h\",\"photo\":\"license+234806812468201\"}','$argon2id$v=19$m=131072,t=4,p=2$N0dOOG5hdk0xYkwuYk85cA$p8w3cR+OyVFn8K5m704cuwtQ7SAO73PjTdrWXxrJjFs','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"Test User Next of Kin Address\",\"phone_num\":\"10987654321\",\"full_name\":\"Test User Next OF KIN\",\"rel\":\"Father\"}','$argon2id$v=19$m=131072,t=4,p=2$Ynk0ajhBQU5aNnZsWlVtNQ$JkK4Lb+4E6ZO04P+LzBU9LYnrhYnk4/W1uKs24EsCuw','2025-08-21 09:18:30',1,NULL,NULL,32),('Julaibibi Jabir',NULL,'08012345674',NULL,'{\"license\":\"\",\"photo\":\"\"}','$argon2id$v=19$m=131072,t=4,p=2$TWlJaUd0MDBFQjNDNmJieA$g+oP1TPnwdGBu0v91mPplV0PiD7y9VndlwgqSZ9IKHw','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"\",\"phone_num\":\"\",\"full_name\":\"\",\"rel\":\"\"}',NULL,'2025-10-10 19:03:56',0,NULL,NULL,33),('Julaibibi Jabir',NULL,'08012345675','Bwari abuja ','{\"license\":\"\",\"photo\":\"\"}','$argon2id$v=19$m=131072,t=4,p=2$aTRxU2FNZndFOGhVNElxZA$M4DwJ7NenSPuhYMD9rTnkBzUrpm4TAM0hp8/p5Cf5wg','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"\",\"phone_num\":\"\",\"full_name\":\"\",\"rel\":\"\"}',NULL,'2025-10-10 19:23:31',0,NULL,NULL,34),('Julaibibi Jabir',NULL,'08012345676','Bwari abuja ','{\"license\":\"\",\"photo\":\"\"}','$argon2id$v=19$m=131072,t=4,p=2$TDdVWHl5UEtHQTV4cjdxag$XJCBh5GQVtoOsbT15e933wo6DXLOsVyU8RhMXjuTv1s','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"\",\"phone_num\":\"\",\"full_name\":\"\",\"rel\":\"\"}',NULL,'2025-10-10 19:24:37',0,NULL,NULL,35),('Julaibibi Jabir',NULL,'08012345672','Bwari abuja ','{\"license\":\"\",\"photo\":\"\"}','$argon2id$v=19$m=131072,t=4,p=2$Q3F3Z1ZEQXlLUGhwRnFMVA$GfLAKF9/dsYSsiNlMtzRihOUTH2EfQ5hNRP5WDx3P4w','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"\",\"phone_num\":\"\",\"full_name\":\"\",\"rel\":\"\"}',NULL,'2025-10-10 19:30:04',0,NULL,NULL,36),('Julaibibi Jabir',NULL,'08012786576','Bwari abuja ','{\"license\":\"\",\"photo\":\"\"}','$argon2id$v=19$m=131072,t=4,p=2$QXlESlVxU1FVRzNMc0xhOQ$2tBgblGGqIPAjLQrgzXufYYPd3RO2nHkDUwzQnRxlco','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"\",\"phone_num\":\"\",\"full_name\":\"\",\"rel\":\"\"}',NULL,'2025-10-10 19:34:12',0,NULL,NULL,37),('Julaibibi Jabir',NULL,'08012786577','Bwari abuja ','{\"license\":\"\",\"photo\":\"\"}','$argon2id$v=19$m=131072,t=4,p=2$OGlxeXlMMmtCSFBFYzlHZQ$XTa/oDBwM0SJqgTByvzOixRAQyVr9E+hCwL2onUDdcc','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"\",\"phone_num\":\"\",\"full_name\":\"\",\"rel\":\"\"}',NULL,'2025-10-10 19:44:48',0,NULL,NULL,38),('Julaibibi Jabir',NULL,'08012786557','Bwari abuja ','{\"license\":\"\",\"photo\":\"\"}','$argon2id$v=19$m=131072,t=4,p=2$Tjk4WGNGRXljZHNxdjR0cQ$wByyQX52WblGpft7ZlTnL7KXvBGo/Uf9cbaC1oCzhSg','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"\",\"phone_num\":\"\",\"full_name\":\"\",\"rel\":\"\"}',NULL,'2025-10-10 20:07:44',0,NULL,NULL,39),('Julaibibi Jabir',NULL,'08012786558','Bwari abuja ','{\"license\": \"123459859273\", \"photo\": \"license08012786558\"}','$argon2id$v=19$m=131072,t=4,p=2$T2xCN3F5ei9lV2JvSFR3Lg$r9Npt0mZSSkxIL/HlWelP822V1wJoQtjKc/7cp6n940','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\": \"bwari ABuja\", \"phone_num\": \"080123456789\", \"full_name\": \"Isah hari\", \"rel\": \"son\"}','$argon2id$v=19$m=131072,t=4,p=2$TUVpTUMuRjZneG5Hc2c0cA$34kjb1flDxCbcw62O32gk97dVx5tmzM4yGV2awlXTrU','2025-10-10 20:13:42',1,NULL,NULL,40),('Jabir Julaibibi',NULL,'08012786518','Bwari abuja ','{\"license\":\"\",\"photo\":\"\"}','$argon2id$v=19$m=131072,t=4,p=2$d05zV24wN2VOQTJWaTREcw$4oCJ905/s1i23octCSWJrRWgKvp/Bla7MdhRMzcnbkY','{\"id\": 1, \"license\": \"ABC123B2\", \"color\": \"Red and white\", \"photo\": \"truck01\"}','{\"address\":\"\",\"phone_num\":\"\",\"full_name\":\"\",\"rel\":\"\"}',NULL,'2025-10-11 11:00:24',0,NULL,NULL,41),('Jabir Julaibibi',NULL,'08012786528','Bwari abuja ','{\"license\":\"\",\"photo\":\"\"}','$argon2id$v=19$m=131072,t=4,p=2$N0xpak92YmZ2NDlmdlVQUQ$PdXNZgQczJbHQCOtFB8LcKxyfrSgofiKCHsQz1aFa9I','{\"id\":\"\", \"license\":\"\", \"color\":\"\",\"photo\":\"\"}','{\"address\":\"\",\"phone_num\":\"\",\"full_name\":\"\",\"rel\":\"\"}',NULL,'2025-10-11 11:21:24',0,NULL,NULL,42),('Jabir Julaibibi',NULL,'08012786533','Bwari abuja ','{\"license\": \"123459859273\", \"photo\": \"license08012786533\"}','$argon2id$v=19$m=131072,t=4,p=2$N296YmJhRHMvYmFCeTlldw$ZkUt9QEVYFq6spQPk14AMw51JqTvhqeofxFO5WkWeyw','{\"id\": \"1\", \"license\": \"ABC 256 B2\", \"color\": \"red and white\", \"photo\": \"truck08012786533\"}','{\"address\": \"bwari ABuja\", \"phone_num\": \"080123456789\", \"full_name\": \"Isah hari\", \"rel\": \"son\"}','$argon2id$v=19$m=131072,t=4,p=2$cXo5c2FUMWVNWmtxRG96bA$Qs960GqtJQLi31FUSEh2RXyXdOl1VX23ip0nlvOwxOQ','2025-10-11 11:23:17',0,NULL,NULL,43),('Jabir Julaibibi',NULL,'08012786534','Bwari abuja ','{\"license\": \"123459859273\", \"photo\": \"license08012786534\"}','$argon2id$v=19$m=131072,t=4,p=2$aVY3Q2ZnNWl3a3FTQnZveg$X/VfxqV2duqJ8jC/OhZHgEATM1ErBHx0EuMFYRopBKo','{\"id\": \"1\", \"license\": \"ABC 256 B2\", \"color\": \"red and white\", \"photo\": \"truck08012786534\"}','{\"address\": \"bwari ABuja\", \"phone_num\": \"080123456789\", \"full_name\": \"Isah hari\", \"rel\": \"son\"}','$argon2id$v=19$m=131072,t=4,p=2$SnlxVmg3V291WkNlY056Rg$UCYZ0gIHAE5mVQZpi/q+SboX3AoHv6ie7TsVGCvXz3M','2025-10-11 11:26:16',0,NULL,NULL,44),('Jabir Julaibibi',NULL,'08012786535','Bwari abuja ','{\"license\": \"123459859273\", \"photo\": \"license08012786535\"}','$argon2id$v=19$m=131072,t=4,p=2$cTltRlp1LkNESjFWa2NVYg$HdSZ2IFLFcb21Uo1QlefKeoDZIOaOx1RZYJ3vpeu+IA','{\"id\": \"1\", \"license\": \"ABC 256 B2\", \"color\": \"red and white\", \"photo\": \"truck08012786535\"}','{\"address\": \"bwari ABuja\", \"phone_num\": \"080123456789\", \"full_name\": \"Isah hari\", \"rel\": \"son\"}','$argon2id$v=19$m=131072,t=4,p=2$MTEvdkZ4QWRJcTREMW5Dcw$AHA0V9xQ5N0bgeWpYT7mhI4pYw1j1D+xvFd9cVckWE4','2025-10-11 11:29:10',0,NULL,NULL,45),('Jabir Julaibibi',NULL,'08012786536','Bwari abuja ','{\"license\": \"123459859273\", \"photo\": \"license08012786536\"}','$argon2id$v=19$m=131072,t=4,p=2$ZjBZYmhoUWZ6Si9sZExmNA$rd64WftjkxMj83av9GDXerrXmYteIaL4EZiGL3Bas24','{\"id\": \"1\", \"license\": \"ABC 256 B2\", \"color\": \"red and white\", \"photo\": \"truck08012786536\"}','{\"address\": \"bwari ABuja\", \"phone_num\": \"080123456789\", \"full_name\": \"Isah hari\", \"rel\": \"son\"}','$argon2id$v=19$m=131072,t=4,p=2$Ny9aMU1VdjJ0SWhlLlV3Zw$oEIGxOHK2FYghnY8oPTFdkaq13MEh2X54iOaKjgWDR4','2025-10-11 11:33:12',1,NULL,NULL,46),('Jabir Julaibibi',NULL,'08012786537','Bwari abuja ','{\"license\": \"123459859273\", \"photo\": \"license08012786537\"}','$argon2id$v=19$m=131072,t=4,p=2$N05COGFYU0tlMW5kRUNNVA$hVxuJfaMAYpn+TxZl6p3hr7zc2wfBVwKd04aChZS9Mc','{\"id\": \"1\", \"license\": \"ABC 256 B2\", \"color\": \"red and white\", \"photo\": \"truck08012786537\"}','{\"address\": \"bwari ABuja\", \"phone_num\": \"080123456789\", \"full_name\": \"Isah hari\", \"rel\": \"son\"}','$argon2id$v=19$m=131072,t=4,p=2$MWI1bkY0YkdMdHBHRG5SUQ$6rdZiLp3D259bS2l154BRm87GhIoeFG8wBkzWiip9H4','2025-10-11 20:33:53',1,NULL,NULL,47);

--
-- Table structure for table `drvrClnt`
--

CREATE TABLE `drvrClnt` (
  `usrName` varchar(255) NOT NULL,
  `usr` varchar(255) DEFAULT NULL,
  `usrPh` varchar(255) DEFAULT NULL,
  `pswrd` longtext DEFAULT NULL,
  `pswrdRstData` longtext DEFAULT NULL,
  `timeStamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `signUpVrfStatus` int(1) DEFAULT 0,
  `userResidentAdress` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `drvrClnt`
--

INSERT INTO `drvrClnt` VALUES ('ClientSanusi',NULL,'08068124682','$argon2i$v=19$m=65536,t=4,p=1$RUtYUHY2VEZaRDZTY3VrMQ$3WjDamgYsiOgygBipTZhvqBEbb2X/5638K96M36NskE',NULL,'2025-03-24 19:59:23',1,NULL),('ClientYusuf',NULL,'08064763531','$argon2i$v=19$m=65536,t=4,p=1$SXB1akZDZ2Z1RUF6MnA3eg$S1I9USDngABotbezVUIkTHv/VJuEOHozauSP+Xillmg',NULL,'2025-03-24 19:59:23',1,NULL),('ClientOgaNuhu',NULL,'07037762286','$argon2i$v=19$m=65536,t=4,p=1$bU1abTB4bkY2MmJ0VkRpaw$8SWRrWCgitAcic4/kgtuP9pujEpepVe3JdeJYdi7pMQ',NULL,'2025-03-24 19:59:24',1,NULL),('name surname',NULL,'08012345678','$argon2i$v=19$m=65536,t=4,p=1$YWE2S1RwVHMucC9OLnFUNA$IYLidNLYP37UU4NR9cjEi2bLfm4zi1XOhXT4QBsLOCs','$argon2i$v=19$m=65536,t=4,p=1$MkhLTlFIRmRQTjVpcGh1VA$t7KqWAj44h9kFAgCu+I82W2RPFsQNOW5SNed7tJc4dc','2025-04-16 17:21:29',1,NULL),('name surname',NULL,'08039616046','$argon2i$v=19$m=65536,t=4,p=1$T3M4aTZFTVd6Vk1CV1pJbw$Z1nEgH2LP+VVNzN8Yxmxk0xTBrQ+lGP7RBM/VSdtyw4','$argon2i$v=19$m=65536,t=4,p=1$Q1BwYXpRS2c5MEhTTmZHcQ$6OYf6DCZcuFhMhP5O/03geZ/aYORFCJrQowyNdf0uvw','2025-04-18 10:52:47',0,NULL),('Yusuf Habu',NULL,'08122764475','$argon2i$v=19$m=65536,t=4,p=1$dGpEMW00cWpERW0vRzcveQ$w7W0d7HpWC95kDYUBnLargRuDmmdZjmdJYYK6lZ6RRo','$argon2i$v=19$m=65536,t=4,p=1$VHlmM0JRNFMualhJOC5KRg$Cj+9xE2BftZVVUOQ8wzZz8hAXUdZMMQCPrCbdXR0uoo','2025-04-18 10:56:27',0,NULL),('Yusuf Habu',NULL,'08122764476','$argon2i$v=19$m=65536,t=4,p=1$VFNxL25WZXUuRWhJek5nWA$/MJox/JaL1RD3LZY91fScbTkf6WVSQfmGI0EXkMUoh4','$argon2i$v=19$m=65536,t=4,p=1$NGR6ZkdTdDNqN21xamM2bQ$eEmJ67hDIWFYUDL8ygIRmX61cRb4InV/pvUGzl2OHRg','2025-04-18 10:57:21',1,NULL),('Billal Jabir','testUpdate@yahoo.com','08012345672','$argon2i$v=19$m=65536,t=4,p=1$ajBRSTk4NkRIOUZWeGZDZw$Ypu7MMZ5zz1o3yrBY65jaoxfHBQkTGNHnibLDn894x8','$argon2i$v=19$m=65536,t=4,p=1$d1VvekJhTEtFcjRvdldkTQ$8+GHAQqAkqTzzuJ+jqVMA3Ipa/hFRB2Hgf0lZdXfMcc','2025-06-25 00:25:01',1,NULL),('Test User',NULL,'012345678901','$argon2id$v=19$m=131072,t=4,p=2$TjU5aTBQTHNXU0NManRBcQ$T5TtgUonEZGLBM2i5X6MmPLGc+i0Jy2fAsYnvxyH0Jc','$argon2id$v=19$m=131072,t=4,p=2$Mk5nMDF3bk5mbjRCSmYzZw$LP91wlv8Z244VVzMVkF1xbcK2JvymeGO+dkxx/P/6tY','2025-08-20 22:43:45',0,'Test user Address'),('Test User',NULL,'012345678902','$argon2id$v=19$m=131072,t=4,p=2$dS9lTU5FU1MzVE81SjNUeQ$S510oGxFKoxNj5PVhDr8mgDyWKi4QcSEBlj9ITA1OwA','$argon2id$v=19$m=131072,t=4,p=2$M01zdUhrbDNMamdIdTdoUA$Qe2ilxRviYRmHNLw53TEYzZhbpZt3XfVSjvwkvwdDIk','2025-08-21 09:29:43',0,'Test user Address');

--
-- Table structure for table `pay_book`
--

CREATE TABLE `pay_book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pay_owner` varchar(50) NOT NULL,
  `transactionId` varchar(50) DEFAULT NULL,
  `transaction` enum('credit','debit') DEFAULT NULL,
  `transacted_amount` decimal(11,2) NOT NULL,
  `debited_to` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `transacted_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_pay_owner` (`pay_owner`),
  CONSTRAINT `CONSTRAINT_1` CHECK (`transaction` = 'credit' and `debited_to` is null and `transactionId` is not null or `transaction` = 'debit' and `debited_to` is not null and `transactionId` is null)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pay_book`
--

INSERT INTO `pay_book` VALUES (1,'08068124682','payldr12','credit',50000.00,NULL,'2025-10-18 05:26:31'),(2,'08068124682','payldr15','credit',60000.00,NULL,'2025-10-18 05:26:31'),(3,'08068124682','payldr16','credit',15000.00,NULL,'2025-10-18 05:26:31'),(4,'08068124682','payldr17','credit',5000.00,NULL,'2025-10-18 05:26:31'),(5,'08068124682','payldr18','credit',280000.00,NULL,'2025-10-18 05:26:31'),(6,'08068124682','payldr19','credit',25000.00,NULL,'2025-10-18 05:26:31'),(7,'08068124682','payldr20','credit',5000.00,NULL,'2025-10-18 05:26:31'),(8,'08068124682','payldr22','credit',20000.00,NULL,'2025-10-18 05:26:31'),(9,'08068124682','payldr23','credit',280000.00,NULL,'2025-10-18 05:26:31'),(10,'08068124682','payldr24','credit',10000.00,NULL,'2025-10-18 05:26:31'),(11,'08068124682','payldr27','credit',30000.00,NULL,'2025-10-18 05:26:31'),(12,'08068124682','payldr28','credit',20000.00,NULL,'2025-10-18 05:26:31'),(13,'08068124682','payldr29','credit',20000.00,NULL,'2025-10-18 05:26:31');

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `transactionId` varchar(25) NOT NULL,
  `flwRef` varchar(255) DEFAULT NULL,
  `flwTransactionID` varchar(255) DEFAULT NULL,
  `transaction_reference` varchar(50) DEFAULT NULL,
  `sumpaid` decimal(10,2) NOT NULL DEFAULT 0.00,
  `verified` int(1) NOT NULL DEFAULT 0,
  `checkCount` int(11) NOT NULL DEFAULT 0,
  `surmEarned` float DEFAULT NULL,
  `disputStatus` tinyint(1) NOT NULL DEFAULT 0,
  `refundStatus` tinyint(1) NOT NULL DEFAULT 0,
  `paytime` timestamp NOT NULL DEFAULT current_timestamp(),
  `refundRequseTime` datetime DEFAULT NULL,
  `refundTime` datetime DEFAULT NULL,
  `payout` enum('0','1') NOT NULL DEFAULT '0',
  UNIQUE KEY `transactionId` (`transactionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` VALUES ('payldr12','flw_tx_ref_Gv5eoN3hAK','9679707',NULL,50000.00,1,0,NULL,0,0,'2025-09-28 13:23:41',NULL,NULL,'1'),('payldr15','flw_tx_ref_uAxw2Mhy20','9679732',NULL,60000.00,1,0,NULL,0,0,'2025-09-28 13:38:59',NULL,NULL,'1'),('payldr16','flw_tx_ref_u6po2NH30Q','9679741',NULL,15000.00,1,0,NULL,0,0,'2025-09-28 13:50:56',NULL,NULL,'1'),('payldr17','flw_tx_ref_VHa9Yt6ZNK','9679754',NULL,5000.00,1,0,NULL,0,0,'2025-09-28 13:59:08',NULL,NULL,'1'),('payldr18','flw_tx_ref_RtRr4J06Wi','9679761',NULL,280000.00,1,0,NULL,0,0,'2025-09-28 14:02:43',NULL,NULL,'1'),('payldr19','flw_tx_ref_mLYVHMIbIr','9679780',NULL,25000.00,1,0,NULL,0,0,'2025-09-28 14:19:10',NULL,NULL,'1'),('payldr2','flw_tx_ref_ox3y7r2zAq','9674676',NULL,5000.00,1,0,NULL,0,0,'2025-09-25 21:31:07',NULL,NULL,'0'),('payldr20','flw_tx_ref_SrMcGCqVqQ','9679786',NULL,5000.00,1,0,NULL,0,0,'2025-09-28 14:26:22',NULL,NULL,'1'),('payldr22','flw_tx_ref_NLakmcQk3R','9679794',NULL,20000.00,1,0,NULL,0,0,'2025-09-28 14:30:16',NULL,NULL,'1'),('payldr23','flw_tx_ref_tym2Ual3b7','9679798',NULL,280000.00,1,0,NULL,0,0,'2025-09-28 14:35:07',NULL,NULL,'1'),('payldr24','flw_tx_ref_eMMRuaq6nd','9679923',NULL,10000.00,1,0,NULL,0,0,'2025-09-28 16:23:18',NULL,NULL,'1'),('payldr27','flw_tx_ref_QTPNMNgiSV','9686511',NULL,30000.00,1,0,NULL,0,0,'2025-10-01 12:38:52',NULL,NULL,'1'),('payldr28','flw_tx_ref_qhp2sHmAvK','9686542',NULL,20000.00,1,0,NULL,0,0,'2025-10-01 12:48:12',NULL,NULL,'1'),('payldr29','MockFLWRef-1760698095435',NULL,'Payldr_pDjBFhPD',20000.00,0,0,NULL,0,0,'2025-10-17 10:20:57',NULL,NULL,'1'),('payldr4','flw_tx_ref_Y2WsolMIbp','9674693',NULL,2000.00,1,0,NULL,0,0,'2025-09-25 21:43:22',NULL,NULL,'0'),('payldr5','flw_tx_ref_SNvBUHd2M4','9674699',NULL,2000.00,1,0,NULL,0,0,'2025-09-25 21:48:14',NULL,NULL,'0'),('payldr6','flw_tx_ref_iEH0flbe6V','9674703',NULL,500.00,1,0,NULL,0,0,'2025-09-25 21:51:26',NULL,NULL,'0'),('payldr8','flw_tx_ref_PVrLSCO9GS','9674705',NULL,2000.00,1,0,NULL,0,0,'2025-09-25 21:54:31',NULL,NULL,'0'),('payldr9','flw_tx_ref_E7os0BQWjI','9674710',NULL,1000.00,1,0,NULL,0,0,'2025-09-25 21:57:23',NULL,NULL,'0');

--
-- Table structure for table `productTable`
--

CREATE TABLE `productTable` (
  `productId` int(11) NOT NULL AUTO_INCREMENT,
  `product` varchar(255) NOT NULL,
  PRIMARY KEY (`productId`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `productTable`
--

INSERT INTO `productTable` VALUES (1,'Shap Sand fine'),(2,'Shap Sand coarse'),(3,'Plaster Sand'),(4,'Top Soil'),(5,'Laterite'),(6,'Stone Dust Dust 1'),(7,'Stone Dust Dust 2'),(8,'Gavel  3/4inch'),(9,'Gavel  1/2inch'),(10,'Gavel  1inch'),(11,'Gavel  2inch'),(12,'Hardcore/Boulders');

--
-- Table structure for table `product_prices`
--

CREATE TABLE `product_prices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `truck_id` int(11) DEFAULT NULL,
  `per_trip_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `per_ton_price` float(10,2) NOT NULL DEFAULT 0.00,
  `status` enum('current','obsolete') NOT NULL DEFAULT 'current',
  `price_set_at` datetime NOT NULL DEFAULT current_timestamp(),
  `price_changed_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_product_current` (`product_id`,`status`,`truck_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_prices`
--

INSERT INTO `product_prices` VALUES (1,2,1,270000.00,0.00,'current','2025-08-16 18:45:53','2025-08-16 18:45:53'),(2,5,NULL,0.00,170000.00,'current','2025-08-16 18:48:11','2025-08-16 18:48:11'),(3,1,1,280000.00,0.00,'current','2025-08-16 20:45:27','2025-08-16 20:45:27'),(4,1,2,350000.00,0.00,'current','2025-08-16 20:45:43','2025-08-16 20:45:43'),(5,1,3,200000.00,0.00,'current','2025-08-16 20:46:28','2025-08-16 20:46:28'),(6,1,4,150000.00,0.00,'current','2025-08-16 20:46:56','2025-08-16 20:46:56'),(7,5,1,280000.00,0.00,'current','2025-08-17 16:26:56','2025-08-17 16:26:56'),(8,6,NULL,0.00,25000.00,'current','2025-08-17 19:00:34','2025-08-17 19:00:34'),(9,1,5,120000.00,0.00,'current','2025-08-24 18:59:10','2025-08-24 18:59:10'),(10,8,NULL,0.00,15000.00,'current','2025-08-24 19:01:08','2025-08-24 19:01:08'),(11,9,NULL,0.00,14000.00,'current','2025-08-24 19:02:51','2025-08-24 19:02:51');

--
-- Table structure for table `projectssites`
--

CREATE TABLE `projectssites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clientId` varchar(25) NOT NULL,
  `projectName` text NOT NULL,
  `loc` text NOT NULL,
  `coordinates` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `siteStatus` enum('active','suspended','completed') NOT NULL DEFAULT 'active',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `delivery_recipient_name` varchar(50) NOT NULL,
  `delivery_recipient_phone` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `projectssites`
--

INSERT INTO `projectssites` VALUES (1,'08012345672','3 besRoom supply','Kubwa','{\"lat\":8.004,\"long\":8.004}','2025-06-25 00:28:02','suspended','2025-08-24 15:04:21','',''),(2,'08064763531','Bungalow Site','Life Camp','{\"lat\":8.004,\"long\":8.004}','2025-06-25 16:57:20','active','2025-08-24 15:04:21','',''),(3,'08012345672','3 besRoom supply','Kubwa','{\"lat\":8.004,\"long\":8.004}','2025-06-29 22:26:26','active','2025-08-24 15:04:21','',''),(4,'08012345672','3 besRoom supply','Kubwa','{\"lat\":8.004,\"long\":8.004}','2025-08-24 15:09:58','active','2025-08-24 15:09:58','',''),(5,'08064763531','Asokoro ','Badamasi Road ','{\"lat\":63.620724933239,\"long\":-107.99340236932}','2025-08-24 18:44:42','active','2025-08-24 18:44:42','',''),(6,'08064763531','Lugbe Site','Pyakasa','{\"lat\":8.9697041244874,\"long\":7.3820802630423}','2025-09-12 06:32:48','active','2025-10-06 20:32:25','supervisor sanusi','08068124682'),(7,'08064763531','3 bedRoom supply','Kubwa','{\"lat\":8.004,\"long\":8.004}','2025-10-06 20:54:26','active','2025-10-06 20:54:26','ilyasu gada byu','08023456789'),(8,'08064763531','New Gwarinpa Site','Gwarinpa','{\"lat\":9.1262895701893,\"long\":7.4240121109362}','2025-10-16 20:38:57','active','2025-10-16 20:45:31','Muhammad Sanusi','08122764475');

--
-- Table structure for table `signup`
--

CREATE TABLE `signup` (
  `user` varchar(255) NOT NULL,
  `genCode` varchar(255) NOT NULL,
  `codeGenTime` varchar(255) NOT NULL,
  `vrfStatu` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `signup`
--

INSERT INTO `signup` VALUES ('yuhyam95@gmail.com','$argon2i$v=19$m=65536,t=4,p=1$WC42VlkuOWdIeXBFZ1Bubw$0Tl8SZwubnYuXT32egwCoXWo2kEVziiAo/0mWvoziYA','1733747642',0),('fasibam472@eoilup.com','$argon2i$v=19$m=65536,t=4,p=1$YUdFOG1pSS9yMWVJZVVaTQ$oi27bf+wo3Aj8v3hv9kkrtJMtMs1x7qyfNcliOy6FAM','1733748826',1),('pepevo7104@eoilup.com','$argon2i$v=19$m=65536,t=4,p=1$QVl3cWljUFcydlUyY1J5Rg$W5SGiDTfLecH1dqwAMoSQs2zNel6wCHn07hSlpH1Bds','1733751509',0),('pepevi7104@eoilup.com','$argon2i$v=19$m=65536,t=4,p=1$ZjdOcFIxZTVKcHpJMlQyVQ$qLFuZnHdSALVvI8oMOlxPuaUzdGlHQ2W1fl+86Gxit4','1733751718',1),('sanucymtb@gmail.com','$argon2i$v=19$m=65536,t=4,p=1$NEs4bEgzaGRHSzR5dldDYg$MiBAzd7QEjQ4JndU2f4nL6Yt6UUgPIehxxMQq9uvh50','1739350264',1),('+2348068124682','$argon2i$v=19$m=65536,t=4,p=1$UVVaT0tsdjNLTm9qMTBiTg$IqULAQw4+yAPQCqtW5xURFDfQPs9ckS1Zs6NllDAxWE','1742843594',1),('+2348064763531','$argon2i$v=19$m=65536,t=4,p=1$cXh0eDZzVmdHR3pETzJyMA$ijrhEFSQmg8Ux2Vy1GGQYpljDClytvwGWghNmoAHitg','1742843595',1),('+2347037762286','$argon2i$v=19$m=65536,t=4,p=1$LzZUZndXMXZNd3Jmd3A4Lg$fvEXC1ppKTySnLjZX+c0PkHU8L87p0euBvRu73r45ng','1742843595',1),('+2348068124682','$argon2i$v=19$m=65536,t=4,p=1$UWZVbHlaTGRKVEkvVHhLQg$KrSp1OXxBjzZWOeMFurVQcFua/bx+w6rG8GiymO8s0U','1742844129',1),('+2348064763531','$argon2i$v=19$m=65536,t=4,p=1$cng3b2NVYkp5cVpNVHlhdw$K8J+0t3Lp01dQvCrW0LCoCxlwyk7nLuW8XDsu/yP3AA','1742844130',1),('+2347037762286','$argon2i$v=19$m=65536,t=4,p=1$VzVFOWFMYkliS04ubFp1TA$0mueG5boDPS50ncCaRkxM2PvFXh9SkbXUJWaDBEzmTM','1742844131',1),('user@example.com','$argon2i$v=19$m=65536,t=4,p=1$ejZudm91Z0JnRGNNV1FrVQ$YhaRuC9WR6ZHSgcrsrlciiY7pvxV8qSTZhRRUrJgsYM','1746049508',0),('user@example.com','$argon2i$v=19$m=65536,t=4,p=1$dU5rZTJra0V6ZlF0MzlZRA$iliYpfULZgpIp4G1hTHZ3h0CGNp0ATPhPtCV2vfMnTw','1746049508',0),('user@example.com','$argon2i$v=19$m=65536,t=4,p=1$clh2bXhqN0pGWU5WekVhcQ$41++nRQmU5uRD0iOjii0XgoefFg3cfrymlvCadvjjD4','1746049509',0),('user@example.com','$argon2i$v=19$m=65536,t=4,p=1$M3BzM2pRTXpqbXIxcEd2cw$t5NPx+FTMYW+kh2udAD3UNIPYYeTT141RWOP9WEkMAM','1746049509',0),('user@example.com','$argon2i$v=19$m=65536,t=4,p=1$eEgzcjNaSGcwMmFGR1BRaw$bdE3LM91fG6i7cehYgNnCi/IZz/iHQFtofgmObJfBTk','1746049508',0),('aishamsambo94@gmail.com','$argon2i$v=19$m=65536,t=4,p=1$NWcxTm56eGdsVlpQc2RsMg$NYEmRNgalA/miaMFwV8uF8zAGqv7ZWmKZRMeWkeZjFM','1746049542',1);

--
-- Table structure for table `stock_log`
--

CREATE TABLE `stock_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transactionId` varchar(255) NOT NULL,
  `stocked_at` datetime NOT NULL DEFAULT current_timestamp(),
  `resumed_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stock_log`
--

INSERT INTO `stock_log` VALUES (1,'payldr24','2025-09-29 19:43:21','2025-09-29 19:44:06'),(2,'payldr24','2025-09-29 19:58:48','2025-09-30 05:14:20'),(3,'payldr24','2025-09-30 05:19:45','2025-09-30 05:23:06'),(4,'payldr24','2025-09-30 05:42:54','2025-09-30 05:51:05');

--
-- Table structure for table `supertable`
--

CREATE TABLE `supertable` (
  `userEmail` varchar(255) NOT NULL,
  `userPhoneNumber` varchar(20) NOT NULL,
  `userFullName` varchar(255) NOT NULL,
  `userPassword` longtext DEFAULT NULL,
  `userDevice` varchar(200) NOT NULL,
  `userStatus` int(1) NOT NULL DEFAULT 0,
  `userPrivilege` int(1) NOT NULL DEFAULT 0,
  `OTP` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `supertable`
--

INSERT INTO `supertable` VALUES ('sanusimtb@gmail.com','+2348068124682','Muhammad sanusi','$argon2id$v=19$m=65536,t=4,p=1$bW03dWdVeGx2ckc5MnB6WA$CacIUKcYYkTwUuqpJNN7buSxZcKN0M6JbfssShy6ydI','9c3189742d53fe119ad5e9484ee2d226',1,1,'$argon2i$v=19$m=65536,t=4,p=1$SDFKaHo5VTFpb3dSbGhUUQ$/h2ZQIak1hG+6OiX1KK6SLSLfzm+SjZn8E2E3QZ/iyE');

--
-- Table structure for table `transctionTable`
--

CREATE TABLE `transctionTable` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `transactionID` varchar(255) DEFAULT NULL,
  `transPaties` longtext NOT NULL,
  `transDestinationData` longtext NOT NULL,
  `reQuestedDriverData` longtext DEFAULT NULL,
  `transitStatus` varchar(50) NOT NULL,
  `requestDate` date NOT NULL,
  `requestTime` time NOT NULL,
  `responseTime` time DEFAULT NULL,
  `rerouteTime` time DEFAULT NULL,
  `deliveryTime` time DEFAULT NULL,
  `driver_rating` float NOT NULL DEFAULT 2.5,
  `client_rating` float NOT NULL DEFAULT 2.5,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transctionTable`
--

INSERT INTO `transctionTable` VALUES (1,'payldr1','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":5}',NULL,'declined','2025-09-25','21:09:29','21:29:31',NULL,NULL,2.5,2.5),(2,'payldr2','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":5}',NULL,'completed','2025-09-25','21:09:30','21:30:26',NULL,'21:34:03',2.5,2.5),(3,'payldr3','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":2}',NULL,'declined','2025-09-25','21:09:36','21:36:31',NULL,NULL,2.5,2.5),(4,'payldr4','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":5}',NULL,'completed','2025-09-25','21:09:42','21:42:55',NULL,'21:46:45',2.5,2.5),(5,'payldr5','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":5}',NULL,'completed','2025-09-25','21:09:47','21:47:09',NULL,'21:49:53',2.5,2.5),(6,'payldr6','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":2}',NULL,'completed','2025-09-25','21:09:50','21:50:59',NULL,'21:53:09',2.5,2.5),(7,'payldr7','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":5}',NULL,'declined','2025-09-25','21:09:53','21:53:32',NULL,NULL,2.5,2.5),(8,'payldr8','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":5}',NULL,'completed','2025-09-25','21:09:53','21:53:58',NULL,'21:56:11',2.5,2.5),(9,'payldr9','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":5}',NULL,'completed','2025-09-25','21:09:56','21:56:54',NULL,'22:02:09',2.5,2.5),(10,'payldr10','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":2}',NULL,'declined','2025-09-25','22:09:08','22:09:32',NULL,NULL,2.5,2.5),(11,'payldr11','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":5}',NULL,'declined','2025-09-25','22:09:13','22:13:32',NULL,NULL,2.5,2.5),(12,'payldr12','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"}}',NULL,'completed','2025-09-28','13:09:23','13:23:08',NULL,'13:32:11',2.5,2.5),(13,'payldr13','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"productId\":1}',NULL,'declined','2025-09-28','13:09:37','13:37:31',NULL,NULL,2.5,2.5),(14,'payldr14','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"productId\":1,\"truckCategoryID\":\"2\"}',NULL,'declined','2025-09-28','13:09:37','13:38:02',NULL,NULL,2.5,2.5),(15,'payldr15','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"productId\":1,\"truckCategoryID\":\"2\"}',NULL,'completed','2025-09-28','13:09:38','13:38:25',NULL,'13:49:38',2.5,2.5),(16,'payldr16','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":2,\"productId\":1,\"truckCategoryID\":2}',NULL,'completed','2025-09-28','13:09:50','13:50:29',NULL,'13:57:21',2.5,2.5),(17,'payldr17','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":2,\"productId\":1,\"truckCategoryID\":2}',NULL,'completed','2025-09-28','13:09:58','13:58:25',NULL,'14:01:30',2.5,2.5),(18,'payldr18','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":2,\"productId\":1,\"truckCategoryID\":2}',NULL,'completed','2025-09-28','14:09:02','14:02:18',NULL,'14:13:40',2.5,2.5),(19,'payldr19','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":2,\"productId\":1,\"truckCategoryID\":2}',NULL,'completed','2025-09-28','14:09:18','14:18:28',NULL,'14:22:25',2.5,2.5),(20,'payldr20','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":1,\"productId\":1,\"truckCategoryID\":2}',NULL,'completed','2025-09-28','14:09:25','14:25:46',NULL,'14:28:00',2.5,2.5),(21,'payldr21','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":1,\"productId\":1,\"truckCategoryID\":2}',NULL,'declined','2025-09-28','14:09:29','14:29:31',NULL,NULL,2.5,2.5),(22,'payldr22','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":1,\"productId\":1,\"truckCategoryID\":2}',NULL,'completed','2025-09-28','14:09:29','14:29:48',NULL,'14:33:37',2.5,2.5),(23,'payldr23','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":1,\"productId\":1,\"truckCategoryID\":2}',NULL,'completed','2025-09-28','14:09:34','14:34:41',NULL,'14:51:46',2.5,2.5),(24,'payldr24','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":10,\"productId\":10,\"truckCategoryID\":2}',NULL,'completed','2025-09-28','16:09:22','16:22:49',NULL,'06:56:16',2.5,2.5),(25,'payldr25','{\"clientId\":\"08068124683\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Life Camp\",\"siteCoordinate\":{\"lon\":\"20.00003\",\"lat\":\"70.06079\"},\"tons\":40}',NULL,'canceled','2025-09-30','09:09:07','09:07:23',NULL,NULL,2.5,2.5),(26,'payldr26','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":5,\"productId\":11,\"truckCategoryID\":2}',NULL,'declined','2025-10-01','12:10:37','12:38:01',NULL,NULL,2.5,2.5),(27,'payldr27','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":2,\"productId\":11,\"truckCategoryID\":2}',NULL,'completed','2025-10-01','12:10:38','12:38:24',NULL,'12:45:59',2.5,2.5),(28,'payldr28','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":2,\"productId\":10,\"truckCategoryID\":2}',NULL,'completed','2025-10-01','12:10:47','12:47:43',NULL,'12:50:27',2.5,2.5),(29,'payldr29','{\"clientId\":\"08064763531\",\"driverId\":\"08068124682\"}','{\"siteLoc\":\"Pyakasa\",\"siteCoordinate\":{\"lon\":\"7.3820802630423\",\"lat\":\"8.9697041244874\"},\"tons\":2,\"productId\":8,\"truckCategoryID\":2}',NULL,'completed','2025-10-01','12:10:52','12:52:09',NULL,'12:58:50',3.3,2.5);

--
-- Table structure for table `transit_monitor`
--

CREATE TABLE `transit_monitor` (
  `transit_id` int(11) NOT NULL AUTO_INCREMENT,
  `transactionID` varchar(50) NOT NULL,
  `distance` float(10,2) NOT NULL DEFAULT 0.00,
  `check_count` int(1) NOT NULL DEFAULT 0,
  `transit_status` enum('open','close') NOT NULL DEFAULT 'open',
  `stocked_since` timestamp NULL DEFAULT NULL,
  `count_last_updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`transit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transit_monitor`
--

INSERT INTO `transit_monitor` VALUES (1,'payldr12',0.00,17,'close',NULL,NULL),(2,'payldr15',0.00,22,'close',NULL,NULL),(3,'payldr16',0.00,14,'close',NULL,NULL),(4,'payldr17',0.00,4,'close',NULL,NULL),(5,'payldr18',0.00,3,'close',NULL,NULL),(6,'payldr19',0.00,4,'close',NULL,NULL),(7,'payldr20',0.00,3,'close',NULL,NULL),(8,'payldr22',0.00,3,'close',NULL,NULL),(9,'payldr23',0.00,25,'close',NULL,NULL),(10,'payldr24',49.50,1,'close',NULL,'2025-09-30 06:53:52'),(11,'payldr27',0.00,0,'close',NULL,NULL),(12,'payldr28',0.00,0,'close',NULL,NULL),(13,'payldr29',0.00,0,'close',NULL,NULL);

--
-- Table structure for table `truckCategoryTable`
--

CREATE TABLE `truckCategoryTable` (
  `truckNamType` varchar(50) NOT NULL,
  `truckNumberOfTyres` varchar(50) NOT NULL,
  `truckCapacity` varchar(50) NOT NULL,
  `TruckCategoryID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`TruckCategoryID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `truckCategoryTable`
--

INSERT INTO `truckCategoryTable` VALUES ('HOWO','10','30-35Tons',1),('Tipper Trailer','16','65-70Tons',2),('Tipper','12','25-30Tons',3),('Tipper','10','18-25Tons',4),('Tipper','6','10-15Tons',5);


