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


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

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

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

INSERT INTO `data_anggota` VALUES (15,1577,'BABAn','P','Peserta Diklat PIM Tk. IV','Ke-3','Bandung, 12 sep 1993','Jl.Sukasuka'),(16,2147483647,'DENY','L','Peserta Diklat PIM Tk. III','Ke-3','Bandung, 1992','Jl. Sukajadi'),(17,50948,'somad','P','Peserta Diklat PIM Tk. III','2008','Bandung, 1992','jl.jalan'),(18,0,'','','','','',''),(19,20394,'babeh','P','Peserta Diklat PIM Tk. III','2009','Bandung, 1992','cibar');

--
-- 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

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

INSERT INTO `data_buku` VALUES (16,'Belajar Membaca','Ayu Andini Agrealian','2011','Deny Grafitara','13245','BOBOY','BIO-Pegangan Guru',4,'Rak 4','Gramedia',3,'2015-10-11 22:49:29'),(19,'KIMIAWI','Ngorong','1959','Erlangga','elemen','kimia','BIO-Pegangan Guru',12,'Rak 4','Jakarta',11,'2015-10-11 23:54:08'),(21,'Slank','Bimbim','1996','Pulau Biru','243','Musik','BIO-Pegangan Guru',2,'Rak 8','Gramedia',0,'2015-10-12 00:11:07'),(22,'Gren Core','Ranggaek','1995','Erlangga','231','','BIO-Teks Siswa',2,'Rak 9','Gramedia',1,'2015-10-12 00:45:15'),(23,'Bob Marley','The Wailers','1976','Log Slebor','250','musik','BIO-Teks Siswa',10,'Rak 7','Gramedia',9,'2015-10-12 01:02:29'),(24,'Krakataw','Alloh SWT','1888','Gunung Kelud','900','alam','BIO-Pegangan Guru',8,'Rak 7','Alami',8,'2015-10-12 01:31:55');

--
-- 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=36 DEFAULT CHARSET=latin1;

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

INSERT INTO `pengunjung` VALUES (1,'Ayu','P','VII a','Pinjam Buku','','','','a','a','2015-10-09','04:48:17'),(2,'bambang','L','VII b','Pinjam Buku','','','','wsdw','wdw','2015-10-09','05:08:27'),(3,'Deny','L','IX a','','Baca Buku','','','Cari Buku','Bagus lah','2015-10-12','05:49:18'),(4,'AYU ANDINI','L','Peserta Diklat PI','','Baca Buku','','','Cari Ilmu','Good','2015-10-12','06:08:19'),(5,'WAWAN','L','PNS Pusdiklat RB','','','Baca Koran','','Inf','Good','2015-10-12','06:11:11'),(6,'GUGUN','L','Peserta Diklat Teknis Fungsional','','','Baca Koran','','eferwe','etw','2015-10-12','06:11:30'),(7,'GANDI','P','Peserta Diklat PIM Tk.III','Pinjam Buku','','','','dsada','ds','2015-10-12','06:14:00'),(8,'BUDI','P','Peserta Diklat PIM Tk.IV','','','Baca Koran','','sgrge','htrhrt','2015-10-12','06:14:18'),(9,'YUYU','P','Pramu Bakti','','','Baca Koran','','wdewfe','fefef','2015-10-12','06:14:43'),(10,'BABAH','P','Lainnya','','Baca Buku','','','sfef','fefe','2015-10-12','06:14:59'),(11,'ADE','P','Peserta Diklat PIM Tk.III','Pinjam Buku','','','','dsf','frfr','2015-10-12','06:18:29'),(12,'ABI','L','Peserta Diklat PIM Tk.IV','','Baca Buku','','','dsdf','defe','2015-10-12','06:18:44'),(13,'ABU','P','Peserta Diklat Teknis Fungsional','','Baca Buku','','','fregrtg','grerger','2015-10-12','06:18:59'),(14,'AWEE','P','Peserta Diklat Prajabatan','','Baca Buku','','','fdgt','gtgtr','2015-10-12','06:19:38'),(15,'jjjyujy','L','Peserta Diklat PIM Tk.III','','Baca Buku','','','jyjy','yuytu','2015-10-12','06:26:28'),(16,'uyutts','L','Peserta Diklat PIM Tk.IV','Pinjam Buku','','','','tutut','utsru','2015-10-12','06:26:43'),(17,'etetw','L','Peserta Diklat PIM Tk.III','','Baca Buku','','','etwetw','tet','2015-10-12','06:30:48'),(18,'tyrty','P','Peserta Diklat PIM Tk.III','Pinjam Buku','','','','ryry','yr','2015-10-12','06:38:24'),(19,'ktyktk','P','Peserta Diklat PIM Tk.IV','Pinjam Buku','','','','tykdy','dyj','2015-10-12','06:38:36'),(20,'rgretger','L','Peserta Diklat PIM Tk. III','','','Baca Koran','','fsfs','ffwfW','2015-10-12','06:42:10'),(21,'KKYU','P','Peserta Diklat PIM Tk. IV','Pinjam Buku','','','','UYKYFU','JYTJTD','2015-10-12','06:42:25'),(22,'bebek','P','Peserta Diklat PIM Tk. III','','Baca Buku','','','hhudw','ndjwjdwe','2015-10-16','02:03:38'),(23,'Bako','P','Peserta Diklat PIM Tk. IV','Pinjam Buku','','','','kjjdked','kdkd','2015-10-16','02:05:41'),(24,'Ayu','P','Peserta Diklat PIM Tk. III','','Baca Buku','','','retak','jungjung','2015-10-16','02:11:48'),(25,'Teteh','L','Peserta Diklat PIM Tk. III','','','','Lainnya','tepararuguh','hujan','2015-10-16','02:13:38'),(26,'Dederosadi','P','Peserta Diklat PIM Tk. III','','','Baca Koran','','fewtt','ryruti','2015-10-16','02:22:48'),(27,'Dederosadi','P','Peserta Diklat PIM Tk. III','','','Baca Koran','','fewfge','efeewg','2015-10-16','02:23:28'),(28,'Dederosadi','P','Peserta Diklat PIM Tk. III','','','Baca Koran','','ccdcd','cdcsc','2015-10-16','02:24:53'),(29,'bubun','L','Peserta Diklat PIM Tk. III','','Baca Buku','','','cscdc','cdcdvds','2015-10-16','02:26:43'),(30,'Dederosadi','L','Peserta Diklat PIM Tk. III','','Baca Buku','','','dcde','thytht','2015-10-16','02:35:20'),(31,'Dederosadi','P','Peserta Diklat PIM Tk. III','Pinjam Buku','','','','cdfed','dfefew','2015-10-16','02:36:26'),(32,'bekok','P','Peserta Diklat PIM Tk. III','Pinjam Buku','','','','ccdcdsc','cdcsdds','2015-10-16','02:37:11'),(33,'mamah','P','Peserta Diklat PIM Tk. III','Pinjam Buku','','','','bksks','mmfjf','2015-10-16','02:46:52'),(34,'dadang','L','Peserta Diklat PIM Tk. III','','','Baca Koran','','dsadasd','fefewfew','2015-10-16','03:11:37'),(35,'gower','L','Peserta Diklat PIM Tk. III','','Baca Buku','','','hcjhfew','njhfwehf','2015-10-16','03:12:53');

--
-- 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=16 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','pinjam',''),(2,'Belajar Membaca',16,'Ayu','11-10-2015','18-10-2015','pinjam',''),(3,'MATA HATI',12,'Ayu','11-10-2015','18-10-2015','kembali',''),(4,'MATA HATI',12,'AHMAD BUDIAWAN','11-10-2015','18-10-2015','pinjam',''),(5,'MATA HATI',12,'ANDRI SURAHMAN','11-10-2015','18-10-2015','pinjam',''),(6,'MATA HATI',12,'ANI SARIYATI','11-10-2015','18-10-2015','kembali',''),(7,'KIMIAWI',19,'AGUNG SETYABUDI','11-10-2015','18-10-2015','pinjam',''),(8,'Slank',21,'AGUNG SETYABUDI','11-10-2015','18-10-2015','pinjam',''),(9,'Slank',21,'Ayu','11-10-2015','18-10-2015','pinjam',''),(10,'Krakatau',24,'Ayu','11-10-2015','18-10-2015','pinjam',''),(11,'Krakatau',24,'Papah rock n roll','11-10-2015','18-10-2015','pinjam',''),(12,'Gren Core',22,'AGUNG SETYABUDI','11-10-2015','18-10-2015','pinjam','hgh'),(13,'Belajar Membaca',16,'AGUNG SETYABUDI','12-10-2015','19-10-2015','pinjam','102'),(14,'KIMIAWI',19,'DENY','12-10-2015','19-10-2015','pinjam','132'),(15,'Bob Marley',23,'DENY','12-10-2015','19-10-2015','pinjam','203');


