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

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

INSERT INTO `data_anggota` VALUES (1,1989876,'Fuji','L','Lainnya','2015','Bandung, 1992','Jalan jalan'),(2,207,'Aries','L','Lainnya','2','Bandung, 12 sep 1993','Jaln'),(3,202,'heri','L','Peserta Diklat PIM Tk. III','8','Bandung, 1992','jkjdhd'),(4,206,'Ujang Teknisi','L','Peserta Diklat PIM Tk. III','3','Bandung, 1992','jlank'),(5,2147483647,'Maman','L','Peserta Diklat PIM Tk. III','3','Brebes','Jl');

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

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

INSERT INTO `data_buku` VALUES (1,'Implentasi Database','gianto','2011','Ganesha','203','Komputer','Komputer',3,'Rak 2','Jakarta',0,'2015-10-29 12:38:57'),(2,'Algoritma','bambang','2013','ganesha','2022','Logika','',2,'Rak 7','Jakarta',2,'2015-10-29 12:48:29'),(3,'Managemen Database','Tohir','1995','Komindo','203','Komputer','',2,'Rak 3','Jakarta',2,'2015-10-30 13:43:04'),(4,'Pengenalan PHP','Yogianto','2013','Komindo','203','Komputer','AA-Penunjang',2,'Rak 4','Bandung',2,'2015-10-30 13:52:20'),(5,'Panuntun Basa','nklf','kjk','nklnflks','kklsnkl','knlkcnsl','Peternakan',2,'Rak 7','lmclsl;',2,'2015-10-30 13:59:26');

--
-- 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=21 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','pinjam','101'),(18,'Implentasi Database',1,'Aries','29-10-2015','05-11-2015','pinjam','202'),(19,'Implentasi Database',1,'heri','29-10-2015','05-11-2015','pinjam','202'),(20,'Algoritma',2,'Aries','03-11-2015','10-11-2015','kembali','206');


