· 8 years ago · Apr 22, 2018, 05:48 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.4.1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Apr 09, 2018 at 12:22 PM
7-- Server version: 5.5.32
8-- PHP Version: 5.4.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: `akademik`
21--
22CREATE DATABASE IF NOT EXISTS `akademik` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
23USE `akademik`;
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `customer`
29--
30
31CREATE TABLE IF NOT EXISTS `customer` (
32 `id_customer` int(5) NOT NULL AUTO_INCREMENT,
33 `username` varchar(50) NOT NULL,
34 `password` varchar(255) NOT NULL,
35 `nama` varchar(255) NOT NULL,
36 `umur` int(3) NOT NULL,
37 `alamat` text NOT NULL,
38 `telp` varchar(15) NOT NULL,
39 `email` varchar(50) NOT NULL,
40 `tgl_lahir` varchar(15) NOT NULL,
41 `kode_pos` varchar(10) NOT NULL,
42 `nama_ibu_k` varchar(50) NOT NULL,
43 `gender` varchar(15) NOT NULL,
44 PRIMARY KEY (`id_customer`)
45) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
46
47--
48-- Dumping data for table `customer`
49--
50
51INSERT INTO `customer` (`id_customer`, `username`, `password`, `nama`, `umur`, `alamat`, `telp`, `email`, `tgl_lahir`, `kode_pos`, `nama_ibu_k`, `gender`) VALUES
52(1, 'cust1', '91ec1f9324753048c0096d036a694f86', 'Customer 1', 25, 'Muara Bahari', '09289301', 'test@gmail.com', '', '', '', ''),
53(3, 'sandi', '827ccb0eea8a706c4c34a16891f84e7b', 'ariessandi x', 29, 'jakarta', '987899', 'sandi@yahoo.com', '', '', '', ''),
54(4, 'aries', '827ccb0eea8a706c4c34a16891f84e7b', 'aries s', 25, 'jakarta', '987980709', 'ss@ymail.com', '', '', '', '');
55
56-- --------------------------------------------------------
57
58--
59-- Table structure for table `mahasiswa`
60--
61
62CREATE TABLE IF NOT EXISTS `mahasiswa` (
63 `nim` char(10) NOT NULL,
64 `nama` varchar(35) NOT NULL,
65 `prodi` char(5) NOT NULL,
66 PRIMARY KEY (`nim`)
67) ENGINE=MyISAM DEFAULT CHARSET=latin1;
68
69--
70-- Dumping data for table `mahasiswa`
71--
72
73INSERT INTO `mahasiswa` (`nim`, `nama`, `prodi`) VALUES
74('1501530044', 'Dhika Bagas Whisnu Aji', 'TI-S1'),
75('1501530034', 'Mochamad Teguh', 'TI-S1'),
76('1501530013', 'Listyani Praptining Putri', 'TI-S1');
77
78-- --------------------------------------------------------
79
80--
81-- Table structure for table `matakuliah`
82--
83
84CREATE TABLE IF NOT EXISTS `matakuliah` (
85 `kdmk` char(6) NOT NULL,
86 `nmmk` varchar(35) NOT NULL,
87 `sks` int(11) NOT NULL,
88 `prodi` char(5) NOT NULL,
89 PRIMARY KEY (`kdmk`)
90) ENGINE=MyISAM DEFAULT CHARSET=latin1;
91
92--
93-- Dumping data for table `matakuliah`
94--
95
96INSERT INTO `matakuliah` (`kdmk`, `nmmk`, `sks`, `prodi`) VALUES
97('112233', 'Pemrograman Internet I', 3, 'TI-D3'),
98('104531', 'Pemrograman Database', 3, 'TI-D3'),
99('812345', 'Basis Data Lanjut', 3, 'TI-S1'),
100('780123', 'Interpersonal Skill', 2, 'TI-S1'),
101('672134', 'Kewirausahaan', 2, 'TI-S1'),
102('671234', 'PTK', 3, 'TI-S1'),
103('123211', 'Algoritma & Pemrograman', 3, 'TI-S1');
104
105-- --------------------------------------------------------
106
107--
108-- Table structure for table `nilai`
109--
110
111CREATE TABLE IF NOT EXISTS `nilai` (
112 `thakd` char(5) NOT NULL,
113 `nim` char(10) NOT NULL,
114 `kdmk` char(6) NOT NULL,
115 `nilai` int(11) DEFAULT NULL,
116 PRIMARY KEY (`thakd`,`nim`,`kdmk`)
117) ENGINE=InnoDB DEFAULT CHARSET=latin1;
118
119--
120-- Dumping data for table `nilai`
121--
122
123INSERT INTO `nilai` (`thakd`, `nim`, `kdmk`, `nilai`) VALUES
124('20122', '09.3.00012', '112233', NULL),
125('20122', '09.5.00056', '780123', NULL),
126('20122', '09.5.00056', '812345', NULL),
127('20122', '10.5.00001', 'M01', NULL),
128('20122', '10.5.00001', 'M02', NULL),
129('20122', '11.5.00001', 'M01', NULL),
130('20122', '11.5.00001', 'M02', NULL),
131('20122', '11.5.00001', 'M03', NULL),
132('20122', '12.5.00001', 'M04', NULL),
133('20122', '12.5.00001', 'M05', NULL);
134
135/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
136/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
137/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;