 -- http://www.phpmyadmin.net
 --
 -- Host: 127.0.0.1
--- Generation Time: Oct 11, 2016 at 03:21 AM
--- Server version: 10.1.13-MariaDB
--- PHP Version: 5.6.23
+-- 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";

(11, 'Successfully updated laboratory().', 'DCpE', '2016-10-10 23:41:56', 1),
(12, 'Successfully added violation(3003).', 'DCpE', '2016-10-10 23:44:19', 1),
(13, 'Successfully updated violation(1030341).', 'DCpE', '2016-10-10 23:45:08', 1),
(14, 'Successfully added item(test paper).', 'SE LABORATORY', '2016-10-10 23:46:31', 0),
(15, 'Staff neil3 has successfully added item(Euls Scepter).', 'SE LABORATORY', '2016-10-11 00:30:14', 0),
(16, 'successfully added user(5001).', 'DCpE', '2016-10-11 00:31:26', 1),
(17, 'Staff pinoy has successfully added item(mar roxas).', 'DCpE', '2016-10-11 00:32:00', 1),
(18, 'successfully added item(5pops).', 'DCpE', '2016-10-11 00:54:41', 1),
(19, 'successfully updated user(141F74).', 'DCpE', '2016-10-11 00:55:46', 1),
(20, 'successfully updated user(141F7).', 'DCpE', '2016-10-11 01:20:48', 0);

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


  `damaged_item` int(20) NOT NULL,
  `item_code` varchar(45) NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `laboratory` varchar(45) NOT NULL,
  `custodian` varchar(45) NOT NULL,
  `borrowdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `borrowers_info`
--

INSERT INTO `borrowers_info` (`borrowers_id`, `borrowers_idnumber`, `borrowers_fname`, `borrowers_mname`, `borrowers_lname`, `year`, `course`, `department`, `subject`, `schedule`, `instructor`, `tablenumber`, `quantity`, `damaged_item`, `item_code`, `item_name`, `laboratory`, `custodian`, `borrowdate`) VALUES
(22, '06031111', 'juliet', 'secret', 'mendez', '', '', '', 'cpe415', 'mwf 7:30-10:10', 'engr. pana', '04', '2', 0, '5', '', '', '', '2016-10-15 15:22:38'),
(23, '06305105', 'juliet', 'secret', 'mendez', '', '', '', 'cpe415', 'mwf 7:30-10:10', 'engr. pana', '05', '1', 0, '6', '', '', '', '2016-10-15 15:22:38'),
(24, '06305105', 'juliet', 'secret', 'mendez', '', '', '', 'cpe415', 'mwf 7:30-10:10', 'engr. uno', '04', '1', 0, '6', '', '', '', '2016-10-15 15:22:38'),
(25, '999', 'jj', 'jj', 'jj', '', '', '', 'jj', 'jj', 'jj', '09', '0', 0, '6', '', '', '', '2016-10-15 15:22:38'),
(26, '12121', 'kk', 'kk', 'kk', '', '', '', 'kk', 'kk', 'kk', '9', '2', 0, '3', '', '', '', '2016-10-15 15:22:38'),
(27, 'dd', 'dd', 'dd', 'dd', '', '', '', 'dd', 'dd', 'dd', '1', '1', 0, '3', '', '', '', '2016-10-15 15:22:38'),
(28, '11', '232', 'asdw', 'asd', '', '', '', 'sdf', 'fdsf', 'sfds', '31', '1', 0, '3', '', '', '', '2016-10-15 15:22:38'),
(29, '11', '232', 'asdw', 'asd', '', '', '', 'sdf', 'fdsf', 'sfds', '31', '1', 0, '3', '', '', '', '2016-10-15 15:22:38'),
(30, '111111', '111111', '111111', '111111111111', '', '', '', '111111', '111111', '111111', '111111', '1', 0, '9', '', '', '', '2016-10-15 15:22:38'),
(92, '12312', 'luffy', 'D.', 'monkey', '', 'BS-CHE', 'DCpE', 'qwiipw', 'qwepo', 'Ms. Juliet Mendez', '2', '1', 0, '1', 'sdfasdf', 'DCpE', 'milky', '2016-10-15 15:22:38'),
(95, '09876', 'Nico', 'O', 'Robin', '', 'Faculty', 'DCE', 'One Piece', 'Sunday 12noon', 'Monkey D. Dragon', 'Sunny', '2', 0, '21', 'Resistor', 'SE Laboratory', 'neil3', '2016-10-15 15:22:38');

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

