text: -- phpMyAdmin SQL Dump
  -- version 4.5.1
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Generation Time: Feb 09, 2018 at 06:52 AM
  -- Server version: 10.1.19-MariaDB
  -- PHP Version: 7.0.13
  
  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 utf8mb4 */;
  
  --
  -- Database: `dasar`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_admin`
  --
  
  CREATE TABLE `tbl_admin` (
    `nim` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_admin`
  --
  
  INSERT INTO `tbl_admin` (`nim`) VALUES
  (''),
  ('201431024'),
  ('201431062'),
  ('201431290'),
  ('201431299'),
  ('201531146'),
  ('201531189'),
  ('201631057'),
  ('201631100'),
  ('201631165'),
  ('201631300');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_bantuan`
  --
  
  CREATE TABLE `tbl_bantuan` (
    `no_bantuan` int(100) NOT NULL,
    `nama` varchar(40) NOT NULL,
    `judul` varchar(50) NOT NULL,
    `keluhan` text NOT NULL,
    `tanggal` datetime NOT NULL,
    `status` varchar(30) NOT NULL,
    `balasan` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_bantuan`
  --
  
  INSERT INTO `tbl_bantuan` (`no_bantuan`, `nama`, `judul`, `keluhan`, `tanggal`, `status`, `balasan`) VALUES
  (1, 'umar', 'tes', 'test', '2017-11-03 12:25:44', 'selesai', 'halo sehat?'),
  (2, 'alwi', 'bantuin kerjain soal dong', 'hehehehe', '2017-11-07 13:31:33', 'selesai', ''),
  (3, 'bagus septian', 'tes', 'praktikan jaman now, GGWP', '2017-11-13 13:23:34', 'selesai', ''),
  (4, 'umar', 'kehilangan rahasia', 'hello world\r\n', '2017-11-21 10:02:40', 'selesai', 'hello');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_jadwal_lab`
  --
  
  CREATE TABLE `tbl_jadwal_lab` (
    `kode_jadwal` varchar(10) NOT NULL,
    `kode_matakuliah` varchar(15) DEFAULT NULL,
    `kelas` varchar(5) DEFAULT NULL,
    `hari` varchar(10) DEFAULT NULL,
    `jam_mulai` time DEFAULT NULL,
    `jam_selesai` time DEFAULT NULL,
    `nama_lab` varchar(15) DEFAULT NULL,
    `pjasisten` varchar(30) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_jadwal_lab`
  --
  
  INSERT INTO `tbl_jadwal_lab` (`kode_jadwal`, `kode_matakuliah`, `kelas`, `hari`, `jam_mulai`, `jam_selesai`, `nama_lab`, `pjasisten`) VALUES
  ('JM001', 'C31040315', 'D', 'jumat', '08:00:00', '10:30:00', 'LAB DASAR 1', 'Sri, Alfin, Abdan'),
  ('JM003', 'C31040413', 'H', 'jumat', '08:00:00', '11:20:00', 'LAB DASAR 2', 'Bintang'),
  ('KM001', 'C31040413', 'A', 'kamis', '08:00:00', '11:20:00', 'LAB DASAR 1', 'Ryan, Sri, Ian, Fahmi'),
  ('KM002', 'C31040413', 'C', 'kamis', '13:00:00', '16:20:00', 'LAB DASAR 1', 'Edwin, Hafiza, Mayang'),
  ('KM003', 'C31040107', 'E', 'kamis', '08:00:00', '10:30:00', 'LAB DASAR 2', 'Difa, Putra'),
  ('KM004', 'C31040201', 'E', 'kamis', '11:00:00', '12:40:00', 'LAB DASAR 2', 'Abdan'),
  ('KM005', 'C31040107', 'G', 'kamis', '13:00:00', '15:30:00', 'LAB DASAR 2', 'Nuggy'),
  ('RB001', 'C31040413', 'F', 'rabu', '08:00:00', '11:20:00', 'LAB DASAR 1', 'Inas, Nilam, Heri'),
  ('RB002', 'C31040413', 'G', 'rabu', '13:00:00', '16:20:00', 'LAB DASAR 1', 'Rilo'),
  ('RB003', 'C31040107', 'E', 'rabu', '08:00:00', '10:30:00', 'LAB DASAR 2', 'Difa, Putra'),
  ('RB004', 'C31040201', 'E', 'rabu', '11:00:00', '12:40:00', 'LAB DASAR 2', 'Abdan'),
  ('RB005', 'C31040107', 'G', 'rabu', '13:00:00', '15:30:00', 'LAB DASAR 2', 'Nuggy'),
  ('SB001', 'C31040203', 'G', 'sabtu', '08:00:00', '09:40:00', 'LAB DASAR 1', 'Abdan, Dhiya, Nilam, Mayang'),
  ('SB002', 'C31040203', 'H', 'sabtu', '10:00:00', '11:40:00', 'LAB DASAR 1', 'Fahmi, Mayang, Abdan'),
  ('SB003', 'C31040107', 'I', 'sabtu', '08:00:00', '10:30:00', 'LAB DASAR 2', 'Aflah'),
  ('SL001', 'C31040107', 'B', 'selasa', '08:00:00', '10:30:00', 'LAB DASAR 1', 'Heri, Ian'),
  ('SL002', 'C31041401', 'A', 'selasa', '11:00:00', '12:40:00', 'LAB DASAR 1', 'Umar, Nuggy Ian'),
  ('SL003', 'C31040311', 'B', 'selasa', '13:00:00', '15:30:00', 'LAB DASAR 1', 'Nilam, Rillo, Mayang, Umar'),
  ('SL004', 'C31040201', 'C', 'selasa', '08:00:00', '09:40:00', 'LAB DASAR 2', 'Abdan'),
  ('SL005', 'C31040201', 'D', 'selasa', '10:00:00', '11:40:00', 'LAB DASAR 2', 'Difa'),
  ('SL006', 'C31040107', 'G', 'selasa', '13:00:00', '15:30:00', 'LAB DASAR 2', 'Givary'),
  ('SN001', 'C31040203', 'F', 'senin', '08:00:00', '09:40:00', 'LAB DASAR 1', 'Alfin, Putra, Umar, Hafiza'),
  ('SN003', 'C31040309', 'B', 'senin', '13:00:00', '14:40:00', 'LAB DASAR 1', 'Ian, Bintang, Edwin, Umar'),
  ('SN004', 'C31040201', 'G', 'senin', '15:00:00', '16:40:00', 'LAB DASAR 1', 'Riantri, Alfin, Inas, Putra'),
  ('SN005', 'C31040201', 'A', 'senin', '08:00:00', '09:40:00', 'LAB DASAR 2', 'Nilam'),
  ('SN006', 'C31040201', 'F', 'senin', '10:00:00', '11:40:00', 'LAB DASAR 2', 'Rilo'),
  ('SN007', 'C31040107', 'A', 'senin', '13:00:00', '15:30:00', 'LAB DASAR 2', 'Dhiya, Mayang');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_matakuliah`
  --
  
  CREATE TABLE `tbl_matakuliah` (
    `kode_matakuliah` varchar(15) NOT NULL,
    `nama_matakuliah` varchar(35) DEFAULT NULL,
    `sks` int(11) DEFAULT NULL,
    `status` int(11) NOT NULL,
    `page` varchar(15) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_matakuliah`
  --
  
  INSERT INTO `tbl_matakuliah` (`kode_matakuliah`, `nama_matakuliah`, `sks`, `status`, `page`) VALUES
  ('201331026', 'AP1 - Kode A', 3, 0, 'ap1-A'),
  ('201331027', 'AP1 - Kode B', 3, 0, 'ap1-B'),
  ('C31000000', 'Workshop', 10, 1, 'workshop'),
  ('C31040101', 'AP1 Pretest', 1, 0, 'ap1Pretest'),
  ('C31040106', 'Algoritma & Pemrograman 2', 3, 0, 'ap2'),
  ('C31040107', 'Algoritma & Pemrograman 1', 3, 1, 'ap1'),
  ('C31040110', 'Statistika', 3, 0, 'statistika'),
  ('C31040201', 'Struktur Data', 2, 1, 'strukturdata'),
  ('C31040202', 'Bahasa Rakitan', 2, 0, 'barak'),
  ('C31040203', 'Pemrograman Visual', 2, 1, 'pemvis'),
  ('C31040206', 'Pemrograman Objek', 2, 0, 'pbo'),
  ('C31040210', 'Mikroprosesor', 3, 0, 'mikroprosessor'),
  ('C31040304', 'Perancangan Basis Data', 2, 0, 'pbd'),
  ('C31040309', 'Teknik Animasi', 2, 1, 'tekan'),
  ('C31040311', 'Sistem Basis Data', 3, 1, 'sbd'),
  ('C31040315', 'Jaringan Komputer', 3, 1, 'jarkom'),
  ('C31040413', 'Rekayasa Perangkat Lunak', 4, 1, 'rpl'),
  ('C31041308', 'Cloud Computing', 2, 0, 'cc'),
  ('C31041401', 'Data Mining', 2, 1, 'datamining'),
  ('C31041409', 'Mobile Programming', 2, 1, 'moprog');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_nilai`
  --
  
  CREATE TABLE `tbl_nilai` (
    `nim` varchar(20) DEFAULT NULL,
    `kode_matakuliah` varchar(15) DEFAULT NULL,
    `kelas` varchar(5) DEFAULT NULL,
    `laporan` varchar(10) DEFAULT NULL,
    `tgl_kumpul` datetime DEFAULT NULL,
    `nilai` int(11) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_nilai`
  --
  
  INSERT INTO `tbl_nilai` (`nim`, `kode_matakuliah`, `kelas`, `laporan`, `tgl_kumpul`, `nilai`) VALUES
  ('201631175', 'C31040203', 'G', '1', '2017-09-16 09:02:18', 85),
  ('201631016', 'C31040203', 'G', '1', '2017-09-16 09:03:40', 88),
  ('201631247', 'C31040203', 'G', '1', '2017-09-16 09:03:50', 80),
  ('201631286', 'C31040203', 'G', '1', '2017-09-16 09:04:31', 82),
  ('201631302', 'C31040203', 'G', '1', '2017-09-16 09:04:45', 82),
  ('201631118', 'C31040203', 'G', '1', '2017-09-16 09:04:56', 80),
  ('201631041', 'C31040203', 'G', '1', '2017-09-16 09:05:21', 80),
  ('201631187', 'C31040203', 'G', '1', '2017-09-16 09:05:31', 85),
  ('201631194', 'C31040203', 'G', '1', '2017-09-16 09:05:44', 82),
  ('201631182', 'C31040203', 'G', '1', '2017-09-16 09:05:54', 82),
  ('201631152', 'C31040203', 'G', '1', '2017-09-16 09:06:07', 80),
  ('201631301', 'C31040203', 'G', '1', '2017-09-16 09:06:18', 78),
  ('201631141', 'C31040203', 'G', '1', '2017-09-16 09:06:26', 80),
  ('201631221', 'C31040203', 'G', '1', '2017-09-16 09:07:01', 78),
  ('201631125', 'C31040203', 'G', '1', '2017-09-16 09:07:13', 82),
  ('201631113', 'C31040203', 'G', '1', '2017-09-16 09:07:24', 80),
  ('201631007', 'C31040203', 'G', '1', '2017-09-16 09:07:36', 80),
  ('201631002', 'C31040203', 'G', '1', '2017-09-16 09:07:44', 90),
  ('201631203', 'C31040203', 'G', '1', '2017-09-16 09:09:50', 88),
  ('201631063', 'C31040203', 'G', '1', '2017-09-16 09:10:00', 82),
  ('201631026', 'C31040203', 'G', '1', '2017-09-16 09:10:08', 85),
  ('201631079', 'C31040203', 'G', '1', '2017-09-16 09:10:29', 88),
  ('201631050', 'C31040203', 'G', '1', '2017-09-16 09:10:43', 85),
  ('201631102', 'C31040203', 'G', '1', '2017-09-16 09:10:56', 85),
  ('201631087', 'C31040203', 'G', '1', '2017-09-16 09:11:07', 82),
  ('201631270', 'C31040203', 'G', '1', '2017-09-16 09:11:18', 82),
  ('201631068', 'C31040203', 'G', '1', '2017-09-16 09:28:35', 75),
  ('201631032', 'C31040203', 'G', '1', '2017-09-16 09:53:25', 75),
  ('201631277', 'C31040203', 'G', '1', '2017-09-16 10:14:08', 81),
  ('201631217', 'C31040203', 'F', '1', '2017-09-18 09:16:39', 65),
  ('201631198', 'C31040203', 'F', '1', '2017-09-18 09:17:00', 99),
  ('201631188', 'C31040203', 'F', '1', '2017-09-18 09:17:11', 94),
  ('201631222', 'C31040203', 'F', '1', '2017-09-18 09:17:21', 85),
  ('201631004', 'C31040203', 'F', '1', '2017-09-18 09:18:45', 80),
  ('201631241', 'C31040203', 'F', '1', '2017-09-18 09:19:51', 85),
  ('201631021', 'C31040203', 'F', '1', '2017-09-18 09:19:59', 70),
  ('201631124', 'C31040203', 'F', '1', '2017-09-18 09:20:06', 80),
  ('201631001', 'C31040203', 'F', '1', '2017-09-18 09:49:14', 70),
  ('201631290', 'C31040203', 'F', '1', '2017-09-18 09:49:23', 75),
  ('201631266', 'C31040203', 'F', '1', '2017-09-18 09:49:31', 80),
  ('201631111', 'C31040203', 'F', '1', '2017-09-18 09:49:44', 40),
  ('201631067', 'C31040203', 'F', '1', '2017-09-18 09:50:01', 75),
  ('201631169', 'C31040203', 'F', '1', '2017-09-18 09:50:18', 80),
  ('201631083', 'C31040203', 'F', '1', '2017-09-18 09:50:25', 85),
  ('201631043', 'C31040203', 'F', '1', '2017-09-18 09:50:32', 90),
  ('201631191', 'C31040203', 'F', '1', '2017-09-18 09:50:40', 85),
  ('201631049', 'C31040203', 'F', '1', '2017-09-18 09:50:46', 80),
  ('201631008', 'C31040203', 'F', '1', '2017-09-18 09:50:52', 90),
  ('201631269', 'C31040203', 'F', '1', '2017-09-18 09:50:59', 90),
  ('201631052', 'C31040203', 'F', '1', '2017-09-18 09:51:04', 90),
  ('201631265', 'C31040203', 'F', '1', '2017-09-18 09:51:09', 90),
  ('201631121', 'C31040203', 'F', '1', '2017-09-18 09:51:15', 85),
  ('201631034', 'C31040203', 'F', '1', '2017-09-18 09:51:20', 85),
  ('201631157', 'C31040203', 'H', '1', '2017-09-23 07:54:34', 84),
  ('201631254', 'C31040203', 'H', '1', '2017-09-23 07:55:00', 78),
  ('201631153', 'C31040203', 'H', '1', '2017-09-23 07:55:10', 80),
  ('201631107', 'C31040203', 'H', '1', '2017-09-23 07:55:18', 78),
  ('201631164', 'C31040203', 'H', '1', '2017-09-23 07:55:34', 75),
  ('201631257', 'C31040203', 'H', '1', '2017-09-23 07:55:56', 81),
  ('201631248', 'C31040203', 'H', '1', '2017-09-23 07:56:05', 78),
  ('201631039', 'C31040203', 'H', '1', '2017-09-23 07:56:27', 85),
  ('201631143', 'C31040203', 'H', '1', '2017-09-23 07:57:08', 75),
  ('201631171', 'C31040203', 'H', '1', '2017-09-23 07:57:42', 60),
  ('201631015', 'C31040203', 'H', '1', '2017-09-23 07:57:51', 78),
  ('201631011', 'C31040203', 'H', '1', '2017-09-23 07:58:10', 80),
  ('201631261', 'C31040203', 'H', '1', '2017-09-23 07:58:19', 80),
  ('201631099', 'C31040203', 'H', '1', '2017-09-23 07:59:06', 75),
  ('201631145', 'C31040203', 'H', '1', '2017-09-23 08:00:44', 75),
  ('201631186', 'C31040203', 'H', '1', '2017-09-23 08:00:52', 78),
  ('201631183', 'C31040203', 'H', '1', '2017-09-23 08:01:04', 80),
  ('201631115', 'C31040203', 'H', '1', '2017-09-23 08:01:11', 75),
  ('201631061', 'C31040203', 'H', '1', '2017-09-23 08:01:18', 85),
  ('201531163', 'C31040315', 'D', '1', '2017-09-23 08:17:22', 83),
  ('201531155', 'C31040315', 'D', '1', '2017-09-23 08:17:29', 85),
  ('201531262', 'C31040315', 'D', '1', '2017-09-23 08:17:37', 75),
  ('201531201', 'C31040315', 'D', '1', '2017-09-23 08:17:45', 78),
  ('201531162', 'C31040315', 'D', '1', '2017-09-23 10:21:05', 80),
  ('201531017', 'C31040315', 'D', '1', '2017-09-23 10:21:14', 80),
  ('201531160', 'C31040315', 'D', '1', '2017-09-23 10:21:25', 80),
  ('201531046', 'C31040315', 'D', '1', '2017-09-23 10:21:31', 80),
  ('201531098', 'C31040315', 'D', '1', '2017-09-23 10:21:37', 75),
  ('201531066', 'C31040315', 'D', '1', '2017-09-23 10:21:44', 75),
  ('201531168', 'C31040315', 'D', '1', '2017-09-23 10:21:51', 80),
  ('201531042', 'C31040315', 'D', '1', '2017-09-23 10:22:00', 80),
  ('201531258', 'C31040315', 'D', '1', '2017-09-23 10:22:06', 80),
  ('201431067', 'C31040315', 'D', '1', '2017-09-23 10:22:21', 80),
  ('201531121', 'C31040315', 'D', '1', '2017-09-23 10:22:53', 80),
  ('201531150', 'C31040315', 'D', '1', '2017-09-23 10:23:02', 89),
  ('201431312', 'C31040315', 'D', '1', '2017-09-23 10:23:13', 65),
  ('201531025', 'C31040315', 'D', '1', '2017-09-23 10:23:19', 80),
  ('201531147', 'C31040315', 'D', '1', '2017-09-23 10:23:47', 82),
  ('201531115', 'C31040315', 'D', '1', '2017-09-23 10:23:52', 75),
  ('201531199', 'C31040315', 'D', '1', '2017-09-23 10:23:58', 87),
  ('201531133', 'C31040315', 'D', '1', '2017-09-23 10:24:07', 65),
  ('201531230', 'C31040315', 'D', '1', '2017-09-23 10:24:24', 65),
  ('201531139', 'C31040315', 'D', '1', '2017-09-23 10:24:31', 80),
  ('201531034', 'C31040315', 'D', '1', '2017-09-23 10:24:36', 80),
  ('201531064', 'C31040315', 'D', '1', '2017-09-23 10:24:47', 80),
  ('201531119', 'C31040315', 'D', '1', '2017-09-23 10:24:54', 70),
  ('201531094', 'C31040315', 'D', '1', '2017-09-23 10:25:02', 80),
  ('201531250', 'C31040315', 'D', '1', '2017-09-23 10:25:10', 80),
  ('201531106', 'C31040315', 'D', '1', '2017-09-23 10:25:15', 75),
  ('201531080', 'C31040315', 'D', '1', '2017-09-23 10:25:23', 80),
  ('201531007', 'C31040315', 'D', '1', '2017-09-23 10:25:29', 85),
  ('201531153', 'C31040315', 'D', '1', '2017-09-23 10:25:37', 80),
  ('201531085', 'C31040315', 'D', '1', '2017-09-23 10:25:44', 80),
  ('201531043', 'C31040315', 'D', '1', '2017-09-23 10:25:50', 80),
  ('201531161', 'C31040315', 'D', '1', '2017-09-23 10:25:54', 89),
  ('201531032', 'C31040315', 'D', '1', '2017-09-23 10:26:08', 60),
  ('201631009', 'C31040203', 'H', '1', '2017-09-23 12:27:24', 55),
  ('201631064', 'C31040203', 'H', '1', '2017-09-23 12:28:04', 98),
  ('201631071', 'C31040203', 'H', '1', '2017-09-23 12:28:24', 55),
  ('201631170', 'C31040203', 'H', '1', '2017-09-23 12:28:43', 85),
  ('201631057', 'C31040203', 'H', '1', '2017-09-23 12:29:08', 85),
  ('201631260', 'C31040203', 'H', '1', '2017-09-23 12:29:20', 70),
  ('201631177', 'C31040203', 'H', '1', '2017-09-23 12:30:04', 90),
  ('201631252', 'C31040203', 'H', '1', '2017-09-23 12:30:13', 75),
  ('201631184', 'C31040203', 'H', '1', '2017-09-23 12:30:35', 70),
  ('201631174', 'C31040203', 'H', '1', '2017-09-23 12:30:44', 70),
  ('201631178', 'C31040203', 'H', '1', '2017-09-23 12:30:51', 60),
  ('201631180', 'C31040203', 'H', '1', '2017-09-23 12:31:00', 75),
  ('201631168', 'C31040203', 'H', '1', '2017-09-23 12:31:07', 65),
  ('201631156', 'C31040203', 'H', '1', '2017-09-23 12:31:16', 92),
  ('201631140', 'C31040203', 'H', '1', '2017-09-23 12:39:44', 60),
  ('201631071', 'C31040203', 'H', '2', '2017-09-23 12:54:54', 75),
  ('201631064', 'C31040203', 'H', '2', '2017-09-23 12:55:13', 88),
  ('201631009', 'C31040203', 'H', '2', '2017-09-23 12:55:38', 84),
  ('201631140', 'C31040203', 'H', '2', '2017-09-23 12:55:49', 80),
  ('201631143', 'C31040203', 'H', '2', '2017-09-23 12:55:57', 82),
  ('201631260', 'C31040203', 'H', '2', '2017-09-23 12:56:30', 88),
  ('201631138', 'C31040203', 'H', '2', '2017-09-23 12:56:38', 85),
  ('201631107', 'C31040203', 'H', '2', '2017-09-23 12:56:51', 88),
  ('201631061', 'C31040203', 'H', '2', '2017-09-23 12:56:59', 87),
  ('201631099', 'C31040203', 'H', '2', '2017-09-23 12:57:08', 86),
  ('201631170', 'C31040203', 'H', '2', '2017-09-23 12:57:19', 88),
  ('201631039', 'C31040203', 'H', '2', '2017-09-23 12:57:31', 85),
  ('201631257', 'C31040203', 'H', '2', '2017-09-23 12:57:37', 75),
  ('201631183', 'C31040203', 'H', '2', '2017-09-23 12:57:43', 75),
  ('201631171', 'C31040203', 'H', '2', '2017-09-23 12:57:54', 88),
  ('201631184', 'C31040203', 'H', '2', '2017-09-23 12:58:12', 87),
  ('201631177', 'C31040203', 'H', '2', '2017-09-23 12:58:37', 90),
  ('201631264', 'C31040203', 'H', '2', '2017-09-23 12:58:59', 86),
  ('201631252', 'C31040203', 'H', '2', '2017-09-23 12:59:12', 85),
  ('201631254', 'C31040203', 'H', '2', '2017-09-23 12:59:22', 65),
  ('201631156', 'C31040203', 'H', '2', '2017-09-23 12:59:33', 86),
  ('201631168', 'C31040203', 'H', '2', '2017-09-23 13:00:06', 90),
  ('201631180', 'C31040203', 'H', '2', '2017-09-23 13:00:17', 88),
  ('201631155', 'C31040203', 'H', '2', '2017-09-23 13:00:30', 88),
  ('201631164', 'C31040203', 'H', '2', '2017-09-23 13:00:40', 83),
  ('201631178', 'C31040203', 'H', '2', '2017-09-23 13:00:49', 78),
  ('201631011', 'C31040203', 'H', '2', '2017-09-23 13:00:55', 85),
  ('201631153', 'C31040203', 'H', '2', '2017-09-23 13:01:01', 85),
  ('201631157', 'C31040203', 'H', '2', '2017-09-23 13:01:07', 90),
  ('201631174', 'C31040203', 'H', '2', '2017-09-23 13:01:18', 92),
  ('201631057', 'C31040203', 'H', '2', '2017-09-23 13:01:28', 88),
  ('201631300', 'C31040203', 'G', '1', '2017-09-23 13:25:10', 85),
  ('201631192', 'C31040203', 'G', '2', '2017-09-23 13:26:17', 75),
  ('201631221', 'C31040203', 'G', '2', '2017-09-23 13:26:46', 83),
  ('201631227', 'C31040203', 'G', '2', '2017-09-23 13:26:58', 65),
  ('201631203', 'C31040203', 'G', '2', '2017-09-23 13:27:08', 86),
  ('201631087', 'C31040203', 'G', '2', '2017-09-23 13:27:25', 89),
  ('201631055', 'C31040203', 'G', '2', '2017-09-23 13:28:07', 70),
  ('201631007', 'C31040203', 'G', '2', '2017-09-23 13:28:24', 89),
  ('201631270', 'C31040203', 'G', '2', '2017-09-23 13:28:33', 89),
  ('201631141', 'C31040203', 'G', '2', '2017-09-23 13:28:41', 82),
  ('201631113', 'C31040203', 'G', '2', '2017-09-23 13:29:24', 85),
  ('201631125', 'C31040203', 'G', '2', '2017-09-23 13:30:29', 88),
  ('201631300', 'C31040203', 'G', '2', '2017-09-23 13:32:40', 85),
  ('201631016', 'C31040203', 'G', '2', '2017-09-23 13:33:04', 85),
  ('201631152', 'C31040203', 'G', '2', '2017-09-23 13:33:32', 90),
  ('201631247', 'C31040203', 'G', '2', '2017-09-23 13:34:51', 50),
  ('201631026', 'C31040203', 'G', '2', '2017-09-23 13:35:19', 60),
  ('201631032', 'C31040203', 'G', '2', '2017-09-23 13:35:35', 56),
  ('201631063', 'C31040203', 'G', '2', '2017-09-23 13:36:06', 53),
  ('201631194', 'C31040203', 'G', '2', '2017-09-23 13:36:32', 75),
  ('201631187', 'C31040203', 'G', '2', '2017-09-23 13:37:02', 93),
  ('201631050', 'C31040203', 'G', '2', '2017-09-23 13:38:20', 75),
  ('201631301', 'C31040203', 'G', '2', '2017-09-23 13:39:19', 98),
  ('201631118', 'C31040203', 'G', '2', '2017-09-23 13:39:30', 90),
  ('201631175', 'C31040203', 'G', '2', '2017-09-23 13:40:28', 95),
  ('201631079', 'C31040203', 'G', '2', '2017-09-23 13:42:06', 95),
  ('201631041', 'C31040203', 'G', '2', '2017-09-23 13:42:19', 98),
  ('201631192', 'C31040203', 'G', '2', '2017-09-23 13:53:17', 75),
  ('201631227', 'C31040203', 'G', '2', '2017-09-23 13:53:42', 65),
  ('201631055', 'C31040203', 'G', '2', '2017-09-23 13:53:52', 70),
  ('201531140', 'C31040315', 'D', '1', '2017-09-23 17:24:02', 78),
  ('201531003', 'C31040315', 'D', '1', '2017-09-23 17:24:53', 80),
  ('201531129', 'C31040203', 'H', '2', '2017-09-25 16:47:24', 58),
  ('201431149', 'C31040413', 'F', '1', '2017-09-28 14:39:08', 78),
  ('201431318', 'C31040413', 'F', '1', '2017-09-28 14:39:23', 82),
  ('201431066', 'C31040413', 'F', '1', '2017-09-28 14:39:35', 82),
  ('201431104', 'C31040413', 'F', '1', '2017-09-28 14:39:47', 85),
  ('201431282', 'C31040413', 'F', '1', '2017-09-28 14:40:01', 87),
  ('201431220', 'C31040413', 'F', '1', '2017-09-28 14:40:16', 85),
  ('201431112', 'C31040413', 'F', '1', '2017-09-28 14:40:33', 88),
  ('201431227', 'C31040413', 'F', '1', '2017-09-28 14:41:02', 88),
  ('201431132', 'C31040413', 'F', '1', '2017-09-28 14:42:26', 78),
  ('201431325', 'C31040413', 'F', '1', '2017-09-28 14:42:40', 73),
  ('201431139', 'C31040413', 'F', '1', '2017-09-28 14:44:16', 86),
  ('201431036', 'C31040413', 'F', '1', '2017-09-28 14:45:20', 78),
  ('201431083', 'C31040413', 'F', '1', '2017-09-28 14:45:34', 70),
  ('201431313', 'C31040413', 'F', '1', '2017-09-28 14:45:48', 82),
  ('201431237', 'C31040413', 'F', '1', '2017-09-28 14:46:02', 80),
  ('201431146', 'C31040413', 'F', '1', '2017-09-28 14:46:14', 80),
  ('201431240', 'C31040413', 'F', '1', '2017-09-28 14:46:29', 80),
  ('201431182', 'C31040413', 'F', '1', '2017-09-28 14:46:49', 82),
  ('201431016', 'C31040413', 'F', '1', '2017-09-28 14:47:04', 82),
  ('201431309', 'C31040413', 'F', '1', '2017-09-28 14:47:17', 81),
  ('201431095', 'C31040413', 'F', '1', '2017-09-28 14:47:30', 84),
  ('201431055', 'C31040413', 'F', '1', '2017-09-28 14:47:40', 80),
  ('201731054', 'C31040101', 'B', '1', '2017-09-28 16:10:30', 30),
  ('201731047', 'C31040101', 'B', '1', '2017-09-28 16:10:41', 70),
  ('201731075', 'C31040101', 'B', '1', '2017-09-28 16:11:17', 80),
  ('201731068', 'C31040101', 'B', '1', '2017-09-28 16:11:32', 70),
  ('201731050', 'C31040101', 'B', '1', '2017-09-28 16:11:49', 65),
  ('201731074', 'C31040101', 'B', '1', '2017-09-28 16:15:11', 65),
  ('201731041', 'C31040101', 'B', '1', '2017-09-28 16:15:23', 75),
  ('201731051', 'C31040101', 'B', '1', '2017-09-28 16:15:33', 90),
  ('201731063', 'C31040101', 'B', '1', '2017-09-28 16:15:42', 70),
  ('201731064', 'C31040101', 'B', '1', '2017-09-28 16:15:53', 40),
  ('201731065', 'C31040101', 'B', '1', '2017-09-28 16:16:02', 70),
  ('201731057', 'C31040101', 'B', '1', '2017-09-28 16:16:12', 70),
  ('201731066', 'C31040101', 'B', '1', '2017-09-28 16:16:22', 65),
  ('201731059', 'C31040101', 'B', '1', '2017-09-28 16:19:50', 40),
  ('201731077', 'C31040101', 'B', '1', '2017-09-28 16:20:01', 40),
  ('201731029', 'C31040101', 'B', '1', '2017-09-28 16:20:19', 70),
  ('201731061', 'C31040101', 'B', '1', '2017-09-28 16:20:28', 60),
  ('201731060', 'C31040101', 'B', '1', '2017-09-28 16:20:35', 70),
  ('201731072', 'C31040101', 'B', '1', '2017-09-28 16:20:47', 65),
  ('201731046', 'C31040101', 'B', '1', '2017-09-28 16:20:57', 40),
  ('201731067', 'C31040101', 'B', '1', '2017-09-28 16:21:09', 40),
  ('201731043', 'C31040101', 'B', '1', '2017-09-28 16:21:20', 70),
  ('201731073', 'C31040101', 'B', '1', '2017-09-28 16:21:34', 80),
  ('201731056', 'C31040101', 'B', '1', '2017-09-28 16:21:44', 80),
  ('201731070', 'C31040101', 'B', '1', '2017-09-28 16:21:52', 80),
  ('201731048', 'C31040101', 'B', '1', '2017-09-28 16:22:04', 70),
  ('201731049', 'C31040101', 'B', '1', '2017-09-28 16:22:15', 85),
  ('201731055', 'C31040101', 'B', '1', '2017-09-28 16:22:26', 40),
  ('201731053', 'C31040101', 'B', '1', '2017-09-28 16:24:28', 70),
  ('201731080', 'C31040101', 'B', '1', '2017-09-28 16:24:35', 75),
  ('201731044', 'C31040101', 'B', '1', '2017-09-28 16:24:41', 75),
  ('201631300', 'C31040203', 'G', '3', '2017-09-30 10:37:30', 90),
  ('201631006', 'C31040203', 'G', '3', '2017-09-30 10:37:36', 70),
  ('201631079', 'C31040203', 'G', '3', '2017-09-30 10:37:42', 95),
  ('201631152', 'C31040203', 'G', '3', '2017-09-30 10:37:49', 56),
  ('201631035', 'C31040203', 'G', '3', '2017-09-30 10:38:02', 85),
  ('201631032', 'C31040203', 'G', '3', '2017-09-30 10:38:07', 41),
  ('201631081', 'C31040203', 'G', '3', '2017-09-30 10:38:14', 65),
  ('201631002', 'C31040203', 'G', '3', '2017-09-30 10:38:22', 63),
  ('201631055', 'C31040203', 'G', '3', '2017-09-30 10:41:35', 90),
  ('201631192', 'C31040203', 'G', '3', '2017-09-30 10:41:43', 65),
  ('201631203', 'C31040203', 'G', '3', '2017-09-30 10:42:53', 83),
  ('201631286', 'C31040203', 'G', '3', '2017-09-30 10:43:11', 80),
  ('201631020', 'C31040203', 'G', '3', '2017-09-30 10:43:18', 67),
  ('201631041', 'C31040203', 'G', '3', '2017-09-30 10:43:30', 85),
  ('201631270', 'C31040203', 'G', '3', '2017-09-30 10:44:30', 85),
  ('201631087', 'C31040203', 'G', '3', '2017-09-30 10:44:37', 80),
  ('201631182', 'C31040203', 'G', '3', '2017-09-30 10:44:44', 95),
  ('201631125', 'C31040203', 'G', '3', '2017-09-30 10:44:52', 98),
  ('201331097', 'C31040203', 'G', '3', '2017-09-30 10:47:13', 74),
  ('201631227', 'C31040203', 'G', '3', '2017-09-30 10:47:21', 73),
  ('201631092', 'C31040203', 'G', '3', '2017-09-30 10:49:33', 90),
  ('201631301', 'C31040203', 'G', '3', '2017-09-30 10:49:42', 72),
  ('201631007', 'C31040203', 'G', '3', '2017-09-30 10:49:47', 95),
  ('201631194', 'C31040203', 'G', '3', '2017-09-30 10:50:18', 70),
  ('201631175', 'C31040203', 'G', '3', '2017-09-30 10:50:24', 77),
  ('201631162', 'C31040203', 'G', '3', '2017-09-30 10:52:46', 82),
  ('201631050', 'C31040203', 'G', '3', '2017-09-30 10:52:52', 65),
  ('201631302', 'C31040203', 'G', '3', '2017-09-30 10:52:58', 84),
  ('201631113', 'C31040203', 'G', '3', '2017-09-30 10:53:08', 92),
  ('201631221', 'C31040203', 'G', '3', '2017-09-30 10:53:13', 78),
  ('201631187', 'C31040203', 'G', '3', '2017-09-30 10:54:39', 95),
  ('201631286', 'C31040203', 'G', '2', '2017-09-30 11:03:02', 65),
  ('201631302', 'C31040203', 'G', '2', '2017-09-30 11:04:22', 85),
  ('201631006', 'C31040203', 'G', '2', '2017-10-02 08:07:33', 80),
  ('201631198', 'C31040203', 'F', '3', '2017-10-02 09:05:15', 90),
  ('201631217', 'C31040203', 'F', '3', '2017-10-02 09:05:25', 83),
  ('201631034', 'C31040203', 'F', '3', '2017-10-02 09:05:54', 83),
  ('201631004', 'C31040203', 'F', '3', '2017-10-02 09:06:24', 80),
  ('201631128', 'C31040203', 'F', '3', '2017-10-02 09:15:11', 75),
  ('201631121', 'C31040203', 'F', '3', '2017-10-02 09:15:37', 83),
  ('201631220', 'C31040203', 'F', '3', '2017-10-02 09:17:38', 80),
  ('201631241', 'C31040203', 'F', '3', '2017-10-02 09:17:47', 90),
  ('201631290', 'C31040203', 'F', '3', '2017-10-02 09:17:57', 85),
  ('201631021', 'C31040203', 'F', '3', '2017-10-02 09:18:05', 85),
  ('201631043', 'C31040203', 'F', '3', '2017-10-02 09:18:17', 85),
  ('201631049', 'C31040203', 'F', '3', '2017-10-02 09:18:28', 85),
  ('201631001', 'C31040203', 'F', '3', '2017-10-02 09:18:39', 83),
  ('201631191', 'C31040203', 'F', '3', '2017-10-02 09:18:45', 85),
  ('201631269', 'C31040203', 'F', '3', '2017-10-02 09:36:47', 88),
  ('201631083', 'C31040203', 'F', '3', '2017-10-02 09:36:53', 88),
  ('201631008', 'C31040203', 'F', '3', '2017-10-02 09:37:02', 85),
  ('201631266', 'C31040203', 'F', '3', '2017-10-02 09:37:08', 87),
  ('201631276', 'C31040203', 'F', '3', '2017-10-02 09:37:17', 88),
  ('201631265', 'C31040203', 'F', '3', '2017-10-02 09:37:27', 90),
  ('201631222', 'C31040203', 'F', '3', '2017-10-02 09:37:39', 90),
  ('201631169', 'C31040203', 'F', '3', '2017-10-02 09:37:47', 88),
  ('201631188', 'C31040203', 'F', '3', '2017-10-02 09:47:35', 90),
  ('201631124', 'C31040203', 'F', '3', '2017-10-02 09:47:46', 87),
  ('201631067', 'C31040203', 'F', '3', '2017-10-02 16:42:24', 83),
  ('201731064', 'C31040107', 'B', '2', '2017-10-03 09:14:48', 80),
  ('201731051', 'C31040107', 'B', '2', '2017-10-03 09:14:54', 77),
  ('201731044', 'C31040107', 'B', '2', '2017-10-03 09:14:59', 77),
  ('201731055', 'C31040107', 'B', '2', '2017-10-03 09:15:05', 77),
  ('201731061', 'C31040107', 'B', '2', '2017-10-03 09:15:13', 72),
  ('201731042', 'C31040107', 'B', '2', '2017-10-03 09:15:31', 60),
  ('201731062', 'C31040107', 'B', '2', '2017-10-03 09:15:37', 65),
  ('201731070', 'C31040107', 'B', '2', '2017-10-03 09:15:45', 75),
  ('201731079', 'C31040107', 'B', '2', '2017-10-03 09:15:57', 70),
  ('201731071', 'C31040107', 'B', '2', '2017-10-03 09:16:03', 55),
  ('201731067', 'C31040107', 'B', '2', '2017-10-03 09:16:41', 65),
  ('201731045', 'C31040107', 'B', '2', '2017-10-03 09:16:59', 55),
  ('201731072', 'C31040107', 'B', '2', '2017-10-03 09:17:20', 82),
  ('201731047', 'C31040107', 'B', '2', '2017-10-03 09:17:35', 60),
  ('201731029', 'C31040107', 'B', '2', '2017-10-03 09:17:50', 60),
  ('201731059', 'C31040107', 'B', '2', '2017-10-03 09:17:59', 45),
  ('201731065', 'C31040107', 'B', '2', '2017-10-03 09:18:06', 5),
  ('201731068', 'C31040107', 'B', '2', '2017-10-03 09:18:15', 48),
  ('201731074', 'C31040107', 'B', '2', '2017-10-03 09:18:23', 60),
  ('201731050', 'C31040107', 'B', '2', '2017-10-03 09:18:36', 35),
  ('201731073', 'C31040107', 'B', '2', '2017-10-03 09:19:21', 85),
  ('201731049', 'C31040107', 'B', '2', '2017-10-03 09:19:30', 40),
  ('201731058', 'C31040107', 'B', '2', '2017-10-03 09:19:38', 80),
  ('201731075', 'C31040107', 'B', '2', '2017-10-03 09:19:46', 76),
  ('201731053', 'C31040107', 'B', '2', '2017-10-03 09:19:52', 45),
  ('201731043', 'C31040107', 'B', '2', '2017-10-03 09:19:57', 82),
  ('201731063', 'C31040107', 'B', '2', '2017-10-03 09:20:02', 80),
  ('201731080', 'C31040107', 'B', '2', '2017-10-03 09:20:54', 65),
  ('201731077', 'C31040107', 'B', '2', '2017-10-03 09:21:05', 65),
  ('201731054', 'C31040107', 'B', '2', '2017-10-03 09:21:13', 55),
  ('201731057', 'C31040107', 'B', '2', '2017-10-03 09:21:21', 70),
  ('201731066', 'C31040107', 'B', '2', '2017-10-03 09:21:30', 65),
  ('201731078', 'C31040107', 'B', '2', '2017-10-03 09:21:38', 68),
  ('201731056', 'C31040107', 'B', '2', '2017-10-03 09:21:46', 65),
  ('201731076', 'C31040107', 'B', '2', '2017-10-03 09:23:14', 65),
  ('201731041', 'C31040107', 'B', '2', '2017-10-03 09:23:20', 75),
  ('201731060', 'C31040107', 'B', '2', '2017-10-03 09:23:26', 78),
  ('201731046', 'C31040107', 'B', '2', '2017-10-03 09:23:33', 62),
  ('201731052', 'C31040107', 'B', '2', '2017-10-03 09:23:39', 55),
  ('201631300', 'C31040203', 'G', '4', '2017-10-10 16:09:12', 95),
  ('201631055', 'C31040203', 'G', '4', '2017-10-10 16:09:36', 85),
  ('201631092', 'C31040203', 'G', '4', '2017-10-10 16:09:46', 90),
  ('201631118', 'C31040203', 'G', '4', '2017-10-10 16:10:05', 67),
  ('201631002', 'C31040203', 'G', '4', '2017-10-10 16:11:25', 70),
  ('201631221', 'C31040203', 'G', '4', '2017-10-10 16:11:35', 85),
  ('201631050', 'C31040203', 'G', '4', '2017-10-10 16:11:45', 70),
  ('201631079', 'C31040203', 'G', '4', '2017-10-10 16:11:56', 60),
  ('201631087', 'C31040203', 'G', '4', '2017-10-10 16:12:52', 90),
  ('201631162', 'C31040203', 'G', '4', '2017-10-10 16:13:03', 95),
  ('201631026', 'C31040203', 'G', '4', '2017-10-10 16:13:13', 60),
  ('201631152', 'C31040203', 'G', '4', '2017-10-10 16:13:25', 67),
  ('201631194', 'C31040203', 'G', '4', '2017-10-10 16:13:35', 70),
  ('201631007', 'C31040203', 'G', '4', '2017-10-10 16:13:44', 95),
  ('201631270', 'C31040203', 'G', '4', '2017-10-10 16:16:00', 70),
  ('201631125', 'C31040203', 'G', '4', '2017-10-10 16:16:09', 90),
  ('201631113', 'C31040203', 'G', '4', '2017-10-10 16:16:18', 70),
  ('201631175', 'C31040203', 'G', '4', '2017-10-10 16:17:06', 70),
  ('201631041', 'C31040203', 'G', '4', '2017-10-10 16:17:17', 95),
  ('201631182', 'C31040203', 'G', '4', '2017-10-10 16:17:28', 95),
  ('201631301', 'C31040203', 'G', '4', '2017-10-10 16:17:38', 60),
  ('201631102', 'C31040203', 'G', '4', '2017-10-10 16:17:48', 78),
  ('201631141', 'C31040203', 'G', '4', '2017-10-10 16:17:57', 63),
  ('201631227', 'C31040203', 'G', '4', '2017-10-10 16:22:04', 60),
  ('201631286', 'C31040203', 'G', '4', '2017-10-10 16:22:21', 83),
  ('201631302', 'C31040203', 'G', '4', '2017-10-10 16:22:35', 95),
  ('201631016', 'C31040203', 'G', '4', '2017-10-10 16:22:47', 76),
  ('201631081', 'C31040203', 'G', '4', '2017-10-10 16:22:58', 82),
  ('201631107', 'C31040203', 'H', '4', '2017-10-10 16:23:32', 92),
  ('201631260', 'C31040203', 'H', '4', '2017-10-10 16:23:41', 75),
  ('201631138', 'C31040203', 'H', '4', '2017-10-10 16:23:51', 88),
  ('201631171', 'C31040203', 'H', '4', '2017-10-10 16:24:30', 98),
  ('201631064', 'C31040203', 'H', '4', '2017-10-10 16:25:09', 98),
  ('201631061', 'C31040203', 'H', '4', '2017-10-10 16:26:46', 75),
  ('201631057', 'C31040203', 'H', '4', '2017-10-10 16:27:04', 92),
  ('201631170', 'C31040203', 'H', '4', '2017-10-10 16:27:27', 96),
  ('201631153', 'C31040203', 'H', '4', '2017-10-10 16:27:37', 88),
  ('201631186', 'C31040203', 'H', '4', '2017-10-10 16:27:48', 75),
  ('201631252', 'C31040203', 'H', '4', '2017-10-10 16:27:56', 79),
  ('201631192', 'C31040203', 'H', '4', '2017-10-10 16:28:13', 86),
  ('201631261', 'C31040203', 'H', '4', '2017-10-10 16:28:22', 98),
  ('201631277', 'C31040203', 'H', '4', '2017-10-10 16:28:31', 60),
  ('201631140', 'C31040203', 'H', '4', '2017-10-10 16:28:47', 65),
  ('201631164', 'C31040203', 'H', '4', '2017-10-10 16:28:56', 96),
  ('201631143', 'C31040203', 'H', '4', '2017-10-10 16:29:04', 65),
  ('201731071', 'C31040101', 'B', '2', '2017-10-12 14:19:47', 50),
  ('201731072', 'C31040101', 'B', '2', '2017-10-12 14:19:55', 50),
  ('201731047', 'C31040101', 'B', '2', '2017-10-12 14:21:57', 50),
  ('201731059', 'C31040101', 'B', '2', '2017-10-12 14:22:06', 50),
  ('201731075', 'C31040101', 'B', '2', '2017-10-12 14:22:17', 50),
  ('201731066', 'C31040101', 'B', '2', '2017-10-12 14:22:28', 50),
  ('201731074', 'C31040101', 'B', '2', '2017-10-12 14:22:37', 50),
  ('201731041', 'C31040101', 'B', '2', '2017-10-12 14:22:43', 50),
  ('201731051', 'C31040101', 'B', '2', '2017-10-12 14:22:54', 100),
  ('201731060', 'C31040101', 'B', '2', '2017-10-12 14:22:59', 50),
  ('201731061', 'C31040101', 'B', '2', '2017-10-12 14:23:15', 50),
  ('201731050', 'C31040101', 'B', '2', '2017-10-12 14:23:20', 50),
  ('201731069', 'C31040101', 'B', '2', '2017-10-12 14:23:28', 100),
  ('201731052', 'C31040101', 'B', '2', '2017-10-12 14:23:39', 100),
  ('201731065', 'C31040101', 'B', '2', '2017-10-12 14:24:11', 25),
  ('201731063', 'C31040101', 'B', '2', '2017-10-12 14:24:28', 50),
  ('201731064', 'C31040101', 'B', '2', '2017-10-12 14:25:02', 50),
  ('201731044', 'C31040101', 'B', '2', '2017-10-12 14:25:16', 50),
  ('201731054', 'C31040101', 'B', '2', '2017-10-12 14:25:30', 50),
  ('201731057', 'C31040101', 'B', '2', '2017-10-12 14:25:47', 25),
  ('201731055', 'C31040101', 'B', '2', '2017-10-12 14:25:54', 50),
  ('201731042', 'C31040101', 'B', '2', '2017-10-12 14:26:03', 50),
  ('201731049', 'C31040101', 'B', '2', '2017-10-12 14:26:24', 50),
  ('201731029', 'C31040101', 'B', '2', '2017-10-12 14:26:36', 100),
  ('201731080', 'C31040101', 'B', '2', '2017-10-12 14:26:47', 50),
  ('201731048', 'C31040101', 'B', '2', '2017-10-12 14:27:04', 90),
  ('201731062', 'C31040101', 'B', '2', '2017-10-12 14:27:14', 90),
  ('201731073', 'C31040101', 'B', '2', '2017-10-12 14:27:33', 50),
  ('201731058', 'C31040101', 'B', '2', '2017-10-12 14:28:04', 50),
  ('201731078', 'C31040101', 'B', '2', '2017-10-12 14:28:11', 50),
  ('201731043', 'C31040101', 'B', '2', '2017-10-12 14:28:24', 50),
  ('201731046', 'C31040101', 'B', '2', '2017-10-12 14:28:32', 50),
  ('201731056', 'C31040101', 'B', '2', '2017-10-12 14:28:37', 50),
  ('201731076', 'C31040101', 'B', '2', '2017-10-12 14:28:44', 50),
  ('201731068', 'C31040101', 'B', '2', '2017-10-12 14:28:49', 50),
  ('201731067', 'C31040101', 'B', '2', '2017-10-12 14:29:14', 50),
  ('201731070', 'C31040101', 'B', '2', '2017-10-12 14:29:36', 25),
  ('201731077', 'C31040101', 'B', '2', '2017-10-12 14:29:44', 50),
  ('201731045', 'C31040101', 'B', '2', '2017-10-12 14:29:49', 25),
  ('201731029', 'C31040101', 'B', '3', '2017-10-12 15:38:30', 80),
  ('201731080', 'C31040101', 'B', '3', '2017-10-12 15:38:36', 55),
  ('201731079', 'C31040101', 'B', '3', '2017-10-12 15:38:46', 55),
  ('201731061', 'C31040101', 'B', '3', '2017-10-12 15:38:53', 40),
  ('201731041', 'C31040101', 'B', '3', '2017-10-12 15:39:01', 75),
  ('201731054', 'C31040101', 'B', '3', '2017-10-12 15:39:08', 40),
  ('201731047', 'C31040101', 'B', '3', '2017-10-12 15:39:13', 40),
  ('201731044', 'C31040101', 'B', '3', '2017-10-12 15:39:46', 50),
  ('201731075', 'C31040101', 'B', '3', '2017-10-12 15:39:51', 75),
  ('201731074', 'C31040101', 'B', '3', '2017-10-12 15:39:58', 25),
  ('201731063', 'C31040101', 'B', '3', '2017-10-12 15:40:05', 60),
  ('201731069', 'C31040101', 'B', '3', '2017-10-12 15:41:09', 30),
  ('201731052', 'C31040101', 'B', '3', '2017-10-12 15:41:18', 25),
  ('201731073', 'C31040101', 'B', '3', '2017-10-12 15:41:24', 90),
  ('201731051', 'C31040101', 'B', '3', '2017-10-12 15:41:32', 85),
  ('201731042', 'C31040101', 'B', '3', '2017-10-12 15:41:39', 65),
  ('201731057', 'C31040101', 'B', '3', '2017-10-12 15:41:51', 20),
  ('201731070', 'C31040101', 'B', '3', '2017-10-12 15:41:58', 20),
  ('201731045', 'C31040101', 'B', '3', '2017-10-12 15:42:52', 20),
  ('201731050', 'C31040101', 'B', '3', '2017-10-12 15:43:00', 20),
  ('201731059', 'C31040101', 'B', '3', '2017-10-12 15:43:11', 58),
  ('201731062', 'C31040101', 'B', '3', '2017-10-12 15:43:18', 50),
  ('201731071', 'C31040101', 'B', '3', '2017-10-12 15:43:27', 25),
  ('201731060', 'C31040101', 'B', '3', '2017-10-12 15:43:33', 60),
  ('201731046', 'C31040101', 'B', '3', '2017-10-12 15:43:39', 65),
  ('201731067', 'C31040101', 'B', '3', '2017-10-12 15:43:46', 83),
  ('201731072', 'C31040101', 'B', '3', '2017-10-12 15:43:55', 25),
  ('201731056', 'C31040101', 'B', '3', '2017-10-12 15:44:01', 45),
  ('201731076', 'C31040101', 'B', '3', '2017-10-12 15:44:09', 70),
  ('201731058', 'C31040101', 'B', '3', '2017-10-12 15:44:16', 70),
  ('201731048', 'C31040101', 'B', '3', '2017-10-12 15:44:24', 20),
  ('201731049', 'C31040101', 'B', '3', '2017-10-12 15:44:32', 15),
  ('201731068', 'C31040101', 'B', '3', '2017-10-12 15:44:43', 60),
  ('201731055', 'C31040101', 'B', '3', '2017-10-12 15:44:51', 60),
  ('201731066', 'C31040101', 'B', '3', '2017-10-12 15:44:56', 30),
  ('201731061', 'C31040107', 'B', '3', '2017-10-12 15:58:34', 60),
  ('201731067', 'C31040107', 'B', '3', '2017-10-12 15:58:46', 60),
  ('201731072', 'C31040107', 'B', '3', '2017-10-12 15:58:54', 60),
  ('201731053', 'C31040107', 'B', '3', '2017-10-12 15:59:00', 60),
  ('201731058', 'C31040107', 'B', '3', '2017-10-12 15:59:06', 60),
  ('201731043', 'C31040107', 'B', '3', '2017-10-12 16:00:11', 75),
  ('201731073', 'C31040107', 'B', '3', '2017-10-12 16:00:24', 75),
  ('201731078', 'C31040107', 'B', '3', '2017-10-12 16:00:31', 75),
  ('201731042', 'C31040107', 'B', '3', '2017-10-12 16:01:18', 70),
  ('201731055', 'C31040107', 'B', '3', '2017-10-12 16:01:25', 70),
  ('201731080', 'C31040107', 'B', '3', '2017-10-12 16:01:30', 65),
  ('201731075', 'C31040107', 'B', '3', '2017-10-12 16:01:36', 60),
  ('201731076', 'C31040107', 'B', '3', '2017-10-12 16:02:49', 60),
  ('201731063', 'C31040107', 'B', '3', '2017-10-12 16:02:54', 60),
  ('201731054', 'C31040107', 'B', '3', '2017-10-12 16:03:07', 60),
  ('201731046', 'C31040107', 'B', '3', '2017-10-12 16:04:13', 60),
  ('201731069', 'C31040107', 'B', '3', '2017-10-12 16:05:19', 60),
  ('201731071', 'C31040107', 'B', '3', '2017-10-12 16:05:39', 65),
  ('201731062', 'C31040107', 'B', '3', '2017-10-12 16:05:44', 70),
  ('201731045', 'C31040107', 'B', '3', '2017-10-12 16:06:16', 65),
  ('201731070', 'C31040107', 'B', '3', '2017-10-12 16:06:21', 75),
  ('201731049', 'C31040107', 'B', '3', '2017-10-12 16:06:32', 62),
  ('201731047', 'C31040107', 'B', '3', '2017-10-12 16:06:42', 65),
  ('201731052', 'C31040107', 'B', '3', '2017-10-12 16:06:47', 65),
  ('201731050', 'C31040107', 'B', '3', '2017-10-12 16:06:53', 60),
  ('201731059', 'C31040107', 'B', '3', '2017-10-12 16:06:58', 50),
  ('201731068', 'C31040107', 'B', '3', '2017-10-12 16:08:17', 60),
  ('201731044', 'C31040107', 'B', '3', '2017-10-12 16:08:23', 70),
  ('201731079', 'C31040107', 'B', '3', '2017-10-12 16:08:30', 60),
  ('201731029', 'C31040107', 'B', '3', '2017-10-12 16:09:06', 70),
  ('201731057', 'C31040107', 'B', '3', '2017-10-12 16:09:16', 60),
  ('201731064', 'C31040107', 'B', '3', '2017-10-12 16:09:26', 70),
  ('201731065', 'C31040107', 'B', '3', '2017-10-12 16:09:33', 60),
  ('201731077', 'C31040107', 'B', '3', '2017-10-12 16:09:40', 60),
  ('201731056', 'C31040107', 'B', '3', '2017-10-12 16:09:45', 60),
  ('201731048', 'C31040107', 'B', '3', '2017-10-12 16:09:50', 60),
  ('201731051', 'C31040107', 'B', '3', '2017-10-12 16:09:58', 70),
  ('201731066', 'C31040107', 'B', '3', '2017-10-12 16:10:05', 70),
  ('201731061', 'C31040101', 'B', '4', '2017-10-12 16:51:05', 0),
  ('201731041', 'C31040101', 'B', '4', '2017-10-12 16:51:13', 40),
  ('201731072', 'C31040101', 'B', '4', '2017-10-12 16:51:23', 25),
  ('201731047', 'C31040101', 'B', '4', '2017-10-12 16:51:29', 45),
  ('201731046', 'C31040101', 'B', '4', '2017-10-12 16:51:36', 45),
  ('201731067', 'C31040101', 'B', '4', '2017-10-12 16:51:44', 25),
  ('201731059', 'C31040101', 'B', '4', '2017-10-12 16:51:52', 45),
  ('201731056', 'C31040101', 'B', '4', '2017-10-12 16:51:57', 80),
  ('201731076', 'C31040101', 'B', '4', '2017-10-12 16:52:04', 80),
  ('201731048', 'C31040101', 'B', '4', '2017-10-12 16:52:10', 80),
  ('201731053', 'C31040101', 'B', '4', '2017-10-12 16:52:20', 60),
  ('201731049', 'C31040101', 'B', '4', '2017-10-12 16:52:29', 50),
  ('201731029', 'C31040101', 'B', '4', '2017-10-12 16:52:37', 80),
  ('201731042', 'C31040101', 'B', '4', '2017-10-12 16:52:44', 70),
  ('201731058', 'C31040101', 'B', '4', '2017-10-12 16:52:50', 45),
  ('201731080', 'C31040101', 'B', '4', '2017-10-12 16:52:57', 65),
  ('201731068', 'C31040101', 'B', '4', '2017-10-12 16:53:02', 80),
  ('201731075', 'C31040101', 'B', '4', '2017-10-12 16:53:07', 75),
  ('201731050', 'C31040101', 'B', '4', '2017-10-12 16:53:19', 60),
  ('201731044', 'C31040101', 'B', '4', '2017-10-12 16:53:26', 15),
  ('201731069', 'C31040101', 'B', '4', '2017-10-12 16:53:32', 40),
  ('201731073', 'C31040101', 'B', '4', '2017-10-12 16:53:38', 80),
  ('201731043', 'C31040101', 'B', '4', '2017-10-12 16:53:43', 45),
  ('201731078', 'C31040101', 'B', '4', '2017-10-12 16:53:49', 25),
  ('201731060', 'C31040101', 'B', '4', '2017-10-12 16:53:53', 75),
  ('201531155', 'C31040315', 'D', '3', '2017-10-13 09:40:39', 90),
  ('201531042', 'C31040315', 'D', '3', '2017-10-13 09:41:06', 90),
  ('201431067', 'C31040315', 'D', '3', '2017-10-13 09:41:19', 70),
  ('201531043', 'C31040315', 'D', '3', '2017-10-13 09:41:30', 90),
  ('201531250', 'C31040315', 'D', '3', '2017-10-13 09:42:28', 89),
  ('201531115', 'C31040315', 'D', '3', '2017-10-13 09:44:04', 73),
  ('201531034', 'C31040315', 'D', '3', '2017-10-13 09:44:20', 90),
  ('201531153', 'C31040315', 'D', '3', '2017-10-13 09:44:24', 90),
  ('201531163', 'C31040315', 'D', '3', '2017-10-13 09:44:29', 90),
  ('201531150', 'C31040315', 'D', '3', '2017-10-13 09:44:32', 90),
  ('201531147', 'C31040315', 'D', '3', '2017-10-13 09:44:41', 90),
  ('201531161', 'C31040315', 'D', '3', '2017-10-13 09:44:58', 90),
  ('201531133', 'C31040315', 'D', '3', '2017-10-13 09:45:05', 65),
  ('201531007', 'C31040315', 'D', '3', '2017-10-13 09:45:10', 89),
  ('201531199', 'C31040315', 'D', '3', '2017-10-13 09:45:15', 90),
  ('201531003', 'C31040315', 'D', '3', '2017-10-13 09:45:22', 80),
  ('201531080', 'C31040315', 'D', '3', '2017-10-13 09:45:27', 87),
  ('201531230', 'C31040315', 'D', '3', '2017-10-13 09:45:33', 90),
  ('201531017', 'C31040315', 'D', '3', '2017-10-13 09:45:37', 78),
  ('201531140', 'C31040315', 'D', '3', '2017-10-13 09:45:45', 75),
  ('201531139', 'C31040315', 'D', '3', '2017-10-13 09:46:08', 85),
  ('201531066', 'C31040315', 'D', '3', '2017-10-13 09:46:11', 70),
  ('201531064', 'C31040315', 'D', '3', '2017-10-13 09:46:15', 80),
  ('201531258', 'C31040315', 'D', '3', '2017-10-13 09:46:19', 90),
  ('201531094', 'C31040315', 'D', '3', '2017-10-13 09:46:25', 83),
  ('201531106', 'C31040315', 'D', '3', '2017-10-13 09:46:34', 83),
  ('201531119', 'C31040315', 'D', '3', '2017-10-13 09:47:50', 85),
  ('201531162', 'C31040315', 'D', '3', '2017-10-13 09:47:57', 68),
  ('201531046', 'C31040315', 'D', '3', '2017-10-13 09:48:13', 88),
  ('201531121', 'C31040315', 'D', '3', '2017-10-13 09:48:18', 88),
  ('201531085', 'C31040315', 'D', '3', '2017-10-13 09:48:29', 90),
  ('201531160', 'C31040315', 'D', '3', '2017-10-13 09:48:34', 85),
  ('201531098', 'C31040315', 'D', '3', '2017-10-13 09:48:39', 75),
  ('201631052', 'C31040203', 'F', '2', '2017-10-13 10:04:46', 85),
  ('201631191', 'C31040203', 'F', '2', '2017-10-13 10:04:54', 83),
  ('201631290', 'C31040203', 'F', '2', '2017-10-13 10:05:01', 84),
  ('201631021', 'C31040203', 'F', '2', '2017-10-13 10:05:12', 86),
  ('201631001', 'C31040203', 'F', '2', '2017-10-13 10:05:22', 84),
  ('201631220', 'C31040203', 'F', '2', '2017-10-13 10:05:32', 82),
  ('201631266', 'C31040203', 'F', '2', '2017-10-13 10:05:46', 84),
  ('201631169', 'C31040203', 'F', '2', '2017-10-13 10:06:11', 82),
  ('201631121', 'C31040203', 'F', '2', '2017-10-13 10:06:17', 82),
  ('201631269', 'C31040203', 'F', '2', '2017-10-13 10:06:23', 85),
  ('201631067', 'C31040203', 'F', '2', '2017-10-13 10:06:33', 84),
  ('201631004', 'C31040203', 'F', '2', '2017-10-13 10:06:42', 84),
  ('201631043', 'C31040203', 'F', '2', '2017-10-13 10:06:48', 85),
  ('201631049', 'C31040203', 'F', '2', '2017-10-13 10:06:57', 84),
  ('201631083', 'C31040203', 'F', '2', '2017-10-13 10:07:04', 87),
  ('201631034', 'C31040203', 'F', '2', '2017-10-13 10:07:15', 84),
  ('201631217', 'C31040203', 'F', '2', '2017-10-13 10:07:25', 84),
  ('201631241', 'C31040203', 'F', '2', '2017-10-13 10:07:38', 87),
  ('201631198', 'C31040203', 'F', '2', '2017-10-13 10:07:43', 90),
  ('201631265', 'C31040203', 'F', '2', '2017-10-13 10:07:48', 77),
  ('201631276', 'C31040203', 'F', '2', '2017-10-13 10:07:54', 60),
  ('201631222', 'C31040203', 'F', '2', '2017-10-13 10:07:59', 95),
  ('201631124', 'C31040203', 'F', '2', '2017-10-13 10:08:07', 80),
  ('201631188', 'C31040203', 'F', '2', '2017-10-13 10:08:13', 90),
  ('201631241', 'C31040203', 'F', '4', '2017-10-13 10:08:30', 95),
  ('201631198', 'C31040203', 'F', '4', '2017-10-13 10:08:36', 95),
  ('201631265', 'C31040203', 'F', '4', '2017-10-13 10:08:41', 80),
  ('201631276', 'C31040203', 'F', '4', '2017-10-13 10:08:50', 77),
  ('201631222', 'C31040203', 'F', '4', '2017-10-13 10:08:56', 95),
  ('201631124', 'C31040203', 'F', '4', '2017-10-13 10:09:02', 85),
  ('201631188', 'C31040203', 'F', '4', '2017-10-13 10:09:08', 95),
  ('201631052', 'C31040203', 'F', '4', '2017-10-13 10:09:26', 84),
  ('201631191', 'C31040203', 'F', '4', '2017-10-13 10:09:32', 83),
  ('201631290', 'C31040203', 'F', '4', '2017-10-13 10:09:46', 82),
  ('201631021', 'C31040203', 'F', '4', '2017-10-13 10:09:54', 82),
  ('201631001', 'C31040203', 'F', '4', '2017-10-13 10:10:00', 82),
  ('201631220', 'C31040203', 'F', '4', '2017-10-13 10:10:06', 50),
  ('201631266', 'C31040203', 'F', '4', '2017-10-13 10:10:13', 87),
  ('201631169', 'C31040203', 'F', '4', '2017-10-13 10:10:22', 84),
  ('201631121', 'C31040203', 'F', '4', '2017-10-13 10:10:29', 84),
  ('201631269', 'C31040203', 'F', '4', '2017-10-13 10:10:36', 85),
  ('201631067', 'C31040203', 'F', '4', '2017-10-13 10:10:45', 84),
  ('201631004', 'C31040203', 'F', '4', '2017-10-13 10:10:52', 84),
  ('201631043', 'C31040203', 'F', '4', '2017-10-13 10:11:00', 85),
  ('201631049', 'C31040203', 'F', '4', '2017-10-13 10:11:06', 84),
  ('201631083', 'C31040203', 'F', '4', '2017-10-13 10:11:13', 87),
  ('201631034', 'C31040203', 'F', '4', '2017-10-13 10:11:18', 84),
  ('201631217', 'C31040203', 'F', '4', '2017-10-13 10:11:25', 84),
  ('201631052', 'C31040203', 'F', '3', '2017-10-13 10:14:10', 85),
  ('201531032', 'C31040315', 'D', '3', '2017-10-13 10:56:48', 80),
  ('201631177', 'C31040203', 'H', '5', '2017-10-14 17:07:59', 95),
  ('201631184', 'C31040203', 'H', '5', '2017-10-14 17:08:11', 88),
  ('201631170', 'C31040203', 'H', '5', '2017-10-14 17:08:23', 95),
  ('201631183', 'C31040203', 'H', '5', '2017-10-14 17:08:34', 88),
  ('201631248', 'C31040203', 'H', '5', '2017-10-14 17:08:42', 60),
  ('201631178', 'C31040203', 'H', '5', '2017-10-14 17:08:49', 95),
  ('201631064', 'C31040203', 'H', '5', '2017-10-14 17:08:54', 100),
  ('201631180', 'C31040203', 'H', '5', '2017-10-14 17:09:02', 89),
  ('201631168', 'C31040203', 'H', '5', '2017-10-14 17:09:21', 90),
  ('201631099', 'C31040203', 'H', '5', '2017-10-14 17:09:28', 85),
  ('201631138', 'C31040203', 'H', '5', '2017-10-14 17:09:36', 86),
  ('201631257', 'C31040203', 'H', '5', '2017-10-14 17:09:46', 84),
  ('201631260', 'C31040203', 'H', '5', '2017-10-14 17:09:58', 88),
  ('201631115', 'C31040203', 'H', '5', '2017-10-14 17:10:04', 89),
  ('201631028', 'C31040203', 'H', '5', '2017-10-14 17:10:12', 88),
  ('201631264', 'C31040203', 'H', '5', '2017-10-14 17:10:18', 85),
  ('201631071', 'C31040203', 'H', '5', '2017-10-14 17:11:28', 84),
  ('201631015', 'C31040203', 'H', '5', '2017-10-14 17:11:35', 82),
  ('201631153', 'C31040203', 'H', '5', '2017-10-14 17:11:40', 85),
  ('201631164', 'C31040203', 'H', '5', '2017-10-14 17:11:47', 87),
  ('201631254', 'C31040203', 'H', '5', '2017-10-14 17:11:53', 70),
  ('201631171', 'C31040203', 'H', '5', '2017-10-14 17:13:56', 95),
  ('201631039', 'C31040203', 'H', '5', '2017-10-14 17:14:01', 90),
  ('201631140', 'C31040203', 'H', '5', '2017-10-14 17:14:09', 90),
  ('201631145', 'C31040203', 'H', '5', '2017-10-14 17:14:12', 70),
  ('201631223', 'C31040203', 'H', '5', '2017-10-14 17:14:17', 95),
  ('201631011', 'C31040203', 'H', '5', '2017-10-14 17:14:27', 83),
  ('201631143', 'C31040203', 'H', '5', '2017-10-14 17:14:42', 95),
  ('201631186', 'C31040203', 'H', '5', '2017-10-14 17:16:59', 95),
  ('201631057', 'C31040203', 'H', '5', '2017-10-14 17:17:06', 95),
  ('201631174', 'C31040203', 'H', '5', '2017-10-14 17:18:03', 98),
  ('201631107', 'C31040203', 'H', '5', '2017-10-14 17:18:24', 95),
  ('201631156', 'C31040203', 'H', '5', '2017-10-14 17:18:56', 95),
  ('201631112', 'C31040203', 'H', '5', '2017-10-14 17:19:04', 95),
  ('201631061', 'C31040203', 'H', '5', '2017-10-14 17:19:13', 90),
  ('201631157', 'C31040203', 'H', '5', '2017-10-14 17:19:20', 95),
  ('201631252', 'C31040203', 'H', '5', '2017-10-14 17:19:28', 95),
  ('201631009', 'C31040203', 'H', '5', '2017-10-14 17:20:29', 60),
  ('201631129', 'C31040203', 'H', '5', '2017-10-14 17:24:39', 95),
  ('201731045', 'C31040101', 'B', '4', '2017-10-18 08:48:51', 70),
  ('201731063', 'C31040101', 'B', '5', '2017-10-18 08:51:14', 70),
  ('201731070', 'C31040101', 'B', '5', '2017-10-18 08:51:22', 70),
  ('201731045', 'C31040101', 'B', '5', '2017-10-18 08:51:26', 70),
  ('201731047', 'C31040101', 'B', '5', '2017-10-18 08:51:31', 70),
  ('201731044', 'C31040101', 'B', '5', '2017-10-18 08:51:58', 70),
  ('201731041', 'C31040101', 'B', '5', '2017-10-18 08:52:04', 70),
  ('201731042', 'C31040101', 'B', '5', '2017-10-18 08:52:08', 70),
  ('201731073', 'C31040101', 'B', '5', '2017-10-18 08:52:16', 75),
  ('201731052', 'C31040101', 'B', '5', '2017-10-18 08:52:22', 70),
  ('201731051', 'C31040101', 'B', '5', '2017-10-18 08:52:29', 70),
  ('201731075', 'C31040101', 'B', '5', '2017-10-18 08:52:34', 70),
  ('201731069', 'C31040101', 'B', '5', '2017-10-18 08:52:41', 70),
  ('201731061', 'C31040101', 'B', '5', '2017-10-18 08:52:45', 40),
  ('201731060', 'C31040101', 'B', '5', '2017-10-18 08:52:50', 70),
  ('201731046', 'C31040101', 'B', '5', '2017-10-18 08:53:02', 70),
  ('201731077', 'C31040101', 'B', '5', '2017-10-18 08:53:06', 60),
  ('201731059', 'C31040101', 'B', '5', '2017-10-18 08:53:11', 40),
  ('201731072', 'C31040101', 'B', '5', '2017-10-18 08:53:15', 70),
  ('201731062', 'C31040101', 'B', '5', '2017-10-18 08:53:21', 70),
  ('201731078', 'C31040101', 'B', '5', '2017-10-18 08:53:28', 70),
  ('201731043', 'C31040101', 'B', '5', '2017-10-18 08:53:34', 70),
  ('201731058', 'C31040101', 'B', '5', '2017-10-18 08:53:41', 70),
  ('201731056', 'C31040101', 'B', '5', '2017-10-18 08:53:45', 70),
  ('201731076', 'C31040101', 'B', '5', '2017-10-18 08:54:01', 70),
  ('201731048', 'C31040101', 'B', '5', '2017-10-18 08:54:06', 70),
  ('201731066', 'C31040101', 'B', '5', '2017-10-18 08:54:14', 70),
  ('201731080', 'C31040101', 'B', '5', '2017-10-18 08:54:19', 70),
  ('201731049', 'C31040101', 'B', '5', '2017-10-18 08:54:23', 70),
  ('201731029', 'C31040101', 'B', '5', '2017-10-18 08:54:41', 70),
  ('201731055', 'C31040101', 'B', '5', '2017-10-18 08:54:45', 70),
  ('201731074', 'C31040101', 'B', '5', '2017-10-18 08:54:49', 70),
  ('201431155', 'C31040413', 'F', '1', '2017-10-18 09:08:29', 83),
  ('201431143', 'C31040413', 'F', '1', '2017-10-18 09:08:40', 82),
  ('201431223', 'C31040413', 'F', '1', '2017-10-18 09:08:48', 80),
  ('201431264', 'C31040413', 'F', '1', '2017-10-18 09:09:54', 84),
  ('201631300', 'C31040203', 'G', '5', '2017-10-24 16:23:57', 96),
  ('201631016', 'C31040203', 'G', '5', '2017-10-24 16:24:19', 95),
  ('201631055', 'C31040203', 'G', '5', '2017-10-24 16:24:32', 96),
  ('201631032', 'C31040203', 'G', '5', '2017-10-24 16:24:46', 65),
  ('201631182', 'C31040203', 'G', '5', '2017-10-24 16:25:15', 98),
  ('201631050', 'C31040203', 'G', '5', '2017-10-24 16:25:26', 70),
  ('201631152', 'C31040203', 'G', '5', '2017-10-24 16:25:35', 80),
  ('201631270', 'C31040203', 'G', '5', '2017-10-24 16:25:45', 97),
  ('201631102', 'C31040203', 'G', '5', '2017-10-24 16:25:53', 95),
  ('201631192', 'C31040203', 'G', '5', '2017-10-24 16:26:00', 90),
  ('201631007', 'C31040203', 'G', '5', '2017-10-24 16:26:09', 90),
  ('201631227', 'C31040203', 'G', '5', '2017-10-24 16:27:09', 95),
  ('201631162', 'C31040203', 'G', '5', '2017-10-24 16:39:06', 95),
  ('201631203', 'C31040203', 'G', '5', '2017-10-24 16:39:13', 85),
  ('201631113', 'C31040203', 'G', '5', '2017-10-24 16:39:19', 95),
  ('201631006', 'C31040203', 'G', '5', '2017-10-24 16:39:24', 70),
  ('201631092', 'C31040203', 'G', '5', '2017-10-24 16:39:31', 90),
  ('201631302', 'C31040203', 'G', '5', '2017-10-24 16:39:36', 96),
  ('201631141', 'C31040203', 'G', '5', '2017-10-24 16:39:48', 71),
  ('201631286', 'C31040203', 'G', '5', '2017-10-24 16:39:53', 97),
  ('201631277', 'C31040203', 'G', '5', '2017-10-24 16:40:13', 0),
  ('201631221', 'C31040203', 'G', '5', '2017-10-24 16:40:18', 85),
  ('201631087', 'C31040203', 'G', '5', '2017-10-24 16:40:23', 97),
  ('201631194', 'C31040203', 'G', '5', '2017-10-24 16:40:27', 60),
  ('201631006', 'C31040203', 'G', '4', '2017-10-24 17:00:33', 60),
  ('201631175', 'C31040203', 'G', '5', '2017-10-24 17:05:28', 90),
  ('201431139', 'C31040413', 'F', '2', '2017-10-25 09:45:37', 100),
  ('201431307', 'C31040413', 'F', '2', '2017-10-25 09:45:50', 75),
  ('201431282', 'C31040413', 'F', '2', '2017-10-25 09:46:03', 62),
  ('201431240', 'C31040413', 'F', '2', '2017-10-25 09:46:11', 100),
  ('201431112', 'C31040413', 'F', '2', '2017-10-25 09:46:19', 100),
  ('201431220', 'C31040413', 'F', '2', '2017-10-25 09:46:26', 75),
  ('201431237', 'C31040413', 'F', '2', '2017-10-25 09:46:35', 100),
  ('201431104', 'C31040413', 'F', '2', '2017-10-25 09:46:42', 70),
  ('201431313', 'C31040413', 'F', '2', '2017-10-25 09:46:51', 100),
  ('201431309', 'C31040413', 'F', '2', '2017-10-25 09:47:01', 83),
  ('201431036', 'C31040413', 'F', '2', '2017-10-25 09:47:13', 75),
  ('201431055', 'C31040413', 'F', '2', '2017-10-25 09:47:22', 85),
  ('201431143', 'C31040413', 'F', '2', '2017-10-25 09:48:23', 100),
  ('201431168', 'C31040413', 'F', '2', '2017-10-25 09:48:35', 75),
  ('201431223', 'C31040413', 'F', '2', '2017-10-25 09:48:42', 100),
  ('201431149', 'C31040413', 'F', '2', '2017-10-25 09:48:49', 86),
  ('201431095', 'C31040413', 'F', '2', '2017-10-25 09:48:57', 100),
  ('201431132', 'C31040413', 'F', '2', '2017-10-25 09:49:13', 78),
  ('201431227', 'C31040413', 'F', '2', '2017-10-25 09:49:18', 86),
  ('201431318', 'C31040413', 'F', '2', '2017-10-25 09:49:25', 80),
  ('201431032', 'C31040413', 'F', '2', '2017-10-25 09:49:35', 100),
  ('201431001', 'C31040413', 'F', '2', '2017-10-25 09:50:16', 70),
  ('201431172', 'C31040413', 'F', '2', '2017-10-25 09:50:25', 73),
  ('201431016', 'C31040413', 'F', '2', '2017-10-25 09:50:35', 82),
  ('201431182', 'C31040413', 'F', '2', '2017-10-25 09:50:44', 82),
  ('201431155', 'C31040413', 'F', '2', '2017-10-25 09:51:03', 85),
  ('201431183', 'C31040413', 'F', '2', '2017-10-25 09:53:04', 70),
  ('201431173', 'C31040413', 'F', '2', '2017-10-25 09:53:15', 79),
  ('201631044', 'C31040203', 'G', '1', '2017-10-28 08:57:23', 40),
  ('201631081', 'C31040203', 'G', '1', '2017-10-28 09:00:12', 80),
  ('201631064', 'C31040203', 'H', '6', '2017-10-30 07:23:42', 95),
  ('201631129', 'C31040203', 'H', '6', '2017-10-30 07:23:58', 80),
  ('201631155', 'C31040203', 'H', '6', '2017-10-30 07:24:13', 95),
  ('201631264', 'C31040203', 'H', '6', '2017-10-30 07:24:26', 95),
  ('201631057', 'C31040203', 'H', '6', '2017-10-30 07:24:38', 93),
  ('201631248', 'C31040203', 'H', '6', '2017-10-30 07:24:54', 90),
  ('201631153', 'C31040203', 'H', '6', '2017-10-30 07:25:05', 95),
  ('201631184', 'C31040203', 'H', '6', '2017-10-30 07:25:23', 88),
  ('201631156', 'C31040203', 'H', '6', '2017-10-30 07:25:44', 95),
  ('201631039', 'C31040203', 'H', '6', '2017-10-30 07:25:56', 85),
  ('201631158', 'C31040203', 'H', '6', '2017-10-30 07:26:13', 90),
  ('201631138', 'C31040203', 'H', '6', '2017-10-30 07:26:37', 90),
  ('201631009', 'C31040203', 'H', '6', '2017-10-30 07:26:47', 83),
  ('201631143', 'C31040203', 'H', '6', '2017-10-30 07:26:56', 95),
  ('201631171', 'C31040203', 'H', '6', '2017-10-30 07:27:07', 98),
  ('201631055', 'C31040203', 'H', '6', '2017-10-30 07:27:19', 95),
  ('201631170', 'C31040203', 'H', '6', '2017-10-30 07:27:42', 90),
  ('201631174', 'C31040203', 'H', '6', '2017-10-30 07:28:00', 97),
  ('201631164', 'C31040203', 'H', '6', '2017-10-30 07:28:12', 92),
  ('201631157', 'C31040203', 'H', '6', '2017-10-30 07:28:23', 90),
  ('201631087', 'C31040203', 'G', '6', '2017-11-04 13:12:33', 85),
  ('201631175', 'C31040203', 'G', '6', '2017-11-04 13:12:47', 95),
  ('201631141', 'C31040203', 'G', '6', '2017-11-04 13:12:56', 80),
  ('201631286', 'C31040203', 'G', '6', '2017-11-04 13:13:08', 0),
  ('201631118', 'C31040203', 'G', '6', '2017-11-04 13:13:15', 97),
  ('201631194', 'C31040203', 'G', '6', '2017-11-04 13:13:24', 40),
  ('201631192', 'C31040203', 'G', '6', '2017-11-04 13:13:39', 90),
  ('201631277', 'C31040203', 'G', '6', '2017-11-04 13:13:50', 83),
  ('201631113', 'C31040203', 'G', '6', '2017-11-04 13:13:59', 98),
  ('201631187', 'C31040203', 'G', '6', '2017-11-04 13:14:07', 98),
  ('201631125', 'C31040203', 'G', '6', '2017-11-04 13:14:27', 98),
  ('201631221', 'C31040203', 'G', '6', '2017-11-04 13:14:44', 98),
  ('201631041', 'C31040203', 'G', '6', '2017-11-04 13:14:57', 85),
  ('201631302', 'C31040203', 'G', '6', '2017-11-04 13:15:10', 90),
  ('201631032', 'C31040203', 'G', '6', '2017-11-04 13:15:25', 35),
  ('201631035', 'C31040203', 'G', '6', '2017-11-04 13:15:40', 93),
  ('201631152', 'C31040203', 'G', '6', '2017-11-04 13:17:01', 88),
  ('201631092', 'C31040203', 'G', '6', '2017-11-04 13:17:11', 98),
  ('201631301', 'C31040203', 'G', '6', '2017-11-04 13:17:19', 85),
  ('201631102', 'C31040203', 'G', '6', '2017-11-04 13:17:44', 93),
  ('201631270', 'C31040203', 'G', '6', '2017-11-04 13:18:34', 85),
  ('201631247', 'C31040203', 'G', '6', '2017-11-04 13:18:44', 35),
  ('201631079', 'C31040203', 'G', '6', '2017-11-04 13:18:57', 85),
  ('201631006', 'C31040203', 'G', '6', '2017-11-04 13:19:04', 80),
  ('201631112', 'C31040203', 'G', '6', '2017-11-04 13:19:25', 90),
  ('201631203', 'C31040203', 'G', '6', '2017-11-04 13:19:34', 57),
  ('201631081', 'C31040203', 'G', '6', '2017-11-04 13:19:41', 95),
  ('201631162', 'C31040203', 'G', '6', '2017-11-04 13:19:54', 87),
  ('201631026', 'C31040203', 'G', '6', '2017-11-04 13:20:13', 50),
  ('201631182', 'C31040203', 'G', '6', '2017-11-04 13:20:22', 80),
  ('201731070', 'C31040107', 'B', '4', '2017-11-06 15:02:01', 80),
  ('201731071', 'C31040107', 'B', '4', '2017-11-06 15:02:09', 60),
  ('201731052', 'C31040107', 'B', '4', '2017-11-06 15:02:17', 50),
  ('201731062', 'C31040107', 'B', '4', '2017-11-06 15:02:23', 40),
  ('201731045', 'C31040107', 'B', '4', '2017-11-06 15:02:39', 60),
  ('201731044', 'C31040107', 'B', '4', '2017-11-06 15:02:46', 65);
  INSERT INTO `tbl_nilai` (`nim`, `kode_matakuliah`, `kelas`, `laporan`, `tgl_kumpul`, `nilai`) VALUES
  ('201731041', 'C31040107', 'B', '4', '2017-11-06 15:02:59', 65),
  ('201731065', 'C31040107', 'B', '4', '2017-11-06 15:03:04', 65),
  ('201731047', 'C31040107', 'B', '4', '2017-11-06 15:03:10', 78),
  ('201731069', 'C31040107', 'B', '4', '2017-11-06 15:03:16', 60),
  ('201731060', 'C31040107', 'B', '4', '2017-11-06 15:03:24', 75),
  ('201731029', 'C31040107', 'B', '4', '2017-11-06 15:03:34', 65),
  ('201731048', 'C31040107', 'B', '4', '2017-11-06 15:05:27', 78),
  ('201731046', 'C31040107', 'B', '4', '2017-11-06 15:05:33', 93),
  ('201731042', 'C31040107', 'B', '4', '2017-11-06 15:06:01', 80),
  ('201731075', 'C31040107', 'B', '4', '2017-11-06 15:06:06', 85),
  ('201731056', 'C31040107', 'B', '4', '2017-11-06 15:06:11', 85),
  ('201731072', 'C31040107', 'B', '4', '2017-11-06 15:06:17', 85),
  ('201731059', 'C31040107', 'B', '4', '2017-11-06 15:06:24', 50),
  ('201731050', 'C31040107', 'B', '4', '2017-11-06 15:06:29', 45),
  ('201731061', 'C31040107', 'B', '4', '2017-11-06 15:06:43', 77),
  ('201731076', 'C31040107', 'B', '4', '2017-11-06 15:07:23', 80),
  ('201731049', 'C31040107', 'B', '4', '2017-11-06 15:07:30', 53),
  ('201731080', 'C31040107', 'B', '4', '2017-11-06 15:07:36', 80),
  ('201731058', 'C31040107', 'B', '4', '2017-11-06 15:07:44', 75),
  ('201731043', 'C31040107', 'B', '4', '2017-11-06 15:08:01', 65),
  ('201731073', 'C31040107', 'B', '4', '2017-11-06 15:08:07', 90),
  ('201731068', 'C31040107', 'B', '4', '2017-11-06 15:08:12', 40),
  ('201731067', 'C31040107', 'B', '4', '2017-11-06 15:08:20', 85),
  ('201731053', 'C31040107', 'B', '4', '2017-11-06 15:08:27', 78),
  ('201731069', 'C31040107', 'B', '2', '2017-11-07 09:04:22', 70),
  ('201731048', 'C31040107', 'B', '2', '2017-11-07 09:04:31', 0),
  ('201731041', 'C31040107', 'B', '3', '2017-11-07 09:04:49', 65),
  ('201731060', 'C31040107', 'B', '3', '2017-11-07 09:04:58', 70),
  ('201731074', 'C31040107', 'B', '3', '2017-11-07 09:05:04', 75),
  ('201731064', 'C31040107', 'B', '4', '2017-11-07 09:05:45', 50),
  ('201731079', 'C31040107', 'B', '4', '2017-11-07 09:05:51', 85),
  ('201731077', 'C31040107', 'B', '4', '2017-11-07 09:05:55', 60),
  ('201731063', 'C31040107', 'B', '4', '2017-11-07 09:06:01', 60),
  ('201731051', 'C31040107', 'B', '4', '2017-11-07 09:06:23', 70),
  ('201731078', 'C31040107', 'B', '4', '2017-11-07 09:06:26', 70),
  ('201731054', 'C31040107', 'B', '4', '2017-11-07 09:06:36', 0),
  ('201731055', 'C31040107', 'B', '4', '2017-11-07 09:06:39', 0),
  ('201731057', 'C31040107', 'B', '4', '2017-11-07 09:06:43', 0),
  ('201731066', 'C31040107', 'B', '4', '2017-11-07 09:07:00', 0),
  ('201731074', 'C31040107', 'B', '4', '2017-11-07 09:07:03', 0),
  ('201731079', 'C31040107', 'B', '5', '2017-11-07 09:09:12', 75),
  ('201731057', 'C31040107', 'B', '5', '2017-11-07 09:09:18', 50),
  ('201731048', 'C31040107', 'B', '5', '2017-11-07 09:09:36', 70),
  ('201731066', 'C31040107', 'B', '5', '2017-11-07 09:09:47', 65),
  ('201731042', 'C31040107', 'B', '5', '2017-11-07 09:09:57', 60),
  ('201731069', 'C31040107', 'B', '5', '2017-11-07 09:10:02', 60),
  ('201731060', 'C31040107', 'B', '5', '2017-11-07 09:10:07', 62),
  ('201731056', 'C31040107', 'B', '5', '2017-11-07 09:10:21', 72),
  ('201731041', 'C31040107', 'B', '5', '2017-11-07 09:10:28', 60),
  ('201731080', 'C31040107', 'B', '5', '2017-11-07 09:10:33', 65),
  ('201731029', 'C31040107', 'B', '5', '2017-11-07 09:10:37', 70),
  ('201731074', 'C31040107', 'B', '5', '2017-11-07 09:10:42', 70),
  ('201731077', 'C31040107', 'B', '5', '2017-11-07 09:10:45', 60),
  ('201731063', 'C31040107', 'B', '5', '2017-11-07 09:10:53', 70),
  ('201731065', 'C31040107', 'B', '5', '2017-11-07 09:10:58', 80),
  ('201731051', 'C31040107', 'B', '5', '2017-11-07 09:11:03', 75),
  ('201731078', 'C31040107', 'B', '5', '2017-11-07 09:11:08', 71),
  ('201731064', 'C31040107', 'B', '6', '2017-11-07 09:11:36', 50),
  ('201731079', 'C31040107', 'B', '6', '2017-11-07 09:11:45', 80),
  ('201731048', 'C31040107', 'B', '6', '2017-11-07 09:11:49', 70),
  ('201731066', 'C31040107', 'B', '6', '2017-11-07 09:11:55', 80),
  ('201731042', 'C31040107', 'B', '6', '2017-11-07 09:12:01', 65),
  ('201731069', 'C31040107', 'B', '6', '2017-11-07 09:12:07', 60),
  ('201731060', 'C31040107', 'B', '6', '2017-11-07 09:12:13', 60),
  ('201731056', 'C31040107', 'B', '6', '2017-11-07 09:12:17', 70),
  ('201731041', 'C31040107', 'B', '6', '2017-11-07 09:12:21', 60),
  ('201731080', 'C31040107', 'B', '6', '2017-11-07 09:12:26', 65),
  ('201731029', 'C31040107', 'B', '6', '2017-11-07 09:12:32', 65),
  ('201731074', 'C31040107', 'B', '6', '2017-11-07 09:12:37', 65),
  ('201731077', 'C31040107', 'B', '6', '2017-11-07 09:12:42', 68),
  ('201731063', 'C31040107', 'B', '6', '2017-11-07 09:12:47', 72),
  ('201731055', 'C31040107', 'B', '6', '2017-11-07 09:12:52', 60),
  ('201731065', 'C31040107', 'B', '6', '2017-11-07 09:12:56', 70),
  ('201731051', 'C31040107', 'B', '6', '2017-11-07 09:13:01', 60),
  ('201731078', 'C31040107', 'B', '6', '2017-11-07 09:13:05', 70),
  ('201731075', 'C31040107', 'B', '6', '2017-11-07 09:13:27', 70),
  ('201731076', 'C31040107', 'B', '6', '2017-11-07 09:13:31', 70),
  ('201731045', 'C31040107', 'B', '6', '2017-11-07 09:13:34', 55),
  ('201731071', 'C31040107', 'B', '6', '2017-11-07 09:13:38', 58),
  ('201731072', 'C31040107', 'B', '6', '2017-11-07 09:13:42', 60),
  ('201731046', 'C31040107', 'B', '6', '2017-11-07 09:13:47', 75),
  ('201731061', 'C31040107', 'B', '6', '2017-11-07 09:13:52', 40),
  ('201731059', 'C31040107', 'B', '6', '2017-11-07 09:14:00', 45),
  ('201731053', 'C31040107', 'B', '6', '2017-11-07 09:14:05', 60),
  ('201731062', 'C31040107', 'B', '6', '2017-11-07 09:14:14', 40),
  ('201731047', 'C31040107', 'B', '6', '2017-11-07 09:14:18', 70),
  ('201731070', 'C31040107', 'B', '6', '2017-11-07 09:14:22', 70),
  ('201731067', 'C31040107', 'B', '6', '2017-11-07 09:14:28', 0),
  ('201731058', 'C31040107', 'B', '6', '2017-11-07 09:15:45', 0),
  ('201731044', 'C31040107', 'B', '6', '2017-11-07 09:16:01', 83),
  ('201731043', 'C31040107', 'B', '6', '2017-11-07 09:16:07', 75),
  ('201731073', 'C31040107', 'B', '6', '2017-11-07 09:16:12', 85),
  ('201731075', 'C31040107', 'B', '5', '2017-11-07 09:20:05', 50),
  ('201731076', 'C31040107', 'B', '5', '2017-11-07 09:20:12', 50),
  ('201731045', 'C31040107', 'B', '5', '2017-11-07 09:20:16', 55),
  ('201731071', 'C31040107', 'B', '5', '2017-11-07 09:20:42', 0),
  ('201731072', 'C31040107', 'B', '5', '2017-11-07 09:20:48', 60),
  ('201731046', 'C31040107', 'B', '5', '2017-11-07 09:20:54', 70),
  ('201731061', 'C31040107', 'B', '5', '2017-11-07 09:21:01', 40),
  ('201731059', 'C31040107', 'B', '5', '2017-11-07 09:21:11', 0),
  ('201731053', 'C31040107', 'B', '5', '2017-11-07 09:21:17', 65),
  ('201731062', 'C31040107', 'B', '5', '2017-11-07 09:21:23', 40),
  ('201731047', 'C31040107', 'B', '5', '2017-11-07 09:21:26', 70),
  ('201731070', 'C31040107', 'B', '5', '2017-11-07 09:21:31', 75),
  ('201731067', 'C31040107', 'B', '5', '2017-11-07 09:21:36', 65),
  ('201731058', 'C31040107', 'B', '5', '2017-11-07 09:21:43', 83),
  ('201731044', 'C31040107', 'B', '5', '2017-11-07 09:21:48', 80),
  ('201731043', 'C31040107', 'B', '5', '2017-11-07 09:21:53', 80),
  ('201731073', 'C31040107', 'B', '5', '2017-11-07 09:21:58', 90),
  ('201731049', 'C31040107', 'B', '5', '2017-11-07 09:23:13', 45),
  ('201731050', 'C31040107', 'B', '5', '2017-11-07 09:23:29', 0),
  ('201731052', 'C31040107', 'B', '5', '2017-11-07 09:23:43', 60),
  ('201731049', 'C31040107', 'B', '6', '2017-11-07 09:24:22', 0),
  ('201731050', 'C31040107', 'B', '6', '2017-11-07 09:24:27', 40),
  ('201731052', 'C31040107', 'B', '6', '2017-11-07 09:24:30', 60),
  ('201731046', 'C31040101', 'B', '6', '2017-11-14 07:52:43', 25),
  ('201731057', 'C31040101', 'B', '6', '2017-11-14 07:52:49', 10),
  ('201731052', 'C31040101', 'B', '6', '2017-11-14 07:52:54', 10),
  ('201731062', 'C31040101', 'B', '6', '2017-11-14 07:52:58', 10),
  ('201731047', 'C31040101', 'B', '6', '2017-11-14 07:53:03', 20),
  ('201731063', 'C31040101', 'B', '6', '2017-11-14 07:53:13', 10),
  ('201731051', 'C31040101', 'B', '6', '2017-11-14 07:53:19', 90),
  ('201731041', 'C31040101', 'B', '6', '2017-11-14 07:53:24', 60),
  ('201731074', 'C31040101', 'B', '6', '2017-11-14 07:53:30', 25),
  ('201731075', 'C31040101', 'B', '6', '2017-11-14 07:53:34', 10),
  ('201731070', 'C31040101', 'B', '6', '2017-11-14 07:53:42', 10),
  ('201731069', 'C31040101', 'B', '6', '2017-11-14 07:53:55', 10),
  ('201731073', 'C31040101', 'B', '6', '2017-11-14 07:54:01', 10),
  ('201731045', 'C31040101', 'B', '6', '2017-11-14 07:54:07', 10),
  ('201731060', 'C31040101', 'B', '6', '2017-11-14 07:54:10', 30),
  ('201731065', 'C31040101', 'B', '6', '2017-11-14 07:54:14', 10),
  ('201731044', 'C31040101', 'B', '6', '2017-11-14 07:54:19', 10),
  ('201731079', 'C31040101', 'B', '6', '2017-11-14 07:54:26', 10),
  ('201731067', 'C31040101', 'B', '6', '2017-11-14 07:54:34', 10),
  ('201731056', 'C31040101', 'B', '6', '2017-11-14 07:54:38', 90),
  ('201731076', 'C31040101', 'B', '6', '2017-11-14 07:54:43', 90),
  ('201731048', 'C31040101', 'B', '6', '2017-11-14 07:54:54', 90),
  ('201731058', 'C31040101', 'B', '6', '2017-11-14 07:55:00', 10),
  ('201731029', 'C31040101', 'B', '6', '2017-11-14 07:55:04', 10),
  ('201731049', 'C31040101', 'B', '6', '2017-11-14 07:55:09', 10),
  ('201731080', 'C31040101', 'B', '6', '2017-11-14 07:55:13', 10),
  ('201731055', 'C31040101', 'B', '6', '2017-11-14 07:55:17', 30),
  ('201731066', 'C31040101', 'B', '6', '2017-11-14 07:55:22', 20),
  ('201731042', 'C31040101', 'B', '6', '2017-11-14 07:55:45', 30),
  ('201731043', 'C31040101', 'B', '6', '2017-11-14 07:55:52', 20),
  ('201731078', 'C31040101', 'B', '6', '2017-11-14 07:55:56', 10),
  ('201731070', 'C31040107', 'B', '7', '2017-11-14 07:58:01', 30),
  ('201731057', 'C31040107', 'B', '7', '2017-11-14 07:58:06', 30),
  ('201731055', 'C31040107', 'B', '7', '2017-11-14 07:58:10', 27),
  ('201731049', 'C31040107', 'B', '7', '2017-11-14 07:58:14', 25),
  ('201731046', 'C31040107', 'B', '7', '2017-11-14 07:58:19', 30),
  ('201731062', 'C31040107', 'B', '7', '2017-11-14 07:58:41', 30),
  ('201731048', 'C31040107', 'B', '7', '2017-11-14 07:58:53', 20),
  ('201731045', 'C31040107', 'B', '7', '2017-11-14 07:59:08', 29),
  ('201731060', 'C31040107', 'B', '7', '2017-11-14 07:59:12', 30),
  ('201731052', 'C31040107', 'B', '7', '2017-11-14 07:59:17', 30),
  ('201731058', 'C31040107', 'B', '7', '2017-11-14 07:59:23', 30),
  ('201731069', 'C31040107', 'B', '7', '2017-11-14 07:59:29', 30),
  ('201731073', 'C31040107', 'B', '7', '2017-11-14 07:59:36', 30),
  ('201731067', 'C31040107', 'B', '7', '2017-11-14 08:00:05', 30),
  ('201731056', 'C31040107', 'B', '7', '2017-11-14 08:00:13', 28),
  ('201731076', 'C31040107', 'B', '7', '2017-11-14 08:00:20', 24),
  ('201731079', 'C31040107', 'B', '7', '2017-11-14 08:00:24', 30),
  ('201731074', 'C31040107', 'B', '7', '2017-11-14 08:00:29', 30),
  ('201731063', 'C31040107', 'B', '7', '2017-11-14 08:00:36', 29),
  ('201731077', 'C31040107', 'B', '7', '2017-11-14 08:00:41', 23),
  ('201731066', 'C31040107', 'B', '7', '2017-11-14 08:01:00', 30),
  ('201731051', 'C31040107', 'B', '7', '2017-11-14 08:01:03', 29),
  ('201731080', 'C31040107', 'B', '7', '2017-11-14 08:01:08', 29),
  ('201731075', 'C31040107', 'B', '7', '2017-11-14 08:01:16', 27),
  ('201731029', 'C31040107', 'B', '7', '2017-11-14 08:01:21', 29),
  ('201731068', 'C31040107', 'B', '7', '2017-11-14 08:01:27', 15),
  ('201731059', 'C31040107', 'B', '7', '2017-11-14 08:01:36', 33),
  ('201731041', 'C31040107', 'B', '7', '2017-11-14 08:01:43', 35),
  ('201731044', 'C31040107', 'B', '7', '2017-11-14 08:01:48', 30),
  ('201731043', 'C31040107', 'B', '7', '2017-11-14 08:01:55', 31),
  ('201731078', 'C31040107', 'B', '7', '2017-11-14 08:02:03', 30),
  ('201731042', 'C31040107', 'B', '7', '2017-11-14 08:02:09', 30),
  ('201731047', 'C31040107', 'B', '7', '2017-11-14 08:02:24', 32),
  ('201731050', 'C31040107', 'B', '7', '2017-11-14 08:06:40', 0),
  ('201731053', 'C31040107', 'B', '7', '2017-11-14 08:06:44', 0),
  ('201731054', 'C31040107', 'B', '7', '2017-11-14 08:06:48', 0),
  ('201731061', 'C31040107', 'B', '7', '2017-11-14 08:06:59', 0),
  ('201731064', 'C31040107', 'B', '7', '2017-11-14 08:07:10', 0),
  ('201731065', 'C31040107', 'B', '7', '2017-11-14 08:07:14', 0),
  ('201731071', 'C31040107', 'B', '7', '2017-11-14 08:07:18', 0),
  ('201731072', 'C31040107', 'B', '7', '2017-11-14 08:07:22', 0),
  ('201731050', 'C31040101', 'B', '6', '2017-11-14 08:08:41', 0),
  ('201731053', 'C31040101', 'B', '6', '2017-11-14 08:08:45', 0),
  ('201731054', 'C31040101', 'B', '6', '2017-11-14 08:08:48', 0),
  ('201731061', 'C31040101', 'B', '6', '2017-11-14 08:08:53', 0),
  ('201731064', 'C31040101', 'B', '6', '2017-11-14 08:08:56', 0),
  ('201731071', 'C31040101', 'B', '6', '2017-11-14 08:09:34', 0),
  ('201731072', 'C31040101', 'B', '6', '2017-11-14 08:09:41', 0),
  ('201731059', 'C31040101', 'B', '6', '2017-11-14 08:09:44', 0),
  ('201731068', 'C31040101', 'B', '6', '2017-11-14 08:09:48', 0),
  ('201731077', 'C31040101', 'B', '6', '2017-11-14 08:09:51', 0),
  ('201731062', 'C31040107', 'B', '8', '2017-11-21 09:47:44', 63),
  ('201731049', 'C31040107', 'B', '8', '2017-11-21 09:48:01', 70),
  ('201731073', 'C31040107', 'B', '8', '2017-11-21 09:48:08', 90),
  ('201731041', 'C31040107', 'B', '8', '2017-11-21 09:48:13', 63),
  ('201731079', 'C31040107', 'B', '8', '2017-11-21 09:48:17', 63),
  ('201731067', 'C31040107', 'B', '8', '2017-11-21 09:48:22', 53),
  ('201731052', 'C31040107', 'B', '8', '2017-11-21 09:48:26', 45),
  ('201731080', 'C31040107', 'B', '8', '2017-11-21 09:48:30', 45),
  ('201731071', 'C31040107', 'B', '8', '2017-11-21 09:48:35', 35),
  ('201731068', 'C31040107', 'B', '8', '2017-11-21 09:48:40', 18),
  ('201731069', 'C31040107', 'B', '8', '2017-11-21 09:48:44', 55),
  ('201731042', 'C31040107', 'B', '8', '2017-11-21 09:49:00', 68),
  ('201731076', 'C31040107', 'B', '8', '2017-11-21 09:49:06', 88),
  ('201731056', 'C31040107', 'B', '8', '2017-11-21 09:49:10', 91),
  ('201731029', 'C31040107', 'B', '8', '2017-11-21 09:49:15', 95),
  ('201731051', 'C31040107', 'B', '8', '2017-11-21 09:49:19', 78),
  ('201731044', 'C31040107', 'B', '8', '2017-11-21 09:49:23', 47),
  ('201731047', 'C31040107', 'B', '8', '2017-11-21 09:49:27', 45),
  ('201731057', 'C31040107', 'B', '8', '2017-11-21 09:49:38', 69),
  ('201731046', 'C31040107', 'B', '8', '2017-11-21 09:49:48', 70),
  ('201731070', 'C31040107', 'B', '8', '2017-11-21 09:49:56', 83),
  ('201731045', 'C31040107', 'B', '8', '2017-11-21 09:49:59', 75),
  ('201731058', 'C31040107', 'B', '8', '2017-11-21 09:50:04', 80),
  ('201731072', 'C31040107', 'B', '8', '2017-11-21 09:50:08', 50),
  ('201731075', 'C31040107', 'B', '8', '2017-11-21 09:50:13', 85),
  ('201731074', 'C31040107', 'B', '8', '2017-11-21 09:50:20', 25),
  ('201731078', 'C31040107', 'B', '8', '2017-11-21 09:50:26', 58),
  ('201731063', 'C31040107', 'B', '8', '2017-11-21 09:50:35', 67),
  ('201731066', 'C31040107', 'B', '8', '2017-11-21 09:50:43', 67),
  ('201731043', 'C31040107', 'B', '8', '2017-11-21 09:50:56', 49),
  ('201431149', 'C31040413', 'F', '3', '2017-11-22 09:56:37', 85),
  ('201431318', 'C31040413', 'F', '3', '2017-11-22 09:56:51', 80),
  ('201431313', 'C31040413', 'F', '3', '2017-11-22 09:57:01', 85),
  ('201431168', 'C31040413', 'F', '3', '2017-11-22 09:57:09', 78),
  ('201431264', 'C31040413', 'F', '3', '2017-11-22 09:57:24', 75),
  ('201431220', 'C31040413', 'F', '3', '2017-11-22 09:57:38', 82),
  ('201431223', 'C31040413', 'F', '3', '2017-11-22 09:57:54', 85),
  ('201431240', 'C31040413', 'F', '3', '2017-11-22 09:58:05', 87),
  ('201431132', 'C31040413', 'F', '3', '2017-11-22 09:58:15', 80),
  ('201431112', 'C31040413', 'F', '3', '2017-11-22 09:58:25', 88),
  ('201431104', 'C31040413', 'F', '3', '2017-11-22 09:58:34', 70),
  ('201431309', 'C31040413', 'F', '3', '2017-11-22 09:58:45', 75),
  ('201431143', 'C31040413', 'F', '3', '2017-11-22 09:58:55', 85),
  ('201431282', 'C31040413', 'F', '3', '2017-11-22 09:59:10', 80),
  ('201431139', 'C31040413', 'F', '3', '2017-11-22 09:59:18', 90),
  ('201431036', 'C31040413', 'F', '3', '2017-11-22 09:59:26', 80),
  ('201431095', 'C31040413', 'F', '3', '2017-11-22 09:59:34', 87),
  ('201431237', 'C31040413', 'F', '3', '2017-11-22 09:59:43', 85),
  ('201431055', 'C31040413', 'F', '3', '2017-11-22 09:59:51', 85),
  ('201431066', 'C31040413', 'F', '3', '2017-11-22 09:59:58', 88),
  ('201531129', 'C31040203', 'H', '7', '2017-11-22 13:39:44', 90),
  ('201631183', 'C31040203', 'H', '7', '2017-11-22 13:40:35', 95),
  ('201631099', 'C31040203', 'H', '7', '2017-11-22 13:40:55', 87),
  ('201631257', 'C31040203', 'H', '7', '2017-11-22 13:41:05', 92),
  ('201631011', 'C31040203', 'H', '7', '2017-11-22 13:41:13', 92),
  ('201631170', 'C31040203', 'H', '7', '2017-11-22 13:41:24', 95),
  ('201631164', 'C31040203', 'H', '7', '2017-11-22 13:41:38', 94),
  ('201631039', 'C31040203', 'H', '7', '2017-11-22 13:41:48', 90),
  ('201631171', 'C31040203', 'H', '7', '2017-11-22 13:42:03', 96),
  ('201631223', 'C31040203', 'H', '7', '2017-11-22 13:42:16', 93),
  ('201631155', 'C31040203', 'H', '7', '2017-11-22 13:42:38', 95),
  ('201631138', 'C31040203', 'H', '7', '2017-11-22 13:42:47', 95),
  ('201631252', 'C31040203', 'H', '7', '2017-11-22 13:43:00', 95),
  ('201631184', 'C31040203', 'H', '7', '2017-11-22 13:43:11', 93),
  ('201631153', 'C31040203', 'H', '7', '2017-11-22 13:43:21', 93),
  ('201631168', 'C31040203', 'H', '7', '2017-11-22 13:43:29', 97),
  ('201631177', 'C31040203', 'H', '7', '2017-11-22 13:43:39', 97),
  ('201631156', 'C31040203', 'H', '7', '2017-11-22 13:43:49', 98),
  ('201631157', 'C31040203', 'H', '7', '2017-11-22 13:44:02', 95),
  ('201631186', 'C31040203', 'H', '7', '2017-11-22 13:44:31', 93),
  ('201631174', 'C31040203', 'H', '7', '2017-11-22 13:44:43', 96),
  ('201631260', 'C31040203', 'H', '7', '2017-11-22 13:44:57', 93),
  ('201631145', 'C31040203', 'H', '7', '2017-11-22 13:45:06', 85),
  ('201631112', 'C31040203', 'H', '7', '2017-11-22 13:45:16', 88),
  ('201631254', 'C31040203', 'H', '7', '2017-11-22 13:45:27', 90),
  ('201631028', 'C31040203', 'H', '7', '2017-11-22 13:45:38', 70),
  ('201631178', 'C31040203', 'H', '7', '2017-11-22 13:45:46', 97),
  ('201631180', 'C31040203', 'H', '7', '2017-11-22 13:45:56', 97),
  ('201631264', 'C31040203', 'H', '7', '2017-11-22 13:46:06', 95),
  ('201631015', 'C31040203', 'H', '7', '2017-11-22 13:46:30', 0),
  ('201631140', 'C31040203', 'H', '7', '2017-11-22 13:46:42', 0),
  ('201631107', 'C31040203', 'H', '7', '2017-11-22 13:46:58', 90),
  ('201631061', 'C31040203', 'H', '7', '2017-11-22 13:47:17', 95),
  ('201631143', 'C31040203', 'H', '7', '2017-11-22 13:47:33', 0),
  ('201631158', 'C31040203', 'H', '7', '2017-11-22 13:47:42', 0),
  ('201631061', 'C31040203', 'H', '6', '2017-11-22 13:48:06', 95),
  ('201631180', 'C31040203', 'H', '6', '2017-11-22 13:48:16', 95),
  ('201631107', 'C31040203', 'H', '6', '2017-11-22 13:48:25', 95),
  ('201631140', 'C31040203', 'H', '6', '2017-11-22 13:48:34', 95),
  ('201631015', 'C31040203', 'H', '6', '2017-11-22 13:48:53', 0),
  ('201631168', 'C31040203', 'H', '6', '2017-11-22 13:49:03', 95),
  ('201631178', 'C31040203', 'H', '6', '2017-11-22 13:49:13', 97),
  ('201631028', 'C31040203', 'H', '6', '2017-11-22 13:49:24', 93),
  ('201631186', 'C31040203', 'H', '6', '2017-11-22 13:49:34', 0),
  ('201631145', 'C31040203', 'H', '6', '2017-11-22 13:49:42', 90),
  ('201631177', 'C31040203', 'H', '6', '2017-11-22 13:50:17', 95),
  ('201631252', 'C31040203', 'H', '6', '2017-11-22 13:50:26', 95),
  ('201431172', 'C31040413', 'F', '3', '2017-11-29 09:19:14', 70),
  ('201431227', 'C31040413', 'F', '3', '2017-11-29 09:20:50', 82),
  ('201631061', 'C31040203', 'G', '6', '2017-11-29 12:03:13', 95),
  ('201631180', 'C31040203', 'G', '6', '2017-11-29 12:03:23', 95),
  ('201631107', 'C31040203', 'G', '6', '2017-11-29 12:03:52', 95),
  ('201631140', 'C31040203', 'G', '6', '2017-11-29 12:03:59', 95),
  ('201631015', 'C31040203', 'G', '6', '2017-11-29 12:04:06', 0),
  ('201631168', 'C31040203', 'G', '6', '2017-11-29 12:04:23', 95),
  ('201631057', 'C31040203', 'H', '7', '2017-11-29 12:33:06', 95),
  ('201631079', 'C31040203', 'G', '7', '2017-11-29 12:41:08', 90),
  ('201631227', 'C31040203', 'G', '7', '2017-11-29 12:41:21', 40),
  ('201631016', 'C31040203', 'G', '7', '2017-11-29 12:41:31', 95),
  ('201631055', 'C31040203', 'G', '7', '2017-11-29 12:41:38', 50),
  ('201631006', 'C31040203', 'G', '7', '2017-11-29 12:41:46', 40),
  ('201631300', 'C31040203', 'G', '7', '2017-11-29 12:41:54', 85),
  ('201631141', 'C31040203', 'G', '7', '2017-11-29 12:42:01', 40),
  ('201631301', 'C31040203', 'G', '7', '2017-11-29 12:42:10', 73),
  ('201631182', 'C31040203', 'G', '7', '2017-11-29 12:42:24', 90),
  ('201631187', 'C31040203', 'G', '7', '2017-11-29 12:42:36', 73),
  ('201631194', 'C31040203', 'G', '7', '2017-11-29 12:42:44', 87),
  ('201631081', 'C31040203', 'G', '7', '2017-11-29 12:42:53', 60),
  ('201631203', 'C31040203', 'G', '7', '2017-11-29 12:43:04', 60),
  ('201631277', 'C31040203', 'G', '7', '2017-11-29 12:43:14', 78),
  ('201631175', 'C31040203', 'G', '7', '2017-11-29 12:43:25', 80),
  ('201631162', 'C31040203', 'G', '7', '2017-11-29 12:44:19', 85),
  ('201631092', 'C31040203', 'G', '7', '2017-11-29 12:44:29', 90),
  ('201631192', 'C31040203', 'G', '7', '2017-11-29 12:44:39', 80),
  ('201631221', 'C31040203', 'G', '7', '2017-11-29 12:44:46', 90),
  ('201631026', 'C31040203', 'G', '7', '2017-11-29 12:44:57', 40),
  ('201631302', 'C31040203', 'G', '7', '2017-11-29 12:45:09', 90),
  ('201631286', 'C31040203', 'G', '7', '2017-11-29 12:50:17', 87),
  ('201631041', 'C31040203', 'G', '7', '2017-11-29 12:50:25', 90),
  ('201631002', 'C31040203', 'G', '7', '2017-11-29 12:50:37', 60),
  ('201631007', 'C31040203', 'G', '7', '2017-11-29 12:50:45', 90),
  ('201631087', 'C31040203', 'G', '7', '2017-11-29 12:50:55', 90),
  ('201631270', 'C31040203', 'G', '7', '2017-11-29 12:51:04', 90),
  ('201631113', 'C31040203', 'G', '7', '2017-11-29 12:51:12', 92),
  ('201631125', 'C31040203', 'G', '7', '2017-11-29 12:51:19', 90),
  ('201631050', 'C31040203', 'G', '7', '2017-11-29 12:52:37', 73),
  ('201631032', 'C31040203', 'G', '7', '2017-11-29 12:52:46', 40),
  ('201631118', 'C31040203', 'G', '7', '2017-11-29 12:52:53', 80),
  ('201731076', 'C31040107', 'B', '10', '2017-12-05 11:22:26', 80),
  ('201731080', 'C31040107', 'B', '10', '2017-12-05 11:22:36', 78),
  ('201731074', 'C31040107', 'B', '10', '2017-12-05 11:22:43', 60),
  ('201731060', 'C31040107', 'B', '10', '2017-12-05 11:23:11', 55),
  ('201731047', 'C31040107', 'B', '10', '2017-12-05 11:23:17', 70),
  ('201731072', 'C31040107', 'B', '10', '2017-12-05 11:23:25', 90),
  ('201731075', 'C31040107', 'B', '10', '2017-12-05 11:23:32', 88),
  ('201731058', 'C31040107', 'B', '10', '2017-12-05 11:23:44', 88),
  ('201731073', 'C31040107', 'B', '10', '2017-12-05 11:23:49', 80),
  ('201731029', 'C31040107', 'B', '10', '2017-12-05 11:23:55', 75),
  ('201731045', 'C31040107', 'B', '10', '2017-12-05 11:24:02', 80),
  ('201731062', 'C31040107', 'B', '10', '2017-12-05 11:24:08', 78),
  ('201731052', 'C31040107', 'B', '10', '2017-12-05 11:24:13', 80),
  ('201731054', 'C31040107', 'B', '10', '2017-12-05 11:24:29', 55),
  ('201731046', 'C31040107', 'B', '10', '2017-12-05 11:24:34', 80),
  ('201731057', 'C31040107', 'B', '10', '2017-12-05 11:24:40', 88),
  ('201731042', 'C31040107', 'B', '10', '2017-12-05 11:24:45', 80),
  ('201731041', 'C31040107', 'B', '10', '2017-12-05 11:24:50', 78),
  ('201731071', 'C31040107', 'B', '10', '2017-12-05 11:25:06', 80),
  ('201731070', 'C31040107', 'B', '10', '2017-12-05 11:25:11', 80),
  ('201731049', 'C31040107', 'B', '10', '2017-12-05 11:25:17', 55),
  ('201731067', 'C31040107', 'B', '10', '2017-12-05 11:25:22', 50),
  ('201731055', 'C31040107', 'B', '10', '2017-12-05 11:25:29', 78),
  ('201731044', 'C31040107', 'B', '10', '2017-12-05 11:25:35', 75),
  ('201731066', 'C31040107', 'B', '10', '2017-12-05 11:25:39', 80),
  ('201731069', 'C31040107', 'B', '10', '2017-12-05 11:26:13', 75),
  ('201731043', 'C31040107', 'B', '10', '2017-12-05 11:26:18', 85),
  ('201731078', 'C31040107', 'B', '10', '2017-12-05 11:26:22', 85),
  ('201731056', 'C31040107', 'B', '10', '2017-12-05 11:26:27', 83),
  ('201731065', 'C31040107', 'B', '10', '2017-12-05 11:26:32', 85),
  ('201731077', 'C31040107', 'B', '10', '2017-12-05 11:26:36', 80),
  ('201731063', 'C31040107', 'B', '10', '2017-12-05 11:26:40', 80),
  ('201731061', 'C31040107', 'B', '10', '2017-12-05 11:26:52', 60),
  ('201731076', 'C31040107', 'B', '11', '2017-12-12 08:03:37', 75),
  ('201731029', 'C31040107', 'B', '11', '2017-12-12 08:03:50', 25),
  ('201731056', 'C31040107', 'B', '11', '2017-12-12 08:04:03', 90),
  ('201731072', 'C31040107', 'B', '11', '2017-12-12 08:04:11', 25),
  ('201731073', 'C31040107', 'B', '11', '2017-12-12 08:04:18', 50),
  ('201731074', 'C31040107', 'B', '11', '2017-12-12 08:04:24', 25),
  ('201731068', 'C31040107', 'B', '11', '2017-12-12 08:04:30', 25),
  ('201731055', 'C31040107', 'B', '11', '2017-12-12 08:04:34', 25),
  ('201731058', 'C31040107', 'B', '11', '2017-12-12 08:04:39', 25),
  ('201731041', 'C31040107', 'B', '11', '2017-12-12 08:05:42', 0),
  ('201731042', 'C31040107', 'B', '11', '2017-12-12 08:05:49', 0),
  ('201731043', 'C31040107', 'B', '11', '2017-12-12 08:05:53', 0),
  ('201731045', 'C31040107', 'B', '11', '2017-12-12 08:06:00', 0),
  ('201731044', 'C31040107', 'B', '11', '2017-12-12 08:06:03', 0),
  ('201731046', 'C31040107', 'B', '11', '2017-12-12 08:06:08', 0),
  ('201731047', 'C31040107', 'B', '11', '2017-12-12 08:06:12', 0),
  ('201731048', 'C31040107', 'B', '11', '2017-12-12 08:06:15', 0),
  ('201731049', 'C31040107', 'B', '11', '2017-12-12 08:06:20', 0),
  ('201731050', 'C31040107', 'B', '11', '2017-12-12 08:06:26', 0),
  ('201731051', 'C31040107', 'B', '11', '2017-12-12 08:06:29', 0),
  ('201731052', 'C31040107', 'B', '11', '2017-12-12 08:06:32', 0),
  ('201731053', 'C31040107', 'B', '11', '2017-12-12 08:06:42', 0),
  ('201731054', 'C31040107', 'B', '11', '2017-12-12 08:06:47', 0),
  ('201731057', 'C31040107', 'B', '11', '2017-12-12 08:06:59', 0),
  ('201731059', 'C31040107', 'B', '11', '2017-12-12 08:07:38', 0),
  ('201731060', 'C31040107', 'B', '11', '2017-12-12 08:07:43', 0),
  ('201731061', 'C31040107', 'B', '11', '2017-12-12 08:07:45', 0),
  ('201731063', 'C31040107', 'B', '11', '2017-12-12 08:07:54', 0),
  ('201731064', 'C31040107', 'B', '11', '2017-12-12 08:07:57', 0),
  ('201731065', 'C31040107', 'B', '11', '2017-12-12 08:08:00', 0),
  ('201731066', 'C31040107', 'B', '11', '2017-12-12 08:08:03', 0),
  ('201731067', 'C31040107', 'B', '11', '2017-12-12 08:08:07', 0),
  ('201731069', 'C31040107', 'B', '11', '2017-12-12 08:08:16', 0),
  ('201731070', 'C31040107', 'B', '11', '2017-12-12 08:08:21', 0),
  ('201731071', 'C31040107', 'B', '11', '2017-12-12 08:08:23', 0),
  ('201731075', 'C31040107', 'B', '11', '2017-12-12 08:08:33', 0),
  ('201731077', 'C31040107', 'B', '11', '2017-12-12 08:08:37', 0),
  ('201731078', 'C31040107', 'B', '11', '2017-12-12 08:08:39', 0),
  ('201731079', 'C31040107', 'B', '11', '2017-12-12 08:08:42', 0),
  ('201731080', 'C31040107', 'B', '11', '2017-12-12 08:08:45', 0),
  ('201731062', 'C31040107', 'B', '11', '2017-12-12 08:09:36', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_user`
  --
  
  CREATE TABLE `tbl_user` (
    `nim` varchar(20) NOT NULL,
    `nama` varchar(50) DEFAULT NULL,
    `password` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `tbl_user`
  --
  
  INSERT INTO `tbl_user` (`nim`, `nama`, `password`) VALUES
  ('', '', ''),
  ('123123123', 'test', '123123123'),
  ('201331062', 'monica kumeang', 'monicakumeang0505'),
  ('201331097', 'lottar b. pardede', '123456'),
  ('201431001', 'selma praditya paramitha', '12345'),
  ('201431016', 'andi indal patara', '201431016'),
  ('201431024', 'miracle-', 'password'),
  ('201431026', 'bintang', '201431026'),
  ('201431032', 'muhamad irsyad r', '212112'),
  ('201431036', 'dwi yen s. saragih', 'K4tasandi'),
  ('201431038', 'nicholas', '25841230'),
  ('201431055', 'novia triani putri', 'pu654321'),
  ('201431057', 'anggisetiawandc', 'anggi1723'),
  ('201431062', 'nilam puspita', 'Nilam'),
  ('201431066', 'ratna mutu manikam', '4444juli'),
  ('201431067', 'rizal adimandana', '12345'),
  ('201431083', 'diego nainggolan', '23031996'),
  ('201431095', 'arga dirgantara', '270796'),
  ('201431104', 'dimas ari', 'xankriegor1'),
  ('201431107', 'yohannes', '12345'),
  ('201431112', 'adi pamungkas', 'QWERASDFZXCV'),
  ('201431114', 'khalil imansyah', '000468'),
  ('201431132', 'harli celebrity', '12345'),
  ('201431139', 'dila', 'zxcvbnm'),
  ('201431143', 'amelia mustika erman', '201431143'),
  ('201431146', 'luthfi fadhlil', 'haraprapikan'),
  ('201431149', 'endang sri wahyuni', 'bulget27'),
  ('201431155', 'indah pradana kusuma', '201431155'),
  ('201431168', 'khaerurrijal', 'dasar'),
  ('201431172', 'astrinda kurniasari', '246118738'),
  ('201431173', 'hardiansyah', '201431173'),
  ('201431182', 'hedwi', '030696'),
  ('201431183', 'rahmat hidayat', '201431183'),
  ('201431191', 'hafiza egyma', '201431191'),
  ('201431220', 'maghfiroh hijrando putra', 'maghfiroh'),
  ('201431223', 'aidha afriza sipayung', '201431223'),
  ('201431227', 'indah rameena', 'indahrameena14'),
  ('201431237', 'exaudina', '201431237'),
  ('201431240', 'sri putri siringo ringo', '101112'),
  ('201431264', 'akhbar fadhilla haq', '201431264'),
  ('201431277', 'pahang mahartam', '036226645'),
  ('201431282', 'muhammad ibnu sina', 'polomarco'),
  ('201431290', 'umar', 'admin'),
  ('201431299', 'pace', 'pace'),
  ('201431307', 'm rully prasetyo', '0nyiskin'),
  ('201431309', 'eka julianty silaban', 'tuhanyesus@'),
  ('201431312', 'ericson slamet untung', '12345'),
  ('201431313', 'sepvica pardede', '19960918'),
  ('201431318', 'zaine erfani', 'irfha'),
  ('201431321', 'raka surya wiebowo', '010115'),
  ('201431324', 'ulfatun syariyah', '67890'),
  ('201431325', 'eqi seftiyan', 'qwerty123'),
  ('201531002', 'gilang budi samudra', 'Gilang31'),
  ('201531003', 'siti nur rahmawati', '12345'),
  ('201531007', 'hafiz yohari', '140897yohari'),
  ('201531017', 'andriekh', 'aikawa'),
  ('201531025', 'muhammad suharto', 'atuamal10'),
  ('201531026', 'muhammad alfin', '03217201634'),
  ('201531029', 'riantri', '201531029'),
  ('201531032', 'hendy augustama', '14081997'),
  ('201531034', 'rizki kurnia hapsari', 'gerobaksayur'),
  ('201531042', 'bianca pingkan nevista', '291196'),
  ('201531043', 'silviana angraini juandi', 'silviana123'),
  ('201531046', 'prasetiyo aldi nugroho', 'asujaran'),
  ('201531064', 'prasasti ginora', 'ginora2729'),
  ('201531066', 'chindy aritonang', '201531066'),
  ('201531067', 'stevanus', '5T3V4NU5'),
  ('201531070', 'joshua melvin', '123456'),
  ('201531080', 'pingki dian sulistiani', 'pingki1102'),
  ('201531085', 'eka nurul ishla aslihi', '21061998'),
  ('201531094', 'ubed sihombing', 'handayani11'),
  ('201531098', 'granite bagas', 'granite97'),
  ('201531099', 'abiyyu', 'rahasia'),
  ('201531101', 'adynata kumara', 'kopassus'),
  ('201531103', 'ahmad riyana s', '290595'),
  ('201531106', 'catur galih santoso', 'afiftia96'),
  ('201531115', 'iqbal haryanto sis', 'exciting'),
  ('201531119', 'moch. ilham tri pamungkas', 'ilhamhate'),
  ('201531120', 'm arief', 'chy23'),
  ('201531121', 'm. firza pahlevi', 'eyessettokill'),
  ('201531123', 'nadia mawarni', 'assmfpnmdday16'),
  ('201531129', 'ristyna lidya m', 'tyna050397'),
  ('201531133', 'wisnu maliqul hakam', '201531133'),
  ('201531139', 'eva cristiani angelina sidabutar', 'evacas'),
  ('201531140', 'andre hendry', '12345'),
  ('201531146', 'fahmi faqih eftu meingga', 'loplop123'),
  ('201531147', 'nurul herwinda', 'n201531147'),
  ('201531150', 'nidia putri paramida', 'nidabaik123'),
  ('201531153', 'reni rahma utami', '201531153'),
  ('201531155', 'mareta dwi sholikhah', '100397'),
  ('201531160', 'maya devita prastisiya', 'magelang'),
  ('201531161', 'raudhatul jannah', 'dian1234'),
  ('201531162', 'andi zabila p f', '201531162'),
  ('201531163', 'maya ristia lanri', 'mayaristia123'),
  ('201531166', 'bagus septian', '0899'),
  ('201531168', 'parahita elandhasari', 'elandha0796'),
  ('201531189', 'ian ahmad fachriza', '123456'),
  ('201531199', 'dewi sri rezeki', 'rezeki'),
  ('201531201', 'ragiel adnan kusuma', 'blink182'),
  ('201531230', 'sahbudi manalu', 'budimulia'),
  ('201531238', 'abdan', 'aww'),
  ('201531250', 'vincentia reynada primadhani', 'nada250'),
  ('201531258', 'rekha ayu anggraeni', '201531258'),
  ('201531262', 'budi hartono untung', '23456789'),
  ('201531263', 'alwi', 'kepodah'),
  ('201631001', 'shahibul azly', '240696'),
  ('201631002', 'dinda chintya natalia tonapa', 'blackberry'),
  ('201631004', 'andi aurliareski', '201631004'),
  ('201631006', 'irfan fahmi ahmadi', 'myaccount'),
  ('201631007', 'yosephine m. s. a. b.', 'mamaku1306'),
  ('201631008', 'electricia natalia lumanauw', 'chya1998'),
  ('201631009', 'muhamad fachrul', '202401'),
  ('201631011', 'yudha randa madhika', 'maxshadow45'),
  ('201631015', 'a. alif akbar r.', '26091997'),
  ('201631016', 'mohammad mutho', 'cahsmansa'),
  ('201631020', 'ardhi anggoro mukti', 'ardhi04'),
  ('201631021', 'iswahyudin', 'Sholat524434'),
  ('201631026', 'mehilda', 'pokokmenlah31'),
  ('201631028', 'hanny febrianti elizabeth', 'sakura21'),
  ('201631029', 'rizky pradana audy setya putra', 'express4'),
  ('201631030', 'alfiansyah zuhri harahap', 'tigabelas08'),
  ('201631032', 'josua nugraha panjaitan', '241108'),
  ('201631034', 'ridho nusantara putra', '191412shh'),
  ('201631035', 'witri utari', 'Mamak987'),
  ('201631039', 'sergius sarmose manggara putra manullang', 'sergius'),
  ('201631041', 'nurdzakirah amir', 'bulukumba'),
  ('201631043', 'muhammad gibran', '030898'),
  ('201631044', 'winata bayu aji', 'winatajelekkayabebek'),
  ('201631049', 'syahrun mubarak', 'besokaja'),
  ('201631050', 'muhammad akhsanul mawalid', '050798'),
  ('201631052', 'angga rizki kurniawan', 'BOMBERS#012'),
  ('201631055', 'parlinggoman pakpahan', 'stt123'),
  ('201631057', 'dhiya khairunnisa', 'pisces07'),
  ('201631061', 'fresly renaldy purba', '565674'),
  ('201631063', 'arka', '111213'),
  ('201631064', 'nur anditha ramadanty', 'anditha12'),
  ('201631067', 'fauzan octhory lukfi', 'fauzan123'),
  ('201631068', 'abdi gunawan ', 'welove4ever'),
  ('201631071', 'dame ria carolina', 'silitonga'),
  ('201631079', 'nana aprilia nurcahyanti', '9N65M74T98N05R'),
  ('201631081', 'afrilia justin', '0104frili'),
  ('201631083', 'teguh hermanto', '05021998'),
  ('201631087', 'ira arfianis', '2maret1998'),
  ('201631092', 'putri nur ahdiah', '123456'),
  ('201631099', 'nurul anwar', 'Anwar099'),
  ('201631100', 'aflahurif atmi wahyu', '080498'),
  ('201631102', 'afif dwi kurniawan', 'afifdwikurniawan'),
  ('201631107', 'zelin lelisiana maria pretty', 'Odiliagemma10'),
  ('201631108', 'tita khurnelia r', '123456'),
  ('201631111', 'epafras setia endungunaung', 'mengapa00'),
  ('201631112', 'ceska caissia reppa', 'ceska 98'),
  ('201631113', 'ni putu dian lestari dewi', 'moonchaejeong'),
  ('201631114', 'bismillah', 'dasar12'),
  ('201631115', 'aklimatulzamzam', '051097'),
  ('201631118', 'ariffudin musthofa basri', '123arif123'),
  ('201631121', 'bayu aryadhi kusuma', '171238'),
  ('201631124', 'dina fitri rahayu', 'dina6117'),
  ('201631125', 'febianti yulanda wulandari', '130299'),
  ('201631128', 'ichlas shidqii', '201631128'),
  ('201631129', 'ristyna lidya m. s.', '201631129'),
  ('201631133', 'monik anggraeni', 'cantik'),
  ('201631138', 'sinta ariani', 'heintraumg9819'),
  ('201631140', 'verisca novianty', 'chika123'),
  ('201631141', 'yusmardianto', 'Yusmar15'),
  ('201631143', 'ainun jariah kamal', '120698'),
  ('201631145', 'amalia shah putri', '266amalia'),
  ('201631152', 'fanny auli erisen', 'erisen19'),
  ('201631153', 'farhan ali', '10123458'),
  ('201631154', 'fatahillah paweloi', 'fatjhe25'),
  ('201631155', 'figina hardiantie', 'fghardiantie17'),
  ('201631156', 'firdha surya shafira', 'firdha156'),
  ('201631157', 'kevin reyhan', 'ratard123'),
  ('201631158', 'l noer muhammad fahmi tamar', 'mikasa123'),
  ('201631162', 'akmal ', 'akmal123'),
  ('201631164', 'maudika indah putri', 'modi3008'),
  ('201631165', 'mayang asura', 'asura'),
  ('201631168', 'muhammad dhika azizi', 'realmfc123...'),
  ('201631169', 'muhammad putra yoka', 'yoka1234'),
  ('201631170', 'mutia khairunisa', 'mutia171798'),
  ('201631171', 'nia rani valentin sirait', 'valentin14'),
  ('201631174', 'nurul ramadhanti hikimiyah', '21februari1998'),
  ('201631175', 'pimar aprilo jujur perkasa', 'pgaxaverius'),
  ('201631177', 'renaldy bagas bayu pambudi', 'renaldy48'),
  ('201631178', 'rian hasiando silaen', 'ilovebudekantin'),
  ('201631180', 'sigit prasetyo noprianto', '19111998'),
  ('201631182', 'sri aulia khalifa', 'aulia182'),
  ('201631183', 'suci ratna listiyani', 'suciratna13'),
  ('201631184', 'tedi rayadi', 'tedy6505'),
  ('201631185', 'teuku abrar', 'indonesia'),
  ('201631186', 'tubagus permadi', '84515'),
  ('201631187', 'willis aprieta sari', '201631187'),
  ('201631188', 'wulandari algadri', '792140'),
  ('201631191', 'agi priharu', 'visual23'),
  ('201631192', 'ahwan kusumo', '12345678'),
  ('201631194', 'bela siska andyansi', 'hariyanto111'),
  ('201631198', 'diva ramadha ristanto', 'exdragon'),
  ('201631203', 'givenchy ampulembang', 'Jayapura0127'),
  ('201631206', 'muhammad yusuf ibrahim', 'yusufibrahim'),
  ('201631217', 'ahmad zaki', '201631217'),
  ('201631220', 'anugrah putra agusta', '201631220'),
  ('201631221', 'chrystyna monica tambunan', 'tambunan11'),
  ('201631222', 'desi yolanda marpaung', 'echicute'),
  ('201631223', 'febrianti sartika', '180298'),
  ('201631227', 'kharismana fajri latuconsina', '980902'),
  ('201631241', 'yossi pratiwi', '201631241'),
  ('201631247', 'nella rut hutahaean', '191669'),
  ('201631248', 'rafi mufadhal difany', 'miniwings01'),
  ('201631252', 'windaikaf', 'w117d4'),
  ('201631254', 'aristo fan brata sanggu', 'ende1797'),
  ('201631257', 'hyang nareswara', 'nareswara1999'),
  ('201631260', 'monica putri loreenza', '21061998'),
  ('201631261', 'muhammad ariski', 'kijok896'),
  ('201631264', 'seren ashari', '10november'),
  ('201631265', 'zandra zenidane', 'Hatihat5'),
  ('201631266', 'fida teresia', 'situmorang16'),
  ('201631269', 'pepi nigatama', '2468PN'),
  ('201631270', 'putri wahyuni', 'putri270'),
  ('201631276', 'eza atoillah', '815694'),
  ('201631277', 'moh.nur aripin', '201631277'),
  ('201631286', 'abdul malik karim', 'malikji148'),
  ('201631288', 'andi hilman agung alashri', '210598'),
  ('201631290', 'andhika indra irawan', 'Trisula249'),
  ('201631300', 'nuggy nugraha', 'persib'),
  ('201631301', 'alfajri hulvi', 'fajri123'),
  ('201631302', 'muhammad adli ramadhan', 'pr1v4cy'),
  ('201631345', 'amalia shah putri', '201631345'),
  ('2017-31-055', 'kelvin fajar', 'Fajar1212'),
  ('201731029', 'muhammad ihza alhafiz', 'ihzaalhafiz'),
  ('201731041', 'chaerul iman', 'pekalongan1'),
  ('201731042', 'chory irwansyah r.', 'chory1622'),
  ('201731043', 'cindy ruth agatha siburian', 'cindy2828'),
  ('201731044', 'deni setiawan', 'denisetiawan82'),
  ('201731045', 'deva rahma sari', 'jangancemburu'),
  ('201731046', 'dhemas septian adhi n', '1ngasi0'),
  ('201731047', 'dhimas aji prabowo', 'dhimasajip123'),
  ('201731048', 'dimas giantaruna', 'dimas123'),
  ('201731049', 'eric supema anggara', 'eric123'),
  ('201731050', 'fadhil mattrawi', 'fadhil124'),
  ('201731051', 'givari fairus ferdiansyah deu', 'riandeu86'),
  ('201731052', 'husna', '191908'),
  ('201731053', 'jeremi sinlae', '201731053'),
  ('201731054', 'jhosua', 'josua23061999'),
  ('201731055', 'kelvin fajar', 'fajar1212'),
  ('201731056', 'm. fajrul islah', 'ojong26'),
  ('201731057', 'm alvin pratama', '200699'),
  ('201731058', 'martogi johan siagian', '181192'),
  ('201731059', 'muhammad ferdianto abrori', '201731059'),
  ('201731060', 'mohammad ichwanuddin ', 'anjing123'),
  ('201731061', 'mohd.farras daffa rizha', 'Balayak12'),
  ('201731062', 'monica kumeang', 'monica5599'),
  ('201731063', 'muhammad arief nurfaiz', 'faiz0073'),
  ('201731064', 'muhammad fhieno rachmadi', 'qazwsx321'),
  ('201731065', 'muhammad hilmy lubna zwagery', '161922'),
  ('201731066', 'muhammad hirzan', 'ijan0312'),
  ('201731067', 'muhammad ilham yafi', 'Bamarolep10'),
  ('201731068', 'muhammad revo wicaksana', 'Janganlupalagi1'),
  ('201731069', 'namira fadia soraya', 'namira6.'),
  ('201731070', 'nurthania nadya rezki', '07031999thania'),
  ('201731071', 'pemi ulandari', 'mansur'),
  ('201731072', 'petrus iverson sinaga', '191197'),
  ('201731073', 'rama agustin sitanggang', 'ramaimut'),
  ('201731074', 'razan syahaq', '201731074'),
  ('201731075', 'reski febrina saridevi', 'cantik99'),
  ('201731076', 'rhasya bintang rizqi', 'Kickkids39'),
  ('201731077', 'rivaldy tri d', 'mainbola'),
  ('201731078', 'rosanna uli artha.p ', 'anaktuhan'),
  ('201731079', 'ruth megah selfina tambunan', 'rmst2808'),
  ('201731080', 'sari nira melia', 'niranira99'),
  ('201731351', 'muhammad ilham', 'Cyber4rt');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `tbl_admin`
  --
  ALTER TABLE `tbl_admin`
    ADD KEY `fk_nim2` (`nim`);
  
  --
  -- Indexes for table `tbl_bantuan`
  --
  ALTER TABLE `tbl_bantuan`
    ADD PRIMARY KEY (`no_bantuan`);
  
  --
  -- Indexes for table `tbl_jadwal_lab`
  --
  ALTER TABLE `tbl_jadwal_lab`
    ADD PRIMARY KEY (`kode_jadwal`),
    ADD KEY `fk_kode_matakuliah` (`kode_matakuliah`);
  
  --
  -- Indexes for table `tbl_matakuliah`
  --
  ALTER TABLE `tbl_matakuliah`
    ADD PRIMARY KEY (`kode_matakuliah`);
  
  --
  -- Indexes for table `tbl_nilai`
  --
  ALTER TABLE `tbl_nilai`
    ADD KEY `fk_nim` (`nim`),
    ADD KEY `fk_kode_matakuliah2` (`kode_matakuliah`);
  
  --
  -- Indexes for table `tbl_user`
  --
  ALTER TABLE `tbl_user`
    ADD PRIMARY KEY (`nim`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `tbl_bantuan`
  --
  ALTER TABLE `tbl_bantuan`
    MODIFY `no_bantuan` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `tbl_admin`
  --
  ALTER TABLE `tbl_admin`
    ADD CONSTRAINT `fk_nim2` FOREIGN KEY (`nim`) REFERENCES `tbl_user` (`nim`);
  
  --
  -- Constraints for table `tbl_jadwal_lab`
  --
  ALTER TABLE `tbl_jadwal_lab`
    ADD CONSTRAINT `fk_kode_matakuliah` FOREIGN KEY (`kode_matakuliah`) REFERENCES `tbl_matakuliah` (`kode_matakuliah`);
  
  --
  -- Constraints for table `tbl_nilai`
  --
  ALTER TABLE `tbl_nilai`
    ADD CONSTRAINT `fk_kode_matakuliah2` FOREIGN KEY (`kode_matakuliah`) REFERENCES `tbl_matakuliah` (`kode_matakuliah`),
    ADD CONSTRAINT `fk_nim` FOREIGN KEY (`nim`) REFERENCES `tbl_user` (`nim`);
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  