DH3yWqgr

1-- phpMyAdmin SQL Dump
2-- version 3.4.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Waktu pembuatan: 31. Oktober 2017 jam 08:27
7-- Versi Server: 5.5.16
8-- Versi PHP: 5.3.8
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `db_cat_dua`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `m_admin`
27--
28
29CREATE TABLE IF NOT EXISTS `m_admin` (
30  `id` int(6) NOT NULL AUTO_INCREMENT,
31  `username` varchar(100) NOT NULL,
32  `password` varchar(100) NOT NULL,
33  `level` enum('admin','guru','siswa','operator') NOT NULL,
34  `kon_id` int(6) NOT NULL,
35  PRIMARY KEY (`id`),
36  KEY `kon_id` (`kon_id`)
37) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=241 ;
38
39--
40-- Dumping data untuk tabel `m_admin`
41--
42
43INSERT INTO `m_admin` (`id`, `username`, `password`, `level`, `kon_id`) VALUES
44(1, 'admin', '4acb4bc224acbbe3c2bfdcaa39a4324e', 'admin', 0),
45(2, 'operator', '2407bd807d6ca01d1bcd766c730cec9a', 'operator', 1),
46(31, '12345', '827ccb0eea8a706c4c34a16891f84e7b', 'guru', 8),
47(38, 'RS', '8cee5050eeb7c783e8bfaa73003ced3a', 'guru', 107),
48(39, 'RP', 'c4cb0a6bcf9b947b0e647a11ebfacefa', 'guru', 106),
49(40, 'PG', '49f38fe03598e4d63f4a0a8791c9c8b9', 'guru', 105),
50(41, 'SM', '4e0d4f6ce30646f5a3f3e2a7422c1c5a', 'guru', 104),
51(42, 'KS', 'a32356331cf2a7f56e45306fc6d328d9', 'guru', 103),
52(43, 'MT', '08ad08f6491037714d09263a79bebfba', 'guru', 102),
53(44, 'HY', 'a172e75d812cea8be65d3e1513c6c0b9', 'guru', 101),
54(45, 'HS', '55a055409207a12d5937b243fd508bde', 'guru', 100),
55(46, 'PT', '35357b9c8fe4d3273d0237ecc8ff2e75', 'guru', 99),
56(47, 'EH', '088a2013906137902c9832d2f5a3a940', 'guru', 98),
57(48, 'AW', '1e5342b2de8f485d2cc77947a6154b3f', 'guru', 97),
58(49, 'IM', '7c78ebb4c223c96f8e6ccc29f73cc28e', 'guru', 96),
59(50, 'GN', 'accb66f0ecd826aac89065990e1da97f', 'guru', 95),
60(51, 'RB', 'c8ee22e1fc2165dfd3d2b04aef93b2f2', 'guru', 94),
61(52, 'GY', '1daf9c39806ca426cd65151747932f6c', 'guru', 93),
62(53, 'OV', '2e9413b5696d0384c61121df61cc1cbb', 'guru', 88),
63(54, 'HD', '27178471f2c4019c872d1545a0f154c7', 'guru', 89),
64(55, 'SC', '6a65edb0cc17d66c677814115b1477f5', 'guru', 90),
65(56, 'ID', 'b718adec73e04ce3ec720dd11a06a308', 'guru', 91),
66(57, 'SH', 'ec5704f0d56945d1e5b8f9a2384a2b4b', 'guru', 92),
67(58, 'SS', 'd53aeb78abc83a52ab8982f5c82a3d5b', 'guru', 87),
68(59, 'AO', '2c64c5cf613d8b9f4f7f3980d29aca10', 'guru', 86),
69(60, 'DN', 'f7373a2c8ea4b1cafd7ab9e8c294331d', 'guru', 85),
70(61, 'RO', 'f5b15f58cabad73d1bf2de7bcb89db6c', 'guru', 84),
71(62, 'JE', '069b38cf28a10a4a128a408ce11d2789', 'guru', 83),
72(63, 'BA', '5fc810cf62601df84b7923b9964c53e6', 'guru', 82),
73(64, 'AQ', '406a827681ba573eb9029a9a41cae6d7', 'guru', 81),
74(65, 'HA', '594c16ca0695f6665d7cf4971707adf6', 'guru', 79),
75(66, 'TO', '304917b92bc3dc0953aab8356f74c02c', 'guru', 80),
76(67, 'AU', '6cc98ba2045fe4098d24356d14447085', 'guru', 78),
77(68, 'SR', '8cb2010d27e13509d364436256e972c0', 'guru', 77),
78(69, 'SO', '98d0360b392de5f1d53acdd6489b6e88', 'guru', 76),
79(70, 'HP', 'e6fc8ce107f2bdf0955f021a391514ce', 'guru', 75),
80(71, 'AI', '0a40e3c91a3a55c9a37428c6d194d0e5', 'guru', 74),
81(72, 'NH', 'd41b7e52a4d4a8b4368f46611d066ece', 'guru', 73),
82(73, 'KD', 'a46be189b8246f0f9657170a0b127665', 'guru', 72),
83(74, 'CR', '1d7b33fc26ca22c2011aaa97fecc43d8', 'guru', 71),
84(75, 'NN', '8cc2e7240164328fdc3f0e5e21032c56', 'guru', 58),
85(76, 'BD', '87a47565be4714701a8bc2354cbaea36', 'guru', 70),
86(77, 'RJ', '0f4bda3a8e49e714c26ef610e2893454', 'guru', 69),
87(78, 'AZ', '546a9a80eb981c7f0aabcaeb34d9514e', 'guru', 68),
88(79, 'DJ', '27a5773a603825cc6999e48cc2b1b270', 'guru', 67),
89(80, 'AB', 'b86fc6b051f63d73de262d4c34e3a0a9', 'guru', 66),
90(81, 'SU', 'f7adf0ba18d705092fa0a1e2f2c0bafb', 'guru', 65),
91(82, 'PJ', '0b62ef5d75cf8af681c9399efbfdc19d', 'guru', 64),
92(83, 'RN', 'bcc029cfba7ada8237717e5f1ff494f1', 'guru', 63),
93(84, 'AP', '0fd3f8dd5edc33b28db1162e15e8fcbc', 'guru', 62),
94(85, 'MW', 'f9f315de90492c8259307985379c2a4e', 'guru', 61),
95(86, 'MZ', 'ac6ad5d9b99757c3a878f2d275ace198', 'guru', 60),
96(87, 'UK', '76423d8352c9e8fc8d7d65f62c55eae9', 'guru', 59),
97(88, 'GR', 'f214a7d42e0de5875d55189e01e2e187', 'guru', 57),
98(89, 'NR', 'c3938dd81fe1366e93d2e29a6ffe2005', 'guru', 56),
99(90, 'AN', 'd9681d05860552e9c3113da381f916fc', 'guru', 55),
100(91, 'WT', '9df2056925e5afd294e827b756d40bd2', 'guru', 54),
101(92, 'EN', 'aa85f1840e282d8a8304dbc2c0d7c9b2', 'guru', 53),
102(93, 'LE', 'cfe6055d2e0503be378bb63449ec7ba6', 'guru', 52),
103(94, 'LU', '920d0c66f3d2ad926a6d590a5d244bd9', 'guru', 51),
104(95, 'HR', 'fd4c638da5f85d025963f99fe90b1b1a', 'guru', 50),
105(96, 'WS', '54df3baef130c81e6ae8432a2567320a', 'guru', 49),
106(97, 'AR', '5b61a1b298a0d06efa6933a97e68d763', 'guru', 48),
107(98, 'DY', '8e33631037901075c85616c9b60441e4', 'guru', 47),
108(99, 'AE', 'ea8a1a99f6c94c275a58dcd78f418c1f', 'guru', 46),
109(100, 'FK', '8c8ba29dafd95af91e280d1e80b81773', 'guru', 45),
110(101, 'SE', 'f003c44deab679aa2edfaff864c77402', 'guru', 44),
111(102, 'ZA', '68caa82010645c82f5e37cbe337cae1c', 'guru', 43),
112(103, 'TR', 'ebe021079e5a3c4f42ca6119eab92633', 'guru', 42),
113(104, 'ER', '1bd3a0484883ca6deaada8395a8f6e85', 'guru', 41),
114(105, 'AT', 'fa868488740aa25870ced6b9169951fb', 'guru', 40),
115(106, 'AM', '25ec916d56b8212e569dbf2e4e4b51d4', 'guru', 39),
116(107, 'BP', '96d4cdff8ed57e93e3b3d843cffe3af7', 'guru', 38),
117(108, 'US', '7516fd43adaa5e0b8a65a672c39845d2', 'guru', 37),
118(109, 'IS', '0bfc16cc12effc1bae4d3766c4f2257d', 'guru', 17),
119(110, 'MA', '2a6039655313bf5dab1e43523b62c374', 'guru', 16),
120(111, 'ST', 'ec8e57d71f07e31203035548b79d03c8', 'guru', 15),
121(112, 'AF', '06fa567b72d78b7e3ea746973fbbd1d5', 'guru', 14),
122(113, 'KR', '38dd815e66dbd0d47a2b876ca442e987', 'guru', 13),
123(114, 'EF', '2c9b682412689d6723e3b31653b5774c', 'guru', 12),
124(115, 'IB', 'fa2452c388ed1c0da4d2fcf91ac4c8c6', 'guru', 11),
125(116, 'BJ', 'ddd70bbaf5be05e1e9caded444c03095', 'guru', 10),
126(117, 'RT', '705610ed3e5ec724f5cb0d76a5fd3aa1', 'guru', 27),
127(118, 'SN', '92666505ce75444ee14be2ebc2f10a60', 'guru', 26),
128(119, 'SA', '3dd6b9265ff18f31dc30df59304b0ca7', 'guru', 25),
129(120, 'SD', '38f99abbc1d339c277c0669e7bc373c0', 'guru', 24),
130(121, 'NL', '796834e7a2839412d79dbc5f1327594d', 'guru', 23),
131(122, 'CE', '7a86131338bf955e0a56311f264aa6aa', 'guru', 22),
132(123, 'RD', 'cd3c9bb8acb671dbd1faba3deaa1e03e', 'guru', 21),
133(124, 'FA', 'ceaaf344427537ca0d8f1dbd83dcb44b', 'guru', 20),
134(125, 'RA', '36fb81539768d678527f9929625716b7', 'guru', 19),
135(126, 'SK', '13dd621f27110108a10a88e99fe9ceaf', 'guru', 18),
136(127, 'KT', 'dd867a684cc8cd9ee15ef8a3280dfb1a', 'guru', 28),
137(128, 'VN', 'e14da64a5617a7f7260ccb29c48fa866', 'guru', 29),
138(129, 'IP', 'a12a3079e14ced46e69ba52b8a90b21a', 'guru', 30),
139(130, 'FT', '1e2f86b95d78d7f8cfcbdc1a07b2fbd7', 'guru', 31),
140(131, 'DW', '0bdfe2e55090d6be70793778d0d8e147', 'guru', 32),
141(132, 'SY', '174fe2539889bbf873e7c2de71949074', 'guru', 33),
142(133, 'NA', 'd4cd0dabcf4caa22ad92fab40844c786', 'guru', 34),
143(135, 'NS', '53c8d15a175221d2127083e66a8cc937', 'guru', 35),
144(136, 'RI', '2cffb802c2aa988d1e7f2c2c78284d62', 'guru', 36),
145(137, '111', '698d51a19d8a121ce581499d7b701668', 'siswa', 13),
146(138, 'SB', 'a06b33d1ea28e90733617ec889d4e76e', 'guru', 110),
147(139, 'HM', '36a12a753997a4032c351f4c6a12c416', 'guru', 109),
148(140, 'LS', 'e8280907c8d32d5af0f36e5442e84a34', 'guru', 108),
149(141, 'WJ', 'f30c99c71bf6c212f4a114adc1e675db', 'guru', 111),
150(142, 'IW', 'e2f757a2cdc6fa6312ea71ce43a211b8', 'guru', 112),
151(143, 'RK', '87c69d95a624572b1d842444b47e69f3', 'guru', 113),
152(144, 'MH', '002f27e5064e874ecf4f5def17d1b797', 'guru', 114),
153(145, 'NK', '93437597656efdb384976096b6261386', 'guru', 116),
154(146, 'JN', 'd9b252866a25986fd8ec8a6c9bded275', 'guru', 117),
155(147, 'RU', 'f9308c5d059650ee40cab30bad1e96d0', 'guru', 141),
156(148, 'BM', '5089fa881630360a9b3361469c1a0c5d', 'guru', 150),
157(149, 'HE', 'bc781c76baf5589eef4fb7b9247b89a0', 'guru', 153),
158(150, 'BR', '19d3326f3137cbadd21ce901a9bed4a7', 'guru', 152),
159(151, 'AY', '93009a886cad217bfada654e0dcff67a', 'guru', 151),
160(152, 'EU', 'f2e6e3b9bff59f293f0e9019a1ecabc5', 'guru', 140),
161(153, 'SW', '6f56aa4e2561eb66f17f6d8de8070a77', 'guru', 139),
162(154, 'RZ', '25e29a048984cda66521f1eab1182666', 'guru', 137),
163(155, 'PS', 'd3d4c5deb455ac79dd5ff47c88bd65d9', 'guru', 138),
164(156, 'WY', '05184b2fec44bde3ebe5d5f386d7e1eb', 'guru', 136),
165(157, 'NY', '93a2a4ba7f0637b17eb0406c741759e8', 'guru', 126),
166(158, 'DE', '3a52f3c22ed6fcde5bf696a6c02c9e73', 'guru', 135),
167(159, 'NO', 'c2f3f489a00553e7a01d369c103c7251', 'guru', 134),
168(160, 'RR', 'cb95449a94688af33f6e9bb090cf2936', 'guru', 133),
169(161, 'PM', '21b7eb30013b04776f5b06bc59209391', 'guru', 132),
170(162, 'HU', '35b5282113b88c2fe23dcbec9f0258c1', 'guru', 130),
171(163, 'MI', '9b38067e23298837802635d5172733d7', 'guru', 129),
172(164, 'UL', '5b26faf932d04f134a2cf70e96c4c548', 'guru', 128),
173(165, 'KH', 'fd7030716334c4db5a83bbbc0f7c7f6f', 'guru', 124),
174(166, 'DR', '3754385271c4f2a2648b471683d21149', 'guru', 125),
175(167, 'AD', 'e182ebbc166d73366e7986813a7fc5f1', 'guru', 119),
176(168, 'SP', '674769e3326f8cf937af4282f2815c02', 'guru', 120),
177(169, 'UJ', '3ab7806fac7c2de105704d4ff29dd581', 'guru', 121),
178(170, 'TT', 'df1f3edb9115acb0a1e04209b7a9937b', 'guru', 122),
179(171, 'TS', '6ba89ab41823af9b65ea5d233031b9f8', 'guru', 123),
180(172, 'AS', 'a2c29192484301fa800100e16e494acf', 'guru', 154),
181(173, 'EK', '6aa451b53d492a8f5a2fa1fa2855be8b', 'guru', 155),
182(174, 'DP', 'e2fca8135c2fadca093abd79a6b1c0d2', 'guru', 156),
183(175, 'WN', 'c6a0e7c2e78ced7f024313cb92b897a3', 'guru', 157),
184(176, '1', 'c4ca4238a0b923820dcc509a6f75849b', 'siswa', 14),
185(177, '2', 'c81e728d9d4c2f636f067f89cc14862c', 'siswa', 15),
186(178, '165510', 'f779acb72743f8cf4b126d43e1e17668', 'siswa', 18),
187(179, '165511', '7f9c8a3e8f67245c115778c9584802f5', 'siswa', 19),
188(180, '165512', '9508daada4bcec3fd23c02ececf6b01f', 'siswa', 20),
189(181, '165513', 'b503ea71d26bbcbef9cfa8dc9160fdfe', 'siswa', 21),
190(182, '165514', '9e40257688af90e1619aaeae77e96fef', 'siswa', 22),
191(183, '165515', 'a9e492ad639224bde63a1133275f000c', 'siswa', 23),
192(184, '165516', '6e630ce4fa9cd2d7f15bd09b6a9c244a', 'siswa', 24),
193(185, '165517', '6f8877d81db2ef37281604214493719e', 'siswa', 25),
194(186, '165518', '8487447795afb3afe083ca2a72bf5654', 'siswa', 26),
195(187, '165519', '69b45094ba8ad7a75ff8e88c01eddf97', 'siswa', 27),
196(188, '165520', '8402d6245997e7225d2ed227e5f2a379', 'siswa', 28),
197(189, '165521', '6bff8cf57719557ab6e33ae63f9d4db2', 'siswa', 29),
198(190, '165522', '951297924cc274baf5ab31aab8cd42f1', 'siswa', 30),
199(191, '165523', '8f2f37f2952c662b1053702f157a0b6f', 'siswa', 31),
200(192, '165524', '32221d8dff60dc73550a09d199fefbad', 'siswa', 32),
201(193, '165525', 'a194eaca9e0439f87f4738b04eacac74', 'siswa', 33),
202(194, '165526', '47e7ee48f4bf45cc9528e7396e72c4cd', 'siswa', 34),
203(195, '165527', '08710d1cd5ab77ba863bcfb3dfc80891', 'siswa', 35),
204(196, '165528', '2544e87c7b5ffba877cbe4d1775ec619', 'siswa', 36),
205(197, '165529', 'e0c615124190204a30c15a2e8f0aa529', 'siswa', 37),
206(198, '165530', '6c2e96c9f43381e829a4fdb9bca2f574', 'siswa', 38),
207(199, '165531', '757df0ac5e947c54db95c2851ed35e0f', 'siswa', 39),
208(200, '165532', '202f176b11d946dc7463a90358b76a98', 'siswa', 40),
209(201, '165533', '23aa62050ad390ae3d3b0cf328472e08', 'siswa', 41),
210(202, '165534', 'd2494ccf67556c9c99b3d07163a91cf7', 'siswa', 42),
211(203, '165535', 'c63a70573abb813d03dc6eb38b97dadd', 'siswa', 43),
212(204, '165536', '5333b76bb87b7924c69c976296a79d2f', 'siswa', 44),
213(205, '165537', '0b432ec0050964ee1b227ae351efc95c', 'siswa', 45),
214(206, '165538', '5d5b3700fed028a19071b9b87db363f4', 'siswa', 46),
215(207, '165539', '0d9a7b11bb67095358259730ab74f623', 'siswa', 47),
216(208, '165540', '8af6ce8a292b34d29a8d5b976b3713aa', 'siswa', 48),
217(209, '165541', '47728fb102f9a594faca695aba49aaa2', 'siswa', 49),
218(210, '155044', 'bdb8fa527a9ba043e9c044a648b75ddc', 'siswa', 50),
219(211, '155045', '3ca4bdee0d08c99ba003fab3cd1713cf', 'siswa', 51),
220(212, '155046', 'b67ac39f909e0642e2963abcb780e3f6', 'siswa', 52),
221(213, '155047', 'b7c24b8962f35979cf4029ad7d37b577', 'siswa', 53),
222(214, '155048', '1e474c1e207c9b93e8da51de7ed77c70', 'siswa', 54),
223(215, '155049', 'f27d82ac755b918259640b925c635a19', 'siswa', 55),
224(216, '155050', 'b9630ac535ef1a4d05dc8f8b1298c731', 'siswa', 56),
225(217, '155051', 'c8e35c657fe3cb53ccb77a4b3cd410eb', 'siswa', 57),
226(218, '155052', '1e938092cfab66be5b7adb4ae8f9d59c', 'siswa', 58),
227(219, '155053', '41280115b82da0827ef2757831955ec9', 'siswa', 59),
228(220, '155055', 'da833a36136dfba8f6c36dc5f6a1a992', 'siswa', 60),
229(221, '155056', '3c3810d26de63e5d40ce5cdb7a66c4f9', 'siswa', 61),
230(222, '155057', 'dc68dfdc58eb2c21a732003b869664c0', 'siswa', 62),
231(223, '155058', 'c8c1187e2f3b7de4b7bdf04306e45567', 'siswa', 63),
232(224, '155059', '2d5091f46b227e53ec876e460c7fd31f', 'siswa', 64),
233(225, '155060', '60e2fa910a30f79bf400df3dfc30ae88', 'siswa', 65),
234(226, '155061', 'effe939ed1cc4f2d17bf39eecdbd7f19', 'siswa', 66),
235(227, '155062', 'dbc2b28561d065d1cd52109b5d855f3f', 'siswa', 67),
236(228, '155063', '795ced384fdcad15310b46841a6f145c', 'siswa', 68),
237(229, '155064', '39b6ba49a66f2e2ee0946db8c1b00f0f', 'siswa', 69),
238(230, '155065', '52121b5ce0d0775e0f7afa3d36d99808', 'siswa', 70),
239(231, '155066', '96dc12d800c28698f8aa4d2da09b9118', 'siswa', 71),
240(232, '155067', 'db90042fad834765b32c5d07c330924f', 'siswa', 72),
241(233, '155068', '9193fef2d50bb7f767c0f9484acd6fe8', 'siswa', 73),
242(234, '155069', 'fd418fb0b118c842f059b38587a8d664', 'siswa', 74),
243(235, '155070', '4e85cfdb1a89d2ac1ab1b725036a3417', 'siswa', 75),
244(236, '155071', '44bad87dcd847568fc93f38ed24835ee', 'siswa', 76),
245(237, '155072', '377830c80ad4c2e41e0d9eb6b337aa9d', 'siswa', 77),
246(238, '155073', 'ee59d1a63be7b1aca0d646dc499efd7e', 'siswa', 78),
247(239, '155074', 'd91067eb078b01d8b93463d51b000ef6', 'siswa', 79),
248(240, '155075', '67c81a455e9bb78d6ab846698b5bba50', 'siswa', 80);
249
250-- --------------------------------------------------------
251
252--
253-- Struktur dari tabel `m_guru`
254--
255
256CREATE TABLE IF NOT EXISTS `m_guru` (
257  `id` int(6) NOT NULL AUTO_INCREMENT,
258  `nip` varchar(30) NOT NULL,
259  `nama` varchar(100) NOT NULL,
260  PRIMARY KEY (`id`)
261) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=158 ;
262
263--
264-- Dumping data untuk tabel `m_guru`
265--
266
267INSERT INTO `m_guru` (`id`, `nip`, `nama`) VALUES
268(8, '12345', 'mohamad erlan efarda, A.Md Kom'),
269(10, 'BJ', 'Drs. BEJO, M.Pd'),
270(11, 'IB', 'IBNU HAJAR DEWANTORO, S.TP,M.Si'),
271(12, 'EF', 'EARLY FALIKHATI, S.Si.'),
272(13, 'KR', 'Drs. KARTONO.'),
273(14, 'AF', 'AFRONI, S.Pd.I'),
274(15, 'ST', 'SUTINIROH, S.Ag.'),
275(16, 'MA', 'MUHAMAD ARFAN, S.Pd.I '),
276(17, 'IS', 'Dra. Rr. ISMIJARTI DR.'),
277(18, 'SK', 'SUKMONO WILOPO, BA.'),
278(19, 'RA', 'RIZKY AFRIYANTI, S.Psi'),
279(20, 'FA', 'FAKHRUL IMANU, S.Pd.'),
280(21, 'RD', 'RAHADIAN SETIYA NUGRAHA, S.Psi'),
281(22, 'CE', 'CHAZANAH ERAWATI, S.Pd'),
282(23, 'NL', 'NAILI FAIZATIS SYIFA, S.Psi.'),
283(24, 'SD', 'Dra. SRI WIDADI'),
284(25, 'SA', 'SITI AMINAH,S.Pd'),
285(26, 'SN', 'SANIMAH, S.Pd.'),
286(27, 'RT', 'RATNA SARI,S.Pd'),
287(28, 'KT', 'KRISTIANA TUNGGADEWI,S.Pd'),
288(29, 'VN', 'VENI VIDIYATI,S.Pd'),
289(30, 'IP', 'ISNAWATI PANGESTU, S.Pd.'),
290(31, 'FT', 'FITRI HARYANI,S.Pd'),
291(32, 'DW', 'DWI PURWANINGSIH, S.S.'),
292(33, 'SY', 'SUPRIYATIN, S.Pd'),
293(34, 'NA', 'NUR AMANAH, S.Pd.'),
294(35, 'NS', 'NINGSIH, S.Pd.Si'),
295(36, 'RI', 'RIYANTO, S.Pd.'),
296(37, 'US', 'USWATUN KHASANAH, S.Pd. (Mat)'),
297(38, 'BP', 'BAMBANG PURWOKO, S.T.'),
298(39, 'AM', 'Drs. AMIR FAHRUDIN'),
299(40, 'AT', 'ATI PRIHATININGSIH, S.Pd.'),
300(41, 'ER', 'SRI ERMI WULANDARI, S.Pd.'),
301(42, 'TR', 'TRIANA SRI WAKHYUNI, S.Pd'),
302(43, 'ZA', 'ZAOZI, S.Pd.'),
303(44, 'SE', 'Drs. SETIONO RAHARJO'),
304(45, 'FK', 'FIKA NURAINI R.,M.Pd'),
305(46, 'AE', 'ACHMAD EFENDI,S.Pd'),
306(47, 'DY', 'Dra. DYAH PONCOWATI'),
307(48, 'AR', 'ARIFIN, S.Pd.'),
308(49, 'WS', 'WASRIYAH, S.Pd'),
309(50, 'HR', 'Drs. HARTONO UTOMO'),
310(51, 'LU', 'LUTFIANI, S.Pd.'),
311(52, 'LE', 'H.AKHMAD SULEMAN, S.Pd.'),
312(53, 'EN', 'ENDAH ANANI , S.Pd'),
313(54, 'WT', 'SRIWATI, S.Pd'),
314(55, 'AN', 'ANIS SUGIARTI, S.Pd'),
315(56, 'NR', 'NUR HIJRIYAH BUDI ASIH, S.Pd'),
316(57, 'GR', 'GALUH RATNANINGSIH,M.Si'),
317(58, 'NN', 'Dra. NUNING TYASTUTI'),
318(59, 'UK', 'USWATUN KHASANAH, S.Pd. (Kim)'),
319(60, 'MZ', 'MOHAMMAD ZENUDIN, S.Pd.'),
320(61, 'MW', 'MUNAWAROH, S.Pd.'),
321(62, 'AP', 'ARI PRISTIANTO N, M.Si'),
322(63, 'RN', 'DIYAH POSORINI, S.Pd.'),
323(64, 'PJ', 'PUJO UTOMO, S.Si.'),
324(65, 'SU', 'SAMSUDIN, S.Pd'),
325(66, 'AB', 'ARIEF BUDIMAN, S.Pd'),
326(67, 'DJ', 'DANANG NOVIAJI P., S.Pd'),
327(68, 'AZ', 'ANY QOTUZZAHROH, S.Pd'),
328(69, 'RJ', 'RITA  FIYANI, S.Pd'),
329(70, 'BD', 'BUDIRJO, S.Pd.'),
330(71, 'CR', 'Drs, CARSONO'),
331(72, 'KD', 'KADARISMAN, M.Pd'),
332(73, 'NH', 'NURHADI, S.Pd.'),
333(74, 'AI', 'ADE WARASTUTI, S.Pd.,M.T'),
334(75, 'HP', 'HERI PRAMONO,M.Pd'),
335(76, 'SO', 'SURIPTO, S.Pd.'),
336(77, 'SR', 'SRI WAHYUNINGSIH, S.Pd.'),
337(78, 'AU', 'AMALIA UTAMI, S.Pd.'),
338(79, 'HA', 'HARTANTO, S.Pd.'),
339(80, 'TO', 'TOTO BINA PUTRA, S.Pi.'),
340(81, 'AQ', 'ABDUL QODIR JUNAEDI, S.Pi.'),
341(82, 'BA', 'BAMBANG ANDI, S.Pd.'),
342(83, 'JE', 'SRI REJEKI, S.Pi.'),
343(84, 'RO', 'ROHAM ARIS ZAKI, S.Kel.'),
344(85, 'DN', 'DANANG RISTANTO, S.T.'),
345(86, 'AO', 'ANGGARA BUDI LAKSONO, S.Kel.'),
346(87, 'SS', 'SUSI KRISTIANINGSIH, S.Pi.'),
347(88, 'OV', 'OLIVIA HIMAWATI M., S.Pi'),
348(89, 'HD', 'HADI RAHARJO, S.Pi'),
349(90, 'SC', 'SUCIATI, S. T.'),
350(91, 'ID', 'IDA HARTONO, S.Pi.'),
351(92, 'SH', 'SACHRONI, S.ST.Pi'),
352(93, 'GY', 'SUGIYONO, S.ST.Pi'),
353(94, 'RB', 'RAHMAT BASUKI, S.ST.Pi'),
354(95, 'GN', 'SIGIT GUNAWAN, ST'),
355(96, 'IM', 'IKHDA MUSYAROFAH, S.Pi'),
356(97, 'AW', 'ADZWAR MUDZTAHID, S.Pi'),
357(98, 'EH', 'EKO HARYANTO, S.Pd'),
358(99, 'PT', 'PATHUDIN, S.Pd.'),
359(100, 'HS', 'HASANUDIN, S.Pd.'),
360(101, 'HY', 'HERYANTO, S.Pd.'),
361(102, 'MT', 'Drs. MIFTAHUDIN'),
362(103, 'KS', 'KUSNANTO, S.Pd.'),
363(104, 'SM', 'MOH. KHAERUS SALIM, S.Pd, MT'),
364(105, 'PG', 'SUPANGAT, S.Pd.'),
365(106, 'RP', 'RAKIM, S.Pd.'),
366(107, 'RS', 'Drs. RUSMANTO US, MT'),
367(108, 'LS', 'LENY SETYORINI, S.Pd.'),
368(109, 'HM', 'HERMAN SETIAWAN,S.Pd'),
369(110, 'SB', 'NIN SUBKHANUDIN FADHILA, ST,M.M'),
370(111, 'WJ', 'ARI ADI WIJAYANTO, S.Pd'),
371(112, 'IW', 'IWAN DARMAWAN, S.Pd.'),
372(113, 'RK', 'RISKANDI, S.Pd.'),
373(114, 'MH', 'MIFTAKHUL HUDA, S.Pd.'),
374(116, 'NK', 'NIKE HARDIANTI, S.Pd'),
375(117, 'JN', 'JAENUDIN, S.Pd.M.T'),
376(119, 'AD', 'ADE PRASETYO, S.Pd.'),
377(120, 'SP', 'SUPRIYADI, S.Pd.'),
378(121, 'UJ', 'UJI HAMZAH, S.Pd.'),
379(122, 'TT', 'TITIK WIDIYANTI, S.Pd.'),
380(123, 'TS', 'TRIO SAFARI, S.Pd.'),
381(124, 'KH', 'KHALIMAH, S.T.'),
382(125, 'DR', 'AKHMAD DARSONO, S.T.'),
383(126, 'NY', 'NURYADI, S.Pd.,M.Kom'),
384(128, 'UL', 'ACHMAD MAULIA T, S.T. M.Kom'),
385(129, 'MI', 'MOHAMAD ISMAIL,  M.Kom'),
386(130, 'HU', 'HURU SETIAWAN, S.Kom.'),
387(132, 'PM', 'PARMAN SUYADI, S.Kom'),
388(133, 'RR', 'RIKA DARNETI, S.Kom'),
389(134, 'NO', 'AKHMAD NOVAL, S.Kom'),
390(135, 'DE', 'DWI ENDARTO, S.T.'),
391(136, 'WY', 'WAHYUDIN, S.Kom.'),
392(137, 'RZ', 'RIZKY KURNIAWAN, S.Kom.'),
393(138, 'PS', 'APIK SHOKHIDIN, S.Kom.'),
394(139, 'SW', 'SARWONO, M.Kom'),
395(140, 'EU', 'EUIS MURNIASIH, S.Kom'),
396(141, 'RU', 'SRI RAHAYU,S.Pd'),
397(150, 'BM', 'BENY MULYADI, S.Pd.'),
398(151, 'AY', 'AGUNG RIYADI, S.Pd.'),
399(152, 'BR', 'MOH. BURHAN, S.Pd.'),
400(153, 'HE', 'Drs. MOH. HERMANSYAH'),
401(154, 'AS', 'AGUS SUPRIYANTO, S.Pd'),
402(155, 'EK', 'EKO RUDIONO, S.Pd.'),
403(156, 'DP', 'DWI PRIYANTO, S.Pd.'),
404(157, 'WN', 'WINARSO, S.Pd.');
405
406--
407-- Trigger `m_guru`
408--
409DROP TRIGGER IF EXISTS `hapus_guru`;
410DELIMITER //
411CREATE TRIGGER `hapus_guru` AFTER DELETE ON `m_guru`
412 FOR EACH ROW BEGIN
413DELETE FROM m_soal WHERE m_soal.id_guru = OLD.id;
414DELETE FROM m_admin WHERE m_admin.level = 'guru' AND m_admin.kon_id = OLD.id;
415DELETE FROM tr_guru_mapel WHERE tr_guru_mapel.id_guru = OLD.id;
416DELETE FROM tr_guru_tes WHERE tr_guru_tes.id_guru = OLD.id;
417END
418//
419DELIMITER ;
420
421-- --------------------------------------------------------
422
423--
424-- Struktur dari tabel `m_mapel`
425--
426
427CREATE TABLE IF NOT EXISTS `m_mapel` (
428  `id` int(6) NOT NULL AUTO_INCREMENT,
429  `nama` varchar(100) NOT NULL,
430  PRIMARY KEY (`id`)
431) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=158 ;
432
433--
434-- Dumping data untuk tabel `m_mapel`
435--
436
437INSERT INTO `m_mapel` (`id`, `nama`) VALUES
438(1, 'Bahasa Indonesia Kelas 10'),
439(2, 'Bahasa Inggris Kelas 10'),
440(3, 'Matematika kelas 10'),
441(4, 'Kimia kelas 10'),
442(5, 'Bahasa Inggris Kelas 11'),
443(6, 'Matematika Kelas 11'),
444(7, 'Matematika Kelas 12'),
445(8, 'Bahasa Indonesia Kelas 11'),
446(9, 'Bahasa Indonesia Kelas 12'),
447(10, 'Bahasa Inggris Kelas 12'),
448(11, 'Biologi Kelas 10'),
449(12, 'Biologi Kelas 11'),
450(13, 'Pendidikan Agama dan Budi Pekerti kelas 10'),
451(14, 'Pendidikan Agama dan Budi Pekerti Kelas 11'),
452(15, 'Pendidikan Agama dan Budi Pekerti Kelas 12'),
453(16, 'Penjasorkes Kelas 10'),
454(17, 'Penjasorkes Kelas 11'),
455(18, 'Penjasorkes Kelas 12'),
456(19, 'PPKN Kelas 10'),
457(20, 'PPKN Kelas 11'),
458(21, 'PPKN Kelas 12'),
459(22, 'Sejarah Indonesia Kelas 10'),
460(23, 'Sejarah Indonesia Kelas 11'),
461(24, 'Sejarah Indonesia Kelas 12'),
462(25, 'Seni Budaya Kelas 10'),
463(26, 'Seni Budaya Kelas 11'),
464(27, 'Seni Budaya Kelas 12'),
465(28, 'Bahasa Jawa Kelas 10'),
466(29, 'Bahasa Jawa Kelas 11'),
467(30, 'Bahasa Jawa Kelas 12'),
468(31, 'Fisika Kelas 10'),
469(32, 'Fisika Kelas 11'),
470(33, 'Pemrograman Dasar Kelas 10'),
471(34, 'Pemrograman Dasar Kelas 11'),
472(35, 'Sistem Komputer Kelas 10'),
473(36, 'Sistem Komputer Kelas 11'),
474(37, 'Simulasi Dan Komunikasi Digital Kelas 10'),
475(38, 'Permesinan Kapal Penangkap Ikan kelas 10'),
476(39, 'Bangunan dan Stabilitas Kapal Penangkap Ikan Kelas 10'),
477(40, 'Hukum Maritim dan Peraturan Perikanan Kelas 10'),
478(41, 'Tenik Penangkapan Ikan Kelas 10'),
479(42, 'Tata Laksana Perikanan Yang Bertanggung Jawab KLS 10'),
480(43, 'Bahasa Inggris Maritim dan Perikanan Kelas 10'),
481(44, 'Prosedur Darurat Kelas 10'),
482(45, 'Kerja Bengkel dan Gambar Teknik Kelas 10'),
483(46, 'Dasar Listrik dan Elektronika Kelas 10'),
484(47, 'Gambar Teknik Otomotif Kelas 10'),
485(48, 'Teknologi Dasar Otomotif  Kelas 10'),
486(49, 'Pekerjaan Dasar Otomotif Kelas 10'),
487(50, 'Gambar Teknik Mesin Kelas 10'),
488(51, 'Dasar Teknik Mesin Kelas 10'),
489(52, 'Teknologi Mekanik,Mekanika tehnik dan EM Kelas 10'),
490(53, 'Dasar Kontruksi Bangunan  Kelas 10'),
491(54, 'Dasar Kontruksi Bangunan  Kelas 10'),
492(55, 'Komputer dan Jaringan Dasar Kelas 10'),
493(56, 'Dasar Desain Grafis Kelas 10'),
494(57, 'Instalasi Tenaga Penggerak Kapal Penangkap Ikan Kelas 10'),
495(58, 'Gambar Kontruksi Bangunan Kelas 11'),
496(59, 'Gambar Kontruksi Bangunan Kelas 12'),
497(60, 'Gambar Interior dan Ekterior Bangunan  Gedung Kelas 11'),
498(61, 'Gambar Interior dan Ekterior Bangunan  Gedung Kelas 12'),
499(62, 'Menggambar Dengan Perangkat Lunak Kelas 11'),
500(63, 'Menggambar Dengan Perangkat Lunak Kelas 12'),
501(64, 'Teknik Gambar Manukfatur Kelas 11'),
502(65, 'Teknik Pemesinan Bubut Kelas 11'),
503(66, 'Teknik Pemesinan Bubut Kelas 12'),
504(67, 'Teknik Pemesinan Frais Kelas 11'),
505(68, 'Teknik Pemesinan Frais Kelas 12'),
506(69, 'Teknik Pemesinan Gerinda Kelas 12'),
507(70, 'Teknik Pemesinan CNC Kelas 12'),
508(71, 'Pemeliharaan Mesin Kendaraan Ringan Kelas 11'),
509(72, 'Pemeliharaan Mesin Kendaraan Ringan Kelas 12'),
510(73, 'Pemeliharaan Sasis dan Pemindah Tenaga Kendaraan Ringan Kelas 11'),
511(74, 'Pemeliharaan Sasis dan Pemindah Tenaga Kendaraan Ringan Kelas 12'),
512(75, 'Pemelihara Kelistrikan Kendaraan Ringan Kelas 11'),
513(76, 'Pemelihara Kelistrikan Kendaraan Ringan Kelas 12'),
514(77, 'Pemeliharaan Mesin Sepeda Motor Kelas 11'),
515(78, 'Pemeliharaan Mesin Sepeda Motor Kelas 12'),
516(80, 'Pemeliharaan Sasis Sepeda Motor Kelas 12'),
517(81, 'Pemeliharaan Kelistrikan Sepeda Motor Kelas 11'),
518(82, 'Pemeliharaan Kelistrikan Sepeda Motor Kelas 12'),
519(83, 'Pemeliharaan Sasis Sepeda Motor Kelas 11'),
520(84, 'Penerapan Rangkaian Elektronika Kelas 11'),
521(85, 'Perekayasaan Sistem Audio Kelas 11'),
522(86, 'Perekayasaan Sistem Audio dan Televisi Kelas 11'),
523(87, 'Perekayasaan Sistem Antena Kelas 11'),
524(88, 'Perencanaan dan Instalasi Sistem Audio Kelas 12'),
525(89, 'Perencanaan dan Instal.asi Sistem Antena Penerima Kelas 12'),
526(90, 'Perbaikan dan Perawatan Peralatan Elektronika AV kelas 12'),
527(91, 'Pelayaran Kapal Perikanan Kelas 11'),
528(92, 'Pelayaran Kapal Perikanan Kelas 12'),
529(93, 'Komunikasi dan Dinas Jaga Kapal perikanan Kelas 11'),
530(94, 'Komunikasi dan Dinas Jaga Kapal perikanan Kelas 12'),
531(95, 'Manajemen Kapal Perikanan Kelas 11'),
532(96, 'Manajemen Kapal Perikanan Kelas 12'),
533(97, 'Teknik dan Alat Penangkap Ikan Kelas 11'),
534(98, 'Teknik dan Alat Penangkap Ikan Kelas 12'),
535(99, 'Motor Diesel dan Instalasi Tenaga Kapal Perikanan Kelas 11'),
536(100, 'Motor Diesel dan Instalasi Tenaga Kapal Perikanan Kelas 12'),
537(101, 'Pesawat Bantu Kapal Perikanan Kelas 11'),
538(102, 'Pesawat Bantu Kapal Perikanan Kelas 12'),
539(103, 'Kelistrikan, Sistem Pengendalian dan Otomatisasi KP Kelas 11'),
540(104, 'Kelistrikan, Sistem Pengendalian dan Otomatisasi KP Kelas 12'),
541(105, 'Mesin Pendingin Kapal Perikanan Kelas 11'),
542(106, 'Mesin Pendingin Kapal Perikanan Kelas 12'),
543(107, 'Komputer Terapan Kelas 11'),
544(108, 'Komunikasi Data Kelas 11'),
545(109, 'Sistem Operasi Jaringan Kelas 11'),
546(110, 'Sistem Operasi Jaringan Kelas 12'),
547(111, 'Administrasi Server Kelas 11'),
548(112, 'Administrasi Server Kelas 12'),
549(113, 'Rancang Bangun Jaringan Kelas 11'),
550(114, 'Rancang Bangun Jaringan Kelas 12'),
551(115, 'Jaringan Nirkabel Kelas 12'),
552(116, 'Keamanan Jaringan Kelas 12'),
553(117, 'Troubleshooting Jaringan Kelas 12'),
554(118, 'Kerja Proyek Teknik Komputer dan Jaringan Kelas 12'),
555(119, 'Desain Multimedia kelas 11'),
556(120, 'Teknik Animasi 2 Dimensi Kelas 11'),
557(121, 'Teknik Animasi 3 Dimensi Kelas 11'),
558(122, 'Teknik Animasi 3 Dimensi Kelas 12'),
559(123, 'Pengolahan Citra Digital kelas 11'),
560(124, 'Pengolahan Citra Digital kelas 12'),
561(125, 'Komposisi Foto Digital kelas 11'),
562(126, 'Teknik Pengambilan  Gambar Bergerak Kelas 12'),
563(127, 'Teknik Pengolahan Audio Kelas 12'),
564(128, 'Teknik Pengolahan Video Kelas 12'),
565(129, 'Desain Multimedia Interaktif Kelas 12'),
566(130, 'Kerja Proyek MultiMedia Kelas 12'),
567(132, 'Prakarya dan Kewirausahaan kelas 10'),
568(133, 'Prakarya dan Kewirausahaan kelas 11'),
569(134, 'Prakarya dan Kewirausahaan kelas 12'),
570(135, 'Kimia Kelas 11'),
571(136, 'Ilmu Bahan, Bahan Bakar, dan Pelumas kelas 11'),
572(137, 'Ilmu Bahan, Bahan Bakar, dan Pelumas kelas 12'),
573(138, 'Sistem Pengendalian dan Otomatisasi Kelas 11'),
574(139, 'Sistem Pengendalian dan Otomatisasi Kelas 12'),
575(140, 'Dinas Jaga Kelas 11'),
576(142, 'Perawatan dan Perbaikan Mesin Kapal Kelas 11'),
577(143, 'Perawatan dan Perbaikan Mesin Kapal Kelas 12'),
578(144, 'Bahan dan Alat Tangkap Penangkap Ikan Kelas 11'),
579(146, 'Menggambar Teknik Kelas 11'),
580(148, 'Kerja Bengkel Kelas 11'),
581(149, 'Kerja Bengkel Kelas 12'),
582(150, 'Produk Kreatif Dan Kewirausahaan Kelas 11'),
583(151, 'Produk Kreatif Dan Kewirausahaan Kelas 12'),
584(152, 'Listrik Kapal Penangkap Ikan Kelas 11'),
585(153, 'Listrik Kapal Penangkap Ikan Kelas 12'),
586(154, 'Gambar Teknik Kelas 10'),
587(155, 'Mekanika Teknik Kelas 10'),
588(156, 'Dasar - Dasar Kontruksi Bangunan dan Tknik Pengkuran Tanah Kelas 10'),
589(157, 'Dasar Program Audio Video Kelas 10');
590
591--
592-- Trigger `m_mapel`
593--
594DROP TRIGGER IF EXISTS `hapus_mapel`;
595DELIMITER //
596CREATE TRIGGER `hapus_mapel` AFTER DELETE ON `m_mapel`
597 FOR EACH ROW BEGIN
598DELETE FROM m_soal WHERE m_soal.id_mapel = OLD.id;
599DELETE FROM tr_guru_mapel WHERE tr_guru_mapel.id_mapel = OLD.id;
600DELETE FROM tr_guru_tes WHERE tr_guru_tes.id_mapel = OLD.id;
601DELETE FROM tr_siswa_mapel WHERE tr_siswa_mapel.id_mapel = OLD.id;
602END
603//
604DELIMITER ;
605
606-- --------------------------------------------------------
607
608--
609-- Struktur dari tabel `m_siswa`
610--
611
612CREATE TABLE IF NOT EXISTS `m_siswa` (
613  `id` int(6) NOT NULL AUTO_INCREMENT,
614  `nama` varchar(100) NOT NULL,
615  `nim` varchar(50) NOT NULL,
616  `jurusan` varchar(50) NOT NULL,
617  PRIMARY KEY (`id`)
618) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=81 ;
619
620--
621-- Dumping data untuk tabel `m_siswa`
622--
623
624INSERT INTO `m_siswa` (`id`, `nama`, `nim`, `jurusan`) VALUES
625(13, 'andy', '111', '10 TKJ 2'),
626(14, 'yunita', '1', '10 TKJ 2'),
627(15, 'kevin', '2', '10 TGB 1'),
628(18, 'AHMAD NURUL FAUZI', '165510', 'XI TKJ'),
629(19, 'ALIF ARRIZKI YUSEN', '165511', 'XI TKJ'),
630(20, 'ANGGITA ANGELIANA AGUSTIN', '165512', 'XI TKJ'),
631(21, 'ARIF BUDIMAN', '165513', 'XI TKJ'),
632(22, 'AULIA TRI NURYANI', '165514', 'XI TKJ'),
633(23, 'AYU SETIYA NINGRUM', '165515', 'XI TKJ'),
634(24, 'DIMAS SUSYANTO', '165516', 'XI TKJ'),
635(25, 'DWI SEPTI ALDILLA', '165517', 'XI TKJ'),
636(26, 'ELSA NADYA PUTRI ASARI', '165518', 'XI TKJ'),
637(27, 'FARAH SEPTIANA WULANDARI', '165519', 'XI TKJ'),
638(28, 'FREDO FREDIANTO', '165520', 'XI TKJ'),
639(29, 'GHINA RAUDHATUL JANNAH', '165521', 'XI TKJ'),
640(30, 'HIDAYAH SETIAWATI', '165522', 'XI TKJ'),
641(31, 'IMAM TAUFIK RAMADHON', '165523', 'XI TKJ'),
642(32, 'INTAN NUR FADHILAH', '165524', 'XI TKJ'),
643(33, 'JULIAN MIA PUSPITA', '165525', 'XI TKJ'),
644(34, 'KHAERULI ADITIA', '165526', 'XI TKJ'),
645(35, 'LAZUARDI WIDYA PRATAMA', '165527', 'XI TKJ'),
646(36, 'M. RIZQI FAUZI MAKSUM', '165528', 'XI TKJ'),
647(37, 'MOHAMAD RIZAL KHAMAMI', '165529', 'XI TKJ'),
648(38, 'MUHAMMAD BAYU AJI', '165530', 'XI TKJ'),
649(39, 'MUHAMMAD FARKHAN NASTAINU', '165531', 'XI TKJ'),
650(40, 'NASHEER MUHAMMAD KHANI', '165532', 'XI TKJ'),
651(41, 'RAFI ARINANDA PUTRA', '165533', 'XI TKJ'),
652(42, 'RIYAN AKBAR MAULANA', '165534', 'XI TKJ'),
653(43, 'RIZKY PRATAMA', '165535', 'XI TKJ'),
654(44, 'UMUL QOIS', '165536', 'XI TKJ'),
655(45, 'VIVI ASFRILIANINGRUM', '165537', 'XI TKJ'),
656(46, 'WAFIQ AZIZAH', '165538', 'XI TKJ'),
657(47, 'WILDAN ADHI UTOMO', '165539', 'XI TKJ'),
658(48, 'WINDA JUNIAR', '165540', 'XI TKJ'),
659(49, 'YULI LESTARI', '165541', 'XI TKJ'),
660(50, 'ADITIYA GUNAWAN', '155044', 'XII TKJ'),
661(51, 'ALIF RIVALDI ARDIANSYAH', '155045', 'XII TKJ'),
662(52, 'AMALIYAH', '155046', 'XII TKJ'),
663(53, 'BAGUS SETIAWAN', '155047', 'XII TKJ'),
664(54, 'DANIEL OWEN SETIAWAN', '155048', 'XII TKJ'),
665(55, 'DEDEN FATIH', '155049', 'XII TKJ'),
666(56, 'DUROTUN NAFISAH', '155050', 'XII TKJ'),
667(57, 'DWI SATRIA INDRIAWAN', '155051', 'XII TKJ'),
668(58, 'EVIN APRILIYAN FAHMI', '155052', 'XII TKJ'),
669(59, 'FAHREZA RIZQI DHARMAWAN', '155053', 'XII TKJ'),
670(60, 'FIRLY SEPTIANA', '155055', 'XII TKJ'),
671(61, 'GUSTIAN ARYA MAHENDRA', '155056', 'XII TKJ'),
672(62, 'HIYANG ZELIKA', '155057', 'XII TKJ'),
673(63, 'MAXBIAGIE SURYA PRATAMA', '155058', 'XII TKJ'),
674(64, 'MOCHAMMAD FAUZAN GHOZALI', '155059', 'XII TKJ'),
675(65, 'MOH. NUR FADHOLI', '155060', 'XII TKJ'),
676(66, 'MOHAMMAD FAIQ FADHILLAH', '155061', 'XII TKJ'),
677(67, 'MOHAMMAD RIZAL ULIL ALBAB', '155062', 'XII TKJ'),
678(68, 'MOHAMMAD RIZKY PRATAMA', '155063', 'XII TKJ'),
679(69, 'MUHAMMAD ADHA ILHAM TOPANI', '155064', 'XII TKJ'),
680(70, 'MUHAMMAD FAJAR SONY SETYAWAN', '155065', 'XII TKJ'),
681(71, 'NURZAHRON MUSYAFFA', '155066', 'XII TKJ'),
682(72, 'OGI MURDIANTO', '155067', 'XII TKJ'),
683(73, 'QIRANI RIFA ANNISA', '155068', 'XII TKJ'),
684(74, 'RIAN SYARIF', '155069', 'XII TKJ'),
685(75, 'RIFKI BAHTIAR', '155070', 'XII TKJ'),
686(76, 'SITI KHODIJAH', '155071', 'XII TKJ'),
687(77, 'SITI KHOTIMAH', '155072', 'XII TKJ'),
688(78, 'SITI NOFI OKTAFIANI', '155073', 'XII TKJ'),
689(79, 'SITI NURKHASANAH', '155074', 'XII TKJ'),
690(80, 'SUMIYATI', '155075', 'XII TKJ');
691
692--
693-- Trigger `m_siswa`
694--
695DROP TRIGGER IF EXISTS `hapus_siswa`;
696DELIMITER //
697CREATE TRIGGER `hapus_siswa` AFTER DELETE ON `m_siswa`
698 FOR EACH ROW BEGIN
699DELETE FROM tr_ikut_ujian WHERE tr_ikut_ujian.id_user = OLD.id;
700END
701//
702DELIMITER ;
703
704-- --------------------------------------------------------
705
706--
707-- Struktur dari tabel `m_soal`
708--
709
710CREATE TABLE IF NOT EXISTS `m_soal` (
711  `id` int(6) NOT NULL AUTO_INCREMENT,
712  `id_guru` int(6) NOT NULL,
713  `id_mapel` int(6) NOT NULL,
714  `bobot` int(2) NOT NULL,
715  `file` varchar(150) NOT NULL,
716  `tipe_file` varchar(50) NOT NULL,
717  `soal` longtext NOT NULL,
718  `opsi_a` longtext NOT NULL,
719  `opsi_b` longtext NOT NULL,
720  `opsi_c` longtext NOT NULL,
721  `opsi_d` longtext NOT NULL,
722  `opsi_e` longtext NOT NULL,
723  `jawaban` varchar(5) NOT NULL,
724  `tgl_input` datetime NOT NULL,
725  `jml_benar` int(6) NOT NULL,
726  `jml_salah` int(6) NOT NULL,
727  PRIMARY KEY (`id`),
728  KEY `id_guru` (`id_guru`),
729  KEY `id_mapel` (`id_mapel`)
730) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=74 ;
731
732--
733-- Dumping data untuk tabel `m_soal`
734--
735
736INSERT INTO `m_soal` (`id`, `id_guru`, `id_mapel`, `bobot`, `file`, `tipe_file`, `soal`, `opsi_a`, `opsi_b`, `opsi_c`, `opsi_d`, `opsi_e`, `jawaban`, `tgl_input`, `jml_benar`, `jml_salah`) VALUES
737(63, 8, 5, 1, '', '', 'Ukuran Border dalam ….?', '#####KM/H', '#####CM', '#####Liter', '#####Pixel', '#####Mph', 'A', '2017-10-11 09:38:05', 3, 3),
738(64, 8, 5, 2, '', '', 'Atribut yang digunakan untuk menentukan sumber berkas suara atau video adalah.', '#####SRC ', '#####LOOP', '#####UNITS', '#####AUTOSTART', '#####HIDDEN', 'B', '2017-10-11 09:38:05', 6, 0),
739(65, 8, 5, 3, '', '', 'yang digunakan untuk memanipulasi data adalah?', '#####REPORT', '#####QUERY', '#####FORM ', '#####TABLE ', '#####COMMIT', 'C', '2017-10-11 09:38:05', 4, 2),
740(66, 8, 5, 1, '', '', 'Perintah melihat pada database SQl ?', '#####create', '#####Sql', '#####insert', '#####database', '#####mysql', 'D', '2017-10-11 09:38:05', 2, 4),
741(67, 8, 5, 2, '', '', 'perintah untuk membuat table', '#####insert', '#####create', '#####database', '#####show', '#####select', 'E', '2017-10-11 09:38:05', 4, 2),
742(68, 8, 5, 3, '', '', 'perintah untuk memanipulasi table', '#####insert', '#####alter', '#####show', '#####select', '#####commit', 'A', '2017-10-11 09:38:05', 1, 5),
743(69, 8, 5, 1, '', '', 'perintah untuk merubah data yang sudah ada pada mysql', '#####create', '#####update', '#####mysql', '#####delete', '#####insert', 'B', '2017-10-11 09:38:05', 3, 3),
744(70, 8, 5, 2, '', '', 'perintah untuk menghapus database pada mysql', '#####delete', '#####crown', '#####update', '#####insert', '#####alter', 'C', '2017-10-11 09:38:05', 4, 2),
745(71, 8, 5, 3, '', '', 'topologi jaringan yang sering digunakan pada lab komputer', '#####star', '#####bus', '#####ring', '#####token ring', '#####mesh', 'D', '2017-10-11 09:38:05', 2, 4),
746(72, 8, 5, 1, '', '', 'cara membuat jaringan wifi local di komputer menggunakan', '#####adhoc', '#####lan card', '#####utp', '#####stp', '#####coaxial', 'E', '2017-10-11 09:38:05', 0, 6),
747(73, 8, 5, 1, 'gambar_soal_73.jpg', 'image/jpeg', '', 'gja_73.jpg#####', 'gjb_73.jpg#####', '#####', 'gjd_73.jpg#####', 'gje_73.jpg#####', 'A', '0000-00-00 00:00:00', 0, 0);
748
749-- --------------------------------------------------------
750
751--
752-- Struktur dari tabel `tr_guru_mapel`
753--
754
755CREATE TABLE IF NOT EXISTS `tr_guru_mapel` (
756  `id` int(6) NOT NULL AUTO_INCREMENT,
757  `id_guru` int(6) NOT NULL,
758  `id_mapel` int(6) NOT NULL,
759  PRIMARY KEY (`id`),
760  KEY `id_guru` (`id_guru`),
761  KEY `id_mapel` (`id_mapel`)
762) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1367 ;
763
764--
765-- Dumping data untuk tabel `tr_guru_mapel`
766--
767
768INSERT INTO `tr_guru_mapel` (`id`, `id_guru`, `id_mapel`) VALUES
769(24, 8, 5),
770(25, 10, 4),
771(26, 11, 11),
772(27, 11, 12),
773(28, 12, 11),
774(29, 12, 12),
775(30, 13, 13),
776(31, 13, 14),
777(32, 13, 15),
778(33, 14, 13),
779(34, 14, 14),
780(35, 14, 15),
781(36, 15, 13),
782(37, 15, 14),
783(38, 15, 15),
784(39, 16, 13),
785(40, 16, 14),
786(41, 16, 15),
787(42, 24, 1),
788(43, 24, 8),
789(44, 24, 9),
790(45, 25, 1),
791(46, 25, 8),
792(47, 25, 9),
793(48, 26, 1),
794(49, 26, 8),
795(50, 26, 9),
796(51, 27, 1),
797(52, 27, 8),
798(53, 27, 9),
799(54, 28, 1),
800(55, 28, 8),
801(56, 28, 9),
802(57, 29, 1),
803(58, 29, 8),
804(59, 29, 9),
805(60, 30, 2),
806(62, 30, 10),
807(63, 31, 2),
808(64, 31, 5),
809(65, 31, 10),
810(66, 30, 5),
811(67, 34, 2),
812(68, 34, 5),
813(69, 34, 10),
814(70, 33, 2),
815(71, 33, 5),
816(72, 33, 10),
817(73, 32, 2),
818(74, 32, 5),
819(75, 32, 10),
820(76, 35, 3),
821(77, 35, 6),
822(78, 35, 7),
823(79, 36, 3),
824(80, 36, 6),
825(81, 36, 7),
826(82, 37, 3),
827(83, 37, 6),
828(84, 37, 7),
829(85, 38, 3),
830(86, 38, 6),
831(87, 38, 7),
832(88, 39, 3),
833(89, 39, 6),
834(90, 39, 7),
835(91, 40, 3),
836(92, 40, 6),
837(93, 40, 7),
838(94, 41, 3),
839(95, 41, 6),
840(96, 41, 7),
841(97, 42, 3),
842(98, 42, 6),
843(99, 42, 7),
844(100, 43, 16),
845(101, 43, 17),
846(102, 43, 18),
847(103, 44, 16),
848(104, 44, 17),
849(105, 44, 18),
850(106, 45, 16),
851(107, 45, 17),
852(108, 45, 18),
853(109, 46, 16),
854(110, 46, 17),
855(111, 46, 18),
856(112, 47, 19),
857(113, 47, 20),
858(114, 47, 21),
859(115, 48, 19),
860(116, 48, 20),
861(117, 48, 21),
862(118, 49, 19),
863(119, 49, 20),
864(120, 49, 21),
865(121, 50, 132),
866(122, 50, 133),
867(123, 50, 134),
868(124, 51, 132),
869(125, 51, 133),
870(126, 51, 134),
871(127, 52, 132),
872(128, 52, 133),
873(129, 52, 134),
874(130, 53, 25),
875(131, 53, 26),
876(132, 53, 27),
877(133, 54, 22),
878(134, 54, 23),
879(135, 54, 24),
880(136, 55, 22),
881(137, 55, 23),
882(138, 55, 24),
883(139, 56, 22),
884(140, 56, 23),
885(141, 56, 24),
886(142, 57, 22),
887(143, 57, 23),
888(144, 57, 24),
889(145, 58, 4),
890(146, 58, 135),
891(147, 59, 4),
892(148, 59, 135),
893(149, 60, 4),
894(150, 60, 135),
895(151, 61, 4),
896(152, 61, 135),
897(153, 62, 31),
898(154, 62, 32),
899(155, 63, 31),
900(156, 63, 32),
901(157, 64, 31),
902(158, 64, 32),
903(159, 65, 25),
904(160, 65, 26),
905(161, 65, 27),
906(162, 66, 25),
907(163, 66, 26),
908(164, 66, 27),
909(165, 67, 28),
910(166, 67, 29),
911(167, 67, 30),
912(168, 68, 28),
913(169, 68, 29),
914(170, 68, 30),
915(171, 69, 28),
916(172, 69, 29),
917(173, 69, 30),
918(174, 97, 37),
919(175, 108, 37),
920(176, 78, 37),
921(177, 104, 37),
922(178, 109, 37),
923(179, 101, 37),
924(180, 110, 37),
925(181, 19, 37),
926(182, 80, 11),
927(183, 80, 12),
928(184, 80, 38),
929(185, 80, 39),
930(186, 80, 40),
931(187, 80, 41),
932(188, 80, 42),
933(189, 80, 43),
934(190, 80, 44),
935(191, 80, 136),
936(192, 80, 137),
937(193, 80, 138),
938(194, 80, 139),
939(195, 80, 140),
940(196, 80, 142),
941(197, 80, 143),
942(198, 80, 144),
943(199, 80, 146),
944(200, 80, 148),
945(201, 80, 149),
946(202, 80, 150),
947(203, 80, 151),
948(204, 80, 99),
949(205, 80, 100),
950(206, 80, 101),
951(207, 80, 102),
952(208, 80, 105),
953(209, 80, 106),
954(210, 81, 11),
955(211, 81, 12),
956(212, 81, 38),
957(213, 81, 39),
958(214, 81, 40),
959(215, 81, 41),
960(216, 81, 42),
961(217, 81, 43),
962(218, 81, 44),
963(219, 81, 99),
964(220, 81, 100),
965(221, 81, 101),
966(222, 81, 102),
967(223, 81, 105),
968(224, 81, 106),
969(225, 81, 136),
970(226, 81, 137),
971(227, 81, 138),
972(228, 81, 139),
973(229, 81, 140),
974(230, 81, 142),
975(231, 81, 143),
976(232, 81, 144),
977(233, 81, 146),
978(234, 81, 148),
979(235, 81, 149),
980(236, 81, 150),
981(237, 81, 151),
982(238, 80, 152),
983(239, 80, 153),
984(240, 81, 152),
985(241, 81, 153),
986(242, 82, 11),
987(243, 82, 12),
988(244, 82, 38),
989(245, 82, 39),
990(246, 82, 40),
991(247, 82, 41),
992(248, 82, 42),
993(249, 82, 43),
994(250, 82, 44),
995(251, 82, 99),
996(252, 82, 100),
997(253, 82, 101),
998(254, 82, 102),
999(255, 82, 105),
1000(256, 82, 106),
1001(257, 82, 136),
1002(258, 82, 137),
1003(259, 82, 138),
1004(260, 82, 139),
1005(261, 82, 140),
1006(262, 82, 142),
1007(263, 82, 143),
1008(264, 82, 144),
1009(265, 82, 150),
1010(266, 82, 151),
1011(267, 82, 152),
1012(268, 82, 153),
1013(269, 83, 11),
1014(270, 83, 12),
1015(271, 83, 38),
1016(272, 83, 39),
1017(273, 83, 40),
1018(274, 83, 41),
1019(275, 83, 42),
1020(276, 83, 43),
1021(277, 83, 44),
1022(278, 83, 99),
1023(279, 83, 100),
1024(280, 83, 101),
1025(281, 83, 102),
1026(282, 83, 105),
1027(283, 83, 106),
1028(284, 83, 136),
1029(285, 83, 137),
1030(286, 83, 138),
1031(287, 83, 139),
1032(288, 83, 140),
1033(289, 83, 142),
1034(290, 83, 143),
1035(291, 83, 144),
1036(292, 83, 146),
1037(293, 83, 148),
1038(294, 83, 149),
1039(295, 83, 150),
1040(296, 83, 151),
1041(297, 83, 152),
1042(298, 83, 153),
1043(299, 82, 146),
1044(300, 82, 148),
1045(301, 82, 149),
1046(302, 84, 11),
1047(303, 84, 12),
1048(304, 84, 38),
1049(305, 84, 39),
1050(306, 84, 40),
1051(307, 84, 41),
1052(308, 84, 42),
1053(309, 84, 43),
1054(310, 84, 44),
1055(311, 84, 99),
1056(312, 84, 100),
1057(313, 84, 101),
1058(314, 84, 102),
1059(315, 84, 105),
1060(316, 84, 106),
1061(317, 84, 136),
1062(318, 84, 137),
1063(319, 84, 138),
1064(320, 84, 139),
1065(321, 84, 140),
1066(322, 84, 142),
1067(323, 84, 143),
1068(324, 84, 144),
1069(325, 84, 146),
1070(326, 84, 148),
1071(327, 84, 149),
1072(328, 84, 150),
1073(329, 84, 151),
1074(330, 84, 152),
1075(331, 84, 153),
1076(332, 85, 11),
1077(333, 85, 12),
1078(334, 85, 38),
1079(335, 85, 39),
1080(336, 85, 40),
1081(337, 85, 41),
1082(338, 85, 42),
1083(339, 85, 43),
1084(340, 85, 44),
1085(341, 85, 99),
1086(342, 85, 100),
1087(343, 85, 101),
1088(344, 85, 102),
1089(345, 85, 105),
1090(346, 85, 106),
1091(347, 85, 136),
1092(348, 85, 137),
1093(349, 85, 138),
1094(350, 85, 139),
1095(351, 85, 140),
1096(352, 85, 142),
1097(353, 85, 143),
1098(354, 85, 144),
1099(355, 85, 146),
1100(356, 85, 148),
1101(357, 85, 149),
1102(358, 85, 150),
1103(359, 85, 151),
1104(360, 85, 152),
1105(361, 85, 153),
1106(362, 86, 11),
1107(363, 86, 12),
1108(364, 86, 38),
1109(365, 86, 39),
1110(366, 86, 40),
1111(367, 86, 41),
1112(368, 86, 42),
1113(369, 86, 43),
1114(370, 86, 44),
1115(371, 86, 99),
1116(372, 86, 100),
1117(373, 86, 101),
1118(374, 86, 102),
1119(375, 86, 105),
1120(376, 86, 106),
1121(377, 86, 136),
1122(378, 86, 137),
1123(379, 86, 138),
1124(380, 86, 139),
1125(381, 86, 140),
1126(382, 86, 142),
1127(383, 86, 143),
1128(384, 86, 144),
1129(385, 86, 146),
1130(386, 86, 148),
1131(387, 86, 149),
1132(388, 86, 150),
1133(389, 86, 151),
1134(390, 86, 152),
1135(391, 86, 153),
1136(392, 87, 11),
1137(393, 87, 12),
1138(394, 87, 38),
1139(395, 87, 39),
1140(396, 87, 40),
1141(397, 87, 41),
1142(398, 87, 42),
1143(399, 87, 43),
1144(400, 87, 44),
1145(401, 87, 99),
1146(402, 87, 100),
1147(403, 87, 101),
1148(404, 87, 102),
1149(405, 87, 105),
1150(406, 87, 106),
1151(407, 87, 136),
1152(408, 87, 137),
1153(409, 87, 138),
1154(410, 87, 139),
1155(411, 87, 140),
1156(412, 87, 142),
1157(413, 87, 143),
1158(414, 87, 144),
1159(415, 87, 146),
1160(416, 87, 148),
1161(417, 87, 149),
1162(418, 87, 150),
1163(419, 87, 151),
1164(420, 87, 152),
1165(421, 87, 153),
1166(422, 88, 11),
1167(423, 88, 12),
1168(424, 88, 38),
1169(425, 88, 39),
1170(426, 88, 40),
1171(427, 88, 41),
1172(428, 88, 42),
1173(429, 88, 43),
1174(430, 88, 44),
1175(431, 88, 99),
1176(432, 88, 100),
1177(433, 88, 101),
1178(434, 88, 102),
1179(435, 88, 105),
1180(436, 88, 106),
1181(437, 88, 136),
1182(438, 88, 137),
1183(439, 88, 138),
1184(440, 88, 139),
1185(441, 88, 140),
1186(442, 88, 142),
1187(443, 88, 143),
1188(444, 88, 144),
1189(445, 88, 146),
1190(446, 88, 148),
1191(447, 88, 149),
1192(448, 88, 150),
1193(449, 88, 151),
1194(450, 88, 152),
1195(451, 88, 153),
1196(452, 89, 11),
1197(453, 89, 12),
1198(454, 89, 38),
1199(455, 89, 39),
1200(456, 89, 40),
1201(457, 89, 41),
1202(458, 89, 42),
1203(459, 89, 43),
1204(460, 89, 44),
1205(461, 89, 99),
1206(462, 89, 100),
1207(463, 89, 101),
1208(464, 89, 102),
1209(465, 89, 105),
1210(466, 89, 106),
1211(467, 89, 136),
1212(468, 89, 137),
1213(469, 89, 138),
1214(470, 89, 139),
1215(471, 89, 140),
1216(472, 89, 142),
1217(473, 89, 143),
1218(474, 89, 144),
1219(475, 89, 146),
1220(476, 89, 148),
1221(477, 89, 149),
1222(478, 89, 150),
1223(479, 89, 151),
1224(480, 89, 152),
1225(481, 89, 153),
1226(482, 90, 11),
1227(483, 90, 12),
1228(484, 90, 38),
1229(485, 90, 39),
1230(486, 90, 40),
1231(487, 90, 41),
1232(488, 90, 42),
1233(489, 90, 43),
1234(490, 90, 44),
1235(491, 90, 99),
1236(492, 90, 100),
1237(493, 90, 101),
1238(494, 90, 102),
1239(495, 90, 105),
1240(496, 90, 106),
1241(497, 90, 136),
1242(498, 90, 137),
1243(499, 90, 138),
1244(500, 90, 139),
1245(501, 90, 140),
1246(502, 90, 142),
1247(503, 90, 143),
1248(504, 90, 144),
1249(505, 90, 146),
1250(506, 90, 148),
1251(507, 90, 149),
1252(508, 90, 150),
1253(509, 90, 151),
1254(510, 90, 152),
1255(511, 90, 153),
1256(512, 91, 11),
1257(513, 91, 12),
1258(514, 91, 38),
1259(515, 91, 39),
1260(516, 91, 40),
1261(517, 91, 41),
1262(518, 91, 42),
1263(519, 91, 43),
1264(520, 91, 44),
1265(521, 91, 99),
1266(522, 91, 100),
1267(523, 91, 101),
1268(524, 91, 102),
1269(525, 91, 105),
1270(526, 91, 106),
1271(527, 91, 136),
1272(528, 91, 137),
1273(529, 91, 138),
1274(530, 91, 139),
1275(531, 91, 140),
1276(532, 91, 142),
1277(533, 91, 143),
1278(534, 91, 144),
1279(535, 91, 146),
1280(536, 91, 148),
1281(537, 91, 149),
1282(538, 91, 150),
1283(539, 91, 151),
1284(540, 91, 152),
1285(541, 91, 153),
1286(542, 92, 11),
1287(543, 92, 12),
1288(544, 92, 38),
1289(545, 92, 39),
1290(546, 92, 40),
1291(547, 92, 41),
1292(548, 92, 42),
1293(549, 92, 43),
1294(550, 92, 44),
1295(551, 92, 99),
1296(552, 92, 100),
1297(553, 92, 101),
1298(554, 92, 102),
1299(555, 92, 105),
1300(556, 92, 106),
1301(557, 92, 136),
1302(558, 92, 137),
1303(559, 92, 138),
1304(560, 92, 139),
1305(561, 92, 140),
1306(562, 92, 142),
1307(563, 92, 143),
1308(564, 92, 144),
1309(565, 92, 146),
1310(566, 92, 148),
1311(567, 92, 149),
1312(568, 92, 150),
1313(569, 92, 151),
1314(570, 92, 152),
1315(571, 92, 153),
1316(572, 93, 11),
1317(573, 93, 12),
1318(574, 93, 38),
1319(575, 93, 39),
1320(576, 93, 40),
1321(577, 93, 41),
1322(578, 93, 42),
1323(579, 93, 43),
1324(580, 93, 44),
1325(581, 93, 99),
1326(582, 93, 100),
1327(583, 93, 101),
1328(584, 93, 102),
1329(585, 93, 105),
1330(586, 93, 106),
1331(587, 93, 136),
1332(588, 93, 137),
1333(589, 93, 138),
1334(590, 93, 139),
1335(591, 93, 140),
1336(592, 93, 142),
1337(593, 93, 143),
1338(594, 93, 144),
1339(595, 93, 146),
1340(596, 93, 148),
1341(597, 93, 149),
1342(598, 93, 150),
1343(599, 93, 151),
1344(600, 93, 152),
1345(601, 93, 153),
1346(602, 94, 11),
1347(603, 94, 12),
1348(604, 94, 38),
1349(605, 94, 39),
1350(606, 94, 40),
1351(607, 94, 41),
1352(608, 94, 42),
1353(609, 94, 43),
1354(610, 94, 44),
1355(611, 94, 99),
1356(612, 94, 100),
1357(613, 94, 101),
1358(614, 94, 102),
1359(615, 94, 105),
1360(616, 94, 106),
1361(617, 94, 136),
1362(618, 94, 137),
1363(619, 94, 138),
1364(620, 94, 139),
1365(621, 94, 140),
1366(622, 94, 142),
1367(623, 94, 143),
1368(624, 94, 144),
1369(625, 94, 146),
1370(626, 94, 148),
1371(627, 94, 149),
1372(628, 94, 150),
1373(629, 94, 151),
1374(630, 94, 152),
1375(631, 94, 153),
1376(632, 95, 11),
1377(633, 95, 12),
1378(634, 95, 38),
1379(635, 95, 39),
1380(636, 95, 40),
1381(637, 95, 41),
1382(638, 95, 42),
1383(639, 95, 43),
1384(640, 95, 44),
1385(641, 95, 99),
1386(642, 95, 100),
1387(643, 95, 101),
1388(644, 95, 102),
1389(645, 95, 105),
1390(646, 95, 106),
1391(647, 95, 136),
1392(648, 95, 137),
1393(649, 95, 138),
1394(650, 95, 139),
1395(651, 95, 140),
1396(652, 95, 142),
1397(653, 95, 143),
1398(654, 95, 144),
1399(655, 95, 146),
1400(656, 95, 148),
1401(657, 95, 149),
1402(658, 95, 150),
1403(659, 95, 151),
1404(660, 95, 152),
1405(661, 95, 153),
1406(662, 96, 11),
1407(663, 96, 12),
1408(664, 96, 38),
1409(665, 96, 39),
1410(666, 96, 40),
1411(667, 96, 41),
1412(668, 96, 42),
1413(669, 96, 43),
1414(670, 96, 44),
1415(671, 96, 45),
1416(672, 96, 99),
1417(673, 96, 100),
1418(674, 96, 101),
1419(675, 96, 102),
1420(676, 96, 105),
1421(677, 96, 106),
1422(678, 96, 136),
1423(679, 96, 137),
1424(680, 96, 138),
1425(681, 96, 139),
1426(682, 96, 140),
1427(683, 96, 142),
1428(684, 96, 143),
1429(685, 96, 144),
1430(686, 96, 146),
1431(687, 96, 148),
1432(688, 96, 149),
1433(689, 96, 150),
1434(690, 96, 151),
1435(691, 96, 152),
1436(692, 96, 153),
1437(693, 97, 11),
1438(694, 97, 12),
1439(695, 97, 38),
1440(696, 97, 39),
1441(697, 97, 40),
1442(698, 97, 41),
1443(699, 97, 42),
1444(700, 97, 43),
1445(701, 97, 44),
1446(702, 97, 99),
1447(703, 97, 100),
1448(704, 97, 101),
1449(705, 97, 102),
1450(706, 97, 105),
1451(707, 97, 106),
1452(708, 97, 136),
1453(709, 97, 137),
1454(710, 97, 138),
1455(711, 97, 139),
1456(712, 97, 140),
1457(713, 97, 142),
1458(714, 97, 143),
1459(715, 97, 144),
1460(716, 97, 146),
1461(717, 97, 148),
1462(718, 97, 149),
1463(719, 97, 150),
1464(720, 97, 151),
1465(721, 97, 152),
1466(722, 97, 153),
1467(723, 70, 58),
1468(724, 70, 59),
1469(725, 70, 60),
1470(726, 70, 61),
1471(727, 70, 62),
1472(728, 70, 63),
1473(729, 70, 154),
1474(730, 70, 155),
1475(731, 70, 156),
1476(732, 71, 58),
1477(733, 71, 59),
1478(734, 71, 60),
1479(735, 71, 61),
1480(736, 71, 62),
1481(737, 71, 63),
1482(738, 71, 154),
1483(739, 71, 155),
1484(740, 71, 156),
1485(741, 72, 58),
1486(742, 72, 59),
1487(743, 72, 60),
1488(744, 72, 61),
1489(745, 72, 62),
1490(746, 72, 63),
1491(747, 72, 154),
1492(748, 72, 155),
1493(749, 72, 156),
1494(750, 73, 58),
1495(751, 73, 59),
1496(752, 73, 60),
1497(753, 73, 61),
1498(754, 73, 62),
1499(755, 73, 63),
1500(756, 73, 154),
1501(757, 73, 155),
1502(758, 73, 156),
1503(759, 74, 58),
1504(760, 74, 59),
1505(761, 74, 60),
1506(762, 74, 61),
1507(763, 74, 62),
1508(764, 74, 63),
1509(765, 74, 154),
1510(766, 74, 155),
1511(767, 74, 156),
1512(768, 75, 58),
1513(769, 75, 59),
1514(770, 75, 60),
1515(771, 75, 61),
1516(772, 75, 62),
1517(773, 75, 63),
1518(774, 75, 154),
1519(775, 75, 155),
1520(776, 75, 156),
1521(777, 76, 58),
1522(778, 76, 59),
1523(779, 76, 60),
1524(780, 76, 61),
1525(781, 76, 62),
1526(782, 76, 63),
1527(783, 76, 154),
1528(784, 76, 155),
1529(785, 76, 156),
1530(786, 77, 58),
1531(787, 77, 59),
1532(788, 77, 60),
1533(789, 77, 61),
1534(790, 77, 62),
1535(791, 77, 63),
1536(792, 77, 154),
1537(793, 77, 155),
1538(794, 77, 156),
1539(795, 78, 58),
1540(796, 78, 59),
1541(797, 78, 60),
1542(798, 78, 61),
1543(799, 78, 62),
1544(800, 78, 63),
1545(801, 78, 154),
1546(802, 78, 155),
1547(803, 78, 156),
1548(804, 79, 58),
1549(805, 79, 59),
1550(806, 79, 60),
1551(807, 79, 61),
1552(808, 79, 62),
1553(809, 79, 63),
1554(810, 79, 154),
1555(811, 79, 155),
1556(812, 79, 156),
1557(813, 98, 47),
1558(814, 98, 48),
1559(815, 98, 49),
1560(816, 98, 71),
1561(817, 98, 72),
1562(818, 98, 73),
1563(819, 98, 74),
1564(820, 98, 75),
1565(821, 98, 76),
1566(822, 99, 47),
1567(823, 99, 48),
1568(824, 99, 49),
1569(825, 99, 71),
1570(826, 99, 72),
1571(827, 99, 73),
1572(828, 99, 74),
1573(829, 99, 75),
1574(830, 99, 76),
1575(831, 100, 47),
1576(832, 100, 48),
1577(833, 100, 49),
1578(834, 100, 71),
1579(835, 100, 72),
1580(836, 100, 73),
1581(837, 100, 74),
1582(838, 100, 75),
1583(839, 100, 76),
1584(840, 101, 47),
1585(841, 101, 48),
1586(842, 101, 49),
1587(843, 101, 71),
1588(844, 101, 72),
1589(845, 101, 73),
1590(846, 101, 74),
1591(847, 101, 75),
1592(848, 101, 76),
1593(849, 102, 47),
1594(850, 102, 48),
1595(851, 102, 49),
1596(852, 102, 71),
1597(853, 102, 72),
1598(854, 102, 73),
1599(855, 102, 74),
1600(856, 102, 75),
1601(857, 102, 76),
1602(858, 103, 47),
1603(859, 103, 48),
1604(860, 103, 49),
1605(861, 103, 71),
1606(862, 103, 72),
1607(863, 103, 73),
1608(864, 103, 74),
1609(865, 103, 75),
1610(866, 103, 76),
1611(867, 104, 47),
1612(868, 104, 48),
1613(869, 104, 49),
1614(870, 104, 71),
1615(871, 104, 72),
1616(872, 104, 73),
1617(873, 104, 74),
1618(874, 104, 75),
1619(875, 104, 76),
1620(876, 105, 47),
1621(877, 105, 48),
1622(878, 105, 49),
1623(879, 105, 71),
1624(880, 105, 72),
1625(881, 105, 73),
1626(882, 105, 74),
1627(883, 105, 75),
1628(884, 105, 76),
1629(885, 106, 47),
1630(886, 106, 48),
1631(887, 106, 49),
1632(888, 106, 71),
1633(889, 106, 72),
1634(890, 106, 73),
1635(891, 106, 74),
1636(892, 106, 75),
1637(893, 106, 76),
1638(894, 107, 47),
1639(895, 107, 48),
1640(896, 107, 49),
1641(897, 107, 71),
1642(898, 107, 72),
1643(899, 107, 73),
1644(900, 107, 74),
1645(901, 107, 75),
1646(902, 107, 76),
1647(903, 111, 47),
1648(904, 111, 48),
1649(905, 111, 49),
1650(906, 111, 71),
1651(907, 111, 72),
1652(908, 111, 73),
1653(909, 111, 74),
1654(910, 111, 75),
1655(911, 111, 76),
1656(912, 112, 47),
1657(913, 112, 48),
1658(914, 112, 49),
1659(915, 112, 71),
1660(916, 112, 72),
1661(917, 112, 73),
1662(918, 112, 74),
1663(919, 112, 75),
1664(920, 112, 76),
1665(921, 113, 47),
1666(922, 113, 48),
1667(923, 113, 49),
1668(924, 113, 71),
1669(925, 113, 72),
1670(926, 113, 73),
1671(927, 113, 74),
1672(928, 113, 75),
1673(929, 113, 76),
1674(930, 114, 47),
1675(931, 114, 48),
1676(932, 114, 49),
1677(933, 114, 77),
1678(934, 114, 78),
1679(936, 114, 80),
1680(937, 114, 81),
1681(938, 114, 82),
1682(939, 116, 47),
1683(940, 116, 48),
1684(941, 116, 49),
1685(942, 116, 77),
1686(943, 116, 78),
1687(944, 116, 80),
1688(945, 116, 81),
1689(946, 116, 82),
1690(947, 116, 83),
1691(948, 117, 47),
1692(949, 117, 48),
1693(950, 117, 49),
1694(951, 117, 77),
1695(952, 117, 78),
1696(953, 117, 80),
1697(954, 117, 81),
1698(955, 117, 82),
1699(956, 117, 83),
1700(966, 141, 2),
1701(967, 141, 5),
1702(968, 141, 10),
1703(969, 109, 47),
1704(970, 109, 48),
1705(971, 109, 49),
1706(972, 109, 77),
1707(973, 109, 78),
1708(974, 109, 80),
1709(975, 109, 81),
1710(976, 109, 82),
1711(977, 109, 83),
1712(978, 150, 47),
1713(979, 150, 48),
1714(980, 150, 49),
1715(981, 150, 77),
1716(982, 150, 78),
1717(983, 150, 80),
1718(984, 150, 81),
1719(985, 150, 82),
1720(986, 150, 83),
1721(987, 154, 50),
1722(988, 154, 51),
1723(989, 154, 52),
1724(990, 154, 64),
1725(991, 154, 65),
1726(992, 154, 66),
1727(993, 154, 67),
1728(994, 154, 68),
1729(995, 154, 69),
1730(996, 154, 70),
1731(997, 155, 50),
1732(998, 155, 51),
1733(999, 155, 52),
1734(1000, 155, 64),
1735(1001, 155, 65),
1736(1002, 155, 66),
1737(1003, 155, 67),
1738(1004, 155, 68),
1739(1005, 155, 69),
1740(1006, 155, 70),
1741(1007, 156, 50),
1742(1008, 156, 51),
1743(1009, 156, 52),
1744(1010, 156, 64),
1745(1011, 156, 65),
1746(1012, 156, 66),
1747(1013, 156, 67),
1748(1014, 156, 68),
1749(1015, 156, 69),
1750(1016, 156, 70),
1751(1017, 157, 50),
1752(1018, 157, 51),
1753(1019, 157, 52),
1754(1020, 157, 64),
1755(1021, 157, 65),
1756(1022, 157, 66),
1757(1023, 157, 67),
1758(1024, 157, 68),
1759(1025, 157, 69),
1760(1026, 157, 70),
1761(1027, 151, 45),
1762(1028, 151, 46),
1763(1029, 151, 84),
1764(1030, 151, 85),
1765(1031, 151, 86),
1766(1032, 151, 87),
1767(1033, 151, 88),
1768(1034, 151, 89),
1769(1035, 151, 90),
1770(1036, 151, 157),
1771(1037, 152, 45),
1772(1038, 152, 46),
1773(1039, 152, 84),
1774(1040, 152, 85),
1775(1041, 152, 86),
1776(1042, 152, 87),
1777(1043, 152, 88),
1778(1044, 152, 89),
1779(1045, 152, 90),
1780(1046, 152, 157),
1781(1047, 153, 45),
1782(1048, 153, 46),
1783(1049, 153, 84),
1784(1050, 153, 85),
1785(1051, 153, 86),
1786(1052, 153, 87),
1787(1053, 153, 88),
1788(1054, 153, 89),
1789(1055, 153, 90),
1790(1056, 153, 157),
1791(1057, 119, 45),
1792(1058, 119, 46),
1793(1059, 119, 84),
1794(1060, 119, 85),
1795(1061, 119, 86),
1796(1062, 119, 87),
1797(1063, 119, 88),
1798(1064, 119, 89),
1799(1065, 119, 90),
1800(1066, 119, 157),
1801(1067, 120, 45),
1802(1068, 120, 46),
1803(1069, 120, 84),
1804(1070, 120, 85),
1805(1071, 120, 86),
1806(1072, 120, 87),
1807(1073, 120, 88),
1808(1074, 120, 89),
1809(1075, 120, 90),
1810(1076, 120, 157),
1811(1077, 121, 45),
1812(1078, 121, 46),
1813(1079, 121, 84),
1814(1080, 121, 85),
1815(1081, 121, 86),
1816(1082, 121, 87),
1817(1083, 121, 88),
1818(1084, 121, 89),
1819(1085, 121, 90),
1820(1086, 121, 157),
1821(1087, 122, 45),
1822(1088, 122, 46),
1823(1089, 122, 84),
1824(1090, 122, 85),
1825(1091, 122, 86),
1826(1092, 122, 87),
1827(1093, 122, 88),
1828(1094, 122, 89),
1829(1095, 122, 90),
1830(1096, 122, 157),
1831(1097, 123, 45),
1832(1098, 123, 46),
1833(1099, 123, 84),
1834(1100, 123, 85),
1835(1101, 123, 86),
1836(1102, 123, 87),
1837(1103, 123, 88),
1838(1104, 123, 89),
1839(1105, 123, 90),
1840(1106, 123, 157),
1841(1107, 124, 45),
1842(1108, 124, 46),
1843(1109, 124, 84),
1844(1110, 124, 85),
1845(1111, 124, 86),
1846(1112, 124, 87),
1847(1113, 124, 88),
1848(1114, 124, 89),
1849(1115, 124, 90),
1850(1116, 124, 157),
1851(1117, 125, 45),
1852(1118, 125, 46),
1853(1119, 125, 84),
1854(1120, 125, 85),
1855(1121, 125, 86),
1856(1122, 125, 87),
1857(1123, 125, 88),
1858(1124, 125, 89),
1859(1125, 125, 90),
1860(1126, 125, 157),
1861(1127, 126, 45),
1862(1128, 126, 46),
1863(1129, 126, 84),
1864(1130, 126, 85),
1865(1131, 126, 86),
1866(1132, 126, 87),
1867(1133, 126, 88),
1868(1134, 126, 89),
1869(1135, 126, 90),
1870(1136, 126, 157),
1871(1137, 108, 45),
1872(1138, 108, 46),
1873(1139, 108, 84),
1874(1140, 108, 85),
1875(1141, 108, 86),
1876(1142, 108, 87),
1877(1143, 108, 88),
1878(1144, 108, 89),
1879(1145, 108, 90),
1880(1146, 108, 157),
1881(1147, 128, 33),
1882(1148, 128, 35),
1883(1149, 128, 55),
1884(1150, 128, 56),
1885(1151, 128, 119),
1886(1152, 128, 120),
1887(1153, 128, 121),
1888(1154, 128, 122),
1889(1155, 128, 123),
1890(1156, 128, 124),
1891(1157, 128, 125),
1892(1158, 128, 126),
1893(1159, 128, 127),
1894(1160, 128, 128),
1895(1161, 128, 129),
1896(1162, 128, 130),
1897(1163, 129, 33),
1898(1164, 129, 35),
1899(1165, 129, 55),
1900(1166, 129, 56),
1901(1167, 129, 119),
1902(1168, 129, 120),
1903(1169, 129, 121),
1904(1170, 129, 122),
1905(1171, 129, 123),
1906(1172, 129, 124),
1907(1173, 129, 125),
1908(1174, 129, 126),
1909(1175, 129, 127),
1910(1176, 129, 128),
1911(1177, 129, 129),
1912(1178, 129, 130),
1913(1179, 130, 33),
1914(1180, 130, 35),
1915(1181, 130, 55),
1916(1182, 130, 56),
1917(1183, 130, 119),
1918(1184, 130, 120),
1919(1185, 130, 121),
1920(1186, 130, 122),
1921(1187, 130, 123),
1922(1188, 130, 124),
1923(1189, 130, 125),
1924(1190, 130, 126),
1925(1191, 130, 127),
1926(1192, 130, 128),
1927(1193, 130, 129),
1928(1194, 130, 130),
1929(1195, 110, 33),
1930(1196, 110, 35),
1931(1197, 110, 55),
1932(1198, 110, 56),
1933(1199, 110, 119),
1934(1200, 110, 120),
1935(1201, 110, 121),
1936(1202, 110, 122),
1937(1203, 110, 123),
1938(1204, 110, 124),
1939(1205, 110, 125),
1940(1206, 110, 126),
1941(1207, 110, 127),
1942(1208, 110, 128),
1943(1209, 110, 129),
1944(1210, 110, 130),
1945(1211, 132, 33),
1946(1212, 132, 35),
1947(1213, 132, 55),
1948(1214, 132, 56),
1949(1215, 132, 119),
1950(1216, 132, 120),
1951(1217, 132, 121),
1952(1218, 132, 122),
1953(1219, 132, 123),
1954(1220, 132, 124),
1955(1221, 132, 125),
1956(1222, 132, 126),
1957(1223, 132, 127),
1958(1224, 132, 128),
1959(1225, 132, 129),
1960(1226, 132, 130),
1961(1227, 133, 33),
1962(1228, 133, 35),
1963(1229, 133, 55),
1964(1230, 133, 56),
1965(1231, 133, 119),
1966(1232, 133, 120),
1967(1233, 133, 121),
1968(1234, 133, 122),
1969(1235, 133, 123),
1970(1236, 133, 124),
1971(1237, 133, 125),
1972(1238, 133, 126),
1973(1239, 133, 127),
1974(1240, 133, 128),
1975(1241, 133, 129),
1976(1242, 133, 130),
1977(1243, 134, 33),
1978(1244, 134, 35),
1979(1245, 134, 55),
1980(1246, 134, 56),
1981(1247, 134, 119),
1982(1248, 134, 120),
1983(1249, 134, 121),
1984(1250, 134, 122),
1985(1251, 134, 123),
1986(1252, 134, 124),
1987(1253, 134, 125),
1988(1254, 134, 126),
1989(1255, 134, 127),
1990(1256, 134, 128),
1991(1257, 134, 129),
1992(1258, 134, 130),
1993(1259, 134, 107),
1994(1260, 134, 108),
1995(1261, 134, 109),
1996(1262, 134, 110),
1997(1263, 134, 111),
1998(1264, 134, 112),
1999(1265, 134, 113),
2000(1266, 134, 114),
2001(1267, 134, 115),
2002(1268, 134, 116),
2003(1269, 134, 117),
2004(1270, 134, 118),
2005(1271, 135, 33),
2006(1272, 135, 35),
2007(1273, 135, 55),
2008(1274, 135, 56),
2009(1275, 135, 107),
2010(1276, 135, 108),
2011(1277, 135, 109),
2012(1278, 135, 110),
2013(1279, 135, 111),
2014(1280, 135, 112),
2015(1281, 135, 113),
2016(1282, 135, 114),
2017(1283, 135, 115),
2018(1284, 135, 116),
2019(1285, 135, 117),
2020(1286, 135, 118),
2021(1287, 136, 33),
2022(1288, 136, 35),
2023(1289, 136, 55),
2024(1290, 136, 56),
2025(1291, 136, 107),
2026(1292, 136, 108),
2027(1293, 136, 109),
2028(1294, 136, 110),
2029(1295, 136, 111),
2030(1296, 136, 112),
2031(1297, 136, 113),
2032(1298, 136, 114),
2033(1299, 136, 115),
2034(1300, 136, 116),
2035(1301, 136, 117),
2036(1302, 136, 118),
2037(1303, 137, 33),
2038(1304, 137, 35),
2039(1305, 137, 55),
2040(1306, 137, 56),
2041(1307, 137, 107),
2042(1308, 137, 108),
2043(1309, 137, 109),
2044(1310, 137, 110),
2045(1311, 137, 111),
2046(1312, 137, 112),
2047(1313, 137, 113),
2048(1314, 137, 114),
2049(1315, 137, 115),
2050(1316, 137, 116),
2051(1317, 137, 117),
2052(1318, 137, 118),
2053(1319, 138, 33),
2054(1320, 138, 35),
2055(1321, 138, 55),
2056(1322, 138, 56),
2057(1323, 138, 107),
2058(1324, 138, 108),
2059(1325, 138, 109),
2060(1326, 138, 110),
2061(1327, 138, 111),
2062(1328, 138, 112),
2063(1329, 138, 113),
2064(1330, 138, 114),
2065(1331, 138, 115),
2066(1332, 138, 116),
2067(1333, 138, 117),
2068(1334, 138, 118),
2069(1335, 139, 33),
2070(1336, 139, 35),
2071(1337, 139, 55),
2072(1338, 139, 56),
2073(1339, 139, 107),
2074(1340, 139, 108),
2075(1341, 139, 109),
2076(1342, 139, 110),
2077(1343, 139, 111),
2078(1344, 139, 112),
2079(1345, 139, 113),
2080(1346, 139, 114),
2081(1347, 139, 115),
2082(1348, 139, 116),
2083(1349, 139, 117),
2084(1350, 139, 118),
2085(1351, 140, 33),
2086(1352, 140, 35),
2087(1353, 140, 55),
2088(1354, 140, 56),
2089(1355, 140, 107),
2090(1356, 140, 108),
2091(1357, 140, 109),
2092(1358, 140, 110),
2093(1359, 140, 111),
2094(1360, 140, 112),
2095(1361, 140, 113),
2096(1362, 140, 114),
2097(1363, 140, 115),
2098(1364, 140, 116),
2099(1365, 140, 117),
2100(1366, 140, 118);
2101
2102-- --------------------------------------------------------
2103
2104--
2105-- Struktur dari tabel `tr_guru_tes`
2106--
2107
2108CREATE TABLE IF NOT EXISTS `tr_guru_tes` (
2109  `id` int(6) NOT NULL AUTO_INCREMENT,
2110  `id_guru` int(6) NOT NULL,
2111  `id_mapel` int(6) NOT NULL,
2112  `nama_ujian` varchar(200) NOT NULL,
2113  `jumlah_soal` int(6) NOT NULL,
2114  `waktu` int(6) NOT NULL,
2115  `jenis` enum('acak','set') NOT NULL,
2116  `detil_jenis` varchar(500) NOT NULL,
2117  `tgl_mulai` datetime NOT NULL,
2118  `terlambat` int(3) NOT NULL,
2119  `token` varchar(5) NOT NULL,
2120  PRIMARY KEY (`id`),
2121  KEY `id_guru` (`id_guru`),
2122  KEY `id_mapel` (`id_mapel`)
2123) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
2124
2125-- --------------------------------------------------------
2126
2127--
2128-- Struktur dari tabel `tr_ikut_ujian`
2129--
2130
2131CREATE TABLE IF NOT EXISTS `tr_ikut_ujian` (
2132  `id` int(6) NOT NULL AUTO_INCREMENT,
2133  `id_tes` int(6) NOT NULL,
2134  `id_user` int(6) NOT NULL,
2135  `list_soal` longtext NOT NULL,
2136  `list_jawaban` longtext NOT NULL,
2137  `jml_benar` int(6) NOT NULL,
2138  `nilai` decimal(10,2) NOT NULL,
2139  `nilai_bobot` decimal(10,2) NOT NULL,
2140  `tgl_mulai` datetime NOT NULL,
2141  `tgl_selesai` datetime NOT NULL,
2142  `status` enum('Y','N') NOT NULL,
2143  PRIMARY KEY (`id`),
2144  KEY `id_tes` (`id_tes`),
2145  KEY `id_user` (`id_user`)
2146) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
2147
2148-- --------------------------------------------------------
2149
2150--
2151-- Struktur dari tabel `tr_siswa_mapel`
2152--
2153
2154CREATE TABLE IF NOT EXISTS `tr_siswa_mapel` (
2155  `no` varchar(20) NOT NULL,
2156  `mapel` varchar(20) NOT NULL,
2157  `id_mapel` varchar(30) NOT NULL
2158) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2159
2160/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2161/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2162/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;