-- MySQL dump 10.13  Distrib 5.7.44, for Linux (x86_64)
--
-- Host: localhost    Database: supportf_repair
-- ------------------------------------------------------
-- Server version	5.7.44-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `supportf_repair`
--


--
-- Table structure for table `repair_list`
--

DROP TABLE IF EXISTS `repair_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `repair_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_of_item` varchar(100) CHARACTER SET utf8 NOT NULL,
  `serial_number` varchar(100) CHARACTER SET utf8 NOT NULL,
  `originating_station` varchar(100) CHARACTER SET utf8 NOT NULL,
  `date_in` varchar(100) CHARACTER SET utf8 NOT NULL,
  `problem` varchar(100) CHARACTER SET utf8 NOT NULL,
  `date_sent` varchar(100) CHARACTER SET utf8 NOT NULL,
  `work_done` varchar(100) CHARACTER SET utf8 NOT NULL,
  `date_returned` varchar(100) CHARACTER SET utf8 NOT NULL,
  `date_returned_to` varchar(100) CHARACTER SET utf8 NOT NULL,
  `remark` varchar(100) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `repair_list`
--

LOCK TABLES `repair_list` WRITE;
/*!40000 ALTER TABLE `repair_list` DISABLE KEYS */;
INSERT INTO `repair_list` (`id`, `name_of_item`, `serial_number`, `originating_station`, `date_in`, `problem`, `date_sent`, `work_done`, `date_returned`, `date_returned_to`, `remark`) VALUES (1,'HP LASERJET P1102W','VNF5826110','ABUJA STATION ','','NOT POWERING/GENERAL SERVICING','12/05/2017','','18/5/2017','',''),(2,'MEXTRON UPS','E100825386','ABUJA STATION ','','NOT POWERING/GENERAL SERVICING','12/05/2017','','','',''),(3,'HP LASERJET PRO M1270W','CNB8G6F8Q8','ENUGU STATION','','NOT POWERING/GENERAL SERVICING','12/05/2017','','18/5/2017','',''),(4,'HP ALL IN ONE','3CR53102BK','PORT-HARCOURT','','BLUE SCREEN ERROR','16/05/2017','','19/06/2017','','bad motherboard cant be fixed'),(5,'HP ALL IN ONE','3CR53102G9','ENUGU STATION','','CRACKED SCREEN ','','','09/06/2017','',''),(6,'MERCURY UPS *','150401E2000N00175','OWERRI','','','','','','',''),(7,'MERCURY UPS','140212E2000N00711','PHC','24/05/2017','BAD','31/05/2017','','','',''),(8,'MOUSE','','ABUJA STATION ','','BAD','','','','',''),(9,'MOUSE','','ABUJA STATION ','','BAD','','','','',''),(10,'LENOVO ALL-IN-ONE DESKTOP POWER PACK','','ABUJA STATION ','','BAD','','','','',''),(11,'LENOVO ALL-IN-ONE DESKTOP','','ABUJA STATION ','','','','','','',''),(12,'VIDTRONIX PRINTER POWER ADAPTOR','','ENUGU STATION','','BAD','','','','',''),(13,'VIDTRONIX PRINTER POWER ADAPTOR','','ENUGU STATION','','BAD','','','','',''),(14,'MERCURY UPS','','ENUGU STATION','','POWER RUNS OUT FAST','','','','',''),(15,'MERCURY UPS','','ENUGU STATION','','POWER RUNS OUT FAST','','','','',''),(16,'KEYBOARD','BCYUHDARZ6CJQ4','OWERRI','23/05/2027','BAD','24/05/2017','','','',''),(17,'MOUSE','','OWERRI','23/05/2027','BAD','24/05/2017','','','',''),(18,'MERCURY UPS','','OWERRI','23/05/2017','POWER RUNS OUT FAST','24/05/2017','','','',''),(19,'MERCURY UPS','','OWERRI','','POWER RUNS OUT FAST','24/05/2017','','','',''),(20,'MERCURY UPS','','OWERRI','23/05/2017','POWER RUNS OUT FAST','24/05/2017','','','',''),(21,'BLUE GATE UPS','','OWERRI','23/05/2017','POWER RUNS OUT FAST','24/05/2017','','','',''),(22,'HP LASERJET P1102W','VNF6M22293','ABUJA STATION ','19/04/2017','IT DOES NOT PICK PAPER/ROLLS PERPETUALLY','13/06/2017','','13/606/2017','',''),(23,'VIDTRONIX PRINTER',' M16-11-0006','BENIN','','','','','','',''),(24,'MERCURY UPS','150602E2000N01629','ABUJA STATION ','06/05/2017','NOT HOLDING CHARGE','06/05/2017','','','',''),(25,'MERCURY UPS','140409E2000N00600','ABUJA STATION ','Mon 05, June, 2017','NOT HOLDING CHARGE','06/05/2017','','','',''),(26,'MERCURY UPS','150609E2000N00049','ABUJA STATION ','06/05/2017','NOT HOLDING CHARGE','06/05/2017','','','',''),(27,'MERCURY UPS','150609E2000N00050','ABUJA STATION ','06/05/2017','NOT HOLDING CHARGE','06/05/2017','','','',''),(28,'MERCURY UPS','150609E2000N00026','ABUJA STATION ','06/05/2017','NOT HOLDING CHARGE','06/05/2017','','','',''),(29,'HP AC ADPTER 19.5V 2.31A','CT: WEFQA0AVS7XGOZ','ABUJA STATION ','06/05/2017','BAD NEEDS REPLACEMENT','','','','',''),(30,'VIDTRONIX PRINTER','M15040014','ABUJA STATION ','06/05/2017','','','','','',''),(31,'VINTRONIX PRINTER','M15040022','ABUJA STATION ','06/05/2017','','','','','',''),(32,'DELL LAPTOP','8ZB1MT1','Elizabeth Ogunrinde','06/05/2017','SHAKY CHARGING PORT/BAD ADAPTOR','','','','',''),(33,'HP LASERJET P1102W','VNF5717670','OWERRI','13/06/2017','STOPPED WORKING','13/06/2017','','','',''),(34,'HP ALL IN ONE','CZC4092794','LAGOS','11/07/2017','NOT POWERING','','','','',''),(35,'HP LASERJET P1102W','VNF5T22788','LAGOS','05/07/2017','Cannot print','','','','',''),(36,'HP LASERJET P1102W','VNF3752286','LAGOS','15/07/2017','Cannot print','17/07/2017','','','',''),(37,'printer','rv254f5vf5rv2wv6','abuja','2017-09-01','not powering','2017-09-07','','','',''),(38,'printer','rv254f5vf5rv2wv6','abuja','2017-09-15','not powering','2017-09-14','','2017-09-04','',''),(39,'Sample Item','00000998876','HQ','18/5/2017','Bad','18/5/2017','','','',''),(40,'Vidtronix Map Printer','14012519','Lagos','2017-08-01','Faulty Power Board','2017-08-29','the Power Board was changed','','','Printer is now functional'),(41,'Vidtronix Map Printer','16002396','Uyo','2017-08-09','Faulty B68 Belt ','2017-09-13','B68 Belt was changed','','','the printer is now working properly'),(42,'HP Laserjet P1102w','VNF4154593','Lagos GAT','2017-09-25','Printing Faintly','2017-09-26','','','',''),(43,'HP Laserjet P1102w','VNF6N00805','Lagos GAT','2017-09-25','Stop printing/Broken Toner chamber','2017-09-26','','','',''),(44,'Mercury UPS','140515E2000B01202','Lagos GAT','2017-09-25','Sparks','2017-09-26','','','',''),(45,'Mercury U.P.S','150609E2000N00376','Benin ','2017-09-25','Not Powering ','2017-09-26','','','',''),(46,'Mercury U.P.S','140409E2000N00647','Benin','2017-09-25','Not Powering','2017-09-26','','','',''),(47,'Blue Gate U.P.s','UPS/BG/BNI/001','Benin ','2017-09-26','Not Powering ','2017-09-26','','','',''),(48,'HP P1102W','VNF5F56375','OWERRI AIRPORT','2017-09-26','Broken Cover and Broken toner chamber','2017-09-26','','','',''),(49,'Mercury UPS','160303E2000N00314','Abuja Station - Silverbird Outlet','2017-09-27','No Longer Holding Power','2017-09-27','Change of battery ','9/10/2017','10/10/2017','Okay'),(50,'HP Pro One 400 G1 AIO Business PC','CZC4350DV8','Abuja Station','2017-09-27','PC No longer Powers on','2017-09-27','','','',''),(51,'Mercury U.P.S','170518E2000N00422','Owerri','27/09/2017','Not Powering','29/09/2017','Change of battery','09/10/2017','10/10/2017','Okay'),(52,'HP 250 G4','CND5283HC9','HQ/ Call Center','10/10/2017','Not coming up','18/10/2017','','','',''),(53,'HP MFP M125NW/CZ173A ','CNB&G36G76','Head Quarters','10/10/2017','Not Powering','19/10/2017','','','',''),(54,'HP ','vnf3753280','MMIA Lagos','2017-10-19','Roller Not Picking up Paper','2017-10-27','','','',''),(55,'Mercury UPS','140515E2000N01201','Cabin Crew Scheduling Lagos','2017-10-19','Battery','2017-10-27','','','',''),(56,'Mercury UPS','150609E2000N00025','Abuja Station','2017-10-19','Battery','2017-10-27','','','',''),(57,'Mercury UPS','140725E2000N00619','Engineering Store - HQ','2017-10-19','Giving Off Sparks','2017-10-27','','','',''),(58,'Mercury UPS','140409E2000N00647','Corporate Communications - HQ','2017-10-19','Affected by Thunder Storm and No Longer Powers on','2017-10-27','','','',''),(59,'HP Laptop','CND5342194','Abuja','2018-06-25','Screen issue','2018-06-26','','','',''),(60,'HP LAP TOP','CND5342194','ABUJA','2018-07-02','SCREEN ISSUE','2018-07-02','','','',''),(61,'HP 250 G4','CND5342194','ABUJA','2018-06-28','SCREEN ISSUE, REPLACEMENT OF POWER','2018-07-02','','','',''),(62,'sample','123456','LOS','2018-07-05','Sample issue','2018-07-05','','','','');
/*!40000 ALTER TABLE `repair_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'supportf_repair'
--

--
-- Dumping routines for database 'supportf_repair'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-03-07 13:22:02
