tcGs7ZzR

1DROP TABLE IF EXISTS `jurusan`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `jurusan` (
5  `id_jurusan` int(11) NOT NULL AUTO_INCREMENT,
6  `nama_jurusan` varchar(50) NOT NULL,
7  PRIMARY KEY (`id_jurusan`)
8) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
9/*!40101 SET character_set_client = @saved_cs_client */;
10 
11DROP TABLE IF EXISTS `mahasiswa`;
12/*!40101 SET @saved_cs_client     = @@character_set_client */;
13/*!40101 SET character_set_client = utf8 */;
14CREATE TABLE `mahasiswa` (
15  `nim` varchar(10) NOT NULL,
16  `nama` varchar(50) NOT NULL,
17  `id_jurusan` int(11) NOT NULL,
18  `alamat` text NOT NULL,
19  PRIMARY KEY (`nim`)
20) ENGINE=InnoDB DEFAULT CHARSET=latin1;