-- MySQL dump 10.13  Distrib 5.1.30, for Win32 (ia32)
--
-- Host: localhost    Database: perpustakaan
-- ------------------------------------------------------
-- Server version	5.1.30-community

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `anggota`
--

DROP TABLE IF EXISTS `anggota`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `anggota` (
  `nomor_anggota` varchar(10) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `tgllahir` date DEFAULT NULL,
  `alamat` varchar(100) DEFAULT NULL,
  `jk` char(1) DEFAULT NULL,
  `jenis_anggota` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`nomor_anggota`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `anggota`
--

LOCK TABLES `anggota` WRITE;
/*!40000 ALTER TABLE `anggota` DISABLE KEYS */;
INSERT INTO `anggota` VALUES ('A01','Asih widyastuti','1997-02-05','solo','P','BI'),('A02','Catur Wiyanti','1995-04-05','klaten','P','BI'),('A03','Halimatus Anita S','1996-05-20','sragen','P','LB'),('A04','Muh. Yusron Al Amin','1995-03-12','semarang','L','LB'),('A05','Ardian M Prastiawan','1980-03-22','sukoharjo','L','PU'),('A06','Tya','1996-03-22','wonogiri','P','PU');
/*!40000 ALTER TABLE `anggota` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `buku`
--

DROP TABLE IF EXISTS `buku`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `buku` (
  `kode_buku` varchar(10) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `pengarang` varchar(20) DEFAULT NULL,
  `penerbit` varchar(20) DEFAULT NULL,
  `tahun_terbit` year(4) DEFAULT NULL,
  `kategori_buku` varchar(10) DEFAULT NULL,
  `kondisi` varchar(20) DEFAULT NULL,
  `tgl_beli` date DEFAULT NULL,
  PRIMARY KEY (`kode_buku`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `buku`
--

LOCK TABLES `buku` WRITE;
/*!40000 ALTER TABLE `buku` DISABLE KEYS */;
INSERT INTO `buku` VALUES ('B01','Dasar Pemrograman','Ardian','PPTI',2008,'TK','Baik','2008-01-05'),('B02','Pemrograman Lanjut','Budi','PPTI',2009,'TK','Baik','2009-05-03'),('B03','Ilmu alam disekitar kita','joko','Tiga Serangkai',2008,'IA','baik','2008-06-07'),('B04','Sosiologi kita','Budi','purnama',2009,'IS','baik','2009-04-07'),('B05','Sastra Jawa','joko','purnama',2009,'SS','baik','2009-09-09');
/*!40000 ALTER TABLE `buku` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jenis_anggota`
--

DROP TABLE IF EXISTS `jenis_anggota`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `jenis_anggota` (
  `kode_jenis` varchar(10) NOT NULL,
  `jenis_anggota` varchar(100) NOT NULL,
  PRIMARY KEY (`kode_jenis`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `jenis_anggota`
--

LOCK TABLES `jenis_anggota` WRITE;
/*!40000 ALTER TABLE `jenis_anggota` DISABLE KEYS */;
INSERT INTO `jenis_anggota` VALUES ('BI','Anggota Biasa'),('LB','Anggota Luar Biasa'),('PU','Pengurus');
/*!40000 ALTER TABLE `jenis_anggota` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kategori_buku`
--

DROP TABLE IF EXISTS `kategori_buku`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `kategori_buku` (
  `kode_kategori` varchar(10) NOT NULL,
  `kategori` varchar(50) NOT NULL,
  PRIMARY KEY (`kode_kategori`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `kategori_buku`
--

LOCK TABLES `kategori_buku` WRITE;
/*!40000 ALTER TABLE `kategori_buku` DISABLE KEYS */;
INSERT INTO `kategori_buku` VALUES ('IA','Ilmu Alam'),('IS','Ilmu SOsial'),('TK','Teknologi'),('SS','Sastra');
/*!40000 ALTER TABLE `kategori_buku` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `peminjaman`
--

DROP TABLE IF EXISTS `peminjaman`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `peminjaman` (
  `kode_buku` varchar(10) NOT NULL,
  `nomor_anggota` varchar(10) NOT NULL,
  `tgl_pinjam` date NOT NULL,
  `tgl_harus_kembali` date DEFAULT NULL,
  `tgl_kembali` date DEFAULT NULL,
  `denda` int(11) DEFAULT NULL,
  PRIMARY KEY (`kode_buku`,`nomor_anggota`,`tgl_pinjam`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `peminjaman`
--

LOCK TABLES `peminjaman` WRITE;
/*!40000 ALTER TABLE `peminjaman` DISABLE KEYS */;
INSERT INTO `peminjaman` VALUES ('B01','A01','2010-03-01','2010-03-08','2010-03-10',1000),('B02','A01','2010-03-01','2010-03-08','0000-00-00',0),('B03','A02','2010-03-10','2010-03-18','0000-00-00',0),('B04','A02','2010-03-10','2010-03-18','0000-00-00',0),('B05','A03','2010-03-15','2010-03-23','2010-03-23',0),('B05','A03','2010-03-16','2010-03-24','2010-03-25',3000);
/*!40000 ALTER TABLE `peminjaman` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-03-29  1:22:37