· 7 years ago · Oct 14, 2018, 03:30 AM
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
14CREATE DATABASE IF NOT EXISTS `penjadwalan_genetik_web` /*!40100 DEFAULT CHARACTER SET latin1 */;
15USE `penjadwalan_genetik_web`;
16
17
18-- Dumping structure for table penjadwalan_genetik_web.dosen
19CREATE 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)
29DELETE FROM `dosen`;
30/*!40000 ALTER TABLE `dosen` DISABLE KEYS */;
31INSERT 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
88CREATE 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)
95DELETE FROM `hari`;
96/*!40000 ALTER TABLE `hari` DISABLE KEYS */;
97INSERT 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
108CREATE 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)
118DELETE FROM `jadwalkuliah`;
119/*!40000 ALTER TABLE `jadwalkuliah` DISABLE KEYS */;
120INSERT 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
274CREATE 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)
282DELETE FROM `jam`;
283/*!40000 ALTER TABLE `jam` DISABLE KEYS */;
284INSERT 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
300CREATE 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)
312DELETE FROM `matakuliah`;
313/*!40000 ALTER TABLE `matakuliah` DISABLE KEYS */;
314INSERT 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
356CREATE 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)
366DELETE FROM `pengampu`;
367/*!40000 ALTER TABLE `pengampu` DISABLE KEYS */;
368INSERT 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'),