API tools faq
paste
Advertisement
Guest User

Test

a guest
Oct 13th, 2018
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 17.00 KB | None | 0 0
raw download clone embed print report
  1. -- --------------------------------------------------------
  2. -- Host:                         127.0.0.1
  3. -- Server version:               5.5.27 - MySQL Community Server (GPL)
  4. -- Server OS:                    Win32
  5. -- HeidiSQL Version:             8.3.0.4779
  6. -- --------------------------------------------------------
  7.  
  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  11. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  12.  
  13. -- Dumping database structure for penjadwalan_genetik_web
  14. CREATE DATABASE IF NOT EXISTS `penjadwalan_genetik_web` /*!40100 DEFAULT CHARACTER SET latin1 */;
  15. USE `penjadwalan_genetik_web`;
  16.  
  17.  
  18. -- Dumping structure for table penjadwalan_genetik_web.dosen
  19. CREATE TABLE IF NOT EXISTS `dosen` (
  20.   `kode` int(2) NOT NULL AUTO_INCREMENT,
  21.   `nidn` varchar(50) DEFAULT NULL,
  22.   `nama` varchar(50) DEFAULT NULL,
  23.   `alamat` varchar(50) DEFAULT NULL,
  24.   `telp` varchar(50) DEFAULT NULL,
  25.   PRIMARY KEY (`kode`)
  26. ) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;
  27.  
  28. -- Dumping data for table penjadwalan_genetik_web.dosen: ~52 rows (approximately)
  29. DELETE FROM `dosen`;
  30. /*!40000 ALTER TABLE `dosen` DISABLE KEYS */;
  31. INSERT INTO `dosen` (`kode`, `nidn`, `nama`, `alamat`, `telp`) VALUES
  32.     (1, '', 'Erlin, Dr. M.Kom ', '', ''),
  33.     (2, '', 'Triyani Arita Fitri, M.Kom \r\n', '', ''),
  34.     (3, '', 'Karpen, M.Kom ', '', ''),
  35.     (4, '', 'Helda Yenni, M.Kom ', '', ''),
  36.     (37, NULL, 'Rini Yanti, S.Si', NULL, NULL),
  37.     (38, NULL, 'Tat Marlina, MH', NULL, NULL),
  38.     (39, NULL, 'Susi Erlinda, M.Kom ', NULL, NULL),
  39.     (40, NULL, 'Yoso frenaguna, S.Kom ', NULL, NULL),
  40.     (41, NULL, 'Elgamar, S.Kom ', NULL, NULL),
  41.     (42, NULL, 'Fransiskus Z, S.Kom ', NULL, NULL),
  42.     (43, NULL, 'Hamdani, M.Kom ', NULL, NULL),
  43.     (44, NULL, 'Herwin, M.Kom ', NULL, NULL),
  44.     (45, NULL, 'Irawati Sastra, S.Kom ', NULL, NULL),
  45.     (46, NULL, 'Tashid, M.Kom ', NULL, NULL),
  46.     (47, '12345', 'Agung Setiawan, S.Kom, MM', '', ''),
  47.     (48, NULL, 'Suprasman,Drs. MM', NULL, NULL),
  48.     (49, NULL, 'Dewi Sari Wahyuni, M.Pd', NULL, NULL),
  49.     (50, NULL, 'Jusniwati, S.Pd', NULL, NULL),
  50.     (51, NULL, 'Masduki, S.Pd', NULL, NULL),
  51.     (52, NULL, 'Hidayati Azizah, S.Si', NULL, NULL),
  52.     (53, NULL, 'Firman Edigan, M.Pd ', NULL, NULL),
  53.     (54, NULL, 'Rahmiati, M.Kom ', NULL, NULL),
  54.     (55, NULL, 'Dwi Haryono, M.Kom ', NULL, NULL),
  55.     (56, NULL, 'Riati, M.Si', NULL, NULL),
  56.     (57, NULL, 'Rahmaddeni, S.Kom ', NULL, NULL),
  57.     (58, NULL, 'Robinson, M.Sc', NULL, NULL),
  58.     (59, NULL, 'Sabam Parjuangan, M.Kom ', NULL, NULL),
  59.     (60, NULL, 'Corina Tri Handayani, MM', NULL, NULL),
  60.     (61, NULL, 'Herispon, M.Si ', NULL, NULL),
  61.     (62, NULL, 'Kastanti, SE ', NULL, NULL),
  62.     (63, NULL, 'Torkis Nasution, M.Kom ', NULL, NULL),
  63.     (64, NULL, 'T. Sy. Eiva Fatdha, M.Kom ', NULL, NULL),
  64.     (65, NULL, 'Syahrul Imardi, M.T', NULL, NULL),
  65.     (66, NULL, 'Nova Rahmi, S.Kom ', NULL, NULL),
  66.     (67, NULL, 'Iwan Iskandar, MT', NULL, NULL),
  67.     (68, NULL, 'Nurjayadi, S.Kom ', NULL, NULL),
  68.     (69, NULL, 'Mar\'aini, MM', NULL, NULL),
  69.     (70, NULL, 'Lusiana, M.Kom ', NULL, NULL),
  70.     (71, NULL, 'Surya Syahrani, S.Kom ', NULL, NULL),
  71.     (72, NULL, 'Misbah Hayati, S.Pd', NULL, NULL),
  72.     (73, NULL, 'Koko Harianto, S.Kom ', NULL, NULL),
  73.     (74, NULL, 'Khusaeri Andesa, S.Kom ', NULL, NULL),
  74.     (75, NULL, 'Susanti, M.IT', NULL, NULL),
  75.     (76, NULL, 'Sujiwo, S.Kom ', NULL, NULL),
  76.     (77, NULL, 'Imelda Yance, M.Pd', NULL, NULL),
  77.     (78, NULL, 'Wirta Agustin, S.Kom ', NULL, NULL),
  78.     (79, NULL, 'Unang Rio, M.Kom ', NULL, NULL),
  79.     (80, NULL, 'Susandri, M.Kom ', NULL, NULL),
  80.     (81, NULL, 'Edwar Ali, M.Kom ', NULL, NULL),
  81.     (82, NULL, 'Dadang Iskandar,Prof. M.Sc', NULL, NULL),
  82.     (83, NULL, 'Alber, M.Pd', NULL, NULL),
  83.     (84, NULL, 'Selamet Wahyudi,Dr', NULL, NULL);
  84. /*!40000 ALTER TABLE `dosen` ENABLE KEYS */;
  85.  
  86.  
  87. -- Dumping structure for table penjadwalan_genetik_web.hari
  88. CREATE TABLE IF NOT EXISTS `hari` (
  89.   `kode` int(10) NOT NULL AUTO_INCREMENT,
  90.   `nama` varchar(50) DEFAULT NULL,
  91.   PRIMARY KEY (`kode`)
  92. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  93.  
  94. -- Dumping data for table penjadwalan_genetik_web.hari: ~6 rows (approximately)
  95. DELETE FROM `hari`;
  96. /*!40000 ALTER TABLE `hari` DISABLE KEYS */;
  97. INSERT INTO `hari` (`kode`, `nama`) VALUES
  98.     (1, 'Senin'),
  99.     (2, 'Selasa'),
  100.     (3, 'Rabu'),
  101.     (4, 'Kamis'),
  102.     (5, 'Jumat'),
  103.     (6, 'Sabtu');
  104. /*!40000 ALTER TABLE `hari` ENABLE KEYS */;
  105.  
  106.  
  107. -- Dumping structure for table penjadwalan_genetik_web.jadwalkuliah
  108. CREATE TABLE IF NOT EXISTS `jadwalkuliah` (
  109.   `kode` int(10) NOT NULL AUTO_INCREMENT,
  110.   `kode_pengampu` int(10) DEFAULT NULL,
  111.   `kode_jam` int(10) DEFAULT NULL,
  112.   `kode_hari` int(10) DEFAULT NULL,
  113.   `kode_ruang` int(10) DEFAULT NULL,
  114.   PRIMARY KEY (`kode`)
  115. ) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=latin1 COMMENT='hasil proses';
  116.  
  117. -- Dumping data for table penjadwalan_genetik_web.jadwalkuliah: ~149 rows (approximately)
  118. DELETE FROM `jadwalkuliah`;
  119. /*!40000 ALTER TABLE `jadwalkuliah` DISABLE KEYS */;
  120. INSERT INTO `jadwalkuliah` (`kode`, `kode_pengampu`, `kode_jam`, `kode_hari`, `kode_ruang`) VALUES
  121.     (1, 1, 2, 6, 8),
  122.     (2, 2, 9, 6, 11),
  123.     (3, 3, 9, 2, 9),
  124.     (4, 4, 1, 5, 6),
  125.     (5, 5, 7, 3, 1),
  126.     (6, 6, 2, 5, 5),
  127.     (7, 7, 3, 6, 1),
  128.     (8, 8, 3, 2, 6),
  129.     (9, 9, 7, 6, 11),
  130.     (10, 10, 8, 1, 16),
  131.     (11, 11, 4, 4, 8),
  132.     (12, 12, 7, 2, 9),
  133.     (13, 13, 2, 4, 15),
  134.     (14, 14, 9, 6, 8),
  135.     (15, 15, 10, 2, 3),
  136.     (16, 16, 2, 5, 4),
  137.     (17, 17, 9, 4, 12),
  138.     (18, 18, 1, 1, 16),
  139.     (19, 19, 10, 3, 12),
  140.     (20, 20, 3, 1, 4),
  141.     (21, 21, 8, 4, 11),
  142.     (22, 22, 4, 3, 5),
  143.     (23, 23, 3, 1, 1),
  144.     (24, 24, 9, 1, 3),
  145.     (25, 25, 10, 2, 7),
  146.     (26, 26, 2, 3, 13),
  147.     (27, 27, 8, 2, 6),
  148.     (28, 32, 5, 2, 5),
  149.     (29, 33, 5, 4, 7),
  150.     (30, 34, 8, 1, 12),
  151.     (31, 36, 8, 6, 21),
  152.     (32, 37, 7, 5, 22),
  153.     (33, 38, 4, 4, 15),
  154.     (34, 39, 5, 3, 15),
  155.     (35, 40, 1, 1, 7),
  156.     (36, 41, 7, 4, 5),
  157.     (37, 42, 4, 6, 14),
  158.     (38, 43, 8, 1, 9),
  159.     (39, 44, 1, 6, 3),
  160.     (40, 45, 8, 4, 10),
  161.     (41, 47, 2, 1, 14),
  162.     (42, 48, 7, 6, 14),
  163.     (43, 49, 10, 3, 16),
  164.     (44, 50, 1, 6, 16),
  165.     (45, 51, 8, 5, 9),
  166.     (46, 52, 6, 2, 14),
  167.     (47, 53, 5, 6, 10),
  168.     (48, 54, 6, 3, 6),
  169.     (49, 55, 1, 1, 8),
  170.     (50, 56, 1, 2, 12),
  171.     (51, 57, 3, 6, 12),
  172.     (52, 58, 7, 2, 8),
  173.     (53, 59, 7, 5, 12),
  174.     (54, 60, 6, 1, 9),
  175.     (55, 61, 1, 1, 3),
  176.     (56, 62, 2, 3, 1),
  177.     (57, 63, 9, 5, 6),
  178.     (58, 64, 4, 4, 11),
  179.     (59, 65, 4, 6, 3),
  180.     (60, 66, 1, 1, 5),
  181.     (61, 67, 6, 2, 6),
  182.     (62, 68, 1, 5, 9),
  183.     (63, 69, 5, 4, 6),
  184.     (64, 70, 4, 2, 9),
  185.     (65, 71, 9, 1, 8),
  186.     (66, 72, 2, 1, 15),
  187.     (67, 73, 8, 4, 13),
  188.     (68, 74, 10, 2, 5),
  189.     (69, 75, 4, 4, 10),
  190.     (70, 76, 8, 2, 3),
  191.     (71, 77, 5, 4, 4),
  192.     (72, 78, 4, 2, 14),
  193.     (73, 79, 10, 1, 16),
  194.     (74, 80, 7, 5, 15),
  195.     (75, 82, 3, 3, 6),
  196.     (76, 83, 7, 6, 13),
  197.     (77, 84, 8, 3, 13),
  198.     (78, 85, 3, 3, 2),
  199.     (79, 86, 7, 4, 21),
  200.     (80, 87, 3, 6, 19),
  201.     (81, 88, 6, 2, 16),
  202.     (82, 89, 4, 6, 4),
  203.     (83, 92, 1, 4, 14),
  204.     (84, 93, 7, 5, 7),
  205.     (85, 94, 1, 2, 9),
  206.     (86, 95, 1, 6, 10),
  207.     (87, 96, 5, 6, 1),
  208.     (88, 97, 7, 4, 8),
  209.     (89, 98, 3, 6, 15),
  210.     (90, 99, 7, 1, 15),
  211.     (91, 100, 4, 2, 2),
  212.     (92, 101, 10, 2, 2),
  213.     (93, 102, 6, 3, 4),
  214.     (94, 103, 1, 1, 10),
  215.     (95, 104, 8, 4, 16),
  216.     (96, 105, 3, 4, 1),
  217.     (97, 106, 4, 1, 2),
  218.     (98, 107, 1, 2, 3),
  219.     (99, 108, 8, 2, 13),
  220.     (100, 109, 1, 3, 3),
  221.     (101, 110, 2, 2, 15),
  222.     (102, 111, 5, 2, 12),
  223.     (103, 112, 9, 6, 7),
  224.     (104, 113, 4, 3, 7),
  225.     (105, 114, 3, 4, 14),
  226.     (106, 115, 6, 4, 1),
  227.     (107, 116, 9, 4, 4),
  228.     (108, 117, 2, 6, 13),
  229.     (109, 118, 8, 3, 14),
  230.     (110, 119, 4, 1, 12),
  231.     (111, 120, 7, 6, 9),
  232.     (112, 121, 4, 3, 11),
  233.     (113, 122, 1, 5, 7),
  234.     (114, 123, 1, 6, 11),
  235.     (115, 124, 6, 6, 3),
  236.     (116, 125, 2, 3, 14),
  237.     (117, 126, 3, 2, 4),
  238.     (118, 127, 3, 2, 13),
  239.     (119, 128, 10, 4, 8),
  240.     (120, 129, 9, 2, 12),
  241.     (121, 130, 9, 5, 8),
  242.     (122, 131, 5, 1, 14),
  243.     (123, 132, 1, 5, 1),
  244.     (124, 133, 8, 2, 7),
  245.     (125, 134, 3, 4, 16),
  246.     (126, 144, 6, 1, 7),
  247.     (127, 145, 4, 4, 13),
  248.     (128, 146, 5, 2, 7),
  249.     (129, 147, 10, 5, 1),
  250.     (130, 148, 4, 1, 5),
  251.     (131, 149, 10, 5, 10),
  252.     (132, 150, 6, 2, 4),
  253.     (133, 151, 7, 4, 14),
  254.     (134, 152, 3, 6, 5),
  255.     (135, 153, 3, 2, 16),
  256.     (136, 154, 7, 3, 2),
  257.     (137, 155, 5, 6, 13),
  258.     (138, 156, 8, 3, 3),
  259.     (139, 157, 2, 4, 7),
  260.     (140, 158, 4, 2, 1),
  261.     (141, 159, 9, 1, 2),
  262.     (142, 160, 6, 3, 10),
  263.     (143, 161, 5, 1, 10),
  264.     (144, 162, 1, 4, 5),
  265.     (145, 163, 8, 1, 6),
  266.     (146, 164, 1, 1, 11),
  267.     (147, 165, 2, 2, 7),
  268.     (148, 166, 5, 1, 16),
  269.     (149, 167, 8, 5, 13);
  270. /*!40000 ALTER TABLE `jadwalkuliah` ENABLE KEYS */;
  271.  
  272.  
  273. -- Dumping structure for table penjadwalan_genetik_web.jam
  274. CREATE TABLE IF NOT EXISTS `jam` (
  275.   `kode` int(10) NOT NULL AUTO_INCREMENT,
  276.   `range_jam` varchar(50) DEFAULT NULL,
  277.   `aktif` enum('Y','N') DEFAULT NULL,
  278.   PRIMARY KEY (`kode`)
  279. ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
  280.  
  281. -- Dumping data for table penjadwalan_genetik_web.jam: ~11 rows (approximately)
  282. DELETE FROM `jam`;
  283. /*!40000 ALTER TABLE `jam` DISABLE KEYS */;
  284. INSERT INTO `jam` (`kode`, `range_jam`, `aktif`) VALUES
  285.     (1, '08.00-08.50', NULL),
  286.     (2, '08.50-09.30', NULL),
  287.     (3, '09.40-10.30', NULL),
  288.     (4, '10.30-11.20', NULL),
  289.     (5, '11.20-12.10', NULL),
  290.     (6, '12.10-13.00', NULL),
  291.     (7, '13.00-13.50', NULL),
  292.     (8, '13.50-14.40', NULL),
  293.     (9, '14.40-15.30', NULL),
  294.     (10, '15.30-16.20', NULL),
  295.     (11, '16.20-17.10', NULL);
  296. /*!40000 ALTER TABLE `jam` ENABLE KEYS */;
  297.  
  298.  
  299. -- Dumping structure for table penjadwalan_genetik_web.matakuliah
  300. CREATE TABLE IF NOT EXISTS `matakuliah` (
  301.   `kode` int(10) NOT NULL AUTO_INCREMENT,
  302.   `kode_mk` varchar(50) DEFAULT NULL,
  303.   `nama` varchar(50) DEFAULT NULL,
  304.   `sks` int(6) DEFAULT NULL,
  305.   `semester` int(6) DEFAULT NULL,
  306.   `aktif` enum('True','False') DEFAULT 'True',
  307.   `jenis` enum('TEORI','PRAKTIKUM') DEFAULT 'TEORI',
  308.   PRIMARY KEY (`kode`)
  309. ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1 COMMENT='example kode_mk = 0765109 ';
  310.  
  311. -- Dumping data for table penjadwalan_genetik_web.matakuliah: ~37 rows (approximately)
  312. DELETE FROM `matakuliah`;
  313. /*!40000 ALTER TABLE `matakuliah` DISABLE KEYS */;
  314. INSERT INTO `matakuliah` (`kode`, `kode_mk`, `nama`, `sks`, `semester`, `aktif`, `jenis`) VALUES
  315.     (1, NULL, 'Basis Data I ', 3, 2, 'True', 'TEORI'),
  316.     (2, NULL, 'Sistem Operasi ', 2, 2, 'True', 'TEORI'),
  317.     (3, NULL, 'Kalkulus  II', 2, 2, 'True', 'TEORI'),
  318.     (4, NULL, 'Pemrograman Desktop I (VB) (T)', 2, 2, 'True', 'TEORI'),
  319.     (5, NULL, 'Pemrograman Desktop I (VB) (P)', 2, 2, 'True', 'PRAKTIKUM'),
  320.     (6, NULL, 'Kewarganegaraan ', 2, 2, 'True', 'TEORI'),
  321.     (7, NULL, 'Bahasa Inggris II', 2, 2, 'True', 'TEORI'),
  322.     (8, NULL, 'Analisa & Perancangan SI', 3, 4, 'True', 'TEORI'),
  323.     (9, NULL, 'Statistik Probabilitas', 2, 4, 'True', 'TEORI'),
  324.     (10, NULL, 'Teknik Digital ', 3, 4, 'True', 'TEORI'),
  325.     (11, NULL, 'Bahasa Indonesia ', 2, 4, 'True', 'TEORI'),
  326.     (12, NULL, 'Troubleshooting', 2, 8, 'True', 'TEORI'),
  327.     (13, NULL, 'Kewirausahaan', 2, 8, 'True', 'TEORI'),
  328.     (14, NULL, 'Perbankan & Lembaga Keuangan', 2, 8, 'True', 'TEORI'),
  329.     (15, NULL, 'Microprocessor', 3, 6, 'True', 'TEORI'),
  330.     (16, NULL, 'Manajemen Proyek TI', 3, 6, 'True', 'TEORI'),
  331.     (17, NULL, 'Teknik Simulasi ', 3, 6, 'True', 'TEORI'),
  332.     (18, NULL, 'Struktur Data  (C++/Java)  (T)', 3, 2, 'True', 'TEORI'),
  333.     (19, NULL, 'Struktur Data  (C++/Java)  (P)', 3, 2, 'True', 'PRAKTIKUM'),
  334.     (20, NULL, 'Teknologi Komputer Utilitas (T) ', 2, 2, 'True', 'TEORI'),
  335.     (21, NULL, 'Teknologi Komputer Utilitas (P) ', 2, 2, 'True', 'PRAKTIKUM'),
  336.     (22, NULL, 'Lingkungan Kerja Jaringan (T) ', 3, 4, 'True', 'TEORI'),
  337.     (23, NULL, 'Lingkungan Kerja Jaringan (P) ', 3, 4, 'True', 'PRAKTIKUM'),
  338.     (24, NULL, 'Matematika Diskrit (T) ', 2, 4, 'True', 'TEORI'),
  339.     (25, NULL, 'Matematika Diskrit (P) ', 2, 4, 'True', 'PRAKTIKUM'),
  340.     (26, NULL, 'Pemrograman Science II (T)', 3, 4, 'True', 'TEORI'),
  341.     (27, NULL, 'Pemrograman Science II (P)', 3, 4, 'True', 'PRAKTIKUM'),
  342.     (28, NULL, 'Pemrograman Desktop II (VB) (T) ', 3, 4, 'True', 'TEORI'),
  343.     (29, NULL, 'Pemrograman Desktop II (VB) (P) ', 3, 4, 'True', 'PRAKTIKUM'),
  344.     (30, NULL, 'Teknologi Open Source II  (T)', 3, 6, 'True', 'TEORI'),
  345.     (31, NULL, 'Teknologi Open Source II  (P)', 3, 6, 'True', 'PRAKTIKUM'),
  346.     (32, NULL, 'Pemrograman Mobile II (T)', 3, 6, 'True', 'TEORI'),
  347.     (33, NULL, 'Pemrograman Mobile II (P)', 3, 6, 'True', 'PRAKTIKUM'),
  348.     (34, NULL, 'Web Desain (T)', 2, 6, 'True', 'TEORI'),
  349.     (35, NULL, 'Web Desain (P)', 2, 6, 'True', 'PRAKTIKUM'),
  350.     (36, NULL, 'Project I  (T)', 2, 6, 'True', 'TEORI'),
  351.     (37, NULL, 'Project I  (P)', 2, 6, 'True', 'PRAKTIKUM');
  352. /*!40000 ALTER TABLE `matakuliah` ENABLE KEYS */;
  353.  
  354.  
  355. -- Dumping structure for table penjadwalan_genetik_web.pengampu
  356. CREATE TABLE IF NOT EXISTS `pengampu` (
  357.   `kode` int(10) NOT NULL AUTO_INCREMENT,
  358.   `kode_mk` int(10) DEFAULT NULL,
  359.   `kode_dosen` int(10) DEFAULT NULL,
  360.   `kelas` varchar(10) DEFAULT NULL,
  361.   `tahun_akademik` varchar(10) DEFAULT NULL,
  362.   PRIMARY KEY (`kode`)
  363. ) ENGINE=InnoDB AUTO_INCREMENT=168 DEFAULT CHARSET=latin1;
  364.  
  365. -- Dumping data for table penjadwalan_genetik_web.pengampu: ~149 rows (approximately)
  366. DELETE FROM `pengampu`;
  367. /*!40000 ALTER TABLE `pengampu` DISABLE KEYS */;
  368. INSERT INTO `pengampu` (`kode`, `kode_mk`, `kode_dosen`, `kelas`, `tahun_akademik`) VALUES
  369.     (1, 1, 1, 'F', '2011-2012'),
  370.     (2, 1, 1, 'G', '2011-2012'),
  371.     (3, 1, 1, 'H', '2011-2012'),
  372.     (4, 1, 2, 'A', '2011-2012'),
  373.     (5, 1, 2, 'D', '2011-2012'),
  374.     (6, 2, 3, 'A', '2011-2012'),
  375.     (7, 2, 3, 'C', '2011-2012'),
  376.     (8, 2, 3, 'D', '2011-2012'),
  377.     (9, 2, 3, 'B', '2011-2012'),
  378.     (10, 2, 4, 'E', '2011-2012'),
  379.     (11, 2, 4, 'G', '2011-2012'),
  380.     (12, 2, 4, 'H', '2011-2012'),
  381.     (13, 2, 4, 'F', '2011-2012'),
  382.     (14, 4, 43, 'C', '2011-2012'),
  383.     (15, 4, 43, 'A', '2011-2012'),
  384.     (16, 4, 43, 'B', '2011-2012'),
  385.     (17, 4, 43, 'D', '2011-2012'),
  386.     (18, 3, 37, 'A', '2011-2012'),
  387.     (19, 3, 37, 'B', '2011-2012'),
  388.     (20, 24, 37, 'G', '2011-2012'),
  389.     (21, 24, 37, 'E', '2011-2012'),
  390.     (22, 24, 37, 'F', '2011-2012'),
  391.     (23, 6, 38, 'F', '2011-2012'),
  392.     (24, 6, 38, 'C', '2011-2012'),
  393.     (25, 6, 38, 'G', '2011-2012'),
  394.     (26, 6, 38, 'H', '2011-2012'),
  395.     (27, 18, 39, 'D', '2011-2012'),
  396.     (32, 18, 39, 'B', '2011-2012'),
  397.     (33, 18, 39, 'C', '2011-2012'),
  398.     (34, 18, 39, 'A', '2011-2012'),
  399.     (36, 19, 40, 'G', '2011-2012'),
  400.     (37, 19, 40, 'H', '2011-2012'),
  401.     (38, 20, 41, 'E', '2011-2012'),
  402.     (39, 20, 41, 'C', '2011-2012'),
  403.     (40, 20, 41, 'D', '2011-2012'),
  404.     (41, 20, 41, 'F', '2011-2012'),
  405.     (42, 12, 41, 'A', '2011-2012'),
  406.     (43, 12, 41, 'B', '2011-2012'),
  407.     (44, 18, 42, 'H', '2011-2012'),
  408.     (45, 18, 42, 'G', '2011-2012'),
  409.     (47, 34, 42, 'D', '2011-2012'),
  410.     (48, 7, 49, 'F', '2011-2012'),
  411.     (49, 7, 49, 'D', '2011-2012'),
  412.     (50, 7, 49, 'C', '2011-2012'),
  413.     (51, 7, 50, 'A', '2011-2012'),
  414.     (52, 7, 50, 'B', '2011-2012'),
  415.     (53, 22, 55, 'B', '2011-2012'),
  416.     (54, 22, 55, 'A', '2011-2012'),
  417.     (55, 22, 55, 'C', '2011-2012'),
  418.     (56, 22, 55, 'D', '2011-2012'),
  419.     (57, 9, 56, 'F', '2011-2012'),
  420.     (58, 9, 56, 'E', '2011-2012'),
  421.     (59, 9, 56, 'G', '2011-2012'),
  422.     (60, 20, 44, 'B', '2011-2012'),
  423.     (61, 22, 44, 'G', '2011-2012'),
  424.     (62, 22, 44, 'E', '2011-2012'),
  425.     (63, 22, 44, 'F', '2011-2012'),
  426.     (64, 20, 45, 'A', '2011-2012'),
  427.     (65, 20, 45, 'G', '2011-2012'),
  428.     (66, 20, 45, 'H', '2011-2012'),
  429.     (67, 12, 45, 'C', '2011-2012'),
  430.     (68, 4, 46, 'E', '2011-2012'),
  431.     (69, 4, 46, 'F', '2011-2012'),
  432.     (70, 28, 46, 'D', '2011-2012'),
  433.     (71, 28, 46, 'E', '2011-2012'),
  434.     (72, 18, 47, 'F', '2011-2012'),
  435.     (73, 18, 47, 'E', '2011-2012'),
  436.     (74, 6, 48, 'A', '2011-2012'),
  437.     (75, 6, 48, 'E', '2011-2012'),
  438.     (76, 6, 48, 'D', '2011-2012'),
  439.     (77, 11, 77, 'E', '2011-2012'),
  440.     (78, 11, 77, 'D', '2011-2012'),
  441.     (79, 11, 77, 'F', '2011-2012'),
  442.     (80, 8, 70, 'A', '2011-2012'),
  443.     (82, 8, 70, 'C', '2011-2012'),
  444.     (83, 8, 70, 'B', '2011-2012'),
  445.     (84, 17, 64, 'C', '2011-2012'),
  446.     (85, 17, 64, 'D', '2011-2012'),
  447.     (86, 31, 66, 'D', '2011-2012'),
  448.     (87, 31, 66, 'C', '2011-2012'),
  449.     (88, 30, 67, 'B', '2011-2012'),
  450.     (89, 30, 67, 'A', '2011-2012'),
  451.     (92, 9, 84, 'A', '2011-2012'),
  452.     (93, 9, 84, 'B', '2011-2012'),
  453.     (94, 9, 84, 'C', '2011-2012'),
  454.     (95, 9, 84, 'D', '2011-2012'),
  455.     (96, 24, 82, 'B', '2011-2012'),
  456.     (97, 24, 82, 'C', '2011-2012'),
  457.     (98, 24, 82, 'D', '2011-2012'),
  458.     (99, 24, 82, 'A', '2011-2012'),
  459.     (100, 11, 83, 'B', '2011-2012'),
  460.     (101, 11, 83, 'A', '2011-2012'),
  461.     (102, 11, 83, 'C', '2011-2012'),
  462.     (103, 10, 57, 'C', '2011-2012'),
  463.     (104, 10, 57, 'E', '2011-2012'),
  464.     (105, 10, 57, 'F', '2011-2012'),
  465.     (106, 10, 57, 'D', '2011-2012'),
  466.     (107, 10, 75, 'B', '2011-2012'),
  467.     (108, 10, 75, 'A', '2011-2012'),
  468.     (109, 36, 63, 'C', '2011-2012'),
  469.     (110, 36, 63, 'D', '2011-2012'),
  470.     (111, 36, 63, 'A', '2011-2012'),
  471.     (112, 8, 81, 'D', '2011-2012'),
  472.     (113, 8, 81, 'F', '2011-2012'),
  473.     (114, 8, 81, 'E', '2011-2012'),
  474.     (115, 26, 79, 'B', '2011-2012'),
  475.     (116, 26, 79, 'A', '2011-2012'),
  476.     (117, 26, 79, 'C', '2011-2012'),
  477.     (118, 28, 80, 'C', '2011-2012'),
  478.     (119, 28, 80, 'A', '2011-2012'),
  479.     (120, 28, 80, 'B', '2011-2012'),
  480.     (121, 26, 76, 'D', '2011-2012'),
  481.     (122, 26, 76, 'E', '2011-2012'),
  482.     (123, 26, 76, 'F', '2011-2012'),
  483.     (124, 3, 52, 'C', '2011-2012'),
  484.     (125, 3, 52, 'E', '2011-2012'),
  485.     (126, 3, 52, 'D', '2011-2012'),
  486.     (127, 3, 53, 'H', '2011-2012'),
  487.     (128, 3, 53, 'G', '2011-2012'),
  488.     (129, 3, 53, 'F', '2011-2012'),
  489.     (130, 17, 75, 'A', '2011-2012'),
  490.     (131, 17, 75, 'B', '2011-2012'),
  491.     (132, 7, 51, 'H', '2011-2012'),
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!