/*
SQLyog Professional v12.5.1 (64 bit)
MySQL - 10.6.11-MariaDB-log : Database - rental_mobil
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_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 `booking` */

DROP TABLE IF EXISTS `booking`;

CREATE TABLE `booking` (
  `id_booking` int(11) NOT NULL AUTO_INCREMENT,
  `kode_booking` varchar(255) NOT NULL,
  `id_login` int(11) NOT NULL,
  `id_mobil` int(11) NOT NULL,
  `ktp` varchar(255) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `alamat` varchar(255) NOT NULL,
  `no_tlp` varchar(15) NOT NULL,
  `tanggal` varchar(255) NOT NULL,
  `lama_sewa` int(11) NOT NULL,
  `total_harga` int(11) NOT NULL,
  `konfirmasi_pembayaran` varchar(255) NOT NULL,
  `tgl_input` varchar(255) NOT NULL,
  PRIMARY KEY (`id_booking`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

/*Data for the table `booking` */

insert  into `booking`(`id_booking`,`kode_booking`,`id_login`,`id_mobil`,`ktp`,`nama`,`alamat`,`no_tlp`,`tanggal`,`lama_sewa`,`total_harga`,`konfirmasi_pembayaran`,`tgl_input`) values 
(1,'1576329294',3,5,'231423123','Krisna','Bekasi','08132312321','2019-12-28',2,400000,'Pembayaran di terima','2019-12-14'),
(2,'1576671989',3,5,'231423','Krisna Waskita','Bekasi Ujung Harapan','082391273127','2019-12-20',2,400525,'Pembayaran di terima','2019-12-18'),
(3,'1642998828',3,5,'1283821832813','Krisna','Bekasi','089618173609','2022-01-26',4,800743,'Pembayaran di terima','2022-01-24');

/*Table structure for table `infoweb` */

DROP TABLE IF EXISTS `infoweb`;

CREATE TABLE `infoweb` (
  `id` int(11) NOT NULL,
  `nama_rental` varchar(255) DEFAULT NULL,
  `telp` varchar(15) DEFAULT NULL,
  `alamat` text DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `no_rek` text DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

/*Data for the table `infoweb` */

insert  into `infoweb`(`id`,`nama_rental`,`telp`,`alamat`,`email`,`no_rek`,`logo`,`updated_at`) values 
(1,'Rental Anang','081298669897','Ujung Harapan Kab. Bekasi','fauzancodekop@gmail.com','BRI A/N Fauzan Falah 123123213123','logo_1773191253.jpg','2022-01-24 11:57:29');

/*Table structure for table `login` */

DROP TABLE IF EXISTS `login`;

CREATE TABLE `login` (
  `id_login` int(11) NOT NULL AUTO_INCREMENT,
  `nama_pengguna` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `level` varchar(255) NOT NULL,
  PRIMARY KEY (`id_login`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

/*Data for the table `login` */

insert  into `login`(`id_login`,`nama_pengguna`,`username`,`password`,`level`) values 
(1,'Anang','admin','202cb962ac59075b964b07152d234b70','admin'),
(3,'Krisna Waskita','demo','fe01ce2a7fbac8fafaed7c982a04e229','pengguna');

/*Table structure for table `mobil` */

DROP TABLE IF EXISTS `mobil`;

CREATE TABLE `mobil` (
  `id_mobil` int(11) NOT NULL AUTO_INCREMENT,
  `no_plat` varchar(255) NOT NULL,
  `merk` varchar(255) NOT NULL,
  `harga` int(255) NOT NULL,
  `deskripsi` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `gambar` text NOT NULL,
  PRIMARY KEY (`id_mobil`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

/*Data for the table `mobil` */

insert  into `mobil`(`id_mobil`,`no_plat`,`merk`,`harga`,`deskripsi`,`status`,`gambar`) values 
(5,'N34234','Avanza',200000,'Apa aja','Tersedia','1673593078toyota-all-new-avanza-2015-tangkapan-layar_169.jpeg'),
(6,'N 1232 BKT','New Xenia',500000,'Baru','Tersedia','all-new-xenia-exterior-tampak-perspektif-depan---varian-1.5r-ads.jpg');

/*Table structure for table `pembayaran` */

DROP TABLE IF EXISTS `pembayaran`;

CREATE TABLE `pembayaran` (
  `id_pembayaran` int(11) NOT NULL AUTO_INCREMENT,
  `id_booking` int(255) NOT NULL,
  `no_rekening` int(255) NOT NULL,
  `nama_rekening` varchar(255) NOT NULL,
  `nominal` int(255) NOT NULL,
  `tanggal` varchar(255) NOT NULL,
  PRIMARY KEY (`id_pembayaran`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

/*Data for the table `pembayaran` */

insert  into `pembayaran`(`id_pembayaran`,`id_booking`,`no_rekening`,`nama_rekening`,`nominal`,`tanggal`) values 
(3,1,2131241,'Krisna Aldi Waskito',400000,'2019-12-14'),
(4,2,2131241,'Krisna Aldi Waskito',400525,'2019-12-18'),
(5,3,13213,'Fauzan Falah',800743,'2022-01-24');

/*Table structure for table `pengembalian` */

DROP TABLE IF EXISTS `pengembalian`;

CREATE TABLE `pengembalian` (
  `id_pengembalian` int(11) NOT NULL AUTO_INCREMENT,
  `kode_booking` varchar(255) NOT NULL,
  `tanggal` varchar(255) NOT NULL,
  `denda` int(255) NOT NULL,
  PRIMARY KEY (`id_pengembalian`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

/*Data for the table `pengembalian` */

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
