-- phpMyAdmin SQL Dump
-- version 4.6.5.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Sep 12, 2017 at 10:34 AM
-- Server version: 10.1.21-MariaDB
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `apl_repair`
--

-- --------------------------------------------------------

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

CREATE TABLE `repair_list` (
  `id` int(11) NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

--
-- Indexes for dumped tables
--

--
-- Indexes for table `repair_list`
--
ALTER TABLE `repair_list`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `repair_list`
--
ALTER TABLE `repair_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
/*!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 */;
