-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 26, 2017 at 05:20 AM
-- Server version: 5.5.39
-- PHP Version: 5.4.31
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `finger`
--
-- --------------------------------------------------------
--
-- Table structure for table `absensi`
--
CREATE TABLE IF NOT EXISTS `absensi` (
`time` time NOT NULL,
`id_user` int(15) NOT NULL,
`date` date NOT NULL,
`ver` int(2) NOT NULL,
`status` int(2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `absensi`
--
INSERT INTO `absensi` (`time`, `id_user`, `date`, `ver`, `status`) VALUES
('17:44:20', 11113, '2016-11-30', 1, 1),
('15:47:27', 22005, '2016-11-30', 1, 1),
('17:40:29', 22003, '2016-11-30', 1, 1),
('16:16:29', 11017, '2016-11-30', 1, 1),
('16:31:39', 11050, '2016-11-30', 1, 1),
('18:19:35', 11111, '2016-11-30', 1, 1),
('18:19:44', 11123, '2016-11-30', 1, 1),
('21:59:03', 22010, '2016-11-30', 1, 1),
('05:32:08', 22011, '2016-12-01', 1, 0),
('06:05:31', 11029, '2016-12-01', 1, 0),
('06:06:47', 11058, '2016-12-01', 1, 0),
('06:07:43', 22010, '2016-12-01', 1, 0),
('06:10:32', 22012, '2016-12-01', 1, 0),
('06:17:56', 22004, '2016-12-01', 1, 0),
('06:20:22', 11050, '2016-12-01', 1, 0),
('06:21:11', 11017, '2016-12-01', 1, 0),
('06:22:03', 11110, '2016-12-01', 1, 0),
('06:22:22', 22003, '2016-12-01', 1, 0),
('06:22:40', 11113, '2016-12-01', 1, 0),
('06:23:17', 11100, '2016-12-01', 1, 0),
('06:23:53', 11005, '2016-12-01', 1, 0),
('06:24:47', 11055, '2016-12-01', 1, 0),
('06:25:02', 11089, '2016-12-01', 1, 0),
('06:25:05', 11127, '2016-12-01', 1, 0),
('06:26:46', 11031, '2016-12-01', 1, 0),
('06:27:03', 11126, '2016-12-01', 1, 0),
('06:27:21', 11056, '2016-12-01', 1, 0),
('06:29:29', 11133, '2016-12-01', 1, 0),
('06:29:40', 11111, '2016-12-01', 1, 0),
('06:29:45', 22008, '2016-12-01', 1, 0),
('06:30:36', 11128, '2016-12-01', 1, 0),
('06:30:57', 11082, '2016-12-01', 1, 0),
('06:32:54', 11106, '2016-12-01', 1, 0),
('06:33:29', 11129, '2016-12-01', 1, 0),
('06:36:01', 11120, '2016-12-01', 1, 0),
('06:37:11', 11107, '2016-12-01', 1, 0),
('06:41:13', 11124, '2016-12-01', 1, 0),
('06:42:41', 11069, '2016-12-01', 1, 0),
('06:43:39', 22006, '2016-12-01', 1, 0),
('06:43:44', 22007, '2016-12-01', 1, 0),
('06:44:11', 22001, '2016-12-01', 1, 0),
('06:48:11', 11054, '2016-12-01', 1, 0),
('06:48:48', 22009, '2016-12-01', 1, 0),
('06:49:01', 22005, '2016-12-01', 1, 0),
('06:50:14', 11092, '2016-12-01', 1, 0),
('06:50:30', 22013, '2016-12-01', 1, 0),
('06:51:37', 22014, '2016-12-01', 1, 0),
('07:51:01', 11101, '2016-12-01', 1, 0),
('08:01:49', 11057, '2016-12-01', 1, 0),
('08:01:58', 11123, '2016-12-01', 1, 0),
('08:08:18', 11064, '2016-12-01', 1, 0),
('08:10:02', 11109, '2016-12-01', 1, 0),
('10:14:41', 11127, '2016-12-01', 1, 1),
('11:58:35', 11109, '2016-12-01', 1, 1),
('13:13:27', 11057, '2016-12-01', 1, 1),
('13:22:17', 11107, '2016-12-01', 1, 1),
('13:22:29', 11133, '2016-12-01', 1, 1),
('13:27:01', 11058, '2016-12-01', 1, 1),
('13:27:42', 11126, '2016-12-01', 1, 1),
('13:29:48', 11056, '2016-12-01', 1, 1),
('13:30:46', 11067, '2016-12-01', 1, 0),
('13:31:16', 11054, '2016-12-01', 1, 1),
('13:34:02', 11082, '2016-12-01', 1, 1),
('13:35:48', 11029, '2016-12-01', 1, 1),
('13:42:13', 11129, '2016-12-01', 1, 1),
('13:50:25', 11069, '2016-12-01', 1, 1),
('13:57:05', 11005, '2016-12-01', 1, 1),
('13:58:04', 22014, '2016-12-01', 1, 1),
('13:58:08', 22013, '2016-12-01', 1, 1),
('13:58:20', 22008, '2016-12-01', 1, 1),
('13:58:26', 22009, '2016-12-01', 1, 1),
('14:24:56', 22001, '2016-12-01', 1, 1),
('14:29:11', 11055, '2016-12-01', 1, 1),
('14:29:22', 11092, '2016-12-01', 1, 1),
('14:31:51', 11100, '2016-12-01', 1, 1),
('14:38:26', 11120, '2016-12-01', 1, 1),
('14:40:49', 22007, '2016-12-01', 1, 1),
('14:41:00', 22004, '2016-12-01', 1, 1),
('15:17:44', 11050, '2016-12-01', 1, 1),
('15:45:34', 11031, '2016-12-01', 1, 1),
('15:50:23', 11106, '2016-12-01', 1, 1),
('15:59:28', 22005, '2016-12-01', 1, 1),
('17:12:10', 11110, '2016-12-01', 1, 1),
('17:21:38', 11123, '2016-12-01', 1, 1),
('17:33:07', 22003, '2016-12-01', 1, 1),
('18:22:56', 11111, '2016-12-01', 1, 1),
('21:58:47', 22010, '2016-12-01', 1, 1),
('05:02:42', 22011, '2016-12-02', 1, 0),
('13:00:21', 22005, '2016-12-02', 1, 0),
('06:10:09', 11029, '2016-12-02', 1, 0),
('06:10:16', 22010, '2016-12-02', 1, 0),
('06:11:37', 22012, '2016-12-02', 1, 0),
('06:14:25', 11050, '2016-12-02', 1, 0),
('06:19:24', 11058, '2016-12-02', 1, 0),
('12:01:34', 22003, '2016-12-02', 1, 0),
('06:25:19', 11106, '2016-12-02', 1, 0),
('06:26:14', 11111, '2016-12-02', 1, 0),
('06:30:29', 11120, '2016-12-02', 1, 0),
('06:30:32', 11130, '2016-12-02', 1, 0),
('06:31:46', 11100, '2016-12-02', 1, 0),
('06:35:53', 11118, '2016-12-02', 1, 0),
('06:38:21', 11031, '2016-12-02', 1, 0),
('06:40:03', 11067, '2016-12-02', 1, 0),
('06:40:11', 11055, '2016-12-02', 1, 0),
('06:41:51', 11126, '2016-12-02', 1, 0),
('06:42:25', 11056, '2016-12-02', 1, 0),
('06:42:58', 11005, '2016-12-02', 1, 0),
('06:46:09', 22001, '2016-12-02', 1, 0),
('06:46:27', 22007, '2016-12-02', 1, 0),
('06:47:03', 11129, '2016-12-02', 1, 0),
('06:49:27', 11107, '2016-12-02', 1, 0),
('06:50:00', 11101, '2016-12-02', 1, 0),
('06:51:27', 11092, '2016-12-02', 1, 0),
('06:51:36', 11123, '2016-12-02', 1, 0),
('06:51:41', 22006, '2016-12-02', 1, 0),
('06:55:14', 11109, '2016-12-02', 1, 0),
('06:57:45', 11069, '2016-12-02', 1, 0),
('06:58:53', 22008, '2016-12-02', 1, 0),
('07:00:53', 11110, '2016-12-02', 1, 0),
('07:03:34', 11113, '2016-12-02', 1, 0),
('07:03:43', 11054, '2016-12-02', 1, 0),
('07:04:52', 11131, '2016-12-02', 1, 0),
('07:08:17', 11133, '2016-12-02', 1, 0),
('07:12:25', 11132, '2016-12-02', 1, 0),
('07:13:36', 11089, '2016-12-02', 1, 0),
('07:15:54', 11127, '2016-12-02', 1, 0),
('07:17:24', 22014, '2016-12-02', 1, 0),
('07:17:45', 22009, '2016-12-02', 1, 0),
('07:22:09', 22013, '2016-12-02', 1, 0),
('07:25:32', 22004, '2016-12-02', 1, 0),
('08:36:04', 11017, '2016-12-02', 1, 0),
('09:10:53', 11109, '2016-12-02', 1, 1),
('10:37:02', 11132, '2016-12-02', 1, 1),
('10:57:25', 11127, '2016-12-02', 1, 1),
('10:58:34', 11133, '2016-12-02', 1, 1),
('11:01:48', 11110, '2016-12-02', 1, 1),
('11:02:33', 11131, '2016-12-02', 1, 1),
('11:03:45', 11058, '2016-12-02', 1, 1),
('11:05:09', 11118, '2016-12-02', 1, 1),
('11:08:02', 11054, '2016-12-02', 1, 1),
('11:08:38', 11082, '2016-12-02', 1, 1),
('11:10:15', 11129, '2016-12-02', 1, 1),
('11:14:49', 22009, '2016-12-02', 1, 1),
('11:14:56', 22013, '2016-12-02', 1, 1),
('11:15:21', 22014, '2016-12-02', 1, 1),
('11:21:58', 22008, '2016-12-02', 1, 1),
('11:22:41', 11107, '2016-12-02', 1, 1),
('11:22:54', 11056, '2016-12-02', 1, 1),
('11:23:59', 22001, '2016-12-02', 1, 1),
('11:24:08', 11126, '2016-12-02', 1, 1),
('11:26:04', 11005, '2016-12-02', 1, 1),
('11:35:24', 11100, '2016-12-02', 1, 1),
('12:00:02', 22006, '2016-12-02', 1, 1),
('12:07:52', 11069, '2016-12-02', 1, 1),
('12:31:47', 11120, '2016-12-02', 1, 1),
('12:42:39', 11101, '2016-12-02', 1, 1),
('12:51:01', 11029, '2016-12-02', 1, 1),
('13:00:29', 22005, '2016-12-02', 1, 1),
('13:01:12', 22007, '2016-12-02', 1, 1),
('13:01:18', 22004, '2016-12-02', 1, 1),
('13:11:04', 11123, '2016-12-02', 1, 1),
('13:11:28', 11092, '2016-12-02', 1, 1),
('13:56:43', 22012, '2016-12-02', 1, 1),
('14:02:08', 11055, '2016-12-02', 1, 1),
('14:05:17', 11050, '2016-12-02', 1, 1),
('14:15:05', 11017, '2016-12-02', 1, 1),
('14:21:13', 11031, '2016-12-02', 1, 1),
('15:12:47', 11106, '2016-12-02', 1, 1),
('15:54:39', 11113, '2016-12-02', 1, 1),
('17:10:08', 11111, '2016-12-02', 1, 1),
('21:58:25', 22010, '2016-12-02', 1, 1),
('05:17:11', 22011, '2016-12-03', 1, 1),
(
