 (3, 'WK02', 'LAB02', 'intel i5 2Ghz', 'Z97', '4GB DDR3', '500GB', 1, 1, 1, 'Requires Repairs', '', '2016-01-27 12:18:21 am', '', 'admin'),
 (4, 'WK03', 'LAB01', 'i3(4010) 2.3Ghz', 'Z97', '4GB DDR3', '500GB', 1, 1, 0, 'Functional', '', '2016-01-27', '12:21:35 am', 'admin'),
 (5, 'WK04', 'LAB01', 'i3(4010) 2.3Ghz', 'Z97', '4GB DDR3', '500GB', 1, 1, 0, 'Functional', '', '2016-01-27', '12:24:04 am', 'admin'),
-(6, 'WK05', 'LAB01', 'i3', 'Z97', '4GB DDR3', '500GB', 1, 1, 0, 'Out of service', '', '2016-01-27', '12:24:59 am', 'admin'),
+(6, 'WK05', 'LAB01', 'i3', 'Z97', '4GB DDR3', '500GB', 1, 1, 0, 'Functional', '', '2016-01-27', '12:24:59 am', 'admin'),
 (8, 'WK06', 'LAB02', 'i3(4010) 2.3Ghz ', 'Z97-A', '4GB DDR3', '500GB', 1, 1, 1, 'Functional', 'fgdfgd11', '2016-01-27', '12:15:41 pm', 'admin'),
 (9, 'WK07', 'LAB09', 'i3(4010) 2.3Ghz', 'Z97-A', '4GB DDR3', '500GB', 1, 1, 1, 'Functional', 'test test test... jkh', '2016-01-28', '04:29:44 pm', 'admin'),
-(10, 'WK08', 'LAB09', 'i3(4010) 2.3Ghz', 'Z97', '4GB DDR3', '500GB', 1, 1, 1, 'Requires Repairs', 'some OS issues', '2016-01-28', '09:51:25 pm', 'admin'),
-(12, 'WK09', 'LAB02', 'i3(4010) 2.3Ghz', 'Z97', '4GB DDR3', '500GB', 1, 1, 0, 'Requires Repairs', '', '2016-01-30', '11:46:48 am', 'admin');
+(10, 'WK08', 'LAB09', 'i3(4010) 2.3Ghz', 'Z97', '4GB DDR3', '500GB', 1, 1, 1, 'Functional', 'some OS issues', '2016-01-28', '09:51:25 pm', 'admin'),
+(12, 'WK09', 'LAB02', 'i3(4010) 2.3Ghz', 'Z97', '4GB DDR3', '500GB', 1, 1, 0, 'Functional', '', '2016-01-30', '11:46:48 am', 'admin');
 
 -- --------------------------------------------------------
 

  `closed_by` varchar(20) NOT NULL,
  `actions_taken` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `issues`

  `computer_code` varchar(20) NOT NULL,
  `status` varchar(25) NOT NULL,
  `closed_date` date NOT NULL,
  `closed_time` time NOT NULL,
  `closed_by` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `issue_id` (`issue_id`,`computer_code`,`closed_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=44 ;

--
-- Dumping data for table `issue_history`
--

INSERT INTO `issue_history` (`id`, `issue_id`, `computer_code`, `status`, `closed_date`, `closed_time`, `closed_by`) VALUES
(6, 15, 'WK02', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(7, 15, 'WK03', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(8, 16, 'WK02', 'resolved', '2016-02-01', '18:54:21', 'admin'),
(9, 16, 'WK03', 'resolved', '2016-02-01', '18:54:21', 'admin'),
(10, 17, 'WK05', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(11, 17, 'WK06', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(12, 18, 'WK01', 'resolved', '2016-02-01', '00:00:00', 'admin'),
(13, 18, 'WK02', 'resolved', '2016-02-01', '00:00:00', 'admin'),
(14, 18, 'WK03', 'resolved', '2016-02-01', '00:00:00', 'admin'),
(15, 18, 'WK04', 'resolved', '2016-02-01', '00:00:00', 'admin'),
(16, 19, 'WK01', 'resolved', '2016-02-01', '18:37:40', 'admin'),
(17, 20, 'WK08', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(18, 21, 'WK01', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(19, 21, 'WK02', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(20, 21, 'WK03', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(21, 21, 'WK04', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(22, 21, 'WK05', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(23, 21, 'WK06', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(24, 21, 'WK07', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(25, 21, 'WK08', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(26, 21, 'WK09', 'resolved', '2016-01-31', '00:00:00', 'admin'),
(27, 22, 'WK02', 'resolved', '0000-00-00', '00:00:00', 'admin'),
(28, 23, 'WK01', 'resolved', '0000-00-00', '00:00:00', 'admin'),
(29, 23, 'WK02', 'resolved', '2016-02-01', '22:34:09', 'admin'),
(30, 24, 'WK01', 'resolved', '2016-02-01', '22:30:28', 'admin'),
(31, 25, 'WK01', 'resolved', '2016-02-01', '22:34:33', 'admin'),
(32, 26, 'WK01', 'resolved', '2016-02-01', '22:40:24', 'admin'),
(33, 26, 'WK02', 'resolved', '2016-02-01', '22:40:24', 'admin'),
(34, 26, 'WK03', 'resolved', '2016-02-01', '22:40:24', 'admin'),
(35, 27, 'WK01', 'resolved', '2016-02-01', '22:43:28', 'admin'),
(36, 27, 'WK02', 'resolved', '2016-02-01', '22:43:28', 'admin'),
(37, 27, 'WK04', 'resolved', '2016-02-01', '22:43:28', 'admin'),
(38, 28, 'WK01', 'resolved', '2016-02-01', '22:44:28', 'admin'),
(39, 28, 'WK02', 'resolved', '2016-02-01', '22:44:28', 'admin'),
(40, 29, 'WK01', 'resolved', '2016-02-01', '22:45:42', 'admin'),
(41, 29, 'WK02', 'open', '0000-00-00', '00:00:00', ''),
(42, 30, 'WK04', 'resolved', '2016-02-01', '22:50:22', 'admin'),
(43, 30, 'WK05', 'resolved', '2016-02-01', '22:50:25', 'admin');

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

