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


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

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

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

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

INSERT INTO `drvr` VALUES ('sanusi',NULL,'+2348068124682','{\"locationName\":\"Dutse Tipper Garage\",\"coodinate\":{\"long\":20.472,\"lat\":70.874}}',NULL,NULL,'$argon2i$v=19$m=65536,t=4,p=1$Wi51SGdNWHg1WWhXRDdaQg$UT+1QMdW2TJUDKgHYiUSVKJAKjGJhQeBIkFJBKoPH4E','[{\"id\":1,\"licensePlate\":\"1234Abj\",\"truckDriver\":\"self\"}]',NULL,NULL,'2025-03-27 13:06:31',1),('yusuf',NULL,'+2348064763531','{\"locationName\":\"Dutse Tipper Garage\",\"coodinate\":{\"long\":20.472,\"lat\":70.874}}',NULL,NULL,'$argon2i$v=19$m=65536,t=4,p=1$RTk0RmlVZkNKN1ZiTWI3eg$08v9asRG941fb4U13rdI3r5uxzU+UC1F/6lPf9NzPcY','[{\"id\":1,\"licensePlate\":\"1234krsh\",\"truckDriver\":\"self\"}]',NULL,NULL,'2025-03-27 13:06:31',1),('OgaNuhu',NULL,'+2347037762286','{\"locationName\":\"Dutse Tipper Garage\",\"coodinate\":{\"long\":20.472,\"lat\":70.874}}',NULL,NULL,'$argon2i$v=19$m=65536,t=4,p=1$LnBSMjBCdU5JeVRGUHdGbA$2Xc3t//j/pGfuGyd56Gh4kkxL4lGexqHuyh/nFzP1+I','[{\"id\":1,\"licensePlate\":\"1234KUJ\",\"truckDriver\":\"self\"}]',NULL,NULL,'2025-03-27 13:06:31',1);

--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `drvrClnt` VALUES ('ClientSanusi',NULL,'+2348068124682','$argon2i$v=19$m=65536,t=4,p=1$RUtYUHY2VEZaRDZTY3VrMQ$3WjDamgYsiOgygBipTZhvqBEbb2X/5638K96M36NskE',NULL,'2025-03-24 19:59:23',1),('ClientYusuf',NULL,'+2348064763531','$argon2i$v=19$m=65536,t=4,p=1$SXB1akZDZ2Z1RUF6MnA3eg$S1I9USDngABotbezVUIkTHv/VJuEOHozauSP+Xillmg',NULL,'2025-03-24 19:59:23',1),('ClientOgaNuhu',NULL,'+2347037762286','$argon2i$v=19$m=65536,t=4,p=1$bU1abTB4bkY2MmJ0VkRpaw$8SWRrWCgitAcic4/kgtuP9pujEpepVe3JdeJYdi7pMQ',NULL,'2025-03-24 19:59:24',1);

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

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

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

INSERT INTO `productTable` VALUES ('Shap Sand','{}','{\"1\":\"fine\", \"2\":\"coarse\"}',1),('Plaster Sand','{}','{}',2),('Top Soil','{}','{}',3),('Laterite','{}','{}',4),('Stone  Dust','{}','{\"1\":\"Dust 1\", \"2\":\"Dust 2\"}',5),('Stone  Dust','{}','{\"1\":\"3/4inch\", \"2\":\"1/2inch\",\"3\":\"1inch\", \"4\":\"2inch\"}',6),('Hardcore/Boulders','{}','{}',7);

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

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

CREATE TABLE `transctionTable` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `transactionID` varchar(255) NOT 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,
  `deliveryTime` time DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `transctionTable` VALUES (7,'#payldr1','{\"clientId\":null,\"driverId\":null}','{\"clientLoc\":\"Life Camp\",\"ClientCoordinate\":{\"long\":\"20.00003\",\"lat\":\"70.06079\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1}',NULL,'requested','2025-04-05','09:22:22',NULL,NULL),(8,'#payldr2','{\"clientId\":\"+2348068124682\",\"driverId\":\"+2348064763531\"}','{\"clientLoc\":\"Life Camp\",\"ClientCoordinate\":{\"long\":\"20.00003\",\"lat\":\"70.06079\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1}',NULL,'completed','2025-04-05','09:36:51','09:37:20','10:12:57'),(9,'#payldr3','{\"clientId\":\"+2348068124682\",\"driverId\":\"+2348064763531\"}','{\"clientLoc\":\"Life Camp\",\"ClientCoordinate\":{\"long\":\"20.00003\",\"lat\":\"70.06079\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1}',NULL,'completed','2025-04-05','10:13:29','10:13:54','04:02:22'),(10,'#payldr4','{\"clientId\":\"+2348068124682\",\"driverId\":\"+2348064763531\"}','{\"clientLoc\":\"Life Camp\",\"ClientCoordinate\":{\"long\":\"20.00003\",\"lat\":\"70.06079\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1}',NULL,'completed','2025-04-05','04:05:39','04:05:55','04:06:01'),(11,'#payldr5','{\"clientId\":\"+2348068124682\",\"driverId\":\"+2348064763531\"}','{\"clientLoc\":\"Life Camp\",\"ClientCoordinate\":{\"long\":\"20.00003\",\"lat\":\"70.06079\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1}',NULL,'declined','2025-04-05','08:19:42','08:20:40',NULL),(12,'#payldr6','{\"clientId\":\"+2348068124682\",\"driverId\":\"+2348064763531\"}','{\"clientLoc\":\"Life Camp\",\"ClientCoordinate\":{\"long\":\"20.00003\",\"lat\":\"70.06079\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1}',NULL,'accepted','2025-04-05','08:23:50','08:24:06',NULL),(13,'#payldr7','{\"clientId\":\"+2348068124682\",\"driverId\":\"+2348064763531\"}','{\"clientLoc\":\"Life Camp\",\"ClientCoordinate\":{\"long\":\"20.00003\",\"lat\":\"70.06079\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1}',NULL,'declined','2025-04-06','06:11:16','06:17:55',NULL),(14,'#payldr8','{\"clientId\":\"+2348068124682\",\"driverId\":\"+2348064763531\"}','{\"clientLoc\":\"Life Camp\",\"ClientCoordinate\":{\"long\":\"20.00003\",\"lat\":\"70.06079\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1}',NULL,'accepted','2025-04-06','06:18:32','06:18:40',NULL),(15,'#payldr9','{\"clientId\":\"+2348068124682\",\"driverId\":\"+2347037762286\"}','{\"clientLoc\":\"Life Camp\",\"ClientCoordinate\":{\"long\":\"20.00003\",\"lat\":\"70.06079\"},\"productId\":1,\"productCategoryID\":1,\"TruckCategoryID\":1}',NULL,'accepted','2025-04-06','06:24:16','06:25:26',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);


