-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `student_info`
--

CREATE TABLE `student_info` (
  `id` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `course_year` varchar(200) NOT NULL,
  `instructor_name` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_info`
--

INSERT INTO `student_info` (`id`, `name`, `course_year`, `instructor_name`) VALUES
('13645853131', 'Juan Dela Cruz', 'BsIT 1C', ''),
('13646154135', 'Junna Dela Cruza', 'BSIS 1X', ''),
('13646653251', 'BERNA CRUZ', 'BSIT 1X', ''),
('13647453243', 'Romblon Berta', 'BSIT 2C', ''),
('13648253235', 'Joan Anthony', 'BSIT 2C', ''),
('942442184391', 'JOSE Martillo', 'BSIT 1C', '');

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

--
-- Table structure for table `tbl_time`
--

CREATE TABLE `tbl_time` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `year_section` varchar(200) NOT NULL,
  `date` varchar(200) NOT NULL,
  `time_in` char(200) DEFAULT NULL,
  `time_out` char(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_time`
--

INSERT INTO `tbl_time` (`id`, `name`, `year_section`, `date`, `time_in`, `time_out`) VALUES
(1, 'Many Pacman', '', '2018-08-09', '16:12:58', '16:24:30'),
(2, 'Many Pacman', '', '2018-08-09', '16:24:26', '16:24:30'),
(3, 'Joan Anthony', 'BSIT 2C', '2018-08-09', '16:24:34', ''),
(4, 'Romblon Berta', 'BSIT 2C', '2018-08-09', '16:24:38', ''),
(5, 'Many Villar', '', '2018-08-09', '16:24:43', ''),
(6, 'Romblon Berto', '', '2018-08-09', '16:24:47', ''),
(7, 'Donna Mae Martillo', 'BSIT 1C', '2018-08-09', '16:24:51', '11:33:13'),
(8, 'Donna Mae Martillo', 'BSIT 1C', '2018-08-23', '11:23:47', '11:33:13'),
(9, 'Donna Mae Martillo', 'BSIT 1C', '2018-08-23', '11:33:06', '11:33:13'),
(10, 'Many Villar', '', '2018-08-23', '11:33:21', ''),
(11, 'JOSE Martillo', 'BSIT 1C', '2018-08-23', '11:40:31', '11:41:18'),
(12, 'Junna Dela Cruza', 'BSIS 1X', '2018-08-23', '11:40:44', ''),
(13, 'Romblon Berta', 'BSIT 2C', '2018-08-23', '11:40:53', ''),
(14, 'BERNA CRUZ', 'BSIT 1X', '2018-08-23', '11:41:02', ''),
(15, 'Joan Anthony', 'BSIT 2C', '2018-08-23', '11:41:09', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `student_info`
--
ALTER TABLE `student_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_time`
--
ALTER TABLE `tbl_time`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_time`
--
ALTER TABLE `tbl_time`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
COMMIT;

