· 9 years ago · Dec 26, 2016, 12:30 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 16 Sep 2016 pada 23.36
7-- Versi Server: 5.6.21
8-- PHP Version: 5.5.19
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: `smk`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktur dari tabel `nilai`
27--
28
29CREATE TABLE IF NOT EXISTS `nilai` (
30`id` int(5) NOT NULL,
31 `semester` int(2) NOT NULL,
32 `kode_pelajaran` char(4) NOT NULL,
33 `kode_guru` char(5) NOT NULL,
34 `kode_kelas` char(4) NOT NULL,
35 `kode_siswa` char(5) NOT NULL,
36 `nilai_tugas1` int(4) NOT NULL,
37 `nilai_tugas2` int(4) NOT NULL,
38 `nilai_tugas3` int(4) NOT NULL,
39 `nilai_tugas4` int(4) NOT NULL,
40 `nilai_tugas5` int(4) NOT NULL,
41 `nilai_tugas6` int(4) NOT NULL,
42 `nilai_tugas7` int(4) NOT NULL,
43 `nilai_tugas8` int(4) NOT NULL,
44 `nilai_tugas9` int(4) NOT NULL,
45 `nilai_tugas10` int(4) NOT NULL,
46 `nilai_tugas11` int(4) NOT NULL,
47 `nilai_tugas12` int(4) NOT NULL,
48 `nilai_tugas13` int(4) NOT NULL,
49 `nilai_uts` int(4) NOT NULL,
50 `nilai_uas` int(4) NOT NULL,
51 `keterangan` varchar(100) NOT NULL
52) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
53
54--
55-- Dumping data untuk tabel `nilai`
56--
57
58INSERT INTO `nilai` (`id`, `semester`, `kode_pelajaran`, `kode_guru`, `kode_kelas`, `kode_siswa`, `nilai_tugas1`, `nilai_tugas2`, `nilai_tugas3`, `nilai_tugas4`, `nilai_tugas5`, `nilai_tugas6`, `nilai_tugas7`, `nilai_tugas8`, `nilai_tugas9`, `nilai_tugas10`, `nilai_tugas11`, `nilai_tugas12`, `nilai_tugas13`, `nilai_uts`, `nilai_uas`, `keterangan`) VALUES
59(1, 1, 'P001', 'G0002', 'K001', 'S0002', 75, 60, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 85, 80, 80, 'Delapan Puluh'),
60(2, 1, 'P001', 'G0003', 'K001', 'S0003', 70, 60, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 75, 80, 'Delapan Puluh'),
61(3, 1, 'P001', 'G0004', 'K001', 'S0004', 75, 80, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 75, 80, 'Delapan Puluh'),
62(4, 1, 'P001', 'G0005', 'K001', 'S0006', 68, 70, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 85, 80, 'Delapan Puluh'),
63(5, 1, 'P001', 'G0001', 'K002', 'S0007', 70, 70, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 75, 79, 'Tujuh Puluh Sembilan'),
64(6, 1, 'P001', 'G0002', 'K002', 'S0010', 78, 80, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 75, 85, 'Delapan Puluh Lima'),
65(7, 1, 'P001', 'G0002', 'K002', 'S0009', 78, 80, 75, 60, 75, 80, 75, 60, 75, 60, 60, 60, 60, 75, 80, 'Delapan Puluh'),
66(8, 1, 'P001', 'G0002', 'K002', 'S0008', 85, 80, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 85, 90, 'Sembilan Puluh'),
67(9, 1, 'P001', 'G0002', 'K002', 'S0005', 75, 70, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 75, 80, 'Delapan Puluh'),
68(10, 1, 'P001', 'G0001', 'K002', 'S0007', 80, 100, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 100, 90, 'Sembilan Puluh'),
69(19, 2, 'P001', 'G0006', 'K004', 'S0016', 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 'ok'),
70(12, 2, 'P008', 'G0006', 'K002', 'S0009', 80, 70, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 90, 80, 'Delapan Puluh'),
71(13, 1, 'P003', 'G0005', 'K003', 'S0002', 80, 80, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 75, 80, 'Delapan Puluh'),
72(14, 1, 'P003', 'G0002', 'K003', 'S0002', 80, 80, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 80, 80, 'Selapan Puluh'),
73(15, 1, 'P004', 'G0006', 'K001', 'S0005', 50, 0, 75, 60, 75, 60, 75, 60, 75, 60, 60, 60, 60, 80, 80, 'Delapan Puluh'),
74(18, 1, 'P010', 'G0006', 'K001', 'S0006', 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 'LULUS');
75
76--
77-- Indexes for dumped tables
78--
79
80--
81-- Indexes for table `nilai`
82--
83ALTER TABLE `nilai`
84 ADD PRIMARY KEY (`id`);
85
86--
87-- AUTO_INCREMENT for dumped tables
88--
89
90--
91-- AUTO_INCREMENT for table `nilai`
92--
93ALTER TABLE `nilai`
94MODIFY `id` int(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
95/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
96/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
97/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;