   `borrowers_fname` varchar(45) NOT NULL,
   `borrowers_mname` varchar(45) NOT NULL,
   `borrowers_lname` varchar(45) NOT NULL,
+  `year` varchar(45) NOT NULL,
+  `course` varchar(45) NOT NULL,
+  `department` varchar(45) NOT NULL,
   `subject` varchar(45) NOT NULL,
   `schedule` varchar(45) NOT NULL,
   `instructor` varchar(45) NOT NULL,

(15, 'DM Laboratory', 'DML', ''),
(16, 'PCB Laboratory', 'PCB Lab', ''),
(19, 'DCpE', 'DCpE', ''),
(20, 'testingan2', 'testingan2', '');

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


-- Dumping data for table `item`
--

INSERT INTO `item` (`code`, `name`, `description`, `previousstatus`, `currentstatus`, `itemtype`, `serialnumber`, `partnumber`, `manufacturenumber`, `dateacquired`, `expirationdate`, `remarks`, `totalquantity`, `availablequantity`, `damagedquantity`, `custodian`, `owner`) VALUES
(1, 'sdfasdf', 'oh yeah', 'asdfg', 'asdf', '', 'zxcvbn1234', '1234567', '1234567', '2016-10-03', '0000-00-00', 'consumable', '2', '1', '2', '1', 'DCpE'),
(2, 'bottle', '1liter', 'none', 'empty', '', '45678', '78', '0987', '2016-10-05', '0000-00-00', 'consumable', '1', '0', 'ok', '', 'DCpE'),
(3, 'adf', 'adf', 'adf', 'adf', '', '456789', '456789', '6789', '2016-10-05', '0000-00-00', 'consumable', '1', '3', '3', '', 'DCpE'),
(4, 'dfghjk', 'fjk', 'fghjk', 'dfghjk', '', '23456789', '345678', '345678', '2016-10-07', '0000-00-00', 'consumable', '4', '4', 'none', '', 'DCpE'),
(5, ' ', ' ', ' ', ' ', '', '  ', ' ', ' ', '2016-10-07', '0000-00-00', ' ', ' ', '2', '0', '', 'DCpE'),
(6, ' ', ' ', ' ', ' ', '', '  ', ' ', ' ', '2016-10-07', '0000-00-00', '  ', ' ', '3', '0', '', 'DCpE'),
(7, ' ', 'tost', 'tost', 'tost', '', 'tost', 'tost', 'tost', '2016-10-07', '0000-00-00', 'tsot', '8', '10', '8', '', 'DCpE'),
(8, 'tust', ' ', 'tust', 'tust', '', 'tust', 'tust', 'tust', '2016-10-07', '0000-00-00', 'non-consumable', '5', '6', '5', '', 'DCpE'),
(9, 'TAAAST', 'tyst', 'tyst', 'tyst', '', 'tyst', 'tyst', 'tyst', '2016-10-07', '0000-00-00', 'non-consumable', '41', '4', '41', '', 'DCpE'),
(10, 'KI', 'assodifl', 'oasidjfalsjf', 'asdfjasoij', '', 'asdfjaso', 'asodijfas', 'asdofjas', '2016-10-07', '0000-00-00', 'non-consumable', 'sldjf', '1', '1', '', 'DCpE'),
(11, '1', '1', '1', '1', '', '1', '1', '11', '2016-10-12', '0000-00-00', '1', '1', '1', '1', '', 'DCpE'),
(12, '2', '22', '2', '2', '', '2', '2', '2', '2016-10-09', '0000-00-00', '2', '2', '2', '2', '', 'DCpE'),
(13, '3', '3', '3', '3', '', '3', '3', '3', '2016-10-09', '0000-00-00', '3', '3', '33', '3', '', 'DCpE'),
(14, '4', '4', '4', '4', '', '4', '44', '4', '2016-10-09', '0000-00-00', '4', '4', '4', '4', '', 'DCpE'),
(15, '5', '5', '5', '5', '', '5', '5', '5', '2016-10-09', '0000-00-00', '5', '5', '5', '5', '', 'DCpE'),
(16, '5', '5', '5', '5', '', '5', '5', '5', '2016-10-09', '0000-00-00', '5', '5', '5', '5', '', 'DCpE'),
(17, '6', '66', '6', '6', '', '6666', '6', '6', '2016-10-09', '0000-00-00', '6', '6', '6', '6', '', 'DCpE'),
(18, '2', '2', '2', '2', '', '2', '2', '2', '2016-10-09', '0000-00-00', '2', '2', '2', '2', '', 'DCpE'),
(19, '3', '3', '3', '3', '', '3', '3', '3', '2016-10-09', '0000-00-00', '3', '3', '3', '3', '123', 'DCpE'),
(20, '3', '3', '3', '3', '', '3', '3', '3', '2016-10-09', '0000-00-00', '3', '3', '3', '3', '', 'DCpE'),
(21, 'Resistor', '300 Ohms', 'Good', 'Good', '', '1212', '1212', '1212', '2016-10-10', '0000-00-00', 'Good Condition', '20', '18', '0', '123456', 'SE LABORATORY'),
(22, 'a', 'a', 'a', 'a', '', 'a', 'a', 'a', '1293-12-31', '0000-00-00', 'a', 'a', 'a', 'a', '', 'DCpE'),
(23, ' 1234', ' 2345', ' 234', ' 2345', '', ' 4235', ' 5', ' 3245', '2016-12-31', '0000-00-00', ' 324354', ' 32435', ' 12435', ' 55', '', 'DCpE'),
(24, 'laptop1', 'lenovo12', 'new', 'good condition', '', '123456', '76543', 'lenovo', '2016-10-12', '0000-00-00', 'not consomable', '1', '1', '0', 'engr. patrick uno`12', 'DCpE'),
(25, 'eew', 'wer', 'wqer', 'wer', '', 'ewr', 'wer', 'ewr', '2016-10-28', '0000-00-00', 'wer', 'er', 'wer', 'wer', 'wer', 'DCpE'),
(26, '3t', '234', '34', '234', '', '3244', '233', '3244', '2016-10-20', '0000-00-00', '132', '123', '32', '23', '2344', 'DCpE'),
(27, '1', '1', '1', '1', '', '1', '1', '1', '2016-10-26', '0000-00-00', '1', '1', '1', '1', '1', 'DCpE'),
(28, 'Chocolate', 'Chocolate', 'N/A', 'N/A', '', 'N/A', 'N/A', 'N/A', '2016-10-11', '0000-00-00', 'consumable', '15', '15', '0', 'Kit', 'SE LABORATORY'),
(29, 'two pops kit', 'two pops kit', 'two pops kit', 'two pops kit', '', 'two pops kit', 'two pops kit', 'two pops kit', '2016-10-12', '0000-00-00', 'consumable', '2', '2', '0', 'kit', 'DCpE'),
(30, '3 pops', '3 pops', 'N/A', 'N/A', '', 'N/A', 'N/A', 'N/A', '2016-10-12', '0000-00-00', 'consumable', '3', '3', '0', 'Kit', 'DCpE'),
(31, 'test paper', 'test paper', 'NA', 'NA', '', 'NA', 'NA', 'NA', '2016-09-28', '0000-00-00', 'consumable', '12', '12', '0', 'kit', 'SE LABORATORY'),
(32, 'Euls Scepter', 'Euls Scepter', 'N/A', 'N/A', '', 'N/A', 'N/A', 'N/A', '2016-10-11', '0000-00-00', 'consumable', '2', '2', '0', 'Kit', 'SE LABORATORY'),
(33, 'Euls Scepter', 'Euls Scepter', 'N/A', 'N/A', '', 'N/A', 'N/A', 'N/A', '2016-10-11', '0000-00-00', 'consumable', '3', '2', '0', 'Kit', 'SE LABORATORY'),
(34, 'mar roxas', 'N/A', 'N/A', 'N/A', '', 'N/A', 'N/A', 'N/A', '2016-10-12', '0000-00-00', 'non-consumable', '1', '1', '0', 'Kit', 'DCpE'),
(35, '5pops', '5pops', '5pops', '5pops', '', '5pops', '5pops', '5pops', '2016-10-19', '0000-00-00', 'consumable', '2', '2', '0', '1', 'DCpE'),
(36, ' ', ' ', ' ', ' ', '', ' ', ' ', ' ', '2015-12-31', '0000-00-00', 'consumable', '0', '0', '0', ' ', 'DCpE'),
(37, '1022831', 'for cleaning', 'new', 'functional', '', '194y1lk', '102310', '12318', '2016-10-14', '0000-00-00', 'consumable', '20', '20', '0', 'trikshot', 'SE Laboratory');

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

