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

  `borrowers_fname` varchar(45) NOT NULL,
  `borrowers_mname` varchar(45) NOT NULL,
  `borrowers_lname` varchar(45) NOT NULL,
  `subject` varchar(45) NOT NULL,
  `schedule` varchar(45) NOT NULL,
  `instructor` varchar(45) NOT NULL,

-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Oct 15, 2016 at 10:07 PM
-- Server version: 10.1.16-MariaDB
-- PHP Version: 7.0.9

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