# MySQL-Front Dump 2.2
#
# Host: localhost Database: jadwal_praktikum
#——————————————————–
# Server version 4.0.12-nt
#
# Table structure for table ‘assisten’
#
CREATE TABLE `assisten` (
`NIM` varchar(10) NOT NULL default ”,
`Nama` varchar(20) NOT NULL default ”,
`Jenis_Kelamin` enum(‘P’,'L’) NOT NULL default ‘P’,
`Fakultas` varchar(20) NOT NULL default ”
) TYPE=MyISAM;
#
# Dumping data for table ‘assisten’
#
INSERT INTO assisten VALUES(“030106002″,”Didi”,”L”,”Teknik”);
INSERT INTO assisten VALUES(“030106005″,”yusuf”,”L”,”Teknik”);
INSERT INTO assisten VALUES(“030106007″,”anti”,”P”,”Matematika”);
INSERT INTO assisten VALUES(“030106032″,”Diana”,”P”,”Matematika”);
#
# Table structure for table ‘dosen’
#
CREATE TABLE `dosen` (
`NIP` varchar(10) NOT NULL default ”,
`Nama` varchar(20) NOT NULL default ”,
`Jenis_Kelamin` enum(‘P’,'L’) NOT NULL default ‘P’
) TYPE=MyISAM;
#
# Dumping data for table ‘dosen’
#
INSERT INTO dosen VALUES(“002003004″,”Tito”,”L”);
INSERT INTO dosen VALUES(“002003005″,”Sony”,”L”);
INSERT INTO dosen VALUES(“002003006″,”Rena”,”P”);
#
# Table structure for table ‘mahasiswa’
#
CREATE TABLE `mahasiswa` (
`Nim` varchar(10) NOT NULL default ”,
`Nama` varchar(20) NOT NULL default ”,
`Jenis_kelamin` enum(‘P’,'L’) NOT NULL default ‘P’,
`Prodi` varchar(20) NOT NULL default ”
) TYPE=MyISAM;
#
# Dumping data for table ‘mahasiswa’
#
INSERT INTO mahasiswa VALUES(“0501060043″,”Sisy”,”P”,”Matematika”);
INSERT INTO mahasiswa VALUES(“0501060036″,”Santi”,”P”,”Matematika”);
INSERT INTO mahasiswa VALUES(“0501060054″,”Linda,”P”,”Matematika”);
INSERT INTO mahasiswa VALUES(“0501060064″,”Dito”,”L”,”Matematika”);
#
# Table structure for table ‘mata_kuliah’
#
CREATE TABLE `mata_kuliah` (
`KODE` varchar(10) NOT NULL default ”,
`Mata_Kuliah` varchar(20) NOT NULL default ”,
`SKS` enum(‘B’,'U’) NOT NULL default ‘B’,
`Bobot_SKS` int(10) unsigned NOT NULL default ‘0′
) TYPE=MyISAM;
#
# Dumping data for table ‘mata_kuliah’
#
INSERT INTO mata_kuliah VALUES(“010243″,”SBD”,”B”,”3″);
INSERT INTO mata_kuliah VALUES(“010242″,”Matlab”,”B”,”3″);
INSERT INTO mata_kuliah VALUES(“010241″,”Pemrograman T”,”B”,”3″);
INSERT INTO mata_kuliah VALUES(“010240″,”Pemrograman D”,”B”,”3″);
INSERT INTO mata_kuliah VALUES(“010239″,”",”B”,”0″);
#
# Table structure for table ‘waktu_pelaksanaan’
#
CREATE TABLE `waktu_pelaksanaan` (
`Jam` time NOT NULL default ‘00:00:00′,
`Hari` varchar(10) NOT NULL default ”
) TYPE=MyISAM;
#
# Dumping data for table ‘waktu_pelaksanaan’
#
INSERT INTO waktu_pelaksanaan VALUES(“07:00:00″,”Senin”);
INSERT INTO waktu_pelaksanaan VALUES(“14:00:00″,”selasa”);
INSERT INTO waktu_pelaksanaan VALUES(“15:00:00″,”Rabu”);
INSERT INTO waktu_pelaksanaan VALUES(“17:00:00″,”Kamis”);
INSERT INTO waktu_pelaksanaan VALUES(“08:00:00″,”Jumat”);
INSERT INTO waktu_pelaksanaan VALUES(“10:00:00″,”Sabtu”);
