PEexafQJ

1
22
33
44
55
66
77
88
99
1010
1111
1212
1313
1414
1515
1616
1717
1818
1919
2020
21DROP TABLE IF EXISTS `jurusan`;
22/*!40101 SET @saved_cs_client     = @@character_set_client */;
23/*!40101 SET character_set_client = utf8 */;
24CREATE TABLE `jurusan` (
25  `id_jurusan` int(11) NOT NULL AUTO_INCREMENT,
26  `nama_jurusan` varchar(50) NOT NULL,
27  PRIMARY KEY (`id_jurusan`)
28) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
29/*!40101 SET character_set_client = @saved_cs_client */;
30 
31DROP TABLE IF EXISTS `mahasiswa`;
32/*!40101 SET @saved_cs_client     = @@character_set_client */;
33/*!40101 SET character_set_client = utf8 */;
34CREATE TABLE `mahasiswa` (
35  `nim` varchar(10) NOT NULL,
36  `nama` varchar(50) NOT NULL,
37  `id_jurusan` int(11) NOT NULL,
38  `alamat` text NOT NULL,
39  PRIMARY KEY (`nim`)
40) ENGINE=InnoDB DEFAULT CHARSET=latin1;