--
-- 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(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=14 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,2147483647,'Ayu Andini Agrealian,ST. MMSC','P','Peserta Diklat PIM Tk. III','2 APBN 2015','201-Asrama 2','081123454321'),(8,2147483647,'Puput','P','PNS Pusdiklat RB','2008','-','081765432111'),(10,2147483647,'Pupung Nenden Nia','P','Peserta Diklat PIM Tk. IV','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');

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

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


--
-- 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=24 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');


