# 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″,”Anteng”,”L”,”Teknik”);
INSERT INTO assisten VALUES(“030106007″,”Lestari”,”P”,”Matematika”);
INSERT INTO assisten VALUES(“030106032″,”Dina”,”P”,”TEKNIK”);
#
# 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″,”Dona”,”P”);
INSERT INTO dosen VALUES(“002009006″,”Sunarti”,”P”);
INSERT INTO dosen VALUES(“002008009″,”Rini”,”P”);
INSERT INTO dosen VALUES(“090803007″,”Firda”,”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″,”Sarti”,”P”,”Matematika”);
INSERT INTO mahasiswa VALUES(“0501060036″,”Sony”,”L”,”Matematika”);
INSERT INTO mahasiswa VALUES(“0501060054″,”Wanda”,”P”,”Matematika”);
INSERT INTO mahasiswa VALUES(“0501060064″,”Gogon”,”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″,”Metleb”,”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(“16: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(“09:00:00″,”Jumat”);
INSERT INTO waktu_pelaksanaan VALUES(“11:00:00″,”Sabtu”);
