text: /*
  SQLyog Ultimate v12.4.0 (32 bit)
  MySQL - 10.1.16-MariaDB : Database - outlier
  *********************************************************************
  */
  
  
  /*!40101 SET NAMES utf8 */;
  
  /*!40101 SET SQL_MODE=''*/;
  
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  CREATE DATABASE /*!32312 IF NOT EXISTS*/`outlier` /*!40100 DEFAULT CHARACTER SET latin1 */;
  
  USE `outlier`;
  
  /*Table structure for table `data_latih` */
  
  DROP TABLE IF EXISTS `data_latih`;
  
  CREATE TABLE `data_latih` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_mhs` int(11) NOT NULL,
    `id_periode` int(11) NOT NULL,
    `mk1` double DEFAULT NULL,
    `mk2` double DEFAULT NULL,
    `mk3` double DEFAULT NULL,
    `mk4` double DEFAULT NULL,
    `mk5` double DEFAULT NULL,
    `mk6` double DEFAULT NULL,
    `mk7` double DEFAULT NULL,
    `mk8` double DEFAULT NULL,
    `mk9` double DEFAULT NULL,
    `mk10` double DEFAULT NULL,
    `mk11` double DEFAULT NULL,
    `mk12` double DEFAULT NULL,
    `mk13` double DEFAULT NULL,
    `mk14` double DEFAULT NULL,
    `mk15` double DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=latin1;
  
  /*Data for the table `data_latih` */
  
  insert  into `data_latih`(`id`,`id_mhs`,`id_periode`,`mk1`,`mk2`,`mk3`,`mk4`,`mk5`,`mk6`,`mk7`,`mk8`,`mk9`,`mk10`,`mk11`,`mk12`,`mk13`,`mk14`,`mk15`) values 
  
  (1,1,1,9,7,10.5,10.5,7.5,10.5,3,10.5,8,12,10.5,10.5,7.5,7.5,3),
  
  (2,2,1,10.5,8,7.5,6,12,7.5,3.5,10.5,8,12,9,10.5,7.5,7.5,3.5),
  
  (3,3,1,10.5,8,9,6,12,7.5,3.5,10.5,8,10.5,10.5,10.5,7.5,10.5,4),
  
  (4,4,1,10.5,7,9,10.5,9,9,3.5,10.5,7,12,10.5,10.5,10.5,7.5,2.5),
  
  (5,5,1,9,7,7.5,0,7.5,7.5,3,10.5,8,10.5,7.5,9,7.5,7.5,3),
  
  (6,6,1,10.5,8,12,10.5,12,7.5,2.5,12,8,10.5,12,12,12,10.5,4),
  
  (7,7,1,10.5,8,12,7.5,10.5,10.5,2.5,12,8,12,10.5,10.5,12,7.5,4),
  
  (8,8,1,10.5,8,7.5,6,12,7.5,2.5,12,8,10.5,9,10.5,9,7.5,3.5),
  
  (9,9,1,10.5,8,12,6,12,7.5,3.5,10.5,7,12,9,10.5,7.5,7.5,3.5),
  
  (10,10,1,7.5,8,12,10.5,12,10.5,4,12,8,12,12,12,10.5,10.5,4),
  
  (11,11,1,10.5,8,12,9,9,10.5,4,12,8,10.5,12,12,12,7.5,3.5),
  
  (12,12,1,10.5,8,12,6,9,10.5,3.5,12,8,12,12,10.5,7.5,7.5,4),
  
  (13,13,1,10.5,8,12,7.5,9,10.5,3.5,10.5,7,10.5,12,10.5,7.5,7.5,3.5),
  
  (14,14,1,7.5,7,12,12,10.5,10.5,3.5,10.5,8,10.5,12,9,12,7.5,3.5),
  
  (15,15,1,10.5,7,12,10.5,10.5,10.5,3.5,12,8,12,12,10.5,10.5,7.5,4),
  
  (16,16,1,9,8,12,7.5,9,10.5,3,12,8,12,12,9,10.5,7.5,3),
  
  (17,17,1,10.5,7,12,6,9,10.5,3,9,7,12,12,10.5,3,7.5,3),
  
  (18,18,1,7.5,8,12,6,9,10.5,3.5,12,7,12,12,10.5,9,7.5,4),
  
  (19,19,1,10.5,8,12,6,9,10.5,3.5,12,8,12,12,9,6,7.5,4),
  
  (20,20,1,9,8,9,10.5,9,10.5,3.5,10.5,8,10.5,12,10.5,9,7.5,4),
  
  (21,21,1,10.5,8,12,9,9,10.5,3,12,7,12,12,10.5,7.5,7.5,4),
  
  (22,22,1,10.5,8,12,10.5,12,12,4,12,8,12,12,10.5,12,9,4),
  
  (23,23,1,9,3,12,7.5,9,10.5,3.5,12,8,10.5,10.5,10.5,9,7.5,4),
  
  (24,24,1,10.5,7,10.5,7.5,9,10.5,3.5,10.5,7,10.5,12,10.5,7.5,7.5,4),
  
  (25,25,1,10.5,8,12,6,10.5,10.5,4,10.5,8,10.5,12,10.5,10.5,10.5,3.5),
  
  (26,26,1,9,8,12,6,9,10.5,3.5,12,8,12,12,10.5,10.5,7.5,4),
  
  (27,27,1,10.5,8,12,9,9,10.5,2,10.5,7,10.5,12,10.5,10.5,7.5,4),
  
  (28,28,1,12,8,12,9,12,7.5,3.5,12,8,12,10.5,12,10.5,10.5,4),
  
  (29,29,1,10.5,8,7.5,6,10.5,7.5,3,12,8,10.5,9,10.5,9,9,3),
  
  (30,30,1,10.5,8,12,12,12,9,3.5,10.5,8,12,10.5,10.5,9,7.5,2.5),
  
  (31,31,1,10.5,7,12,12,12,12,3.5,12,8,12,12,12,12,7.5,3),
  
  (32,32,1,9,8,12,12,12,12,3.5,12,8,12,12,12,10.5,7.5,4),
  
  (33,33,1,9,7,10.5,7.5,10.5,10.5,3.5,12,7,12,10.5,10.5,10.5,7.5,3.5),
  
  (34,34,1,10.5,7,10.5,10.5,10.5,10.5,3.5,12,8,12,10.5,10.5,9,7.5,2.5),
  
  (35,35,1,9,8,10.5,12,12,10.5,3,10.5,8,12,12,10.5,10.5,7.5,3),
  
  (36,36,1,10.5,7,12,9,12,10.5,2,10.5,8,12,10.5,10.5,10.5,7.5,2.5),
  
  (37,37,1,10.5,8,12,12,12,10.5,3.5,12,8,10.5,12,12,10.5,10.5,4),
  
  (38,38,1,10.5,8,12,12,12,10.5,4,12,8,10.5,12,12,10.5,10.5,4),
  
  (39,39,1,9,7,10.5,12,9,10.5,3,10.5,8,10.5,12,10.5,10.5,7.5,4),
  
  (40,40,1,7.5,7,10.5,10.5,10.5,10.5,3.5,10.5,8,10.5,10.5,10.5,9,7.5,4),
  
  (41,41,1,10.5,7,12,10.5,12,10.5,3.5,12,8,12,12,12,12,10.5,4),
  
  (42,42,1,10.5,7,12,10.5,12,10.5,3.5,10.5,8,12,10.5,10.5,10.5,9,4),
  
  (43,43,1,10.5,7,12,10.5,12,10.5,3.5,12,8,12,12,10.5,12,7.5,4),
  
  (44,44,1,9,7,10.5,10.5,10.5,10.5,4,10.5,7,9,10.5,10.5,7.5,7.5,3.5),
  
  (45,45,1,10.5,8,12,10.5,10.5,10.5,3.5,12,8,9,12,12,12,7.5,4),
  
  (46,46,1,10.5,8,12,12,10.5,10.5,2,12,8,9,10.5,12,12,10.5,4),
  
  (47,47,1,9,8,12,7.5,10.5,10.5,3,12,8,12,12,10.5,10.5,9,4),
  
  (48,48,1,12,8,12,12,12,10.5,3.5,12,8,12,12,12,12,9,4),
  
  (49,49,1,10.5,6,12,12,10.5,10.5,3.5,10.5,7,10.5,12,10.5,10.5,7.5,4),
  
  (50,50,1,9,8,10.5,6,9,10.5,1,10.5,7,10.5,12,10.5,9,7.5,3),
  
  (51,51,1,10.5,8,12,7.5,9,10.5,3.5,10.5,8,10.5,12,10.5,12,7.5,3.5),
  
  (52,52,1,7.5,8,10.5,10.5,9,10.5,3,12,8,10.5,12,10.5,10.5,7.5,3.5),
  
  (53,53,1,12,7,12,9,12,7.5,3.5,12,8,10.5,10.5,12,10.5,10.5,4),
  
  (54,54,1,10.5,7,10.5,7.5,12,7.5,4,12,8,10.5,10.5,10.5,9,10.5,3),
  
  (55,55,1,10.5,8,9,9,12,7.5,3.5,12,8,12,10.5,10.5,10.5,10.5,4),
  
  (56,56,1,12,8,12,10.5,12,7.5,3.5,12,8,12,12,12,10.5,10.5,3.5),
  
  (57,57,1,10.5,8,7.5,6,10.5,7.5,4,10.5,8,12,9,12,9,10.5,3.5),
  
  (58,58,1,9,8,12,7.5,9,10.5,4,10.5,7,12,12,12,9,7.5,4),
  
  (59,59,1,10.5,7,12,9,10.5,10.5,2.5,12,7,9,12,10.5,9,10.5,4),
  
  (60,60,1,10.5,8,12,6,10.5,10.5,3.5,12,8,10.5,12,12,10.5,7.5,3.5),
  
  (61,61,1,10.5,7,12,9,10.5,10.5,2.5,10.5,8,9,12,10.5,12,9,4),
  
  (62,62,1,10.5,8,12,10.5,9,10.5,4,12,8,12,12,10.5,10.5,7.5,4),
  
  (63,63,1,10.5,8,12,10.5,12,7.5,4,10.5,8,12,10.5,12,10.5,10.5,4),
  
  (64,64,1,10.5,8,12,6,9,10.5,4,12,8,10.5,7.5,10.5,7.5,7.5,2.5),
  
  (65,65,1,10.5,8,10.5,7.5,12,7.5,4,12,8,10.5,10.5,10.5,10.5,10.5,4),
  
  (66,66,1,10.5,8,9,7.5,9,10.5,3.5,10.5,8,12,12,10.5,6,9,4),
  
  (67,67,1,10.5,8,10.5,6,10.5,7.5,3.5,10.5,7,12,9,12,9,7.5,4),
  
  (68,68,1,10.5,7,10.5,9,12,7.5,4,12,7,10.5,9,10.5,10.5,9,4),
  
  (69,69,1,10.5,7,7.5,9,12,7.5,3.5,10.5,8,9,9,10.5,9,9,3),
  
  (70,70,1,10.5,8,9,9,12,7.5,3.5,10.5,7,9,7.5,9,6,9,3.5),
  
  (71,71,1,10.5,8,10.5,7.5,12,7.5,3.5,12,8,12,9,12,9,7.5,3.5),
  
  (72,72,1,10.5,8,12,10.5,12,7.5,3.5,12,8,10.5,7.5,12,10.5,9,4),
  
  (73,73,1,10.5,8,10.5,12,12,7.5,3.5,12,8,12,9,12,10.5,9,4),
  
  (74,74,1,10.5,8,10.5,6,12,7.5,3.5,12,8,9,7.5,10.5,10.5,12,3),
  
  (75,75,1,10.5,8,10.5,9,12,7.5,3.5,10.5,8,9,6,12,9,10.5,4),
  
  (76,76,1,10.5,8,10.5,7.5,12,7.5,3.5,12,8,9,9,12,10.5,7.5,4),
  
  (77,77,1,10.5,0,7.5,6,12,7.5,4,10.5,8,9,6,12,9,7.5,2.5),
  
  (78,78,1,10.5,8,12,7.5,12,7.5,3.5,12,8,9,10.5,10.5,10.5,9,4),
  
  (79,79,1,10.5,8,9,6,10.5,7.5,3.5,10.5,8,9,7.5,10.5,10.5,9,3),
  
  (80,80,1,10.5,8,10.5,7.5,12,7.5,4,10.5,8,10.5,10.5,9,10.5,12,4),
  
  (81,81,1,10.5,8,12,10.5,12,7.5,3.5,10.5,8,10.5,7.5,9,10.5,10.5,3.5),
  
  (82,82,1,10.5,7,12,10.5,12,10.5,3,12,8,10.5,10.5,12,10.5,7.5,4),
  
  (83,83,1,7.5,8,12,6,9,10.5,2,10.5,7,10.5,10.5,10.5,6,7.5,3),
  
  (84,84,1,9,8,12,9,12,10.5,3.5,10.5,8,9,10.5,10.5,10.5,7.5,4),
  
  (85,85,1,10.5,7,9,6,12,7.5,3.5,10.5,8,7.5,7.5,9,10.5,12,3);
  
  /*Table structure for table `dosen` */
  
  DROP TABLE IF EXISTS `dosen`;
  
  CREATE TABLE `dosen` (
    `id_dosen` int(11) NOT NULL AUTO_INCREMENT,
    `nid` int(11) DEFAULT NULL,
    `nama` varchar(30) DEFAULT NULL,
    `id_login` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id_dosen`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
  
  /*Data for the table `dosen` */
  
  insert  into `dosen`(`id_dosen`,`nid`,`nama`,`id_login`) values 
  
  (1,1,'Misbah',90),
  
  (2,2,'Misbach',90),
  
  (3,3,'Hendra',91),
  
  (4,4,'Tri',100),
  
  (5,5,'Umi',101),
  
  (6,6,'Jazuli',102),
  
  (7,7,'Jazuli',103),
  
  (8,8,'Agustin',104),
  
  (9,9,'Misbach',105),
  
  (10,10,'Harun',106),
  
  (11,11,'Tri',107),
  
  (12,12,'Jazuli',108),
  
  (13,13,'Tri',109),
  
  (14,14,'Utomo Pujianto',110),
  
  (15,15,'Utomo Pujianto',111);
  
  /*Table structure for table `dosen_mk` */
  
  DROP TABLE IF EXISTS `dosen_mk`;
  
  CREATE TABLE `dosen_mk` (
    `id_dosen_mk` int(2) NOT NULL AUTO_INCREMENT,
    `id_dosen` int(3) DEFAULT NULL,
    `id_mk` int(5) DEFAULT NULL,
    `id_periode` int(4) DEFAULT NULL,
    PRIMARY KEY (`id_dosen_mk`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
  
  /*Data for the table `dosen_mk` */
  
  insert  into `dosen_mk`(`id_dosen_mk`,`id_dosen`,`id_mk`,`id_periode`) values 
  
  (1,1,1,1),
  
  (2,2,2,1),
  
  (3,3,3,1),
  
  (4,4,4,1),
  
  (5,5,5,1),
  
  (6,6,6,1),
  
  (7,7,7,1),
  
  (8,8,8,1),
  
  (9,9,9,1),
  
  (10,10,10,1),
  
  (11,11,11,1),
  
  (12,12,12,1),
  
  (13,13,13,1),
  
  (14,14,14,1),
  
  (15,15,15,1);
  
  /*Table structure for table `hasil` */
  
  DROP TABLE IF EXISTS `hasil`;
  
  CREATE TABLE `hasil` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_mhs` int(11) DEFAULT NULL,
    `id_periode` int(11) DEFAULT NULL,
    `mk1` varchar(200) DEFAULT NULL,
    `mk2` varchar(200) DEFAULT NULL,
    `mk3` varchar(200) DEFAULT NULL,
    `mk4` varchar(200) DEFAULT NULL,
    `mk5` varchar(200) DEFAULT NULL,
    `mk6` varchar(200) DEFAULT NULL,
    `mk7` varchar(200) DEFAULT NULL,
    `mk8` varchar(200) DEFAULT NULL,
    `mk9` varchar(200) DEFAULT NULL,
    `mk10` varchar(200) DEFAULT NULL,
    `mk11` varchar(200) DEFAULT NULL,
    `mk12` varchar(200) DEFAULT NULL,
    `mk13` varchar(200) DEFAULT NULL,
    `mk14` varchar(200) DEFAULT NULL,
    `mk15` varchar(200) DEFAULT NULL,
    `hasil` varchar(200) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=426 DEFAULT CHARSET=latin1;
  
  /*Data for the table `hasil` */
  
  insert  into `hasil`(`id`,`id_mhs`,`id_periode`,`mk1`,`mk2`,`mk3`,`mk4`,`mk5`,`mk6`,`mk7`,`mk8`,`mk9`,`mk10`,`mk11`,`mk12`,`mk13`,`mk14`,`mk15`,`hasil`) values 
  
  (341,1,1,'KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (342,2,1,'LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (343,3,1,'LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','LEBIH','BERMASALAH'),
  
  (344,4,1,'LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','BERMASALAH'),
  
  (345,5,1,'KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (346,6,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (347,7,1,'LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (348,8,1,'LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (349,9,1,'LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (350,10,1,'KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (351,11,1,'LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','BERPRESTASI'),
  
  (352,12,1,'LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','BERPRESTASI'),
  
  (353,13,1,'LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (354,14,1,'KURANG','KURANG','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','BERMASALAH'),
  
  (355,15,1,'LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (356,16,1,'KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','KURANG','BERPRESTASI'),
  
  (357,17,1,'LEBIH','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (358,18,1,'KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','BERPRESTASI'),
  
  (359,19,1,'LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','BERPRESTASI'),
  
  (360,20,1,'KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','LEBIH','BERMASALAH'),
  
  (361,21,1,'LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','BERPRESTASI'),
  
  (362,22,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (363,23,1,'KURANG','KURANG','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','LEBIH','BERMASALAH'),
  
  (364,24,1,'LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','KURANG','KURANG','KURANG','LEBIH','BERMASALAH'),
  
  (365,25,1,'LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','BERPRESTASI'),
  
  (366,26,1,'KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (367,27,1,'LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (368,28,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (369,29,1,'LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','KURANG','BERMASALAH'),
  
  (370,30,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','BERPRESTASI'),
  
  (371,31,1,'LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','KURANG','BERPRESTASI'),
  
  (372,32,1,'KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (373,33,1,'KURANG','KURANG','KURANG','KURANG','KURANG','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','BERMASALAH'),
  
  (374,34,1,'LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (375,35,1,'KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','KURANG','BERPRESTASI'),
  
  (376,36,1,'LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','BERPRESTASI'),
  
  (377,37,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (378,38,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (379,39,1,'KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','BERMASALAH'),
  
  (380,40,1,'KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','LEBIH','BERMASALAH'),
  
  (381,41,1,'LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (382,42,1,'LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (383,43,1,'LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (384,44,1,'KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (385,45,1,'LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (386,46,1,'LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (387,47,1,'KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (388,48,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (389,49,1,'LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (390,50,1,'KURANG','LEBIH','KURANG','KURANG','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (391,51,1,'LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','BERPRESTASI'),
  
  (392,52,1,'KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','BERMASALAH'),
  
  (393,53,1,'LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (394,54,1,'LEBIH','KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','KURANG','BERMASALAH'),
  
  (395,55,1,'LEBIH','LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (396,56,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','BERPRESTASI'),
  
  (397,57,1,'LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','BERMASALAH'),
  
  (398,58,1,'KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','BERPRESTASI'),
  
  (399,59,1,'LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','LEBIH','LEBIH','BERPRESTASI'),
  
  (400,60,1,'LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','BERPRESTASI'),
  
  (401,61,1,'LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (402,62,1,'LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (403,63,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (404,64,1,'LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (405,65,1,'LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (406,66,1,'LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','BERPRESTASI'),
  
  (407,67,1,'LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','LEBIH','BERMASALAH'),
  
  (408,68,1,'LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (409,69,1,'LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','KURANG','BERMASALAH'),
  
  (410,70,1,'LEBIH','LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','LEBIH','KURANG','BERMASALAH'),
  
  (411,71,1,'LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','BERPRESTASI'),
  
  (412,72,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (413,73,1,'LEBIH','LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (414,74,1,'LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','LEBIH','KURANG','BERPRESTASI'),
  
  (415,75,1,'LEBIH','LEBIH','KURANG','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','BERPRESTASI'),
  
  (416,76,1,'LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (417,77,1,'LEBIH','KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (418,78,1,'LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','LEBIH','LEBIH','KURANG','KURANG','KURANG','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (419,79,1,'LEBIH','LEBIH','KURANG','KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','LEBIH','LEBIH','KURANG','BERMASALAH'),
  
  (420,80,1,'LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','LEBIH','LEBIH','LEBIH','BERPRESTASI'),
  
  (421,81,1,'LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','LEBIH','LEBIH','KURANG','BERPRESTASI'),
  
  (422,82,1,'LEBIH','KURANG','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (423,83,1,'KURANG','LEBIH','LEBIH','KURANG','KURANG','LEBIH','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','KURANG','BERMASALAH'),
  
  (424,84,1,'KURANG','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','BERPRESTASI'),
  
  (425,85,1,'LEBIH','KURANG','KURANG','KURANG','LEBIH','KURANG','LEBIH','KURANG','LEBIH','KURANG','KURANG','KURANG','LEBIH','LEBIH','KURANG','BERMASALAH');
  
  /*Table structure for table `jenis_user` */
  
  DROP TABLE IF EXISTS `jenis_user`;
  
  CREATE TABLE `jenis_user` (
    `id_j_user` int(3) NOT NULL,
    `n_j_user` varchar(10) DEFAULT NULL,
    PRIMARY KEY (`id_j_user`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  /*Data for the table `jenis_user` */
  
  insert  into `jenis_user`(`id_j_user`,`n_j_user`) values 
  
  (1,'Admin'),
  
  (2,'Mahasiswa'),
  
  (3,'Dosen'),
  
  (4,'Kaprodi');
  
  /*Table structure for table `login` */
  
  DROP TABLE IF EXISTS `login`;
  
  CREATE TABLE `login` (
    `id_login` int(3) NOT NULL AUTO_INCREMENT,
    `id_priv` int(3) DEFAULT NULL,
    `username` varchar(200) DEFAULT NULL,
    `password` varchar(200) DEFAULT NULL,
    PRIMARY KEY (`id_login`)
  ) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=latin1;
  
  /*Data for the table `login` */
  
  insert  into `login`(`id_login`,`id_priv`,`username`,`password`) values 
  
  (1,2,'10622089','12345'),
  
  (2,2,'10622039','12345'),
  
  (3,2,'10622031','12345'),
  
  (4,2,'10622081','12345'),
  
  (5,2,'10622046','12345'),
  
  (6,2,'10622047','12345'),
  
  (7,2,'10622078','12345'),
  
  (8,2,'10622054','12345'),
  
  (9,2,'10622045','12345'),
  
  (10,2,'10621082','12345'),
  
  (11,2,'10621099','12345'),
  
  (12,2,'10621092','12345'),
  
  (13,2,'10621078','12345'),
  
  (14,2,'10621060','12345'),
  
  (15,2,'10621054','12345'),
  
  (16,2,'10621068','12345'),
  
  (17,2,'10621094','12345'),
  
  (18,2,'10621093','12345'),
  
  (19,2,'10621071','12345'),
  
  (20,2,'10621084','12345'),
  
  (21,2,'10621070','12345'),
  
  (22,2,'10621100','12345'),
  
  (23,2,'10621067','12345'),
  
  (24,2,'10621090','12345'),
  
  (25,2,'10621098','12345'),
  
  (26,2,'10621069','12345'),
  
  (27,2,'10621080','12345'),
  
  (28,2,'10622056','12345'),
  
  (29,2,'10622059','12345'),
  
  (30,2,'10621039','12345'),
  
  (31,2,'10621049','12345'),
  
  (32,2,'10621055','12345'),
  
  (33,2,'10621029','12345'),
  
  (34,2,'10621042','12345'),
  
  (35,2,'10621044','12345'),
  
  (36,2,'10621033','12345'),
  
  (37,2,'10621051','12345'),
  
  (38,2,'10621058','12345'),
  
  (39,2,'10621057','12345'),
  
  (40,2,'10621059','12345'),
  
  (41,2,'10621041','12345'),
  
  (42,2,'10621034','12345'),
  
  (43,2,'10621035','12345'),
  
  (44,2,'10621022','12345'),
  
  (45,2,'10621021','12345'),
  
  (46,2,'10621001','12345'),
  
  (47,2,'10621007','12345'),
  
  (48,2,'10621052','12345'),
  
  (49,2,'10621066','12345'),
  
  (50,2,'10621088','12345'),
  
  (51,2,'10621073','12345'),
  
  (52,2,'10621061','12345'),
  
  (53,2,'10622048','12345'),
  
  (54,2,'10622063','12345'),
  
  (55,2,'10622040','12345'),
  
  (56,2,'10622053','12345'),
  
  (57,2,'10622061','12345'),
  
  (58,2,'10622084','12345'),
  
  (59,2,'10622077','12345'),
  
  (60,2,'10622083','12345'),
  
  (61,2,'10622082','12345'),
  
  (62,2,'10622088','12345'),
  
  (63,2,'10622004','12345'),
  
  (64,2,'10622079','12345'),
  
  (65,2,'10622010','12345'),
  
  (66,2,'10622085','12345'),
  
  (67,2,'10622043','12345'),
  
  (68,2,'10622066','12345'),
  
  (69,2,'69','12345'),
  
  (70,2,'10622015','12345'),
  
  (71,2,'10622032','12345'),
  
  (72,2,'10622019','12345'),
  
  (73,2,'10622001','12345'),
  
  (74,2,'10622014','12345'),
  
  (75,2,'10622005','12345'),
  
  (76,2,'10622023','12345'),
  
  (77,2,'10621008','12345'),
  
  (78,2,'10622024','12345'),
  
  (79,2,'10622006','12345'),
  
  (80,2,'10622030','12345'),
  
  (81,2,'10622029','12345'),
  
  (82,2,'10621002','12345'),
  
  (83,2,'10621075','12345'),
  
  (84,2,'10621010','12345'),
  
  (85,2,'10622018','12345'),
  
  (86,2,NULL,NULL),
  
  (88,2,NULL,NULL),
  
  (89,2,NULL,NULL),
  
  (90,3,'dosen2','dosen2'),
  
  (91,3,'dosen3','dosen3'),
  
  (97,1,'admin','admin'),
  
  (100,3,'dosen4','dosen4'),
  
  (101,3,'dosen5','dosen5'),
  
  (102,3,'dosen6','dosen6'),
  
  (103,3,'dosen7','dosen7'),
  
  (104,3,'dosen8','dosen8'),
  
  (105,3,'dosen9','dosen9'),
  
  (106,3,'dosen10','dosen10'),
  
  (107,3,'dosen11','dosen11'),
  
  (108,3,'dosen12','dosen12'),
  
  (109,3,'dosen13','dosen13'),
  
  (110,3,'dosen14','dosen14'),
  
  (111,3,'dosen15','dosen15');
  
  /*Table structure for table `mahasiswa` */
  
  DROP TABLE IF EXISTS `mahasiswa`;
  
  CREATE TABLE `mahasiswa` (
    `id_mhs` int(3) NOT NULL AUTO_INCREMENT,
    `nim` int(8) DEFAULT NULL,
    `nama` varchar(40) DEFAULT NULL,
    `id_login` int(11) NOT NULL DEFAULT '0',
    `tahun_masuk` int(4) DEFAULT NULL,
    PRIMARY KEY (`id_mhs`)
  ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;
  
  /*Data for the table `mahasiswa` */
  
  insert  into `mahasiswa`(`id_mhs`,`nim`,`nama`,`id_login`,`tahun_masuk`) values 
  
  (1,10622089,'AHMAD SAIFUDDIN',1,2010),
  
  (2,10622039,'AKHMAD FIRMANSYAH',2,2010),
  
  (3,10622031,'MUHAMMAD SHOFIHIN',3,2010),
  
  (4,10622081,'DIONIKO SEPTYONDA',4,2010),
  
  (5,10622046,'DEDY RUSDIANTO',5,2010),
  
  (6,10622047,'FEBRIAN RAINBOW PERDANA PUTRA',6,2010),
  
  (7,10622078,'MOCHAMAD BENI MASHUD',7,2010),
  
  (8,10622054,'MOHAMMAD LUKMAN KHAKIM',8,2010),
  
  (9,10622045,'FAHMI MAULANA',9,2010),
  
  (10,10621082,'MUHAMMAD NIZAM AL ANSHORI',10,2010),
  
  (11,10621099,'NURUL WILDATUR RAHMA',11,2010),
  
  (12,10621092,'BARRY SETYA D.',12,2010),
  
  (13,10621078,'MUHAMMAD NUR YAQIN',13,2010),
  
  (14,10621060,'MOH. ABDI SETIAWAN',14,2010),
  
  (15,10621054,'DIMAS ANGGORO SAPTO ADI',15,2010),
  
  (16,10621068,'MOH. HUSSEN ALHABSYIH',16,2010),
  
  (17,10621094,'MUHAMMAD KAFILUDIN',17,2010),
  
  (18,10621093,'CANDRA FERNANDO',18,2010),
  
  (19,10621071,'HUSNUL KHULUQ',19,2010),
  
  (20,10621084,'ARIF RAHMAT WAHYUDI',20,2010),
  
  (21,10621070,'SATRIA PRATAMA NUR JULIANTO',21,2010),
  
  (22,10621100,'MUHAMMAD ZABAN JAUHARI',22,2010),
  
  (23,10621067,'ACHMAD DEDDY DWI DARMAWAN',23,2010),
  
  (24,10621090,'FRIDAY ARIES LAKSANA WIBAWA',24,2010),
  
  (25,10621098,'ALIFAH UMI FATHONAH',25,2010),
  
  (26,10621069,'MOHAMAD BAHARUDDIN RABANI',26,2010),
  
  (27,10621080,'ICHA ZULFIA',27,2010),
  
  (28,10622056,'ANGGRAINI TIKA PUSPITASARI',28,2010),
  
  (29,10622059,'ACHMAD FARIS BUDIANSYAH',29,2010),
  
  (30,10621039,'MUCHSIN AL BASYAR',30,2010),
  
  (31,10621049,'MUHAMMAD SYARIF',31,2010),
  
  (32,10621055,'MUHAMMAD HABIBULLOH',32,2010),
  
  (33,10621029,'FIRMAN RENGGA SAPUTRA',33,2010),
  
  (34,10621042,'FAHMI DWI NOVIANTO',34,2010),
  
  (35,10621044,'AHMAD FAHMI AFIFUDDIN',35,2010),
  
  (36,10621033,'NUR JAYATI',36,2010),
  
  (37,10621051,'AUNUR RASYID',37,2010),
  
  (38,10621058,'SEPTYAN CHUSNUL FAJAR',38,2010),
  
  (39,10621057,'TRENDY VALENTINO',39,2010),
  
  (40,10621059,'M. KAMIL KUSUMA NEGARA',40,2010),
  
  (41,10621041,'MEINGGAN VILIAN SARI',41,2010),
  
  (42,10621034,'SINTIYA EMILIYA HARDI',42,2010),
  
  (43,10621035,'MUHAMMAD FATHUR ROZI',43,2010),
  
  (44,10621022,'AKHMAD KHOIRUL BAKHRIS',44,2010),
  
  (45,10621021,'NUR EVA LATIFAH',45,2010),
  
  (46,10621001,'LOLITA APRILLA',46,2010),
  
  (47,10621007,'DEVI PURNAMA SARI',47,2010),
  
  (48,10621052,'SYARIFATUL MUDAWAMAH',48,2010),
  
  (49,10621066,'KOMARUDDIN',49,2010),
  
  (50,10621088,'ANDI SAPUTRO',50,2010),
  
  (51,10621073,'MUHAMMAD HAMDI ASROFI',51,2010),
  
  (52,10621061,'ZAINUL ABIDIN',52,2010),
  
  (53,10622048,'KUSUMANIGRUM',53,2010),
  
  (54,10622063,'FIYA ROHMAWATI',54,2010),
  
  (55,10622040,'NIHAYATUS SAADAH',55,2010),
  
  (56,10622053,'FATIMATUZ ZAHROH',56,2010),
  
  (57,10622061,'JAZULI KHIBIYAN',57,2010),
  
  (58,10622084,'ACHMAD SYAIFUL AZIZ',58,2010),
  
  (59,10622077,'EVI PUTRI MAULIDIA',59,2010),
  
  (60,10622083,'SITI AISYAH',60,2010),
  
  (61,10622082,'YUDI ROSYADI',61,2010),
  
  (62,10622088,'IVAN ROSYADY',62,2010),
  
  (63,10622004,'MOHAMAD SYAIFUDDIN',63,2010),
  
  (64,10622079,'ERMELINDO DE ARAUJO GOMES',64,2010),
  
  (65,10622010,'PERDANA KUSWANTORO',65,2010),
  
  (66,10622085,'ABDUS SHOMAD',66,2010),
  
  (67,10622043,'MUHAMMAD SHOLIKHUDDIN',67,2010),
  
  (68,10622066,'MUHAMMAD TAUFIQ',68,2010),
  
  (69,69,'MUHAMAD SUYUL',69,2010),
  
  (70,10622015,'ISA AHMAD ANSHORI',70,2010),
  
  (71,10622032,'FITRIANAH',71,2010),
  
  (72,10622019,'LENI NAFITA WATI',72,2010),
  
  (73,10622001,'NINA MAULFAH',73,2010),
  
  (74,10622014,'RIZKY DHARMAWAN',74,2010),
  
  (75,10622005,'MOCHAMMAD RIZKI SABATA',75,2010),
  
  (76,10622023,'MASHFUFAH',76,2010),
  
  (77,10621008,'FIKI ARFI ARDIANTO',77,2010),
  
  (78,10622024,'NI`MATUZZAHROH',78,2010),
  
  (79,10622006,'WAWAN ERDIYANSYAH',79,2010),
  
  (80,10622030,'PANJI PURNOMO',80,2010),
  
  (81,10622029,'FAJAR KURNIAWAN',81,2010),
  
  (82,10621002,'FARHANA',82,2010),
  
  (83,10621075,'MOHAMMAD NURDIYANSYAH',83,2010),
  
  (84,10621010,'HARIYONO HANAFI',84,2010),
  
  (85,10622018,'ROHMAN',85,2010),
  
  (90,101,'Maryam',1,2010),
  
  (92,102,'Sintiya',89,2010);
  
  /*Table structure for table `mata_kuliah` */
  
  DROP TABLE IF EXISTS `mata_kuliah`;
  
  CREATE TABLE `mata_kuliah` (
    `id_mk` int(2) NOT NULL AUTO_INCREMENT,
    `kode_mk` varchar(5) DEFAULT NULL,
    `n_mk` varchar(30) DEFAULT NULL,
    PRIMARY KEY (`id_mk`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
  
  /*Data for the table `mata_kuliah` */
  
  insert  into `mata_kuliah`(`id_mk`,`kode_mk`,`n_mk`) values 
  
  (1,'MK_1','Pend. Pancasila & Kewarganegar'),
  
  (2,'MK_2','Pendidikan Agama Islam'),
  
  (3,'MK_3','Elektronika Digital'),
  
  (4,'MK_4','Kalkulus I'),
  
  (5,'MK_5','Logika Informatika'),
  
  (6,'MK_6','Pengantar Teknologi Informasi'),
  
  (7,'MK_7','Prak. Pengantar Teknologi Info'),
  
  (8,'MK_8','Bahasa Indonesia'),
  
  (9,'MK_9','Al Islam & Kemuhammadiyahan I'),
  
  (10,'MK_10','Matematika Diskrit'),
  
  (11,'MK_11','Kalkulus II'),
  
  (12,'MK_12','Organisasi & Arsitektur Komput'),
  
  (13,'MK_13','Aljabar Linier & Matriks'),
  
  (14,'MK_14','Algoritma & Pemrograman'),
  
  (15,'MK_15','Prakt. Algoritma & Pemrograman');
  
  /*Table structure for table `periode` */
  
  DROP TABLE IF EXISTS `periode`;
  
  CREATE TABLE `periode` (
    `id_periode` int(4) NOT NULL AUTO_INCREMENT,
    `semester` int(2) DEFAULT NULL,
    `tahun` int(15) DEFAULT NULL,
    PRIMARY KEY (`id_periode`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  
  /*Data for the table `periode` */
  
  insert  into `periode`(`id_periode`,`semester`,`tahun`) values 
  
  (1,1,2010),
  
  (2,1,2011),
  
  (3,1,2012),
  
  (4,1,2013),
  
  (5,1,2014),
  
  (6,2,2010),
  
  (7,2,2011),
  
  (8,2,2012),
  
  (9,2,2013),
  
  (10,2,2014);
  
  /*Table structure for table `peserta_mk` */
  
  DROP TABLE IF EXISTS `peserta_mk`;
  
  CREATE TABLE `peserta_mk` (
    `id_peserta` int(3) NOT NULL AUTO_INCREMENT,
    `id_dosen_mk` int(2) DEFAULT NULL,
    `id_mhs` int(3) DEFAULT NULL,
    `nilai` double DEFAULT NULL,
    PRIMARY KEY (`id_peserta`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2637 DEFAULT CHARSET=latin1;
  
  /*Data for the table `peserta_mk` */
  
  insert  into `peserta_mk`(`id_peserta`,`id_dosen_mk`,`id_mhs`,`nilai`) values 
  
  (1362,1,1,9),
  
  (1363,1,2,10.5),
  
  (1364,1,3,10.5),
  
  (1365,1,4,10.5),
  
  (1366,1,5,9),
  
  (1367,1,6,10.5),
  
  (1368,1,7,10.5),
  
  (1369,1,8,10.5),
  
  (1370,1,9,10.5),
  
  (1371,1,10,7.5),
  
  (1372,1,11,10.5),
  
  (1373,1,12,10.5),
  
  (1374,1,13,10.5),
  
  (1375,1,14,7.5),
  
  (1376,1,15,10.5),
  
  (1377,1,16,9),
  
  (1378,1,17,10.5),
  
  (1379,1,18,7.5),
  
  (1380,1,19,10.5),
  
  (1381,1,20,9),
  
  (1382,1,21,10.5),
  
  (1383,1,22,10.5),
  
  (1384,1,23,9),
  
  (1385,1,24,10.5),
  
  (1386,1,25,10.5),
  
  (1387,1,26,9),
  
  (1388,1,27,10.5),
  
  (1389,1,28,12),
  
  (1390,1,29,10.5),
  
  (1391,1,30,10.5),
  
  (1392,1,31,10.5),
  
  (1393,1,32,9),
  
  (1394,1,33,9),
  
  (1395,1,34,10.5),
  
  (1396,1,35,9),
  
  (1397,1,36,10.5),
  
  (1398,1,37,10.5),
  
  (1399,1,38,10.5),
  
  (1400,1,39,9),
  
  (1401,1,40,7.5),
  
  (1402,1,41,10.5),
  
  (1403,1,42,10.5),
  
  (1404,1,43,10.5),
  
  (1405,1,44,9),
  
  (1406,1,45,10.5),
  
  (1407,1,46,10.5),
  
  (1408,1,47,9),
  
  (1409,1,48,12),
  
  (1410,1,49,10.5),
  
  (1411,1,50,9),
  
  (1412,1,51,10.5),
  
  (1413,1,52,7.5),
  
  (1414,1,53,12),
  
  (1415,1,54,10.5),
  
  (1416,1,55,10.5),
  
  (1417,1,56,12),
  
  (1418,1,57,10.5),
  
  (1419,1,58,9),
  
  (1420,1,59,10.5),
  
  (1421,1,60,10.5),
  
  (1422,1,61,10.5),
  
  (1423,1,62,10.5),
  
  (1424,1,63,10.5),
  
  (1425,1,64,10.5),
  
  (1426,1,65,10.5),
  
  (1427,1,66,10.5),
  
  (1428,1,67,10.5),
  
  (1429,1,68,10.5),
  
  (1430,1,69,10.5),
  
  (1431,1,70,10.5),
  
  (1432,1,71,10.5),
  
  (1433,1,72,10.5),
  
  (1434,1,73,10.5),
  
  (1435,1,74,10.5),
  
  (1436,1,75,10.5),
  
  (1437,1,76,10.5),
  
  (1438,1,77,10.5),
  
  (1439,1,78,10.5),
  
  (1440,1,79,10.5),
  
  (1441,1,80,10.5),
  
  (1442,1,81,10.5),
  
  (1443,1,82,10.5),
  
  (1444,1,83,7.5),
  
  (1445,1,84,9),
  
  (1446,1,85,10.5),
  
  (1447,2,1,7),
  
  (1448,2,2,8),
  
  (1449,2,3,8),
  
  (1450,2,4,7),
  
  (1451,2,5,7),
  
  (1452,2,6,8),
  
  (1453,2,7,8),
  
  (1454,2,8,8),
  
  (1455,2,9,8),
  
  (1456,2,10,8),
  
  (1457,2,11,8),
  
  (1458,2,12,8),
  
  (1459,2,13,8),
  
  (1460,2,14,7),
  
  (1461,2,15,7),
  
  (1462,2,16,8),
  
  (1463,2,17,7),
  
  (1464,2,18,8),
  
  (1465,2,19,8),
  
  (1466,2,20,8),
  
  (1467,2,21,8),
  
  (1468,2,22,8),
  
  (1469,2,23,3),
  
  (1470,2,24,7),
  
  (1471,2,25,8),
  
  (1472,2,26,8),
  
  (1473,2,27,8),
  
  (1474,2,28,8),
  
  (1475,2,29,8),
  
  (1476,2,30,8),
  
  (1477,2,31,7),
  
  (1478,2,32,8),
  
  (1479,2,33,7),
  
  (1480,2,34,7),
  
  (1481,2,35,8),
  
  (1482,2,36,7),
  
  (1483,2,37,8),
  
  (1484,2,38,8),
  
  (1485,2,39,7),
  
  (1486,2,40,7),
  
  (1487,2,41,7),
  
  (1488,2,42,7),
  
  (1489,2,43,7),
  
  (1490,2,44,7),
  
  (1491,2,45,8),
  
  (1492,2,46,8),
  
  (1493,2,47,8),
  
  (1494,2,48,8),
  
  (1495,2,49,6),
  
  (1496,2,50,8),
  
  (1497,2,51,8),
  
  (1498,2,52,8),
  
  (1499,2,53,7),
  
  (1500,2,54,7),
  
  (1501,2,55,8),
  
  (1502,2,56,8),
  
  (1503,2,57,8),
  
  (1504,2,58,8),
  
  (1505,2,59,7),
  
  (1506,2,60,8),
  
  (1507,2,61,7),
  
  (1508,2,62,8),
  
  (1509,2,63,8),
  
  (1510,2,64,8),
  
  (1511,2,65,8),
  
  (1512,2,66,8),
  
  (1513,2,67,8),
  
  (1514,2,68,7),
  
  (1515,2,69,7),
  
  (1516,2,70,8),
  
  (1517,2,71,8),
  
  (1518,2,72,8),
  
  (1519,2,73,8),
  
  (1520,2,74,8),
  
  (1521,2,75,8),
  
  (1522,2,76,8),
  
  (1523,2,77,0),
  
  (1524,2,78,8),
  
  (1525,2,79,8),
  
  (1526,2,80,8),
  
  (1527,2,81,8),
  
  (1528,2,82,7),
  
  (1529,2,83,8),
  
  (1530,2,84,8),
  
  (1531,2,85,7),
  
  (1532,3,1,10.5),
  
  (1533,3,2,7.5),
  
  (1534,3,3,9),
  
  (1535,3,4,9),
  
  (1536,3,5,7.5),
  
  (1537,3,6,12),
  
  (1538,3,7,12),
  
  (1539,3,8,7.5),
  
  (1540,3,9,12),
  
  (1541,3,10,12),
  
  (1542,3,11,12),
  
  (1543,3,12,12),
  
  (1544,3,13,12),
  
  (1545,3,14,12),
  
  (1546,3,15,12),
  
  (1547,3,16,12),
  
  (1548,3,17,12),
  
  (1549,3,18,12),
  
  (1550,3,19,12),
  
  (1551,3,20,9),
  
  (1552,3,21,12),
  
  (1553,3,22,12),
  
  (1554,3,23,12),
  
  (1555,3,24,10.5),
  
  (1556,3,25,12),
  
  (1557,3,26,12),
  
  (1558,3,27,12),
  
  (1559,3,28,12),
  
  (1560,3,29,7.5),
  
  (1561,3,30,12),
  
  (1562,3,31,12),
  
  (1563,3,32,12),
  
  (1564,3,33,10.5),
  
  (1565,3,34,10.5),
  
  (1566,3,35,10.5),
  
  (1567,3,36,12),
  
  (1568,3,37,12),
  
  (1569,3,38,12),
  
  (1570,3,39,10.5),
  
  (1571,3,40,10.5),
  
  (1572,3,41,12),
  
  (1573,3,42,12),
  
  (1574,3,43,12),
  
  (1575,3,44,10.5),
  
  (1576,3,45,12),
  
  (1577,3,46,12),
  
  (1578,3,47,12),
  
  (1579,3,48,12),
  
  (1580,3,49,12),
  
  (1581,3,50,10.5),
  
  (1582,3,51,12),
  
  (1583,3,52,10.5),
  
  (1584,3,53,12),
  
  (1585,3,54,10.5),
  
  (1586,3,55,9),
  
  (1587,3,56,12),
  
  (1588,3,57,7.5),
  
  (1589,3,58,12),
  
  (1590,3,59,12),
  
  (1591,3,60,12),
  
  (1592,3,61,12),
  
  (1593,3,62,12),
  
  (1594,3,63,12),
  
  (1595,3,64,12),
  
  (1596,3,65,10.5),
  
  (1597,3,66,9),
  
  (1598,3,67,10.5),
  
  (1599,3,68,10.5),
  
  (1600,3,69,7.5),
  
  (1601,3,70,9),
  
  (1602,3,71,10.5),
  
  (1603,3,72,12),
  
  (1604,3,73,10.5),
  
  (1605,3,74,10.5),
  
  (1606,3,75,10.5),
  
  (1607,3,76,10.5),
  
  (1608,3,77,7.5),
  
  (1609,3,78,12),
  
  (1610,3,79,9),
  
  (1611,3,80,10.5),
  
  (1612,3,81,12),
  
  (1613,3,82,12),
  
  (1614,3,83,12),
  
  (1615,3,84,12),
  
  (1616,3,85,9),
  
  (1617,4,1,10.5),
  
  (1618,4,2,6),
  
  (1619,4,3,6),
  
  (1620,4,4,10.5),
  
  (1621,4,5,0),
  
  (1622,4,6,10.5),
  
  (1623,4,7,7.5),
  
  (1624,4,8,6),
  
  (1625,4,9,6),
  
  (1626,4,10,10.5),
  
  (1627,4,11,9),
  
  (1628,4,12,6),
  
  (1629,4,13,7.5),
  
  (1630,4,14,12),
  
  (1631,4,15,10.5),
  
  (1632,4,16,7.5),
  
  (1633,4,17,6),
  
  (1634,4,18,6),
  
  (1635,4,19,6),
  
  (1636,4,20,10.5),
  
  (1637,4,21,9),
  
  (1638,4,22,10.5),
  
  (1639,4,23,7.5),
  
  (1640,4,24,7.5),
  
  (1641,4,25,6),
  
  (1642,4,26,6),
  
  (1643,4,27,9),
  
  (1644,4,28,9),
  
  (1645,4,29,6),
  
  (1646,4,30,12),
  
  (1647,4,31,12),
  
  (1648,4,32,12),
  
  (1649,4,33,7.5),
  
  (1650,4,34,10.5),
  
  (1651,4,35,12),
  
  (1652,4,36,9),
  
  (1653,4,37,12),
  
  (1654,4,38,12),
  
  (1655,4,39,12),
  
  (1656,4,40,10.5),
  
  (1657,4,41,12),
  
  (1658,4,42,9),
  
  (1659,4,43,12),
  
  (1660,4,44,9),
  
  (1661,4,45,10.5),
  
  (1662,4,46,12),
  
  (1663,4,47,7.5),
  
  (1664,4,48,12),
  
  (1665,4,49,12),
  
  (1666,4,50,6),
  
  (1667,4,51,7.5),
  
  (1668,4,52,10.5),
  
  (1669,4,53,9),
  
  (1670,4,54,7.5),
  
  (1671,4,55,9),
  
  (1672,4,56,10.5),
  
  (1673,4,57,6),
  
  (1674,4,58,7.5),
  
  (1675,4,59,9),
  
  (1676,4,60,6),
  
  (1677,4,61,9),
  
  (1678,4,62,10.5),
  
  (1679,4,63,10.5),
  
  (1680,4,64,6),
  
  (1681,4,65,7.5),
  
  (1682,4,66,7.5),
  
  (1683,4,67,6),
  
  (1684,4,68,9),
  
  (1685,4,69,9),
  
  (1686,4,70,9),
  
  (1687,4,71,7.5),
  
  (1688,4,72,10.5),
  
  (1689,4,73,12),
  
  (1690,4,74,6),
  
  (1691,4,75,9),
  
  (1692,4,76,7.5),
  
  (1693,4,77,6),
  
  (1694,4,78,7.5),
  
  (1695,4,79,6),
  
  (1696,4,80,7.5),
  
  (1697,4,81,10.5),
  
  (1698,4,82,10.5),
  
  (1699,4,83,6),
  
  (1700,4,84,9),
  
  (1701,4,85,6),
  
  (1702,5,1,7.5),
  
  (1703,5,2,12),
  
  (1704,5,3,12),
  
  (1705,5,4,9),
  
  (1706,5,5,7.5),
  
  (1707,5,6,12),
  
  (1708,5,7,10.5),
  
  (1709,5,8,12),
  
  (1710,5,9,12),
  
  (1711,5,10,12),
  
  (1712,5,11,9),
  
  (1713,5,12,9),
  
  (1714,5,13,9),
  
  (1715,5,14,10.5),
  
  (1716,5,15,10.5),
  
  (1717,5,16,9),
  
  (1718,5,17,9),
  
  (1719,5,18,9),
  
  (1720,5,19,9),
  
  (1721,5,20,9),
  
  (1722,5,21,9),
  
  (1723,5,22,12),
  
  (1724,5,23,9),
  
  (1725,5,24,9),
  
  (1726,5,25,10.5),
  
  (1727,5,26,9),
  
  (1728,5,27,9),
  
  (1729,5,28,12),
  
  (1730,5,29,10.5),
  
  (1731,5,30,12),
  
  (1732,5,31,12),
  
  (1733,5,32,12),
  
  (1734,5,33,10.5),
  
  (1735,5,34,10.5),
  
  (1736,5,35,12),
  
  (1737,5,36,12),
  
  (1738,5,37,12),
  
  (1739,5,38,12),
  
  (1740,5,39,9),
  
  (1741,5,40,10.5),
  
  (1742,5,41,12),
  
  (1743,5,42,12),
  
  (1744,5,43,12),
  
  (1745,5,44,10.5),
  
  (1746,5,45,10.5),
  
  (1747,5,46,10.5),
  
  (1748,5,47,10.5),
  
  (1749,5,48,12),
  
  (1750,5,49,10.5),
  
  (1751,5,50,9),
  
  (1752,5,51,9),
  
  (1753,5,52,9),
  
  (1754,5,53,12),
  
  (1755,5,54,12),
  
  (1756,5,55,12),
  
  (1757,5,56,12),
  
  (1758,5,57,10.5),
  
  (1759,5,58,9),
  
  (1760,5,59,10.5),
  
  (1761,5,60,10.5),
  
  (1762,5,61,10.5),
  
  (1763,5,62,9),
  
  (1764,5,63,12),
  
  (1765,5,64,9),
  
  (1766,5,65,12),
  
  (1767,5,66,9),
  
  (1768,5,67,10.5),
  
  (1769,5,68,12),
  
  (1770,5,69,12),
  
  (1771,5,70,12),
  
  (1772,5,71,12),
  
  (1773,5,72,12),
  
  (1774,5,73,12),
  
  (1775,5,74,12),
  
  (1776,5,75,12),
  
  (1777,5,76,12),
  
  (1778,5,77,12),
  
  (1779,5,78,12),
  
  (1780,5,79,10.5),
  
  (1781,5,80,12),
  
  (1782,5,81,12),
  
  (1783,5,82,12),
  
  (1784,5,83,9),
  
  (1785,5,84,12),
  
  (1786,5,85,12),
  
  (1787,6,1,10.5),
  
  (1788,6,2,7.5),
  
  (1789,6,3,7.5),
  
  (1790,6,4,9),
  
  (1791,6,5,7.5),
  
  (1792,6,6,7.5),
  
  (1793,6,7,10.5),
  
  (1794,6,8,7.5),
  
  (1795,6,9,7.5),
  
  (1796,6,10,10.5),
  
  (1797,6,11,10.5),
  
  (1798,6,12,10.5),
  
  (1799,6,13,10.5),
  
  (1800,6,14,10.5),
  
  (1801,6,15,10.5),
  
  (1802,6,16,10.5),
  
  (1803,6,17,10.5),
  
  (1804,6,18,10.5),
  
  (1805,6,19,10.5),
  
  (1806,6,20,10.5),
  
  (1807,6,21,10.5),
  
  (1808,6,22,12),
  
  (1809,6,23,10.5),
  
  (1810,6,24,10.5),
  
  (1811,6,25,10.5),
  
  (1812,6,26,10.5),
  
  (1813,6,27,10.5),
  
  (1814,6,28,7.5),
  
  (1815,6,29,7.5),
  
  (1816,6,30,9),
  
  (1817,6,31,12),
  
  (1818,6,32,12),
  
  (1819,6,33,10.5),
  
  (1820,6,34,10.5),
  
  (1821,6,35,10.5),
  
  (1822,6,36,10.5),
  
  (1823,6,37,10.5),
  
  (1824,6,38,10.5),
  
  (1825,6,39,10.5),
  
  (1826,6,40,10.5),
  
  (1827,6,41,10.5),
  
  (1828,6,42,10.5),
  
  (1829,6,43,10.5),
  
  (1830,6,44,10.5),
  
  (1831,6,45,10.5),
  
  (1832,6,46,10.5),
  
  (1833,6,47,10.5),
  
  (1834,6,48,10.5),
  
  (1835,6,49,10.5),
  
  (1836,6,50,10.5),
  
  (1837,6,51,10.5),
  
  (1838,6,52,10.5),
  
  (1839,6,53,7.5),
  
  (1840,6,54,7.5),
  
  (1841,6,55,7.5),
  
  (1842,6,56,7.5),
  
  (1843,6,57,7.5),
  
  (1844,6,58,10.5),
  
  (1845,6,59,10.5),
  
  (1846,6,60,10.5),
  
  (1847,6,61,10.5),
  
  (1848,6,62,10.5),
  
  (1849,6,63,7.5),
  
  (1850,6,64,10.5),
  
  (1851,6,65,7.5),
  
  (1852,6,66,10.5),
  
  (1853,6,67,7.5),
  
  (1854,6,68,7.5),
  
  (1855,6,69,7.5),
  
  (1856,6,70,7.5),
  
  (1857,6,71,7.5),
  
  (1858,6,72,7.5),
  
  (1859,6,73,7.5),
  
  (1860,6,74,7.5),
  
  (1861,6,75,7.5),
  
  (1862,6,76,7.5),
  
  (1863,6,77,7.5),
  
  (1864,6,78,7.5),
  
  (1865,6,79,7.5),
  
  (1866,6,80,7.5),
  
  (1867,6,81,7.5),
  
  (1868,6,82,10.5),
  
  (1869,6,83,10.5),
  
  (1870,6,84,10.5),
  
  (1871,6,85,7.5),
  
  (1872,7,1,3),
  
  (1873,7,2,3.5),
  
  (1874,7,3,3.5),
  
  (1875,7,4,3.5),
  
  (1876,7,5,3),
  
  (1877,7,6,2.5),
  
  (1878,7,7,2.5),
  
  (1879,7,8,3.5),
  
  (1880,7,9,3.5),
  
  (1881,7,10,4),
  
  (1882,7,11,4),
  
  (1883,7,12,3.5),
  
  (1884,7,13,3.5),
  
  (1885,7,14,3.5),
  
  (1886,7,15,3.5),
  
  (1887,7,16,3),
  
  (1888,7,17,3),
  
  (1889,7,18,3.5),
  
  (1890,7,19,3.5),
  
  (1891,7,20,3.5),
  
  (1892,7,21,3),
  
  (1893,7,22,4),
  
  (1894,7,23,3.5),
  
  (1895,7,24,3.5),
  
  (1896,7,25,4),
  
  (1897,7,26,3.5),
  
  (1898,7,27,2),
  
  (1899,7,28,3.5),
  
  (1900,7,29,3),
  
  (1901,7,30,3.5),
  
  (1902,7,31,3.5),
  
  (1903,7,32,3.5),
  
  (1904,7,33,3.5),
  
  (1905,7,34,3.5),
  
  (1906,7,35,3),
  
  (1907,7,36,2),
  
  (1908,7,37,3.5),
  
  (1909,7,38,4),
  
  (1910,7,39,3),
  
  (1911,7,40,3.5),
  
  (1912,7,41,3.5),
  
  (1913,7,42,3.5),
  
  (1914,7,43,3.5),
  
  (1915,7,44,4),
  
  (1916,7,45,3.5),
  
  (1917,7,46,2),
  
  (1918,7,47,3),
  
  (1919,7,48,3.5),
  
  (1920,7,49,3.5),
  
  (1921,7,50,1),
  
  (1922,7,51,3.5),
  
  (1923,7,52,3),
  
  (1924,7,53,3.5),
  
  (1925,7,54,4),
  
  (1926,7,55,3.5),
  
  (1927,7,56,3.5),
  
  (1928,7,57,4),
  
  (1929,7,58,4),
  
  (1930,7,59,2.5),
  
  (1931,7,60,3.5),
  
  (1932,7,61,2.5),
  
  (1933,7,62,4),
  
  (1934,7,63,4),
  
  (1935,7,64,4),
  
  (1936,7,65,4),
  
  (1937,7,66,3.5),
  
  (1938,7,67,3.5),
  
  (1939,7,68,4),
  
  (1940,7,69,3.5),
  
  (1941,7,70,3.5),
  
  (1942,7,71,3.5),
  
  (1943,7,72,3.5),
  
  (1944,7,73,3.5),
  
  (1945,7,74,3.5),
  
  (1946,7,75,3.5),
  
  (1947,7,76,3.5),
  
  (1948,7,77,4),
  
  (1949,7,78,3.5),
  
  (1950,7,79,3.5),
  
  (1951,7,80,4),
  
  (1952,7,81,3.5),
  
  (1953,7,82,3),
  
  (1954,7,83,2),
  
  (1955,7,84,3.5),
  
  (1956,7,85,3.5),
  
  (1957,8,1,10.5),
  
  (1958,8,2,10.5),
  
  (1959,8,3,10.5),
  
  (1960,8,4,10.5),
  
  (1961,8,5,10.5),
  
  (1962,8,6,12),
  
  (1963,8,7,12),
  
  (1964,8,8,12),
  
  (1965,8,9,10.5),
  
  (1966,8,10,12),
  
  (1967,8,11,12),
  
  (1968,8,12,12),
  
  (1969,8,13,10.5),
  
  (1970,8,14,10.5),
  
  (1971,8,15,12),
  
  (1972,8,16,12),
  
  (1973,8,17,9),
  
  (1974,8,18,12),
  
  (1975,8,19,12),
  
  (1976,8,20,10.5),
  
  (1977,8,21,12),
  
  (1978,8,22,12),
  
  (1979,8,23,12),
  
  (1980,8,24,10.5),
  
  (1981,8,25,10.5),
  
  (1982,8,26,12),
  
  (1983,8,27,10.5),
  
  (1984,8,28,12),
  
  (1985,8,29,12),
  
  (1986,8,30,10.5),
  
  (1987,8,31,12),
  
  (1988,8,32,12),
  
  (1989,8,33,12),
  
  (1990,8,34,12),
  
  (1991,8,35,10.5),
  
  (1992,8,36,10.5),
  
  (1993,8,37,12),
  
  (1994,8,38,12),
  
  (1995,8,39,10.5),
  
  (1996,8,40,10.5),
  
  (1997,8,41,12),
  
  (1998,8,42,10.5),
  
  (1999,8,43,12),
  
  (2000,8,44,10.5),
  
  (2001,8,45,12),
  
  (2002,8,46,12),
  
  (2003,8,47,12),
  
  (2004,8,48,12),
  
  (2005,8,49,10.5),
  
  (2006,8,50,10.5),
  
  (2007,8,51,10.5),
  
  (2008,8,52,12),
  
  (2009,8,53,12),
  
  (2010,8,54,12),
  
  (2011,8,55,12),
  
  (2012,8,56,12),
  
  (2013,8,57,10.5),
  
  (2014,8,58,10.5),
  
  (2015,8,59,12),
  
  (2016,8,60,12),
  
  (2017,8,61,10.5),
  
  (2018,8,62,12),
  
  (2019,8,63,10.5),
  
  (2020,8,64,12),
  
  (2021,8,65,12),
  
  (2022,8,66,10.5),
  
  (2023,8,67,10.5),
  
  (2024,8,68,12),
  
  (2025,8,69,10.5),
  
  (2026,8,70,10.5),
  
  (2027,8,71,12),
  
  (2028,8,72,12),
  
  (2029,8,73,12),
  
  (2030,8,74,12),
  
  (2031,8,75,10.5),
  
  (2032,8,76,12),
  
  (2033,8,77,10.5),
  
  (2034,8,78,12),
  
  (2035,8,79,10.5),
  
  (2036,8,80,10.5),
  
  (2037,8,81,10.5),
  
  (2038,8,82,12),
  
  (2039,8,83,10.5),
  
  (2040,8,84,10.5),
  
  (2041,8,85,10.5),
  
  (2042,9,1,8),
  
  (2043,9,2,8),
  
  (2044,9,3,8),
  
  (2045,9,4,7),
  
  (2046,9,5,8),
  
  (2047,9,6,8),
  
  (2048,9,7,8),
  
  (2049,9,8,8),
  
  (2050,9,9,7),
  
  (2051,9,10,8),
  
  (2052,9,11,8),
  
  (2053,9,12,8),
  
  (2054,9,13,7),
  
  (2055,9,14,8),
  
  (2056,9,15,8),
  
  (2057,9,16,8),
  
  (2058,9,17,7),
  
  (2059,9,18,7),
  
  (2060,9,19,8),
  
  (2061,9,20,8),
  
  (2062,9,21,7),
  
  (2063,9,22,8),
  
  (2064,9,23,8),
  
  (2065,9,24,7),
  
  (2066,9,25,8),
  
  (2067,9,26,8),
  
  (2068,9,27,7),
  
  (2069,9,28,8),
  
  (2070,9,29,8),
  
  (2071,9,30,8),
  
  (2072,9,31,8),
  
  (2073,9,32,8),
  
  (2074,9,33,7),
  
  (2075,9,34,8),
  
  (2076,9,35,8),
  
  (2077,9,36,8),
  
  (2078,9,37,8),
  
  (2079,9,38,8),
  
  (2080,9,39,8),
  
  (2081,9,40,8),
  
  (2082,9,41,8),
  
  (2083,9,42,8),
  
  (2084,9,43,8),
  
  (2085,9,44,7),
  
  (2086,9,45,8),
  
  (2087,9,46,8),
  
  (2088,9,47,8),
  
  (2089,9,48,8),
  
  (2090,9,49,7),
  
  (2091,9,50,7),
  
  (2092,9,51,8),
  
  (2093,9,52,8),
  
  (2094,9,53,8),
  
  (2095,9,54,8),
  
  (2096,9,55,8),
  
  (2097,9,56,8),
  
  (2098,9,57,8),
  
  (2099,9,58,7),
  
  (2100,9,59,7),
  
  (2101,9,60,8),
  
  (2102,9,61,8),
  
  (2103,9,62,8),
  
  (2104,9,63,8),
  
  (2105,9,64,8),
  
  (2106,9,65,8),
  
  (2107,9,66,8),
  
  (2108,9,67,7),
  
  (2109,9,68,7),
  
  (2110,9,69,8),
  
  (2111,9,70,7),
  
  (2112,9,71,8),
  
  (2113,9,72,8),
  
  (2114,9,73,8),
  
  (2115,9,74,8),
  
  (2116,9,75,8),
  
  (2117,9,76,8),
  
  (2118,9,77,8),
  
  (2119,9,78,8),
  
  (2120,9,79,8),
  
  (2121,9,80,8),
  
  (2122,9,81,8),
  
  (2123,9,82,8),
  
  (2124,9,83,7),
  
  (2125,9,84,8),
  
  (2126,9,85,8),
  
  (2127,10,1,12),
  
  (2128,10,2,12),
  
  (2129,10,3,10.5),
  
  (2130,10,4,12),
  
  (2131,10,5,10.5),
  
  (2132,10,6,10.5),
  
  (2133,10,7,12),
  
  (2134,10,8,10.5),
  
  (2135,10,9,12),
  
  (2136,10,10,12),
  
  (2137,10,11,10.5),
  
  (2138,10,12,12),
  
  (2139,10,13,10.5),
  
  (2140,10,14,10.5),
  
  (2141,10,15,12),
  
  (2142,10,16,12),
  
  (2143,10,17,12),
  
  (2144,10,18,12),
  
  (2145,10,19,12),
  
  (2146,10,20,10.5),
  
  (2147,10,21,12),
  
  (2148,10,22,12),
  
  (2149,10,23,10.5),
  
  (2150,10,24,10.5),
  
  (2151,10,25,10.5),
  
  (2152,10,26,12),
  
  (2153,10,27,10.5),
  
  (2154,10,28,12),
  
  (2155,10,29,10.5),
  
  (2156,10,30,12),
  
  (2157,10,31,12),
  
  (2158,10,32,12),
  
  (2159,10,33,12),
  
  (2160,10,34,12),
  
  (2161,10,35,12),
  
  (2162,10,36,12),
  
  (2163,10,37,10.5),
  
  (2164,10,38,10.5),
  
  (2165,10,39,10.5),
  
  (2166,10,40,10.5),
  
  (2167,10,41,12),
  
  (2168,10,42,12),
  
  (2169,10,43,12),
  
  (2170,10,44,9),
  
  (2171,10,45,9),
  
  (2172,10,46,9),
  
  (2173,10,47,12),
  
  (2174,10,48,12),
  
  (2175,10,49,10.5),
  
  (2176,10,50,10.5),
  
  (2177,10,51,10.5),
  
  (2178,10,52,10.5),
  
  (2179,10,53,10.5),
  
  (2180,10,54,10.5),
  
  (2181,10,55,12),
  
  (2182,10,56,12),
  
  (2183,10,57,12),
  
  (2184,10,58,12),
  
  (2185,10,59,9),
  
  (2186,10,60,10.5),
  
  (2187,10,61,9),
  
  (2188,10,62,12),
  
  (2189,10,63,12),
  
  (2190,10,64,10.5),
  
  (2191,10,65,10.5),
  
  (2192,10,66,12),
  
  (2193,10,67,12),
  
  (2194,10,68,10.5),
  
  (2195,10,69,9),
  
  (2196,10,70,9),
  
  (2197,10,71,12),
  
  (2198,10,72,10.5),
  
  (2199,10,73,12),
  
  (2200,10,74,9),
  
  (2201,10,75,9),
  
  (2202,10,76,9),
  
  (2203,10,77,9),
  
  (2204,10,78,9),
  
  (2205,10,79,9),
  
  (2206,10,80,10.5),
  
  (2207,10,81,10.5),
  
  (2208,10,82,10.5),
  
  (2209,10,83,10.5),
  
  (2210,10,84,9),
  
  (2211,10,85,7.5),
  
  (2212,11,1,10.5),
  
  (2213,11,2,9),
  
  (2214,11,3,10.5),
  
  (2215,11,4,10.5),
  
  (2216,11,5,7.5),
  
  (2217,11,6,12),
  
  (2218,11,7,10.5),
  
  (2219,11,8,9),
  
  (2220,11,9,9),
  
  (2221,11,10,12),
  
  (2222,11,11,12),
  
  (2223,11,12,12),
  
  (2224,11,13,12),
  
  (2225,11,14,12),
  
  (2226,11,15,12),
  
  (2227,11,16,12),
  
  (2228,11,17,12),
  
  (2229,11,18,12),
  
  (2230,11,19,12),
  
  (2231,11,20,12),
  
  (2232,11,21,12),
  
  (2233,11,22,12),
  
  (2234,11,23,10.5),
  
  (2235,11,24,12),
  
  (2236,11,25,12),
  
  (2237,11,26,12),
  
  (2238,11,27,12),
  
  (2239,11,28,10.5),
  
  (2240,11,29,9),
  
  (2241,11,30,10.5),
  
  (2242,11,31,12),
  
  (2243,11,32,12),
  
  (2244,11,33,10.5),
  
  (2245,11,34,10.5),
  
  (2246,11,35,12),
  
  (2247,11,36,10.5),
  
  (2248,11,37,12),
  
  (2249,11,38,12),
  
  (2250,11,39,12),
  
  (2251,11,40,10.5),
  
  (2252,11,41,12),
  
  (2253,11,42,10.5),
  
  (2254,11,43,12),
  
  (2255,11,44,10.5),
  
  (2256,11,45,12),
  
  (2257,11,46,10.5),
  
  (2258,11,47,12),
  
  (2259,11,48,12),
  
  (2260,11,49,12),
  
  (2261,11,50,12),
  
  (2262,11,51,12),
  
  (2263,11,52,12),
  
  (2264,11,53,10.5),
  
  (2265,11,54,10.5),
  
  (2266,11,55,10.5),
  
  (2267,11,56,12),
  
  (2268,11,57,9),
  
  (2269,11,58,12),
  
  (2270,11,59,12),
  
  (2271,11,60,12),
  
  (2272,11,61,12),
  
  (2273,11,62,12),
  
  (2274,11,63,10.5),
  
  (2275,11,64,7.5),
  
  (2276,11,65,10.5),
  
  (2277,11,66,12),
  
  (2278,11,67,9),
  
  (2279,11,68,9),
  
  (2280,11,69,9),
  
  (2281,11,70,7.5),
  
  (2282,11,71,9),
  
  (2283,11,72,7.5),
  
  (2284,11,73,9),
  
  (2285,11,74,7.5),
  
  (2286,11,75,6),
  
  (2287,11,76,9),
  
  (2288,11,77,6),
  
  (2289,11,78,10.5),
  
  (2290,11,79,7.5),
  
  (2291,11,80,10.5),
  
  (2292,11,81,7.5),
  
  (2293,11,82,10.5),
  
  (2294,11,83,10.5),
  
  (2295,11,84,10.5),
  
  (2296,11,85,7.5),
  
  (2297,12,1,10.5),
  
  (2298,12,2,10.5),
  
  (2299,12,3,10.5),
  
  (2300,12,4,10.5),
  
  (2301,12,5,9),
  
  (2302,12,6,12),
  
  (2303,12,7,10.5),
  
  (2304,12,8,10.5),
  
  (2305,12,9,10.5),
  
  (2306,12,10,12),
  
  (2307,12,11,12),
  
  (2308,12,12,10.5),
  
  (2309,12,13,10.5),
  
  (2310,12,14,9),
  
  (2311,12,15,10.5),
  
  (2312,12,16,9),
  
  (2313,12,17,10.5),
  
  (2314,12,18,10.5),
  
  (2315,12,19,9),
  
  (2316,12,20,10.5),
  
  (2317,12,21,9),
  
  (2318,12,22,12),
  
  (2319,12,23,10.5),
  
  (2320,12,24,10.5),
  
  (2321,12,25,10.5),
  
  (2322,12,26,10.5),
  
  (2323,12,27,10.5),
  
  (2324,12,28,12),
  
  (2325,12,29,10.5),
  
  (2326,12,30,10.5),
  
  (2327,12,31,12),
  
  (2328,12,32,12),
  
  (2329,12,33,10.5),
  
  (2330,12,34,10.5),
  
  (2331,12,35,10.5),
  
  (2332,12,36,10.5),
  
  (2333,12,37,12),
  
  (2334,12,38,12),
  
  (2335,12,39,10.5),
  
  (2336,12,40,10.5),
  
  (2337,12,41,12),
  
  (2338,12,42,10.5),
  
  (2339,12,43,10.5),
  
  (2340,12,44,10.5),
  
  (2341,12,45,12),
  
  (2342,12,46,12),
  
  (2343,12,47,10.5),
  
  (2344,12,48,12),
  
  (2345,12,49,10.5),
  
  (2346,12,50,10.5),
  
  (2347,12,51,10.5),
  
  (2348,12,52,10.5),
  
  (2349,12,53,12),
  
  (2350,12,54,10.5),
  
  (2351,12,55,10.5),
  
  (2352,12,56,12),
  
  (2353,12,57,12),
  
  (2354,12,58,12),
  
  (2355,12,59,10.5),
  
  (2356,12,60,12),
  
  (2357,12,61,10.5),
  
  (2358,12,62,10.5),
  
  (2359,12,63,12),
  
  (2360,12,64,10.5),
  
  (2361,12,65,10.5),
  
  (2362,12,66,10.5),
  
  (2363,12,67,12),
  
  (2364,12,68,10.5),
  
  (2365,12,69,10.5),
  
  (2366,12,70,9),
  
  (2367,12,71,12),
  
  (2368,12,72,12),
  
  (2369,12,73,12),
  
  (2370,12,74,10.5),
  
  (2371,12,75,12),
  
  (2372,12,76,12),
  
  (2373,12,77,12),
  
  (2374,12,78,10.5),
  
  (2375,12,79,10.5),
  
  (2376,12,80,9),
  
  (2377,12,81,9),
  
  (2378,12,82,12),
  
  (2379,12,83,10.5),
  
  (2380,12,84,10.5),
  
  (2381,12,85,9),
  
  (2382,13,1,7.5),
  
  (2383,13,2,7.5),
  
  (2384,13,3,7.5),
  
  (2385,13,4,10.5),
  
  (2386,13,5,7.5),
  
  (2387,13,6,12),
  
  (2388,13,7,12),
  
  (2389,13,8,9),
  
  (2390,13,9,7.5),
  
  (2391,13,10,10.5),
  
  (2392,13,11,12),
  
  (2393,13,12,7.5),
  
  (2394,13,13,7.5),
  
  (2395,13,14,12),
  
  (2396,13,15,10.5),
  
  (2397,13,16,10.5),
  
  (2398,13,17,3),
  
  (2399,13,18,9),
  
  (2400,13,19,6),
  
  (2401,13,20,9),
  
  (2402,13,21,7.5),
  
  (2403,13,22,12),
  
  (2404,13,23,9),
  
  (2405,13,24,7.5),
  
  (2406,13,25,10.5),
  
  (2407,13,26,10.5),
  
  (2408,13,27,10.5),
  
  (2409,13,28,10.5),
  
  (2410,13,29,9),
  
  (2411,13,30,9),
  
  (2412,13,31,12),
  
  (2413,13,32,10.5),
  
  (2414,13,33,10.5),
  
  (2415,13,34,9),
  
  (2416,13,35,10.5),
  
  (2417,13,36,10.5),
  
  (2418,13,37,10.5),
  
  (2419,13,38,10.5),
  
  (2420,13,39,10.5),
  
  (2421,13,40,9),
  
  (2422,13,41,12),
  
  (2423,13,42,10.5),
  
  (2424,13,43,12),
  
  (2425,13,44,7.5),
  
  (2426,13,45,12),
  
  (2427,13,46,12),
  
  (2428,13,47,10.5),
  
  (2429,13,48,12),
  
  (2430,13,49,10.5),
  
  (2431,13,50,9),
  
  (2432,13,51,12),
  
  (2433,13,52,10.5),
  
  (2434,13,53,10.5),
  
  (2435,13,54,9),
  
  (2436,13,55,10.5),
  
  (2437,13,56,10.5),
  
  (2438,13,57,9),
  
  (2439,13,58,9),
  
  (2440,13,59,9),
  
  (2441,13,60,10.5),
  
  (2442,13,61,12),
  
  (2443,13,62,10.5),
  
  (2444,13,63,10.5),
  
  (2445,13,64,7.5),
  
  (2446,13,65,10.5),
  
  (2447,13,66,6),
  
  (2448,13,67,9),
  
  (2449,13,68,10.5),
  
  (2450,13,69,9),
  
  (2451,13,70,6),
  
  (2452,13,71,9),
  
  (2453,13,72,10.5),
  
  (2454,13,73,10.5),
  
  (2455,13,74,10.5),
  
  (2456,13,75,9),
  
  (2457,13,76,10.5),
  
  (2458,13,77,9),
  
  (2459,13,78,10.5),
  
  (2460,13,79,10.5),
  
  (2461,13,80,10.5),
  
  (2462,13,81,10.5),
  
  (2463,13,82,10.5),
  
  (2464,13,83,6),
  
  (2465,13,84,10.5),
  
  (2466,13,85,10.5),
  
  (2467,14,1,7.5),
  
  (2468,14,2,7.5),
  
  (2469,14,3,7.5),
  
  (2470,14,4,10.5),
  
  (2471,14,5,7.5),
  
  (2472,14,6,12),
  
  (2473,14,7,12),
  
  (2474,14,8,9),
  
  (2475,14,9,7.5),
  
  (2476,14,10,10.5),
  
  (2477,14,11,12),
  
  (2478,14,12,7.5),
  
  (2479,14,13,7.5),
  
  (2480,14,14,12),
  
  (2481,14,15,10.5),
  
  (2482,14,16,10.5),
  
  (2483,14,17,3),
  
  (2484,14,18,9),
  
  (2485,14,19,6),
  
  (2486,14,20,9),
  
  (2487,14,21,7.5),
  
  (2488,14,22,12),
  
  (2489,14,23,9),
  
  (2490,14,24,7.5),
  
  (2491,14,25,10.5),
  
  (2492,14,26,10.5),
  
  (2493,14,27,10.5),
  
  (2494,14,28,10.5),
  
  (2495,14,29,9),
  
  (2496,14,30,9),
  
  (2497,14,31,12),
  
  (2498,14,32,10.5),
  
  (2499,14,33,10.5),
  
  (2500,14,34,9),
  
  (2501,14,35,10.5),
  
  (2502,14,36,10.5),
  
  (2503,14,37,10.5),
  
  (2504,14,38,10.5),
  
  (2505,14,39,10.5),
  
  (2506,14,40,9),
  
  (2507,14,41,12),
  
  (2508,14,42,10.5),
  
  (2509,14,43,12),
  
  (2510,14,44,7.5),
  
  (2511,14,45,12),
  
  (2512,14,46,12),
  
  (2513,14,47,10.5),
  
  (2514,14,48,12),
  
  (2515,14,49,10.5),
  
  (2516,14,50,9),
  
  (2517,14,51,12),
  
  (2518,14,52,10.5),
  
  (2519,14,53,10.5),
  
  (2520,14,54,9),
  
  (2521,14,55,10.5),
  
  (2522,14,56,10.5),
  
  (2523,14,57,9),
  
  (2524,14,58,9),
  
  (2525,14,59,9),
  
  (2526,14,60,10.5),
  
  (2527,14,61,12),
  
  (2528,14,62,10.5),
  
  (2529,14,63,10.5),
  
  (2530,14,64,7.5),
  
  (2531,14,65,10.5),
  
  (2532,14,66,6),
  
  (2533,14,67,9),
  
  (2534,14,68,10.5),
  
  (2535,14,69,9),
  
  (2536,14,70,6),
  
  (2537,14,71,9),
  
  (2538,14,72,10.5),
  
  (2539,14,73,10.5),
  
  (2540,14,74,10.5),
  
  (2541,14,75,9),
  
  (2542,14,76,10.5),
  
  (2543,14,77,9),
  
  (2544,14,78,10.5),
  
  (2545,14,79,10.5),
  
  (2546,14,80,10.5),
  
  (2547,14,81,10.5),
  
  (2548,14,82,10.5),
  
  (2549,14,83,6),
  
  (2550,14,84,10.5),
  
  (2551,14,85,10.5),
  
  (2552,15,1,3),
  
  (2553,15,2,3.5),
  
  (2554,15,3,4),
  
  (2555,15,4,2.5),
  
  (2556,15,5,3),
  
  (2557,15,6,4),
  
  (2558,15,7,4),
  
  (2559,15,8,3.5),
  
  (2560,15,9,3.5),
  
  (2561,15,10,4),
  
  (2562,15,11,3.5),
  
  (2563,15,12,4),
  
  (2564,15,13,3.5),
  
  (2565,15,14,3.5),
  
  (2566,15,15,4),
  
  (2567,15,16,3),
  
  (2568,15,17,3),
  
  (2569,15,18,4),
  
  (2570,15,19,4),
  
  (2571,15,20,4),
  
  (2572,15,21,4),
  
  (2573,15,22,4),
  
  (2574,15,23,4),
  
  (2575,15,24,4),
  
  (2576,15,25,3.5),
  
  (2577,15,26,4),
  
  (2578,15,27,4),
  
  (2579,15,28,4),
  
  (2580,15,29,3),
  
  (2581,15,30,2.5),
  
  (2582,15,31,3),
  
  (2583,15,32,4),
  
  (2584,15,33,3.5),
  
  (2585,15,34,2.5),
  
  (2586,15,35,3),
  
  (2587,15,36,2.5),
  
  (2588,15,37,4),
  
  (2589,15,38,4),
  
  (2590,15,39,4),
  
  (2591,15,40,4),
  
  (2592,15,41,4),
  
  (2593,15,42,4),
  
  (2594,15,43,4),
  
  (2595,15,44,3.5),
  
  (2596,15,45,4),
  
  (2597,15,46,4),
  
  (2598,15,47,4),
  
  (2599,15,48,4),
  
  (2600,15,49,4),
  
  (2601,15,50,3),
  
  (2602,15,51,3.5),
  
  (2603,15,52,3.5),
  
  (2604,15,53,4),
  
  (2605,15,54,3),
  
  (2606,15,55,4),
  
  (2607,15,56,3.5),
  
  (2608,15,57,3.5),
  
  (2609,15,58,4),
  
  (2610,15,59,4),
  
  (2611,15,60,3.5),
  
  (2612,15,61,4),
  
  (2613,15,62,4),
  
  (2614,15,63,4),
  
  (2615,15,64,2.5),
  
  (2616,15,65,4),
  
  (2617,15,66,4),
  
  (2618,15,67,4),
  
  (2619,15,68,4),
  
  (2620,15,69,3),
  
  (2621,15,70,3.5),
  
  (2622,15,71,3.5),
  
  (2623,15,72,4),
  
  (2624,15,73,4),
  
  (2625,15,74,3),
  
  (2626,15,75,4),
  
  (2627,15,76,4),
  
  (2628,15,77,2.5),
  
  (2629,15,78,4),
  
  (2630,15,79,3),
  
  (2631,15,80,4),
  
  (2632,15,81,3.5),
  
  (2633,15,82,4),
  
  (2634,15,83,3),
  
  (2635,15,84,4),
  
  (2636,15,85,3);
  
  /*Table structure for table `priv` */
  
  DROP TABLE IF EXISTS `priv`;
  
  CREATE TABLE `priv` (
    `id_priv` int(3) NOT NULL,
    `n_priv` varchar(10) DEFAULT NULL,
    PRIMARY KEY (`id_priv`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  /*Data for the table `priv` */
  
  insert  into `priv`(`id_priv`,`n_priv`) values 
  
  (1,'admin'),
  
  (2,'mahasiswa'),
  
  (3,'dosen'),
  
  (4,'kaprodi');
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  