--
-- Host: localhost    Database: db_perpus
-- ------------------------------------------------------


--
-- Table structure for table `data_anggota`
--

CREATE TABLE `data_anggota` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `no_induk` varchar(18) NOT NULL,
  `nama` varchar(35) NOT NULL,
  `jk` varchar(2) NOT NULL,
  `kelas` varchar(35) NOT NULL,
  `angkatan` varchar(15) NOT NULL,
  `ttl` varchar(30) NOT NULL,
  `alamat` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_anggota`
--

INSERT INTO `data_anggota` VALUES (1,'1989876','Fuji','L','Peserta Diklat PIM Tk. III','2015','113-Asrama 3','018191801234'),(2,'207','Aries','L','Peserta Diklat PIM Tk. III','2 APBN 2015','213-Asrama 1','081123454321'),(3,'202','heri','P','Lainnya','2008','-','08154321111222'),(4,'206','Ujang Teknisi','L','Peserta Diklat Teknis Fungsional','2 PNBP 2015','214-Asrama2','081251502753'),(5,'2147483647','Maman','P','Peserta Diklat PIM Tk. IV','2 PNBP 2015','202- Asrama 2','08211234325'),(6,'2147483647','dadang','L','Peserta Diklat PIM Tk. III','1 APBN 2015','201-Asrama 2','0812253375'),(7,'198012122010011001','Ayu Andini Agrealian,ST. MMSC','P','Peserta Diklat PIM Tk. III','2 APBN 2015','201-Asrama 2','081123454321'),(8,'198010072008011001','Puput','P','Peserta Diklat Teknis Fungsional','2008','-','081765432111'),(10,'198110122009011001','Pupung Nenden Nia','L','Peserta Diklat PIM Tk. III','2 APBN 2015','201 Asrama 2','081123454321'),(11,'2147483647','Ayu Marcela Panjaitan','P','PNS Pusdiklat RB','2009','-','081542316'),(12,'2147483647','Sity Badrasyah,ST','P','PNS Pusdiklat RB','1999','-','0819275645343'),(13,'2147483647','Agung Arief Rachman','L','Peserta Diklat PIM Tk. III','2 PNBP 2015','204-Asrama 2','08134526543'),(14,'2147483647','Deny','L','PNS Pusdiklat RB','2008','-','081917035124'),(15,'2147483647','komarudin','L','Peserta Diklat PIM Tk. III','1 APBN 2015','134-Asrama 2','081234565432'),(16,'1933','gower','L','Peserta Diklat PIM Tk. IV','208','34','34566'),(17,'2147483647','frrr','P','Peserta Diklat PIM Tk. III','dgdg','dgdg','dgg'),(18,'2147483647','fsf','L','Peserta Diklat Teknis Fungsional','dfsf','fsfs','fsF'),(19,'2147483647','jghk','P','Peserta Diklat Teknis Fungsional','bb','nb,bl','jjk'),(20,'2147483647','vdfdf','P','Peserta Diklat PIM Tk. III','43','vbdsb','sdsdb'),(21,'197310072008011001','kskfj','L','Peserta Diklat PIM Tk. IV','kkadjad',',md.am','mndman'),(22,'00001','AYU ANDINI','P','Peserta Diklat PIM Tk. III','2008','216-2','089123456'),(23,'hgyk','Dederosadi','L','Peserta Diklat PIM Tk. III','hh','mnm',' nn'),(24,'197310072008011001','kjgk','L','Peserta Diklat PIM Tk. III','rge','grg','rgr'),(25,'197310072008011001','somas','L','Peserta Diklat PIM Tk. IV','mlg','mkmfkg','nkgkf'),(26,'3984','bambang','L','Peserta Diklat PIM Tk. III','2098','jksd','dfdf'),(27,'1989876','vdfdf','L','Peserta Diklat PIM Tk. III','dsvsdvv','vsdvd','dvdsvs'),(28,'1989876','grtg','L','Peserta Diklat PIM Tk. III','nhmjm','k,k.l','nhgn'),(29,'9824940','dwd','L','Peserta Diklat PIM Tk. III','dwq','dwdw','dwqdwd');

--
-- Table structure for table `data_buku`
--

CREATE TABLE `data_buku` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `judul` varchar(250) NOT NULL,
  `pengarang` varchar(250) NOT NULL,
  `th_terbit` varchar(4) NOT NULL,
  `penerbit` varchar(250) NOT NULL,
  `isbn` varchar(25) NOT NULL,
  `kategori` varchar(50) NOT NULL,
  `kode_klas` varchar(20) NOT NULL,
  `jumlah_buku` int(2) NOT NULL,
  `lokasi` varchar(50) NOT NULL,
  `asal` varchar(50) NOT NULL,
  `jum_temp` int(4) NOT NULL,
  `tgl_input` varchar(75) NOT NULL,
  `image` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data_buku`
--

INSERT INTO `data_buku` VALUES (3,'SAIN','Yogianto','2010','Ganesha','2012','Komputer','',3,'Rak 3','Beli',0,'2015-11-07 20:47:35','sain.jpg'),(4,'Managemen Database','Bambang Prayogi','2007','Gunung Kelud','2022','Komputer','',4,'Rak 2','Beli',2,'2015-11-07 20:51:12','book.jpg'),(5,'Algoritma','Yogianto','2011','Ganesha','250','Matematika','',3,'Rak 3','Beli',0,'2015-11-07 20:52:51','dinamika.jpg'),(23,'Buku Cerita','ngarang','2013','bulan sabit','2013','buku bacaan','',2,'Rak 4','Beli',2,'2015-11-08 13:58:50','softkil.jpg'),(24,'MATA HATI','Ngorong','2006','swasta','2011','Hitung','',2,'Rak 3','Beli',1,'2015-11-08 14:23:49','nabihistry.jpg'),(25,'Belajar Membaca','Baban','2011','Gunung Kelud','2011','HUKUM','',20,'RAK 1','Beli',19,'2015-11-08 14:59:51','sifat.jpg'),(26,'Pernikahan Dini','Ramphujabhi','2002','Gunung Kelud','2011','Cerita','',3,'Rak 2','Beli',2,'2015-11-08 15:35:11','nikah.jpg'),(27,'Buku Untuk Karyawan','Karyawati','2020','Esahilang','2003','Pengetahuan','',2,'Rak 3','Hibah',2,'2015-11-08 15:36:48','bukar.jpg'),(28,'Alquran','Alloh SWT','2013','Nabi','200098','Agama','',2,'Rak 7','Pembelian',1,'2015-11-08 19:58:19','alquran.jpg'),(29,'MATA HATI','sdfsd','fsdf','fsdfsd','fsdfds','dfgfd','',0,'dfsd','Pembelian',0,'2015-11-12 00:08:00','bukar.jpg'),(30,'hjhjhsd','www','wqe','rerr','rrtt','ewrt','',0,'wrer','Pembelian',0,'2015-11-12 10:08:39','alquran.jpg'),(31,'MATA HATI','dsfsdf','vdsv','sfew','vb','ddwq','',0,'fwfewfw','Hadiah',0,'2015-11-12 10:09:23','bukar.jpg'),(32,'jhjajdas','mdnamnd,a',',md,','ndanmsda','fgfdg','gdg','',0,'dsds','Pembelian',0,'2015-11-12 10:32:38','buktri.jpg'),(33,'jhjajdas','njcs','ajdk','lklkdsa',',kdlasda','jkdasjkd','',0,'kasjdkaj','Pembelian',0,'2015-11-12 10:33:41','bukar.jpg'),(34,'MATA HATI','dsfsdf','sfsf','asfasf','asfasf','dasfas','',0,'saasfas','Pembelian',0,'2015-11-12 10:47:42','bukar.jpg'),(35,'MATA HATI','kfjfue','ndhg','bgshn','juytgdh','ndhd','',3,'Rak 2','Hadiah',3,'2015-11-12 10:49:41','bukar.jpg'),(36,'MATA HATI','sdsad','dasd','sadasd','dsasd','dasd','',4,'dwedw','Pembelian',3,'2015-11-12 11:43:41','esq.jpg'),(37,'MATA HATI','Munir, SH','jkjf','fsfsd','sd','gsdgs','',0,'gdsgds','Hadiah',0,'2015-11-12 12:41:15','forex.jpg');

--
-- Table structure for table `pengunjung`
--

CREATE TABLE `pengunjung` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) NOT NULL,
  `jk` varchar(2) NOT NULL,
  `kelas` varchar(50) NOT NULL,
  `perlu1` varchar(15) NOT NULL,
  `perlu2` varchar(15) NOT NULL,
  `perlu3` varchar(15) NOT NULL,
  `perlu4` varchar(15) NOT NULL,
  `cari` varchar(255) NOT NULL,
  `saran` varchar(255) NOT NULL,
  `tgl_kunjung` date NOT NULL,
  `jam_kunjung` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pengunjung`
--

INSERT INTO `pengunjung` VALUES (42,'Ujang Teknisi','L','Peserta Diklat PIM Tk. III','','Baca Buku','','','Buku yang tahu tentang Mekanikal','Baik-baik sajahhh','2015-10-23','06:15:18'),(43,'Haris','L','Peserta Diklat PIM Tk. IV','Pinjam Buku','','','','Cara belajar raraban','ya gtt dech...','2015-10-23','06:16:16'),(44,'Fuji','L','Lainnya','Pinjam Buku','','','','Cari Buku','','2015-10-29','06:35:55'),(45,'ABCD','P','Peserta Diklat PIM Tk. III','Pinjam Buku','','','','blabla','','2015-10-30','07:40:02'),(46,'Deny','L','Peserta Diklat PIM Tk. III','Pinjam Buku','','','','cari buku','hghgska','2015-11-03','04:14:58'),(47,'Aries','L','Peserta Diklat PIM Tk. IV','','Baca Buku','','','pinjam buku','hghgs','2015-11-03','04:15:29');

--
-- Table structure for table `trans_pinjam`
--

CREATE TABLE `trans_pinjam` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `judul_buku` varchar(250) NOT NULL,
  `id_peminjam` int(4) NOT NULL,
  `nama_peminjam` varchar(100) NOT NULL,
  `tgl_pinjam` varchar(15) NOT NULL,
  `tgl_kembali` varchar(15) NOT NULL,
  `status` varchar(10) NOT NULL,
  `ket` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `trans_pinjam`
--

INSERT INTO `trans_pinjam` VALUES (1,'1 Milyar Trick PHP Cewek',4,'AGUNG SETYABUDI','11-10-2015','18-10-2015','kembali',''),(2,'Belajar Membaca',16,'Ayu','11-10-2015','18-10-2015','kembali',''),(3,'MATA HATI',12,'Ayu','11-10-2015','18-10-2015','kembali',''),(4,'MATA HATI',12,'AHMAD BUDIAWAN','11-10-2015','18-10-2015','kembali',''),(5,'MATA HATI',12,'ANDRI SURAHMAN','11-10-2015','18-10-2015','kembali',''),(6,'MATA HATI',12,'ANI SARIYATI','11-10-2015','18-10-2015','kembali',''),(7,'KIMIAWI',19,'AGUNG SETYABUDI','11-10-2015','18-10-2015','kembali',''),(8,'Slank',21,'AGUNG SETYABUDI','11-10-2015','18-10-2015','kembali',''),(9,'Slank',21,'Ayu','11-10-2015','18-10-2015','kembali',''),(10,'Krakatau',24,'Ayu','11-10-2015','18-10-2015','kembali',''),(11,'Krakatau',24,'Papah rock n roll','11-10-2015','18-10-2015','kembali',''),(12,'Gren Core',22,'AGUNG SETYABUDI','11-10-2015','18-10-2015','kembali','hgh'),(13,'Belajar Membaca',16,'AGUNG SETYABUDI','12-10-2015','19-10-2015','kembali','102'),(14,'KIMIAWI',19,'DENY','12-10-2015','19-10-2015','kembali','132'),(15,'Bob Marley',23,'DENY','12-10-2015','19-10-2015','kembali','203'),(16,'Bob Marley',23,'DENY','23-10-2015','30-10-2015','kembali','203'),(17,'Implentasi Database',1,'Fuji','29-10-2015','05-11-2015','kembali','101'),(18,'Implentasi Database',1,'Aries','29-10-2015','12-11-2015','kembali','202'),(19,'Implentasi Database',1,'heri','29-10-2015','05-11-2015','kembali','202'),(20,'Algoritma',2,'Aries','03-11-2015','10-11-2015','kembali','206'),(21,'Managemen Database',1,'Ujang Teknisi','07-11-2015','21-11-2015','kembali','208'),(22,'Managemen Database',1,'Aries','07-11-2015','14-11-2015','kembali','567'),(23,'MATA HATI',2,'Aries','07-11-2015','14-11-2015','kembali','212'),(24,'Pernikahan Dini',26,'Maman','08-11-2015','15-11-2015','pinjam','201'),(25,'SAIN',3,'Fuji','09-11-2015','16-11-2015','pinjam','31'),(26,'SAIN',3,'kskfj','10-11-2015','17-11-2015','pinjam','23'),(27,'SAIN',3,'Pupung Nenden Nia','10-11-2015','17-11-2015','pinjam','203'),(28,'Algoritma',5,'kskfj','10-11-2015','17-11-2015','pinjam','203'),(29,'Managemen Database',4,'Aries','10-11-2015','17-11-2015','pinjam','203'),(30,'Belajar Membaca',25,'Pupung Nenden Nia','10-11-2015','17-11-2015','pinjam','234'),(32,'MATA HATI',24,'Ayu Andini Agrealian,ST. MMSC','12-11-2015','19-11-2015','pinjam','67'),(33,'MATA HATI',36,'Ayu Andini Agrealian,ST. MMSC','12-11-2015','19-11-2015','pinjam','67'),(34,'Algoritma',5,'Ayu Andini Agrealian,ST. MMSC','12-11-2015','19-11-2015','pinjam','5'),(35,'Algoritma',5,'Ayu Andini Agrealian,ST. MMSC','12-11-2015','19-11-2015','pinjam','54'),(36,'Alquran',28,'AYU ANDINI','12-11-2015','19-11-2015','pinjam','4');


