 (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`


INSERT INTO `issues` (`id`, `issue`, `description`, `severity`, `status`, `opened_by`, `opened_date`, `opened_time`, `closed_date`, `closed_time`, `closed_by`, `actions_taken`) VALUES
(15, 'test', 'test', 'Medium', 'resolved', 'admin', '2015-11-26', '21:33:20', '2016-01-31', '12:22:47', 'admin', 'asdasdasd'),
(16, 'erere', 'zxsasa sjdha sdjaskjdla ksd', 'High', 'resolved', 'admin', '2016-01-30', '22:07:10', '2016-02-01', '18:54:21', 'admin', 'jhgjhg\n'),
(17, 'another issue', 'this is a short description of the current issue', 'High', 'resolved', 'admin', '2016-01-31', '13:34:15', '2016-01-31', '13:35:19', 'admin', 'nothing serious'),
(18, 'another issue 2', 'asda sd asd asda', 'Medium', 'resolved', 'admin', '2016-01-31', '13:34:48', '2016-02-01', '18:11:25', 'admin', 'bla bla blaa'),
(19, 'ererezsdas', 'sadas', 'Low', 'resolved', 'admin', '2016-01-31', '14:30:26', '2016-02-01', '18:37:39', 'admin', 'aaaaaaaa'),
(20, 'another issue 3', 'adsada', 'Medium', 'resolved', 'admin', '2016-01-31', '14:44:58', '2016-01-31', '14:45:40', 'admin', 'dsfsdfs'),
(21, 'another issue 4', 'test test', 'Medium', 'resolved', 'admin', '2016-01-31', '17:47:41', '2016-01-31', '17:48:01', 'admin', 'hgjh'),
(22, 'sdfsdfs', 'dfsdfsd', 'Medium', 'resolved', 'admin', '2016-02-01', '18:41:50', '2016-02-01', '22:17:29', 'admin', ' <br/> Actions for WK02 - hgjhgjhgj <br/> Actions for WK02 - asasas'),
(23, 'hgjh', 'jgjhg', 'High', 'resolved', 'admin', '2016-02-01', '18:54:53', '2016-02-01', '22:34:09', 'admin', ' <br/> Actions for WK02 - asdasdas <br/> Actions for WK01 - sasasasas <br/> Actions for WK02 - nothing <br/> Actions for WK02 - '),
(24, 'erere', 'dasdas', 'Low', 'resolved', 'admin', '2016-02-01', '22:20:18', '2016-02-01', '22:30:28', 'admin', ' <br/> Actions for WK01 - sdsdasd <br/> Actions for WK01 - zxczx <br/> Actions for WK01 - sdasda <br/> Actions for WK01 - zczxczx'),
(25, 'dfsdf', 'sdfsdfs', 'Medium', 'resolved', 'admin', '2016-02-01', '22:34:19', '2016-02-01', '22:34:32', 'admin', ''),
(26, 'sdasd', 'asdasd', 'Medium', 'resolved', 'admin', '2016-02-01', '22:34:42', '2016-02-01', '22:40:24', 'admin', 'hkjhkj'),
(27, 'asdas', 'asdasd', 'Medium', 'resolved', 'admin', '2016-02-01', '22:43:19', '2016-02-01', '22:43:28', 'admin', ' <br/> '),
(28, 'ssasa', 'sasas', 'Low', 'resolved', 'admin', '2016-02-01', '22:44:19', '2016-02-01', '22:44:28', 'admin', ' <br/> Actions for WK01 - asasasa <br/> asasa'),
(29, 'wewew', 'wewew', 'High', 'open', 'admin', '2016-02-01', '22:45:09', '0000-00-00', '00:00:00', '', ' <br/> Actions for WK01 - done'),
(30, 'sasa', 'sasas', 'select one', 'resolved', 'admin', '2016-02-01', '22:48:21', '2016-02-01', '22:50:26', 'admin', 'Actions for WK04 - asdasdas <br/> Actions for WK05 - asdasdasdsad <br/> '),
(31, 'test', 'fdsdf', 'Medium', 'resolved', 'admin', '2016-02-01', '22:49:59', '2016-02-01', '22:50:09', 'admin', ' <br/> ');

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

